Every active UK company whose main declared activity is plumbing, heat and air-conditioning installation. Around 42,000 companies. Plumbers, heating engineers, gas installers and air-conditioning contractors. SIC class 43220. One of the densest and most reachable trades on the register, and the natural list for merchants, boiler and HVAC manufacturers, certification schemes, trade insurance and job management software.
| Company Name | Company Number | Incorporated | Status | Sic Code | Sic Description | Post Town | Postcode | Size Band | Accounts Next Due |
|---|---|---|---|---|---|---|---|---|---|
| NASCOT LIMITED | 04690235 | 2003-03-07 | Active | 43220 | Plumbing, heat and air-conditioning installation | KENILWORTH | CV8 1LY | Small | 2027-04-30 |
| MD & BW BUXTON LIMITED | 04690133 | 2003-03-07 | Active | 43220 | Plumbing, heat and air-conditioning installation | DERBYSHIRE | DE75 7QJ | Small | 2027-12-31 |
| CARMARTHEN REFRIGERATION LIMITED | 04690487 | 2003-03-07 | Active | 43220 | Plumbing, heat and air-conditioning installation | CARMARTHEN | SA31 3RU | Small | 2026-12-31 |
| EXOTHERMIC INSTALLATIONS LIMITED | 04687952 | 2003-03-06 | Active | 43220 | Plumbing, heat and air-conditioning installation | SWINDON | SN25 4YE | Unknown | 2027-12-31 |
| ENVIROTECH CLIMATE CONTROL LIMITED | 04688724 | 2003-03-06 | Active | 43220 | Plumbing, heat and air-conditioning installation | BIRMINGHAM | B46 1HQ | Small | 2027-12-31 |
| P H MACHIN LIMITED | 04686506 | 2003-03-05 | Active | 43220 | Plumbing, heat and air-conditioning installation | NORTH YORKSHIRE | DL9 3RE | Micro | 2026-12-31 |
| MARK MCGUIRE LIMITED | 04686761 | 2003-03-05 | Active | 43220 | Plumbing, heat and air-conditioning installation | CUMBRIA | LA14 4LQ | Small | 2026-12-31 |
| R.J. MITCHELL AND SON LIMITED | 04685599 | 2003-03-04 | Active | 43220 | Plumbing, heat and air-conditioning installation | BATH | BA2 2UE | Small | 2027-12-31 |
| OCTOPLUMB LIMITED | 04686173 | 2003-03-04 | Active | 43220 | Plumbing, heat and air-conditioning installation | LEICESTER | LE19 1SX | Small | 2026-12-31 |
Prepared by DataSteak from Companies House, October 2026 snapshot. Original data published by the source; the cut, cleaning and typing are ours.
Source: Companies House · Office for National Statistics · See Attributions for licensing information.
10 fields, with types, how much of each is filled in, and a real example from the data.
| Column | Type | Populated | Example |
|---|---|---|---|
| company_name | Text | 100% | NASCOT LIMITED |
| company_number | Text | 100% | 04690235 |
| incorporated | Date | 100% | 2003-03-07 |
| status | Text | 100% | Active |
| sic_code | Text | 100% | 43220 |
| sic_description | Text | 100% | Plumbing, heat and air-conditioning installation |
| post_town | Text | 100% | KENILWORTH |
| postcode | Text | 100% | CV8 1LY |
| size_band | Text | 100% | Small |
| accounts_next_due | Date | 100% | 2027-04-30 |
Measured from this product's own query rather than the dataset as a whole, so it describes what you would actually be buying.
Companies incorporated in the last 90 days with a registered address in the London postal…
£249.00 · View → IT & TechnologyActive companies in the London postal areas whose primary SIC code sits in division 62 or…
£199.00 · View → MixedCompanies in the London postal areas currently marked as proposed for strike off, meaning…
£249.00 · View →It's generated on demand. When you buy, the query runs against the live data and builds your file right then, so it's current as of your purchase. You download it straight away.
A one-off download of this exact cut, all 42,086 rows and every column shown above, as a CSV file that opens in Excel or Google Sheets. It's a snapshot of the data as it is today. It does not include ongoing updates or API access, neither of which is available yet.
Yes, on request. We can turn on API access for this dataset against your account, and you issue your own key from your dashboard. It returns the same data as the file, over HTTP, in JSON, with the edition date on every response so your systems can tell when there is something new to pull.
It is not a live feed. The data changes when the register is refreshed, roughly monthly, and the API serves whatever the current edition is. Access is arranged per dataset rather than bought from the site, so ask us and we will set it up.
Yes. The preview above is real data, and the 15-row sample download gives you every column so you can check the format and quality first.
Yes. A commercial and internal-business licence is included. Redistribution as-is is restricted; enterprise redistribution rights are available on request.
The price shown includes UK VAT at 20%, so it is the amount you pay with nothing added at the end, and checkout shows the split before you commit. A VAT invoice is raised and emailed automatically when payment goes through, carrying our VAT number and the tax breakdown, so a UK VAT-registered business can reclaim the VAT without asking us for anything. More on pricing and licensing.
42,086 rows, generated fresh on download.