Freight brokerage

Both legs read FMCSA — the Company Census for the carrier and the operating-authority record for active status — but the magic is a computed filter on the authority grant date, isolating the 54-to-60-month band. That window is when insurance and factoring relationships recurringly come up for renewal, a predictable capital moment tied to the age of the authority rather than any single event. Most carrier lists are undated and static; deriving the authority age turns the census into a timing tool, surfacing the fleets at the exact recurring decision point. It's two FMCSA records plus a date calculation competitors reading raw rosters simply don't do — the renewal moment, computed.

The primary leg reads an FMCSA operating-authority revocation — the carrier can no longer legally haul for hire; the intersect leg confirms they STILL appear on the active carrier roster (the L&I / MCS-150 census). That gap — revoked authority but still listed and operating — is a displacement moment: freight that needs a new home, equipment that may come to market, a book of business in transition. Brokers, asset-based carriers, and transportation M&A buyers want exactly that timing. A revocation alone might be a name already gone; requiring a live roster presence catches the carriers caught mid-wind-down, across an authority record and the census that hasn't caught up yet.

One leg reads a WARN Act layoff notice — a filed, dated downsizing; the other confirms the carrier still shows active operating status on the FMCSA L&I roster. A layoff at a company already gone is noise; a layoff at a carrier still listed and operating is a fleet coming apart while the trucks are still on the road. That gap is the day-one window for equipment buyers, auctioneers, and factors — capacity about to free up and assets about to move, caught the week the notice posts rather than after the auction is announced. Two records that rarely sit together: a state layoff filing and the carrier census.