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.

N916TTReyes-Hernandez Jose R · San Juan, PRBuilt 1989 · S/N 2841146 N9172YMohammadreza Sabzi · Los Angeles, CABuilt 1985 · S/N 28-8616034 N9174MParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616035 N917DKEncore Jet Management LLC · San Antonio, TXBuilt 1998 · S/N 2843186 N917TCDebarros David · Ashland, VABuilt 1998 · S/N 2843167 N9180DSan Souci Holdings LLC · Reisterstown, MDS/N 2837014 N9180HPiper Aircraft Inc · Vero Beach, FLS/N 2837015 N9182WMoyer Aviation Inc · Tobyhanna, PABuilt 1989 · S/N 2841130 N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141 N9183WAerolina Inc · Hendersonville, NCBuilt 1989 · S/N 2837024 N918AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881947 N918GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881074 N918PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843307 N9191N9191n LLC · Salem, NHBuilt 1989 · S/N 2890136 N9195KWatson Joseph L Jr · Concord, NCBuilt 1976 · S/N 28-7690227 N9197BEsteban John G · Dublin, NHBuilt 1993 · S/N 2890192 N919AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881948 N919RFRegion Flyers LLC · Valparaiso, INBuilt 1981 · S/N 28-8216062 N91EENorthern Tier Private Investg & Security Cnslg Inc · Towanda, PABuilt 1982 · S/N 28-8390005 N9201ZOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841001 N9205XOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841005 N9206NSkylink Xpress Inc · San Bernardino, CABuilt 1990 · S/N 2841301 N920ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841216 N9210BOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841010 N92135Jackson Christopher Michael · Clearwater, FLBuilt 1979 · S/N 288090127 N9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022 N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023 N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229 N921NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881885 N921PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843268 N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030 N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447 N9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1989 · S/N 2841044 N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448 N9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391 N9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232 N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392 N9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181 N9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841123 N9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeBuilt 1976 · S/N 28-7690233 N9240KHolland Wyatt Eugene · Garner, IAS/N 28-7690234 N9246FFischer Alfred M · Genoa City, WIBuilt 1989 · S/N 2841254 N9248KGerstner Michael J · Ola, ARBuilt 1976 · S/N 28-7690236 N924NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881886 N92500Romeo Charlie Aviation LLC · Stuart, FLBuilt 1994 · S/N 2890207 N92505Thunderbird Aviation Inc · Bloomington, MNBuilt 1994 · S/N 2890211 N9250CRegion Flyers LLC · Valparaiso, INBuilt 1978 · S/N 28-7816451 N9254KBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7690237 N9255CD&J Aviation LLC · Apopka, FLBuilt 1978 · S/N 28-7890393 N9256CBluegrass Aviation LLC · Clarksville, TNBuilt 1978 · S/N 28-7890394

Back to AD 2016-07-21