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.

N639STVector Aviation LLC · Mentor, OHBuilt 2006 · S/N 2843639N639TBMurphy Craig D · Boise, IDBuilt 1991 · S/N 938N63ACurry Vertis Michael · Crockett, TXBuilt 1990 · S/N M-II-784N63ABAircraft Leasing & Management LLC · Lewes, DEBuilt 1965 · S/N 914N63AJSehgal Aviation Inc · Shoreline, WABuilt 2003 · S/N 3255003N63AKWinchell Lawrence R III · Salem, NJS/N 467-2005N63AMSierra Yankee Victor LLC · Austin, TXBuilt 1980 · S/N 17273981N63AZArnold Vincent Craig · Rosharon, TXBuilt 2008 · S/N 1026N63BASullivan Richard P · Star, IDBuilt 1963 · S/N 28-1494N63BDCampbell Joseph H · Jeffersonville, INBuilt 1979 · S/N R18201067N63BESutton John S · Pelham, ALS/N 2812N63BGDenali Asset Management LLC · Incline Village, NVBuilt 2019 · S/N 10180018N63BSPfinx LLC · Chapel Hill, NCBuilt 1992 · S/N 24-3286N63BTSilverback Solutions LLC · Amlin, OHBuilt 1976 · S/N 32R-7680094N63CEBarr Air Patrol LLC · Mesquite, TXFirst renewal noticeBuilt 1998 · S/N 18280357N63CLThomas Matthew L · Lakeland, FLBuilt 2000 · S/N 20887N63CTSmith Glenn C · University Place, WABuilt 1996 · S/N 1335N63CVClark Terry L · Bartlesville, OKBuilt 1979 · S/N 386-79N63DABass Lake Aviation LLC · Webster, WIBuilt 1998 · S/N 1238-98N63DGMiller Colette L · Sequim, WAS/N 637N63DMDurbin Hal E · Findlay, OHBuilt 1981 · S/N DM2N63DTTanona Duane T · Enumclaw, WABuilt 1998 · S/N 23762N63EDRosinbaum Daryl A · Waller, TXBuilt 2024 · S/N 63N63EZWorley Dan L · Heber Springs, ARS/N 1109N63FEFour Macs Logistics LLC · Houlka, MSBuilt 1992 · S/N 1225N63FHRegistered aircraftBuilt 2004 · S/N 60498N63FKHawley Robert W · Fort Worth, TXBuilt 1962 · S/N 28-757N63FM63 Foxmike Inc · Wilmington, DEBuilt 1999 · S/N 27-0274N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616N63GKRawareo LLC · Warsaw, MOS/N 28-20781N63GMBmi Aviation LLC · Hallandale Beach, FLBuilt 1990 · S/N 24-3182N63GSAerial Surveys Inc · Dover, DEBuilt 2002 · S/N 5218N63HESkoog Rodney D · White Bear Lake, MNBuilt 2004 · S/N 452-2004N63HYTailwheel Pilots LLC · Lacon, ILBuilt 2001 · S/N 2173N63JDD'Angelo Joseph P · Callicoon Center, NYBuilt 1979 · S/N 17272940N63JWRegistered aircraftBuilt 1977 · S/N 18-7709139N63KBBeene Kenneth E · Waco, TXBuilt 2006 · S/N 2460N63LDKnudsen Allan L · Council Bluffs, IABuilt 2008 · S/N 60383N63LTEtienne Realty LLC · Pembroke Pines, FLS/N 27-7754100N63LUChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280591N63MMNzere Michael · Crowley, TXBuilt 1963 · S/N 2569N63MSSire Daniel T · Wausau, WIBuilt 2005 · S/N 90768N63MTGriffith Gary L · Palestine, TXBuilt 1962 · S/N M-97N63PEGoodinson Marc D · Hamburg, NJBuilt 1968 · S/N 28R-30908N63PKRegistered aircraftBuilt 1965 · S/N 734N63PLBoeing Employees Flying Club St Louis Inc · Saint Louis, MOBuilt 1977 · S/N 28-7816263N63PVAir Tech Flying Club Inc · Chesterfield, VABuilt 1994 · S/N 3213087N63RMclenaghan Alvin N · Phoenix, AZBuilt 1965 · S/N 858N63RH4-D Aviation Consulting LLC · Wilmington, DES/N 60494N63RLVolland Aimee C · Tavernier, FLBuilt 1976 · S/N 28R-7635368
Back to AD 87-10-06 R1