d o t logoUnited States Department of Transportation

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

PART 241 T100 U.S. Air Carrier Monthly Market Report

PDF

OMB No: 2138-0040

EXPIRATION DATE: 10/31/2020

REQUIREMENTS

RECORD DESCRIPTION: T100 – Traffic and Capacity Statistics for On-Flight Market Data Report

Field Description Data Type Length Comments Sample Data
Data Type Character 1 One letter data type (M) M
Entity Code Character 5 Five character code assigned by DOT 0A050
Year of Data Numeric 4 Year (CCYY) 2010
Month of Data Numeric 2 Month (MM) 03
Origin Airport Character 3 Three letter OAG airport code BWI
Destination Airport Character 3 Three Letter OAG airport code LAS
Service Class Character 1 One letter service class code: F, G, L, N, P, R F
Market Passengers Numeric 7 Up to seven numbers Enplaned passengers 328 passengers
Market Freight Numeric 10 Up to ten numbers, reported in pounds 104528 lbs. of freight
Market Mail Numeric 10 Up to ten numbers, reported in pounds 5428 lbs. of mail

RECORD FORMAT:

The T100 – Market Report 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: XX201003-T100MKT.csv

Sample Record Format:

M,0A050,2010,03,BWI,LAS,F,328,104528,5428