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.

N9707DPapke Brian D · Beulah, MIS/N 22-6619N9707LGriffith Jonathan E · Newark, NJBuilt 1971 · S/N MC-96N9707MCombs Charles D · Buffalo, MOBuilt 1967 · S/N 670267N9707PN B Tweet & Sons · Nome, AKBuilt 1975 · S/N 18-7509135N9707WBulger Edward P · Amesbury, MABuilt 1967 · S/N 28-23182N9708FDodson International Parts Inc · Rantoul, KSBuilt 1998 · S/N T20608008N9708JGautsch Michael J · Onalaska, WIBuilt 1967 · S/N 28-3899N9709BPeterson Air LLC · Chisago City, MNBuilt 1981 · S/N 172RG0982N9709DPearce Ricky · Parsons, KSBuilt 1959 · S/N 22-6621N9709KLkn Cherokee LLC · Mooresville, NCBuilt 1976 · S/N 28-7625191N9709MAndersen Michael S · Bensenville, ILBuilt 1967 · S/N 670269N9709QRobles Andres M · Plantation, FLBuilt 1970 · S/N MB-494N9709WStewart Glen W · Lebanon, TNBuilt 1967 · S/N 28-23184N970ACNaples Air Center Inc · Naples, FLBuilt 1980 · S/N 28-8116113N970LCMajeste Air LLC · Loveland, COBuilt 1979 · S/N 28-8016214N970PGJoyful Flight LLC · Madison, WIBuilt 2000 · S/N 452-2000N970WCCavorite Aviation LLC · Lehi, UTBuilt 2002 · S/N 2843522N970WMMartin James Louis Trustee · Reno, NVBuilt 2010 · S/N 70811N9710FAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280017N9710JThompson Stephen N · Hagerman, IDBuilt 1967 · S/N 28-3901N9710QBluesky A24r LLC · Nashville, TNBuilt 1970 · S/N MC-66N97116N97116 LLC · Hector, MNS/N 17276155N9711MKats Daniel L Jr · Labelle, FLBuilt 1967 · S/N 670271N9711PTop A Farms Inc · Benkelman, NEBuilt 1975 · S/N 18-7509116N9711UDakota Ear Nose & Throat Clinic Pc · Sturtevant, WIS/N AA1C0119N9711WChapman Darren P · Winter Haven, FLBuilt 1967 · S/N 28-23186N9712JBowers Nicholas M · Mount Hope, WIBuilt 1967 · S/N 28-3903N9712NKeller Gerald C · Kokomo, INS/N 156N9712UUnruh Ronald E · Pampa, TXBuilt 1976 · S/N AA5A-0112N9713DBallard Gary B · Leslie, ARBuilt 1959 · S/N 22-6625N9713PMeggers Roger D · Baker, MTBuilt 1975 · S/N 18-7509139N9713URoderick Richard · Farmington, NMBuilt 1976 · S/N AA5A-0113N9713WGiles Robert L · Columbia, SCBuilt 1967 · S/N 28-23189N9713YEsteban Rioufol Peralta · Houston, TXBuilt 1976 · S/N MC-396N9714DVermeire Calvin L · Soldotna, AKBuilt 1959 · S/N 22-6626N9714LWebaire LLC · Slidell, LABuilt 1971 · S/N MB-510N9714PGilman Robert L · Wasilla, AKBuilt 1976 · S/N 18-7709003N9714UWeyers Gregory J · Lakewood, WIBuilt 1976 · S/N AA5A-0114N97154Poddoubnyi Andrey Alexandrovich · Vista, CABuilt 1984 · S/N 17276160N9715CBragg Larry M · Kansas City, MOBuilt 1978 · S/N 28-7816520N9715DMccullough Robert · Carlton, WABuilt 1959 · S/N 22-6627N9715JFly By Faith LLC · Laurel Springs, NCBuilt 1967 · S/N 28-3906N97163Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276161N9716DKappele Arthur J · Crystal River, FLBuilt 1959 · S/N 22-6628N9716LOettmeier Bert W Jr Trustee · Leawood, KSBuilt 1971 · S/N MC-98N9716MAshton Flyers Inc · Ashton, IDBuilt 1967 · S/N 670276N9716PGreater Boston Soaring Club · Sterling, MABuilt 1975 · S/N 25-7556032N97172C P Aviation · Santa Paula, CABuilt 1984 · S/N 17276162N9717BCeruto Jorge · Auburndale, FLBuilt 1981 · S/N 172RG0987N9717CMiloud Chadd · Fort Worth, TXBuilt 1978 · S/N 28-7816522
Back to AD 87-10-06 R1