{"current_page":1,"data":[{"id":11407916,"change_date":"2026-03-18 21:38:00","inspection_id":"87323266","dot_number":"1693850","report_state":"MI","report_number":"MOREM06368","insp_date":"2026-03-17 00:00:00","insp_start_time":"1629","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"6680 GUINEA RD","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"232000","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":"1262950","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2026-03-18 21:38:00","snet_input_date":"2026-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-18 21:38:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2026-03-21T09:47:02.000000Z","updated_at":"2026-03-29T09:32:00.000000Z","inspection_violations":[{"id":19236004,"change_date":"2026-03-18 21:38:00","inspection_id":"87323266","insp_violation_id":"272478085","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-21T10:12:42.000000Z","updated_at":"2026-03-29T09:58:01.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19540412,"change_date":"2026-03-18 21:38:00","inspection_id":"87323266","insp_unit_id":"212202714","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"38A","insp_unit_license":"BB78637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG8LPKX9199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:21.000000Z","updated_at":"2026-03-29T09:18:41.000000Z"},{"id":19540413,"change_date":"2026-03-18 21:38:00","inspection_id":"87323266","insp_unit_id":"212202715","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"4576","insp_unit_license":"E164900","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L3834RC34576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:21.000000Z","updated_at":"2026-03-29T09:18:41.000000Z"},{"id":19540414,"change_date":"2026-03-18 21:38:00","inspection_id":"87323266","insp_unit_id":"212202716","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":"4577","insp_unit_license":"E164901","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H5814RC34577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:21.000000Z","updated_at":"2026-03-29T09:18:41.000000Z"}]},{"id":10240096,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","dot_number":"1693850","report_state":"MI","report_number":"STUDM00770","insp_date":"2025-11-18 00:00:00","insp_start_time":"1110","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IRP LOT","county_code_state":"MI","county_code":"045","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":"2025-11-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1251079","transaction_code":"C","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-11-19 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-19 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-23T10:31:49.000000Z","updated_at":"2025-12-08T10:30:37.000000Z","inspection_violations":[{"id":17321681,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_violation_id":"270464012","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210416042","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:08.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","normalized_code":"3939ALIL"},{"id":17321682,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_violation_id":"270464013","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210416042","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:08.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","normalized_code":"3922SLLSR"},{"id":17321683,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_violation_id":"270464014","seq_no":"3","part_no":"393","part_no_section":"75A1-TAORETA","insp_viol_unit":"1","insp_unit_id":"210416041","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4580443","created_at":"2025-12-07T10:32:08.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","normalized_code":"39375A1TAORETA"},{"id":17321684,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_violation_id":"270464015","seq_no":"4","part_no":"393","part_no_section":"47A-BCLMBD","insp_viol_unit":"2","insp_unit_id":"210416042","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:08.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","normalized_code":"39347ABCLMBD"},{"id":17321685,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_violation_id":"270464016","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"210416042","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:08.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","normalized_code":"39347E"},{"id":17321686,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_violation_id":"270464017","seq_no":"6","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"210416042","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:08.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":17291445,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_unit_id":"210416041","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BB78638","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG0LPKX9200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:27.000000Z","updated_at":"2025-12-08T10:00:46.000000Z"},{"id":17291446,"change_date":"2025-12-04 21:38:00","inspection_id":"86362812","insp_unit_id":"210416042","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E096923","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F4YS600827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:27.000000Z","updated_at":"2025-12-08T10:00:46.000000Z"}]},{"id":9583782,"change_date":"2025-09-03 21:40:00","inspection_id":"85672585","dot_number":"1693850","report_state":"MI","report_number":"POWEL04025","insp_date":"2025-09-02 00:00:00","insp_start_time":"1050","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-52 @ I-96","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMRIZE","shipping_paper_number":"868054","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-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"213200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238999","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:30.000000Z","updated_at":"2025-09-10T10:44:56.000000Z","inspection_violations":[{"id":15655502,"change_date":"2025-09-03 21:40:00","inspection_id":"85672585","insp_violation_id":"268435939","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208730314","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:11.000000Z","updated_at":"2025-09-06T10:48:11.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15655503,"change_date":"2025-09-03 21:40:00","inspection_id":"85672585","insp_violation_id":"268435940","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"3","insp_unit_id":"208730315","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:48:11.000000Z","updated_at":"2025-09-06T10:48:11.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15821655,"change_date":"2025-09-03 21:40:00","inspection_id":"85672585","insp_unit_id":"208730313","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"58A","insp_unit_license":"BD96973","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG9SLVT5127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"},{"id":15821656,"change_date":"2025-09-03 21:40:00","inspection_id":"85672585","insp_unit_id":"208730314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"9410","insp_unit_license":"B400145","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS24345C00941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"},{"id":15821657,"change_date":"2025-09-03 21:40:00","inspection_id":"85672585","insp_unit_id":"208730315","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"9411","insp_unit_license":"B400146","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS20575C009411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"}]},{"id":9322840,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","dot_number":"1693850","report_state":"MI","report_number":"MOREM06032","insp_date":"2025-07-30 00:00:00","insp_start_time":"1016","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IRP LOT CROWNER RD","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233941","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2025-08-07T10:44:51.000000Z","updated_at":"2025-08-08T10:00:43.000000Z","inspection_violations":[{"id":15127523,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_violation_id":"267823583","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4576426","created_at":"2025-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:50.000000Z","normalized_code":"39216D"},{"id":15127524,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_violation_id":"267823584","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208225113","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:50.000000Z","normalized_code":"3922SLLSOA"},{"id":15127525,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_violation_id":"267823585","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"208225113","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:50.000000Z","normalized_code":"3922SLL"},{"id":15127526,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_violation_id":"267823586","seq_no":"4","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"2","insp_unit_id":"208225114","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:50.000000Z","normalized_code":"393207ASUBL"},{"id":15127527,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_violation_id":"267823587","seq_no":"5","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"2","insp_unit_id":"208225114","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4576426","created_at":"2025-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:50.000000Z","normalized_code":"393207ASUBL"},{"id":15127528,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_violation_id":"267823588","seq_no":"6","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"208225114","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:50.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":15353510,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_unit_id":"208225113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"60A","insp_unit_license":"BE04617","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG2SLVT5129","insp_unit_decal":"Y","insp_unit_decal_number":"03546887","created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:53.000000Z"},{"id":15353511,"change_date":"2025-08-04 21:39:00","inspection_id":"85398437","insp_unit_id":"208225114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"2914","insp_unit_license":"E663194","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L387FR052914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:53.000000Z"}]},{"id":9238026,"change_date":"2025-07-24 21:41:00","inspection_id":"85309125","dot_number":"1693850","report_state":"MI","report_number":"MOREM06007","insp_date":"2025-07-22 00:00:00","insp_start_time":"1441","insp_end_time":"1512","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B GUINNEA RD","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"232000","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":"1231760","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":"01693850","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":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:52.000000Z","inspection_violations":[{"id":14956107,"change_date":"2025-07-24 21:41:00","inspection_id":"85309125","insp_violation_id":"267628909","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":"X4569457","created_at":"2025-07-27T10:44:15.000000Z","updated_at":"2025-07-28T10:48:52.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":15201325,"change_date":"2025-07-24 21:41:00","inspection_id":"85309125","insp_unit_id":"208060424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"59A","insp_unit_license":"BE04616","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG0SLVT5128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:04.000000Z"},{"id":15201326,"change_date":"2025-07-24 21:41:00","inspection_id":"85309125","insp_unit_id":"208060425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"4576","insp_unit_license":"E164900","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L3834RC34576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:04.000000Z"},{"id":15201327,"change_date":"2025-07-24 21:41:00","inspection_id":"85309125","insp_unit_id":"208060426","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":"4577","insp_unit_license":"E164901","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H5814RC34577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:04.000000Z"}]},{"id":9807915,"change_date":"2025-10-02 21:42:00","inspection_id":"85907770","dot_number":"1693850","report_state":"MI","report_number":"MOREM05984","insp_date":"2025-07-15 00:00:00","insp_start_time":"0909","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CREYTS RD","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"1243933","transaction_code":"C","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-07-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2025-10-02T10:00:24.000000Z","updated_at":"2025-10-05T10:01:45.000000Z","inspection_violations":[{"id":16194398,"change_date":"2025-10-02 21:42:00","inspection_id":"85907770","insp_violation_id":"269057625","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":"X4567717","created_at":"2025-10-05T10:17:31.000000Z","updated_at":"2025-10-05T10:17:31.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16307833,"change_date":"2025-10-02 21:42:00","inspection_id":"85907770","insp_unit_id":"209264174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"61A","insp_unit_license":"BE04618","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG9SLVT5130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"},{"id":16307834,"change_date":"2025-10-02 21:42:00","inspection_id":"85907770","insp_unit_id":"209264175","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"E PAK","insp_unit_company":"5111","insp_unit_license":"F215527","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D835MA505111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":9123784,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","dot_number":"1693850","report_state":"MI","report_number":"MOREM05976","insp_date":"2025-07-10 00:00:00","insp_start_time":"1242","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TURKEYVILLE REST AREA","county_code_state":"MI","county_code":"025","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"KEELEY CONSTRUCTION GROUP","shipping_paper_number":"183955.1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","viol_total":"12","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229797","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:45.000000Z","inspection_violations":[{"id":14709304,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347842","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3922SLL"},{"id":14709305,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347843","seq_no":"2","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":"X4559712","created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3922SLLEWG3"},{"id":14709306,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347844","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"207822048","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3922SLL"},{"id":14709307,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347845","seq_no":"4","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"207822048","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3922SLLSOA"},{"id":14709308,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347846","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207822048","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3939ALIL"},{"id":14709309,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347847","seq_no":"6","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"207822048","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3939ALBL"},{"id":14709310,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347848","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207822048","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39395F"},{"id":14709311,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347849","seq_no":"8","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"207822049","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39311A1LLPL"},{"id":14709312,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347850","seq_no":"9","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207822049","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3922SLLSR"},{"id":14709313,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347851","seq_no":"10","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207822049","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39347E"},{"id":14709314,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347852","seq_no":"11","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207822049","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4559712","created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39347E"},{"id":14709315,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_violation_id":"267347853","seq_no":"12","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"207822049","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":14979934,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_unit_id":"207822048","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"36A","insp_unit_license":"BB48445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14JPJT8206","insp_unit_decal":"Y","insp_unit_decal_number":"03546877","created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"},{"id":14979935,"change_date":"2025-07-11 21:39:00","inspection_id":"85189147","insp_unit_id":"207822049","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"1055","insp_unit_license":"D483103","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2431WC001055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"}]},{"id":8796610,"change_date":"2025-06-02 21:39:00","inspection_id":"84843075","dot_number":"1693850","report_state":"MI","report_number":"KIRKB05025","insp_date":"2025-05-30 00:00:00","insp_start_time":"0945","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1223665","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:29.000000Z","updated_at":"2025-06-06T10:00:37.000000Z","inspection_violations":[{"id":14065337,"change_date":"2025-06-02 21:39:00","inspection_id":"84843075","insp_violation_id":"266613200","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:41.000000Z","updated_at":"2025-06-06T10:15:56.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":14394632,"change_date":"2025-06-02 21:39:00","inspection_id":"84843075","insp_unit_id":"207184484","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MAC T","insp_unit_company":"6227","insp_unit_license":"E969840","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2039KC046227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:27.000000Z","updated_at":"2025-06-06T09:45:58.000000Z"},{"id":14394633,"change_date":"2025-06-02 21:39:00","inspection_id":"84843075","insp_unit_id":"207184485","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC T","insp_unit_company":"6226","insp_unit_license":"D821601","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2434KC046226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:27.000000Z","updated_at":"2025-06-06T09:45:58.000000Z"},{"id":14394634,"change_date":"2025-06-02 21:39:00","inspection_id":"84843075","insp_unit_id":"207184486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"51A","insp_unit_license":"BD25035","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG8PPUG1730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:27.000000Z","updated_at":"2025-06-06T09:45:58.000000Z"}]},{"id":8702498,"change_date":"2025-05-21 21:42:00","inspection_id":"84743475","dot_number":"1693850","report_state":"MI","report_number":"ECSJT00178","insp_date":"2025-05-19 00:00:00","insp_start_time":"1349","insp_end_time":"1502","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CREYTS RD \/ MT HOPE HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222031","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:24.000000Z","updated_at":"2025-05-25T10:06:36.000000Z","inspection_violations":[{"id":13870827,"change_date":"2025-05-21 21:42:00","inspection_id":"84743475","insp_violation_id":"266381721","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"206992773","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S48646","created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:04.000000Z","normalized_code":"3922SLLEWA2"},{"id":13870828,"change_date":"2025-05-21 21:42:00","inspection_id":"84743475","insp_violation_id":"266381722","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206992774","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:05.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14221036,"change_date":"2025-05-21 21:42:00","inspection_id":"84743475","insp_unit_id":"206992773","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"40A","insp_unit_license":"BC57232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG6LPKX9198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:15.000000Z"},{"id":14221037,"change_date":"2025-05-21 21:42:00","inspection_id":"84743475","insp_unit_id":"206992774","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":null,"insp_unit_license":"E594516","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT38CXYMSS0037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:15.000000Z"}]},{"id":8534274,"change_date":"2025-05-02 21:41:00","inspection_id":"84566420","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03383","insp_date":"2025-05-01 00:00:00","insp_start_time":"0740","insp_end_time":"0807","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219979","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-06T10:06:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13876892,"change_date":"2025-05-02 21:41:00","inspection_id":"84566420","insp_unit_id":"206617274","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"58A","insp_unit_license":"BD96973","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG9SLVT5127","insp_unit_decal":"Y","insp_unit_decal_number":"35167456","created_at":"2025-05-05T10:04:47.000000Z","updated_at":"2025-05-07T10:03:07.000000Z"}]},{"id":8534275,"change_date":"2025-05-02 21:41:00","inspection_id":"84566421","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03384","insp_date":"2025-05-01 00:00:00","insp_start_time":"0807","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219924","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-06T10:06:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13876893,"change_date":"2025-05-02 21:41:00","inspection_id":"84566421","insp_unit_id":"206617275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"40A","insp_unit_license":"BC57232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG6LPKX9198","insp_unit_decal":"Y","insp_unit_decal_number":"35167455","created_at":"2025-05-05T10:04:47.000000Z","updated_at":"2025-05-07T10:03:07.000000Z"}]},{"id":8534276,"change_date":"2025-05-02 21:41:00","inspection_id":"84566422","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03385","insp_date":"2025-05-01 00:00:00","insp_start_time":"0827","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"1219934","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-06T10:06:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13876894,"change_date":"2025-05-02 21:41:00","inspection_id":"84566422","insp_unit_id":"206617276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"48A","insp_unit_license":"BD21505","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"KJJBWFG8PLNZ2703","insp_unit_decal":"Y","insp_unit_decal_number":"35167453","created_at":"2025-05-05T10:04:47.000000Z","updated_at":"2025-05-07T10:03:07.000000Z"},{"id":13876895,"change_date":"2025-05-02 21:41:00","inspection_id":"84566422","insp_unit_id":"206617277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"6228","insp_unit_license":"E994110","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2438KC046228","insp_unit_decal":"Y","insp_unit_decal_number":"35167454","created_at":"2025-05-05T10:04:47.000000Z","updated_at":"2025-05-07T10:03:07.000000Z"}]},{"id":8534277,"change_date":"2025-05-02 21:41:00","inspection_id":"84566423","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03386","insp_date":"2025-05-01 00:00:00","insp_start_time":"0855","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219995","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-06T10:06:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13876896,"change_date":"2025-05-02 21:41:00","inspection_id":"84566423","insp_unit_id":"206617278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"38A","insp_unit_license":"BB78637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG8LPKX9199","insp_unit_decal":"Y","insp_unit_decal_number":"35167457","created_at":"2025-05-05T10:04:47.000000Z","updated_at":"2025-05-07T10:03:07.000000Z"}]},{"id":8513141,"change_date":"2025-04-30 21:52:00","inspection_id":"84544217","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03379","insp_date":"2025-04-30 00:00:00","insp_start_time":"0750","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219609","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","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:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13839187,"change_date":"2025-04-30 21:52:00","inspection_id":"84544217","insp_unit_id":"206576288","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"19A","insp_unit_license":"BD64869","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14HPJB1092","insp_unit_decal":"Y","insp_unit_decal_number":"35167452","created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":8513142,"change_date":"2025-04-30 21:52:00","inspection_id":"84544218","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03380","insp_date":"2025-04-30 00:00:00","insp_start_time":"0815","insp_end_time":"0837","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"62000","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":"1219782","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","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:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13839188,"change_date":"2025-04-30 21:52:00","inspection_id":"84544218","insp_unit_id":"206576289","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"37A","insp_unit_license":"BD14637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD13JPJT8178","insp_unit_decal":"Y","insp_unit_decal_number":"35167451","created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":8513143,"change_date":"2025-04-30 21:52:00","inspection_id":"84544219","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03381","insp_date":"2025-04-30 00:00:00","insp_start_time":"0837","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219645","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","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:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13839189,"change_date":"2025-04-30 21:52:00","inspection_id":"84544219","insp_unit_id":"206576290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"52A","insp_unit_license":"BB48410","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG7RLUZ2918","insp_unit_decal":"Y","insp_unit_decal_number":"35167449","created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":8513147,"change_date":"2025-04-30 21:52:00","inspection_id":"84544223","dot_number":"1693850","report_state":"MI","report_number":"MORGZ03382","insp_date":"2025-04-30 00:00:00","insp_start_time":"0900","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219762","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","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:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13839196,"change_date":"2025-04-30 21:52:00","inspection_id":"84544223","insp_unit_id":"206576299","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"50A","insp_unit_license":"BD14592","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG1PLNZ2705","insp_unit_decal":"Y","insp_unit_decal_number":"35167450","created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":8320443,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","dot_number":"1693850","report_state":"MI","report_number":"MOREM05806","insp_date":"2025-04-07 00:00:00","insp_start_time":"0905","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DEWITT REST AREA","county_code_state":"MI","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"SP02002354","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"8","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1216612","transaction_code":"A","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2025-04-11T10:12:21.000000Z","updated_at":"2025-04-12T10:22:08.000000Z","inspection_violations":[{"id":13093895,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498482","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4510073","created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"3922SLLEWA1"},{"id":13093896,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498483","seq_no":"2","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-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"3922SLLSR"},{"id":13093897,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498484","seq_no":"3","part_no":"392","part_no_section":"9A3","insp_viol_unit":"1","insp_unit_id":"206204525","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"3929A3"},{"id":13093898,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498485","seq_no":"4","part_no":"393","part_no_section":"203A-CBP","insp_viol_unit":"1","insp_unit_id":"206204525","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"393203ACBP"},{"id":13093899,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498486","seq_no":"5","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"206204525","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"3929A2C"},{"id":13093900,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498487","seq_no":"6","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"206204525","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"39345DB"},{"id":13093901,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498488","seq_no":"7","part_no":"393","part_no_section":"47F-B","insp_viol_unit":"1","insp_unit_id":"206204525","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"39347FB"},{"id":13093902,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_violation_id":"265498489","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206204526","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:39:47.000000Z","updated_at":"2025-04-11T10:47:50.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13494433,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_unit_id":"206204525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BD14637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD13JPJT8178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:05:11.000000Z","updated_at":"2025-04-12T10:00:02.000000Z"},{"id":13494434,"change_date":"2025-04-08 21:40:00","inspection_id":"84341001","insp_unit_id":"206204526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D248790","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1K38XRRC16562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:05:11.000000Z","updated_at":"2025-04-12T10:00:02.000000Z"}]},{"id":7565940,"change_date":"2025-01-14 21:55:00","inspection_id":"83548011","dot_number":"1693850","report_state":"MI","report_number":"BESSJ00961","insp_date":"2025-01-06 00:00:00","insp_start_time":"1225","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-52 @ BOYCE RD","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"208000","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":"1205825","transaction_code":"C","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:15.000000Z","updated_at":"2025-03-17T20:55:15.000000Z","inspection_violations":[{"id":11826315,"change_date":"2025-01-14 21:55:00","inspection_id":"83548011","insp_violation_id":"263994555","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":12207545,"change_date":"2025-01-14 21:55:00","inspection_id":"83548011","insp_unit_id":"204827472","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"WESTE","insp_unit_company":"50A","insp_unit_license":"BD14592","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG1PLNZ2705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:45.000000Z","updated_at":"2025-03-17T23:49:45.000000Z"},{"id":12207546,"change_date":"2025-01-14 21:55:00","inspection_id":"83548011","insp_unit_id":"204827473","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"1346","insp_unit_license":"E663193","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F3YS691346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:45.000000Z","updated_at":"2025-03-17T23:49:45.000000Z"},{"id":12207547,"change_date":"2025-01-14 21:55:00","inspection_id":"83548011","insp_unit_id":"204827474","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"N\/A","insp_unit_license":"E752350","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195F0YS691361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:45.000000Z","updated_at":"2025-03-17T23:49:45.000000Z"}]},{"id":7014145,"change_date":"2024-10-22 21:41:00","inspection_id":"82965853","dot_number":"1693850","report_state":"MI","report_number":"BURGM06375","insp_date":"2024-10-21 00:00:00","insp_start_time":"1025","insp_end_time":"1049","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"STINE RD","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1198944","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[{"id":10944380,"change_date":"2024-10-22 21:41:00","inspection_id":"82965853","insp_violation_id":"262484565","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11313180,"change_date":"2024-10-22 21:41:00","inspection_id":"82965853","insp_unit_id":"203524601","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"52A","insp_unit_license":"BB48410","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG7RLUZ2918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"},{"id":11313181,"change_date":"2024-10-22 21:41:00","inspection_id":"82965853","insp_unit_id":"203524602","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"4372","insp_unit_license":"E214979","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L385GR054372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"},{"id":11313182,"change_date":"2024-10-22 21:41:00","inspection_id":"82965853","insp_unit_id":"203524603","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"4373","insp_unit_license":"E214980","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H583GR054373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"}]},{"id":6575411,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","dot_number":"1693850","report_state":"MI","report_number":"HICKG02682","insp_date":"2024-08-27 00:00:00","insp_start_time":"0905","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-69 @ LANSING RD CHARLOTTE","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"132000","viol_total":"11","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":"1191777","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10219849,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438526","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202609869","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39395A"},{"id":10219850,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438527","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"},{"id":10219851,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438528","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"},{"id":10219852,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438529","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"},{"id":10219853,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438530","seq_no":"6","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39375A"},{"id":10219854,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438531","seq_no":"7","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39375A"},{"id":10219855,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438532","seq_no":"8","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"393205A"},{"id":10219856,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438533","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"393207A"},{"id":10219857,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438534","seq_no":"10","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"393207C"},{"id":10219858,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438535","seq_no":"11","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"202609870","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"393207A"},{"id":10219859,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_violation_id":"261438536","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202609869","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":10600523,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_unit_id":"202609869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD96916","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJALAV57DX84684","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"},{"id":10600524,"change_date":"2024-08-27 21:42:00","inspection_id":"82498926","insp_unit_id":"202609870","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D821446","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H2D02433VW024502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"}]},{"id":6445166,"change_date":"2024-08-12 21:43:00","inspection_id":"82360273","dot_number":"1693850","report_state":"MI","report_number":"SHEPZ04554","insp_date":"2024-08-12 00:00:00","insp_start_time":"1025","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E MICHIGAN @ FERGUSON ST","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"1189913","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-08-12 21:43:00","snet_input_date":"2024-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-12 21:43:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:40.000000Z","updated_at":"2025-03-17T20:30:40.000000Z","inspection_violations":[{"id":10008236,"change_date":"2024-08-12 21:43:00","inspection_id":"82360273","insp_violation_id":"261140445","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202346479","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:26.000000Z","updated_at":"2025-03-17T21:54:26.000000Z","normalized_code":"3922"},{"id":10008237,"change_date":"2024-08-12 21:43:00","inspection_id":"82360273","insp_violation_id":"261140446","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202346480","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:26.000000Z","updated_at":"2025-03-17T21:54:26.000000Z","normalized_code":"3922"},{"id":10008238,"change_date":"2024-08-12 21:43:00","inspection_id":"82360273","insp_violation_id":"261140447","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"202346480","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4422951","created_at":"2025-03-17T21:54:26.000000Z","updated_at":"2025-03-17T21:54:26.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":10388127,"change_date":"2024-08-12 21:43:00","inspection_id":"82360273","insp_unit_id":"202346479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"35A","insp_unit_license":"BB08609","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD1XJPJL5990","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:40.000000Z","updated_at":"2025-03-17T23:30:40.000000Z"},{"id":10388128,"change_date":"2024-08-12 21:43:00","inspection_id":"82360273","insp_unit_id":"202346480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"E-PAK","insp_unit_company":"5144","insp_unit_license":"E313238","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9E5D839MA505144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:40.000000Z","updated_at":"2025-03-17T23:30:40.000000Z"}]},{"id":5885588,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","dot_number":"1693850","report_state":"MI","report_number":"ECSJT00153","insp_date":"2024-05-30 00:00:00","insp_start_time":"1444","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANAL RD \/ DAVIS HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1180527","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":9124807,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_violation_id":"259835113","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201175003","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S46073","created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"3922"},{"id":9124808,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_violation_id":"259835114","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201175002","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"39311"},{"id":9124809,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_violation_id":"259835115","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201175003","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"39355E"},{"id":9124810,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_violation_id":"259835116","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201175003","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"39347E"},{"id":9124811,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_violation_id":"259835117","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"201175003","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"39353B"},{"id":9124812,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_violation_id":"259835118","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201175003","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9479416,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_unit_id":"201175002","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"40A","insp_unit_license":"BC57232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG6LPKX9198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"},{"id":9479417,"change_date":"2024-05-31 21:39:00","inspection_id":"81757881","insp_unit_id":"201175003","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"0826","insp_unit_license":"E029555","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F4XS600826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5700313,"change_date":"2024-05-08 21:42:00","inspection_id":"81557221","dot_number":"1693850","report_state":"MI","report_number":"MOREM05254","insp_date":"2024-05-07 00:00:00","insp_start_time":"1527","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOLT REST AREA","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOFFMAN BROTHERS","shipping_paper_number":"13-0101SG","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"211000","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":"1177537","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-05-08 21:42:00","snet_input_date":"2024-05-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-08 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"11068","created_at":"2025-03-17T20:15:50.000000Z","updated_at":"2025-03-17T20:15:50.000000Z","inspection_violations":[{"id":8817666,"change_date":"2024-05-08 21:42:00","inspection_id":"81557221","insp_violation_id":"259385891","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":"X4372762","created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9181240,"change_date":"2024-05-08 21:42:00","inspection_id":"81557221","insp_unit_id":"200792233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"19A","insp_unit_license":"BD64869","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14HPJB1092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"},{"id":9181241,"change_date":"2024-05-08 21:42:00","inspection_id":"81557221","insp_unit_id":"200792234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"7302","insp_unit_license":"D821448","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H2D02434TW047302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"},{"id":9181242,"change_date":"2024-05-08 21:42:00","inspection_id":"81557221","insp_unit_id":"200792235","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"4602","insp_unit_license":"D821447","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H2D01951VW024602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"}]},{"id":5575983,"change_date":"2024-04-23 21:41:00","inspection_id":"81421784","dot_number":"1693850","report_state":"MI","report_number":"BURGM05994","insp_date":"2024-04-22 00:00:00","insp_start_time":"1155","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IOSCO RD","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1175073","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8617973,"change_date":"2024-04-23 21:41:00","inspection_id":"81421784","insp_violation_id":"259082375","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4365681","created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8981911,"change_date":"2024-04-23 21:41:00","inspection_id":"81421784","insp_unit_id":"200530399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"38A","insp_unit_license":"BB78637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG8LPKX9199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8981912,"change_date":"2024-04-23 21:41:00","inspection_id":"81421784","insp_unit_id":"200530400","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"2694","insp_unit_license":"E029500","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS243XTC096294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8981913,"change_date":"2024-04-23 21:41:00","inspection_id":"81421784","insp_unit_id":"200530401","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"6334","insp_unit_license":"E812964","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS2058TC096334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5511718,"change_date":"2024-04-15 21:41:00","inspection_id":"81351796","dot_number":"1693850","report_state":"MI","report_number":"HICKG02519","insp_date":"2024-04-15 00:00:00","insp_start_time":"0915","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CROWNER DR @ BILL WOOD DR","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"1173650","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-04-15 21:41:00","snet_input_date":"2024-04-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-15 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:57.000000Z","updated_at":"2025-03-17T20:11:57.000000Z","inspection_violations":[{"id":8514627,"change_date":"2024-04-15 21:41:00","inspection_id":"81351796","insp_violation_id":"258931620","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4359651","created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":8878328,"change_date":"2024-04-15 21:41:00","inspection_id":"81351796","insp_unit_id":"200397824","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"57","insp_unit_license":"BC98848","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG9RLUZ2922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:35.000000Z","updated_at":"2025-03-17T23:15:35.000000Z"},{"id":8878329,"change_date":"2024-04-15 21:41:00","inspection_id":"81351796","insp_unit_id":"200397825","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORCY","insp_unit_company":null,"insp_unit_license":"D210617","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DTD18A37TP037734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:35.000000Z","updated_at":"2025-03-17T23:15:35.000000Z"}]},{"id":4910272,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","dot_number":"1693850","report_state":"MI","report_number":"KIRKB04463","insp_date":"2024-01-25 00:00:00","insp_start_time":"0945","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"71391752","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"230000","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":"1161910","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2024-01-26 21:39:00","snet_input_date":"2024-01-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-26 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:02.000000Z","updated_at":"2025-03-17T20:00:02.000000Z","inspection_violations":[{"id":7565320,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_violation_id":"257515368","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"199127613","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"39347E"},{"id":7565321,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_violation_id":"257515369","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"199127613","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"39345D"},{"id":7565322,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_violation_id":"257515370","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"199127613","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"39353B"},{"id":7565323,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_violation_id":"257515371","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"199127614","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4304802","created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"3922"},{"id":7565324,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_violation_id":"257515372","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"3","insp_unit_id":"199127614","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4304802","created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":7901543,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_unit_id":"199127612","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"43A","insp_unit_license":"BC48444","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG0MPMU2249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"},{"id":7901544,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_unit_id":"199127613","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"E PAK","insp_unit_company":"5111","insp_unit_license":"E313240","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D835MA505111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"},{"id":7901545,"change_date":"2024-01-26 21:39:00","inspection_id":"80695062","insp_unit_id":"199127614","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"E PAK","insp_unit_company":"5112","insp_unit_license":"E313241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D651MA505112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"}]},{"id":4520004,"change_date":"2023-11-29 21:42:00","inspection_id":"80267868","dot_number":"1693850","report_state":"MI","report_number":"KIRKB04408","insp_date":"2023-11-29 00:00:00","insp_start_time":"0930","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"589745","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1155102","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-11-29 21:42:00","snet_input_date":"2023-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-29 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:32.000000Z","updated_at":"2025-03-17T19:52:32.000000Z","inspection_violations":[{"id":6992309,"change_date":"2023-11-29 21:42:00","inspection_id":"80267868","insp_violation_id":"256619707","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198267503","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39375A3"},{"id":6992310,"change_date":"2023-11-29 21:42:00","inspection_id":"80267868","insp_violation_id":"256619708","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198267503","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7269393,"change_date":"2023-11-29 21:42:00","inspection_id":"80267868","insp_unit_id":"198267503","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"41A","insp_unit_license":"BC48442","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG7MPMU2247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:03.000000Z","updated_at":"2025-03-17T23:01:03.000000Z"},{"id":7269394,"change_date":"2023-11-29 21:42:00","inspection_id":"80267868","insp_unit_id":"198267504","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"E-PAK","insp_unit_company":"5144","insp_unit_license":"E313238","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9E5D839MA505144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:03.000000Z","updated_at":"2025-03-17T23:01:03.000000Z"},{"id":7269395,"change_date":"2023-11-29 21:42:00","inspection_id":"80267868","insp_unit_id":"198267505","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"E-PAK","insp_unit_company":"5145","insp_unit_license":"E313239","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D655MA505145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:03.000000Z","updated_at":"2025-03-17T23:01:03.000000Z"}]},{"id":4236506,"change_date":"2023-10-19 21:41:00","inspection_id":"79954827","dot_number":"1693850","report_state":"MI","report_number":"DELMT00814","insp_date":"2023-10-18 00:00:00","insp_start_time":"1250","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1150084","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-10-19 21:41:00","snet_input_date":"2023-10-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-19 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:40.000000Z","updated_at":"2025-03-17T19:46:40.000000Z","inspection_violations":[{"id":6559721,"change_date":"2023-10-19 21:41:00","inspection_id":"79954827","insp_violation_id":"255935810","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"197643921","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:35.000000Z","updated_at":"2025-03-17T21:37:35.000000Z","normalized_code":"3922"},{"id":6559722,"change_date":"2023-10-19 21:41:00","inspection_id":"79954827","insp_violation_id":"255935811","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"197643920","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:35.000000Z","updated_at":"2025-03-17T21:37:35.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":6813286,"change_date":"2023-10-19 21:41:00","inspection_id":"79954827","insp_unit_id":"197643919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"37A","insp_unit_license":"BD14637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD13JPJT8178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:06.000000Z","updated_at":"2025-03-17T22:57:06.000000Z"},{"id":6813287,"change_date":"2023-10-19 21:41:00","inspection_id":"79954827","insp_unit_id":"197643920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"6226","insp_unit_license":"D821601","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2039KC046227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:06.000000Z","updated_at":"2025-03-17T22:57:06.000000Z"},{"id":6813288,"change_date":"2023-10-19 21:41:00","inspection_id":"79954827","insp_unit_id":"197643921","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"6227","insp_unit_license":"D821604","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2434KC046226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:06.000000Z","updated_at":"2025-03-17T22:57:06.000000Z"}]},{"id":3955333,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","dot_number":"1693850","report_state":"MI","report_number":"STUDM00635","insp_date":"2023-09-11 00:00:00","insp_start_time":"1330","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IRP LOT","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CRANDELL","shipping_paper_number":"17122","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"105740","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1145401","transaction_code":"A","transaction_date":"2023-09-11 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-09-12 21:40:00","snet_input_date":"2023-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-12 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:51.000000Z","updated_at":"2025-03-17T19:40:51.000000Z","inspection_violations":[{"id":6115514,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219412","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:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3922"},{"id":6115515,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219413","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197014055","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3939A"},{"id":6115516,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219414","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197014055","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39395A"},{"id":6115517,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219415","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197014055","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39395F"},{"id":6115518,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219416","seq_no":"5","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197014055","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"393209D"},{"id":6115519,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219417","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197014055","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39347E"},{"id":6115520,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219418","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197014055","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39353B"},{"id":6115521,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219419","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197014056","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3922"},{"id":6115522,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_violation_id":"255219420","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197014056","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6359871,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_unit_id":"197014055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"17A","insp_unit_license":"BA64232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVXA7CG8ELFZ5528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"},{"id":6359872,"change_date":"2023-09-12 21:40:00","inspection_id":"79643219","insp_unit_id":"197014056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"0829","insp_unit_license":"E928499","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F8YS600829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3933919,"change_date":"2023-09-08 21:41:00","inspection_id":"79619446","dot_number":"1693850","report_state":"MI","report_number":"DEJOS00705","insp_date":"2023-09-07 00:00:00","insp_start_time":"0930","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOLCIM","shipping_paper_number":"326822065","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-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1145038","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[{"id":6080459,"change_date":"2023-09-08 21:41:00","inspection_id":"79619446","insp_violation_id":"255164063","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":"X4269663","created_at":"2025-03-17T21:35:25.000000Z","updated_at":"2025-03-17T21:35:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6325548,"change_date":"2023-09-08 21:41:00","inspection_id":"79619446","insp_unit_id":"196968032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"56A","insp_unit_license":"BD54512","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG7RLUZ2921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"},{"id":6325549,"change_date":"2023-09-08 21:41:00","inspection_id":"79619446","insp_unit_id":"196968033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"6228","insp_unit_license":"D821602","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2438KC046228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"},{"id":6325550,"change_date":"2023-09-08 21:41:00","inspection_id":"79619446","insp_unit_id":"196968034","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"6229","insp_unit_license":"D821603","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2032KC046229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3811926,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","dot_number":"1693850","report_state":"MI","report_number":"HICKG02300","insp_date":"2023-08-22 00:00:00","insp_start_time":"1810","insp_end_time":"1850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LANSING RD @ ROYSTON RD","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142038","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-08-23 21:40:00","snet_input_date":"2023-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-23 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:04.000000Z","updated_at":"2025-03-17T19:38:04.000000Z","inspection_violations":[{"id":5881780,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984811","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39311"},{"id":5881781,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984812","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39348A"},{"id":5881782,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984813","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39347E"},{"id":5881783,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984814","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39353B"},{"id":5881784,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984815","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39353B"},{"id":5881785,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984816","seq_no":"6","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39381"},{"id":5881786,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984817","seq_no":"7","part_no":"387","part_no_section":"301(a)","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"387301A"},{"id":5881787,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_violation_id":"254984818","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196813960","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6128849,"change_date":"2023-08-30 21:44:00","inspection_id":"79483291","insp_unit_id":"196813960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"14A","insp_unit_license":"BC48434","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKMHD7X37M194846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"}]},{"id":3802850,"change_date":"2023-08-22 21:43:00","inspection_id":"79473145","dot_number":"1693850","report_state":"MI","report_number":"POWEL03239","insp_date":"2023-07-21 00:00:00","insp_start_time":"0755","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOLCIM","shipping_paper_number":"181198","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-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"213200","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":"1141634","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-08-22 21:43:00","snet_input_date":"2023-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:01.000000Z","updated_at":"2025-03-17T19:38:01.000000Z","inspection_violations":[{"id":5865860,"change_date":"2023-08-22 21:43:00","inspection_id":"79473145","insp_violation_id":"254804225","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6114397,"change_date":"2023-08-22 21:43:00","inspection_id":"79473145","insp_unit_id":"196665180","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"54A","insp_unit_license":"BD54500","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG9RLUZ2919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"},{"id":6114398,"change_date":"2023-08-22 21:43:00","inspection_id":"79473145","insp_unit_id":"196665181","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"4578","insp_unit_license":"E230931","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L3874RC3457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"},{"id":6114399,"change_date":"2023-08-22 21:43:00","inspection_id":"79473145","insp_unit_id":"196665182","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":"4579","insp_unit_license":"B884738","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H5854RC34579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"}]},{"id":3447379,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","dot_number":"1693850","report_state":"MI","report_number":"NEGUB02414","insp_date":"2023-07-05 00:00:00","insp_start_time":"0930","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"CAMBRIDGE SCALES","county_code_state":"MI","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"326816901","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1133878","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-07-06 21:43:00","snet_input_date":"2023-07-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-06 21:43:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:19.000000Z","updated_at":"2025-03-17T19:31:19.000000Z","inspection_violations":[{"id":5314819,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","insp_violation_id":"253903488","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"195859693","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39348A"},{"id":5314820,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","insp_violation_id":"253903489","seq_no":"2","part_no":"393","part_no_section":"70(b)(1)(i)","insp_viol_unit":"3","insp_unit_id":"195859693","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39370B1I"},{"id":5314821,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","insp_violation_id":"253903490","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195859692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5543569,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","insp_unit_id":"195859691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"48A","insp_unit_license":"BD21505","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG8PLNZ2703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:45.000000Z","updated_at":"2025-03-17T22:46:45.000000Z"},{"id":5543570,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","insp_unit_id":"195859692","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"6294","insp_unit_license":"E029500","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS243XTC096294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:45.000000Z","updated_at":"2025-03-17T22:46:45.000000Z"},{"id":5543571,"change_date":"2023-07-06 21:43:00","inspection_id":"79074852","insp_unit_id":"195859693","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"6334","insp_unit_license":"E812964","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS2058TC096334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:45.000000Z","updated_at":"2025-03-17T22:46:45.000000Z"}]},{"id":3000983,"change_date":"2023-05-09 21:42:00","inspection_id":"78571741","dot_number":"1693850","report_state":"MI","report_number":"MOREM04867","insp_date":"2023-05-09 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NIXON RD","county_code_state":"MI","county_code":"045","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":"2023-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"1125193","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-05-09 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-09 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:34.000000Z","updated_at":"2025-03-17T19:22:34.000000Z","inspection_violations":[{"id":4607913,"change_date":"2023-05-09 21:42:00","inspection_id":"78571741","insp_violation_id":"252715799","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":"X4215376","created_at":"2025-03-17T21:28:28.000000Z","updated_at":"2025-03-17T21:28:28.000000Z","normalized_code":"39216A"},{"id":4607914,"change_date":"2023-05-09 21:42:00","inspection_id":"78571741","insp_violation_id":"252715800","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:28:28.000000Z","updated_at":"2025-03-17T21:28:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4828423,"change_date":"2023-05-09 21:42:00","inspection_id":"78571741","insp_unit_id":"194830968","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"40A","insp_unit_license":"BC57232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG6LPKX9198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:02.000000Z","updated_at":"2025-03-17T22:41:02.000000Z"},{"id":4828424,"change_date":"2023-05-09 21:42:00","inspection_id":"78571741","insp_unit_id":"194830969","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"1136","insp_unit_license":"A162911","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2431WC001136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:02.000000Z","updated_at":"2025-03-17T22:41:02.000000Z"}]},{"id":2910177,"change_date":"2023-04-27 21:43:00","inspection_id":"78469224","dot_number":"1693850","report_state":"MI","report_number":"POWEL03121","insp_date":"2023-04-27 00:00:00","insp_start_time":"0645","insp_end_time":"0705","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"213200","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":"1123810","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:26.000000Z","updated_at":"2025-03-17T19:20:26.000000Z","inspection_violations":[{"id":4464616,"change_date":"2023-04-27 21:43:00","inspection_id":"78469224","insp_violation_id":"252484089","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4681919,"change_date":"2023-04-27 21:43:00","inspection_id":"78469224","insp_unit_id":"194627008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"32A","insp_unit_license":"BB08606","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD11JPJL5991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4681920,"change_date":"2023-04-27 21:43:00","inspection_id":"78469224","insp_unit_id":"194627009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"5144","insp_unit_license":"E313238","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9E5D839MA505144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4681921,"change_date":"2023-04-27 21:43:00","inspection_id":"78469224","insp_unit_id":"194627010","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"TRLR","insp_unit_company":"5145","insp_unit_license":"E313239","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D655MA505145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"}]},{"id":2741318,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","dot_number":"1693850","report_state":"MI","report_number":"BURGM05208","insp_date":"2023-04-04 00:00:00","insp_start_time":"0845","insp_end_time":"0922","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DIETZ RD","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1120651","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:18.000000Z","updated_at":"2025-03-17T19:17:18.000000Z","inspection_violations":[{"id":4207992,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_violation_id":"252064397","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194243998","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4207993,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_violation_id":"252064398","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194243998","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4207994,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_violation_id":"252064399","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194243998","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3939A"},{"id":4207995,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_violation_id":"252064400","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194243998","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3939A"},{"id":4207996,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_violation_id":"252064401","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194243998","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3939A"},{"id":4207997,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_violation_id":"252064402","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"194244000","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4412556,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_unit_id":"194243998","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"39A","insp_unit_license":"BB78638","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG0LPKX9200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:44.000000Z","updated_at":"2025-03-17T22:37:44.000000Z"},{"id":4412557,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_unit_id":"194243999","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"4372","insp_unit_license":"E214979","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L385GR054372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:44.000000Z","updated_at":"2025-03-17T22:37:44.000000Z"},{"id":4412558,"change_date":"2023-04-05 21:41:00","inspection_id":"78277888","insp_unit_id":"194244000","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"4373","insp_unit_license":"E214980","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H583GR054373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:44.000000Z","updated_at":"2025-03-17T22:37:44.000000Z"}]},{"id":2656618,"change_date":"2023-03-24 21:41:00","inspection_id":"78180719","dot_number":"1693850","report_state":"MI","report_number":"LECHR03017","insp_date":"2023-03-23 00:00:00","insp_start_time":"1550","insp_end_time":"1608","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"1515 LAKE LANSING RD","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","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":"1119352","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:34.000000Z","updated_at":"2025-03-17T19:15:34.000000Z","inspection_violations":[{"id":4082733,"change_date":"2023-03-24 21:41:00","inspection_id":"78180719","insp_violation_id":"251858513","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:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4277074,"change_date":"2023-03-24 21:41:00","inspection_id":"78180719","insp_unit_id":"194055095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA84255","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND10EDFY6922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"},{"id":4277075,"change_date":"2023-03-24 21:41:00","inspection_id":"78180719","insp_unit_id":"194055096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E096923","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F4YS600827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"},{"id":4277076,"change_date":"2023-03-24 21:41:00","inspection_id":"78180719","insp_unit_id":"194055097","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D531950","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195F8Y2600837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":2193423,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","dot_number":"1693850","report_state":"MI","report_number":"STUDM00567","insp_date":"2023-01-19 00:00:00","insp_start_time":"1500","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IRP LOT","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CRANDELL","shipping_paper_number":"23-801","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-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1110137","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-20 21:41:00","snet_input_date":"2023-01-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-20 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:59.000000Z","updated_at":"2025-03-17T19:06:59.000000Z","inspection_violations":[{"id":3387837,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","insp_violation_id":"250692132","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192985387","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39347E"},{"id":3387838,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","insp_violation_id":"250692133","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192985387","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39353B"},{"id":3387839,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","insp_violation_id":"250692134","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192985387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3939A"},{"id":3387840,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","insp_violation_id":"250692135","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192985387","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":3530321,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","insp_unit_id":"192985387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"7A","insp_unit_license":"BA64234","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14GPHD6433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:20.000000Z","updated_at":"2025-03-17T22:31:20.000000Z"},{"id":3530322,"change_date":"2023-01-20 21:41:00","inspection_id":"77653595","insp_unit_id":"192985388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2914","insp_unit_license":"E663194","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1DL387FR052914","insp_unit_decal":"Y","insp_unit_decal_number":"32322432","created_at":"2025-03-17T22:31:20.000000Z","updated_at":"2025-03-17T22:31:20.000000Z"}]},{"id":2115113,"change_date":"2023-01-11 21:42:00","inspection_id":"77563726","dot_number":"1693850","report_state":"MI","report_number":"COLLD02595","insp_date":"2023-01-11 00:00:00","insp_start_time":"0800","insp_end_time":"0841","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY, CHARLOTTE","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108637","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-11 21:42:00","snet_input_date":"2023-01-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:33.000000Z","updated_at":"2025-03-17T19:05:33.000000Z","inspection_violations":[{"id":3274739,"change_date":"2023-01-11 21:42:00","inspection_id":"77563726","insp_violation_id":"250507582","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"192810339","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39347E"},{"id":3274740,"change_date":"2023-01-11 21:42:00","inspection_id":"77563726","insp_violation_id":"250507583","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"192810339","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39353B"},{"id":3274741,"change_date":"2023-01-11 21:42:00","inspection_id":"77563726","insp_violation_id":"250507584","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192810339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3404117,"change_date":"2023-01-11 21:42:00","inspection_id":"77563726","insp_unit_id":"192810338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"50A","insp_unit_license":"BD14592","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG1PLNZ2705","insp_unit_decal":"Y","insp_unit_decal_number":"32324049","created_at":"2025-03-17T22:30:23.000000Z","updated_at":"2025-03-17T22:30:23.000000Z"},{"id":3404118,"change_date":"2023-01-11 21:42:00","inspection_id":"77563726","insp_unit_id":"192810339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"9410","insp_unit_license":"B400145","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS24345C009410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:23.000000Z","updated_at":"2025-03-17T22:30:23.000000Z"}]},{"id":2131999,"change_date":"2023-01-12 21:42:00","inspection_id":"77583018","dot_number":"1693850","report_state":"MI","report_number":"LINEM00393","insp_date":"2023-01-11 00:00:00","insp_start_time":"0720","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY, CHARLOTTE","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","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":"1108784","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-12 21:42:00","snet_input_date":"2023-01-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:53.000000Z","updated_at":"2025-03-17T19:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3430964,"change_date":"2023-01-12 21:42:00","inspection_id":"77583018","insp_unit_id":"192848078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"44A","insp_unit_license":"BC48445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG7MPMU2250","insp_unit_decal":"Y","insp_unit_decal_number":"32322414","created_at":"2025-03-17T22:30:36.000000Z","updated_at":"2025-03-17T22:30:36.000000Z"},{"id":3430965,"change_date":"2023-01-12 21:42:00","inspection_id":"77583018","insp_unit_id":"192848079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"4372","insp_unit_license":"E214979","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L385GR054372","insp_unit_decal":"Y","insp_unit_decal_number":"32322415","created_at":"2025-03-17T22:30:36.000000Z","updated_at":"2025-03-17T22:30:36.000000Z"}]},{"id":2132000,"change_date":"2023-01-12 21:42:00","inspection_id":"77583019","dot_number":"1693850","report_state":"MI","report_number":"LINEM00394","insp_date":"2023-01-11 00:00:00","insp_start_time":"0755","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","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":"1108759","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-12 21:42:00","snet_input_date":"2023-01-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:53.000000Z","updated_at":"2025-03-17T19:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3430966,"change_date":"2023-01-12 21:42:00","inspection_id":"77583019","insp_unit_id":"192848080","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"48A","insp_unit_license":"BD21505","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG8PLNZ2703","insp_unit_decal":"Y","insp_unit_decal_number":"32322416","created_at":"2025-03-17T22:30:36.000000Z","updated_at":"2025-03-17T22:30:36.000000Z"},{"id":3430967,"change_date":"2023-01-12 21:42:00","inspection_id":"77583019","insp_unit_id":"192848081","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"9289","insp_unit_license":"E116492","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L3866RD39289","insp_unit_decal":"Y","insp_unit_decal_number":"32322441","created_at":"2025-03-17T22:30:36.000000Z","updated_at":"2025-03-17T22:30:36.000000Z"}]},{"id":2106290,"change_date":"2023-01-12 21:42:00","inspection_id":"77553512","dot_number":"1693850","report_state":"MI","report_number":"LINEM00389","insp_date":"2023-01-10 00:00:00","insp_start_time":"0615","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","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-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108308","transaction_code":"C","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:30.000000Z","updated_at":"2025-03-17T19:05:30.000000Z","inspection_violations":[{"id":3260630,"change_date":"2023-01-12 21:42:00","inspection_id":"77553512","insp_violation_id":"250544759","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192847295","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3389538,"change_date":"2023-01-12 21:42:00","inspection_id":"77553512","insp_unit_id":"192847295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"46A","insp_unit_license":"BD14576","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG4PLNZ2701","insp_unit_decal":"Y","insp_unit_decal_number":"32322405","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"},{"id":3389539,"change_date":"2023-01-12 21:42:00","inspection_id":"77553512","insp_unit_id":"192847296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"5111","insp_unit_license":"E313240","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D835MA505111","insp_unit_decal":"Y","insp_unit_decal_number":"32322406","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"},{"id":3389540,"change_date":"2023-01-12 21:42:00","inspection_id":"77553512","insp_unit_id":"192847297","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"UNK","insp_unit_company":"5112","insp_unit_license":"E313241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D651MA505112","insp_unit_decal":"Y","insp_unit_decal_number":"32322407","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"}]},{"id":2106291,"change_date":"2023-01-12 21:42:00","inspection_id":"77553513","dot_number":"1693850","report_state":"MI","report_number":"LINEM00390","insp_date":"2023-01-10 00:00:00","insp_start_time":"0715","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","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-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108400","transaction_code":"C","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:30.000000Z","updated_at":"2025-03-17T19:05:30.000000Z","inspection_violations":[{"id":3260631,"change_date":"2023-01-12 21:42:00","inspection_id":"77553513","insp_violation_id":"250544760","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192847298","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3389541,"change_date":"2023-01-12 21:42:00","inspection_id":"77553513","insp_unit_id":"192847298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"49A","insp_unit_license":"BD14578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFGXPLNZ2704","insp_unit_decal":"Y","insp_unit_decal_number":"32322408","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"},{"id":3389542,"change_date":"2023-01-12 21:42:00","inspection_id":"77553513","insp_unit_id":"192847299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"2912","insp_unit_license":"E796640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L383FR052912","insp_unit_decal":"Y","insp_unit_decal_number":"32322409","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"}]},{"id":2106292,"change_date":"2023-01-12 21:42:00","inspection_id":"77553514","dot_number":"1693850","report_state":"MI","report_number":"LINEM00391","insp_date":"2023-01-10 00:00:00","insp_start_time":"0750","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108321","transaction_code":"C","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:30.000000Z","updated_at":"2025-03-17T19:05:30.000000Z","inspection_violations":[{"id":3260632,"change_date":"2023-01-12 21:42:00","inspection_id":"77553514","insp_violation_id":"250544772","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192847318","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3389543,"change_date":"2023-01-12 21:42:00","inspection_id":"77553514","insp_unit_id":"192847317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"51A","insp_unit_license":"BD25035","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG8PPUG1730","insp_unit_decal":"Y","insp_unit_decal_number":"32322410","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"},{"id":3389544,"change_date":"2023-01-12 21:42:00","inspection_id":"77553514","insp_unit_id":"192847318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"4576","insp_unit_license":"E164900","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L3834RC34576","insp_unit_decal":"Y","insp_unit_decal_number":"32322411","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"}]},{"id":2106473,"change_date":"2023-01-12 21:42:00","inspection_id":"77553712","dot_number":"1693850","report_state":"MI","report_number":"COLLD02594","insp_date":"2023-01-10 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY, CHARLOTTE","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108210","transaction_code":"C","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:30.000000Z","updated_at":"2025-03-17T19:05:30.000000Z","inspection_violations":[{"id":3260889,"change_date":"2023-01-12 21:42:00","inspection_id":"77553712","insp_violation_id":"250544797","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192847339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3389855,"change_date":"2023-01-12 21:42:00","inspection_id":"77553712","insp_unit_id":"192847339","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"37A","insp_unit_license":"BB48444","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD13JPJT8178","insp_unit_decal":"Y","insp_unit_decal_number":"32322412","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"},{"id":3389856,"change_date":"2023-01-12 21:42:00","inspection_id":"77553712","insp_unit_id":"192847340","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"226","insp_unit_license":"D821601","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2039KC046227","insp_unit_decal":"Y","insp_unit_decal_number":"32322413","created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"}]},{"id":2115045,"change_date":"2023-01-11 21:42:00","inspection_id":"77563649","dot_number":"1693850","report_state":"MI","report_number":"LINEM00392","insp_date":"2023-01-10 00:00:00","insp_start_time":"0915","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"800 ISLAND HWY, CHARLOTTE","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EMPTY","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-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1108677","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2023-01-11 21:42:00","snet_input_date":"2023-01-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:33.000000Z","updated_at":"2025-03-17T19:05:33.000000Z","inspection_violations":[{"id":3274596,"change_date":"2023-01-11 21:42:00","inspection_id":"77563649","insp_violation_id":"250507415","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"192810215","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39360C"},{"id":3274597,"change_date":"2023-01-11 21:42:00","inspection_id":"77563649","insp_violation_id":"250507416","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"192810215","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":3404010,"change_date":"2023-01-11 21:42:00","inspection_id":"77563649","insp_unit_id":"192810215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"14A","insp_unit_license":"BC48434","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKMHD7X37M194846","insp_unit_decal":"Y","insp_unit_decal_number":"32322442","created_at":"2025-03-17T22:30:23.000000Z","updated_at":"2025-03-17T22:30:23.000000Z"}]},{"id":2012491,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","dot_number":"1693850","report_state":"MI","report_number":"HICKG01976","insp_date":"2022-12-21 00:00:00","insp_start_time":"1520","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LANSNG RD @ I-96","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-26 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1106864","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-12-26 21:31:00","snet_input_date":"2022-12-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-26 21:31:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:41.000000Z","updated_at":"2025-03-17T19:03:41.000000Z","inspection_violations":[{"id":3123471,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_violation_id":"250260318","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192574758","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"3939A"},{"id":3123472,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_violation_id":"250260319","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"192574758","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39319"},{"id":3123473,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_violation_id":"250260320","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"192574759","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"3939A"},{"id":3123474,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_violation_id":"250260321","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"3","insp_unit_id":"192574759","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":3237879,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_unit_id":"192574757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"37A","insp_unit_license":"BB48444","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD13JPJT8178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"},{"id":3237880,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_unit_id":"192574758","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E116492","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L3866RD39289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"},{"id":3237881,"change_date":"2022-12-26 21:31:00","inspection_id":"77446283","insp_unit_id":"192574759","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D689096","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H5896RD3929","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"}]},{"id":1807204,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","dot_number":"1693850","report_state":"MI","report_number":"HICKG01920","insp_date":"2022-11-22 00:00:00","insp_start_time":"1050","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LANSING RD @ CANAL RD","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103009","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[{"id":2825906,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768919","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192111104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"},{"id":2825907,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768920","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192111104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"},{"id":2825908,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768921","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192111104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"},{"id":2825909,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768922","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192111104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"},{"id":2825910,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768923","seq_no":"5","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"192111104","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39360C"},{"id":2825911,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768924","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192111104","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39378"},{"id":2825912,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768925","seq_no":"7","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192111105","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4144721","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3929A"},{"id":2825913,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_violation_id":"249768926","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192111105","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2907052,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_unit_id":"192111104","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14A","insp_unit_license":"BA64232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVXA7CG8ELFZ5528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"},{"id":2907053,"change_date":"2022-11-23 21:40:00","inspection_id":"77211594","insp_unit_id":"192111105","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"51","insp_unit_license":"D248790","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1K38XRRC16562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1458553,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","dot_number":"1693850","report_state":"MI","report_number":"STUDM00547","insp_date":"2022-10-05 00:00:00","insp_start_time":"1230","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANAL\/BILLWOOD","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CRANDALL","shipping_paper_number":"23-801","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1097518","transaction_code":"C","transaction_date":"2022-12-05 00:00:00","upload_date":"2022-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:28.000000Z","updated_at":"2025-03-17T18:53:28.000000Z","inspection_violations":[{"id":2296217,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_violation_id":"249939572","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192280041","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3939A"},{"id":2296218,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_violation_id":"249939573","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192280041","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3939A"},{"id":2296219,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_violation_id":"249939574","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192280042","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2296220,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_violation_id":"249939575","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"192280042","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"393207A"},{"id":2296221,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_violation_id":"249939576","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192280042","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2347990,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_unit_id":"192280041","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6A","insp_unit_license":"BA42239","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJALAVX7DX84681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"},{"id":2347991,"change_date":"2022-12-06 21:40:00","inspection_id":"76810670","insp_unit_id":"192280042","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"LEAD","insp_unit_license":"E096923","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F4YS600827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":1365917,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","dot_number":"1693850","report_state":"MI","report_number":"HICKG01857","insp_date":"2022-09-22 00:00:00","insp_start_time":"0900","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-69 @ POTTERVILLE REST AREA","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"20","oos_total":"7","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"19","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1096212","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-09-26 21:39:00","snet_input_date":"2022-09-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-26 21:39:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:57.000000Z","updated_at":"2025-03-17T18:51:57.000000Z","inspection_violations":[{"id":2160013,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641269","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"3922"},{"id":2160014,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641270","seq_no":"2","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"191095085","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39343A"},{"id":2160015,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641271","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191095085","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39345D"},{"id":2160016,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641272","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191095085","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"3963A1"},{"id":2160017,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641273","seq_no":"5","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"393201A"},{"id":2160018,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641274","seq_no":"6","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"393100B"},{"id":2160019,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641275","seq_no":"7","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"393104A"},{"id":2160020,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641276","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39347E"},{"id":2160021,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641277","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39353B"},{"id":2160022,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641278","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39347E"},{"id":2160023,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641279","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191095086","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"3963A1"},{"id":2160024,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641280","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"3963A1"},{"id":2160025,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641281","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39348A"},{"id":2160026,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641282","seq_no":"19","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"393100B"},{"id":2160027,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641283","seq_no":"14","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39347E"},{"id":2160028,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641284","seq_no":"15","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39353B"},{"id":2160029,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641285","seq_no":"16","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39347E"},{"id":2160030,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641286","seq_no":"17","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39347E"},{"id":2160031,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641287","seq_no":"18","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"39348A"},{"id":2160032,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_violation_id":"248641288","seq_no":"20","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"3","insp_unit_id":"191095087","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"393104A"}],"inspection_per_units":[{"id":2199517,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_unit_id":"191095085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"31","insp_unit_license":"BC33957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND16EDGA0821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"},{"id":2199518,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_unit_id":"191095086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":"31","insp_unit_license":"D180840","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT38S9YMSS1311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"},{"id":2199519,"change_date":"2022-09-26 21:39:00","inspection_id":"76703277","insp_unit_id":"191095087","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"BENS","insp_unit_company":null,"insp_unit_license":"E164659","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT5809YMSS1312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"}]},{"id":1063967,"change_date":"2022-08-17 21:40:00","inspection_id":"76352384","dot_number":"1693850","report_state":"MI","report_number":"BURGM04742","insp_date":"2022-08-15 00:00:00","insp_start_time":"1215","insp_end_time":"1253","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCOTT RD","county_code_state":"MI","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SCHLEGEL","shipping_paper_number":"48708","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1089583","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-08-17 21:40:00","snet_input_date":"2022-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:30.000000Z","updated_at":"2025-03-17T18:46:30.000000Z","inspection_violations":[{"id":1678732,"change_date":"2022-08-17 21:40:00","inspection_id":"76352384","insp_violation_id":"247793093","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:49.000000Z","updated_at":"2025-03-17T21:14:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1712095,"change_date":"2022-08-17 21:40:00","inspection_id":"76352384","insp_unit_id":"190374441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"7A","insp_unit_license":"BA64234","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14GPHD6433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"},{"id":1712096,"change_date":"2022-08-17 21:40:00","inspection_id":"76352384","insp_unit_id":"190374442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2914","insp_unit_license":"E663194","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L387FR052914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"},{"id":1712097,"change_date":"2022-08-17 21:40:00","inspection_id":"76352384","insp_unit_id":"190374443","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"2915","insp_unit_license":"E663195","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H585FR052915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"}]},{"id":1016388,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","dot_number":"1693850","report_state":"MI","report_number":"ECSJT00080","insp_date":"2022-08-10 00:00:00","insp_start_time":"1032","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LANSING RD\/WAVERLY RD","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CRANDELL BROS TRUCKING","shipping_paper_number":"113256.1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"131400","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1088599","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-08-11 21:38:00","snet_input_date":"2022-08-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:28.000000Z","updated_at":"2025-03-17T18:45:28.000000Z","inspection_violations":[{"id":1600262,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_violation_id":"247655702","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190259641","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"3965B"},{"id":1600263,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_violation_id":"247655703","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190259641","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"3963A1"},{"id":1600264,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_violation_id":"247655704","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190259641","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39347E"},{"id":1600265,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_violation_id":"247655705","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190259641","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39353B"},{"id":1600266,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_violation_id":"247655706","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"190259642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1635284,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_unit_id":"190259641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8A","insp_unit_license":"BA20011","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FUYFXYB8VA809878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:18.000000Z","updated_at":"2025-03-17T22:18:18.000000Z"},{"id":1635285,"change_date":"2022-08-11 21:38:00","inspection_id":"76296602","insp_unit_id":"190259642","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"1601","insp_unit_license":"D821452","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU243F7WS481601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:18.000000Z","updated_at":"2025-03-17T22:18:18.000000Z"}]},{"id":895317,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","dot_number":"1693850","report_state":"MI","report_number":"STUDM00531","insp_date":"2022-07-26 00:00:00","insp_start_time":"0825","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GUINEA\/BILLWOOD","county_code_state":"MI","county_code":"045","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","viol_total":"11","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1085497","transaction_code":"A","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1410529,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319559","seq_no":"1","part_no":"387","part_no_section":"303(b)(4)","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:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"387303B4"},{"id":1410530,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319560","seq_no":"2","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"189970597","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4017560","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39375B"},{"id":1410531,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319561","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189970597","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39347E"},{"id":1410532,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319562","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189970597","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39353B"},{"id":1410533,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319563","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189970597","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3939A"},{"id":1410534,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319564","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189970598","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39617C"},{"id":1410535,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319565","seq_no":"7","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"189970598","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4017560","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"393100B"},{"id":1410536,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319566","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189970598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3939A"},{"id":1410537,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319567","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189970598","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39348A"},{"id":1410538,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319568","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189970598","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3922"},{"id":1410539,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_violation_id":"247319569","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189970598","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1441099,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_unit_id":"189970597","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"29A","insp_unit_license":"BC33956","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJALAV76DV78359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"},{"id":1441100,"change_date":"2022-07-26 21:42:00","inspection_id":"76154985","insp_unit_id":"189970598","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"0827","insp_unit_license":"D180754","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F4YS600827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"}]},{"id":895318,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","dot_number":"1693850","report_state":"MI","report_number":"STUDM00532","insp_date":"2022-07-26 00:00:00","insp_start_time":"1525","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96\/WILLOW HWY","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1085762","transaction_code":"A","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1410540,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_violation_id":"247319570","seq_no":"1","part_no":"387","part_no_section":"303(b)(4)","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:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"387303B4"},{"id":1410541,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_violation_id":"247319571","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189970600","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4026717","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39617C"},{"id":1410542,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_violation_id":"247319572","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"3","insp_unit_id":"189970601","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39617C"},{"id":1410543,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_violation_id":"247319573","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"3","insp_unit_id":"189970601","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1441101,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_unit_id":"189970599","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"36A","insp_unit_license":"BB48445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14JPJT8206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"},{"id":1441102,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_unit_id":"189970600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EPAK","insp_unit_company":"5105","insp_unit_license":"E230932","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9E5D83XMA505105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"},{"id":1441103,"change_date":"2022-07-26 21:42:00","inspection_id":"76154986","insp_unit_id":"189970601","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EPAK","insp_unit_company":"5106","insp_unit_license":"E230933","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9E5D656MA505106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"}]},{"id":348116,"change_date":"2022-06-09 21:42:00","inspection_id":"75508411","dot_number":"1693850","report_state":"MI","report_number":"STUDM00505","insp_date":"2022-05-05 00:00:00","insp_start_time":"1020","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LANSING RD\/I96","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1074558","transaction_code":"C","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-05-09 21:41:00","snet_input_date":"2022-05-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-09 21:41:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:39.000000Z","updated_at":"2025-03-17T18:33:39.000000Z","inspection_violations":[{"id":546010,"change_date":"2022-06-09 21:42:00","inspection_id":"75508411","insp_violation_id":"246342819","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"3","insp_unit_id":"189153351","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:37.000000Z","updated_at":"2025-03-17T21:09:37.000000Z","normalized_code":"39323"}],"inspection_per_units":[{"id":562929,"change_date":"2022-06-09 21:42:00","inspection_id":"75508411","insp_unit_id":"189153349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"41A","insp_unit_license":"BC48442","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALFG7MPMU2247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"},{"id":562930,"change_date":"2022-06-09 21:42:00","inspection_id":"75508411","insp_unit_id":"189153350","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EPAK","insp_unit_company":"5111","insp_unit_license":"E313240","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D835MA505111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"},{"id":562931,"change_date":"2022-06-09 21:42:00","inspection_id":"75508411","insp_unit_id":"189153351","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EPAK","insp_unit_company":"5112","insp_unit_license":"E313241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1F9E5D651MA505112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"}]},{"id":100730,"change_date":"2022-04-04 21:40:00","inspection_id":"75211242","dot_number":"1693850","report_state":"MI","report_number":"MOREM04015","insp_date":"2022-04-04 00:00:00","insp_start_time":"0702","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MT HOPE HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1070319","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01693850","upload_search_indicator":null,"census_search_date":"2022-04-04 21:40:00","snet_input_date":"2022-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"CRANDELL BROTHERS TRUCKING","insp_carrier_street":"800 ISLAND HIGHWAY","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"MI","insp_carrier_zip_code":"48813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:25.000000Z","updated_at":"2025-03-17T18:29:25.000000Z","inspection_violations":[{"id":148154,"change_date":"2022-04-04 21:40:00","inspection_id":"75211242","insp_violation_id":"244941794","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:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3922"},{"id":148155,"change_date":"2022-04-04 21:40:00","inspection_id":"75211242","insp_violation_id":"244941795","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:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":163053,"change_date":"2022-04-04 21:40:00","inspection_id":"75211242","insp_unit_id":"187967847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"36A","insp_unit_license":"BB48445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD14JPJT8206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:12.000000Z","updated_at":"2025-03-17T22:09:12.000000Z"},{"id":163054,"change_date":"2022-04-04 21:40:00","inspection_id":"75211242","insp_unit_id":"187967848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"1351","insp_unit_license":"A162923","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F7YS691351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:12.000000Z","updated_at":"2025-03-17T22:09:12.000000Z"},{"id":163055,"change_date":"2022-04-04 21:40:00","inspection_id":"75211242","insp_unit_id":"187967849","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"1366","insp_unit_license":"A162922","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195FXYS691366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:12.000000Z","updated_at":"2025-03-17T22:09:12.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1693850\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1693850\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1693850\/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\/1693850\/inspections","per_page":100,"prev_page_url":null,"to":57,"total":57}