Where can I find a database that contains all the airline companies with their alliances and if they are low cost or not

Question

I am looking for a database that contains all the airline companies alongside the alliances that they belong to, and if they are low-cost or not.

So far I found this Airport, airline and route data but it doesn't seem to give the information on whether the compagnies are low cost and to which alliance they belong to.

Answer 1

Try this query on Wikidata:

SELECT DISTINCT ?aLabel ?is_lowcost ?affiliateLabel ?iata where {
  ?a wdt:P31/wdt:P279* wd:Q1875615 .
  BIND ((EXISTS {?a wdt:P31 wd:Q190915 }) AS ?is_lowcost )
  OPTIONAL {?a wdt:P749 ?parent}
  OPTIONAL {?a wdt:P361 ?whole}
  OPTIONAL {?a wdt:P127 ?owner}
  OPTIONAL {?a wdt:P114 ?alliance}
  OPTIONAL {?a wdt:P229 ?iata}
  BIND ( COALESCE(?alliance, ?parent, ?parent, ?owner) AS ?affiliate)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
  } ORDER BY DESC(?is_lowcost)

The values in the affiliateLabel column are coalesced from the values of these properties:

• parent organization,
• part of,
• owner,
• airline alliance.

Try this query, if you want to get the values of these properties separated.

As to low-coster status, the data is obviously incomplete. For instanse, wd:Q18398469 is definitely a low-coster.