{"current_page":1,"data":[{"id":12376440,"change_date":"2026-07-29 21:42:00","inspection_id":"88339110","dot_number":"603957","report_state":"MI","report_number":"DIUBJ04233","insp_date":"2026-07-07 00:00:00","insp_start_time":"1550","insp_end_time":"1609","registration_date":null,"region":"ED","ci_status_code":"C","location":"141","location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FORD","shipping_paper_number":"657567","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":"U","pen_cen_match":"I","final_status_date":"2026-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3701350","transaction_code":"C","transaction_date":"2026-07-29 00:00:00","upload_date":"2026-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2026-07-29 21:42:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-07 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:27.000000Z","updated_at":"2026-08-09T09:30:05.000000Z","inspection_violations":[{"id":21538786,"change_date":"2026-07-29 21:42:00","inspection_id":"88339110","insp_violation_id":"275805661","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"214880706","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-10T09:59:42.000000Z","updated_at":"2026-08-09T09:44:41.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":21491164,"change_date":"2026-07-29 21:42:00","inspection_id":"88339110","insp_unit_id":"214880705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211783","insp_unit_license":"PWR3637","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYD49X2NJ126087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:52.000000Z","updated_at":"2026-08-09T09:01:15.000000Z"},{"id":21491165,"change_date":"2026-07-29 21:42:00","inspection_id":"88339110","insp_unit_id":"214880706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"62129","insp_unit_license":"549868ST","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1S12E9535GE533146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:52.000000Z","updated_at":"2026-08-09T09:01:15.000000Z"}]},{"id":12364057,"change_date":"2026-07-06 21:38:00","inspection_id":"88325815","dot_number":"603957","report_state":"IN","report_number":"9702004952","insp_date":"2026-06-29 00:00:00","insp_start_time":"1618","insp_end_time":"1707","registration_date":null,"region":"ED","ci_status_code":"C","location":"4365N","location_desc":"SEYMOUR IN","county_code_state":"IN","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WEGMANN AUTOMOTIVE","shipping_paper_number":"0080325443","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3688355","transaction_code":"A","transaction_date":"2026-07-05 00:00:00","upload_date":"2026-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2026-07-06 21:38:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-06 21:38:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-09T09:40:18.000000Z","updated_at":"2026-07-17T09:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21470644,"change_date":"2026-07-06 21:38:00","inspection_id":"88325815","insp_unit_id":"214457450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"62141","insp_unit_license":"3426998","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV5PSNL9456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-09T09:15:40.000000Z","updated_at":"2026-07-17T09:01:23.000000Z"}]},{"id":12251441,"change_date":"2026-06-22 21:40:00","inspection_id":"88209883","dot_number":"603957","report_state":"KY","report_number":"CV43337008","insp_date":"2026-06-22 00:00:00","insp_start_time":"1137","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"J & L WELDING AND FABRICATION,LLC","shipping_paper_number":"PGMC00000810","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2351994","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-22 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-06-22 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:57.000000Z","updated_at":"2026-07-03T09:31:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21275004,"change_date":"2026-06-22 21:40:00","inspection_id":"88209883","insp_unit_id":"214226074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62134","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:24.000000Z","updated_at":"2026-07-05T09:02:15.000000Z"},{"id":21275005,"change_date":"2026-06-22 21:40:00","inspection_id":"88209883","insp_unit_id":"214226075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"W29169","insp_unit_license":"41TLR30412","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D0JL072882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:24.000000Z","updated_at":"2026-07-05T09:02:15.000000Z"}]},{"id":11500970,"change_date":"2026-03-27 21:40:00","inspection_id":"87421058","dot_number":"603957","report_state":"MI","report_number":"BIEGK00687","insp_date":"2026-03-26 00:00:00","insp_start_time":"1305","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 1MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"ELECTRONIC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1264313","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:44.000000Z","updated_at":"2026-04-07T09:32:27.000000Z","inspection_violations":[{"id":19420050,"change_date":"2026-03-27 21:40:00","inspection_id":"87421058","insp_violation_id":"272691879","seq_no":"1","part_no":"395","part_no_section":"22H1-ELDNUM","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":"2026-03-30T10:20:06.000000Z","updated_at":"2026-04-07T09:48:42.000000Z","normalized_code":"39522H1ELDNUM"},{"id":19420051,"change_date":"2026-03-27 21:40:00","inspection_id":"87421058","insp_violation_id":"272691880","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","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-30T10:20:06.000000Z","updated_at":"2026-04-07T09:48:42.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":19702647,"change_date":"2026-03-27 21:40:00","inspection_id":"87421058","insp_unit_id":"212384211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3426999","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV0PSNL9459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:48.000000Z"}]},{"id":11350853,"change_date":"2026-03-12 21:39:00","inspection_id":"87268958","dot_number":"603957","report_state":"OH","report_number":"3258000406","insp_date":"2026-03-10 00:00:00","insp_start_time":"1237","insp_end_time":"1254","registration_date":null,"region":"ED","ci_status_code":"C","location":"BG R\/S","location_desc":"BOWLING GREEN OH","county_code_state":"OH","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EFTEC","shipping_paper_number":"00097439","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2994909","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2026-03-12 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-12 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:39:51.000000Z","updated_at":"2026-03-23T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19426050,"change_date":"2026-03-12 21:39:00","inspection_id":"87268958","insp_unit_id":"212096679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"211568","insp_unit_license":"PWR2961","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYD49X2NJ107507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:35.000000Z","updated_at":"2026-03-23T09:08:30.000000Z"},{"id":19426051,"change_date":"2026-03-12 21:39:00","inspection_id":"87268958","insp_unit_id":"212096680","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRICK COM","insp_unit_company":"62128","insp_unit_license":"549867ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9533GE533145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:35.000000Z","updated_at":"2026-03-23T09:08:30.000000Z"}]},{"id":11351414,"change_date":"2026-03-12 21:39:00","inspection_id":"87269558","dot_number":"603957","report_state":"OH","report_number":"3266001102","insp_date":"2026-03-10 00:00:00","insp_start_time":"0947","insp_end_time":"1017","registration_date":null,"region":"ED","ci_status_code":"C","location":"07","location_desc":"EATON OH","county_code_state":"OH","county_code":"135","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"THE SCHARINE GROUP INC.","shipping_paper_number":"7100523766","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2994201","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2026-03-12 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-12 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:39:51.000000Z","updated_at":"2026-03-23T09:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19426963,"change_date":"2026-03-12 21:39:00","inspection_id":"87269558","insp_unit_id":"212097757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"621-34","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:36.000000Z","updated_at":"2026-03-23T09:08:38.000000Z"},{"id":19426964,"change_date":"2026-03-12 21:39:00","inspection_id":"87269558","insp_unit_id":"212097758","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"H15496","insp_unit_license":"5458370","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D1TL661118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:36.000000Z","updated_at":"2026-03-23T09:08:38.000000Z"}]},{"id":10635875,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","dot_number":"603957","report_state":"MI","report_number":"DIUBJ03908","insp_date":"2026-01-12 00:00:00","insp_start_time":"2325","insp_end_time":"0024","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":"FORD","shipping_paper_number":"322875","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1256270","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:01.000000Z","updated_at":"2026-01-24T10:30:37.000000Z","inspection_violations":[{"id":17890630,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","insp_violation_id":"271168074","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211052815","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39375A3TAOL"},{"id":17890631,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","insp_violation_id":"271168075","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"211052815","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39345B2BHTD"},{"id":17890632,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","insp_violation_id":"271168076","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211052816","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39347E"},{"id":17890633,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","insp_violation_id":"271168077","seq_no":"4","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"211052816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":17838783,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","insp_unit_id":"211052815","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211568","insp_unit_license":"PWR2961","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYD49X2NJ107507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:11.000000Z"},{"id":17838784,"change_date":"2026-01-13 21:39:00","inspection_id":"86777018","insp_unit_id":"211052816","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"62128","insp_unit_license":"549867ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9533GE533145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:11.000000Z"}]},{"id":10633196,"change_date":"2026-01-13 21:39:00","inspection_id":"86774197","dot_number":"603957","report_state":"IN","report_number":"9955000316","insp_date":"2026-01-07 00:00:00","insp_start_time":"1302","insp_end_time":"1400","registration_date":null,"region":"CS","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CHICAGO MODIFICATION CENTER","shipping_paper_number":"000000000000001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2757797","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:35:59.000000Z","updated_at":"2026-01-24T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17834299,"change_date":"2026-01-13 21:39:00","inspection_id":"86774197","insp_unit_id":"211046521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"62141","insp_unit_license":"3426998","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV5PSNL9456","insp_unit_decal":"Y","insp_unit_decal_number":"36111645","created_at":"2026-01-16T10:08:35.000000Z","updated_at":"2026-01-24T10:01:53.000000Z"}]},{"id":10512027,"change_date":"2025-12-24 21:35:00","inspection_id":"86647274","dot_number":"603957","report_state":"OH","report_number":"3255001014","insp_date":"2025-12-22 00:00:00","insp_start_time":"1254","insp_end_time":"1355","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ELYRIA OH","county_code_state":"OH","county_code":"093","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":"U","pen_cen_match":"I","final_status_date":"2025-12-24 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2695345","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2025-12-24 21:35:00","snet_input_date":"2025-12-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-24 21:35:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-27T10:38:29.000000Z","updated_at":"2026-01-04T10:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17604478,"change_date":"2025-12-24 21:35:00","inspection_id":"86647274","insp_unit_id":"210790724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3746969","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV9PSNL9458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-27T10:09:24.000000Z","updated_at":"2026-01-04T10:00:11.000000Z"}]},{"id":9888782,"change_date":"2025-10-08 21:40:00","inspection_id":"85992672","dot_number":"603957","report_state":"MI","report_number":"WHEES03327","insp_date":"2025-10-08 00:00:00","insp_start_time":"0735","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"HWY","location_desc":"WB","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1245180","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:49.000000Z","updated_at":"2025-10-12T10:01:07.000000Z","inspection_violations":[{"id":16305124,"change_date":"2025-10-08 21:40:00","inspection_id":"85992672","insp_violation_id":"269178964","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:07.000000Z","updated_at":"2025-10-12T10:16:23.000000Z","normalized_code":"3922SLLML"},{"id":16305125,"change_date":"2025-10-08 21:40:00","inspection_id":"85992672","insp_violation_id":"269178965","seq_no":"2","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:07.000000Z","updated_at":"2025-10-12T10:16:23.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":16407292,"change_date":"2025-10-08 21:40:00","inspection_id":"85992672","insp_unit_id":"209366032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915068","insp_unit_license":"PWJ7939","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR7KSKR5056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:26.000000Z"},{"id":16407293,"change_date":"2025-10-08 21:40:00","inspection_id":"85992672","insp_unit_id":"209366033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"62124","insp_unit_license":"530129ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9538GE532072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:26.000000Z"}]},{"id":9864444,"change_date":"2025-10-09 21:41:00","inspection_id":"85967121","dot_number":"603957","report_state":"KY","report_number":"CV44930092","insp_date":"2025-10-06 00:00:00","insp_start_time":"1055","insp_end_time":"1157","registration_date":"2025-10-09 00:00:00","region":"ET","ci_status_code":"C","location":"9808","location_desc":"VERONA","county_code_state":"KY","county_code":"015","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"EFTEC","shipping_paper_number":"94727","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2308185","transaction_code":"C","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-06 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:48.000000Z","updated_at":"2025-10-13T10:01:05.000000Z","inspection_violations":[{"id":16329181,"change_date":"2025-10-09 21:41:00","inspection_id":"85967121","insp_violation_id":"269205166","seq_no":"1","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"209385659","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:33.000000Z","updated_at":"2025-10-13T10:16:45.000000Z","normalized_code":"39383H"},{"id":16329182,"change_date":"2025-10-09 21:41:00","inspection_id":"85967121","insp_violation_id":"269205167","seq_no":"2","part_no":"393","part_no_section":"201A-VFC","insp_viol_unit":"2","insp_unit_id":"209385660","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-10-12T10:17:33.000000Z","updated_at":"2025-10-13T10:16:45.000000Z","normalized_code":"393201AVFC"}],"inspection_per_units":[{"id":16425674,"change_date":"2025-10-09 21:41:00","inspection_id":"85967121","insp_unit_id":"209385659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"621-34","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:21.000000Z","updated_at":"2025-10-13T09:46:14.000000Z"},{"id":16425675,"change_date":"2025-10-09 21:41:00","inspection_id":"85967121","insp_unit_id":"209385660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"2956","insp_unit_license":"442680ST","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5V8VA5328CM205329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:21.000000Z","updated_at":"2025-10-13T09:46:14.000000Z"}]},{"id":9807647,"change_date":"2025-10-02 21:42:00","inspection_id":"85907485","dot_number":"603957","report_state":"MI","report_number":"HERLK02700","insp_date":"2025-09-26 00:00:00","insp_start_time":"1249","insp_end_time":"1316","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ SANDSTONE RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":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":"117350","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":"1243722","transaction_code":"C","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:23.000000Z","updated_at":"2025-10-05T10:01:44.000000Z","inspection_violations":[{"id":16193758,"change_date":"2025-10-02 21:42:00","inspection_id":"85907485","insp_violation_id":"269057076","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4603882","created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":16307371,"change_date":"2025-10-02 21:42:00","inspection_id":"85907485","insp_unit_id":"209263753","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","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":16307372,"change_date":"2025-10-02 21:42:00","inspection_id":"85907485","insp_unit_id":"209263754","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":null,"insp_unit_license":"530132ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9538GE532069","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":9645124,"change_date":"2025-09-10 21:40:00","inspection_id":"85736938","dot_number":"603957","report_state":"MI","report_number":"BIEGK00447","insp_date":"2025-09-10 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EFTEC NORTH AMERICA","shipping_paper_number":"94258","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1240389","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:39.000000Z","updated_at":"2025-09-13T10:47:39.000000Z","inspection_violations":[{"id":15786887,"change_date":"2025-09-10 21:40:00","inspection_id":"85736938","insp_violation_id":"268584663","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208853935","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-13T10:50:43.000000Z","updated_at":"2025-09-14T11:56:07.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15936268,"change_date":"2025-09-10 21:40:00","inspection_id":"85736938","insp_unit_id":"208853935","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915066","insp_unit_license":"PWH5386","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR3KSKR5054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"},{"id":15936269,"change_date":"2025-09-10 21:40:00","inspection_id":"85736938","insp_unit_id":"208853936","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRK","insp_unit_company":"8617","insp_unit_license":"450601ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9536DE526539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"}]},{"id":9546834,"change_date":"2025-08-29 21:40:00","inspection_id":"85634280","dot_number":"603957","report_state":"MI","report_number":"DUBOL00204","insp_date":"2025-08-27 00:00:00","insp_start_time":"1040","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 @ BEECH DALY RD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORD DEVEOPMENT CENTER","shipping_paper_number":"74427","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-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238628","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:32.000000Z","updated_at":"2025-09-06T10:42:32.000000Z","inspection_violations":[{"id":15585372,"change_date":"2025-08-29 21:40:00","inspection_id":"85634280","insp_violation_id":"268346825","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4584641","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":15757355,"change_date":"2025-08-29 21:40:00","inspection_id":"85634280","insp_unit_id":"208660907","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"621-37","insp_unit_license":"3295159","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACXFC4KHKN1232","insp_unit_decal":"Y","insp_unit_decal_number":"35455373","created_at":"2025-09-09T09:46:53.000000Z","updated_at":"2025-09-09T09:46:53.000000Z"}]},{"id":9351677,"change_date":"2025-08-07 21:39:00","inspection_id":"85428774","dot_number":"603957","report_state":"IN","report_number":"5417009697","insp_date":"2025-08-06 00:00:00","insp_start_time":"1300","insp_end_time":"1340","registration_date":null,"region":"CD","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CHICAGO MODIFICATION CENTER","shipping_paper_number":"16658","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"2098563","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:40.000000Z","updated_at":"2025-08-12T10:42:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15405331,"change_date":"2025-08-07 21:39:00","inspection_id":"85428774","insp_unit_id":"208280750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"62139","insp_unit_license":"3746969","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALAHNDV9PSNL9458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:19.000000Z","updated_at":"2025-08-11T09:45:40.000000Z"}]},{"id":8915717,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","dot_number":"603957","report_state":"IN","report_number":"8632008917","insp_date":"2025-06-11 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"PORTAGE IN","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TDM","shipping_paper_number":"16558","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":"U","pen_cen_match":"I","final_status_date":"2025-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"6","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":"1872613","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2025-06-17 21:40:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:47.000000Z","updated_at":"2025-06-22T10:00:12.000000Z","inspection_violations":[{"id":14298547,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_violation_id":"266879798","seq_no":"1","part_no":"395","part_no_section":"32B-ELDDFR","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-06-20T10:16:23.000000Z","updated_at":"2025-06-21T10:16:53.000000Z","normalized_code":"39532BELDDFR"},{"id":14298548,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_violation_id":"266879799","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:23.000000Z","updated_at":"2025-06-21T10:16:53.000000Z","normalized_code":"3922SLLLR"},{"id":14298549,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_violation_id":"266879800","seq_no":"3","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:23.000000Z","updated_at":"2025-06-21T10:16:53.000000Z","normalized_code":"3953A1HOSPD"},{"id":14298550,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_violation_id":"266879801","seq_no":"4","part_no":"395","part_no_section":"3A3II","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-06-20T10:16:23.000000Z","updated_at":"2025-06-21T10:16:53.000000Z","normalized_code":"3953A3II"},{"id":14298551,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_violation_id":"266879802","seq_no":"5","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:23.000000Z","updated_at":"2025-06-21T10:16:53.000000Z","normalized_code":"3958E1PC"},{"id":14298552,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_violation_id":"266879803","seq_no":"6","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:23.000000Z","updated_at":"2025-06-21T10:16:53.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":14608886,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_unit_id":"207418766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"915068","insp_unit_license":"PWJ7939","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR7KSKR5056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:00.000000Z","updated_at":"2025-06-22T09:45:16.000000Z"},{"id":14608887,"change_date":"2025-06-17 21:40:00","inspection_id":"84969502","insp_unit_id":"207418767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRICK COM","insp_unit_company":"62122","insp_unit_license":"530131ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9534GE532070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:00.000000Z","updated_at":"2025-06-22T09:45:16.000000Z"}]},{"id":7791274,"change_date":"2025-05-07 21:44:00","inspection_id":"83784769","dot_number":"603957","report_state":"TN","report_number":"I01R841195","insp_date":"2025-02-03 00:00:00","insp_start_time":"0846","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":"HAYWDE","location_desc":"HAYWOOD COUNTY SCALES EB","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1806736","transaction_code":"C","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2025-02-05 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"2TNS001","mcmis_add_date":"2025-02-05 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:56.000000Z","updated_at":"2025-05-11T10:14:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13952409,"change_date":"2025-05-07 21:44:00","inspection_id":"83784769","insp_unit_id":"206702298","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62140","insp_unit_license":"3376174","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"3ALAHNDV7PSNL9457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:28:05.000000Z","updated_at":"2025-05-11T03:13:13.000000Z"}]},{"id":7766223,"change_date":"2025-05-07 21:44:00","inspection_id":"83758414","dot_number":"603957","report_state":"TN","report_number":"I01R061258","insp_date":"2025-01-31 00:00:00","insp_start_time":"0738","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":"UNK","location_desc":"INTERSTATE 40","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"21161424","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-02-02 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1806291","transaction_code":"C","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2025-02-02 21:33:00","snet_input_date":"2025-01-31 00:00:00","source_office":"2TNS001","mcmis_add_date":"2025-02-02 21:33:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:31.000000Z","updated_at":"2025-05-11T10:14:26.000000Z","inspection_violations":[{"id":13592972,"change_date":"2025-05-07 21:44:00","inspection_id":"83758414","insp_violation_id":"266063178","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-09T11:18:08.000000Z","updated_at":"2025-05-10T11:31:54.000000Z","normalized_code":"3958EHOSPD"},{"id":13592973,"change_date":"2025-05-07 21:44:00","inspection_id":"83758414","insp_violation_id":"266063179","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-09T11:18:08.000000Z","updated_at":"2025-05-10T11:31:54.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":13952310,"change_date":"2025-05-07 21:44:00","inspection_id":"83758414","insp_unit_id":"206690558","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62140","insp_unit_license":"3376174","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"3ALAHNDV7PSNL9457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:28:05.000000Z","updated_at":"2025-05-11T03:13:11.000000Z"}]},{"id":7214797,"change_date":"2024-11-18 21:40:00","inspection_id":"83178513","dot_number":"603957","report_state":"IN","report_number":"3909006538","insp_date":"2024-11-14 00:00:00","insp_start_time":"1552","insp_end_time":"1637","registration_date":null,"region":"CS","ci_status_code":"C","location":"1394W","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BLOUGH INC","shipping_paper_number":"21160339","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","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":"1064596","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2024-11-18 21:40:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:29.000000Z","updated_at":"2025-03-17T20:46:29.000000Z","inspection_violations":[{"id":11276756,"change_date":"2024-11-18 21:40:00","inspection_id":"83178513","insp_violation_id":"262943911","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"203923337","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:44.000000Z","updated_at":"2025-03-17T22:00:44.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":11637513,"change_date":"2024-11-18 21:40:00","inspection_id":"83178513","insp_unit_id":"203923337","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"915068","insp_unit_license":"PWJ7939","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR7KSKR5056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:36.000000Z","updated_at":"2025-03-17T23:43:36.000000Z"},{"id":11637514,"change_date":"2024-11-18 21:40:00","inspection_id":"83178513","insp_unit_id":"203923338","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRICK COM","insp_unit_company":"62126","insp_unit_license":"549865ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E953XGE533143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:36.000000Z","updated_at":"2025-03-17T23:43:36.000000Z"}]},{"id":7174787,"change_date":"2024-11-12 21:42:00","inspection_id":"83136197","dot_number":"603957","report_state":"MI","report_number":"HOLLM04098","insp_date":"2024-11-08 00:00:00","insp_start_time":"0955","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"I-94 W\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"21160238","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-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1200950","transaction_code":"A","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11209264,"change_date":"2024-11-12 21:42:00","inspection_id":"83136197","insp_violation_id":"262849233","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":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLEWA1"},{"id":11209265,"change_date":"2024-11-12 21:42:00","inspection_id":"83136197","insp_violation_id":"262849234","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203842339","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":11572706,"change_date":"2024-11-12 21:42:00","inspection_id":"83136197","insp_unit_id":"203842339","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FHT","insp_unit_company":null,"insp_unit_license":"3376174","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV7PSNL9457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":6814818,"change_date":"2024-09-25 21:41:00","inspection_id":"82754087","dot_number":"603957","report_state":"IN","report_number":"9667000030","insp_date":"2024-09-19 00:00:00","insp_start_time":"1420","insp_end_time":"1516","registration_date":null,"region":"ED","ci_status_code":"C","location":"1394W","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FORD DEABORN","shipping_paper_number":"21159414","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"884089","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:14.000000Z","updated_at":"2025-03-17T20:38:14.000000Z","inspection_violations":[{"id":10612874,"change_date":"2024-09-25 21:41:00","inspection_id":"82754087","insp_violation_id":"262023590","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"203120564","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39375A2"}],"inspection_per_units":[{"id":10989572,"change_date":"2024-09-25 21:41:00","inspection_id":"82754087","insp_unit_id":"203120563","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"621-35","insp_unit_license":"2983884","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR8KLKM7104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"},{"id":10989573,"change_date":"2024-09-25 21:41:00","inspection_id":"82754087","insp_unit_id":"203120564","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"W17428","insp_unit_license":"393417Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D6GL951683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"}]},{"id":6645098,"change_date":"2024-09-17 21:45:00","inspection_id":"82573260","dot_number":"603957","report_state":"MI","report_number":"ANDER06642","insp_date":"2024-09-04 00:00:00","insp_start_time":"0450","insp_end_time":"0520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 22 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","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-09-04 21:42: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":"1193386","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-04 21:42:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:49.000000Z","updated_at":"2025-03-17T20:34:49.000000Z","inspection_violations":[{"id":10338343,"change_date":"2024-09-17 21:45:00","inspection_id":"82573260","insp_violation_id":"261857441","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202973924","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10713533,"change_date":"2024-09-17 21:45:00","inspection_id":"82573260","insp_unit_id":"202973924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PWJ7939","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR7KSKR5056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"},{"id":10713534,"change_date":"2024-09-17 21:45:00","inspection_id":"82573260","insp_unit_id":"202973925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"W17428","insp_unit_license":"393417Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D6GL951683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"}]},{"id":6613156,"change_date":"2024-09-04 21:42:00","inspection_id":"82539291","dot_number":"603957","report_state":"OH","report_number":"3240000482","insp_date":"2024-08-29 00:00:00","insp_start_time":"1141","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"09580","location_desc":"US 80\/90","county_code_state":"OH","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"TROY DESIGN AND MANUFACTURING","shipping_paper_number":"21159060","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1752630","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-30 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:05.000000Z","updated_at":"2025-03-17T20:34:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10662194,"change_date":"2024-09-04 21:42:00","inspection_id":"82539291","insp_unit_id":"202753315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FHT","insp_unit_company":"62141","insp_unit_license":"3426998","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV5PSNL9456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:25.000000Z","updated_at":"2025-03-17T23:33:25.000000Z"}]},{"id":6084502,"change_date":"2024-06-26 21:43:00","inspection_id":"81973557","dot_number":"603957","report_state":"OH","report_number":"3280010391","insp_date":"2024-06-26 00:00:00","insp_start_time":"0832","insp_end_time":"0902","registration_date":null,"region":"CT","ci_status_code":"C","location":"00113","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"113","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"EFTEC","shipping_paper_number":"00086838","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1736198","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-26 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9800088,"change_date":"2024-06-26 21:43:00","inspection_id":"81973557","insp_unit_id":"201607690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"621-34","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:32.000000Z","updated_at":"2025-03-17T23:24:32.000000Z"},{"id":9800089,"change_date":"2024-06-26 21:43:00","inspection_id":"81973557","insp_unit_id":"201607691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"167069","insp_unit_license":"251074C","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4828MM023609","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:32.000000Z","updated_at":"2025-03-17T23:24:32.000000Z"}]},{"id":5824465,"change_date":"2026-02-25 21:48:00","inspection_id":"81691941","dot_number":"603957","report_state":"IN","report_number":"9063000506","insp_date":"2024-05-20 00:00:00","insp_start_time":"1129","insp_end_time":"1200","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MISHAWAKA IN","county_code_state":"IN","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"QUAD INDUSTRIES","shipping_paper_number":"39132","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-23 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"32000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"507231","transaction_code":"C","transaction_date":"2024-05-22 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2024-05-23 21:40:00","snet_input_date":"2024-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-23 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:15.000000Z","updated_at":"2026-03-08T09:31:28.000000Z","inspection_violations":[{"id":18846874,"change_date":"2026-02-25 21:48:00","inspection_id":"81691941","insp_violation_id":"272018842","seq_no":"1","part_no":"392","part_no_section":"8-D","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":"2026-02-28T10:56:54.000000Z","updated_at":"2026-03-08T09:49:15.000000Z","normalized_code":"3928D"},{"id":18846875,"change_date":"2026-02-25 21:48:00","inspection_id":"81691941","insp_violation_id":"272018843","seq_no":"2","part_no":"395","part_no_section":"22H4-ELDBRODS","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":"2026-02-28T10:56:54.000000Z","updated_at":"2026-03-08T09:49:15.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":18846876,"change_date":"2026-02-25 21:48:00","inspection_id":"81691941","insp_violation_id":"272018844","seq_no":"3","part_no":"395","part_no_section":"22H1-ELDNUM","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":"2026-02-28T10:56:54.000000Z","updated_at":"2026-03-08T09:49:15.000000Z","normalized_code":"39522H1ELDNUM"}],"inspection_per_units":[{"id":19183094,"change_date":"2026-02-25 21:48:00","inspection_id":"81691941","insp_unit_id":"211821523","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"62142","insp_unit_license":"3426999","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV0PSNL9459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:13.000000Z","updated_at":"2026-03-08T09:05:47.000000Z"}]},{"id":5719520,"change_date":"2024-05-10 21:39:00","inspection_id":"81578051","dot_number":"603957","report_state":"OH","report_number":"1382000031","insp_date":"2024-05-10 00:00:00","insp_start_time":"1344","insp_end_time":"1359","registration_date":null,"region":"ET","ci_status_code":"C","location":"149","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"149","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"FORD","shipping_paper_number":"613095","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":"I","final_status_date":"2024-05-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1725446","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-10 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:57.000000Z","updated_at":"2025-03-17T20:15:57.000000Z","inspection_violations":[{"id":8849677,"change_date":"2024-05-10 21:39:00","inspection_id":"81578051","insp_violation_id":"259432649","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200831967","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9212130,"change_date":"2024-05-10 21:39:00","inspection_id":"81578051","insp_unit_id":"200831966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"621-34","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"},{"id":9212131,"change_date":"2024-05-10 21:39:00","inspection_id":"81578051","insp_unit_id":"200831967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"31495","insp_unit_license":"4907KM","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532C9GT131914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"}]},{"id":5390700,"change_date":"2024-03-28 21:41:00","inspection_id":"81219333","dot_number":"603957","report_state":"MI","report_number":"HERLK02106","insp_date":"2024-03-27 00:00:00","insp_start_time":"1436","insp_end_time":"1453","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MGA RESEARCH","shipping_paper_number":"S1429964","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-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1171045","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:28.000000Z","updated_at":"2025-03-17T20:09:28.000000Z","inspection_violations":[{"id":8319506,"change_date":"2024-03-28 21:41:00","inspection_id":"81219333","insp_violation_id":"258638066","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:46:13.000000Z","updated_at":"2025-03-17T21:46:13.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":8681987,"change_date":"2024-03-28 21:41:00","inspection_id":"81219333","insp_unit_id":"200137991","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FHT","insp_unit_company":"62141","insp_unit_license":"3426998","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV5PSNL9456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:45.000000Z","updated_at":"2025-03-17T23:13:45.000000Z"}]},{"id":4838921,"change_date":"2024-02-01 21:43:00","inspection_id":"80617152","dot_number":"603957","report_state":"OH","report_number":"3281022609","insp_date":"2024-01-16 00:00:00","insp_start_time":"1425","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"109","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"EFTEC NORTH AMERICA, LLC.","shipping_paper_number":"00083818","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1698924","transaction_code":"C","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-16 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:29.000000Z","updated_at":"2025-03-17T19:58:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7785325,"change_date":"2024-02-01 21:43:00","inspection_id":"80617152","insp_unit_id":"199223202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915067","insp_unit_license":"PWJ7940","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR5KSKR5055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"},{"id":7785326,"change_date":"2024-02-01 21:43:00","inspection_id":"80617152","insp_unit_id":"199223203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"U82516","insp_unit_license":"5307347","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532W37L058968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"}]},{"id":4570337,"change_date":"2023-12-06 21:42:00","inspection_id":"80323318","dot_number":"603957","report_state":"MI","report_number":"MALIK02082","insp_date":"2023-12-05 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ M59","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1155993","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:24.000000Z","updated_at":"2025-03-17T19:53:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7350753,"change_date":"2023-12-06 21:42:00","inspection_id":"80323318","insp_unit_id":"198376206","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"621-37","insp_unit_license":"3295159","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACXFC4KHKN1232","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"}]},{"id":4543273,"change_date":"2023-12-02 21:31:00","inspection_id":"80293548","dot_number":"603957","report_state":"IN","report_number":"9286004671","insp_date":"2023-11-30 00:00:00","insp_start_time":"1152","insp_end_time":"1250","registration_date":null,"region":"CS","ci_status_code":"C","location":"1394W","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"IINYX LIVONIA","shipping_paper_number":"938854","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-02 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"115061","transaction_code":"A","transaction_date":"2023-12-02 00:00:00","upload_date":"2023-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2023-12-02 21:31:00","snet_input_date":"2023-11-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-02 21:31:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:57.000000Z","updated_at":"2025-03-17T19:52:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7307008,"change_date":"2023-12-02 21:31:00","inspection_id":"80293548","insp_unit_id":"198317669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"621-34","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"Y","insp_unit_decal_number":"33455846","created_at":"2025-03-17T23:01:23.000000Z","updated_at":"2025-03-17T23:01:23.000000Z"},{"id":7307009,"change_date":"2023-12-02 21:31:00","inspection_id":"80293548","insp_unit_id":"198317670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"W86982","insp_unit_license":"438351Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D4LL190940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:23.000000Z","updated_at":"2025-03-17T23:01:23.000000Z"}]},{"id":4222123,"change_date":"2023-10-18 21:40:00","inspection_id":"79938929","dot_number":"603957","report_state":"IN","report_number":"4956009938","insp_date":"2023-10-17 00:00:00","insp_start_time":"1534","insp_end_time":"1608","registration_date":null,"region":"ED","ci_status_code":"C","location":"5570W","location_desc":"RICHMOND IN","county_code_state":"IN","county_code":"177","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FORD MOTOR COMPANY","shipping_paper_number":"133594","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","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":"70856","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":"2023-10-18 21:40:00","snet_input_date":"2023-10-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-18 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:35.000000Z","updated_at":"2025-03-17T19:46:35.000000Z","inspection_violations":[{"id":6537027,"change_date":"2023-10-18 21:40:00","inspection_id":"79938929","insp_violation_id":"255897112","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(ii)","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:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":6790067,"change_date":"2023-10-18 21:40:00","inspection_id":"79938929","insp_unit_id":"197610668","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3376174","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAHNDV7PSNL9457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:56.000000Z","updated_at":"2025-03-17T22:56:56.000000Z"}]},{"id":2266096,"change_date":"2023-01-31 21:43:00","inspection_id":"77736336","dot_number":"603957","report_state":"MI","report_number":"LULAN01639","insp_date":"2023-01-30 00:00:00","insp_start_time":"1445","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-96 @ M-59","county_code_state":"MI","county_code":"161","insp_level_id":"2","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":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1111457","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:29.000000Z","updated_at":"2025-03-17T19:08:29.000000Z","inspection_violations":[{"id":3496407,"change_date":"2023-01-31 21:43:00","inspection_id":"77736336","insp_violation_id":"250871637","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193155337","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3922"},{"id":3496408,"change_date":"2023-01-31 21:43:00","inspection_id":"77736336","insp_violation_id":"250871638","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193155336","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":3647710,"change_date":"2023-01-31 21:43:00","inspection_id":"77736336","insp_unit_id":"193155336","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"},{"id":3647711,"change_date":"2023-01-31 21:43:00","inspection_id":"77736336","insp_unit_id":"193155337","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4907KN","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532C9GT131914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"}]},{"id":2193505,"change_date":"2023-01-20 21:41:00","inspection_id":"77653696","dot_number":"603957","report_state":"MI","report_number":"DELMT00248","insp_date":"2023-01-19 00:00:00","insp_start_time":"1540","insp_end_time":"1600","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-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1110016","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":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-20 21:41:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:59.000000Z","updated_at":"2025-03-17T19:06:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3530466,"change_date":"2023-01-20 21:41:00","inspection_id":"77653696","insp_unit_id":"192985579","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62116","insp_unit_license":"2983875","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGGDV3ESFN9204","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":1947720,"change_date":"2022-12-14 21:39:00","inspection_id":"77372412","dot_number":"603957","report_state":"MI","report_number":"MATTB04645","insp_date":"2022-12-13 00:00:00","insp_start_time":"1900","insp_end_time":"1915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ 17 MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORD","shipping_paper_number":"0000270271","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-12-14 21:39: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":"1105708","transaction_code":"A","transaction_date":"2022-12-13 00:00:00","upload_date":"2022-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-14 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:33.000000Z","updated_at":"2025-03-17T19:02:33.000000Z","inspection_violations":[{"id":3024885,"change_date":"2022-12-14 21:39:00","inspection_id":"77372412","insp_violation_id":"250100547","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:21:24.000000Z","updated_at":"2025-03-17T21:21:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3133827,"change_date":"2022-12-14 21:39:00","inspection_id":"77372412","insp_unit_id":"192428147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"019152","insp_unit_license":"PWT2157","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPBDP9XXLD683732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:27.000000Z","updated_at":"2025-03-17T22:28:27.000000Z"},{"id":3133828,"change_date":"2022-12-14 21:39:00","inspection_id":"77372412","insp_unit_id":"192428148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"62129","insp_unit_license":"549868ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E9535GE533146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:27.000000Z","updated_at":"2025-03-17T22:28:27.000000Z"}]},{"id":1647079,"change_date":"2022-11-01 21:40:00","inspection_id":"77027909","dot_number":"603957","report_state":"MI","report_number":"DEJOS00062","insp_date":"2022-10-31 00:00:00","insp_start_time":"1230","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES 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":"PRISM","shipping_paper_number":"14769","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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1100522","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2584885,"change_date":"2022-11-01 21:40:00","inspection_id":"77027909","insp_violation_id":"249369289","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191748245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2650200,"change_date":"2022-11-01 21:40:00","inspection_id":"77027909","insp_unit_id":"191748245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62120","insp_unit_license":"2983879","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGKDV6FSGN3257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":2841476,"change_date":"2023-04-19 21:42:00","inspection_id":"78391265","dot_number":"603957","report_state":"US","report_number":"1726000118","insp_date":"2022-10-11 00:00:00","insp_start_time":"1435","insp_end_time":"1451","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE EB SCALES","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"TROY DESIGN AND MANUFACTURING CO.","shipping_paper_number":"0000014726","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3460","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-20 00:00:00","source_office":"3MID001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:14.000000Z","updated_at":"2025-03-17T19:19:14.000000Z","inspection_violations":[{"id":4359074,"change_date":"2023-04-19 21:42:00","inspection_id":"78391265","insp_violation_id":"252316835","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194474834","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:20.000000Z","updated_at":"2025-03-17T21:27:20.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4572911,"change_date":"2023-04-19 21:42:00","inspection_id":"78391265","insp_unit_id":"194474834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"621-18","insp_unit_license":"2983877","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGKDV2FSGN3253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:04.000000Z","updated_at":"2025-03-17T22:39:04.000000Z"}]},{"id":1026357,"change_date":"2022-08-12 21:39:00","inspection_id":"76308189","dot_number":"603957","report_state":"IN","report_number":"7558004272","insp_date":"2022-08-09 00:00:00","insp_start_time":"0905","insp_end_time":"1000","registration_date":"2022-08-12 00:00:00","region":"CT","ci_status_code":"C","location":"1394E","location_desc":"#13  I-94 EB  PORTER","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"STEVE WALCH","shipping_paper_number":"12380159","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"2142767","transaction_code":"A","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-12 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-08-12 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:48.000000Z","updated_at":"2025-03-17T18:45:48.000000Z","inspection_violations":[{"id":1616945,"change_date":"2022-08-12 21:39:00","inspection_id":"76308189","insp_violation_id":"247683505","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190283206","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:34.000000Z","updated_at":"2025-03-17T21:14:34.000000Z","normalized_code":"39395A"},{"id":1616946,"change_date":"2022-08-12 21:39:00","inspection_id":"76308189","insp_violation_id":"247683506","seq_no":"2","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190283206","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:34.000000Z","updated_at":"2025-03-17T21:14:34.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":1651524,"change_date":"2022-08-12 21:39:00","inspection_id":"76308189","insp_unit_id":"190283206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62118","insp_unit_license":"2983877","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGKDV2FSGN3255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:24.000000Z","updated_at":"2025-03-17T22:18:24.000000Z"}]},{"id":748392,"change_date":"2022-07-05 21:42:00","inspection_id":"75983549","dot_number":"603957","report_state":"MI","report_number":"BRACG00801","insp_date":"2022-06-28 00:00:00","insp_start_time":"1244","insp_end_time":"1309","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RELIANCE FINISHING","shipping_paper_number":"WC06272022RP","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-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1082159","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1177827,"change_date":"2022-07-05 21:42:00","inspection_id":"75983549","insp_violation_id":"246884350","seq_no":"1","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189600105","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39353B"},{"id":1177828,"change_date":"2022-07-05 21:42:00","inspection_id":"75983549","insp_violation_id":"246884351","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189600105","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1203316,"change_date":"2022-07-05 21:42:00","inspection_id":"75983549","insp_unit_id":"189600105","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62120","insp_unit_license":"3983879","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGKDV6FSGN3257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]},{"id":377155,"change_date":"2022-05-12 21:41:00","inspection_id":"75542727","dot_number":"603957","report_state":"US","report_number":"0782000710","insp_date":"2022-05-10 00:00:00","insp_start_time":"1214","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"#13 I-94 WB PORTER","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"POWDER COAT","shipping_paper_number":"15316","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"4862","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-12 00:00:00","source_office":"3IND001","mcmis_add_date":"2022-05-12 21:41:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:02.000000Z","updated_at":"2025-03-17T18:34:02.000000Z","inspection_violations":[{"id":590396,"change_date":"2022-05-12 21:41:00","inspection_id":"75542727","insp_violation_id":"245751526","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188650983","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":609814,"change_date":"2022-05-12 21:41:00","inspection_id":"75542727","insp_unit_id":"188650983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62120","insp_unit_license":"2983879","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGKDV6FSGN3257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:55.000000Z","updated_at":"2025-03-17T22:11:55.000000Z"}]},{"id":319773,"change_date":"2022-05-04 21:41:00","inspection_id":"75474534","dot_number":"603957","report_state":"IN","report_number":"9015004036","insp_date":"2022-05-03 00:00:00","insp_start_time":"1125","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"1394E","location_desc":"#13  I-94 EB  PORTER","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2126995","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-04 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:00.000000Z","updated_at":"2025-03-17T18:33:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":517256,"change_date":"2022-05-04 21:41:00","inspection_id":"75474534","insp_unit_id":"188503295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"621-34","insp_unit_license":"2983883","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDR6KLKM7103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:22.000000Z","updated_at":"2025-03-17T22:11:22.000000Z"},{"id":517257,"change_date":"2022-05-04 21:41:00","inspection_id":"75474534","insp_unit_id":"188503296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"W17428","insp_unit_license":"393417Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D6GL951683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:22.000000Z","updated_at":"2025-03-17T22:11:22.000000Z"}]},{"id":186043,"change_date":"2022-04-15 21:37:00","inspection_id":"75314951","dot_number":"603957","report_state":"OH","report_number":"3220005927","insp_date":"2022-04-13 00:00:00","insp_start_time":"1232","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"EFTEC NORTH AMERICA LLC","shipping_paper_number":"70236","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1591360","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:50.000000Z","updated_at":"2025-03-17T18:30:50.000000Z","inspection_violations":[{"id":283577,"change_date":"2022-04-15 21:37:00","inspection_id":"75314951","insp_violation_id":"245187224","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"188178203","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":301337,"change_date":"2022-04-15 21:37:00","inspection_id":"75314951","insp_unit_id":"188178203","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915066","insp_unit_license":"PWH5386","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR3KSKR5054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:01.000000Z","updated_at":"2025-03-17T22:10:01.000000Z"},{"id":301338,"change_date":"2022-04-15 21:37:00","inspection_id":"75314951","insp_unit_id":"188178204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"2956","insp_unit_license":"442680ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"5V8VA5328CM205329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:01.000000Z","updated_at":"2025-03-17T22:10:01.000000Z"}]},{"id":88499,"change_date":"2022-04-01 21:39:00","inspection_id":"75196403","dot_number":"603957","report_state":"MI","report_number":"DETGT03693","insp_date":"2022-03-31 00:00:00","insp_start_time":"1020","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"36642","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-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1070122","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-01 21:39:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:08.000000Z","updated_at":"2025-03-17T18:29:08.000000Z","inspection_violations":[{"id":131313,"change_date":"2022-04-01 21:39:00","inspection_id":"75196403","insp_violation_id":"244911593","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:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":143689,"change_date":"2022-04-01 21:39:00","inspection_id":"75196403","insp_unit_id":"187939370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"621-38","insp_unit_license":"2983887","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALAGGDV9KSKN0104","insp_unit_decal":"Y","insp_unit_decal_number":"30967847","created_at":"2025-03-17T22:09:05.000000Z","updated_at":"2025-03-17T22:09:05.000000Z"}]},{"id":1170,"change_date":"2022-04-05 21:40:00","inspection_id":"75075274","dot_number":"603957","report_state":"OH","report_number":"3259011913","insp_date":"2022-03-17 00:00:00","insp_start_time":"1212","insp_end_time":"1243","registration_date":"2022-04-04 00:00:00","region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"EFTEC","shipping_paper_number":"69572","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-17 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1586368","transaction_code":"C","transaction_date":"2022-03-17 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00603957","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-03-17 21:31:00","insp_carrier_name":"RODRIGUEZ EXPEDITED FREIGHT SYSTEMS INC","insp_carrier_street":"9400 PELHAM ROAD","insp_carrier_city":"TAYLOR","insp_carrier_state":"MI","insp_carrier_zip_code":"48180","insp_colonia":null,"docket_number":"290964","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:42.000000Z","updated_at":"2025-03-17T18:27:42.000000Z","inspection_violations":[{"id":1340,"change_date":"2022-04-05 21:40:00","inspection_id":"75075274","insp_violation_id":"244972420","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"187996539","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:09.000000Z","updated_at":"2025-03-17T21:07:09.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1911,"change_date":"2022-04-05 21:40:00","inspection_id":"75075274","insp_unit_id":"187996539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915066","insp_unit_license":"PWH5386","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGLDR3KSKR5054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:16.000000Z","updated_at":"2025-03-17T22:08:16.000000Z"},{"id":1912,"change_date":"2022-04-05 21:40:00","inspection_id":"75075274","insp_unit_id":"187996540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":null,"insp_unit_license":"549865ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1S12E953XGE503143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:16.000000Z","updated_at":"2025-03-17T22:08:16.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/603957\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/603957\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/603957\/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\/603957\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}