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.

N729NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881024N729PGGray Paul E · Elberta, ALBuilt 2012 · S/N 72874N729RGMad Dog Services LLC · Vero Beach, FLS/N 32-7940021N729RVTwo Bag Ice LLC · Media, PABuilt 2016 · S/N 1581N729SCCole Michael J · Ginnison, COBuilt 1978 · S/N R18200750N72ABGlobe Motorcycles Ltd Inc · Pembroke Pines, FLBuilt 1969 · S/N 25-5088N72AEDaror Edward S · Glendale, AZBuilt 2003 · S/N 60271N72ARDollar Douglas A · Crawford, MSBuilt 1972 · S/N 22-72N72BJRoll John K · Houma, LABuilt 1999 · S/N BE-001N72BLSkrow Works Inc · West Monroe, LAS/N 17257795N72BNBower Fredrick S · Watervliet, MIFirst renewal noticeBuilt 1980 · S/N WRN2N72BWChapman Oliver J · Wingo, KYBuilt 1950 · S/N 18-159N72BZParker Bruce C · Boise, IDBuilt 2010 · S/N 21N72CCCaterfull Inc · Miami Beach, FLBuilt 1975 · S/N 17266347N72CDG Brinkman Aviation Inc · Naperville, ILBuilt 1971 · S/N 28-7205013N72CLCjr Wings · Harrisburg, PABuilt 1972 · S/N 747N72CVMccullough Wayne L · Greenfield, INBuilt 1958 · S/N 22-6115N72DCopenhaver Tracy K · Anthony, KSBuilt 1972 · S/N 14-72N72DBDavis James M · Tuscaloosa, ALBuilt 1972 · S/N 202N72DDMildebrandt Donald E · East Troy, WIBuilt 2006 · S/N 375N72DEBaschwit Janie · Mooresville, INBuilt 1990 · S/N 001N72DLD Air LLC · The Colony, TXBuilt 1976 · S/N 263-76N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006N72EBVector Airmotive LLC · Frisco, TXS/N 1211-95N72ERMaierhoffer Henry F Jr · Sylvania, GABuilt 1977 · S/N 17269501N72FAJones Donald T Jr · Barrigada, GUBuilt 1977 · S/N 31-7812023N72FDEngesath David H · Duluth, MNBuilt 1974 · S/N 17263913N72FMBank Of Utah Trustee · Salt Lake City, UTS/N 27-0264N72FYStrongpoint Real Estate Group LLC · Danville, PABuilt 1966 · S/N 3425N72GSSmith Gregory S · New Orleans, LABuilt 2007 · S/N 70473N72HQKirby Bobby J Jr · Hernando, FLBuilt 1977 · S/N 11966721N72HYTwedt Dennis · Baker, MTBuilt 2004 · S/N 2279N72JCBores Scott J · Huron, OHS/N 3324N72JHBooher Stephen R · Corrales, NMBuilt 1999 · S/N 1N72JNTroy I Mounts Md Inc · San Juis Obispo, CABuilt 1974 · S/N 17263882N72KGrace Jesse L · Troutdale, ORBuilt 1967 · S/N 28-10927N72KCYeilding R Edward · Florence, ALBuilt 1972 · S/N 298-72N72KFKirkpatrick John Drew · Post, TXBuilt 2004 · S/N 18281361N72KJJameson Kirk A · Lake Panasoffkee, FLBuilt 2018 · S/N BC11117009AN72KWPerformance Aviation LLC · Wilmington, DEBuilt 1972 · S/N 2028N72LFLarrabee Joey S Trustee · Holyoke, COBuilt 2005 · S/N 1388-2005N72LMCoonan Paul M · Huntsville, MOS/N AA5-0217N72LPRavens Rebuilders Inc · Ellenboro, WVBuilt 2003 · S/N 0152N72LTReynolds Cindy L · Wills Point, TXBuilt 1968 · S/N 580863N72MMagical Thing Air LLC · Jasper, INBuilt 2003 · S/N DM0287MTAN72MCAa-Aero Inc · Fairfield, NJBuilt 2005 · S/N 18281653N72MGAerosox LLC · Diamondhead, MSBuilt 1967 · S/N 680033N72MHQuasar Aircraft Corp · Jacksonville, FLBuilt 1978 · S/N 28R-7918008N72MRSnide Thomas C · Dublin, OHBuilt 1998 · S/N 18280123N72MVBeck Douglas J · Lincoln, NEBuilt 2001 · S/N 80842B
Back to AD 87-10-06 R1