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.

N5293SBullock Agency Inc · Saint Charles, ILBuilt 1970 · S/N 28-26841N5294LBreidenbach Amy K · Onalaska, WIBuilt 1968 · S/N 28-4595N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941N5297LIndulgences Inc · Putnam Valley, NYBuilt 1968 · S/N 28-4599N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349N5299LSerafini Ronald S · Murphy, NCS/N 28-4601N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450N52HWBurns Robert B · Placerville, CABuilt 1966 · S/N 28-3466N52RWWorland Flying Club LLC · Worland, WYBuilt 1973 · S/N 28-7305341N5300LUrgell Michael N · Trophy Club, TXBuilt 1968 · S/N 28-4602N5300UEden Mark A · Weirsdale, FLBuilt 1964 · S/N 28-20235N5301LSpagway Aviation Corp · Divide, COBuilt 1968 · S/N 28-4603N5304LBryant Christopher P · Montpelier, OHBuilt 1968 · S/N 28-4606N5305LStearns Simon K · Edwardsville, ILBuilt 1968 · S/N 28-4607N5306LRusch Steven A · Sequim, WABuilt 1968 · S/N 28-4608N5308LNelson John · Wichita, KSBuilt 1968 · S/N 28-4610N5309LTexasflight3000 Holdings LLC · Crossroads, TXBuilt 1968 · S/N 28-4611N5311LKitko Stephen D · Bellefonte, PABuilt 1968 · S/N 28-4614N5311TSchrier Timothy M · Savage, MNBuilt 1972 · S/N 28-7225397N5313WWoodard Milton · Ripley, TNBuilt 1962 · S/N 28-367N5314LGormley Laurie A · Las Cruces, NMS/N 28-4616N5314WRasler Christopher · Puyallup, WABuilt 1962 · S/N 28-369N5315LTorres Daniel A · Baldwin, NYBuilt 1968 · S/N 28-4617N5318LWing Timothy R · Raleigh, NCBuilt 1968 · S/N 28-4620N5318TSmith Stephan R · Morrisville, PABuilt 1972 · S/N 28-7225398N5319SCampo Jonathan Ibarra · Lakeland, FLBuilt 1970 · S/N 28-26831N5321LBartel Jonathan L · Fresno, CABuilt 1968 · S/N 28-4624N5323WBibb Benjamin W · Efland, NCS/N 28-380N5324LJohnson Jack D · Fresno, CABuilt 1968 · S/N 28-4627N5324TBlake Rodney · Trophy Club, TXBuilt 1972 · S/N 28-7225400N5326LMarshall Aero LLC · San Antonio, TXBuilt 1968 · S/N 28-4629N5327LLeipzig Richard R · Franklin, TNBuilt 1968 · S/N 28-4631N5328SArreola Christopher · La Verne, CABuilt 1970 · S/N 28-26940N532CMRed Land Holdings LLC · Fayetteville, GAS/N 28-4632N532FLCleared Skies LLC · Heber, AZBuilt 1971 · S/N 28-7125361N5330LDavenport Ross K · Raleigh, NCS/N 28-4634N5331FGeorge Walker Field Inc · Bedminster, NJBuilt 1976 · S/N 28-7725043N5331LKeneston Mark · Ballston Spa, NYBuilt 1968 · S/N 28-4635N5331SGulley Christopher B · Bridgeport, ALBuilt 1970 · S/N 28-26936N5332LWings Over L A Aviation LLC · West Hills, CAS/N 28-4636N5332SNimmons Johnny · Brookshire, TXBuilt 1970 · S/N 28-26926N5333LCentral Indiana Aviation Mission Inc · Cicero, INBuilt 1968 · S/N 28-4637N5334LJwac Aviation LLC · Cullman, ALBuilt 1968 · S/N 28-4639N5334SFischer Howard W Jr · Boydton, VABuilt 1970 · S/N 28-26924N5338LHaynes Robert · Friendswood, TXBuilt 1968 · S/N 28-4643N5339LAlpcal Group LLC · Ventura, CABuilt 1968 · S/N 28-4644N5339SGyorke George Jr · West Ossipee, NHBuilt 1970 · S/N 28-26932
Back to AD 96-10-01 R1