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.

N4428DJst Management LLC · Zephyrhills, FLS/N 34727N4428UAtlanta Sky Signs LLC · Sharpsburg, GAS/N 15060428N4429ETwo Niner LLC · Portola Valley, CAS/N 21064709N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647N4429QDyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 17261708N4429RMacoupin Flyers Inc · Hettick, ILBuilt 1974 · S/N 17263174N442CROklahoma Aviation LLC · Bethany, OKBuilt 2015 · S/N 172S11519N442ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12029N442GRAk Air Leasing LLC · Homer, AKBuilt 1972 · S/N U20601811N442HBAirborne LLC · Wilmington, DEBuilt 1975 · S/N 17265246N442KSChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12514N442LHSkylane 182q LLC · Punta Gorda, FLBuilt 1980 · S/N 18267692N442PGLuedders & Reed Inc · Pawnee City, NEBuilt 1966 · S/N 17254799N442RAKing Air Properties LLC · Huntington Beach, CABuilt 1971 · S/N 18260739N442SSN442ss LLC · Middletown, OHBuilt 1965 · S/N P206-0121N44309Urstadt Chris M · Girdwood, AKBuilt 1978 · S/N 18503486N4430CAltitude Partners LLC · Louisburg, NCBuilt 1980 · S/N 18267705N4430LDunn Michael P · Queen Creek, AZS/N 17254519N4430RDunder Neil DBA · Cicero, INBuilt 1974 · S/N 17263175N4430ULfm Aviation LLC · Bozeman, MTBuilt 1964 · S/N 15060430N4431QGraham Huber L · Gulf Breeze, FLBuilt 1973 · S/N 17261710N4431RRaritan Valley Flying School · Princeton, NJBuilt 1974 · S/N 17263176N4431VPeters Frank S · Aspen, COBuilt 1977 · S/N 18265958N4432RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263177N4432UHull Ronald W · Temecula, CABuilt 1964 · S/N 15060432N4433BAircraft Partner N4433b Dst · BerlinBuilt 1955 · S/N 26777N4433QTwo Dog Enterprises Inc · Madison, WIBuilt 1973 · S/N 17261712N4433RWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18502953N4434KAzar Abdo Georges · Houston, TXS/N 18268241N4434QFaires Kelly C · Cedartown, GABuilt 1973 · S/N 17261713N4434RAll American Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 17263179N4435BHarstad Calvin B · Viking, MNS/N 26779N4436BHarris Derek A · Marion, TXBuilt 1955 · S/N 26780N4436LLehman Bradley R · Onsted, MIBuilt 1966 · S/N 17254527N4436QVan Hoomissen Thomas J · Anchorage, AKS/N 17261715N4436RDoran Kenneth J · Twisp, WABuilt 1974 · S/N 17263181N4437BCaudill Charles D · Fairbanks, AKBuilt 1955 · S/N 26781N4437LThomas John · Lees Summit, MOBuilt 1966 · S/N 17254528N4438LHarvey Jason Kyle · Glendale, AZS/N 17254529N4439QLipan Creek Flying Serice LLC · Eola, TXBuilt 1971 · S/N 18800839N443EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12644N443KAKirsch John P · Fort Defiance, AZS/N U20602496N443KSKent State University · Stow, OHBuilt 2020 · S/N 172S12473N4441KWeaver Aircraft Co · Carson City, NVBuilt 1966 · S/N 15065397N4441LKwon Andrew W · Tujunga, CABuilt 1966 · S/N 17254534N4441QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800841N4441RAtwood Flying Club · Atwood, KSBuilt 1974 · S/N 17263184N4441WHodge Henry D Jr · Anchorage, AKBuilt 1978 · S/N U20604389N4442FRegistration Pending · Sulphur, LARegistration pendingBuilt 1958 · S/N 46144N4442LSchoepflin Robert D · Palouse, WABuilt 1966 · S/N 17254535
Back to AD 79-10-14 R1