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.

N45132Jamesweathers Robi J · Blaine, MNS/N 15076747N4513BBishop Robert W · Celina, TXBuilt 1955 · S/N 31412N4513CSlowpoke Air LLC · Palm Harbor, FLS/N 25457N45143Fly Sky Ads LLC · Manalapan, NJBuilt 1975 · S/N 15076753N45156Flight Training Solutions LLC · Longwood, FLBuilt 1975 · S/N 15076760N4515BWestern Parachute Sales Inc · Eagle Creek, ORBuilt 1955 · S/N 31414N45166Jet Life LLC · Coconut Creek, FLS/N 15076764N45169Carlisle Elizabeth L · Mohnton, PABuilt 1975 · S/N 15076766N4516CStahlman Michael J · Portland, ORBuilt 1952 · S/N 25460N4516USteelman Aviation LLC · Montague, CAS/N 15060516N45170Smits Joel R · Crete, ILBuilt 1975 · S/N 15076767N4517B4517b Holding Group LLC · Moses Lake, WAS/N 31416N4517CHainline Thomas D · Sumter, SCBuilt 1952 · S/N 25461N4517FAeropod Inc · Aurora, COS/N 185-1001N45188Arias Armando D · Santa Cruz, CABuilt 1976 · S/N 177RG1095N4518CLongden Earl W · Spirit Lake, IDBuilt 1954 · S/N 25462N45190Violette Colin E · Rough And Ready, CABuilt 1975 · S/N 15076777N45193Bostwick James · Melrose, NMBuilt 1976 · S/N 177RG1096N45198Ebe Aviation LLC · Urbandale, IABuilt 1975 · S/N 15076781N451BA1928 LLC · Salmon, IDBuilt 2005 · S/N 18281645N451CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282194N451NACooke J C Jr · Crystal Springs, MSBuilt 1969 · S/N 18259546N451SWAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1960 · S/N 50885N45203November 45203 LLC · Waterbury Center, VTBuilt 1975 · S/N 15076784N4520FRegistered aircraftBuilt 1966 · S/N 185-1005N4521BWitthaus James K Jr · Anchorage, AKBuilt 1955 · S/N 31420N4521URodriguez Sergio · Rancho Cucamonga, CAS/N 15060521N4522CEvans Michael R · Nome, AKS/N 25466N45230Zutter Regan James · Hooper, UTBuilt 1975 · S/N 15076793N45235Grimes James R · Carlton, GAS/N 15076796N45237Defrees Brooks H · Boulder, COBuilt 1975 · S/N 15076797N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467N45243Keas Kirby Clay · Lakeway, TXS/N 15076800N45245Rimar Dale S · Boca Raton, FLS/N 15076802N45246Carlsen Brent R · Rochester, MNBuilt 1975 · S/N 15076803N45247Airgo Inc · Centralia, ILBuilt 1975 · S/N 15076804N45248Lewis Steven A · Mesa, AZBuilt 1976 · S/N 177RG1098N4524CMcateer Kristina · East Greenwich, RIS/N 25468N4524UJennett Chris · Hudson, FLBuilt 1964 · S/N 15060524N45250Thiele Klaus U · San Diego, CABuilt 1976 · S/N 177RG1099N45256Albertson James M · Westville, FLBuilt 1975 · S/N 15076808N45262Wyoming Aviation Association Inc · Cheyenne, WYBuilt 1975 · S/N 15076811N45263Ruder Bonita E · Maple Park, ILBuilt 1975 · S/N 15076812N4526CWhitson Ryan L · Audubon, NJS/N 25470N4526UDrewelow Kevin R · Topeka, KSBuilt 1964 · S/N 15060526N45270Lessley Gavin W · Carrollton, MSBuilt 1975 · S/N 15076815N45274Robinson Charles F · Portage, MIFirst renewal noticeBuilt 1975 · S/N 15076817N45277Fritz Kurt C · Montoursville, PABuilt 1976 · S/N 177RG1100N4527BKrogman Aerial Spraying Inc · Lake Lillian, MNBuilt 1955 · S/N 31426N4527UToth Karl A · Fair Oaks, CABuilt 1964 · S/N 15060527
Back to AD 79-10-14 R1