| Natural ID | varchar(30) | Natural aircraft ID (combination of the ch-aviation production line code and either the line/construction or manufacturer serial number, changes for aircraft not yet delivered where l/n, c/n or msn are not yet known (assigned by ch-aviation) | Foreign | Aircraft | Natural ID |
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) | Foreign | Aircraft | Aircraft ID |
| Operator | varchar(255) | Operator name | | | |
| Opr. ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
| Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | | | |
| CN | varchar(16) | Construction/Line Number | | | |
| MSN | varchar(16) | Manufacturer Serial Number | | | |
| Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | | | |
| Month | month | Month of the hours and cycles | | | |
| Year | year | Year of the hours and cycles | | | |
| cycles | decimal(10,0) | number of monthly cycles | | | |
| hours | decimal(10,2) | number of monthly hours (hhh.hh) | | | |
| avg stage length | char(5) | average monthly stage length in hours and minutes (hh:mm) | | | |
| avg_daily_utilisation | char(5) | average daily utilisation in hours and minutes (hh:mm) | | | |
| utilisation_data_type | varchar(255) | indication whether the data is: actual historical data, estimated data, forecasted data or ADS-B data | | | |
| TTM cycles | int(11) | Trailing twelve months cycles | | | |
| TTM hours | decimal(10,2) | Trailing twelve months hours | | | |
| TTM avg stage length | char(5) | Trailing twelve months average stage length (hh:mm) | | | |
| TTM avg daily utilisation | char(5) | Trailing twelve months average daily utilisation (hh:mm) | | | |
| since eis cycles | int(11) | Cycles since entry into service | | | |
| since eis hours | decimal(10,2) | Hours since entry into service | | | |
| since eis avg stage length | char(5) | Avg. stage length since entry into service (hh:mm) | | | |
| since eis avg daily utilisation | char(5) | Avg. daily utilisation since entry into service (hh:mm) | | | |
| as of | date | As of date (date when utilisation data was last provided) | | | |
| source | varchar(255) | Source of utilisation data | | | |
| source ch code | varchar(3) | Operator or Manufacturer ch-aviation code (assigned by ch-aviation) | | | |
| data quality indicator | varchar(16) | An aircraft is whitelisted for an operator/MSN combination if it meets one of the following: Utilization Match: Spire ADS-B based cycles closely align with OEM data (within ±1–2 cycles or ±10%, depending on sample size) in the past two years. Flight Path Continuity: At least 95% of previous destinations match the next origin, with 10+ flights tracked in the past two years. Otherwise, it is blacklisted | | | |
| data quality index | decimal(3,2) | A score from 0 to 1 indicating completeness of flight tracking for the month: 0 = takeoff and/or landing missing; 1 = both takeoff and landing are present; values in between reflect partial data completeness. | | | |
