Skip to content

Hawaiian Airlines Inc

Registered aircraft · 45

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 = 'HAWAIIAN AIRLINES INC' OR list_contains(g.other_registrant_names, 'HAWAIIAN 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 = 'HAWAIIAN AIRLINES INC' OR list_contains(g.other_registrant_names, 'HAWAIIAN 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 = 'HAWAIIAN AIRLINES INC' OR list_contains(g.other_registrant_names, 'HAWAIIAN 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.

N202HAAirbus A321-271N · S/N 7917Built 2017 · Seattle, WA N204HAAirbus A321-271N · S/N 7959Built 2017 · Seattle, WA N214HAAirbus A321-271N · S/N 8157Built 2018 · Seattle, WA N215HAAirbus A321-271N · S/N 8266Built 2018 · Seattle, WA N216HAAirbus A321-271N · S/N 8471Built 2018 · Seattle, WA N217HAAirbus A321-271N · S/N 8578Built 2018 · Seattle, WA N218HAAirbus A321-271N · S/N 8764Built 2019 · Seattle, WA N220HAAirbus A321-271N · S/N 8872Built 2019 · Seatac, WA N223HAAirbus A321-271N · S/N 9060Built 2019 · Seattle, WA N226HAAirbus A321-271N · S/N 9127Built 2019 · Seattle, WA N228HAAirbus A321-271N · S/N 9274Built 2019 · Seattle, WA N251MBellanca CH300 PACEMAKER · S/N 154Built 1929 · Seattle, WA N370HAAirbus A330-243 · S/N 1511Built 2014 · Seattle, WA N373HAAirbus A330-243 · S/N 1530Built 2014 · Seattle, WA N383HAAirbus A330-243 · S/N 1217Built 2011 · Seattle, WA N384HAAirbus A330-243 · S/N 1259Built 2011 · Seattle, WA N385HAAirbus A330-243 · S/N 1295Built 2012 · Seattle, WA N391HAAirbus A330-243 · S/N 1399Built 2013 · Seatac, WA N396HAAirbus A330-243 · S/N 1488Built 2014 · Seattle, WA N399HAAirbus A330-243 · S/N 1496Built 2014 · Seattle, WA N475HABoeing 717-200 · S/N 55121Built 2001 · Seattle, WA N476HABoeing 717-200 · S/N 55118Built 2001 · Seattle, WA N477HABoeing 717-200 · S/N 55122Built 2001 · Seatac, WA N478HABoeing 717-200 · S/N 55123Built 2001 · Seattle, WA N479HABoeing 717-200 · S/N 55124Built 2001 · Seattle, WA N480HABoeing 717-200 · S/N 55125Built 2001 · Seattle, WA N483HABoeing 717-200 · S/N 55128Built 2001 · Seattle, WA N484HABoeing 717-200 · S/N 55129Built 2001 · Seatac, WA N485HABoeing 717-200 · S/N 55130Built 2001 · Seatac, WA N486HABoeing 717-200 · S/N 55131Built 2001 · Seattle, WA N487HABoeing 717-200 · S/N 55132Built 2001 · Seattle, WA N488HABoeing 717-200 · S/N 55001Built 1998 · Seattle, WA N489HABoeing 717-200 · S/N 55002Built 1998 · Seattle, WA N490HABoeing 717-200 · S/N 55151Built 2000 · Seattle, WA N491HABoeing 717-200 · S/N 55175Built 2003 · Seatac, WA N492HABoeing 717-200 · S/N 55181Built 2004 · Seatac, WA N493HABoeing 717-200 · S/N 55184Built 2005 · Seatac, WA N494HABoeing 717-200 · S/N 55182Built 2004 · Seattle, WA N495HABoeing 717-200 · S/N 55185Built 2004 · Seatac, WA N780HABoeing 787-9 · S/N 66428Built 2024 · Seattle, WA N781HABoeing 787-9 · S/N 66429Built 2023 · Seattle, WA N783HABoeing 787-9 · S/N 66431Built 2025 · Seattle, WA N784HABoeing 787-9 · S/N 66432Built 2025 · Seattle, WA N826BCBoeing 717-200 · S/N 55183Honolulu, HI N883BCBoeing 717-200 · S/N 55190Honolulu, HI

Back to Hawaiian Airlines Inc