OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N7924WStumpner Van H · Warsaw, MOBuilt 1964 · S/N 28-1963N7927WFlight 4 U LLC · Lakeport, CABuilt 1964 · S/N 28-1967N7928CCash Management Consulting LLC · Granite Springs, NYBuilt 1975 · S/N 28-7625088N7929WStevenson Robert F · Wilmington, DEBuilt 1964 · S/N 28-1970N7930NMerrill Erich W III · Corvallis, ORBuilt 1969 · S/N 28-5341N7930WFleenor Robert S · Scottsburg, INBuilt 1964 · S/N 28-1971N7931NScott Lindbloom · Ft Wright, KYBuilt 1969 · S/N 28-5342N7932NMyers Richard J · Lebanon, TNBuilt 1969 · S/N 28-5343N7932WBlaine Richard A Jr · Boardman, OHBuilt 1964 · S/N 28-1973N7933NCc Aero Services LLC · Bullard, TXBuilt 1969 · S/N 28-5344N7934WAir Roanoke Ltd · Roanoke, VABuilt 1964 · S/N 28-1975N7935NTorrington Flying Club Inc · Torrington, WYBuilt 1969 · S/N 28-5347N7935WRather Be Flying LLC · New Castle, DEBuilt 1964 · S/N 28-1976N7936WHiller Jeron P · Marshfield, WIBuilt 1964 · S/N 28-1978N7937WYang Zhongyi Deroll · Oro Valley, AZBuilt 1964 · S/N 28-1979N7938WPiper Club LLC · Atkinson, NEBuilt 1964 · S/N 28-1980N7939NOrama Jorge H · Fort Myers, FLBuilt 1969 · S/N 28-5351N7939WCaviation LLC · Columbus, NES/N 28-1981N7940NCloudburst Resources Inc · Lavonia, GABuilt 1969 · S/N 28-5355N7940WMurray Air LLC · Patoka, ILS/N 28-2051N7941NHonke Richard · Lake Andes, SDBuilt 1969 · S/N 28-5356N7941WHansen Brandon C · Hyde Park, UTBuilt 1964 · S/N 28-1982N7943WBlue Ridge Aviation Services LLC · Ridgeway, VABuilt 1964 · S/N 28-1985N7944NInspire Aviation LLC · Magnolia, TXBuilt 1969 · S/N 28-5360N7944WPadisak Michael · Traverse City, MIBuilt 1964 · S/N 28-1987N7945NWittenbrader Jeffrey M · Lake Ariel, PABuilt 1969 · S/N 28-5361N7945WOnward Enterprises LLC · Laurel, MSBuilt 1964 · S/N 28-1989N7946NSommer Matthew D · Whiteford, MDBuilt 1969 · S/N 28-5362N7946WCushman Jeffrey R · Superior, WIBuilt 1964 · S/N 28-1990N7948NHayes William B · Saint Charles, MOBuilt 1969 · S/N 28-5364N7948WCruse Billy · North Bend, WAFirst renewal noticeS/N 28-1992N7949NGuess-Slatosky Carrie · Randleman, NCBuilt 1969 · S/N 28-5365N7951WHerman Eric M · Hugo, MNBuilt 1964 · S/N 28-1998N7953CFox Victor Aircraft & Sales LLC · Lebanon, TNBuilt 1975 · S/N 28-7625090N7953WMcdaniel James D · Ortonville, MIBuilt 1964 · S/N 28-2001N7954NW8s Enterprises LLC · Stillwater, OKBuilt 1969 · S/N 28-5370N7955NByrne Daryl K · Eagle, IDBuilt 1969 · S/N 28-5371N7955WLucas William J · Cochran, GABuilt 1964 · S/N 28-2003N7956WBartlett Henry D · Colorado Springs, COBuilt 1964 · S/N 28-2005N7957WKendry Shane Joseph · Panama City, FLBuilt 1964 · S/N 28-2006N7959WNorman Jeremy J · Morgantown, WVBuilt 1964 · S/N 28-2008N795CWNemish John M · Suffolk, VABuilt 1964 · S/N 28-2002N7960NJenkins James Randal · Yukon, OKBuilt 1969 · S/N 28-5376N7961NRegistered aircraftBuilt 1969 · S/N 28-5377N7961WMoore Donald A · Livingston, MTBuilt 1964 · S/N 28-2010N7962NFisher Albert Lee III · Oshkosh, WIBuilt 1969 · S/N 28-5378N7962WHoffman Donald A · Boynton Beach, FLBuilt 1964 · S/N 28-2011N7963NJohnson Dennis E · Factoryville, PABuilt 1969 · S/N 28-5379N7963WRichardson Douglas M · Westminster, COBuilt 1964 · S/N 28-2012N7964NLoar Kenneth Joseph Jr · Mundelein, ILBuilt 1969 · S/N 28-5380
Back to AD 96-10-01 R1