OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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:79-10-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:79-10-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.

N8898NTaylor Danny H · Defuniak Springs, FLBuilt 1969 · S/N 28-25762N8899ERgp Aviation LLC · Wilmington, DES/N 28-7690215N8899LSujet Dylan P · Hampton, NJBuilt 1974 · S/N AA5-0698N889DALeik Aviation LLC · Dousman, WIBuilt 2023 · S/N 80814N889SCCrawford Stevan L · Woodinville, WABuilt 2005 · S/N 2476N889TJvs LLC · Santa Rosa, CABuilt 1957 · S/N 18-5540N88ABBrown James L · Athens, ALBuilt 1973 · S/N 17262739N88AKState Of Alaska · Anchorage, AKBuilt 1965 · S/N 18-8311N88BELee George M · Queen City, TXBuilt 1988 · S/N 1317N88CFWoodford William Boyd · Superior, MTBuilt 2012 · S/N 21500N88CTCameron John W · Canby, ORS/N 882N88CVAllen David L · Sturgis, SDBuilt 1999 · S/N 80327N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618N88DRAkerson Charles J · Clarksville, TNBuilt 1965 · S/N 3170N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476N88FNSaline County Flyers Association LLC · Little Rock, ARBuilt 1969 · S/N 28-26119N88GEGothreaux William A · Deridder, LAS/N 1934N88GGSchneck Doreen Trustee · Albany, GABuilt 1970 · S/N 3N88GKSale Reported · Crestview, FLSale reportedBuilt 2003 · S/N 80271N88GVAllen Timothy J · Petersburgh, NYBuilt 1988 · S/N 413N88JCFarooq Tayab · Allen, TXS/N 675N88JLSummit Concepts Inc · Wilmington, DES/N 463N88LLLarrabee Consulting Group LLC · West Carrollton, OHBuilt 1977 · S/N 973-77N88LWRkj Enterprises · Bay City, TXS/N 334N88MDWaage Matthew L · Elkhart Lake, WIBuilt 1955 · S/N 18-4260N88MRMarkus Stanley L · Oconomowoc, WIS/N 814N88NSDaniel Timidaiski · Mukilteo, WABuilt 1975 · S/N AA5B-0196N88PYSegler Max D · Shoreview, MNBuilt 1960 · S/N 18-7425N88QBAckerman Mendel R · Saint Matthews, SCBuilt 1975 · S/N 1N88RDLafayette Flying Service LLC · Lafayette, LABuilt 1992 · S/N 2214N88RFGrant Joseph P · Priest River, IDBuilt 1975 · S/N 18-7609027N88SSWasson Trevor J · Whitewater, MTBuilt 1976 · S/N 205-76N88SWBoline Lonny R · Lincoln, MEBuilt 1970 · S/N MB-500N88SYYamashita Bruce · Honolulu, HIBuilt 1969 · S/N 17258613N88TFHarts Joel D · Coffeyville, KSBuilt 1969 · S/N 69N88VLMccullough Peter M · Evansville, INBuilt 1985 · S/N BL-1N88WCClobes Warren J · Evansville, WIBuilt 2009 · S/N 4518N88WSChamberlain Donald R · Simsbury, CTBuilt 1974 · S/N 1N8900DRay Robert L · Palmer, AKBuilt 1958 · S/N 22-6055N8901DLeberman Odin F · Santa Maria, CABuilt 1958 · S/N 22-6056N8901JQuinn Andrew · Fort Worth, TXBuilt 1965 · S/N 28-2878N8902DTurkington Ryan · Homer, AKBuilt 1958 · S/N 22-6057N8902JLeavitt Jason R · Barnstead, NHBuilt 1965 · S/N 28-2880N8902VFlycarolina LLC · Concord, NCS/N 17264259N8902YBraaten Allan C · Surprise, AZBuilt 1973 · S/N 18-7409032N8903DBesner Eugene F · Hemlock, MIS/N 22-6058N8904DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6059N8904JHenderson John · Kirksville, MOBuilt 1965 · S/N 28-2882N8904PMeline Marilyn Robinson · Stanton, MNBuilt 1966 · S/N 18-8406N8904VWaymaker Aviation LLC · Yukon, OKBuilt 1974 · S/N 17264261
Back to AD 79-10-03 R2