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.

N979DJJirak Daniel L · Wasilla, AKBuilt 2023 · S/N 1001N979FMMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1995 · S/N S1713N979LWLapp Daniel · Lincoln, NHBuilt 2002 · S/N 468-2002N979PMGeyer Patrick H · Metamora, MIBuilt 2024 · S/N 74657N979PTCappe Ivestment Group LLC · Homestead, FLBuilt 1974 · S/N 17264503N979SAShafer Ian · Tabernacle, NJBuilt 1976 · S/N 32R-7680339N979SFMaus Stephen N · Bozeman, MTBuilt 2004 · S/N T18208286N97AABentham Gordon M · Katy, TXBuilt 1999 · S/N 4636235N97ACReber Tim · Terrace Park, OHBuilt 1993 · S/N 706-93N97ADCunningham David · Thomasville, NCBuilt 1967 · S/N 28-22666N97AFArmstrong Aviation LLC · Ogallala, NEBuilt 1997 · S/N 2118N97APTruitt James B · Evansville, INBuilt 2011 · S/N 82099N97BCGuy George Hopkins III · Saratoga, CABuilt 2008 · S/N 510-2008N97BMZawodny Jeremy D · Groveland, CABuilt 1997 · S/N 5342N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475N97CREsmailka Harold E DBA · Ruby, AKBuilt 1977 · S/N 32R-7780078N97CXGold Aero Aviation LLC · Tampa, FLBuilt 1997 · S/N 4636128N97DJSilva Ronald C · Rescue, CABuilt 1995 · S/N 23257N97DVWaugh Terry R · Phoenix, AZBuilt 1977 · S/N AA5B0455N97ECCollum Auto Transport LLC · Milton, FLBuilt 1995 · S/N 0019N97EEMcnary Richard C · Eatonville, WAS/N 92075N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188N97FSFlying S Inc · Palestine, ILBuilt 2021 · S/N PX1520012N97FZRegistered aircraftBuilt 1997 · S/N 79697N97GBTaf Aerial Servics LLC · Beeville, TXBuilt 1996 · S/N 14089CN97GCMohr Ronald G · Trenton, SCS/N 25611N97GHHoward Gregory · Beaverton, ORBuilt 1999 · S/N G2001014N97GLHarrison Christopher J · Danville, CAS/N 0709N97GPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1998 · S/N 1837N97GTMihalyi Attila · Princeton, NJS/N 2135N97HLWalker Manufacturing Co · Fort Collins, COBuilt 2000 · S/N 3257167N97HPPoutre Robert Paul Trustee · Osceola, WIBuilt 2003 · S/N NF0002N97HRRoberts Harold S DBA · Spartanburg, SCBuilt 1965 · S/N 32-73N97HWMarshall Robert W · Redlands, CABuilt 2022 · S/N 600N97HYFulghum Michael Eugene · Humble, TXBuilt 2004 · S/N 18281349N97JEJolly Anthony G · Carthage, MSS/N 23194N97JNHowe Brian J · Wilsonville, ORS/N A-4N97JSHarbold Norris B Jr · Clover, SCBuilt 1951 · S/N 156-194N97JVVanbeber Jacob P · Boonville, NYS/N 8-0107N97JWDorn Albert William II Trustee · Tucson, AZBuilt 1978 · S/N R18200652N97JXAc Holdings II Inc · Lewes, DEBuilt 2004 · S/N 6062N97KBBelue Kevin D · Madison, ALBuilt 2002 · S/N 25003N97KDYoakley Donald W · Fleming Island, FLBuilt 2014 · S/N 3332N97LAWhite Eagle 3 LLC · Wilmington, DEBuilt 1997 · S/N 3246076N97LHSteele James W · Nampa, IDBuilt 2001 · S/N 001N97LKKnife Edge LLC · N Redngtn Bch, FLBuilt 1997 · S/N 792-97N97LRAtwill Brock · Paragould, ARBuilt 1980 · S/N 28-8011116N97LWAdkins Clinton R · Corvallis, MTBuilt 2007 · S/N 3573N97MADodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7552006N97MBNelson Garrett D · Bonney Lake, WABuilt 2004 · S/N 60142
Back to AD 87-10-06 R1