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.

N33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDBuilt 1975 · S/N 28-7515360N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176N33759Flight Time Club LLC · Searcy, ARFirst renewal noticeBuilt 1975 · S/N 28R-7535188N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235N33763Elon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515361N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178N33770Bassett Christopher D · Robbinsville, NCS/N 28R-7535191N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180N3378WKimball Jason S · Riverview, FLS/N 32-232N33793Schwartz Robert E · Middleburg, FLBuilt 1975 · S/N 28-7515363N33795Coco Phillip J · Middletown, CTBuilt 1975 · S/N 28R-7535194N33796235 Flying Circus Inc · Gillette, NJBuilt 1975 · S/N 28-7510063N337BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881099N337FBMa Aviation Group LLC · Farmingdale, NYBuilt 2003 · S/N 2843550N337GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881424N33802Drew Mark David · Phoenix, AZBuilt 1975 · S/N 28-7515364N33803Mclellan Simon W · Monroe, WABuilt 1975 · S/N 28-7505182N33804Klintrin Collectibles LLC · Downers Grove, ILBuilt 1975 · S/N 28R-7535195N33806Eagle 64 LLC · Stuart, FLBuilt 1975 · S/N 28-7515365N33815Hyde Leasing LLC · Water Valley, MSBuilt 1975 · S/N 28R-7535199N33816Hettinger John E · Sterling, COBuilt 1975 · S/N 28R-7535200N3382WMoffatt Jeffrey Charles · Morgan Hill, CABuilt 1965 · S/N 32-237N33831D&K Sales Inc · Canton, GABuilt 1975 · S/N 32-7500032N33836Patton Daniel E · Thornton, PABuilt 1975 · S/N 28-7505186N3383WFour Dudes Flying LLC · Cabot, ARBuilt 1965 · S/N 32-239N33847Registered aircraftBuilt 1975 · S/N 28-7525249N33848Crymes Robert S · Woodbridge, VABuilt 1975 · S/N 28-7505187N33849Sanzaro Aero LLC · Bunnell, FLBuilt 1975 · S/N 28R-7535206N33850Jbm Ventures Inc · Apollo Beach, FLBuilt 1975 · S/N 28-7510068N33863N318bm LLC · Monroe, LABuilt 1975 · S/N 28R-7535208N33864Hirsch Bernard David · Carmel, INS/N 32-7500033N338672 F LLC · Valentine, NEBuilt 1975 · S/N 28R-7535209N3386WTranswestern Air Service Inc · Golden, COBuilt 1965 · S/N 32-244N3388WTexas Wings LLC · San Antonio, TXBuilt 1965 · S/N 32-246N3389WUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1965 · S/N 32-247N338BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881263N338MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881096N338PAFl Ventures I LLC · Winter Park, FLBuilt 2002 · S/N 2844076N3390WClear Blue Skies LLC · Saint Paul Park, MNBuilt 1965 · S/N 32-249N3391RValiair Lc Trustee · Casper, WYBuilt 1969 · S/N 28-5668N3391WNeckerauer John R · Acme, PABuilt 1965 · S/N 32-250N3392REllsworth Steven C · Muscatine, IABuilt 1969 · S/N 28-5669N3392WMartinez Paul · Sonora, TXBuilt 1965 · S/N 32-251N3393DFiscus Ronald E III · Anchorage, AKS/N 32-40656N3393RBay Richard G · Sparks, NVBuilt 1969 · S/N 28-5672N3395WGabrick Steven J · Hickory Valley, TNBuilt 1965 · S/N 32-255N3396QRomanair Wdr Inc · Winder, GABuilt 1977 · S/N 28-7790455N3396WDaubert Donald W · Chandler, AZBuilt 1965 · S/N 32-256N3397QMills Ronald S · South Jordan, UTBuilt 1977 · S/N 28R-7703106N3397WLarson Robb J · Danbury, WIBuilt 1965 · S/N 32-257
Back to AD 87-08-08 R3