{"current_page":1,"data":[{"id":11943837,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","dot_number":"3935126","report_state":"RI","report_number":"M014000062","insp_date":"2026-05-07 00:00:00","insp_start_time":"1501","insp_end_time":"1456","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3348221","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2026-05-17 21:35:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-17 21:35:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-20T09:41:08.000000Z","updated_at":"2026-05-28T09:30:07.000000Z","inspection_violations":[{"id":20773532,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320417","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"26203503482, 26","created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3922SLL"},{"id":20773533,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320418","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213607165","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3939ALSML"},{"id":20773534,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320419","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213607165","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3939ALSML"},{"id":20773535,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320420","seq_no":"4","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"213607164","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3922SLLMF"},{"id":20773536,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320421","seq_no":"5","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"213607165","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"26203503603","created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3963A1HCM"},{"id":20773537,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320422","seq_no":"6","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213607164","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"39378AWS"},{"id":20773538,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320423","seq_no":"7","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213607165","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3939ALSML"},{"id":20773539,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320424","seq_no":"8","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213607164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3939ALFTSI"},{"id":20773540,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_violation_id":"274320425","seq_no":"9","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213607165","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:06.000000Z","updated_at":"2026-05-28T09:39:31.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":20769068,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_unit_id":"213607165","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"1","insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:15.000000Z","updated_at":"2026-05-28T09:01:44.000000Z"},{"id":20769067,"change_date":"2026-05-17 21:35:00","inspection_id":"87879087","insp_unit_id":"213607164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:15.000000Z","updated_at":"2026-05-28T09:01:44.000000Z"}]},{"id":11691964,"change_date":"2026-04-20 21:37:00","inspection_id":"87618042","dot_number":"3935126","report_state":"RI","report_number":"M034000158","insp_date":"2026-04-14 00:00:00","insp_start_time":"1053","insp_end_time":"1128","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH KINGSTOWN RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-20 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"24650","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3182946","transaction_code":"A","transaction_date":"2026-04-19 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2026-04-20 21:37:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:37:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:15.000000Z","updated_at":"2026-05-01T09:30:19.000000Z","inspection_violations":[{"id":20313297,"change_date":"2026-04-20 21:37:00","inspection_id":"87618042","insp_violation_id":"273707417","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"213103550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:23.000000Z","updated_at":"2026-05-01T09:41:04.000000Z","normalized_code":"3939ALRLI"},{"id":20313298,"change_date":"2026-04-20 21:37:00","inspection_id":"87618042","insp_violation_id":"273707418","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"213103550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:23.000000Z","updated_at":"2026-05-01T09:41:04.000000Z","normalized_code":"3939ALSLI"},{"id":20313296,"change_date":"2026-04-20 21:37:00","inspection_id":"87618042","insp_violation_id":"273707416","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"26502500932 & 2","created_at":"2026-04-27T09:50:23.000000Z","updated_at":"2026-05-01T09:41:04.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":20348212,"change_date":"2026-04-20 21:37:00","inspection_id":"87618042","insp_unit_id":"213103549","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:24.000000Z","updated_at":"2026-05-01T09:02:50.000000Z"},{"id":20348213,"change_date":"2026-04-20 21:37:00","inspection_id":"87618042","insp_unit_id":"213103550","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:24.000000Z","updated_at":"2026-05-01T09:02:50.000000Z"}]},{"id":11517242,"change_date":"2026-03-30 21:39:00","inspection_id":"87438250","dot_number":"3935126","report_state":"MA","report_number":"EI00000383","insp_date":"2026-03-30 00:00:00","insp_start_time":"1331","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"327H","location_desc":"H-SWANSEA","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"AUTOCLEAR TECH","shipping_paper_number":"129-032026","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24650","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"543089","transaction_code":"A","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2026-03-30 21:39:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-30 21:39:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-02T09:46:54.000000Z","updated_at":"2026-04-10T09:31:04.000000Z","inspection_violations":[{"id":19455058,"change_date":"2026-03-30 21:39:00","inspection_id":"87438250","insp_violation_id":"272738206","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"212424277","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"121682AE","created_at":"2026-04-02T10:10:21.000000Z","updated_at":"2026-04-09T09:52:14.000000Z","normalized_code":"3922SLL"},{"id":19455059,"change_date":"2026-03-30 21:39:00","inspection_id":"87438250","insp_violation_id":"272738207","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"212424277","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:21.000000Z","updated_at":"2026-04-09T09:52:14.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19732053,"change_date":"2026-03-30 21:39:00","inspection_id":"87438250","insp_unit_id":"212424277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:40.000000Z","updated_at":"2026-04-10T09:05:40.000000Z"},{"id":19732054,"change_date":"2026-03-30 21:39:00","inspection_id":"87438250","insp_unit_id":"212424278","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:40.000000Z","updated_at":"2026-04-10T09:05:40.000000Z"}]},{"id":9466211,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","dot_number":"3935126","report_state":"RI","report_number":"M008000205","insp_date":"2025-08-15 00:00:00","insp_start_time":"1353","insp_end_time":"1510","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH KINGSTOWN RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2156236","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2025-08-21 21:40:00","snet_input_date":"2025-08-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-21 21:40:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:41.000000Z","updated_at":"2025-08-25T10:42:41.000000Z","inspection_violations":[{"id":15422700,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","insp_violation_id":"268153983","seq_no":"1","part_no":"393","part_no_section":"75A2-TAOBB-6","insp_viol_unit":"2","insp_unit_id":"208502640","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25502502208","created_at":"2025-08-24T10:48:26.000000Z","updated_at":"2025-08-25T10:43:50.000000Z","normalized_code":"39375A2TAOBB6"},{"id":15422701,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","insp_violation_id":"268153984","seq_no":"2","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"208502639","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"25502502207","created_at":"2025-08-24T10:48:26.000000Z","updated_at":"2025-08-25T10:43:50.000000Z","normalized_code":"39341BNPB"},{"id":15422702,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","insp_violation_id":"268153985","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"208502640","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"25502502208","created_at":"2025-08-24T10:48:26.000000Z","updated_at":"2025-08-25T10:43:50.000000Z","normalized_code":"39343DB"},{"id":15422703,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","insp_violation_id":"268153986","seq_no":"4","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"208502639","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"25502502207","created_at":"2025-08-24T10:48:26.000000Z","updated_at":"2025-08-25T10:43:50.000000Z","normalized_code":"393207ASTBW"}],"inspection_per_units":[{"id":15612655,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","insp_unit_id":"208502639","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2570","insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:36.000000Z","updated_at":"2025-08-25T09:45:21.000000Z"},{"id":15612656,"change_date":"2025-08-21 21:40:00","inspection_id":"85549059","insp_unit_id":"208502640","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:36.000000Z","updated_at":"2025-08-25T09:45:21.000000Z"}]},{"id":9388847,"change_date":"2025-08-12 21:39:00","inspection_id":"85467741","dot_number":"3935126","report_state":"MA","report_number":"DF00002515","insp_date":"2025-08-11 00:00:00","insp_start_time":"1710","insp_end_time":"1724","registration_date":null,"region":"ET","ci_status_code":"C","location":"372H","location_desc":"H-WESTWOOD","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"525454","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2025-08-12 21:39:00","snet_input_date":"2025-08-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-12 21:39:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:42.000000Z","updated_at":"2025-08-16T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15471030,"change_date":"2025-08-12 21:39:00","inspection_id":"85467741","insp_unit_id":"208351116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:19.000000Z","updated_at":"2025-08-16T09:45:40.000000Z"},{"id":15471031,"change_date":"2025-08-12 21:39:00","inspection_id":"85467741","insp_unit_id":"208351117","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:19.000000Z","updated_at":"2025-08-16T09:45:40.000000Z"}]},{"id":9138731,"change_date":"2025-07-14 21:40:00","inspection_id":"85204952","dot_number":"3935126","report_state":"MA","report_number":"CC00007471","insp_date":"2025-07-08 00:00:00","insp_start_time":"1833","insp_end_time":"2005","registration_date":null,"region":"ET","ci_status_code":"C","location":"294H","location_desc":"H-SEEKONK","county_code_state":"MA","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"522610","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:43.000000Z","updated_at":"2025-07-18T10:45:43.000000Z","inspection_violations":[{"id":14741905,"change_date":"2025-07-14 21:40:00","inspection_id":"85204952","insp_violation_id":"267384373","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:05.000000Z","updated_at":"2025-07-18T10:47:01.000000Z","normalized_code":"38323A2LCDLN"},{"id":14741906,"change_date":"2025-07-14 21:40:00","inspection_id":"85204952","insp_violation_id":"267384374","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"2","insp_unit_id":"207850913","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:05.000000Z","updated_at":"2025-07-18T10:47:01.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":15006855,"change_date":"2025-07-14 21:40:00","inspection_id":"85204952","insp_unit_id":"207850912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:29.000000Z","updated_at":"2025-07-18T09:45:36.000000Z"},{"id":15006856,"change_date":"2025-07-14 21:40:00","inspection_id":"85204952","insp_unit_id":"207850913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:29.000000Z","updated_at":"2025-07-18T09:45:36.000000Z"}]},{"id":8490898,"change_date":"2025-04-29 21:48:00","inspection_id":"84520557","dot_number":"3935126","report_state":"MA","report_number":"DZ00000339","insp_date":"2025-04-28 00:00:00","insp_start_time":"1615","insp_end_time":"1624","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"45092885","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"515993","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:46.000000Z","updated_at":"2025-05-02T13:50:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13799816,"change_date":"2025-04-29 21:48:00","inspection_id":"84520557","insp_unit_id":"206533516","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:14:26.000000Z","updated_at":"2025-05-03T10:05:36.000000Z"},{"id":13799817,"change_date":"2025-04-29 21:48:00","inspection_id":"84520557","insp_unit_id":"206533517","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"1PC206","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"4YNBN16284C019515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:14:26.000000Z","updated_at":"2025-05-03T10:05:36.000000Z"}]},{"id":8422823,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","dot_number":"3935126","report_state":"RI","report_number":"0050000011","insp_date":"2025-04-14 00:00:00","insp_start_time":"1056","insp_end_time":"1205","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HOWARDS WHOLESALE AUTO","shipping_paper_number":"S3-27303300","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"10","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1618661","transaction_code":"A","transaction_date":"2025-04-20 00:00:00","upload_date":"2025-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2025-04-20 21:33:00","snet_input_date":"2025-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-20 21:33:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-23T10:02:56.000000Z","updated_at":"2025-04-24T10:01:39.000000Z","inspection_violations":[{"id":13292184,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723526","seq_no":"1","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"206401484","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"39311A1CSURR"},{"id":13292185,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723527","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"206401485","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"3939ALSML"},{"id":13292186,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723528","seq_no":"3","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"2","insp_unit_id":"206401485","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":13292187,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723529","seq_no":"4","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"206401484","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"39311A1CSLRR"},{"id":13292188,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723530","seq_no":"5","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"206401484","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"39311A1LLPL"},{"id":13292189,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723531","seq_no":"6","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"2","insp_unit_id":"206401485","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"39341BNPB"},{"id":13292190,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723532","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206401485","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"3963A1BOS"},{"id":13292191,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723533","seq_no":"8","part_no":"393","part_no_section":"42A-BM","insp_viol_unit":"2","insp_unit_id":"206401485","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"39342ABM"},{"id":13292192,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723534","seq_no":"9","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"206401484","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"39341BNPB"},{"id":13292193,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_violation_id":"265723535","seq_no":"10","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"206401484","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-23T10:20:04.000000Z","updated_at":"2025-04-24T10:20:16.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":13675866,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_unit_id":"206401484","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-23T09:49:34.000000Z","updated_at":"2025-04-24T09:47:52.000000Z"},{"id":13675867,"change_date":"2025-04-20 21:33:00","inspection_id":"84448895","insp_unit_id":"206401485","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-23T09:49:34.000000Z","updated_at":"2025-04-24T09:47:52.000000Z"}]},{"id":8301839,"change_date":"2025-04-05 21:33:00","inspection_id":"84321426","dot_number":"3935126","report_state":"RI","report_number":"0070000791","insp_date":"2025-03-31 00:00:00","insp_start_time":"0720","insp_end_time":"0830","registration_date":null,"region":"ED","ci_status_code":"C","location":"95 SB","location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1557144","transaction_code":"A","transaction_date":"2025-04-05 00:00:00","upload_date":"2025-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2025-04-05 21:33:00","snet_input_date":"2025-03-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-05 21:33:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-08T10:08:52.000000Z","updated_at":"2025-04-09T10:00:46.000000Z","inspection_violations":[{"id":13055156,"change_date":"2025-04-05 21:33:00","inspection_id":"84321426","insp_violation_id":"265455765","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"206168564","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:56:49.000000Z","updated_at":"2025-04-09T10:18:32.000000Z","normalized_code":"3922SLLUCR"},{"id":13055157,"change_date":"2025-04-05 21:33:00","inspection_id":"84321426","insp_violation_id":"265455766","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25001601351","created_at":"2025-04-07T10:56:49.000000Z","updated_at":"2025-04-09T10:18:32.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":13460516,"change_date":"2025-04-05 21:33:00","inspection_id":"84321426","insp_unit_id":"206168564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-08T10:02:27.000000Z","updated_at":"2025-04-09T09:51:15.000000Z"},{"id":13460517,"change_date":"2025-04-05 21:33:00","inspection_id":"84321426","insp_unit_id":"206168565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-08T10:02:27.000000Z","updated_at":"2025-04-09T09:51:15.000000Z"}]},{"id":7552898,"change_date":"2025-01-06 21:38:00","inspection_id":"83534301","dot_number":"3935126","report_state":"RI","report_number":"0070000637","insp_date":"2024-12-30 00:00:00","insp_start_time":"1619","insp_end_time":"1730","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218242","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2025-01-06 21:38:00","snet_input_date":"2024-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:38:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[{"id":11805771,"change_date":"2025-01-06 21:38:00","inspection_id":"83534301","insp_violation_id":"263765677","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"24001545810","created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":12186514,"change_date":"2025-01-06 21:38:00","inspection_id":"83534301","insp_unit_id":"204660487","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"},{"id":12186515,"change_date":"2025-01-06 21:38:00","inspection_id":"83534301","insp_unit_id":"204660488","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7515612,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","dot_number":"3935126","report_state":"RI","report_number":"0203000126","insp_date":"2024-12-23 00:00:00","insp_start_time":"1221","insp_end_time":"1321","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SODJO BUSINESS CENTER","shipping_paper_number":"HBL24-9012","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202933","transaction_code":"C","transaction_date":"2024-12-30 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2024-12-30 21:38:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-30 21:38:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:43.000000Z","updated_at":"2025-03-17T20:52:43.000000Z","inspection_violations":[{"id":11746087,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","insp_violation_id":"263904078","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"204776829","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39341BNPB"},{"id":11746088,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","insp_violation_id":"263904079","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"2","insp_unit_id":"204776830","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"393207ASAPPAS"},{"id":11746089,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","insp_violation_id":"263904080","seq_no":"3","part_no":"391","part_no_section":"45B-MCEM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39145BMCEM"},{"id":11746090,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","insp_violation_id":"263904081","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204776829","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":12125029,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","insp_unit_id":"204776829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1QW145","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWX36F4YEA98270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:53.000000Z","updated_at":"2025-03-17T23:48:53.000000Z"},{"id":12125030,"change_date":"2025-01-13 21:45:00","inspection_id":"83495116","insp_unit_id":"204776830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:53.000000Z","updated_at":"2025-03-17T23:48:53.000000Z"}]},{"id":6694703,"change_date":"2024-09-11 21:40:00","inspection_id":"82625968","dot_number":"3935126","report_state":"RI","report_number":"0114000106","insp_date":"2024-09-04 00:00:00","insp_start_time":"0919","insp_end_time":"1019","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"EAST GREENWICH RI","county_code_state":"RI","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22150","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"833460","transaction_code":"A","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2024-09-11 21:40:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-11 21:40:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:41.000000Z","updated_at":"2025-03-17T20:35:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10794698,"change_date":"2024-09-11 21:40:00","inspection_id":"82625968","insp_unit_id":"202859206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"},{"id":10794699,"change_date":"2024-09-11 21:40:00","inspection_id":"82625968","insp_unit_id":"202859207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"}]},{"id":5315752,"change_date":"2024-03-19 21:44:00","inspection_id":"81137918","dot_number":"3935126","report_state":"MA","report_number":"DB00001951","insp_date":"2024-03-18 00:00:00","insp_start_time":"1855","insp_end_time":"1906","registration_date":null,"region":"ET","ci_status_code":"C","location":"233H","location_desc":"H-NORTH ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"METRO GISTICS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"487952","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2024-03-19 21:44:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-19 21:44:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:55.000000Z","updated_at":"2025-03-17T20:07:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8561283,"change_date":"2024-03-19 21:44:00","inspection_id":"81137918","insp_unit_id":"199977033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"},{"id":8561284,"change_date":"2024-03-19 21:44:00","inspection_id":"81137918","insp_unit_id":"199977034","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"1PC126","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL4336NL010067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"}]},{"id":2755664,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","dot_number":"3935126","report_state":"RI","report_number":"502A001060","insp_date":"2023-04-07 00:00:00","insp_start_time":"1021","insp_end_time":"1121","registration_date":null,"region":"ET","ci_status_code":"C","location":"502","location_desc":"RTE 403","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23150","viol_total":"4","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"81545","transaction_code":"C","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2023-06-29 21:41:00","snet_input_date":"2023-04-07 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:23.000000Z","updated_at":"2025-03-17T19:17:23.000000Z","inspection_violations":[{"id":4229558,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","insp_violation_id":"253770990","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195739128","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4229559,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","insp_violation_id":"253770991","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195739128","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"23502500829","created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3963A1"},{"id":4229560,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","insp_violation_id":"253770992","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"195739129","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39343"},{"id":4229561,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","insp_violation_id":"253770993","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195739129","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":4435092,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","insp_unit_id":"195739128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"},{"id":4435093,"change_date":"2023-06-29 21:41:00","inspection_id":"78294139","insp_unit_id":"195739129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"3N987","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL3522DL002495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"}]},{"id":2221885,"change_date":"2023-01-25 21:42:00","inspection_id":"77685954","dot_number":"3935126","report_state":"ME","report_number":"0242001864","insp_date":"2023-01-25 00:00:00","insp_start_time":"0720","insp_end_time":"0743","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23150","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"359630","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2023-01-25 21:42:00","snet_input_date":"2023-01-25 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-01-25 21:42:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:42.000000Z","updated_at":"2025-03-17T19:07:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3575952,"change_date":"2023-01-25 21:42:00","inspection_id":"77685954","insp_unit_id":"193050432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"Y","insp_unit_decal_number":"32395261","created_at":"2025-03-17T22:31:39.000000Z","updated_at":"2025-03-17T22:31:39.000000Z"},{"id":3575953,"change_date":"2023-01-25 21:42:00","inspection_id":"77685954","insp_unit_id":"193050433","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"KAMP","insp_unit_company":null,"insp_unit_license":"3N987","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL3522DL002495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:39.000000Z","updated_at":"2025-03-17T22:31:39.000000Z"}]},{"id":2176075,"change_date":"2023-01-19 21:43:00","inspection_id":"77633592","dot_number":"3935126","report_state":"MA","report_number":"CC00006108","insp_date":"2023-01-18 00:00:00","insp_start_time":"1940","insp_end_time":"2000","registration_date":null,"region":"ET","ci_status_code":"C","location":"329H","location_desc":"H-TAUNTON","county_code_state":"MA","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"23150","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"458966","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":"M","census_search_date":"2023-01-19 21:43:00","snet_input_date":"2023-01-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-19 21:43:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3502291,"change_date":"2023-01-19 21:43:00","inspection_id":"77633592","insp_unit_id":"192944070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"},{"id":3502292,"change_date":"2023-01-19 21:43:00","inspection_id":"77633592","insp_unit_id":"192944071","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"KAMP","insp_unit_company":null,"insp_unit_license":"3N987","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL3522DL002495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":2101511,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","dot_number":"3935126","report_state":"ME","report_number":"9270001819","insp_date":"2023-01-09 00:00:00","insp_start_time":"1205","insp_end_time":"1242","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"PRE OWNED AUTO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23150","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"359035","transaction_code":"A","transaction_date":"2023-01-09 00:00:00","upload_date":"2023-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03935126","upload_search_indicator":null,"census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-09 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"SPESHOL DELIVERY LLC","insp_carrier_street":"36 STONE AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02889-8624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:29.000000Z","updated_at":"2025-03-17T19:05:29.000000Z","inspection_violations":[{"id":3254028,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","insp_violation_id":"250472299","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"192776737","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:24.000000Z","updated_at":"2025-03-17T21:22:24.000000Z","normalized_code":"39617C"},{"id":3254029,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","insp_violation_id":"250472300","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192776736","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:24.000000Z","updated_at":"2025-03-17T21:22:24.000000Z","normalized_code":"39617C"},{"id":3254030,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","insp_violation_id":"250472301","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192776736","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:24.000000Z","updated_at":"2025-03-17T21:22:24.000000Z","normalized_code":"39395F"},{"id":3254031,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","insp_violation_id":"250472302","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192776737","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:24.000000Z","updated_at":"2025-03-17T21:22:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3381647,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","insp_unit_id":"192776736","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1HF817","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"2GC4YNEY2N1232052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:14.000000Z","updated_at":"2025-03-17T22:30:14.000000Z"},{"id":3381648,"change_date":"2023-01-10 21:40:00","inspection_id":"77547917","insp_unit_id":"192776737","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"KAMP","insp_unit_company":null,"insp_unit_license":"3N987","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5VGFL3522DL002495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:14.000000Z","updated_at":"2025-03-17T22:30:14.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/3935126\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/3935126\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/3935126\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/3935126\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}