OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2197QCarnahan Benjamin J · Grass Valley, CAS/N 177RG0597N2197YWeber Raymond E · Palmer, AKBuilt 1962 · S/N 17249697N21980Harris Kenneth L · Greeley, COBuilt 1973 · S/N 15074586N21981Mahoney Thomas H · Dorrance, KSS/N 15074587N21986Corr Harvey R · Nipomo, CABuilt 1973 · S/N 15074591N2198GAirstar Aviation Inc · Chester, SCBuilt 1958 · S/N 51498N2198ROlson Darryld A · Buckley, WAS/N 18255398N2198YCustard Ray · Houston, TXBuilt 1962 · S/N 17249698N21990Mcmahan William K · Sandy Valley, NVS/N 15074594N21997Myers Donald W II · Saint Francisville, LAS/N 15074599N2199GEmery Craig A · Wasilla, AKBuilt 1958 · S/N 51499N2199UWood James DBA · Memphis, MOS/N 18800799N219BTDacy Justin A · Boerne, TXBuilt 1976 · S/N 21061568N219CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13080N219CEGillison William · Lake Village, ARBuilt 2023 · S/N 18283219N219JKMiller Charles Jr · Kill Devil Hills, NCS/N 15075463N219MCHansen Todd · Friday Harbor, WABuilt 2004 · S/N 18281323N219PDWolfair LLC · Lewes, DEBuilt 2005 · S/N 18281665N219RADorshorst Dustin J · Deforest, WIBuilt 1971 · S/N 15072929N219SPLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1999 · S/N 172S8219N21ADBogart Donald W Jr · Long Beach, CABuilt 1961 · S/N 18253313N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907N21BMGandee James T · Bullhead City, AZS/N 21061941N21CFSmith Robert R · Benton, LABuilt 1974 · S/N 17702163N21CPT Howard And Associates Architects Inc · Dallas, TXBuilt 1961 · S/N 18253721N21DFDose Gary W · Pinehurst, IDBuilt 1977 · S/N 18265789N21EBSunview Flying Service LLC · Jordan, NYBuilt 1974 · S/N 177RG0589N21EWRountree Christopher B · Burbank, CAS/N 18255335N21FFHor Aviation LLC · Harrisburg, PABuilt 1969 · S/N 18260179N21LDCaswell Bruce · Charleston, WVBuilt 1963 · S/N 18255173N21LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8936N21LS7ac Aviation LLC · Fort Worth, TXBuilt 1964 · S/N 17251817N21LWRegistered aircraftBuilt 1973 · S/N 18261932N21MBAarons David J · Birmingham, ALBuilt 1975 · S/N 15077002N21PVPeterson Kirk A · Nixa, MOBuilt 1966 · S/N 18256921N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066N21RHWogan Joseph M · Mesa, AZBuilt 1972 · S/N 18261224N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591N21SJPointcloud Aviation LLC · Plymouth, MNBuilt 1981 · S/N 18267869N21SZVista Air Inc · Pacoima, CABuilt 1998 · S/N 17280653N21TBAughinbaugh Christopher · Rancho Cordova, CABuilt 1966 · S/N 18257128N21TGScott John · Arcadia, FLBuilt 1972 · S/N 18261547N21TNNavar Thomas R Jr · El Paso, TXS/N 31685N21YCp Aviation Inc · Santa Paula, CABuilt 1954 · S/N 30837N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000N22003Hall David D · Des Moines, WAS/N 15068002N22009Dundon Nick · Bozeman, MTBuilt 1967 · S/N 15068006N2200GCarey Alan W · Fallon, NVBuilt 1958 · S/N 51500N2200XPowell George · Locust Grove, GABuilt 1965 · S/N 337-0100N22014Sun Valley Aviation Inc · Harlingen, TXBuilt 1967 · S/N 15068010
Back to AD 79-10-14 R1