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.

N6077WParrish Stephen W · Minneola, FLBuilt 1964 · S/N 28-20090N6079WAmos Warren E · Cypress, TXBuilt 1964 · S/N 28-20092N6086WPegasus Ir LLC · Miami, FLBuilt 1964 · S/N 28-20100N6091WN6091w LLC · Orange Park, FLS/N 28-20105N6092WBoling Bret J · Wichita, KSS/N 28-20106N6093WLee Richard L · Bowie, TXBuilt 1964 · S/N 28-20107N6097WWallette Robert Michael · Port Saint Lucie, FLBuilt 1964 · S/N 28-20111N6098WFall Line Aviation LLC · Augusta, GAS/N 28-20112N6101WStuder Joseph D · Troy, KSBuilt 1964 · S/N 28-20115N6105WBlackwell Mario S · Lathrop, CABuilt 1964 · S/N 28-20119N6109JKane Michael Vincent II · Virginia Beach, VAS/N 28-7625219N6109WCity Of Westfield · Westfield, MABuilt 1964 · S/N 28-20123N610FLRoberts John R Jr · Homestead, FLS/N 28-7125488N610SHSeto Christopher · Seattle, WABuilt 1972 · S/N 28-7305139N6110WZimmerman David A · Memphis, TNBuilt 1964 · S/N 28-20125N6112WRoberts Jackie P · Bangs, TXBuilt 1964 · S/N 28-20127N6113WMurray Brian C · Jonesboro, ARS/N 28-20128N6114WGottschalk William R · Fort Atkinson, WIBuilt 1964 · S/N 28-20129N6116WKlyder Thomas A · Inverness, FLS/N 28-20131N6117WRoesler Robert D · Gordonsville, VAS/N 28-20132N6118WPiekielek John L · Punxsutawney, PABuilt 1964 · S/N 28-20133N611FLZipp Nicole E · Raleigh, NCBuilt 1971 · S/N 28-7125489N611VMCavender Jake Scott · Jacksonville, FLBuilt 1971 · S/N 28-7125344N611VWAlley Mark Z · Cedar City, UTS/N 28-20130N6121WRadius Aviation LLC · Fort Rucker, ALBuilt 1964 · S/N 28-20137N6122WN6122w LLC · Tillamook, ORS/N 28-20138N6126WMatthews James C · Gilbert, SCBuilt 1964 · S/N 28-20142N6127WLa Aviation Ltd · Wilmington, DES/N 28-20143N6129JBlue Skies Aircraft LLC · Kalispell, MTBuilt 1976 · S/N 28-7625221N612LCGoodman Lawrence A · Granbury, TXBuilt 1969 · S/N 28-26033N6134WRegistration Pending · Mesa, AZRegistration pendingBuilt 1964 · S/N 28-20151N6135WWhiskey Aviation LLC · Huntsville, ALBuilt 1964 · S/N 28-20152N6137WPrepmasters Inc · Boynton Beach, FLS/N 28-20134N6138VGlover Michael M · Mechanicsville, VABuilt 1968 · S/N 28-23988N6139WFleetwood James D · French Lick, INBuilt 1964 · S/N 28-20157N613FLOwens William N · Lexington, NCBuilt 1971 · S/N 28-7125492N6140WKing Donna K · Mount Pleasant, MIBuilt 1964 · S/N 28-20158N6142WBurns Robert J · Loxahatchee, FLBuilt 1964 · S/N 28-20160N6144WFiebelkorn Daniel S · Gregory, SDBuilt 1964 · S/N 28-20162N6145WRegistered aircraftS/N 28-20163N6147WLister Stephen J · Sherman, ILBuilt 1964 · S/N 28-20166N6148WAir Ventures Flying School LLC · Smithfield, RIBuilt 1964 · S/N 28-20167N614973 Dudes 1 Plane LLC · Olympia, WABuilt 1976 · S/N 28-7625109N614FLEagle Sky Patrol Inc · Deadwood, SDBuilt 1971 · S/N 28-7125493N614WTJamestown Jet Center Inc · Jamestown, NDBuilt 1968 · S/N 28-23777N6152WRogers Samuel I · Leroy, KSBuilt 1964 · S/N 28-20171N6156WHousley Steven W · Hot Springs, SDS/N 28-20175N6157JSale Reported · Columbus, OHSale reportedBuilt 1976 · S/N 28-76-25224N6157WLaminar Skies Aviation LLC · Broken Arrow, OKBuilt 1964 · S/N 28-20176N6159WSale Reported · San Luis Obispo, CASale reportedBuilt 1964 · S/N 28-20178
Back to AD 96-10-01 R1