{"current_page":1,"data":[{"id":11519960,"change_date":"2026-03-30 21:39:00","inspection_id":"87441118","dot_number":"3697253","report_state":"TX","report_number":"V262267245","insp_date":"2026-03-22 00:00:00","insp_start_time":"1302","insp_end_time":"1323","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"22M IH35 SB SVC RD","county_code_state":"TX","county_code":"479","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS BERRY PATCH","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-03-30 21:39: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":"9901547","transaction_code":"A","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2026-03-30 21:39:00","snet_input_date":"2026-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-30 21:39:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2026-04-02T09:46:58.000000Z","updated_at":"2026-04-10T09:31:32.000000Z","inspection_violations":[{"id":19458702,"change_date":"2026-03-30 21:39:00","inspection_id":"87441118","insp_violation_id":"272744866","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"212431898","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:29.000000Z","updated_at":"2026-04-09T09:52:49.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":19736769,"change_date":"2026-03-30 21:39:00","inspection_id":"87441118","insp_unit_id":"212431898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"005","insp_unit_license":"20N651N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7KN095420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:44.000000Z","updated_at":"2026-04-10T09:06:24.000000Z"}]},{"id":11478717,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","dot_number":"3697253","report_state":"TX","report_number":"V262274304","insp_date":"2026-03-17 00:00:00","insp_start_time":"0214","insp_end_time":"0259","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MP 24","county_code_state":"TX","county_code":"479","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DSV AIR AND SEA","shipping_paper_number":"CUS3334057","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-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","viol_total":"8","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9894962","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2026-03-28T09:44:51.000000Z","updated_at":"2026-04-05T09:32:50.000000Z","inspection_violations":[{"id":19377255,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641089","seq_no":"1","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"212337793","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"39355C1"},{"id":19377256,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641090","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"212337794","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"39355E"},{"id":19377257,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641091","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212337793","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"39378"},{"id":19377258,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641092","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212337793","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"3939"},{"id":19377259,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641093","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212337793","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"3939"},{"id":19377260,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641094","seq_no":"7","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"212337793","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"3965B"},{"id":19377261,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641095","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"3922RG"},{"id":19377262,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_violation_id":"272641096","seq_no":"4","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"212337793","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:04.000000Z","updated_at":"2026-04-05T10:01:56.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":19661971,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_unit_id":"212337793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52","insp_unit_license":"10P641N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:02.000000Z","updated_at":"2026-04-05T09:19:16.000000Z"},{"id":19661972,"change_date":"2026-03-25 21:40:00","inspection_id":"87397751","insp_unit_id":"212337794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"203215","insp_unit_license":"32UE6M","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2535L3869745","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:02.000000Z","updated_at":"2026-04-05T09:19:16.000000Z"}]},{"id":11206706,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","dot_number":"3697253","report_state":"TX","report_number":"V262237844","insp_date":"2026-02-21 00:00:00","insp_start_time":"1613","insp_end_time":"1708","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 SB MM 323","county_code_state":"TX","county_code":"309","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DSV AIR AND SEA","shipping_paper_number":"0068705","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-02-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9860947","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2026-02-23 21:38:00","snet_input_date":"2026-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2026-02-26T10:36:59.000000Z","updated_at":"2026-03-06T10:30:53.000000Z","inspection_violations":[{"id":18793215,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_violation_id":"271968027","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:59.000000Z","updated_at":"2026-03-06T10:41:35.000000Z","normalized_code":"39111B2Q"},{"id":18793216,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_violation_id":"271968028","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"211772369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:59.000000Z","updated_at":"2026-03-06T10:41:35.000000Z","normalized_code":"39311"},{"id":18793217,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_violation_id":"271968029","seq_no":"3","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"2","insp_unit_id":"211772370","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:59.000000Z","updated_at":"2026-03-06T10:41:35.000000Z","normalized_code":"39345DLPC"},{"id":18793218,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_violation_id":"271968030","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211772369","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:59.000000Z","updated_at":"2026-03-06T10:41:35.000000Z","normalized_code":"39360C"},{"id":18793219,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_violation_id":"271968031","seq_no":"5","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"211772369","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:59.000000Z","updated_at":"2026-03-06T10:41:35.000000Z","normalized_code":"39360D"},{"id":18793220,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_violation_id":"271968032","seq_no":"6","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:59.000000Z","updated_at":"2026-03-06T10:41:35.000000Z","normalized_code":"3958F01"}],"inspection_per_units":[{"id":19136829,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_unit_id":"211772369","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52","insp_unit_license":"52N661N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:14.000000Z","updated_at":"2026-03-06T10:03:38.000000Z"},{"id":19136830,"change_date":"2026-02-23 21:38:00","inspection_id":"87117853","insp_unit_id":"211772370","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"269","insp_unit_license":"99UF9M","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2533L3034503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:14.000000Z","updated_at":"2026-03-06T10:03:38.000000Z"}]},{"id":10542481,"change_date":"2026-04-09 22:18:00","inspection_id":"86678978","dot_number":"3697253","report_state":"TX","report_number":"V252154676","insp_date":"2025-12-19 00:00:00","insp_start_time":"0945","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B501","location_desc":"COLUMBIA POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRAVO RIVER TRANSPORT","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-12-30 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9802620","transaction_code":"C","transaction_date":"2025-12-30 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-12-30 21:37:00","snet_input_date":"2025-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-30 21:37:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2026-01-02T10:36:40.000000Z","updated_at":"2026-04-20T10:08:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20160216,"change_date":"2026-04-09 22:18:00","inspection_id":"86678978","insp_unit_id":"212896908","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"05","insp_unit_license":"74S519N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7KN095420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:20.000000Z","updated_at":"2026-04-19T10:26:52.000000Z"}]},{"id":9080143,"change_date":"2026-04-09 22:13:00","inspection_id":"85143163","dot_number":"3697253","report_state":"TX","report_number":"V251928167","insp_date":"2025-06-26 00:00:00","insp_start_time":"1700","insp_end_time":"1728","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B501","location_desc":"COLUMBIA POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRAVO RIVER TRANSPORT","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-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9627232","transaction_code":"C","transaction_date":"2025-07-07 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-06-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-07-11T10:44:37.000000Z","updated_at":"2026-04-20T10:01:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20100750,"change_date":"2026-04-09 22:13:00","inspection_id":"85143163","insp_unit_id":"212844329","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03","insp_unit_license":"R711511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGB8372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:28:30.000000Z","updated_at":"2026-04-19T10:14:37.000000Z"}]},{"id":9033829,"change_date":"2026-04-09 22:13:00","inspection_id":"85094228","dot_number":"3697253","report_state":"TX","report_number":"V251928162","insp_date":"2025-06-25 00:00:00","insp_start_time":"1755","insp_end_time":"1819","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B501","location_desc":"COLUMBIA POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRAVO RIVER TRANSPORT","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-06-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9621672","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-06-30 21:39:00","snet_input_date":"2025-06-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-30 21:39:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-07-03T10:01:56.000000Z","updated_at":"2026-04-20T10:01:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20099231,"change_date":"2026-04-09 22:13:00","inspection_id":"85094228","insp_unit_id":"212843918","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"1N69902","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD51GLHA3260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:28:29.000000Z","updated_at":"2026-04-19T10:14:15.000000Z"}]},{"id":8797760,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","dot_number":"3697253","report_state":"TX","report_number":"V251899210","insp_date":"2025-06-01 00:00:00","insp_start_time":"1305","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 SB MM 119","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO RIVER TRANSPORT","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-06-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9597481","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-06-02 21:40:00","snet_input_date":"2025-06-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-02 21:40:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-06-05T10:00:33.000000Z","updated_at":"2025-06-06T10:00:43.000000Z","inspection_violations":[{"id":14068826,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","insp_violation_id":"266617033","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207187154","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:46.000000Z","updated_at":"2025-06-06T10:16:10.000000Z","normalized_code":"3939"},{"id":14068827,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","insp_violation_id":"266617034","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207187155","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-05T10:15:46.000000Z","updated_at":"2025-06-06T10:16:10.000000Z","normalized_code":"3939"},{"id":14068828,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","insp_violation_id":"266617035","seq_no":"3","part_no":"395","part_no_section":"22G","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:46.000000Z","updated_at":"2025-06-06T10:16:10.000000Z","normalized_code":"39522G"},{"id":14068829,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","insp_violation_id":"266617036","seq_no":"4","part_no":"395","part_no_section":"22H4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:46.000000Z","updated_at":"2025-06-06T10:16:10.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":14397235,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","insp_unit_id":"207187154","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"003","insp_unit_license":"R711511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGB8372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:29.000000Z","updated_at":"2025-06-06T09:46:07.000000Z"},{"id":14397236,"change_date":"2025-06-02 21:40:00","inspection_id":"84844278","insp_unit_id":"207187155","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"90413","insp_unit_license":"DJ3849","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2530FP090413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:29.000000Z","updated_at":"2025-06-06T09:46:07.000000Z"}]},{"id":8431275,"change_date":"2025-04-21 21:40:00","inspection_id":"84457892","dot_number":"3697253","report_state":"TX","report_number":"V251833343","insp_date":"2025-04-15 00:00:00","insp_start_time":"1635","insp_end_time":"1709","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 NB","county_code_state":"TX","county_code":"479","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SCHNEIDER ELECTRIC","shipping_paper_number":"904146301","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":"2025-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9556435","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-04-24T10:03:11.000000Z","updated_at":"2025-04-26T10:25:04.000000Z","inspection_violations":[{"id":13310916,"change_date":"2025-04-21 21:40:00","inspection_id":"84457892","insp_violation_id":"265744319","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206418293","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:28:24.000000Z","updated_at":"2025-04-25T10:43:59.000000Z","normalized_code":"3922RG"},{"id":13310917,"change_date":"2025-04-21 21:40:00","inspection_id":"84457892","insp_violation_id":"265744320","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206418292","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:28:24.000000Z","updated_at":"2025-04-25T10:43:59.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13691330,"change_date":"2025-04-21 21:40:00","inspection_id":"84457892","insp_unit_id":"206418292","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"004","insp_unit_license":"7616F80","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDRXJSJX6903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:57:29.000000Z","updated_at":"2025-04-25T10:01:58.000000Z"},{"id":13691331,"change_date":"2025-04-21 21:40:00","inspection_id":"84457892","insp_unit_id":"206418293","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"1262","insp_unit_license":"TS9984","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"5V8VC5325CM205024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:57:29.000000Z","updated_at":"2025-04-25T10:01:58.000000Z"}]},{"id":8298617,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","dot_number":"3697253","report_state":"TX","report_number":"V251827898","insp_date":"2025-04-03 00:00:00","insp_start_time":"0915","insp_end_time":"1016","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAN ANTONIO MASONRY & STEEL","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9542239","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-04-07T10:22:20.000000Z","updated_at":"2025-04-08T10:09:53.000000Z","inspection_violations":[{"id":13049969,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449882","seq_no":"1","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"206162875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"39347A"},{"id":13049970,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449883","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206162875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"39353B"},{"id":13049971,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449884","seq_no":"3","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206162876","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"39355E"},{"id":13049972,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449885","seq_no":"4","part_no":"393","part_no_section":"60E-WS","insp_viol_unit":"1","insp_unit_id":"206162875","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"39360EWS"},{"id":13049973,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449886","seq_no":"5","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"206162876","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"39375C"},{"id":13049974,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449887","seq_no":"6","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"206162875","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"39383G"},{"id":13049975,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_violation_id":"265449888","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206162875","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:53.000000Z","updated_at":"2025-04-07T11:01:17.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13455321,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_unit_id":"206162875","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52","insp_unit_license":"62N052N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:13:05.000000Z","updated_at":"2025-04-08T10:01:33.000000Z"},{"id":13455322,"change_date":"2025-04-04 21:41:00","inspection_id":"84318061","insp_unit_id":"206162876","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"7000","insp_unit_license":"BQ9529","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS25336G813803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:13:05.000000Z","updated_at":"2025-04-08T10:01:33.000000Z"}]},{"id":7816706,"change_date":"2025-02-07 21:40:00","inspection_id":"83811467","dot_number":"3697253","report_state":"TX","report_number":"72HC9DAO0N","insp_date":"2025-01-30 00:00:00","insp_start_time":"1215","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN TRAVIS CO. (223-250","county_code_state":"TX","county_code":"453","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9492029","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T21:00:22.000000Z","updated_at":"2025-03-17T21:00:22.000000Z","inspection_violations":[{"id":12214731,"change_date":"2025-02-07 21:40:00","inspection_id":"83811467","insp_violation_id":"264404456","seq_no":"1","part_no":"393","part_no_section":"201D","insp_viol_unit":"2","insp_unit_id":"205218773","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":12614813,"change_date":"2025-02-07 21:40:00","inspection_id":"83811467","insp_unit_id":"205218772","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"7167C82","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDRXJSJX6903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"},{"id":12614814,"change_date":"2025-02-07 21:40:00","inspection_id":"83811467","insp_unit_id":"205218773","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"25UF4P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS41L6003456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"}]},{"id":7451704,"change_date":"2026-04-09 22:07:00","inspection_id":"83428048","dot_number":"3697253","report_state":"TX","report_number":"V241668984","insp_date":"2024-12-12 00:00:00","insp_start_time":"1415","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B501","location_desc":"COLUMBIA POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRAVO RIVER TRANSPORT","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-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9453627","transaction_code":"C","transaction_date":"2024-12-19 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-12-18 21:41:00","snet_input_date":"2024-12-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T20:51:33.000000Z","updated_at":"2026-04-20T09:52:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20029904,"change_date":"2026-04-09 22:07:00","inspection_id":"83428048","insp_unit_id":"212775323","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"1N69902","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD51GLHA3260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:29.000000Z","updated_at":"2026-04-19T09:58:44.000000Z"}]},{"id":7395839,"change_date":"2024-12-13 21:41:00","inspection_id":"83369342","dot_number":"3697253","report_state":"TX","report_number":"V241718353","insp_date":"2024-12-03 00:00:00","insp_start_time":"0955","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 MM59 NB LA SALL","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO RIVER TRANSPORT","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-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9446246","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T20:50:20.000000Z","updated_at":"2025-03-17T20:50:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11930983,"change_date":"2024-12-13 21:41:00","inspection_id":"83369342","insp_unit_id":"204379306","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"003","insp_unit_license":"R711511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGB8372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:44.000000Z","updated_at":"2025-03-17T23:46:44.000000Z"}]},{"id":6588057,"change_date":"2026-04-09 22:06:00","inspection_id":"82512331","dot_number":"3697253","report_state":"TX","report_number":"V241514703","insp_date":"2024-08-23 00:00:00","insp_start_time":"1545","insp_end_time":"1611","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B501","location_desc":"COLUMBIA POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRAVO RIVER TRANSPORT","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-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9363659","transaction_code":"C","transaction_date":"2024-08-28 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-08-28 21:43:00","snet_input_date":"2024-08-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-28 21:43:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T20:33:39.000000Z","updated_at":"2026-04-20T09:48:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20018613,"change_date":"2026-04-09 22:06:00","inspection_id":"82512331","insp_unit_id":"212757409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"R711511","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGB8372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:20.000000Z","updated_at":"2026-04-19T09:55:56.000000Z"}]},{"id":6336885,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","dot_number":"3697253","report_state":"TX","report_number":"6X9G9DMWJ5","insp_date":"2024-07-26 00:00:00","insp_start_time":"1600","insp_end_time":"1745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12800 S IH 35 HWY","county_code_state":"TX","county_code":"453","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9336358","transaction_code":"C","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T20:28:18.000000Z","updated_at":"2025-03-17T20:28:18.000000Z","inspection_violations":[{"id":9838550,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","insp_violation_id":"260926904","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3958A1"},{"id":9838551,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","insp_violation_id":"260926905","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202153763","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39617C"},{"id":9838552,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","insp_violation_id":"260926906","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202153762","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39378"},{"id":9838553,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","insp_violation_id":"260926907","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202153762","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10211244,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","insp_unit_id":"202153762","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"},{"id":10211245,"change_date":"2024-07-30 21:44:00","inspection_id":"82244316","insp_unit_id":"202153763","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5380","insp_unit_license":"268218C","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532365L902384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"}]},{"id":5218256,"change_date":"2024-03-05 21:41:00","inspection_id":"81031261","dot_number":"3697253","report_state":"TX","report_number":"V241344342","insp_date":"2024-02-26 00:00:00","insp_start_time":"1415","insp_end_time":"1447","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-35 MM-59 NB LA SA","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO RIVER TRANSPORT","shipping_paper_number":"FSC21170","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9216035","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-02-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8043136,"change_date":"2024-03-05 21:41:00","inspection_id":"81031261","insp_violation_id":"258218863","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"199769661","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39383G"},{"id":8043137,"change_date":"2024-03-05 21:41:00","inspection_id":"81031261","insp_violation_id":"258218864","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199769662","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8402931,"change_date":"2024-03-05 21:41:00","inspection_id":"81031261","insp_unit_id":"199769661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"69U457M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YDA97797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"},{"id":8402932,"change_date":"2024-03-05 21:41:00","inspection_id":"81031261","insp_unit_id":"199769662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53052","insp_unit_license":"61UK3A","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2532GP549586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"}]},{"id":5055078,"change_date":"2024-02-14 21:42:00","inspection_id":"80853590","dot_number":"3697253","report_state":"TX","report_number":"V241327082","insp_date":"2024-02-09 00:00:00","insp_start_time":"0910","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRAVO RIVER TRANSPORT INC","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-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9196869","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7792424,"change_date":"2024-02-14 21:42:00","inspection_id":"80853590","insp_violation_id":"257849064","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"199431246","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39345"},{"id":7792425,"change_date":"2024-02-14 21:42:00","inspection_id":"80853590","insp_violation_id":"257849065","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199431246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39345B2"},{"id":7792426,"change_date":"2024-02-14 21:42:00","inspection_id":"80853590","insp_violation_id":"257849066","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199431246","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8137216,"change_date":"2024-02-14 21:42:00","inspection_id":"80853590","insp_unit_id":"199431246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"79N430M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YDA97797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":4634967,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","dot_number":"3697253","report_state":"TX","report_number":"V231163927","insp_date":"2023-12-07 00:00:00","insp_start_time":"1340","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 NORTHBOUND MILE","county_code_state":"TX","county_code":"283","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG BOX FDC","shipping_paper_number":"314370414","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":null,"post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9147564","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2024-12-04 21:42:00","snet_input_date":"2023-12-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[{"id":7165124,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234499","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"393209D"},{"id":7165125,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234500","seq_no":"2","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"393209E"},{"id":7165126,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234501","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39345"},{"id":7165127,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234502","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39360C"},{"id":7165128,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234503","seq_no":"5","part_no":"393","part_no_section":"83F","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39383F"},{"id":7165129,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234504","seq_no":"6","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3958AELD"},{"id":7165130,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234505","seq_no":"7","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"204184857","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3963A1"},{"id":7165131,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234506","seq_no":"8","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3965B"},{"id":7165132,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_violation_id":"263234507","seq_no":"9","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204184856","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7454823,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_unit_id":"204184856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52","insp_unit_license":"51S365M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"},{"id":7454824,"change_date":"2024-12-04 21:42:00","inspection_id":"80394334","insp_unit_id":"204184857","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"HMKD802150","insp_unit_license":"P858544","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D3NL333086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4412261,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","dot_number":"3697253","report_state":"TX","report_number":"V231211737","insp_date":"2023-11-09 00:00:00","insp_start_time":"1340","insp_end_time":"1413","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"RIC WILLIAMSON MEMOR","county_code_state":"TX","county_code":"367","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WEATHERFORD CUSHION","shipping_paper_number":"27946676","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":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9123712","transaction_code":"A","transaction_date":"2023-11-13 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:50:19.000000Z","updated_at":"2025-03-17T19:50:19.000000Z","inspection_violations":[{"id":6828270,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364044","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39145B"},{"id":6828271,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364045","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39319"},{"id":6828272,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364046","seq_no":"3","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"393209E"},{"id":6828273,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364047","seq_no":"4","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"198032871","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39355D3"},{"id":6828274,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364048","seq_no":"5","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39360C"},{"id":6828275,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364049","seq_no":"6","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39383G"},{"id":6828276,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364050","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198032871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3939A"},{"id":6828277,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364051","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3939A"},{"id":6828278,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364052","seq_no":"9","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3965B"},{"id":6828279,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_violation_id":"256364053","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198032870","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7096195,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_unit_id":"198032870","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52","insp_unit_license":"72M339M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:35.000000Z","updated_at":"2025-03-17T22:59:35.000000Z"},{"id":7096196,"change_date":"2023-11-13 21:42:00","inspection_id":"80149549","insp_unit_id":"198032871","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"53113","insp_unit_license":"76UF3P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS45L6003475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:35.000000Z","updated_at":"2025-03-17T22:59:35.000000Z"}]},{"id":3904115,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","dot_number":"3697253","report_state":"TX","report_number":"V231084683","insp_date":"2023-09-03 00:00:00","insp_start_time":"0030","insp_end_time":"0103","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A401","location_desc":"IH 35 SOUTHBOUND SAN MARCOS","county_code_state":"TX","county_code":"209","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120938","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9068242","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-09-05 21:41:00","snet_input_date":"2023-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:40:04.000000Z","updated_at":"2025-03-17T19:40:04.000000Z","inspection_violations":[{"id":6033260,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085780","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196900603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39311"},{"id":6033261,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085781","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"196900604","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"393209E"},{"id":6033262,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085782","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196900604","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39375C"},{"id":6033263,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085783","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196900604","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39375C"},{"id":6033264,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085784","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196900603","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"3939A"},{"id":6033265,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085785","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196900604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"3939A"},{"id":6033266,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_violation_id":"255085786","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196900604","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":6277446,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_unit_id":"196900603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"53112","insp_unit_license":"85UF3P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS43L6003474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"},{"id":6277447,"change_date":"2023-09-05 21:41:00","inspection_id":"79586357","insp_unit_id":"196900604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"59M255M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YDA97797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"}]},{"id":2711544,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","dot_number":"3697253","report_state":"TX","report_number":"6JSF0ALSED","insp_date":"2023-03-29 00:00:00","insp_start_time":"1521","insp_end_time":"1553","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN LA SALLE CO. (38-82","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER CORP","shipping_paper_number":"MXA047411","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8942538","transaction_code":"A","transaction_date":"2023-03-31 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:16:36.000000Z","updated_at":"2025-03-17T19:16:36.000000Z","inspection_violations":[{"id":4165527,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","insp_violation_id":"251995529","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194177101","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"3939A"},{"id":4165528,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","insp_violation_id":"251995530","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194177101","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"39375C"},{"id":4165529,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","insp_violation_id":"251995531","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194177102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"3939A"},{"id":4165530,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","insp_violation_id":"251995532","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194177102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4363907,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","insp_unit_id":"194177101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"002","insp_unit_license":"1N53299","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP4D49X8CD144890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"},{"id":4363908,"change_date":"2023-03-31 21:41:00","inspection_id":"78244194","insp_unit_id":"194177102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"53134","insp_unit_license":"08UF5P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS47M6003074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"}]},{"id":2546898,"change_date":"2023-06-07 21:42:00","inspection_id":"78056034","dot_number":"3697253","report_state":"TX","report_number":"V231000991","insp_date":"2023-02-20 00:00:00","insp_start_time":"0239","insp_end_time":"0251","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 83 AND FM 374","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BARCEL SA","shipping_paper_number":"23111300","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8924908","transaction_code":"C","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-03-09 21:43:00","snet_input_date":"2023-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-09 21:43:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:13:41.000000Z","updated_at":"2025-03-17T19:13:41.000000Z","inspection_violations":[{"id":3917991,"change_date":"2023-06-07 21:42:00","inspection_id":"78056034","insp_violation_id":"253369742","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195383140","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4099712,"change_date":"2023-06-07 21:42:00","inspection_id":"78056034","insp_unit_id":"195383140","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"862697G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YDA97797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:22.000000Z","updated_at":"2025-03-17T22:35:22.000000Z"},{"id":4099713,"change_date":"2023-06-07 21:42:00","inspection_id":"78056034","insp_unit_id":"195383141","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"53134","insp_unit_license":"08UF5P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS47M6003074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:22.000000Z","updated_at":"2025-03-17T22:35:22.000000Z"}]},{"id":2258415,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","dot_number":"3697253","report_state":"TX","report_number":"6I0G0XUCSB","insp_date":"2023-01-24 00:00:00","insp_start_time":"1635","insp_end_time":"1714","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN LA SALLE CO. (38-82","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CONVERTIDORA","shipping_paper_number":"53134","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8891354","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:08:10.000000Z","updated_at":"2025-03-17T19:08:10.000000Z","inspection_violations":[{"id":3486327,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_violation_id":"250854416","seq_no":"1","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"193137045","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"393203A"},{"id":3486328,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_violation_id":"250854417","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3958"},{"id":3486329,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_violation_id":"250854418","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193137045","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3965B"},{"id":3486330,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_violation_id":"250854419","seq_no":"4","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"193137045","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39381"},{"id":3486331,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_violation_id":"250854420","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193137045","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39378"},{"id":3486332,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_violation_id":"250854421","seq_no":"6","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"193137046","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":3635515,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_unit_id":"193137045","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"808869G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG12LJ55423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"},{"id":3635516,"change_date":"2023-01-30 21:44:00","inspection_id":"77727736","insp_unit_id":"193137046","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T001","insp_unit_license":"08UF5P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS47M6003074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"}]},{"id":2246989,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","dot_number":"3697253","report_state":"TX","report_number":"6HSF0IIT20","insp_date":"2023-01-16 00:00:00","insp_start_time":"1509","insp_end_time":"1616","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN MCLENNAN CO. (316-3","county_code_state":"TX","county_code":"309","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8889889","transaction_code":"A","transaction_date":"2023-01-27 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-01-27 21:41:00","snet_input_date":"2023-01-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:08:06.000000Z","updated_at":"2025-03-17T19:08:06.000000Z","inspection_violations":[{"id":3471543,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_violation_id":"250830315","seq_no":"1","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"193111525","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39355D2"},{"id":3471544,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_violation_id":"250830316","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193111525","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39378"},{"id":3471545,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_violation_id":"250830317","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193111526","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3939A"},{"id":3471546,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_violation_id":"250830318","seq_no":"4","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"193111526","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39355D3"},{"id":3471547,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_violation_id":"250830319","seq_no":"5","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3958A1"},{"id":3471548,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_violation_id":"250830320","seq_no":"6","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":3616796,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_unit_id":"193111525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"002","insp_unit_license":"781498G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP4D49X8CD144890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"},{"id":3616797,"change_date":"2023-01-27 21:41:00","inspection_id":"77714813","insp_unit_id":"193111526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"7000","insp_unit_license":"BQ9529","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS25336G813803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"}]},{"id":2048988,"change_date":"2023-01-02 21:31:00","inspection_id":"77487851","dot_number":"3697253","report_state":"TX","report_number":"6H7F0AGK54","insp_date":"2022-12-26 00:00:00","insp_start_time":"1451","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN LA SALLE CO. (38-82","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO RIVER TRANSPORT","shipping_paper_number":"SF10104387","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-02 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8864729","transaction_code":"A","transaction_date":"2023-01-02 00:00:00","upload_date":"2023-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2023-01-02 21:31:00","snet_input_date":"2022-12-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-02 21:31:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T19:04:22.000000Z","updated_at":"2025-03-17T19:04:22.000000Z","inspection_violations":[{"id":3172694,"change_date":"2023-01-02 21:31:00","inspection_id":"77487851","insp_violation_id":"250341596","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"192657242","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:01.000000Z","updated_at":"2025-03-17T21:22:01.000000Z","normalized_code":"39383G"},{"id":3172695,"change_date":"2023-01-02 21:31:00","inspection_id":"77487851","insp_violation_id":"250341597","seq_no":"2","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"192657243","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:01.000000Z","updated_at":"2025-03-17T21:22:01.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":3295971,"change_date":"2023-01-02 21:31:00","inspection_id":"77487851","insp_unit_id":"192657242","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"740206G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YDA97797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:36.000000Z","updated_at":"2025-03-17T22:29:36.000000Z"},{"id":3295972,"change_date":"2023-01-02 21:31:00","inspection_id":"77487851","insp_unit_id":"192657243","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"53128","insp_unit_license":"02UF5P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:36.000000Z","updated_at":"2025-03-17T22:29:36.000000Z"}]},{"id":1699749,"change_date":"2022-11-09 21:41:00","inspection_id":"77088154","dot_number":"3697253","report_state":"TX","report_number":"6FQC0MWV57","insp_date":"2022-11-03 00:00:00","insp_start_time":"1236","insp_end_time":"1256","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN LA SALLE CO. (38-82","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COVERTIDORA","shipping_paper_number":"FSC19303","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-08 21:38: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":"8821804","transaction_code":"C","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03697253","upload_search_indicator":"M","census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"BRAVO RIVER TRANSPORT INC","insp_carrier_street":"6014 COLT DR","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78043","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041125","created_at":"2025-03-17T18:57:49.000000Z","updated_at":"2025-03-17T18:57:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2735045,"change_date":"2022-11-09 21:41:00","inspection_id":"77088154","insp_unit_id":"191891451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"628432G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YDA97797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"},{"id":2735046,"change_date":"2022-11-09 21:41:00","inspection_id":"77088154","insp_unit_id":"191891452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"79UF4P","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3ELDTMS40M6002235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3697253\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3697253\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3697253\/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\/3697253\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}