OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N365DLSoehner Harold D · Winslow, AZBuilt 2009 · S/N DAL001N365DRPace Ryan · Morgan, UTBuilt 2023 · S/N 002N365MADip Aviation LLC · Fort Lauderdale, FLBuilt 1999 · S/N 18280582N365MEEhnisz Craig T · Monterey, CABuilt 2000 · S/N 18280855N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688N365NGReid Michael V · Sulphur Springs, TXBuilt 1968 · S/N 28-11124N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033N365PSFainer Jeffrey M · San Diego, CABuilt 1978 · S/N AA5A0552N365RWWalter Aviation · Perry, IABuilt 1990 · S/N 903N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783N365TGengarelly Robert M · Benson, AZBuilt 2011 · S/N 72419N365WCCrane Douglas F · Ukiah, CABuilt 2002 · S/N 18281170N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673N3660RBackcountry Wings LLC · Gig Harbor, WABuilt 1970 · S/N 28-5764N3661Mckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1969 · S/N 070N36615Booth Warren Russell · Doylestown, PABuilt 1978 · S/N 32-7840166N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286N3661EPiper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960071N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129N3661PBradham David T · Kenai, AKBuilt 1955 · S/N 22-3412N3661QLong Nathan J · Huntsburg, OHS/N MA-251N3661WPrete Vincent A · Jim Thorpe, PABuilt 1966 · S/N 32-568N36626Farrier John M · Tillamook, ORBuilt 1973 · S/N 411-74N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73N3662CArmi LLC · Nevada, IABuilt 1978 · S/N R18200297N3662RBevard Thomas E · Montross, VABuilt 1969 · S/N 28-5766N3662ZDaniel Dario M · Charlotte, NCBuilt 1960 · S/N 22-7560N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249N3664WSuffoletto Gregory · Hamburg, NYBuilt 1966 · S/N 32-572N3664XLurie Steven C · Delta, ALBuilt 1968 · S/N 314N3665CN3665c LLC · Otsego, MNBuilt 1978 · S/N R18200299N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817N3665NElt Aviation Inc · Peewee Valley, KYBuilt 1967 · S/N 680029N3665PHarness Jesse J · Peoria, AZS/N 18-4621N3665RDomke Kenneth M · Soldotna, AKBuilt 1954 · S/N 18-4112N3665WWitham Chris · Cathedral City, CABuilt 1966 · S/N 32-573N3666CStrauss Kenneth W · Vashon, WABuilt 1978 · S/N R18200300N3666KVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 22356N3666MLarson Samuel T · Anchorage, AKS/N 12-2616N3666QHighum Peter · Hernando Beach, FLBuilt 1967 · S/N MA-253N3666TOlson Ronnie E · Palmer, AKBuilt 1976 · S/N F-073N3666ZWedepohl Richard · Madison, WIBuilt 1960 · S/N 22-7564N3667PSlofly LLC · Red Lodge, MTBuilt 1955 · S/N 18-4624N3667QLife'S A Beech LLC · Wilmington, DEBuilt 1967 · S/N MA-269N3667RShamrock Aviation LLC · Broken Bow, NEBuilt 1970 · S/N 28-5771N3668KPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-23678N3668QPaul B Meadowbrook Pc · Albany, ORFirst renewal noticeS/N MA-255
Back to AD 87-10-06 R1