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.

N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180N33803Mclellan Simon W · Monroe, WABuilt 1975 · S/N 28-7505182N33836Patton Daniel E · Thornton, PABuilt 1975 · S/N 28-7505186N33847Registered aircraftBuilt 1975 · S/N 28-7525249N33848Crymes Robert S · Woodbridge, VABuilt 1975 · S/N 28-7505187N3391RValiair Lc Trustee · Casper, WYBuilt 1969 · S/N 28-5668N3392REllsworth Steven C · Muscatine, IABuilt 1969 · S/N 28-5669N3393RBay Richard G · Sparks, NVBuilt 1969 · S/N 28-5672N3398R3y3 Piper Group LLC · Saint Charles, IABuilt 1969 · S/N 28-5671N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182N33FKMotis Joseph D · Huntington Beach, CABuilt 1970 · S/N 28-5763N33YBBriggs Kent · Manhattan, KSBuilt 1963 · S/N 28-956N33YYMoore Keith V · Germantown, TNBuilt 1966 · S/N 28-3230N3413KRogers Howard M · Douglasville, GAS/N 28-23547N341STZimmie Thomas F · Wynantskill, NYBuilt 1973 · S/N 28-7305476N3426RCarter Thomas M · Macedon, NYBuilt 1969 · S/N 28-5675N3428RLagrange David F · Winterset, IAS/N 28-5678N3432KPorte Elvis · Miami, FLBuilt 1967 · S/N 28-23552N3436RGressly Aviation LLC · Camp Verde, AZS/N 28-5680N343NYDimaria Philip L · Port Saint Lucie, FLBuilt 1971 · S/N 28-7105107N343TMLumberton Air 2 LLC · Mount Laurel, NJBuilt 1974 · S/N 28-7505051N343WADominguez Zeneida E · Clewiston, FLBuilt 1969 · S/N 28-26163N3444Hartman James N · Bremerton, WABuilt 1965 · S/N 28-2162N3451KMorehead Matt F · Chico, CABuilt 1967 · S/N 28-23559N3451QCcr Holdings LLC · Rushford, MNBuilt 1977 · S/N 28-7725228N3452KRegistered aircraftBuilt 1967 · S/N 28-23561N3455RBulut LLC · Los Angeles, CABuilt 1969 · S/N 28-5685N3459KCarrell David W · Pittsburgh, PABuilt 1967 · S/N 28-23566N3460RHenninger Mark E · Mill Creek, WABuilt 1969 · S/N 28-5687N3461RJarriel Investments Inc · Register, GAS/N 28-5689N3462RFor Skies Flying Club Ltd · Martinsville, ILBuilt 1969 · S/N 28-5690N3464KAviation Explorers Post 8000 Inc · Ottawa, KSBuilt 1967 · S/N 28-23567N3465KNiepert William · Jacksonville, NCS/N 28-23568N3465RSchissel Todd E · Decorah, IABuilt 1969 · S/N 28-5693N3466KRegistration Pending · Bulverde, TXRegistration pendingBuilt 1967 · S/N 28-23569N3468RFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1969 · S/N 28-5695N3470RCook Chayil LLC · Granger, INBuilt 1970 · S/N 28-5696N3471RKilpatrick Kerry · Somerset, NJBuilt 1970 · S/N 28-5697N3472RKomar Michael J · Danville, PABuilt 1969 · S/N 28-5698N3477KToles Richard O · Wolcott, NYBuilt 1967 · S/N 28-23572N3478KYarber Brandon Tate · Cleveland, TNBuilt 1967 · S/N 28-23573N347GWAllen Air LLC · Creola, ALBuilt 1966 · S/N 28-3651N347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledS/N 28-571N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575N3480QAdcock Curtis D · Westerville, OHS/N 28-7725229N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701N3489KGfh LLC · Zillah, WABuilt 1967 · S/N 28-23582N3493RValente Joseph · Sun Lakes, AZBuilt 1970 · S/N 28-5703N349ERWatkins Noble Marvin II · Port Saint Lucie, FLBuilt 1967 · S/N 28-3932
Back to AD 96-10-01 R1