OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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
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.

N118WHWindward Aero LLC · Moultonborough, NHBuilt 2020 · S/N 4914N1190QBritell Andrew Paul · Sandwich, NHBuilt 1972 · S/N 21059690N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506N1191QCameron Schoessler Aviation LLC · Bliss, IDBuilt 1975 · S/N U20602862N1194AGta Air Inc · Addison, TXBuilt 1969 · S/N E-159N1194QKirkpatrick Jason · Mosca, COBuilt 1975 · S/N U20602864N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236N1195MBrown Alan J · Cheyenne, WYBuilt 1975 · S/N 18264240N1195TRoberts Robin W · Birmingham, ALBuilt 1974 · S/N E-629N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N1197MSholer Jon R · Battle Ground, WABuilt 1975 · S/N 18264241N1197VVentry Solutions Inc · Hauser, IDBuilt 1976 · S/N R1722137N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698N1198ZExecutive Airfleet LLC · Boca Raton, FLS/N 411151N1199ULansford Inc · Clovis, NMBuilt 1982 · S/N 21064673N1199ZZdmsquared Aviation LLC · Phoenixville, PABuilt 2012 · S/N 0404N119ABSafford Aviation Service Inc · Coolidge, AZBuilt 1966 · S/N TE-145N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188N119ALSch Aviation Inc Trustee · Sporle Kings LynnS/N 3896N119BDPhillips Danny W · Jefferson, TXBuilt 1953 · S/N 23225N119BKAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2019 · S/N 1853N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119EWBte Aviation LLC · Wilmington, DEBuilt 1981 · S/N E-1863N119GN119g LLC · Dover, DEBuilt 2023 · S/N 9191N119GGYepes Hurtado Andres F · Lubbock, TXBuilt 1978 · S/N 28R-7931008N119JBWagner Mathew J · Gary, SDBuilt 1958 · S/N D-5683N119JLMayo Clive S · Palmetto Bay, FLBuilt 1973 · S/N 18262575N119JSFennen David A · Katy, TXBuilt 1961 · S/N D-6861N119LKMy Wings LLC · Eden Prairie, MNBuilt 2016 · S/N 4366N119LMRegistered aircraftBuilt 1971 · S/N 22-0001N119MKFlatirons Aviation LLC · Naples, FLBuilt 2011 · S/N 2084N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121N119PARicciardi Brian P · Hyannis, MAS/N 402B0610N119PEDoo Me Too LLC · Spearfish, SDS/N 411043N119PTGod Speed Aviation LLC · Bloomington, INBuilt 2023 · S/N 9398N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231N119RKHtv Music Co · Franklin, TNBuilt 1972 · S/N 18261574N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N119WJLauber Land Developers LLC · Saint Louis, MOS/N 3978N119WWDavis Bob F · Helena, MTBuilt 1951 · S/N 22481N119WZWhiskey Zulu LLC · Urbandale, IABuilt 2002 · S/N 0414N119XUSale Reported · VentabrenSale reportedBuilt 1973 · S/N 0008N11ACN11ac LLC · Lighthouse Point, FLS/N TC-215N11APAp Aero LLC · Oklahoma City, OKBuilt 1974 · S/N 21060168N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11BCBledsoe Lucile M · Wray, COBuilt 1991 · S/N EA-515N11BNAlpha 414a LLC · New Smyrna Beach, FLBuilt 1979 · S/N 414A0311N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146
Back to AD 2000-23-21