OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N5820QSmith Douglas C · Lewisville, TXBuilt 1965 · S/N 3119N5820UScarpelli Leonard · Lakewood, ILBuilt 1970 · S/N 28-26650N5820WRed Baron Aviation LLC · Pine Bush, NYBuilt 1964 · S/N 28-2000N5820ZWilson Jonathon D · Breckenridge, MIBuilt 1963 · S/N 22-9677N5821WEnander Johannes T · Grenora, NDS/N 28-2033N5822DFranz Stanley E · Yakima, WABuilt 1956 · S/N 22-4497N5822QKnudsen Ernst W · Ennis, TXBuilt 1965 · S/N 3120N5822UCurliss James P · Quincy, MABuilt 1970 · S/N 28-26653N5823UNewton Donald S · Elk Grove, CABuilt 1970 · S/N 28-26654N5823WHill Travis R · Aledo, TXBuilt 1964 · S/N 28-2070N5824DWitthuhn Johnie B · Callaway, NEBuilt 1956 · S/N 22-4499N5824QTss-Glass Machinery Sales Inc · Fort Worth, TXS/N 3121N5824ULindaman Craig C · San Luis Obispo, CABuilt 1970 · S/N 28-26655N5824WBowman William K · Morrison, TNBuilt 1965 · S/N 28-2107N58250Gulick Stephen P · Burlington, VTBuilt 1985 · S/N 50N5825LMahurin Devin · Mountain Grove, MOBuilt 1972 · S/N AA5-0025N5825TTeshima Mark William · Clovis, NMS/N 28-1595N5825UGantz Clayton B · Forestville, CABuilt 1970 · S/N 28-26656N5825WIndian Trucking Company Inc · Destin, FLBuilt 1965 · S/N 28-2113N5826LGibson Bobby S · Clearwater, FLBuilt 1972 · S/N AA5-0026N5826QN5826q LLC · Sheridan, WYBuilt 1965 · S/N 3122N5826UHill Christopher L · Milner, GABuilt 1969 · S/N 28-26657N5827DNurge Richard · Gilroy, CAS/N 22-4502N5828DSchulz Lucas H · New Boston, MIBuilt 1956 · S/N 22-4503N58294Nance James Aaron · Woodbridge, VABuilt 1979 · S/N 18-7909055N5829UFarrell Mark O · Pittsburgh, PABuilt 1969 · S/N 28-26660N582MHuffman Prairie LLC · Claymont, DEBuilt 1991 · S/N 1608N5830CKueber Jake T · Anchorage, AKBuilt 1962 · S/N 18-7778N5830WWard Orval G · Bentonville, ARBuilt 1965 · S/N 28-2148N5830YMost Gordon G · Thedford, NEFirst renewal noticeS/N 18-8411N5831LCooks Aviation LLC · Conover, NCBuilt 1972 · S/N AA5-0231N5831WSonafrank Eric J · Somerset, INBuilt 1965 · S/N 28-2149N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5832LPlesea Lucian · Redlands, CABuilt 1972 · S/N AA5-0232N5832PBrooks William L · Vienna, VABuilt 1959 · S/N 24-913N5832QHli Aviation LLC · Red Banks, MSBuilt 1965 · S/N 3125N5832UBecker Randall T · Santa Rosa, CABuilt 1970 · S/N 28-26663N5833DBixler Scott E · Rising Fawn, GABuilt 1956 · S/N 22-4509N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5833WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-2159N5834LFount Valley Flying Club LLC · Kidron, OHS/N AA5-0034N5834QGill Harold P · Bolton, MABuilt 1965 · S/N 3126N5834UNewburn William A Jr · Fresno, CABuilt 1969 · S/N 28-26665N5834WDowdy Joseph N · Blacksburg, VABuilt 1965 · S/N 28-2186N5837LDudock John M Jr · Birch Run, MIBuilt 1972 · S/N AA5-0037N5837UDeblass Christopher C · Cranford, NJBuilt 1969 · S/N 28-26668N5838LCox Andrew C · Scappoose, ORBuilt 1972 · S/N AA5-0038N5838WJohn Andrew P · Auburn, MES/N 28-2207N5839LHoyer Chase R · Jarrell, TXBuilt 1972 · S/N AA5-0039N5839PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-920
Back to AD 79-10-03 R2