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.

N9693DNewberg Curtis · Willmar, MNBuilt 1958 · S/N 18-6794N9693HClear Creek Aviation LLC · Buffalo, WYBuilt 1975 · S/N 17266318N9693MHiggins Michael · Pasadena, CABuilt 1967 · S/N 670029N9693PStewart Jonah M · Wasilla, AKBuilt 1975 · S/N 18-7509037N9693QHughes Ronnie D · Cedar Park, TXBuilt 1975 · S/N 17265777N9693VRabideau William J III · Stafford Springs, CTBuilt 1974 · S/N 17264472N9693WDelaney Kevin P · Germantown, TNBuilt 1967 · S/N 28-23165N9694HFitch William R · Dubuque, IABuilt 1975 · S/N 17266319N9694JEli Team 6 Air Services LLC · Madisonville, TNBuilt 1967 · S/N 28-3883N9694LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276598N9694PBocek James C · Sheridan, WYBuilt 1975 · S/N 18-7509038N9694QBexbach North America LLC · Reno, NVBuilt 1975 · S/N 17265778N9694VHaller Patrick C · York, SCBuilt 1974 · S/N 17264473N9694WBertsch Brian · Seeley Lake, MTS/N 28-23166N9695CTrhb Enterprises LLC · Danville, PABuilt 1978 · S/N 32-7840112N9695DPc Flyers LLC · Post Falls, IDBuilt 1959 · S/N 18-6798N9695HGoddard Robert J · Haverhill, MABuilt 1975 · S/N 17266320N9695JVaughn Gary Petty · Sanger, TXBuilt 1967 · S/N 28-3884N9695PTop Hand Inc · Laurel, MTBuilt 1975 · S/N 18-7509039N9695SPearson Lemuel H · Maxwell, CABuilt 1966 · S/N 81N9696FShakman Michael L Trustee · Chicago, ILBuilt 1998 · S/N 18280269N9696HMirror Image Inc · Belgrade, MTBuilt 1975 · S/N 17266321N9696LAny Border LLC · Yankton, SDBuilt 1986 · S/N 17276599N9696XCurrier Dustan A L · Fairbanks, AKS/N CCK-1865-0061N9697DWarner Carl P · Lindley, NYBuilt 1959 · S/N 22-6607N9697PDubious Adventures II LLC · Big Lake, AKBuilt 1975 · S/N 18-7509040N9697SMelton Aviation LLC · Allen, TXBuilt 2005 · S/N 3257409N9697VWestern Edge Aviation LLC · Dickinson, NDBuilt 1974 · S/N 17264476N9697YAfterburner Aviation LLC · Lewes, DEBuilt 1963 · S/N TD-526N9698HEagle Simulator LLC · Lake Oswego, ORBuilt 1975 · S/N 17266322N9698JWalters Max D · Lamar, MOBuilt 1967 · S/N 28-3887N9698MCiota Shane · Tucson, AZBuilt 1967 · S/N 670245N9698SLindgren Darrell A · Lake Nebagamon, WIBuilt 1966 · S/N 47N9698VVermont Flight Academy Inc · South Burlington, VTBuilt 1974 · S/N 17264477N9698WCas Ltd · Swanton, VTBuilt 1967 · S/N 28-23171N9699DKelly Michael J · Port Orange, FLBuilt 2003 · S/N 80805N9699JTrevino Alberto O · Vero Beach, FLBuilt 1967 · S/N 28-3888N9699VPiercy Danille Marie · North Bay Village, FLBuilt 1974 · S/N 17264478N969DBBristol David W · Sautee Nacoochee, GABuilt 1969 · S/N 28-26197N969DGDelta Sierra Avia Inc · West New York, NJBuilt 1967 · S/N 680117N969DMFlying Cracker LLC · Wilmington, DEBuilt 2007 · S/N 14122CN969DRReeder Don W · Rathdrum, IDBuilt 2009 · S/N 1001N969EZCommand Air LLC · White Salmon, WAS/N 25070CN969FHoke Mitchell · Boulder, COBuilt 1999 · S/N 80371N969GFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 0486N969JHJls Aviation LLC DBA · Fredericksburg, VABuilt 1979 · S/N 17273547N969JSSwanstrom John Trustee · Santa Rosa, CABuilt 2012 · S/N 91718N969LAJackson Aviation Of South Georgia LLC · Thomasville, GABuilt 1967 · S/N 28R-30138N969MGRas Aviation LLC · Elyria, OHS/N TD-553N969NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881923
Back to AD 87-10-06 R1