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.

N823MLLaidlaw Leslie G · Mankato, MNBuilt 2021 · S/N 0049N823MXEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 2573N823NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881162N823PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881250N823PBBrown Scott · Aguanga, CABuilt 1979 · S/N 49N823PPPsm Aviation LLC · Lewes, DEBuilt 1975 · S/N M-1650N823RVScott J Pias · Raleigh, NCS/N 81368N823SPUberti Christopher · Brighton, MIBuilt 1976 · S/N 24-0003N823SSArchipelago Immobilien LLC · Jacksonville Beach, FLBuilt 2000 · S/N 0001N823SWMiley Gregg E · Melba, IDBuilt 2000 · S/N 24000N823TRAirknocker Inc · Wilmington, DEBuilt 2013 · S/N 11487N823WWHoffman Richard D · Waterford, WIBuilt 1997 · S/N 20017N82405Womack Bert E · Anchorage, AKBuilt 1979 · S/N 18-7909096N8240DLindee Justin T · Owatonna, MNBuilt 1980 · S/N 28-8011125N8240ESimplelife Skys LLC · Van Buren, ARBuilt 1980 · S/N 28-8011126N8240NStein Kenneth A · Rapid City, SDBuilt 1969 · S/N 28-25448N8240PForsgren Keith · Wasilla, AKBuilt 1963 · S/N 18-8045N8240WGeiger Nathaniel · Omaha, NES/N 28-2383N8241ABaloga David M · Payson, AZBuilt 1982 · S/N 32R-8229060N8241CL & S Aircraft Holdings LLC · Yukon, OKBuilt 1975 · S/N 28-7690109N8241PRegistered aircraftBuilt 1963 · S/N 24-3495N8241WLuckey Jeffrey E · Camarillo, CABuilt 1965 · S/N 28-2385N8241ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316079N82422Bishop Boyd · Gillette, WYBuilt 1979 · S/N 18-7909098N82423Aeronautical Development LLC · Richland, MIBuilt 1980 · S/N 28-8011127N82424Skow Perry M · Harrison, IDS/N 18-7709163N8242NBrezina Douglas P · Broadview, ILBuilt 1969 · S/N 28-25450N8242PLake Donald T · Green Valley, AZFirst renewal noticeBuilt 1963 · S/N 24-3496N8243EMacon Air LLC · Franklin, NCBuilt 1979 · S/N 17272155N8243LFieri Doug · La Verne, CABuilt 1980 · S/N 32-8024035N8243PMountain Mooney Inc · Idaho Falls, IDS/N 24-3497N8243WHill Andrew M · Spokane, WAS/N 28-2389N8243YHampton Brent · Edgewood, TXBuilt 1966 · S/N 30-1369N82443Dolat Jacqueline M · Kenai, AKBuilt 1977 · S/N 18-7709166N82448Fejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 18-7909099N8244JTonys Aerial Service Inc · Great Bend, KSBuilt 1979 · S/N 61P06487963299N8244PWright Russell · Ocala, FLBuilt 1964 · S/N 24-3499N8244SExtreme Helicopter Service LLC · Alice, TXBuilt 1994 · S/N 2430N8244UFaherty Michael F · Greensboro, NCBuilt 1980 · S/N 28-8016371N8244VVaughn Anthony D · Monticello, KYBuilt 1980 · S/N 32-8006063N8244XDestiny Ministries International Inc · Kissimmee, FLS/N P648RN8244YDow Jeff · Port Hadlock, WABuilt 1965 · S/N 30-917N82452Snyder Matthew A · Tok, AKS/N 18-7809139N82453Zimmerman Tyler J · Sterling, AKBuilt 1978 · S/N 18-7809179N82455Gmt Enterprises LLC · Naknek, AKBuilt 1980 · S/N 32-8006079N82456Ajk Aircraft LLC · Xenia, OHBuilt 1980 · S/N 32-8006080N82457Cassella Matthew Victor · Branford, CTBuilt 1980 · S/N 32-8006081N8245CVector Aviation LLC · Mentor, OHBuilt 1980 · S/N 28-8090372N8245NShimei Mark A · Titusville, FLBuilt 1969 · S/N 28-25454N8245WJ & L Aircraft Rentals Llctrust · Oxford, GABuilt 1965 · S/N 28-2391
Back to AD 87-10-06 R1