OpenAirDocs.org
AD 95-19-15 R1

Registered aircraft · 1,889

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:95-19-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1')
  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.

N28810Air & Road Sports Inc · Las Vegas, NVBuilt 1978 · S/N AA5B0834N28815Registered aircraftBuilt 1978 · S/N AA5B0836N28819Sun Samuel K · San Diego, CABuilt 1978 · S/N AA5B0838N28831Stewart William G · Thousand Oaks, CABuilt 1978 · S/N AA5B0842N28834Vogel Victor H Trustee · Loveland, OHBuilt 1978 · S/N AA5B0844N28838Giuffre Matthew S · The Villages, FLBuilt 1978 · S/N AA5B0726N28839Turgeon Douglas · Anderson, SCBuilt 1978 · S/N AA5B0846N28840Weld&Fly Lc · Crandall, GAS/N AA5B0847N28847Mayeda Ronald K · Foster City, CABuilt 1978 · S/N AA5B0851N28848Voltz John H · Alexandria, LABuilt 1978 · S/N AA5B0852N28854Air Devices Co LLC · Alpena, MIBuilt 1978 · S/N AA5B0861N28856Thompson Mitchell L · Exton, PABuilt 1978 · S/N AA5B0863N28857Sentell Charles S III · Minden, LABuilt 1978 · S/N AA5B0864N28859Newman Richard Donald · Mercer Island, WABuilt 1978 · S/N AA5B0866N28863Koleszar John R · Lynnfield, MABuilt 1978 · S/N AA5B0870N28865Maritime Aviation LLC · Kalispell, MTBuilt 1978 · S/N AA5B0871N28866Marcoski Edward T · Downers Grove, ILBuilt 1978 · S/N AA5B0872N28869Registered aircraftBuilt 1978 · S/N AA5B0874N28878Alsup Patrick J · League City, TXBuilt 1978 · S/N AA5B0876N28879Cady Eugene Roland · Port Orange, FLBuilt 1978 · S/N AA5B0877N28881Buttery Craig B · Loxahatchee, FLBuilt 1978 · S/N AA5B0878N28893Janzen Andrew S · Oklahoma City, OKBuilt 1978 · S/N AA5B0753N28896Pafford David A · Floydada, TXS/N AA5B0752N288CFAdams Charles R · Granbury, TXBuilt 1978 · S/N AA5B0840N288HCLampe Erik J · Appleton, WIBuilt 1992 · S/N 10101N28917Turnage Andrew · Houston, TXBuilt 1978 · S/N AA5B0888N28923Brown Robert · Rye, NHBuilt 1978 · S/N AA5B0890N28927Platt Jeremie Aaron · Rich Hill, MOBuilt 1978 · S/N AA5B0894N28929Ramsay Farms And Elevator · Rockville, INS/N AA5B0895N28930Mayer Steven T · Aurora, ORBuilt 1978 · S/N AA5B0896N28948Badowski Eric W · Plano, TXBuilt 1978 · S/N AA5B0902N28950Fischer Andrea D · Belleville, KSBuilt 1978 · S/N AA5B0903N28969Silva Carlos A · Massapequa, NYBuilt 1978 · S/N AA5B0911N28976Kirby Benjamin · Colorado Springs, COBuilt 1978 · S/N AA5B0914N28981Walker William B · Spokane, WABuilt 1978 · S/N AA5B0919N28983Radel Anne-Marie · West Hills, CABuilt 1978 · S/N AA5B0921N28986Recreation Plus Inc · London, OHBuilt 1978 · S/N AA5B0922N289915 By 5 Aircraft LLC · New Braunfels, TXBuilt 1978 · S/N AA5B0926N28993Fradkin Tyler Jacob · Redondo Beach, CABuilt 1978 · S/N AA5B0927N28995Carlson Linda · Broomfield, COBuilt 1978 · S/N AA5B0929N28996H&A Aviation Lc · Hanover, VABuilt 1978 · S/N AA5B-0930N28998Clark Glenn W · Mary Esther, FLS/N AA5B0933N289HFLiegl Benjamin A · Fort Worth, TXBuilt 1977 · S/N AA5B0686N28GMForinger Mark A · Pinehurst, NCBuilt 1976 · S/N AA5A0272N28HGHill Donald G · Westerly, RIBuilt 1978 · S/N AA5B0868N28KWGrumman Girl LLC · Brooklyn, NYBuilt 1991 · S/N 10085N2EEMatthews Mark A · Independence, ORBuilt 1975 · S/N AA5B-0064N2GDGarland Gary · Oakhurst, OKBuilt 1979 · S/N AA5B1149N2YLStroud John · Santa Fe, NMBuilt 1975 · S/N AA5B-0148N300BKManning Ryan E · Watsonville, CABuilt 1976 · S/N AA5B0335
Back to AD 95-19-15 R1