Aircraft Utilisation

ColumnData TypeData descriptionPackage requiredKeyData SetJoin OnInternal notes
Natural IDvarchar(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)UtilisationForeignAircraftNatural ID
Aircraft IDint(11)Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation)UtilisationForeignAircraftAircraft ID
Operatorvarchar(255)Operator nameUtilisation
Opr. ch-a Codevarchar(4)Operator ch-aviation code (assigned by ch-aviation)UtilisationForeignAirlinesAirline ch-a Code
Variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)Utilisation
CNvarchar(16)Construction/Line NumberUtilisation
MSNvarchar(16)Manufacturer Serial NumberUtilisation
Registrationvarchar(16)Aircraft Registration, blank if unknown or no longer registeredUtilisation
xxxx-yy cyclesdecimal(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 yearUtilisation
xxxx-yy hoursdecimal(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 yearUtilisation
xxxx-yy stage lengthchar(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 yearUtilisation
xxxx-yy avg daily utilisationchar(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 yearUtilisation
xxxx-yy utilisation data typevarchar(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 = monthUtilisation
TTM cyclesint(11)Trailing twelve months cyclesUtilisation
TTM hoursdecimal(10,2)Trailing twelve months hoursUtilisation
TTM avg stage lengthchar(5)Trailing twelve months average stage length (hh:mm)Utilisation
TTM avg daily utilisationchar(5)Trailing twelve months average daily utilisation (hh:mm)Utilisation
Since EIS cyclesint(11)Cycles since entry into serviceUtilisation
Since EIS hoursdecimal(10,2)Hours since entry into serviceUtilisation
Since EIS avg stage lengthchar(5)Avg. stage length since entry into service (hh:mm)Utilisation
Since EIS avg daily utilisationchar(5)Avg. daily utilisation since entry into service (hh:mm)Utilisation
As ofdateAs of date (date when utilisation data was last provided)Utilisation
Sourcevarchar(255)Source of utilisation dataUtilisation
Source ch-a Codevarchar(3)Operator or Manufacturer ch-aviation code (assigned by ch-aviation)UtilisationForeignAirlinesAirline ch-a Code