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.

N293FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844176N293HPThree View Flyers LLC · Hauppauge, NYBuilt 2004 · S/N 2843603N293LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020015N293MGGeorgia Aviation Authority · Eastman, GABuilt 2015 · S/N 2844155N293RLCunningham Clinton · Kissimmee, FLBuilt 1975 · S/N 28-7505126N293WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020054N29407Guymon Stephen L · Mesa, AZS/N 28-7921034N29408Angels Aviation LLC · Ripon, CABuilt 1979 · S/N 28-7921035N2940QSkyhawk Flying Club Inc · Omaha, NES/N 28R-7737044N2940RRespass Keith D · Bluffton, SCBuilt 1969 · S/N 28R-35334N2940TKeller Vickie Rae · Arvada, COBuilt 1979 · S/N 28-7911254N2940VMike Koller Enterprises Inc · Wilmington, DEBuilt 1979 · S/N 28-7911255N2940ZMi Casa Apratment Corp · Mayaguez, PRBuilt 1979 · S/N 28-7911256N2941BTaylor James Dean · Abilene, TXBuilt 1979 · S/N 28-7911257N2941LWells Joseph L · Ashburn, VABuilt 1979 · S/N 28-7916564N2941UBaldasaro John · Clifton Park, NYBuilt 1979 · S/N 28-7916566N2942RBright Michael R · Whitehall, MIBuilt 1979 · S/N 28-7916571N2942TCentral Minnesota Aviation LLC · Paynesville, MNBuilt 1979 · S/N 28-7990577N2943DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 28R7918231N2943QAurand Bradley · Selinsgrove, PABuilt 1977 · S/N 32R-7780272N2943YMatana Aviation Group LLC · Bradenton, FLBuilt 1979 · S/N 28R-7931267N2944VPerez John H · Conroe, TXBuilt 1979 · S/N 28-7911258N2944YValley Sand & Gravel LLC · Helena, MTS/N 28-7911260N2945DShattuck Mark B · San Gregorio, CABuilt 1979 · S/N 28-7911262N2945QWarrior Aviation Lc · Prairie Village, KSS/N 28-7716128N2945RHuestis Gary M · Blackfoot, IDBuilt 1969 · S/N 28R-35339N2945TPinto Aviation LLC · Francestown, NHBuilt 1979 · S/N 28-7911263N2946BReading Aero Club Inc · Reading, PABuilt 1979 · S/N 28-7911264N2946MAir-Ag Inc · Tarboro, NCBuilt 1977 · S/N 28-7816325N2946QHess Kenneth J · Kearneysville, WVS/N 28-7716129N2947ESlipstream Inc · Saint Petersburg, FLBuilt 1979 · S/N 32-7940222N2947UDickenson Scott · Montgomery, TXBuilt 1979 · S/N 32-7940226N2948QMartin John Michael · Kingwood, TXBuilt 1977 · S/N 28-7790427N294BJMiller Craig · Yerington, NVBuilt 1979 · S/N 28-7911251N294FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844177N294KPPensom Holdings Professional LLC · Southlake, TXBuilt 1979 · S/N 28-7911287N294PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843504N294SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 28-1258N294TWLouris Thomas W · Lake Oswego, ORBuilt 1965 · S/N 28-2202N2950GLcc East LLC · Freehold, NJBuilt 1979 · S/N 28-7916572N2950PFarrell Brian M · Vienna, VABuilt 1979 · S/N 28-7916576N2950RRebecca Aviatrix LLC · Columbus, INS/N 28R-35340N2950WTaglilatelo Dale R · Cocoa, FLBuilt 1979 · S/N 28--7916577N2951XMonsalve Zauris J · Coconut Creek, FLFirst renewal noticeS/N 32-7940227N2952RTowers Roland M · Shady Shores, TXBuilt 1969 · S/N 28R-35344N2952YPreston Marty D · South Bend, INBuilt 1979 · S/N 28-7990580N29535Clouse Tyler Woods · Forest City, IABuilt 1979 · S/N 28-7990448N29537Garcia John C · Peoria, AZBuilt 1979 · S/N 28-7990449N2953QW-Wingmen LLC · Simi Valley, CABuilt 1977 · S/N 28R-7703084N2953UClarkson Fredrich A · Oro Valley, AZBuilt 1979 · S/N 28-7990582
Back to AD 87-08-08 R3