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.

N5902RWojcik Dorene L · Cortland, OHS/N 17253571N5902TMaglaughlin Ronald D · Udall, KSS/N 15060602N5903AHunt Kenneth · Humble, TXBuilt 1956 · S/N 28503N5903BAbidance Inc · Winthrop, WAS/N 33903N5903GRybarczyk Mathias M · Rice Lake, WIS/N 15071403N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049N5904B98x LLC · Caddo Mills, TXBuilt 1956 · S/N 33904N5904FRegistered aircraftBuilt 1967 · S/N 21058904N5904JHodge Marcus · Mansfield, LABuilt 1975 · S/N 18263572N5905JF92 Aviation Llp · Dover, OKBuilt 1975 · S/N 18263573N5905RSmart Harold J · Locust Grove, GABuilt 1965 · S/N 17253574N5905TThomas Paul C · Roberts, WIBuilt 1964 · S/N 15060605N59060Agriflite Services Inc · Wakarusa, INBuilt 1973 · S/N 21060059N5906AGnb Aviation LLC · Lake City, TNBuilt 1956 · S/N 28506N5906GBennett Cass · Oxnard, CABuilt 1969 · S/N 15071406N5906JErkie Norman R · Denison, TXS/N A1500206N5906ROlson Bradley P · Pendleton, ORBuilt 1965 · S/N 17253575N5906TGraf John R · Mather, CABuilt 1964 · S/N 15060606N59073Hartenstine Michael Carl · Lancaster, CABuilt 1973 · S/N 21060069N5907BWarner Aric D · Rosamond, CAS/N 33907N5907ERiver City Flying Club Inc · Valley Center, KSBuilt 1978 · S/N 17271957N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907N5907RBrown Kriss · Naperville, ILBuilt 1965 · S/N 17253576N5907TMccracken David M · Woodland, PABuilt 1964 · S/N 15060607N5908APomeroy Cattle Ranch LLC · Kalispell, MTS/N 28508N5908BLifland Kenneth D · Mckinney, TXBuilt 1956 · S/N 33908N5908EEncarnacion Rosario Joel Alberto · Norwalk, CTBuilt 1959 · S/N 17408N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908N5908GRohrbough Nathan F · Weston, WVBuilt 1969 · S/N 15071408N5908TDorweiler Tom O · Springfield, MOBuilt 1964 · S/N 15060608N5909ARyan Michael W · Rincon, GABuilt 1956 · S/N 28509N5909EOwens Flight Training LLC · Lafayette, LABuilt 1978 · S/N 17271958N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909N5909RWagner Christopher J · Tulsa, OKBuilt 1965 · S/N 17253578N590CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282171N590MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608339N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818N590SPTubreaux Aviation Services LLC · Shreveport, LABuilt 2000 · S/N 172S8520N59105Allen Willis M Jr · El Cajon, CABuilt 1973 · S/N 21060093N5910AAlumbaugh Ian M · Mcpherson, KSBuilt 1956 · S/N 28510N5911BKatzer Jamin · Frederick, COBuilt 1956 · S/N 33911N5911EOne Fiddy LLC · Bellingham, WAS/N 17411N5911JAveightor LLC · Alba, TXBuilt 1975 · S/N 18263574N5912BPrice Rand S · Casper, WYBuilt 1956 · S/N 33912N5912ERobinson Brayden K · Palmer, AKBuilt 1959 · S/N 17412N5913GFerguson Joe C · Shreveport, LABuilt 1969 · S/N 15071413N5913RWilliams Alonzo · Bentonville, ARBuilt 1965 · S/N 17253582N59141Peters Mark E · Newport News, VABuilt 1973 · S/N 21060118
Back to AD 79-10-14 R1