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.

N8051NSapienza Gregory T · Williamstown, NJBuilt 1969 · S/N 28-25298N8051WMcginn Gary P · Elk City, OKBuilt 1965 · S/N 28-2124N8052NBcaeronautics LLC · Houston, TXBuilt 1968 · S/N 28-25299N8052WTaylor Robert E · Haines City, FLBuilt 1965 · S/N 28-2125N8053NJump Ventures LLC · Key West, FLBuilt 1968 · S/N 28-25300N8057NTrisauskas Kestutis · Hazlet, NJBuilt 1968 · S/N 28-25305N8057WMarsh John T Jr · Athens, GABuilt 1965 · S/N 28-2134N8058WPierce Allen L · Douglas, WYBuilt 1965 · S/N 28-2135N8060NWind Island LLC · Darien, ILBuilt 1968 · S/N 28-25309N8060WSchroeder Jeffry S · Springfield, ILS/N 28-2139N8061NNorth Florida Flyers LLC · Green Cove Springs, FLBuilt 1969 · S/N 28-25310N8061WReardon Christopher · Chicago, ILS/N 28-2140N8062WGolden Wings Aviation LLC · Kamas, UTS/N 28-2142N8063NDean Ralph G · Alfred, MEBuilt 1968 · S/N 28-25313N8064WSled Aviation LLC · Prosper, TXBuilt 1965 · S/N 28-2146N8065NSotelo Kaleb N · Visalia, CABuilt 1968 · S/N 28-25315N8065WGard Roger L · Danville, IAS/N 28-2147N8066NSouthern Air Services LLC · Myakka City, FLBuilt 1968 · S/N 28-25316N8066WWilson Jamal Abdul · White Plains, MDBuilt 1965 · S/N 28-2151N8067NCsp Avionics LLC · Knoxville, TNBuilt 1968 · S/N 28-25317N8068WRkd Flier Inc · Nemaha, IABuilt 1965 · S/N 28-2154N8069NRajski Douglas S · Freeburg, ILBuilt 1968 · S/N 28-25319N8069WAdventures In The Sky Aviation LLC · Fresno, CABuilt 1965 · S/N 28-2155N806CWWilling John W · Grove City, OHBuilt 1965 · S/N 28-2152N8070WMordini Robert D · Grand Marais, MNFirst renewal noticeS/N 28-2156N8071NFigone David Anthony · Williams, AZBuilt 1968 · S/N 28-25321N8071WFernandez Gregory · San Antonio, TXBuilt 1965 · S/N 28-2158N8073NKiwi Choppers LLC · Hillsboro, ORBuilt 1968 · S/N 28-25323N8075WPale Horse Imports Inc · Shingletown, CABuilt 1965 · S/N 28-2163N8076WTipton James · Hot Springs, ARBuilt 1965 · S/N 28-2165N8077NRodgers Wesley T · Enterprise, ALS/N 28-25328N8079WFox Michael · Winfield, KSBuilt 1965 · S/N 28-2168N8082WWallace Louis Wayne · Sherman, TXBuilt 1965 · S/N 28-2172N8083WNedelea Traian · Katy, TXBuilt 1965 · S/N 28-2173N8084WFieldgrove Matt L · Somerton, AZBuilt 1965 · S/N 28-2174N8085WFireside Aviators Assn Corp · San Jose, CAFirst renewal noticeBuilt 1965 · S/N 28-2175N8087WCampbell James A · Brighton, MIBuilt 1981 · S/N 28-2177N8089WBrind F Alan · Ionia, NYFirst renewal noticeBuilt 1965 · S/N 28-2180N808KASchlomer Lyle M · Osseo, WIS/N 28-4583N8091WClement Timothy S · Skidmore, MOS/N 28-2182N8091XBlack Hunter F · Blanding, UTBuilt 1966 · S/N 28-21777N8092NCash Management Consulting LLC · Granite Springs, NYBuilt 1968 · S/N 28-25335N8092WDidea Aviation LLC · Orlando, FLBuilt 1965 · S/N 28-2183N8093NSaraland High School · Saraland, ALS/N 28-25336N8094NEggan Mark A · Lee Center, NYBuilt 1968 · S/N 28-25337N8094WMatney Tara · Abingdon, VABuilt 1965 · S/N 28-2188N8095WSkierka Michael A · Browning, MTBuilt 1965 · S/N 28-2189N8096WRoberts Heather V · Birmingham, ALBuilt 1965 · S/N 28-2190N8098NBlessing Gary · Cape Coral, FLBuilt 1968 · S/N 28-25342N8099WClarion County Flight Club LLC · Shippenville, PABuilt 1965 · S/N 28-2194
Back to AD 96-10-01 R1