Disclosure: I'm Ben, and I built the Apify Actor mentioned later in this post. I charge per result for it. The tutorial part uses only free public data.
Freight insurance agents, factoring companies, ELD and fuel-card sellers, and brokers looking for capacity all need the same thing: a list of trucking companies with a phone number and fleet size. People pay for those lists, but the source behind most of them is free. Every US interstate carrier files an MCS-150 with FMCSA, and US DOT publishes the result as open data, refreshed daily.
Here's how to query it yourself, and what tripped me up.
The datasets
All on data.transportation.gov (Socrata), no key needed for light use:
Company Census File ( az4n-8mr2 ): one row per USDOT number, with legal name, address, phone, email (if filed), power units, drivers, cargo, operation type and status.
L&I "Carrier – All With History" ( 6eyk-hxee ): MC dockets, authority and insurance.
L&I "AuthHist – All With History" ( 9mw4-x3tu ): authority grants, revocations…