OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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.

N78890Edmondson Donald M · Harvest, ALBuilt 1964 · S/N 2905N78891Registered aircraftBuilt 1964 · S/N 2906N78892Rathbun Robert E · Maywood, MOS/N 2907N78893King Eugene A · Rch Palos Vrd, CABuilt 1964 · S/N 2908N78894Gonzalez Francisco C · Biloxi, MSBuilt 1965 · S/N 2909N78897Knox Phillip A · Snellville, GABuilt 1964 · S/N 2912N78898Clawson Michael · Allentown, NJS/N 2913N7889GFricker Mark W · Avon, INFirst renewal noticeBuilt 1970 · S/N 17259589N7889PWalker Zachary R · Burlington, NDBuilt 1963 · S/N 2403N7889VPoorman Christopher · Burleson, TXBuilt 1964 · S/N 2851N7889WBetts Paula H · Valparaiso, INBuilt 1964 · S/N 28-1913N788BGSeminole Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 4496143N788BWNelson Thomas H Jr · Chatham, MSBuilt 1997 · S/N 1230-97N788MCRoberts James A · Edina, MNBuilt 1978 · S/N 17270430N788RKSalomonsson Mats E · Hayward, CAS/N 28-24831N788SHSouthwest Technology Center School Dist No. 27 · Altus, OKBuilt 2004 · S/N 3631N788TDBurdick Kelly E · Wasilla, AKBuilt 1972 · S/N 18-9001N788ZStaton Robbie L · Lonoke, ARS/N 670N78901Emslie Ronald H · Sacramento, CABuilt 1961 · S/N 1915N78903Brar Kulbir Singh · Fresno, CABuilt 1961 · S/N 1917N78907Pritchard John A · Perry, KSS/N 1921N78909Takemura Chris · Mountain View, CABuilt 1961 · S/N 1923N7890GAltus Aircraft LLC · Taylor, TXBuilt 1970 · S/N 17259590N7890VDoherty Kevin R · Silver Spring, MDBuilt 1964 · S/N 2852N78911Watt Charles D · Marietta, OHBuilt 1961 · S/N 1940N78912Mid America Plumbing LLC · Moscow, TNBuilt 1961 · S/N 1941N78913Ambrose Gary L · Camden, NCBuilt 1961 · S/N 1942N78914Collins Camden B · Millersport, OHS/N 1943N78915Hendryx Alec B · Coffeyville, KSBuilt 1961 · S/N 1944N78918Pearlman Fredric M · Southfield, MIBuilt 1962 · S/N 1952N7891GSam Aviation LLC · Long Beach, CABuilt 1970 · S/N 17259591N7891WN7891w LLC · North Las Vegas, NVBuilt 1964 · S/N 28-1916N78920Duncan Mark T · Orange Grove, TXBuilt 1961 · S/N 1954N78923Rodriguez Julian P · New York, NYBuilt 1961 · S/N 1957N78925Sale Reported · Winthrop, MESale reportedBuilt 1962 · S/N 2037N78927Sly David P · Nevada, IAS/N 1961N78928Lejcar Matthew J · Cumberland Furnace, TNBuilt 1961 · S/N 1962N78929Boccaccio Peter A · Burke, SDS/N 1963N7892VLambert Mathew Chase · Chapel Hill, TNBuilt 1964 · S/N 2854N7892WRegistered aircraftBuilt 1964 · S/N 28-1917N78930Klingenberg Richard A · Idaho Falls, IDBuilt 1961 · S/N 1964N78934Harville Leonard W · Giddings, TXBuilt 1961 · S/N 1968N78937Reisen LLC · Stevensville, MTBuilt 1961 · S/N 1971N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794N7893DMoes John E · Manchester, IABuilt 1957 · S/N 22-5516N7893GRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1970 · S/N 17259593N7893VDarnell Noah Alexander · Searcy, ARBuilt 1964 · S/N 2855N78940Gaskins Gregory G · Godley, TXS/N 1974N78943Tutino John · Pleasant Valley, NYBuilt 1961 · S/N 1977N78945Ag-Aero Services LLC · Spring Hill, FLBuilt 1962 · S/N 1979
Back to AD 80-04-03 R2