OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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-14-R1')
    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-14-R1')
  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.

N422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LABuilt 1979 · S/N U20605347N422RTCarter Ted J · Bigfork, MTS/N 18052795N422SHSig Aero LLC · Lewes, DEBuilt 2019 · S/N 18283090N422SPCrosby Scott · Mauldin, SCBuilt 1978 · S/N 18266299N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164N42300James Douglas M Trustee · Scottsdale, AZBuilt 1968 · S/N 18258952N42304Ratcliff John · Rincon, GABuilt 1968 · S/N 18258954N42305Registered aircraftBuilt 1973 · S/N 18052339N42306Wright Nolene L Trustee · Wright, WYBuilt 1968 · S/N 18258956N4230FBiffle Sam E · Midland, TXBuilt 1958 · S/N 46130N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130N42311Murphy Kenneth E · Pahrump, NVBuilt 1968 · S/N 18258959N42313Altitude Enterprises LLC · Omaha, NEBuilt 1968 · S/N 18258961N42314Mackenzie Jeffrey S · Woodland, MIBuilt 1968 · S/N 18258962N42317Meyers Brad C · Reno, TXBuilt 1968 · S/N 18258963N4231FYancey Emron A · Sterling, AKS/N 46131N4231LSeaplanes R Fun Inc · Moneta, VABuilt 1966 · S/N 17254300N4231TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12370N42323Gardiner Russell J · Phoenix, AZS/N 18258965N42325Henry Nolan T · Ashland, ORS/N 18258967N42326Hooper James Carl · Webster, MNBuilt 1968 · S/N 18258968N42328High Tony W · Walters, OKBuilt 1968 · S/N 18258969N4232QRamstad Trygg J · Anchorage, AKS/N 18502227N4232USterling John A · Port Lavaca, TXS/N 150-60232N4232VBishop John · Annapolis, MDBuilt 1948 · S/N 18588N42335Gubernat John F Jr · Pepperell, MABuilt 1968 · S/N 18258971N4233FSilverman James R · Superior, MTS/N 46133N4233LTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 17254302N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133N42349Skylane 49 LLC · Glenwood Springs, COBuilt 1968 · S/N 18258976N4234NHain Bruce P · Kennesaw, GAS/N 26263N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134N4234UWasson Tina A · Lakeport, CABuilt 1964 · S/N 15060234N42359Lincoln Roger Trustee · Gildford, MTBuilt 1973 · S/N 18052343N4235FCastle Nial K III · Bonner Springs, KSBuilt 1958 · S/N 46135N4235LReiter Trevor D · Minot, NDBuilt 1966 · S/N 17254304N4235UCottrell Mark C · Leitchfield, KYBuilt 1963 · S/N 15060235N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171N42364Smathers Geoffrey R · Mars, PABuilt 1968 · S/N 18258986N42368Madson Chris J · King City, CABuilt 1968 · S/N 18258988N42369Hecker Darin · Grants Pass, ORBuilt 1968 · S/N 18258989N4236LPierce Russell A · San Antonio, TXBuilt 1966 · S/N 17254305N4236QTyrrell Jerry R · Woodland, WABuilt 1973 · S/N 18502228N4236VSpitler John E · Laramie, WYBuilt 1948 · S/N 18592N42371Optum Sun LLC · Laguna Hills, CAS/N 18258990N42376Johnson Lytle D · Anacortes, WABuilt 1973 · S/N 18052348N42379Wh Land Holdings LLC · Kirbyville, TXBuilt 1968 · S/N 18258996N4237FScherr Steven J · Mandan, NDBuilt 1958 · S/N 46137N4237UMark & Debbe Inc DBA · Kalispell, MTS/N 15060237N42380Payne Patricia C · Spokane, WABuilt 1968 · S/N 18258997
Back to AD 79-10-14 R1