Rotstein David
Operator of record for 25 catalogued wells across 2 states. Every well below links to its full registry page.
Filed as: ROTSTEIN, DAVID · Rotstein, David
At a glance
Rotstein David is the operator of record for 25 catalogued U.S. oil & gas wells in 2 states. None is listed as active, 8 (32%) are plugged & abandoned. Its largest concentration is in Kentucky, with 18 wells (72% of its portfolio).
Wells operated
25
Active
0
Plugged
8
Orphaned
0
Portfolio by state
| State | Wells |
|---|---|
| Kentucky | 18 |
| Illinois | 7 |
Well mix
- Oil wells
- 2
- Gas wells
- 0
- Shut-in
- 0
- Active share
- 0%
Is this your company?
Claim Rotstein David to keep this portfolio accurate — verified operators can correct well statuses and add plugging documentation.
Claim your operator profileWhere does Rotstein David operate?
Rotstein David's catalogued wells are spread across 2 states: Kentucky (18) and Illinois (7). Its 18 Kentucky wells are 0.0% of the 201,022 catalogued in that state — its largest share of any state. Counts cover only states whose registries WellCensus has ingested with operator names; wells in Nebraska and Texas (location indexes) and in states without a registry ingest are not yet attributed to any operator.
How many of Rotstein David’s wells are active, plugged or orphaned?
0% of Rotstein David's catalogued wells are active, 29 percentage points below the national share of 29%. 32% are plugged & abandoned, against 47% nationally. None of the wells filed under this name is flagged as orphaned.
What kinds of wells does Rotstein David operate?
By product class, 2 (8%) are oil wells and 0 (0%) gas wells; nationally the shares are 43% and 17%. The deepest of its wells with a published depth is Gould, Raymond W. 4 in Lawrence, IL at 1,880 ft. The wells listed below sit in Lawrence (IL), Johnson (KY) and Warren (KY). State filings spell the name 2 ways; WellCensus merges exact-normalized spellings only, so subsidiaries and affiliates keep their own pages.
Notable wells operated by Rotstein David
| Well | API # / state ID | Status | Type | Location | Operator | Depth |
|---|---|---|---|---|---|---|
| Gould, Raymond W. 4 | 12-101-02279 | Plugged & abandoned | Oil | Lawrence, IL | Rotstein, David | 1,880 ft |
| Dining, B. J. 2 | 12-101-02797 | Plugged & abandoned | Injection | Lawrence, IL | Rotstein, David | 1,850 ft |
| Finley 4 | 12-101-02592 | Plugged & abandoned | Injection | Lawrence, IL | Rotstein, David | 1,660 ft |
| Leighty 3 | 12-101-02552 | Plugged & abandoned | Injection | Lawrence, IL | Rotstein, David | 1,652 ft |
| Finley 2 | 12-101-02352 | Plugged & abandoned | Injection | Lawrence, IL | Rotstein, David | 1,650 ft |
| Gould, Raymond W. 2 | 12-101-02245 | Plugged & abandoned | Injection | Lawrence, IL | Rotstein, David | 1,640 ft |
| Jordan, Theodore 3-A | 12-101-02258 | Plugged & abandoned | Injection | Lawrence, IL | Rotstein, David | 1,640 ft |
| Franklin, Toral Heirs G8 | 16-115-01701 | Plugged & abandoned | Oil | Johnson, KY | Rotstein, David | 744 ft |
| Young Brothers Tract #1 8 | KGS record 2044099 | Other status | Other type | Warren, KY | Rotstein, David | 575 ft |
| Hollbrook-Williams & Franklin E9 | KGS record 2042993 | Other status | Other type | Johnson, KY | Rotstein, David | — |
| Holdbrook, Morton 2 | KGS record 3000760 | Other status | Other type | Johnson, KY | Rotstein, David | — |
| Hollbrook-Williams & Franklin M2 | KGS record 2042994 | Other status | Other type | Johnson, KY | Rotstein, David | — |
Deepest first where depth is published. See all 25 wells →
Frequently asked questions
How many wells does Rotstein David operate?
Rotstein David is the operator of record for 25 catalogued oil & gas wells, with the largest concentration in Kentucky (18). Only wells in states WellCensus has ingested are counted.
How many of Rotstein David's wells are still active?
0 of Rotstein David's catalogued wells are active; 8 are plugged & abandoned.
In which states does Rotstein David operate wells?
Rotstein David is the operator of record for wells in Kentucky (18) and Illinois (7).
Does Rotstein David operate mostly oil or gas wells?
2 of Rotstein David's catalogued wells are oil wells and 0 are gas wells; the rest are injection, service or unclassified wells.
What is Rotstein David's deepest well?
Among wells with a published depth, Gould, Raymond W. 4 in Lawrence, IL is the deepest at 1,880 ft.
Where Rotstein David's wells are
About this data
Source: State oil & gas regulator registries (operator of record as filed, exact-normalized across states) plus the USGS United States Documented Orphaned Well Database (2026), as published October 10, 2026 — WellCensus refreshes it monthly. See the methodology for how records are matched, cleaned and scored.
Cite as: WellCensus, “Rotstein David — well portfolio”, https://wellcensus.com/operators/rotstein-david-103499 (data as of October 10, 2026).
Dataset updated . Operator portfolios are resolved from raw state registry filings (exact-normalized names; subsidiaries stay separate).