{"current_page":1,"data":[{"id":12487088,"change_date":"2026-07-18 21:34:00","inspection_id":"88450163","dot_number":"1242162","report_state":"US","report_number":"2039001351","insp_date":"2026-07-17 00:00:00","insp_start_time":"1936","insp_end_time":"1953","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX08","location_desc":"PHARR TX","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SWEET SEASONS LLC","shipping_paper_number":"DR407034955","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-18 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3785646","transaction_code":"A","transaction_date":"2026-07-18 00:00:00","upload_date":"2026-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2026-07-18 21:34:00","snet_input_date":"2026-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-18 21:34:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-21T09:42:48.000000Z","updated_at":"2026-07-25T09:37:16.000000Z","inspection_violations":[{"id":21738670,"change_date":"2026-07-18 21:34:00","inspection_id":"88450163","insp_violation_id":"275591629","seq_no":"1","part_no":"391","part_no_section":"11B2-Z","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-21T10:05:41.000000Z","updated_at":"2026-07-25T09:54:42.000000Z","normalized_code":"39111B2Z"}],"inspection_per_units":[{"id":21687701,"change_date":"2026-07-18 21:34:00","inspection_id":"88450163","insp_unit_id":"214694852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"09","insp_unit_license":"48BF4K","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLD50GSFN3960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-21T09:20:21.000000Z","updated_at":"2026-07-25T09:13:44.000000Z"},{"id":21687702,"change_date":"2026-07-18 21:34:00","inspection_id":"88450163","insp_unit_id":"214694853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"A16232B","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0628DW700304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-21T09:20:21.000000Z","updated_at":"2026-07-25T09:13:44.000000Z"}]},{"id":11611672,"change_date":"2026-04-09 22:21:00","inspection_id":"87539284","dot_number":"1242162","report_state":"TX","report_number":"V262300743","insp_date":"2026-04-05 00:00:00","insp_start_time":"1129","insp_end_time":"1202","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A501","location_desc":"INDIOS POE","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-09 22:21: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":"9912545","transaction_code":"A","transaction_date":"2026-04-09 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-09 22:21:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA SUR","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2026-04-12T10:16:04.000000Z","updated_at":"2026-04-20T10:12:29.000000Z","inspection_violations":[{"id":20146179,"change_date":"2026-04-09 22:21:00","inspection_id":"87539284","insp_violation_id":"273507463","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"212938060","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:25.000000Z","updated_at":"2026-04-19T14:08:32.000000Z","normalized_code":"39311TU"}],"inspection_per_units":[{"id":20194740,"change_date":"2026-04-09 22:21:00","inspection_id":"87539284","insp_unit_id":"212938060","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"48BF4K","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLD50GSFN3960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:49.000000Z","updated_at":"2026-04-19T10:38:03.000000Z"}]},{"id":10836897,"change_date":"2026-04-09 22:18:00","inspection_id":"86865207","dot_number":"1242162","report_state":"TX","report_number":"V262175990","insp_date":"2026-01-20 00:00:00","insp_start_time":"1335","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A201","location_desc":"PHARR POE","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FAMILIA MONTES PRODUCE","shipping_paper_number":"580","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":"2026-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9828443","transaction_code":"C","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-22 21:39:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2026-01-25T10:37:02.000000Z","updated_at":"2026-04-20T10:08:26.000000Z","inspection_violations":[{"id":20072488,"change_date":"2026-04-09 22:18:00","inspection_id":"86865207","insp_violation_id":"273438306","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":"2026-04-11T10:21:27.000000Z","updated_at":"2026-04-19T13:48:36.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":20154634,"change_date":"2026-04-09 22:18:00","inspection_id":"86865207","insp_unit_id":"212905702","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":"03","insp_unit_license":"403EZ6","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"1XKADB9X17J199640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:16.000000Z","updated_at":"2026-04-19T10:28:15.000000Z"},{"id":20154635,"change_date":"2026-04-09 22:18:00","inspection_id":"86865207","insp_unit_id":"212905703","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-07","insp_unit_license":"A08086B","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537EM967721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:16.000000Z","updated_at":"2026-04-19T10:28:15.000000Z"}]},{"id":10836907,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","dot_number":"1242162","report_state":"TX","report_number":"V262180032","insp_date":"2026-01-16 00:00:00","insp_start_time":"1053","insp_end_time":"1132","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17M IH69E NB SVC RD","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO LOGISTICS SERVICES","shipping_paper_number":"5181","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":"Y","pen_cen_match":null,"final_status_date":"2026-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9828500","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-22 21:39:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2026-01-25T10:37:02.000000Z","updated_at":"2026-02-02T10:30:49.000000Z","inspection_violations":[{"id":18119752,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","insp_violation_id":"271366989","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"211241232","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:43.000000Z","updated_at":"2026-02-02T10:37:09.000000Z","normalized_code":"39345B2UV"},{"id":18119753,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","insp_violation_id":"271366990","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"211241232","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:43.000000Z","updated_at":"2026-02-02T10:37:09.000000Z","normalized_code":"39360D"},{"id":18119754,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","insp_violation_id":"271366991","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"211241232","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-01-25T10:42:43.000000Z","updated_at":"2026-02-02T10:37:09.000000Z","normalized_code":"39375A3"},{"id":18119755,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","insp_violation_id":"271366992","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"211241233","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-01-25T10:42:43.000000Z","updated_at":"2026-02-02T10:37:09.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":18206199,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","insp_unit_id":"211241232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"47BB4E","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"3AKJGLD50GSGZ3572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:21.000000Z","updated_at":"2026-02-02T10:03:20.000000Z"},{"id":18206200,"change_date":"2026-01-22 21:39:00","inspection_id":"86865217","insp_unit_id":"211241233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"010","insp_unit_license":"180C083","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2535CU265011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:21.000000Z","updated_at":"2026-02-02T10:03:20.000000Z"}]},{"id":10541806,"change_date":"2025-12-30 21:37:00","inspection_id":"86678281","dot_number":"1242162","report_state":"TX","report_number":"V252131425","insp_date":"2025-12-26 00:00:00","insp_start_time":"1330","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MILITARY ROAD EAST O","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FOWARDING MINFER & LOGISTICS","shipping_paper_number":"MEMA890610LA3","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-12-30 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9802020","transaction_code":"A","transaction_date":"2025-12-30 00:00:00","upload_date":"2025-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-30 21:37:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2026-01-02T10:36:40.000000Z","updated_at":"2026-01-10T10:30:32.000000Z","inspection_violations":[{"id":17705285,"change_date":"2025-12-30 21:37:00","inspection_id":"86678281","insp_violation_id":"270957119","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":"2026-01-02T10:40:39.000000Z","updated_at":"2026-01-10T10:31:14.000000Z","normalized_code":"3922W"},{"id":17705286,"change_date":"2025-12-30 21:37:00","inspection_id":"86678281","insp_violation_id":"270957120","seq_no":"2","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":"2026-01-02T10:40:39.000000Z","updated_at":"2026-01-10T10:31:14.000000Z","normalized_code":"3922W"},{"id":17705287,"change_date":"2025-12-30 21:37:00","inspection_id":"86678281","insp_violation_id":"270957121","seq_no":"3","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":"2026-01-02T10:40:39.000000Z","updated_at":"2026-01-10T10:31:14.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":17658551,"change_date":"2025-12-30 21:37:00","inspection_id":"86678281","insp_unit_id":"210855974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"4","insp_unit_license":"99AA2U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-02T10:06:25.000000Z","updated_at":"2026-01-10T10:00:38.000000Z"},{"id":17658552,"change_date":"2025-12-30 21:37:00","inspection_id":"86678281","insp_unit_id":"210855975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"012","insp_unit_license":"A10684B","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0628HW704486","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-02T10:06:25.000000Z","updated_at":"2026-01-10T10:00:38.000000Z"}]},{"id":10390641,"change_date":"2025-12-09 21:39:00","inspection_id":"86520412","dot_number":"1242162","report_state":"TX","report_number":"V252035030","insp_date":"2025-12-08 00:00:00","insp_start_time":"1823","insp_end_time":"1833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MILITARY ROADWAY EAS","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ABRAHAM MEDINA MARTINEZ","shipping_paper_number":"1021","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-12-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9781237","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-09 21:39:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-12-12T10:31:42.000000Z","updated_at":"2025-12-13T10:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17371196,"change_date":"2025-12-09 21:39:00","inspection_id":"86520412","insp_unit_id":"210509369","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETE","insp_unit_company":null,"insp_unit_license":"21AA2U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1XPHDB9X17N671885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:33.000000Z","updated_at":"2025-12-13T10:01:19.000000Z"},{"id":17371197,"change_date":"2025-12-09 21:39:00","inspection_id":"86520412","insp_unit_id":"210509370","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":null,"insp_unit_license":"A00466B","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204W001412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:33.000000Z","updated_at":"2025-12-13T10:01:19.000000Z"}]},{"id":10009707,"change_date":"2025-10-22 21:39:00","inspection_id":"86120358","dot_number":"1242162","report_state":"TX","report_number":"V252033350","insp_date":"2025-10-15 00:00:00","insp_start_time":"2035","insp_end_time":"2110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MIL 281 \/ MCCOL","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FORWARDING MINFER & LOGISTICS","shipping_paper_number":"962","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-10-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9734333","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-22 21:39:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-10-25T10:01:42.000000Z","updated_at":"2025-10-26T10:01:12.000000Z","inspection_violations":[{"id":16548444,"change_date":"2025-10-22 21:39:00","inspection_id":"86120358","insp_violation_id":"269456751","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-10-25T10:17:30.000000Z","updated_at":"2025-10-26T10:16:52.000000Z","normalized_code":"3922W"},{"id":16548445,"change_date":"2025-10-22 21:39:00","inspection_id":"86120358","insp_violation_id":"269456752","seq_no":"2","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-10-25T10:17:30.000000Z","updated_at":"2025-10-26T10:16:52.000000Z","normalized_code":"3922W"},{"id":16548446,"change_date":"2025-10-22 21:39:00","inspection_id":"86120358","insp_violation_id":"269456753","seq_no":"3","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-10-25T10:17:30.000000Z","updated_at":"2025-10-26T10:16:52.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16626412,"change_date":"2025-10-22 21:39:00","inspection_id":"86120358","insp_unit_id":"209604263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"47BB4E","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLD50GSGZ3572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:51.000000Z","updated_at":"2025-10-26T09:46:29.000000Z"},{"id":16626413,"change_date":"2025-10-22 21:39:00","inspection_id":"86120358","insp_unit_id":"209604264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"010","insp_unit_license":"180C083","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2535CU265011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:51.000000Z","updated_at":"2025-10-26T09:46:29.000000Z"}]},{"id":9529265,"change_date":"2025-08-28 21:40:00","inspection_id":"85615441","dot_number":"1242162","report_state":"US","report_number":"2039000421","insp_date":"2025-08-27 00:00:00","insp_start_time":"2030","insp_end_time":"2053","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX08","location_desc":"PHARR TX","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SWEET SEASONS","shipping_paper_number":"DR406614799","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2188530","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2025-08-28 21:40:00","snet_input_date":"2025-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-28 21:40:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:05.000000Z","updated_at":"2025-09-06T10:42:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15727336,"change_date":"2025-08-28 21:40:00","inspection_id":"85615441","insp_unit_id":"208627133","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"02","insp_unit_license":"79AT9D","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLDRXESFD0309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:29.000000Z","updated_at":"2025-09-09T09:46:29.000000Z"},{"id":15727337,"change_date":"2025-08-28 21:40:00","inspection_id":"85615441","insp_unit_id":"208627134","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"014","insp_unit_license":"A00571B","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06217S701127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:29.000000Z","updated_at":"2025-09-09T09:46:29.000000Z"}]},{"id":8679042,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","dot_number":"1242162","report_state":"TX","report_number":"V251667612","insp_date":"2025-05-14 00:00:00","insp_start_time":"1021","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 281 WEST OF CAGE","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FAMILIA MONTES PRODUCE","shipping_paper_number":"434","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-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9582490","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-05-22T10:01:41.000000Z","updated_at":"2025-05-23T10:05:50.000000Z","inspection_violations":[{"id":13821872,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327819","seq_no":"1","part_no":"393","part_no_section":"13C3","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"39313C3"},{"id":13821873,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327820","seq_no":"2","part_no":"393","part_no_section":"201A","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"393201A"},{"id":13821874,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327821","seq_no":"3","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"206947776","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"393207A"},{"id":13821875,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327822","seq_no":"4","part_no":"393","part_no_section":"207A","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"393207A"},{"id":13821876,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327823","seq_no":"5","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"206947776","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"393209E"},{"id":13821877,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327824","seq_no":"6","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"39355E"},{"id":13821878,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327825","seq_no":"7","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"39375C"},{"id":13821879,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327826","seq_no":"8","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"206947776","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"39383G"},{"id":13821880,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327827","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"3939"},{"id":13821881,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327828","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206947777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"3939"},{"id":13821882,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_violation_id":"266327829","seq_no":"11","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206947776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":14178557,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_unit_id":"206947776","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26","insp_unit_license":"21AA2U","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"1XPHDB9X17N671885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:22.000000Z","updated_at":"2025-05-23T09:51:07.000000Z"},{"id":14178558,"change_date":"2025-05-19 21:40:00","inspection_id":"84718742","insp_unit_id":"206947777","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"013","insp_unit_license":"A00466B","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204W001412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:22.000000Z","updated_at":"2025-05-23T09:51:07.000000Z"}]},{"id":8372033,"change_date":"2025-04-14 21:41:00","inspection_id":"84395426","dot_number":"1242162","report_state":"TX","report_number":"V251831131","insp_date":"2025-04-09 00:00:00","insp_start_time":"2000","insp_end_time":"2032","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 281 MILITARY HIGH","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MACAFE IMPORT-EXPORT LLC","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":"2025-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9549291","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-04-17T10:05:42.000000Z","updated_at":"2025-04-18T10:23:51.000000Z","inspection_violations":[{"id":13195415,"change_date":"2025-04-14 21:41:00","inspection_id":"84395426","insp_violation_id":"265614101","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"206305575","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:30:01.000000Z","updated_at":"2025-04-18T10:47:57.000000Z","normalized_code":"39311TL"},{"id":13195416,"change_date":"2025-04-14 21:41:00","inspection_id":"84395426","insp_violation_id":"265614102","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206305576","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:30:01.000000Z","updated_at":"2025-04-18T10:47:57.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":13587182,"change_date":"2025-04-14 21:41:00","inspection_id":"84395426","insp_unit_id":"206305575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"79AT9D","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLDRXESFD0309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:58:26.000000Z","updated_at":"2025-04-18T10:04:23.000000Z"},{"id":13587183,"change_date":"2025-04-14 21:41:00","inspection_id":"84395426","insp_unit_id":"206305576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"016","insp_unit_license":"A92212A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354U125185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:58:26.000000Z","updated_at":"2025-04-18T10:04:23.000000Z"}]},{"id":7845348,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","dot_number":"1242162","report_state":"TX","report_number":"V251706474","insp_date":"2025-02-10 00:00:00","insp_start_time":"1548","insp_end_time":"1632","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 493 AND US281 MIL","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO LOGISTICS SERVICES CORP","shipping_paper_number":"5156","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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9495831","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[{"id":12259655,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_violation_id":"264466368","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"205276321","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39355E"},{"id":12259656,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_violation_id":"264466369","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205276320","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3963A1"},{"id":12259657,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_violation_id":"264466370","seq_no":"3","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-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922W"},{"id":12259658,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_violation_id":"264466371","seq_no":"4","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-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922W"},{"id":12259659,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_violation_id":"264466372","seq_no":"5","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-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12661751,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_unit_id":"205276320","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"79AT9D","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLDRXESFD0309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"},{"id":12661752,"change_date":"2025-02-11 21:40:00","inspection_id":"83841612","insp_unit_id":"205276321","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"016","insp_unit_license":"A92212A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354U125185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7750606,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","dot_number":"1242162","report_state":"TX","report_number":"V251740863","insp_date":"2025-01-26 00:00:00","insp_start_time":"1200","insp_end_time":"1247","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CAGE RD AND US 281","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SWEET SEASON","shipping_paper_number":"DR406332087","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-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9486706","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-01-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:59:09.000000Z","updated_at":"2025-03-17T20:59:09.000000Z","inspection_violations":[{"id":12111591,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_violation_id":"264264582","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205087852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"39311TL"},{"id":12111592,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_violation_id":"264264583","seq_no":"2","part_no":"393","part_no_section":"130","insp_viol_unit":"1","insp_unit_id":"205087852","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"393130"},{"id":12111593,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_violation_id":"264264584","seq_no":"3","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"205087852","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"393209E"},{"id":12111594,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_violation_id":"264264585","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205087852","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"39378"},{"id":12111595,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_violation_id":"264264586","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205087852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3939"},{"id":12111596,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_violation_id":"264264587","seq_no":"6","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-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12507772,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_unit_id":"205087852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"5","insp_unit_license":"26AK6V","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCNAPR76C252801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:03.000000Z","updated_at":"2025-03-17T23:53:03.000000Z"},{"id":12507773,"change_date":"2025-01-30 21:41:00","inspection_id":"83741848","insp_unit_id":"205087853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"011","insp_unit_license":"A85281A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537DM606619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:03.000000Z","updated_at":"2025-03-17T23:53:03.000000Z"}]},{"id":7431469,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","dot_number":"1242162","report_state":"TX","report_number":"V241727728","insp_date":"2024-12-11 00:00:00","insp_start_time":"1632","insp_end_time":"1757","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:25\u00bf\u00bf 53' 36.85N","county_code_state":"TX","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"L & P CUSTOMHOUSE BROKERAGE","shipping_paper_number":"8726","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-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9451221","transaction_code":"C","transaction_date":"2024-12-17 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-16 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:51:09.000000Z","updated_at":"2026-04-20T09:54:26.000000Z","inspection_violations":[{"id":19887091,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","insp_violation_id":"273218346","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"212789057","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:14:04.000000Z","updated_at":"2026-04-19T12:33:43.000000Z","normalized_code":"3922RG"},{"id":19887092,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","insp_violation_id":"273218347","seq_no":"2","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":"2026-04-11T10:14:04.000000Z","updated_at":"2026-04-19T12:33:43.000000Z","normalized_code":"3922W"},{"id":19887093,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","insp_violation_id":"273218348","seq_no":"3","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":"2026-04-11T10:14:04.000000Z","updated_at":"2026-04-19T12:33:43.000000Z","normalized_code":"3922W"},{"id":19887094,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","insp_violation_id":"273218349","seq_no":"4","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":"2026-04-11T10:14:04.000000Z","updated_at":"2026-04-19T12:33:43.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":20055745,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","insp_unit_id":"212789056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"42EP6R","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1FUJA6DE27LX29872","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:49.000000Z","updated_at":"2026-04-19T10:03:47.000000Z"},{"id":20055746,"change_date":"2026-04-09 22:09:00","inspection_id":"83406817","insp_unit_id":"212789057","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"016","insp_unit_license":"A96065A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354U125185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:49.000000Z","updated_at":"2026-04-19T10:03:47.000000Z"}]},{"id":7137259,"change_date":"2026-04-09 22:07:00","inspection_id":"83096390","dot_number":"1242162","report_state":"TX","report_number":"V241655854","insp_date":"2024-10-20 00:00:00","insp_start_time":"1146","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 2061 SOUTH OF LAS","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FAMILIA MONTES PRODUCE","shipping_paper_number":"53710","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-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9421232","transaction_code":"C","transaction_date":"2024-11-06 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-06 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:44:43.000000Z","updated_at":"2026-04-20T09:50:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20029259,"change_date":"2026-04-09 22:07:00","inspection_id":"83096390","insp_unit_id":"212771341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"013","insp_unit_license":"180C960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204W001412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:29.000000Z","updated_at":"2026-04-19T10:00:33.000000Z"},{"id":20029258,"change_date":"2026-04-09 22:07:00","inspection_id":"83096390","insp_unit_id":"212771340","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5","insp_unit_license":"26AK6V","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"2HSCNAPR76C252801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:29.000000Z","updated_at":"2026-04-19T10:00:33.000000Z"}]},{"id":6496612,"change_date":"2024-08-18 21:31:00","inspection_id":"82415069","dot_number":"1242162","report_state":"US","report_number":"1566001174","insp_date":"2024-08-16 00:00:00","insp_start_time":"2142","insp_end_time":"2233","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX02","location_desc":"BROWNSVILLE TX","county_code_state":"TX","county_code":"061","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","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":"754445","transaction_code":"A","transaction_date":"2024-08-18 00:00:00","upload_date":"2024-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2024-08-18 21:31:00","snet_input_date":"2024-08-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-18 21:31:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-03-17T20:31:37.000000Z","inspection_violations":[{"id":10088340,"change_date":"2024-08-18 21:31:00","inspection_id":"82415069","insp_violation_id":"261253238","seq_no":"1","part_no":"387","part_no_section":"7(f)","insp_viol_unit":"1","insp_unit_id":"202450909","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3877F"},{"id":10088341,"change_date":"2024-08-18 21:31:00","inspection_id":"82415069","insp_violation_id":"261253239","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202450909","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"39360C"},{"id":10088342,"change_date":"2024-08-18 21:31:00","inspection_id":"82415069","insp_violation_id":"261253240","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202450909","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10472213,"change_date":"2024-08-18 21:31:00","inspection_id":"82415069","insp_unit_id":"202450909","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"4","insp_unit_license":"99AA2U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"}]},{"id":6491730,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","dot_number":"1242162","report_state":"TX","report_number":"V241490688","insp_date":"2024-08-14 00:00:00","insp_start_time":"2040","insp_end_time":"2116","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 281 MM 790","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SWEET SEASONS","shipping_paper_number":"406142973","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-08-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9353297","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-16 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10080320,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","insp_violation_id":"261304530","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"202493900","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"393207A"},{"id":10080321,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","insp_violation_id":"261304531","seq_no":"2","part_no":"393","part_no_section":"55(a)","insp_viol_unit":"2","insp_unit_id":"202493901","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"39355A"},{"id":10080322,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","insp_violation_id":"261304532","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202493900","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"39360C"},{"id":10080323,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","insp_violation_id":"261304533","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202493900","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":10464507,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","insp_unit_id":"202493900","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"99AA2U","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"},{"id":10464508,"change_date":"2024-08-20 21:43:00","inspection_id":"82409935","insp_unit_id":"202493901","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"13","insp_unit_license":"180C960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204W001412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"}]},{"id":6366499,"change_date":"2024-08-01 21:41:00","inspection_id":"82275876","dot_number":"1242162","report_state":"US","report_number":"1140000977","insp_date":"2024-08-01 00:00:00","insp_start_time":"1515","insp_end_time":"1604","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX09","location_desc":"PROGRESSO TX","county_code_state":"TX","county_code":"215","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-01 21:41: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"709126","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:05.000000Z","updated_at":"2025-03-17T20:29:05.000000Z","inspection_violations":[{"id":9884388,"change_date":"2024-08-01 21:41:00","inspection_id":"82275876","insp_violation_id":"260962498","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202186513","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10259544,"change_date":"2024-08-01 21:41:00","inspection_id":"82275876","insp_unit_id":"202186513","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"01","insp_unit_license":"31AT9D","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLD50ESFX6331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:15.000000Z","updated_at":"2025-03-17T23:29:15.000000Z"}]},{"id":6095662,"change_date":"2024-06-27 21:41:00","inspection_id":"81985603","dot_number":"1242162","report_state":"TX","report_number":"V241468069","insp_date":"2024-06-26 00:00:00","insp_start_time":"1755","insp_end_time":"1834","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-69 SOUTH OF EAST","county_code_state":"TX","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IMERYS FUSED MINERALS NIAGRA","shipping_paper_number":"7382","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-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9311887","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-27 21:41:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:23:24.000000Z","updated_at":"2025-03-17T20:23:24.000000Z","inspection_violations":[{"id":9461121,"change_date":"2024-06-27 21:41:00","inspection_id":"81985603","insp_violation_id":"260357084","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3922"},{"id":9461122,"change_date":"2024-06-27 21:41:00","inspection_id":"81985603","insp_violation_id":"260357085","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:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9818151,"change_date":"2024-06-27 21:41:00","inspection_id":"81985603","insp_unit_id":"201630680","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"79AT9D","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3AKJGLDRXESFD0309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:42.000000Z","updated_at":"2025-03-17T23:24:42.000000Z"},{"id":9818152,"change_date":"2024-06-27 21:41:00","inspection_id":"81985603","insp_unit_id":"201630681","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"016","insp_unit_license":"A96065A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354U125185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:42.000000Z","updated_at":"2025-03-17T23:24:42.000000Z"}]},{"id":5610244,"change_date":"2024-04-26 21:40:00","inspection_id":"81459198","dot_number":"1242162","report_state":"TX","report_number":"V241393809","insp_date":"2024-04-15 00:00:00","insp_start_time":"1052","insp_end_time":"1123","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MILITARY RD AND CAGE","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":"208","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-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9258986","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-26 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:13:53.000000Z","updated_at":"2025-03-17T20:13:53.000000Z","inspection_violations":[{"id":8676145,"change_date":"2024-04-26 21:40:00","inspection_id":"81459198","insp_violation_id":"259176498","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200603977","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39378"},{"id":8676146,"change_date":"2024-04-26 21:40:00","inspection_id":"81459198","insp_violation_id":"259176499","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"200603978","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"3929A2"},{"id":8676147,"change_date":"2024-04-26 21:40:00","inspection_id":"81459198","insp_violation_id":"259176500","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200603977","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":9037077,"change_date":"2024-04-26 21:40:00","inspection_id":"81459198","insp_unit_id":"200603977","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"04","insp_unit_license":"99AA2U","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:05.000000Z","updated_at":"2025-03-17T23:17:05.000000Z"},{"id":9037078,"change_date":"2024-04-26 21:40:00","inspection_id":"81459198","insp_unit_id":"200603978","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"13","insp_unit_license":"180C960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204W001412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:05.000000Z","updated_at":"2025-03-17T23:17:05.000000Z"}]},{"id":5139733,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","dot_number":"1242162","report_state":"TX","report_number":"V241343177","insp_date":"2024-02-23 00:00:00","insp_start_time":"1212","insp_end_time":"1254","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CAGE SOUTH OF MILITA","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SWEETER EXPORTADORA","shipping_paper_number":"DR405928356","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-02-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9207235","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-26 21:43:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T20:04:16.000000Z","updated_at":"2025-03-17T20:04:16.000000Z","inspection_violations":[{"id":7926844,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_violation_id":"258047778","seq_no":"1","part_no":"387","part_no_section":"7(f)","insp_viol_unit":"1","insp_unit_id":"199608948","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3877F"},{"id":7926845,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_violation_id":"258047779","seq_no":"2","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"199608948","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3929AA1"},{"id":7926846,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_violation_id":"258047780","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199608948","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3939A"},{"id":7926847,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_violation_id":"258047781","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199608949","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3922"},{"id":7926848,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_violation_id":"258047782","seq_no":"6","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:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8275590,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_unit_id":"199608948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"403EZ6","insp_unit_license_state":"DF","insp_unit_vehicle_id_number":"1XKADB9X17J199640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:00.000000Z","updated_at":"2025-03-17T23:10:00.000000Z"},{"id":8275591,"change_date":"2024-02-26 21:43:00","inspection_id":"80946060","insp_unit_id":"199608949","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"A80508A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06217S701127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:00.000000Z","updated_at":"2025-03-17T23:10:00.000000Z"}]},{"id":4748335,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","dot_number":"1242162","report_state":"TX","report_number":"V231276561","insp_date":"2023-12-31 00:00:00","insp_start_time":"1400","insp_end_time":"1452","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MILITARY HWY AND MCC","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":"Y","pen_cen_match":null,"final_status_date":"2024-12-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"9164142","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":"2024-12-09 21:42:00","snet_input_date":"2023-12-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-02 21:44:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T19:56:53.000000Z","updated_at":"2025-03-17T19:56:53.000000Z","inspection_violations":[{"id":7329097,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","insp_violation_id":"263344261","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204280330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39311TL"},{"id":7329098,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","insp_violation_id":"263344262","seq_no":"2","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"204280330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39311TU"},{"id":7329099,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","insp_violation_id":"263344263","seq_no":"3","part_no":"393","part_no_section":"13D3","insp_viol_unit":"2","insp_unit_id":"204280331","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39313D3"},{"id":7329100,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","insp_violation_id":"263344264","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204280330","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":7638540,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","insp_unit_id":"204280330","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"21AA2U","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"1XPHDB9X17N671885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:16.000000Z","updated_at":"2025-03-17T23:04:16.000000Z"},{"id":7638541,"change_date":"2024-12-09 21:42:00","inspection_id":"80518046","insp_unit_id":"204280331","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"013","insp_unit_license":"180C960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204W001412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:16.000000Z","updated_at":"2025-03-17T23:04:16.000000Z"}]},{"id":4655710,"change_date":"2024-12-05 21:38:00","inspection_id":"80417040","dot_number":"1242162","report_state":"TX","report_number":"V231263569","insp_date":"2023-12-14 00:00:00","insp_start_time":"2000","insp_end_time":"2044","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 281 MILITARY RD E","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MONTES PRODUCE","shipping_paper_number":"145","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-12-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9150728","transaction_code":"C","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":"2024-12-05 21:38:00","snet_input_date":"2023-12-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"H MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T19:54:59.000000Z","updated_at":"2025-03-17T19:54:59.000000Z","inspection_violations":[{"id":7196904,"change_date":"2024-12-05 21:38:00","inspection_id":"80417040","insp_violation_id":"263267934","seq_no":"1","part_no":"383","part_no_section":"23A2","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:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"38323A2"},{"id":7196905,"change_date":"2024-12-05 21:38:00","inspection_id":"80417040","insp_violation_id":"263267935","seq_no":"2","part_no":"391","part_no_section":"45B","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":7488286,"change_date":"2024-12-05 21:38:00","inspection_id":"80417040","insp_unit_id":"204212024","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"79AT9D","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"3AKJGLDRXESFD0309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"},{"id":7488287,"change_date":"2024-12-05 21:38:00","inspection_id":"80417040","insp_unit_id":"204212025","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"016","insp_unit_license":"A96065A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354U125185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"}]},{"id":3604400,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","dot_number":"1242162","report_state":"US","report_number":"1141000296","insp_date":"2023-07-26 00:00:00","insp_start_time":"1347","insp_end_time":"1451","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BROWNSVILLETX","county_code_state":"TX","county_code":"061","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CORRAL BOOTS","shipping_paper_number":"810159193","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"9","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":"35083","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2023-07-27 21:39:00","snet_input_date":"2023-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-27 21:39:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:11.000000Z","updated_at":"2025-03-17T19:34:11.000000Z","inspection_violations":[{"id":5557822,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303513","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196216407","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39353B"},{"id":5557823,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303514","seq_no":"6","part_no":"393","part_no_section":"43E-BBST","insp_viol_unit":"2","insp_unit_id":"196216408","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39343EBBST"},{"id":5557824,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303515","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196216408","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39347E"},{"id":5557825,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303516","seq_no":"8","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"196216408","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"3963A1BALAC"},{"id":5557826,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303517","seq_no":"9","part_no":"393","part_no_section":"55D3-B","insp_viol_unit":"2","insp_unit_id":"196216408","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39355D3B"},{"id":5557827,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303518","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"196216407","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"3939ALIL"},{"id":5557828,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303519","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"196216407","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39383G"},{"id":5557829,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303520","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"196216407","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"3965BL"},{"id":5557830,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_violation_id":"254303521","seq_no":"3","part_no":"393","part_no_section":"67C4-F","insp_viol_unit":"1","insp_unit_id":"196216407","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39367C4F"}],"inspection_per_units":[{"id":5795441,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_unit_id":"196216407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"853AT8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"L21570001530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"},{"id":5795442,"change_date":"2023-07-27 21:39:00","inspection_id":"79251198","insp_unit_id":"196216408","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"952VW1","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS25303P943520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3236474,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","dot_number":"1242162","report_state":"US","report_number":"1141000176","insp_date":"2023-06-01 00:00:00","insp_start_time":"1205","insp_end_time":"1254","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BROWNSVILLETX","county_code_state":"TX","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CORRAL BOOT COMPANY","shipping_paper_number":"MY81015762-7","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-06-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"21910","transaction_code":"A","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2023-06-08 21:41:00","snet_input_date":"2023-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-08 21:41:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:56.000000Z","updated_at":"2025-03-17T19:26:56.000000Z","inspection_violations":[{"id":4990024,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377134","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3939ALRLI"},{"id":4990025,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377135","seq_no":"2","part_no":"387","part_no_section":"7(f)","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3877F"},{"id":4990026,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377136","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39378"},{"id":4990027,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377137","seq_no":"4","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39311A1LBL"},{"id":4990028,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377138","seq_no":"5","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"393209ESPSLA"},{"id":4990029,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377139","seq_no":"6","part_no":"393","part_no_section":"67C4-F","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39367C4F"},{"id":4990030,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377140","seq_no":"7","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3965BL"},{"id":4990031,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377141","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195388606","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39353B"},{"id":4990032,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377142","seq_no":"9","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"2","insp_unit_id":"195388607","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3963A1ALBV"},{"id":4990033,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_violation_id":"253377143","seq_no":"10","part_no":"396","part_no_section":"3A1-BNMH","insp_viol_unit":"2","insp_unit_id":"195388607","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3963A1BNMH"}],"inspection_per_units":[{"id":5205236,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_unit_id":"195388606","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"853AT8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"L21570001530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:02.000000Z","updated_at":"2025-03-17T22:44:02.000000Z"},{"id":5205237,"change_date":"2023-06-08 21:41:00","inspection_id":"78837386","insp_unit_id":"195388607","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"B496063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532WX7L020296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:02.000000Z","updated_at":"2025-03-17T22:44:02.000000Z"}]},{"id":3145171,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","dot_number":"1242162","report_state":"TX","report_number":"6LCC0WGYJG","insp_date":"2023-05-24 00:00:00","insp_start_time":"1119","insp_end_time":"1216","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A201","location_desc":"PHARR\/HIDALGO BRIDGE","county_code_state":"TX","county_code":"215","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GUILLERMO MEDINA","shipping_paper_number":"258","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-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"13","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8989044","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T19:25:20.000000Z","updated_at":"2025-03-17T19:25:20.000000Z","inspection_violations":[{"id":4842976,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090697","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39378"},{"id":4842977,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090698","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3965B"},{"id":4842978,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090699","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3965B"},{"id":4842979,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090700","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39395A"},{"id":4842980,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090701","seq_no":"6","part_no":"392","part_no_section":"22(b)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39222B"},{"id":4842981,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090702","seq_no":"7","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39383G"},{"id":4842982,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090703","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39345B2"},{"id":4842983,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090704","seq_no":"9","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3965B"},{"id":4842984,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090705","seq_no":"10","part_no":"393","part_no_section":"65(f)","insp_viol_unit":"1","insp_unit_id":"195152163","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39365F"},{"id":4842985,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090706","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195152164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"},{"id":4842986,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090707","seq_no":"12","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195152164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39355E"},{"id":4842987,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090708","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195152164","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39347E"},{"id":4842988,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_violation_id":"253090709","seq_no":"14","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195152164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5058733,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_unit_id":"195152163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"02","insp_unit_license":"129DS8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"8150011ME143NAL","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"},{"id":5058734,"change_date":"2023-05-25 21:42:00","inspection_id":"78734264","insp_unit_id":"195152164","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"24","insp_unit_license":"A60659A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25371U271602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"}]},{"id":2784341,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","dot_number":"1242162","report_state":"US","report_number":"1528000066","insp_date":"2023-04-11 00:00:00","insp_start_time":"1504","insp_end_time":"1604","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"PROGRESO LAKESTX","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AZTECA CONFITERIA SA DE CV","shipping_paper_number":"69623","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-04-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","viol_total":"5","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":"7807","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":"2023-04-12 21:40:00","snet_input_date":"2023-04-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-04-12 21:40:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:03.000000Z","updated_at":"2025-03-17T19:18:03.000000Z","inspection_violations":[{"id":4272533,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_violation_id":"252168773","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"194339791","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39021TB1MC"},{"id":4272534,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_violation_id":"252168774","seq_no":"2","part_no":"390","part_no_section":"21TB3-OPERBY","insp_viol_unit":"1","insp_unit_id":"194339791","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39021TB3OPERBY"},{"id":4272535,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_violation_id":"252168775","seq_no":"3","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"194339791","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"393209ESPSLA"},{"id":4272536,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_violation_id":"252168776","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"194339792","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39617CPI"},{"id":4272537,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_violation_id":"252168777","seq_no":"5","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"194339792","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39375A1TEPBM"}],"inspection_per_units":[{"id":4481564,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_unit_id":"194339791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"853AT8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"L21570001530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:20.000000Z","updated_at":"2025-03-17T22:38:20.000000Z"},{"id":4481565,"change_date":"2023-04-12 21:40:00","inspection_id":"78326489","insp_unit_id":"194339792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"952VW1","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS25303P943520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:20.000000Z","updated_at":"2025-03-17T22:38:20.000000Z"}]},{"id":2028952,"change_date":"2022-12-28 21:40:00","inspection_id":"77464884","dot_number":"1242162","report_state":"US","report_number":"1528006471","insp_date":"2022-12-21 00:00:00","insp_start_time":"0940","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":"9","location_desc":"PROGRESO POE","county_code_state":"TX","county_code":"215","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1282663","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-28 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-12-28 21:40:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"4654 PALACIO REAL","insp_carrier_city":"BROWNSVILLE","insp_carrier_state":"TX","insp_carrier_zip_code":"78521","insp_colonia":null,"docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:00.000000Z","updated_at":"2025-03-17T19:04:00.000000Z","inspection_violations":[{"id":3145153,"change_date":"2022-12-28 21:40:00","inspection_id":"77464884","insp_violation_id":"250296331","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192612957","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:55.000000Z","updated_at":"2025-03-17T21:21:55.000000Z","normalized_code":"3963A1"},{"id":3145154,"change_date":"2022-12-28 21:40:00","inspection_id":"77464884","insp_violation_id":"250296332","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192612957","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:55.000000Z","updated_at":"2025-03-17T21:21:55.000000Z","normalized_code":"3963A1"},{"id":3145155,"change_date":"2022-12-28 21:40:00","inspection_id":"77464884","insp_violation_id":"250296333","seq_no":"3","part_no":"387","part_no_section":"7(f)","insp_viol_unit":"1","insp_unit_id":"192612957","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:55.000000Z","updated_at":"2025-03-17T21:21:55.000000Z","normalized_code":"3877F"},{"id":3145156,"change_date":"2022-12-28 21:40:00","inspection_id":"77464884","insp_violation_id":"250296334","seq_no":"4","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"192612957","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:55.000000Z","updated_at":"2025-03-17T21:21:55.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":3264548,"change_date":"2022-12-28 21:40:00","inspection_id":"77464884","insp_unit_id":"192612957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"99AA2U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:21.000000Z","updated_at":"2025-03-17T22:29:21.000000Z"}]},{"id":1989863,"change_date":"2022-12-20 21:41:00","inspection_id":"77420574","dot_number":"1242162","report_state":"TX","report_number":"6GWN0XQFHP","insp_date":"2022-12-15 00:00:00","insp_start_time":"2305","insp_end_time":"2322","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0336 IN HIDALGO CO. (716-72","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-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8856827","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T19:03:19.000000Z","updated_at":"2025-03-17T19:03:19.000000Z","inspection_violations":[{"id":3089960,"change_date":"2022-12-20 21:41:00","inspection_id":"77420574","insp_violation_id":"250207070","seq_no":"3","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"192524954","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375A2"},{"id":3089961,"change_date":"2022-12-20 21:41:00","inspection_id":"77420574","insp_violation_id":"250207071","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"192524953","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39360C"},{"id":3089962,"change_date":"2022-12-20 21:41:00","inspection_id":"77420574","insp_violation_id":"250207072","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192524954","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3201736,"change_date":"2022-12-20 21:41:00","inspection_id":"77420574","insp_unit_id":"192524953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04","insp_unit_license":"99AA2U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"},{"id":3201737,"change_date":"2022-12-20 21:41:00","inspection_id":"77420574","insp_unit_id":"192524954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"14","insp_unit_license":"A60656A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25322U809902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1810599,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","dot_number":"1242162","report_state":"TX","report_number":"6G890WHAP4","insp_date":"2022-11-21 00:00:00","insp_start_time":"0925","insp_end_time":"0959","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A201","location_desc":"PHARR\/HIDALGO BRIDGE","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SWEET SEASONS","shipping_paper_number":"623","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8835758","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T18:59:59.000000Z","updated_at":"2025-03-17T18:59:59.000000Z","inspection_violations":[{"id":2831780,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779448","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192119473","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39311"},{"id":2831781,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779449","seq_no":"2","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"192119473","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39382"},{"id":2831782,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779450","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192119473","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39395A"},{"id":2831783,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779451","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192119473","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39395F"},{"id":2831784,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779452","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192119474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39311"},{"id":2831785,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779453","seq_no":"6","part_no":"393","part_no_section":"13(b)","insp_viol_unit":"2","insp_unit_id":"192119474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39313B"},{"id":2831786,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779454","seq_no":"7","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"192119474","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39355E"},{"id":2831787,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779455","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192119474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"},{"id":2831788,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_violation_id":"249779456","seq_no":"9","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192119474","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2912542,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_unit_id":"192119473","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26","insp_unit_license":"21AA2U","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"1XPHDB9X17N671885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:56.000000Z","updated_at":"2025-03-17T22:26:56.000000Z"},{"id":2912543,"change_date":"2022-11-23 21:40:00","inspection_id":"77215565","insp_unit_id":"192119474","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRKA","insp_unit_company":"01","insp_unit_license":"A60660A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PT01PNAX49001272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:56.000000Z","updated_at":"2025-03-17T22:26:56.000000Z"}]},{"id":1845584,"change_date":"2022-11-30 21:40:00","inspection_id":"77255375","dot_number":"1242162","report_state":"TX","report_number":"6G5C0XIP6O","insp_date":"2022-11-18 00:00:00","insp_start_time":"1150","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A401","location_desc":"VETERANS BRIDGE LOS TOMATES(CU","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CORRAL TRADING","shipping_paper_number":"2574","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"8839488","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T19:00:43.000000Z","updated_at":"2025-03-17T19:00:43.000000Z","inspection_violations":[{"id":2879082,"change_date":"2022-11-30 21:40:00","inspection_id":"77255375","insp_violation_id":"249858877","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"192199717","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39360C"},{"id":2879083,"change_date":"2022-11-30 21:40:00","inspection_id":"77255375","insp_violation_id":"249858878","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192199717","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2969792,"change_date":"2022-11-30 21:40:00","inspection_id":"77255375","insp_unit_id":"192199717","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"853AT8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"L21570001530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:19.000000Z","updated_at":"2025-03-17T22:27:19.000000Z"},{"id":2969793,"change_date":"2022-11-30 21:40:00","inspection_id":"77255375","insp_unit_id":"192199718","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"B496063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532WX7L020296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:19.000000Z","updated_at":"2025-03-17T22:27:19.000000Z"}]},{"id":1733094,"change_date":"2022-11-14 21:42:00","inspection_id":"77126684","dot_number":"1242162","report_state":"US","report_number":"0919012170","insp_date":"2022-11-10 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"PROGRESO POE","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"PRANI, S.A. DE C.V.","shipping_paper_number":"TFMIHP704617585","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-14 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":"1276310","transaction_code":"A","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-14 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-11-14 21:42:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"4654 PALACIO REAL","insp_carrier_city":"BROWNSVILLE","insp_carrier_state":"TX","insp_carrier_zip_code":"78521","insp_colonia":null,"docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:35.000000Z","updated_at":"2025-03-17T18:58:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2788702,"change_date":"2022-11-14 21:42:00","inspection_id":"77126684","insp_unit_id":"191941095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"99AA2U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCEAPRX7C449849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:04.000000Z","updated_at":"2025-03-17T22:26:04.000000Z"},{"id":2788703,"change_date":"2022-11-14 21:42:00","inspection_id":"77126684","insp_unit_id":"191941096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"016","insp_unit_license":"A60658A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354U125185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:04.000000Z","updated_at":"2025-03-17T22:26:04.000000Z"}]},{"id":1639646,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","dot_number":"1242162","report_state":"US","report_number":"1330012985","insp_date":"2022-10-25 00:00:00","insp_start_time":"1032","insp_end_time":"1126","registration_date":null,"region":"CT","ci_status_code":"C","location":"2","location_desc":"VIB","county_code_state":"TX","county_code":"061","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CORRAL BOOTS COMPANY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1274202","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-31 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-10-31 21:41:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"4654 PALACIO REAL","insp_carrier_city":"BROWNSVILLE","insp_carrier_state":"TX","insp_carrier_zip_code":"78521","insp_colonia":null,"docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:43.000000Z","updated_at":"2025-03-17T18:56:43.000000Z","inspection_violations":[{"id":2572277,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_violation_id":"249348928","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"191731340","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"393209E"},{"id":2572278,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_violation_id":"249348929","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191731340","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"39347E"},{"id":2572279,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_violation_id":"249348930","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191731340","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"39353B"},{"id":2572280,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_violation_id":"249348931","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191731340","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3965B"},{"id":2572281,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_violation_id":"249348932","seq_no":"6","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"191731340","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":2638027,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_unit_id":"191731340","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"853AT8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"L21570001530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:05.000000Z","updated_at":"2025-03-17T22:25:05.000000Z"},{"id":2638028,"change_date":"2022-10-31 21:41:00","inspection_id":"77019394","insp_unit_id":"191731341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"B496063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532WX7L020296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:05.000000Z","updated_at":"2025-03-17T22:25:05.000000Z"}]},{"id":1566569,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","dot_number":"1242162","report_state":"TX","report_number":"6FAI0WHBNC","insp_date":"2022-10-18 00:00:00","insp_start_time":"1808","insp_end_time":"1848","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A201","location_desc":"PHARR\/HIDALGO BRIDGE","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FAMILIA MONTES PRODUCE SPR DE","shipping_paper_number":"605","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8806527","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-20 21:41:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T18:55:34.000000Z","updated_at":"2025-03-17T18:55:34.000000Z","inspection_violations":[{"id":2463895,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164807","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191563165","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39378"},{"id":2463896,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164808","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"191563165","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"393209E"},{"id":2463897,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164809","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191563165","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3965B"},{"id":2463898,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164810","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"191563165","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39383G"},{"id":2463899,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164811","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191563165","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39395A"},{"id":2463900,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164812","seq_no":"6","part_no":"392","part_no_section":"22(b)","insp_viol_unit":"1","insp_unit_id":"191563165","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39222B"},{"id":2463901,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164813","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191563166","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"},{"id":2463902,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164814","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191563166","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"},{"id":2463903,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164815","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191563166","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"},{"id":2463904,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164816","seq_no":"10","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"191563166","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39319"},{"id":2463905,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164817","seq_no":"11","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"191563166","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3965B"},{"id":2463906,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_violation_id":"249164818","seq_no":"12","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"191563166","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":2521510,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_unit_id":"191563165","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"02","insp_unit_license":"129DS8","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"8150011ME143NAL","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"},{"id":2521511,"change_date":"2022-10-20 21:41:00","inspection_id":"76935431","insp_unit_id":"191563166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"24","insp_unit_license":"A60659A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25371U271602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"}]},{"id":1265361,"change_date":"2022-09-12 21:43:00","inspection_id":"76586314","dot_number":"1242162","report_state":"US","report_number":"1168013922","insp_date":"2022-09-07 00:00:00","insp_start_time":"1428","insp_end_time":"1501","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"ROMA POE","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"VEGETALES JAZMINEZ","shipping_paper_number":"J23-015","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1265746","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-12 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-09-12 21:43:00","insp_carrier_name":"FRANCISCO MEDINA GARZA","insp_carrier_street":"4654 PALACIO REAL","insp_carrier_city":"BROWNSVILLE","insp_carrier_state":"TX","insp_carrier_zip_code":"78521","insp_colonia":null,"docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:05.000000Z","updated_at":"2025-03-17T18:50:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2036377,"change_date":"2022-09-12 21:43:00","inspection_id":"76586314","insp_unit_id":"190850215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"853AT8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"L21570001530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:59.000000Z","updated_at":"2025-03-17T22:20:59.000000Z"},{"id":2036378,"change_date":"2022-09-12 21:43:00","inspection_id":"76586314","insp_unit_id":"190850216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"B496063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532WX7L020296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:59.000000Z","updated_at":"2025-03-17T22:20:59.000000Z"}]},{"id":1103695,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","dot_number":"1242162","report_state":"TX","report_number":"6DJD0XIM80","insp_date":"2022-08-16 00:00:00","insp_start_time":"1328","insp_end_time":"1428","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":"BRAVO LOGISTICS SERVICES","shipping_paper_number":"5080","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-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8749124","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T18:47:12.000000Z","updated_at":"2025-03-17T18:47:12.000000Z","inspection_violations":[{"id":1739564,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_violation_id":"247902457","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190469502","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39360D"},{"id":1739565,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_violation_id":"247902458","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"190469502","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"393203C"},{"id":1739566,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_violation_id":"247902459","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190469502","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3965B"},{"id":1739567,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_violation_id":"247902460","seq_no":"4","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"190469502","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"393205A"},{"id":1739568,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_violation_id":"247902461","seq_no":"6","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190469503","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39355E"},{"id":1739569,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_violation_id":"247902462","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190469502","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1775601,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_unit_id":"190469502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"02","insp_unit_license":"129DS8","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"008150011ME143NAL","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:13.000000Z","updated_at":"2025-03-17T22:19:13.000000Z"},{"id":1775602,"change_date":"2022-08-22 21:43:00","inspection_id":"76398715","insp_unit_id":"190469503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"24","insp_unit_license":"A60659A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25371U271602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:13.000000Z","updated_at":"2025-03-17T22:19:13.000000Z"}]},{"id":649554,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","dot_number":"1242162","report_state":"TX","report_number":"6BTE0WHDS9","insp_date":"2022-06-15 00:00:00","insp_start_time":"1344","insp_end_time":"1442","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A201","location_desc":"PHARR\/HIDALGO BRIDGE","county_code_state":"TX","county_code":"215","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FAMILIA MONTES PRODUCE","shipping_paper_number":"411299380","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-20 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8688736","transaction_code":"A","transaction_date":"2022-06-20 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01242162","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-20 21:36:00","insp_carrier_name":"TRANSPORTES FRANCISCO MEDINA GARZA","insp_carrier_street":"DOROTEO ARANGO 7","insp_carrier_city":"MATAMOROS","insp_carrier_state":"TA","insp_carrier_zip_code":"87340","insp_colonia":"FRANCISCO VILLA","docket_number":"488512","insp_interstate":"Y","insp_carrier_state_id":"0080605","created_at":"2025-03-17T18:39:10.000000Z","updated_at":"2025-03-17T18:39:10.000000Z","inspection_violations":[{"id":1023572,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595055","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"189354545","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39375A1"},{"id":1023573,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595056","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"189354545","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39383G"},{"id":1023574,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595057","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"189354545","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"393207A"},{"id":1023575,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595058","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189354545","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"3965B"},{"id":1023576,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595059","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189354545","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"3963A1"},{"id":1023577,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595060","seq_no":"6","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189354546","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39355E"},{"id":1023578,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_violation_id":"246595061","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"189354546","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1044470,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_unit_id":"189354545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"02","insp_unit_license":"129DS8","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"8150011ME143NAL","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:36.000000Z","updated_at":"2025-03-17T22:14:36.000000Z"},{"id":1044471,"change_date":"2022-06-20 21:36:00","inspection_id":"75867045","insp_unit_id":"189354546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"24","insp_unit_license":"A60659A","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25371U271602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:36.000000Z","updated_at":"2025-03-17T22:14:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1242162\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1242162\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1242162\/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\/1242162\/inspections","per_page":100,"prev_page_url":null,"to":36,"total":36}