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.

N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833N5759AFlying K & Associates Inc · Hawthorne, FLBuilt 1956 · S/N 28359N5759EHarrison Gary L · New London, WIBuilt 1959 · S/N 17259N5759JThree Six Golf Ltd · Cary, NCBuilt 1974 · S/N 18263522N5759RP & R Aviation LLC · Edenton, NCS/N 17253428N575AAHanson Dirk Allen · Moorhead, MNS/N 205-0322N575DKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 18283291N575NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10954N575PMLiebfried Andrew H · Lunenburg, MABuilt 1975 · S/N 18264045N575RWWashington County · Hillsboro, ORBuilt 1978 · S/N R1722881N575SPCharlie Leasing LLC · Green Bay, WIBuilt 2000 · S/N 172S8504N575TDDahl Russell · Nashua, MTBuilt 1976 · S/N 17268034N575YSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 172S9656N5760BAbbott Jay D · Rocky Mount, VABuilt 1956 · S/N 33760N5760CHenson Robert H Jr · Lanark, ILBuilt 1950 · S/N 19714N5760GVan De Walle Matthew W · San Antonio, TXBuilt 1969 · S/N 15071260N5761BTerry Canales Attorney At Law Pllc · Edinburg, TXBuilt 1956 · S/N 33761N5762CColescott Zachary · Cleveland, TNBuilt 1950 · S/N 19716N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462N5763EVilla Rafael O · Miami, FLBuilt 1978 · S/N 17271936N5763JLemons Brooks D · Visalia, CABuilt 1971 · S/N 21059463N5763TLumgair David R · Painter, VABuilt 1964 · S/N 17251663N5764AMorrison Benjamin F III · Godley, TXBuilt 1956 · S/N 28364N5765B5765 Bravo LLC · Three Forks, MTBuilt 1956 · S/N 33765N5765CFinnegan John J · North Fort Myers, FLBuilt 1950 · S/N 19719N5765GQuiring Jason L · Terrell, NCS/N 15071265N5765TRawareo LLC · Warsaw, MOBuilt 1964 · S/N 17251665N5766ASoma Holdings LLC · Wasilla, AKBuilt 1956 · S/N 28366N5766BClover Crest II Inc · Key Largo, FLBuilt 1956 · S/N 33766N5766CMacgregor David A Jr · Naples, FLBuilt 1950 · S/N 19720N5766JVan Hoogmoed Andrew P · Turlock, CABuilt 1980 · S/N 17273834N5766TJanson Flying Service Inc · Wadena, MNBuilt 1964 · S/N 17251666N5767BBarker Ski LLC · Big Lake, AKBuilt 1956 · S/N 33767N5767JValiair Limited Co Trustee · Casper, WYBuilt 1971 · S/N 21059467N5767RSelf Averill L · Campbell, TXBuilt 1965 · S/N 17253436N5768AGowing Glyn Thomas · Longview, TXBuilt 1956 · S/N 28368N5768CJones Gary A · Huron, SDBuilt 1950 · S/N 19722N5768GBilton Nicholas J · Bozeman, MTBuilt 1969 · S/N 15071268N5768JHaag Walter G · Fall City, WABuilt 1971 · S/N 21059468N5768RAllenray Corp · Otsego, MIBuilt 1965 · S/N 17253437N5768TCrouse Sheldon · Mount Pleasant, NCBuilt 1964 · S/N 17251668N5769BOgorman Errol M · Festus, MOBuilt 1956 · S/N 33769N5769GHarper William M Jr · Foley, ALBuilt 1969 · S/N 15071269N5769JRegistration Pending · Derby, KSRegistration pendingBuilt 1974 · S/N 18263527N5769RLatimer Francis E · Washingtonville, NYBuilt 1965 · S/N 17253438N576BWBridgewater State University · North Dartmouth, MAS/N 17280494N576CACivil Air Patrol · Montgomery, ALBuilt 2008 · S/N 18282122N576DSLcb Leasing · Bristow, VABuilt 2010 · S/N 18282229N576NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10962N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501
Back to AD 79-10-14 R1