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.

N337GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881424N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349N337HCustom Aircraft Inc · Palmer, AKBuilt 1999 · S/N 2999N337HRRahlf Steven · Muscatine, IAS/N 3N337JMJstol LLC · Monrovia, INBuilt 2022 · S/N CCK-1865-1107N337MEFlytcentrix LLC · Lewes, DES/N 172S8468N337MGTew-Mac LLC · Tewksbury, MABuilt 2025 · S/N 2810N337RARogers Kenneth R · Sandusky, OHBuilt 1978 · S/N 3099N337RVGeorge Gary D · Humble, TXBuilt 2010 · S/N 71040N337SBA1b LLC · Hinsdale, MTBuilt 2000 · S/N 2052N337WMLee Mark A · Toppenish, WABuilt 2023 · S/N MAL-001N338Plane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N 2141N33802Drew Mark David · Phoenix, AZBuilt 1975 · S/N 28-7515364N33803Mclellan Simon W · Monroe, WABuilt 1975 · S/N 28-7505182N33804Klintrin Collectibles LLC · Downers Grove, ILBuilt 1975 · S/N 28R-7535195N33806Eagle 64 LLC · Stuart, FLBuilt 1975 · S/N 28-7515365N3380KKabat Jules Max · Las Vegas, NVBuilt 1946 · S/N 1373N3380MSkaggs Jay D · Eagle River, AKBuilt 1947 · S/N 12-2227N3380XGretencord Howard F Trustee · Kansas City, MOBuilt 1966 · S/N 3381N3380ZSchwend Brian · Forsyth, MTBuilt 1960 · S/N 18-7261N33815Hyde Leasing LLC · Water Valley, MSBuilt 1975 · S/N 28R-7535199N33816Hettinger John E · Sterling, COBuilt 1975 · S/N 28R-7535200N3381XBagwell Trevor T · Valencia, CABuilt 1966 · S/N 3382N3382WMoffatt Jeffrey Charles · Morgan Hill, CABuilt 1965 · S/N 32-237N33831D&K Sales Inc · Canton, GABuilt 1975 · S/N 32-7500032N33836Patton Daniel E · Thornton, PABuilt 1975 · S/N 28-7505186N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683N3383WFour Dudes Flying LLC · Cabot, ARBuilt 1965 · S/N 32-239N3383XHiger Matthew Ward · Las Vegas, NVBuilt 1966 · S/N 1096N3383ZMcghee Johnny A · Louisburg, NCBuilt 1960 · S/N 18-7267N33847Registered aircraftBuilt 1975 · S/N 28-7525249N33848Crymes Robert S · Woodbridge, VABuilt 1975 · S/N 28-7505187N33849Sanzaro Aero LLC · Bunnell, FLBuilt 1975 · S/N 28R-7535206N3384XWendt Wesley A · Leavenworth, KSBuilt 1966 · S/N 1097N3384ZJones Robert D Jr · Chugiak, AKBuilt 1960 · S/N 18-7268N33850Jbm Ventures Inc · Apollo Beach, FLBuilt 1975 · S/N 28-7510068N3385XKelly Paul M · Granite Bay, CABuilt 1966 · S/N 3383N33863N318bm LLC · Monroe, LABuilt 1975 · S/N 28R-7535208N33864Hirsch Bernard David · Carmel, INS/N 32-7500033N338672 F LLC · Valentine, NEBuilt 1975 · S/N 28R-7535209N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526N3386WTranswestern Air Service Inc · Golden, COBuilt 1965 · S/N 32-244N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687N3387ZBlake Clark D · Belle Fourche, SDBuilt 1960 · S/N 18-7271N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688N3388WTexas Wings LLC · San Antonio, TXBuilt 1965 · S/N 32-246N3388XRoth Joe D · Livingston, TXBuilt 1966 · S/N 1099N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352
Back to AD 87-10-06 R1