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.

N5562UWilkosz Robert · Tampa, FLBuilt 1969 · S/N 28-26288N5563UBlair James S · Beltsville, MDBuilt 1970 · S/N 28-26882N55640Adams Charles G III · Tawas City, MIBuilt 1973 · S/N 28-7305430N55641Gizzy LLC · Fish Creek, WIBuilt 1973 · S/N 28R-7335263N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439N5565FHenley Brett · Manchester, TNFirst renewal noticeBuilt 1968 · S/N 28-24905N5565JPerez Luis M Trustee · Corona, CAS/N 32-982N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292N55660Cifuentes Julio · Naples, FLS/N 28R-7335268N55664Cherokee 55664 LLC · Sparks, NVBuilt 1973 · S/N 28-7310145N55665Bramley Matt J · Mesa, AZBuilt 1973 · S/N 28-7310123N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438N5566JBickwall Aviation LLC · Wilmington, DEBuilt 1968 · S/N 32-994N5566UKingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26293N5566WRegistered aircraftBuilt 1962 · S/N 28-660N55671Brown Christopher A · Tigard, ORBuilt 1973 · S/N 28-7305440N55673Smith Gordon H · Racine, WIBuilt 1973 · S/N 28-7305442N55675Sykes Kinsley · Palm Coast, FLBuilt 1973 · S/N 28-7305443N55677Arrow II Aviation LLC · Rocky Mount, NCBuilt 1973 · S/N 28R-7335270N55678Murdick Robert A II · Bluemont, VABuilt 1973 · S/N 28R-7335271N55679Patriot Parachute Team Inc · Blaine, MNBuilt 1973 · S/N 32-7340132N5567W3k Weavers Investment Group LLC · Shelbyville, KYBuilt 1962 · S/N 28-661N55680Madsen Pest Management LLC · Siren, WIBuilt 1973 · S/N 28-7325466N55682Ufer Mark · Sherburn, MNBuilt 1973 · S/N 32-7340108N55687Rieber Russell C · Stockton, CABuilt 1973 · S/N 28-7305444N5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationS/N 28-662N55691Brown Alan · Lugoff, SCS/N 28-7305447N55695Straight Arrow Aviation LLC · Aurora, ILBuilt 1973 · S/N 28R-7335273N55696Walla Walla University · College Place, WABuilt 1973 · S/N 28R-7335274N55699Hill Caleb · Indianapolis, INBuilt 1973 · S/N 28R-7335281N5569UJapikse Bert · Pawleys Island, SCBuilt 1970 · S/N 28-26884N5569WBridges Michael D · Clovis, NMBuilt 1962 · S/N 28-663N556FLKarg Asset Management LLC · Pocahontas, ARS/N 28-7125395N556PAAviator Corp · Wilmington, DEBuilt 1972 · S/N 28-7225477N556SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881343N55700Curry Edwin A · Pearland, TXBuilt 1973 · S/N 28R-7335279N55701Level Up Aviation LLC · Newton, ALBuilt 1973 · S/N 28-7325460N55702Seay Horace M · Desoto, TXBuilt 1973 · S/N 28-7325461N55706Camp Justin P · Edwall, WABuilt 1973 · S/N 28-7305448N5570FCherokee Adventure Corp · Wilmington, DEBuilt 1968 · S/N 28-25006N5570URegistration Pending · Mesa, AZRegistration pendingBuilt 1969 · S/N 28-26299N55711To Ivan K · Auburndale, FLS/N 28R-7335276N55715Ricker Alexander · Spur, TXBuilt 1973 · S/N 28-7325464N55716Norby Aviation LLC · Hopkinton, MABuilt 1973 · S/N 28-7325465
Back to AD 87-08-08 R3