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.

N6293EWatkins Jerry G · Portland, ORBuilt 1959 · S/N 46393N6293GMindy Limited LLC · Muscatine, IABuilt 1979 · S/N 17273588N6293TFranks Lauren N · La Fayette, GABuilt 1964 · S/N 15060993N62946Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275365N6294EFlightpath Leasing LLC · Tallahassee, FLS/N 46394N6294GGoodrich Michael O · Cogan Station, PABuilt 1970 · S/N 15071794N6294NJanzen Brian · Fort Worth, TXBuilt 1981 · S/N 18267821N6294RMitrenko Alexander V · Selinsgrove, PABuilt 1979 · S/N 172RG0154N6294SErmel Ryan · Taylor, PABuilt 1967 · S/N 15067094N62953Dodge Inc · Wilmington, DEBuilt 1981 · S/N 17275367N6295DCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272700N6295EBuffo Perry J · Albion, NJBuilt 1959 · S/N 46395N6295GRegistration Pending · Eliot, MERegistration pendingBuilt 1970 · S/N 15071795N6295YSkydoc LLC · Mokena, ILBuilt 1981 · S/N 21064322N62960Fossen Kenneth J · Omaha, NEBuilt 1981 · S/N 17275368N6296ABarber Michael L · Igo, CABuilt 1956 · S/N 33096N6296EKlad-Air LLC · Catlett, VABuilt 1959 · S/N 46396N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185N6296KMclean Lachlan · North Creek, NYBuilt 1975 · S/N 15077629N6296THillsboro Flying Club Inc · Hillsboro, WIBuilt 1964 · S/N 15060996N6297FHitchcock Lonnie G · Sparta, TNS/N 337-0297N6297GMaclean Kenneth J · Northborough, MABuilt 1974 · S/N 18263311N6297HHackbart Gary H · Las Vegas, NVBuilt 1978 · S/N 20700472N6297RBejna Robert C · Addison, ILBuilt 1965 · S/N 15061597N6297TFrazier Joel A · Fennimore, WIBuilt 1964 · S/N 15060997N6297YL&L Aviation LLC · Baden, PAS/N 21064323N62983Studer Rodney J · Shelby, MIS/N 15063618N6298AExec Air Of Naples · Naples, FLBuilt 1956 · S/N 33098N6298EGreenes R&R LLC · Hobbs, NMBuilt 1983 · S/N 18268358N6298FKubik John A · Hardy, VAS/N 337-0298N6299CCenturion Flight LLC · Auburn, WABuilt 1980 · S/N 21063858N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704N6299ECarpenter Daniel R · Jefferson City, MOBuilt 1959 · S/N 46399N6299FLynch Gregory R · Pahrump, NVBuilt 1966 · S/N 337-0299N6299KMarco Aviation Club Corp · Naples, FLBuilt 1975 · S/N 15077630N6299RNorwood Dan L · Chippewa Falls, WIBuilt 1965 · S/N 15061599N6299SSena Gregori C · Buckeye, AZBuilt 1967 · S/N 15067099N6299TRegistered aircraftN-number assigned, not yet registeredS/N 15060999N629AHSuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9301N629BCVolar V LLC · Edmond, OKBuilt 2013 · S/N 172S11277N629CMByrne Thomas J · Cascade, IDBuilt 1965 · S/N 18256340N629CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282268N629EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2021 · S/N 172S12750N629ESKorenek Michael A · Houston, TXBuilt 2002 · S/N 18281163N629JWPenniman Reagan E · Georgetown, TXBuilt 1961 · S/N 15059205N629LBBachman Aviation LLC · Independence, IABuilt 1979 · S/N R1723063N629MMMcgraw Michael T · Gainesville, GABuilt 1973 · S/N 17262164N629SPTextron Aviation Inc · Wichita, KSS/N 172S13663N629TCAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N 18281629N629WCCollins Jeffery Scott · Griffin, GABuilt 1963 · S/N 18254745
Back to AD 79-10-14 R1