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.

N7318JHdr Aero LLC · Lewes, DEBuilt 1968 · S/N 28-24667N7319FJdnichols LLC · Wichita, KSBuilt 1968 · S/N 28-25229N7319JGross Randolph A · Round Rock, TXBuilt 1968 · S/N 28-24670N7319WDavis Jeffrey M · Phoenix, AZBuilt 1963 · S/N 28-1184N7320WSuchting Carl Joseph · Little Egg Harbor, NJBuilt 1963 · S/N 28-1186N7321FWebster Joshua P · West Rutland, VTBuilt 1968 · S/N 28-25231N7322FEdixon James Richard II · Cameron Park, CAS/N 28-25189N7322WLocum Mike M · Sparta, TNBuilt 1963 · S/N 28-1190N7323WHigh Desert Skys LLC · Blackfoot, IDS/N 28-1192N7324WFerreira Barney Manuel · Truckee, CAS/N 28-1193N7325JBasco Richard A · Charlotte, NCBuilt 1968 · S/N 28-24678N7325WMitchell Lawrence Jr · Steubenville, OHFirst renewal noticeBuilt 1963 · S/N 28-1195N7326FByrd Jonathan L · Rome, GAS/N 28-25235N7326WHeinze William J · Ashley, MIBuilt 1963 · S/N 28-1196N7327FAirconrad LLC · Duncansville, PAS/N 28-25236N7327JWhite Benjamin M · Hallsville, TXBuilt 1968 · S/N 28-24681N7327WCerto Russell · Grand Island, NYBuilt 1963 · S/N 28-1198N7328JNightline Air LLC · Saratoga Springs, UTBuilt 1968 · S/N 28-24682N7329FProflite Aero LLC · Easton, PABuilt 1968 · S/N 28-25237N7329JWalser Air LLC · Warwick, RIBuilt 1968 · S/N 28-24683N7329WHohl Warren G · Albany, GABuilt 1963 · S/N 28-1200N7330WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1963 · S/N 28-1201N7331FGreenwood Stephen R · Salt Lake City, UTBuilt 1968 · S/N 28-25238N7331JRitchey David C · Hilliard, OHBuilt 1968 · S/N 28-24685N7331WBandit Aviation LLC · Batesville, MSBuilt 1963 · S/N 28-1091N7332JRegistration Pending · Peculiar, MORegistration pendingBuilt 1968 · S/N 28-24686N7335WWhitworth Kenneth W · Hanford, CARegistration expired, pending cancellationBuilt 1963 · S/N 28-1205N7336JKey West Aviation LLC · Key West, FLBuilt 1968 · S/N 28-24691N7336WDemers Matthew H · Plano, TXBuilt 1963 · S/N 28-1206N7337WReynolds Jessica C · Maricopa, AZBuilt 1963 · S/N 28-1220N7338WEvans Russell Slade · Austin, TXBuilt 1963 · S/N 28-1209N7340WMillar Russell J · Saint Onge, SDS/N 28-1211N7341JRicciardi John A · Norwalk, CTBuilt 1968 · S/N 28-24696N7342JWingate Nicholaus · Lawton, OKS/N 28-24671N7343JSawyer Dean A · Kerrville, TXBuilt 1968 · S/N 28-24484N7343WRicht Jerry A · Cleveland, TNBuilt 1963 · S/N 28-1214N7344WRegistered aircraftBuilt 1963 · S/N 28-1221N7345JAlpha 1 Aviation LLC · Helena, ALBuilt 1968 · S/N 28-24612N7346JJacobson Daniel · Neenah, WIBuilt 1968 · S/N 28-24620N7347WHinzman Mark D · Reno, NVS/N 28-1224N7348JDippolito Mario M · Sherwood, ARBuilt 1968 · S/N 28-24698N7348WRosenau Dillon L · Upham, NDBuilt 1963 · S/N 28-1226N7349JWolfe Frank A · Nahcotta, WABuilt 1968 · S/N 28-24699N7349WGritzo Russell E · Edgewood, NMBuilt 1963 · S/N 28-1228N734XMahler Steven · Hanover, PABuilt 1974 · S/N 28-7405079N7350WLisa Mark P · Paso Robles, CABuilt 1963 · S/N 28-1229N7351JRudolph Robert E · Martinez, CABuilt 1968 · S/N 28-24702N7351WMoser Jeffrey E · Creighton, NEBuilt 1963 · S/N 28-1230N7353WSales Michael · Delphi, INS/N 28-1233N7354J7354j LLC · Colorado Springs, COBuilt 1968 · S/N 28-24706
Back to AD 96-10-01 R1