Skip to content

Registered aircraft · 149

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

N100LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9321 N100QSRegistered aircraftBuilt 2012 · S/N 9480 N101QSRegistered aircraftBuilt 2012 · S/N 9483 N101UDUnicorp Aviation LLC · Orlando, FLS/N 60015 N104QSRegistered aircraftBuilt 2013 · S/N 9555 N109QSRegistered aircraftBuilt 2013 · S/N 9589 N110QSRegistered aircraftBuilt 2013 · S/N 9592 N111QSRegistered aircraftBuilt 2014 · S/N 9660 N112QSRegistered aircraftBuilt 2015 · S/N 9710 N113QSRegistered aircraftBuilt 2015 · S/N 9722 N114QSRegistered aircraftBuilt 2015 · S/N 9732 N115QSRegistered aircraftBuilt 2015 · S/N 9734 N116QSRegistered aircraftBuilt 2016 · S/N 9768 N117MSStar Flight LLC · Greenwich, CTBuilt 2014 · S/N 9386 N117QSRegistered aircraftBuilt 2016 · S/N 9777 N119JJJohnson Willis J · Franklin, TNBuilt 2019 · S/N 9879 N11ABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9536 N120QSRegistered aircraftBuilt 2022 · S/N 60066 N121QSRegistered aircraftBuilt 2022 · S/N 60070 N1226Five Delta Alpha LLC · Dover, DEBuilt 2015 · S/N 9737 N122QSNetjets Sales Inc · Oklahoma City, OKBuilt 2022 · S/N 60073 N123QSRegistered aircraftBuilt 2022 · S/N 60076 N124QSRegistered aircraftBuilt 2023 · S/N 60080 N125QSRegistered aircraftBuilt 2023 · S/N 60085 N126QSRegistered aircraftBuilt 2023 · S/N 60090 N127QSRegistered aircraftBuilt 2023 · S/N 60102 N128QSRegistered aircraftBuilt 2024 · S/N 60113 N129QSRegistered aircraftBuilt 2024 · S/N 60117 N130QSRegistered aircraftBuilt 2024 · S/N 60126 N131QSRegistered aircraftBuilt 2024 · S/N 60134 N132QSRegistered aircraftBuilt 2024 · S/N 60137 N133QSRegistered aircraftBuilt 2024 · S/N 60149 N134QSRegistered aircraftBuilt 2025 · S/N 60165 N135QSRegistered aircraftBuilt 2025 · S/N 60175 N136QSRegistered aircraftBuilt 2025 · S/N 60182 N137QS8brs LLC · Oklahoma City, OKBuilt 2025 · S/N 60185 N137ZMZoma Falcon LLC · Centennial, COBuilt 2008 · S/N 9275 N138QS9494 Aviation LLC · Oklahoma City, OKBuilt 2026 · S/N 60196 N139QSRegistered aircraftBuilt 2025 · S/N 60200 N140QSTvpx Aircraft Solutions Inc Trustee · Oklahoma City, OKBuilt 2026 · S/N 60205 N142RMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 60022 N144QSRegistered aircraftS/N 60216 N149QSRegistered aircraftS/N 60221 N188JHaut Enterprises LLC · North Kingstown, RIBuilt 2010 · S/N 9383 N205ELInvemed Securities Inc · New York, NYBuilt 2006 · S/N 9201 N20RGBsr Aviation LLC · Crestwood, KYBuilt 2006 · S/N 9190 N214MDHdb Aviation LLC · Farmers Branch, TXBuilt 2004 · S/N 9152 N215TMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9719 N226RRegistered aircraftAssigned (import), pending cancellationS/N 60226 N240WLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 9696

Back to AD 2014-21-08