Field Name Description Support Table
Year Year
Month Month of Year Get Lookup Table
Quarter Quarter (1-4) 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
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
SchRevPaxEnplaned K110 - Scheduled Revenue Passenger Enplaned
NonSchRevPaxEnplaned V110 - Non Scheduled Revenue Passenger Enplaned
RevPaxMiles Z140 - Revenue Passenger Miles
AvailSeatMiles Z320 - Available Seat Miles
RADPerformed Z510 - Revenue Aircraft Departures Performed
RADScheduled Z520 - Revenue Aircraft Departures Scheduled
DataSource Source of Data (D=Domestic, I=International) Get Lookup Table
