OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N1516XNorthern James E · Oakdale, CABuilt 1973 · S/N 379-73N15171Eckler David L · New Hudson, MIBuilt 1972 · S/N 28-7310018N15172Transit William B · Macomb Township, MIBuilt 1972 · S/N 32-7340018N15176St Germain Joseph Ronald · Glenview, ILBuilt 1972 · S/N 28-7305032N15177Air Craft Enviromental Sys Inc · Hilton, NYBuilt 1972 · S/N 28-7310019N15179Henson Ricky T · Covington, TNBuilt 1972 · S/N 28-7225601N1517EHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 1978 · S/N 17271031N1517JPardiac Kenneth R · Howell, MIBuilt 1967 · S/N 28-23912N1517XDippolito Thaddeus M · Sherwood, ARBuilt 1975 · S/N 28R-7535306N15190Coastal Air · Groton, CTBuilt 1972 · S/N 28-7305034N15191Lumpp John R · Old Brookville, NYBuilt 1972 · S/N 28R-7335033N15198Kehl Bryan R · Moorpark, CABuilt 1972 · S/N 32-7340020N1519RSims John · Ingleside, TXBuilt 1974 · S/N AA5B-0019N1519THigh Flyers Aviation Services LLC · Gaithersburg, MDBuilt 1972 · S/N 34-7250337N1519VBent Prop LLC · Inver Grove, MNBuilt 1974 · S/N 17263641N1519XAycd LLC · Allentown, PABuilt 1975 · S/N 28-7505238N151AMacnealy Gregory A · Vandalia, OHS/N 764N151ABAirsign Airships America LLC · Williston, FLBuilt 1997 · S/N 101N151ARJlp Aerospace LLC · Kansas City, MOBuilt 2006 · S/N 82290N151AV51st Aero Squadron LLC · Hoover, ALBuilt 1985 · S/N 28-8590042N151BBBlack William M · Rochester, NYBuilt 1978 · S/N 881N151BJJohnson Bruce A · Peoria, AZBuilt 2010 · S/N 40606N151BSEvans Linda J · North Wales, PABuilt 2001 · S/N 18280934N151CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2007 · S/N 1705N151CHGharazeddine Raja · Kaplan, LABuilt 2001 · S/N 2843495N151CPSale Reported · Millersville, MDSale reportedS/N 1977N151DB1 Zero Sierra Whisky LLC · Helena, MTBuilt 1965 · S/N 832N151DFMartens Brian · Spokane, WABuilt 1992 · S/N 20917N151DJValley City Flying Club Llp · Valley City, NDBuilt 1975 · S/N 28-7515308N151DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020040N151DSCastro Salvador A · Houston, TXBuilt 1975 · S/N 28-7515287N151EColwell C Stephen · Lago Vista, TXBuilt 2012 · S/N 91758N151GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881456N151JLLuebben John R · Sun City West, AZBuilt 1990 · S/N 3050N151JSPerkins E G Jr · Greenwood, MSBuilt 1994 · S/N 738-94N151KCAir Flite Inc · Shawnee, OKBuilt 1997 · S/N S1752N151LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842194N151LTBoss Dog LLC · Sheridan, WYBuilt 1963 · S/N 1316-125N151MMccallum Michael G · Ashby, MABuilt 2021 · S/N 216N151MELoweth William A · Noank, CTBuilt 2000 · S/N 18280722N151MMBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7715129N151MSEisenbaum Jeffrey S · Ashland, ORBuilt 2014 · S/N 40576N151NAMht Aviation LLC · Saint Petersburg, FLBuilt 1984 · S/N 197N151NDBrescia Joseph J · Dandridge, TNS/N 1200N151PAIntermountain Fabrication LLC · Jerome, IDBuilt 2003 · S/N T18208186N151PCWear Thomas M · Bridgewater, NJBuilt 2001 · S/N 884-2001N151PMHistorical Aeroplane Foundation Inc · Villa Park, CAS/N 219N151PSAviation Services Of Tn Inc · Sparta, TNBuilt 2024 · S/N AS03N151RLinden Richard M Jr · Dallas, TXBuilt 1966 · S/N WA-1N151RSSonoma Valley Aircraft Inc · Vineburg, CAS/N 228
Back to AD 87-10-06 R1