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.

N4759XBaginsky D D · Salesville, OHBuilt 1966 · S/N 15064809N475EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12248N475LN475l LLC · Boise, IDS/N 18259396N4760CJaars Inc · Waxhaw, NCS/N U20605805N4760EYoung John L · Glorieta, NMBuilt 1982 · S/N 18268269N4761CForbis Aviation LLC · Calera, OKBuilt 1979 · S/N 21063617N4761DNordstrom Anne D Trustee · Walpole, NHBuilt 1958 · S/N 34861N4761EDorsheimer Ryan J · Camp Hill, PABuilt 1982 · S/N 18268270N4761QMichaelson Lawrence · Big Lake, AKBuilt 1967 · S/N 185-1226N4762BAllen Kenneth W · Anchorage, AKBuilt 1955 · S/N 31660N4762EFly185 LLC · Estes Park, COBuilt 1979 · S/N 18503868N4762XSpatiumtech LLC · Madison, ALBuilt 1966 · S/N 15064812N4763DRandolph Terrence · Bowie, MDBuilt 1979 · S/N 17272354N4763NBathum Dale · Ketchum, IDS/N 18267346N4763UCopper River Airmotive LLC · Copper Center, AKBuilt 1964 · S/N 18051463N4764BPratt Sean · Hampton, NHBuilt 1977 · S/N 18503371N4764DQuadrelec Engineering Corp · Tulsa, OKBuilt 1979 · S/N 17272355N4764NWhite Robert H · Eagar, AZBuilt 1979 · S/N 18267347N4764QShapiro David · Homer, AKBuilt 1967 · S/N 185-1230N4764URegistered aircraftBuilt 1965 · S/N 18051464N47657Dallam Pat M · Cool, CABuilt 1979 · S/N 17271962N4765QDigger Dougs Crop Dusting Services Inc · Salem, WIBuilt 1976 · S/N 18802513TN4766DHutchison Frank J · Tucson, AZBuilt 1958 · S/N 34866N4766EWillard Raymond C · Wasilla, AKBuilt 1979 · S/N 18503872N4766UMoore Murray H · Twain Harte, CABuilt 1964 · S/N 18051466N4767DFulton Daniel M · Blacksburg, SCBuilt 1958 · S/N 34867N4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORBuilt 1979 · S/N 18267350N4767UDeckload Aviation LLC · Kodiak, AKBuilt 1979 · S/N U20605091N4768BEversole Eric L · Kent, WABuilt 1955 · S/N 31666N4768DBoyd Amy L · Kila, MTBuilt 1958 · S/N 34868N4768EEagle Aviation Inc · Tucson, AZBuilt 1978 · S/N 17271633N4768FZankiz Jose Carlos · Naples, FLS/N P206-0368N4768NTreadwell Dennis A · El Cajon, CABuilt 1979 · S/N 18267351N4769BNesbett David A Trustee · Anchorage, AKBuilt 1955 · S/N 31667N4769NTurner Luke · Mineral Wells, TXBuilt 1979 · S/N 18267352N4769XAnderson Aviation LLC · Erie, PABuilt 1966 · S/N 15064819N476CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283298N476CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2015 · S/N 172S11621N476DTTallarita Domenic A · Palm Springs, CAS/N 17254299N476DWSkylane Capital Group LLC · Seattle, WABuilt 1980 · S/N 18267793N476EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12249N476KETrexel Paul C · Willits, CABuilt 1975 · S/N 18264067N476LSHoffman Anthony J Trustee · Hillsboro, ORBuilt 1976 · S/N U20603283N476MSBrooks Duane T Trustee · Mount Shasta, CAS/N 15077515N476SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280621N4770DNapier Michael D · Russell, KYBuilt 1958 · S/N 34870N4771ULoomis Rick A · Prescott, AZS/N 18051471N4772EDrost Larry L · Charlevoix, MIBuilt 1978 · S/N 17271637N4772QHodgson John P · Atlanta, GABuilt 1967 · S/N 185-1239N4772RKimball Michael G · Placerville, COBuilt 1979 · S/N 172RG0027
Back to AD 79-10-14 R1