Skip to content

Registered aircraft · 1,634

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21')
ORDER BY 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.

N209HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8186 N209NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5901 N210NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5540 N211NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5442 N212HAAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 8129 N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498 N213HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8237 N214HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8157 N215HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8266 N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292 N216HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8471 N217HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8578 N218HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 8764 N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229 N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255 N220HAHawaiian Airlines Inc · Seatac, WABuilt 2019 · S/N 8872 N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262 N223HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 9060 N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694 N226HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 9127 N226VLSetna Io LLC · Lincolnshire, ILS/N 2264 N227HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 9223 N228HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 9274 N228NVSunrise Asset Management LLC · Las Vegas, NVBuilt 1997 · S/N 716 N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667 N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773 N230HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 9547 N230NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2001 · S/N 1372 N231XCMojave Jet LLC · Nolensville, TNS/N 231 N232FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6838 N233FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7095 N233NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2003 · S/N 2001 N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272 N235NVSunrise Asset Management LLC · Las Vegas, NVS/N 1130 N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389 N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458 N238NVUmb Bank Na Trustee · Salt Lake City, UTS/N 2133 N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144 N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550 N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664 N247NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7704 N248NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7781 N249NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7766 N250NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7743 N251NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7838 N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252 N252NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7868 N253ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3690 N253NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7900 N254NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7913

Back to AD 2018-17-21