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.

N5335TBillingsley Tom · Lufkin, TXS/N 3257231N5336VKenco Leasing LLC · Mentor, OHBuilt 2001 · S/N 3257240N5337FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790092N5337SAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 2001 · S/N 2843479N5338FParker Gary L · Metamora, MIBuilt 1976 · S/N 28R-7635452N5338LHaynes Robert · Friendswood, TXBuilt 1968 · S/N 28-4643N53392Seacrest Seven LLC · Savannah, GAS/N 3257249N5339FFox Stephen J · Corning, ARS/N 3246195N5339LAlpcal Group LLC · Ventura, CABuilt 1968 · S/N 28-4644N5339SGyorke George Jr · West Ossipee, NHBuilt 1970 · S/N 28-26932N533CASkylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841210N533DDEverglades Aviation Academy LLC · Weston, FLS/N 28-8190240N533FLLuvsflying Flight Training LLC · Staten Island, NYS/N 28-7125363N533JTIpi Private Wealth LLC · Decatur, ILBuilt 2001 · S/N 3257198N533KGautier Timothy L · Merritt Island, FLBuilt 1977 · S/N 28R-7703201N533PUEagle Flyers Vii LLC · Carmel, INS/N 2837001N533RBValdez Eddie III · Keller, TXBuilt 1981 · S/N 28R-8218002N533TRiser LLC · Wimberley, TXBuilt 1966 · S/N 32721N5340ACrews Randall S · Valdosta, GAS/N 2843489N5340LFalcon Flying Club Inc · Mesa, AZBuilt 1968 · S/N 28-4645N5340MN5340m LLC · Greenville, SCBuilt 2001 · S/N 3246198N5341FZhang Linjie · Peachtree City, GABuilt 1976 · S/N 28-7725044N5341SRegistration Pending · Selma, TXRegistration pendingBuilt 1970 · S/N 28-26806N53424Winnie Inc · Winchester, VAS/N 3257259N5342FClark Robert L · Shippensburg, PABuilt 1976 · S/N 28-7715102N5342JMoore Durk · Farmington Hills, MIS/N 2843493N5342KWest Coast Equipment Leasing LLC · Aurora, ORBuilt 2001 · S/N 2843467N5342LAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 3246200N5342VS & L Real Estate LLC · Waterloo, IABuilt 2002 · S/N 3246205N5343CFranks Flying LLC · Dover, DES/N 3257255N5343FTrident Aircraft Leasing LLC · Easton, MDBuilt 1976 · S/N 28-7715103N53447Bank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 2843535N5344STop Flight Aviation Snh LLC · Savannah, TNBuilt 1970 · S/N 28-26812N5344WTech Team Corp · Saint Joseph, MOS/N 3246201N53455Real Robert · Miami, FLBuilt 2002 · S/N 3246204N5345FArcher Air LLC · Traverse City, MIBuilt 1976 · S/N 28-7790093N53464Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3257262N5346FSo Send I You LLC · Cheyenne, WYS/N 28-7790094N5346UAverett University · Danville, VABuilt 2003 · S/N 2843542N5347FDeland Aviation LLC · Deland, FLBuilt 1976 · S/N 28R-7635453N5347LKing Michael · Durango, COBuilt 1968 · S/N 28-4650N5348LPn4 Aviation Holdings LLC · Bishop, CAS/N 28-4651N5349LHart Brad S · Elephant Butte, NMS/N 28-4652N5349MWhiskey Bravo LLC · Clarksville, TNBuilt 2002 · S/N 3257307N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278N534FLGray Gary G · Kansas City, MOBuilt 1971 · S/N 28-7125364N534SCSpartan Education LLC · Tulsa, OKS/N 2881320N53509Waynes Aircraft Maintenance · Homestead, FLBuilt 2002 · S/N 2844071N5350LN5350l LLC · Statesville, NCFirst renewal noticeBuilt 1968 · S/N 28-4653
Back to AD 87-08-08 R3