US FMCSA Insurance Gap, Permits & New LLC Signal Engine avatar

US FMCSA Insurance Gap, Permits & New LLC Signal Engine

Pricing

from $4.50 / 1,000 verified b2b signal rows

Go to Apify Store
US FMCSA Insurance Gap, Permits & New LLC Signal Engine

US FMCSA Insurance Gap, Permits & New LLC Signal Engine

Zero-proxy US public-record B2B signal engine: (1) FMCSA 3-table live BMC-91X insurance gap & phone cross-join, (2) 100% phone-verified $75K+ Austin & NYC commercial permits, (3) Colorado SOS & Texas Sales Tax new LLCs with Registered Agent proxy filtering.

Pricing

from $4.50 / 1,000 verified b2b signal rows

Rating

0.0

(0)

Developer

Yaşar Kaan Özdamur

Yaşar Kaan Özdamur

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

3 hours ago

Last modified

Categories

Features

Limited permissions

Share

US DOT FMCSA 3-Table Insurance Gap & Verified-Phone Commercial Permits Engine

Structured B2B lead intelligence engine built on official US federal and municipal Socrata Open Data APIs (data.transportation.gov, data.austintexas.gov, data.cityofnewyork.us).

Unlike single-table scrapers that output raw policy rows without phone numbers or unverified building permits with empty contractor fields, this Actor executes a server-side batch SoQL Cross-Join across three official tables and filters strictly for 100% phone-verified records.


Why Single-Table Socrata Scrapers Fail (And How Cross-Join Solves It)

Data SourceSingle-Table Scraper ProblemThis Actor's Cross-Join Architecture
US DOT FMCSA Insurance (x96h-evps)Contains docket_number, usdot_number, policy_no, and BMC-91X transaction dates, but 0% company names, 0% phone numbers, and 0% current authority status.Joins x96h-evps (daily BMC-91X filings) ⋈ inys-ebih (Authority & Contact table via batch WHERE docket_number IN (...)) ⋈ az4n-8mr2 (Company Census power_units), returning 100% verified phone (bus_telno), company name (legal_name), street address, and $0 BIPD insurance-gap flags.
Austin Building Permits (3syk-w9eu)Unfiltered queries return 72%–76% NULL project valuations (minor residential plumbing/electrical work).Enforces permit_class_mapped='Commercial' AND total_job_valuation >= 75000 AND contractor_phone IS NOT NULL, yielding 100% General Contractor company, contact name, direct phone, and verified dollar valuation ($100K–$60M+).
NYC DOB Permits (ipu4-2q9a)Raw dumps include minor plumbing/signage rows and unparsed text dates (MM/DD/YYYY).Filters strictly for job_type IN ('NB', 'A1') (New Buildings & Major Class-A1 Alterations) with 100% verified contractor phone (permittee_s_phone__) and NYC DOB license numbers.
CO SOS (4ykn-tg5h) & TX Sales Tax (jrea-zgmq)Raw business registry dumps are flooded with commercial Registered Agent proxy addresses (Northwest RA, LegalZoom, Incfile).Automatically flags COMMERCIAL_RA_PROXY vs DIRECT_OWNER_OR_OFFICE so outbound teams can optionally exclude proxy filings (excludeCommercialRaProxy: true).
Seattle (76t5-zqzr) & LA (pi9x-tg5x)Seattle commercial permits have 84% NULL contractor names and no phone column; Los Angeles has 0% contractor/phone columns.Excluded by design. Every FMCSA and commercial permit record emitted is guaranteed to carry a non-empty company name and direct phone number.

Signal Priority Tags (signal_priority)

Mode A: fmcsa_crossjoin (Trucking Insurance Brokers, Freight Factoring & Fleet SaaS)

  1. CRITICAL_BIPD_ZERO: Carrier holds an Active or existing operating authority in inys-ebih, has a recent BMC-91X transaction in x96h-evps, but currently shows bipd_file = 0.00 ($0 Bodily Injury & Property Damage coverage on file — highest urgency compliance/re-quoting signal).
  2. PENDING_NEW_BMC91X: Carrier operating authority is Pending with bipd_file = 0.00 and a newly submitted BMC-91X policy filing processed today.
  3. ACTIVE_RENEWAL: Established carrier (Active / Inactive with bipd_file >= $750,000) recording a new BMC-91X policy replacement or renewal.

Mode B: permits_verified_phone (Construction Equipment Rental, Subcontractors, B2B Suppliers)

  1. TIER1_COMMERCIAL_1M_PLUS: Commercial project with reported job valuation >= $1,000,000 and verified General Contractor phone.
  2. TIER2_COMMERCIAL_75K_PLUS: Commercial project with reported job valuation between $75,000 and $999,999 and verified General Contractor phone.
  3. TIER1_NYC_NEW_BUILDING_NB: NYC Department of Buildings NB (New Building) permit with verified contractor phone and DOB license.
  4. TIER2_NYC_MAJOR_ALT_A1: NYC Department of Buildings A1 (Major Alteration requiring new Certificate of Occupancy) with verified contractor phone and DOB license.

Mode C: new_llc_tax (Merchant Services, Business Banking, Bookkeeping & Web Agencies)

  1. CO_NEW_LLC_DIRECT_OWNER / CO_NEW_LLC_RA_PROXY: Newly formed Colorado LLCs/Corps (4ykn-tg5h) tagged with Commercial Registered Agent proxy detection.
  2. TX_ACTIVE_SALES_TAX_PERMIT: Active Texas Comptroller Sales Tax Permits (jrea-zgmq) with physical commercial storefront addresses and NAICS codes.

Live Sample Output

1. FMCSA 3-Table Cross-Join (live_fmcsa_signals.csv)

signal_prioritytrans_datedocket_numberusdot_numberlegal_namephone_formattedbus_citybus_state_codeop_auth_statusbipd_filemax_cov_amountpower_units
CRITICAL_BIPD_ZERO2026-11-19MC864742618560685S.B.S Logistics Services LLC+1 (832) 713-7688HoustonTXActive0.00750000.002
CRITICAL_BIPD_ZERO2026-11-19MC571061187050650Midnight Mile Trucking LLC+1 (513) 616-1205SpringdaleOHActive0.00750000.001
PENDING_NEW_BMC91X2026-11-19MC641888514991621J7 Enterprises LLC+1 (573) 576-1858Cape GirardeauMOPending0.00750000.00PENDING_CENSUS_SYNC
PENDING_NEW_BMC91X2026-11-19MC572992755826764CORREIA HEAVY CONTRACTING LLC+1 (848) 203-8998aberdeenNJPending0.00750000.001
ACTIVE_RENEWAL2026-11-19MC3710132368413GDK LOGISTICS INC+1 (201) 906-4734Lincoln ParkNJActive750000.00750000.008
ACTIVE_RENEWAL2026-11-19MC754557136707247GARVIA TRANSPORT LLC+1 (484) 651-4549TemplePAActive1000000.001000000.006

2. Verified-Phone Commercial Permits (live_permits_signals.csv)

signal_prioritysource_citypermit_idissue_datecontractor_companycontractor_contactcontractor_phonelicense_or_tradeproject_addressvaluation_usd
TIER1_COMMERCIAL_1M_PLUSAUSTIN_TX2026-084222 BP2026-11-17Hensel Phelps Construction Co.Bradley Winans+1 (512) 834-9848General Contractor10113 MAINTAINERS DR60000000.00
TIER1_COMMERCIAL_1M_PLUSAUSTIN_TX2020-158797 BP2026-11-12Constructinople LLCEyad Kasemi+1 (909) 806-9750General Contractor1717 E ANDERSON LN SVRD EB4000000.00
TIER2_COMMERCIAL_75K_PLUSAUSTIN_TX2026-132873 BP2026-11-18Hanna Design Group IncRobert Perry+1 (847) 719-0372General Contractor8602 FM 969 RD BLDG 3775000.00
TIER1_NYC_NEW_BUILDING_NBNYC_NY3215981882026-11-16PARK MANAGEMENT USA CORPSHIA KOHN+1 (718) 210-3181DOB-LIC-06219356 HOWARD AVE, BROOKLYNEST_MAJOR_NB_A1
TIER1_NYC_NEW_BUILDING_NBNYC_NY2101821942026-11-16SPAXEL BUILDERS LLCGUCIM GJONBALAJ+1 (347) 827-6153DOB-LIC-06231921695 MONROE AVENUE, BRONXEST_MAJOR_NB_A1

Input Configuration

{
"mode": "all",
"limit": 15,
"minPermitValuationUsd": 75000,
"onlyCriticalBipdZero": false,
"excludeCommercialRaProxy": false,
"socrataAppToken": ""
}
  • mode ("all" | "both" | "fmcsa_crossjoin" | "permits_verified_phone" | "new_llc_tax"): Selects which pipeline(s) to execute.
  • limit (integer, default 15, max 200): Maximum enriched records returned per pipeline. Uses chunked 50-item batch WHERE ... IN (...) SoQL requests to stay well below public Socrata rate limits with $0 proxy cost.
  • minPermitValuationUsd (integer, default 75000): Minimum commercial job valuation in USD for Austin building permits.
  • onlyCriticalBipdZero (boolean, default false): When true, filters FMCSA output strictly to CRITICAL_BIPD_ZERO and PENDING_NEW_BMC91X records.
  • excludeCommercialRaProxy (boolean, default false): When true, filters out Colorado LLCs filed via commercial Registered Agent proxies (e.g., Northwest RA, LegalZoom, Incfile).
  • socrataAppToken (string, optional): Optional X-App-Token for Socrata APIs. If omitted or if the optional az4n-8mr2 census endpoint returns HTTP 429, the engine logs SKIPPED_HTTP_429_GRACEFUL in census_flag and completes without failing.

1-Click AI Agent & MCP Server Integration (Claude, Cursor, n8n)

This Actor is natively MCP-ready via Apify's official Model Context Protocol endpoint—no server hosting required:

  • Single-Actor MCP Endpoint: https://mcp.apify.com/?actors=pipeforge/us-socrata-b2b-signal-crossjoin-engine
  • 2-Actor B2B Signal + Domain Trigger Chain: https://mcp.apify.com/?actors=pipeforge/us-socrata-b2b-signal-crossjoin-engine,pipeforge/b2b-domain-tech-stack-dns-ssl-sales-trigger

Example prompt in Claude Desktop / Cursor / n8n AI Agent:

"Run pipeforge/us-socrata-b2b-signal-crossjoin-engine in fmcsa_crossjoin mode with onlyCriticalBipdZero: true and limit: 25, then return a call sheet of carriers with active authority, $0 BIPD on file, fleet size, and formatted phone numbers."


n8n / Make.com / Clay Webhook Automation

  1. Add an HTTP Request node (POST https://api.apify.com/v2/acts/pipeforge~us-socrata-b2b-signal-crossjoin-engine/run-sync-get-dataset-items) using Header Auth (Authorization: Bearer <YOUR_APIFY_TOKEN>) scheduled daily at 07:00 EST.
  2. Set mode to "fmcsa_crossjoin", "permits_verified_phone", or "new_llc_tax".
  3. Map phone_formatted / contractor_phone, legal_name / contractor_company, and signal_priority directly into HubSpot, Close CRM, Clay, Google Sheets, or Slack alerts.