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.

N3225RHansen Duane D · Rockford, ILBuilt 1969 · S/N 28R-31134N3225WCherokee Aero Group Inc · Lakeland, FLBuilt 1965 · S/N 32-33N32265Norsesian Brandon · Valrico, FLBuilt 1974 · S/N 28-7525040N32267Top Flight Aviation LLC · Reedsburg, WIBuilt 1974 · S/N 28-7515105N32269Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7515106N3226NDeuel Justin R · Mankato, MNS/N 243N3226WAlbert James R · Corpus Christi, TXBuilt 1965 · S/N 32-34N32271Tylka Edward · Lockport, ILBuilt 1974 · S/N 28-7505044N32274Simaan Daniel · Fontana, CABuilt 1974 · S/N 28-7525042N32276Price Company · Spokane, WABuilt 1974 · S/N 28-7515109N3227CSnider Frederick A Jr · Morgantown, WVBuilt 1978 · S/N R18200258N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475N3227MParker Shon T · Wasilla, AKBuilt 1947 · S/N 12-2108N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114N3227QBrands Robert C · Cary, NCS/N 32R-7780299N32288Habzansky Michael E · Greens Fork, INBuilt 1974 · S/N 287515112N3228PPopejoy Marc · Fort Scott, KSBuilt 1958 · S/N 24-294N3228QR&G Aviation LLC · Jonesboro, ARS/N 32R-7780300N32291Active Pilot Inc · Van Nuys, CABuilt 1974 · S/N 28-7515114N32292Mdr Rental Corp · Ann Arbor, MIBuilt 1974 · S/N 28-7515115N32293Stone James B · Springfield, VABuilt 1974 · S/N 28-7505046N32294Cloud Dancer Aviation Inc · Deland, FLBuilt 1974 · S/N 28R-7535041N32296Fly South Aviation LLC · Charlotte, NCBuilt 1974 · S/N 28-7525046N32299Lundahl Kristina N · Windsor, COBuilt 1974 · S/N 28-7515116N322ALHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2004 · S/N 10559N322ASHenning Kurt D · Auke Bay, AKBuilt 2000 · S/N 18049CN322ATAbkadirov Tagir · Tampa, FLS/N 1524N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231N322BWRobl Christopher · Littleton, COBuilt 2003 · S/N 026N322CARoyal Majesty Aviation LLC · Atlanta, GAS/N 28R-7130013N322CHRayworth Lyle D · Carrollton, GAS/N 82992N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545N322DRMcgrath James T · Campbell, CABuilt 2005 · S/N 81291N322DWAutry Michael D · Metuchen, NJBuilt 2015 · S/N 11384N322ERucinski Thomas · Paramus, NJBuilt 1992 · S/N 698-93N322EFRkm Aviation · Lexington, NCBuilt 2021 · S/N 28020031N322GEPierce Michael W · Leitchfield, KYS/N 0934N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096N322JK & M Aviation LLC · West Liberty, KYS/N 24-1316N322KLBuyair LLC · Valdosta, GAS/N 10220N322MEMast Enterprises Equipment LLC · South Boston, VABuilt 1989 · S/N 4622064N322MLAshcraft Aviation LLC · Bay City, TXS/N 3572N322MMRiver Transport LLC · Redlands, CABuilt 2002 · S/N T18208126N322NDUn Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881749N322RAEuroamerican Development Group Inc · New York City, NYBuilt 1978 · S/N 13053N322SHelfrick Edward W Jr · Elysburg, PABuilt 1995 · S/N 2005N322TBBlack Nelson T · Temple, TXBuilt 2010 · S/N 1N322TEEschmann Tim · Novinger, MOBuilt 2004 · S/N 18281372N322TMSkywagons.Com LLC · Placerville, CABuilt 1991 · S/N 27-0084N322WNo Business LLC · Kalispell, MTBuilt 1978 · S/N 32R-7887190
Back to AD 87-10-06 R1