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.

N4485FSaunders Raymond C III · Albuquerque, NMBuilt 1976 · S/N 28-7790033N4485TKreigh Kevin M · Auburn, INBuilt 1972 · S/N 28-7225161N4485XL & A Bennett Second Family Lp · Renton, WAS/N 32-7640026N44862Red Arrow III LLC · Carson City, NVBuilt 1977 · S/N 28R-7703335N44863Jg Aviation LLC · Indianapolis, INBuilt 1977 · S/N 32R-7780544N4486FRegistration Pending · Hague, VARegistration pendingBuilt 1976 · S/N 28R-7635411N4486JHess Garrett J · Fullerton, CABuilt 1967 · S/N 28-22904N44872Allmond Aviation LLC · Peoria, ILBuilt 1977 · S/N 28-7816033N44884Rsi Transportation LLC · Kalispell, MTS/N 28-7816037N44886Personal Aviation Inc · Poway, CABuilt 1977 · S/N 28-7816038N44887Gabriel Robert A · Lancaster, PABuilt 1977 · S/N 28R-7737149N44889Gray Bradley D · Killeen, TXBuilt 1977 · S/N 28R-7703336N4488TN4488t LLC · Newport Beach, CABuilt 1972 · S/N 28R-7235035N4488XReklis Aviation LLC · Schaumburg, ILBuilt 1975 · S/N 28-7615019N44891Rci Asset Management Inc · San Diego, CABuilt 1977 · S/N 28R-7703339N44898Andel Robert M · Milford, CTBuilt 1977 · S/N 28-7816040N4489XFidelis Aviation LLC · Cornelius, NCBuilt 1975 · S/N 28-7690021N448AWeeke Aviation LLC · Kalispell, MTBuilt 1998 · S/N 3257034N448KGTondi David M · Sterling, VABuilt 1981 · S/N 32R-8113037N448MAReynolds Roger David · Key West, FLBuilt 1998 · S/N 3257048N448MJWilson Darrell Gene III · Mcpherson, KSBuilt 1966 · S/N 32-772N448PValiair Limited Company · Casper, WYS/N 28R7703058N448RMPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020287N448ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881673N44903Treehouse Aviation LLC · Tuscaloosa, ALBuilt 1977 · S/N 28R-7703341N4490JAmes Bradley · Bushland, TXBuilt 1967 · S/N 28-22908N44929Registered aircraftS/N 28-7816044N44931H&R Aircraft Co LLC · Ward, ARBuilt 1977 · S/N 28-7816046N4493FMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7715041N4493JBrown Henry T · Cairo, GABuilt 1967 · S/N 28-22911N44941Herboldsheimer Dixon · Westminster, COBuilt 1977 · S/N 28R-7703344N44944Karimi Enterprises LLC · Myrtle Beach, SCBuilt 1977 · S/N 32-7740113N44949Shoreline Aviation Inc · Marshfield, MABuilt 1977 · S/N 28-7816050N4494JAldrich Matthew H · Corinth, TXBuilt 1967 · S/N 28-22913N4495FKitty Tango LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7790034N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044N44962Johnson Bud W · Cedar City, UTBuilt 1977 · S/N 28R-7703350N44966Gillette Scott A · Lancaster, CABuilt 1977 · S/N 28R-7703351N4496FN4496f LLC · Provo, UTS/N 28-7790035N4496JOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-22915N4496XJennings Matthew · Valley Center, CAS/N 28-7690022N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045N4497FMurray David J · Waymart, PABuilt 1976 · S/N 28R-7635412N4497JStewarts Aircraft Service · Waynesville, OHBuilt 1967 · S/N 28-22916N4497TArrow97t Llp · Feeding Hills, MABuilt 1972 · S/N 28R-7235042N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023N4498FSapit Corp · Los Banos, CABuilt 1976 · S/N 32R-7680453N4498JHartshorn James · Las Vegas, NVBuilt 1967 · S/N 28-22919N4498TCunniff Jack S · Weymouth, MAFirst renewal noticeBuilt 1972 · S/N 28R-7235045
Back to AD 87-08-08 R3