{"count":6,"carriers":[{"dot_number":"2049743","legal_name":"SPECIALTY POWERWASHING SERVICES LLC","dba_name":"SPS LLC","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"8678 S 550 E","phy_city":"BERNE","phy_state":"IN","phy_zip":"46711","phy_country":"US","phone":"2605898922","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20100625 0000","add_date":"20100625","officer_1":"JOE D ADAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:49:52","updated_at":"2026-05-16 01:49:52"},{"dot_number":"2355840","legal_name":"SPS LLC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"226 6TH STREET","phy_city":"BEVERLY","phy_state":"OH","phy_zip":"45715","phy_country":"US","phone":"7409841707","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":5,"total_drivers":7,"total_cdl":3,"mcs150_mileage":60000,"mcs150_mileage_year":"2016","mcs150_date":"20181002 0000","add_date":"20121107","officer_1":"JERRY M WELCH","officer_2":"","fleet_size_class":"C","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:06","updated_at":"2026-05-16 01:52:06"},{"dot_number":"2629503","legal_name":"WASPS LLC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"874 W 26TH ST","phy_city":"OGDEN","phy_state":"UT","phy_zip":"84401","phy_country":"US","phone":"3852442626","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":0,"mcs150_mileage":15000,"mcs150_mileage_year":"2025","mcs150_date":"20260509 0000","add_date":"20150427","officer_1":"ROBERT A WILSON","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:53:47","updated_at":"2026-05-16 01:53:47"},{"dot_number":"2985866","legal_name":"SPS LLC","dba_name":"","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"20842 HIGHWAY MM","phy_city":"VERSAILLES","phy_state":"MO","phy_zip":"65084-5462","phy_country":"US","phone":"5737891096","mc_number":"MC-22057","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":1,"mcs150_mileage_year":"2016","mcs150_date":"20170424 1101","add_date":"20170315","officer_1":"ROGER ALAN COCHRANE JR.","officer_2":"KAREN RENE BLAKLEY","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:56:44","updated_at":"2026-05-16 01:56:44"},{"dot_number":"4148664","legal_name":"SPS LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"512 LAYLA WAY","phy_city":"KILLDEER","phy_state":"ND","phy_zip":"58640","phy_country":"US","phone":"7015092396","mc_number":"MC-1592133","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20240418 1722","add_date":"20231024","officer_1":"NOAH GRIMM","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"B","source":"census","ingested_at":"2026-05-16 02:06:14","updated_at":"2026-05-16 02:06:14"},{"dot_number":"4286449","legal_name":"SPS LLC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"221 SAN PASQUAL AVE","phy_city":"SOUTH PASADENA","phy_state":"CA","phy_zip":"91030-1648","phy_country":"US","phone":"2106194050","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20240823 1814","add_date":"20240823","officer_1":"DAVID STERCKX","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 02:06:53","updated_at":"2026-05-16 02:06:53"}]}