{"current_page":1,"data":[{"id":9189761,"change_date":"2025-07-18 21:40:00","inspection_id":"85258308","dot_number":"2860627","report_state":"TX","report_number":"V251915408","insp_date":"2025-07-11 00:00:00","insp_start_time":"0600","insp_end_time":"0621","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGUILA","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9642152","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2025-07-18 21:40:00","snet_input_date":"2025-07-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-18 21:40:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 EAST EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0910709","created_at":"2025-07-21T10:43:37.000000Z","updated_at":"2025-07-22T10:45:18.000000Z","inspection_violations":[{"id":14844855,"change_date":"2025-07-18 21:40:00","inspection_id":"85258308","insp_violation_id":"267502955","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207954665","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:46:20.000000Z","updated_at":"2025-07-22T10:46:39.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":15102914,"change_date":"2025-07-18 21:40:00","inspection_id":"85258308","insp_unit_id":"207954665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195646","insp_unit_license":"2627882","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC5JDJX1863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:37.000000Z","updated_at":"2025-07-22T09:45:58.000000Z"}]},{"id":9080312,"change_date":"2025-07-07 21:40:00","inspection_id":"85143337","dot_number":"2860627","report_state":"TX","report_number":"V251933284","insp_date":"2025-07-03 00:00:00","insp_start_time":"1115","insp_end_time":"1144","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 493 NB S. OF MILE","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGUILA FOOD DISTRIBUTION, LLC","shipping_paper_number":"293931","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":"Y","pen_cen_match":null,"final_status_date":"2025-07-07 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":"9627575","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 EAST EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0910709","created_at":"2025-07-11T10:44:37.000000Z","updated_at":"2025-07-11T10:44:37.000000Z","inspection_violations":[{"id":14623484,"change_date":"2025-07-07 21:40:00","inspection_id":"85143337","insp_violation_id":"267247288","seq_no":"1","part_no":"392","part_no_section":"2W","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-07-10T10:42:50.000000Z","updated_at":"2025-07-11T10:46:31.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":14901002,"change_date":"2025-07-07 21:40:00","inspection_id":"85143337","insp_unit_id":"207735249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195646","insp_unit_license":"2627882","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC5JDJX1863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:26.000000Z","updated_at":"2025-07-11T09:46:08.000000Z"}]},{"id":9056988,"change_date":"2025-07-03 21:34:00","inspection_id":"85118566","dot_number":"2860627","report_state":"TX","report_number":"V251673534","insp_date":"2025-06-27 00:00:00","insp_start_time":"0630","insp_end_time":"0719","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGUILA FOOD DISTRIBUTION LLC","shipping_paper_number":"293508","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-03 21:34: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":"9625755","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2025-07-03 21:34:00","snet_input_date":"2025-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-03 21:34:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 EAST EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0910709","created_at":"2025-07-07T10:07:33.000000Z","updated_at":"2025-07-07T10:07:33.000000Z","inspection_violations":[{"id":14575277,"change_date":"2025-07-03 21:34:00","inspection_id":"85118566","insp_violation_id":"267192497","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207691176","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:52.000000Z","updated_at":"2025-07-07T10:15:31.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14860476,"change_date":"2025-07-03 21:34:00","inspection_id":"85118566","insp_unit_id":"207691176","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195644","insp_unit_license":"2627880","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC1JDJX1861","insp_unit_decal":"Y","insp_unit_decal_number":"35112726","created_at":"2025-07-06T09:46:18.000000Z","updated_at":"2025-07-07T09:45:21.000000Z"}]},{"id":8619386,"change_date":"2025-05-13 21:41:00","inspection_id":"84656052","dot_number":"2860627","report_state":"TX","report_number":"V251851590","insp_date":"2025-05-09 00:00:00","insp_start_time":"0615","insp_end_time":"0642","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGUILA FOOD","shipping_paper_number":"530019","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-13 21:41: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":"9576020","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-05-17T10:04:12.000000Z","updated_at":"2025-05-17T10:09:09.000000Z","inspection_violations":[{"id":13704950,"change_date":"2025-05-13 21:41:00","inspection_id":"84656052","insp_violation_id":"266196849","seq_no":"1","part_no":"393","part_no_section":"67","insp_viol_unit":"1","insp_unit_id":"206834408","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-16T10:35:38.000000Z","updated_at":"2025-05-18T10:25:51.000000Z","normalized_code":"39367"}],"inspection_per_units":[{"id":14073674,"change_date":"2025-05-13 21:41:00","inspection_id":"84656052","insp_unit_id":"206834408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195644","insp_unit_license":"2627880","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC1JDJX1861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:47.000000Z","updated_at":"2025-05-17T09:51:05.000000Z"}]},{"id":8559724,"change_date":"2025-05-06 21:40:00","inspection_id":"84593220","dot_number":"2860627","report_state":"TX","report_number":"V251827003","insp_date":"2025-05-02 00:00:00","insp_start_time":"0715","insp_end_time":"0746","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGUILA","shipping_paper_number":"289117","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9570626","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2025-05-06 21:40:00","snet_input_date":"2025-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-05-09T10:26:08.000000Z","updated_at":"2025-05-10T10:52:10.000000Z","inspection_violations":[{"id":13568411,"change_date":"2025-05-06 21:40:00","inspection_id":"84593220","insp_violation_id":"266036729","seq_no":"1","part_no":"387","part_no_section":"303B4","insp_viol_unit":"1","insp_unit_id":"206667297","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:58:35.000000Z","updated_at":"2025-05-09T11:07:20.000000Z","normalized_code":"387303B4"},{"id":13568412,"change_date":"2025-05-06 21:40:00","inspection_id":"84593220","insp_violation_id":"266036730","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206667297","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:58:35.000000Z","updated_at":"2025-05-09T11:07:20.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13922677,"change_date":"2025-05-06 21:40:00","inspection_id":"84593220","insp_unit_id":"206667297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195644","insp_unit_license":"2627880","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC1JDJX1861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:15:14.000000Z","updated_at":"2025-05-10T10:03:33.000000Z"}]},{"id":8259157,"change_date":"2025-04-01 21:40:00","inspection_id":"84276602","dot_number":"2860627","report_state":"TX","report_number":"V251829823","insp_date":"2025-03-28 00:00:00","insp_start_time":"0740","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGUILAR FOOD DISTRIBUTORS","shipping_paper_number":"286254","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-31 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":"9537085","transaction_code":"C","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2025-03-31 21:41:00","snet_input_date":"2025-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-31 21:41:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-04-03T10:04:41.000000Z","updated_at":"2025-04-06T10:18:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13370159,"change_date":"2025-04-01 21:40:00","inspection_id":"84276602","insp_unit_id":"206102283","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195644","insp_unit_license":"2627880","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC1JDJX1861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-04T10:05:13.000000Z","updated_at":"2025-04-05T09:52:52.000000Z"}]},{"id":6008883,"change_date":"2026-04-09 22:03:00","inspection_id":"81892140","dot_number":"2860627","report_state":"TX","report_number":"V241430230","insp_date":"2024-06-12 00:00:00","insp_start_time":"0712","insp_end_time":"0739","registration_date":"2024-07-08 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SPUR 600 NORTH OF FM","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGUILA FOOD DISTRIBUTION, LLC","shipping_paper_number":"653","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":"Y","pen_cen_match":null,"final_status_date":"2024-06-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"9302453","transaction_code":"C","transaction_date":"2024-06-18 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2024-06-17 21:46:00","snet_input_date":"2024-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-17 21:46:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T20:21:52.000000Z","updated_at":"2026-04-20T09:43:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19985674,"change_date":"2026-04-09 22:03:00","inspection_id":"81892140","insp_unit_id":"212732250","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"396356","insp_unit_license":"PMX1801","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALACWFC5NDMV5638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:26:53.000000Z","updated_at":"2026-04-19T09:45:53.000000Z"}]},{"id":4636032,"change_date":"2026-04-09 21:58:00","inspection_id":"80395518","dot_number":"2860627","report_state":"TX","report_number":"V231243269","insp_date":"2023-11-25 00:00:00","insp_start_time":"0921","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MILITARY HWY WEST OF","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGUILA FOOD DISTRIBUTION, LLC","shipping_paper_number":"247270","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":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:44: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":"9148211","transaction_code":"C","transaction_date":"2023-12-14 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2023-12-14 21:44:00","snet_input_date":"2023-11-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:44:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T19:54:36.000000Z","updated_at":"2026-04-20T09:37:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19937075,"change_date":"2026-04-09 21:58:00","inspection_id":"80395518","insp_unit_id":"212670232","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"195644","insp_unit_license":"2627880","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC1JDJX1861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:26:12.000000Z","updated_at":"2026-04-19T09:25:42.000000Z"}]},{"id":2267646,"change_date":"2023-03-29 21:42:00","inspection_id":"77738091","dot_number":"2860627","report_state":"TX","report_number":"6HYM0AODD3","insp_date":"2023-01-22 00:00:00","insp_start_time":"2230","insp_end_time":"2300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 83 AND LEO AVE","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":"2023-03-29 21:42: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":"8892448","transaction_code":"C","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2023-03-29 21:42:00","snet_input_date":"2023-01-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T19:08:29.000000Z","updated_at":"2025-03-17T19:08:29.000000Z","inspection_violations":[{"id":3498724,"change_date":"2023-03-29 21:42:00","inspection_id":"77738091","insp_violation_id":"251940500","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"194129803","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":"39021A"},{"id":3498725,"change_date":"2023-03-29 21:42:00","inspection_id":"77738091","insp_violation_id":"251940501","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194129804","insp_violation_category_id":"29","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":"39617C"}],"inspection_per_units":[{"id":3650402,"change_date":"2023-03-29 21:42:00","inspection_id":"77738091","insp_unit_id":"194129803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"385097","insp_unit_license":"R537183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2NSMT0216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:10.000000Z","updated_at":"2025-03-17T22:32:10.000000Z"},{"id":3650403,"change_date":"2023-03-29 21:42:00","inspection_id":"77738091","insp_unit_id":"194129804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"243","insp_unit_license":"177B962","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2533H2030402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:10.000000Z","updated_at":"2025-03-17T22:32:10.000000Z"}]},{"id":2159192,"change_date":"2023-01-17 21:42:00","inspection_id":"77614699","dot_number":"2860627","report_state":"TX","report_number":"6HH60AOCED","insp_date":"2023-01-05 00:00:00","insp_start_time":"0648","insp_end_time":"0715","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGUILA FOOD DISTRIBUTION","shipping_paper_number":"218921","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8877687","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T19:06:18.000000Z","updated_at":"2025-03-17T19:06:18.000000Z","inspection_violations":[{"id":3337191,"change_date":"2023-01-17 21:42:00","inspection_id":"77614699","insp_violation_id":"250611127","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"3922"},{"id":3337192,"change_date":"2023-01-17 21:42:00","inspection_id":"77614699","insp_violation_id":"250611128","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39141A"},{"id":3337193,"change_date":"2023-01-17 21:42:00","inspection_id":"77614699","insp_violation_id":"250611129","seq_no":"4","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:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":3474982,"change_date":"2023-01-17 21:42:00","inspection_id":"77614699","insp_unit_id":"192909141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"302339","insp_unit_license":"SCC1347","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HAEUMML3PL194960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:54.000000Z","updated_at":"2025-03-17T22:30:54.000000Z"}]},{"id":2117555,"change_date":"2023-01-11 21:43:00","inspection_id":"77566494","dot_number":"2860627","report_state":"TX","report_number":"6HG90AOD9H","insp_date":"2023-01-04 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 83 AND STUART PLA","county_code_state":"TX","county_code":"061","insp_level_id":"1","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":"2023-01-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8875054","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T19:05:34.000000Z","updated_at":"2025-03-17T19:05:34.000000Z","inspection_violations":[{"id":3279087,"change_date":"2023-01-11 21:43:00","inspection_id":"77566494","insp_violation_id":"250515026","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192816555","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3408332,"change_date":"2023-01-11 21:43:00","inspection_id":"77566494","insp_unit_id":"192816555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"}]},{"id":1520734,"change_date":"2022-10-14 21:39:00","inspection_id":"76882623","dot_number":"2860627","report_state":"TX","report_number":"6F510AOD61","insp_date":"2022-10-13 00:00:00","insp_start_time":"0055","insp_end_time":"0115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","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":"VARIOUS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8801453","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:54:47.000000Z","updated_at":"2025-03-17T18:54:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2447529,"change_date":"2022-10-14 21:39:00","inspection_id":"76882623","insp_unit_id":"191454910","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"},{"id":2447530,"change_date":"2022-10-14 21:39:00","inspection_id":"76882623","insp_unit_id":"191454911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"95","insp_unit_license":"021C535","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA9622YB091521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"}]},{"id":1489954,"change_date":"2022-10-11 21:42:00","inspection_id":"76847208","dot_number":"2860627","report_state":"TX","report_number":"6EPM0MJKFO","insp_date":"2022-09-27 00:00:00","insp_start_time":"2248","insp_end_time":"2310","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","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-10-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8796364","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-10-11 21:42:00","snet_input_date":"2022-09-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-11 21:42:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:54:08.000000Z","updated_at":"2025-03-17T18:54:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2397933,"change_date":"2022-10-11 21:42:00","inspection_id":"76847208","insp_unit_id":"191383132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:25.000000Z","updated_at":"2025-03-17T22:23:25.000000Z"},{"id":2397934,"change_date":"2022-10-11 21:42:00","inspection_id":"76847208","insp_unit_id":"191383133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"58","insp_unit_license":"058B180","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25398U314640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:25.000000Z","updated_at":"2025-03-17T22:23:25.000000Z"}]},{"id":1047908,"change_date":"2022-08-22 21:43:00","inspection_id":"76333208","dot_number":"2860627","report_state":"TX","report_number":"6D770AOC0A","insp_date":"2022-08-04 00:00:00","insp_start_time":"0650","insp_end_time":"0726","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CONWAY NORTH OF US 8","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGUILA FOOD DISTRIBUTION, LLC","shipping_paper_number":"204436","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8743087","transaction_code":"C","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1650676,"change_date":"2022-08-22 21:43:00","inspection_id":"76333208","insp_violation_id":"247897122","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:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"38323A2"},{"id":1650677,"change_date":"2022-08-22 21:43:00","inspection_id":"76333208","insp_violation_id":"247897123","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39141A"},{"id":1650678,"change_date":"2022-08-22 21:43:00","inspection_id":"76333208","insp_violation_id":"247897124","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1686198,"change_date":"2022-08-22 21:43:00","inspection_id":"76333208","insp_unit_id":"190466828","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"396349","insp_unit_license":"PMW5772","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALACWFC2NDMV5631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":868596,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","dot_number":"2860627","report_state":"TX","report_number":"6CME0VIEHP","insp_date":"2022-07-14 00:00:00","insp_start_time":"1355","insp_end_time":"1458","registration_date":"2022-07-25 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN STARR CO. (794-840)","county_code_state":"TX","county_code":"427","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GRUPO GUSI SPR DE RL DE CV","shipping_paper_number":"S21000011988","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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8719774","transaction_code":"C","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-07-21 21:40:00","snet_input_date":"2022-07-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-21 21:40:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[{"id":1367723,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","insp_violation_id":"247290872","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189947958","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"},{"id":1367724,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","insp_violation_id":"247290873","seq_no":"2","part_no":"376","part_no_section":"11(d)(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:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"37611D1"},{"id":1367725,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","insp_violation_id":"247290874","seq_no":"3","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:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3958A1"},{"id":1367726,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","insp_violation_id":"247290875","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189947958","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1398355,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","insp_unit_id":"189947957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"},{"id":1398356,"change_date":"2022-07-25 21:40:00","inspection_id":"76123771","insp_unit_id":"189947958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"56","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537FU115910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"}]},{"id":663952,"change_date":"2022-06-21 21:42:00","inspection_id":"75884111","dot_number":"2860627","report_state":"TX","report_number":"6BS30AJRG8","insp_date":"2022-06-14 00:00:00","insp_start_time":"0337","insp_end_time":"0349","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","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-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8690214","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1067316,"change_date":"2022-06-21 21:42:00","inspection_id":"75884111","insp_unit_id":"189388450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"},{"id":1067317,"change_date":"2022-06-21 21:42:00","inspection_id":"75884111","insp_unit_id":"189388451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"221","insp_unit_license":"121C996","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2533J8031420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":641794,"change_date":"2022-06-27 21:41:00","inspection_id":"75857937","dot_number":"2860627","report_state":"TX","report_number":"6BLL0AHDO8","insp_date":"2022-06-07 00:00:00","insp_start_time":"2050","insp_end_time":"2110","registration_date":"2022-06-27 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN STARR CO. (794-840)","county_code_state":"TX","county_code":"427","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LAREDO COLD SERVICES","shipping_paper_number":"S21000011239","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-17 21:40: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":"8685446","transaction_code":"C","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-06-17 21:40:00","snet_input_date":"2022-06-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-17 21:40:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:39:08.000000Z","updated_at":"2025-03-17T18:39:08.000000Z","inspection_violations":[{"id":1008841,"change_date":"2022-06-27 21:41:00","inspection_id":"75857937","insp_violation_id":"246741634","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189483367","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:43.000000Z","updated_at":"2025-03-17T21:11:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1031564,"change_date":"2022-06-27 21:41:00","inspection_id":"75857937","insp_unit_id":"189483367","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:32.000000Z","updated_at":"2025-03-17T22:14:32.000000Z"},{"id":1031565,"change_date":"2022-06-27 21:41:00","inspection_id":"75857937","insp_unit_id":"189483368","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"55","insp_unit_license":"063C936","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV482W99L259406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:32.000000Z","updated_at":"2025-03-17T22:14:32.000000Z"}]},{"id":599147,"change_date":"2022-06-15 21:41:00","inspection_id":"75807386","dot_number":"2860627","report_state":"TX","report_number":"6BG90VIEET","insp_date":"2022-06-02 00:00:00","insp_start_time":"0945","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN STARR CO. (794-840)","county_code_state":"TX","county_code":"427","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGUILA FOOD DISTRIBUTION","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8677789","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":"02860627","upload_search_indicator":"M","census_search_date":"2022-06-13 21:42:00","snet_input_date":"2022-06-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-13 21:42:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:38:08.000000Z","updated_at":"2025-03-17T18:38:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":963334,"change_date":"2022-06-15 21:41:00","inspection_id":"75807386","insp_unit_id":"189274012","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447488","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR7CSBD6801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:07.000000Z","updated_at":"2025-03-17T22:14:07.000000Z"},{"id":963335,"change_date":"2022-06-15 21:41:00","inspection_id":"75807386","insp_unit_id":"189274013","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"63","insp_unit_license":"076B982","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537GU623702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:07.000000Z","updated_at":"2025-03-17T22:14:07.000000Z"}]},{"id":566551,"change_date":"2022-06-14 21:42:00","inspection_id":"75768242","dot_number":"2860627","report_state":"TX","report_number":"6B9M0AJRDN","insp_date":"2022-05-26 00:00:00","insp_start_time":"2229","insp_end_time":"2247","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LAREDO COLD SERVICES","shipping_paper_number":"521000011006","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-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"8671456","transaction_code":"C","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02860627","upload_search_indicator":"M","census_search_date":"2022-06-08 21:41:00","snet_input_date":"2022-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-08 21:41:00","insp_carrier_name":"AGUILA FOOD DISTRIBUTION LLC","insp_carrier_street":"3001 E EXPRESSWAY 83","insp_carrier_city":"MERCEDES","insp_carrier_state":"TX","insp_carrier_zip_code":"78570","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0910709","created_at":"2025-03-17T18:37:45.000000Z","updated_at":"2025-03-17T18:37:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":911558,"change_date":"2022-06-14 21:42:00","inspection_id":"75768242","insp_unit_id":"189245333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"354784","insp_unit_license":"R447388","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHHDR2LSLW9284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:49.000000Z","updated_at":"2025-03-17T22:13:49.000000Z"},{"id":911559,"change_date":"2022-06-14 21:42:00","inspection_id":"75768242","insp_unit_id":"189245334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"7248","insp_unit_license":"206C073","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2537N8588725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:49.000000Z","updated_at":"2025-03-17T22:13:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2860627\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2860627\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2860627\/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\/2860627\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}