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.

N32613Gray Matthew C · Enterprise, ALBuilt 1974 · S/N 28R-7535072N3261WParish Ora Nichols · Martinez, GABuilt 1965 · S/N 32-85N32622Region Flyers LLC · Valparaiso, INBuilt 1974 · S/N 28R-7535073N32623Five Sides Racing LLC · Fallbrook, CABuilt 1974 · S/N 28-7510026N32627Joyner Hudson Ellis · Memphis, TNS/N 28-7525091N3263PSalazar Ralph T Jr · Leesville, LABuilt 1965 · S/N 28-2338N32645Taylor Trent & Haugan Inc · Santa Barbara, CABuilt 1975 · S/N 28-7510070N32646Russell Thomas Carl · Beverly Hills, FLBuilt 1974 · S/N 28-7525094N32649Pensinger Chris · Saint Paul, MNFirst renewal noticeBuilt 1974 · S/N 28-7515209N32653Emerald Flyers LLC · Everett, WABuilt 1974 · S/N 28-7505079N32655Brewer Gerald W · Sulphur Springs, TXBuilt 1974 · S/N 32-7540055N32659Allen Aviation LLC · Mansfield, MABuilt 1974 · S/N 28-7515212N32662Murukas Nicholas · Bourbonnais, ILBuilt 1974 · S/N 28-7515213N32665White Richard L Trustee · Los Altos, CABuilt 1974 · S/N 28R-7535076N32680Neumann Peter G · Cape Coral, FLBuilt 1974 · S/N 28R-7535077N32681Vanden Bos Roy · Great Falls, MTS/N 28-7510029N32684Registration Pending · Brooks, GARegistration pendingBuilt 1974 · S/N 28-7525097N32690Integrity Aviation LLC · Coatesville, INBuilt 1974 · S/N 28-7515217N32691Mid-American Pilot Association Inc · Lawrenceville, ILBuilt 1974 · S/N 28-7515218N32692Holland Walter E Trustee · Casa Grande, AZBuilt 1974 · S/N 28-7505083N32693Oconner Brian E · Santa Cruz, CAS/N 28R-7535078N326BPEagle Flew LLC · Sanford, NCBuilt 1974 · S/N 32-7540014N326CCMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881575N326DPSiemer William S · Labelle, FLBuilt 1967 · S/N 32-854N326MMHarrington James G · Westport, MABuilt 1973 · S/N 28-7325347N326RHHerrlin Rodney C · East Hampton, NYBuilt 1979 · S/N 28-8090145N32700Mob Aviation USA LLC · Auburndale, FLBuilt 1974 · S/N 28-7525099N32701Rees Truck & Trailer Inc · Fort Dodge, IABuilt 1974 · S/N 28-7515220N32702Eagle Air Group LLC · Stafford, VABuilt 1974 · S/N 28-7515222N32703Venture West LLC · Mesa, AZBuilt 1974 · S/N 28-7505084N32704Hobson Martin G · Loomis, CABuilt 1974 · S/N 28-7505085N32706Strembicke Derek R · Owens Crossroads, ALBuilt 1974 · S/N 32-7540060N32711Three Rivers Aero LLC · Three Rivers, MIBuilt 1974 · S/N 28-7525102N32712Piper712 LLC · Saint Petersburg, FLBuilt 1974 · S/N 28-7515224N32713Bleese Hubert A · Enderlin, NDBuilt 1974 · S/N 28-7515225N32714Meringer Ronald Eduardo · Phoenix, AZBuilt 1974 · S/N 28-7505086N32727Denton Christopher G · Youngsville, NCS/N 28R-7535082N32728Marianas Air Transfer Inc · Tinian, MPBuilt 1974 · S/N 32-7540061N3272WTownsend Douglas W · Charlotte, NCBuilt 1965 · S/N 32-102N32731Reels Up LLC · Middletown, DEBuilt 1974 · S/N 28-7515227N32735Hukle Grant L · Mantachie, MSBuilt 1974 · S/N 28-7515228N32739Beneke Mark N · Bushton, KSBuilt 1974 · S/N 28-7525105N32744Arndt Douglas E · Marion, WIBuilt 1974 · S/N 28-7515231N32747Aaof Investments LLC · Fort Mc Coy, FLBuilt 1974 · S/N 28R-7535084N32749Ryszka Aviation LLC · Heber City, UTBuilt 1974 · S/N 28R-7535085N3274RBurton Re Holdings LLC · Mustang, OKBuilt 1970 · S/N 28R-31258N32761Harding Antony · Rittman, OHBuilt 1974 · S/N 28-7515232N32762Keyes William H · Englewood, TNBuilt 1974 · S/N 28-7515234N32767James Stanley C · Palmer, AKS/N 28-7525110N32769Sarasota Aero Club LLC · Venice, FLBuilt 1974 · S/N 28-7515235
Back to AD 87-08-08 R3