Regional Subsidiaries

Column Data Type Data description Package required Key Data Set Join On
Rel Subsidiary varchar(48) Regional brand name Airlines Primary Regional Carriers Rel Subsidiary
Parent Carrier varchar(255) Parent name Airlines      
Parent Carrier ch-a Code varchar(3) Parent operator ch-aviation code (assigned by ch-aviation) Airlines Primary/Foreign Airlines Airline ch-a Code