OpenAirDocs.org
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.

N4558PAviation Services Of Tn Inc · Dover, DEBuilt 1960 · S/N 27-64N4558RMorgan Chad A · Sarepta, LABuilt 1965 · S/N 28-21300N4559AKsm Aviation LLC · Kalispell, MTS/N AA5B1245N4559BSpencer Douglas L · Lexington, GABuilt 1979 · S/N AA5B1246N4559JBolduc Michael A · Strong, MEBuilt 1968 · S/N 28R-30419N4559LAirtime Aviation Inc · Tulsa, OKBuilt 1979 · S/N AA5B1247N4559RCavu Flight LLC · Simpsonville, SCS/N 28-21301N4559TLeek Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7205185N4559XJlp Flying LLC · Clewiston, FLBuilt 1975 · S/N 28R-7635089N455ADMoghis Edgar C · Redwood City, CAS/N 316N455AFGlacier Bay Aviation LLC · Fayetteville, GABuilt 1968 · S/N 17701336N455BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010039N455DDBailey Steven S · Ottawa, KSBuilt 1995 · S/N 21455N455ETLakes Aircraft Inc. · Maumee, OHBuilt 1975 · S/N 0711N455FLFisher Jeffrey D · Omaha, NEBuilt 1971 · S/N 28-7125250N455HFlying 20 Club Inc · Newtown, CTBuilt 2000 · S/N 28-43393N455HSSagnieres Hubert · Newport, VTBuilt 2001 · S/N 18281054N455JIsler Jerry L · Donalsonville, GABuilt 2007 · S/N 1070N455LPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7450172N455LBBaker Air Service LLC · Hahira, GABuilt 1997 · S/N 80184N455MAA & J Aviation LLC · Madison, MSBuilt 2001 · S/N 32-57205N455NMMoore Daniel O · Fairfield, CAS/N 48N455RTSouthern Genesis Aero LLC · Midland City, ALBuilt 2000 · S/N 447-2000N455TASurles Gregory Taylor · Emerald Isle, NCBuilt 1978 · S/N AA5B-0571N455TWTd Air LLC · Cannon Beach, ORBuilt 2001 · S/N 4636323N4560PAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1960 · S/N 27-66N4560YCleveland William B III · Canal Fulton, OHBuilt 1973 · S/N 18-7309017N4561XAir Bhnb LLC · Statesboro, GAS/N 28-7625055N4562RMcclure Richard A · Victoria, TXS/N 28-21304N4562TSellers Kelly A · Crossville, TNS/N 28-7205186N4562XVenture West LLC · Mesa, AZBuilt 1975 · S/N 28R-7635078N4562YEd Air Inc · Oaktown, INBuilt 1967 · S/N 25-4186N4563FOcean City Flying Club Inc · Newport, RIBuilt 1976 · S/N 32R-7680460N4563JPilling Ian M · Bonita, CABuilt 1968 · S/N 28R-30425N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N4563XTriple D LLC · Scotland, PABuilt 1975 · S/N 32R-7680029N4564FStern Aviation Inc · N Fort Myers, FLBuilt 1976 · S/N 28R-7635454N4565AGriswold Joshua M · Wasilla, AKBuilt 1956 · S/N 22-3876N4565FHughey Charles A Jr · Oak Ridge, TNBuilt 1976 · S/N 28-7725022N4565RHenderson Javier · Raleigh, NCS/N 28-21308N4565TSchendel Daryl R · Barstow, CABuilt 1972 · S/N 28R-7235094N4566JDifilippo Antonio O · Spring Church, PABuilt 1968 · S/N 28R-30429N4566RMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-21309N4566WBoling Kyle C · Oak Hill, FLBuilt 1976 · S/N 13056N4566XZihala William · North Little Rock, ARBuilt 1975 · S/N 28R-7635079N4567Amigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11033N45678Kdm Aviation LLC · Wilmington, DEBuilt 2012 · S/N 41063N4567ADonovan Timothy P · Wichita Falls, TXBuilt 1956 · S/N 22-3878N4567TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250136N4568ABartlett Michael W · Barron, WIBuilt 1956 · S/N 22-3879
Back to AD 87-10-06 R1