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.

N4116JKerns Brothers LLC · Boardman, ORS/N 28-22433N4117JKeeven Thomas R · Elsberry, MOS/N 28-22434N41180Calladine Matthew · Wellsville, NYBuilt 1974 · S/N 28-7405081N4118JSale Reported · Dallas, TXSale reportedBuilt 1966 · S/N 28-22435N41193Stephen Air LLC · Woodsfield, OHBuilt 1974 · S/N 28-7425203N41197Fancher Ronald Albert · Linden, TNBuilt 1974 · S/N 28-7405082N4119JStowers Monique J · Los Lunas, NMBuilt 1966 · S/N 28-22436N411FLSmith J Lewis IV · Land O Lakes, FLS/N 28-7125188N411WPN411wp LLC · Mount Vernon, OHBuilt 1968 · S/N 28-4826N41209Remy Investments LLC · Fairfax, VABuilt 1974 · S/N 28-7405071N41214Kamler Ron · Santa Rosa, CABuilt 1974 · S/N 28-7425207N4121JForster Simon J · Cedar Park, TXBuilt 1966 · S/N 28-22439N41223Chen Melissa Y Fan · Montverde, FLS/N 28-7425208N41229Whitewings Inc · Lewis Center, OHBuilt 1974 · S/N 28-7405084N4122JCollum Aviation LLC · Milton, FLBuilt 1966 · S/N 28-22440N4123JHebrank Kenneth A · Greensburg, PABuilt 1966 · S/N 28-22441N4124JRiggin Flight Service Inc · Madison, SDBuilt 1966 · S/N 28-22443N4125JYero Miguel A III · Santa Ana, CABuilt 1966 · S/N 28-22444N41265Sunrise Aviation Y1n LLC · Albert Lea, MNBuilt 1974 · S/N 28-7405087N4126JRogers Barclay L · Martinsburg, WVBuilt 1966 · S/N 28-22445N41271Paris Keely Owen · Ottumwa, IABuilt 1974 · S/N 28-7405088N4127JVan Aero LLC · Dover, DEBuilt 1966 · S/N 28-22446N41293Wauchula Aero Club Inc · Wauchula, FLS/N 28-7405090N4130JOur Space Properties LLC · Camdenton, MOBuilt 1966 · S/N 28-22451N4131JTomb Randall H Jr · Pittsburgh, PAFirst renewal noticeBuilt 1966 · S/N 28-22453N41320Dutchyshyn Harry V Jr · Pasadena, MDBuilt 1974 · S/N 28-7405092N4132JDubois Aviation Inc · Chino, CABuilt 2001 · S/N 28-22454N41342Papoutsis Thomas J · Chambersburg, PAS/N 28-7405094N41348Low George D · Newport, MIBuilt 1974 · S/N 28-7425227N4134JPriebe Aviation LLC · Waseca, MNBuilt 1966 · S/N 28-22456N41357Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7425228N41383Lamontagne Bradley Theodore Jr · Pleasant View, TNBuilt 1974 · S/N 28-7425232N41387Horizon Aviation LLC · Brooks, GABuilt 1972 · S/N 28-7225198N4138JRegistration Pending · Orlando, FLRegistration pendingBuilt 1966 · S/N 28-22461N4139JWolles Joseph · Dell Rapids, SDBuilt 1966 · S/N 28-22463N4140JStone Raymond M · Moore, OKBuilt 1966 · S/N 28-22464N41415Cavins Todd J · Stillwater, OKBuilt 1974 · S/N 28-7405101N41419Ater Mark · Greenville, OHBuilt 1974 · S/N 28-7425237N41449Maccani Mark J · Bessemer, MIBuilt 1974 · S/N 28-7405104N4144JMclean Yvonne A · Warfordsburg, PABuilt 1966 · S/N 28-22468N4145JDyka Samuel M · Flushing, MIBuilt 1966 · S/N 28-22469N4146JJackson Billy B · Los Angeles, CABuilt 1966 · S/N 28-22470N41472Jeborah Aero LLC · Jefferson City, MOBuilt 1974 · S/N 28-7425245N41477Shepro Scott M · Senoia, GABuilt 1974 · S/N 28-7405107N41497Bagley Russell L · Frankston, TXBuilt 1974 · S/N 28-7425249N4149JElko Aviation Group LLC · Elko, NVBuilt 1966 · S/N 28-22474N414BCRoche Robert C · Casa Grande, AZBuilt 1965 · S/N 28-21129N414FLRk Aviation LLC · Nashville, INS/N 28-7125192N4152JPaulson Kim A · Devils Lake, NDBuilt 1966 · S/N 28-22478N41537Lenko Mark A · Lovettsville, VABuilt 1974 · S/N 28-7405115
Back to AD 96-10-01 R1