{"current_page":1,"data":[{"id":12031514,"change_date":"2026-05-27 21:40:00","inspection_id":"87971739","dot_number":"3342873","report_state":"TX","report_number":"7DS99DMNIW","insp_date":"2026-03-13 00:00:00","insp_start_time":"0913","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"800 E 87TH ST","county_code_state":"TX","county_code":"135","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOUTHWEST","shipping_paper_number":"UNKNOWN","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-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9970412","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-03-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2026-05-30T09:39:37.000000Z","updated_at":"2026-06-07T09:31:27.000000Z","inspection_violations":[{"id":20935423,"change_date":"2026-05-27 21:40:00","inspection_id":"87971739","insp_violation_id":"274535657","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-05-30T09:58:04.000000Z","updated_at":"2026-06-07T09:43:30.000000Z","normalized_code":"39111B2Q"},{"id":20935424,"change_date":"2026-05-27 21:40:00","inspection_id":"87971739","insp_violation_id":"274535658","seq_no":"2","part_no":"395","part_no_section":"24D","insp_viol_unit":"1","insp_unit_id":"213780570","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:04.000000Z","updated_at":"2026-06-07T09:43:30.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":20912549,"change_date":"2026-05-27 21:40:00","inspection_id":"87971739","insp_unit_id":"213780570","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"15V237W","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV3HSHY7849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:46.000000Z","updated_at":"2026-06-07T09:03:20.000000Z"},{"id":20912550,"change_date":"2026-05-27 21:40:00","inspection_id":"87971739","insp_unit_id":"213780571","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"90Z236W","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482WLXL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:46.000000Z","updated_at":"2026-06-07T09:03:20.000000Z"}]},{"id":10148532,"change_date":"2025-11-07 21:40:00","inspection_id":"86266637","dot_number":"3342873","report_state":"TX","report_number":"V252103035","insp_date":"2025-11-05 00:00:00","insp_start_time":"1958","insp_end_time":"2024","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"233M IH20 WB","county_code_state":"TX","county_code":"353","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MODERN POLYMER PIPE","shipping_paper_number":"106116","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"9750857","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-11-10T10:31:44.000000Z","updated_at":"2025-11-11T10:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16895500,"change_date":"2025-11-07 21:40:00","inspection_id":"86266637","insp_unit_id":"209910346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"16","insp_unit_license":"92R448N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJ6LDV3HSHY7849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:16.000000Z","updated_at":"2025-11-11T10:01:17.000000Z"},{"id":16895501,"change_date":"2025-11-07 21:40:00","inspection_id":"86266637","insp_unit_id":"209910347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"95R448N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482WLXL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:16.000000Z","updated_at":"2025-11-11T10:01:17.000000Z"}]},{"id":10047383,"change_date":"2025-10-27 21:39:00","inspection_id":"86160022","dot_number":"3342873","report_state":"TX","report_number":"V252064236","insp_date":"2025-10-20 00:00:00","insp_start_time":"1054","insp_end_time":"1126","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 285 MM 420","county_code_state":"TX","county_code":"371","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CALICHE NOW","shipping_paper_number":"13456","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-10-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"9738570","transaction_code":"A","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2025-10-27 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-10-30T10:00:49.000000Z","updated_at":"2025-11-01T10:01:13.000000Z","inspection_violations":[{"id":16626550,"change_date":"2025-10-27 21:39:00","inspection_id":"86160022","insp_violation_id":"269545753","seq_no":"1","part_no":"393","part_no_section":"11S","insp_viol_unit":"2","insp_unit_id":"209678792","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-30T10:16:05.000000Z","updated_at":"2025-10-31T10:17:07.000000Z","normalized_code":"39311S"},{"id":16626551,"change_date":"2025-10-27 21:39:00","inspection_id":"86160022","insp_violation_id":"269545754","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209678791","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-30T10:16:05.000000Z","updated_at":"2025-10-31T10:17:07.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":16694905,"change_date":"2025-10-27 21:39:00","inspection_id":"86160022","insp_unit_id":"209678791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"55S416N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR5DSBA4334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:54.000000Z","updated_at":"2025-10-31T09:46:30.000000Z"},{"id":16694906,"change_date":"2025-10-27 21:39:00","inspection_id":"86160022","insp_unit_id":"209678792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"68T399N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC1116297P008177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:54.000000Z","updated_at":"2025-10-31T09:46:30.000000Z"}]},{"id":9217391,"change_date":"2025-07-22 21:42:00","inspection_id":"85287362","dot_number":"3342873","report_state":"TX","report_number":"V251927939","insp_date":"2025-07-21 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"N OLD POST RD AT GIL","county_code_state":"TX","county_code":"415","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SAHILY & KATIA TRUKING","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9645054","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15158860,"change_date":"2025-07-22 21:42:00","inspection_id":"85287362","insp_unit_id":"208015038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"304","insp_unit_license":"R745741","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK76LU58240","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:09.000000Z"},{"id":15158861,"change_date":"2025-07-22 21:42:00","inspection_id":"85287362","insp_unit_id":"208015039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"304","insp_unit_license":"229B463","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRDM9623GH727783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:09.000000Z"}]},{"id":8416748,"change_date":"2025-04-18 21:40:00","inspection_id":"84442470","dot_number":"3342873","report_state":"TX","report_number":"V251827964","insp_date":"2025-04-16 00:00:00","insp_start_time":"2340","insp_end_time":"0017","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:32\u00bf\u00bf27'31.84\"N","county_code_state":"TX","county_code":"441","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RAARE","shipping_paper_number":"41623-2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","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":"9554095","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2025-04-18 21:40:00","snet_input_date":"2025-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-04-21T10:26:15.000000Z","updated_at":"2025-04-23T10:03:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13665764,"change_date":"2025-04-18 21:40:00","inspection_id":"84442470","insp_unit_id":"206390502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"16","insp_unit_license":"76N074N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV3HSHY7849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:17:22.000000Z","updated_at":"2025-04-22T10:04:07.000000Z"},{"id":13665765,"change_date":"2025-04-18 21:40:00","inspection_id":"84442470","insp_unit_id":"206390503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"06","insp_unit_license":"97N074N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148302V1575667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:17:22.000000Z","updated_at":"2025-04-22T10:04:07.000000Z"}]},{"id":7653318,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","dot_number":"3342873","report_state":"TX","report_number":"V251745435","insp_date":"2025-01-14 00:00:00","insp_start_time":"0917","insp_end_time":"0944","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13385  TX36","county_code_state":"TX","county_code":"477","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"OCCIDENTAL PERMIAN LTD","shipping_paper_number":"7280839","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-01-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9476253","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2025-01-17 21:40:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-17 21:40:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T20:57:03.000000Z","updated_at":"2025-03-17T20:57:03.000000Z","inspection_violations":[{"id":11957269,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_violation_id":"264063678","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"204899737","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"393209E"},{"id":11957270,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_violation_id":"264063679","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"204899738","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"39375A3"},{"id":11957271,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_violation_id":"264063680","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204899737","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3939TS"},{"id":11957272,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_violation_id":"264063681","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"204899738","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3939TS"},{"id":11957273,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_violation_id":"264063682","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"204899738","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":12349291,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_unit_id":"204899737","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"25N918M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"},{"id":12349292,"change_date":"2025-01-17 21:40:00","inspection_id":"83639725","insp_unit_id":"204899738","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"35N918M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148302V1575667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"}]},{"id":7221386,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","dot_number":"3342873","report_state":"TX","report_number":"V241600586","insp_date":"2024-11-13 00:00:00","insp_start_time":"0903","insp_end_time":"0956","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WEATHERFORD ARTIFICIAL","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-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9429921","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T20:46:47.000000Z","updated_at":"2025-03-17T20:46:47.000000Z","inspection_violations":[{"id":11286551,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_violation_id":"262958046","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203937044","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39347E"},{"id":11286552,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_violation_id":"262958047","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203937044","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39347E"},{"id":11286553,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_violation_id":"262958048","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203937044","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39353B"},{"id":11286554,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_violation_id":"262958049","seq_no":"4","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"203937044","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"3963A1BOS"},{"id":11286555,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_violation_id":"262958050","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203937045","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11648216,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_unit_id":"203937044","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"91","insp_unit_license":"85U841M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"},{"id":11648217,"change_date":"2024-11-18 21:41:00","inspection_id":"83185524","insp_unit_id":"203937045","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":6771860,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","dot_number":"3342873","report_state":"TX","report_number":"V241540512","insp_date":"2024-09-17 00:00:00","insp_start_time":"1338","insp_end_time":"1426","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX115","county_code_state":"TX","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAKER HUGHES","shipping_paper_number":"104200778513","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-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","viol_total":"14","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9381525","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[{"id":10547361,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931025","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"38323A2"},{"id":10547362,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931026","seq_no":"2","part_no":"392","part_no_section":"9a(a)(2)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3929AA2"},{"id":10547363,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931027","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39347E"},{"id":10547364,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931028","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39353B"},{"id":10547365,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931029","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203034931","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547366,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931030","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203034931","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547367,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931031","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547368,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931032","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203034931","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547369,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931033","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547370,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931034","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203034931","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547371,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931035","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547372,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931036","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203034930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3939A"},{"id":10547373,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931037","seq_no":"13","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3953A3II"},{"id":10547374,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_violation_id":"261931038","seq_no":"14","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203034931","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10920086,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_unit_id":"203034930","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"91","insp_unit_license":"56Z565V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"},{"id":10920087,"change_date":"2024-09-19 21:42:00","inspection_id":"82708108","insp_unit_id":"203034931","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"}]},{"id":6459244,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","dot_number":"3342873","report_state":"TX","report_number":"V241484648","insp_date":"2024-08-08 00:00:00","insp_start_time":"1310","insp_end_time":"1438","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12825 IH20 EB SVC RD","county_code_state":"TX","county_code":"353","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DIAMONDBACK","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9349006","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2024-08-13 21:43:00","snet_input_date":"2024-08-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-13 21:43:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T20:30:45.000000Z","updated_at":"2025-03-17T20:30:45.000000Z","inspection_violations":[{"id":10032205,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175115","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202375692","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"39347E"},{"id":10032206,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175116","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202375692","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"39353B"},{"id":10032207,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175117","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202375692","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"39383G"},{"id":10032208,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175118","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202375692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3939A"},{"id":10032209,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175119","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202375693","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3939A"},{"id":10032210,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175120","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202375692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3939A"},{"id":10032211,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175121","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202375692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3939A"},{"id":10032212,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_violation_id":"261175122","seq_no":"8","part_no":"392","part_no_section":"2","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":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10411237,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_unit_id":"202375692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTE","insp_unit_company":"91","insp_unit_license":"80T686M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:54.000000Z","updated_at":"2025-03-17T23:30:54.000000Z"},{"id":10411238,"change_date":"2024-08-13 21:43:00","inspection_id":"82375218","insp_unit_id":"202375693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:54.000000Z","updated_at":"2025-03-17T23:30:54.000000Z"}]},{"id":5769857,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","dot_number":"3342873","report_state":"TX","report_number":"V241362431","insp_date":"2024-05-10 00:00:00","insp_start_time":"1200","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB","county_code_state":"TX","county_code":"161","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":"Y","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"1","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9274905","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T20:17:06.000000Z","updated_at":"2025-03-17T20:17:06.000000Z","inspection_violations":[{"id":8932475,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554844","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"200936475","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3929A2"},{"id":8932476,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554845","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"200936474","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"393209E"},{"id":8932477,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554846","seq_no":"3","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"2","insp_unit_id":"200936475","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39375A4"},{"id":8932478,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554847","seq_no":"4","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"200936474","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39381"},{"id":8932479,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554848","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200936474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3939A"},{"id":8932480,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554849","seq_no":"6","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39522G"},{"id":8932481,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554850","seq_no":"7","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39522H1"},{"id":8932482,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554851","seq_no":"8","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39522H2"},{"id":8932483,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554852","seq_no":"9","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39522H3"},{"id":8932484,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554853","seq_no":"10","part_no":"396","part_no_section":"5(a)","insp_viol_unit":"2","insp_unit_id":"200936475","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3965A"},{"id":8932485,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_violation_id":"259554854","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200936474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9293357,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_unit_id":"200936474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"91","insp_unit_license":"90W407V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"},{"id":9293358,"change_date":"2024-05-16 21:41:00","inspection_id":"81632664","insp_unit_id":"200936475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":4635830,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","dot_number":"3342873","report_state":"TX","report_number":"V231238850","insp_date":"2023-12-08 00:00:00","insp_start_time":"0526","insp_end_time":"0613","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:31  28'18.61\"N","county_code_state":"TX","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BJS SAND BAGGER","shipping_paper_number":"1527C","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-12-14 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9147710","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2023-12-14 21:44:00","snet_input_date":"2023-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:44:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[{"id":7167679,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_violation_id":"263370574","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204303210","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39375C"},{"id":7167680,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_violation_id":"263370575","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"204303211","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39375C"},{"id":7167681,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_violation_id":"263370576","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204303211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3939"},{"id":7167682,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_violation_id":"263370577","seq_no":"4","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204303210","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3965B"},{"id":7167683,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_violation_id":"263370578","seq_no":"5","part_no":"392","part_no_section":"2WC","insp_viol_unit":"2","insp_unit_id":"204303211","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":7456254,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_unit_id":"204303210","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"91","insp_unit_license":"43N368M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:41.000000Z","updated_at":"2025-03-17T23:02:41.000000Z"},{"id":7456255,"change_date":"2024-12-10 21:41:00","inspection_id":"80395304","insp_unit_id":"204303211","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:41.000000Z","updated_at":"2025-03-17T23:02:41.000000Z"}]},{"id":3718575,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","dot_number":"3342873","report_state":"TX","report_number":"6NHC9DAT8Z","insp_date":"2023-08-09 00:00:00","insp_start_time":"1152","insp_end_time":"1254","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11400  FAIRWAY PINES","county_code_state":"TX","county_code":"157","insp_level_id":"1","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":"2023-08-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"96500","viol_total":"14","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9049838","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2023-08-10 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-10 21:42:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T19:36:10.000000Z","updated_at":"2025-03-17T19:36:10.000000Z","inspection_violations":[{"id":5734433,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593356","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"3922"},{"id":5734434,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593357","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196478015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"3922"},{"id":5734435,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593358","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"3922"},{"id":5734436,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593359","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39375C"},{"id":5734437,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593360","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39375C"},{"id":5734438,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593361","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39347E"},{"id":5734439,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593362","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39353B"},{"id":5734440,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593363","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"3963A1"},{"id":5734441,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593364","seq_no":"9","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39355D2"},{"id":5734442,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593365","seq_no":"10","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"196478015","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39360D"},{"id":5734443,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593366","seq_no":"11","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196478015","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39395A"},{"id":5734444,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593367","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196478015","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"3939A"},{"id":5734445,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593368","seq_no":"13","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"393201A"},{"id":5734446,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_violation_id":"254593369","seq_no":"14","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"196478016","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"393201A"}],"inspection_per_units":[{"id":5979135,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_unit_id":"196478015","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"JD58MJ","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"4V4NC9EH5EN156940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"},{"id":5979136,"change_date":"2023-08-10 21:42:00","inspection_id":"79379196","insp_unit_id":"196478016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"178C655","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF48201W1058426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"}]},{"id":3313815,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","dot_number":"3342873","report_state":"TX","report_number":"6LZH0ALZTN","insp_date":"2023-06-16 00:00:00","insp_start_time":"1720","insp_end_time":"1800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0006 IN SHACKELFORD CO. (29","county_code_state":"TX","county_code":"417","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ROCKDALE STONE","shipping_paper_number":"1033","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-06-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9009153","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2023-06-19 21:36:00","snet_input_date":"2023-06-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-19 21:36:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T19:28:33.000000Z","updated_at":"2025-03-17T19:28:33.000000Z","inspection_violations":[{"id":5112490,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579902","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195562964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3939A"},{"id":5112491,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579903","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195562965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3939A"},{"id":5112492,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579904","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"195562965","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"39345D"},{"id":5112493,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579905","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195562965","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3922"},{"id":5112494,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579906","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"195562965","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"393110B"},{"id":5112495,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579907","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"195562964","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"393205C"},{"id":5112496,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_violation_id":"253579908","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195562964","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":5327881,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_unit_id":"195562964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"80M150M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:01.000000Z","updated_at":"2025-03-17T22:45:01.000000Z"},{"id":5327882,"change_date":"2023-06-19 21:36:00","inspection_id":"78925080","insp_unit_id":"195562965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:01.000000Z","updated_at":"2025-03-17T22:45:01.000000Z"}]},{"id":3047538,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","dot_number":"3342873","report_state":"TX","report_number":"6L089DGTWU","insp_date":"2023-05-12 00:00:00","insp_start_time":"0826","insp_end_time":"0946","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8979120","transaction_code":"C","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4683210,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035642","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39347E"},{"id":4683211,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035643","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39353B"},{"id":4683212,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035644","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39347A"},{"id":4683213,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035645","seq_no":"4","part_no":"393","part_no_section":"50","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39350"},{"id":4683214,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035646","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39378"},{"id":4683215,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035647","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939A"},{"id":4683216,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035648","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939A"},{"id":4683217,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035649","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939A"},{"id":4683218,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035650","seq_no":"9","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"195102879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39319"},{"id":4683219,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_violation_id":"253035651","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195102880","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4903020,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_unit_id":"195102879","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"92R101M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"},{"id":4903021,"change_date":"2023-05-23 21:43:00","inspection_id":"78624456","insp_unit_id":"195102880","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"}]},{"id":3004282,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","dot_number":"3342873","report_state":"TX","report_number":"6KQB0XCVXR","insp_date":"2023-05-02 00:00:00","insp_start_time":"1010","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PROTECTIVE COATINGS","shipping_paper_number":"435964","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"63000","viol_total":"17","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"17","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8974247","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2023-05-09 21:43:00","snet_input_date":"2023-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T19:22:36.000000Z","updated_at":"2025-03-17T19:22:36.000000Z","inspection_violations":[{"id":4614024,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726257","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39345D"},{"id":4614025,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726258","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39395F"},{"id":4614026,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726259","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3965B"},{"id":4614027,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726260","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3939A"},{"id":4614028,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726261","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39319"},{"id":4614029,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726262","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3939A"},{"id":4614030,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726263","seq_no":"7","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3929A2"},{"id":4614031,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726264","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194839136","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3965B"},{"id":4614032,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726265","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3963A1"},{"id":4614033,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726266","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39348A"},{"id":4614034,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726267","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39348A"},{"id":4614035,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726268","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39348A"},{"id":4614036,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726269","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39348A"},{"id":4614037,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726270","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3963A1"},{"id":4614038,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726271","seq_no":"16","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39347E"},{"id":4614039,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726272","seq_no":"17","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39353B"},{"id":4614040,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_violation_id":"252726273","seq_no":"18","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"194839137","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":4833933,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_unit_id":"194839136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:04.000000Z","updated_at":"2025-03-17T22:41:04.000000Z"},{"id":4833934,"change_date":"2023-05-09 21:43:00","inspection_id":"78575549","insp_unit_id":"194839137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"205B541","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:04.000000Z","updated_at":"2025-03-17T22:41:04.000000Z"}]},{"id":2086729,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","dot_number":"3342873","report_state":"TX","report_number":"6HG70XUFB8","insp_date":"2023-01-04 00:00:00","insp_start_time":"0658","insp_end_time":"0751","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0014 IN CORYELL CO. (277-27","county_code_state":"TX","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL PIPE & SUPPLY","shipping_paper_number":"10963","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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8870287","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2023-01-06 21:39:00","snet_input_date":"2023-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"8638 GREEN RIVER DR 2800","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T19:05:07.000000Z","updated_at":"2025-03-17T19:05:07.000000Z","inspection_violations":[{"id":3229234,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_violation_id":"250434030","seq_no":"1","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"192743365","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"393104B"},{"id":3229235,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_violation_id":"250434031","seq_no":"2","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"192743365","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"393104B"},{"id":3229236,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_violation_id":"250434032","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192743365","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3939A"},{"id":3229237,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_violation_id":"250434033","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192743364","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39378"},{"id":3229238,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_violation_id":"250434034","seq_no":"5","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":3357400,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_unit_id":"192743364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"749324G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:02.000000Z","updated_at":"2025-03-17T22:30:02.000000Z"},{"id":3357401,"change_date":"2023-01-06 21:39:00","inspection_id":"77531063","insp_unit_id":"192743365","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"749333G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:02.000000Z","updated_at":"2025-03-17T22:30:02.000000Z"}]},{"id":1103073,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","dot_number":"3342873","report_state":"TX","report_number":"6DF70XNOKN","insp_date":"2022-08-12 00:00:00","insp_start_time":"0743","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN WALLER CO. (688-704","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLESS OILFIELD SERVICES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"78001","viol_total":"6","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8748508","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2022-08-22 21:43:00","snet_input_date":"2022-08-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"12955 WOODFOREST BLVD APT 61","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77015-2726","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T18:47:12.000000Z","updated_at":"2025-03-17T18:47:12.000000Z","inspection_violations":[{"id":1737723,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_violation_id":"247899603","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"190467962","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"393110B"},{"id":1737724,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_violation_id":"247899604","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"190467961","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39348A"},{"id":1737725,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_violation_id":"247899605","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190467961","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3963A1"},{"id":1737726,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_violation_id":"247899606","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190467961","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3963A1"},{"id":1737727,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_violation_id":"247899607","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190467962","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3939A"},{"id":1737728,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_violation_id":"247899608","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190467961","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1774493,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_unit_id":"190467961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"397997G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:12.000000Z","updated_at":"2025-03-17T22:19:12.000000Z"},{"id":1774494,"change_date":"2022-08-22 21:43:00","inspection_id":"76398019","insp_unit_id":"190467962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"95","insp_unit_license":"397956G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:12.000000Z","updated_at":"2025-03-17T22:19:12.000000Z"}]},{"id":179029,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","dot_number":"3342873","report_state":"TX","report_number":"69VA0XNN0Y","insp_date":"2022-04-06 00:00:00","insp_start_time":"1020","insp_end_time":"1055","registration_date":"2022-06-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN WALLER CO. (688-704","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"QUAIL RUN","shipping_paper_number":"1322","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-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8621057","transaction_code":"C","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03342873","upload_search_indicator":"M","census_search_date":"2022-04-14 21:42:00","snet_input_date":"2022-04-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-14 21:42:00","insp_carrier_name":"ALBERTO PEREZ COLVO","insp_carrier_street":"12955 WOODFOREST BLVD APT 61","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77015-2726","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016922","created_at":"2025-03-17T18:30:33.000000Z","updated_at":"2025-03-17T18:30:33.000000Z","inspection_violations":[{"id":270587,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","insp_violation_id":"246524985","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"189302611","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39375A3"},{"id":270588,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","insp_violation_id":"246524986","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189302610","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39395A"},{"id":270589,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","insp_violation_id":"246524987","seq_no":"3","part_no":"392","part_no_section":"22(b)","insp_viol_unit":"1","insp_unit_id":"189302610","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39222B"},{"id":270590,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","insp_violation_id":"246524988","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189302610","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":290152,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","insp_unit_id":"189302610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"91","insp_unit_license":"895036F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR6WC047124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"},{"id":290153,"change_date":"2022-06-16 21:43:00","inspection_id":"75306850","insp_unit_id":"189302611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"95","insp_unit_license":"895086F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482W1XL594094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3342873\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3342873\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3342873\/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\/3342873\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}