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.

N7413KBecerra Edward Jr · Mount Pleasant, WIBuilt 1950 · S/N 20-323N7413RRegistration Pending · Gilbert, AZRegistration pendingS/N 28-21930N7413WRivera Genaro · Clarksville, TNBuilt 1963 · S/N 28-1301N7413YOutka Air LLC · Aberdeen, SDBuilt 1964 · S/N 30-475N74141Spragg Zachary · Great Mills, MDBuilt 1975 · S/N AA5B-0155N74143Fearn Richard · Gainesville, GABuilt 1975 · S/N AA5B-0158N74146Vick Brian · Lutz, FLBuilt 1975 · S/N AA5B-0159N74147Shoppell Stuart J · Dahlgren, VABuilt 1975 · S/N AA5B-0160N7414DCulver Robert D · Sacramento, CABuilt 1957 · S/N 22-5175N7414RVx Aircraft Services LLC · Batesville, ARBuilt 1966 · S/N 28-21953N74151Chapman Larry · Abilene, TXBuilt 1975 · S/N AA5B-0163N7415KClarke Kenneth J · Anchorage, AKS/N 17259115N7415RHolland Nathan A · Wildomar, CABuilt 1966 · S/N 28-21938N7415VHall Kevin · Morgan, UTBuilt 1975 · S/N 20-1149N7416CN7416c LLC · Anchorage, AKBuilt 2024 · S/N 347416N7416GDreggors David Richard · Altamonte Springs, FLBuilt 1970 · S/N 17259116N7416PDavenport Jimmy J · Hayesville, NCBuilt 1961 · S/N 24-2604N7416RMessing Mathew · Bremerton, WABuilt 1966 · S/N 28-21940N7416WEdmiston Jonathan B · Oak Harbor, WABuilt 1963 · S/N 28-1304N74177Campbell Peter Shane · Knoxville, TNBuilt 1974 · S/N 177RG0481N7417DUnderwood Todd M · Foley, ALBuilt 1957 · S/N 22-5178N7417JKeefer James F · Montoursville, PABuilt 1968 · S/N 28R-30759N7417KHulse Anthony G · Wasilla, AKBuilt 1950 · S/N 20-328N7417PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2605N7417RDestination Flyer LLC · Memphis, TNBuilt 1966 · S/N 28-21941N7417VCottage Village Living II LLC · Brownfield, TXBuilt 1975 · S/N 20-1151N7418JCreel Kenneth Darrell · Smithville, TNBuilt 1968 · S/N 28R-30760N7418RJones Clayton S · Boerne, TXS/N 28-21942N7418YArmbrister Justin R · Blue Ridge, TXBuilt 1964 · S/N 30-482N7419FSmith Helicopters Inc · Cotulla, TXBuilt 1977 · S/N 670606N7419GFlycarolina LLC · Concord, NCBuilt 1970 · S/N 17259119N7419PBollfrass William Henry III · Rhinelander, WIBuilt 1961 · S/N 24-2607N7419RDiorio Christopher J · Melba, IDBuilt 1966 · S/N 28-21944N7419WBaker Terry · Mesa, AZBuilt 1977 · S/N M-1973N741BDRitenour John E · Waynesboro, PABuilt 2002 · S/N 1024N741DMFrench David · Tucson, AZS/N 28-1080N741DPPleasant Aviation LLC · Mount Pleasant, TXBuilt 1974 · S/N 17264611N741DWCub Driver LLC · Morgan, UTBuilt 2005 · S/N PA0205N741FHammer Thomas · Plantersville, TXBuilt 2011 · S/N 3129N741FLFerrario Michael R · San Rafael, CABuilt 1972 · S/N 28-7225578N741GSReform Friendly Flyers LLC · Buhl, ALBuilt 1970 · S/N 17259111N741HCUp 2011 LLC · Edmond, OKS/N 001N741LClarke Adam M · Lompoc, CABuilt 2004 · S/N 1001N741MBNelson Aircraft Sales LLC · Austin, MNBuilt 2006 · S/N 70041N741NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881026N741RASkyline Solutions Inc · Deland, FLBuilt 1989 · S/N 2841137N741SSlavick Dennis M · Palm Desert, CAS/N 49N741TCRegistration Pending · Kansas City, MORegistration pendingBuilt 1941 · S/N 3056N741TJJackson Thomas R Jr · Spearfish, SDBuilt 1964 · S/N 30-477N742United States Department Of Agriculture · Cedar City, UTBuilt 1964 · S/N 18-8146
Back to AD 90-04-06 R1