OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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.

N4205TPoulsen Carlton Jr · Bossier City, LABuilt 1971 · S/N 28-7205095N4206JRegistration Pending · Linn, MORegistration pendingBuilt 1966 · S/N 28-22551N4206TTownsend Rhett · Manakin Sabot, VAS/N 28-7205094N4207GDavis Glenn A · Fair Oaks, CAS/N 28-23878N4207TMisiura Edward Stanley Trustee · Elmhurst, NYBuilt 1971 · S/N 28-7225093N4210JPlamondon Steven J · Lake Leelanau, MIBuilt 1966 · S/N 28-22556N4211J11j Inc · Fort Lauderdale, FLBuilt 1966 · S/N 28-22558N4212TAci Medical Management Inc · San Marcos, CABuilt 1971 · S/N 28-7205099N4213TMallard Aviation LLC · Manchester, NHBuilt 1971 · S/N 28-7205100N42161Registered aircraftS/N 28-7425312N4216TExtreme Metals LLC · El Dorado, ARBuilt 1971 · S/N 28-7205102N4217JShuffler David · Kingman, AZBuilt 1966 · S/N 28-22565N4218TGolden Pick LLC · Maple Plain, MNS/N 28-7225096N4220JHisghman Jonathan G · Waynesboro, VABuilt 1966 · S/N 28-22568N4221JKeystone Aviation LLC · Melrose, FLBuilt 1966 · S/N 28-22569N4221TEralet Inc · Middletown, DEBuilt 1971 · S/N 28-7225097N4222JHerrera Justin C · Willits, CAS/N 28-22570N4223JMccormick Brian C · Irvine, CABuilt 1966 · S/N 28-22571N42241Peters Dale M · Naknek, AKBuilt 1974 · S/N 28-7405163N4224TKhair Air Aviation LLC · Senoia, GABuilt 1971 · S/N 28-7205105N4225TCulpepper Steven F · Columbus, GAS/N 28-7125592N4226TElledge William L · Glen Saint Mary, FLBuilt 1971 · S/N 28-7125576N4227JRoberts Richard M · Plains, KSS/N 28-22576N4229TRobinson Lee B · Kerrville, TXBuilt 1971 · S/N 28-7225098N4230JPleasant Valley Aviation Inc · Bellefonte, PABuilt 1966 · S/N 28-22579N4231JBielusiak Stanley J · Dartmouth, MABuilt 1967 · S/N 28-22580N4232FSekel David A · San Diego, CABuilt 1976 · S/N 28-7725005N4232JN4232j LLC · Waialua, HIS/N 28-22581N4234JHomerun Horizons LLC · Weatherford, TXBuilt 1967 · S/N 28-22585N4234TParsons Donald Jr · Crumpler, NCBuilt 1971 · S/N 28-7205109N42358Bakker Margaret E Trustee · Petaluma, CABuilt 1974 · S/N 28-7425314N4235JBarrett Kevin M · Pittsburg, TXBuilt 1967 · S/N 28-22586N4237JMoppert Stephen Kyler · Madison, MSS/N 28-22589N4237TPeak 2 Peak Enterprises LLC · Sebring, FLS/N 28-7225101N4238TChopper Aviation LLC · Cahokia Heights, ILBuilt 1971 · S/N 28-7205111N423DMGga N423dm LLC · Glendale, AZBuilt 1969 · S/N 28-25683N423FLIglewski David W · Muskego, WIBuilt 1971 · S/N 28-7125204N423JCPeterson Daniel R · Riverview, FLBuilt 1967 · S/N 28-3922N4240JBillings Christopher · St Johns, FLBuilt 1967 · S/N 28-22593N4240TBlankenbijl Eric J · Grapeview, WAS/N 28-7205112N4241JImmen David F · Bonanza, ORBuilt 1967 · S/N 28-22594N4243JCase Jamie · Tyngsboro, MABuilt 1967 · S/N 28-22598N4245THormazabal Hugo F · Orlando, FLBuilt 1971 · S/N 28-7205115N4246JBk Media LLC · Hilo, HIBuilt 1967 · S/N 28-22601N4248JSaia Mark · Oak Harbor, WABuilt 1967 · S/N 28-22604N4248TCress Terry G · Hollywood, FLBuilt 1971 · S/N 28-7205118N4249TGulf Bravo Aviation LLC · Lafayette, LABuilt 1971 · S/N 28-7225104N424FLNeihart Randy L · Fontana, CAS/N 28-7125205N4250JLeasing Systems Inc · Gallatin, TNBuilt 1967 · S/N 28-22606N4250TKennedy Elvis L II · Hoover, ALBuilt 1971 · S/N 28-7205119
Back to AD 96-10-01 R1