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.

N7354WAmico David A · Newburyport, MABuilt 1963 · S/N 28-1234N7355JCzyszczon Aviation LLC · St Pete Beach, FLBuilt 1968 · S/N 28-24707N7356JHyatt Philip D · Gadsden, ALBuilt 1968 · S/N 28-24708N7357JCswnz Inc · Wilmington, DEBuilt 1968 · S/N 28-24709N7359JAdams Daniel W · Maryville, TNBuilt 1968 · S/N 28-24711N7359WHumphrey Eric N · Osceola, IABuilt 1963 · S/N 28-1239N735FLInternational Air Services Inc Trustee · Carson City, NVS/N 28-7225537N7360WLudwig Paul P · Algonquin, ILBuilt 1963 · S/N 28-1240N7361WRichart Mark D · Canton, PABuilt 1963 · S/N 28-1358N7362WWinterberg Jeremy · Auburndale, FLBuilt 1963 · S/N 28-1242N7363WBurke David L · Sturgeon Bay, WIBuilt 1963 · S/N 28-1243N7364JLewis Mark A · Ozark, ALBuilt 1968 · S/N 28-24718N7365WRobert Jason T · Fernandina Beach, FLS/N 28-1246N7366WBatchelder Norman · Newport Beach, CAFirst renewal noticeBuilt 1963 · S/N 28-1248N7367JWise Dustin A · Fairbanks, AKS/N 28-24722N7367WRapp Stephen Martin Trustee · Zephyr, TXBuilt 1963 · S/N 28-1249N7368WBurkholder Earl F · Middleburg, PABuilt 1963 · S/N 28-1250N7369JSmith Zachary T · Nokesville, VABuilt 1968 · S/N 28-24724N736RMBagwell Danny A · Arley, ALBuilt 1967 · S/N 28-22876N7370JBoone Bradford D · Lincoln, MEBuilt 1968 · S/N 28-24725N7370WDonahue Emily Stacy · Dallas, TXBuilt 1963 · S/N 28-1252N7371WVista I Inc · Smithville, OHBuilt 1963 · S/N 28-1253N7372JMccabe Colin · Frisco, TXBuilt 1968 · S/N 28-24727N7373WColvin Michael E · Monroe, WIBuilt 1963 · S/N 28-1255N7375CErick Enterprises LLC · Spreckels, CABuilt 1969 · S/N 28-25634N7375JRegistered aircraftBuilt 1968 · S/N 28-24731N7376WButtercup Express LLC · Woodward, OKBuilt 1963 · S/N 28-1278N7377JKlinginsmith Randal L · Kearney, NEBuilt 1968 · S/N 28-24740N7377WMorris Vaughan · Weatherford, TXBuilt 1963 · S/N 28-1259N7378WTribuno Michael G · Rosamond, CABuilt 1963 · S/N 28-1360N7380JBednarek Michael H · Centerville, OHBuilt 1968 · S/N 28-24742N7380WRohlfes David M · Newcastle, CABuilt 1963 · S/N 28-1263N7381WTogliatti Robert A · Lakewood, OHBuilt 1963 · S/N 28-1265N7382JMinor Air LLC · Joplin, MOS/N 28-24744N7383JCox Jakori Akeem · Las Vegas, NVBuilt 1968 · S/N 28-24745N7383WRed Rock Flying School LLC · Mesa, AZBuilt 1963 · S/N 28-1267N7384WRader Kyle L · Hutto, TXBuilt 1963 · S/N 28-1268N7385JGardner Chuck R · Estherville, IABuilt 1968 · S/N 28-24747N7388WLiebsack Steven G · Torrance, CABuilt 1966 · S/N 28-3757N7389WMcnulty Ian M · Willis, TXS/N 28-1274N7390JViets Richard C · Bloomer, WIBuilt 1968 · S/N 28-24752N7390WRegistration Pending · Concord, NCRegistration pendingBuilt 1963 · S/N 28-1275N7391JDenke Larry · Long Valley, SDBuilt 1968 · S/N 28-24754N7391WDippolito Mario M · Sherwood, ARBuilt 1963 · S/N 28-1276N7392J33 Global LLC · Potomac Falls, VABuilt 1968 · S/N 28-24755N7393JSale Reported · Tyler, TXSale reportedBuilt 1968 · S/N 28-24756N7394JHorizon Aviation LLC · Brooks, GAS/N 28-22785N7395JOhm Aviation LLC · Wmca, NVS/N 28-24758N7395WHuckfeldt Owen D · Alliance, NEBuilt 1963 · S/N 28-1283N7396JBurns Preston T · Spruce Pine, ALBuilt 1968 · S/N 28-24759
Back to AD 96-10-01 R1