Field Name Description Support Table
Year Year
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).
CarrierCode 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 Carrier Name
Entity Carrier's Operation Region. Carriers Report Data by Operation Region Get Lookup Table
GeneralManagers General Managers
PilotsCopilots Pilots and Copilots
OtherFlightPersonnel Other Flight Personnel
PaxGSA Passenger/General Services & Administration
Maintenance Maintenance Employees
AcftTrafficHandlingGrp1 Aircraft Traffic Handling Group1 Employees
GeneralAcftTrafficHandling General Aircraft Traffic Handling Employees
AircraftControl Aircraft Control Employees
PaxHandling Passenger Handling Employees
CargoHandling Cargo Handling Employees
TraineesInstructor Trainees and Instructor
Statistical Statistical Employees
TrafficSoliciters Traffic Soliciters
Other Other Employees
TransportRelated Transport Related Employees
Total Total Employees
