Skip to content

Registered aircraft · 5,443

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:2016-07-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:2016-07-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:2016-07-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:2016-07-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:2016-07-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:2016-07-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.

N92DADelory Dana E · Shoreacres, TXBuilt 1992 · S/N 28-37057 N92GRMarrero Teresa · Jayuya, PRS/N 28-7816159 N92UATaylor Aviation Inc · Montgomery, NYBuilt 1992 · S/N 2837058 N930MAPlaceway Scott M · Lapeer, MIBuilt 2020 · S/N 2881404 N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459 N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241 N9318CTarakji Mohamad Hani A · Van Nuys, CABuilt 1978 · S/N 28-7890398 N931ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881511 N931GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881076 N9321CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 28R-7837191 N9324KBellew Philip H · Gadsden, ALBuilt 1976 · S/N 28-7690243 N932ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881512 N932GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881077 N9334CBadzinski James P · Roseville, MNBuilt 1978 · S/N 28-7816461 N9337CLovett Zachary · Fort Worth, TXBuilt 1978 · S/N 28-7816462 N9338CSmart4 LLC · Kissimmee, FLBuilt 1978 · S/N 28-7816463 N933CC27 Latitude LLC DBA · West Palm Beach, FLBuilt 1979 · S/N 28-7990503 N933GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881224 N933SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881873 N9341CMerlin Aviation LLC · South Saint Paul, MNBuilt 1978 · S/N 28-7890399 N934NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881887 N9358CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816466 N935DELong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990146 N935GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881078 N9360CPure Joy Aviation One LLC · Schaumburg, ILBuilt 1978 · S/N 28-7890401 N9362CThanheiser Heige · Lincoln, NEBuilt 1978 · S/N 28R-7837193 N9375CFucik John J · Reno, NVBuilt 1978 · S/N 28-7890403 N9377CLiggett Services Inc · Fort Washington, PABuilt 1978 · S/N 28R-7837195 N937SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881874 N9392CThompson Terry · Lake Placid, FLBuilt 1978 · S/N 28-7816471 N9396CShaw Kent E · Gaithersburg, MDBuilt 1978 · S/N 28-7816472 N9397CServant Air Ministries Inc · Merritt Island, FLBuilt 1978 · S/N 28-7890409 N939GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881079 N939RJUaa International Inc · La Verne, CABuilt 1998 · S/N 2843136 N93KNPataky Gabriel J · Sarasota, FLBuilt 1993 · S/N 2890174 N93WRDukic Slobodan · Jacksonville, FLBuilt 1977 · S/N 28-7890106 N9401CRegistered aircraftBuilt 1978 · S/N 28R-7837197 N9412KAero Quest LLC DBA · Olive Branch, MSS/N 28-7690249 N941GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881080 N941NZCumplido Luis · Rumford, RIBuilt 1977 · S/N 28R-7737172 N9431COsgood Air LLC · Ransom, KSBuilt 1978 · S/N 28-7890411 N943NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881922 N944DBManning David A · Aledo, TXS/N 2844109 N944EVSouthlake Aviation LLC · Arden, NCBuilt 2025 · S/N 2881867 N9454CPuglia Frank V · El Cajon, CABuilt 1978 · S/N 28-7816477 N945DBHoskins Joshua C · Frisco, TXBuilt 2000 · S/N 2843312 N945LBAllegro Jeff · Upper Lake, CABuilt 1979 · S/N 28-7990404 N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412 N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253 N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413

Back to AD 2016-07-21