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.

N8011ZJackson Jet Center · Boise, IDS/N U206-0411N80121Sky Gypsies LLC · Lansdale, PABuilt 1975 · S/N 17266384N80123Fremont Aviation Inc · Fremont, NEBuilt 1975 · S/N 17266385N80124Amundsen John D · Soldotna, AKS/N 18503094N80127J C Dalco Inc · Westminster, CABuilt 1975 · S/N 17266388N80128Gonzalez William I · Babylon, NYBuilt 1975 · S/N 17266389N80129Potter Raymond C · Torrey, UTBuilt 1975 · S/N 17266390N8012FHood William T · Columbia, SCBuilt 1966 · S/N 15064112N8012SCollins Scott · Upland, CABuilt 1965 · S/N 15061612N8012XSingh Joga · Auburn, WABuilt 1961 · S/N 17248512N80130Harrison W Henry · Philadelphia, PABuilt 1975 · S/N 17266391N80131Riverside Pilots Inc · Riverside, CABuilt 1975 · S/N 17266392N80135Adventure North Flying Service Inc · Aitkin, MNBuilt 1975 · S/N 17266395N80137Walla Walla University · College Place, WABuilt 1975 · S/N 17266397N80138Candace A Larned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 172RG0507N8013ATrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1952 · S/N 20865N8013LCarroll Connie S · Clyde, TXBuilt 1967 · S/N 17256213N8013SRedmond Angela L · Austin, TXBuilt 1965 · S/N 15061613N80149Cielos Serenos LLC · Tucson, AZBuilt 1975 · S/N 17266403N8014AMcdaniel Leigh W · Orland, CABuilt 1952 · S/N 20866N8014BHeinrich George F Jr · Hastings, MNBuilt 1957 · S/N 29814N8014EHutton Steve · Saint Helens, ORFirst renewal noticeBuilt 1978 · S/N 17272117N8014SMurray Bart · Pacifica, CAS/N 15061614N80154Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17266405N80158Anderson Paul M · Brandon, MNBuilt 1975 · S/N 17266407N80159Iowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17266408N8015FLewis L Dwight Jr · Lopez Island, WABuilt 1966 · S/N 15064115N8015ZKennedy Kerry D · Anchorage, AKBuilt 1965 · S/N U206-0415N80160D S Swain Gas Co Inc · Washington, NCBuilt 1975 · S/N 17266409N80164Bogacz Frank · Sarver, PABuilt 1974 · S/N 17266412N80165Hodgkins John L III · Lake George, NYBuilt 1975 · S/N 17266413N80168Stratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17266416N8016APak Holdings LLC · Anchorage, AKBuilt 1952 · S/N 20868N80173Air Athens LLC · Athens, GABuilt 1975 · S/N 17266420N8017ABue Brian G · Palmer, AKBuilt 1952 · S/N 20869N8017LOgle Randall W · Wenatchee, WABuilt 1967 · S/N 17256217N8017SHughes Todd R · Rocky Ford, COS/N 150-61617N8017VThrush Hills LLC · Volga, SDBuilt 1967 · S/N 188-0267N8017XCaudill Jimmy L · Grove, OKBuilt 1961 · S/N 17248517N80181Vero Technical Support Inc · Pensacola, FLBuilt 1975 · S/N 17266425N80182Ranson Allan W · Hot Springs, ARBuilt 1975 · S/N 17266426N80183Northland Aviation LLC · Manitowoc, WIBuilt 1976 · S/N 17266427N80184Ljmf LLC · Hays, KSBuilt 1975 · S/N 17266428N80185Aviation Training Inc · Cameron Park, CABuilt 1975 · S/N 17266429N80186J J Jenkinson Inc · Meade, KSBuilt 1975 · S/N 17266430N80187Amalong Timothy M · Tucson, AZBuilt 1975 · S/N 17266431N80189Smith Darvin L · Atlanta, GAS/N 17266433N8018AConley Ronald Dean Trustee · Lamoille, NVBuilt 1952 · S/N 20870N8018VLight Flight Ltd · Lehighton, PABuilt 1967 · S/N 188-0268N8019AOlson Kenneth L · Raymond, WABuilt 1952 · S/N 20871
Back to AD 79-10-14 R1