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.

N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251N8866WPalmer Todd J · Sherrills Ford, NCBuilt 1964 · S/N 28-10421N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729N8867WPayne Jason S · Overgaard, AZBuilt 1964 · S/N 28-10422N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354N8868WBolton Barbara A · Alameda, CABuilt 1964 · S/N 28-10424N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731N8869WA&O Properties LLC · Harlan, IAS/N 28-10425N886ACAir Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881397N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262N886JHJpj Aviation Holdings LLC · Wilmington, DEBuilt 1981 · S/N 32R-8213006N8870EGriffin Robert B · Middletown, DEBuilt 1976 · S/N 28-7610089N8870JAsel LLC · North Charleston, SCS/N 28-2842N8870NRiley Dennis M · Surry, MEBuilt 1969 · S/N 28-25732N8871JJohnson Richard E · Mulberry, FLBuilt 1965 · S/N 28-2843N8871NCramer Michael L · Rockville Centre, NYBuilt 1969 · S/N 28-25733N8871WGutierrez Alajandro · Madison, MSBuilt 1964 · S/N 28-10428N8872JPriority Aviation LLC · Lewes, DES/N 28-2844N8873WGarza Reynaldo E · Corpus Christi, TXS/N 28-10430N8874CPleasant Valley Aviation Inc · Bellefonte, PABuilt 1976 · S/N 28-7625135N8874JMelland Curtis B · Hazen, NDBuilt 1965 · S/N 28-2847N8874NFisher Tim A · Stockton, MDBuilt 1969 · S/N 28-25737N8875NMcclendon Charles Dowel · Lynchburg, VABuilt 1969 · S/N 28-25738N8875WBryan Greg · Oelwein, IABuilt 1964 · S/N 28-10432N8876JDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2848N8877EParrot Flying LLC · San Francisco, CABuilt 1976 · S/N 28-7625162N8877WAvery Aviation LLC · Picabo, IDBuilt 1964 · S/N 28-10434N8878NCampbell Carl F · Amherst, NHBuilt 1969 · S/N 28-25741N8878WBallard Tim · Roseburg, ORS/N 28-10436N8879EFlickinger Charles P · Hermitage, PAS/N 28-7625163N8879JDaddona John M · Oakville, CTBuilt 1965 · S/N 28-2852N8879NBesheer Susan Anita · Palm Springs, CABuilt 1969 · S/N 28-25743N887KJCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2021 · S/N 28020025N8880NAnderson Aviation LLC · Bulverde, TXS/N 28-25744N8881WYellow Flyers Inc · Sioux Falls, SDBuilt 1964 · S/N 28-10440N8882FCirrus Services Inc · Fargo, NDBuilt 1976 · S/N 28-7715294N8882JWisian Hans C · Boerne, TXBuilt 1965 · S/N 28-2855N8882WFleet James Reginald Jr · Jacksonville, FLBuilt 1964 · S/N 28-10441N8883JRegistration Pending · Midlothian, TXRegistration pendingBuilt 1965 · S/N 28-2857N8883NWarner Alexander Douglas · Grand Rapids, MIBuilt 1969 · S/N 28-25749N88847So-Do Holdings LLC · Monticello, GAS/N 32R-7680354N8884NDubois Jerry · Oklahoma City, OKBuilt 1969 · S/N 28-25750N8884WFolse Eldred · North Las Vegas, NVBuilt 1964 · S/N 28-10444N8885JWeise David D · Marion, TXBuilt 1965 · S/N 28-2859N8885WBarker Theo G T · Loveland, COBuilt 1964 · S/N 28-10445N8886WTuggle Rodney J · Kansas City, MOBuilt 1964 · S/N 28-10446N8887JWeskap LLC · West Grove, PABuilt 1965 · S/N 28-2862N8888JSnapp Steve J · Los Alamos, NMS/N 28-2863
Back to AD 87-08-08 R3