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.

N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034N9618GH&M Ltd · Warren, IDS/N 18263409N9618HRegistration Pending · Wasilla, AKRegistration pendingBuilt 1977 · S/N 18503454N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039N9619ADanziger George E · Florence, MABuilt 1949 · S/N 15340N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924N9619EHofer Terril D · Maple Grove, MNBuilt 1984 · S/N 18268430N961AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12154N961ERCoyote Air LLC · Hermiston, ORBuilt 1979 · S/N 18266923N961LCSanpete Aviation LLC · Nephi, UTS/N 17250480N961LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12031N961UTRepllp LLC · Marietta, GABuilt 1977 · S/N R1722337N961WSWalt Schwartz Aviation LLC · Louisville, KYBuilt 1985 · S/N 18268462N9620EJones Benjamin J · Little Rock, ARBuilt 1984 · S/N 18268431N9620GMehling Robert C · Hardin, MTS/N 18801564N9620QObar Danny · Middleton, IDBuilt 1979 · S/N 18503780N96218Link Jessica Elizabeth · Castalia, OHBuilt 1967 · S/N R172-0214N9621BLee Gerald R · Glennallen, AKBuilt 1957 · S/N 32918N9621TJ D Kraemer Enterprises LLC · Fargo, NDS/N 57421N9621VHathor Aviation LLC · Johnstown, COBuilt 1974 · S/N 17264401N96227Civil Air Patrol Inc · Montgomery, ALBuilt 1983 · S/N 17276045N9622BSmith Glenn R · Palmer, AKBuilt 1957 · S/N 32919N9622HSanders Flight Training Center LLC · Jasper, ALBuilt 1975 · S/N 17266272N9622QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265707N9623ASun 'N Fun Fly-In Inc · Lakeland, FLFirst renewal noticeBuilt 1949 · S/N 15344N9623GBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802596TN9623RUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606906N9623VSchreder Peter T · Joseph, ORS/N 17264403N9624ASnead John S DBA · Crescent City, FLBuilt 1950 · S/N 15345N9624EA & I Aviator Investments LLC · La Habra, CABuilt 1984 · S/N 18268432N9625QMars Aerospace Inc · Bay Shore, NYBuilt 1975 · S/N 17265709N9625VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 17264405N9626AWebie Matthew W · Madison, ALBuilt 1949 · S/N 15347N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927N9626GFly 2 Crp LLC · Cleveland, TXBuilt 1972 · S/N U20601826N9626HRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 17266274N9626QChambers Matthew A · Tehachapi, CABuilt 1975 · S/N 17265710N9626XPortman Joe · Elmendorf, TXBuilt 1962 · S/N 21057926N9627HSuperbuyer Inc · San Jose, CABuilt 1975 · S/N 17266275N9627XW J Bolton Farms LLC · Marked Tree, ARBuilt 1962 · S/N 21057927N9628BBryan Kirk J · Big Timber, MTBuilt 1957 · S/N 32925N9628GNicols Bruce D · Titusville, PABuilt 1974 · S/N 18263410N9628HT3 Aerosports LLC · Vian, OKBuilt 1975 · S/N 17266276N96299Djm Aviation LLC · Rhome, TXS/N 17276054N9629AWinover Orville J Jr · Tyler, TXBuilt 1950 · S/N 15350N9629BVisser Ag Inc · Rigby, IDBuilt 1957 · S/N 32926N9629GSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 18801570N9629TBramlett Russell · Winder, GABuilt 1960 · S/N 57429N962AFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 177RG0464N962AMInternational Air Services Inc · Carson City, NVBuilt 1976 · S/N 177RG1054
Back to AD 79-10-14 R1