Registered aircraft · 47,133

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:2000-23-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:2000-23-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:2000-23-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:2000-23-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:2000-23-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:2000-23-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.

N388WAuza Joseph · Casa Grande, AZBuilt 1956 · S/N 33876 N389Donalds Flying Service Inc · Pantego, NCBuilt 1953 · S/N 30085 N3890CBrandt Robert C · Schaumburg, ILBuilt 1954 · S/N 31038 N3890YEllsworth Joseph D Trustee · Salida, COBuilt 1964 · S/N 21058390 N3891CStaple K Aviation LLC · Queen Creek, AZBuilt 1954 · S/N 31039 N3891WPhoenix Construction Services Inc · Lynn Haven, FLBuilt 2022 · S/N 8993 N3891YCartwright Chris · Yuba City, CABuilt 1964 · S/N 21058391 N3892DWeiss Steven John · Las Vegas, NVBuilt 1957 · S/N 34592 N3893Rhynard Andrew · Fairbanks, AKBuilt 1958 · S/N 50246 N3893CCravens Robert A · Bend, ORBuilt 1954 · S/N 31041 N3893DGardner Jay A · Agua Dulce, CABuilt 1957 · S/N 34593 N38944Lewis David A · Fairfield, CAFirst renewal noticeBuilt 1977 · S/N 28R-7703284 N3894CWatson Philip D · Wheatland, INBuilt 1954 · S/N 31042 N3895GMike Kilo Aviation LLC · Garden Ridge, TXBuilt 1967 · S/N U206-0895 N3896DMills Air Service Inc · Marstons Mills, MABuilt 1957 · S/N 34596 N3896GEco Flite Service Inc · Lake Elsinore, CABuilt 1967 · S/N U206-0896 N3897CKing Bruce J · Waldport, ORBuilt 1954 · S/N 31045 N3897YHmw LLC · Wilmington, DEBuilt 1964 · S/N 21058397 N38981Kreck Blake T · Terrell, TXBuilt 1977 · S/N 28R-7703290 N38991Jaquez Francisco P · Corona, NYBuilt 1977 · S/N 28R-7703291 N38995Baxter Donald J · Dallas, TXBuilt 1977 · S/N 28R-7703292 N389ARLifetime Aviation Services LLC · Muncie, INBuilt 2024 · S/N 10190 N389BCBrady Scott · Manakin Sabot, VAS/N CD-1160 N389BHHorn Bradley P · Waterloo, ILBuilt 1961 · S/N 185-0098 N389BS94k Aviation LLC · Wichita, KSBuilt 2016 · S/N 1389 N389CSSahi Carl R · Coventry, CTBuilt 1985 · S/N 250860 N389MCCarstetter Melvin D · Lakebay, WABuilt 1978 · S/N D-10150 N389SLively Kirk D · Cresson, TXBuilt 1969 · S/N D-9083 N389WAOlsen Donald Jr · Silverdale, WABuilt 1966 · S/N 337-0389 N389WMKairos Holdings LLC · Scottsboro, ALBuilt 2024 · S/N 9905 N389ZSmith Daniel P · Saint George, UTBuilt 1960 · S/N D-6561 N38AUBraun Aviation LLC · Lakewood Village, TXBuilt 2024 · S/N 10332 N38AWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 1971 N38AZN731ny LLC · Phoenix, AZBuilt 1980 · S/N P21000516 N38BTMccully Bruce F · Nashville, TNS/N D-7261 N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023 N38CMSale Reported · Fay-Aux-LogesSale reportedBuilt 1979 · S/N 340A0901 N38DBWestern Skymaters LLC · Salt Lake City, UTBuilt 1973 · S/N 0002 N38DKCullinan Robert B · Rch Palos Vrd, CABuilt 1965 · S/N D-7899 N38DVMedic Choppers LLC · Springdale, ARBuilt 1968 · S/N E-83 N38DZWoolard Flying Service Inc · Corning, ARBuilt 1990 · S/N TH-1577 N38EPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2068 N38FCEagle Aero Inc · Lafayette, LABuilt 1980 · S/N 18504145 N38FE239 Lear LLC · Dover, DES/N 340-0096 N38FGPatten Mark Samuel · Anchorage, AKBuilt 1979 · S/N 18503920 N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829 N38GWAircraft Partner N38gw Dst · BerlinBuilt 2004 · S/N 1015 N38HVVandervoort Hendrikus J · Waller, TXBuilt 2017 · S/N 957 N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960 N38LZJk Hangar LLC · Green Bay, WIBuilt 2007 · S/N 2782

Back to AD 2000-23-21