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.

N6127RPhillips Bill · Galt, CABuilt 1965 · S/N T210-0027N6127TVan Hammers Gary C · Mukwonago, WIS/N 15060827N6127VSorbi Aviation Inc · El Cajon, CAS/N 172RG0583N61282Trimble David G · Vici, OKBuilt 1969 · S/N 15070939N61286Houseman Jeffery D · Millersville, MOBuilt 1966 · S/N 15063430N61288Vanorman Curt M · Clarkesville, GABuilt 1969 · S/N 15070944N6128EWang Tekang · Ashburn, VABuilt 1959 · S/N 46228N6128NJones Charles C · Mccall, IDBuilt 1980 · S/N 18267794N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028N61296Coomes Scott F · Seattle, WABuilt 1969 · S/N 15070947N61297Highway Jet League Flyers Brotherhood LLC · Allouez, WIBuilt 1969 · S/N 15070948N61298Arizona Game And Fish Department · Phoenix, AZBuilt 1980 · S/N 18504142N6129GPeters William E · Bel Air, MDBuilt 1970 · S/N 15071629N6129KLatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1975 · S/N 15077538N6129RIncline Engineering And Consulting LLC · Ovalo, TXBuilt 1965 · S/N T210-0029N612ADCurless Harley J · Havana, ILBuilt 1974 · S/N 182-62855N612BKKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 20608325N612BZDerby City Aviation LLC · Vero Beach, FLBuilt 1979 · S/N 17272084N612DMRegistered aircraftBuilt 1977 · S/N 177RG1212N612DPCarlson Glenn Alan · Byron Center, MIBuilt 2007 · S/N 18281953N612ESHouston Jason S · Shelton, WABuilt 1973 · S/N 18262270N612HKDickey Stephen H · De Leon, TXBuilt 1977 · S/N 177RG1303N612HPAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274933N612JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13588N612PDMenagerie Enterprises Inc DBA · Denison, TXBuilt 2015 · S/N 172S11647N612RTimm Robert S · Minneapolis, MNBuilt 1977 · S/N R1722687N612RKMalcomson Kenneth L · Cresson, TXBuilt 1959 · S/N 46603N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356N61301Southern Seaplane Inc · Belle Chasse, LABuilt 1980 · S/N 18504144N6130BFandango Aviation LLC · Lake Elsinore, CABuilt 1956 · S/N 34130N6130CMay And Carter Oil Co · Jackson, GABuilt 1979 · S/N 21063808N6130DJones Matthew A · Saluda, NCBuilt 1979 · S/N 17272610N6130ERounds Donald W DBA · Waller, TXS/N 46230N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030N61311Wood James A · Madera, CABuilt 1969 · S/N 15070955N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508N6131EWilliams Rick J · Cooperstown, NYBuilt 1958 · S/N 46231N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031N6131GCragg Gordon E · Georgetown, TXBuilt 1969 · S/N 15071631N6131RAir LLC · Salem, ORS/N T210-0031N61321Gerdes Brian K · Los Alamitos, CAS/N 15070963N61323N61323 LLC · Portland, ORBuilt 1980 · S/N 18504147N61324Wills Evan J · Lynnwood, WABuilt 1969 · S/N 15070964N61325Zetir Mohamad · Oviedo, FLBuilt 1969 · S/N 15070965N61329Girls Love To Fly Inc · Roseville, CABuilt 1969 · S/N 15070969N6132GMorcom Aviation Services Inc · Everett, WABuilt 1979 · S/N 17273570N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584N61333Gustafson Michael J · Minnetonka, MNBuilt 1969 · S/N 15070972
Back to AD 79-10-14 R1