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.

N8083SKoenig William J · Benedict, MDS/N 15061683N80841Sparta 140 Club Inc · Grand Rapids, MIBuilt 1976 · S/N 17266769N80842Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266770N80847Evergreen Flying Club Inc · Medina, WABuilt 1976 · S/N 17266771N8084ARegistration Pending · Madison, NHRegistration pendingBuilt 1952 · S/N 20936N8084BN8084b LLC · Fort Worth, TXBuilt 1975 · S/N 177RG0705N8084FAustin Michael S · Utica, KYS/N 15064184N8084SHunter Robert M · Rawlins, WYS/N 15061684N8084TKnight Doyle D · Loon Lake, WABuilt 1960 · S/N 17556784N8084XSnyder Paul G · Lincoln, NEBuilt 1961 · S/N 17248584N80855Bowe Joseph E DBA · Chippewa Falls, WIBuilt 1976 · S/N 17266774N8085BHowell Rebecca Elizabeth · Elgin, TXBuilt 1957 · S/N 29885N8085EMcdonald Douglas A · Falls Church, VAS/N 17272137N8085LDowns Warren · Dillingham, AKBuilt 1967 · S/N 17256285N8085SSchulz Michael L · Norfolk, NEBuilt 1965 · S/N 15061685N80864Kessler Garry A · Lansing, WVBuilt 1976 · S/N 17266778N80865Green Rick A · Hudson, IABuilt 1976 · S/N 17266779N80866Preston Richard K Trustee · Albuquerque, NMBuilt 1976 · S/N 17266780N80868Paradis Paul A · Bar Harbor, MEBuilt 1976 · S/N 17266781N8086ANievin Garrett P · Ashburn, VABuilt 1952 · S/N 20938N8086TRains David O · El Paso, TXBuilt 1960 · S/N 17556786N8086VSchmitt Rudy · Brookshire, TXS/N 188-0336N8086XPaumen Kurt J · Ramsey, MNBuilt 1961 · S/N 17248586N80870Robben William J · Pampa, TXBuilt 1976 · S/N 17266782N80871Monnin Aviation LLC · Amherst, NYBuilt 1976 · S/N 17266783N80872Yakima 872 Flying Club · Yakima, WABuilt 1976 · S/N 17266784N80874Jls Aviation LLC · Fredericksburg, VABuilt 1976 · S/N 17266786N8087ARichards Vincent C · Deland, FLBuilt 1952 · S/N 20939N8087FWarbington Michael L · Enid, OKS/N 15064187N8087LBawden Scott L · Saint George, UTS/N 17256287N8087SBridges Jeffrey · Allen, TXBuilt 1965 · S/N 15061687N8087XMagers William L · Nampa, IDS/N 17248587N80884Rein W Clark · Ottawa, KSBuilt 1976 · S/N 17266788N8088LMarciano Raymond P · Cleveland, OHS/N 17256288N8088SRutherford Thom J · Birchwood, WIBuilt 1965 · S/N 15061688N8088XSky 66 Aero LLC · Talala, OKBuilt 1961 · S/N 17248588N80896Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17266793N80899Pedersen Herbert N · Willard, UTFirst renewal noticeS/N 15067399N8089ESkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 17272138N8089FFlying A Aviation LLC · Archer City, TXBuilt 1966 · S/N 15064189N8089GWellman Steven R Trustee · Englewood, FLBuilt 1971 · S/N 177RG0089N8089SBleier Rachel · Grayslake, ILBuilt 1965 · S/N 15061689N8089TGonzaez Richard · Granbury, TXBuilt 1960 · S/N 17556789N808BCMahanawai Lele LLC · Honolulu, HIBuilt 1970 · S/N 18260273N808BPChemtech-Engineering Inc · Racine, WIBuilt 2004 · S/N 18281455N808DWHall Danny J · Torrington, CTBuilt 2001 · S/N 18281044N808ESStaples Safari Ministries Outreach · Clayton, WAS/N 15064164N808FSBradley Supply Company LLC · Mesquite, NVS/N 21061586N808KSDucks Are Free LLC · Salina, KSBuilt 1967 · S/N 15067436N808PEBarbers Point Flight School LLC · Kapolei, HIBuilt 2020 · S/N 172S12538
Back to AD 79-10-14 R1