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.

N7258MJj Flyers LLC · Corinth, MSBuilt 1958 · S/N 55558N7258RMoynihan Daniel P · Hernando Beach, FLS/N 17280981N7258SBusiness As Usual LLC · Spartanburg, SCBuilt 1967 · S/N 15067958N7258TAutry Stephen W · Durango, COBuilt 1959 · S/N 46858N7259AHalladay Roy · Erie, COS/N 29359N7259EWiley Jerry Lynn · Mission, TXBuilt 1959 · S/N 52259N7259GLuevano Eric · Huntington Beach, CAS/N 18263318N7259MRosario Ted · Salome, AZBuilt 1958 · S/N 55559N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559N7259SSchafer Louis L · Murfreesboro, TNBuilt 1967 · S/N 15067959N7259THarrington Everett Dean · Council, IDBuilt 1959 · S/N 46859N7259XRedtail LLC · Lafayette, COBuilt 1961 · S/N 15059359N725ASGeorgia Co Of Aspiring Flyers LLC · Clarkesville, GABuilt 1978 · S/N 18266640N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802N725BJBas Part Sales LLC · Greeley, COS/N 20608023N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842N725LCReeves Jerry H · Whitesburg, GABuilt 1964 · S/N 17251919N725LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13209N725LVAia Echo LLC · Henderson, NVBuilt 2021 · S/N 172S12748N725PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 172S8009N725RBBatesole William D Trustee · Walpole, NHBuilt 1968 · S/N 15068309N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254N725VPTeam Negrich LLC · Osteen, FLBuilt 1971 · S/N U20601664N725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734N7260AChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280861N7260HN2617f LLC · Frankfort, KYBuilt 2000 · S/N 18280896N7260KAmbitious Aviation LLC · Newport News, VABuilt 2000 · S/N 18280895N7260QNaples Flying Club Inc · Naples, FLBuilt 2001 · S/N 18280957N7260XCoutu Justin · Whitewater, COBuilt 1961 · S/N 15059360N72612Washington State Dept Of Transp · Tumwater, WAS/N 18280988N72614Liberty Leasing IV LLC · Melbourne, FLBuilt 2000 · S/N 20608117N7261ACassity Michael D · Springfield, MOBuilt 1956 · S/N 29361N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961N7261HMurray John Fulton III · Fort Worth, TXS/N 20608143N7261MCox Jeff C · Newark, OHBuilt 2000 · S/N 18280901N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561N7261ZChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9080N7262ACf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2000 · S/N 20608138N7262EStrough Jacob L · Twin Falls, IDBuilt 1959 · S/N 52262N7262MRegistered aircraftBuilt 2000 · S/N 18280900N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562N7262XFlight School Of Gwinnett Inc · Lawrenceville, GAS/N 17280993N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806N7263AHillside Farms · Elaine, ARBuilt 1956 · S/N 29363N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963N7263MGolan Shachar Yaacov · Farmington Hills, MIBuilt 1958 · S/N 55563N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563N7263TScheler Thomas · Independence, ORS/N 46863N72647Awa Tupua LLC · Brambleton, VABuilt 1999 · S/N 18280623
Back to AD 79-10-14 R1