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.

N28512Brownfield Izzy · Denton, TXS/N AA5B0648N28515Registered aircraftBuilt 1977 · S/N AA5B0657N28519Sopwith Camel Flying Club LLC · Salt Lake City, UTS/N AA5B0658N28526Christensen James C · Dayton, OHBuilt 1977 · S/N AA5B0659N28531Hedden James A · Easton, PABuilt 1977 · S/N AA5B0661N28532Alluris Aviation LLC · Port Charlotte, FLS/N AA5B0662N28534Johnston Alan · Michigan City, INBuilt 1977 · S/N AA5B0663N28536Dynamic Aero Inc · Overland Park, KSS/N AA5B0665N28537Checkerboard Aviation LLC · Valdosta, GABuilt 1977 · S/N AA5B0666N28538Hawthorn Benjamin R · Cedar Park, TXS/N AA5B0667N28541Kdh Inc · Dover, DES/N AA5B0668N28548Slate James L · Mooresville, NCS/N AA5B0671N28550C W Flyers Inc · Wausau, WIBuilt 1977 · S/N AA5B0673N28557Registered aircraftBuilt 1977 · S/N AA5B0680N28558Levasseur Arnold O · Sandy Valley, NVBuilt 1977 · S/N AA5B0681N28560Hemphill Thomas N · Valencia, CABuilt 1977 · S/N AA5B0682N28565Jenks David R · Hernando, FLBuilt 1977 · S/N AA5B0684N28569Harper James Barry · Cimarron, NMBuilt 1977 · S/N AA5B0685N28572Peck Jeff · Denton, TXS/N AA5B0688N28573Bearpaw Aviation LLC · Brookfield, WIBuilt 1977 · S/N AA5B0689N28575Maxwell Jay Nate · Cookeville, TNBuilt 1977 · S/N AA5B0690N28583Mcgee Michael R · Mamou, LABuilt 1977 · S/N AA5B0691N28584Cereal City Flying Club LLC · Battle Creek, MIBuilt 1977 · S/N AA5B0692N28590Olson William A · Lebanon, OHS/N AA5B0695N28591Toher Wayne R · Danbury, CTBuilt 1977 · S/N AA5B0696N28593Mcmillan David S · Rangeley, MEBuilt 1978 · S/N AA5B0697N28604Quest Technical Sales & Marketing Inc · Westlake Village, CABuilt 1978 · S/N AA5B0701N28610Brown Ryan O · Columbia, TNBuilt 1977 · S/N AA5B0677N28611Campbell Soren · Asheville, NCS/N AA5B0649N28618Morgan Robert J · Mojave, CABuilt 1978 · S/N AA5B0707N28622Cole Quentin P · Huntingdon Valley, PABuilt 1978 · S/N AA5B0708N28630Flying Tiger LLC · Chesapeake, VABuilt 1978 · S/N AA5B0711N28631Perry Colin C · Petaluma, CABuilt 1978 · S/N AA5B0712N28633Fritz William J · Carnesville, GABuilt 1978 · S/N AA5B0713N28634Wolvin Michael S · N Fort Myers, FLBuilt 1978 · S/N AA5B0714N28635N28635 LLC · Harding, PABuilt 1978 · S/N AA5B0715N28637Rust Scott Allen · Indianapolis, INBuilt 1978 · S/N AA5B0716N28639International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N AA5B0718N28641Cpr Pacific LLC · Salinas, CABuilt 1978 · S/N AA5B0719N28646Kutok Stephen M · Commack, NYBuilt 1978 · S/N AA5B0721N28650Loseka Tiger LLC · Columbia, ILBuilt 1978 · S/N AA5B0723N28651Dass Aaron · Conroe, TXBuilt 1978 · S/N AA5B0724N28655Straight & Level Aviation LLC · Bradenton, FLBuilt 1978 · S/N AA5B0731N28657Gutelius Kenneth · Lake Orion, MIBuilt 1978 · S/N AA5B0733N28658Hadden Aviation LLC · Sylacauga, ALBuilt 1978 · S/N AA5B0734N28659Timidaiski Daniel · Mikilteo, WABuilt 1978 · S/N AA5B0735N28663Ramsey Kelly · Argyle, TXBuilt 1978 · S/N AA5B0737N28664Aces Flying Services LLC · Sanford, NCBuilt 1978 · S/N AA5B0738N28672Woyshnis Kyle · Port Orchard, WABuilt 1978 · S/N AA5B0745N28673Da Silva Raul L · San Francisco, CAS/N AA5B0746
Back to AD 95-19-15 R1