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.

N42520R & D Aero LLC · Midlothian, TXBuilt 1968 · S/N 18259054N42521Coutrney Joseph · Livingston, LAS/N 18259055N42525Titus Daniel A · Batavia, OHBuilt 1968 · S/N 18259056N42526Stanley Gerald L · Littleton, COBuilt 1973 · S/N 18052359N42536N B B S LLC · Kansas City, KSBuilt 1973 · S/N 18052360N42538Walled Lake Flying Club · Waterford, MIBuilt 1968 · S/N 18259064N42539Lincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1968 · S/N 18259065N42543Browne Hunter J · Woodacre, CABuilt 1968 · S/N 18259069N42546Hogue Patrick L · Paso Robles, CABuilt 1968 · S/N 18259070N42549Schutz Christopher J · Rock Springs, WYBuilt 1968 · S/N 18259072N42550Byerley Mark S · Greenback, TNBuilt 1968 · S/N 18259073N42554Cagle Kimberlee S · Houston, TXBuilt 1968 · S/N 18259075N42556Quality Contractors LLC · Deary, IDBuilt 1968 · S/N 18259076N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35N42560Mallory Mark P Trustee · Independence, ORBuilt 1968 · S/N 18259077N42564Williams Robert E · Clermont, GABuilt 1968 · S/N 18259079N42565Pops Space LLC · Luther, OKBuilt 1968 · S/N 18259080N42567C & T Aviation LLC · Seattle, WABuilt 1968 · S/N 18259081N42572Modi Yogini · Homestead, FLS/N 18259084N42576Larch Hill Laboratory LLC · Earlville, NYBuilt 1968 · S/N 18259087N42577Buttered Landings LLC · Hutchinson, KSS/N 18259088N42578Hodges James M Jr · Manchester, GABuilt 1968 · S/N 18259089N4257ST&S Proch Investments LLC · Harrisonville, MOBuilt 1976 · S/N E-939N42580Cox Bruce R · Brock, TXBuilt 1968 · S/N 18259091N42589Haas Kile B · Monette, ARBuilt 1973 · S/N 18052365N4258CSonrise Aviation LLC · Portland, INBuilt 1978 · S/N 310R1386N42591Mcferrin Clinton J · Kyle, TXBuilt 1968 · S/N 18259094N42594Wunsch Larry K · Fond Du Lac, WIBuilt 1968 · S/N 18259095N42599Avco Patrol LLC · Lyndon, KSBuilt 1968 · S/N 18259098N425BBGarcia Robert Lee · Horseshoe Bay, TXBuilt 1968 · S/N 30099N425BVBvi Air LLC · Grand Forks, NDBuilt 2014 · S/N 4158N425CDDtn Aviation LLC · Winona, MNBuilt 2004 · S/N 0892N425CGSchmiesing Brothers Aviation Ltd · Minster, OHBuilt 2007 · S/N 2814N425ESKatz Stanley · Riverhead, NYBuilt 2026 · S/N 11332N425JAWhiskey Tango Fox LLC · Portland, ORBuilt 2007 · S/N 2452N425KPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 28R7931243N425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNS/N 18268454N425MBPauls Valley Fly Boys LLC · Davis, OKBuilt 1976 · S/N 18264927N425MGGrinnan Michael · Stafford, VAS/N D-7813N425MHN425mh LLC · Geismar, LABuilt 2017 · S/N 4517N425MSMcdonald Shane · Belmont, MSBuilt 2005 · S/N 1256N425MTRkg Enterprises · Hibbing, MNBuilt 2015 · S/N 4201N425PQuimus Aviation LLC · Townsend, WIBuilt 1998 · S/N E-3175N425PRHorizon Technical Services Inc · Farmingdale, NYBuilt 1977 · S/N 18266202N425RBAkguc Cengiz · Lantana, TXBuilt 1962 · S/N 18254214N425SJCook Christopher J · Baxley, GABuilt 2003 · S/N 1342N425SWGratitude Unlimited LLC · Reno, NVBuilt 2016 · S/N 1463N425TButler Joshua · Gravette, ARBuilt 1961 · S/N CD-281N425TASkyhawks Inc · Westminster, COBuilt 1976 · S/N 18264951N425WMRegistered aircraftBuilt 2017 · S/N 1628
Back to AD 2000-23-21