|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 = '501') AND (category.subclass = '153') ORDER BY date ASC, patent, type|
Total of 3 patents found where: Class is '501'; Subclass is '153';
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|
|R||12,992||July 13, 1909||Manufacture of Spar Insulators
Feldspar insulator material (reissue of 907,155)
|LOCKE, Fred M.
|U||1,631,730||June 7, 1927||Ceramic Material
Porcelain composition for spark plugs and insulators consisting of Sillimanite
|JEFFERY, Joseph A.
MONTGOMERY, Earle T.
|Porcelain||Champion Porcelain Co.|
|U||4,332,913||June 1, 1982||Flux Combination of Barium Oxide and Potassium Feldspar for High Strength Alumina Porcelain Electric Insulators
Porcelain composition with low shrinkage during firing
||Porcelain||Rosenthal Technik AG|
Total of 0.01 seconds