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.

N58852Backcountry Wagons LLC · Kalispell, MTBuilt 1973 · S/N 18262343N58853Moulin Neil D · Harrah, OKBuilt 1973 · S/N 18262344N58859Corby David J · Richmond, MIBuilt 1973 · S/N 18262348N5885BGottlieb Kevin L · Anchorage, AKBuilt 1956 · S/N 33885N5885EZeller Bruce C · Shelton, WAS/N 17385N5885TSale Reported · Cleveland, GASale reportedS/N 185-0785N58860Rentz Jimmy L · Bainbridge, GABuilt 1973 · S/N 18262349N58865Fairhill Properties LLC · Valley City, NDBuilt 1973 · S/N 18262354N58866R And M Steel Company · Caldwell, IDBuilt 1973 · S/N 18262355N5886BSchramm Craig O · Fenton, MIBuilt 1956 · S/N 33886N5886RZimmer James D · Mason City, NEBuilt 1965 · S/N 17253555N58873Carman Steven W · Grass Valley, CABuilt 1973 · S/N 18262362N58877Executive Flight LLC · Greenwood, MSBuilt 1973 · S/N 18262366N5887BRedden Timothy Ray · Citrus Heights, CABuilt 1956 · S/N 33887N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887N58882Coburn Shawn · Dos Palos, CABuilt 1973 · S/N 18262371N58884Snider Aaron A · Ludington, MIBuilt 1973 · S/N 18262373N58885Livengood John M · Prescott, AZBuilt 1973 · S/N 18262374N58888Ducommun Robert C · New York, NYBuilt 1973 · S/N 18262377N5888ADahlberg James C · Ogilvie, MNS/N 28488N5888CCwf Enterprises Inc · Grove, OKS/N U20605888N5888RTepper Steve D · Stayton, ORBuilt 1965 · S/N 17253557N5889BLeitz Steven C · Cathlamet, WABuilt 1956 · S/N 33889N5889RPatkotak Crawford A · Barrow, AKS/N 17253558N588DCDynoair LLC · Watertown, SDBuilt 1998 · S/N 18280243N588ERTextron Aviation Inc · Wichita, KSS/N 172S13617N588LCProdonor LLC · Phoenix, AZBuilt 1965 · S/N 17253895N58909Plantation Farms Inc · Wall, TXFirst renewal noticeBuilt 1973 · S/N 18262390N5890AMartin Jason L · Fort Worth, TXBuilt 1956 · S/N 28490N5890BKilo Aviation LLC · East Peoria, ILBuilt 1956 · S/N 33890N5890GPommer Timothy J · Kittanning, PABuilt 1969 · S/N 15071390N5890RYell Christopher R · Williamsburg, KYBuilt 1965 · S/N 17253559N5891GWebb Christopher L · Burns, TNBuilt 1969 · S/N 15071391N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560N5891THutchison John N · Big Lake, AKBuilt 1964 · S/N 1850791N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394N58924Quicksilver Air Inc · Fairbanks, AKS/N 18262395N58926Hawkeye Aviation Inc · Yakima, WABuilt 1973 · S/N 18262397N5892THayden Daniel · North Pole, AKBuilt 1964 · S/N 185-0792N5893EWafer James R · Buellton, CABuilt 1959 · S/N 17393N58944Cassada Josh A · Charlevoix, MIBuilt 1973 · S/N 18262415N58949M & M Aircraft LLC · Cresson, TXBuilt 1973 · S/N 18262420N5894BFischer Alfred M DBA · Genoa City, WIS/N 33894N5894RMurray Kevin D · Moneta, VABuilt 1965 · S/N 17253563N58954Musheinesh Issa A · Bloomfield Hills, MIBuilt 1973 · S/N 18262424N5895ADuncan Russell A · Glen Burnie, MDBuilt 1956 · S/N 28495N5895RBernhard Sterling · Harper, TXBuilt 1965 · S/N 17253564N5895THeligray LLC · Kalispell, MTBuilt 1964 · S/N 185-0795N58960Regan Ed · Torrance, CABuilt 1973 · S/N 18262428N58961Monteith Andrew W · Lebanon, PABuilt 1973 · S/N 18262429
Back to AD 79-10-14 R1