AD 79-10-14 R1

Registered aircraft · 56,582

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.

N97508Sale Reported · Hurricane, WVSale reportedBuilt 1979 · S/N 18267116N9750GGee Richard L · Seattle, WABuilt 1972 · S/N 18052250N9750LLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1986 · S/N 17276608N9750QPurdy Adrian · Missouri City, TXBuilt 1975 · S/N 17265789N97513Registration Pending · Colona, ILRegistration pendingBuilt 1979 · S/N 18267117N9751APerla Guido F · Vashon, WABuilt 1950 · S/N 19212N9751BDoyle Kevin M · Kenai, AKBuilt 1957 · S/N 50049N9751GJanes John L Jr · Anchorage, AKBuilt 1972 · S/N 18052251N9751TAbles Marlan L · Carthage, ARBuilt 1960 · S/N 47551N97523Rwp LLC · Bloomington, INBuilt 1979 · S/N 18267119N97528Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276308N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012N9752XBirdman Aviation LLC · Indianapolis, INBuilt 1962 · S/N 21058052N9752ZRocky Pointe Logistics LLC · Hayden, IDBuilt 1982 · S/N U20606644N97533Associated Pilots Inc · Winchester, MABuilt 1979 · S/N 18267123N9753AFowler Flyers Inc · Fowler, COS/N 19214N9753TCowan Ronnie C · Glasgow, KYS/N 47553N9753VBellamy Mark A · Freeville, NYBuilt 1966 · S/N 188-0203N97540Popeye And Olives Adventures LLC · Helena, MTBuilt 1979 · S/N 18267127N97543Carter Michael E · Dallas, GAS/N 18267128N97549Brandt Jeremy · Torrance, CAS/N 17276206N9754FFirst Eclipse Ltd · Richmond, VABuilt 1997 · S/N 17280037N9754GWings Aircraft Leasing And Services LLC · Wasilla, AKBuilt 1972 · S/N 18052254N97553Gregor Anthony J · Bethesda, OHBuilt 1979 · S/N 18267129N9755BRs Specialties LLC · Anchorage, AKBuilt 1957 · S/N 50053N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227N9755HQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N 18267997N97563Fenell Jeffrey A · Stahlstown, PAS/N 18267133N9756VLarson Lynn R · Casselton, NDS/N 188-0206N97578Utecht Thomas A · Friant, CABuilt 1979 · S/N 18267135N97580Wardall Wesley David · Ione, CABuilt 1979 · S/N 18267137N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N9758HBlue Sky Aviation Association Inc · Readington, NJBuilt 1981 · S/N 18268000N9758XHernandez Luis Ignacio · Naples, FLBuilt 1962 · S/N 21058058N97596Aero-Sphere Inc · Longmont, COBuilt 1979 · S/N 18267143N9759ALove John W Jr · Los Lunas, NMBuilt 1950 · S/N 19220N9759BHernandez Raymond · Burleson, TXBuilt 1957 · S/N 50057N9759GMcneill Dudley · Happy, TXBuilt 1974 · S/N 18801592N9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLBuilt 1962 · S/N 21058059N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718N975CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281975N975PCBeck Steven · San Clemente, CABuilt 1975 · S/N 18263546N975SRBrown Tyrone · Fontana, CABuilt 1968 · S/N 18258964N975TAMitchell David G · Cadiz, OHBuilt 2002 · S/N 172S9257N975THAnson Air LLC · Sugar Land, TXBuilt 2023 · S/N 172S12975N97601Zapata Michael III · Cary, NCBuilt 1979 · S/N 18267145N9760AK & S Aviation Adventures LLC · Toms River, NJS/N 19221N9760XGubler Joseph A · Fairhaven, MABuilt 1962 · S/N 21058060N97611Bravo Aviation Co · San Antonio, TXBuilt 1979 · S/N 18267147N9761HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18268003
Back to AD 79-10-14 R1