AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N4085PTango Bravo Aviation LLC · Taylorsville, MSBuilt 1959 · S/N 23-1563N4085WIrvin Gary Z · Parrish, FLFirst renewal noticeBuilt 2001 · S/N 25190N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072N4086KRobinson Mark V · Vacaville, CABuilt 1966 · S/N 1N4086MBudak Mark · Melba, IDBuilt 1947 · S/N 12-2969N40872Ole South Aviators LLC · Athens, GAS/N 31-8152134N40874Jones Sherman Farrell · Buena Park, CABuilt 1973 · S/N 28-7425184N40875Meidinger Timothy J · Klamath Falls, ORBuilt 1941 · S/N 5-1184N40876Gray John W · Rohnert Park, CABuilt 1973 · S/N 28-7415100N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565N4087ZNcsb LLC · Anchorage, AKBuilt 1964 · S/N 18-8102N4088Katz Matthew · Los Angeles, CAS/N 124N40881Hsu Feng · Albuquerque, NMS/N 28-7425185N40882Flight Factory LLC · Danville, CABuilt 1973 · S/N 28-7415105N4088FCole Warren G · Watkinsville, GABuilt 1976 · S/N 28-7725002N4088MRam Aviation LLC · Palmer, AKBuilt 1947 · S/N 12-3003SN4088PBas Part Sales LLC · Greeley, COS/N 23-1561N4089Indrebo Rick J · Livermore, CABuilt 1989 · S/N 173N4089FKorb Orry P · Santa Cruz, CABuilt 2002 · S/N 81452N4089MViens Ernest W · Eagle River, AKBuilt 1947 · S/N 12-2978N408BWKough David M · Nashville, TNBuilt 2002 · S/N 60116N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119N408EZKoester David P · Newport, ORS/N 709N408FHStevens William C · Ashland, MTBuilt 2012 · S/N 2012131N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184N408JMRobinson Wayne D · Highlands Ranch, COBuilt 2000 · S/N 80380N408JNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1966 · S/N 58N408LTDecathlon LLC · Lincoln, NEBuilt 2025 · S/N 012N408TWWayne Terry · Belews Creek, NCBuilt 2024 · S/N JA699-7-23N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109N40905Martin James Christopher · South Jordan, UTBuilt 1973 · S/N 28R-7435140N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112N4092MSmith Dennis L · Carthage, NCFirst renewal noticeBuilt 1947 · S/N 12-2983N40935International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 7603N40936Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 7592N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572N4093XBartholomeo Daryl A · Cleveland, OKBuilt 1971 · S/N 5193N40940Williams Richard S · Longview, TXBuilt 2009 · S/N TB-001N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077N4094MVaughn Charles M · Titusville, FLBuilt 1946 · S/N 12-3028N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118N40957Roberts Linda L · Bell Buckle, TNBuilt 1941 · S/N 7627
Back to AD 90-04-06 R1