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.

N4475JHilburn Brian · Philadephia, PABuilt 1967 · S/N 28-22891N44761Henderson Gregory S · Saltsburg, PABuilt 1974 · S/N 28-7515025N44763Flying Peanuts LLC · Wilmington, DEBuilt 1974 · S/N 28-7505007N44764Hess Alex · American Fork, UTBuilt 1974 · S/N 28-7505008N44771Benedict Kevin M · Lakeland, FLBuilt 1974 · S/N 28-7525003N44772Hanson Donald H · Bellevue, WABuilt 1974 · S/N 28-7515028N44773Nair Vihas G · Philadelphia, PABuilt 1974 · S/N 28-7515029N44775Heuerman Jordan D · Casey, ILBuilt 1974 · S/N 28-7515030N44777Delisi Carl V · Linden, MIS/N 28-7510004N44780Imler Jarrod M · Gallatin, TNBuilt 1975 · S/N 28-7510005N44782Alsup Jonathan S · Tok, AKBuilt 1974 · S/N 32-7500002N44783Family Eye Care Center LLC · Elkins, WVBuilt 1974 · S/N 32-7540004N44786Flight Academy LLC · Van Nuys, CAS/N 28-7515032N44789Dzialo Matthew J · Pawtucket, RIBuilt 1974 · S/N 28-7505011N4478JFly 500 LLC · Fort Pierce, FLBuilt 1967 · S/N 28-22894N4478TSchroder David A · Venice, FLBuilt 1972 · S/N 28-7205168N4478XWhite Raymond W · Montrose, MIBuilt 1975 · S/N 28-7615017N44790Spence William M · Naples, FLBuilt 1974 · S/N 28R-7535007N44792Ocean Air Inc · Eugene, ORBuilt 1974 · S/N 28-7515064N4479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1972 · S/N 28R-7235033N447KCN447kc LLC · Mesa, AZS/N 3255047N447KSPoletto Danny A · Great Falls, MTBuilt 1969 · S/N 28-25439N447RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020197N44800Schoppe Marc · Durham, NCBuilt 1975 · S/N 28-7505012N44802Page Aviation Services LLC · Fort Myers, FLS/N 28R-7535009N44805Gage Christopher · Truckee, CABuilt 1974 · S/N 28-7525008N44806Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 28-7515037N4480JGonzalez Guadalupe G · Atwater, CABuilt 1967 · S/N 28-22896N4480TSell Justin L · Lucerne, INBuilt 1972 · S/N 28R-7235067N44813Olusanya Babajide A · Cherry Hill, NJBuilt 1974 · S/N 32-7540006N44817Tokach Nicholas J · Hinckley, OHBuilt 1974 · S/N 28-7525009N44819Mayflower Aero LLC · Appleton, WIBuilt 1974 · S/N 287515041N4481JMusser Fred R · Severna Park, MDFirst renewal noticeBuilt 1967 · S/N 28-22898N4481XSpence Johnn · Apache Junction, AZS/N 28-7625042N44820Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816022N4482JWebe Properties LLC · Toledo, OHBuilt 1967 · S/N 28-22899N4482TIdeal Aviation LLC · Auburn, PABuilt 1972 · S/N 28-7205169N44836Monadnock Aviation Inc · Keene, NHBuilt 1977 · S/N 28-7816025N4483FHill Patrick E · Oceanside, CABuilt 1976 · S/N 28-7790031N4483JHelms Tate · Lake Charles, LABuilt 1967 · S/N 28-22900N4483TWaterboy Aviation LLC · Richlandtown, PABuilt 1972 · S/N 32-7240072N4483XBowers Gregory L · Greensboro, NCBuilt 1975 · S/N 28-7690020N44844Morland Robert L · Bowman, NDBuilt 1977 · S/N 28R-7703330N44845N44845 LLC · Ozark, MOBuilt 1977 · S/N 28R-7703331N44847Hill David F · Pembroke, MABuilt 1977 · S/N 28-7816026N4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLBuilt 1975 · S/N 28R-7635056N44851King Air Inc · Naknek, AKS/N 32-7740107N44855Marshall Xavier T · Carson, CAS/N 28-7816028N44858Swaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7816032N44859Tarcelo Francis Antonio G · Sun City, CABuilt 1977 · S/N 28R-7703333
Back to AD 87-08-08 R3