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.

N8379SAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 18256479N837CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11585N837DDKleeman Thomas J · Cooper Landing, AKBuilt 1977 · S/N R1722743N837GACampbell Stephen V · Farmingdale, NYS/N 182-67338N837KSKansas State University · Salina, KSBuilt 2019 · S/N 172S12307N837LAVolar Xi LLC · Edmond, OKBuilt 2011 · S/N 172S11074N837SPIsrani Vijay · Cupertino, CABuilt 2001 · S/N 172S8727N8380ALynch Henry D · Hebron, NHBuilt 1952 · S/N 25232N8380BShull Thomas A · Copper Center, AKBuilt 1957 · S/N 36180N8380UTrp Enterprises Inc · Mocksville, NCBuilt 1965 · S/N 17252280N8381BRaymond Kyle Inc · Eagle, COS/N 36181N8381LShielded Holdings LLC - Series Av 12 · Katy, TXBuilt 1968 · S/N 17256581N8381SUer LLC · Searcy, ARBuilt 2018 · S/N 18283035N8381TMapes Peter B · Oscoda, MIS/N 17557081N8381UFuryious Aviation LLC · Bossier City, LABuilt 1964 · S/N 17252281N8381ZVoran Carlon R · Port Alsworth, AKBuilt 1963 · S/N 205-0381N8382BDevore Plane Affects Lp · Independence, KSS/N 36182N8382GArneson Kenneth W · Beaverton, ORS/N 15062482N8382JHouseknecht Thomas · State College, PABuilt 1967 · S/N 15066282N8382LMedina Solla Edwin O · Trujillo Alto, PRBuilt 1968 · S/N 17256582N8382SFitzwater Richard B · Athol, IDBuilt 1965 · S/N 18256482N8383BSpears Franklin L · Lebanon, KYBuilt 1957 · S/N 36183N8383MKessler Aviation LLC · Lansing, WVBuilt 1969 · S/N A1500083N8383QThompson Gordon H · Anchorage, AKBuilt 1978 · S/N 18503675N8383UBuzby Justin T · Wasilla, AKBuilt 1964 · S/N 17252283N8384GWoodall Steve W · Penngrove, CABuilt 1965 · S/N 15062484N8384JKondol Andrlej J · Maspeth, NYBuilt 1967 · S/N 15066284N8384M1st Clev-Mar LLC · Gainesville, TXBuilt 1969 · S/N A1500084N8384XVehrs Roger K · Roseburg, ORBuilt 1961 · S/N 17248884N8385BTkn Holdings LLC · Pima, AZBuilt 1957 · S/N 36185N8385JJones Stanley E · Vallejo, CABuilt 1967 · S/N 15066285N8385LKrebs Lisa Christine · Homer, AKBuilt 1968 · S/N 17256585N8385UClow Streeter M · Mansfield, OHFirst renewal noticeBuilt 1964 · S/N 17252285N8385ZHoneysett Robert E Jr · Anchorage, AKS/N 205-0385N8386ATwo Flyers LLC · Wilmington, DEBuilt 1952 · S/N 25238N8386GIndy Hot Air LLC · Westfield, INBuilt 1965 · S/N 15062486N8386JMyers Raymond R · Deer Park, WABuilt 1967 · S/N 15066286N8386LAdams Haidyn · Pentwater, MIS/N 17256586N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520N8386QLe Tourneau University · Longview, TXBuilt 1976 · S/N U20603247N8386SDavis Lawrence R · Kent, OHS/N 18256486N8386XSchool Board Of Leon County Florida · Tallahassee, FLBuilt 1961 · S/N 17248886N8387GAir Land And Sea Adventures LLC · West Palm Beach, FLBuilt 1965 · S/N 15062487N8387LSerra Christopher R · Snellville, GABuilt 1968 · S/N 17256587N8387URegistered aircraftBuilt 1964 · S/N 17252287N8388AHamm Simon P · Denali, AKBuilt 1953 · S/N 25240N8388BTouch And Go Inc · Center, COBuilt 1957 · S/N 36188N8388JCunningham Kevin M · Alexandria, MNS/N 15066288N8388MGreater Chattanooga Aviation Club LLC · Chattanooga, TNBuilt 1976 · S/N 18264601N8388SRose Mary R · Portland, ORBuilt 1965 · S/N 18256488
Back to AD 79-10-14 R1