Technical_Requirement_Attachment_2_March_23.pdf

ATTACHMENT 2

HSTS02-15-Q-OIA095A

TECHNICAL DATA REQUIREMENTS:

1. Worldwide Scheduled Flights: Data file shall contain, at a minimum:

Carrier Code

Flight Number

Duplicate Carriers

Duplicate Flight Numbers

Departure Airport Code

Departure City Code

Departure Country Code (ISO-2 format)

Arrival Airport Code

Arrival City Code

Arrival Country Code (ISO-2 format)

Departure Time

Arrival Time

Arrival day

Days of Operation

Stops

Intermediate Airports

Aircraft Change

Aircraft Type

Aircraft Model

Service Type

Available Seats

Freight Class

Domestic / International

Schedule Start date

Schedule End date

Full Route (aggregation of IATA codes in sequence)

Shared Airline Designation

Multi Carrier Designation

Aircraft Owner

Operating / Non operation carrier identifier

Departure Terminal

Arrival Terminal

2. Aircraft data: Data file shall include, at a minimum:

Aircraft Name

Aircraft Type

Aircraft Body Type

Cargo Service Types

Max Speed

Max Range

Specific Aircraft Code

PAX Service Types

General Aircraft Code

3. (Stations, metropolitan areas, et al): Data file shall include, at a minimum:

Country (ISO-2)

Location Code

Location Type

GMT Offset

DST Start Date

DST End Date

Location Name

Location Coordinates (latitude/longitude)

4. Carrier data: Data file shall include, at a minimum:

Carrier Code

Carrier Name

Country (ISO-2)

State

5. The quoter must demonstrate the capability of providing TSA with access to all required data files on a Secure File Transfer Protocol (SFTP) site.

6. The quoter shall provide samples of the following data files in zipped, pipe-delimited text format via ftp download.

Worldwide flight data - All flight data for every scheduled flight (domestic and international, arrival and departure) from/to the country of United Arab Emirates between 0001 05 October 2014 and 2359 12 October 2014.

Aircraft Data - Aircraft data will provide full and complete details for all aircraft associated with data provided in Worldwide Flight Data sample.

Location Data - All locations worldwide.

Carrier Data - All carriers worldwide