{"current_page":1,"data":[{"id":6680280,"change_date":"2024-09-17 21:45:00","inspection_id":"82610755","dot_number":"3783697","report_state":"MI","report_number":"JURKV02761","insp_date":"2024-09-05 00:00:00","insp_start_time":"1100","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KENTUCKY FERTILIZER","shipping_paper_number":"420550","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1194125","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[{"id":10396610,"change_date":"2024-09-17 21:45:00","inspection_id":"82610755","insp_violation_id":"261865492","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10770884,"change_date":"2024-09-17 21:45:00","inspection_id":"82610755","insp_unit_id":"202980212","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2048","insp_unit_license":"RC29534","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR9HSGP5348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"},{"id":10770885,"change_date":"2024-09-17 21:45:00","inspection_id":"82610755","insp_unit_id":"202980213","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"1953","insp_unit_license":"E918205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327GS691953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6575366,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","dot_number":"3783697","report_state":"MI","report_number":"PEIFM06512","insp_date":"2024-08-27 00:00:00","insp_start_time":"0300","insp_end_time":"0355","registration_date":null,"region":"ET","ci_status_code":"C","location":"144","location_desc":"MONROE INSP BUILDING","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AJM","shipping_paper_number":"36813","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":"N","gross_comb_veh_wt":"120000","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":"1191811","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","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":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10219724,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","insp_violation_id":"261870195","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:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3922"},{"id":10219725,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","insp_violation_id":"261870196","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202984205","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":10219726,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","insp_violation_id":"261870197","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202984205","insp_violation_category_id":"23","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":"39375C"},{"id":10219727,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","insp_violation_id":"261870198","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202984205","insp_violation_category_id":"23","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":"39375C"}],"inspection_per_units":[{"id":10600440,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","insp_unit_id":"202984204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2046","insp_unit_license":"RC29533","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHD7986","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":10600441,"change_date":"2024-09-17 21:45:00","inspection_id":"82498879","insp_unit_id":"202984205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"129626T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532C1MR160669","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":6220311,"change_date":"2024-09-16 21:43:00","inspection_id":"82119478","dot_number":"3783697","report_state":"MI","report_number":"COPEK02694","insp_date":"2024-07-08 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ 26 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1185246","transaction_code":"C","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[{"id":9661226,"change_date":"2024-09-16 21:43:00","inspection_id":"82119478","insp_violation_id":"261825584","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202945366","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10021740,"change_date":"2024-09-16 21:43:00","inspection_id":"82119478","insp_unit_id":"202945365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2040","insp_unit_license":"RC33497","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR6HLHT3184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"},{"id":10021741,"change_date":"2024-09-16 21:43:00","inspection_id":"82119478","insp_unit_id":"202945366","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ABTR","insp_unit_company":"727804","insp_unit_license":"E570509","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C7KT266012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":6143303,"change_date":"2024-07-03 21:40:00","inspection_id":"82036769","dot_number":"3783697","report_state":"MI","report_number":"SCSKN00206","insp_date":"2024-07-01 00:00:00","insp_start_time":"1145","insp_end_time":"1224","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 & FRED MOORE HIGHWAY","county_code_state":"MI","county_code":"147","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"83751","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":"1184608","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[{"id":9536428,"change_date":"2024-07-03 21:40:00","inspection_id":"82036769","insp_violation_id":"260463618","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9895565,"change_date":"2024-07-03 21:40:00","inspection_id":"82036769","insp_unit_id":"201728602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2026","insp_unit_license":"RC29533","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHD7986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"},{"id":9895566,"change_date":"2024-07-03 21:40:00","inspection_id":"82036769","insp_unit_id":"201728603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"53255","insp_unit_license":"E918204","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329GB611584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":5616789,"change_date":"2024-04-29 21:42:00","inspection_id":"81466361","dot_number":"3783697","report_state":"UT","report_number":"24WT001339","insp_date":"2024-04-23 00:00:00","insp_start_time":"2036","insp_end_time":"2125","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT21","location_desc":"BRIGHAM CITY UT","county_code_state":"UT","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JM SMUCKER & SUBSIDIARIES","shipping_paper_number":"051500017423440","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"2","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":"437621","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-04-29 21:42:00","snet_input_date":"2024-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-29 21:42:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:55.000000Z","updated_at":"2025-03-17T20:13:55.000000Z","inspection_violations":[{"id":8687195,"change_date":"2024-04-29 21:42:00","inspection_id":"81466361","insp_violation_id":"259190459","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"39524"},{"id":8687196,"change_date":"2024-04-29 21:42:00","inspection_id":"81466361","insp_violation_id":"259190460","seq_no":"2","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":"C24200079","created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9048014,"change_date":"2024-04-29 21:42:00","inspection_id":"81466361","insp_unit_id":"200616714","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1994","insp_unit_license":"RC20160","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EHXGN943935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"},{"id":9048015,"change_date":"2024-04-29 21:42:00","inspection_id":"81466361","insp_unit_id":"200616715","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"141078","insp_unit_license":"E918445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2537EU772754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"}]},{"id":5447735,"change_date":"2024-04-05 21:40:00","inspection_id":"81281715","dot_number":"3783697","report_state":"MI","report_number":"SAHIW01681","insp_date":"2024-04-04 00:00:00","insp_start_time":"2235","insp_end_time":"2305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB-I-75 @ OUTER DR","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORTY SOLUTIONS","shipping_paper_number":"235-0039690","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1172115","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:40.000000Z","updated_at":"2025-03-17T20:10:40.000000Z","inspection_violations":[{"id":8408595,"change_date":"2024-04-05 21:40:00","inspection_id":"81281715","insp_violation_id":"258774743","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"39524D"},{"id":8408596,"change_date":"2024-04-05 21:40:00","inspection_id":"81281715","insp_violation_id":"258774744","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200262812","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8774900,"change_date":"2024-04-05 21:40:00","inspection_id":"81281715","insp_unit_id":"200262811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC29534","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR9HSGP5348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:36.000000Z","updated_at":"2025-03-17T23:14:36.000000Z"},{"id":8774901,"change_date":"2024-04-05 21:40:00","inspection_id":"81281715","insp_unit_id":"200262812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"1953","insp_unit_license":"E918205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327GS691953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:36.000000Z","updated_at":"2025-03-17T23:14:36.000000Z"}]},{"id":5491392,"change_date":"2024-04-11 21:41:00","inspection_id":"81329768","dot_number":"3783697","report_state":"MI","report_number":"LITTJ04981","insp_date":"2024-04-01 00:00:00","insp_start_time":"1330","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E\/B @ LIVERNOIS","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1173283","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[{"id":8480876,"change_date":"2024-04-11 21:41:00","inspection_id":"81329768","insp_violation_id":"258883228","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":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":8845684,"change_date":"2024-04-11 21:41:00","inspection_id":"81329768","insp_unit_id":"200356471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2024","insp_unit_license":"RC23158","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR7GLGW8621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"},{"id":8845685,"change_date":"2024-04-11 21:41:00","inspection_id":"81329768","insp_unit_id":"200356472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"PTLZ211669","insp_unit_license":"129626T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532C1MR160669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5287026,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","dot_number":"3783697","report_state":"MI","report_number":"PEIFM06099","insp_date":"2024-03-14 00:00:00","insp_start_time":"0120","insp_end_time":"0210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB AT SCALES","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAS","shipping_paper_number":"2177473591","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-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1168930","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:28.000000Z","updated_at":"2025-03-17T20:07:28.000000Z","inspection_violations":[{"id":8152350,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383862","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4341340","created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39524D"},{"id":8152351,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383863","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199914356","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39347E"},{"id":8152352,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383864","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199914356","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39353B"},{"id":8152353,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383865","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199914356","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39347E"},{"id":8152354,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383866","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199914356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"},{"id":8152355,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383867","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199914356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"},{"id":8152356,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383868","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199914356","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4341340","created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3963A1"},{"id":8152357,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383869","seq_no":"8","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199914357","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39375C"},{"id":8152358,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_violation_id":"258383870","seq_no":"9","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199914357","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":8513982,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_unit_id":"199914356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2024","insp_unit_license":"RC23158","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR7GLGW8621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"},{"id":8513983,"change_date":"2024-03-14 21:41:00","inspection_id":"81106476","insp_unit_id":"199914357","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"129626T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532C1MR160669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"}]},{"id":5188727,"change_date":"2024-03-15 21:40:00","inspection_id":"80999037","dot_number":"3783697","report_state":"KY","report_number":"CV44623889","insp_date":"2024-02-29 00:00:00","insp_start_time":"1834","insp_end_time":"1851","registration_date":"2024-03-15 00:00:00","region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PREMIER FOAM INC","shipping_paper_number":"413753","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-03-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"2212666","transaction_code":"C","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":"M","census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-03-01 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7996619,"change_date":"2024-03-15 21:40:00","inspection_id":"80999037","insp_violation_id":"258407580","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":"EP49758","created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8354559,"change_date":"2024-03-15 21:40:00","inspection_id":"80999037","insp_unit_id":"199934218","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2022","insp_unit_license":"RC33442","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDV2JSJX7301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"},{"id":8354560,"change_date":"2024-03-15 21:40:00","inspection_id":"80999037","insp_unit_id":"199934219","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"V101","insp_unit_license":"E741377","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327CS299906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4856621,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","dot_number":"3783697","report_state":"NY","report_number":"SPG0215311","insp_date":"2024-01-12 00:00:00","insp_start_time":"1400","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"20291A","location_desc":"AMSTERDAM (EXIT 27)","county_code_state":"NY","county_code":"057","insp_level_id":"3","service_center":"EA","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-01-18 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"3","driver_viol_total":"6","driver_oos_total":"3","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2900546","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":"M","census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:52.000000Z","updated_at":"2025-03-17T19:58:52.000000Z","inspection_violations":[{"id":7486382,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_violation_id":"257393172","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3958E1"},{"id":7486383,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_violation_id":"257393173","seq_no":"2","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3953A2"},{"id":7486384,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_violation_id":"257393174","seq_no":"3","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3953A3I"},{"id":7486385,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_violation_id":"257393175","seq_no":"4","part_no":"395","part_no_section":"26(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HLQSBZ","created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"39526B"},{"id":7486386,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_violation_id":"257393176","seq_no":"5","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HLQSJW","created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"39530B1"},{"id":7486387,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_violation_id":"257393177","seq_no":"6","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HLQST2","created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":7813851,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_unit_id":"199010825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2022","insp_unit_license":"RC33442","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDV2JSJX7301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:49.000000Z","updated_at":"2025-03-17T23:05:49.000000Z"},{"id":7813852,"change_date":"2024-01-18 21:45:00","inspection_id":"80636357","insp_unit_id":"199010826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"E918205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327GS691953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:49.000000Z","updated_at":"2025-03-17T23:05:49.000000Z"}]},{"id":4711710,"change_date":"2023-12-27 21:42:00","inspection_id":"80478304","dot_number":"3783697","report_state":"MI","report_number":"MATTB05509","insp_date":"2023-12-26 00:00:00","insp_start_time":"1435","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ 38 MM","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1158646","transaction_code":"A","transaction_date":"2023-12-26 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2023-12-27 21:42:00","snet_input_date":"2023-12-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-27 21:42:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:11.000000Z","updated_at":"2025-03-17T19:56:11.000000Z","inspection_violations":[{"id":7274640,"change_date":"2023-12-27 21:42:00","inspection_id":"80478304","insp_violation_id":"257067301","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":7578472,"change_date":"2023-12-27 21:42:00","inspection_id":"80478304","insp_unit_id":"198686251","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2040","insp_unit_license":"RC33497","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR6HLHT3184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:44.000000Z","updated_at":"2025-03-17T23:03:44.000000Z"},{"id":7578473,"change_date":"2023-12-27 21:42:00","inspection_id":"80478304","insp_unit_id":"198686252","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2018","insp_unit_license":"E963733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D9GL922663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:44.000000Z","updated_at":"2025-03-17T23:03:44.000000Z"}]},{"id":4586753,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","dot_number":"3783697","report_state":"NY","report_number":"SPT0531666","insp_date":"2023-12-04 00:00:00","insp_start_time":"1410","insp_end_time":"1554","registration_date":null,"region":"ES","ci_status_code":"C","location":"12001M","location_desc":"NY","county_code_state":"NY","county_code":"123","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"11","oos_total":"1","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1755447","transaction_code":"C","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2023-12-08 21:40:00","snet_input_date":"2023-12-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-08 21:40:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:46.000000Z","updated_at":"2025-05-24T10:04:36.000000Z","inspection_violations":[{"id":13836734,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345653","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206961925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39355E"},{"id":13836735,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345654","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"206961925","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"3963A1"},{"id":13836736,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345655","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2T81HGL3DP","created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"3922"},{"id":13836737,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345656","seq_no":"4","part_no":"392","part_no_section":"2FT","insp_viol_unit":"1","insp_unit_id":"206961924","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"3922FT"},{"id":13836738,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345657","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"206961924","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39311"},{"id":13836739,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345658","seq_no":"6","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"206961924","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39355C1"},{"id":13836740,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345659","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206961925","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39347E"},{"id":13836741,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345660","seq_no":"8","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"206961925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39353B"},{"id":13836742,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345661","seq_no":"9","part_no":"395","part_no_section":"26B","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39526B"},{"id":13836743,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345662","seq_no":"10","part_no":"392","part_no_section":"2-ML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"3922ML"},{"id":13836744,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_violation_id":"266345663","seq_no":"11","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:06.000000Z","updated_at":"2025-05-24T10:22:04.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":14191023,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_unit_id":"206961924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"2022","insp_unit_license":"RC33442","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDV2JSJX7301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:45.000000Z","updated_at":"2025-05-24T09:49:46.000000Z"},{"id":14191024,"change_date":"2025-05-20 21:41:00","inspection_id":"80341265","insp_unit_id":"206961925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"1953","insp_unit_license":"E918205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327GS691953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:45.000000Z","updated_at":"2025-05-24T09:49:46.000000Z"}]},{"id":3988388,"change_date":"2023-09-17 21:31:00","inspection_id":"79679879","dot_number":"3783697","report_state":"NC","report_number":"0006576236","insp_date":"2023-09-17 00:00:00","insp_start_time":"1051","insp_end_time":"1143","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-77,","location_desc":"I-77, SOUTH","county_code_state":"NC","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"WALTERS FOODS LLC","shipping_paper_number":"4-508573","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-17 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2109339","transaction_code":"A","transaction_date":"2023-09-17 00:00:00","upload_date":"2023-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":"M","census_search_date":"2023-09-17 21:31:00","snet_input_date":"2023-09-17 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-09-17 21:31:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[{"id":6170065,"change_date":"2023-09-17 21:31:00","inspection_id":"79679879","insp_violation_id":"255310265","seq_no":"1","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:49.000000Z","updated_at":"2025-03-17T21:35:49.000000Z","normalized_code":"39532B"}],"inspection_per_units":[{"id":6413206,"change_date":"2023-09-17 21:31:00","inspection_id":"79679879","insp_unit_id":"197090028","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2048","insp_unit_license":"RC29534","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHD7986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"},{"id":6413207,"change_date":"2023-09-17 21:31:00","inspection_id":"79679879","insp_unit_id":"197090029","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIT","insp_unit_company":"141078","insp_unit_license":"E918445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2537EU772754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"}]},{"id":3888754,"change_date":"2023-09-01 21:39:00","inspection_id":"79569172","dot_number":"3783697","report_state":"MI","report_number":"DIUBJ02713","insp_date":"2023-09-01 00:00:00","insp_start_time":"0100","insp_end_time":"0130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 NB AT MM 24","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL STEERING SYSTEMS","shipping_paper_number":"A923420","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143904","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[{"id":6009529,"change_date":"2023-09-01 21:39:00","inspection_id":"79569172","insp_violation_id":"255045650","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3958F1"},{"id":6009530,"change_date":"2023-09-01 21:39:00","inspection_id":"79569172","insp_violation_id":"255045651","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196865424","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3939A"},{"id":6009531,"change_date":"2023-09-01 21:39:00","inspection_id":"79569172","insp_violation_id":"255045652","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196865424","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6252113,"change_date":"2023-09-01 21:39:00","inspection_id":"79569172","insp_unit_id":"196865423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC29533","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHD7986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"},{"id":6252114,"change_date":"2023-09-01 21:39:00","inspection_id":"79569172","insp_unit_id":"196865424","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E356085","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA062X6W700002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"}]},{"id":3845373,"change_date":"2023-08-30 21:44:00","inspection_id":"79520814","dot_number":"3783697","report_state":"MI","report_number":"BLAKD03953","insp_date":"2023-08-26 00:00:00","insp_start_time":"0430","insp_end_time":"0450","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N75 @ DIXIE","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KAMCO","shipping_paper_number":"GENERAL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1142755","transaction_code":"C","transaction_date":"2023-08-26 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[{"id":5939137,"change_date":"2023-08-30 21:44:00","inspection_id":"79520814","insp_violation_id":"254981704","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6182535,"change_date":"2023-08-30 21:44:00","inspection_id":"79520814","insp_unit_id":"196811833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2022","insp_unit_license":"RC29854","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR3JSJW4280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"},{"id":6182536,"change_date":"2023-08-30 21:44:00","inspection_id":"79520814","insp_unit_id":"196811834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"53255","insp_unit_license":"E918204","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329GB611584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"}]},{"id":3723224,"change_date":"2023-08-30 21:45:00","inspection_id":"79384318","dot_number":"3783697","report_state":"MI","report_number":"WONTD00623","insp_date":"2023-08-10 00:00:00","insp_start_time":"1750","insp_end_time":"1815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ MM24","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EXPERT TECHNOLOGIES GROUP","shipping_paper_number":"262592","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-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1139913","transaction_code":"C","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5741106,"change_date":"2023-08-30 21:45:00","inspection_id":"79384318","insp_violation_id":"254989858","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:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3922"},{"id":5741107,"change_date":"2023-08-30 21:45:00","inspection_id":"79384318","insp_violation_id":"254989859","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":5986630,"change_date":"2023-08-30 21:45:00","inspection_id":"79384318","insp_unit_id":"196817783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2020","insp_unit_license":"RC27973","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH5HN994521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5986631,"change_date":"2023-08-30 21:45:00","inspection_id":"79384318","insp_unit_id":"196817784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"53255","insp_unit_license":"E918204","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329GB611584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3468330,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","dot_number":"3783697","report_state":"MI","report_number":"ESCOT01901","insp_date":"2023-07-08 00:00:00","insp_start_time":"1440","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LUNA PIER RD@N I-75","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BRIDGE LOGISTICS","shipping_paper_number":"0162050","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-07-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1134209","transaction_code":"A","transaction_date":"2023-07-08 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03783697","upload_search_indicator":null,"census_search_date":"2023-07-10 21:42:00","snet_input_date":"2023-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-10 21:42:00","insp_carrier_name":"CEDRA LLC","insp_carrier_street":"17301 FLORA ST","insp_carrier_city":"MELVINDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48122","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:41.000000Z","updated_at":"2025-03-17T19:31:41.000000Z","inspection_violations":[{"id":5346947,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958050","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195908096","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"3922"},{"id":5346948,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958051","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195908096","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39347E"},{"id":5346949,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958052","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195908096","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39347E"},{"id":5346950,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958053","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195908096","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4245052","created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"3963A1"},{"id":5346951,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958054","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195908096","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39375C"},{"id":5346952,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958055","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195908096","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39353B"},{"id":5346953,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958056","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"195908097","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39345D"},{"id":5346954,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_violation_id":"253958057","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"195908097","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":5576813,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_unit_id":"195908096","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2024","insp_unit_license":"RC23158","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR7GLGW8621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:02.000000Z","updated_at":"2025-03-17T22:47:02.000000Z"},{"id":5576814,"change_date":"2023-07-10 21:42:00","inspection_id":"79098751","insp_unit_id":"195908097","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"101","insp_unit_license":"E741377","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327CS299906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:02.000000Z","updated_at":"2025-03-17T22:47:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3783697\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3783697\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3783697\/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\/3783697\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}