Skip to content
WellCensus

Search wells & operators

Look up any catalogued U.S. oil & gas well by well name or API number (10–14 digits, dashes OK), find an operator by name, or filter wells by state, county, status and type — then export the result to CSV.

Well results for the current filters
WellAPI # / state IDStatusTypeLocationOperator
Lease by Trojan Oil Co. 104-037-11786Plugged & abandonedOilLos Angeles, CATrojan Oil Co.
Huddlestun 112-079-24874Plugged & abandonedOilJasper, ILTrojan Oil Co., Inc.
Frohning, Carl 212-079-00649Plugged & abandonedOilJasper, ILTrojan Oil Co.
Frohning, Carl 112-079-00627ActiveOilJasper, ILTrojan Oil Co.
Frohning, Carl 512-079-01477Plugged & abandonedOilJasper, ILTrojan Oil Co.
Bergbower, Leonard 2-A12-079-24161Other statusOther typeJasper, ILTrojan Oil Co.
Murray 1-D12-159-24284Other statusOther typeRichland, ILTrojan Oil Co., Inc.
Bergbower 412-079-24162Plugged & abandonedOther typeJasper, ILTrojan Oil Co., Inc.
Hemrich 2-A12-079-00734ActiveOilJasper, ILTrojan Oil Co.
Frohning, Carl 312-079-01475Plugged & abandonedOilJasper, ILTrojan Oil Co.
Frohning, Carl 412-079-01476Plugged & abandonedOilJasper, ILTrojan Oil Co.