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.

N8794NCopeland Kevin D · Vidalia, GABuilt 1969 · S/N 28-25637N8795NCycle-Moto Inc · Gilbert, AZBuilt 1969 · S/N 28-25639N8796NMitchell Michael R · Swanville, MEBuilt 1969 · S/N 28-25640N8799NDuffe William B · Moscow, IABuilt 1969 · S/N 28-25643N8800JRobinson Jacob · Lewistown, MTS/N 28-2745N8802JShivers James C II · Columbus, OHBuilt 1965 · S/N 28-2750N8804JClosen David A · Comanche, TXS/N 28-2754N8804NCarbon Regional Aero Club · Lehighton, PABuilt 1969 · S/N 28-25649N8805J8805 Partners LLC · Oklahoma City, OKBuilt 1965 · S/N 28-2755N8806JLytle Hugh R · Senoia, GABuilt 1965 · S/N 28-2756N8806NHorne Terry A · Carefree, AZBuilt 1969 · S/N 28-25652N8807JNorris Dana G III · Zanesville, OHS/N 28-2757N8807NTruax James D · Roanoke, INBuilt 1969 · S/N 28-25653N8808JCoulliette Brian K · Jacksonville, FLBuilt 1965 · S/N 28-2758N8810NShawl Robert M · Woodlake, CABuilt 1969 · S/N 28-25657N8813NLangton Shane A · Boise, IDBuilt 1969 · S/N 28-25660N8814JCarey H Dwain · Cheyenne, WYBuilt 1965 · S/N 28-2766N8814NMarshall Lance A · Portland, ORBuilt 1969 · S/N 28-25661N8815NJenkins Roger Clayton II · Plain Dealing, LABuilt 1969 · S/N 28-25663N8816JHuff Roger A · Johnstown, OHBuilt 1965 · S/N 28-2770N8817CSharon Ricky E · Roberta, GABuilt 1976 · S/N 28-7625132N8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1965 · S/N 28-2771N881TAMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3023N8820EDishman John David · Brooklyn, NYBuilt 1976 · S/N 28-7625161N8820JSurles Willian T · Chuckey, TNBuilt 1965 · S/N 28-2774N8821JJanssen Brittney Juen · Pleasantville, IABuilt 1965 · S/N 28-2775N8822NFirestine Joseph W · Atwater, CABuilt 1969 · S/N 28-25670N8823JBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2778N8823NAvia Flight Academy · Stratford, CTBuilt 1969 · S/N 28-25671N8824JJohnson Lawrence F · Ancorage, AKBuilt 1965 · S/N 28-2779N8824NDale Keith Wayne · Gurdon, ARBuilt 1969 · S/N 28-25672N8825JAlexander Carol E · Pineville, LABuilt 1965 · S/N 28-2780N8825NMissouri River Flying Club LLC · Mandan, NDBuilt 1969 · S/N 28-25673N8826NWg Aviation LLC · Shippenville, PABuilt 1969 · S/N 28-25675N8830JAnderas Per R · Green Bay, WIBuilt 1965 · S/N 28-2927N8831NAllen Aviation LLC · Mansfield, MABuilt 1969 · S/N 28-25682N8832JN597w Llp · Arnold, MDBuilt 1965 · S/N 28-2788N8835NRegistered aircraftS/N 28-25685N8836JSonic Skunk Works LLC · Houston, TXBuilt 1965 · S/N 28-2793N8837JJerry Wachtel N · Carleton, NEBuilt 1965 · S/N 28-2794N8837NAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1969 · S/N 28-25688N8838JSchlensig Randall D · Anthem, AZBuilt 1965 · S/N 28-2795N8839JPadgett John E · Austin, TXS/N 28-2796N8839NCooper Thomas J · Henderson, NVBuilt 1969 · S/N 28-25690N883CFolkers Daniel E · Norwalk, IABuilt 1973 · S/N 28-7325345N883MMoffett James D · North East, MDBuilt 1969 · S/N 28-26047N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799N8843JDiorio Christopher J · Melba, IDS/N 28-2801
Back to AD 96-10-01 R1