Every company that runs a commercial truck across state lines in the US needs a USDOT number. When someone files for one, FMCSA adds a row to its Company Census File, and the US DOT publishes that file as an open dataset that refreshes daily.
That makes it one of the cleanest lead sources around. A brand-new carrier needs insurance, a factoring company, fuel cards, an ELD, a dispatcher and often a truck, all within its first few weeks. In the week to November 18 the file gained 1,509 new active carriers, and every one of them had a phone number and an email address on file.
This post shows how to query it directly, with no key and no scraping.
The endpoint
The census file lives on the DOT's Socrata portal as dataset az4n-8mr2:
https://data.transportation.gov/resource/az4n-8mr2.json
Socrata speaks SoQL, a small SQL dialect passed as query parameters. Counting the carriers added since a date takes one request:
GET https://data.transportation.gov/resource/az4n-8mr2.json
?$select=count(*)
&$where=add_date >= '20261113'
[{ "count": "1546" }]
add_date is stored as YYYYMMDD text, so a plain string comparison works.
Pulling the new carriers
const BASE = 'https://data.transportation.gov/resource/az4n-8mr2.json';
const ymd = (d) => d.toISOString().slice(0, 10).replace(/-/g, '');
const since = ymd(new Date(Date.now() - 7 * 86400000));
const where = [
`add_date >= '${since}'`,
`status_code = 'A'`, // active only
`phy_state in ('TX','FL','CA')`,
`classdef like '%AUTHORIZED FOR HIRE%'`,
].join(' AND ');
const url = `${BASE}?$where=${encodeURIComponent(where)}`
+ `&$order=${encodeURIComponent('add_date DESC, dot_number DESC')}`
+ `&$limit=1000&$offset=0`;
const rows = await (await fetch(url)).json();
console.log(rows.length, rows[0]);
Page with $offset until a page comes back shorter than $limit. Without an app token Socrata throttles you, but a daily pull of a few thousand rows is nowhere near the limit.
The fields that matter
Each row has around 40 columns. The useful ones:
| Column | What it is |
|---|---|
dot_number |
USDOT number, the primary key |
legal_name, dba_name
|
Company names |
add_date |
Date FMCSA added the carrier |
phone, email_address, company_officer_1
|
Contact details from the MCS-150 filing |
phy_street, phy_city, phy_state, phy_zip
|
Physical address |
carrier_operation |
A interstate, B intrastate hazmat, C intrastate non-hazmat |
classdef |
Free text such as AUTHORIZED FOR HIRE;PRIVATE PROPERTY
|
power_units, truck_units, total_drivers, total_cdl
|
Fleet size |
hm_ind |
Y if the carrier hauls hazmat |
A few gotchas:
-
power_unitsis text. Cast it to filter numerically:power_units::number <= 2. -
Cargo types are flag columns (
crgo_genfreight,crgo_bldgmat,crgo_produceand so on) holding'X'when set. A refrigerated-food filter iscrgo_coldfood = 'X'. -
MC numbers sit in
docket1..3, each with its own prefix and status columns. Look one up across all three with anOR. -
Phone numbers are bare digits. Normalize them to E.164 (
+1and 10 digits) before loading into a CRM.
What a week of new carriers looks like
From the 1,509 active carriers added between November 13 and 18:
- 74% are authorized for hire, meaning they haul other people's freight and need cargo insurance and a factoring partner
- 58% have one power unit or none, and 84% have two or fewer: these are owner-operators
- 57% are interstate, so they also need an MC authority, BOC-3 and UCR
- Top states: California 157, Texas 152, Florida 120, Georgia 80, Pennsylvania 74
- Top cargo: general freight 753, building materials 255, construction 255, grain/feed/hay 75
Weekday adds run around 400 a day, and weekend adds are far lower.
Turning it into a daily lead list
The pattern I use is a scheduled job that pulls the last 1 to 2 days, dedupes on dot_number and pushes new rows to a CRM or a sheet. If you'd rather not maintain it, I packaged the same query as an Apify actor: FMCSA Trucking Carrier Leads. It adds state, fleet size, cargo, hazmat and for-hire filters, plus lookup by DOT number, MC number or company name, and it returns normalized rows with a SAFER snapshot link.
{
"mode": "new",
"addedWithinDays": 1,
"states": ["TX", "FL"],
"authorizedForHireOnly": true,
"maxPowerUnits": 2,
"requireEmail": true
}
Either way, the data is public and free, and it updates every day.
A note on use: these are business registrations filed with a federal regulator. Many owner-operators list a personal phone and email, so follow CAN-SPAM and TCPA rules and honor opt-outs.
Top comments (0)