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.

N8940JMullins David H · Zebulon, GABuilt 1965 · S/N 28-2958N8941JTilghman Michael B · Salisbury, MDBuilt 1965 · S/N 28-2959N8943JHuber Steven C · Hernando, MSBuilt 1966 · S/N 28-2961N8945JFischer Thomas F · Troy, ILBuilt 1965 · S/N 28-2963N8946J2mec Holdings LLC · Kalispell, MTBuilt 1965 · S/N 28-2964N8948JAlbright Frank E · Ashley, INS/N 28-2968N8949JSchmidt Roger L · Plattsmouth, NEBuilt 1965 · S/N 28-2969N8951JMoehle Colleen M · Lincoln, ILBuilt 1966 · S/N 28-2971N8952JSolley Aviation LLC · Nebo, NCS/N 28-2972N8956JBays Bob D · Jasper, MOBuilt 1965 · S/N 28-2977N8957CTracon Aviation LLC · Winter Springs, FLBuilt 1976 · S/N 28-7625137N8957JAirplane LLC · Farmington, UTBuilt 1965 · S/N 28-2978N8958CWinter John T · Tucson, AZBuilt 1976 · S/N 28-7625138N8958JDavis William M · New Lenox, ILBuilt 1966 · S/N 28-2979N8959JRegistration Pending · Fairmont, WVRegistration pendingS/N 28-2980N8960JRegistered aircraftFirst renewal noticeBuilt 1965 · S/N 28-2982N8962JStory Allen D · Arlington, TXBuilt 1965 · S/N 28-2984N8965JN8965j LLC · Anchorage, AKBuilt 1966 · S/N 28-2987N8966JBrown Bradford K · Leoti, KSBuilt 1965 · S/N 28-2988N8967JJust Plane Fun LLC · Sunrise, FLBuilt 1965 · S/N 28-2990N8968JStevens Raymond W · Norfolk, VAS/N 28-2991N896CFMiles Air Leasing LLC · Canonsburg, PABuilt 1968 · S/N 28-4852N8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996N8976JGreat Plains Aviation LLC · Lincoln, NEBuilt 1966 · S/N 28-2999N8977JJohnson Bradley F · West Babylon, NYBuilt 1966 · S/N 28-3000N897MBJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-21978N8983JStensrud Maynard R · Waseca, MNBuilt 1966 · S/N 28-3006N8984JKlassen Wayne V · New Ulm, MNBuilt 1965 · S/N 28-3007N8986JKleinberg Kenneth A · Saugerties, NYBuilt 1965 · S/N 28-3009N8988JMerkle Hunter T · Mattawa, WABuilt 1966 · S/N 28-3011N8989JJohnston Family Clinic Inc · Meridian, MSS/N 28-3012N8990JStites Charles Harold · Chapel Hill, NCBuilt 1966 · S/N 28-3014N8991JCavoto Allyn E III · Adrian, PABuilt 1965 · S/N 28-3015N8992JMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1965 · S/N 28-3016N8993JHealy Law Offices Pc · Tyler, TXBuilt 1965 · S/N 28-3017N8994JBatham Carin C · Yuba City, CABuilt 1965 · S/N 28-3018N8995JBloomquist Eric R · Phoenix, AZBuilt 1965 · S/N 28-3019N8997JKakuska Michael · Madison, WIBuilt 1965 · S/N 28-3021N8998JObrien Robert · Warrens, WIBuilt 1966 · S/N 28-3022N89YBGnoss Field Flying Club · Fairfax, CAS/N 28-1553N8CNDominguez Jake R · Menifee, CABuilt 1966 · S/N 28-22301N8ERJcr Aviation LLC · Rock Hill, SCBuilt 1966 · S/N 28-3307N8MLCarlson Chad E · Downers Grove, ILBuilt 1972 · S/N 28-7205259N8ZWMccarthy Edward D · New Milford, CTBuilt 1965 · S/N 28-2474N9001JZuckerman Kenneth · Grass Valley, CABuilt 1966 · S/N 28-3026N9003JBlack David · Lakeville, MNBuilt 1966 · S/N 28-3028N9004JRegistration Pending · Los Angeles, CARegistration pending, pending cancellationBuilt 1966 · S/N 28-3029
Back to AD 96-10-01 R1