{"current_page":1,"data":[{"id":12690860,"change_date":"2026-08-11 21:41:00","inspection_id":"88664937","dot_number":"2833432","report_state":"MI","report_number":"LAUEJ02467","insp_date":"2026-08-11 00:00:00","insp_start_time":"1020","insp_end_time":"1109","registration_date":null,"region":"ED","ci_status_code":"C","location":"841","location_desc":"MI","county_code_state":"MI","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3955468","transaction_code":"A","transaction_date":"2026-08-11 00:00:00","upload_date":"2026-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2026-08-11 21:41:00","snet_input_date":"2026-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-11 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-14T09:40:41.000000Z","updated_at":"2026-08-22T09:32:45.000000Z","inspection_violations":[{"id":22096081,"change_date":"2026-08-11 21:41:00","inspection_id":"88664937","insp_violation_id":"276055418","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4735111","created_at":"2026-08-14T10:00:20.000000Z","updated_at":"2026-08-22T09:44:00.000000Z","normalized_code":"3922SLLEWA2"},{"id":22096082,"change_date":"2026-08-11 21:41:00","inspection_id":"88664937","insp_violation_id":"276055419","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:20.000000Z","updated_at":"2026-08-22T09:44:00.000000Z","normalized_code":"39617CPI"},{"id":22096083,"change_date":"2026-08-11 21:41:00","inspection_id":"88664937","insp_violation_id":"276055420","seq_no":"3","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":"2026-08-14T10:00:20.000000Z","updated_at":"2026-08-22T09:44:00.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":22025954,"change_date":"2026-08-11 21:41:00","inspection_id":"88664937","insp_unit_id":"215090330","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD60883","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-14T09:19:08.000000Z","updated_at":"2026-08-22T09:02:04.000000Z"},{"id":22025955,"change_date":"2026-08-11 21:41:00","inspection_id":"88664937","insp_unit_id":"215090331","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"E544299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5077J1223248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-14T09:19:08.000000Z","updated_at":"2026-08-22T09:02:04.000000Z"}]},{"id":12690181,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","dot_number":"2833432","report_state":"MI","report_number":"BROWP03204","insp_date":"2026-08-11 00:00:00","insp_start_time":"0705","insp_end_time":"0745","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"033","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"3954729","transaction_code":"A","transaction_date":"2026-08-11 00:00:00","upload_date":"2026-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2026-08-11 21:40:00","snet_input_date":"2026-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-11 21:40:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-14T09:40:39.000000Z","updated_at":"2026-08-22T09:32:41.000000Z","inspection_violations":[{"id":22095218,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_violation_id":"276053021","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"215088450","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:04.000000Z","updated_at":"2026-08-22T09:43:44.000000Z","normalized_code":"39617CPI"},{"id":22095219,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_violation_id":"276053022","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215088450","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:04.000000Z","updated_at":"2026-08-22T09:43:44.000000Z","normalized_code":"3922SLLSR"},{"id":22095220,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_violation_id":"276053023","seq_no":"5","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"1","insp_unit_id":"215088450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:04.000000Z","updated_at":"2026-08-22T09:43:44.000000Z","normalized_code":"39348ABIAD"},{"id":22095221,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_violation_id":"276053024","seq_no":"6","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"215088450","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4730594","created_at":"2026-08-14T10:00:04.000000Z","updated_at":"2026-08-22T09:43:44.000000Z","normalized_code":"3922SLLIFTA"},{"id":22095216,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_violation_id":"276053019","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"215088450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-14T10:00:04.000000Z","updated_at":"2026-08-22T09:43:44.000000Z","normalized_code":"3939ALHLI"},{"id":22095217,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_violation_id":"276053020","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"215088450","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-14T10:00:04.000000Z","updated_at":"2026-08-22T09:43:44.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":22024852,"change_date":"2026-08-11 21:40:00","inspection_id":"88664206","insp_unit_id":"215088450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"60","insp_unit_license":"BD60821","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDXUEX57J198541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-14T09:19:06.000000Z","updated_at":"2026-08-22T09:01:56.000000Z"}]},{"id":12557484,"change_date":"2026-07-27 21:39:00","inspection_id":"88524836","dot_number":"2833432","report_state":"MI","report_number":"ZASTM02171","insp_date":"2026-07-27 00:00:00","insp_start_time":"0933","insp_end_time":"0955","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"041","insp_level_id":"3","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-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"76001","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":"3843151","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2026-07-27 21:39:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-30T09:40:00.000000Z","updated_at":"2026-08-07T09:30:36.000000Z","inspection_violations":[{"id":21862575,"change_date":"2026-07-27 21:39:00","inspection_id":"88524836","insp_violation_id":"275751654","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:39.000000Z","updated_at":"2026-08-07T09:41:08.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":21804919,"change_date":"2026-07-27 21:39:00","inspection_id":"88524836","insp_unit_id":"214833856","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5","insp_unit_license":"BC80872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXL40X2JD469233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:22.000000Z","updated_at":"2026-08-07T09:01:57.000000Z"},{"id":21804920,"change_date":"2026-07-27 21:39:00","inspection_id":"88524836","insp_unit_id":"214833857","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"E602540","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI0112A388R022717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:22.000000Z","updated_at":"2026-08-07T09:01:57.000000Z"}]},{"id":11794103,"change_date":"2026-04-30 21:41:00","inspection_id":"87726927","dot_number":"2833432","report_state":"MI","report_number":"ZASTM02129","insp_date":"2026-04-30 00:00:00","insp_start_time":"1123","insp_end_time":"1257","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PIKE DISTRIBUTORS","county_code_state":"MI","county_code":"041","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2026-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133500","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":"1268447","transaction_code":"A","transaction_date":"2026-04-30 00:00:00","upload_date":"2026-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2026-04-30 21:41:00","snet_input_date":"2026-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-30 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:58.000000Z","updated_at":"2026-05-11T09:31:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20516297,"change_date":"2026-04-30 21:41:00","inspection_id":"87726927","insp_unit_id":"213317904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BD60805","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKXAMCG7GPGY1241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:58.000000Z","updated_at":"2026-05-11T09:03:57.000000Z"},{"id":20516298,"change_date":"2026-04-30 21:41:00","inspection_id":"87726927","insp_unit_id":"213317905","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"TRUK","insp_unit_company":"85077","insp_unit_license":"E931801","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5364EM288577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:58.000000Z","updated_at":"2026-05-11T09:03:57.000000Z"}]},{"id":10438657,"change_date":"2025-12-15 21:39:00","inspection_id":"86570661","dot_number":"2833432","report_state":"MI","report_number":"ZASTM01997","insp_date":"2025-12-11 00:00:00","insp_start_time":"1420","insp_end_time":"1439","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TRADERS POINT @ US-2","county_code_state":"MI","county_code":"153","insp_level_id":"3","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":"N","pen_cen_match":null,"final_status_date":"2025-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1253577","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2025-12-15 21:39:00","snet_input_date":"2025-12-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:43.000000Z","updated_at":"2025-12-26T10:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17463018,"change_date":"2025-12-15 21:39:00","inspection_id":"86570661","insp_unit_id":"210614482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD60822","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWJAARX8J645063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:36.000000Z","updated_at":"2025-12-26T10:01:05.000000Z"}]},{"id":9888625,"change_date":"2025-10-08 21:40:00","inspection_id":"85992508","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01658","insp_date":"2025-10-07 00:00:00","insp_start_time":"1235","insp_end_time":"1304","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28EB @ M-117","county_code_state":"MI","county_code":"095","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-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1245295","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:49.000000Z","updated_at":"2025-10-12T10:01:06.000000Z","inspection_violations":[{"id":16304755,"change_date":"2025-10-08 21:40:00","inspection_id":"85992508","insp_violation_id":"269178538","seq_no":"1","part_no":"392","part_no_section":"2-DMOVE","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-10-11T10:18:06.000000Z","updated_at":"2025-10-12T10:16:21.000000Z","normalized_code":"3922DMOVE"}],"inspection_per_units":[{"id":16407014,"change_date":"2025-10-08 21:40:00","inspection_id":"85992508","insp_unit_id":"209365711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD60807","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ49425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:25.000000Z"},{"id":16407015,"change_date":"2025-10-08 21:40:00","inspection_id":"85992508","insp_unit_id":"209365712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILK","insp_unit_company":null,"insp_unit_license":"E849114","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5362EM288576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:25.000000Z"}]},{"id":8962916,"change_date":"2025-06-23 21:41:00","inspection_id":"85019732","dot_number":"2833432","report_state":"MI","report_number":"BROWP02524","insp_date":"2025-06-18 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-2 & M-77","county_code_state":"MI","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LOUISIANA PACIFIC","shipping_paper_number":"47655","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1226609","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:36.000000Z","updated_at":"2025-06-28T10:00:36.000000Z","inspection_violations":[{"id":14395654,"change_date":"2025-06-23 21:41:00","inspection_id":"85019732","insp_violation_id":"266988585","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207510087","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:59.000000Z","updated_at":"2025-06-27T10:17:55.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14692931,"change_date":"2025-06-23 21:41:00","inspection_id":"85019732","insp_unit_id":"207510087","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"122","insp_unit_license":"BD60807","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ494250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:10.000000Z"},{"id":14692932,"change_date":"2025-06-23 21:41:00","inspection_id":"85019732","insp_unit_id":"207510088","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILKE","insp_unit_company":"002","insp_unit_license":"E849114","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5362EM288576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:10.000000Z"}]},{"id":8921432,"change_date":"2025-06-17 21:41:00","inspection_id":"84975561","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ99299","insp_date":"2025-06-17 00:00:00","insp_start_time":"0853","insp_end_time":"0913","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77SB @ MEAD RD","county_code_state":"MI","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"224133908104","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":"2025-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"156000","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":"1225799","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:57.000000Z","updated_at":"2025-06-22T10:00:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14619435,"change_date":"2025-06-17 21:41:00","inspection_id":"84975561","insp_unit_id":"207429689","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BD60815","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALAVX5PU84578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:06.000000Z","updated_at":"2025-06-22T09:45:57.000000Z"},{"id":14619436,"change_date":"2025-06-17 21:41:00","inspection_id":"84975561","insp_unit_id":"207429690","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"E974164","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4LFE5230X53527618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:06.000000Z","updated_at":"2025-06-22T09:45:57.000000Z"}]},{"id":8873304,"change_date":"2025-06-11 21:42:00","inspection_id":"84924349","dot_number":"2833432","report_state":"MI","report_number":"ZASTM01882","insp_date":"2025-06-10 00:00:00","insp_start_time":"0820","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-117 COUNTY LINE","county_code_state":"MI","county_code":"095","insp_level_id":"1","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":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42: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":"1224665","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","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:40.000000Z","inspection_violations":[{"id":14217461,"change_date":"2025-06-11 21:42:00","inspection_id":"84924349","insp_violation_id":"266785455","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207334535","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:36.000000Z","updated_at":"2025-06-17T10:17:43.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":14533001,"change_date":"2025-06-11 21:42:00","inspection_id":"84924349","insp_unit_id":"207334535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"09","insp_unit_license":"BD13135","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHALCK27PX79710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:55.000000Z"}]},{"id":8779921,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","dot_number":"2833432","report_state":"MI","report_number":"BROWP02487","insp_date":"2025-05-28 00:00:00","insp_start_time":"0935","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28 SENEY REST AREA\/CUT OUT","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2025-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"16","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223464","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:08.000000Z","updated_at":"2025-06-04T10:01:08.000000Z","inspection_violations":[{"id":14033544,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576878","seq_no":"1","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39375GTAOW"},{"id":14033545,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576879","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"3922SLLED"},{"id":14033546,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576880","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":14033547,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576881","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4529666","created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39617CPI"},{"id":14033548,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576882","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207152107","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39617CPI"},{"id":14033549,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576883","seq_no":"6","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"207152107","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39395A1"},{"id":14033550,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576884","seq_no":"7","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39345DB"},{"id":14033551,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576885","seq_no":"8","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"3963A1BALAC"},{"id":14033552,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576886","seq_no":"9","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39345DB"},{"id":14033553,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576887","seq_no":"10","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39345DB"},{"id":14033554,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576888","seq_no":"11","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4529666","created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"3963A1BALAC"},{"id":14033555,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576889","seq_no":"12","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39345DBAAL"},{"id":14033556,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576890","seq_no":"13","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39348ABIBD"},{"id":14033557,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576891","seq_no":"14","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39348ABIBD"},{"id":14033558,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576892","seq_no":"15","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"39343DB"},{"id":14033559,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_violation_id":"266576893","seq_no":"16","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"2","insp_unit_id":"207152108","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":14364729,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_unit_id":"207152107","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"322","insp_unit_license":"BD60883","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:49.000000Z"},{"id":14364730,"change_date":"2025-05-30 21:40:00","inspection_id":"84825477","insp_unit_id":"207152108","insp_unit_type_id":"15","insp_unit_number":"2","insp_unit_make":"TTSI","insp_unit_company":"NONE","insp_unit_license":"E174236","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5078K1223257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:49.000000Z"}]},{"id":6423845,"change_date":"2024-09-17 21:45:00","inspection_id":"82337389","dot_number":"2833432","report_state":"MI","report_number":"STOLJ99549","insp_date":"2024-08-08 00:00:00","insp_start_time":"0840","insp_end_time":"0903","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M117 NORTH OF BROWN","county_code_state":"MI","county_code":"097","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-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1189347","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":"02833432","upload_search_indicator":null,"census_search_date":"2024-08-08 21:42:00","snet_input_date":"2024-08-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:16.000000Z","updated_at":"2025-03-17T20:30:16.000000Z","inspection_violations":[{"id":9974364,"change_date":"2024-09-17 21:45:00","inspection_id":"82337389","insp_violation_id":"261872253","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:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10353000,"change_date":"2024-09-17 21:45:00","inspection_id":"82337389","insp_unit_id":"202985802","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"75","insp_unit_license":"BC30380","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPALU0X25D848759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"}]},{"id":6046750,"change_date":"2024-06-26 21:43:00","inspection_id":"81932879","dot_number":"2833432","report_state":"MI","report_number":"LAUEJ01611","insp_date":"2024-06-20 00:00:00","insp_start_time":"1111","insp_end_time":"1224","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2\/ US 41","county_code_state":"MI","county_code":"041","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-06-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1183414","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":"02833432","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":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:36.000000Z","updated_at":"2025-03-17T20:22:36.000000Z","inspection_violations":[{"id":9379435,"change_date":"2024-06-26 21:43:00","inspection_id":"81932879","insp_violation_id":"260328704","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201606679","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4388620","created_at":"2025-03-17T21:51:21.000000Z","updated_at":"2025-03-17T21:51:21.000000Z","normalized_code":"3922"},{"id":9379436,"change_date":"2024-06-26 21:43:00","inspection_id":"81932879","insp_violation_id":"260328705","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"201606679","insp_violation_category_id":"23","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":"39375C"}],"inspection_per_units":[{"id":9738935,"change_date":"2024-06-26 21:43:00","inspection_id":"81932879","insp_unit_id":"201606678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"122","insp_unit_license":"BD60807","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ494250","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":9738936,"change_date":"2024-06-26 21:43:00","inspection_id":"81932879","insp_unit_id":"201606679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILKE","insp_unit_company":"00","insp_unit_license":"E849114","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5362EM288576","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":5030376,"change_date":"2024-02-12 21:41:00","inspection_id":"80826632","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01395","insp_date":"2024-02-09 00:00:00","insp_start_time":"0756","insp_end_time":"0904","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZELLAR EXCAVATING","county_code_state":"MI","county_code":"153","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-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1164399","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-12 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[{"id":7750896,"change_date":"2024-02-12 21:41:00","inspection_id":"80826632","insp_violation_id":"257788087","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"199379947","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39351"},{"id":7750897,"change_date":"2024-02-12 21:41:00","inspection_id":"80826632","insp_violation_id":"257788088","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199379947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8097255,"change_date":"2024-02-12 21:41:00","inspection_id":"80826632","insp_unit_id":"199379947","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD23710","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWDB0XX1J868353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":5030385,"change_date":"2024-02-12 21:41:00","inspection_id":"80826641","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01396","insp_date":"2024-02-09 00:00:00","insp_start_time":"0936","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZELLAR EXCAVATING","county_code_state":"MI","county_code":"153","insp_level_id":"1","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-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1164381","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-12 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8097270,"change_date":"2024-02-12 21:41:00","inspection_id":"80826641","insp_unit_id":"199379963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"50","insp_unit_license":"BC80162","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X5ND786513","insp_unit_decal":"Y","insp_unit_decal_number":"33686097","created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":5030386,"change_date":"2024-02-12 21:41:00","inspection_id":"80826642","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01397","insp_date":"2024-02-09 00:00:00","insp_start_time":"1010","insp_end_time":"1048","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZELLAR EXCAVATING","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1164396","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-12 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8097271,"change_date":"2024-02-12 21:41:00","inspection_id":"80826642","insp_unit_id":"199379964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"58","insp_unit_license":"BC80163","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7ND786514","insp_unit_decal":"Y","insp_unit_decal_number":"33686098","created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":5030387,"change_date":"2024-02-12 21:41:00","inspection_id":"80826643","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01398","insp_date":"2024-02-09 00:00:00","insp_start_time":"1140","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZELLAR EXCAVATING","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"61000","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":"1164307","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-12 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[{"id":7750916,"change_date":"2024-02-12 21:41:00","inspection_id":"80826643","insp_violation_id":"257788108","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199379965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8097272,"change_date":"2024-02-12 21:41:00","inspection_id":"80826643","insp_unit_id":"199379965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17","insp_unit_license":"BC80854","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X45J101966","insp_unit_decal":"Y","insp_unit_decal_number":"33686099","created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":5030388,"change_date":"2024-02-12 21:41:00","inspection_id":"80826644","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01399","insp_date":"2024-02-09 00:00:00","insp_start_time":"1330","insp_end_time":"1401","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZELLAR EXCAVATING","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"1164403","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-12 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8097273,"change_date":"2024-02-12 21:41:00","inspection_id":"80826644","insp_unit_id":"199379966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"322","insp_unit_license":"BC80192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"Y","insp_unit_decal_number":"33686100","created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":4997963,"change_date":"2024-02-07 21:41:00","inspection_id":"80791118","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01389","insp_date":"2024-02-06 00:00:00","insp_start_time":"1034","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-117SB @ CTY LINE","county_code_state":"MI","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73800","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":"1163622","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-07 21:41:00","snet_input_date":"2024-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":7698262,"change_date":"2024-02-07 21:41:00","inspection_id":"80791118","insp_violation_id":"257712235","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":"X4318262","created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"},{"id":7698263,"change_date":"2024-02-07 21:41:00","inspection_id":"80791118","insp_violation_id":"257712236","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"199312421","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"393104F3"}],"inspection_per_units":[{"id":8044442,"change_date":"2024-02-07 21:41:00","inspection_id":"80791118","insp_unit_id":"199312420","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD23710","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWDB0XX1J868353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"},{"id":8044443,"change_date":"2024-02-07 21:41:00","inspection_id":"80791118","insp_unit_id":"199312421","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E102663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK523XG1034648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4977384,"change_date":"2024-02-05 21:40:00","inspection_id":"80768646","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01388","insp_date":"2024-02-02 00:00:00","insp_start_time":"1425","insp_end_time":"1607","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-123SB @ CTY RD 510","county_code_state":"MI","county_code":"095","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"1163003","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":7666938,"change_date":"2024-02-05 21:40:00","inspection_id":"80768646","insp_violation_id":"257666456","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":"X4316205","created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3922"},{"id":7666939,"change_date":"2024-02-05 21:40:00","inspection_id":"80768646","insp_violation_id":"257666457","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:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8010921,"change_date":"2024-02-05 21:40:00","inspection_id":"80768646","insp_unit_id":"199269571","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"58","insp_unit_license":"BC80163","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7ND786514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"},{"id":8010922,"change_date":"2024-02-05 21:40:00","inspection_id":"80768646","insp_unit_id":"199269572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTSI","insp_unit_company":null,"insp_unit_license":"E454186","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5073J1223236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"}]},{"id":4664408,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","dot_number":"2833432","report_state":"MI","report_number":"GUTHG02491","insp_date":"2023-12-18 00:00:00","insp_start_time":"1130","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RAPID RIVER CUT OUTS","county_code_state":"MI","county_code":"041","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LOUISIANA PACIFIC CORPORATION","shipping_paper_number":"43891","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-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123600","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":"1157791","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2023-12-19 21:41:00","snet_input_date":"2023-12-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-19 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:21.000000Z","updated_at":"2025-03-17T19:55:21.000000Z","inspection_violations":[{"id":7211086,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_violation_id":"256964630","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":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922"},{"id":7211087,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_violation_id":"256964631","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198577089","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3939A"},{"id":7211088,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_violation_id":"256964632","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198577090","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"39375C"},{"id":7211089,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_violation_id":"256964633","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198577090","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"39375C"},{"id":7211090,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_violation_id":"256964634","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198577090","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7502269,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_unit_id":"198577089","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"NONE","insp_unit_license":"BC80883","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKXAMCG7GPGY1241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:04.000000Z","updated_at":"2025-03-17T23:03:04.000000Z"},{"id":7502270,"change_date":"2023-12-19 21:41:00","inspection_id":"80426503","insp_unit_id":"198577090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"004","insp_unit_license":"D979583","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5364EM288577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:04.000000Z","updated_at":"2025-03-17T23:03:04.000000Z"}]},{"id":4643617,"change_date":"2023-12-15 21:38:00","inspection_id":"80403717","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01369","insp_date":"2023-12-14 00:00:00","insp_start_time":"1338","insp_end_time":"1358","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-123NB @ CTY RD 510","county_code_state":"MI","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"222114119604","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-12-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"73800","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":"1157508","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":"02833432","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":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","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":[],"inspection_per_units":[{"id":7468546,"change_date":"2023-12-15 21:38:00","inspection_id":"80403717","insp_unit_id":"198534386","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"77","insp_unit_license":"BA32140","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWDB0XX1J868353","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":7468547,"change_date":"2023-12-15 21:38:00","inspection_id":"80403717","insp_unit_id":"198534387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E102663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK523XG1034648","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":3914139,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","dot_number":"2833432","report_state":"MI","report_number":"STOLJ00623","insp_date":"2023-09-05 00:00:00","insp_start_time":"1325","insp_end_time":"1508","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZELLAR SANITATION","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1144434","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2023-09-06 21:43:00","snet_input_date":"2023-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-06 21:43:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:07.000000Z","updated_at":"2025-03-17T19:40:07.000000Z","inspection_violations":[{"id":6047936,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","insp_violation_id":"255110253","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"196923035","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"393100B"},{"id":6047937,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","insp_violation_id":"255110254","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196923035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"3922"},{"id":6047938,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","insp_violation_id":"255110255","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196923035","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"3939A"},{"id":6047939,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","insp_violation_id":"255110256","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"196923035","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"393207A"},{"id":6047940,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","insp_violation_id":"255110257","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196923035","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":6293535,"change_date":"2023-09-06 21:43:00","inspection_id":"79597459","insp_unit_id":"196923035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"37","insp_unit_license":"BD13119","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPAMB0XX2D584218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:52.000000Z","updated_at":"2025-03-17T22:52:52.000000Z"}]},{"id":3653759,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01302","insp_date":"2023-08-01 00:00:00","insp_start_time":"1028","insp_end_time":"1142","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77SB @ SAFETY TURNOFF","county_code_state":"MI","county_code":"153","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"71001","viol_total":"10","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1137921","transaction_code":"C","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[{"id":5632648,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952418","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:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3922"},{"id":5632649,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952419","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196787947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3939A"},{"id":5632650,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952420","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196787947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3939A"},{"id":5632651,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952421","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196787947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3939A"},{"id":5632652,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952422","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196787947","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39347E"},{"id":5632653,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952423","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196787947","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39353B"},{"id":5632654,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952424","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196787948","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39347E"},{"id":5632655,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952425","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196787948","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39353B"},{"id":5632656,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952426","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196787948","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4256293","created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"393207A"},{"id":5632657,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_violation_id":"254952427","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196787948","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5874964,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_unit_id":"196787947","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17","insp_unit_license":"BC80854","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X45J101966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:22.000000Z","updated_at":"2025-03-17T22:49:22.000000Z"},{"id":5874965,"change_date":"2023-08-29 21:42:00","inspection_id":"79306518","insp_unit_id":"196787948","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"C540608","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M4875RC3678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:22.000000Z","updated_at":"2025-03-17T22:49:22.000000Z"}]},{"id":3118616,"change_date":"2023-05-23 21:42:00","inspection_id":"78704548","dot_number":"2833432","report_state":"MI","report_number":"LAUEJ01336","insp_date":"2023-05-22 00:00:00","insp_start_time":"1100","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2 \/ US 41","county_code_state":"MI","county_code":"041","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":"2023-05-23 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":"1127387","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2023-05-23 21:42:00","snet_input_date":"2023-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-23 21:42:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:38.000000Z","updated_at":"2025-03-17T19:24:38.000000Z","inspection_violations":[{"id":4800588,"change_date":"2023-05-23 21:42:00","inspection_id":"78704548","insp_violation_id":"253022644","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":"X4214016","created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5016241,"change_date":"2023-05-23 21:42:00","inspection_id":"78704548","insp_unit_id":"195093237","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC80192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"},{"id":5016242,"change_date":"2023-05-23 21:42:00","inspection_id":"78704548","insp_unit_id":"195093238","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"E354549","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M536152961103120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"}]},{"id":3043536,"change_date":"2023-05-15 21:42:00","inspection_id":"78619884","dot_number":"2833432","report_state":"MI","report_number":"STOLJ00577","insp_date":"2023-05-10 00:00:00","insp_start_time":"0930","insp_end_time":"0948","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"117 @ COUNTY LINE","county_code_state":"MI","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NO #","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-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1125725","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":"02833432","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":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","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":4674899,"change_date":"2023-05-15 21:42:00","inspection_id":"78619884","insp_violation_id":"252828137","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:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4896180,"change_date":"2023-05-15 21:42:00","inspection_id":"78619884","insp_unit_id":"194928086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"09","insp_unit_license":"BA88480","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHALCK27PX79710","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":2818058,"change_date":"2023-04-17 21:41:00","inspection_id":"78364848","dot_number":"2833432","report_state":"MI","report_number":"WERNR01213","insp_date":"2023-04-14 00:00:00","insp_start_time":"1200","insp_end_time":"1243","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2 NEAR M41","county_code_state":"MI","county_code":"041","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":"2023-04-17 21:41: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":"1122022","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2023-04-17 21:41:00","snet_input_date":"2023-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:34.000000Z","updated_at":"2025-03-17T19:18:34.000000Z","inspection_violations":[{"id":4324052,"change_date":"2023-04-17 21:41:00","inspection_id":"78364848","insp_violation_id":"252259613","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":"X4192255","created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4535579,"change_date":"2023-04-17 21:41:00","inspection_id":"78364848","insp_unit_id":"194422163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC80193","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"P362139847638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"},{"id":4535580,"change_date":"2023-04-17 21:41:00","inspection_id":"78364848","insp_unit_id":"194422164","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILKE","insp_unit_company":null,"insp_unit_license":"D979593","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5360EM288575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"}]},{"id":2585849,"change_date":"2023-03-15 21:42:00","inspection_id":"78100630","dot_number":"2833432","report_state":"MI","report_number":"GUTHG02304","insp_date":"2023-03-14 00:00:00","insp_start_time":"1120","insp_end_time":"1222","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M117 SAFETY TURN OUT NEAR M28","county_code_state":"MI","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"164100","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":"1117631","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2023-03-15 21:42:00","snet_input_date":"2023-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-15 21:42:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:27.000000Z","updated_at":"2025-03-17T19:14:27.000000Z","inspection_violations":[{"id":3976738,"change_date":"2023-03-15 21:42:00","inspection_id":"78100630","insp_violation_id":"251680932","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":"X4171354","created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"3922"},{"id":3976739,"change_date":"2023-03-15 21:42:00","inspection_id":"78100630","insp_violation_id":"251680933","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:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4162055,"change_date":"2023-03-15 21:42:00","inspection_id":"78100630","insp_unit_id":"193890590","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"50","insp_unit_license":"BC80162","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X5ND786513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"},{"id":4162056,"change_date":"2023-03-15 21:42:00","inspection_id":"78100630","insp_unit_id":"193890591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"NONE","insp_unit_license":"E544299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5077J1223248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"}]},{"id":1625078,"change_date":"2022-10-28 21:39:00","inspection_id":"77002646","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01151","insp_date":"2022-10-27 00:00:00","insp_start_time":"0840","insp_end_time":"0856","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77NB @ DUTCH FRED LAKE RD","county_code_state":"MI","county_code":"153","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-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1100180","transaction_code":"A","transaction_date":"2022-10-27 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2022-10-28 21:39:00","snet_input_date":"2022-10-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-28 21:39:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:39.000000Z","updated_at":"2025-03-17T18:56:39.000000Z","inspection_violations":[{"id":2550882,"change_date":"2022-10-28 21:39:00","inspection_id":"77002646","insp_violation_id":"249312132","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:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2614450,"change_date":"2022-10-28 21:39:00","inspection_id":"77002646","insp_unit_id":"191697301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC80192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:54.000000Z","updated_at":"2025-03-17T22:24:54.000000Z"},{"id":2614451,"change_date":"2022-10-28 21:39:00","inspection_id":"77002646","insp_unit_id":"191697302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTSI","insp_unit_company":null,"insp_unit_license":"E174236","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5078K1223257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:54.000000Z","updated_at":"2025-03-17T22:24:54.000000Z"}]},{"id":934135,"change_date":"2022-08-01 21:39:00","inspection_id":"76200788","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01094","insp_date":"2022-07-29 00:00:00","insp_start_time":"1145","insp_end_time":"1202","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-117SB @ CTY LINE","county_code_state":"MI","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80001","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":"1086207","transaction_code":"A","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-07-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","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":[],"inspection_per_units":[{"id":1503645,"change_date":"2022-08-01 21:39:00","inspection_id":"76200788","insp_unit_id":"190063604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC80193","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ494250","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":1503646,"change_date":"2022-08-01 21:39:00","inspection_id":"76200788","insp_unit_id":"190063605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D979594","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W91V5364EM288577","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":934101,"change_date":"2022-08-01 21:39:00","inspection_id":"76200751","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01091","insp_date":"2022-07-28 00:00:00","insp_start_time":"0939","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77SB @ RIVER RD","county_code_state":"MI","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"222114008702","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":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62001","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":"1086383","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":"02833432","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":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","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":1473665,"change_date":"2022-08-01 21:39:00","inspection_id":"76200751","insp_violation_id":"247431017","seq_no":"1","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"190063539","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":1503586,"change_date":"2022-08-01 21:39:00","inspection_id":"76200751","insp_unit_id":"190063538","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC80854","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X45J01966","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":1503587,"change_date":"2022-08-01 21:39:00","inspection_id":"76200751","insp_unit_id":"190063539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E102663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK523XG1034648","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":697192,"change_date":"2022-06-27 21:40:00","inspection_id":"75923293","dot_number":"2833432","report_state":"MI","report_number":"BYARC00606","insp_date":"2022-06-21 00:00:00","insp_start_time":"1317","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M94 \/ DUKES RD","county_code_state":"MI","county_code":"103","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1081196","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1093959,"change_date":"2022-06-27 21:40:00","inspection_id":"75923293","insp_violation_id":"246726340","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:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3922"},{"id":1093960,"change_date":"2022-06-27 21:40:00","inspection_id":"75923293","insp_violation_id":"246726341","seq_no":"2","part_no":"393","part_no_section":"116","insp_viol_unit":"2","insp_unit_id":"189470819","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"393116"}],"inspection_per_units":[{"id":1119992,"change_date":"2022-06-27 21:40:00","inspection_id":"75923293","insp_unit_id":"189470818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"322","insp_unit_license":"BC80192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:04.000000Z","updated_at":"2025-03-17T22:15:04.000000Z"},{"id":1119993,"change_date":"2022-06-27 21:40:00","inspection_id":"75923293","insp_unit_id":"189470819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"E174236","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5078K1223257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:04.000000Z","updated_at":"2025-03-17T22:15:04.000000Z"}]},{"id":515468,"change_date":"2022-06-09 21:42:00","inspection_id":"75707759","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01057","insp_date":"2022-05-27 00:00:00","insp_start_time":"0807","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77SB @ SAFETY TURNOFF","county_code_state":"MI","county_code":"153","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1077623","transaction_code":"C","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2022-05-31 21:41:00","snet_input_date":"2022-05-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:43.000000Z","updated_at":"2025-03-17T18:36:43.000000Z","inspection_violations":[{"id":817254,"change_date":"2022-06-09 21:42:00","inspection_id":"75707759","insp_violation_id":"246331624","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:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":829575,"change_date":"2022-06-09 21:42:00","inspection_id":"75707759","insp_unit_id":"189144089","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC80192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X4NJ496510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:19.000000Z","updated_at":"2025-03-17T22:13:19.000000Z"},{"id":829576,"change_date":"2022-06-09 21:42:00","inspection_id":"75707759","insp_unit_id":"189144090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"E174236","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5078K1223257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:19.000000Z","updated_at":"2025-03-17T22:13:19.000000Z"}]},{"id":71911,"change_date":"2022-03-30 21:40:00","inspection_id":"75176051","dot_number":"2833432","report_state":"MI","report_number":"CAMEJ01017","insp_date":"2022-03-29 00:00:00","insp_start_time":"1452","insp_end_time":"1534","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28WB @ SENEY REST AREA","county_code_state":"MI","county_code":"153","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","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":"1069694","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2022-03-30 21:40:00","snet_input_date":"2022-03-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-30 21:40:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:48.000000Z","updated_at":"2025-03-17T18:28:48.000000Z","inspection_violations":[{"id":105034,"change_date":"2022-03-30 21:40:00","inspection_id":"75176051","insp_violation_id":"244862034","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":"X3986565","created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":116755,"change_date":"2022-03-30 21:40:00","inspection_id":"75176051","insp_unit_id":"187897462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BB98411","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPFL60X2YN50187","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:56.000000Z","updated_at":"2025-03-17T22:08:56.000000Z"},{"id":116756,"change_date":"2022-03-30 21:40:00","inspection_id":"75176051","insp_unit_id":"187897463","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E082067","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI0017A386R092793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:56.000000Z","updated_at":"2025-03-17T22:08:56.000000Z"}]},{"id":19702,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","dot_number":"2833432","report_state":"MI","report_number":"LAUEJ01057","insp_date":"2022-03-21 00:00:00","insp_start_time":"1130","insp_end_time":"1327","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FISHER RD \/ TROUT LAKE RD","county_code_state":"MI","county_code":"097","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-03-22 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1068517","transaction_code":"A","transaction_date":"2022-03-21 00:00:00","upload_date":"2022-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02833432","upload_search_indicator":null,"census_search_date":"2022-03-22 21:31:00","snet_input_date":"2022-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-22 21:31:00","insp_carrier_name":"ZELLAR EXCAVATING AND SONS INC","insp_carrier_street":"2725W US HIGHWAY 2","insp_carrier_city":"GULLIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49840","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:48.000000Z","updated_at":"2025-03-17T18:27:48.000000Z","inspection_violations":[{"id":27231,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","insp_violation_id":"244702666","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":"X4031611","created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"3922"},{"id":27232,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","insp_violation_id":"244702667","seq_no":"2","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"187754650","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4031765","created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"39375A1"},{"id":27233,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","insp_violation_id":"244702668","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"187754650","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"39375C"},{"id":27234,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","insp_violation_id":"244702669","seq_no":"4","part_no":"393","part_no_section":"116","insp_viol_unit":"1","insp_unit_id":"187754649","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"393116"}],"inspection_per_units":[{"id":31756,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","insp_unit_id":"187754649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BB98411","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPFL60X2YN501870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:27.000000Z","updated_at":"2025-03-17T22:08:27.000000Z"},{"id":31757,"change_date":"2022-03-22 21:31:00","inspection_id":"75106700","insp_unit_id":"187754650","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"E082067","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI0017A386R092793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:27.000000Z","updated_at":"2025-03-17T22:08:27.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2833432\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2833432\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2833432\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2833432\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}