Skip to content

Alaska Airlines Inc

Registered aircraft · 235

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'ALASKA AIRLINES INC' OR list_contains(g.other_registrant_names, 'ALASKA AIRLINES INC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'ALASKA AIRLINES INC' OR list_contains(g.other_registrant_names, 'ALASKA AIRLINES INC')
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'ALASKA AIRLINES INC' OR list_contains(g.other_registrant_names, 'ALASKA AIRLINES INC')
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N205HAAirbus A321-271N · S/N 8092Built 2018 · Seatac, WA N212HAAirbus A321-271N · S/N 8129Built 2018 · Seatac, WA N214AKBoeing 737-900ER · S/N 60579Built 2019 · Seatac, WA N215AKBoeing 737-900ER · S/N 36347Built 2019 · Seattle, WA N224AKBoeing 737-990ER · S/N 62680Built 2016 · Seattle, WA N236AKBoeing 737-990ER · S/N 36351Built 2016 · Seattle, WA N237AKBoeing 737-990ER · S/N 36357Built 2016 · Seattle, WA N238AKBoeing 737-990ER · S/N 62681Built 2016 · Seattle, WA N247AKBoeing 737-990ER · S/N 36364Built 2016 · Seattle, WA N248AKBoeing 737-990ER · S/N 62469Built 2016 · Seattle, WA N251AKBoeing 737-990ER · S/N 62470Seatac, WA N253AKBoeing 737-990ER · S/N 36348Built 2016 · Seattle, WA N260AKBoeing 737-990ER · S/N 36349Built 2016 · Seattle, WA N263AKBoeing 737-990ER · S/N 62471Built 2016 · Seattle, WA N264AKBoeing 737-990ER · S/N 36360Built 2016 · Seatac, WA N265AKBoeing 737-900ER · S/N 62682Built 2016 · Seatac, WA N266AKBoeing 737-900ER · S/N 62683Built 2016 · Seatac, WA N267AKBoeing 737-900ER · S/N 60581Built 2017 · Seattle, WA N268AKBoeing 737-900ER · S/N 36365Built 2017 · Seattle, WA N270AKBoeing 737-900ER · S/N 44111Built 2017 · Seattle, WA N272AKBoeing 737-900ER · S/N 44112Built 2017 · Seattle, WA N273AKBoeing 737-900ER · S/N 61554Built 2017 · Seatac, WA N274AKBoeing 737-900ER · S/N 61555Built 2017 · Seattle, WA N275AKBoeing 737-900ER · S/N 61556Built 2017 · Seatac, WA N277AKBoeing 737-900ER · S/N 62472Built 2017 · Seatac, WA N278AKBoeing 737-900ER · S/N 44113Built 2017 · Seatac, WA N280AKBoeing 737-900ER · S/N 60582Built 2017 · Seattle, WA N281AKBoeing 737-900ER · S/N 62679Built 2017 · Seatac, WA N282AKBoeing 737-900ER · S/N 62473Built 2017 · Seattle, WA N283AKBoeing 737-900ER · S/N 36358Built 2017 · Seattle, WA N284AKBoeing 737-900ER · S/N 64152Built 2017 · Seattle, WA N285AKBoeing 737-900ER · S/N 60577Built 2018 · Seatac, WA N287AKBoeing 737-900ER · S/N 36359Built 2018 · Seatac, WA N288AKBoeing 737-900ER · S/N 60575Built 2018 · Seatac, WA N290AKBoeing 737-900ER · S/N 64300Built 2018 · Seattle, WA N291BTBoeing 737-9 · S/N 44088Built 2021 · Seattle, WA N292AKBoeing 737-900ER · S/N 64301Built 2018 · Seatac, WA N293AKBoeing 737-900ER · S/N 64302Built 2018 · Seatac, WA N294AKBoeing 737-900ER · S/N 64303Built 2018 · Seatac, WA N296AKBoeing 737-900ER · S/N 64304Built 2018 · Seattle, WA N297AKBoeing 737-900ER · S/N 60578Built 2019 · Seattle, WA N298AKBoeing 737-900ER · S/N 60583Built 2019 · Seattle, WA N374HAAirbus A330-243 · S/N 1565Built 2014 · Seattle, WA N386HAAirbus A330-243 · S/N 1302Built 2012 · Seatac, WA N388HAAirbus A330-243 · S/N 1310Built 2012 · Seattle, WA N393HAAirbus A330-243 · S/N 1422Built 2013 · Seatac, WA N395HAAirbus A330-243 · S/N 1469Built 2013 · Seattle, WA N402ASBoeing 737-990ER · S/N 41189Built 2012 · Seatac, WA N403ASBoeing 737-990ER · S/N 41730Built 2012 · Seattle, WA N407ASBoeing 737-990ER · S/N 41731Built 2012 · Seatac, WA

Back to Alaska Airlines Inc