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.

N5827QPromises LLC · Pompano Beach, FLBuilt 1965 · S/N 859N5828DSchulz Lucas H · New Boston, MIBuilt 1956 · S/N 22-4503N5828QGreater Cincinnati Aero Club LLC · Alexandria, KYBuilt 1965 · S/N 3123N58294Nance James Aaron · Woodbridge, VABuilt 1979 · S/N 18-7909055N5829QHenery L Bodmer Inc · Kenmare, NDBuilt 1965 · S/N 780N5829UFarrell Mark O · Pittsburgh, PABuilt 1969 · S/N 28-26660N582ASChip Henry Aviation LLC · Bel Aire, KSBuilt 1996 · S/N 4636036N582BBAftab Younus · Pleasanton, CABuilt 1984 · S/N BLACKWOOD 0001N582BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881959N582MHuffman Prairie LLC · Claymont, DEBuilt 1991 · S/N 1608N582MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.398N582TCBreak For It Aviation LLC · Draper, UTBuilt 2005 · S/N 18281550N5830CKueber Jake T · Anchorage, AKBuilt 1962 · S/N 18-7778N5830WWard Orval G · Bentonville, ARBuilt 1965 · S/N 28-2148N5830YMost Gordon G · Thedford, NEFirst renewal noticeS/N 18-8411N58319Schweizer Rsg LLC · Fort Worth, TXBuilt 1979 · S/N 390761N5831LCooks Aviation LLC · Conover, NCBuilt 1972 · S/N AA5-0231N5831QCueva Arturo A · Los Angeles, CABuilt 1965 · S/N 781N5831WSonafrank Eric J · Somerset, INBuilt 1965 · S/N 28-2149N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5832LPlesea Lucian · Redlands, CABuilt 1972 · S/N AA5-0232N5832NWitherington III William A · Newnan, GABuilt 1978 · S/N 14381N5832PBrooks William L · Vienna, VABuilt 1959 · S/N 24-913N5832QHli Aviation LLC · Red Banks, MSBuilt 1965 · S/N 3125N5832UBecker Randall T · Santa Rosa, CABuilt 1970 · S/N 28-26663N5832VPowless Robert A · Tierra Verde, FLBuilt 1993 · S/N 27-0144N5833DBixler Scott E · Rising Fawn, GABuilt 1956 · S/N 22-4509N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5833PCochran Keith W · Long Beach, CAS/N 24-914N5833QDyer Albert L · New Smyrna Beach, FLBuilt 1965 · S/N 782N5833WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-2159N5833YMyob Group LLC · Ocala, FLS/N 27-2982N5834LFount Valley Flying Club LLC · Kidron, OHS/N AA5-0034N5834QGill Harold P · Bolton, MABuilt 1965 · S/N 3126N5834UNewburn William A Jr · Fresno, CABuilt 1969 · S/N 28-26665N5834WDowdy Joseph N · Blacksburg, VABuilt 1965 · S/N 28-2186N58359Warner Robert G Jr · Broomall, PABuilt 1979 · S/N 1290861N5835PLoya Francisco · Crestline, CAS/N 24-916N58363Hartle Aaron Duane · Vicksburg, MIBuilt 1979 · S/N 690796N5836PShort Final LLC · Murfreesboro, TNBuilt 1959 · S/N 24-917N58371Bilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 690794N5837LDudock John M Jr · Birch Run, MIBuilt 1972 · S/N AA5-0037N5837PGoodman Wayne A · Conway, SCBuilt 1959 · S/N 24-918N5837UDeblass Christopher C · Cranford, NJBuilt 1969 · S/N 28-26668N58384Sonnichsen Landen D · Delta Junction, AKS/N 990829N5838LCox Andrew C · Scappoose, ORBuilt 1972 · S/N AA5-0038N5838MMuller Isaac Paul · Nampa, IDBuilt 2026 · S/N 5838N5838PHoughtling Marvin · Pasadena, TXBuilt 1959 · S/N 24-919N5838WJohn Andrew P · Auburn, MES/N 28-2207N58397Frost Darrell G · Atlanta, TXBuilt 1979 · S/N 1090833
Back to AD 87-10-06 R1