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.

N5741FBrower Alan L · Califon, NJBuilt 1968 · S/N 28-25043N5741WGonzalez Jose M · Arlington, TXBuilt 1963 · S/N 28-1435N5742UAdams Sara · Leavenworth, KSBuilt 1970 · S/N 28-26562N5742WJohnson Ronald H · Goodlettsville, TNBuilt 1963 · S/N 28-1428N5744ULance Sylvia · Acushnet, MABuilt 1970 · S/N 28-26564N5744WGarrett Jackson Trustee · Pleasant Garden, NCBuilt 1963 · S/N 28-1447N5745UMccormick Todd L · Ankeny, IAS/N 28-26565N5746USale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28-26567N5747FMsol Air LLC · Lakeland, FLBuilt 1968 · S/N 28-25048N5749WDch Aviation LLC · Owasso, OKBuilt 1963 · S/N 28-1467N574BFKrusemark Emma A · Pender, NES/N 28-25047N574FLDynamic Aviators LLC · San Angelo, TXS/N 28-7125421N5752URiggin Flight Service · Madison, SDS/N 28-26575N5753FRauch Jack · San Rafael, CABuilt 1968 · S/N 28-25056N5753WRegistration Pending · Royse City, TXRegistration pendingS/N 28-1490N5754FStorm Joseph K · Enumclaw, WABuilt 1968 · S/N 28-25057N5754UAuthement Michael Ray · Pecos, TXBuilt 1969 · S/N 28-26577N5755UKyzer Aviation Holdings LLC · Fort Mill, SCS/N 28-26579N5755WSchmidt Mia H · Van Nuys, CABuilt 1963 · S/N 28-1499N5756FStewart Larry E · Seymour, INBuilt 1968 · S/N 28-25059N5757FWaletzko David L · Avon, MNBuilt 1968 · S/N 28-25060N5757WN63e LLC · Fallon, NVBuilt 1964 · S/N 28-1527N5758FTipnis Zachary Arjun · Troy, NYS/N 28-25061N5759FGelnett Dean A · Lansdale, PABuilt 1968 · S/N 28-25062N5759WChimera Air Inc · Maumee, OHBuilt 1964 · S/N 28-1529N575PAGrw Air Services LLC · Springport, INBuilt 1975 · S/N 28-7525330N576Madera County Aircrafters Inc · Madera, CABuilt 1974 · S/N 28-7425428N5760FG & D Leasing LLC · Tempe, AZBuilt 1968 · S/N 28-25063N5761FNoriega Vanessa · Miami, FLBuilt 1968 · S/N 28-25064N5762UYoung Robert C · Redmond, WABuilt 1969 · S/N 28-26586N5763FSugarloaf Air LLC · Harrison, ARBuilt 1968 · S/N 28-25066N5764FRegistration Pending · Monticello, GARegistration pendingS/N 28-25067N5764USlingsby Scott D Trustee · Francestown, NHBuilt 1970 · S/N 28-26588N5765FAerotica LLC · Fleming Island, FLBuilt 1968 · S/N 28-25069N5765UHarvell Joshua L · Salem, WIS/N 28-26589N5766FDaedalus Flight School Inc · P. FokaiaBuilt 1976 · S/N 28-7725065N5766WWessels Quin K · Lake Geneva, WIBuilt 1964 · S/N 28-1555N5767FPena Edwin Arturo · Mission Hills, CABuilt 1968 · S/N 28-25071N5767UAir Kraft Spraying Inc · Timber Lake, SDBuilt 1969 · S/N 28-26590N5768FCollum Aviation LLC · Milton, FLBuilt 1968 · S/N 28-25072N5768UParsons Clinton K DBA · Etna, MEBuilt 1969 · S/N 28-26591N5769UKim Sungtae · Fort Worth, TXBuilt 1969 · S/N 28-26593N576FLRocky Top Corp · Erin, TNBuilt 1971 · S/N 28-7125425N576PAClear Skies LLC · Whitehall, PABuilt 1975 · S/N 28-7525331N5770WGallo Danny P · Nashotah, WIBuilt 1964 · S/N 28-1578N5771WCrumpton Bradley N · Caddo Mills, TXBuilt 1964 · S/N 28-1579N5772UBernstein Matthew D · North Charleston, SCBuilt 1970 · S/N 28-26596N5772WBallard Gary H · Soddy Daisy, TNBuilt 1964 · S/N 28-1580N5773UNelson Francis A · Winchester, VABuilt 1970 · S/N 28-26597N5775UBravo Tango Aviation · Spearfish, SDBuilt 1970 · S/N 28-26599
Back to AD 96-10-01 R1