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.

N3HYWyco Aviation LLC · Kalispell, MTBuilt 2001 · S/N 3257252N3KBJobe Dwaine B · Chilhowee, MOBuilt 1967 · S/N 28-3872N3NBKane Airstar LLC · Mountain Home, ARBuilt 1977 · S/N 32R-7780277N3NLBaez Rafael · Stafford, VABuilt 1964 · S/N 28-1826N3TZCasey Edmond L Trustee · Los Angeles, CABuilt 1968 · S/N 28R-30490N3UWRegistered aircraftBuilt 1964 · S/N 28-10341N40004Tennesen James B · Menomonie, WIBuilt 1977 · S/N 28R-7737126N40005Williams Brian · Rhinebeck, NYBuilt 1977 · S/N 28-7716312N40006Kotwal Pramod · Bedford, MABuilt 1977 · S/N 28-7716314N40008Birkland Mitchell L · Lake Jackson, TXBuilt 1977 · S/N 28-7716317N40010Sain Ricky F · Vale, NCS/N 28R-7737127N40015Wings Flying Club Inc · Sheperdsville, KYBuilt 1977 · S/N 28-7716319N40016Miller Aircraft Services Inc · Crookston, MNBuilt 1977 · S/N 28-7716320N40017Biro Of Chicago Inc · Chicago, ILBuilt 1977 · S/N 28-7716321N40019Registered aircraftBuilt 1977 · S/N 28-7716322N4001RPrusso Douglas M · Woodstock, GABuilt 1967 · S/N 32-40286N40021Zieber Josh · Leesville, LAS/N 28-7716323N40023Stice Garrett · Summit, ARBuilt 1977 · S/N 28-7816002N40024Teton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 28R-7737128N4002WBall David J · Shreveport, LABuilt 1966 · S/N 32-40019N40033Fly Well Flying Club Inc · Roseville, MNBuilt 1977 · S/N 32R-7780509N40037Pars Avn Corp · Wilmington, DES/N 28-7816003N4003RRowley Stephen A · Burlington, WIBuilt 1967 · S/N 32-40289N40042Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816004N40045Lawson William · Somerset, WIBuilt 1977 · S/N 28-7816006N40046Ponce Annabelle S Brack · Zephyr Cove, NVBuilt 1977 · S/N 28R-7703296N4004RHoche-Mong Michel · Campbell, CABuilt 1967 · S/N 32-40291N4004WWatson Worldwide LLC · Buzzards Bay, MAS/N 32-40003N40057Hovnanyan Ari · Van Nuys, CABuilt 1977 · S/N 28-7716313N40058Johnson Cassandra · Temecula, CABuilt 1977 · S/N 28-7816007N40060Marshall Loraine · Independence, KYBuilt 1977 · S/N 28-7816009N40062Kiwi Air Inc · Sausalito, CAS/N 28-7890003N40065Aldridge Raymond · Moultrie, GABuilt 1977 · S/N 28R-7703302N40068Van Houten Bradley Thomas · Naples, FLBuilt 1977 · S/N 28R-7737131N40069Brown Willard Jr · Far Hills, NJS/N 28-7890170N40070Penski Christopher E · Ocala, FLBuilt 1977 · S/N 28-7816012N4009RFagerberg Albert · Hot Springs Villag, ARBuilt 1967 · S/N 32-40301N400CBSamper Aviation LLC · Easton, PABuilt 1969 · S/N 28R-31123N400FLSouthard Joseph P · Greer, SCBuilt 1971 · S/N 28-7125174N400GFLively Joshua · Montague, MABuilt 1985 · S/N 32R-8613002N400JCRegistered aircraftBuilt 1965 · S/N 28-2121N400JRAirspeed Investments LLC · Springfield, TNBuilt 1982 · S/N 28-8316007N400JWAirfleet Holdings LLC · Beverly Hills, CABuilt 1974 · S/N 28-7405276N400UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020228N4010WOne Zero Whiskey LLC · Savannah, GAS/N 32-40012N4011QKolb Michael J · Glenside, PABuilt 1977 · S/N 28R-7737059N4011RHot Shots Aerial Photography LLC · Mesa, AZBuilt 1967 · S/N 32-40304N4011WAdami Devin · Truckee, CABuilt 1966 · S/N 32-40014N4012FNational 967.LLC · Rock Hill, SCBuilt 1976 · S/N 28-7725001N4013QSegura Huey F Jr · Lafayette, LABuilt 1977 · S/N 28R-7703118
Back to AD 87-08-08 R3