{"current_page":1,"data":[{"id":12344977,"change_date":"2026-07-02 21:40:00","inspection_id":"88304626","dot_number":"1441260","report_state":"MI","report_number":"KELLC02437","insp_date":"2026-07-02 00:00:00","insp_start_time":"1312","insp_end_time":"1325","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"073","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":"U","pen_cen_match":"I","final_status_date":"2026-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"3673321","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2026-07-02 21:40:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-02 21:40:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-05T09:42:16.000000Z","updated_at":"2026-07-14T09:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21438592,"change_date":"2026-07-02 21:40:00","inspection_id":"88304626","insp_unit_id":"214418720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2-24","insp_unit_license":"BD57328","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GD49SE79RF191285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:44.000000Z","updated_at":"2026-07-14T09:02:17.000000Z"},{"id":21438593,"change_date":"2026-07-02 21:40:00","inspection_id":"88304626","insp_unit_id":"214418721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"NONE","insp_unit_license":"F195818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZEDT1426H1143577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:44.000000Z","updated_at":"2026-07-14T09:02:17.000000Z"}]},{"id":10507665,"change_date":"2026-01-05 21:37:00","inspection_id":"86642752","dot_number":"1441260","report_state":"MI","report_number":"COPEK03615","insp_date":"2025-12-22 00:00:00","insp_start_time":"1600","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OPYDKE @ FEATHERSTONE","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","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-23 21:38: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":"1254625","transaction_code":"C","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:36.000000Z","updated_at":"2026-01-16T10:30:16.000000Z","inspection_violations":[{"id":17750148,"change_date":"2026-01-05 21:37:00","inspection_id":"86642752","insp_violation_id":"271015214","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-01-08T10:38:01.000000Z","updated_at":"2026-01-16T10:30:34.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17705679,"change_date":"2026-01-05 21:37:00","inspection_id":"86642752","insp_unit_id":"210914383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BB16670","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KYCY1HF163328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:23.000000Z"}]},{"id":9817872,"change_date":"2025-10-02 21:42:00","inspection_id":"85918124","dot_number":"1441260","report_state":"MI","report_number":"FRIZS03393","insp_date":"2025-09-29 00:00:00","insp_start_time":"1405","insp_end_time":"1414","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-127 N\/B @ BLANCHARD RD","county_code_state":"MI","county_code":"073","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"1243997","transaction_code":"C","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2025-09-30 21:39:00","snet_input_date":"2025-09-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-30 21:39:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-03T10:01:52.000000Z","updated_at":"2025-10-05T10:01:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16308209,"change_date":"2025-10-02 21:42:00","inspection_id":"85918124","insp_unit_id":"209264602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0799","insp_unit_license":"BE09684","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJG3DV0RHVD0799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:55.000000Z","updated_at":"2025-10-05T09:46:55.000000Z"},{"id":16308210,"change_date":"2025-10-02 21:42:00","inspection_id":"85918124","insp_unit_id":"209264603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E590423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK5338K1037426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:55.000000Z","updated_at":"2025-10-05T09:46:55.000000Z"}]},{"id":8513154,"change_date":"2025-04-30 21:52:00","inspection_id":"84544230","dot_number":"1441260","report_state":"MI","report_number":"BARTC02830","insp_date":"2025-04-29 00:00:00","insp_start_time":"1115","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M115 @ ANIOCK DR","county_code_state":"MI","county_code":"165","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-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","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":"1219739","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:09.000000Z","updated_at":"2025-05-04T10:40:21.000000Z","inspection_violations":[{"id":13475888,"change_date":"2025-04-30 21:52:00","inspection_id":"84544230","insp_violation_id":"265930116","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"1","insp_unit_id":"206576308","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:49.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":13839204,"change_date":"2025-04-30 21:52:00","inspection_id":"84544230","insp_unit_id":"206576308","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD50161","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYFE3PDUN8570","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"},{"id":13839205,"change_date":"2025-04-30 21:52:00","inspection_id":"84544230","insp_unit_id":"206576309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ITCI","insp_unit_company":null,"insp_unit_license":"F158125","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JK0DT202KM01697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":8194912,"change_date":"2025-03-24 21:40:00","inspection_id":"84208955","dot_number":"1441260","report_state":"MI","report_number":"AKERT00493","insp_date":"2025-03-24 00:00:00","insp_start_time":"1123","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 & 17 MILE RD","county_code_state":"MI","county_code":"081","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1214611","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2025-03-24 21:40:00","snet_input_date":"2025-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-24 21:40:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-27T10:01:32.000000Z","updated_at":"2025-03-28T10:14:14.000000Z","inspection_violations":[{"id":12849884,"change_date":"2025-03-24 21:40:00","inspection_id":"84208955","insp_violation_id":"265221319","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","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-27T10:29:37.000000Z","updated_at":"2025-03-28T10:40:45.000000Z","normalized_code":"3922SLLSR"},{"id":12849885,"change_date":"2025-03-24 21:40:00","inspection_id":"84208955","insp_violation_id":"265221320","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-27T10:29:37.000000Z","updated_at":"2025-03-28T10:40:45.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":13248746,"change_date":"2025-03-24 21:40:00","inspection_id":"84208955","insp_unit_id":"205959671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"13-24","insp_unit_license":"BD84898","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSE79RF357719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T09:57:37.000000Z","updated_at":"2025-03-28T10:04:50.000000Z"},{"id":13248747,"change_date":"2025-03-24 21:40:00","inspection_id":"84208955","insp_unit_id":"205959672","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"DT-35","insp_unit_license":"E989506","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZEDT1428P2288449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T09:57:37.000000Z","updated_at":"2025-03-28T10:04:50.000000Z"}]},{"id":7970105,"change_date":"2025-02-26 21:42:00","inspection_id":"83972366","dot_number":"1441260","report_state":"MI","report_number":"HOLLM04242","insp_date":"2025-02-25 00:00:00","insp_start_time":"1123","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ SARGENT 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":"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-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"1211255","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12452500,"change_date":"2025-02-26 21:42:00","inspection_id":"83972366","insp_violation_id":"264716680","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:49.000000Z","updated_at":"2025-03-17T22:06:49.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12866574,"change_date":"2025-02-26 21:42:00","inspection_id":"83972366","insp_unit_id":"205517827","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD93367","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSE7XRF363464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"},{"id":12866575,"change_date":"2025-02-26 21:42:00","inspection_id":"83972366","insp_unit_id":"205517828","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"E791423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZEDT1428H1130796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":6579520,"change_date":"2024-08-28 21:41:00","inspection_id":"82503245","dot_number":"1441260","report_state":"IN","report_number":"8557005436","insp_date":"2024-08-27 00:00:00","insp_start_time":"1002","insp_end_time":"1050","registration_date":null,"region":"ED","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","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":"2024-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"789140","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-08-28 21:41:00","snet_input_date":"2024-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-28 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:14.000000Z","updated_at":"2025-03-17T20:33:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10607097,"change_date":"2024-08-28 21:41:00","inspection_id":"82503245","insp_unit_id":"202618042","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"9087","insp_unit_license":"BC65445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYDP9X8FJ459087","insp_unit_decal":"Y","insp_unit_decal_number":"34401595","created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"}]},{"id":6046856,"change_date":"2024-06-26 21:43:00","inspection_id":"81932994","dot_number":"1441260","report_state":"MI","report_number":"PATTM04694","insp_date":"2024-06-20 00:00:00","insp_start_time":"1250","insp_end_time":"1315","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":"2024-06-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1183437","transaction_code":"C","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-06-21 21:39:00","snet_input_date":"2024-06-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-21 21:39:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:36.000000Z","updated_at":"2025-03-17T20:22:36.000000Z","inspection_violations":[{"id":9379580,"change_date":"2024-06-26 21:43:00","inspection_id":"81932994","insp_violation_id":"260328627","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:51:21.000000Z","updated_at":"2025-03-17T21:51:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9739116,"change_date":"2024-06-26 21:43:00","inspection_id":"81932994","insp_unit_id":"201606605","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC67474","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HA6GVC72MN000159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"}]},{"id":5768116,"change_date":"2024-05-17 21:40:00","inspection_id":"81630703","dot_number":"1441260","report_state":"MI","report_number":"MALOJ01803","insp_date":"2024-05-15 00:00:00","insp_start_time":"1015","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 S\/B @ HARTWICK PINES RA","county_code_state":"MI","county_code":"039","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-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","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":"1178839","transaction_code":"C","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:05.000000Z","updated_at":"2025-03-17T20:17:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9290599,"change_date":"2024-05-17 21:40:00","inspection_id":"81630703","insp_unit_id":"200954585","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90440","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT3GEB99257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"},{"id":9290600,"change_date":"2024-05-17 21:40:00","inspection_id":"81630703","insp_unit_id":"200954586","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"T-1241","insp_unit_license":"E989507","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH202XM1241241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5575982,"change_date":"2024-04-23 21:41:00","inspection_id":"81421783","dot_number":"1441260","report_state":"MI","report_number":"BROWP01911","insp_date":"2024-04-22 00:00:00","insp_start_time":"1110","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75","county_code_state":"MI","county_code":"033","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":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"84570","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":"1174894","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8981909,"change_date":"2024-04-23 21:41:00","inspection_id":"81421783","insp_unit_id":"200530397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"594","insp_unit_license":"BB79352","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FWWHECBXYAF62312","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":8981910,"change_date":"2024-04-23 21:41:00","inspection_id":"81421783","insp_unit_id":"200530398","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"LB48","insp_unit_license":"D959604","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNFT2329GL161750","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":4955168,"change_date":"2024-02-01 21:43:00","inspection_id":"80744302","dot_number":"1441260","report_state":"MI","report_number":"FRIZS02914","insp_date":"2024-01-31 00:00:00","insp_start_time":"1015","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W. ISABELLA RD @ MCGRUDER RD","county_code_state":"MI","county_code":"111","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1162696","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[{"id":7631819,"change_date":"2024-02-01 21:43:00","inspection_id":"80744302","insp_violation_id":"257613537","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199222243","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7974700,"change_date":"2024-02-01 21:43:00","inspection_id":"80744302","insp_unit_id":"199222243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7878","insp_unit_license":"BA81792","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWDB0X96J157878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4858689,"change_date":"2024-01-18 21:45:00","inspection_id":"80638640","dot_number":"1441260","report_state":"MI","report_number":"LAUEJ01535","insp_date":"2024-01-17 00:00:00","insp_start_time":"0820","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-18 21:45: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":"1160990","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:53.000000Z","updated_at":"2025-03-17T19:58:53.000000Z","inspection_violations":[{"id":7488621,"change_date":"2024-01-18 21:45:00","inspection_id":"80638640","insp_violation_id":"257396733","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3922"},{"id":7488622,"change_date":"2024-01-18 21:45:00","inspection_id":"80638640","insp_violation_id":"257396734","seq_no":"2","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":null,"created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":7817297,"change_date":"2024-01-18 21:45:00","inspection_id":"80638640","insp_unit_id":"199015326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB75451","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAN9EH485787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:52.000000Z","updated_at":"2025-03-17T23:05:52.000000Z"}]},{"id":4803036,"change_date":"2024-01-10 21:44:00","inspection_id":"80577846","dot_number":"1441260","report_state":"MI","report_number":"BROWP01769","insp_date":"2024-01-09 00:00:00","insp_start_time":"0835","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28 W\/B & RACO","county_code_state":"MI","county_code":"033","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":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"1159932","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7727670,"change_date":"2024-01-10 21:44:00","inspection_id":"80577846","insp_unit_id":"198898650","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"5-12","insp_unit_license":"BD34208","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3KZCG6CF200813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4570422,"change_date":"2023-12-06 21:42:00","inspection_id":"80323408","dot_number":"1441260","report_state":"MI","report_number":"CELMS00788","insp_date":"2023-12-05 00:00:00","insp_start_time":"1405","insp_end_time":"1430","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2023-12-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1156052","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-12-06 21:42:00","snet_input_date":"2023-12-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:24.000000Z","updated_at":"2025-03-17T19:53:24.000000Z","inspection_violations":[{"id":7069366,"change_date":"2023-12-06 21:42:00","inspection_id":"80323408","insp_violation_id":"256743745","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198376370","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7350901,"change_date":"2023-12-06 21:42:00","inspection_id":"80323408","insp_unit_id":"198376370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC36897","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK55LN37561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"},{"id":7350902,"change_date":"2023-12-06 21:42:00","inspection_id":"80323408","insp_unit_id":"198376371","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":null,"insp_unit_license":"C602809","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA5320D1042806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"}]},{"id":4115128,"change_date":"2023-10-03 21:41:00","inspection_id":"79820879","dot_number":"1441260","report_state":"MI","report_number":"PATTM04437","insp_date":"2023-10-02 00:00:00","insp_start_time":"1215","insp_end_time":"1240","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":"313","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-03 21:41: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":"1148297","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-10-03 21:41:00","snet_input_date":"2023-10-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:05.000000Z","updated_at":"2025-03-17T19:44:05.000000Z","inspection_violations":[{"id":6366799,"change_date":"2023-10-03 21:41:00","inspection_id":"79820879","insp_violation_id":"255627403","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:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6616326,"change_date":"2023-10-03 21:41:00","inspection_id":"79820879","insp_unit_id":"197372982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC95881","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT2HDA07530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:31.000000Z","updated_at":"2025-03-17T22:55:31.000000Z"}]},{"id":3974167,"change_date":"2023-09-14 21:41:00","inspection_id":"79664142","dot_number":"1441260","report_state":"MI","report_number":"ELDEH00305","insp_date":"2023-09-13 00:00:00","insp_start_time":"1825","insp_end_time":"1850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ KING RD","county_code_state":"MI","county_code":"145","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27200","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":"1145913","transaction_code":"A","transaction_date":"2023-09-13 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-09-14 21:41:00","snet_input_date":"2023-09-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-14 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:14.000000Z","updated_at":"2025-03-17T19:41:14.000000Z","inspection_violations":[{"id":6146218,"change_date":"2023-09-14 21:41:00","inspection_id":"79664142","insp_violation_id":"255270051","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197057241","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6390309,"change_date":"2023-09-14 21:41:00","inspection_id":"79664142","insp_unit_id":"197057240","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"NONE","insp_unit_license":"BA70292","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KYC89GF187844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:41.000000Z","updated_at":"2025-03-17T22:53:41.000000Z"},{"id":6390310,"change_date":"2023-09-14 21:41:00","inspection_id":"79664142","insp_unit_id":"197057241","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"DT-23","insp_unit_license":"D595435","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZEDT1422H1122788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:41.000000Z","updated_at":"2025-03-17T22:53:41.000000Z"}]},{"id":3888702,"change_date":"2023-09-01 21:39:00","inspection_id":"79569110","dot_number":"1441260","report_state":"MI","report_number":"PENNJ00821","insp_date":"2023-08-31 00:00:00","insp_start_time":"1515","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-127 @ SAINT CHARLES RD","county_code_state":"MI","county_code":"057","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":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"112900","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":"1143994","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":"01441260","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":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[{"id":6009435,"change_date":"2023-09-01 21:39:00","inspection_id":"79569110","insp_violation_id":"255045511","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:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":6252017,"change_date":"2023-09-01 21:39:00","inspection_id":"79569110","insp_unit_id":"196865308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"512","insp_unit_license":"BA90491","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ9X6HM170375","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":6252018,"change_date":"2023-09-01 21:39:00","inspection_id":"79569110","insp_unit_id":"196865309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D224066","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3536F1004199","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":3609464,"change_date":"2023-07-27 21:40:00","inspection_id":"79256967","dot_number":"1441260","report_state":"MI","report_number":"LULAN01905","insp_date":"2023-07-25 00:00:00","insp_start_time":"1125","insp_end_time":"1200","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1136998","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5566394,"change_date":"2023-07-27 21:40:00","inspection_id":"79256967","insp_violation_id":"254318412","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":"X4251413","created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5803365,"change_date":"2023-07-27 21:40:00","inspection_id":"79256967","insp_unit_id":"196228456","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"BB7936","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZHAZCV16AV6630","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":2910021,"change_date":"2023-04-27 21:43:00","inspection_id":"78469056","dot_number":"1441260","report_state":"MI","report_number":"BARTC02244","insp_date":"2023-04-26 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M72 @ SMITH LAKE","county_code_state":"MI","county_code":"079","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":"2023-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"29300","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":"1123643","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:26.000000Z","updated_at":"2025-03-17T19:20:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4681671,"change_date":"2023-04-27 21:43:00","inspection_id":"78469056","insp_unit_id":"194626722","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"264","insp_unit_license":"BC14581","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT1KDA19983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4681672,"change_date":"2023-04-27 21:43:00","inspection_id":"78469056","insp_unit_id":"194626723","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNIE","insp_unit_company":null,"insp_unit_license":"D165704","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"56JTE2020FA141017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"}]},{"id":2695434,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","dot_number":"1441260","report_state":"TN","report_number":"5Z19105188","insp_date":"2023-03-29 00:00:00","insp_start_time":"1430","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"S","location_desc":"GREENE COUNTY SCALES","county_code_state":"TN","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101870","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1638422","transaction_code":"C","transaction_date":"2024-07-15 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-03-30 21:40:00","snet_input_date":"2023-03-29 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-03-30 21:40:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:15.000000Z","updated_at":"2025-05-11T10:10:24.000000Z","inspection_violations":[{"id":13577498,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","insp_violation_id":"266059121","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"2","insp_unit_id":"206685307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:05:31.000000Z","updated_at":"2025-05-10T11:15:04.000000Z","normalized_code":"3939H"},{"id":13577499,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","insp_violation_id":"266059122","seq_no":"2","part_no":"392","part_no_section":"2IRP","insp_viol_unit":"2","insp_unit_id":"206685307","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:05:31.000000Z","updated_at":"2025-05-10T11:15:04.000000Z","normalized_code":"3922IRP"},{"id":13577500,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","insp_violation_id":"266059123","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"206685307","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:05:31.000000Z","updated_at":"2025-05-10T11:15:04.000000Z","normalized_code":"3922"},{"id":13577501,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","insp_violation_id":"266059124","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206685307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:05:31.000000Z","updated_at":"2025-05-10T11:15:04.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13931187,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","insp_unit_id":"206685306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"512","insp_unit_license":"BA90491","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ9X6HM170375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:09:50.000000Z","updated_at":"2025-05-11T02:44:16.000000Z"},{"id":13931188,"change_date":"2025-05-07 21:43:00","inspection_id":"78225606","insp_unit_id":"206685307","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"LB46","insp_unit_license":"D909548","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNFT2328GL161108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:09:50.000000Z","updated_at":"2025-05-11T02:44:16.000000Z"}]},{"id":2524206,"change_date":"2023-03-07 21:41:00","inspection_id":"78030278","dot_number":"1441260","report_state":"IN","report_number":"5267012272","insp_date":"2023-03-06 00:00:00","insp_start_time":"0925","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"2269S","location_desc":"#22  I-69  SB  HUNTINGTON","county_code_state":"IN","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"J. RANCK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2179533","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":"M","census_search_date":"2023-03-07 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-03-07 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:18.000000Z","updated_at":"2025-03-17T19:13:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4062775,"change_date":"2023-03-07 21:41:00","inspection_id":"78030278","insp_unit_id":"193748095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"67","insp_unit_license":"BC59675","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0X5HT1LEE89681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:07.000000Z","updated_at":"2025-03-17T22:35:07.000000Z"}]},{"id":2358020,"change_date":"2023-02-13 21:43:00","inspection_id":"77840982","dot_number":"1441260","report_state":"MI","report_number":"DAWDD02452","insp_date":"2023-02-10 00:00:00","insp_start_time":"0809","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 AT REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"J RANCK ELECTRIC INC","shipping_paper_number":"02102023","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-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1113420","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2023-02-13 21:43:00","snet_input_date":"2023-02-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MT PLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:01.000000Z","updated_at":"2025-03-17T19:10:01.000000Z","inspection_violations":[{"id":3631512,"change_date":"2023-02-13 21:43:00","inspection_id":"77840982","insp_violation_id":"251101217","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":"X4168651","created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3922"},{"id":3631513,"change_date":"2023-02-13 21:43:00","inspection_id":"77840982","insp_violation_id":"251101218","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"193368670","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39375G"},{"id":3631514,"change_date":"2023-02-13 21:43:00","inspection_id":"77840982","insp_violation_id":"251101219","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193368670","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3794836,"change_date":"2023-02-13 21:43:00","inspection_id":"77840982","insp_unit_id":"193368670","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"786","insp_unit_license":"BC14542","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMKAAR46H247288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"},{"id":3794837,"change_date":"2023-02-13 21:43:00","inspection_id":"77840982","insp_unit_id":"193368671","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":"LB9","insp_unit_license":"E398181","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112HAN3032L060089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"}]},{"id":1254508,"change_date":"2022-09-11 21:30:00","inspection_id":"76573486","dot_number":"1441260","report_state":"MI","report_number":"OSHEE01888","insp_date":"2022-09-09 00:00:00","insp_start_time":"1305","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ANNA DR & MEECHER RD","county_code_state":"MI","county_code":"137","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":"2022-09-11 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1094107","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2022-09-11 21:30:00","snet_input_date":"2022-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-11 21:30:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[{"id":1986197,"change_date":"2022-09-11 21:30:00","inspection_id":"76573486","insp_violation_id":"248325521","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190824289","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2019265,"change_date":"2022-09-11 21:30:00","inspection_id":"76573486","insp_unit_id":"190824289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"517","insp_unit_license":"BC25446","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0XXLM377325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:52.000000Z","updated_at":"2025-03-17T22:20:52.000000Z"}]},{"id":1248779,"change_date":"2022-09-09 21:38:00","inspection_id":"76566908","dot_number":"1441260","report_state":"MI","report_number":"KELLC01635","insp_date":"2022-09-08 00:00:00","insp_start_time":"1500","insp_end_time":"1506","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US23NB @ RIPLEY BLVD","county_code_state":"MI","county_code":"007","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-09 21:38: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":"1093951","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2022-09-09 21:38:00","snet_input_date":"2022-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:43.000000Z","updated_at":"2025-03-17T18:49:43.000000Z","inspection_violations":[{"id":1976498,"change_date":"2022-09-09 21:38:00","inspection_id":"76566908","insp_violation_id":"248309022","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:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":2009688,"change_date":"2022-09-09 21:38:00","inspection_id":"76566908","insp_unit_id":"190810581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"250","insp_unit_license":"BA90440","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2HSCNASR5YC072467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"}]},{"id":748651,"change_date":"2022-07-05 21:42:00","inspection_id":"75983838","dot_number":"1441260","report_state":"MI","report_number":"FRIZS02511","insp_date":"2022-07-05 00:00:00","insp_start_time":"0714","insp_end_time":"0729","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-20 E\/B @ M-30","county_code_state":"MI","county_code":"111","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"159200","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":"1082501","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-07-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1203756,"change_date":"2022-07-05 21:42:00","inspection_id":"75983838","insp_unit_id":"189600636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7878","insp_unit_license":"BA81792","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWDB0X96J157878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"},{"id":1203757,"change_date":"2022-07-05 21:42:00","inspection_id":"75983838","insp_unit_id":"189600637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E372889","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5SPDG2633MW2K3221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]},{"id":377429,"change_date":"2022-06-09 21:42:00","inspection_id":"75543043","dot_number":"1441260","report_state":"MI","report_number":"BURGM04539","insp_date":"2022-05-11 00:00:00","insp_start_time":"1200","insp_end_time":"1223","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WALKER RD","county_code_state":"MI","county_code":"037","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":"2022-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","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":"1075133","transaction_code":"C","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2022-05-12 21:41:00","snet_input_date":"2022-05-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-12 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:02.000000Z","updated_at":"2025-03-17T18:34:02.000000Z","inspection_violations":[{"id":590807,"change_date":"2022-06-09 21:42:00","inspection_id":"75543043","insp_violation_id":"246330947","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":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"3922"},{"id":590808,"change_date":"2022-06-09 21:42:00","inspection_id":"75543043","insp_violation_id":"246330948","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189143613","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"393104F3"}],"inspection_per_units":[{"id":610272,"change_date":"2022-06-09 21:42:00","inspection_id":"75543043","insp_unit_id":"189143612","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7878","insp_unit_license":"BA81792","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWDB0X96J157878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:57.000000Z","updated_at":"2025-03-17T22:11:57.000000Z"},{"id":610273,"change_date":"2022-06-09 21:42:00","inspection_id":"75543043","insp_unit_id":"189143613","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"T52","insp_unit_license":"E590423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK5338K1037426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:57.000000Z","updated_at":"2025-03-17T22:11:57.000000Z"}]},{"id":243036,"change_date":"2022-06-09 21:42:00","inspection_id":"75382880","dot_number":"1441260","report_state":"MI","report_number":"FRIZS02482","insp_date":"2022-04-22 00:00:00","insp_start_time":"1416","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S. SHEPHARD RD @ BROADWAY RD","county_code_state":"MI","county_code":"073","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","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-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11600","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":"1072674","transaction_code":"C","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01441260","upload_search_indicator":null,"census_search_date":"2022-04-25 21:41:00","snet_input_date":"2022-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"J RANCK ELECTRIC INC","insp_carrier_street":"1993 GOVER PARKWAY","insp_carrier_city":"MTPLEASANT","insp_carrier_state":"MI","insp_carrier_zip_code":"48858","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:51.000000Z","updated_at":"2025-03-17T18:31:51.000000Z","inspection_violations":[{"id":373336,"change_date":"2022-06-09 21:42:00","inspection_id":"75382880","insp_violation_id":"246333343","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:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"39216A"},{"id":373337,"change_date":"2022-06-09 21:42:00","inspection_id":"75382880","insp_violation_id":"246333344","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"189145293","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":394138,"change_date":"2022-06-09 21:42:00","inspection_id":"75382880","insp_unit_id":"189145293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"6-16","insp_unit_license":"BC95889","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC5KYC80GZ265586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:37.000000Z","updated_at":"2025-03-17T22:10:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1441260\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1441260\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1441260\/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\/1441260\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}