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.

N7440QAircraft Holding LLC · Orem, UTBuilt 1972 · S/N 18261080N7440TFranklin Benjamin L Jr · Woodstock, GABuilt 1960 · S/N 47040N7440XWatonwan Flyers Inc · Saint James, MNBuilt 1960 · S/N 17247940N7441AMadison Nicholas R · Fayette, ALBuilt 1959 · S/N 29541N7441GSussex Aero Maintenance Inc · Georgetown, DEBuilt 1970 · S/N 17259141N7441NAir Impressions Inc · Waco, TXBuilt 1974 · S/N 18263219N7441QSelinger Melvin · Arcata, CABuilt 1972 · S/N 18261081N7441TGarst Lynn F · Oklahoma City, OKBuilt 1959 · S/N 47041N7441XHolland Newel G · Nacogdoches, TXBuilt 1960 · S/N 17247941N7442TTrono Zach C · Charlotte, VTBuilt 1959 · S/N 47042N7442XBeail Herschel D · Quincy, CABuilt 1960 · S/N 17247942N7443MVaccari Kevin N · Walnut Ridge, ARBuilt 1959 · S/N 55743N7443TGuarno Adam C · Milton, FLS/N 47043N7444MMitchell Lester L · Okmulgee, OKBuilt 1958 · S/N 55744N7444QGroffman Armand Rossini · Los Alamos, NMBuilt 1972 · S/N 18261084N7444TDmac Aircraft LLC · Savannah, GABuilt 1959 · S/N 47044N7445EElite Aircraft Sales LLC · Searcy, ARFirst renewal noticeS/N 57145N7445NSkyplane Pilots LLC · Bluffton, SCS/N 18263223N7445QPennino James B · Rancho Cucamonga, CABuilt 1972 · S/N 18261085N7445TKiss Sandor A Jr · Petaluma, CAS/N 47045N7445XMelott Matthew · Mesa, AZS/N 17247945N7446MHobson George A · Fairbanks, AKBuilt 1958 · S/N 55746N7446QAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 18261086N7446TGot Wings LLC · Woodbury, NYBuilt 1959 · S/N 47046N7447XBrewer Eric V · Alva, OKS/N 17247947N7448MCadwell David Earl · Windsor, COBuilt 1959 · S/N 55748N7448NCcx-2000-0111 LLC · Garberville, CABuilt 1977 · S/N U20603662N7448QWilkus Michael J · Mound, MNBuilt 1972 · S/N 18261088N7448XPeterson Bruce L · Williston, NDBuilt 1960 · S/N 17247948N7449EDabir-Ebrahimi Mike M · San Mateo, CABuilt 1960 · S/N 57149N7449GAvmajic LLC · Waterford, MIBuilt 1970 · S/N 17259149N744CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281803N744DPAviation Components Inc · Tarzana, CABuilt 1968 · S/N 18258929N744EFTango Alpha Sierra LLC · Austin, TXBuilt 1976 · S/N 18264796N744MDeforest Shawn L · Lexington, NCBuilt 1978 · S/N 17270562N744NGEvans William H Jr · Gardendale, TXBuilt 1953 · S/N 30397N744RCastaneda Jose · Yakima, WABuilt 1974 · S/N 21060521N744TAAtp Aircraft 7 LLC · Wilmington, DEBuilt 2018 · S/N 172S12144N744WTwin Bridges Aviation LLC · Sheridan, MTS/N 33701N7450EFernald Greg · New River, AZBuilt 1960 · S/N 57150N7450GLewis Benjamin · Delano, MNBuilt 1970 · S/N 17259150N7450MJones Jeremy · Lampasas, TXS/N 55750N7451ETucker Charles M · White City, ORBuilt 1960 · S/N 57151N7451GPresto William R · Houston, PABuilt 1973 · S/N 15074660N7451XReady Aim Flyer LLC · New Castle, DES/N 17247951N7452AHill Nathaniel J · Goldendale, WABuilt 1956 · S/N 29552N7453ASwope Aviation Solutions LLC · Independence, MOBuilt 1956 · S/N 29553N7453EMuller Ronald V · Kansas City, MOBuilt 1960 · S/N 57153N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N7453MHauser Casey L · Springfield, ORBuilt 1959 · S/N 55753
Back to AD 79-10-14 R1