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.

N3972TQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 28R-30321N3972WMills Charles H · Ashburn, VABuilt 1967 · S/N 32-889N3972XSoares Jeffrey A · Aptos, CABuilt 1975 · S/N 28R-7535378N39731F5 Industries LLC · Tacoma, WAS/N 28-7916002N39732Love Richard F · Egg Hbr Twp, NJBuilt 1978 · S/N 28-7990013N39739Vy Partners LLC · Louisville, KYBuilt 1978 · S/N 28-7990015N3973TMeissner Edward T · Hartland, WIBuilt 1967 · S/N 28R-30322N39744Mytrex Properties LLC · South Jordan, UTBuilt 1978 · S/N 32R-7887159N39747Cardano Aviation LLC · Newton, NCBuilt 1978 · S/N 28-7990016N39749Lentz Kenneth C · Gaylord, MIBuilt 1978 · S/N 28-7990017N3974MValia Sachin N · Landis, NCBuilt 1978 · S/N 28-7816394N3974RAuclair Bill T DBA · Winsted, CTBuilt 1971 · S/N 28-7105080N39751Phoenix Aviation Inc · Portland, ORS/N 32R-7885244N3975KGlissman Robert D · Mystic, CTBuilt 1967 · S/N 28-23861N39771Ainley Alan · Paragould, ARBuilt 1978 · S/N 32-7840177N39773Brittain Brett · Clinton, OKBuilt 1978 · S/N 32R-7887164N3977RSusens Dennis W · Columbia Falls, MTBuilt 1971 · S/N 28-7105082N3977TBeauman James · Indianapolis, INBuilt 1967 · S/N 28R-30327N3979KGrams Terry · Smithville, MOBuilt 1967 · S/N 28-23866N3979RClinton Flying Service Inc · Clinton, NCBuilt 1971 · S/N 28-7105084N397FAPiper Aircraft Inc · Vero Beach, FLS/N 28010097N397WNWillis Donald C · Telford, TNS/N 28-43070N3980KStephen Reinhart Air LLC · Depew, NYBuilt 1967 · S/N 28-23867N3980RMayor Michael E · Union, KYS/N 28-7105085N3980UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842221N3980WJohnson Ralph W · Shelbyville, TNBuilt 1967 · S/N 32-948N3981KLenko David J · Smyrna, DEBuilt 1967 · S/N 28-23869N3981WDream LLC · Middletown, DEBuilt 1967 · S/N 32-950N3982KElson Irving A · Rockville, MDBuilt 1967 · S/N 28-23871N3982WStrassfield Justin · Moyock, NCBuilt 1967 · S/N 32-951N3982XSauve Tiffany A · Racine, WIBuilt 1975 · S/N 28R-7535382N3983KDetroit Piper Sales & Service Inc · Pontiac, MIRegistration revokedBuilt 1967 · S/N 28-23872N3984RThompson Jim R · Holdenville, OKBuilt 1971 · S/N 28-7105088N3984TParidee Kevin M Jr · Cumming, GABuilt 1967 · S/N 28R-30335N3985RRealm Group Transport Inc · Las Vegas, NVS/N 28-7105089N3986WDelaware Flyers Inc · Fort Wayne, INBuilt 1967 · S/N 32-957N3986XFitzwater Randy · Patterson, MOS/N 28-7515439N3987WPhipps Robert Sean · Euless, TXS/N 32-959N3987XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 28-7505253N3988TPalmetto Standard Aviation LLC · Spartanburg, SCBuilt 1967 · S/N 28R-30340N3988WGrant Robert M Trustee · Farmington Hills, MIBuilt 1967 · S/N 32-960N3988XMohlenkamp Jami S · Erie, COBuilt 1975 · S/N 28R-7635002N3989FWfc Aviation Inc · Johnstown, PABuilt 1976 · S/N 28-7615435N3989KWeese John G · Fort Worth, TXS/N 28-23879N3989RTemple Barbara A · Canyon City, ORBuilt 1971 · S/N 28-7105093N3989WHigher Plane Inc · Wilton Manors, FLBuilt 1967 · S/N 32-893N3989XEdgar Mary E · Butler, TNBuilt 1975 · S/N 32-7640007N398FAPiper Aircraft Inc · Vero Beach, FLS/N 28010098N398HCoco Aircraft Inc · Merritt Island, FLBuilt 1984 · S/N 288516062N398TCC & H Air Direct Flight Service Inc · Wilmington, DEBuilt 1998 · S/N 3257057
Back to AD 87-08-08 R3