| 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) | Utilisation | 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) | Utilisation | Foreign | Aircraft | Aircraft ID | |
| Operator | varchar(255) | Operator name | Utilisation | | | | |
| 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. | Utilisation | Foreign | Airlines | Airline ch-a Code | |
| Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Utilisation | | | | |
| CN | varchar(16) | Construction/Line Number | Utilisation | | | | |
| MSN | varchar(16) | Manufacturer Serial Number | Utilisation | | | | |
| Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | Utilisation | | | | |
| xxxx-yy cycles | decimal(10,0) | number of monthly cycles, a column exists for each xxxx-yy, where xxxx = year, yy = month; data available for previous, current and next year | Utilisation | | | | |
| xxxx-yy hours | decimal(10,0) | number of monthly hours, a column exists for each xxxx-yy, where xxxx = year, yy = month; data available for previous, current and next year | Utilisation | | | | |
| xxxx-yy avg stage length | char(5) | average monthly stage length in hours and minutes (hh:mm), a column exists for each xxxx-yy, where xxxx = year, yy = month; data available for previous, current and next year | Utilisation | | | | |
| xxxx-yy avg daily utilisation | char(5) | average daily utilisation in hours and minutes (hh:mm), a column exists for each xxxx-yy, where xxxx = year, yy = month; data available for previous, current and next year | Utilisation | | | | |
| xxxx-yy utilisation data type | varchar(255) | indication whether the data is: actual historical data, estimated data, or forecasted data, a column exists for each xxxx-yy, where xxxx = year, yy = month | Utilisation | | | | |
| TTM cycles | int(11) | Trailing twelve months cycles | Utilisation | | | | |
| TTM hours | decimal(10,2) | Trailing twelve months hours | Utilisation | | | | |
| TTM avg stage length | char(5) | Trailing twelve months average stage length (hh:mm) | Utilisation | | | | |
| TTM avg daily utilisation | char(5) | Trailing twelve months average daily utilisation (hh:mm) | Utilisation | | | | |
| Since EIS cycles | int(11) | Cycles since entry into service | Utilisation | | | | |
| Since EIS hours | decimal(10,2) | Hours since entry into service | Utilisation | | | | |
| Since EIS avg stage length | char(5) | Avg. stage length since entry into service (hh:mm) | Utilisation | | | | |
| Since EIS avg daily utilisation | char(5) | Avg. daily utilisation since entry into service (hh:mm) | Utilisation | | | | |
| As of | date | As of date (date when utilisation data was last provided) | Utilisation | | | | |
| Source | varchar(255) | Source of utilisation data | Utilisation | | | | |
| Source ch-a Code | varchar(3) | Operator or Manufacturer ch-aviation code (assigned by ch-aviation) | Utilisation | Foreign | Airlines | Airline ch-a Code | |
