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.

N4196HBurnett John A · Wadsworth, ILS/N 15-79N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N41973Legacy Aviation LLC · Murfreesboro, TNS/N 28-7405155N41977Augusti Group Enterprises Inc · Clayton, NCBuilt 1974 · S/N 28-7415375N41978Henderson Jason E · Corona, CABuilt 1974 · S/N 28-7415376N4197YAgnew Michael D · Pardeeville, WIS/N 1193-77N4197ZBurns Barry D · Amarillo, TXS/N 18-8389N41980Warren Donald E · Pine Bluff, ARBuilt 1974 · S/N 28-7415377N41983Brotherman LLC · Hereford, TXBuilt 1974 · S/N 28-7415379N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157N41988Sky High Investments LLC · Greenwood, INBuilt 1945 · S/N 1419N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N4198FRal Aviation LLC · Trumbull, CTBuilt 1976 · S/N 28-7790006N4198RTaf Aerial Services LLC · Beeville, TXBuilt 1999 · S/N 14096CN4198YGallo Michael R · High Falls, NYBuilt 1977 · S/N 292-77N4198ZMcfarlane Bradley J · Port Alsworth, AKBuilt 1966 · S/N 18-8391N41992Stein Anthony J · Locust Grove, GABuilt 1974 · S/N 28-7415380N41995Columbus State Community College · Columbus, OHFirst renewal noticeBuilt 1974 · S/N 28-7415382N41997Caae Leasing LLC · Lake Zurich, ILBuilt 1974 · S/N 28R-7435235N4199AKiser Richard K · Mount Solon, VABuilt 1951 · S/N 18-924N4199HN4199h Club Llp · Oshkosh, WIBuilt 1978 · S/N 24-0661N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543N4199ZSymanowski Kevin · Reeder, NDBuilt 1966 · S/N 18-8392N419ACSimmons Scott · Anchorage, AKBuilt 2000 · S/N 408-99N419AKSpats Aviation LLC · Toledo, OHBuilt 1951 · S/N 18-1067N419ALTomahawk Aero Services LLC · Bellingham, WABuilt 1978 · S/N 38-78A0401N419DTurner Spencer A · Modesto, CABuilt 1995 · S/N 20419N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003N419FKlenoski Brian D · Fulton, MIBuilt 2000 · S/N 22690N419FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2002 · S/N 419-19/0B2N419GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881176N419GCRiley Bradlee A · Archdale, NCBuilt 2016 · S/N AAZA0167N419JNWheeler Kelly · Columbia Falls, MTBuilt 2017 · S/N 419N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787N419MGAnderson Todd · Bondurant, IABuilt 2007 · S/N 05-503N419PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843413N419RStruthers Robert J · Geneva, ILBuilt 2009 · S/N 0001N419SGilpin Nathan L · Cornelia, GAS/N 419-SN419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001N419WPHole Jeffrey Wayne · Stockton, CABuilt 1996 · S/N 1331N419YBBlum Bradley R · Waukesha, WIBuilt 2011 · S/N 4566N41ACPitts Flying Club Of Stoughton · Stoughton, WIBuilt 1979 · S/N 321GN41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N41AHHarding Kenneth H · Columbus, OHBuilt 1954 · S/N 22-1899N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385
Back to AD 90-04-06 R1