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.

N7136QPa Lawrence LLC · Anchorage, AKBuilt 1972 · S/N 17260436N7136SGonzalez Alec · Homestead, FLBuilt 1967 · S/N 15067836N7136TSnouffer Robert E · Mountain Grove, MOBuilt 1959 · S/N 46736N7136XArchangel Michael Flyers Inc · Princeville, HIS/N 17702290N71374Farmers Supply Corp · Ontario, ORBuilt 1969 · S/N 18259596N71378Hanson Jared E · Missoula, MTBuilt 1969 · S/N 18259598N7137ACarrico Drew E · Redway, CABuilt 1956 · S/N 29237N7137ESss Inc · Anchorage, AKBuilt 1959 · S/N 52137N7137TLeavitt John E · Palmer, AKBuilt 1959 · S/N 46737N71384Neal Donald L · Fresno, CABuilt 1969 · S/N 18259600N71386Single Engine Flyers LLC · Fredericksburg, TXBuilt 1969 · S/N 18259601N7138GWerenko Zandra · Cape Canaveral, FLBuilt 1973 · S/N 15074616N7138QArctic Aviation Leasing LLC · Anchorage, AKBuilt 1975 · S/N U20603074N7138SDeaton Craig · West Alexandria, OHBuilt 1967 · S/N 15067838N7138THudson Thomas C · Bessemer, ALBuilt 1959 · S/N 46738N7138XHalvorson Jerome B · Wyndmere, NDBuilt 1961 · S/N 15059238N71397Turner Chris · Kosse, TXBuilt 1969 · S/N 18259606N71398Koch Jon P · Menahga, MNBuilt 1969 · S/N 18259607N7139ATimothy Scott Bloom · Chugiak, AKBuilt 1956 · S/N 29239N7139DBenjamin Ralph L · Fitchburg, WIBuilt 1999 · S/N 18280549N7139EBarnes Gary · Idaho City, IDBuilt 1959 · S/N 52139N7139GSkysg LLC · Eugene, ORBuilt 1969 · S/N 17258839N7139QFernander David · Enterprise, ALBuilt 1972 · S/N 17260439N7139XBryk Steven L · Port Orange, FLBuilt 1999 · S/N 18280551N713ADSchuessler William · Turner, ORBuilt 1975 · S/N 18264339N713BJRiley James A · Richmond, KYBuilt 1959 · S/N 46696N713CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12529N713DJimmy & Steve Aviation LLC · Fredericksburg, VABuilt 1973 · S/N 18262519N713FSTfs Air LLC · Loveland, COBuilt 2008 · S/N 17281513N713GFFleming Geoffrey R Jr · Port Saint Lucie, FLBuilt 1975 · S/N 18263999N713JHMccauley James · Ithaca, NYBuilt 2000 · S/N 18280777N713JKSbarounis Carl A · Torrance, CABuilt 1975 · S/N 17265460N713KRegistered aircraftBuilt 1975 · S/N 18263804N713LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11660N713MATraining Wheels & Advanced Technologies LLC · La Salle, COBuilt 1966 · S/N U206-0679N713PMWestbank Fishing LLC · New Orleans, LABuilt 1999 · S/N 18280427N713RBKay Timothy A · Kyle, TXBuilt 2000 · S/N 172S8547N713SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13579N713SJKoerner James L Trustee · Gilbert, AZBuilt 1977 · S/N 17269713N713SMJa Williams Investments LLC · Austin, TXBuilt 1969 · S/N 18259920N713SZN713sz LLC · Jacksonville, FLBuilt 2023 · S/N 172S12957N713TGSelway Construction Group LLC · Moscow, IDBuilt 1979 · S/N U20605218N714United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502711N71400Wubben Robert C · Waupaca, WIBuilt 1969 · S/N 18259609N71405Bowes John Michael · Lake City, FLBuilt 1969 · S/N 18259611N71408Emerald Darin · Springerville, AZBuilt 1969 · S/N 18259612N71409Piedmont Flight Inc · Winston Salem, NCBuilt 1976 · S/N 17267227N7140EJ W Bamford Inc · Oroville, CABuilt 1959 · S/N 52140N7140FLogan Gregory A · Chouteau, OKS/N 15063740N7140JCohesive Aviation LLC · Gilford, NHBuilt 1980 · S/N 17273901
Back to AD 79-10-14 R1