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.

N50816Dingee Robert G · Clarks Summit, PABuilt 1968 · S/N 15069571N50818Bradley Hayden Ace · Litchfield Park, AZBuilt 1968 · S/N 15069572N50819Registered aircraftBuilt 1968 · S/N 15069573N5081AJones William H Trustee · Wenden, AZBuilt 1955 · S/N 28081N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222N5082AYoung Ryan E · Willis, TXBuilt 1955 · S/N 28082N5082DRegistered aircraftBuilt 1958 · S/N 51182N5082EWeaver M Thomas · Kalispell, MTBuilt 1979 · S/N 18503928N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320N5082WAmeeti Robert Keith Trustee · Newport Beach, CABuilt 2001 · S/N 172S8970N50832Whalen John F Jr · West Ossipee, NHS/N 15069584N50835Henson Chad Cox · Galivants Ferry, SCBuilt 1968 · S/N 15069585N50836Leeper Miles F · Douglass, KSBuilt 1968 · S/N 15069586N50837N50837 LLC · Kaneohe, HIBuilt 1968 · S/N 15069587N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956N5083NN5083 LLC · San Diego, CABuilt 1979 · S/N 18267504N50840Dahlgren John W · Little Egg Harbor, NJBuilt 1968 · S/N 15069588N50844Ellenson Conroy N · Browns Valley, CABuilt 1968 · S/N 15069590N50846Jackson Bob · Bay City, TXS/N 15069592N5084AOsterberg Douglas L · Neenah, WIBuilt 1955 · S/N 28084N5084DArrow LLC · Pateros, WABuilt 1958 · S/N 51184N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322N50850Knutson Wayne R · Tioga, NDBuilt 1968 · S/N 15069596N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600N50858Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10894N5085DHawkes Brian R · Hamilton, MTBuilt 1958 · S/N 51185N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957N50864Rasmussen Agribusiness Inc · Antelope, MTS/N 17264215N50865Smith Leslie A · Waresboro, GAFirst renewal noticeBuilt 1968 · S/N 15069606N50868Krekacs Gabor · La Crescenta, CABuilt 1968 · S/N 15069608N5086ANeeley James L · Temecula, CAS/N 21063263N5086DGillaspy Paul J · Orcutt, CABuilt 1958 · S/N 51186N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703N5086NSnoopy Aviation Ltd · San Antonio, TXBuilt 1979 · S/N 18267505N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324N50871Saint Joseph Of Cupertino Shenandoah Flying Assoc · Winchester, VABuilt 1968 · S/N 15069610N50874Priddle Linda Ann · Carlsborg, WABuilt 1968 · S/N 15069613N50875Krs Aerial Inc · Plain City, OHS/N 15069614N50876Parker David A · Sacramento, CAS/N 15069615N5087AMenard Bernny · Abbeville, LABuilt 1955 · S/N 28087N5087BSchwebach Victoria L · Coronado, CAS/N 18255988N5087DPenz Johnathan D · Russian Mission, AKBuilt 1958 · S/N 51187N5087EDern Aviation · Lake Charles, LAS/N 17271704N5087JSession Jason E · Higden, ARS/N 17273698N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958N50887Stanton Sport Aviation Inc · Stanton, MNBuilt 1968 · S/N 15069620
Back to AD 79-10-14 R1