OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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.

N333PSDoran Jeffrey T · Westerville, OHS/N 21060834N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525N333PXTime Investment Corp · Greenville, NCBuilt 2011 · S/N 3791N333QBAdams Chad D · Dayton, ORBuilt 1955 · S/N 31398N333QKPcg Aviation LLC · Charleston, SCBuilt 2025 · S/N 11014N333RDConn Aviation LLC · Millersburg, OHBuilt 2020 · S/N 2161N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188N333RYZ2 Aviation LLC · Sausalito, CABuilt 2025 · S/N 10809N333SJDonald Robert Ferguson · Billings, MTBuilt 1974 · S/N 18502614N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779N333TFBluebird Airways Inc · East Palatka, FLBuilt 1975 · S/N CE-553N333THUchiyamada Brian N · San Gabriel, CABuilt 1977 · S/N CE-692N333TRBreaking Wind LLC · Alabaster, ALBuilt 1979 · S/N CE-860N333UDSpecialty Aero LLC · Seattle, WABuilt 1981 · S/N 340A1256N333VSFgc Corrmed Aero Inc · Benton, KYBuilt 2023 · S/N 9200N333VWHelderman Laban W · Newton, NCBuilt 1956 · S/N 33952N333WDanarich LLC · Rancho Mirage, CABuilt 1979 · S/N TE-1172N333WAPowell Jay · Columbia, MSBuilt 1969 · S/N E-176N333WDWoelbing Aviation LLC · Franksville, WIBuilt 1966 · S/N 310L-0002N333WSMuller Gabriel J · Leesburg, VABuilt 2004 · S/N 0906N333WVSilverstein Sam III · Charleston, WVBuilt 2012 · S/N 200N333XJpg Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-266N333YCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 29-0497N333YTRegistered aircraftBuilt 1968 · S/N 18258912N333ZVWalker Wilber D III · Beeville, TXBuilt 1977 · S/N 18265835N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739N334Jeffrey Mark · Clayton, MIBuilt 1967 · S/N D-8467N33401Innes Associates Insurance Services Inc · Safford, AZBuilt 1975 · S/N 34-7570115N3340RFrieze Rex · Fair Play, MOBuilt 1967 · S/N 18258640N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140N3340UGingerich Fred D · Heron, MTBuilt 1963 · S/N 18254740N3340XVito Bavaro Construction Inc · Escalon, CAS/N 310L-0190N3340YMckinney Sandra C · Williamsburg, OHBuilt 1962 · S/N 18254340N3341DTwenty One Miles LLC · Woodland Hills, CABuilt 1955 · S/N 32139N3341FLani Lea Sky Tours LLC · Honolulu, HIBuilt 1966 · S/N 18257341N3341RKozlenko Roman · Irvine, CABuilt 1967 · S/N 18258641N3341UKroschel Wayne Addie · Mora, MNBuilt 1963 · S/N 18254741N3341XJackson Rex A · Granbury, TXBuilt 1967 · S/N 310L-0191N3342FKaradza Bosko S · Welch, MNS/N 18257342N3342URobert Smith Associates Inc · Albany, NYBuilt 1963 · S/N 18254742N3343FLutes Ralph E · Shipshewana, INBuilt 1966 · S/N 18257343N3344MSmith Andrew L · Hillsboro, TXBuilt 1993 · S/N CE-1731N3344RStorm Water Services Inc · Redmond, ORBuilt 1967 · S/N 18258644N3344UPiescinski Kurt G · Fort Lauderdale, FLBuilt 1963 · S/N 18254744N3345BR Farms LLC · Wilmington, DEBuilt 1994 · S/N E-2865N3345FBrassard Alan Gaston · Durham, NCBuilt 1966 · S/N 18257345N3345MEz Aviation Holdings LLC · Orlando, FLBuilt 2018 · S/N 32-0003
Back to AD 2000-23-21