{"current_page":1,"data":[{"id":11983777,"change_date":"2026-05-22 08:06:00","inspection_id":"87921125","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01766","insp_date":"2026-05-21 00:00:00","insp_start_time":"0652","insp_end_time":"0726","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 08:06:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3376409","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2026-05-22 08:06:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 08:06:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-25T09:40:59.000000Z","updated_at":"2026-06-02T09:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20834092,"change_date":"2026-05-22 08:06:00","inspection_id":"87921125","insp_unit_id":"213684779","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"28","insp_unit_license":"BC80869","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2N187Y5KW02879","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:35.000000Z","updated_at":"2026-06-02T09:02:57.000000Z"}]},{"id":11836850,"change_date":"2026-05-06 21:40:00","inspection_id":"87772229","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01754","insp_date":"2026-05-06 00:00:00","insp_start_time":"0942","insp_end_time":"0951","registration_date":null,"region":"ES","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-06 21:40: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":"3270559","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2026-05-06 21:40:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:12.000000Z","updated_at":"2026-05-16T13:24:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20585683,"change_date":"2026-05-06 21:40:00","inspection_id":"87772229","insp_unit_id":"213406862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC80869","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2N187Y5KW028790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:18.000000Z","updated_at":"2026-05-16T12:31:29.000000Z"}]},{"id":11794055,"change_date":"2026-04-30 21:41:00","inspection_id":"87726877","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00811","insp_date":"2026-04-30 00:00:00","insp_start_time":"1153","insp_end_time":"1207","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M117 @ CNTY LINE","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":"2026-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1268448","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":"02637583","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 SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","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":[{"id":20508255,"change_date":"2026-04-30 21:41:00","inspection_id":"87726877","insp_violation_id":"273965471","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:56.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20516217,"change_date":"2026-04-30 21:41:00","inspection_id":"87726877","insp_unit_id":"213317796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"106","insp_unit_license":"BE39251","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYFE1PDUL3960","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":11782100,"change_date":"2026-04-29 21:40:00","inspection_id":"87713448","dot_number":"2637583","report_state":"MI","report_number":"ZASTM02123","insp_date":"2026-04-27 00:00:00","insp_start_time":"1420","insp_end_time":"1540","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1267874","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2026-04-29 21:40:00","snet_input_date":"2026-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-29 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-02T09:41:05.000000Z","updated_at":"2026-05-10T09:31:05.000000Z","inspection_violations":[{"id":20487920,"change_date":"2026-04-29 21:40:00","inspection_id":"87713448","insp_violation_id":"273936605","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:48.000000Z","updated_at":"2026-05-10T09:41:41.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":20496572,"change_date":"2026-04-29 21:40:00","inspection_id":"87713448","insp_unit_id":"213292565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:20.000000Z","updated_at":"2026-05-10T09:03:46.000000Z"}]},{"id":11665583,"change_date":"2026-04-16 21:41:00","inspection_id":"87595912","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01736","insp_date":"2026-04-16 00:00:00","insp_start_time":"1202","insp_end_time":"1304","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CTY RD 458EB @ CTY RD 427","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1266648","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:36.000000Z","updated_at":"2026-04-27T09:31:36.000000Z","inspection_violations":[{"id":20262117,"change_date":"2026-04-16 21:41:00","inspection_id":"87595912","insp_violation_id":"273649602","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4632667","created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":20292632,"change_date":"2026-04-16 21:41:00","inspection_id":"87595912","insp_unit_id":"213054173","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"116","insp_unit_license":"BD23715","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2K195C51M018285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"}]},{"id":11310029,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01724","insp_date":"2026-03-05 00:00:00","insp_start_time":"1004","insp_end_time":"1133","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":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54001","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1261515","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2026-03-06 21:42:00","snet_input_date":"2026-03-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-06 21:42:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-09T09:42:39.000000Z","updated_at":"2026-03-17T09:31:06.000000Z","inspection_violations":[{"id":19029254,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252647","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"3922SLLS2"},{"id":19029255,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252648","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"39617CPI"},{"id":19029256,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252649","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"39395F"},{"id":19029257,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252650","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"3963A1BOS"},{"id":19029258,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252651","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"39347E"},{"id":19029259,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252652","seq_no":"6","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"39353BB"},{"id":19029260,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252653","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"39347E"},{"id":19029261,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_violation_id":"272252654","seq_no":"8","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"212015057","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":19350592,"change_date":"2026-03-06 21:42:00","inspection_id":"87226149","insp_unit_id":"212015057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"116","insp_unit_license":"BD23715","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2K195C51M018285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:26.000000Z","updated_at":"2026-03-17T09:03:32.000000Z"}]},{"id":10297683,"change_date":"2025-12-04 21:38:00","inspection_id":"86423241","dot_number":"2637583","report_state":"MI","report_number":"ZASTM01996","insp_date":"2025-11-24 00:00:00","insp_start_time":"1314","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77 @ MORRISON","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1252121","transaction_code":"C","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:40.000000Z","updated_at":"2025-12-08T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17293108,"change_date":"2025-12-04 21:38:00","inspection_id":"86423241","insp_unit_id":"210416562","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"103","insp_unit_license":"BE33100","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCYXGDHC1193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:53.000000Z"}]},{"id":9867616,"change_date":"2025-10-06 21:41:00","inspection_id":"85970475","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00791","insp_date":"2025-10-03 00:00:00","insp_start_time":"1214","insp_end_time":"1353","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M28 @ M117 RDSIDE PK","county_code_state":"MI","county_code":"095","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":"2025-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1244808","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-10-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:55.000000Z","updated_at":"2025-10-10T10:01:27.000000Z","inspection_violations":[{"id":16258278,"change_date":"2025-10-06 21:41:00","inspection_id":"85970475","insp_violation_id":"269125499","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:20.000000Z","updated_at":"2025-10-10T10:17:12.000000Z","normalized_code":"3939ALHLI"},{"id":16258279,"change_date":"2025-10-06 21:41:00","inspection_id":"85970475","insp_violation_id":"269125500","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209323113","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:20.000000Z","updated_at":"2025-10-10T10:17:12.000000Z","normalized_code":"3939ALCL"},{"id":16258280,"change_date":"2025-10-06 21:41:00","inspection_id":"85970475","insp_violation_id":"269125501","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209323113","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:20.000000Z","updated_at":"2025-10-10T10:17:12.000000Z","normalized_code":"39347E"},{"id":16258281,"change_date":"2025-10-06 21:41:00","inspection_id":"85970475","insp_violation_id":"269125502","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"209323113","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:20.000000Z","updated_at":"2025-10-10T10:17:12.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":16367655,"change_date":"2025-10-06 21:41:00","inspection_id":"85970475","insp_unit_id":"209323113","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"29","insp_unit_license":"BC80174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR3GC7LM006358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:50.000000Z","updated_at":"2025-10-10T09:46:53.000000Z"}]},{"id":9238148,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","dot_number":"2637583","report_state":"MI","report_number":"ZASTM01902","insp_date":"2025-07-22 00:00:00","insp_start_time":"1343","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2\/DAYS RIVER","county_code_state":"MI","county_code":"041","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":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1231746","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:52.000000Z","inspection_violations":[{"id":14956343,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629165","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"39617CPI"},{"id":14956344,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629166","seq_no":"2","part_no":"393","part_no_section":"47A-BCLMBD","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"39347ABCLMBD"},{"id":14956345,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629167","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"39347E"},{"id":14956346,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629168","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"39347E"},{"id":14956347,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629169","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"39347E"},{"id":14956348,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629170","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"39347E"},{"id":14956349,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629171","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4546773","created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"3963A1BOS"},{"id":14956350,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_violation_id":"267629172","seq_no":"8","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"208060662","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":15201544,"change_date":"2025-07-24 21:41:00","inspection_id":"85309255","insp_unit_id":"208060662","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"28","insp_unit_license":"BC80869","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2N187Y5KW028790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:05.000000Z"}]},{"id":8963002,"change_date":"2025-06-23 21:41:00","inspection_id":"85019823","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00763","insp_date":"2025-06-18 00:00:00","insp_start_time":"1400","insp_end_time":"1436","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2 @ MACK.\/SCHOOLCRAFT LINE","county_code_state":"MI","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PUBLIC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1226651","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":"02637583","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 SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14395844,"change_date":"2025-06-23 21:41:00","inspection_id":"85019823","insp_violation_id":"266988810","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207510252","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:56.000000Z","normalized_code":"39021TB2DOT"},{"id":14395845,"change_date":"2025-06-23 21:41:00","inspection_id":"85019823","insp_violation_id":"266988811","seq_no":"2","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"207510252","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:56.000000Z","normalized_code":"39355D1B"}],"inspection_per_units":[{"id":14693074,"change_date":"2025-06-23 21:41:00","inspection_id":"85019823","insp_unit_id":"207510252","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"121","insp_unit_license":"BC45458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWNAZT8BJ424721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:11.000000Z"}]},{"id":8963181,"change_date":"2025-06-23 21:41:00","inspection_id":"85020011","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00761","insp_date":"2025-06-18 00:00:00","insp_start_time":"0956","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M77 NORTH OF SHEPPARD ST","county_code_state":"MI","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PUBLUC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226722","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":"02637583","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 SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14396258,"change_date":"2025-06-23 21:41:00","inspection_id":"85020011","insp_violation_id":"266989319","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14693383,"change_date":"2025-06-23 21:41:00","inspection_id":"85020011","insp_unit_id":"207510592","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"103","insp_unit_license":"BC80861","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCYXGDHC1193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:12.000000Z"}]},{"id":8779957,"change_date":"2025-05-30 21:40:00","inspection_id":"84825518","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01597","insp_date":"2025-05-30 00:00:00","insp_start_time":"0908","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E VICTORY WAY @ NEWBERRY AVE","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":"2025-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1223583","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","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":14033639,"change_date":"2025-05-30 21:40:00","inspection_id":"84825518","insp_violation_id":"266576995","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"3922SLLTL"},{"id":14033640,"change_date":"2025-05-30 21:40:00","inspection_id":"84825518","insp_violation_id":"266576996","seq_no":"2","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":"X4472925","created_at":"2025-06-02T10:17:14.000000Z","updated_at":"2025-06-03T10:17:32.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":14364792,"change_date":"2025-05-30 21:40:00","inspection_id":"84825518","insp_unit_id":"207152193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","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":8512917,"change_date":"2025-04-30 21:52:00","inspection_id":"84543974","dot_number":"2637583","report_state":"MI","report_number":"ZASTM01869","insp_date":"2025-04-28 00:00:00","insp_start_time":"0649","insp_end_time":"0710","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-2 @ M-117","county_code_state":"MI","county_code":"097","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-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"1219488","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:09.000000Z","updated_at":"2025-05-04T10:40:17.000000Z","inspection_violations":[{"id":13475391,"change_date":"2025-04-30 21:52:00","inspection_id":"84543974","insp_violation_id":"265929526","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4503096","created_at":"2025-05-02T11:42:06.000000Z","updated_at":"2025-05-03T11:17:19.000000Z","normalized_code":"39216AD"},{"id":13475392,"change_date":"2025-04-30 21:52:00","inspection_id":"84543974","insp_violation_id":"265929527","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206575851","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:42:06.000000Z","updated_at":"2025-05-03T11:17:19.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":13838807,"change_date":"2025-04-30 21:52:00","inspection_id":"84543974","insp_unit_id":"206575851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:24:55.000000Z","updated_at":"2025-05-04T10:12:54.000000Z"}]},{"id":8468543,"change_date":"2025-04-25 21:36:00","inspection_id":"84497094","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01574","insp_date":"2025-04-24 00:00:00","insp_start_time":"1151","insp_end_time":"1223","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CTY RD 458 @ CTY RD 383","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":"2025-04-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1219065","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-04-25 21:36:00","snet_input_date":"2025-04-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-25 21:36:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-28T10:14:20.000000Z","updated_at":"2025-04-29T10:02:34.000000Z","inspection_violations":[{"id":13387034,"change_date":"2025-04-25 21:36:00","inspection_id":"84497094","insp_violation_id":"265828940","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:43.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":13759226,"change_date":"2025-04-25 21:36:00","inspection_id":"84497094","insp_unit_id":"206489902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"120","insp_unit_license":"BC45456","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWNAZT6BJ424720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:28.000000Z"}]},{"id":8045812,"change_date":"2025-03-06 21:39:00","inspection_id":"84051891","dot_number":"2637583","report_state":"MI","report_number":"GUTHG02714","insp_date":"2025-03-05 00:00:00","insp_start_time":"1035","insp_end_time":"1126","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HWY SHOULDER NEAR HIAWATHA TRL","county_code_state":"MI","county_code":"097","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":"2025-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1212220","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2025-03-06 21:39:00","snet_input_date":"2025-03-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:23.000000Z","updated_at":"2025-03-17T21:05:23.000000Z","inspection_violations":[{"id":12573768,"change_date":"2025-03-06 21:39:00","inspection_id":"84051891","insp_violation_id":"264871774","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4490978","created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"3922SLLS4"},{"id":12573769,"change_date":"2025-03-06 21:39:00","inspection_id":"84051891","insp_violation_id":"264871775","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":12989652,"change_date":"2025-03-06 21:39:00","inspection_id":"84051891","insp_unit_id":"205662931","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:28.000000Z","updated_at":"2025-03-17T23:58:28.000000Z"}]},{"id":6971706,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00710","insp_date":"2024-10-15 00:00:00","insp_start_time":"1345","insp_end_time":"1424","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":"PUBLIC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1198247","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:25.000000Z","updated_at":"2025-03-17T20:41:25.000000Z","inspection_violations":[{"id":10872038,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","insp_violation_id":"262382716","seq_no":"1","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"203437333","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"3969D2FTF"},{"id":10872039,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","insp_violation_id":"262382717","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203437333","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39347E"},{"id":10872040,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","insp_violation_id":"262382718","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203437333","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39353B"},{"id":10872041,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","insp_violation_id":"262382719","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"203437333","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"3939ALLPL"},{"id":10872042,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","insp_violation_id":"262382720","seq_no":"5","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":11244555,"change_date":"2024-10-16 21:40:00","inspection_id":"82920725","insp_unit_id":"203437333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:23.000000Z","updated_at":"2025-03-17T23:39:23.000000Z"}]},{"id":6971707,"change_date":"2024-10-16 21:40:00","inspection_id":"82920726","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00711","insp_date":"2024-10-15 00:00:00","insp_start_time":"1445","insp_end_time":"1534","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":"PUBLIC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198201","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:25.000000Z","updated_at":"2025-03-17T20:41:25.000000Z","inspection_violations":[{"id":10872043,"change_date":"2024-10-16 21:40:00","inspection_id":"82920726","insp_violation_id":"262382721","seq_no":"1","part_no":"393","part_no_section":"47B-BMBCBD-SA","insp_viol_unit":"1","insp_unit_id":"203437334","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39347BBMBCBDSA"},{"id":10872044,"change_date":"2024-10-16 21:40:00","inspection_id":"82920726","insp_violation_id":"262382722","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"203437334","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39348ABIBD"},{"id":10872045,"change_date":"2024-10-16 21:40:00","inspection_id":"82920726","insp_violation_id":"262382723","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"203437334","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":11244556,"change_date":"2024-10-16 21:40:00","inspection_id":"82920726","insp_unit_id":"203437334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"121","insp_unit_license":"BC45458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWNAZT8BJ424721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:23.000000Z","updated_at":"2025-03-17T23:39:23.000000Z"}]},{"id":6971708,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00712","insp_date":"2024-10-15 00:00:00","insp_start_time":"1545","insp_end_time":"1631","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":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198328","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:25.000000Z","updated_at":"2025-03-17T20:41:25.000000Z","inspection_violations":[{"id":10872046,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","insp_violation_id":"262382724","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203437335","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39347E"},{"id":10872047,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","insp_violation_id":"262382725","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203437335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39353B"},{"id":10872048,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","insp_violation_id":"262382726","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203437335","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"39347E"},{"id":10872049,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","insp_violation_id":"262382727","seq_no":"4","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"203437335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"3963A1ALBV"},{"id":10872050,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","insp_violation_id":"262382728","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"203437335","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":11244557,"change_date":"2024-10-16 21:40:00","inspection_id":"82920727","insp_unit_id":"203437335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"29","insp_unit_license":"BC80174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR3GC7LM006358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:23.000000Z","updated_at":"2025-03-17T23:39:23.000000Z"}]},{"id":6971907,"change_date":"2024-10-16 21:40:00","inspection_id":"82920936","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01534","insp_date":"2024-10-15 00:00:00","insp_start_time":"1440","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"415 CHIPPEWA AVE","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-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198268","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:25.000000Z","updated_at":"2025-03-17T20:41:25.000000Z","inspection_violations":[{"id":10872457,"change_date":"2024-10-16 21:40:00","inspection_id":"82920936","insp_violation_id":"262383201","seq_no":"1","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"1","insp_unit_id":"203437703","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"393207ASUBL"},{"id":10872458,"change_date":"2024-10-16 21:40:00","inspection_id":"82920936","insp_violation_id":"262383202","seq_no":"2","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"1","insp_unit_id":"203437703","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:58:41.000000Z","updated_at":"2025-03-17T21:58:41.000000Z","normalized_code":"393207ASUBL"}],"inspection_per_units":[{"id":11244891,"change_date":"2024-10-16 21:40:00","inspection_id":"82920936","insp_unit_id":"203437703","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"103","insp_unit_license":"BC80861","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCYXGDHC1193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:23.000000Z","updated_at":"2025-03-17T23:39:23.000000Z"}]},{"id":6971908,"change_date":"2024-10-16 21:40:00","inspection_id":"82920937","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01535","insp_date":"2024-10-15 00:00:00","insp_start_time":"1525","insp_end_time":"1608","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"415 CHIPPEWA AVE","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-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198233","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:25.000000Z","updated_at":"2025-03-17T20:41:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11244892,"change_date":"2024-10-16 21:40:00","inspection_id":"82920937","insp_unit_id":"203437704","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC45456","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWNAZT6BJ424720","insp_unit_decal":"Y","insp_unit_decal_number":"34637207","created_at":"2025-03-17T23:39:23.000000Z","updated_at":"2025-03-17T23:39:23.000000Z"}]},{"id":6490088,"change_date":"2024-09-17 21:45:00","inspection_id":"82408203","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01505","insp_date":"2024-08-15 00:00:00","insp_start_time":"0833","insp_end_time":"0919","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEWBERRY DETACHMENT M-123","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":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-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1190362","transaction_code":"C","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10076867,"change_date":"2024-09-17 21:45:00","inspection_id":"82408203","insp_violation_id":"261859179","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202975474","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39347E"},{"id":10076868,"change_date":"2024-09-17 21:45:00","inspection_id":"82408203","insp_violation_id":"261859180","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202975474","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39353B"},{"id":10076869,"change_date":"2024-09-17 21:45:00","inspection_id":"82408203","insp_violation_id":"261859181","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10461670,"change_date":"2024-09-17 21:45:00","inspection_id":"82408203","insp_unit_id":"202975474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"}]},{"id":6586263,"change_date":"2024-08-28 21:42:00","inspection_id":"82510416","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01470","insp_date":"2024-06-25 00:00:00","insp_start_time":"1245","insp_end_time":"1401","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-117SB @ BROWN RD","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192254","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10239848,"change_date":"2024-08-28 21:42:00","inspection_id":"82510416","insp_violation_id":"261466882","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"39141A1"},{"id":10239849,"change_date":"2024-08-28 21:42:00","inspection_id":"82510416","insp_violation_id":"261466883","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4377113","created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"38323A2"},{"id":10239850,"change_date":"2024-08-28 21:42:00","inspection_id":"82510416","insp_violation_id":"261466884","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"202632499","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":10618214,"change_date":"2024-08-28 21:42:00","inspection_id":"82510416","insp_unit_id":"202632499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"29","insp_unit_license":"BC80174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR3GC7LM006358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":4774742,"change_date":"2024-01-05 21:46:00","inspection_id":"80546885","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01375","insp_date":"2024-01-05 00:00:00","insp_start_time":"0728","insp_end_time":"0749","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28 @ CTY RD 403","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159644","transaction_code":"A","transaction_date":"2024-01-05 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2024-01-05 21:46:00","snet_input_date":"2024-01-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:17.000000Z","updated_at":"2025-03-17T19:57:17.000000Z","inspection_violations":[{"id":7367800,"change_date":"2024-01-05 21:46:00","inspection_id":"80546885","insp_violation_id":"257213223","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7681299,"change_date":"2024-01-05 21:46:00","inspection_id":"80546885","insp_unit_id":"198838912","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"103","insp_unit_license":"BC80861","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCYXGDHC1193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"}]},{"id":4539037,"change_date":"2023-12-01 21:42:00","inspection_id":"80288909","dot_number":"2637583","report_state":"MI","report_number":"ZASTM01695","insp_date":"2023-11-30 00:00:00","insp_start_time":"1357","insp_end_time":"1412","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-117 SB @ RASKI ROAD","county_code_state":"MI","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 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":"1155554","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[{"id":7022716,"change_date":"2023-12-01 21:42:00","inspection_id":"80288909","insp_violation_id":"256667528","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":"X4296650","created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7300208,"change_date":"2023-12-01 21:42:00","inspection_id":"80288909","insp_unit_id":"198308753","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"29","insp_unit_license":"BC80174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR3GC7LM006358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"}]},{"id":3674465,"change_date":"2023-08-04 21:41:00","inspection_id":"79330084","dot_number":"2637583","report_state":"MI","report_number":"ZASTM01626","insp_date":"2023-08-04 00:00:00","insp_start_time":"0655","insp_end_time":"0832","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEWBERRY BP","county_code_state":"MI","county_code":"095","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1138628","transaction_code":"A","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[{"id":5663792,"change_date":"2023-08-04 21:41:00","inspection_id":"79330084","insp_violation_id":"254477925","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196373672","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3939A"},{"id":5663793,"change_date":"2023-08-04 21:41:00","inspection_id":"79330084","insp_violation_id":"254477926","seq_no":"2","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4255541","created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39111B5"},{"id":5663794,"change_date":"2023-08-04 21:41:00","inspection_id":"79330084","insp_violation_id":"254477927","seq_no":"3","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4255541","created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":5907676,"change_date":"2023-08-04 21:41:00","inspection_id":"79330084","insp_unit_id":"196373672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"29","insp_unit_license":"BC80174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR3GC7LM006358","insp_unit_decal":"Y","insp_unit_decal_number":"33031537","created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3413539,"change_date":"2023-06-30 21:40:00","inspection_id":"79036967","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01288","insp_date":"2023-06-29 00:00:00","insp_start_time":"1220","insp_end_time":"1238","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28WB @ M-77","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1133090","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:36.000000Z","updated_at":"2025-03-17T19:30:36.000000Z","inspection_violations":[{"id":5261437,"change_date":"2023-06-30 21:40:00","inspection_id":"79036967","insp_violation_id":"253816932","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":"X4234778","created_at":"2025-03-17T21:31:27.000000Z","updated_at":"2025-03-17T21:31:27.000000Z","normalized_code":"3922"},{"id":5261438,"change_date":"2023-06-30 21:40:00","inspection_id":"79036967","insp_violation_id":"253816933","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:27.000000Z","updated_at":"2025-03-17T21:31:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5488284,"change_date":"2023-06-30 21:40:00","inspection_id":"79036967","insp_unit_id":"195782676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"103","insp_unit_license":"BC80861","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCYXGDHC1193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:18.000000Z","updated_at":"2025-03-17T22:46:18.000000Z"}]},{"id":2799292,"change_date":"2023-04-13 21:43:00","inspection_id":"78343415","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01213","insp_date":"2023-04-12 00:00:00","insp_start_time":"1255","insp_end_time":"1422","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SANDTOWN RD @ M-117","county_code_state":"MI","county_code":"097","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":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1121627","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2023-04-13 21:43:00","snet_input_date":"2023-04-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:08.000000Z","updated_at":"2025-03-17T19:18:08.000000Z","inspection_violations":[{"id":4295808,"change_date":"2023-04-13 21:43:00","inspection_id":"78343415","insp_violation_id":"252210141","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":"X4194108","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4505303,"change_date":"2023-04-13 21:43:00","inspection_id":"78343415","insp_unit_id":"194375188","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":2799293,"change_date":"2023-04-13 21:43:00","inspection_id":"78343416","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01214","insp_date":"2023-04-12 00:00:00","insp_start_time":"1547","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CAR POOL LOT M-117 @ US-2","county_code_state":"MI","county_code":"097","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":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"63200","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":"1121716","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2023-04-13 21:43:00","snet_input_date":"2023-04-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA  AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:08.000000Z","updated_at":"2025-03-17T19:18:08.000000Z","inspection_violations":[{"id":4295809,"change_date":"2023-04-13 21:43:00","inspection_id":"78343416","insp_violation_id":"252210142","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":"X4194271","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4505304,"change_date":"2023-04-13 21:43:00","inspection_id":"78343416","insp_unit_id":"194375189","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":1636635,"change_date":"2022-10-31 21:41:00","inspection_id":"77015926","dot_number":"2637583","report_state":"MI","report_number":"CAMEJ01154","insp_date":"2022-10-28 00:00:00","insp_start_time":"1340","insp_end_time":"1415","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1100373","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2022-10-31 21:41:00","snet_input_date":"2022-10-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-31 21:41:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:43.000000Z","updated_at":"2025-03-17T18:56:43.000000Z","inspection_violations":[{"id":2567290,"change_date":"2022-10-31 21:41:00","inspection_id":"77015926","insp_violation_id":"249340499","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:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2632782,"change_date":"2022-10-31 21:41:00","inspection_id":"77015926","insp_unit_id":"191723829","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC80869","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2N187Y5KW028790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:03.000000Z","updated_at":"2025-03-17T22:25:03.000000Z"}]},{"id":551190,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","dot_number":"2637583","report_state":"MI","report_number":"STOLJ00518","insp_date":"2022-06-03 00:00:00","insp_start_time":"1120","insp_end_time":"1238","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US2 @ BLANEY BP","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PUBLIG","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1078580","transaction_code":"C","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02637583","upload_search_indicator":null,"census_search_date":"2022-06-06 21:41:00","snet_input_date":"2022-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-06 21:41:00","insp_carrier_name":"ZELLAR SANITATION INC","insp_carrier_street":"415 S CHIPPEWA AVE","insp_carrier_city":"MANISTIQUE","insp_carrier_state":"MI","insp_carrier_zip_code":"49854","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:27.000000Z","updated_at":"2025-03-17T18:37:27.000000Z","inspection_violations":[{"id":867375,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_violation_id":"246342505","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4020865","created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39216A"},{"id":867376,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_violation_id":"246342506","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"C","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4020918","created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39216A"},{"id":867377,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_violation_id":"246342507","seq_no":"3","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"189153129","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39375A"},{"id":867378,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_violation_id":"246342508","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189153129","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39395A"},{"id":867379,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_violation_id":"246342509","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"189153129","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39395F"},{"id":867380,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_violation_id":"246342510","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189153129","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":886802,"change_date":"2022-06-09 21:42:00","inspection_id":"75750070","insp_unit_id":"189153129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"BC80868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEKTAT5NL324478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2637583\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2637583\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2637583\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2637583\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}