OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N9748WWest David · Astoria, ORBuilt 1967 · S/N 28-23231N9749JNoth Christopher A · Seminole, FLBuilt 1967 · S/N 28-3935N974ABPiper Aircraft Inc · Vero Beach, FLS/N 28010093N974ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916126N974CT&W Rentals LLC · Houma, LABuilt 2007 · S/N 3257477N974GShea Joseph W · Omaha, NES/N 32R-8313016N974MATerriair Aviation LLC · Littleton, COS/N 28-8116288N9750JBaltz Aviation Services LLC · Mercer, WIBuilt 1967 · S/N 28-3897N9751JR&A Aviation LLC · Flower Mound, TXBuilt 1967 · S/N 28-3944N9752CAero-Sphere Inc · Longmont, COBuilt 1978 · S/N 28-7816524N9753WSeppala Matthew T · Hortonville, WIS/N 28-23236N9755JDesroches John · Scottsdale, AZS/N 28-3947N9755WAncheta Kai A · Anchorage, AKBuilt 1967 · S/N 28-23239N9756JJackson Robert L · Leesburg, VABuilt 1967 · S/N 28-3948N9757JCarbiener Diane M · Kewanee, ILBuilt 1967 · S/N 28-3949N9757WTld And Company LLC · Trenton, FLBuilt 1967 · S/N 28-23241N9758JKiarsis Stephen G · West Wareham, MABuilt 1967 · S/N 28-3950N9759JLazy H LLC · Carleton, NEBuilt 1967 · S/N 28-3951N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121N975BESaucerman & Company LLC · Hampstead, NCBuilt 1996 · S/N 3246040N975LEBlue Borracho LLC · Manitou Springs, COBuilt 1975 · S/N 28-7690001N9760CStreet Steven J · Rochester, MIBuilt 1978 · S/N 28-7816526N9760JHanks Cathy J · Danville, KYBuilt 1967 · S/N 28-3953N9760WRegistered aircraftBuilt 1967 · S/N 28-23244N9761WRivera-Osorio Karolina · Monroe, NYS/N 28-23245N9763JShaffer Timothy R · Marion, IABuilt 1967 · S/N 28-3958N9764KSchoff Wardell R · Hamilton, MOBuilt 1977 · S/N 28R-7837038N9764WMich John D · Fort Morgan, COBuilt 1967 · S/N 28-23250N9765JPinson Cassandra · Chandler, AZBuilt 1967 · S/N 28-3960N9765WShelby Gary J · Harleysville, PABuilt 1967 · S/N 28-23251N9766WYoung Justice P · Prairie Grove, ARS/N 28-23252N9767JMatta Aviation Services LLC · Junction City, KSBuilt 1967 · S/N 28-3963N9767WBrighton Flying Club LLC · Brighton, MIBuilt 1967 · S/N 28-23254N9768CHansen Kurt C · Washington, UTBuilt 1978 · S/N 32-7840116N9768JOpp Prop Air LLC · Collierville, TNBuilt 1967 · S/N 28-3964N9768KArrow Aviation LLC · Topeka, KSBuilt 1977 · S/N 28R-7803067N9768WEichner Cynthia A Loening · Tolland, CTBuilt 1967 · S/N 28-23255N9769FFrost Aviation Services Inc · Las Cruces, NMBuilt 2023 · S/N 28020114N9769JDubovtsev Mikhail · Wildwood, NJBuilt 1967 · S/N 28-3967N976ABPiper Aircraft Inc · Vero Beach, FLS/N 28010096N976ACNaples Air Center Inc · Naples, FLBuilt 1981 · S/N 28-8116308N976WBBuckland Lauren O Jr · Winder, GABuilt 1977 · S/N 32R-7780355N9770WRegistration Pending · Altus, OKRegistration pendingBuilt 1967 · S/N 28-23257N9771JBuzzard Roost Aviation LLC · Marble, NCBuilt 1967 · S/N 28-4009N9772WCow Dog Flyers LLC · Bozeman, MTBuilt 1967 · S/N 28-23259N9773J1st Flight LLC · Granby, COBuilt 1967 · S/N 28-3972N9776JVarman Michael J · Elwood, ILS/N 28-3975N9776KMoto Flyers LLC · Chillicothe, OHBuilt 1977 · S/N 32R-7880033N9777JKunick Matthew · Belfair, WAS/N 28-3976N9777MEgs Air LLC · St Thomas, VIBuilt 2004 · S/N 2844116
Back to AD 87-08-08 R3