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.

N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021N227RJFrost Cavin B · Odessa, TXS/N 18280383N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085N227RVSoule Stephen J · Waterbury Center, VTBuilt 2001 · S/N 24293N227SFSager Charles K · Hedgesville, WVBuilt 2000 · S/N 437-2000N227THPristatskly Roman · Ivyland, PAS/N 227N227WDPowell David C · Ingram, TXBuilt 1990 · S/N 4622097N227WFTrayler James · Waco, TXBuilt 2004 · S/N T18208288N227WZ7wz LLC · Calhoun, GAS/N 61P07488063369N227XYMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881571N227YReese Michael · Phoenix, AZBuilt 2007 · S/N 20351N227YZTurtle Partners II LLC · Providence, RIBuilt 2002 · S/N 25078CN2280TRegistered aircraftBuilt 1977 · S/N R18200016N2281QFreeman Michael J · Chillicothe, OHBuilt 1977 · S/N 28-7716096N2281SHyce Richard A · Wasilla, AKBuilt 2015 · S/N TC0604103N2281TAvpac Insurance Services Inc · Santa Ana, CABuilt 1977 · S/N R18200017N2282Inverted Taildragger LLC · Dover, DEBuilt 2018 · S/N 1904N2284DKellner Aaron · Bloomfield, CTBuilt 1995 · S/N 1N2284PChickasha Wings Inc · Chickasha, OKBuilt 1957 · S/N 23-895N2284TKenley Clay · Crockett, TXBuilt 1977 · S/N R18200019N2284UAttitude Toys LLC · Wilmington, DES/N 454N2284YBorn Daniel P · Lawrence, KSBuilt 1967 · S/N 17700084N2285YKrid Cardinal LLC · Centerville, INBuilt 1967 · S/N 17700085N2286MRegan Herbert George · Gowen, MIBuilt 1977 · S/N 28-7816271N2287AGiacopassi Dean · Newport News, VABuilt 2002 · S/N 40.226N2287CKounovsky Jerry F · Tucson, AZBuilt 1967 · S/N 272N2287P250 Flyers LLC · Middletown, DEBuilt 1957 · S/N 23-898N2288FJ&Jn2288 LLC · Houston, TXBuilt 2018 · S/N 25428N2288PChisum Robert · Lorenzo, TXS/N 23-899N2288QMidnight 30 LLC · Columbia, MSBuilt 1977 · S/N 32R-7780242N2288TRegistered aircraftBuilt 1966 · S/N 670204N2288ULay Jerry K · Minonk, ILBuilt 1966 · S/N 459N2288ZMaxwell Robert H Jr · Quincy, FLS/N 28-2196N2289ABauer Melchior E · Vallejo, CAS/N 22-677N2289MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816274N2289UEastern Stearman Inc Trustee · Leesburg, VABuilt 1966 · S/N 460N228AMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 28-7990544N228ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274354N228ARHurricane Creek Flying Club LLC · Walla Walla, WABuilt 1979 · S/N 17273580N228CABowles Thomas J · Prairie Village, KSBuilt 1981 · S/N R18201686N228CJSplashin LLC · White Lake, MIBuilt 1977 · S/N 17269610N228CMKittleson Allen F · Granbury, TXBuilt 1973 · S/N 73-31058N228ERRoscioli Lamberto · Lighthouse Point, FLBuilt 1992 · S/N 10119N228FPRegistered aircraftS/N 24-2538N228GHopkins Boone K · Saint Simons Is, GAS/N 612N228GGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 28-7990387N228HPLance Reid Enterprises LLC · Turlock, CABuilt 1980 · S/N R18201643N228HSSweeney David H · Houston, TXBuilt 2003 · S/N T20608419N228JLLeslie John F · Newark, DEBuilt 2006 · S/N 970N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711
Back to AD 87-10-06 R1