|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN category ON category.patent = patent.patent AND category.type = patent.type WHERE (category.class = '174') AND (category.subclass = '141C') ORDER BY date DESC, patent, type|
Total of 4 patents found where: Class is '174'; Subclass is '141C';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
|T / S||Patent||Date||Description||Patentee||Category||Assigned To|
|U||5,796,048||August 18, 1998||Insulator having Conductive Surface Coating to Prevent Corona Discharge
|RFI||NGK Insulators, Ltd.|
|U||1,983,569||December 11, 1934||Pedestal Switch Insulator
Pedestal insulator to support switch gear or bus bar
|ROWLAND, Davidge H.
||Pedestal||Locke Insulator Corp.|
|U||1,661,823||March 6, 1928||Insulator
Suspension string with insulators having conducting surface to balance electrical field
|HAWLEY, Kent A.
||Suspension||Locke Insulator Corp.|
|U||1,521,743||January 6, 1925||Insulator
Suspension arcing horn system and insulator (see 1,552,664 and 1,783,271)
|AUSTIN, Arthur O.
||Suspension||The Ohio Brass Co.|
Total of 0.01 seconds