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.

N8147SHoehn Ronald T · Perryville, MOS/N 15061747N8147VSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 188-0397N8148BRoberts Michael · Port Orchard, WABuilt 1957 · S/N 29948N8149BBergstrom Matthew James · Renton, WABuilt 1957 · S/N 29949N8149MMcinnish John · Tallassee, ALBuilt 1976 · S/N 18264547N8149XBlacksword Armoury Inc · Hawthorne, FLBuilt 1961 · S/N 17248649N814BMMcdaniel Robert L · Columbia, ILBuilt 1966 · S/N 17255216N814CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13364N814DEDickinson Dennis D · St Pete Beach, FLBuilt 1966 · S/N 17254192N814EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13184N814FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12456N814HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280814N814JAdvantage Aviation Services LLC · South Saint Paul, MNS/N 337-0596N814JHOcean Ave LLC · Mound House, NVS/N 18264821N814KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281248N814MVSterling Flight Training LLC · Jacksonville, FLBuilt 2005 · S/N 172S9965N814RReed Mackenzie · Princeton, TXS/N 17260405N814SAMarion Military Institute · Marion, ALBuilt 2002 · S/N 17281114N814WMLannom John Rusty · Lebanon, TNBuilt 2001 · S/N 18280939N8150BFond Of Flying Co · Dover, DES/N 29950N8150LKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1967 · S/N 17256350N8150TAhs Aero LLC · Phoenix, MIS/N 17556850N8150VSchindler Flying Inc · Neligh, NEBuilt 1968 · S/N 188-0400N8151AHayes James R · Sonora, CABuilt 1952 · S/N 25003N8151BBig Valley Flying Club · Lookout, CABuilt 1957 · S/N 29951N8151FMitchell John F · Shannon, ILBuilt 1966 · S/N 15064251N8151LBrown Gary D · Rainbow City, ALBuilt 1967 · S/N 17256351N8151TAffordable Flight Time LLC · Eagle River, AKBuilt 1960 · S/N 17556851N8151UYork George T · Harvard, ILBuilt 1964 · S/N 17252051N8151XEvarts Raymond A · Cedar City, UTS/N 17248651N8152AMattoon Michael · Santa Fe, NMBuilt 1952 · S/N 25004N8152LBowman Douglas M · Elyria, OHBuilt 1967 · S/N 17256352N8152UGentry James L · Englewood, TNBuilt 1964 · S/N 17252052N8152VBrowning Lonnie O IV · Allendale, SCBuilt 1974 · S/N A1500543N8153AKaulback Joseph F · Andover, CTS/N 25005N8153LTr Air LLC · Kenton, OHBuilt 1967 · S/N 17256353N8153SBelli Tony G · Huron, OHBuilt 1965 · S/N 15061753N8153UGorman Shawn Michael · Van Wert, OHBuilt 1964 · S/N 17252053N8153XArmbrister Justin R · Blue Ridge, TXBuilt 1961 · S/N 17248653N8154BWestnyack Aviaiton LLC · Sag Harbor, NYBuilt 1957 · S/N 29954N8154FWilson Gary L · Levant, MES/N 15064254N8154UPodgorski James E · Walworth, WIBuilt 1964 · S/N 17252054N8154ZTurner Company LLC · Hearne, TXBuilt 1962 · S/N 205-0154N8155BBrockman Charles · Bend, ORBuilt 1957 · S/N 29955N8155FJapundza Bob · Kokomo, INBuilt 1966 · S/N 15064255N8155SSale Reported · Cherry Valley, CASale reportedS/N 15061755N8155TChristen Richard P · Bend, ORS/N 17556855N8155UShearer Ronald L · Quincy, INBuilt 1964 · S/N 17252055N8156AReetz Duane W · Clintonville, WIBuilt 1952 · S/N 25008N8156FKindlon Aviation Inc · Glenmont, NYBuilt 1966 · S/N 15064256
Back to AD 79-10-14 R1