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.

N5892UFeighl Engineering Group Inc · Hot Springs, ARS/N 28-26735N5892VShadbolt George · Merriman, NEBuilt 1977 · S/N 28R-7703162N5893UCasper Gary · Spring Creek, NVBuilt 1970 · S/N 28-26706N5893WFinch Howell M Jr · Victoria, TXBuilt 1965 · S/N 28-2645N5896UGift Academy Inc · Vernon, TXS/N 28-26792N5897VMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716212N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213N5898WFrazier Justyn K · Mesa, AZS/N 28-2708N589APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843765N589LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020107N589SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881407N589VWPierce Thurlow L · Attica, MIBuilt 1967 · S/N 32-908N58AEKraujales Adam M · East Moriches, NYS/N 28-5075N58YMTailwind Partners LLC · Valparaiso, INBuilt 1967 · S/N 28-4515N5900VFagen Aaron J · Granite Falls, MNS/N 28-7790510N5902WWald Charles E · Greenwood, MOBuilt 1965 · S/N 28-2752N5903VIllinois Valley Flying Club · Peru, ILBuilt 1977 · S/N 28-7790511N5903WCluff Benjamin · Meridian, IDBuilt 1965 · S/N 28-2967N5904UGilded Gull Aviation LLC · Middletown, RIBuilt 1970 · S/N 28-26891N5904WReinhart Adam R · Courtland, MNBuilt 1965 · S/N 28-2699N5906VL J L & D Inc · Wilmington, DEBuilt 1977 · S/N 28R-7703164N5906WGjj LLC · Kalispell, MTBuilt 1965 · S/N 28-2814N5907VJ And K Flying Service Inc · Grand Island, NYBuilt 1977 · S/N 28R-7703165N5908UEcostudio Real Estate LLC · South Amboy, NJBuilt 1970 · S/N 28-26505N5908WPrindle Ry · Hillsboro, ORBuilt 1965 · S/N 28-2879N5909WCornebise Ricky · Levelland, TXBuilt 1966 · S/N 28-3032N590FLDonnelly Matthew J · Romulus, NYS/N 28-7125452N590JKJk Aircraft Options LLC · Aripeka, FLBuilt 2001 · S/N 2844049N590RUSA Jet And Helicopter Inc · Denver, NCBuilt 1965 · S/N 28-21327N590UOhio University Department Of Aviation · Albany, OHBuilt 2002 · S/N 2844061N5910VMaffei Michael C · Winchester, MABuilt 1977 · S/N 32R-7780377N5910WMetz Tyler B · Bridgeport, WVBuilt 1966 · S/N 28-3040N5911UMoore Air Inc · Honolulu, HIBuilt 1970 · S/N 28-26824N5911WBrimmer Harold C · Longview, TXBuilt 1966 · S/N 28-3042N5914UShawver Aviation LLC · Knoxville, IAS/N 28-26794N5914VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1977 · S/N 28-7716214N5914WSteadfast Avatiion LLC · Mesa, AZBuilt 1966 · S/N 28-3124N5915UOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1970 · S/N 28-26897N5915WTheobald Daryl · Aberdeen, SDBuilt 1966 · S/N 28-3139N5916UForsman Airways LLC · Glenwood, MNBuilt 1970 · S/N 28-26780N5917VHeyano Norman J · Dillingham, AKBuilt 1977 · S/N 28-7790512N5917WHiggins James L · Harrisville, MIBuilt 1966 · S/N 28-3187N5918VKnutson Sever B · Hutchinson, MNBuilt 1977 · S/N 28-7790513N5918WLathrop Patrick W · Kent, WABuilt 1966 · S/N 28-3189N5919UDewater Mark · Mulberry, ARBuilt 1970 · S/N 28-26561N591PTRegistered aircraftBuilt 1977 · S/N 32R-7880026N5920VMount Ptisi LLC · Winston Salem, NCBuilt 1977 · S/N 28R-7703167N5920WSynergy Aviation LLC · Greer, SCBuilt 1966 · S/N 28-3223N5921WStearns Edwin Ben Jr · Eloy, AZS/N 28-3227N5922FNeel Aviation LLC · Lakeland, FLBuilt 1976 · S/N 28-7715158
Back to AD 87-08-08 R3