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.

N611JBBlanton Jeff H · Sacramento, CABuilt 2022 · S/N 24493N611JPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N 287916111N611KJArmstrong John G · Colorado Springs, COBuilt 2021 · S/N 91764N611LCThompson James G · Mcallen, TXBuilt 1980 · S/N 61P07998063410N611LMFolck James C · Andersonville, TNBuilt 2010 · S/N 40390N611MHAwesome Aero LLC · South Plainfield, NJBuilt 2004 · S/N 40.408N611RCCutbirth Henry R · Monahans, TXBuilt 1991 · S/N 375N611RFWhitman Michael L Ll · Farmington, NMBuilt 2008 · S/N 470-320-216N611RVNelson Miles · Corvallis, ORBuilt 2000 · S/N 24761N611SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881601N611SEGo Suborbitals LLC · Los Altos, CABuilt 2009 · S/N 72962N611SGRph Engineering LLC · Lehi, UTBuilt 1979 · S/N 27-8054020N611TTSutherland Mark V · Brownwood, TXBuilt 2007 · S/N 40292N611VProtain Jaden · Reno, NVBuilt 1959 · S/N 24-968N611VMCavender Jake Scott · Jacksonville, FLBuilt 1971 · S/N 28-7125344N611VWAlley Mark Z · Cedar City, UTS/N 28-20130N611WFWalker Aaron W · Phoenix, AZBuilt 2025 · S/N 41047N611WKSharpe William L · Bushnell, FLBuilt 2023 · S/N 5206N611WLVincent Brett D · Fayetteville, GABuilt 1978 · S/N 32R-7885212N611WWCone S E Jr · Hobbs, NMBuilt 1978 · S/N 277854093N611XBravo One LLC · Saint Louis, MOBuilt 2000 · S/N 0721N6120ABrabeck Mark F · Glasgow, MTBuilt 1991 · S/N S1520N6120PDremel Ronald W · North Bend, PABuilt 1959 · S/N 24-1220N6120SLash Gary L · Round Rock, TXBuilt 1980 · S/N R18201618N6120ZH & H Ag Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-140N6121AMichael Lancy Architect Inc · Glendora, CABuilt 1998 · S/N 20021N6121HRethink Creative Group LLC · Fort Worth, TXBuilt 1977 · S/N 28-7816225N6121PSmith Gloria M · New Hampton, NYBuilt 1959 · S/N 24-1221N6121TMcalilly Stephen L · Tupelo, MSBuilt 1982 · S/N R18201909N6121VPugmire Marsh C · Saint Charles, IDBuilt 1980 · S/N 172RG0582N6121WRadius Aviation LLC · Fort Rucker, ALBuilt 1964 · S/N 28-20137N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332N6122DBudde Bobby M Jr · San Jose, CAFirst renewal noticeBuilt 1979 · S/N 17272607N6122JVatm Sky Investments LLC · Thomson, GABuilt 1976 · S/N 28-7615305N6122SBusiness Jet Managers Inc · Canton, MIBuilt 1980 · S/N R18201619N6122WN6122w LLC · Tillamook, ORS/N 28-20138N6122XGranberry Philip G · Anchorage, AKBuilt 1988 · S/N 7486CN6123DCampi Curtis · Boulder City, NVBuilt 1957 · S/N 22-4767N6123FJws Aviation LLC · Edina, MNBuilt 1979 · S/N 17273153N6123NPfisters Flying Wahine · Waialua, HIBuilt 1969 · S/N MB-409N6123QAirflair Inc · Maurice, IABuilt 1976 · S/N 28-7790065N6123VWings Over La Aviation LLC · Van Nuys, CABuilt 1965 · S/N TD-613N6124DWegener Flying Services LLC · Indialantic, FLBuilt 1979 · S/N 17272608N6124JCrews Aaron Gregory · Boone, IABuilt 1976 · S/N 28-7690346N6124MDiscovery Air LLC · Austin, TXBuilt 2000 · S/N 3257143N6124NPacific Coast Air Museum · Santa Rosa, CABuilt 1968 · S/N MB-410N6124QLewis Chip M · Eau Claire, WIS/N 10073CN6124TBanjo Ben Aviation LLC · Kilgore, TXS/N R18201911N6125PThomas Roger · Hudson, OHBuilt 2004 · S/N 18281387N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336
Back to AD 87-10-06 R1