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.

N9240JThorson Jason J · East Grand Forks, MNBuilt 1966 · S/N 28-3314N9240KHolland Wyatt Eugene · Garner, IAS/N 28-7690234N9241MBellinger John · Wexford, PABuilt 1966 · S/N 3447N9241SCosby Asa · Weldon, CAS/N M-1734N92424Christiansen Cortland · Bakersfield, CAS/N 17261573N9242DWeishaar Wallace · Livingston, TXBuilt 1958 · S/N 22-6302N9242HRoland Aviation LLC · Gualala, CABuilt 1975 · S/N 17266040N9242JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3316N9242VHurley Gregory · Capon Bridge, WVBuilt 1969 · S/N 690061N9242ZProfit Solving Group LLC · Bigfork, MTBuilt 1975 · S/N AA5B-0183N9243DPiper Aviation Museum Foundation · Lock Haven, PABuilt 1958 · S/N 22-6303N9243HSeward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 17266041N9243JRoney Edward A · Weirton, WVBuilt 1966 · S/N 28-3318N92445Pureflight Aviation Training LLC · Newberg, ORBuilt 1973 · S/N 17261575N92447American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261576N92448Eckholt John · Forest Grove, ORBuilt 1973 · S/N 17261577N9244DShrode Rafe C · Jewett, TXS/N 22-6304N9244HCoachron Investments LLC · Grosse Ile, MIBuilt 1975 · S/N 17266042N9244JRichardson David M · Dwight, ILS/N 28-3319N9244SKonefal Arthur Joseph · Fairbanks, AKBuilt 1975 · S/N M-1740N9244VGibbs Richard L · Palm Coast, FLBuilt 1969 · S/N 690062N9245SMowery Joseph · Orlando, FLBuilt 1975 · S/N M-1741N9246FFischer Alfred M · Genoa City, WIBuilt 1989 · S/N 2841254N9246JMckool John Jr · Johnstown, PABuilt 1966 · S/N 28-3321N9246KN9246k Corp LLC · Federal Way, WAFirst renewal noticeBuilt 1976 · S/N 28-7615189N92471Shoemaker Floyd · Oneida, TNS/N 17261579N9247DLaw C Scott · Oklahoma City, OKBuilt 1958 · S/N 22-6307N9247JGreco Timothy F · Sewell, NJBuilt 1966 · S/N 28-3322N9248KGerstner Michael J · Ola, ARBuilt 1976 · S/N 28-7690236N9249HGencur Paul A · Hudson, OHBuilt 1975 · S/N 17266044N9249VRobertson Scot H · Tribune, KSBuilt 1969 · S/N 690064N924CSBeinhauer Emerson R · Naperville, ILBuilt 1992 · S/N 1N924DBFlying Veterans Club Of San Francisco Inc · Belmont, CABuilt 1973 · S/N 28-7305198N924EIzzard William S · Crescent City, FLBuilt 1996 · S/N 002N924KAEvanoff Mark Alan · Saint Augustine, FLBuilt 1965 · S/N 28-21295N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509N924SHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2005 · S/N 3871N924TEPlyler Robert S · Spring, TXBuilt 2002 · S/N 10203N92500Romeo Charlie Aviation LLC · Stuart, FLBuilt 1994 · S/N 2890207N92505Thunderbird Aviation Inc · Bloomington, MNBuilt 1994 · S/N 2890211N9250CRegion Flyers LLC · Valparaiso, INBuilt 1978 · S/N 28-7816451N9250DJouflas Nikos A · Anchorage, AKBuilt 1958 · S/N 18-6541N92511Mckay Donald A · Soldotna, AKS/N 12-34N9251JGholami Amir K · Santa Rosa, CABuilt 1966 · S/N 28-3326N9251MFelix Eric · Oshkosh, WIBuilt 1966 · S/N 3451N9252HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17266047N9252JFlying Wrenches LLC · Cairo, NEBuilt 1966 · S/N 28-3327N9252MStarfox Aero LLC · Hays, KSBuilt 1966 · S/N 3452N9253DHand Keith A · Anchorage, AKBuilt 1958 · S/N 18-6546N9253SKnuth Charles Allen · Avon, INBuilt 1975 · S/N M-1750
Back to AD 79-10-03 R2