{"current_page":1,"data":[{"id":8481558,"change_date":"2025-04-29 21:47:00","inspection_id":"84510621","dot_number":"3457041","report_state":"IN","report_number":"6665006528","insp_date":"2025-04-24 00:00:00","insp_start_time":"1240","insp_end_time":"1303","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WEST HARRISON IN","county_code_state":"IN","county_code":"029","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-29 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1640675","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-29 21:47:00","snet_input_date":"2025-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-29 21:47:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:25:44.000000Z","updated_at":"2025-05-02T13:46:43.000000Z","inspection_violations":[{"id":13413212,"change_date":"2025-04-29 21:47:00","inspection_id":"84510621","insp_violation_id":"265858321","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T10:45:54.000000Z","updated_at":"2025-05-02T10:57:42.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":13783123,"change_date":"2025-04-29 21:47:00","inspection_id":"84510621","insp_unit_id":"206515608","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5760","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH6KN195760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:01:53.000000Z","updated_at":"2025-05-03T09:52:16.000000Z"}]},{"id":8435262,"change_date":"2025-04-22 21:40:00","inspection_id":"84462042","dot_number":"3457041","report_state":"OH","report_number":"3259000119","insp_date":"2025-04-20 00:00:00","insp_start_time":"1100","insp_end_time":"1129","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FINDLAY OH","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1626068","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-22 21:40:00","snet_input_date":"2025-04-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:26:24.000000Z","updated_at":"2025-04-26T10:26:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13697932,"change_date":"2025-04-22 21:40:00","inspection_id":"84462042","insp_unit_id":"206425429","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"2039","insp_unit_license":"RC46872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH0KN195723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:04:58.000000Z","updated_at":"2025-04-26T09:51:04.000000Z"},{"id":13697933,"change_date":"2025-04-22 21:40:00","inspection_id":"84462042","insp_unit_id":"206425430","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"V510013","insp_unit_license":"HV14714","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1DW1A532XHB754013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:04:58.000000Z","updated_at":"2025-04-26T09:51:04.000000Z"}]},{"id":8430554,"change_date":"2025-04-21 21:40:00","inspection_id":"84457133","dot_number":"3457041","report_state":"MI","report_number":"DEJOS01537","insp_date":"2025-04-18 00:00:00","insp_start_time":"1425","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ CONCORD RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218322","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:03:08.000000Z","updated_at":"2025-04-26T10:24:48.000000Z","inspection_violations":[{"id":13308981,"change_date":"2025-04-21 21:40:00","inspection_id":"84457133","insp_violation_id":"265741709","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-04-24T10:27:07.000000Z","updated_at":"2025-04-25T10:42:19.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":13690110,"change_date":"2025-04-21 21:40:00","inspection_id":"84457133","insp_unit_id":"206416618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2059","insp_unit_license":"RC46446","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4WC9EH5NN601228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:56:49.000000Z","updated_at":"2025-04-25T10:00:37.000000Z"},{"id":13690111,"change_date":"2025-04-21 21:40:00","inspection_id":"84457133","insp_unit_id":"206416619","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"GV2201641","insp_unit_license":"PA87416","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0629NK332529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:56:49.000000Z","updated_at":"2025-04-25T10:00:37.000000Z"}]},{"id":8370598,"change_date":"2025-04-14 21:41:00","inspection_id":"84393936","dot_number":"3457041","report_state":"MI","report_number":"HERLK02397","insp_date":"2025-04-13 00:00:00","insp_start_time":"0835","insp_end_time":"0904","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"E\/B I-94 @ SOUTH 127","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KC GLOBAL SALES","shipping_paper_number":"548374576","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1217367","transaction_code":"A","transaction_date":"2025-04-13 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-14 21:41:00","snet_input_date":"2025-04-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-17T10:05:36.000000Z","updated_at":"2025-04-18T10:23:22.000000Z","inspection_violations":[{"id":13191240,"change_date":"2025-04-14 21:41:00","inspection_id":"84393936","insp_violation_id":"265608413","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4516085","created_at":"2025-04-17T10:27:08.000000Z","updated_at":"2025-04-18T10:44:44.000000Z","normalized_code":"39282DUMT"},{"id":13191241,"change_date":"2025-04-14 21:41:00","inspection_id":"84393936","insp_violation_id":"265608414","seq_no":"2","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4516085","created_at":"2025-04-17T10:27:08.000000Z","updated_at":"2025-04-18T10:44:44.000000Z","normalized_code":"39524DELDPT"},{"id":13191242,"change_date":"2025-04-14 21:41:00","inspection_id":"84393936","insp_violation_id":"265608415","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:27:08.000000Z","updated_at":"2025-04-18T10:44:44.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":13584722,"change_date":"2025-04-14 21:41:00","inspection_id":"84393936","insp_unit_id":"206302409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC38226","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJHPDV3KLKP3939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:56:45.000000Z","updated_at":"2025-04-18T10:01:52.000000Z"},{"id":13584723,"change_date":"2025-04-14 21:41:00","inspection_id":"84393936","insp_unit_id":"206302410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"367559Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAP062XDD449246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:56:45.000000Z","updated_at":"2025-04-18T10:01:52.000000Z"}]},{"id":8367378,"change_date":"2025-04-14 21:40:00","inspection_id":"84390560","dot_number":"3457041","report_state":"IN","report_number":"9667000483","insp_date":"2025-04-11 00:00:00","insp_start_time":"0859","insp_end_time":"0921","registration_date":null,"region":"ED","ci_status_code":"C","location":"1394W","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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-04-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"1593480","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-14 21:40:00","snet_input_date":"2025-04-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-14 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-17T10:05:09.000000Z","updated_at":"2025-04-18T10:21:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13578159,"change_date":"2025-04-14 21:40:00","inspection_id":"84390560","insp_unit_id":"206295979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"2055","insp_unit_license":"RC49228","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH7KN195766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:53:06.000000Z","updated_at":"2025-04-18T09:55:32.000000Z"},{"id":13578160,"change_date":"2025-04-14 21:40:00","inspection_id":"84390560","insp_unit_id":"206295980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"2302387","insp_unit_license":"PE85961","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K5PS062345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:53:06.000000Z","updated_at":"2025-04-18T09:55:32.000000Z"}]},{"id":8277326,"change_date":"2025-04-02 21:41:00","inspection_id":"84295760","dot_number":"3457041","report_state":"MI","report_number":"DPDCB00374","insp_date":"2025-04-01 00:00:00","insp_start_time":"1401","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"2","location_desc":"MICHIGAN\/GREENFIELD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50500","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":"1215847","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398658,"change_date":"2025-04-02 21:41:00","inspection_id":"84295760","insp_unit_id":"206122337","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2043","insp_unit_license":"RC48896","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH2KN195769","insp_unit_decal":"Y","insp_unit_decal_number":"35169179","created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:59.000000Z"}]},{"id":8277327,"change_date":"2025-04-02 21:41:00","inspection_id":"84295761","dot_number":"3457041","report_state":"MI","report_number":"DPDCB00375","insp_date":"2025-04-01 00:00:00","insp_start_time":"1441","insp_end_time":"1548","registration_date":null,"region":"ET","ci_status_code":"C","location":"2","location_desc":"MICHIGAN\/GREENFIELD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50500","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":"1215849","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398659,"change_date":"2025-04-02 21:41:00","inspection_id":"84295761","insp_unit_id":"206122338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1019","insp_unit_license":"RC48545","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH5KN195779","insp_unit_decal":"Y","insp_unit_decal_number":"35169180","created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:59.000000Z"}]},{"id":8277346,"change_date":"2025-04-02 21:41:00","inspection_id":"84295781","dot_number":"3457041","report_state":"MI","report_number":"WONTD01618","insp_date":"2025-04-01 00:00:00","insp_start_time":"2215","insp_end_time":"2245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ MM 15","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1215830","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[{"id":13008887,"change_date":"2025-04-02 21:41:00","inspection_id":"84295781","insp_violation_id":"265402643","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:08:37.000000Z","updated_at":"2025-04-05T10:43:16.000000Z","normalized_code":"3922SLLLR"},{"id":13008888,"change_date":"2025-04-02 21:41:00","inspection_id":"84295781","insp_violation_id":"265402644","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"206122371","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:08:37.000000Z","updated_at":"2025-04-05T10:43:16.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":13398686,"change_date":"2025-04-02 21:41:00","inspection_id":"84295781","insp_unit_id":"206122371","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2049","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH6KN195760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:01:00.000000Z"},{"id":13398687,"change_date":"2025-04-02 21:41:00","inspection_id":"84295781","insp_unit_id":"206122372","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"V506481","insp_unit_license":"HV43237","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532CXKR954437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:01:00.000000Z"}]},{"id":8203406,"change_date":"2025-03-25 21:36:00","inspection_id":"84217897","dot_number":"3457041","report_state":"KY","report_number":"CV41295235","insp_date":"2025-03-25 00:00:00","insp_start_time":"1206","insp_end_time":"1237","registration_date":null,"region":"ET","ci_status_code":"C","location":"9808","location_desc":"VERONA","county_code_state":"KY","county_code":"015","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"111N8XRTL","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":null,"final_status_date":"2025-03-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2275356","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":"M","census_search_date":"2025-03-25 21:36:00","snet_input_date":"2025-03-25 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-03-25 21:36:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:15:09.000000Z","updated_at":"2025-03-29T10:20:19.000000Z","inspection_violations":[{"id":12865338,"change_date":"2025-03-25 21:36:00","inspection_id":"84217897","insp_violation_id":"265239147","seq_no":"1","part_no":"392","part_no_section":"2UCR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:35:28.000000Z","updated_at":"2025-03-28T10:51:42.000000Z","normalized_code":"3922UCR"},{"id":12865339,"change_date":"2025-03-25 21:36:00","inspection_id":"84217897","insp_violation_id":"265239148","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"205975805","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:35:28.000000Z","updated_at":"2025-03-28T10:51:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":13263495,"change_date":"2025-03-25 21:36:00","inspection_id":"84217897","insp_unit_id":"205975805","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1021","insp_unit_license":"RC42496","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH6KN195712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:07:49.000000Z","updated_at":"2025-03-29T10:01:50.000000Z"},{"id":13263496,"change_date":"2025-03-25 21:36:00","inspection_id":"84217897","insp_unit_id":"205975806","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P972597","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0621NB332105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:07:49.000000Z","updated_at":"2025-03-29T10:01:50.000000Z"}]},{"id":8084411,"change_date":"2025-03-11 21:41:00","inspection_id":"84092596","dot_number":"3457041","report_state":"MI","report_number":"WALKB03373","insp_date":"2025-03-10 00:00:00","insp_start_time":"1923","insp_end_time":"1943","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I 94 @ CONCORD RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":"N","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-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1212663","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[{"id":12634161,"change_date":"2025-03-11 21:41:00","inspection_id":"84092596","insp_violation_id":"264949490","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4498900","created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":13052592,"change_date":"2025-03-11 21:41:00","inspection_id":"84092596","insp_unit_id":"205736940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"RC43929","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH7KN197954","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13052593,"change_date":"2025-03-11 21:41:00","inspection_id":"84092596","insp_unit_id":"205736941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PB59486","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K3PS063381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":8034957,"change_date":"2025-03-05 21:40:00","inspection_id":"84040557","dot_number":"3457041","report_state":"MI","report_number":"WORDN05413","insp_date":"2025-02-28 00:00:00","insp_start_time":"1953","insp_end_time":"2050","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"1136DTM5V","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":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211991","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-02-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:58.000000Z","updated_at":"2025-03-17T21:04:58.000000Z","inspection_violations":[{"id":12556495,"change_date":"2025-03-05 21:40:00","inspection_id":"84040557","insp_violation_id":"264849580","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4497805","created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3922SLLEWA1"},{"id":12556496,"change_date":"2025-03-05 21:40:00","inspection_id":"84040557","insp_violation_id":"264849581","seq_no":"2","part_no":"391","part_no_section":"41B10-MC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4497805","created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39141B10MC"},{"id":12556497,"change_date":"2025-03-05 21:40:00","inspection_id":"84040557","insp_violation_id":"264849582","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"205642202","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":12971894,"change_date":"2025-03-05 21:40:00","inspection_id":"84040557","insp_unit_id":"205642201","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2031","insp_unit_license":"RC40745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9TH0CN560468","insp_unit_decal":"Y","insp_unit_decal_number":"34933473","created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"},{"id":12971895,"change_date":"2025-03-05 21:40:00","inspection_id":"84040557","insp_unit_id":"205642202","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"HV2301147","insp_unit_license":"PB43934","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K8PS027329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"}]},{"id":7999631,"change_date":"2025-03-01 21:34:00","inspection_id":"84003299","dot_number":"3457041","report_state":"OH","report_number":"3294000368","insp_date":"2025-02-27 00:00:00","insp_start_time":"0806","insp_end_time":"0828","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SUNBURY OH","county_code_state":"OH","county_code":"041","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1133KB2HQ","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-03-01 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1416190","transaction_code":"A","transaction_date":"2025-03-01 00:00:00","upload_date":"2025-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-03-01 21:34:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-01 21:34:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:08.000000Z","updated_at":"2025-03-17T21:04:08.000000Z","inspection_violations":[{"id":12498703,"change_date":"2025-03-01 21:34:00","inspection_id":"84003299","insp_violation_id":"264776759","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:03.000000Z","updated_at":"2025-03-17T22:07:03.000000Z","normalized_code":"3958EHOSPD"},{"id":12498704,"change_date":"2025-03-01 21:34:00","inspection_id":"84003299","insp_violation_id":"264776760","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:03.000000Z","updated_at":"2025-03-17T22:07:03.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":12914534,"change_date":"2025-03-01 21:34:00","inspection_id":"84003299","insp_unit_id":"205575264","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1024","insp_unit_license":"RC42082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH6JN999619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"},{"id":12914535,"change_date":"2025-03-01 21:34:00","inspection_id":"84003299","insp_unit_id":"205575265","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGHV2203152","insp_unit_license":"PA96025","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K3NS887152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":7931311,"change_date":"2025-02-21 21:40:00","inspection_id":"83931704","dot_number":"3457041","report_state":"MI","report_number":"DAWDD03868","insp_date":"2025-02-20 00:00:00","insp_start_time":"1447","insp_end_time":"1511","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","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-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1210637","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-02-21 21:40:00","snet_input_date":"2025-02-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-21 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:51.000000Z","updated_at":"2025-03-17T21:02:51.000000Z","inspection_violations":[{"id":12390627,"change_date":"2025-02-21 21:40:00","inspection_id":"83931704","insp_violation_id":"264636386","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:31.000000Z","updated_at":"2025-03-17T22:06:31.000000Z","normalized_code":"3922SLLLR"},{"id":12390628,"change_date":"2025-02-21 21:40:00","inspection_id":"83931704","insp_violation_id":"264636387","seq_no":"2","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:31.000000Z","updated_at":"2025-03-17T22:06:31.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":12803121,"change_date":"2025-02-21 21:40:00","inspection_id":"83931704","insp_unit_id":"205442968","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1027","insp_unit_license":"RC42847","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH0KN195768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:26.000000Z","updated_at":"2025-03-17T23:56:26.000000Z"}]},{"id":7869830,"change_date":"2025-02-14 21:39:00","inspection_id":"83867202","dot_number":"3457041","report_state":"OH","report_number":"3234000269","insp_date":"2025-02-11 00:00:00","insp_start_time":"0907","insp_end_time":"0956","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"VANDALIA OH","county_code_state":"OH","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"1149JGQV2","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-02-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1360879","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-02-14 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-14 21:39:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:33.000000Z","updated_at":"2025-03-17T21:01:33.000000Z","inspection_violations":[{"id":12299096,"change_date":"2025-02-14 21:39:00","inspection_id":"83867202","insp_violation_id":"264518637","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"205324225","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":12702047,"change_date":"2025-02-14 21:39:00","inspection_id":"83867202","insp_unit_id":"205324224","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1028","insp_unit_license":"RC42008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH9KN195722","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:18.000000Z","updated_at":"2025-03-17T23:55:18.000000Z"},{"id":12702048,"change_date":"2025-02-14 21:39:00","inspection_id":"83867202","insp_unit_id":"205324225","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"507125","insp_unit_license":"HV43881","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C2KR955081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:18.000000Z","updated_at":"2025-03-17T23:55:18.000000Z"}]},{"id":7794909,"change_date":"2025-02-05 21:39:00","inspection_id":"83788571","dot_number":"3457041","report_state":"MI","report_number":"HADZM04682","insp_date":"2025-02-04 00:00:00","insp_start_time":"1420","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I75 @ SIEGLER","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"111KTSFKF","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1208972","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-02-05 21:39:00","snet_input_date":"2025-02-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-05 21:39:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:57.000000Z","updated_at":"2025-03-17T20:59:57.000000Z","inspection_violations":[{"id":12181145,"change_date":"2025-02-05 21:39:00","inspection_id":"83788571","insp_violation_id":"264356262","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4465883","created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":12579640,"change_date":"2025-02-05 21:39:00","inspection_id":"83788571","insp_unit_id":"205173737","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2044","insp_unit_license":"RC47270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH5KN195782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:56.000000Z","updated_at":"2025-03-17T23:53:56.000000Z"},{"id":12579641,"change_date":"2025-02-05 21:39:00","inspection_id":"83788571","insp_unit_id":"205173738","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WV2501019","insp_unit_license":"PE26608","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D2SL555176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:56.000000Z","updated_at":"2025-03-17T23:53:56.000000Z"}]},{"id":7709509,"change_date":"2025-01-26 21:32:00","inspection_id":"83698681","dot_number":"3457041","report_state":"OH","report_number":"3238000190","insp_date":"2025-01-23 00:00:00","insp_start_time":"1252","insp_end_time":"1322","registration_date":null,"region":"ES","ci_status_code":"C","location":"03","location_desc":"FINDLAY OH","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON FULFILLMENT","shipping_paper_number":"DET3-114RYYTX5","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-01-26 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"1287198","transaction_code":"A","transaction_date":"2025-01-26 00:00:00","upload_date":"2025-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-01-26 21:32:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-26 21:32:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:18.000000Z","updated_at":"2025-03-17T20:58:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12440829,"change_date":"2025-01-26 21:32:00","inspection_id":"83698681","insp_unit_id":"205007270","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"2039","insp_unit_license":"RC46872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH0KN195723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:18.000000Z","updated_at":"2025-03-17T23:52:18.000000Z"},{"id":12440830,"change_date":"2025-01-26 21:32:00","inspection_id":"83698681","insp_unit_id":"205007271","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNG V501743","insp_unit_license":"HV20455","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532CXJR457354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:18.000000Z","updated_at":"2025-03-17T23:52:18.000000Z"}]},{"id":7584153,"change_date":"2025-01-14 21:55:00","inspection_id":"83567126","dot_number":"3457041","report_state":"MI","report_number":"WONTD01492","insp_date":"2025-01-07 00:00:00","insp_start_time":"2230","insp_end_time":"2245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ MM 10","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","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":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1206229","transaction_code":"C","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-01-09 21:40:00","snet_input_date":"2025-01-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[{"id":11855107,"change_date":"2025-01-14 21:55:00","inspection_id":"83567126","insp_violation_id":"263996616","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12237080,"change_date":"2025-01-14 21:55:00","inspection_id":"83567126","insp_unit_id":"204829311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2037","insp_unit_license":"RC43929","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH7KN197954","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:05.000000Z","updated_at":"2025-03-17T23:50:05.000000Z"}]},{"id":7693989,"change_date":"2025-01-23 21:39:00","inspection_id":"83682384","dot_number":"3457041","report_state":"IL","report_number":"0882740109","insp_date":"2025-01-06 00:00:00","insp_start_time":"1530","insp_end_time":"1553","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-294","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":null,"final_status_date":"2025-01-23 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"80000","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":"2381379","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-01-23 21:39:00","snet_input_date":"2025-01-06 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-01-23 21:39:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"112722","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:55.000000Z","updated_at":"2025-03-17T20:57:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12415404,"change_date":"2025-01-23 21:39:00","inspection_id":"83682384","insp_unit_id":"204976829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"RC22456","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EHXFN927605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:02.000000Z","updated_at":"2025-03-17T23:52:02.000000Z"}]},{"id":7589604,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","dot_number":"3457041","report_state":"IN","report_number":"9473001153","insp_date":"2025-01-05 00:00:00","insp_start_time":"0017","insp_end_time":"0106","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"INDIANAPOLIS IN","county_code_state":"IN","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"LAN2MQJ13B8FE7B","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","viol_total":"8","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":"1231419","transaction_code":"C","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:41.000000Z","updated_at":"2025-04-27T10:29:32.000000Z","inspection_violations":[{"id":13343905,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781446","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"3922SLLSWZ"},{"id":13343906,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781447","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"206449113","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"3922SLLUCR"},{"id":13343907,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781448","seq_no":"3","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000203184598","created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"39216D"},{"id":13343908,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781449","seq_no":"4","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"39530B1ELDDFR"},{"id":13343909,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781450","seq_no":"5","part_no":"395","part_no_section":"3A2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"3953A2HOSPD"},{"id":13343910,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781451","seq_no":"6","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"39530B1ELDDFR"},{"id":13343911,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781452","seq_no":"7","part_no":"395","part_no_section":"22H2-ELDNISDT","insp_viol_unit":"1","insp_unit_id":"206449113","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"39522H2ELDNISDT"},{"id":13343912,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_violation_id":"265781453","seq_no":"8","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:02:52.000000Z","updated_at":"2025-04-26T10:42:15.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":13719739,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_unit_id":"206449113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1021","insp_unit_license":"RC42496","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH6KN195712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:09:19.000000Z","updated_at":"2025-04-27T09:55:44.000000Z"},{"id":13719740,"change_date":"2025-04-23 21:41:00","inspection_id":"83572851","insp_unit_id":"206449114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGHV2300651","insp_unit_license":"PB10325","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K1PS029651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:09:19.000000Z","updated_at":"2025-04-27T09:55:44.000000Z"}]},{"id":7370422,"change_date":"2025-01-02 21:39:00","inspection_id":"83342758","dot_number":"3457041","report_state":"KY","report_number":"CV42990377","insp_date":"2024-12-07 00:00:00","insp_start_time":"0814","insp_end_time":"0900","registration_date":"2025-01-02 00:00:00","region":"CT","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"113385BRR","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":null,"final_status_date":"2024-12-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2259169","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":"M","census_search_date":"2024-12-09 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:48.000000Z","updated_at":"2025-03-17T20:49:48.000000Z","inspection_violations":[{"id":11517495,"change_date":"2025-01-02 21:39:00","inspection_id":"83342758","insp_violation_id":"263724943","seq_no":"1","part_no":"395","part_no_section":"3A2-PROPN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"3953A2PROPN"},{"id":11517496,"change_date":"2025-01-02 21:39:00","inspection_id":"83342758","insp_violation_id":"263724944","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"204622099","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":11889727,"change_date":"2025-01-02 21:39:00","inspection_id":"83342758","insp_unit_id":"204622099","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2031","insp_unit_license":"RC40745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9TH0CN560468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:16.000000Z","updated_at":"2025-03-17T23:46:16.000000Z"},{"id":11889728,"change_date":"2025-01-02 21:39:00","inspection_id":"83342758","insp_unit_id":"204622100","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"505408","insp_unit_license":"HV40264","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C0KT953364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:16.000000Z","updated_at":"2025-03-17T23:46:16.000000Z"}]},{"id":7359546,"change_date":"2024-12-07 21:33:00","inspection_id":"83331224","dot_number":"3457041","report_state":"IN","report_number":"8290000619","insp_date":"2024-12-04 00:00:00","insp_start_time":"0930","insp_end_time":"1005","registration_date":null,"region":"ES","ci_status_code":"C","location":"5570W","location_desc":"RICHMOND IN","county_code_state":"IN","county_code":"177","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"111NCZ43P","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":"2024-12-07 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1127748","transaction_code":"A","transaction_date":"2024-12-07 00:00:00","upload_date":"2024-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-12-07 21:33:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-07 21:33:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:27.000000Z","updated_at":"2025-03-17T20:49:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11871637,"change_date":"2024-12-07 21:33:00","inspection_id":"83331224","insp_unit_id":"204245948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"2020","insp_unit_license":"RC33003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH6GN940790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:06.000000Z","updated_at":"2025-03-17T23:46:06.000000Z"},{"id":11871638,"change_date":"2024-12-07 21:33:00","inspection_id":"83331224","insp_unit_id":"204245949","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V567405","insp_unit_license":"PD62955","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C0LR294474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:06.000000Z","updated_at":"2025-03-17T23:46:06.000000Z"}]},{"id":6952187,"change_date":"2024-10-14 21:37:00","inspection_id":"82900060","dot_number":"3457041","report_state":"MI","report_number":"WONTD01384","insp_date":"2024-10-12 00:00:00","insp_start_time":"0015","insp_end_time":"0045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ MM 5","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"112Y4L27V","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":null,"final_status_date":"2024-10-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198075","transaction_code":"A","transaction_date":"2024-10-12 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:02.000000Z","updated_at":"2025-03-17T20:41:02.000000Z","inspection_violations":[{"id":10838787,"change_date":"2024-10-14 21:37:00","inspection_id":"82900060","insp_violation_id":"262333828","seq_no":"1","part_no":"393","part_no_section":"88","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4447133","created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39388"},{"id":10838788,"change_date":"2024-10-14 21:37:00","inspection_id":"82900060","insp_violation_id":"262333829","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11213403,"change_date":"2024-10-14 21:37:00","inspection_id":"82900060","insp_unit_id":"203396431","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2029","insp_unit_license":"RC28500","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH7JN999628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:05.000000Z","updated_at":"2025-03-17T23:39:05.000000Z"},{"id":11213404,"change_date":"2024-10-14 21:37:00","inspection_id":"82900060","insp_unit_id":"203396432","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"V522602","insp_unit_license":"TM3772","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1GR1A0625LK162070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:05.000000Z","updated_at":"2025-03-17T23:39:05.000000Z"}]},{"id":6432317,"change_date":"2024-08-09 21:38:00","inspection_id":"82346438","dot_number":"3457041","report_state":"OH","report_number":"3234014257","insp_date":"2024-08-08 00:00:00","insp_start_time":"1312","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"11375","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"113","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"115JQW4LW","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":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1746382","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"3500 WALL AVE","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48101","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10366831,"change_date":"2024-08-09 21:38:00","inspection_id":"82346438","insp_unit_id":"202320904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2025","insp_unit_license":"RC40933","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH4HN977242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"},{"id":10366832,"change_date":"2024-08-09 21:38:00","inspection_id":"82346438","insp_unit_id":"202320905","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"2303189","insp_unit_license":"PB55311","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K5PS062247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"}]},{"id":6390541,"change_date":"2024-08-05 21:42:00","inspection_id":"82301771","dot_number":"3457041","report_state":"IL","report_number":"0941670005","insp_date":"2024-08-03 00:00:00","insp_start_time":"0648","insp_end_time":"0700","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"80","county_code_state":"IL","county_code":"197","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"NA","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2344101","transaction_code":"A","transaction_date":"2024-08-03 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-08-05 21:42:00","snet_input_date":"2024-08-03 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-08-05 21:42:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"475 S SCHAEFER HWY SUITE A4","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48217","insp_colonia":null,"docket_number":"112722","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:30.000000Z","updated_at":"2025-03-17T20:29:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10298852,"change_date":"2024-08-05 21:42:00","inspection_id":"82301771","insp_unit_id":"202235286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1005","insp_unit_license":"RC30709","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EJ1GN930378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:41.000000Z","updated_at":"2025-03-17T23:29:41.000000Z"}]},{"id":6143435,"change_date":"2024-07-03 21:40:00","inspection_id":"82036915","dot_number":"3457041","report_state":"MI","report_number":"WHEES02733","insp_date":"2024-07-01 00:00:00","insp_start_time":"0845","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"115PZ76TN","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":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1184324","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"475 S SCHAEFER HWY SUITE A4","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48217","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9895791,"change_date":"2024-07-03 21:40:00","inspection_id":"82036915","insp_unit_id":"201728880","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2022","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH1HN977246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"},{"id":9895792,"change_date":"2024-07-03 21:40:00","inspection_id":"82036915","insp_unit_id":"201728881","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"PS0221060","insp_unit_license":"245292T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532K4PS021060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":6119009,"change_date":"2024-07-01 21:44:00","inspection_id":"82010583","dot_number":"3457041","report_state":"OH","report_number":"0590000866","insp_date":"2024-06-30 00:00:00","insp_start_time":"0629","insp_end_time":"0657","registration_date":null,"region":"ET","ci_status_code":"C","location":"01175","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"NONE","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":"2024-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1736982","transaction_code":"A","transaction_date":"2024-06-30 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-07-01 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"3500 WALL AVE","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48101","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:49.000000Z","updated_at":"2025-03-17T20:23:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9856099,"change_date":"2024-07-01 21:44:00","inspection_id":"82010583","insp_unit_id":"201679614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2023","insp_unit_license":"RC40550","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD5XGSGU5335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"},{"id":9856100,"change_date":"2024-07-01 21:44:00","inspection_id":"82010583","insp_unit_id":"201679615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"AZNGHV220344","insp_unit_license":"PA96325","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K1NS887442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"}]},{"id":5819892,"change_date":"2024-05-22 21:40:00","inspection_id":"81687013","dot_number":"3457041","report_state":"OH","report_number":"3262002240","insp_date":"2024-05-22 00:00:00","insp_start_time":"0616","insp_end_time":"0637","registration_date":null,"region":"ET","ci_status_code":"C","location":"101023","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"101","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","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":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1728102","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-22 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"3500 WALL AVE","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48101","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:56.000000Z","updated_at":"2025-03-17T20:17:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9373227,"change_date":"2024-05-22 21:40:00","inspection_id":"81687013","insp_unit_id":"201038391","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1008","insp_unit_license":"RC33371","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH4JN999585","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:19.000000Z","updated_at":"2025-03-17T23:20:19.000000Z"},{"id":9373228,"change_date":"2024-05-22 21:40:00","inspection_id":"81687013","insp_unit_id":"201038392","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"AZNGV567120","insp_unit_license":"TM9985","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C1LR294189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:19.000000Z","updated_at":"2025-03-17T23:20:19.000000Z"}]},{"id":5755727,"change_date":"2024-05-15 21:43:00","inspection_id":"81617329","dot_number":"3457041","report_state":"MI","report_number":"ANDER06366","insp_date":"2024-05-15 00:00:00","insp_start_time":"0110","insp_end_time":"0140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 NB 24 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","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":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1178628","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"475 S SCHAEFER HWY SUITE A4","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48217","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:43.000000Z","updated_at":"2025-03-17T20:16:43.000000Z","inspection_violations":[{"id":8908172,"change_date":"2024-05-15 21:43:00","inspection_id":"81617329","insp_violation_id":"259519195","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200906720","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3939A"},{"id":8908173,"change_date":"2024-05-15 21:43:00","inspection_id":"81617329","insp_violation_id":"259519196","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200906720","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9270573,"change_date":"2024-05-15 21:43:00","inspection_id":"81617329","insp_unit_id":"200906719","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1016","insp_unit_license":"RC37855","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH8FN916960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"},{"id":9270574,"change_date":"2024-05-15 21:43:00","inspection_id":"81617329","insp_unit_id":"200906720","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"20744","insp_unit_license":"675972","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1DW1A5328ES522599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5744734,"change_date":"2024-05-14 21:42:00","inspection_id":"81605430","dot_number":"3457041","report_state":"MI","report_number":"POWED04738","insp_date":"2024-05-13 00:00:00","insp_start_time":"1950","insp_end_time":"2010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ WAYNE RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","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-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1178258","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-05-14 21:42:00","snet_input_date":"2024-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-14 21:42:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"475 S SCHAEFER HWY SUITE A4","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48217","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:40.000000Z","updated_at":"2025-03-17T20:16:40.000000Z","inspection_violations":[{"id":8889692,"change_date":"2024-05-14 21:42:00","inspection_id":"81605430","insp_violation_id":"259493674","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9252945,"change_date":"2024-05-14 21:42:00","inspection_id":"81605430","insp_unit_id":"200884868","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1008","insp_unit_license":"RC33371","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH4JN999585","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:06.000000Z","updated_at":"2025-03-17T23:19:06.000000Z"}]},{"id":5608005,"change_date":"2024-04-26 21:39:00","inspection_id":"81456667","dot_number":"3457041","report_state":"MI","report_number":"ANDER06323","insp_date":"2024-04-25 00:00:00","insp_start_time":"2355","insp_end_time":"0025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 21 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","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":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1175481","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"475 S SCHAEFER HWY SUITE A4","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48217","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[{"id":8670346,"change_date":"2024-04-26 21:39:00","inspection_id":"81456667","insp_violation_id":"259167863","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200598872","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3939A"},{"id":8670347,"change_date":"2024-04-26 21:39:00","inspection_id":"81456667","insp_violation_id":"259167864","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200598872","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9033357,"change_date":"2024-04-26 21:39:00","inspection_id":"81456667","insp_unit_id":"200598871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1016","insp_unit_license":"RC37855","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH8FN916960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"},{"id":9033358,"change_date":"2024-04-26 21:39:00","inspection_id":"81456667","insp_unit_id":"200598872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"V240039","insp_unit_license":"PD63061","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K5RJ434873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5400003,"change_date":"2024-04-01 21:40:00","inspection_id":"81229461","dot_number":"3457041","report_state":"OH","report_number":"3283014569","insp_date":"2024-03-29 00:00:00","insp_start_time":"1114","insp_end_time":"1204","registration_date":null,"region":"ET","ci_status_code":"C","location":"041","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"041","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"E207199996D2","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":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1715531","transaction_code":"C","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"3500 WALL AVE","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48101","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8697179,"change_date":"2024-04-01 21:40:00","inspection_id":"81229461","insp_unit_id":"200183048","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1001","insp_unit_license":"RB80021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EJ4CN551109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8697180,"change_date":"2024-04-01 21:40:00","inspection_id":"81229461","insp_unit_id":"200183049","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"V508060","insp_unit_license":"HV44916","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532CXLR439116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":5144778,"change_date":"2024-02-27 21:39:00","inspection_id":"80951542","dot_number":"3457041","report_state":"MI","report_number":"MATTB05670","insp_date":"2024-02-26 00:00:00","insp_start_time":"1700","insp_end_time":"1715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ 9 MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"MULTIPLE","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":null,"final_status_date":"2024-02-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1166641","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-02-27 21:39:00","snet_input_date":"2024-02-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-27 21:39:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"475 S SCHAEFER HWY SUITE A4","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48217","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:32.000000Z","updated_at":"2025-03-17T20:04:32.000000Z","inspection_violations":[{"id":7933422,"change_date":"2024-02-27 21:39:00","inspection_id":"80951542","insp_violation_id":"258061048","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:19.000000Z","updated_at":"2025-03-17T21:44:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8283624,"change_date":"2024-02-27 21:39:00","inspection_id":"80951542","insp_unit_id":"199621081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1009","insp_unit_license":"RC33372","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH7JN999595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:03.000000Z","updated_at":"2025-03-17T23:10:03.000000Z"},{"id":8283625,"change_date":"2024-02-27 21:39:00","inspection_id":"80951542","insp_unit_id":"199621082","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"512972","insp_unit_license":"P897073","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1DW1A5322NSA59345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:03.000000Z","updated_at":"2025-03-17T23:10:03.000000Z"}]},{"id":4955211,"change_date":"2024-02-01 21:43:00","inspection_id":"80744348","dot_number":"3457041","report_state":"MI","report_number":"DEJOS00890","insp_date":"2024-01-31 00:00:00","insp_start_time":"2220","insp_end_time":"2240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ DETTMAN RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"DTW3-113WQ5FBG","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1162689","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7974773,"change_date":"2024-02-01 21:43:00","inspection_id":"80744348","insp_unit_id":"199222325","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1008","insp_unit_license":"RC33371","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH4JN999585","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"},{"id":7974774,"change_date":"2024-02-01 21:43:00","inspection_id":"80744348","insp_unit_id":"199222326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"V568179","insp_unit_license":"TN3971","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C6LR334248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4233675,"change_date":"2023-10-19 21:40:00","inspection_id":"79951649","dot_number":"3457041","report_state":"NY","report_number":"SPE0228538","insp_date":"2023-10-18 00:00:00","insp_start_time":"1028","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","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":"N","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-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2880397","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":"M","census_search_date":"2023-10-19 21:40:00","snet_input_date":"2023-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-19 21:40:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:39.000000Z","updated_at":"2025-03-17T19:46:39.000000Z","inspection_violations":[{"id":6555277,"change_date":"2023-10-19 21:40:00","inspection_id":"79951649","insp_violation_id":"255927866","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":6808681,"change_date":"2023-10-19 21:40:00","inspection_id":"79951649","insp_unit_id":"197637095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1006","insp_unit_license":"RC32363","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH7EN154610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:04.000000Z","updated_at":"2025-03-17T22:57:04.000000Z"},{"id":6808682,"change_date":"2023-10-19 21:40:00","inspection_id":"79951649","insp_unit_id":"197637096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"HV2202817","insp_unit_license":"PA89690","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:04.000000Z","updated_at":"2025-03-17T22:57:04.000000Z"}]},{"id":4045517,"change_date":"2024-02-07 21:41:00","inspection_id":"79743385","dot_number":"3457041","report_state":"MI","report_number":"DAWDD03083","insp_date":"2023-09-22 00:00:00","insp_start_time":"1352","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","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":"2023-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147247","transaction_code":"C","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2023-09-25 21:41:00","snet_input_date":"2023-09-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-25 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:47.000000Z","updated_at":"2025-03-17T19:42:47.000000Z","inspection_violations":[{"id":6262061,"change_date":"2024-02-07 21:41:00","inspection_id":"79743385","insp_violation_id":"257712327","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4282380","created_at":"2025-03-17T21:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"3922"},{"id":6262062,"change_date":"2024-02-07 21:41:00","inspection_id":"79743385","insp_violation_id":"257712328","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"3922"},{"id":6262063,"change_date":"2024-02-07 21:41:00","inspection_id":"79743385","insp_violation_id":"257712329","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6504547,"change_date":"2024-02-07 21:41:00","inspection_id":"79743385","insp_unit_id":"199312501","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1003","insp_unit_license":"RB88662","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH9DN568342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:34.000000Z","updated_at":"2025-03-17T22:54:34.000000Z"}]},{"id":3901700,"change_date":"2023-09-05 21:41:00","inspection_id":"79583636","dot_number":"3457041","report_state":"MI","report_number":"HAYND00323","insp_date":"2023-09-02 00:00:00","insp_start_time":"0800","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1144228","transaction_code":"A","transaction_date":"2023-09-02 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03457041","upload_search_indicator":null,"census_search_date":"2023-09-05 21:41:00","snet_input_date":"2023-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"WISH TRUCKING INC","insp_carrier_street":"17220 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:03.000000Z","updated_at":"2025-03-17T19:40:03.000000Z","inspection_violations":[{"id":6028533,"change_date":"2023-09-05 21:41:00","inspection_id":"79583636","insp_violation_id":"255077226","seq_no":"1","part_no":"393","part_no_section":"25(f)","insp_viol_unit":"2","insp_unit_id":"196894369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39325F"}],"inspection_per_units":[{"id":6273287,"change_date":"2023-09-05 21:41:00","inspection_id":"79583636","insp_unit_id":"196894368","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1004","insp_unit_license":"RC29000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH8FN933290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:42.000000Z","updated_at":"2025-03-17T22:52:42.000000Z"},{"id":6273288,"change_date":"2023-09-05 21:41:00","inspection_id":"79583636","insp_unit_id":"196894369","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"OV230161","insp_unit_license":"PC56359","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3PEA7532XP1000517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:42.000000Z","updated_at":"2025-03-17T22:52:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3457041\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3457041\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3457041\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3457041\/inspections","per_page":100,"prev_page_url":null,"to":36,"total":36}