{"current_page":1,"data":[{"id":12763954,"change_date":"2026-08-19 21:46:00","inspection_id":"88736014","dot_number":"1776564","report_state":"MI","report_number":"BACZM03219","insp_date":"2026-08-19 00:00:00","insp_start_time":"1128","insp_end_time":"1210","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-19 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"78350","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":"4023574","transaction_code":"A","transaction_date":"2026-08-19 00:00:00","upload_date":"2026-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-08-19 21:46:00","snet_input_date":"2026-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-19 21:46:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-22T09:39:54.000000Z","updated_at":"2026-08-22T09:39:54.000000Z","inspection_violations":[{"id":22218838,"change_date":"2026-08-19 21:46:00","inspection_id":"88736014","insp_violation_id":"276208270","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"215224067","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4741088","created_at":"2026-08-22T09:58:08.000000Z","updated_at":"2026-08-22T09:58:08.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":22154854,"change_date":"2026-08-19 21:46:00","inspection_id":"88736014","insp_unit_id":"215224067","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC53316","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXPEX4TJ169372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-22T09:16:32.000000Z","updated_at":"2026-08-22T09:16:32.000000Z"}]},{"id":12755511,"change_date":"2026-08-18 21:42:00","inspection_id":"88727584","dot_number":"1776564","report_state":"MI","report_number":"BARTT05625","insp_date":"2026-08-18 00:00:00","insp_start_time":"1429","insp_end_time":"1453","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"087","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":"2026-08-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"4013305","transaction_code":"A","transaction_date":"2026-08-18 00:00:00","upload_date":"2026-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-08-18 21:42:00","snet_input_date":"2026-08-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-18 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-22T09:39:30.000000Z","updated_at":"2026-08-22T09:39:30.000000Z","inspection_violations":[{"id":22204077,"change_date":"2026-08-18 21:42:00","inspection_id":"88727584","insp_violation_id":"276188458","seq_no":"1","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":"X4751670","created_at":"2026-08-22T09:57:16.000000Z","updated_at":"2026-08-22T09:57:16.000000Z","normalized_code":"39216D"},{"id":22204078,"change_date":"2026-08-18 21:42:00","inspection_id":"88727584","insp_violation_id":"276188459","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-22T09:57:17.000000Z","updated_at":"2026-08-22T09:57:17.000000Z","normalized_code":"3922SLL"},{"id":22204079,"change_date":"2026-08-18 21:42:00","inspection_id":"88727584","insp_violation_id":"276188460","seq_no":"3","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-22T09:57:17.000000Z","updated_at":"2026-08-22T09:57:17.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":22141688,"change_date":"2026-08-18 21:42:00","inspection_id":"88727584","insp_unit_id":"215207603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC60572","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FV6HJBB1YHB61579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-21T09:15:39.000000Z","updated_at":"2026-08-22T09:15:42.000000Z"}]},{"id":12225283,"change_date":"2026-06-18 21:42:00","inspection_id":"88183248","dot_number":"1776564","report_state":"MI","report_number":"BACZM03125","insp_date":"2026-06-18 00:00:00","insp_start_time":"1421","insp_end_time":"1445","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"46200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3574410","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:42.000000Z","updated_at":"2026-06-29T09:31:17.000000Z","inspection_violations":[{"id":21277647,"change_date":"2026-06-18 21:42:00","inspection_id":"88183248","insp_violation_id":"274998833","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"214177572","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:05:13.000000Z","updated_at":"2026-06-29T09:43:17.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":21231292,"change_date":"2026-06-18 21:42:00","inspection_id":"88183248","insp_unit_id":"214177572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD38769","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVDCXFC7NHNL1583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:34.000000Z","updated_at":"2026-06-29T09:02:23.000000Z"},{"id":21231293,"change_date":"2026-06-18 21:42:00","inspection_id":"88183248","insp_unit_id":"214177573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E179782","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9MP40255G085223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:34.000000Z","updated_at":"2026-06-29T09:02:23.000000Z"}]},{"id":12149943,"change_date":"2026-06-10 21:44:00","inspection_id":"88099025","dot_number":"1776564","report_state":"MI","report_number":"MALIK03734","insp_date":"2026-06-10 00:00:00","insp_start_time":"1043","insp_end_time":"1053","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","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":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3508704","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:31.000000Z","updated_at":"2026-06-21T09:31:23.000000Z","inspection_violations":[{"id":21146395,"change_date":"2026-06-10 21:44:00","inspection_id":"88099025","insp_violation_id":"274819351","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","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":"2026-06-13T10:02:43.000000Z","updated_at":"2026-06-21T09:45:44.000000Z","normalized_code":"3922SLLSIV"},{"id":21146394,"change_date":"2026-06-10 21:44:00","inspection_id":"88099025","insp_violation_id":"274819350","seq_no":"1","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":null,"created_at":"2026-06-13T10:02:43.000000Z","updated_at":"2026-06-21T09:45:44.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":21106503,"change_date":"2026-06-10 21:44:00","inspection_id":"88099025","insp_unit_id":"214018061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1071","insp_unit_license":"BC47258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3WRE76LF254033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:58.000000Z","updated_at":"2026-06-21T09:02:33.000000Z"}]},{"id":12100851,"change_date":"2026-06-04 21:46:00","inspection_id":"88045311","dot_number":"1776564","report_state":"MI","report_number":"BEAMW04901","insp_date":"2026-06-04 00:00:00","insp_start_time":"1505","insp_end_time":"1516","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","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":"2026-06-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"3470102","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:58.000000Z","updated_at":"2026-06-16T09:32:04.000000Z","inspection_violations":[{"id":21058516,"change_date":"2026-06-04 21:46:00","inspection_id":"88045311","insp_violation_id":"274700954","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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":"2026-06-07T10:01:08.000000Z","updated_at":"2026-06-16T09:46:57.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":21025441,"change_date":"2026-06-04 21:46:00","inspection_id":"88045311","insp_unit_id":"213918865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1088","insp_unit_license":"BC56621","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSE78LF310155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:11.000000Z","updated_at":"2026-06-16T09:04:10.000000Z"}]},{"id":12077790,"change_date":"2026-06-02 21:41:00","inspection_id":"88020367","dot_number":"1776564","report_state":"MI","report_number":"BALLB05319","insp_date":"2026-06-02 00:00:00","insp_start_time":"1200","insp_end_time":"1255","registration_date":null,"region":"ES","ci_status_code":"C","location":"ROAD","location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ROSEVILLE CRUSHED","shipping_paper_number":"13771","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":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80600","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":"3450874","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:28.000000Z","updated_at":"2026-06-13T09:31:30.000000Z","inspection_violations":[{"id":21015835,"change_date":"2026-06-02 21:41:00","inspection_id":"88020367","insp_violation_id":"274645631","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4683544","created_at":"2026-06-06T10:00:19.000000Z","updated_at":"2026-06-13T09:43:43.000000Z","normalized_code":"3922SLLEWA3"},{"id":21015836,"change_date":"2026-06-02 21:41:00","inspection_id":"88020367","insp_violation_id":"274645632","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"213872771","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-06T10:00:19.000000Z","updated_at":"2026-06-13T09:43:43.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":20988303,"change_date":"2026-06-02 21:41:00","inspection_id":"88020367","insp_unit_id":"213872771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"483","insp_unit_license":"BA98449","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTXRAPT5BJ266981","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:23.000000Z","updated_at":"2026-06-13T09:02:36.000000Z"}]},{"id":12036990,"change_date":"2026-05-28 21:41:00","inspection_id":"87977358","dot_number":"1776564","report_state":"MI","report_number":"LYDEC04720","insp_date":"2026-05-28 00:00:00","insp_start_time":"0714","insp_end_time":"0734","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","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":"3416550","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:52.000000Z","updated_at":"2026-06-08T09:30:49.000000Z","inspection_violations":[{"id":20946280,"change_date":"2026-05-28 21:41:00","inspection_id":"87977358","insp_violation_id":"274549400","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:06.000000Z","updated_at":"2026-06-08T09:42:30.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":20921720,"change_date":"2026-05-28 21:41:00","inspection_id":"87977358","insp_unit_id":"213790913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4040","insp_unit_license":"BD78504","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXBS0CHBM7175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:03.000000Z","updated_at":"2026-06-08T09:02:37.000000Z"},{"id":20921721,"change_date":"2026-05-28 21:41:00","inspection_id":"87977358","insp_unit_id":"213790914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"2110","insp_unit_license":"E768338","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI2235A170R111522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:03.000000Z","updated_at":"2026-06-08T09:02:37.000000Z"}]},{"id":12027309,"change_date":"2026-05-27 21:40:00","inspection_id":"87967245","dot_number":"1776564","report_state":"MI","report_number":"LYDEC04717","insp_date":"2026-05-27 00:00:00","insp_start_time":"1500","insp_end_time":"1515","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"093","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":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"3411757","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:31.000000Z","updated_at":"2026-06-07T09:30:53.000000Z","inspection_violations":[{"id":20929264,"change_date":"2026-05-27 21:40:00","inspection_id":"87967245","insp_violation_id":"274527080","seq_no":"1","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":"2026-05-30T09:57:45.000000Z","updated_at":"2026-06-07T09:42:34.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":20905854,"change_date":"2026-05-27 21:40:00","inspection_id":"87967245","insp_unit_id":"213772196","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1103","insp_unit_license":"BC74223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3YSEY0MF228071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:34.000000Z","updated_at":"2026-06-07T09:02:16.000000Z"}]},{"id":11848765,"change_date":"2026-05-07 21:40:00","inspection_id":"87784734","dot_number":"1776564","report_state":"MI","report_number":"JURKV03382","insp_date":"2026-05-07 00:00:00","insp_start_time":"1025","insp_end_time":"1053","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"226151800402","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"3278843","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:33.000000Z","updated_at":"2026-05-18T09:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20605297,"change_date":"2026-05-07 21:40:00","inspection_id":"87784734","insp_unit_id":"213430778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD82513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZP4TXXSJ126600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:49.000000Z","updated_at":"2026-05-18T09:03:19.000000Z"},{"id":20605298,"change_date":"2026-05-07 21:40:00","inspection_id":"87784734","insp_unit_id":"213430779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"F208608","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FS06144S1044090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:49.000000Z","updated_at":"2026-05-18T09:03:19.000000Z"}]},{"id":11586909,"change_date":"2026-04-07 21:39:00","inspection_id":"87512661","dot_number":"1776564","report_state":"MI","report_number":"RAMSB02384","insp_date":"2026-04-07 00:00:00","insp_start_time":"0635","insp_end_time":"0702","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 WB AT KENSINGTON RD","county_code_state":"MI","county_code":"093","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":"2026-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1265260","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-04-07 21:39:00","snet_input_date":"2026-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-07 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-10T09:43:21.000000Z","updated_at":"2026-04-17T09:55:19.000000Z","inspection_violations":[{"id":19594015,"change_date":"2026-04-07 21:39:00","inspection_id":"87512661","insp_violation_id":"272918165","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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":"2026-04-09T10:16:53.000000Z","updated_at":"2026-04-18T10:44:26.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":19860498,"change_date":"2026-04-07 21:39:00","inspection_id":"87512661","insp_unit_id":"212587527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1202","insp_unit_license":"BE35940","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KSE71SF303886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:29.000000Z","updated_at":"2026-04-18T09:31:12.000000Z"}]},{"id":11454832,"change_date":"2026-03-23 21:51:00","inspection_id":"87372550","dot_number":"1776564","report_state":"MI","report_number":"GENTC03272","insp_date":"2026-03-21 00:00:00","insp_start_time":"1158","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HUBBARD LAKE RD @ WINTERS RD","county_code_state":"MI","county_code":"007","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1263670","transaction_code":"A","transaction_date":"2026-03-21 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-03-23 21:51:00","snet_input_date":"2026-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[{"id":19328397,"change_date":"2026-03-23 21:51:00","inspection_id":"87372550","insp_violation_id":"272583733","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","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":"2026-03-26T10:02:15.000000Z","updated_at":"2026-04-03T09:51:35.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":19618695,"change_date":"2026-03-23 21:51:00","inspection_id":"87372550","insp_unit_id":"212288797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3014","insp_unit_license":"3927561","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACXFC2THWR8496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:50.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11130069,"change_date":"2026-03-06 21:42:00","inspection_id":"87043495","dot_number":"1776564","report_state":"MI","report_number":"BACZM02984","insp_date":"2026-02-12 00:00:00","insp_start_time":"1458","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ CURTIS RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259130","transaction_code":"C","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2026-02-13 21:39:00","snet_input_date":"2026-02-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-16T10:38:47.000000Z","updated_at":"2026-03-17T09:30:30.000000Z","inspection_violations":[{"id":19034973,"change_date":"2026-03-06 21:42:00","inspection_id":"87043495","insp_violation_id":"272249439","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"212012389","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-09T10:08:54.000000Z","updated_at":"2026-03-17T09:40:56.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":19342234,"change_date":"2026-03-06 21:42:00","inspection_id":"87043495","insp_unit_id":"212012389","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC31944","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMMN9LH623360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:20.000000Z","updated_at":"2026-03-17T09:02:37.000000Z"}]},{"id":10351600,"change_date":"2025-12-04 21:38:00","inspection_id":"86479540","dot_number":"1776564","report_state":"MI","report_number":"BACZM02923","insp_date":"2025-12-02 00:00:00","insp_start_time":"1535","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2025-12-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1252797","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-12-04 21:38:00","snet_input_date":"2025-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-04 21:38:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-07T10:31:44.000000Z","updated_at":"2025-12-08T10:31:09.000000Z","inspection_violations":[{"id":17327946,"change_date":"2025-12-04 21:38:00","inspection_id":"86479540","insp_violation_id":"270461040","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"210413576","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-07T10:32:18.000000Z","updated_at":"2025-12-08T10:31:47.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":17299107,"change_date":"2025-12-04 21:38:00","inspection_id":"86479540","insp_unit_id":"210413576","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD08938","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAN28H655251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:32.000000Z","updated_at":"2025-12-08T10:01:22.000000Z"}]},{"id":9511876,"change_date":"2025-08-26 21:40:00","inspection_id":"85597164","dot_number":"1776564","report_state":"MI","report_number":"POWED05400","insp_date":"2025-08-26 00:00:00","insp_start_time":"1153","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BELLEVILLE RD @ I-94 SVC DR","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"1238077","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-08-26 21:40:00","snet_input_date":"2025-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-29T10:43:07.000000Z","updated_at":"2025-09-05T10:46:46.000000Z","inspection_violations":[{"id":15516287,"change_date":"2025-08-26 21:40:00","inspection_id":"85597164","insp_violation_id":"268261442","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208593626","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4580612","created_at":"2025-09-05T10:49:52.000000Z","updated_at":"2025-09-05T10:49:52.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15696043,"change_date":"2025-08-26 21:40:00","inspection_id":"85597164","insp_unit_id":"208593626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1126","insp_unit_license":"BC93499","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSEY9NF165462","insp_unit_decal":"Y","insp_unit_decal_number":"35455142","created_at":"2025-08-29T09:46:42.000000Z","updated_at":"2025-09-05T09:46:09.000000Z"},{"id":15696044,"change_date":"2025-08-26 21:40:00","inspection_id":"85597164","insp_unit_id":"208593627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":"6100","insp_unit_license":"F174339","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"7NWH19A68SK051111","insp_unit_decal":"Y","insp_unit_decal_number":"35455143","created_at":"2025-08-29T09:46:42.000000Z","updated_at":"2025-09-05T09:46:09.000000Z"}]},{"id":9499782,"change_date":"2025-08-25 21:40:00","inspection_id":"85584519","dot_number":"1776564","report_state":"MI","report_number":"POWEL04006","insp_date":"2025-08-22 00:00:00","insp_start_time":"0730","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","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-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"41000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1237933","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:44.000000Z","updated_at":"2025-08-29T10:42:44.000000Z","inspection_violations":[{"id":15491783,"change_date":"2025-08-25 21:40:00","inspection_id":"85584519","insp_violation_id":"268233768","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"208569823","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:52.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":15673873,"change_date":"2025-08-25 21:40:00","inspection_id":"85584519","insp_unit_id":"208569822","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4040","insp_unit_license":"BD78504","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXBS0CHBM7175","insp_unit_decal":"Y","insp_unit_decal_number":"35457131","created_at":"2025-08-28T09:45:36.000000Z","updated_at":"2025-08-29T09:46:03.000000Z"},{"id":15673874,"change_date":"2025-08-25 21:40:00","inspection_id":"85584519","insp_unit_id":"208569823","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E588545","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCE2626N1007741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:36.000000Z","updated_at":"2025-08-29T09:46:03.000000Z"}]},{"id":9392309,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","dot_number":"1776564","report_state":"MI","report_number":"MCGEJ03660","insp_date":"2025-08-12 00:00:00","insp_start_time":"1055","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M65NB @ TURNER RD","county_code_state":"MI","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116900","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1235837","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-08-12 21:40:00","snet_input_date":"2025-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-12 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:51.000000Z","updated_at":"2025-08-16T10:00:54.000000Z","inspection_violations":[{"id":15269252,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_violation_id":"267981381","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X477198","created_at":"2025-08-15T10:45:53.000000Z","updated_at":"2025-08-16T10:44:09.000000Z","normalized_code":"3922SLLCP"},{"id":15269253,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_violation_id":"267981382","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208358751","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:53.000000Z","updated_at":"2025-08-16T10:44:09.000000Z","normalized_code":"39617CPI"},{"id":15269254,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_violation_id":"267981383","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208358751","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:53.000000Z","updated_at":"2025-08-16T10:44:09.000000Z","normalized_code":"39395A1"},{"id":15269255,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_violation_id":"267981384","seq_no":"4","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"208358751","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:53.000000Z","updated_at":"2025-08-16T10:44:09.000000Z","normalized_code":"39381H"},{"id":15269256,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_violation_id":"267981385","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208358752","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:53.000000Z","updated_at":"2025-08-16T10:44:09.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15478283,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_unit_id":"208358751","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"481","insp_unit_license":"BE01462","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDT8C4C87F408955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:24.000000Z","updated_at":"2025-08-16T09:46:09.000000Z"},{"id":15478284,"change_date":"2025-08-12 21:40:00","inspection_id":"85471356","insp_unit_id":"208358752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"2038","insp_unit_license":"D268217","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA4139G1000841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:24.000000Z","updated_at":"2025-08-16T09:46:09.000000Z"}]},{"id":9364490,"change_date":"2025-08-08 21:39:00","inspection_id":"85442219","dot_number":"1776564","report_state":"MI","report_number":"FROSR00897","insp_date":"2025-08-06 00:00:00","insp_start_time":"1240","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ MT MORRIS","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1234721","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[{"id":15212036,"change_date":"2025-08-08 21:39:00","inspection_id":"85442219","insp_violation_id":"267918538","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":null,"created_at":"2025-08-11T10:45:29.000000Z","updated_at":"2025-08-12T10:45:28.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":15428387,"change_date":"2025-08-08 21:39:00","inspection_id":"85442219","insp_unit_id":"208305860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BC69364","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCX4EXXLD673700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"}]},{"id":9216905,"change_date":"2025-07-22 21:42:00","inspection_id":"85286844","dot_number":"1776564","report_state":"MI","report_number":"MANIJ01931","insp_date":"2025-07-21 00:00:00","insp_start_time":"0828","insp_end_time":"0851","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1231560","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-25T10:46:00.000000Z","updated_at":"2025-07-27T10:41:02.000000Z","inspection_violations":[{"id":14907592,"change_date":"2025-07-22 21:42:00","inspection_id":"85286844","insp_violation_id":"267573550","seq_no":"1","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-07-25T10:47:41.000000Z","updated_at":"2025-07-26T10:42:50.000000Z","normalized_code":"3922SLLS1"},{"id":14907593,"change_date":"2025-07-22 21:42:00","inspection_id":"85286844","insp_violation_id":"267573551","seq_no":"2","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":"X4550119","created_at":"2025-07-25T10:47:41.000000Z","updated_at":"2025-07-26T10:42:50.000000Z","normalized_code":"39216AD"},{"id":14907594,"change_date":"2025-07-22 21:42:00","inspection_id":"85286844","insp_violation_id":"267573552","seq_no":"3","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":"X4550119","created_at":"2025-07-25T10:47:41.000000Z","updated_at":"2025-07-26T10:42:50.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":15158062,"change_date":"2025-07-22 21:42:00","inspection_id":"85286844","insp_unit_id":"208013947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC71756","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXD29MDMS0762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:07.000000Z"}]},{"id":9051901,"change_date":"2025-07-02 21:40:00","inspection_id":"85113306","dot_number":"1776564","report_state":"MI","report_number":"BEAMW04387","insp_date":"2025-07-01 00:00:00","insp_start_time":"1430","insp_end_time":"1447","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M57 @ STUART","county_code_state":"MI","county_code":"145","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-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","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":"1228177","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:24.000000Z","updated_at":"2025-07-07T10:07:24.000000Z","inspection_violations":[{"id":14562529,"change_date":"2025-07-02 21:40:00","inspection_id":"85113306","insp_violation_id":"267176436","seq_no":"1","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":"X4542215","created_at":"2025-07-05T10:16:42.000000Z","updated_at":"2025-07-06T10:17:44.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":14850847,"change_date":"2025-07-02 21:40:00","inspection_id":"85113306","insp_unit_id":"207680198","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PBT","insp_unit_company":null,"insp_unit_license":"3772997","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1NPCX4EX9SD708239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:11.000000Z","updated_at":"2025-07-06T09:45:56.000000Z"}]},{"id":9014498,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","dot_number":"1776564","report_state":"MI","report_number":"LITTJ05491","insp_date":"2025-06-26 00:00:00","insp_start_time":"0915","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-275 N\/B @ ECORSE","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1227558","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:24.000000Z","updated_at":"2025-07-03T10:00:47.000000Z","inspection_violations":[{"id":14489472,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","insp_violation_id":"267095370","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"207609085","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:59.000000Z","normalized_code":"39343DBMA"},{"id":14489473,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","insp_violation_id":"267095371","seq_no":"2","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"2","insp_unit_id":"207609085","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:59.000000Z","normalized_code":"39311A1LTSM"},{"id":14489474,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","insp_violation_id":"267095372","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"207609085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:59.000000Z","normalized_code":"3939ALSLI"},{"id":14489475,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","insp_violation_id":"267095373","seq_no":"4","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"2","insp_unit_id":"207609085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:59.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":14784464,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","insp_unit_id":"207609084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"4017","insp_unit_license":"BC87814","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKHPVK5MH624553","insp_unit_decal":"Y","insp_unit_decal_number":"35167768","created_at":"2025-07-01T09:47:38.000000Z","updated_at":"2025-07-01T09:49:51.000000Z"},{"id":14784465,"change_date":"2025-06-27 21:39:00","inspection_id":"85073832","insp_unit_id":"207609085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"E510984","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCE2622N9007284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:38.000000Z","updated_at":"2025-07-01T09:49:51.000000Z"}]},{"id":8990614,"change_date":"2025-06-26 21:41:00","inspection_id":"85049091","dot_number":"1776564","report_state":"MI","report_number":"DAWDD04020","insp_date":"2025-06-25 00:00:00","insp_start_time":"1446","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RAUHORN ELECTRIC INC","shipping_paper_number":"06252025","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-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"1227471","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:58.000000Z","updated_at":"2025-06-30T10:00:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14745112,"change_date":"2025-06-26 21:41:00","inspection_id":"85049091","insp_unit_id":"207566970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"4005","insp_unit_license":"BC69364","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCX4EXXLD673700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:15.000000Z","updated_at":"2025-07-01T09:47:23.000000Z"}]},{"id":8982325,"change_date":"2025-06-25 21:40:00","inspection_id":"85040198","dot_number":"1776564","report_state":"MI","report_number":"GRAHA00951","insp_date":"2025-06-24 00:00:00","insp_start_time":"1515","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-94 E\/B @ MM 253","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-06-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1227287","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-06-25 21:40:00","snet_input_date":"2025-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-25 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:08.000000Z","updated_at":"2025-06-30T10:00:36.000000Z","inspection_violations":[{"id":14439117,"change_date":"2025-06-25 21:40:00","inspection_id":"85040198","insp_violation_id":"267038693","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","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-06-28T10:17:01.000000Z","updated_at":"2025-06-29T10:16:02.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":14728465,"change_date":"2025-06-25 21:40:00","inspection_id":"85040198","insp_unit_id":"207549140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3004","insp_unit_license":"3772613","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FD0X5HT3REE87388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:15.000000Z","updated_at":"2025-06-29T09:45:55.000000Z"}]},{"id":8873536,"change_date":"2025-06-11 21:42:00","inspection_id":"84924596","dot_number":"1776564","report_state":"MI","report_number":"BARTT04935","insp_date":"2025-06-09 00:00:00","insp_start_time":"1736","insp_end_time":"1752","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@MORRIS","county_code_state":"MI","county_code":"087","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":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1224959","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-14T10:01:01.000000Z","updated_at":"2025-06-15T10:00:41.000000Z","inspection_violations":[{"id":14217932,"change_date":"2025-06-11 21:42:00","inspection_id":"84924596","insp_violation_id":"266785977","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":"X4531406","created_at":"2025-06-14T10:16:36.000000Z","updated_at":"2025-06-17T10:17:45.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":14533398,"change_date":"2025-06-11 21:42:00","inspection_id":"84924596","insp_unit_id":"207334962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NONE","insp_unit_license":"BC71756","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXD29MDMS0762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:11.000000Z","updated_at":"2025-06-15T09:45:57.000000Z"}]},{"id":8702462,"change_date":"2025-05-21 21:42:00","inspection_id":"84743438","dot_number":"1776564","report_state":"MI","report_number":"DAWDD03968","insp_date":"2025-05-20 00:00:00","insp_start_time":"1505","insp_end_time":"1528","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1222333","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:24.000000Z","updated_at":"2025-05-25T10:06:35.000000Z","inspection_violations":[{"id":13870746,"change_date":"2025-05-21 21:42:00","inspection_id":"84743438","insp_violation_id":"266381638","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-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:02.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":14220971,"change_date":"2025-05-21 21:42:00","inspection_id":"84743438","insp_unit_id":"206992706","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"BE06241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMKAAN85H126307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:14.000000Z"},{"id":14220972,"change_date":"2025-05-21 21:42:00","inspection_id":"84743438","insp_unit_id":"206992707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"NONE","insp_unit_license":"F046750","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2422KL160291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:14.000000Z"}]},{"id":8146423,"change_date":"2025-03-18 21:40:00","inspection_id":"84157823","dot_number":"1776564","report_state":"MI","report_number":"MALIK02880","insp_date":"2025-03-17 00:00:00","insp_start_time":"0655","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2025-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1213603","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-21T10:34:39.000000Z","updated_at":"2025-03-22T10:36:28.000000Z","inspection_violations":[{"id":12749503,"change_date":"2025-03-18 21:40:00","inspection_id":"84157823","insp_violation_id":"265107694","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-21T10:59:33.000000Z","updated_at":"2025-03-21T11:13:32.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":13158388,"change_date":"2025-03-18 21:40:00","inspection_id":"84157823","insp_unit_id":"205861424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BD38808","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GTXNDA04596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:06:48.000000Z","updated_at":"2025-03-22T09:59:57.000000Z"}]},{"id":7774309,"change_date":"2025-02-03 21:39:00","inspection_id":"83766966","dot_number":"1776564","report_state":"MI","report_number":"GRAHA00828","insp_date":"2025-02-03 00:00:00","insp_start_time":"1108","insp_end_time":"1149","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-94 E\/B @ RATTLE RUN RD","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1208615","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[{"id":12147613,"change_date":"2025-02-03 21:39:00","inspection_id":"83766966","insp_violation_id":"264310222","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":12546777,"change_date":"2025-02-03 21:39:00","inspection_id":"83766966","insp_unit_id":"205133211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3004","insp_unit_license":"3772613","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FD0X5HT3REE87388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":7545567,"change_date":"2025-01-14 21:55:00","inspection_id":"83526537","dot_number":"1776564","report_state":"MI","report_number":"GRAHA00797","insp_date":"2025-01-02 00:00:00","insp_start_time":"1504","insp_end_time":"1526","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I69 E\/B @ MM 188","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-01-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"1205593","transaction_code":"C","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2025-01-03 21:39:00","snet_input_date":"2025-01-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:52.000000Z","updated_at":"2025-03-17T20:54:52.000000Z","inspection_violations":[{"id":11792239,"change_date":"2025-01-14 21:55:00","inspection_id":"83526537","insp_violation_id":"263995402","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":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":12174260,"change_date":"2025-01-14 21:55:00","inspection_id":"83526537","insp_unit_id":"204828294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"392","insp_unit_license":"BD38772","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT2NDA04624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:23.000000Z","updated_at":"2025-03-17T23:49:23.000000Z"}]},{"id":7472898,"change_date":"2024-12-20 21:40:00","inspection_id":"83450293","dot_number":"1776564","report_state":"MI","report_number":"KOCHJ01788","insp_date":"2024-12-19 00:00:00","insp_start_time":"1700","insp_end_time":"1715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ BEAVER RD","county_code_state":"MI","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2024-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"1205124","transaction_code":"A","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-12-20 21:40:00","snet_input_date":"2024-12-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:58.000000Z","updated_at":"2025-03-17T20:51:58.000000Z","inspection_violations":[{"id":11679568,"change_date":"2024-12-20 21:40:00","inspection_id":"83450293","insp_violation_id":"263602724","seq_no":"1","part_no":"392","part_no_section":"2-SLLILC","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:02:50.000000Z","updated_at":"2025-03-17T22:02:50.000000Z","normalized_code":"3922SLLILC"}],"inspection_per_units":[{"id":12055978,"change_date":"2024-12-20 21:40:00","inspection_id":"83450293","insp_unit_id":"204504766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"373","insp_unit_license":"BC31947","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT5KEG55561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"}]},{"id":7294323,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","dot_number":"1776564","report_state":"MI","report_number":"KIRKB04804","insp_date":"2024-11-26 00:00:00","insp_start_time":"1250","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-96 & GRAND RIVER-HOWELL","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"110600","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202706","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-11-27 21:40:00","snet_input_date":"2024-11-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-27 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:11.000000Z","updated_at":"2025-03-17T20:48:11.000000Z","inspection_violations":[{"id":11405163,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_violation_id":"263127177","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"204087153","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3965BL"},{"id":11405164,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_violation_id":"263127178","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204087153","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39347E"},{"id":11405165,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_violation_id":"263127179","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204087153","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39353B"},{"id":11405166,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_violation_id":"263127180","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204087153","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39347E"},{"id":11405167,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_violation_id":"263127181","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"204087153","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4453878","created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3963A1BOS"},{"id":11405168,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_violation_id":"263127182","seq_no":"6","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"204087154","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4453878","created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":11766070,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_unit_id":"204087153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"469","insp_unit_license":"BA25069","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZHATAK63AK34060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"},{"id":11766071,"change_date":"2024-11-27 21:40:00","inspection_id":"83262502","insp_unit_id":"204087154","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"2011","insp_unit_license":"D129567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3224F1001197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"}]},{"id":7115512,"change_date":"2024-11-04 21:40:00","inspection_id":"83073488","dot_number":"1776564","report_state":"MI","report_number":"SCSKN00227","insp_date":"2024-11-01 00:00:00","insp_start_time":"1247","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-69 NEAR WADHAMS RD","county_code_state":"MI","county_code":"147","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":"N","pen_cen_match":null,"final_status_date":"2024-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"83651","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":"1200540","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:18.000000Z","updated_at":"2025-03-17T20:44:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11476327,"change_date":"2024-11-04 21:40:00","inspection_id":"83073488","insp_unit_id":"203724427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4008","insp_unit_license":"BD17768","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHC5DV7DDFE3178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"},{"id":11476328,"change_date":"2024-11-04 21:40:00","inspection_id":"83073488","insp_unit_id":"203724428","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"2012","insp_unit_license":"D153755","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI7832A175R090622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"}]},{"id":6883299,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","dot_number":"1776564","report_state":"MI","report_number":"MANIJ01748","insp_date":"2024-10-02 00:00:00","insp_start_time":"0816","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REST AREA","county_code_state":"MI","county_code":"129","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":null,"final_status_date":"2024-10-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116900","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1196996","transaction_code":"C","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-10-03 21:42:00","snet_input_date":"2024-10-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-03 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:47.000000Z","updated_at":"2025-03-17T20:39:47.000000Z","inspection_violations":[{"id":10722553,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","insp_violation_id":"262195187","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203275693","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:57.000000Z","updated_at":"2025-03-17T21:57:57.000000Z","normalized_code":"3939A"},{"id":10722554,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","insp_violation_id":"262195188","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203275693","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:57.000000Z","updated_at":"2025-03-17T21:57:57.000000Z","normalized_code":"3922"},{"id":10722555,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","insp_violation_id":"262195189","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203275694","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:57.000000Z","updated_at":"2025-03-17T21:57:57.000000Z","normalized_code":"3939A"},{"id":10722556,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","insp_violation_id":"262195190","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203275694","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:57.000000Z","updated_at":"2025-03-17T21:57:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11101089,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","insp_unit_id":"203275693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BA50029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDT8C4C87F408955","insp_unit_decal":"Y","insp_unit_decal_number":"34636281","created_at":"2025-03-17T23:37:57.000000Z","updated_at":"2025-03-17T23:37:57.000000Z"},{"id":11101090,"change_date":"2024-10-04 21:40:00","inspection_id":"82826721","insp_unit_id":"203275694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"D268217","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA4139G1000841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:57.000000Z","updated_at":"2025-03-17T23:37:57.000000Z"}]},{"id":6658512,"change_date":"2024-09-17 21:45:00","inspection_id":"82587516","dot_number":"1776564","report_state":"MI","report_number":"MALIK02565","insp_date":"2024-09-05 00:00:00","insp_start_time":"0640","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","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":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1193756","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10361152,"change_date":"2024-09-17 21:45:00","inspection_id":"82587516","insp_violation_id":"261868491","seq_no":"1","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:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10735395,"change_date":"2024-09-17 21:45:00","inspection_id":"82587516","insp_unit_id":"202982446","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"388","insp_unit_license":"BD88725","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKHPVM5PH419613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6631759,"change_date":"2024-09-17 21:45:00","inspection_id":"82559147","dot_number":"1776564","report_state":"MI","report_number":"BOLLJ00674","insp_date":"2024-08-29 00:00:00","insp_start_time":"0915","insp_end_time":"1004","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115300","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":"1193291","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10314955,"change_date":"2024-09-17 21:45:00","inspection_id":"82559147","insp_violation_id":"261859199","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202975503","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3922"},{"id":10314956,"change_date":"2024-09-17 21:45:00","inspection_id":"82559147","insp_violation_id":"261859200","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202975504","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10691975,"change_date":"2024-09-17 21:45:00","inspection_id":"82559147","insp_unit_id":"202975503","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"492","insp_unit_license":"BD20591","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYCY4EHFT7397","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"},{"id":10691976,"change_date":"2024-09-17 21:45:00","inspection_id":"82559147","insp_unit_id":"202975504","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D588576","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3636H1002278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":6431901,"change_date":"2024-09-17 21:45:00","inspection_id":"82345981","dot_number":"1776564","report_state":"MI","report_number":"COPEK02774","insp_date":"2024-08-09 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ HAGGERTY","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"34500","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":"1189752","transaction_code":"C","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9987540,"change_date":"2024-09-17 21:45:00","inspection_id":"82345981","insp_violation_id":"261860211","seq_no":"1","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:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10366112,"change_date":"2024-09-17 21:45:00","inspection_id":"82345981","insp_unit_id":"202976360","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"4024","insp_unit_license":"BC93492","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKHPVK0LH299115","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":10366113,"change_date":"2024-09-17 21:45:00","inspection_id":"82345981","insp_unit_id":"202976361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"C161","insp_unit_license":"E588546","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCE2624N1007737","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":6431909,"change_date":"2024-09-17 21:45:00","inspection_id":"82345989","dot_number":"1776564","report_state":"MI","report_number":"KIRKB04648","insp_date":"2024-08-08 00:00:00","insp_start_time":"1705","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-96 & FOWLERVILLE","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1189845","transaction_code":"C","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","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":10366126,"change_date":"2024-09-17 21:45:00","inspection_id":"82345989","insp_unit_id":"202981187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"387","insp_unit_license":"BD88723","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT5PDA00361","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":10366127,"change_date":"2024-09-17 21:45:00","inspection_id":"82345989","insp_unit_id":"202981188","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"BLK TLR","insp_unit_license":"E966822","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4M9FB1213NJ171340","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":6357638,"change_date":"2024-09-17 21:45:00","inspection_id":"82266508","dot_number":"1776564","report_state":"MI","report_number":"MALIK02496","insp_date":"2024-07-31 00:00:00","insp_start_time":"0735","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2024-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"1188260","transaction_code":"C","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:44.000000Z","updated_at":"2025-03-17T20:28:44.000000Z","inspection_violations":[{"id":9870570,"change_date":"2024-09-17 21:45:00","inspection_id":"82266508","insp_violation_id":"261868352","seq_no":"1","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:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10245406,"change_date":"2024-09-17 21:45:00","inspection_id":"82266508","insp_unit_id":"202982312","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1077","insp_unit_license":"BC33527","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSE70LF235600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"}]},{"id":6933711,"change_date":"2024-10-10 21:42:00","inspection_id":"82880395","dot_number":"1776564","report_state":"MI","report_number":"LITTJ05172","insp_date":"2024-07-16 00:00:00","insp_start_time":"0915","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 @ M-8","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"93900","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":"1197849","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-07-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":10807738,"change_date":"2024-10-10 21:42:00","inspection_id":"82880395","insp_violation_id":"262292104","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","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:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":11182695,"change_date":"2024-10-10 21:42:00","inspection_id":"82880395","insp_unit_id":"203359414","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4008","insp_unit_license":"BC69366","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHC5DV7DDFE3178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"},{"id":11182696,"change_date":"2024-10-10 21:42:00","inspection_id":"82880395","insp_unit_id":"203359415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"2012","insp_unit_license":"D153755","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA4137F1001761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"}]},{"id":6152578,"change_date":"2024-07-05 21:36:00","inspection_id":"82046627","dot_number":"1776564","report_state":"MI","report_number":"SHEPZ04452","insp_date":"2024-07-03 00:00:00","insp_start_time":"1345","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","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":"2024-07-05 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1184905","transaction_code":"A","transaction_date":"2024-07-03 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-07-05 21:36:00","snet_input_date":"2024-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-05 21:36:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:37.000000Z","updated_at":"2025-03-17T20:24:37.000000Z","inspection_violations":[{"id":9548846,"change_date":"2024-07-05 21:36:00","inspection_id":"82046627","insp_violation_id":"260481438","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4401402","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39216A"},{"id":9548847,"change_date":"2024-07-05 21:36:00","inspection_id":"82046627","insp_violation_id":"260481439","seq_no":"2","part_no":"387","part_no_section":"301(a)","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-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"387301A"}],"inspection_per_units":[{"id":9910688,"change_date":"2024-07-05 21:36:00","inspection_id":"82046627","insp_unit_id":"201747131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"364","insp_unit_license":"BC45154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC0KDKT4823","insp_unit_decal":"Y","insp_unit_decal_number":"34300486","created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"}]},{"id":5985556,"change_date":"2024-06-13 21:42:00","inspection_id":"81866827","dot_number":"1776564","report_state":"MI","report_number":"COPEK02639","insp_date":"2024-06-07 00:00:00","insp_start_time":"1310","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1181997","transaction_code":"A","transaction_date":"2024-06-07 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9285349,"change_date":"2024-06-13 21:42:00","inspection_id":"81866827","insp_violation_id":"260071833","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:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9641117,"change_date":"2024-06-13 21:42:00","inspection_id":"81866827","insp_unit_id":"201382854","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4022","insp_unit_license":"BD02280","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCY9EDFP7654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5576204,"change_date":"2024-04-23 21:41:00","inspection_id":"81422030","dot_number":"1776564","report_state":"MI","report_number":"BALLB04626","insp_date":"2024-04-23 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"DIVISION @ JAY","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37400","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175163","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8618497,"change_date":"2024-04-23 21:41:00","inspection_id":"81422030","insp_violation_id":"259083019","seq_no":"1","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"2","insp_unit_id":"200530831","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"393100C"}],"inspection_per_units":[{"id":8982281,"change_date":"2024-04-23 21:41:00","inspection_id":"81422030","insp_unit_id":"200530831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"FT161","insp_unit_license":"E898427","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCE2628P1009817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8982282,"change_date":"2024-04-23 21:41:00","inspection_id":"81422030","insp_unit_id":"200530832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"359","insp_unit_license":"BB81293","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WRMAL3GG351798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5551499,"change_date":"2024-04-19 21:39:00","inspection_id":"81395235","dot_number":"1776564","report_state":"MI","report_number":"BACZM02257","insp_date":"2024-04-18 00:00:00","insp_start_time":"0839","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1174452","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-04-19 21:39:00","snet_input_date":"2024-04-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-19 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:46.000000Z","updated_at":"2025-03-17T20:12:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8942066,"change_date":"2024-04-19 21:39:00","inspection_id":"81395235","insp_unit_id":"200481820","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC71756","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXD29MDMS0762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:12.000000Z","updated_at":"2025-03-17T23:16:12.000000Z"}]},{"id":5268141,"change_date":"2024-03-12 21:39:00","inspection_id":"81085904","dot_number":"1776564","report_state":"MI","report_number":"MALIK02232","insp_date":"2024-03-11 00:00:00","insp_start_time":"0950","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2024-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27990","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1168645","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-03-12 21:39:00","snet_input_date":"2024-03-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-12 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:04.000000Z","updated_at":"2025-03-17T20:07:04.000000Z","inspection_violations":[{"id":8123997,"change_date":"2024-03-12 21:39:00","inspection_id":"81085904","insp_violation_id":"258339776","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":null,"created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"3922"},{"id":8123998,"change_date":"2024-03-12 21:39:00","inspection_id":"81085904","insp_violation_id":"258339777","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199873580","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"39343"},{"id":8123999,"change_date":"2024-03-12 21:39:00","inspection_id":"81085904","insp_violation_id":"258339778","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199873580","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8483401,"change_date":"2024-03-12 21:39:00","inspection_id":"81085904","insp_unit_id":"199873579","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"372","insp_unit_license":"BC56326","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT6KDA25472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"},{"id":8483402,"change_date":"2024-03-12 21:39:00","inspection_id":"81085904","insp_unit_id":"199873580","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HAUL","insp_unit_company":"2007","insp_unit_license":"D109251","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5NHUHAV28FW067846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"}]},{"id":5114517,"change_date":"2024-02-22 21:43:00","inspection_id":"80918433","dot_number":"1776564","report_state":"MI","report_number":"KAATZ00139","insp_date":"2024-02-21 00:00:00","insp_start_time":"0809","insp_end_time":"0829","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W\/B I 69 @ WASHBURN RD","county_code_state":"MI","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"135800","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":"1165980","transaction_code":"A","transaction_date":"2024-02-21 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[{"id":7886717,"change_date":"2024-02-22 21:43:00","inspection_id":"80918433","insp_violation_id":"257985576","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199554755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8234216,"change_date":"2024-02-22 21:43:00","inspection_id":"80918433","insp_unit_id":"199554755","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"425","insp_unit_license":"BC87526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X0AJ272087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"},{"id":8234217,"change_date":"2024-02-22 21:43:00","inspection_id":"80918433","insp_unit_id":"199554756","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"2034","insp_unit_license":"D255635","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M512146981115777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"}]},{"id":5052771,"change_date":"2024-02-14 21:42:00","inspection_id":"80851073","dot_number":"1776564","report_state":"MI","report_number":"BARTT04202","insp_date":"2024-02-13 00:00:00","insp_start_time":"1105","insp_end_time":"1122","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@FIVE LAKES","county_code_state":"MI","county_code":"087","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1164752","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7786538,"change_date":"2024-02-14 21:42:00","inspection_id":"80851073","insp_violation_id":"257840189","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:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8133308,"change_date":"2024-02-14 21:42:00","inspection_id":"80851073","insp_unit_id":"199425906","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"482","insp_unit_license":"BA50028","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSWXSBR25J152724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:41.000000Z","updated_at":"2025-03-17T23:08:41.000000Z"},{"id":8133309,"change_date":"2024-02-14 21:42:00","inspection_id":"80851073","insp_unit_id":"199425907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"0","insp_unit_license":"E158576","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKA048303M064247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:41.000000Z","updated_at":"2025-03-17T23:08:41.000000Z"}]},{"id":4987755,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","dot_number":"1776564","report_state":"MI","report_number":"MALIK02173","insp_date":"2024-02-05 00:00:00","insp_start_time":"0740","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B 18 1\/2 MILE RD @ M-53","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1163227","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-02-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:37.000000Z","updated_at":"2025-03-17T20:01:37.000000Z","inspection_violations":[{"id":7681746,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","insp_violation_id":"257686985","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199290047","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3939A"},{"id":7681747,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","insp_violation_id":"257686986","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199290047","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"39343"},{"id":7681748,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","insp_violation_id":"257686987","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199290047","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3939A"},{"id":7681749,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","insp_violation_id":"257686988","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199290046","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":8027547,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","insp_unit_id":"199290046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"366","insp_unit_license":"BC31949","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT7KEG55849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"},{"id":8027548,"change_date":"2024-02-06 21:42:00","inspection_id":"80779892","insp_unit_id":"199290047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAM","insp_unit_company":"2030","insp_unit_license":"D217008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JPBU2521AP024664","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"}]},{"id":4745761,"change_date":"2024-01-02 21:43:00","inspection_id":"80515235","dot_number":"1776564","report_state":"MI","report_number":"CTPRW00162","insp_date":"2023-12-28 00:00:00","insp_start_time":"1520","insp_end_time":"1533","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ SCALES","county_code_state":"MI","county_code":"099","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":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1158916","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2024-01-02 21:43:00","snet_input_date":"2023-12-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[{"id":7323983,"change_date":"2024-01-02 21:43:00","inspection_id":"80515235","insp_violation_id":"257141649","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198767998","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7634054,"change_date":"2024-01-02 21:43:00","inspection_id":"80515235","insp_unit_id":"198767998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"383","insp_unit_license":"BC69361","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACWFC5JDJL2880","insp_unit_decal":"Y","insp_unit_decal_number":"N\/A","created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4703011,"change_date":"2023-12-26 21:40:00","inspection_id":"80468825","dot_number":"1776564","report_state":"MI","report_number":"HADZM04088","insp_date":"2023-12-21 00:00:00","insp_start_time":"1515","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WAYNE @ WICK RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-12-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"1158463","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-12-26 21:40:00","snet_input_date":"2023-12-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-26 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:08.000000Z","updated_at":"2025-03-17T19:56:08.000000Z","inspection_violations":[{"id":7264185,"change_date":"2023-12-26 21:40:00","inspection_id":"80468825","insp_violation_id":"257049366","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:41:06.000000Z","updated_at":"2025-03-17T21:41:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7564727,"change_date":"2023-12-26 21:40:00","inspection_id":"80468825","insp_unit_id":"198665430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"476","insp_unit_license":"BD27396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBM7C1C36F411801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:36.000000Z","updated_at":"2025-03-17T23:03:36.000000Z"},{"id":7564728,"change_date":"2023-12-26 21:40:00","inspection_id":"80468825","insp_unit_id":"198665431","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ASSEM","insp_unit_company":"252","insp_unit_license":"E420191","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI1070A164R051204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:36.000000Z","updated_at":"2025-03-17T23:03:36.000000Z"}]},{"id":4643769,"change_date":"2023-12-15 21:38:00","inspection_id":"80403882","dot_number":"1776564","report_state":"MI","report_number":"POWED04476","insp_date":"2023-12-14 00:00:00","insp_start_time":"1700","insp_end_time":"1715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WAYNE RD @ WICK","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-12-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1157527","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-12-15 21:38:00","snet_input_date":"2023-12-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-15 21:38:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:56.000000Z","updated_at":"2025-03-17T19:54:56.000000Z","inspection_violations":[{"id":7180250,"change_date":"2023-12-15 21:38:00","inspection_id":"80403882","insp_violation_id":"256918749","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:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7468807,"change_date":"2023-12-15 21:38:00","inspection_id":"80403882","insp_unit_id":"198534690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"N\/A","insp_unit_license":"BC47257","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3WRE70LF253427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:47.000000Z","updated_at":"2025-03-17T23:02:47.000000Z"}]},{"id":4408825,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","dot_number":"1776564","report_state":"MI","report_number":"MCGEJ03037","insp_date":"2023-11-10 00:00:00","insp_start_time":"0700","insp_end_time":"0806","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @ 4 MILE RD","county_code_state":"MI","county_code":"039","insp_level_id":"1","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1153099","transaction_code":"A","transaction_date":"2023-11-10 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:17.000000Z","updated_at":"2025-03-17T19:50:17.000000Z","inspection_violations":[{"id":6821956,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_violation_id":"256353184","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3958F1"},{"id":6821957,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_violation_id":"256353185","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:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3922"},{"id":6821958,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_violation_id":"256353186","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198024618","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4291935","created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39347E"},{"id":6821959,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_violation_id":"256353187","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198024618","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39353B"},{"id":6821960,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_violation_id":"256353188","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198024618","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39347E"},{"id":6821961,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_violation_id":"256353189","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198024619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7090400,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_unit_id":"198024618","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"435","insp_unit_license":"BC87526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X0AJ27208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"},{"id":7090401,"change_date":"2023-11-13 21:42:00","inspection_id":"80145737","insp_unit_id":"198024619","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":"267","insp_unit_license":"B732719","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E92924656E111230","insp_unit_decal":"Y","insp_unit_decal_number":"33396687","created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"}]},{"id":4342280,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","dot_number":"1776564","report_state":"MI","report_number":"MALIK02050","insp_date":"2023-11-01 00:00:00","insp_start_time":"0735","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-11-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36500","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1151817","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:05.000000Z","updated_at":"2025-03-17T19:49:05.000000Z","inspection_violations":[{"id":6716695,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_violation_id":"256189262","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197880608","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6716696,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_violation_id":"256189263","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197880608","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"39378"},{"id":6716697,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_violation_id":"256189264","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197880608","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6716698,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_violation_id":"256189265","seq_no":"4","part_no":"393","part_no_section":"70(d)(8)","insp_viol_unit":"2","insp_unit_id":"197880609","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"39370D8"},{"id":6716699,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_violation_id":"256189266","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":6983623,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_unit_id":"197880608","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4028","insp_unit_license":"BD38768","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALDCXFC2NDNK5017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:37.000000Z","updated_at":"2025-03-17T22:58:37.000000Z"},{"id":6983624,"change_date":"2023-11-02 21:42:00","inspection_id":"80071895","insp_unit_id":"197880609","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ASSEM","insp_unit_company":"232","insp_unit_license":"E632345","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI0173A170R111301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:37.000000Z","updated_at":"2025-03-17T22:58:37.000000Z"}]},{"id":4227524,"change_date":"2023-10-20 21:40:00","inspection_id":"79944970","dot_number":"1776564","report_state":"MI","report_number":"HADZM03963","insp_date":"2023-10-17 00:00:00","insp_start_time":"1630","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WARREN @ LORAINE","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIR","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-10-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110600","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":"1149976","transaction_code":"C","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-10-18 21:41:00","snet_input_date":"2023-10-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-18 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:37.000000Z","updated_at":"2025-03-17T19:46:37.000000Z","inspection_violations":[{"id":6544818,"change_date":"2023-10-20 21:40:00","inspection_id":"79944970","insp_violation_id":"255963795","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6798730,"change_date":"2023-10-20 21:40:00","inspection_id":"79944970","insp_unit_id":"197668398","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"469","insp_unit_license":"BA25069","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZHATAK63AK34060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:59.000000Z","updated_at":"2025-03-17T22:56:59.000000Z"},{"id":6798731,"change_date":"2023-10-20 21:40:00","inspection_id":"79944970","insp_unit_id":"197668399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"N\/A","insp_unit_license":"D129567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3224F1001197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:59.000000Z","updated_at":"2025-03-17T22:56:59.000000Z"}]},{"id":4034140,"change_date":"2023-09-22 21:39:00","inspection_id":"79730732","dot_number":"1776564","report_state":"MI","report_number":"MALIK01984","insp_date":"2023-09-21 00:00:00","insp_start_time":"1450","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 30 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147058","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-09-22 21:39:00","snet_input_date":"2023-09-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[{"id":6244441,"change_date":"2023-09-22 21:39:00","inspection_id":"79730732","insp_violation_id":"255427281","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"197188937","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":6485923,"change_date":"2023-09-22 21:39:00","inspection_id":"79730732","insp_unit_id":"197188936","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"4026","insp_unit_license":"BC93495","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKHPVK5MH655561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:27.000000Z","updated_at":"2025-03-17T22:54:27.000000Z"},{"id":6485924,"change_date":"2023-09-22 21:39:00","inspection_id":"79730732","insp_unit_id":"197188937","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CORN","insp_unit_company":"270","insp_unit_license":"E510986","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4MJUB22214E037250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:27.000000Z","updated_at":"2025-03-17T22:54:27.000000Z"}]},{"id":3888700,"change_date":"2023-09-01 21:39:00","inspection_id":"79569108","dot_number":"1776564","report_state":"MI","report_number":"MANIJ01425","insp_date":"2023-08-31 00:00:00","insp_start_time":"1041","insp_end_time":"1219","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BRIDGE ST","county_code_state":"MI","county_code":"011","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":null,"final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43400","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143808","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-08-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[{"id":6009431,"change_date":"2023-09-01 21:39:00","inspection_id":"79569108","insp_violation_id":"255045507","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3939A"},{"id":6009432,"change_date":"2023-09-01 21:39:00","inspection_id":"79569108","insp_violation_id":"255045508","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196865304","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3922"},{"id":6009433,"change_date":"2023-09-01 21:39:00","inspection_id":"79569108","insp_violation_id":"255045509","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"196865305","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4266552","created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":6252013,"change_date":"2023-09-01 21:39:00","inspection_id":"79569108","insp_unit_id":"196865304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC31945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC6LDLB6908","insp_unit_decal":"Y","insp_unit_decal_number":"33028879","created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"},{"id":6252014,"change_date":"2023-09-01 21:39:00","inspection_id":"79569108","insp_unit_id":"196865305","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAOT","insp_unit_company":null,"insp_unit_license":"C685225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9MP40245G085259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"}]},{"id":3858893,"change_date":"2023-08-29 21:42:00","inspection_id":"79535897","dot_number":"1776564","report_state":"MI","report_number":"NESBA00795","insp_date":"2023-08-29 00:00:00","insp_start_time":"1125","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"N I-75@CROOKS RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1143412","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[{"id":5960346,"change_date":"2023-08-29 21:42:00","inspection_id":"79535897","insp_violation_id":"254954200","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:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6203936,"change_date":"2023-08-29 21:42:00","inspection_id":"79535897","insp_unit_id":"196789268","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1095","insp_unit_license":"BC70255","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSE76MF142176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3789804,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","dot_number":"1776564","report_state":"MI","report_number":"CINIM01784","insp_date":"2023-08-21 00:00:00","insp_start_time":"0955","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M 115 WB @ N RIVER RD","county_code_state":"MI","county_code":"035","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"194800","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1141283","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:41.000000Z","updated_at":"2025-03-17T19:37:41.000000Z","inspection_violations":[{"id":5844976,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","insp_violation_id":"254982909","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196812752","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"39347E"},{"id":5844977,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","insp_violation_id":"254982910","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196812752","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"39353B"},{"id":5844978,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","insp_violation_id":"254982911","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196812751","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"39311"},{"id":5844979,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","insp_violation_id":"254982912","seq_no":"4","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":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6093355,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","insp_unit_id":"196812751","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"435","insp_unit_license":"BC87526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X0AJ27208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:11.000000Z","updated_at":"2025-03-17T22:51:11.000000Z"},{"id":6093356,"change_date":"2023-08-30 21:44:00","inspection_id":"79458538","insp_unit_id":"196812752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"E322006","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1LH455WJXL1B28844","insp_unit_decal":"Y","insp_unit_decal_number":"33031834","created_at":"2025-03-17T22:51:11.000000Z","updated_at":"2025-03-17T22:51:11.000000Z"}]},{"id":3421082,"change_date":"2023-07-03 21:38:00","inspection_id":"79045378","dot_number":"1776564","report_state":"MI","report_number":"PENNJ00766","insp_date":"2023-06-30 00:00:00","insp_start_time":"1220","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-57 @ ELY HWY","county_code_state":"MI","county_code":"057","insp_level_id":"2","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":"2023-07-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1133332","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-06-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:54.000000Z","updated_at":"2025-03-17T19:30:54.000000Z","inspection_violations":[{"id":5273408,"change_date":"2023-07-03 21:38:00","inspection_id":"79045378","insp_violation_id":"253837518","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195799866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5500062,"change_date":"2023-07-03 21:38:00","inspection_id":"79045378","insp_unit_id":"195799865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB81290","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN9KH714851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:25.000000Z","updated_at":"2025-03-17T22:46:25.000000Z"},{"id":5500063,"change_date":"2023-07-03 21:38:00","inspection_id":"79045378","insp_unit_id":"195799866","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"D961863","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH1820H1117211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:25.000000Z","updated_at":"2025-03-17T22:46:25.000000Z"}]},{"id":3404622,"change_date":"2023-06-29 21:43:00","inspection_id":"79027020","dot_number":"1776564","report_state":"MI","report_number":"MANIJ01365","insp_date":"2023-06-29 00:00:00","insp_start_time":"0834","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"129","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2023-06-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1132832","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-06-29 21:43:00","snet_input_date":"2023-06-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-29 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:33.000000Z","updated_at":"2025-03-17T19:30:33.000000Z","inspection_violations":[{"id":5248398,"change_date":"2023-06-29 21:43:00","inspection_id":"79027020","insp_violation_id":"253795917","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":null,"created_at":"2025-03-17T21:31:22.000000Z","updated_at":"2025-03-17T21:31:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5473873,"change_date":"2023-06-29 21:43:00","inspection_id":"79027020","insp_unit_id":"195763127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3784644036","insp_unit_license":"3412902","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC5PDUH4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"}]},{"id":3413684,"change_date":"2023-06-30 21:40:00","inspection_id":"79037127","dot_number":"1776564","report_state":"MI","report_number":"HADZM03782","insp_date":"2023-06-29 00:00:00","insp_start_time":"1555","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ METROPILAT","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13500","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":"1133189","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:36.000000Z","updated_at":"2025-03-17T19:30:36.000000Z","inspection_violations":[{"id":5261700,"change_date":"2023-06-30 21:40:00","inspection_id":"79037127","insp_violation_id":"253817252","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:27.000000Z","updated_at":"2025-03-17T21:31:27.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5488521,"change_date":"2023-06-30 21:40:00","inspection_id":"79037127","insp_unit_id":"195782951","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1138","insp_unit_license":"BD03259","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKJPVK1MH648451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:18.000000Z","updated_at":"2025-03-17T22:46:18.000000Z"}]},{"id":3375528,"change_date":"2023-06-27 21:40:00","inspection_id":"78994126","dot_number":"1776564","report_state":"MI","report_number":"MALIK01816","insp_date":"2023-06-27 00:00:00","insp_start_time":"0650","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 22 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1132340","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:48.000000Z","updated_at":"2025-03-17T19:29:48.000000Z","inspection_violations":[{"id":5204965,"change_date":"2023-06-27 21:40:00","inspection_id":"78994126","insp_violation_id":"253724788","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5426336,"change_date":"2023-06-27 21:40:00","inspection_id":"78994126","insp_unit_id":"195697145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"383","insp_unit_license":"BC69361","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACWFC5JDJL2880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:49.000000Z","updated_at":"2025-03-17T22:45:49.000000Z"}]},{"id":3334212,"change_date":"2023-06-21 21:42:00","inspection_id":"78947868","dot_number":"1776564","report_state":"MI","report_number":"KOCHJ01185","insp_date":"2023-06-20 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-46 @ OAK RD","county_code_state":"MI","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2023-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","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":"1131358","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-06-21 21:42:00","snet_input_date":"2023-06-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-21 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:56.000000Z","updated_at":"2025-03-17T19:28:56.000000Z","inspection_violations":[{"id":5140359,"change_date":"2023-06-21 21:42:00","inspection_id":"78947868","insp_violation_id":"253622332","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":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5360477,"change_date":"2023-06-21 21:42:00","inspection_id":"78947868","insp_unit_id":"195606531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4030","insp_unit_license":"BD49513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVMG3FMXPHNW5171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":3083564,"change_date":"2023-05-18 21:43:00","inspection_id":"78664933","dot_number":"1776564","report_state":"MI","report_number":"BENNK00316","insp_date":"2023-05-17 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","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-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1126688","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[{"id":4738648,"change_date":"2023-05-18 21:43:00","inspection_id":"78664933","insp_violation_id":"252926583","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195015596","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:03.000000Z","updated_at":"2025-03-17T21:29:03.000000Z","normalized_code":"3939A"},{"id":4738649,"change_date":"2023-05-18 21:43:00","inspection_id":"78664933","insp_violation_id":"252926584","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195015596","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:03.000000Z","updated_at":"2025-03-17T21:29:03.000000Z","normalized_code":"3939A"},{"id":4738650,"change_date":"2023-05-18 21:43:00","inspection_id":"78664933","insp_violation_id":"252926585","seq_no":"3","part_no":"393","part_no_section":"106(b)","insp_viol_unit":"1","insp_unit_id":"195015596","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:03.000000Z","updated_at":"2025-03-17T21:29:03.000000Z","normalized_code":"393106B"}],"inspection_per_units":[{"id":4960068,"change_date":"2023-05-18 21:43:00","inspection_id":"78664933","insp_unit_id":"195015596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC69358","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC9LHLB6363","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"}]},{"id":3068358,"change_date":"2023-05-17 21:43:00","inspection_id":"78647780","dot_number":"1776564","report_state":"MI","report_number":"WILLD02751","insp_date":"2023-05-16 00:00:00","insp_start_time":"1440","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-14 & HAGERTY","county_code_state":"MI","county_code":"163","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"1126384","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4936063,"change_date":"2023-05-17 21:43:00","inspection_id":"78647780","insp_unit_id":"194983554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC87526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X0AJ27208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"},{"id":4936064,"change_date":"2023-05-17 21:43:00","inspection_id":"78647780","insp_unit_id":"194983555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":null,"insp_unit_license":"B732719","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E92924656E111230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"}]},{"id":3053593,"change_date":"2023-05-16 21:42:00","inspection_id":"78631262","dot_number":"1776564","report_state":"MI","report_number":"WARRJ02142","insp_date":"2023-05-15 00:00:00","insp_start_time":"1410","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":null,"final_status_date":"2023-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1126140","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-05-16 21:42:00","snet_input_date":"2023-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:24.000000Z","updated_at":"2025-03-17T19:23:24.000000Z","inspection_violations":[{"id":4692737,"change_date":"2023-05-16 21:42:00","inspection_id":"78631262","insp_violation_id":"252857842","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194952580","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3922"},{"id":4692738,"change_date":"2023-05-16 21:42:00","inspection_id":"78631262","insp_violation_id":"252857843","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194952581","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4912678,"change_date":"2023-05-16 21:42:00","inspection_id":"78631262","insp_unit_id":"194952580","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"482","insp_unit_license":"BA50028","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSWXSBR25J152724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"},{"id":4912679,"change_date":"2023-05-16 21:42:00","inspection_id":"78631262","insp_unit_id":"194952581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ENTYR","insp_unit_company":"267","insp_unit_license":"B732719","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E92924656E111230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"}]},{"id":3043531,"change_date":"2023-05-15 21:42:00","inspection_id":"78619878","dot_number":"1776564","report_state":"MI","report_number":"JURKV02188","insp_date":"2023-05-10 00:00:00","insp_start_time":"1115","insp_end_time":"1228","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125772","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:21.000000Z","updated_at":"2025-03-17T19:23:21.000000Z","inspection_violations":[{"id":4674897,"change_date":"2023-05-15 21:42:00","inspection_id":"78619878","insp_violation_id":"252828135","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194928079","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"3922"},{"id":4674898,"change_date":"2023-05-15 21:42:00","inspection_id":"78619878","insp_violation_id":"252828136","seq_no":"2","part_no":"383","part_no_section":"93(b)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"38393B3"}],"inspection_per_units":[{"id":4896175,"change_date":"2023-05-15 21:42:00","inspection_id":"78619878","insp_unit_id":"194928079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4030","insp_unit_license":"BD49513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVMG3FMXPHNW5171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:36.000000Z","updated_at":"2025-03-17T22:41:36.000000Z"}]},{"id":2316619,"change_date":"2023-02-07 21:41:00","inspection_id":"77793569","dot_number":"1776564","report_state":"MI","report_number":"ROLLJ02044","insp_date":"2023-02-07 00:00:00","insp_start_time":"0800","insp_end_time":"0818","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB M37 @ M55","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1112669","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3568229,"change_date":"2023-02-07 21:41:00","inspection_id":"77793569","insp_violation_id":"250995834","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"},{"id":3568230,"change_date":"2023-02-07 21:41:00","inspection_id":"77793569","insp_violation_id":"250995835","seq_no":"2","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":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3728634,"change_date":"2023-02-07 21:41:00","inspection_id":"77793569","insp_unit_id":"193274420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1103","insp_unit_license":"BC74223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3YSEY0MF228071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":2316679,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","dot_number":"1776564","report_state":"MI","report_number":"SCIBA02119","insp_date":"2023-02-06 00:00:00","insp_start_time":"0830","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SARANAC REST AREA","county_code_state":"MI","county_code":"067","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":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116900","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112595","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3568319,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_violation_id":"250995962","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193274543","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39378"},{"id":3568320,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_violation_id":"250995963","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193274543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39353B"},{"id":3568321,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_violation_id":"250995964","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193274543","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39347E"},{"id":3568322,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_violation_id":"250995965","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193274543","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39347E"},{"id":3568323,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_violation_id":"250995966","seq_no":"5","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193274544","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":3728735,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_unit_id":"193274543","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"481","insp_unit_license":"BA50029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDT8C4C87F408955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"},{"id":3728736,"change_date":"2023-02-07 21:41:00","inspection_id":"77793640","insp_unit_id":"193274544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FEELI","insp_unit_company":"2038","insp_unit_license":"D268217","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA4139G1000841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":1572683,"change_date":"2022-10-21 21:39:00","inspection_id":"76942481","dot_number":"1776564","report_state":"MI","report_number":"SHEPZ03393","insp_date":"2022-10-19 00:00:00","insp_start_time":"1450","insp_end_time":"1655","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115300","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":"1099256","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:36.000000Z","updated_at":"2025-03-17T18:55:36.000000Z","inspection_violations":[{"id":2472620,"change_date":"2022-10-21 21:39:00","inspection_id":"76942481","insp_violation_id":"249178580","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4137919","created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3922"},{"id":2472621,"change_date":"2022-10-21 21:39:00","inspection_id":"76942481","insp_violation_id":"249178581","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191576359","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4137919","created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2531066,"change_date":"2022-10-21 21:39:00","inspection_id":"76942481","insp_unit_id":"191576359","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"492","insp_unit_license":"BC16131","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYCY4EHFT7397","insp_unit_decal":"Y","insp_unit_decal_number":"32003869","created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"},{"id":2531067,"change_date":"2022-10-21 21:39:00","inspection_id":"76942481","insp_unit_id":"191576360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"2094","insp_unit_license":"E391135","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3637M9004844","insp_unit_decal":"Y","insp_unit_decal_number":"32003870","created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1508311,"change_date":"2022-10-13 21:40:00","inspection_id":"76868062","dot_number":"1776564","report_state":"MI","report_number":"BALLB03868","insp_date":"2022-10-12 00:00:00","insp_start_time":"1005","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"M53 N @ 25 MILE","county_code_state":"MI","county_code":"099","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":"2022-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1098343","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-10-13 21:40:00","snet_input_date":"2022-10-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-13 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:29.000000Z","updated_at":"2025-03-17T18:54:29.000000Z","inspection_violations":[{"id":2373941,"change_date":"2022-10-13 21:40:00","inspection_id":"76868062","insp_violation_id":"249010685","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4129207","created_at":"2025-03-17T21:17:53.000000Z","updated_at":"2025-03-17T21:17:53.000000Z","normalized_code":"3922"},{"id":2373942,"change_date":"2022-10-13 21:40:00","inspection_id":"76868062","insp_violation_id":"249010686","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:53.000000Z","updated_at":"2025-03-17T21:17:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2427574,"change_date":"2022-10-13 21:40:00","inspection_id":"76868062","insp_unit_id":"191426318","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"470","insp_unit_license":"BC60572","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FV6HJBB1YHB61579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:38.000000Z","updated_at":"2025-03-17T22:23:38.000000Z"}]},{"id":1508395,"change_date":"2022-10-13 21:40:00","inspection_id":"76868155","dot_number":"1776564","report_state":"MI","report_number":"PATTM03986","insp_date":"2022-10-12 00:00:00","insp_start_time":"1230","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2022-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"93000","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":"1098370","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-10-13 21:40:00","snet_input_date":"2022-10-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-13 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:29.000000Z","updated_at":"2025-03-17T18:54:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2427709,"change_date":"2022-10-13 21:40:00","inspection_id":"76868155","insp_unit_id":"191426473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC03169","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWGAAR85J007825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:38.000000Z","updated_at":"2025-03-17T22:23:38.000000Z"},{"id":2427710,"change_date":"2022-10-13 21:40:00","inspection_id":"76868155","insp_unit_id":"191426474","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"D268216","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA4137G1000840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:38.000000Z","updated_at":"2025-03-17T22:23:38.000000Z"}]},{"id":1466922,"change_date":"2022-10-07 21:39:00","inspection_id":"76820376","dot_number":"1776564","report_state":"MI","report_number":"MALIK01371","insp_date":"2022-10-06 00:00:00","insp_start_time":"1355","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 32 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1097638","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:46.000000Z","updated_at":"2025-03-17T18:53:46.000000Z","inspection_violations":[{"id":2310357,"change_date":"2022-10-07 21:39:00","inspection_id":"76820376","insp_violation_id":"248900208","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":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2361653,"change_date":"2022-10-07 21:39:00","inspection_id":"76820376","insp_unit_id":"191329761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"439","insp_unit_license":"BC54318","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDYW86F6WVA17291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":1435965,"change_date":"2022-10-04 21:41:00","inspection_id":"76784426","dot_number":"1776564","report_state":"MI","report_number":"MALIK01368","insp_date":"2022-10-03 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 32 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2022-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1097185","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-10-04 21:41:00","snet_input_date":"2022-10-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:06.000000Z","updated_at":"2025-03-17T18:53:06.000000Z","inspection_violations":[{"id":2259220,"change_date":"2022-10-04 21:41:00","inspection_id":"76784426","insp_violation_id":"248816326","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":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2311670,"change_date":"2022-10-04 21:41:00","inspection_id":"76784426","insp_unit_id":"191258005","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"485","insp_unit_license":"BB29191","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVMG3DV9DHBZ7317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:50.000000Z","updated_at":"2025-03-17T22:22:50.000000Z"}]},{"id":1388270,"change_date":"2022-09-28 21:40:00","inspection_id":"76728994","dot_number":"1776564","report_state":"MI","report_number":"PATTM03951","insp_date":"2022-09-27 00:00:00","insp_start_time":"1440","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2022-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1096584","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-09-28 21:40:00","snet_input_date":"2022-09-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:20.000000Z","updated_at":"2025-03-17T18:52:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2235574,"change_date":"2022-09-28 21:40:00","inspection_id":"76728994","insp_unit_id":"191147385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB47014","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X8HM157892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:18.000000Z","updated_at":"2025-03-17T22:22:18.000000Z"}]},{"id":1388368,"change_date":"2022-09-28 21:40:00","inspection_id":"76729099","dot_number":"1776564","report_state":"MI","report_number":"MALIK01358","insp_date":"2022-09-27 00:00:00","insp_start_time":"0715","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","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":"N","pen_cen_match":null,"final_status_date":"2022-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"1096516","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-09-28 21:40:00","snet_input_date":"2022-09-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:20.000000Z","updated_at":"2025-03-17T18:52:20.000000Z","inspection_violations":[{"id":2192922,"change_date":"2022-09-28 21:40:00","inspection_id":"76729099","insp_violation_id":"248697778","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191147596","insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2235755,"change_date":"2022-09-28 21:40:00","inspection_id":"76729099","insp_unit_id":"191147596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4012","insp_unit_license":"BD17778","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC5JDJH1292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:18.000000Z","updated_at":"2025-03-17T22:22:18.000000Z"},{"id":2235756,"change_date":"2022-09-28 21:40:00","inspection_id":"76729099","insp_unit_id":"191147597","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ASSEM","insp_unit_company":"2072","insp_unit_license":"E286778","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI1804A170R062320","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:18.000000Z","updated_at":"2025-03-17T22:22:18.000000Z"}]},{"id":1326382,"change_date":"2022-09-20 21:41:00","inspection_id":"76657280","dot_number":"1776564","report_state":"MI","report_number":"MALIK01340","insp_date":"2022-09-19 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 32 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2022-09-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","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":"1095612","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-09-20 21:41:00","snet_input_date":"2022-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-20 21:41:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:13.000000Z","updated_at":"2025-03-17T18:51:13.000000Z","inspection_violations":[{"id":2098569,"change_date":"2022-09-20 21:41:00","inspection_id":"76657280","insp_violation_id":"248529450","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":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2135171,"change_date":"2022-09-20 21:41:00","inspection_id":"76657280","insp_unit_id":"190998622","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"376","insp_unit_license":"BC54333","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WRMALXKG566927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:38.000000Z","updated_at":"2025-03-17T22:21:38.000000Z"},{"id":2135172,"change_date":"2022-09-20 21:41:00","inspection_id":"76657280","insp_unit_id":"190998623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"N\/A","insp_unit_company":"210","insp_unit_license":"A327182","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"00006976210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:38.000000Z","updated_at":"2025-03-17T22:21:38.000000Z"}]},{"id":1304212,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","dot_number":"1776564","report_state":"MI","report_number":"OSHEE01894","insp_date":"2022-09-15 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 @ HEISE RD","county_code_state":"MI","county_code":"029","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":"N","pen_cen_match":null,"final_status_date":"2022-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1095266","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-09-16 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:49.000000Z","updated_at":"2025-03-17T18:50:49.000000Z","inspection_violations":[{"id":2063367,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_violation_id":"248469602","seq_no":"1","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"190945793","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"39381"},{"id":2063368,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_violation_id":"248469603","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190945793","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"39395F"},{"id":2063369,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_violation_id":"248469604","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190945794","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3939A"},{"id":2063370,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_violation_id":"248469605","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190945794","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3939A"},{"id":2063371,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_violation_id":"248469606","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"190945794","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"39319"},{"id":2063372,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_violation_id":"248469607","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190945794","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2099117,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_unit_id":"190945793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC74223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3YSEY0MF228071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"},{"id":2099118,"change_date":"2022-09-16 21:40:00","inspection_id":"76631582","insp_unit_id":"190945794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DYNW","insp_unit_company":null,"insp_unit_license":"D255602","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4U141ABX9V1X34845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"}]},{"id":933854,"change_date":"2022-08-01 21:39:00","inspection_id":"76200459","dot_number":"1776564","report_state":"MI","report_number":"DETGT03904","insp_date":"2022-07-28 00:00:00","insp_start_time":"1010","insp_end_time":"1033","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I94 @ ANN ARBOR RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"1086386","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1473253,"change_date":"2022-08-01 21:39:00","inspection_id":"76200459","insp_violation_id":"247430460","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4093967","created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1503152,"change_date":"2022-08-01 21:39:00","inspection_id":"76200459","insp_unit_id":"190063007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"489","insp_unit_license":"BB81292","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC7JHJU4688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"},{"id":1503153,"change_date":"2022-08-01 21:39:00","inspection_id":"76200459","insp_unit_id":"190063008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAOT","insp_unit_company":"297","insp_unit_license":"C685224","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9MP40225G085258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]},{"id":785275,"change_date":"2022-07-10 21:31:00","inspection_id":"76026249","dot_number":"1776564","report_state":"MI","report_number":"LITTJ04065","insp_date":"2022-07-08 00:00:00","insp_start_time":"1235","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E\/B @ I-275","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-10 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1083275","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01776564","upload_search_indicator":null,"census_search_date":"2022-07-10 21:31:00","snet_input_date":"2022-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-10 21:31:00","insp_carrier_name":"RAUHORN ELECTRIC INC","insp_carrier_street":"14140 33 MILE RD","insp_carrier_city":"BRUCE TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48065","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:34.000000Z","updated_at":"2025-03-17T18:41:34.000000Z","inspection_violations":[{"id":1238588,"change_date":"2022-07-10 21:31:00","inspection_id":"76026249","insp_violation_id":"246989821","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189689528","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":1263484,"change_date":"2022-07-10 21:31:00","inspection_id":"76026249","insp_unit_id":"189689527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"4023","insp_unit_license":"BD02312","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FWBAWDA55AU15631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"},{"id":1263485,"change_date":"2022-07-10 21:31:00","inspection_id":"76026249","insp_unit_id":"189689528","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"2099","insp_unit_license":"E694972","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI6741A170R052522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1776564\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1776564\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1776564\/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\/1776564\/inspections","per_page":100,"prev_page_url":null,"to":77,"total":77}