Aircraft Histories

Column Data Type Data description Package required Key Data Set Join On
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) History 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) History Primary/Foreign Aircraft Aircraft ID
C/N varchar(16) Construction/Line Number History      
MSN varchar(16) Manufacturer Serial Number History      
Production Line varchar(255) Production Line designation (i.e. A320) History      
Aircraft Family varchar(255) Aircraft Family designation (i.e. A320N) History      
Aircraft varchar(16) Aircraft designation (i.e. A321) History      
Aircraft Type varchar(16) Aircraft Type designation (i.e. A321-200) History      
Aircraft Variant varchar(255) Aircraft Variant designation (i.e. A321-200N) History      
Airline varchar(255) Operator name History      
Airline ch-a Code varchar(4) Operator ch-aviation code (assigned by ch-aviation) History Foreign Airlines Airline ch-a Code
Registration varchar(16) Aircraft Registration, blank if unknown or no longer registered History      
Date From Varchar(10) From date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) History Primary    
Date To varchar(10) To date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) History      
Date In varchar(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 Out varchar(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-Out varchar(10) Date the aircraft was rolled out  (YYYY-MM-DD, YYYY-MM or YYYY) History      
Registration Date varchar(10) Date the aircraft was first registered  (YYYY-MM-DD, YYYY-MM or YYYY) History      
First Flight varchar(10) Date the aircraft has first flown  (YYYY-MM-DD, YYYY-MM or YYYY) History      
Delivery Date varchar(10) Actual Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) History      
First Sighting varchar(10) Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) History      
End of Life varchar(10) Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) History      
Engine Manufacturer varchar(255) Engine manufacturer name History      
Engine Manufacturer Code varchar(4) Engine manufacturer ch-aviation code (assigned by ch-aviation) History Foreign Entities Entity ch-a Code
Engine Family varchar(16) Engine family (i.e. JT9D) History      
Engine Master Series varchar(32) Engine master series designation (i.e. JT9D-7R4) History      
Engine Type varchar(16) Engine type designation (i.e. PW JT9D) History      
Engine Subtype varchar(32) Engine subtype designation (i.e. PW JT9D-7R4H1) History      
Number of Engines int(11) Number of engines installed on the aircraft History