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.

N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879N20954Hardin John M · Terrell, TXS/N 17263881N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030N2099CFrazier Jon A · Vista, CAS/N TD-276N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438N209CCCampbell Aviation Inc · Dutton, MTBuilt 1997 · S/N 20209N209DBCreedon William P · Escondido, CABuilt 1971 · S/N 139N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158N209ESSweeney Edward C · Parrish, FLBuilt 1971 · S/N 146N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302N209JRegistered aircraftBuilt 1982 · S/N 28-8216153N209JVPlahn Paul H · Minneapolis, MNBuilt 1971 · S/N 148N209PTSilver Express DBA · Miami, FLBuilt 1979 · S/N 44-7995239N209SFWhitaker Alvin E · Waterloo, WIBuilt 1971 · S/N 142N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475N20AKAuer Matthew J · Anchorage, AKBuilt 2005 · S/N 5771N20ALHarrington Mark · West Milford, NJBuilt 1991 · S/N 46N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836N20DUWings Of Hope · Chesterfield, MOBuilt 1985 · S/N 529N20EUWerking John William III · New Windsor, MDS/N 628N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20JCJcmc Inc · Junction City, KSBuilt 1955 · S/N 22-2879N20JDDesroches John · Scottsdale, AZBuilt 1962 · S/N 28-375N20JEReid Keith D · Vinemont, ALBuilt 1996 · S/N 20N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393N20JPJohnson Leif M · Midlothian, TXBuilt 1993 · S/N 783N20JZWest William D · Newton, NCBuilt 1986 · S/N 652N20KBAnderson David R · Sycamore, ILBuilt 1976 · S/N M-2-570N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669N20KNShaw William C · Carmel, NYS/N 682N20LEQuality Leasing Inc · Niceville, FLBuilt 1994 · S/N 1809080N20LKHobert Robert W Trustee · Penn Valley, CABuilt 2001 · S/N 21299
Back to AD 79-10-03 R2