{"current_page":1,"data":[{"id":5333444,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","dot_number":"3243752","report_state":"TX","report_number":"V241367149","insp_date":"2024-03-19 00:00:00","insp_start_time":"1030","insp_end_time":"1203","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 181 AND SH 123","county_code_state":"TX","county_code":"255","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RAMIREZ BOYZ TRUCKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"21","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"19","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9228541","transaction_code":"C","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[{"id":8229640,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522116","seq_no":"1","part_no":"387","part_no_section":"301(a)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"387301A"},{"id":8229641,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522117","seq_no":"2","part_no":"392","part_no_section":"71(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"13","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39271A"},{"id":8229642,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522118","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200031480","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39311"},{"id":8229643,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522119","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200031480","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39311"},{"id":8229644,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522120","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39311"},{"id":8229645,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522121","seq_no":"6","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"200031480","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"393207A"},{"id":8229646,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522122","seq_no":"7","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"393209E"},{"id":8229647,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522123","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39345B2"},{"id":8229648,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522124","seq_no":"9","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39345D"},{"id":8229649,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522125","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39347E"},{"id":8229650,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522126","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39353B"},{"id":8229651,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522127","seq_no":"12","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200031480","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39355E"},{"id":8229652,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522128","seq_no":"13","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39378"},{"id":8229653,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522129","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3939A"},{"id":8229654,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522130","seq_no":"15","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3958A1"},{"id":8229655,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522131","seq_no":"16","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39617C"},{"id":8229656,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522132","seq_no":"17","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3963A1"},{"id":8229657,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522133","seq_no":"18","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3963A1"},{"id":8229658,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522134","seq_no":"19","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"200031480","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3965B"},{"id":8229659,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522135","seq_no":"20","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3922"},{"id":8229660,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_violation_id":"258522136","seq_no":"21","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200031479","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8589208,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_unit_id":"200031479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"R702022","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X92J888852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"},{"id":8589209,"change_date":"2024-03-21 21:41:00","inspection_id":"81157166","insp_unit_id":"200031480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"03","insp_unit_license":"218B023","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS24981M586401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"}]},{"id":3738970,"change_date":"2023-08-14 21:43:00","inspection_id":"79401917","dot_number":"3243752","report_state":"TX","report_number":"V231083398","insp_date":"2023-07-15 00:00:00","insp_start_time":"0620","insp_end_time":"0633","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 83\/ MM 874","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9051856","transaction_code":"A","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T19:36:33.000000Z","updated_at":"2025-03-17T19:36:33.000000Z","inspection_violations":[{"id":5767731,"change_date":"2023-08-14 21:43:00","inspection_id":"79401917","insp_violation_id":"254645114","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"196522599","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39330"},{"id":5767732,"change_date":"2023-08-14 21:43:00","inspection_id":"79401917","insp_violation_id":"254645115","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196522599","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39378"},{"id":5767733,"change_date":"2023-08-14 21:43:00","inspection_id":"79401917","insp_violation_id":"254645116","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196522599","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39378"},{"id":5767734,"change_date":"2023-08-14 21:43:00","inspection_id":"79401917","insp_violation_id":"254645117","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196522599","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6012347,"change_date":"2023-08-14 21:43:00","inspection_id":"79401917","insp_unit_id":"196522599","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R402672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8X52474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"}]},{"id":2145240,"change_date":"2023-01-13 21:41:00","inspection_id":"77598155","dot_number":"3243752","report_state":"TX","report_number":"6HG49DCNYJ","insp_date":"2023-01-04 00:00:00","insp_start_time":"0411","insp_end_time":"0440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"800  ROBBIE ST","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLASSIC FRUIT","shipping_paper_number":"227077","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-01-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8876751","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2023-01-13 21:41:00","snet_input_date":"2023-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-13 21:41:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T19:06:14.000000Z","updated_at":"2025-03-17T19:06:14.000000Z","inspection_violations":[{"id":3319296,"change_date":"2023-01-13 21:41:00","inspection_id":"77598155","insp_violation_id":"250580466","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"38323A2"},{"id":3319297,"change_date":"2023-01-13 21:41:00","inspection_id":"77598155","insp_violation_id":"250580467","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3958"},{"id":3319298,"change_date":"2023-01-13 21:41:00","inspection_id":"77598155","insp_violation_id":"250580468","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3452366,"change_date":"2023-01-13 21:41:00","inspection_id":"77598155","insp_unit_id":"192877671","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R512174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X92J888852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"},{"id":3452367,"change_date":"2023-01-13 21:41:00","inspection_id":"77598155","insp_unit_id":"192877672","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"104C966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2539CU400202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"}]},{"id":2040542,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","dot_number":"3243752","report_state":"TX","report_number":"6H5D0XJLHT","insp_date":"2022-12-24 00:00:00","insp_start_time":"1354","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0281 IN JIM WELLS CO. (652-","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WALMART","shipping_paper_number":"172491","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8863626","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":null,"census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T19:04:20.000000Z","updated_at":"2025-03-17T19:04:20.000000Z","inspection_violations":[{"id":3162838,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324116","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192638413","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39345"},{"id":3162839,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324117","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192638413","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39345B2"},{"id":3162840,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324118","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192638413","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39345B2"},{"id":3162841,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324119","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"192638413","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39383G"},{"id":3162842,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324120","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192638413","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39375C"},{"id":3162843,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324121","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192638413","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"3939A"},{"id":3162844,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324122","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"192638414","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39345B2"},{"id":3162845,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_violation_id":"250324123","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192638414","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3282822,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_unit_id":"192638413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R402672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8XR832474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:30.000000Z","updated_at":"2025-03-17T22:29:30.000000Z"},{"id":3282823,"change_date":"2022-12-29 21:40:00","inspection_id":"77478245","insp_unit_id":"192638414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COMM","insp_unit_company":"T04","insp_unit_license":"181B904","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XEU857460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:30.000000Z","updated_at":"2025-03-17T22:29:30.000000Z"}]},{"id":1918122,"change_date":"2022-12-09 21:40:00","inspection_id":"77338531","dot_number":"3243752","report_state":"TX","report_number":"6GNG0XCFFE","insp_date":"2022-12-06 00:00:00","insp_start_time":"1604","insp_end_time":"1637","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C399","location_desc":"US-0281 IN BROOKS CO. (708-742","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DRISCOLL'S","shipping_paper_number":"OR03102822","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8847554","transaction_code":"A","transaction_date":"2022-12-09 00:00:00","upload_date":"2022-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2022-12-09 21:40:00","snet_input_date":"2022-12-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-09 21:40:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T19:01:54.000000Z","updated_at":"2025-03-17T19:01:54.000000Z","inspection_violations":[{"id":2982703,"change_date":"2022-12-09 21:40:00","inspection_id":"77338531","insp_violation_id":"250033007","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192362837","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:12.000000Z","updated_at":"2025-03-17T21:21:12.000000Z","normalized_code":"39378"},{"id":2982704,"change_date":"2022-12-09 21:40:00","inspection_id":"77338531","insp_violation_id":"250033008","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"192362837","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:12.000000Z","updated_at":"2025-03-17T21:21:12.000000Z","normalized_code":"39355D2"},{"id":2982705,"change_date":"2022-12-09 21:40:00","inspection_id":"77338531","insp_violation_id":"250033009","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"192362837","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:12.000000Z","updated_at":"2025-03-17T21:21:12.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":3086326,"change_date":"2022-12-09 21:40:00","inspection_id":"77338531","insp_unit_id":"192362837","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"R512174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X92J888852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:08.000000Z","updated_at":"2025-03-17T22:28:08.000000Z"},{"id":3086327,"change_date":"2022-12-09 21:40:00","inspection_id":"77338531","insp_unit_id":"192362838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R608","insp_unit_license":"104C966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2539CU400202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:08.000000Z","updated_at":"2025-03-17T22:28:08.000000Z"}]},{"id":1207739,"change_date":"2022-09-02 21:39:00","inspection_id":"76519599","dot_number":"3243752","report_state":"TX","report_number":"6DXG0AOA1Q","insp_date":"2022-08-30 00:00:00","insp_start_time":"1621","insp_end_time":"1639","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0281 IN HIDALGO CO. (742-81","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOCATION","shipping_paper_number":"30509","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-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"8762172","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1915493,"change_date":"2022-09-02 21:39:00","inspection_id":"76519599","insp_violation_id":"248203442","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190713645","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":1942406,"change_date":"2022-09-02 21:39:00","inspection_id":"76519599","insp_unit_id":"190713645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R402672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8XR832474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"},{"id":1942407,"change_date":"2022-09-02 21:39:00","inspection_id":"76519599","insp_unit_id":"190713646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"T04","insp_unit_license":"153B110","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538AM933901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":1127188,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","dot_number":"3243752","report_state":"TX","report_number":"6DQ00VMG2M","insp_date":"2022-08-22 00:00:00","insp_start_time":"2357","insp_end_time":"0021","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C399","location_desc":"US-0281 IN BROOKS CO. (708-742","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TBC LLC","shipping_paper_number":"5789","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8753358","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T18:47:33.000000Z","updated_at":"2025-03-17T18:47:33.000000Z","inspection_violations":[{"id":1780986,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","insp_violation_id":"247970704","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190523340","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"39378"},{"id":1780987,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","insp_violation_id":"247970705","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190523340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"3939A"},{"id":1780988,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","insp_violation_id":"247970706","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190523341","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"3939A"},{"id":1780989,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","insp_violation_id":"247970707","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190523341","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1813166,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","insp_unit_id":"190523340","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R402672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8XR832474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:30.000000Z","updated_at":"2025-03-17T22:19:30.000000Z"},{"id":1813167,"change_date":"2022-08-24 21:39:00","inspection_id":"76426073","insp_unit_id":"190523341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T04","insp_unit_license":"153B110","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538AM933901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:30.000000Z","updated_at":"2025-03-17T22:19:30.000000Z"}]},{"id":586996,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","dot_number":"3243752","report_state":"TX","report_number":"6BB90XVBQX","insp_date":"2022-05-28 00:00:00","insp_start_time":"0854","insp_end_time":"0929","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0077 IN SAN PATRICIO CO. (6","county_code_state":"TX","county_code":"409","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDEX FRESH","shipping_paper_number":"311027","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-06-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8673904","transaction_code":"C","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2022-06-10 21:41:00","snet_input_date":"2022-05-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-10 21:41:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T18:38:04.000000Z","updated_at":"2025-03-17T18:38:04.000000Z","inspection_violations":[{"id":920806,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","insp_violation_id":"246490252","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189272797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:21.000000Z","updated_at":"2025-03-17T21:11:21.000000Z","normalized_code":"39378"},{"id":920807,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","insp_violation_id":"246490253","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"189272797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:21.000000Z","updated_at":"2025-03-17T21:11:21.000000Z","normalized_code":"39360C"},{"id":920808,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","insp_violation_id":"246490254","seq_no":"3","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"189272797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:21.000000Z","updated_at":"2025-03-17T21:11:21.000000Z","normalized_code":"39379"},{"id":920809,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","insp_violation_id":"246490255","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189272797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:21.000000Z","updated_at":"2025-03-17T21:11:21.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":943234,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","insp_unit_id":"189272797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"R512174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X92J888852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:00.000000Z","updated_at":"2025-03-17T22:14:00.000000Z"},{"id":943235,"change_date":"2022-06-15 21:41:00","inspection_id":"75792293","insp_unit_id":"189272798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COMM","insp_unit_company":"904","insp_unit_license":"181B904","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XEU857460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:00.000000Z","updated_at":"2025-03-17T22:14:00.000000Z"}]},{"id":630853,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","dot_number":"3243752","report_state":"TX","report_number":"6B4D0YTQ7L","insp_date":"2022-05-21 00:00:00","insp_start_time":"1303","insp_end_time":"1359","registration_date":"2022-09-02 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0907 IN HIDALGO CO. (714-73","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8682410","transaction_code":"C","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03243752","upload_search_indicator":"M","census_search_date":"2022-06-16 21:43:00","snet_input_date":"2022-05-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"AURORA RAMIREZ","insp_carrier_street":"8222 N VAL VERDE RD","insp_carrier_city":"DONNA","insp_carrier_state":"TX","insp_carrier_zip_code":"78537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972217","created_at":"2025-03-17T18:38:49.000000Z","updated_at":"2025-03-17T18:38:49.000000Z","inspection_violations":[{"id":989528,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_violation_id":"248203980","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"190713930","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"393205C"},{"id":989529,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_violation_id":"248203981","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190713930","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39378"},{"id":989530,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_violation_id":"248203982","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190713930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39311"},{"id":989531,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_violation_id":"248203983","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190713930","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39345B2"},{"id":989532,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_violation_id":"248203984","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190713930","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":1014144,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_unit_id":"190713930","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R402672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8XR832474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:25.000000Z","updated_at":"2025-03-17T22:14:25.000000Z"},{"id":1014145,"change_date":"2022-09-02 21:39:00","inspection_id":"75845041","insp_unit_id":"190713931","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T04","insp_unit_license":"153B110","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538AM933901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:25.000000Z","updated_at":"2025-03-17T22:14:25.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3243752\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3243752\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3243752\/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\/3243752\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}