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.

N333HJSchlender Mike · Clintonville, WIS/N 39-29N333HMVia Vitae Aviation LLC · Lexington, KYBuilt 1981 · S/N 32R-8113096N333HTTiernan Barton M · Anchorage, AKBuilt 1979 · S/N 33380N333HYFrantz Paul B · Abbeville, GABuilt 1963 · S/N 30-174N333JDMountain Mojo Aviation LLC · Banner Elk, NCBuilt 1980 · S/N 27-8054016N333JFWolfe LLC · Rogers, TXBuilt 1963 · S/N 2493N333JGCuthbert Victor W · Dowagiac, MIBuilt 1964 · S/N TD-580N333JMKahl Fredric P · Monmouth, MEBuilt 1972 · S/N M-1404N333JSWarbird Adventures Inc · Ocoee, FLBuilt 1977 · S/N 612-77N333KMParker Michael A · Fowler, INBuilt 1987 · S/N 586N333KNKris Noone Air LLC · Wilmington, DEBuilt 1973 · S/N 17261426N333KRSimmons Anthony T · Easley, SCBuilt 1966 · S/N 1290N333KTSpringer Leasing LLC · Athens, GABuilt 1976 · S/N 32R-7680436N333LESky Photoshop LLC · Winter Garden, FLBuilt 2021 · S/N 2666N333LSBrown Richard G · Blanchard, OKBuilt 1978 · S/N 17271006N333LTGlover William S · Mount Pleasant, TXBuilt 1981 · S/N 495N333MGherardini Donald A · Sullivan, ILBuilt 2007 · S/N 90439N333MABadolato Leonard · Berlin, NJBuilt 1976 · S/N 28-7615116N333MDDunkel Matthew T · Port Orange, FLBuilt 1998 · S/N 070N333MHMerritt Hal S · Hilliard, FLBuilt 2001 · S/N 001N333MKSmith Craig A · Kokomo, INBuilt 1993 · S/N 27-0172N333MMDunlap Rodney L · Jonesboro, ARBuilt 2018 · S/N 40399N333MTGesl Gregg R · New Braunfels, TXBuilt 1968 · S/N 680142N333NPhillipson Justin M · Vacaville, CABuilt 2003 · S/N M-1-2023N333NCCapital Flying Inc · Elk Grove, CABuilt 1968 · S/N 28-5118N333NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881782N333NTKoerner Norman H · Roanoke, TXBuilt 1962 · S/N TD-515N333PBBourne Hoppe & Associates LLC · Midland, MIBuilt 1975 · S/N 27-7654013N333PGAty Aviation Inc · Watertown, SDBuilt 1977 · S/N 28R-7737114N333PHJ&L Management Group LLC · Lewes, DEFirst renewal noticeBuilt 1993 · S/N 2326N333PJHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2005 · S/N 3804N333PKPalmer Joe A · Meridian, IDS/N PK-2N333PRGriffin Wings LLC · Lithia, FLBuilt 1973 · S/N 31-7305112N333PYMatonti James Robert · Oklahoma City, OKS/N 28-7515380N333RAShepard Cameron J · Reading, PABuilt 1978 · S/N 3094N333RPBordelon Greg M · Houston, TXBuilt 1996 · S/N MII-1466N333RVJones Guy L · Albuquerque, NMBuilt 1980 · S/N 219N333RZJj Magic LLC · Wilmington, DEBuilt 2003 · S/N 10167N333SBSmythe John J III · Rch Palos Vrd, CAS/N 502HN333SEParis Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7350091N333SHVitez David D · Morgantown, WVBuilt 1969 · S/N 15070617N333SNHub City Aviation Academy LLC · Lubbock, TXBuilt 1966 · S/N 30-982N333SPBelote David Eldon Trustee · Elbert, COBuilt 1975 · S/N 17702265N333TMSkywagon Aero LLC · Wilmington, DEBuilt 1971 · S/N 18-8939N333TSAerostar Management Services LLC · Kissimmee, FLBuilt 1999 · S/N 172S8240N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099N333VRSpruce Home + Closet LLC · Southlake, TXBuilt 2016 · S/N 41228N333WHHarris Robert W · Covington, TNBuilt 1986 · S/N 333N333WPPhillips William R · Cullman, ALBuilt 2022 · S/N 80239N333WYJrm Wings LLC · Farmington, UTS/N 30-1800
Back to AD 87-10-06 R1