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.

N7045WCooksey Don R · Newcastle, WYBuilt 1962 · S/N 28-800N7046RRegistration Pending · Vero Beach, FLRegistration pendingBuilt 1966 · S/N 28-21743N7046WStreed Gwain E Trustee · Christmas Valley, ORBuilt 1962 · S/N 28-802N7047RCoulter Frank R · Cygnet, OHBuilt 1966 · S/N 28-21744N7047WApflight LLC · Naples, FLBuilt 1963 · S/N 28-793N7048ROdonnell Bernard A · Wilbraham, MABuilt 1966 · S/N 28-21746N7048WHisle Kenneth Ray · Winchester, KYBuilt 1962 · S/N 28-806N7049WAuto Ink · San Diego, CABuilt 1962 · S/N 28-809N704FLBabri Masood A · Lorton, VABuilt 1972 · S/N 28-7225256N7051RBest Equipment Leasing LLC · Bakersfield, CABuilt 1966 · S/N 28-21749N7052RSell Carl N · Spanaway, WABuilt 1966 · S/N 28-21750N7052WPuskala Thomas S · Iron River, MIBuilt 1962 · S/N 28-817N7053WRed Rock Flying School LLC · Mesa, AZBuilt 1962 · S/N 28-805N7054WLanguage Gert Johannes · Hays, KSS/N 28-820N7055RRegistered aircraftBuilt 1966 · S/N 28-21754N7055WRickard Donald L · Rowland Hts, CABuilt 1962 · S/N 28-823N7056WEustace Daryl R · Scottsboro, ALBuilt 1962 · S/N 28-824N7057RContreras Robert G · Norman, OKBuilt 1966 · S/N 28-21756N7057WWatkins Travis · Haughton, LABuilt 1962 · S/N 28-829N7058RMoss Harold E II · Overland, MOBuilt 1966 · S/N 28-21757N7058WRoman Donald M Jr · New Middletown, OHBuilt 1962 · S/N 28-810N7059WMartin Gerard A · Boston, KYBuilt 1962 · S/N 28-811N705FLSue Christina Alicia · San Antonio, TXBuilt 1972 · S/N 28-7225290N7060WHorst Gregory J · Glen Burnie, MDS/N 28-819N7063RWirt Wayne A · Llano, CABuilt 1966 · S/N 28-21763N7064RNagel Aaron J · Alliance, OHBuilt 1966 · S/N 28-21764N7064WDalotto Gianpaul · Deridder, LABuilt 1962 · S/N 28-838N7065WShirley Janice · Warsaw, NYBuilt 1962 · S/N 28-839N7066RBarreto Colon Wilfredo · Lake Dallas, TXBuilt 1966 · S/N 28-21767N7069RMccoy Evan Tyler · Tullahoma, TNBuilt 1966 · S/N 28-21770N7069WBirmingham Michael F · Goldsboro, NCBuilt 1962 · S/N 28-818N706FLTime Flys Idaho LLC · Clarkston, WAS/N 28-7225300N7070RRegistration Pending · Seward, NERegistration pendingBuilt 1966 · S/N 28-21771N7070WFullerton Brice · Oroville, WAS/N 28-849N7071RKarabulut Semih · North Little Rock, ARS/N 28-21772N7071WTeigen Travis S · Glenwood City, WIBuilt 1962 · S/N 28-851N7072RMckinley Matthew R · Sault Sainte Marie, MIS/N 28-21773N7072WNelson David L · Laporte, INBuilt 1962 · S/N 28-852N7073RMorris Gregory A · Arlington, TXBuilt 1966 · S/N 28-21774N7073WTjc Aviation Group LLC · Rolling Meadows, ILBuilt 1962 · S/N 28-853N7074RCl Finney Aviation LLC · Benton, KSBuilt 1966 · S/N 28-21775N7075RYoungs William R · Grand Blanc, MIBuilt 1966 · S/N 28-21776N7077WMcclure Jared B · Claremore, OKBuilt 1962 · S/N 28-859N7078RSeidel Electrical Services Inc · Salinas, CAS/N 28-21779N7079RKoerner Aviation Inc · Kankakee, ILBuilt 1966 · S/N 28-21781N7081RStearns Edwin B Jr · Eloy, AZS/N 28-21783N7083RJohnson David G · Starkville, MSBuilt 1966 · S/N 28-21785N7083WBell O Z · Victorville, CABuilt 1962 · S/N 28-869N7084WGrahn James A · Las Vegas, NVBuilt 1962 · S/N 28-870N7085RDubois Aviation Inc · Chino, CABuilt 1966 · S/N 28-21788
Back to AD 96-10-01 R1