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.

N7700FClairy Scott M · Justin, TXBuilt 1966 · S/N 15063800N7700HBrensing Steve E · Stafford, KSBuilt 1972 · S/N 18261304N7700UJarvis Tree Service Inc · Heber Springs, ARBuilt 1964 · S/N 17251700N7700XRule Paul Crane Trustee · Wapato, WABuilt 1961 · S/N 17248200N7701FRegistered aircraftBuilt 1977 · S/N 18503245N7701UIyer Sundaresh R · Northborough, MABuilt 1964 · S/N 17251701N7702EWhite Don DBA · Mount Vernon, WABuilt 1959 · S/N 17502N7702KRose Hugh S · Fairbanks, AKBuilt 1976 · S/N 18052705N7702TNablo Dustin · Haddam Neck, CTS/N 47302N7702VBrown Warren C · Pasadena, CABuilt 1976 · S/N 177RG0905N7703FGonzales Donald M · Columbia Station, OHS/N 15063803N7703TRegistered aircraftBuilt 1972 · S/N 18502056N7704UAllen Philip · Portland, ORBuilt 1976 · S/N 15077826N7704XStark Linda L · Arroyo Grande, CABuilt 1960 · S/N 17248204N7705EGerber James R · Larchwood, IABuilt 1959 · S/N 17505N7705FEisel Joseph D · Dexter, ORBuilt 1966 · S/N 15063805N7705UCaldwell Evan-James Gray · Camano Island, WAS/N 17251705N7706XAircaft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1960 · S/N 17248206N7707AGay Chris · Anchorage, AKBuilt 1956 · S/N 32604N7707TAmerican Petro Inc · Ball Ground, GABuilt 1960 · S/N 47307N7707UMeese Brian D · Conroe, TXBuilt 1964 · S/N 17251707N7708AFrelin Josef J · Anchorage, AKS/N 32605N7708UDahle Jacob J · Morristown, MNBuilt 1964 · S/N 17251708N7709FChiang Yucheng · Glenview, ILBuilt 1966 · S/N 15063809N770CBTeton Avjet LLC · Driggs, IDBuilt 1976 · S/N R172-2175N770CDCunningham Campers & Rvs · Clarksville, INBuilt 1976 · S/N 33701774N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569N770HTailwind Aviation LLC · Huntingburg, INBuilt 1966 · S/N 18257818N770NAOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1975 · S/N 15077280N770SPHa Emily J · Fort Worth, TXBuilt 1970 · S/N 15071805N7710TMorton David W · Brady, TXBuilt 1960 · S/N 47310N7710XGraves Robert D · Elberton, GABuilt 1960 · S/N 17248210N7711AMckay Donald A · Soldotna, AKBuilt 1956 · S/N 32608N7711DCaldwell Joel A · Kenai, AKBuilt 1976 · S/N U206-03170N7711EHeaton Stewart · Spanish Fork, UTBuilt 1959 · S/N 17511N7711FMcclain Eugene L · Maryville, TNBuilt 1966 · S/N 15063811N7711LClick Justin T · Hobart, INBuilt 1969 · S/N 185-1521N7711TBaker Eddy · Waynesville, ILBuilt 1960 · S/N 47311N7711UHaneline Douglas A II · Statesville, NCFirst renewal noticeS/N 17251711N7712AMizer James D · Hailey, IDFirst renewal noticeBuilt 1956 · S/N 32609N7712UGolding James M · Diamond Springs, CABuilt 1964 · S/N 17251712N7713EFitzgerald Keith M · Coopersburg, PABuilt 1959 · S/N 17513N7713GDavenport Jimmy J · Hayesville, NCS/N 17259413N7713THatton Daniel R · Portland, ORS/N 47313N7713UDavisson Paul V · Jupiter, FLBuilt 1964 · S/N 17251713N7714ALawyers Real Estate Services LLC · Hondo, NMBuilt 1956 · S/N 32611N7714FRegistration Pending · Oxford, MIRegistration pendingS/N 15063814N7714GGlynco Manning Aviation Inc · Brunswick, GABuilt 1970 · S/N 17259414N7714UKimbrell Quentin · Cape Girardeau, MOS/N 17251714N7714XLenhardt Edward J · Green Lane, PABuilt 1961 · S/N 17248214
Back to AD 79-10-14 R1