Field Name Description Support Table
Year Year
Month Month 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).
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
FullTimeEmployees Monthly Number of Full-Time Employees (For Filter Statistics = 'Sum' for yearly data, the results are a Monthly Average)
PartTimeEmployees Monthly Number of Part-Time Employees (For Filter Statistics = 'Sum' for yearly data, the results are a Monthly Average)
TotalEmployees Monthly Number of Full-Time and Part-Time Employees (For Filter Statistics = 'Sum' for yearly data, the results are a Monthly Average)
FTEEmployees Monthly Number of FTE's (Full-Time Equivalent Employees count two part-time employees as one full-time employee) (For Filter Statistics = 'Sum' for yearly data, the results are a Monthly Average)
