Skip to content

Registered aircraft · 891

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:2004-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-06-13') 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:2004-06-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-06-13')
  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:2004-06-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-06-13')
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.

N205NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5724 N206FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4272 N206NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5289 N207FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4307 N207NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5638 N208NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5640 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 N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498 N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292 N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229 N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255 N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262 N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694 N226VLSetna Io LLC · Lincolnshire, ILS/N 2264 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 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 N255NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7989 N256NVSunrise Asset Managment LLC · Las Vegas, NVBuilt 2018 · S/N 8220 N257NVAllegiant Air LLC · Las Vegas, NVBuilt 2018 · S/N 8329 N258NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4015 N259NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4057 N260NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4104 N261NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4115 N262NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4122

Back to AD 2004-06-13