runbookify
← All plans
Logistics & Transportation / Carrier Selection & Management

Carrier Authority & Safety Checker: Catch Revoked Carriers Before You Tender

Check every carrier's MC/DOT authority and safety rating against your reference snapshot before a load goes out — and make compliance sign off on anything that looks risky.

BeginnerAn afternoonBuilds onNext.jsSupabaseResend
What you'll build

A web tool where a dispatcher enters an MC or DOT number, it matches against your maintained FMCSA-style reference snapshot, flags revoked / conditional / out-of-date carriers, compliance reviews every flag and marks the carrier cleared-to-tender or hold, and every check is captured in an audit log.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A Supabase account (free)
  • A Vercel account (free)
  • A Resend account (free)
  • A CSV of your carrier list with MC/DOT numbers
  • A reference snapshot CSV (authority status + safety rating) you can refresh periodically
  • Claude Code or any AI coding agent

The problem this kills

A dispatcher is staring at a load that has to move now, and a carrier they've used before says they can grab it. So they tender it. What nobody checked in that moment: the carrier's operating authority was revoked last week, or their safety rating quietly went conditional, or the last time anyone verified them was four months ago. Now your brokerage has handed freight to a carrier that, on paper, has no business hauling it — and if anything goes wrong, that's your name on the file.

Authority and safety status change constantly, and the pressure to cover a load works directly against the discipline of checking. The fix isn't another binder of rules nobody reads at 4pm. It's a fast check the dispatcher actually does — type the MC or DOT number, see in plain language whether this carrier is good to go or needs a second look — backed by a compliance person who signs off on anything flagged. You do not need to be a developer to build that.

What you'll build

A simple internal web tool for your brokerage. A dispatcher types in a carrier's MC or DOT number right before tendering. The tool matches it against your maintained reference snapshot — the periodically-imported FMCSA-style file of authority status and safety ratings — and instantly tells them whether the carrier is active and good, or flagged because the authority is revoked / inactive, the safety rating is conditional or unsatisfactory, or the snapshot data is simply out of date and needs a recheck. Anything flagged goes to a compliance reviewer who looks at it and marks the carrier cleared-to-tender or hold — with a reason. Every check and every decision lands in an audit log, so you can always show who cleared which carrier, against what data, and when.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how you select and vet carriers today, what's in your carrier list and your snapshot file, the exact column names and ID conventions you use, how often you refresh the snapshot, your recheck cadence, and the messy edge cases (carriers with both MC and DOT, common-vs-contract authority, brokers posing as carriers). It reads a short spec back to you for a thumbs-up, then builds the tool around your answers instead of a generic template. From there it walks the agent through the data model, the snapshot import, the lookup-and-flag engine, the compliance review gate, the cleared-to-tender export, and the audit trail. Every step ends with a ready-to-copy prompt.

The governance it includes (this is the point)

This isn't a toy. The plan builds in the controls a real compliance function needs: login so only your team can use it, row-level security so people only see their own brokerage's carriers and decisions, a complete audit trail of every lookup and every clear/hold decision (who, what, against which snapshot, and when), a hard human-approval gate so no flagged carrier is marked cleared-to-tender until compliance decides, and duplicate guards keyed on the MC/DOT number so the same carrier isn't double-entered or a snapshot file imported twice. The whole tool exists to make a careful human decision fast — the system raises the flag, a person makes the call.

Who it's for

Freight-brokerage compliance leads, dispatch supervisors, and dispatchers who tender loads and need to confirm a carrier's authority and safety status in the few seconds they actually have before committing. If you can describe what makes a carrier "good to tender" in your shop, you can build this.

You've got this — open the plan, paste the first prompt, and you'll be checking your first carrier this afternoon.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.