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.

N4328TWhite Mickey S · Hyrum, UTBuilt 1970 · S/N 28-26927N4330TBc 180 LLC · Chouteau, OKBuilt 1971 · S/N 28-7205142N43311Myers James · Coolidge, AZBuilt 1974 · S/N 28-7425355N4331XS E D Air LLC · Kimball, SDBuilt 1975 · S/N 28-7625013N43321Alexander Terry · Stamps, ARFirst renewal noticeBuilt 1974 · S/N 28-7425357N43325Air Ventures Flying School LLC · Smithfield, RIBuilt 1974 · S/N 28-7425358N4333JHaengel Marci M · Canton, MIBuilt 1967 · S/N 28-22708N4333TBluebird Airventures LLC · Bosque Farms, NMBuilt 1971 · S/N 28-7205143N43348A Bit Extra LLC · River Ridge, LABuilt 1974 · S/N 28-7425362N4334JBest Equipment Leasing LLC · Bakersfield, CABuilt 1967 · S/N 28-22709N4335JByas Victor Jr · Cleveland, MSBuilt 1967 · S/N 28-22710N43361Jordan Mark E · Fort Leonard Wood, MOBuilt 1974 · S/N 28-7405191N4336JLaunching P.A.D. LLC · Scottsdale, AZS/N 28-22711N4337JLee Lonnie R · Wichita, KSBuilt 1967 · S/N 28-22713N4338JSky Raider Flying Club · Spokane, WABuilt 1967 · S/N 28-22714N4338TBenham Properties LLC · Sullivan, INS/N 28-7205144N433FLTrue North Aviation LLC · Cooperstown, NDBuilt 1971 · S/N 28-7125217N433RAHudson Allen D · Rio Grande, OHS/N 28-22705N43431Upchurch James Stephen · Rockfield, KYBuilt 1974 · S/N 28-7425366N4343ERegistered aircraftS/N 287405194N4343TLeonard Alan W · Hiubee, MOBuilt 1971 · S/N 28-7225153N43449Blue Sky B&Rd LLC · Heber City, UTBuilt 1974 · S/N 28-7405195N4344TSpiegel Carl E · Waterford, CTBuilt 1971 · S/N 28-7205146N4345JSkinner Gary L · Winchester, OHS/N 28-22721N4345PManning Jay · Midland, TXS/N 28-3105N4346JVelthuis Remintyn · Fontana, CABuilt 1967 · S/N 28-22723N4349JMason Gregory K · South Jordan, UTS/N 28-2749N4349TJrh Avgroup Inc · Satellite Beach, FLBuilt 1972 · S/N 28-7205147N434FLPerkins Jeffrey E · Grand Prairie, TXBuilt 1971 · S/N 28-7125220N434JVClark Nathaniel T · Duncanville, TXBuilt 1966 · S/N 28-3646N434WPZimmerman Justin W · Palmer, AKBuilt 1968 · S/N 28-5071N43511Freedom Development Corporation LLC · Rock Hill, SCBuilt 1974 · S/N 28-7405201N4352TJaycee Flying Club Inc · Mineral Ridge, OHBuilt 1971 · S/N 28-7205148N4352XBackstreet Aviation LLC · Hickory, NCBuilt 1975 · S/N 28-7505191N4353JStevens Fredric Dale · Tucson, AZBuilt 1967 · S/N 28-22731N43559Smith Thomas Michael · Saint Cloud, MNBuilt 1974 · S/N 28-7425378N4355JMurray Jeffrey S · Windermere, FLBuilt 1967 · S/N 28-22733N4356FLindberg James D · San Bernardino, CABuilt 1976 · S/N 28-7725011N4356JKennedy Kevin L · Moscow, IDBuilt 1967 · S/N 28-22734N4357JBirchmeier Luke · Fenton, MIS/N 28-22735N4357TWorth Rodney D · Shawnee, KSBuilt 1971 · S/N 28-7205151N43586Slb Aviation LLC · Lakeside, IABuilt 1974 · S/N 28-7405205N4358JOgden Frederick T · Mena, ARBuilt 1967 · S/N 28-22736N43593Goodnuz Aviation LLC · Wooster, OHBuilt 1974 · S/N 28-7425380N43599Miller James G Jr · Catonsville, MDBuilt 1974 · S/N 28-7405207N4359XWiedenbeck Thomas · Holmen, WIBuilt 1975 · S/N 28-7525281N43601Sale Reported · Green Valley, AZSale reportedBuilt 1974 · S/N 28-7425381N4360JDonaldson Gary K · Kearns, UTS/N 28-22738N4361JRever David L · Laurel, MDBuilt 1967 · S/N 28-22739N4361XCharles City Aeronautics Inc · Charles City, IABuilt 1975 · S/N 28-7625020
Back to AD 96-10-01 R1