OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,401

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.

N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152N1141MSunshine Flyers · Auburn, CAS/N 17260152N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1144LComposite Sign Products Inc · Zeeland, MIBuilt 1964 · S/N 306N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1144XFly Texas Sky LLC · Arlington, TXBuilt 1975 · S/N 28-7505215N1146VPlane Cents LLC · Henderson, NVBuilt 1996 · S/N 2641N1147LLandry Lonny Reid · Fort Worth, TXBuilt 1964 · S/N 309N114BCBoatman John H Jr · Smyrna, TNS/N 376N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080N114CMCunningham Terence R · Santa Barbara, CABuilt 1977 · S/N 18-7709146N114DCHaley Jack Michael Trustee · Keller, TXBuilt 1990 · S/N 057N114DJJohnson Danny A · Joplin, MOBuilt 1994 · S/N 455N114DKQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 0923N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720N114JCRossi Michael W · Boca Raton, FLBuilt 1984 · S/N 1092N114TVSafi Masoud · Mckinney, TXS/N 1333N114VGN22vg LLC · Milford, NJS/N 2351N114VVAugust Aero LLC · Kalispell, MTBuilt 1986 · S/N 114N114WPUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 17267603N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343N1150AMountain Air Spray Company · Craig, COBuilt 1951 · S/N 18-744N1150PGiermek Peter T · Olean, NYBuilt 1955 · S/N 23-163N1150SWoodraska Kenneth A · Oelwein, IABuilt 1997 · S/N 4103N1150XVenture North Aviation LLC · Cloquet, MNBuilt 1975 · S/N 28-7515394N1152MRst Aviation LLC · Vero Beach, FLBuilt 1970 · S/N 17259452N1153LSeelye Donald C · Charlevoix, MIBuilt 1965 · S/N 315N1155WState Of Alaska · Dillingham, AKS/N AC101N11564Ajw Management LLC · Scottsdale, AZBuilt 1975 · S/N 17702347N11566Monterrosa Frank J · Lincoln, CABuilt 1975 · S/N 17702348N1156EGooding Flying Club · Gooding, IDBuilt 1977 · S/N 986-77N1157XAscend Aviation LLC · Bountiful, UTBuilt 1975 · S/N 28-7525294N11585Registered aircraftS/N 17702349N1158LTimm Jack W · Wasilla, AKBuilt 1965 · S/N 320N1158PLorenzo Walker Institute Of Tech · Naples, FLBuilt 1955 · S/N 23-171N11596Tagart Charles · Senoia, GAS/N 17702352N1159XBarrett Tyler J · Cullman, ALS/N 28-7505217N1159YAultman Micah · Rocky Face, GABuilt 1962 · S/N 15059559N115AEPilipshen Paul D · Brightwaters, NYS/N 414HN115AGOliver Ross · Sunnyvale, CABuilt 1995 · S/N 82060/C1N115AKGrob Aircraft N115ak Llp · Steamboat Springs, COS/N 82054/C2N115BYPobiega Michael J · Fort Mill, SCBuilt 2004 · S/N 488-2004N115DDDed Aviation LLC · Saint Louis, MOS/N 3494N115JHanson John Eric · Livermore, CABuilt 1986 · S/N 607N115JAFarmer Stephen E · Tullahoma, TNBuilt 1967 · S/N 28-22953N115JEKillion Christopher Brett · Wausatosa, WIBuilt 1993 · S/N 10154
Back to AD 79-10-03 R2