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.

N7276SMorgan Michael · Wichita, KSBuilt 1967 · S/N 15067976N7276TBraner Richard C Trustee · Oakdale, CABuilt 1959 · S/N 46876N7276VLegends Air Center LLC · Bentonville, ARBuilt 1999 · S/N 18280570N7276XEvv 150 LLC · Evansville, INBuilt 1961 · S/N 15059376N7276ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608043N72771Jones Steve · Roach, MOBuilt 2000 · S/N 18280924N7277ADrzewiecki Chad M · Cuyahoga Falls, OHBuilt 1952 · S/N 29377N7277SMarkland Benjamin Harrison · Lehigh Acres, FLBuilt 1967 · S/N 15067977N7277TStrehler Stanford L · League City, TXBuilt 1959 · S/N 46877N72780Dean'S Flight Inc · Pembine, WIS/N 18280954N72788Christiansen Aviation LLC · Wilmington, DES/N 17280988N7278EAlvarez Scott · Battle Ground, WABuilt 1959 · S/N 52278N7278NPerry Christopher W · West Sacramento, CAFirst renewal noticeBuilt 1974 · S/N 18263065N7278SEngineers Flying Club Inc · Bethany, OKBuilt 1999 · S/N 18280506N7278TChudy Daniel B · Yucaipa, CAS/N 46878N7278WHeinichen Richard · Dripping Springs, TXBuilt 1999 · S/N 18280509N7278XTwin City Cloud 7 Inc · Eden Prairie, MNBuilt 1999 · S/N 18280510N72798Skylane 72798 LLC · Winston Salem, NCBuilt 2001 · S/N 18280946N7279AGoerger Allan E · Barney, NDBuilt 1956 · S/N 29379N7279BBautista Mark S · Sonora, CAS/N 18280542N7279EXtreme Divers West Inc · San Juan, PRS/N 52279N7279GMartin Rick · Rindge, NHBuilt 1973 · S/N 15074633N7279SLee Peter Joohak · Irvine, CABuilt 1967 · S/N 15067979N7279WCj Aviation LLC · Freeport, MEFirst renewal noticeBuilt 1999 · S/N 18280544N727BSHorvath Andrew J · Winnsboro, SCBuilt 1966 · S/N 15064667N727CMoore Kelly M · Moscow, IDBuilt 1958 · S/N 51319N727CGOwens Keith E · Wrightstown, NJBuilt 2000 · S/N 18280838N727CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282255N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086N727DGMarsh David G · Bluffdale, UTBuilt 1955 · S/N 31710N727DRRoss Trucking LLC · Goldendale, WAS/N U206-0556N727FACorporate Services LLC · Baton Rouge, LAS/N 21059414N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912N727GLRheney John W III · Cameron, SCBuilt 1976 · S/N 18264939N727HMPatterson Casey Paul · Kinston, ALS/N 15066715N727JTStory Billy G · Kempner, TXBuilt 1965 · S/N 337-0200N727KDReich Brad Roy · Rohnert Park, CAS/N 17254281N727LBMcnamee John B · Sugar Land, TXBuilt 1974 · S/N 177RG0626N727LCBurmaster Christopher R · Murfreesboro, TNBuilt 1966 · S/N 17254788N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938N727LHHale John A · Ennis, MTBuilt 1965 · S/N P206-0085N727LSScarsella Luciano S · Lafayette, LAS/N 18265755N727LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13590N727METruesdell Shannon · Stephenville, TXBuilt 1976 · S/N 17268426N727NEDeeair Ltd · Dayton, OHBuilt 1979 · S/N U20605152N727NSBarrett Kemberly · Woodway, TXBuilt 2006 · S/N 18281809N727PBRegistration Pending · Farson, WYRegistration pendingBuilt 1973 · S/N 18262260N727PCPb&J Holding LLC · Franktown, COBuilt 1979 · S/N 18267396N727PMMiddlebrook Paul E · Penn Yan, NYBuilt 1981 · S/N 17275485N727RCKelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17263887
Back to AD 79-10-14 R1