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.

N2962AKapsner Mark W · Willow, AKBuilt 1953 · S/N 30162N2962DBlanchard Stephanie T · Seldovia, AKS/N 26905N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062N2962XRomine John M · Broken Arrow, OKBuilt 1967 · S/N 17700362N29631Registered aircraftBuilt 1973 · S/N 21059873N2963CMcmillian Tommy D · Wasilla, AKBuilt 1954 · S/N 30863N2963FConnell Gary A · Anchorage, AKS/N 18257063N2963SDougherty Paul · Bethel, PABuilt 1967 · S/N 15066863N2963XWayner Ronald P · Sutton, AKBuilt 1967 · S/N 17700363N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963N29643Campbell Robert A · Dayton, TXS/N 17701005N29645Borgman Dale A · Rescue, CABuilt 1968 · S/N 17701006N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064N2964SRichardson David M · Dwight, ILBuilt 1967 · S/N 15066864N2964VPlane Awesome LLC · Plymouth, MAS/N 15076335N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964N29651Geurs John Z · Ossian, INBuilt 1968 · S/N 17701009N2965CBauer Joachim · Rhome, TXFirst renewal noticeBuilt 1954 · S/N 30865N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065N2965UPatterson John R · Leeds, ALBuilt 1963 · S/N 17250565N2965XLynch Thomas L · Fort Collins, COBuilt 1967 · S/N 17700365N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119N29667Viles Timothy · Bartlett, TNBuilt 1968 · S/N 17701016N2966ACroffut David P · Anchorage, AKBuilt 1953 · S/N 30166N2966DTruman Michael · Warner Robins, GABuilt 1955 · S/N 26909N2966FNansen Peter D · Bellingham, WABuilt 1966 · S/N 18257066N2966KMichels LLC · Wasilla, AKBuilt 1980 · S/N 18053140N2966VBode Aviation Inc · Albuquerque, NMBuilt 1974 · S/N 15076336N29673Olson Andrew S · Copper Canyon, TXBuilt 1968 · S/N 17701018N29674Snflk Leasing LLC · Andrews, TXBuilt 1973 · S/N 21059875N2967EBme N2967e LLC · Clearwater, FLBuilt 1978 · S/N 17271391N2967SJordan Jason A · Portland, MEBuilt 1967 · S/N 15066867N2968AMcdowell Claude Michael · Anchorage, AKBuilt 1953 · S/N 30168N2968SVoyles Robert L · Seymour, TNBuilt 1967 · S/N 15066868N2968XJansen Edward M · Hummelstown, PABuilt 1967 · S/N 17700368N296BJQualitair LLC Trustee · MichelstadtBuilt 1965 · S/N 21058697N296BWAmerican Driveaway LLC · Cowden, ILBuilt 1977 · S/N R1722379N296CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281995N296MEJwl Aviation LLC · San Carlos, CABuilt 2000 · S/N 172S8554N296NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11096N296PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10211N296PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13324N2970CClegg Bruce R · Brentwood, CABuilt 1954 · S/N 30870N2970DOldfield Alan Scott · Mize, KYS/N 26913N2970ESparrowhawk Aviation · Manvel, TXBuilt 1978 · S/N 17271393N2970JFlorida State College At Jacksonville · Jacksonville, FLBuilt 1966 · S/N 15065770N2970SDouble Circle LLC · Bosque Farms, NMBuilt 1967 · S/N 15066870N2970XMonroe William R · Hawk Point, MOBuilt 1967 · S/N 17700370N2971CTailwinds Air Inc · Morganza, LABuilt 1954 · S/N 30871
Back to AD 79-10-14 R1