SOW-10-Q-80011.doc

DTRT57-10-Q-80011

STATEMENT OF WORK

Background

As a part of its ongoing support for the Federal Aviation Administration’s (FAA’s) Office of Environment and Energy (AEE), the Volpe Center’s Acoustics and Air Quality facilities are undertaking a lead role in the continued development of the Aviation Environmental Design Tool (AEDT). For several years, the comprehensive body of airline schedule and fleet data required to sustain this effort has come from products purchased piecemeal on an annual basis by the Volpe Center from the Official Airline Guide (OAG) and BACK Aviation. As AEDT development intensifies and the project's data needs become more complex, a flexible, comprehensive data license will be required for the 2000 - 2014 data years of two databases the Volpe Center currently subscribes to each year: 1. the historical schedule and monthly Locations / Daylights Savings Time (DST) database subscription, and 2. the world fleet database subscription. Both databases will be utilized by the AEDT software to generate results for the 2000 - 2014 data years. At this time, the Volpe Center would like to procure a five-year license to the 2000-2014 data.

Objective

By purchasing a five-year license to the required historical schedule and fleet data, the Volpe Center will maintain fast, flexible, easy access to a comprehensive body of airline schedule and fleet data while avoiding the necessity to repeat the subscription process each year or with each data use.

Requirements The purchased database license must fulfill the Volpe Center's schedule and fleet database needs described in the "Description of License" section below for the existing data years 2000-2008 during the period of performance. Also within this period of performance, the Volpe Center will be given access to all 2009, 2010, 2011, 2012, 2013, and 2014 schedule and fleet data that becomes available through annual database updates. All data must be sourced and provided by the same vendor. All data must be compatible with pre-processing codes and internal algorithms that have already been developed for the AEDT.

Description of License The database license provided by the vendor will have a period of performance of five years from the date of purchase and will provide the following data:

Historical Schedule Data

The AEDT requires monthly worldwide historical airline schedule databases for the years 2000 - 2014. The data to be delivered must consist of all worldwide monthly historical airline schedules for January through December of each year from 2000 - 2014, including carrier detail. The 2000 - 2014 historical schedule databases consist of the following:

· The monthly historical databases for the years 2000 - 2014, consisting of the operating carrier data fields listed in Attachment A. All files need to be made available in CSV format.

· The 2000 - 2014 monthly Locations / DST files, consisting of the data fields listed in Attachment B. All files need to be made available in TXT format.

World Fleet Data

The AEDT requires the 2000 - 2014 world fleet databases. The data to be delivered must consist of all worldwide biannual airline fleet information for each year from 2000 - 2014, consisting of the data fields listed in Attachment C. The 2000 - 2014 world fleet databases will be made available in text definition file format (TDF) for each year from 2000 - 2014.

All historical schedule data and world fleet data must be sourced and provided by the same vendor.

Deliverables

One five-year data license granting access to downloads of 2000 - 2014 historical schedule data and world fleet data, as described in the "Description of License" section above.

Period of Performance

The license provided will be active for five years from the date of award.

Attachment A. Historical Schedule Database Fields Carrier Code

Flight Number

Carrier 2

Flight Number 2

Departure Airport Code

Departure City Code

Departure Country Code

Arrival Airport Code

Arrival City Code

Arrival Country Code

Departure Time

Arrival Time

Arrival Day

Elapsed Journey Time

Days of Operation

Stops

Intermediate Airports

Aircraft Change

Government Approval

Comment 010/050

General Aircraft Type Code

Specific Aircraft Type Code

Service Type

Available Seats

Freight

Passenger Class 1

Passenger Class 2

Passenger Class 3

Passenger Class 4

Passenger Class 5

Passenger Class 6

Passenger Class 7

Passenger Class 8

Passenger Class 9

Passenger Class 10

Freight Classes

Restriction

Domestic/International Marker

Effective from date

Effective to date

Full Routing

Longest Sector

Distance

Shared Airline Designator

Multi Carrier Designator

Flight Duplication

Aircraft Owner

Operating/Non Operating MarkerCharacter

Ghost Flight

Duplicate

Duplicate Carrier 1

Duplicate Flight 1

Duplicate Carrier 2

Duplicate Flight 2

Duplicate Carrier 3

Duplicate Flight 3

Duplicate Carrier 4

Duplicate Flight 4

Duplicate Carrier 5

Duplicate Flight 5

Duplicate Carrier 6

Duplicate Flight 6

Duplicate Carrier 7

Duplicate Flight 7

Duplicate Carrier 8

Duplicate Flight 8

Duplicate Carrier 9

Duplicate Flight 9

Duplicate Carrier 10

Duplicate Flight 10

Duplicate Carrier 11

Duplicate Flight 11

Duplicate Carrier 12

Duplicate Flight 12

Duplicate Carrier 13

Duplicate Flight 13

Duplicate Carrier 14

Duplicate Flight 14

Duplicate Carrier 15

Duplicate Flight 15 Attachment B. Locations / Daylight Savings Time Database Fields Carrier1 Carrier1Name FlightNo1Carrier2 Carrier2Name FlightNo2 CarrDom1 CarrDom1Name CarrDom2 CarrDom2Name DepAirport DepAirportName DepTerminal DepCity DepCityName DepState DepStateName DepIATACtry DepIATACtryName DepDOTCtry DepDOTCtryName DepReg DepRegName ArrAirport ArrAirportName ArrTerminal ArrCity ArrCityName ArrState ArrStateName ArrIATACtry ArrIATACtryName ArrDOTCtry ArrDOTCtryName ArrReg ArrRegName LocalDepTime LocalArrTime LocalArrDay LocalDaysOfOp ArrDaysOfOp Service Seats FstSeats BusSeats EcoSeats EffFrom EffTo LocalDaysOfOp1 LocalDaysOfOp2 LocalDaysOfOp3 LocalDaysOfOp4 LocalDaysOfOp5 LocalDaysOfOp6 LocalDaysOfOp7 ElapsedTime FlyingTime GroundTime Stops IntAirports IntCities IntCountries AcftChange AcftChApt1 AcftChApt2 AcftChApt3 GeneralAcft GeneralAcftName SpecificAcft SpecificAcftName SecondAcft ThirdAcft FourthAcft Freightons PassClass FreightClass Routing StatMiles NautMiles Km DistStMiles DistNtMiles DistKM Restrictions ShAirlDes MultCDes DupMarker DupCar1 DupCar2 DupCar3 DupCar4 DupCar5 DupCar6 DupCar7 DupCar8 OpCar Comment AcftOwnerCode AcftOwnerCodeName CockpitCrewCode CockpitCrewCodeName CabinCrewCode CabinCrewCodeName LongLeg MaxTakeOffWeight HoldVolume RangeKm RangeStatMiles RangeNautMiles CruiseSpeed Category Manufacturer Ghost SubGovnApp FltDup Frequency ASMs ASKs TotalSeatCapacity TotalTonnage

Attachment C. Fleet Database File Database Fields

AIRCRAFT TYPE

AIRCRAFT STATUS CODE

AIRCRAFT SERIAL NUMBER

PRODUCTION LINE NUMBER

AIRCRAFT MANUFACTURER

MANUFACTURE DATE

DELIVERY DATE

REG./TAIL NO.

ENGINE MANUFACTURER

ENGINE MODEL

NUMBER OF ENGINES

AIRCRAFT NOISE CLASS (STAGE)

HOURS/CYCLES DATE

TOTAL HOURS

TOTAL CYCLES

EQUIPMENT CATEGORY

EQUIPMENT TYPE

AIRCRAFT EQUIPMENT MODEL

FIRST CLASS SEATS

BUS. CLASS SEATS

COACH SEATS

TOTAL SEATS

OPERATOR CATEGORY

OPERATOR NAME

OPERATOR IATA CODE

OPERATOR ICAO CODE

OPER. COUNTRY CODE

OPER. REGION CODE

ACTIVITY DATE

ACTIVITY

WING SPAN (M)

WING AREA (SQ.M)

OVERALL LENGTH (M)

OVERALL HEIGHT (M)

BELLY VOLUME (CU.M)

MAXIMUM SEATING

FUEL CAPACITY (L)

MAX. TAKEOFF WEIGHT (KG)

MAX. PAYLOAD (KG)

OPERATING EMPTY WEIGHT (KG)

MAX. LANDING WEIGHT (KG)

MAX. ZERO-FUEL WEIGHT (KG)

RANGE W/MAX. FUEL (KM)

RANGE W/MAX. PAYLOAD (KM)

AVERAGE AGE OF AIRCRAFT