OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N222DUCg 340 LLC · Fountain Hills, AZBuilt 1973 · S/N 27-7305046N222ECInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 1-0041N222ESThakkar Ravi R · Charlotte, NCBuilt 2003 · S/N 80282N222EWGuzman Steven M · Port Saint Lucie, FLS/N 23-1539N222FGoddspeed LLC · Encinitas, CABuilt 2000 · S/N T20608154N222FLPerkins Dwight L · Oklahoma City, OKBuilt 1970 · S/N 28-26582N222GBJames David L DBA · Auburn, CAS/N 61P-0255-047N222GDSolverson Aircraft Management LLC · Waunakee, WIS/N 2185N222GESmith Daniel J · Mcmurray, PABuilt 1975 · S/N 32-7500020N222GFFischer Edward T · Appleton, WIBuilt 2002 · S/N 40.230N222GGLangley Richard A · Sheyenne, NDS/N 120-HN222GHConcho Aviation LLC · Sterling City, TXS/N 0714N222GTCrosswind LLC · Wilmington, DEBuilt 2007 · S/N 24714N222HHitchcock Duane B · Burlington, COBuilt 1997 · S/N 222N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670N222HMAmerican Saddlair LLC · Park City, UTBuilt 1994 · S/N 27-0183N222HPHarrison Walter E · Taylor, TXBuilt 1982 · S/N R18201881N222HUPlane Nutz LLC · Sugar City, IDBuilt 2003 · S/N 2238N222JAJeff Abrams LLC · Ocala, FLBuilt 2000 · S/N 3062N222JDAcro Aviation LLC · Littleton, COBuilt 1983 · S/N 5016N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215N222JLThomas Kent C · Muncie, INBuilt 1973 · S/N 32-7340135N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097N222KKBymers Gary E · Waunakee, WIS/N 222N222KLLohmueller Kurt M · Powder Springs, GABuilt 2005 · S/N 21308N222KMKomoroski Edward J · Frenchtown, NJBuilt 1990 · S/N 337N222KRSharon Carl G · Brookshire, TXBuilt 1979 · S/N 24-0773N222KSTriple Two Inc · Wilmington, DEBuilt 1976 · S/N 28-7790270N222LEHigh View Air LLC · Driftwood, TXBuilt 1965 · S/N 1525-187N222LKCoulter Lance A · Meeker, COBuilt 2009 · S/N 40262N222LYLava Tech LLC · St George, UTBuilt 2010 · S/N 91629N222MJHonore Breen Aviation LLC · Allegan, MIS/N 12-1905N222MMYount Patrick G · Buckeye, AZBuilt 1991 · S/N 27-0086N222MNMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881532N222MTJw182 LLC · Kalispell, MTBuilt 1998 · S/N 18280108N222NARodriguez Lukas · River Oaks, TXBuilt 1974 · S/N 28-7415226N222NDPlane Nonsense Inc · Middletown, DEBuilt 2001 · S/N 2842111N222NLLawson Lonnie B II · Linden, PABuilt 2001 · S/N 25137N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473N222PCSmith Dustin L · Corinth, MSBuilt 1987 · S/N 1N222PFStokes Brian L · Boulder City, NVBuilt 1979 · S/N R18201308N222PJSchroeder James L · Rapid City, SDBuilt 1973 · S/N 28-7305259N222PPPreferred Landing LLC · Tomball, TXBuilt 1978 · S/N 32R-7985013N222PWWelch Michael C · El Dorado Hills, CABuilt 1990 · S/N 155N222RACaptain Rick LLC · Miami Lakes, FLBuilt 1973 · S/N 28R-7435127N222RJAmbrose James · Dyersburg, TNBuilt 1977 · S/N 22-1438N222RKMiller Bruce · Plano, TXBuilt 1974 · S/N 448-74N222RVWyatt Jacob A · Ogallala, NEBuilt 1992 · S/N 2305N222SNNorris Jason M · Smyrna, TNBuilt 1969 · S/N 31004
Back to AD 87-10-06 R1