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.

N874ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881388N874MAPilipis Maximiliano · Brooksville, FLBuilt 2007 · S/N 3232074N874PAFf22 LLC · Scottsdale, AZS/N 2881339N874WVHolt George A · Santa Clarita, CAS/N 28-7610137N8750ECrosscheck Ftc LLC · Greeneville, TNBuilt 1976 · S/N 28-7690197N8750NMidwest Avionics LLC · Peculiar, MOBuilt 1969 · S/N 28-25570N8750WFinn Kalyn · New Berlin, WIBuilt 1964 · S/N 28-10290N8751EHansen William L · Shasta Lake, CABuilt 1976 · S/N 28-7690198N8752EH & T Air LLC · Huron, SDBuilt 1976 · S/N 32R-7680173N8752WMagalhaes Paulo · Pompano Beach, FLBuilt 1964 · S/N 28-10292N8753NWright Pamela J · Easton, PABuilt 1969 · S/N 28-25573N8753WDavis Glenn S · Berlin, CTBuilt 1964 · S/N 28-10293N8754ESix Two Seven Aviation LLC · Sardis, MSBuilt 1976 · S/N 28-7625155N8755EGokoffski Anthony · Larkspur, CAS/N 28-7690200N8755WAndersen Troy L · Longmont, COBuilt 1964 · S/N 28-10295N8756CDt Aviation LLC · Ontario, CABuilt 1976 · S/N 28-7615125N8756EHowell Richard · Louisville, KYS/N 28-7690201N8756WSandidge Tate · Stearns, KYBuilt 1964 · S/N 28-10296N8757ELa Copious LLC · Pinetop, AZFirst renewal noticeS/N 28R-7635211N8757N57 November LLC · Charlotte, NCBuilt 1969 · S/N 28-25576N8758EMiller Kevin · Dover, DEBuilt 1976 · S/N 28R-7635212N8759EN8759e LLC · Wilmington, DES/N 32R-7680174N8759NDisanto Rocco F · Morganton, NCBuilt 1969 · S/N 28-25580N8759WBig Sky Air LLC · Cedar Rapids, IABuilt 1964 · S/N 28-10299N875CFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020102N875DSHall Christopher L · West Bloomfield, MIS/N 28-7410102N875GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881069N875SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881744N8760CReindl Thomas A · Algonquin, ILBuilt 1976 · S/N 28-7615126N8760EArchie Airways LLC · Durant, OKBuilt 1976 · S/N 32R-7680175N8760WCarlsbad Raceway Corp · Hemet, CABuilt 1964 · S/N 28-10300N8761FCook William M · Warsaw, INS/N 28-7790265N8761WMakeev Alexandre · Concord, CABuilt 1964 · S/N 28-10301N8762EPrewitt Russell · Statham, GABuilt 1976 · S/N 28-7625156N8762NKlyc Aviation LLC · Lake City, FLBuilt 1969 · S/N 28-25582N8763EBodwell Keith J · West Cornwall, CTS/N 28-7615160N8763NNardi Rocky · Floyds Knobs, INBuilt 1969 · S/N 28-25585N8763WGoldsworthy Joe E · Buckeye, AZBuilt 1964 · S/N 28-10303N8764CMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7690160N8764EFa40 Plane LLC · New Port Richey, FLBuilt 1976 · S/N 28-7690202N8764WJohnson Walter R · Chuckey, TNBuilt 1964 · S/N 28-10304N8765CLatitude Aviation LLC · Spring, TXBuilt 1976 · S/N 28-7690161N8765EMoore Alex W · Deep Gap, NCBuilt 1976 · S/N 28-7690203N8765FSmith Nelson · Brighton, IAS/N 28-7790266N8766ELoose Larry A · Jamestown, NDBuilt 1976 · S/N 28R-7635213N8766WKeesling Roger Lynn · Starkville, MSS/N 28-10306N8767NAbernathy Larry D · Vernon, TXBuilt 1969 · S/N 28-25591N8768KRegistered aircraftS/N 32-7340149N8768NHammonds Benjamin J · Newcomerstown, OHS/N 28-25589N8768WMeyer Eric W · Derby, KSBuilt 1964 · S/N 28-10309
Back to AD 87-08-08 R3