Search the Insulator Patent Reference Library:

Build your search criteria. The patent must match all the values specified.
Select patent types: Utility   Design   Reissue
Patent number:
Date:
Year between: and
Patentee starting with:
City:
State:
Assigned To starting with:
Description containing:
Category:
Class:    Subclass:
Click Search when complete:
SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (last_name = 'STEARNS') AND (first_name = 'Charles') ORDER BY assigned_to ASC, date, patent, type

Total of 2 patents found where: Last Name is 'STEARNS'; First Name is 'Charles';

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 25,534 September 20, 1859 Machine for Making Lightning Rods
Machine for making corrugated, twisted lightning rods out of sheet metal		 STEARNS, Charles
 Lightning Rod Machine  
 Jacob A. Kissell and Nathan Blickensderfer
U 65,775 June 11, 1867 Improvement in Lightning Rods
Lightning rod made of a continuous strip of copper wound and corrugated into rods		 STEARNS, Charles
 Lightning Rod Jacob A. Kissell and Nathan Blickensderfer

Total of 0.00 seconds