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.

N63146C M B Aviation LLC · Farmington Hills, MIBuilt 1974 · S/N 32-7440117N6315WAir Share Aviators Flight Club LLC · Fairfax, CAFirst renewal noticeBuilt 1964 · S/N 28-20372N6316JMcintosh Rick D · Kansas City, MOBuilt 1968 · S/N 28-4723N6316RHolec David V · Senoia, GABuilt 1966 · S/N 28-21482N6318RN383j LLC · Henderson, NVBuilt 1966 · S/N 28-21484N6319CNew York Aviators LLC · South Ozone Park, NYBuilt 1978 · S/N 28-7890362N6319RRj Aviation LLC · Hurricane, UTBuilt 1966 · S/N 28-21485N631BWHaase Eric J · Woodland Hills, CABuilt 1973 · S/N 32-7340041N631FLMiller William H · Blue Mound, ILBuilt 1971 · S/N 28-7125526N631FTFlorida Institute Of Technology · Melbourne, FLBuilt 1981 · S/N 28-8216036N631NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881166N631PCPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020282N6320CHeme Flying LLC · Lewisville, NCBuilt 1978 · S/N 28R-7837157N6320JJns Corp · Wilmington, DEBuilt 1968 · S/N 28-4728N6321JPrecision Aircraft Service LLC · Staples, MNBuilt 1968 · S/N 28-4729N6322JBaus Mark L · La Crosse, KSBuilt 1968 · S/N 28-4730N6323JYoung Troy D · Vernon, TXS/N 28-4731N6323RSeigel Virginia L · Havre, MTBuilt 1966 · S/N 28-21490N6323WMedicine By Design Inc · Miami, FLBuilt 1964 · S/N 28-20379N6325CCurtis Aviation LLC · Derby, KSBuilt 1978 · S/N 28R-7803220N6325JBantle Flyers LLC · North Chesterfield, VABuilt 1968 · S/N 28-4733N6325RVaught Janet M · Creedmoor, NCBuilt 1966 · S/N 28-21492N6326CBridges Gerald Lloyd · Chelsea, MIBuilt 1978 · S/N 32-7840079N6326RBlancett-Maddock David D · Kailua Kona, HIBuilt 1966 · S/N 28-21494N6326WKipkurui Stephen · Fort Worth, TXBuilt 1964 · S/N 28-20382N6328JWildflower Remedies LLC · Millersburg, OHS/N 28-4736N6329JBeavers Danny G · San Antonio, TXBuilt 1968 · S/N 28-4737N6329RLomax Robert P · Belfair, WABuilt 1966 · S/N 28-21497N6329WKingsley Kaland W · Miller, MOBuilt 1964 · S/N 28-20385N632NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881153N632SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881433N632WBKesner Ronald H Jr · Troy, VABuilt 1966 · S/N 32-620N6330JBrashear Don F · Orcas, WABuilt 1968 · S/N 28-4738N6330RLuton Christopher S · Cedar Park, TXBuilt 1966 · S/N 28-21498N6331CLambert James Donald · Sterling, COBuilt 1978 · S/N 28-7816408N6332REllis Mark D · Parma, OHBuilt 1966 · S/N 28-21501N6334CPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7816409N6334JBazacos Theresa B · Pensacola, FLBuilt 1968 · S/N 28-4743N6334RPollock William J · Agawam, MABuilt 1966 · S/N 28-21503N6335JAher Kishor Dudhabhai · Livingston, NJBuilt 1968 · S/N 28-4744N6336JTessmann David James · Albuquerque, NMBuilt 1968 · S/N 28-4745N6337WGuerin Bryant J · West Ossipee, NHS/N 28-20394N6338JBennett Aviation LLC · Gillette, WYBuilt 1968 · S/N 28-4747N6338RJohnson Cody J · Trafalgar, INBuilt 1966 · S/N 28-21507N6339RSeager Anthony M · Medford, ORBuilt 1966 · S/N 28-21508N633CEpperson Dallas C · Asheville, NCS/N 28-7125601N633SGCherokee N633sg LLC · Leonardtown, MDBuilt 1972 · S/N 32-7340051N6340J4 M Aviation LLC · Glenwood, ARBuilt 1968 · S/N 28-4749N6340WVarnell George W · Kennesaw, GABuilt 1964 · S/N 28-20398N6341CD & D Design & Manufacturing Inc · Wheatland, OKBuilt 1978 · S/N 28-7816411
Back to AD 87-08-08 R3