Oregon Licensed Plumbing Contractors
U.S. Location Dataset // 2,234
This is the complete licensed universe of plumbing contractors in Oregon, not a directory of the ones who chose to be listed: every active license the Oregon Construction Contractors Board publishes in its public extract, reduced to one row per licensed firm or individual at an address. 2,234 records. 381 records carry a separate business name from the licensed individual. Classifications in the file: Plumbing / PB-Plumbing Contractor (1,759), Boiler / BB-Boiler Business (274), Electrical / CPI-Ltd Pump Install Spec Contractor (201). 354 licensees list an out-of-state address (contractors licensed in Oregon but based elsewhere); the state column identifies them so they are one filter to drop. Each record carries the state license number, so it joins cleanly to permit data, insurance certificates and other state files, and the expiration date, so you can target renewals. Buyers use it for distributor and manufacturer territory planning, dealer-program recruitment, insurance and financing prospecting, and roll-up sourcing in a fragmented trade. Association lists such as our ACCA member dataset cover the engaged slice; this covers everyone the state allows to pull a permit. Refreshed weekly from the board's extract.
All 2,234 records, as published — the complete set rather than a sample. That matters most for coverage and gap questions: put together the same list from partial searches and every location you miss reads as a gap that is not there, so the answer is wrong rather than merely late. Assembling the U.S.-wide coverage by hand also means one query per area against sources that cap what they return per search.
☆Who uses this data
Sales & Business Development
Territory planning, lead generation, and prospecting for teams selling products or services to contractors
Market Research & Competitive Intelligence
Analyzing Oregon Licensed Plumbing Contractors's geographic footprint, density, and overlap with competitors
Logistics & Supply Chain
Route optimization, delivery planning, and distribution network analysis across 2,234 locations
Real Estate & Site Selection
Co-tenancy analysis, trade area studies, and identifying expansion opportunities near existing contractors
✓Data quality & methodology
This dataset is compiled directly from Oregon Licensed Plumbing Contractors's official contractor locator system. We query the same data source that powers the “Find a contractor” page on their website, ensuring the data matches what the brand itself publishes.
Weekly
Refresh frequency
Deduplicated
By name + address + city
Validated
Format checks on all fields
Every record goes through automated quality checks including ZIP code format validation, coordinate bounds verification (US only), phone number standardization, and duplicate detection. Records that fail validation are flagged and excluded from the dataset.
⇆Three ways to buy this dataset
The whole file
$29
All 2,234 records as a CSV. One payment, yours to keep, no subscription.
Per record, for AI agents
—
This dataset is small enough that the whole file is the only sensible purchase. Metered queries start at 5,000 records.
API access
MCP
Connect an assistant to search, sample, quote and buy. Pay by card or stablecoin, no account needed.
{}Data Fields
The percentage is how much of the file carries that field, measured on the delivered CSV rather than estimated. 1 of 15 fields are populated on under half the rows (phone). Every row always carries the identifiers and the full address.
≡Sample Data Preview
| name | licenseeName | licenseNumber | licenseType | trade | status | expires | address | city | state | zip | country | county | sourceUrl |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 800 PLUMBER+AIR PACIFIC NW; WIRED TOGETHER ELECTRIC | MEP PROS INC | BCD-BB398 | Boiler / BB-Boiler Business | plumbing | Active | 2029-07-01 | 9735 SW SUNSHINE CT STE 100 | BEAVERTON | OR | 97005 | US | WASHINGTON | https://data.oregon.gov/api/views/vhbr-cuaq/rows.csv?accessType=DOWNLOAD |
| 3 KINGS | 3 KINGS ENVIRONMENTAL INC | BCD-PB2707 | Plumbing / PB-Plumbing Contractor | plumbing | Active | 2029-07-01 | PO BOX 280 | BATTLE GROUND | WA | 98604 | US | CLARK | https://data.oregon.gov/api/views/vhbr-cuaq/rows.csv?accessType=DOWNLOAD |
| ACCO ENGINEERED SYSTEMS INC | ACCO ENGINEERED SYSTEMS INC | BCD-BB75 | Boiler / BB-Boiler Business | plumbing | Active | 2029-07-01 | 888 E WALNUT ST | PASADENA | CA | 91101-1895 | US | LOS ANGELES | https://data.oregon.gov/api/views/vhbr-cuaq/rows.csv?accessType=DOWNLOAD |
| AGRI LINES IRRIGATION INC | AGRI LINES IRRIGATION INC | BCD-CPI222 | Electrical / CPI-Ltd Pump Install Spec Contractor | plumbing | Active | 2029-07-01 | PO BOX 660 | PARMA | ID | 83660 | US | CANYON | https://data.oregon.gov/api/views/vhbr-cuaq/rows.csv?accessType=DOWNLOAD |
| AIR PRODUCTS AND CHEMICALS INC | AIR PRODUCTS AND CHEMICALS INC | BCD-BB371 | Boiler / BB-Boiler Business | plumbing | Active | 2029-07-01 | 1940 AIR PRODUCTS BLVD | ALLENTOWN | PA | 18106 | US | LEHIGH | https://data.oregon.gov/api/views/vhbr-cuaq/rows.csv?accessType=DOWNLOAD |
?Frequently Asked Questions
Is this the same as the state's license lookup?
It is the same underlying data, taken from the board's bulk public extract rather than one-at-a-time lookups, and reshaped to one row per licensed firm or individual at an address with a trade column and a certified/registered class. The lookup shows one license at a time; this is all of them in one file, refreshed weekly.
Does every record have a phone number and a business name?
Only where the board publishes them. State boards license the qualifying individual, and many file an individual name and address rather than a company name. The name column uses the business name when one is on file and the licensee otherwise; licenseeName always carries the individual. Phone is present only for boards that publish it.
Why are some addresses outside Oregon?
Contractors can hold a Oregon license while being based in another state, common near state lines and for national firms. They are real Oregon licensees, so they are included, and the state column makes them a one-filter exclusion if you only want in-state locations.