Field Name Description Support Table
Year Year
Quarter Quarter (1-4) Get Lookup Table
Month Month of Year Get Lookup Table
AirlineID An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation. Get Lookup Table
UniqueCarrier Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years. Get Lookup Table
UniqueCarrierName Unique Carrier Name. When the same name has been used by multiple carriers, a numeric suffix is used for earlier users, for example, Air Caribbean, Air Caribbean (1).
UniqCarrierEntity Unique Entity for a Carrier's Operation Region. Get Lookup Table
CarrierRegion Carrier's Operation Region. Carriers Report Data by Operation Region Get Lookup Table
Carrier Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code. Get Lookup Table
CarrierName Reporting Carrier Name
CarrierGroup Carrier Group Code. Used in Legacy Analysis Get Lookup Table
CarrierGroupNew Carrier Group New Get Lookup Table
ServiceClass Type of service provided (Scheduled, Non-Scheduled, etc.). Note that some service classes are sums of other detailed classes, for example, K (F+G), V (L+N+P+R), and Z (K+V). Get Lookup Table
RevPaxEnplaned Revenue Passengers Enplaned
RevPaxMiles Revenue Passenger Miles
RPMCoach Revenue Passenger Miles, Coach
RPMFirstClass Revenue Passenger Miles, First Class
NonRevPaxMiles Non-Revenue Passenger Miles
RevTonMiles Revenue Ton Miles
RTMFreight Revenue Ton Miles, Freight
RevPaxTonMiles Revenue Passenger Ton Miles
RTMUSPrMail Revenue Ton Miles, U.S. Priority Mail
RTMUSNonPrMail Revenue Ton Miles, U.S. Non-Priority Mail
RTMMail Revenue Ton Miles, Mail
RTMForeignMail Revenue Ton Miles, Foreign Mail
RTMExpress Revenue Ton Miles, Express Mail
NonRevTonMiles Non-Revenue Ton Miles
AvailTonMiles Available Ton Miles
AvailSeatMiles Available Seat Miles
ASMFirstClass Available Seat Miles (First Class)
ASMCoach Available Seat Miles (Coach)
RevMilesFlown Revenue Aircraft Miles Flown
RevMilesSched Revenue Aircraft Miles Scheduled
SchRAMComp Scheduled Revenue Aircraft Miles Completed
RADPerformed Revenue Aircraft Departures Performed
RevAirHours Revenue Aircraft Hours (Airborne)
AirHoursRampToRamp Aircraft Hours (Ramp to Ramp)
