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.

N307AG4th Down Aviation LLC · Provo, UTBuilt 2006 · S/N 41595N307CDBarton Michael · Creve Coeur, MOBuilt 2004 · S/N 1092N307CFSchwarzenberg Johannes · Helena, MTFirst renewal noticeBuilt 1973 · S/N 21059961N307CPCirrus R50 LLC · Shreveport, LABuilt 2008 · S/N 3228N307GRJ & D Flying LLC · Sand Point, AKBuilt 1979 · S/N 18503947N307HYWallace Richard Ronald · Santa Teresa, NMBuilt 2021 · S/N 2472N307JHRoundy Joseph · Three Forks, MTBuilt 1980 · S/N 207-00584N307JRSatellite Radio Management Inc · Hays, KSBuilt 2005 · S/N 41513N307JSPittard Kirk L · Grapevine, TXBuilt 1999 · S/N E-3268N307NRAeromac II LLC · Gillette, WYBuilt 2024 · S/N 10386N307PMRegistered aircraftBuilt 2004 · S/N L2K-199N307TKReim Rodney D · Enid, OKBuilt 2007 · S/N BD4K00-101N307TTCharter Place LLC · Jackson, WYBuilt 1980 · S/N EA-182N307ZEsterak David R · Boyce, LABuilt 1960 · S/N D-6458N3080BLamermayer Amy E · Fairfield, OHBuilt 1986 · S/N CE-1096N3080KSnuggs Ronald S · Driggs, IDBuilt 1987 · S/N E-2389N3080QN3080q LLC · Phoenix, AZBuilt 1967 · S/N 18258080N3080YHd Aviation LLC · Birch Tree, MOBuilt 1962 · S/N 18254080N30813T L Irrigation · Hastings, NEBuilt 1987 · S/N E-2393N30819Collins William T · Cameron, TXBuilt 1987 · S/N CE-1188N3081FHenion John D · Trumansburg, NYBuilt 1966 · S/N 18257181N3081TAviation Training Inc · Cameron Park, CABuilt 1994 · S/N CE-1781N3082GSmith Dennis W · Oshkosh, WIBuilt 1987 · S/N CE-1124N3082KTecair Inc · Ventura, CABuilt 1987 · S/N CE-1199N3082QAttaalla Maged A · Torrance, CAS/N 18258082N3082YSappington Steven R · Redondo Beach, CABuilt 1962 · S/N 18254082N3083CBear Boss LLC · Missoula, MTBuilt 1958 · S/N D-5754N3083FFree Richard D · Clearwater, KSBuilt 1966 · S/N 18257183N3083GHolly Grove Flying Service Inc · Holly Grove, ARBuilt 1988 · S/N CE-1237N3083HSalters Flying LLC · South Dartmouth, MABuilt 1988 · S/N E-2425N3083JPrivate Jet Solutions LLC · Prior Lake, MNBuilt 1988 · S/N CE-1242N3083LPrice Randy L · Pahrump, NVS/N 310J0083N3084CHeft Joel R · Mcgregor, TXBuilt 1958 · S/N D-5755N3084MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1988 · S/N EA-480N3084NLaprelle James L · Placitas, NMBuilt 1988 · S/N CE-1246N3084QHibbard Paul A · Mountain Home, IDBuilt 1977 · S/N 28R-7703089N3084YWasatch Industries LLC · Ogden, UTBuilt 1962 · S/N 18254084N3084ZMather Clay · Orange Beach, ALBuilt 1988 · S/N E-2426N3085CRoberts Marc A · Thomasville, PABuilt 1958 · S/N D-5761N3085FA To Z Endeavors LLC · Leawood, KSBuilt 1987 · S/N E-2396N3085KBennett Ross G · Eustis, FLBuilt 1987 · S/N E-2401N3085WFly Rudolf Corp · Wilmington, DEBuilt 1973 · S/N TE-954N3086CBlue Baron Fl LLC · Saint Cloud, FLS/N TE-510N3086FKellair Inc · Wilmington, DEBuilt 1966 · S/N 18257186N3086KRicotta Tom · Yuma, AZBuilt 1988 · S/N E-2406N3086WAltair Aircraft LLC · Gainesville, FLBuilt 1972 · S/N 18502042N3087FCascio John T · Deland, FLBuilt 1966 · S/N 18257187N3087QBellas Business LLC · Kalispell, MTBuilt 1967 · S/N 18258087N3088CMeester Daniel J · Longmont, COBuilt 1958 · S/N D-5773N3088DAquasol Corp · Rock Hill, SCBuilt 1987 · S/N E-2398
Back to AD 2000-23-21