OpenAirDocs.org
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.

N4798LThompson Michael · Stacy, MNS/N 28-4136N4798SEller Donald B · Palmer, AKBuilt 1969 · S/N 32-1183N4798THrv Holdings LLC · Camp Hill, PABuilt 1972 · S/N 28-7205196N47995Raab David A · York, PABuilt 1977 · S/N 28-7890168N4799PPlayer Dennis · Union Bridge, MDBuilt 1960 · S/N 27-359N4799SMiller Charles B · Pass Christian, MSBuilt 1969 · S/N 32-1184N4799TSale Reported · Omaha, NESale reportedBuilt 1972 · S/N 28-7205197N4799WHudson Kelsey L · Snohomish, WABuilt 1977 · S/N 14119N479ACVick Vernon A · Dublin, OHBuilt 1999 · S/N 427-99N479BKTensas Taildraggers LLC · Saint Joseph, LABuilt 2017 · S/N 153N479CBIsland Air LLC · Dover, DEBuilt 1979 · S/N 61P06427963296N479CNFlight World Inc · San Juan, PRBuilt 1975 · S/N 17266007N479FLImmell John A · Chillicothe, OHBuilt 1971 · S/N 28-7125285N479JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020079N479NTFlight World Inc · San Juan, PRBuilt 1975 · S/N 17265279N47ACReabe Aircraft Improvement Inc · De Pere, WIBuilt 1974 · S/N 3200N47AFL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281041N47ASM D Ham LLC · Conover, NCFirst renewal noticeBuilt 1998 · S/N 21048CN47ATPutman William C · Bigfork, MTS/N 147N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N47BLLade Burton G · Bemidji, MNBuilt 2010 · S/N 003N47BNCavorite Aviation LLC · Lehi, UTBuilt 1995 · S/N 28-43020N47CTSweetwater Flyers LLC · Emporia, KSBuilt 1972 · S/N 17701769N47CWPetersen Alfred Charles · Buffalo Grove, ILBuilt 1986 · S/N 840N47DCL&D Joint Sealing LLC · Fairbury, NEBuilt 1985 · S/N 3515N47DERichards Ronald W · Grant City, MOBuilt 1996 · S/N 23106N47DHBeard Donald Ray · Bulverde, TXBuilt 1983 · S/N 129N47DLFairley Michael L · Shawnee, KSS/N 608-320-354N47ECRv Aviation LLC · Wilmington, DEBuilt 2009 · S/N 5130N47EEGt Aviation Solutions LLC · Mount Juliet, TNS/N 27-2009N47ER15 East Management Inc · Wake Forest, NCBuilt 2002 · S/N 4636340N47EZRinell Eric S · San Luis Obispo, CABuilt 2020 · S/N 0002N47GHBrennan William · Bethpage, NYBuilt 1969 · S/N 32-40766N47HJWhite Billy C · Baker, FLBuilt 1987 · S/N 476N47HYJoseph C Thomas · Lenoir, NCBuilt 2000 · S/N 2054N47JEHurley Nicholas John · Trinity, NCBuilt 1977 · S/N 32R-7780532N47JGCorcoran Peter A · Fallbrook, CABuilt 1976 · S/N 47N47JLElliott David Robert · San Jose, CABuilt 1996 · S/N 3923N47JQJaquish William E · Tunkhannock, PABuilt 2003 · S/N 2109N47LMelugin Michael R · Manteo, NCBuilt 1977 · S/N 0770N47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1979 · S/N 28-7990480N47LULetourneau University · Longview, TXBuilt 2017 · S/N 4496416N47MEN47me LLC · Tampa, FLBuilt 1981 · S/N 6008848161250N47MKAztec Aviation Two LLC · Augusta, GABuilt 1973 · S/N 27-7305122N47MLWitt Jerry D III · Houston, TXBuilt 1956 · S/N 22-3865N47MMNorstar Aviation LLC · Farmingdale, NYBuilt 1977 · S/N 31-7812036N47NLAnton Billy V · Satanta, KSBuilt 2018 · S/N 135BN47NZFish Dwain E · Silver Springs, NVS/N 1947N47PGRandall Skye Sanjay · Lansdowne, PABuilt 1977 · S/N AA5A0340N47PLGreer Wesley E · Woodstock, GABuilt 2008 · S/N 72157
Back to AD 87-10-06 R1