OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565N39SJArrigo Johnathan T · Mill Spring, NCBuilt 1999 · S/N 3269N39SKJustman Robert A · Cotati, CABuilt 2003 · S/N 25726N39TSMiller William L · Williamson, GABuilt 1982 · S/N 39N39WDWilliams Ryan P · Calera, OKBuilt 1984 · S/N 106DN3AAJones Stephen C · Wadsworth, ILS/N E3B-318N3ACMaurer Christian N · Loveland, OHS/N 1002N3AKSantana Barry W · Wasilla, AKBuilt 2011 · S/N TC0604104N3ARMatejczyk Daniel E · West Hills, CAFirst renewal noticeBuilt 1974 · S/N 10N3BNHansen Warren K · Bozeman, MTBuilt 1972 · S/N 430-73N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531N3DNNodorft Daniel F · Orlando, FLBuilt 1983 · S/N 28-8390043N3DTBighorn Flying Company LLC · Wood River, NEBuilt 1962 · S/N 18-7774N3FHScarborough Alex C · Lubbock, TXBuilt 2001 · S/N 451-2001N3GPAerospace Museum Of California · Mcclellan, CAFirst renewal noticeBuilt 1973 · S/N GP3N3JARegistered aircraftBuilt 1975 · S/N 17266528N3JKPagenkopf Joseph C · Juneau, AKBuilt 1976 · S/N 941-76N3KBJobe Dwaine B · Chilhowee, MOBuilt 1967 · S/N 28-3872N3KMStevens Burton G · Las Vegas, NVBuilt 1965 · S/N 2995N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747N3MWDantonio David · Wichita Falls, TXBuilt 1977 · S/N 414N3NEPatton Ronald V · Marion, TXBuilt 1988 · S/N 2AP305N3NLBaez Rafael · Stafford, VABuilt 1964 · S/N 28-1826N3PLCarlin Bernard T III · Norman, OKBuilt 1969 · S/N 52N3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442N3SKMiller Chad L · Shipshewana, INBuilt 1979 · S/N AA5B1219N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547N3VEAero 356 LLC · Phoenix, AZS/N 3073N3VRMckinnon David C · Cornelia, GABuilt 1980 · S/N EE2N3VTFleming Stephen · Los Lunas, NMBuilt 1995 · S/N 21017N3WPHagar Kevin J · Skiatook, OKBuilt 1961 · S/N 1820N3XMSmith Michael K · Grass Valley, CABuilt 1996 · S/N B93F96N3YHarding Mike R · Ventura, CABuilt 1961 · S/N 1N3YRStone Charles Douglas · Cedarville, OHBuilt 1975 · S/N 18-7509113N3YSAdams Harry J · New Waverly, TXS/N 916N3ZRRegistered aircraftBuilt 1973 · S/N 1048N40005Williams Brian · Rhinebeck, NYBuilt 1977 · S/N 28-7716312N40006Kotwal Pramod · Bedford, MABuilt 1977 · S/N 28-7716314N40008Birkland Mitchell L · Lake Jackson, TXBuilt 1977 · S/N 28-7716317N4000MDonair LLC · Enid, OKBuilt 1962 · S/N M-90N4000ZAmstrup Jeremy T · Fairbanks, AKBuilt 1963 · S/N 18-7951N40015Wings Flying Club Inc · Sheperdsville, KYBuilt 1977 · S/N 28-7716319N40016Miller Aircraft Services Inc · Crookston, MNBuilt 1977 · S/N 28-7716320N40017Biro Of Chicago Inc · Chicago, ILBuilt 1977 · S/N 28-7716321N40019Registered aircraftBuilt 1977 · S/N 28-7716322N4001LRobinson Helicopter Co · Torrance, CABuilt 1990 · S/N 1331
Back to AD 79-10-03 R2