Column |
Data Type |
Data description |
Package required |
Key |
Data Set |
Join On |
Internal notes |
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(4) |
Operator ch-aviation code (assigned by ch-aviation) |
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 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 |
|