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.

N66352Seaplane Adventures LLC · Cheyenne, WYBuilt 1979 · S/N ME-251N66354Chesson Bradley S · Tacoma, WABuilt 1979 · S/N M-2214N6635BChandler Jerome P · Redondo Beach, CABuilt 1979 · S/N ME-245N6635DGooderum Mark P · Excelsior, MNBuilt 1979 · S/N MC-668N6635JIndian Head Flying Club LLC · Indian Head, MDBuilt 1968 · S/N 28-5102N6635PJohnston Robert J · Oro Valley, AZBuilt 1960 · S/N 24-1757N6635UBistline Ladell J Sr · Colorado City, AZS/N 130N6636DAnderson James M · Little Rock, ARS/N MC-690N6636LAoa Kissimmee Inc · Kissimmee, FLBuilt 1979 · S/N ME-256N6636TVincent Air LLC · Carroll, IABuilt 1979 · S/N ME-259N6636UBurcham Jaime S · Advance, NCBuilt 1963 · S/N 131N6636VMoss Herman D · Centreville, VABuilt 1970 · S/N 32-32N6637JCaison Rodney D · Carrollton, VABuilt 1968 · S/N 28-5105N6637PEbner Rudy · Orange, TXBuilt 1960 · S/N 24-1759N6638BAhmed Gedi A · Saint Paul, MNS/N M-2217N6638HWright Aero Inc · Saint Cloud, MNBuilt 1979 · S/N ME-266N66399Acord Aviation Co L L C · Chandler, OKBuilt 1983 · S/N 17275988N6639DBig Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2223N6639JColoski Dennis J · Marlton, NJBuilt 1968 · S/N 28-5106N6639PMustain Michael J · Monticello, GABuilt 1960 · S/N 24-1761N663ABBald Allan D · Alton, NHBuilt 2003 · S/N 80176N663AFSnelling Peter G · Thornton, PABuilt 1981 · S/N 28-8290060N663DHEmig Terry · Casa Grande, AZS/N 3505N663DXSouthtec Inc · Wilmington, DEBuilt 2002 · S/N 80663N663GMMitchell David · Carrollton, GABuilt 2007 · S/N GM-6N663NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881288N663RTRaiders Tigers Flying Club Inc DBA · Houston, TXBuilt 1975 · S/N 17265988N663RVPlaxco Mitchell O · Huntsville, ALBuilt 2005 · S/N 25201N663SMMacmoyle Scott · Blairstown, NJBuilt 1976 · S/N AA5B0370N663WTSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843128N66405Mh Aviation LLC · Foster City, CABuilt 1996 · S/N 783-96N6640HSolis Aviation LLC · Carroll, OHBuilt 1975 · S/N 17265520N6640JHeesch Donald · Nunn, COS/N 28-5107N6640PAlexander Paul S · Selma, ALBuilt 1959 · S/N 24-1762N6640VCarlsbad Raceway Corp · Hemet, CAS/N TF-1N6640WAldrich David G · Naples, FLBuilt 1965 · S/N 28-20739N6641JStratus Business Development LLC · Nashua, NHBuilt 1968 · S/N 28-5109N6641PMartinous Shawn A · Providence, RIBuilt 1960 · S/N 24-1763N6642JFive By Ten LLC · Loveland, COBuilt 1968 · S/N 28-5110N6642UCrawford Daniel G Trustee · Dryden, MIBuilt 1963 · S/N 137N6642WBrown Kevin D · Saint Louis, MOBuilt 1965 · S/N 28-20742N6643JJohnson Steve · Attleboro, MABuilt 1968 · S/N 28-5111N6643WWeiss Stephan T · San Jose, CABuilt 1965 · S/N 28-20743N6644BN6644b LLC · Cresson, TXBuilt 1958 · S/N 35744N6644MSierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17260503N6644YN6644y LLC · Philomath, ORBuilt 1968 · S/N 27-3958N6644ZKing Jonathan R · Palmer, AKBuilt 1950 · S/N 18-362N6645AAlmost There Air LLC · Daytona Beach, FLBuilt 1978 · S/N 27-7954029N6645JMcdonald Neill F Jr · Fairfax, VABuilt 1968 · S/N 28-5131N6645UFreemont Investors Inc · Bainbridge Island, WAS/N 140
Back to AD 87-10-06 R1