Start-Ups

ColumnData TypeData descriptionKeyData SetJoin On
Operator Namevarchar(255)Operator name
Operator ch-a Codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.Primary/ForeignOperatorsOperator ch-a Code
Start-Up Infovarchar(255)Start-up information free text
IATAvarchar(2)Operator IATA two-character code
Countryvarchar(255)Country name
Country ISOchar(2)ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
Typevarchar(255)Description of operator's primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier)
Type Codechar(1)Operator type code: S - Scheduled Carrier, V - Virtual Carrier, D - Division, C - Cargo Carrier, B - Business/Private Carrier, G - Government, M - Manufacturer, U - Supplier
Websitevarchar(255)Website URL
Planned Start-Upvarchar(255)Planned start-up quarter (formatted yyyy/qq)
Start-Up addeddateDate the start-up was added to the ch-aviation database
Start-Up last updateddateDate the start-up status was last updated
Majority government ownedvarchar(3)Indicator if start-up is majority government owned
Investorvarchar(255)Investor names
known investor in airlinesvarchar(3)Indicator if start-up has investor with an airline experience
known investor in aviationvarchar(3)Indicator if start-up has investor with aviation experience
Planned fleet sizesmallint(5)Planned fleet size
incorporation number/ VAT numbertextIncorporation number or VAT number
Incorporation_sourcetextSource of Incorporation number or VAT number
Application_date_AOCvachar(10)AOC application date or month (formatted as YYYY/MM)
AOC application in process?varchar(3)Indicator if AOC application is in progress
AOC application sourcetextSource of AOC application
AOC numbervarchar(255)AOC number if AOC has been awarded
AOC number sourcetextAOC number source
Start up aircraft variantsvarchar(255)Planned aircraft variants (if already known)
Start up aircraft familiesvarchar(255)Planned aircraft families (if already known)