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.

N38MWWise Michael L · Lagrangeville, NYBuilt 2026 · S/N 11294N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N38PJVolar LLC · Lebanon, TNBuilt 2007 · S/N P38-1N38PKDeininger Robert · Apopka, FLS/N EA-467N38RCharliefoxtrot LLC · Farmington, MOBuilt 1973 · S/N TC-1541N38RRClark Martin B · Dayton, OHBuilt 1976 · S/N E-815N38RZGgt Aviation LLC · Saint Paul, MNBuilt 1977 · S/N 18265430N38SSKane Of The Upstate · Greenville, SCS/N E-544N38TLBonanza 1 LLC · Hernando, MSBuilt 1991 · S/N TH1642N38TXGlinn Andrew T · Keystone, NEBuilt 1977 · S/N 28R-7703297N38WBEighttwotwo LLC · Wilmington, DEBuilt 1980 · S/N E-1780N38WGOneal Eric T · Geneva, FLBuilt 1970 · S/N TE-811N38WPWjjb Aviation LLC · Fountain Hills, AZBuilt 2018 · S/N 4728N38ZZZulu Zulu Av8 Inc · Las Vegas, NVS/N 18262727N3900GCoyle Jerry Lee · Prairie Grove, ARBuilt 1967 · S/N U206-0900N3901DDanford Scott M · Chickamauga, GAS/N 34601N3901YCentruion Express LLC · North Port, FLS/N 21058401N3902ACountry Trail LLC · Asheville, NCBuilt 1970 · S/N TE-786N3903HMinniti Robert J III · Lansdowne, VAFirst renewal noticeS/N 25-0449N3903QWashington Chinook LLC · Bellingham, WABuilt 1973 · S/N 18502209N3904YOtto William R · Ontario, CABuilt 1964 · S/N 21058404N3905DKoehn Jerry L · Cimarron, KSBuilt 1957 · S/N 34605N3906YWildbur Mark B · Laramie, WYBuilt 1964 · S/N 21058406N3907GMid-America Sport Parachute Club · Taylorville, ILBuilt 1967 · S/N U206-0907N3907YAckley John · Brownsville, TXBuilt 1964 · S/N 21058407N3908DMoors Greg K · Athol, IDBuilt 1957 · S/N 34608N3908ER & S Grant Aero Co LLC · Fraser, MIBuilt 2006 · S/N 41600N3908XDeutsch Chad A · Evansdale, IAS/N 34-7570308N3909DDavidson Danny F · Anchorage, AKBuilt 1957 · S/N 34609N3909XSmith Aero Inc · Huntington Beach, CABuilt 1975 · S/N 34-7670001N390BMontoya Aviation LLC · Glenview, ILBuilt 1957 · S/N D-4974N390CPYes Air LLC · San Diego, CABuilt 2007 · S/N 1882N390CSMh Aero Services LLC · Norcross, GABuilt 2016 · S/N T24002108N390HWRojecki Stephen T Trustee · Navarre, FLBuilt 1967 · S/N D-8608N390LFAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1989 · S/N CE-1378N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N3910ARzepka Rick · Solon, OHBuilt 1970 · S/N D-9093N3912DPmn Enterprises LLC · Fremont, WIBuilt 1957 · S/N 34612N3912PRegistered aircraftBuilt 1978 · S/N P21000074N3914APlane Jane Aviation LLC · Sylvania, GABuilt 1970 · S/N TE-789N3914DKapowsin Air Sports Ltd · Shelton, WABuilt 1957 · S/N 34614N3916YMelagrano Jeffrey D · Scarsdale, NYBuilt 1964 · S/N 21058416N3917DBlue Sky Powers N3917d LLC · Dover, DEBuilt 1957 · S/N 34617N3917YSmf Multi Sports LLC · Lewes, DES/N 18253917N3918USutton Gary K · Rexburg, IDS/N 15061318N3918XHorton Gregory L · Moorpark, CAS/N 28R-7703001N3919DPallet Rack Surplus Inc · Conyers, GAS/N 34619N391BRWagers Wings LLC · Cleveland Heights, OHBuilt 2015 · S/N TH-2451N391CPMkns 319cp LLC · Kalispell, MTBuilt 2008 · S/N 3072
Back to AD 2000-23-21