OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N299MWAbramovich Michael Pavel · Scottsdale, AZBuilt 1960 · S/N 15059071N299PLTextron Aviation Inc · Wichita, KSS/N 172S13654N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631N299RQRds Aviation LLC · Powder Springs, GABuilt 1977 · S/N 177RG1167N299TDBrueggen Erin J · Cashton, WIBuilt 1950 · S/N 15596N29AFDale Michael · Murrieta, CABuilt 1998 · S/N 17280456N29BCD' Jm Holdings LLC · Sugar Land, TXBuilt 1974 · S/N P3370172N29CMChenango 11 LLC · Wilmington, DEBuilt 1976 · S/N 18264793N29ERCosta Air Service LLC · Painted Post, NYBuilt 1977 · S/N 17269532N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262N29HTTrede 2023 LLC · Aurora, ORBuilt 2024 · S/N 172S13215N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579N29LKGibbons David · Holmen, WIS/N 177RG0736N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309N29NDDamstetter Katherine M · Hudson, FLS/N 15066888N29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N29SRAviation USA LLC · Anchorage, AKBuilt 1978 · S/N 18503582N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789N2AWSpacecrafters Inc · Silver Springs, FLBuilt 1971 · S/N 17701692N2BFMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 15068499N2BPMiami Clipper Aviation LLC · Cutler Bay, FLBuilt 1972 · S/N 17701783N2CNCassel Paul E · Hernando, MSS/N 18052848N2CWMiller Steven D · Mccall, IDS/N 18502486N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609N2FNFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269910N2GAWilson Frank C · Irondale, OHBuilt 1974 · S/N 18502376N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443N2JKGoldberg Leonard J · Westbrook, CTBuilt 1977 · S/N 18265546N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436N2KFLivingston H Clark · Akron, ALBuilt 1968 · S/N 17700997N2KGLowe Samuel S III · Mary Esther, FLBuilt 1974 · S/N 17702073N2NMMayberry Harold M · Bryant, ILBuilt 1949 · S/N 18831N2PJMorgan Bryan K · Sacramento, CABuilt 1969 · S/N 337-1161N2QDSpectraq · Las Vegas, NVS/N P3370277N2QFAbel Elliot A · Terre Haute, INBuilt 1977 · S/N P3370280N2QKPax Air LLC · Minden, NVS/N P3370283N2QMNorth Casade Air Transport LLC · Manson, WABuilt 1977 · S/N P3370290N2QPNoess Michael A · Shakopee, MNBuilt 1977 · S/N P3370291N2SKRegistered aircraftBuilt 1980 · S/N 172RG0666N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908N2SSFlying M Aircraft LLC · Kuna, IDBuilt 1952 · S/N 19980N2TAMontgomery Keith L · Florence, ALBuilt 1972 · S/N 15073811N2TGB2c2 Aviation LLC · Piedmont, CABuilt 1969 · S/N 337-1064
Back to AD 79-10-14 R1