AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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.

N932UWRegistration Pending · St George, UTRegistration pendingBuilt 2022 · S/N 40119N932WSMarg Aviation Enterprises LLC · Lawrenceburg, TNS/N 0296N932WTRose Doug · Anderson, INBuilt 2013 · S/N 90747N932XWoodward Chris Calvin · Arvada, COS/N 0199012N9330BCarpenter Michael R · Wasilla, AKBuilt 1959 · S/N 55130N9330JTinaga Resorts Corp · San Angelo, TXS/N 28-3424N9330VWest Daryl DBA · Kirkland, WABuilt 1969 · S/N 700003N9330WMarcy Michael S · Farmington, NMBuilt 1968 · S/N 28-11014N9331JSkysight Consulting LLC · Memphis, TNBuilt 1966 · S/N 28-3428N9331PAmra Nabil · Chaska, MNS/N 24-4829N9331VMartin Edward J · Poplar Grove, ILBuilt 1969 · S/N 700002N9331WBallou Wesley S · Houston, TXS/N 28-11015N9332DMartin Clint R · Escondido, CABuilt 1958 · S/N 22-6352N9332JKnutson Wayne R · Thompson, NDBuilt 1966 · S/N 28-3429N9332MKasakoff Lloyd · Diamond Bar, CAS/N 1264N9332NSloan Donald W · Dover, DEFirst renewal noticeBuilt 1969 · S/N 28R-35032N9332WWicker Kevin N · Beechgrove, TNBuilt 1967 · S/N 28-11016N9333FFire Bird Aviation Inc · Vivian, LAFirst renewal noticeBuilt 1964 · S/N 34-0040N9333JRau Alan · Java, SDBuilt 1966 · S/N 28-3430N9333MMalaka Air LLC · Bradenton, FLBuilt 1966 · S/N 1265N9333NGlendale Community College · Glendale, CABuilt 1969 · S/N 28R-35033N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831N9333VFletcher Jeffrey A · Belle Chasse, LABuilt 1963 · S/N 53-0207N9333ZLong Todd A · Maple Plain, MNBuilt 2008 · S/N 1010N9334CBadzinski James P · Roseville, MNBuilt 1978 · S/N 28-7816461N9334HFree State Flying Club · College Park, MDBuilt 1975 · S/N 17266092N9334MLee Gary L · Aberdeen, IDBuilt 1966 · S/N 1266N9334NRoberson Ronald M · High Ridge, MOBuilt 1969 · S/N 28R-35040N9334RMirolla Michael · Lake Balboa, CABuilt 1979 · S/N R18200692N9334SFontaine & Associates Inc · Pearl, MSBuilt 1975 · S/N MC-347N9334VSwope William T · Georgetown, OHS/N 700003N9335MPerry Christopher T · Eugene, ORBuilt 1966 · S/N 1267N9335SKeep Climbing LLC · Las Vegas, NVS/N M-1642N9336DSitta Donald C · Farmington, NMS/N 22-6356N9336MRioux Roger J · Corpus Christi, TXBuilt 1966 · S/N 1268N9336WForbes Eric L · Pahrump, NVBuilt 1968 · S/N 28-11021N9337CLovett Zachary · Fort Worth, TXBuilt 1978 · S/N 28-7816462N9337DNantz William G Jr · Raleigh, NCBuilt 1958 · S/N 22-6357N9337EMarianas Air Transfer Inc · Saipan, MPBuilt 1979 · S/N 17272230N9337HLorraine'S Blue Sky Aviation LLC · Norman, OKBuilt 1975 · S/N 17266095N9337JHudson Kenneth J · Caswell Beach, NCBuilt 1966 · S/N 28-3434N9337KSkyrise Aviation Corp · Pompano Beach, FLBuilt 1976 · S/N 28-7625176N9337NHoward Robert L · Jacksonville, NCBuilt 1969 · S/N 28R-35037N9337PWesterfield John III · Birmingham, ALBuilt 1969 · S/N 24-4835N9337SDalton Stephen P · Lewistown, PABuilt 1975 · S/N M-1655N9338BTopp Jason · Grace City, NDBuilt 1981 · S/N 172RG0799N9338CSmart4 LLC · Kissimmee, FLBuilt 1978 · S/N 28-7816463N9338HSchab Davis Maragaret A · Spangle, WABuilt 1975 · S/N 17266096N9338JCarr Shelby · Stevenson, ALBuilt 1966 · S/N 28-3435N9338NForker Thomas S · Williamsport, PABuilt 1969 · S/N 28R-35038
Back to AD 87-10-06 R1