Updated Monthly

Federal Contractors — Plumbing, Heating, and Air-Conditioning Contractors (NAICS 238220)
U.S. Location Dataset // 6,156

6,156 US federal contractors with primary NAICS 238220, Plumbing, Heating, and Air-Conditioning Contractors — active SAM.gov registrations for contract awards, from the 2026-09-06 SAM.gov public extract. 100.0% carry a street address, 62.6% a website, 100.0% a primary NAICS code with its title, 100.0% a CAGE code, 100.0% the name of the government business point of contact, and 39.2% are small businesses for their primary NAICS. Email addresses where the firm publishes one on its SBA profile. Every row carries the UEI and CAGE code, physical and mailing address, entity structure, state and country of incorporation, entity start date, every NAICS and PSC code with titles, the set-aside and ownership flags SAM records (woman-owned, veteran-owned, service-disabled veteran-owned, minority-owned, 8(a) and HUBZone certifications with expiry dates), the purpose of registration, and the initial, activation, last-update and expiration dates of the registration. Registrants who opted out of public display in SAM.gov (31,437 in this extract) are excluded from every product. Built from the SAM.gov public entity extract — the monthly file the General Services Administration publishes of every registration in the System for Award Management, decoded with GSA's own layout, the Census NAICS list and the GSA PSC manual.

6,156Locations
56States
127Data Fields
CSVFormat

All 6,156 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

GovCon Sales & Teaming

Every registered contractor with its NAICS, PSC, set-aside flags and 8(a) / HUBZone certifications — find subcontractors, teaming partners and prospects from the register of record rather than a compiled list.

Registration & Compliance Services

Expiration dates on every active registration and a separate file of registrations that already lapsed — the renewal universe, with the government business contact named.

Market Analysts & Economic Development

Registrants by state, congressional district, NAICS sector and ownership class, joinable to USAspending and FPDS awards on UEI.

Vendor Risk & Procurement

A clean UEI / CAGE spine with entity structure, incorporation, exclusion and debt-offset flags to reconcile a supplier list against.

Data quality & methodology

This dataset is built from the SAM.gov public entity extract — the monthly file the General Services Administration publishes of every registration in the System for Award Management, the register every organisation must be in before it can receive a federal contract or grant. Every row is the entity's own registration, keyed by its permanent Unique Entity ID, with its business types, NAICS and PSC codes decoded from GSA's published layout, the Census NAICS list and the GSA PSC manual. Nothing comes from a company's website. The public extract carries the names and titles of the points of contact an entity designates but no email address or telephone number for any of them, and none are appended.

Monthly

Refresh frequency

Deduplicated

One row per SAM.gov Unique Entity ID (UEI); the active and expired files never overlap

Validated

Format checks on all fields

Registrations are published as SAM holds them. The only rows removed are the registrants who set SAM's 'no public display' flag, which is honoured and counted on every dataset; expired registrations are kept in their own file rather than dropped. Dates are normalised to ISO and every code is decoded with the government's own tables, with the raw codes kept alongside. Every build round-trips a random sample against the live SAM.gov Entity Management API and is not published if any row disagrees.

Three ways to buy this dataset

The whole file

$39

All 6,156 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$1.28 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 3,078 records.

API access

MCP

Connect an assistant to search, sample, quote and buy. Pay by card or stablecoin, no account needed.

{}Data Fields

uei100%cage_code100%legal_business_name100%dba_name27%division_name18%division_number4%registration_status100%purpose_of_registration_code100%purpose_of_registration100%initial_registration_date100%registration_expiration_date100%last_update_date81%activation_date100%address100%address24%city100%state100%zip100%zip488%country100%congressional_district100%mailing_address100%mailing_address25%mailing_city100%mailing_state100%mailing_zip100%mailing_country100%website63%entity_structure_code100%entity_structure100%state_of_incorporation96%country_of_incorporation96%entity_start_date100%fiscal_year_end100%business_type_codes100%business_types100%for_profit99%nonprofit0%other_not_for_profit0%woman_owned14%woman_owned_small_business12%economically_disadvantaged_wosb0%veteran_owned13%service_disabled_veteran_owned8%minority_owned21%black_american_owned8%hispanic_american_owned10%native_american_owned2%asian_pacific_american_owned2%subcontinent_asian_american_owned1%self_certified_small_disadvantaged4%dot_certified_dbe5%manufacturer_of_goods2%foreign_owned1%labor_surplus_area_firm0%us_federal_government0%us_state_government0%us_local_government0%tribal_government0%tribally_owned_firm0%alaskan_native_corporation_owned0%educational_institution0%hospital0%community_development_corporation_owned0%sba_8a_certified1%sba_8a_certification_expires1%sba_hubzone_certified1%sba_hubzone_certification_expires0%sba_8a_joint_venture0%primary_naics100%primary_naics_title100%small_business_for_primary_naics50%naics_sector_code100%naics_sector100%naics_codes100%naics_count100%psc_codes30%psc_titles30%psc_count100%credit_card_accepted99%govt_business_poc_name100%govt_business_poc_title70%alt_govt_business_poc_name33%alt_govt_business_poc_title17%electronic_business_poc_name100%electronic_business_poc_title72%past_performance_poc_name37%past_performance_poc_title25%debt_subject_to_offset85%active_exclusion0%disaster_response_areas35%disaster_response_count100%entity_validation_source91%extract_date100%phone71%fax17%phone_as_of71%contract_awards_count100%contract_obligations_total29%contract_obligations_last_12_months15%largest_contract_obligations29%first_contract_date29%last_contract_date29%top_awarding_agency29%awarding_agencies_count29%business_size_determination29%highly_compensated_officers0%parent_uei29%parent_name29%largest_contract_url29%latest_contract_url29%usaspending_recipient_url29%sam_entity_url100%phone_source71%email63%email_domain_accepts_mail63%email_type63%email_matches_website39%contact_person84%contact_phone63%capabilities_narrative19%year_established84%sba_profile_updated84%sba_profile_url84%employees_reported_ppp42%ppp_loan_date42%ppp_borrower_name42%

The percentage is how much of the file carries that field, measured on the delivered CSV rather than estimated. 65 of 127 fields are populated on under half the rows (dba_name, division_name, division_number, address2, mailing_address2, nonprofit, …). Every row always carries the identifiers and the full address.

Sample Data Preview

federal-contractors-naics-238220_locations_us.csv — 5 of 6,156 rows, 93 of 127 columns · scroll →UTF-8
ueicage_codelegal_business_namedba_namedivision_namedivision_numberregistration_statuspurpose_of_registration_codepurpose_of_registrationinitial_registration_dateregistration_expiration_datelast_update_dateactivation_dateaddressaddress2citystatezipzip4countrycongressional_districtmailing_addressmailing_address2mailing_citymailing_statemailing_zipmailing_countrywebsiteentity_structure_codeentity_structurestate_of_incorporationcountry_of_incorporationentity_start_datefiscal_year_endbusiness_type_codesbusiness_typesfor_profitwoman_ownedwoman_owned_small_businessveteran_ownedminority_ownedhispanic_american_ownedprimary_naicsprimary_naics_titlesmall_business_for_primary_naicsnaics_sector_codenaics_sectornaics_codesnaics_countpsc_countcredit_card_acceptedgovt_business_poc_namegovt_business_poc_titlealt_govt_business_poc_namealt_govt_business_poc_titleelectronic_business_poc_nameelectronic_business_poc_titlepast_performance_poc_namedebt_subject_to_offsetdisaster_response_countentity_validation_sourceextract_datephonefaxphone_as_ofcontract_awards_countcontract_obligations_totalcontract_obligations_last_12_monthslargest_contract_obligationsfirst_contract_datelast_contract_datetop_awarding_agencyawarding_agencies_countbusiness_size_determinationparent_ueiparent_namelargest_contract_urllatest_contract_urlusaspending_recipient_urlsam_entity_urlphone_sourceemailemail_domain_accepts_mailemail_typeemail_matches_websitecontact_personcontact_phoneyear_establishedsba_profile_updatedsba_profile_urlemployees_reported_pppppp_loan_dateppp_borrower_name
C18KNS2LAJH65K0D5AMERICAN TESTING, INC.activeZ2All Awards2009-06-232026-11-182025-11-202025-11-203220 CORPORATE CTSUITE FELLICOTT CITYMD210422252USA033220 CORPORATE CTSUITE FELLICOTT CITYMD21042USAwww.americantesting.us2LCorporate Entity (Not Tax Exempt)MDUSA1984-04-0112-312X;XS;A2;8C;8WFor Profit Organization;Subchapter S Corporation;Woman Owned Business;Joint Venture Women Owned Small Business;Woman Owned Small Businessyesyesyes238220Plumbing, Heating, and Air-Conditioning Contractors23Construction238220;23899020yesCHRISTINE KELLYPRESIDENTCHRISTINE KELLYPRESIDENTCHRISTINE KELLYPRESIDENTno0E&Y2026-09-06410-461-6211410-461-62742026-03-1142438411.00454790.001781780.002020-12-162026-03-11Department of Health and Human Services1OTHER THAN SMALL BUSINESSC18KNS2LAJH6AMERICAN TESTING, INC.https://www.usaspending.gov/award/CONT_AWD_75N90023P00728_7529_-NONE-_-NONE-/https://www.usaspending.gov/award/CONT_AWD_75N90023P00728_7529_-NONE-_-NONE-/https://www.usaspending.gov/recipient/ee047c05-b831-3345-155e-385225526a2f-C/latesthttps://sam.gov/entity/C18KNS2LAJH6/coreDataUSAspending contract recordckelly@americantesting.usyescompanyyesChristine Kelly410-461-621119842025-11-20https://search.certifications.sba.gov/profile/C18KNS2LAJH6/5K0D5162020-04-10AMERICAN TESTING INC
C18YJS28KEK51M0A7ABLE HEATING & AIR CONDITIONING, INCABLE HEATING & AIR CONDITIONING INCHVAC MECHANICAL23activeZ2All Awards2010-10-142027-03-202026-03-241020 COLORADO AVECHULA VISTACA919111618USA521020 COLORADO AVENUESTE ACHULA VISTACA91911USA2LCorporate Entity (Not Tax Exempt)CAUSA1983-12-1812-312X;PI;23For Profit Organization;Hispanic American Owned;Minority Owned Businessyesyesyes238220Plumbing, Heating, and Air-Conditioning Contractorsyes23Construction236220;23822020yesANDREW MORENOPRESIDENTMOSES MORENOANDREW MORENOPRESIDENTno0E&Y2026-09-06619-409-9100619-409-91112026-06-242645381243.825119936.0011982787.002020-12-032026-06-24Department of Defense2SMALL BUSINESSC18YJS28KEK5ABLE HEATING & AIR CONDITIONING, INChttps://www.usaspending.gov/award/CONT_AWD_N6247322F4862_9700_N6247319D2421_9700/https://www.usaspending.gov/award/CONT_AWD_80AFRC26FA049_8000_80AFRC26DA002_8000/https://www.usaspending.gov/recipient/6e77c6a2-4138-9298-6e64-7e946320106c-C/latesthttps://sam.gov/entity/C18YJS28KEK5/coreDataUSAspending contract recordamoreno@ableac.netyescompanyAndrew Moreno619-409-910019832026-03-24https://search.certifications.sba.gov/profile/C18YJS28KEK5/1M0A7
C19CTKKZFYA35NLB8TRI-STAR COMPANIES INCactiveZ2All Awards2009-08-252027-03-182026-03-20910 KEATING RDBATESVILLEMS386068746USA02P.O. BOX 1549BATESVILLEMS38606USAwww.tristarcompanies.com2LCorporate Entity (Not Tax Exempt)MSUSA1999-02-0412-312XFor Profit Organizationyes238220Plumbing, Heating, and Air-Conditioning Contractorsno23Construction237110;238110;238120;238130;238140;238190;238210;238220;238290;238310;238320;238390;238990130yesAUSTIN E JOYNERCONTROLLERWADE SCOTTVICE-PRESIDENTAUSTIN E JOYNERCONTROLLERno0E&Y2026-09-06662-578-4440662-578-44472026-04-085168053.0083000.0083000.002021-07-152026-04-08Department of Agriculture1SMALL BUSINESSC19CTKKZFYA3TRI-STAR COMPANIES INChttps://www.usaspending.gov/award/CONT_AWD_1232SA25P0458_12H2_-NONE-_-NONE-/https://www.usaspending.gov/award/CONT_AWD_1232SA25P0458_12H2_-NONE-_-NONE-/https://www.usaspending.gov/recipient/ae77ea6e-5c32-ff2c-d0a1-056a45cb5928-C/latesthttps://sam.gov/entity/C19CTKKZFYA3/coreDataUSAspending contract recordajoyner@tristarcompanies.comyescompanyyesAustin Joyner662-578-444019992026-03-20https://search.certifications.sba.gov/profile/C19CTKKZFYA3/5NLB8442020-04-08TRI-STAR COMPANIES, INC.
C1B1PFJUDP3452HE6ARIZONA COMMERCIAL PLUMBING, INC.activeZ2All Awards2008-04-292026-09-292025-10-012025-10-011209 W REMUDA WAYPAYSONAZ855415209USA02PO BOX 931PAYSONAZ85547USA2LCorporate Entity (Not Tax Exempt)AZUSA2006-06-2012-312X;XSFor Profit Organization;Subchapter S Corporationyes238220Plumbing, Heating, and Air-Conditioning Contractors23Construction23822010yesJEFF ASHBYJEFF ASHBYJEFF ASHBYJEFF ASHBYno0E&Y2026-09-06928-474-2171928-474-46952024-01-05125969.0025969.002024-01-042024-01-05Department of the Interior1OTHER THAN SMALL BUSINESSC1B1PFJUDP34ARIZONA COMMERCIAL PLUMBING, INC.https://www.usaspending.gov/award/CONT_AWD_140A1124P0005_1450_-NONE-_-NONE-/https://www.usaspending.gov/award/CONT_AWD_140A1124P0005_1450_-NONE-_-NONE-/https://www.usaspending.gov/recipient/0a80ef12-0fab-f12e-ebf5-2c0ab39a0f6f-C/latesthttps://sam.gov/entity/C1B1PFJUDP34/coreDataUSAspending contract recordarizonacommercial@hotmail.comyesfree webmailJeff Ashby928-474-217120062025-10-01https://search.certifications.sba.gov/profile/C1B1PFJUDP34/52HE6
C1DQM7UNJG567K461NATIONAL AIR DUCT MAINTENANCE CORPactiveZ2All Awards2026-05-042027-05-032026-05-052026-05-05439 N WESTERN AVECHICAGOIL606121419USA07439 N WESTERN AVECHICAGOIL60612USA2LCorporate Entity (Not Tax Exempt)ILUSA1964-01-0106-302X;A5For Profit Organization;Veteran Owned Businessyesyes238220Plumbing, Heating, and Air-Conditioning Contractors23Construction238220;561720;56179030FRANK GALASSOFRANK GALASSOFRANK GALASSOFRANK GALASSOno0E&Y2026-09-06312-829-1060312-829-46652026-06-1627399734.001550065.006047089.002020-10-012026-06-16Department of Veterans Affairs1SMALL BUSINESSC1DQM7UNJG56NATIONAL AIR DUCT MAINTENANCE CORPhttps://www.usaspending.gov/award/CONT_AWD_36C25223P0591_3600_-NONE-_-NONE-/https://www.usaspending.gov/award/CONT_AWD_36C25223P0591_3600_-NONE-_-NONE-/https://www.usaspending.gov/recipient/2a3e7e9c-5db6-00b3-ca51-2762074c1b8d-C/latesthttps://sam.gov/entity/C1DQM7UNJG56/coreDataUSAspending contract recordnadciw@aol.comyesfree webmailFrank Galasso312-829-106019642026-05-05https://search.certifications.sba.gov/profile/C1DQM7UNJG56/7K46172021-03-10NATIONAL AIR DUCT MAINTENANCE CORP.
Showing 5 real rows from 6,156 total, all 93 columns that carry data in them. 34 further columns are empty across these five rows — the field list above gives each one's fill rate across the whole file.

Federal Contractors — Plumbing, Heating, and Air-Conditioning Contractors (NAICS 238220)

6,156 locations · CSV · Updated Monthly

Buy Dataset — $39

?Frequently Asked Questions

What is one row in this file?

One entity registration in SAM.gov, the System for Award Management every organisation must register in before it can receive a federal contract or grant. US federal contractors with primary NAICS 238220, Plumbing, Heating, and Air-Conditioning Contractors — active SAM.gov registrations for contract awards. The row is keyed by the Unique Entity ID (UEI), which is permanent and is the same id USAspending and FPDS use.

Does it include email addresses or phone numbers?

Yes, from two public government sources, and every row says which. Telephone and fax come from the entity's most recent federal contract record in USAspending (FY2021–FY2026); where there is none, from the firm's own SBA Small Business Search profile. Email addresses come only from SBA profiles, and only where the firm chose to display them, so they are mostly small businesses. The SAM.gov extract itself carries contact names but no email or phone. Nothing is guessed or compiled from other lists, and no email is ever inferred from a website.

How often is it refreshed?

Monthly. GSA publishes the public entity extract once a month, on the first Sunday; this file is rebuilt from each new extract and carries the extract date on every row (2026-09-06 for the current file). There is no daily public extract, so a claim of weekly or daily updates for this data would not be true.

Is every SAM.gov registrant here?

Every registrant in the public extract except those who set the 'no public display' flag — 31,437 registrants in the 2026-09-06 file asked SAM not to show their registration in public search, and that request is honoured here even though the extract itself carries their records. Entities whose registration has expired are in the separate expired-registrations file, not this one.

How does this differ from USAspending or FPDS data?

SAM.gov records who is registered and eligible to receive an award; USAspending records the awards. This file joins the two on UEI: every registration, plus, for each one that won a contract FY2021–FY2026, the number of awards, dollars obligated in total and in the last 12 months, the top awarding agency, the contracting officer's size determination, the five highest-compensated officers where disclosed, and links to the largest and most recent award and the full USAspending recipient profile. The contract totals are reconciled to USAspending's own published totals for every closed fiscal year before a file is built.

How is the data verified?

A random sample of rows is round-tripped against the live SAM.gov Entity Management API on every build, comparing legal name, CAGE code, physical address, status and expiration date; a build with any disagreement is not published. Rows an entity updated after the monthly extract was cut are reported as drift, which the last_update_date column lets you see.

Related Datasets

$39
6,156 locations
Buy Dataset — $39