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.

N5269LKarel John · Stillwater, MNBuilt 1967 · S/N 28-4567N5269TKailua Aviation LLC · Moorestown, NJBuilt 1972 · S/N 28-7205253N5269WGoetz David B · Gleason, WIS/N 28-315N526AAPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 2881626N526GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881180N526MMInfante Juan Carlos Jr · Palmetto Bay, FLBuilt 1979 · S/N 28-7911333N526PUKantoch Mark M · Bartlett, ILS/N 2841191N5271LBright Skies Sales And Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-4569N5271TOracle Aviation LLC · Omaha, NEBuilt 1972 · S/N 28R-7235212N5273LMancuso Dale · Dallas, TXFirst renewal noticeBuilt 1967 · S/N 28-4571N5273SCarnegie Nursing Home Inc · Carnegie, OKBuilt 1971 · S/N 28-7125209N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908N5278SN5278s LLC · Katy, TXBuilt 1970 · S/N 28-26911N5278WJohns Tyler B · Folsom, CABuilt 1962 · S/N 28-326N5279LCarverair LLC · Lakeland, FLBuilt 1967 · S/N 28-4578N5279TDicecco Jennifer · West Chester, PABuilt 1972 · S/N 28-7225386N527BKShires Patrick O · San Andreas, CABuilt 1978 · S/N 28-7890310N527FLPatterson Roy A · Cameron, TXS/N 28-7125354N527LMacan Ed · Overland Park, KSBuilt 1975 · S/N 28-7505228N527SCSpartan Education LLC · Tulsa, OKS/N 2881319N527WPProctor Justin Paul · New Bern, NCBuilt 1968 · S/N 28R-30977N5280WKinney Colton S · Montrose, MNBuilt 1962 · S/N 28-329N5281LPioneer Aviation Inc · Fond Du Lac, WIBuilt 1968 · S/N 28-4581N5281SKurkjian Daniel C · Chester Springs, PABuilt 1970 · S/N 28-26918N5281TCentury Flight Systems Inc · Mineral Wells, TXBuilt 1972 · S/N 28-7205255N5281WThomaston Mitchell E · Hampton, GABuilt 1962 · S/N 28-330N5282LHodges Richard T · Williamston, MIBuilt 1967 · S/N 28-4582N5282TMehlberg Jerry L · Medford, WIBuilt 1972 · S/N 28R-7235215N5282WFloe Glen M · Wickenburg, AZBuilt 1962 · S/N 28-331N5283TN5283t LLC · Reno, NVBuilt 1972 · S/N 28R-7235216N5284LRobert N Mclay Md A Professional Medical Corp · Chula Vista, CABuilt 1967 · S/N 28-4584N5287WStump Kenneth H · Ward, ARBuilt 1962 · S/N 28-336N5288WMcdowell John Michael · Auburn, CABuilt 1962 · S/N 28-338N5289LJames Brandon · Maple Valley, WABuilt 1968 · S/N 28-4590N5289SHarrison John M · Letart, WVBuilt 1970 · S/N 28-26945N528BFBoldflight LLC · Danville, INBuilt 1975 · S/N 28-7525176N528BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881766N528CWBorrel Rene Jean Luc · Marksville, LABuilt 1977 · S/N 32R-7885005N528FLRamirez Ciro · Corona, CABuilt 1971 · S/N 28-7125358N528GYFrazier Michael · Crofton, MDBuilt 1976 · S/N 28-7690444N528JAEagle Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020128N528RWChaplin Michael A · Marathon, FLBuilt 1970 · S/N 28-11342N5290LWenger Michael · Lancaster, PABuilt 1968 · S/N 28-4591N5291SWilliams Scott H · Renton, WABuilt 1970 · S/N 28-26913N5292SVermilyea Paul E · Newton, KSBuilt 1970 · S/N 28-26923N5293SBullock Agency Inc · Saint Charles, ILBuilt 1970 · S/N 28-26841N5294LBreidenbach Amy K · Onalaska, WIBuilt 1968 · S/N 28-4595N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941
Back to AD 87-08-08 R3