OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N9597JWingswat LLC · Placentia, CABuilt 1966 · S/N 28-3743N9598JMardis Andrew · Pelzer, SCBuilt 1966 · S/N 28-3744N9599CDomenico Joseph A · Saint Germain, WIBuilt 1978 · S/N 32-7840104N9599JOrban Kenneth D · Tellico Plains, TNBuilt 1966 · S/N 28-3745N9599WNelson Scott G · Lakota, NDS/N 28-23050N959ACQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 28R-8118009N959GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881473N959MMBugle Equipment And Leasing LLC · Houston, TXBuilt 2003 · S/N 3257325N95APWingnut Enterprises Inc · Sarasota, FLBuilt 1995 · S/N 32-46012N95BRChickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 28-25841N95EPFlying Cow LLC · Falls City, NEBuilt 1975 · S/N 32R-7680075N95HFEddings Samuel David · Camino, CABuilt 1973 · S/N 28R7335311N95JPKeller Justin Allen · Youngstown, FLBuilt 1973 · S/N 28-7305429N95PGAviation Sensation LLC · Clearwater, FLBuilt 1974 · S/N 28R-7535026N95QLoftis Philip D · Buckhannon, WVBuilt 1975 · S/N 28-7515408N95RAKennedy Crosswind LLC · Wellsburg, IABuilt 1973 · S/N 32-7440054N95TRegistered aircraftBuilt 1987 · S/N 3213003N95TSSkywest Leasing Inc · St George, UTBuilt 1997 · S/N 2843103N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505N9601JGevers Robert L · Lafayette, INBuilt 1966 · S/N 28-3747N9603WMoore Alan Ray · Glenwood, ARBuilt 1967 · S/N 28-23055N9605CA O G Aircraft Services LLC · Aberdeen, NJBuilt 1978 · S/N 28-7816502N9606WMandolesi Daniel Martin · Hulmeville, PABuilt 1967 · S/N 28-23059N9607CLmc Aviation LLC · Goleta, CABuilt 1978 · S/N 28-7890429N9607WK-9 Handler LLC · Henderson, NVBuilt 1967 · S/N 28-23060N9608JGomm Bruce J · Colfax, NDS/N 28-3754N9608KPiper Arrow N9608k LLC · Ann Arbor, MIBuilt 1976 · S/N 28R-7635250N9608WBright Skies Sales & Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-23061N9609JAdams Donald J · Lock Haven, PABuilt 1966 · S/N 28-3755N9609WCullen Michael R · Fort Mohave, AZBuilt 1967 · S/N 28-23062N960ACNaples Air Center Inc · Naples, FLBuilt 1990 · S/N 2841325N960WCStardust Aviation LLC · Farmingdale, NYBuilt 2000 · S/N 2843368N9611JStull Donald K · Catawba, NCBuilt 1966 · S/N 28-3761N9612JReich Gregory N · Schwenksville, PABuilt 1966 · S/N 28-3810N9612WJama Aviation LLC · Blaine, MNBuilt 1967 · S/N 28-23066N9613CSmall James F Jr · Great Mills, MDBuilt 1978 · S/N 28R-7803269N9613JKraun Fred M · Fall City, WABuilt 1966 · S/N 28-3766N9613WAir Wilma LLC · Tijeras, NMS/N 28-23067N9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTBuilt 1978 · S/N 32-7840106N9614JSkinner Roger · Delanson, NYBuilt 1966 · S/N 28-3767N9614WByrne Matthew A · West Allis, WIBuilt 1967 · S/N 28-23069N9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCBuilt 1978 · S/N 32-7840107N9616JGarsteck Paula · Put In Bay, OHBuilt 1966 · S/N 28-3769N9616WKohut Jeanette G · Southern Pines, NCBuilt 1967 · S/N 28-23071N9617CPete And Pete Sales Inc · Williamsville, NYBuilt 1978 · S/N 32R-7885060N9617JBeaverdam Aeronautics LLC · Chatom, ALBuilt 1966 · S/N 28-3771N9617WPoskevich Douglas P · Deland, FLS/N 28-23072N9619JFlick Kristina R · Port Ewen, NYBuilt 1966 · S/N 28-3773N9619WId Rather Knot LLC · Louisville, KYBuilt 1967 · S/N 28-23075N961ABPiper Aircraft Inc · Vero Beach, FLS/N 28010089
Back to AD 87-08-08 R3