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 |
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.