d o t logoUnited States Department of Transportation

  OST-R > BTS
ESubmit User Guide Report Formats Manage Profile Contact OAI FAQ Log Out

PART 217 T100 (f) Foreign Air Carrier Traffic Data

PDF

OMB NO: 2138-0040

EXPIRATION DATE: 10/31/2020

Paperwork Reduction Act Burden Statement

A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0040. Public reporting for Schedule T-100(f) Report of Traffic and Capacity, is estimated to be approximately 2 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 217. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jennifer Rodes, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jennifer.rodes@dot.gov.

REQUIREMENTS

RECORD DESCRIPTION: T100 (f) Foreign Air Carrier Traffic Data

Field Description Data Type Length Comments Sample Data
Carrier Code Character 3 2 or 3 digit Carrier Code BA
Year and Month of Data Numeric 6 Format: YYYYMM
YYYY = century and year; Format:
MM: 01 = January …
        12 = December
200612
Origin Airport Character 3 The three letter OAG code identifying the airport. IAH
Destination Airport Character 3 The three letter OAG code identifying the airport. LGW
Service Class Character 1 One letter service class code:
F, G, L, N, P, R, H
F
Segment Aircraft Type
and Cabin Configuration
Number 4 The 1st 3 characters identify the type of aircraft used on the non-stop segment.
The 4th character is used to identify the type of cabin configuration:
1 - Passenger
2 - Cargo
3 - Passenger/Cargo
6271
Segment Departures Performed Number Up to 5 Up to five numeric Revenue departures performed 49
Segment Passengers Number Up to 10 Up to seven numeric, reported transported passengers 6707
Segment Freight Number Up to 10 Up to ten numeric, freight reported in kilos 521842
Segment Available Seats Number Up to 7 Up to seven numeric, aircraft seating capacity 10976
Segment Available Capacity Number Up to 10 Up to ten numeric, reported in kilos 1903195
Market Passengers Number Up to 10 Up to seven numbers Enplaned passengers 6707
Market Freight Number Up to 10 Up to ten numbers, reported in kilos 521842


RECORD FORMAT:

The T100(f) Foreign Air Carrier Traffic Data reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.

The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.

The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.

The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.

Suggested file name: XXX201003-T100F.csv

Sample Record Format:

BA,200612,IAH,DTW,F,6261,30,1647,17137,5670,772500,0,0
BA,200612,IAH,LGW,F,6271,49,6707,521842,10976,1903195,6707,521842
BA,200612,IAH,LHR,F,0,0,0,0,0,0,1643,12935