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.

N7472WTait Ronald M · Fort Worth, TXBuilt 1963 · S/N 28-1377N7473RSonntag Donald · Marengo, ILFirst renewal noticeBuilt 1966 · S/N 28-22022N7474RGregorski Thomas E · Kenly, NCBuilt 1966 · S/N 28-22023N7474TWorks James K · Avalon, CABuilt 1967 · S/N 28-23432N7474WZimmerman Sandra · Henderson, NVBuilt 1963 · S/N 28-1379N7475RTolsma Garrett J · Kirkland, WABuilt 1966 · S/N 28-22024N7476RCarrillo Jeremiah · Shelton, WABuilt 1966 · S/N 28-22026N7476WAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 28-1385N7477RRegistration Pending · Richmond Hill, GARegistration pendingS/N 28-22028N7477WBechaver Landon Robert · Mesa, AZBuilt 1963 · S/N 28-1387N7478WTaylor Randall Devlin Trustee · Austin, TXBuilt 1963 · S/N 28-1388N7479RDnr Solutions LLC · Idaho Falls, IDS/N 28-22030N7479WTcheutchua Romeo J · Portales, NMBuilt 1963 · S/N 28-1389N747MWWhite Michael Jay · Oakland Park, FLS/N 28-4657N7480WYessmann Dan Seiji · Gardena, CABuilt 1963 · S/N 28-1390N7481WFlying Nova LLC · Tacoma, WABuilt 1963 · S/N 28-1391N7483RCarpenter Bruce E · Monroe, NYBuilt 1966 · S/N 28-22035N7483WPack Jon C · Blue Ridge, GABuilt 1963 · S/N 28-1393N7484WSotvik Tanner · Devils Lake, NDBuilt 1963 · S/N 28-1394N7485WBond Jesse · Pulaski, TNS/N 28-1395N7486WBaney David · Summitville, INBuilt 1963 · S/N 28-1396N7487RDeschamp Patrick B · Bottineau, NDS/N 28-22040N74889Unlimited Aviation LLC · Webster, NYBuilt 1967 · S/N 28-4519N7488RSimpson Kevin B · Newberg, ORBuilt 1966 · S/N 28-22042N7488WAnuradha Jairam · Camas, WABuilt 1963 · S/N 28-1399N7489WHostetler Kevin · Green Forest, ARBuilt 1963 · S/N 28-1400N748RSGrady Michael J · Farmington, NMBuilt 1968 · S/N 28-5230N7490WCome Fly With Me LLC · Columbiana, ALBuilt 1963 · S/N 28-1401N7491WWillard Michael W · Boonville, NCS/N 28-1402N7492WN7492w LLC · Spicewood, TXBuilt 1963 · S/N 28-1405N7493RWalcher James W · Wilmington, ILBuilt 1966 · S/N 28-22047N7493WNonn Lidia G · Appleton, WIBuilt 1965 · S/N 28-2900N7494WLandreth Homer W · Peoria, AZBuilt 1963 · S/N 28-1407N7499RCart Caleb L · Eunice, LAS/N 28-22054N7499WWoodward Adam B · Fort Collins, COBuilt 1963 · S/N 28-1412N74LPMendota Flyers LLC · Middleton, WIBuilt 1968 · S/N 28-25196N74THDe Gracia Jack P · Orlando, FLBuilt 1966 · S/N 28-22308N7500RSzymanski Tadeusz C · Fort Myers, FLBuilt 1966 · S/N 28-22055N7500WGajewski Richard G · Naples, FLBuilt 1963 · S/N 28-1413N7501WTide Pools LLC · Tucson, AZBuilt 1963 · S/N 28-1406N75021Miller Mariemma L · Martinsburg, PABuilt 1976 · S/N 28-7625192N7502RStapleton James W Jr · Nebo, NCBuilt 1966 · S/N 28-22058N7503RQuinn George B · Ponce, PRBuilt 1966 · S/N 28-22059N7503WAscend Aviation LLC · Bountiful, UTBuilt 1965 · S/N 28-2903N7504WThompson Reese F · Lake Stevens, WABuilt 1965 · S/N 28-2905N75055Registered aircraftBuilt 1976 · S/N 28-7625196N7505RMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 28-22061N7506RGleason Joseph G · Gainesville, FLBuilt 1966 · S/N 28-22062N7507RPanko Douglas A · Minooka, ILFirst renewal noticeBuilt 1966 · S/N 28-22063N7508RTaylor Devan A · Overland Park, KSBuilt 1966 · S/N 28-22065
Back to AD 96-10-01 R1