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.

N7760GLeriche Nicolette · Oceanside, NYBuilt 1970 · S/N 17259460N7760UScott Timothy E · West Danville, VTBuilt 1964 · S/N 17251760N7761FSullivan Randall G · Liberty, TXBuilt 1966 · S/N 15063861N7761KGoldmark Peter J · Olympia, WAS/N 18052722N7762EPierce Roger V · Broken Arrow, OKBuilt 1959 · S/N 17562N7762FCosta Air Service LLC · Painted Post, NYS/N 15063862N7762TLisle Rachel C · New Enterprise, PABuilt 1960 · S/N 47362N7762XRodriguez Bruno · Crestview, FLBuilt 1961 · S/N 17248262N7763CHudzinski Thomas E · Wasilla, AKS/N 32341N7763FRoss Joshua S · Homer, AKBuilt 1966 · S/N 15063863N7763TWood Pro Ventures LLC · Justiceburg, TXBuilt 1960 · S/N 47363N7763UMarshall Michael S · Lincoln, CABuilt 1976 · S/N 15077835N7764FAbouhatab Majed · Houston, TXBuilt 1966 · S/N 15063864N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464N7764XMalcolm Ward A · Moorefield, WVBuilt 1960 · S/N 17248264N7765EFuellner Sean L · Shelocta, PAS/N 17565N7765FFilippone Chrristopher A · Ormond Beach, FLS/N 15063865N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465N7765TWhisman Marc K · Long Beach, CABuilt 1960 · S/N 47365N7765UCentral Ohio Soaring Association Inc · Marion, OHBuilt 1976 · S/N 15077837N7766EArmitage Alexandra S · Nederland, COBuilt 1959 · S/N 17566N7766FBuckman Bill · Lorenzo, TXBuilt 1966 · S/N 15063866N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466N7766TGourley Steven E · Unionville, MOBuilt 1960 · S/N 47366N7767AWinged Bear LLC · Grafton, WIBuilt 1956 · S/N 32664N7767BKline Paul · El Mirage, AZBuilt 1971 · S/N 18501945N7767EBruce Matthew · Arlington, TXBuilt 1959 · S/N 17567N7767FMorris Donald R · Murphysboro, ILS/N 15063867N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467N7767TVisscher Paul J · Madison, GABuilt 1960 · S/N 47367N7767USkynet Aviation LLC · Cocoa Beach, FLS/N 15077838N7768AAmundson Scott E · Wrightwood, CAS/N 32665N7768EYounger David B · Port Angeles, WABuilt 1959 · S/N 17568N7768UFoothill Sport Aviation LLC · Cameron Park, CABuilt 1976 · S/N 15077839N7769APliska Alan T · Torrance, CABuilt 1956 · S/N 32666N7769EFieldgrove Matt · Somerton, AZBuilt 1959 · S/N 17569N7769TWhiskey Tango Foxtrot Aviation LLC · Bemidji, MNBuilt 1960 · S/N 47369N776AASolo Aircraft Rental LLC · Farmingdale, NYBuilt 2005 · S/N 172S9928N776CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281776N776MWAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13475N776NGoeken William K Trustee · Sanger, TXS/N 18503239N776SASopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1976 · S/N 15077884N776SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12444N776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480N776VB40ac LLC · Hartford, WIBuilt 2000 · S/N 172S8508N7770ASampson Zachary J · New Braunfels, TXS/N 17252309N7770EDye John Donald Jr · Higginsville, MOBuilt 1960 · S/N 17570N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470N7770KAir Craft LLC · Sheridan, WYBuilt 1976 · S/N 18052726N7770TShinn William D · Milton, WABuilt 1960 · S/N 47370
Back to AD 79-10-14 R1