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 Alaskan Air Carrier Weekly Traffic and Capacity Data Report

PDF

REQUIREMENTS

RECORD DESCRIPTION: T100 Alaskan Air Carrier Weekly Segment and Market Report

Field Description Data Type Length Comments Sample Data
Data Type Character 1 One letter code (S) S
Entity code Character 5 Five character code assigned by DOT 06000
Year of Data Numeric 4 Year (CCYY) 2010
Month of Data Numeric 2 Month (MM) 05
Day of Service Numeric 2 Day of month the service was performed – for use by USPS Only 27
Origin Airport Character 3 Three letter OAG airport code FAI
Destination Airport Character 3 Three letter OAG airport code GAL
Service Class Character 1 One letter service class code: F, G, L, N, P, R F
Segment Aircraft Type Numeric 3 DOT assigned three numeric aircraft type code 405
Segment Cabin Configuration Numeric 1 One numeric aircraft cabin configuration code: 1,2,3,4 3
Segment Departures Performed Numeric 5 Up to five numeric departures performed 1
Segment Available Capacity Numeric 10 Up to ten numeric, reported in pounds 3793
Segment Available Seats Numeric 7 Up to seven numeric, aircraft seating capacity 16
Segment Passengers Transported Numeric 7 Up to seven numeric, reported transported passengers 3
Segment Freight Transported Numeric 10 Up to ten numeric, freight reported in pounds 239
Segment Mail Transported Numeric 10 Up to ten numeric, mail reported in pounds 1106
Segment Scheduled Departures Numeric 5 scheduled departures 1
Segment Ramp-to-Ramp time Numeric 10 Up to ten numeric, reported in minutes 72
Segment Airborne time in minutes Numeric 10 Up to ten numeric, reported in minutes 60
DOT Certification Numeric 3 Values are: 135, 121 for use by USPS Only 121

RECORD FORMAT:

The T100 – Alaskan Air Carrier Weekly Segment 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: XX20100528-T100AKSEG.csv

Sample Record Format:

S,06000,2010,05,27,FAI,GAL,F,405,3,1,3793,16,3,239,1106,1,72,60,121