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.

N809MAStraw Robert D · Farmington, MNS/N 28-23712N80PDGatpandan Grace Michele V · Martinez, CABuilt 1967 · S/N 28-4044N8100NSpeicher Peter · Grand Forks, NDBuilt 1968 · S/N 28-25288N8100WWaggoner Alan L · Blanchard, OKBuilt 1965 · S/N 28-2195N8101WMccooknet Inc · Mccook, NEBuilt 1965 · S/N 28-2197N8102WGutierrez Juan · Sarasota, FLBuilt 1965 · S/N 28-2198N8103WRegistration Pending · West Linn, ORRegistration pendingS/N 28-2201N8104CFly Cosah LLC · Kalamazoo, MIS/N 28-7625095N8104WJejgr LLC · Presho, SDBuilt 1965 · S/N 28-2203N8105WPrillwitz Robert L · Black River Falls, WIBuilt 1965 · S/N 28-2204N8109WEvans James F Jr · East Hartland, CTBuilt 1965 · S/N 28-2209N810MATody Mark H Sr · Grand View, WIBuilt 1967 · S/N 28-23846N8110WJanczura Boguslaw S · Park Ridge, ILBuilt 1965 · S/N 28-2210N8112WTomerlin Danny · Pulaski, TNBuilt 1965 · S/N 28-2214N8113WPridmore Joseph P · Columbus, MSBuilt 1965 · S/N 28-2217N8114WZimny Jaroslaw · KrasocinS/N 28-2218N8115WBaity Robert G · Yadkinville, NCBuilt 1965 · S/N 28-2219N8116WKilbourne Garrot · Porum, OKS/N 28-2222N8118WHenson Anthony · Jasper, ALBuilt 1965 · S/N 28-2224N8122WRoberts Barry R · Aurora, COBuilt 1965 · S/N 28-2229N8125WLynch Ronald · Carson City, NVBuilt 1965 · S/N 28-2233N8128WSilver Wings Legacy LLC · Weatherford, TXBuilt 1965 · S/N 28-2238N8130WAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1965 · S/N 28-2240N8132WGore Robert E Jr · Aiken, SCBuilt 1965 · S/N 28-2243N8134WBrilliant Holdings LLC · Winfield, MOS/N 28-2245N8135WWoodrum Alan D · Danville, ILBuilt 1965 · S/N 28-2246N8136WNajjar Craig S · Norwood, MABuilt 1965 · S/N 28-2249N8138WSky Air Inc · Cedar Rapids, IABuilt 1965 · S/N 28-2251N8139WHigh Five Flight Inc · Dawson, NEBuilt 1965 · S/N 28-2252N8141WParham Randy L · Saint Charles, MOBuilt 1965 · S/N 28-2254N8143WMartell Ryan · Madison Heights, VABuilt 1965 · S/N 28-2257N8144WHill John W · Reno, NVBuilt 1965 · S/N 28-2258N8145WNagel Thomas H · Tiffin, OHBuilt 1965 · S/N 28-2259N8146WKemp Terry L · Lowell, ARBuilt 1965 · S/N 28-2260N8147WFirst Landings Aviation LLC · Apopka, FLBuilt 1965 · S/N 28-2261N814MSteuk Patricia A Trustee · Middle Bass, OHBuilt 1966 · S/N 28-3601N8150WJames Anthony K · Lexington, NCBuilt 1965 · S/N 28-2264N8151NSmitty 172 LLC · Rockford, MIBuilt 1969 · S/N 28-25345N8151WMcarter Fred D III · Kentwood, LAFirst renewal noticeBuilt 1965 · S/N 28-2265N8152WStokes Kade · Caraway, ARS/N 28-2266N8153NStacy Blackburn · Milton, FLS/N 28-25347N8153WClear Sky Aviation LLC · Oviedo, FLBuilt 1965 · S/N 28-2267N8154NArmosa Studios LLC · Franklin, TNBuilt 1968 · S/N 28-25348N8154WBennink James · Spring Lake, MIBuilt 1965 · S/N 28-2268N8155NThompson Trent A · Forsyth, MTBuilt 1968 · S/N 28-25349N8155WCochran William J · Williamson, GAS/N 28-2270N8156NMoreau Donald G · Dayton, TXBuilt 1968 · S/N 28-25351N8156WLandis Michael D · Jonestown, PABuilt 1965 · S/N 28-2272N8157NBolton Jeffrey · Mont Belvieu, TXBuilt 1968 · S/N 28-25352N8157WFippin Brett Thomas · Brentwood, CABuilt 1965 · S/N 28-2273
Back to AD 96-10-01 R1