Using PPP Loan Data to Find HVAC and Plumbing Businesses to Buy
By Matt Cullerton, founder of Mavric and Apso
You can build a list of long-running trades businesses by filtering the SBA's public PPP loan file, joining Texas charter dates and Department of Labor Form 5500 filings, and mailing letters to the owners. A TikTok from @angusthenontechnical shows this pipeline with Claude doing the filtering and pitches it as a free replacement for a "$10k" Codie Sanchez program. The data sources are real and the math is right, but the payroll figures date from 2019 or 2020, the headcount join misses most large firms, and private equity buyers are already working the same niche.
How the PPP lead list workflow works
The video shows a six-step pipeline: "SBA PPP file," "Claude filters it," "Texas registration," "DOL Form 5500," "Jev reviews," "Letter to top 50." The prompt on screen asks the model to:
- Download
public_150k_plus_240930.csvfrom data.sba.gov. - Keep rows where NAICSCode is 238220, BorrowerState is TX and CurrentApprovalAmount is at least $150,000.
- Estimate annual payroll as loan / 2.5 x 12.
- Match each company to its Texas Secretary of State charter date and keep the ones registered 30+ years.
- Join the DOL Form 5500-SF file by company name to get active plan participants.
Every source named checks out. The SBA's PPP FOIA dataset lists public_150k_plus_240930.csv with a last update of October 21, 2024. The Texas Active Franchise Tax Permit Holders dataset carries an SOS file number and charter date for each taxpayer. The DOL's Form 5500 datasets cover "approximately 800,000 retirement and welfare benefit plans," refreshed "around the first of each month."
The payroll formula is also correct. SBA's loan-sizing guidance set the maximum loan at 2.5 times average monthly payroll, capped at $10 million, so dividing the loan by 2.5 and multiplying by 12 recovers the annual payroll the borrower claimed.
How many leads does it produce?
The model's on-screen output reports the funnel: "survivors.csv has 271 loans across 215 companies. That's 1,219 Texas 238220 loans of $150k+, narrowed to the ones whose name matches a Texas charter dated October 1996 or earlier." October 1996 is thirty years before the October 2026 post date. The sample results include Advent Air Conditioning (Lewisville, 1984), The Lee Thompson Co. (Houston, 1961), Texair Company Inc (McAllen, 1952) and Frost & Keeling (1978).
The narration calls these "plumbing businesses." NAICS 238220 is Plumbing, Heating, and Air-Conditioning Contractors, one combined code, and five of the six sample names are HVAC or mechanical firms.
Is PPP payroll data current?
No. PPP first-draw loans were sized on 2019 or 2020 payroll, and the dataset was last updated in October 2024. In an October 2026 outreach campaign, that payroll figure is about six years old.
The model flagged this on screen: "I left PPP JobsReported in as a 2020-era fallback." The voiceover skips that line and says the pipeline will "check each of their current headcounts."
The JobsReported field was unreliable from the start. Wealth Management reported on July 13, 2020 that out of nearly 4.9 million loans, jobs retained was zero for 554,146 records, blank for 324,122 and negative for seven.
Why the Form 5500 join misses the biggest firms
Form 5500-SF is the short form for small plans, generally those with fewer than 100 participants at the start of the plan year. Larger employers file the full Form 5500, which is a separate dataset. A business with no ERISA plan does not appear in either file.
The model said so on screen: "Only 85 rows got a headcount, and that's the biggest problem with this approach ... So the firms with $10M+ payroll mostly come back blank: Lochridge-Priest, Engineered Air Balance, Graco, United Chester, and others." It also warned that names were matched exactly after stripping punctuation and suffixes, so companies that renamed or operate under a DBA drop out.
The Texas charter date has its own limit. It records when the legal entity registered with the Secretary of State, which may differ from when the business started. An LLC conversion, holding-company restructure or merger resets it. The 30-year filter can drop old shops that reincorporated and keep newer operations inside old entities.
What is Jev?
The "Jev reviews" step reads Google reviews for a company, such as Reed Service Co., and returns yes/no answers with probabilities: "Owner still does the work? NO p = 1.00," "Named successor? YES p = 0.66," "Mentions retiring? NO p = 1.00." Jev is a decision model from TypeSafe AI, a San Francisco company founded by former OpenAI researcher Diogo Almeida, which came out of stealth with a $40 million seed led by DCVC. Its yes/no question type returns a probability, which matches the output on screen. Reed Service Co.'s site places it in Beaumont, Texas since 1974.
Codie Sanchez, BizScout and the "$10k" claim
The title card says "Codie Sanchez is a $10k workflow," and the narration says she "sells you a $10,000 community on how to do that." Her Contrarian Academy page publishes no price and routes applicants through an "Apply to join" form, so $10,000 is not a figure she states.
The video also shows a LinkedIn post from Sanchez announcing BizScout, an off-market deal-sourcing platform. She announced it on X in September 2024. BizScout's press page dates a $5 million seed round to April 14, 2026, with Valor Equity, Karman Ventures, Balaji Srinivasan, Sean Rad and Bill Perkins, and reports more than 150,000 registered users and 220 closed deals in eighteen months. Sanchez backed software for this sourcing step two years before the clip.
Private equity is buying the same businesses
On February 17, 2026, Blackstone agreed to buy Champions Group, a home services platform with more than 1,800 field technicians, from Odyssey Investment Partners for about $2.5 billion, roughly 18.5 times trailing EBITDA. Individual buyers mailing letters to HVAC owners are competing with buyers like that.
Angus says in the video: "This is not even my method, by the way. People have been doing this for years." The AI speeds up sourcing. Seller financing, diligence on a business without audited financials, license transfer and keeping the crew after the owner leaves are not in the six-step pipeline.
Bottom line
The PPP, Texas charter and Form 5500 sources are real, and the 2.5x payroll formula matches SBA rules. The payroll data is from 2019 or 2020, the 5500-SF join returned headcounts for only 85 of 271 rows, and NAICS 238220 is mostly HVAC. The "$10k" price is not published by Sanchez, and she funded a sourcing platform for this work in 2024.
Sources
- SBA PPP FOIA dataset - the PPP loan files and last update date.
- SBA, How to Calculate Maximum Loan Amounts - the 2.5x payroll sizing rule.
- DOL EBSA Form 5500 Datasets - plan filing data.
- DOL 2023 Form 5500-SF Instructions - the small-plan threshold.
- Texas Active Franchise Tax Permit Holders - SOS file numbers and charter dates.
- NAICS 238220 - the industry code definition.
- Wealth Management, PPP data errors, July 13, 2020 - problems in the jobs-retained field.
- DataCamp, Jev explained - TypeSafe AI's Jev model.
- Reed Service Co. - company history.
- BizScout seed round press page - BizScout funding and user figures.
- Codie Sanchez on X, September 2024 - BizScout announcement.
- Contrarian Academy - application-only program with no listed price.
- PE Professional, Blackstone and Champions Group - the $2.5 billion deal.
Published October 5, 2026. Based on a TikTok by @6783510017912865797. Full video notes (markdown)