Aircraft Histories

ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
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)HistoryForeignAircraftNatural ID
Aircraft IDint(11)Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation)HistoryPrimary/ForeignAircraftAircraft ID
C/Nvarchar(16)Construction/Line NumberHistory
MSNvarchar(16)Manufacturer Serial NumberHistory
Production Linevarchar(255)Production Line designation (i.e. A320)History
Aircraft Familyvarchar(255)Aircraft Family designation (i.e. A320N)History
Aircraftvarchar(16)Aircraft designation (i.e. A321)History
Aircraft Typevarchar(16)Aircraft Type designation (i.e. A321-200)History
Aircraft Variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)History
Airlinevarchar(255)Operator nameHistory
Airline ch-a Codevarchar(4)Operator ch-aviation code (assigned by ch-aviation)HistoryForeignAirlinesAirline ch-a Code
Registrationvarchar(16)Aircraft Registration, blank if unknown or no longer registeredHistory
Date FromVarchar(10)From date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY)HistoryPrimary
Date Tovarchar(10)To date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY)History
Date Invarchar(10)Date the aircraft was delivered to the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY)History
Date Outvarchar(10)Date the aircraft left the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY)History
Roll-Outvarchar(10)Date the aircraft was rolled out  (YYYY-MM-DD, YYYY-MM or YYYY)History
Registration Datevarchar(10)Date the aircraft was first registered  (YYYY-MM-DD, YYYY-MM or YYYY)History
First Flightvarchar(10)Date the aircraft has first flown  (YYYY-MM-DD, YYYY-MM or YYYY)History
Delivery Datevarchar(10)Actual Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY)History
First Sightingvarchar(10)Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY)History
End of Lifevarchar(10)Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY)History
Engine Manufacturervarchar(255)Engine manufacturer nameHistory
Engine Manufacturer Codevarchar(4)Engine manufacturer ch-aviation code (assigned by ch-aviation)HistoryForeignEntitiesEntity ch-a Code
Engine Familyvarchar(16)Engine family (i.e. JT9D)History
Engine Master Seriesvarchar(32)Engine master series designation (i.e. JT9D-7R4)History
Engine Typevarchar(16)Engine type designation (i.e. PW JT9D)History
Engine Subtypevarchar(32)Engine subtype designation (i.e. PW JT9D-7R4H1)History
Number of Enginesint(11)Number of engines installed on the aircraftHistory