Aircraft Utilisation

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