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.

N4104T4a Legacy Enterprises LLC · Mcallen, TXBuilt 2001 · S/N E-3411N4105SAxis Aviation Group Inc · Sacramento, CABuilt 1975 · S/N TC-1845N4105YChock Steven Y H · Lopez Island, WABuilt 1962 · S/N 1850305N4106SCompnet Solutions Inc · Dallas, TXBuilt 1975 · S/N CE-559N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735N4107YJohnson Eric L Trustee · Valley, WABuilt 1962 · S/N 185-0307N4108GKimberk Frederick S · Cambridge, MABuilt 1971 · S/N TH-166N4108QStuckle Gary W · Davenport, WABuilt 1967 · S/N 310N-0008N4108SBto Aviation LLC · Eden Prairie, MNBuilt 1975 · S/N TH-605N4109BMccowan Joseph F · Sylvania, OHBuilt 1974 · S/N 75-30760N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352N410ADCon Air LLC · Okeana, OHBuilt 1975 · S/N 18263881N410AGRg Rentals LLC · Las Vegas, NVBuilt 2007 · S/N 31-0021N410ASBase Aviation LLC · Murfreesboro, TNBuilt 2024 · S/N 9822N410CEBurggraf Sean Hj · Grand Rapids, MNS/N 18052477N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52N410HAWalega Jane Ellen · Essex, MDBuilt 1982 · S/N E-2035N410HBJh Rfg6 LLC · Teton Village, WYBuilt 2020 · S/N 2123N410JCFbn Holding Corp · Larkspur, CABuilt 1986 · S/N 4608038N410JDN410jd LLC · Oneida, TNBuilt 2025 · S/N 11001N410KGGreylady Aviation LLC · Bellville, TXBuilt 2009 · S/N ES-014N410LJBednar David · Norwalk, IABuilt 1982 · S/N EA293N410MBHall Donny K · Cookeville, TNBuilt 2008 · S/N 29-0505N410MJSnuggs Jason M · Gainesville, TXBuilt 1969 · S/N 18259784N410MPGulf Horizon Ventures LLC · Tampa, FLBuilt 2021 · S/N 5005N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48N410PKEnergy And Environment LLC · Fayette, MES/N 18503358N410PPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3600N410RFFeldtman Robert W · Buckholts, TXBuilt 1974 · S/N 18263478N410RHHurst Randall · Corinth, TXBuilt 2007 · S/N L2K-276N410RRGarrison Concrete Systems LLC · Scottsdale, AZBuilt 2008 · S/N 31-0083N410RWButler National Inc · New Century, KSBuilt 1982 · S/N E-2031N410SMMartin Aviation LLC · Grandview, TXBuilt 2015 · S/N 1077N410SRBiondich Amy · Rubicon, WIBuilt 2006 · S/N 2138N410T410t LLC · Kennett Square, PABuilt 1988 · S/N CE-1239N410TWRice Dwight L · Borger, TXBuilt 2008 · S/N 411044N410VVDaniels Mark A · Raleigh, NCS/N 3394N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N4112Feltmann Dean A · North Charleston, SCBuilt 1966 · S/N TE-159N41130Chapa Jana K · Corpus Christi, TXS/N 18255794N4114QAerofeather Aviation Inc · Suffolk, VABuilt 1977 · S/N 28R-7703122N4114SHeffernan Duane C · Moravia, NYS/N CE-434N4115SDanielson Adam M · Chassell, MIS/N TH-644N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288N41184Airwings Inc Trustee · Wilmington, DEBuilt 1998 · S/N 3449059N4118SStevens Ronald D · Boise, IDFirst renewal noticeBuilt 1975 · S/N CE-563N411AArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1979 · S/N 18503748N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524
Back to AD 2000-23-21