OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N56343R&T Wings LLC · Lewes, DES/N 28-7325612N56344Rogers Steve M · Brenham, TXBuilt 1973 · S/N 28-7305574N5634WEagle Vision LLC · Hamer, IDBuilt 1962 · S/N 28-781N56350Aerospace Technology Group Inc · Temecula, CABuilt 1973 · S/N 28-7325613N56353Groux Zachary Brian · Spring, TXBuilt 1973 · S/N 28R7335418N56355Vectair USA LLC · Olive Branch, MSBuilt 1973 · S/N 28R7335419N56363Romzick Peter G · Oxford, MIBuilt 1973 · S/N 28-73-25618N56367N56367 LLC · Manassas, VABuilt 1973 · S/N 32-7300058N5636UMontie Michael · Fairview Park, OHBuilt 1969 · S/N 28-26432N5636WWatkins Micah · Queen Creek, AZBuilt 1962 · S/N 28-783N5637UCurtis Alex K · Winnemucca, NVBuilt 1969 · S/N 28-26433N56380Zimin Carl E · Naknek, AKBuilt 1973 · S/N 287325620N56382Risley Air LLC · Myrtle Beach, SCBuilt 1973 · S/N 287305580N56387Prentice Robert D · Ripon, WIBuilt 1973 · S/N 287305584N5638ULig Tyl LLC · Akron, NYBuilt 1969 · S/N 28-26435N56390Renard Jerome L Trustee · Curtis, NEBuilt 1973 · S/N 28R-7335431N56392Ricottilli Stanley L · Mill Creek, WVBuilt 1973 · S/N 32-7300060N56396Sky North Aviation & Flight Training LLC · Arbuckle, CABuilt 1973 · S/N 287325623N5639FTaffet Jay · New Orleans, LABuilt 1976 · S/N 28-7790132N5639UMcconnell Charles L · Phoenix, AZBuilt 1969 · S/N 28-26434N563APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843764N563CARegistration Pending · Wilmington, DERegistration pendingBuilt 1975 · S/N 28R-7535275N563DFGolden Aviation LLC · Hillsborough, NJBuilt 2022 · S/N 2881563N563FLParkerson James R · Greenville, MSS/N 28-7125405N563JTRick Crum Aircraft Sales Inc · Prestonsburg, KYBuilt 2000 · S/N 3257181N563KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843936N563MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020139N563PJMcdonald Patrick J · Des Moines, IABuilt 1973 · S/N 28R-7335411N563PRPope County Aviation LLC · Russellville, ARS/N 32-7200027N563PUAri Ben Aviator Inc · Fort Pierce, FLBuilt 2000 · S/N 2842105N563SBWalker Linda V · Zeeland, MIBuilt 1973 · S/N 28R-7335429N563SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881400N563VWRichen Owyn · Seattle, WABuilt 1968 · S/N 32-1029N56404Mark Lindstrom · Fort Worth, TXBuilt 1973 · S/N 287305586N5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436N56410Ehrler Andrew N · Flushing, NYS/N 28R-7335433N56414Gordon David P · Truckee, CABuilt 1973 · S/N 287305588N56418Shepler John E · Mobile, ALBuilt 1973 · S/N 28R7335434N5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789N56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628N56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591N5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439N56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439N5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596
Back to AD 87-08-08 R3