OpenAirDocs.org
AD 2000-23-21

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

N3607DCusick Christopher J · La Jolla, CABuilt 1956 · S/N 35307N3607UHastings Flyers LLC · Hastings, NES/N 18255007N3607YHlavnicka Timothy D · Haines, AKS/N 21058107N3608URegistration Pending · Homer, AKRegistration pendingBuilt 1963 · S/N 18255008N36097Conner Don R · Hot Springs, SDFirst renewal noticeS/N 28R-7803310N360AStrong LLC · Norcross, GABuilt 1981 · S/N E-1904N360ACAlpha Charlie LLC · Post Falls, IDBuilt 1975 · S/N 18263631N360BGregs Inc · Tiburon, CABuilt 1957 · S/N D-4910N360CWassup Homes LLC · Wilmington, DEBuilt 2007 · S/N 2562N360CD360cd LLC · Eagle, IDBuilt 2009 · S/N 3516N360DAPacific Aviation Holdings Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11121N360DCGolike Timothy R · Anchorage, AKS/N 185-02173N360DE360 Skyhigh LLC · Cedar Rapids, IABuilt 2006 · S/N 381-320-136N360EZTurner Jeffrey K · Modesto, CABuilt 1995 · S/N SJ2146N360FVRegistered aircraftBuilt 2014 · S/N E-4035N360GBergmann Keith A · Lake Elmo, MNBuilt 1961 · S/N CD-306N360GCHuelskamp Thomas · Fowler, KSBuilt 2012 · S/N 289-320-51N360JBSouthpark Partnership Ltd · Cullman, ALBuilt 1975 · S/N 18264476N360KBRavinski Mark J · Assonet, MABuilt 1989 · S/N 378N360KKKoch Aviation LLC · Easton, PABuilt 2024 · S/N 10379N360LVJb Acquisitions LLC · Gonzales, LABuilt 2008 · S/N 3272N360MBPermian Aviation Partners LLC · Graham, TXBuilt 2024 · S/N 10360N360MWMission Wings International Inc · Salem, OHS/N P206-0572N360NEGoldrivet · Stateline, NVBuilt 1980 · S/N EA-128N360PMBon Aire Inc · Middlesboro, KYBuilt 1978 · S/N E-1253N360RJOliver Paul D · Bozeman, MTBuilt 1964 · S/N 206-0225N360TThroop Greg J · Spokane, WABuilt 1967 · S/N D-8427N360TPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11615N360UAdrenalyne Consulting LLC · Scottsdale, AZBuilt 1997 · S/N TH-1834N360VRMouki Aviation LLC · South Lake Tahoe, CABuilt 2018 · S/N 1744N360WLLaughlin Linda · Bluff Dale, TXBuilt 2002 · S/N 0216N360WTThompson William E · Columbus, OHBuilt 2001 · S/N 964-320-804-SFBN36106Leaseair LLC · Wilmington, DEBuilt 1978 · S/N 34-7870293N3611ASgmbb LLC · Seneca, SCBuilt 1979 · S/N E-1472N3611CNicoll Steve · Bozeman, MTBuilt 1957 · S/N 31109N3612CLipka Will · Center Point, TXBuilt 1954 · S/N 31110N3613CSchneiderhan Edward F · Laurium, MIS/N 31111N3613UN3613u LLC · Lakeland, FLBuilt 1963 · S/N 18255013N3614UT Yowonske Enterprises LLC · Rostraver Township, PAS/N 18255014N3614YEmission -Air Inc · Lexington, NCBuilt 1962 · S/N 21058114N3615CMarkwardt Jacquelyn K · Santa Cruz, CABuilt 1954 · S/N 31113N3616DRobinson Mark V · Vacaville, CAFirst renewal noticeBuilt 1956 · S/N 35316N3616UHatch Koay A · Gilbert, AZBuilt 1963 · S/N 18255016N3616YAnderson Dana R · Redding, CABuilt 1962 · S/N 21058116N3617YSchindele Micheal D · Tolna, NDBuilt 1962 · S/N 21058117N3618GIndustrial Consulting LLC · Repton, ALBuilt 1956 · S/N 35313N3619CHamby Michael R · Parma, IDBuilt 1954 · S/N 31117N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565TN3619YWilliams Jimmy Z · Sherman, TXBuilt 1962 · S/N 21058119N361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308
Back to AD 2000-23-21