{"current_page":1,"data":[{"id":10289370,"change_date":"2025-11-25 21:39:00","inspection_id":"86414529","dot_number":"3481812","report_state":"TX","report_number":"7AMB9DJW62","insp_date":"2025-11-19 00:00:00","insp_start_time":"1103","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17700  KATY FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9768287","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-11-25 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-25 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-11-28T10:31:59.000000Z","updated_at":"2025-11-29T10:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17180281,"change_date":"2025-11-25 21:39:00","inspection_id":"86414529","insp_unit_id":"210266162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"15","insp_unit_license":"XGB1581","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y56N009686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:43.000000Z","updated_at":"2025-11-29T10:01:22.000000Z"}]},{"id":10148346,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","dot_number":"3481812","report_state":"TX","report_number":"79V69DJN0C","insp_date":"2025-10-23 00:00:00","insp_start_time":"0645","insp_end_time":"0728","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR-","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":"2025-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9750428","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":"03481812","upload_search_indicator":"M","census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-11-10T10:31:44.000000Z","updated_at":"2025-11-11T10:31:03.000000Z","inspection_violations":[{"id":16844104,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_violation_id":"269816569","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:56.000000Z","updated_at":"2025-11-11T10:32:11.000000Z","normalized_code":"39216"},{"id":16844105,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_violation_id":"269816570","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209909974","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:56.000000Z","updated_at":"2025-11-11T10:32:11.000000Z","normalized_code":"39347E"},{"id":16844106,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_violation_id":"269816571","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209909974","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:56.000000Z","updated_at":"2025-11-11T10:32:11.000000Z","normalized_code":"39347E"},{"id":16844107,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_violation_id":"269816572","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209909974","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:56.000000Z","updated_at":"2025-11-11T10:32:11.000000Z","normalized_code":"39395F"},{"id":16844108,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_violation_id":"269816573","seq_no":"5","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209909974","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-10T10:32:56.000000Z","updated_at":"2025-11-11T10:32:11.000000Z","normalized_code":"3963A1BOS"},{"id":16844109,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_violation_id":"269816574","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"209909974","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:56.000000Z","updated_at":"2025-11-11T10:32:11.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":16895177,"change_date":"2025-11-07 21:40:00","inspection_id":"86266438","insp_unit_id":"209909974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"TBW8301","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y63W151799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:16.000000Z","updated_at":"2025-11-11T10:01:15.000000Z"}]},{"id":9829264,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","dot_number":"3481812","report_state":"TX","report_number":"793A9DAZFB","insp_date":"2025-09-25 00:00:00","insp_start_time":"1010","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"22000  LONGENBAUGH R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2025-10-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51220","viol_total":"11","oos_total":"2","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9711606","transaction_code":"A","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-10-01 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-01 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-10-04T10:01:46.000000Z","updated_at":"2025-10-05T10:01:17.000000Z","inspection_violations":[{"id":16180001,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036773","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"3922RG"},{"id":16180002,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036774","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"39330"},{"id":16180003,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036775","seq_no":"4","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"38323A2"},{"id":16180004,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036776","seq_no":"5","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"39141APC"},{"id":16180005,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036777","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"3939"},{"id":16180006,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036778","seq_no":"7","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"39021A"},{"id":16180007,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036779","seq_no":"8","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"39345B2UV"},{"id":16180008,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036780","seq_no":"9","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"3965B"},{"id":16180009,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036781","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209245463","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"39617C"},{"id":16180010,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036782","seq_no":"12","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"3922W"},{"id":16180011,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_violation_id":"269036783","seq_no":"13","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:00.000000Z","updated_at":"2025-10-05T10:16:55.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16295916,"change_date":"2025-10-01 21:40:00","inspection_id":"85930027","insp_unit_id":"209245463","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"999","insp_unit_license":"1N66684","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX04Y08M001763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:47:08.000000Z","updated_at":"2025-10-05T09:46:34.000000Z"}]},{"id":9719555,"change_date":"2025-09-18 21:43:00","inspection_id":"85804201","dot_number":"3481812","report_state":"TX","report_number":"78U89DCA8X","insp_date":"2025-09-16 00:00:00","insp_start_time":"0825","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9800  SOUTH FWY","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":"2025-09-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9698725","transaction_code":"C","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-09-17 21:41:00","snet_input_date":"2025-09-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-17 21:41:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-09-23T10:02:26.000000Z","updated_at":"2025-09-23T10:02:26.000000Z","inspection_violations":[{"id":15956826,"change_date":"2025-09-18 21:43:00","inspection_id":"85804201","insp_violation_id":"268790548","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"209031849","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:51.000000Z","updated_at":"2025-09-22T10:17:51.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":16094710,"change_date":"2025-09-18 21:43:00","inspection_id":"85804201","insp_unit_id":"209031849","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"XDD9279","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y56N009686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:57.000000Z","updated_at":"2025-09-22T09:46:26.000000Z"}]},{"id":9622605,"change_date":"2025-09-08 21:38:00","inspection_id":"85713320","dot_number":"3481812","report_state":"TX","report_number":"78IF9DCQ6G","insp_date":"2025-09-04 00:00:00","insp_start_time":"1520","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RG EXCOVOTIONS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9689110","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-09-08 21:38:00","snet_input_date":"2025-09-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-08 21:38:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-09-10T10:46:13.000000Z","updated_at":"2025-09-11T10:46:34.000000Z","inspection_violations":[{"id":15737057,"change_date":"2025-09-08 21:38:00","inspection_id":"85713320","insp_violation_id":"268527174","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"208805073","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:15.000000Z","updated_at":"2025-09-12T10:50:30.000000Z","normalized_code":"39355D1"},{"id":15737058,"change_date":"2025-09-08 21:38:00","inspection_id":"85713320","insp_violation_id":"268527175","seq_no":"2","part_no":"393","part_no_section":"75B","insp_viol_unit":"1","insp_unit_id":"208805073","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:15.000000Z","updated_at":"2025-09-12T10:50:30.000000Z","normalized_code":"39375B"},{"id":15737059,"change_date":"2025-09-08 21:38:00","inspection_id":"85713320","insp_violation_id":"268527176","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208805073","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:15.000000Z","updated_at":"2025-09-12T10:50:30.000000Z","normalized_code":"3939"},{"id":15737060,"change_date":"2025-09-08 21:38:00","inspection_id":"85713320","insp_violation_id":"268527177","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208805073","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:15.000000Z","updated_at":"2025-09-12T10:50:30.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":15894281,"change_date":"2025-09-08 21:38:00","inspection_id":"85713320","insp_unit_id":"208805073","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"15","insp_unit_license":"XDD9279","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y56N009686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:43.000000Z","updated_at":"2025-09-12T10:47:18.000000Z"}]},{"id":9451817,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","dot_number":"3481812","report_state":"TX","report_number":"V251941468","insp_date":"2025-08-14 00:00:00","insp_start_time":"0940","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 610","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR TRUCKING SERVICE","shipping_paper_number":"7111","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-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9670071","transaction_code":"A","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-08-23T10:46:35.000000Z","updated_at":"2025-08-23T10:46:35.000000Z","inspection_violations":[{"id":15393698,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_violation_id":"268123324","seq_no":"1","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"208474975","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:07.000000Z","updated_at":"2025-08-23T10:48:35.000000Z","normalized_code":"39355C1"},{"id":15393699,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_violation_id":"268123325","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208474975","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:07.000000Z","updated_at":"2025-08-23T10:48:36.000000Z","normalized_code":"39378"},{"id":15393700,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_violation_id":"268123326","seq_no":"3","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208474975","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:08.000000Z","updated_at":"2025-08-23T10:48:36.000000Z","normalized_code":"39383G"},{"id":15393701,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_violation_id":"268123327","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208474975","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:08.000000Z","updated_at":"2025-08-23T10:48:36.000000Z","normalized_code":"3939"},{"id":15393702,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_violation_id":"268123328","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208474975","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:08.000000Z","updated_at":"2025-08-23T10:48:36.000000Z","normalized_code":"3939"},{"id":15393703,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_violation_id":"268123329","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"208474975","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:08.000000Z","updated_at":"2025-08-23T10:48:36.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":15585656,"change_date":"2025-08-19 21:40:00","inspection_id":"85534115","insp_unit_id":"208474975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"007","insp_unit_license":"VMP4095","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HSDJSJR1EH032494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:43.000000Z","updated_at":"2025-08-23T09:46:14.000000Z"}]},{"id":9078440,"change_date":"2025-07-07 21:40:00","inspection_id":"85141380","dot_number":"3481812","report_state":"TX","report_number":"76QA9DCP4Q","insp_date":"2025-07-02 00:00:00","insp_start_time":"1053","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9626676","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-07-11T10:44:35.000000Z","updated_at":"2025-07-11T10:44:35.000000Z","inspection_violations":[{"id":14617639,"change_date":"2025-07-07 21:40:00","inspection_id":"85141380","insp_violation_id":"267240751","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207731661","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:42.000000Z","updated_at":"2025-07-11T10:46:08.000000Z","normalized_code":"3922RG"},{"id":14617640,"change_date":"2025-07-07 21:40:00","inspection_id":"85141380","insp_violation_id":"267240752","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"207731661","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:42.000000Z","updated_at":"2025-07-11T10:46:08.000000Z","normalized_code":"39311"},{"id":14617641,"change_date":"2025-07-07 21:40:00","inspection_id":"85141380","insp_violation_id":"267240753","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207731661","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:42.000000Z","updated_at":"2025-07-11T10:46:08.000000Z","normalized_code":"3939"},{"id":14617642,"change_date":"2025-07-07 21:40:00","inspection_id":"85141380","insp_violation_id":"267240754","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207731661","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:42.000000Z","updated_at":"2025-07-11T10:46:08.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14897772,"change_date":"2025-07-07 21:40:00","inspection_id":"85141380","insp_unit_id":"207731661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"007","insp_unit_license":"VMP4095","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HSDJSJR1EH032494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:25.000000Z","updated_at":"2025-07-11T09:45:58.000000Z"}]},{"id":9092582,"change_date":"2025-07-09 10:00:00","inspection_id":"85154524","dot_number":"3481812","report_state":"TX","report_number":"76PE9DBV5D","insp_date":"2025-07-01 00:00:00","insp_start_time":"1441","insp_end_time":"1454","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-09 08:53:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9629861","transaction_code":"C","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-07-09 08:53:00","snet_input_date":"2025-07-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-09 08:53:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-07-12T10:45:05.000000Z","updated_at":"2025-07-14T10:45:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14923560,"change_date":"2025-07-09 10:00:00","inspection_id":"85154524","insp_unit_id":"207760360","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"002","insp_unit_license":"VVP3535","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AW02Y0FM044457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:41.000000Z","updated_at":"2025-07-13T09:45:19.000000Z"}]},{"id":9015353,"change_date":"2025-06-27 21:39:00","inspection_id":"85074730","dot_number":"3481812","report_state":"TX","report_number":"76IA9DIA3N","insp_date":"2025-06-24 00:00:00","insp_start_time":"1030","insp_end_time":"1057","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5900  IRVINGTON BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOCAL CONSTRUCTION SITE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9619206","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-06-30T10:01:25.000000Z","updated_at":"2025-07-03T10:00:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14785875,"change_date":"2025-06-27 21:39:00","inspection_id":"85074730","insp_unit_id":"207610863","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"015","insp_unit_license":"XDD9279","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y56N009686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:39.000000Z","updated_at":"2025-07-01T09:49:55.000000Z"}]},{"id":8828563,"change_date":"2025-06-05 21:41:00","inspection_id":"84876976","dot_number":"3481812","report_state":"TX","report_number":"75DB9DBV38","insp_date":"2025-05-14 00:00:00","insp_start_time":"1101","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  TURNING BASIN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9599590","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-06-09T10:01:07.000000Z","updated_at":"2025-06-09T10:01:07.000000Z","inspection_violations":[{"id":14132618,"change_date":"2025-06-05 21:41:00","inspection_id":"84876976","insp_violation_id":"266689664","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207248770","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:18.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14454212,"change_date":"2025-06-05 21:41:00","inspection_id":"84876976","insp_unit_id":"207248770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"002","insp_unit_license":"VVP3535","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AW02Y0FM044457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:28.000000Z","updated_at":"2025-06-09T09:45:59.000000Z"}]},{"id":8559740,"change_date":"2025-05-06 21:40:00","inspection_id":"84593237","dot_number":"3481812","report_state":"TX","report_number":"74YC9DJM4I","insp_date":"2025-04-29 00:00:00","insp_start_time":"1242","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5200 W 34TH ST","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9569683","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-05-06 21:40:00","snet_input_date":"2025-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-05-09T10:26:08.000000Z","updated_at":"2025-05-10T10:52:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13922704,"change_date":"2025-05-06 21:40:00","inspection_id":"84593237","insp_unit_id":"206667328","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"23M095N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y56N009686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:15:14.000000Z","updated_at":"2025-05-10T10:03:34.000000Z"}]},{"id":7718731,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","dot_number":"3481812","report_state":"TX","report_number":"72A99DCAW1","insp_date":"2025-01-23 00:00:00","insp_start_time":"0957","insp_end_time":"1034","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3643 W 12TH ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9483047","transaction_code":"C","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:58:21.000000Z","updated_at":"2025-03-17T20:58:21.000000Z","inspection_violations":[{"id":12058938,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_violation_id":"264218684","seq_no":"1","part_no":"383","part_no_section":"25A1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"38325A1"},{"id":12058939,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_violation_id":"264218685","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205045143","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39378"},{"id":12058940,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_violation_id":"264218686","seq_no":"3","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"205045143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"999"},{"id":12058941,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_violation_id":"264218687","seq_no":"4","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"205045143","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39383G"},{"id":12058942,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_violation_id":"264218688","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205045143","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"3939TS"},{"id":12058943,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_violation_id":"264218689","seq_no":"6","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"205045143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":12455966,"change_date":"2025-01-28 21:39:00","inspection_id":"83708364","insp_unit_id":"205045143","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"TBW8301","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y63W151799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"}]},{"id":7546159,"change_date":"2025-01-03 21:39:00","inspection_id":"83527161","dot_number":"3481812","report_state":"TX","report_number":"71FC9DJM08","insp_date":"2024-12-23 00:00:00","insp_start_time":"1217","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6000  WESTVIEW DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"7658-44","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-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9464005","transaction_code":"A","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2025-01-03 21:39:00","snet_input_date":"2024-12-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:54:53.000000Z","updated_at":"2025-03-17T20:54:53.000000Z","inspection_violations":[{"id":11793853,"change_date":"2025-01-03 21:39:00","inspection_id":"83527161","insp_violation_id":"263751092","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"38323A2"},{"id":11793854,"change_date":"2025-01-03 21:39:00","inspection_id":"83527161","insp_violation_id":"263751093","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39141A"},{"id":11793855,"change_date":"2025-01-03 21:39:00","inspection_id":"83527161","insp_violation_id":"263751094","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204647345","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":12175234,"change_date":"2025-01-03 21:39:00","inspection_id":"83527161","insp_unit_id":"204647345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"011","insp_unit_license":"TLB3030","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3CV64AM90030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:26.000000Z","updated_at":"2025-03-17T23:49:26.000000Z"}]},{"id":7519957,"change_date":"2024-12-30 21:39:00","inspection_id":"83499705","dot_number":"3481812","report_state":"TX","report_number":"715D9DBVWY","insp_date":"2024-12-13 00:00:00","insp_start_time":"1309","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4500  DACOMA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9460523","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:52:44.000000Z","updated_at":"2025-03-17T20:52:44.000000Z","inspection_violations":[{"id":11752561,"change_date":"2024-12-30 21:39:00","inspection_id":"83499705","insp_violation_id":"263696122","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204594784","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":12132001,"change_date":"2024-12-30 21:39:00","inspection_id":"83499705","insp_unit_id":"204594784","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"VVP3535","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AW02Y0FM044457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"}]},{"id":7383268,"change_date":"2024-12-12 21:42:00","inspection_id":"83356197","dot_number":"3481812","report_state":"TX","report_number":"V241681480","insp_date":"2024-12-02 00:00:00","insp_start_time":"0945","insp_end_time":"1014","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14522  FM521","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR TRUCKING SERVICES","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9443849","transaction_code":"C","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-12-10 21:42:00","snet_input_date":"2024-12-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-10 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:50:16.000000Z","updated_at":"2025-03-17T20:50:16.000000Z","inspection_violations":[{"id":11534843,"change_date":"2024-12-12 21:42:00","inspection_id":"83356197","insp_violation_id":"263429010","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204354315","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11910286,"change_date":"2024-12-12 21:42:00","inspection_id":"83356197","insp_unit_id":"204354315","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STLG","insp_unit_company":"010","insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:32.000000Z","updated_at":"2025-03-17T23:46:32.000000Z"}]},{"id":7262133,"change_date":"2024-11-22 21:41:00","inspection_id":"83228465","dot_number":"3481812","report_state":"TX","report_number":"V241693645","insp_date":"2024-11-21 00:00:00","insp_start_time":"1020","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH288 SB AT CR101","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR TRUCKING SERVICE","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9434540","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":11354059,"change_date":"2024-11-22 21:41:00","inspection_id":"83228465","insp_violation_id":"263051421","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"204018062","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"393209D"},{"id":11354060,"change_date":"2024-11-22 21:41:00","inspection_id":"83228465","insp_violation_id":"263051422","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"204018062","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":11713945,"change_date":"2024-11-22 21:41:00","inspection_id":"83228465","insp_unit_id":"204018062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STLG","insp_unit_company":"010","insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":7278698,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","dot_number":"3481812","report_state":"TX","report_number":"70IF9DIAUE","insp_date":"2024-11-20 00:00:00","insp_start_time":"1510","insp_end_time":"1614","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9435345","transaction_code":"C","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-11-25 21:44:00","snet_input_date":"2024-11-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-25 21:44:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:47:46.000000Z","updated_at":"2025-03-17T20:47:46.000000Z","inspection_violations":[{"id":11376836,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","insp_violation_id":"263129331","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"38323A2"},{"id":11376837,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","insp_violation_id":"263129332","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39141A"},{"id":11376838,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","insp_violation_id":"263129333","seq_no":"3","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"204088929","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39355D1"},{"id":11376839,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","insp_violation_id":"263129334","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204088929","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39311"},{"id":11376840,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","insp_violation_id":"263129335","seq_no":"5","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"1","insp_unit_id":"204088929","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939BRKLAMP"}],"inspection_per_units":[{"id":11740613,"change_date":"2024-11-27 21:40:00","inspection_id":"83245970","insp_unit_id":"204088929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"004","insp_unit_license":"TGV0736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV43LL96750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":7073310,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","dot_number":"3481812","report_state":"TX","report_number":"6ZRF9DCOEE","insp_date":"2024-10-24 00:00:00","insp_start_time":"1517","insp_end_time":"1538","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  BRITTMOORE RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COOLEY","shipping_paper_number":"004","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-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9413659","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:43:27.000000Z","updated_at":"2025-03-17T20:43:27.000000Z","inspection_violations":[{"id":11041206,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617658","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"38323A2"},{"id":11041207,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617659","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39141A"},{"id":11041208,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617660","seq_no":"3","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"203641006","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39355D1"},{"id":11041209,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617661","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"203641006","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39360C"},{"id":11041210,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617662","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"203641006","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3939H"},{"id":11041211,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617663","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203641006","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39311"},{"id":11041212,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_violation_id":"262617664","seq_no":"7","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"203641006","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":11407546,"change_date":"2024-10-29 21:42:00","inspection_id":"83028594","insp_unit_id":"203641006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"004","insp_unit_license":"TGV0736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV43LL96750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":7329809,"change_date":"2024-12-03 21:40:00","inspection_id":"83299924","dot_number":"3481812","report_state":"TX","report_number":"6ZEF9DBVUH","insp_date":"2024-10-11 00:00:00","insp_start_time":"1551","insp_end_time":"1610","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  MANGUM RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9441534","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11460738,"change_date":"2024-12-03 21:40:00","inspection_id":"83299924","insp_violation_id":"263202572","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"38323A2"},{"id":11460739,"change_date":"2024-12-03 21:40:00","inspection_id":"83299924","insp_violation_id":"263202573","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39141A"},{"id":11460740,"change_date":"2024-12-03 21:40:00","inspection_id":"83299924","insp_violation_id":"263202574","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204156844","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11824282,"change_date":"2024-12-03 21:40:00","inspection_id":"83299924","insp_unit_id":"204156844","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"004","insp_unit_license":"TGV0736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV43LL96750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":6771288,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","dot_number":"3481812","report_state":"TX","report_number":"6YRC9DCRXY","insp_date":"2024-09-18 00:00:00","insp_start_time":"1238","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1100  SUE BARNETT DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LONESTAR DUMP TRUCK","shipping_paper_number":"61642","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":"50000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9381305","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":"03481812","upload_search_indicator":"M","census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[{"id":10545548,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","insp_violation_id":"261928476","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203033736","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39378"},{"id":10545549,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","insp_violation_id":"261928477","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"203033736","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39355D1"},{"id":10545550,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","insp_violation_id":"261928478","seq_no":"3","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:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"38323A2"},{"id":10545551,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","insp_violation_id":"261928479","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39141A"},{"id":10545552,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","insp_violation_id":"261928480","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203033736","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10919138,"change_date":"2024-09-19 21:42:00","inspection_id":"82707508","insp_unit_id":"203033736","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"011","insp_unit_license":"TLB3030","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3CV64AM90030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:06.000000Z","updated_at":"2025-03-17T23:36:06.000000Z"}]},{"id":7027283,"change_date":"2024-10-23 21:42:00","inspection_id":"82979866","dot_number":"3481812","report_state":"TX","report_number":"6YRB9DATAS","insp_date":"2024-09-18 00:00:00","insp_start_time":"1111","insp_end_time":"1126","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4800  SH 6","county_code_state":"TX","county_code":"157","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9409277","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"4405 TALINA WAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77041","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:42:38.000000Z","updated_at":"2025-03-17T20:42:38.000000Z","inspection_violations":[{"id":10968713,"change_date":"2024-10-23 21:42:00","inspection_id":"82979866","insp_violation_id":"262520130","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":11333633,"change_date":"2024-10-23 21:42:00","inspection_id":"82979866","insp_unit_id":"203551650","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSH5735","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV44PM54768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6371100,"change_date":"2024-08-01 21:41:00","inspection_id":"82280896","dot_number":"3481812","report_state":"TX","report_number":"6XC99DGP9P","insp_date":"2024-07-29 00:00:00","insp_start_time":"0946","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  SORTERS MCCLELL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9339192","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-07-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[{"id":9890944,"change_date":"2024-08-01 21:41:00","inspection_id":"82280896","insp_violation_id":"260973641","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202197137","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39360C"},{"id":9890945,"change_date":"2024-08-01 21:41:00","inspection_id":"82280896","insp_violation_id":"260973642","seq_no":"2","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"202197137","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":10266952,"change_date":"2024-08-01 21:41:00","inspection_id":"82280896","insp_unit_id":"202197137","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6104653,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","dot_number":"3481812","report_state":"TX","report_number":"6WDI9DJN67","insp_date":"2024-06-24 00:00:00","insp_start_time":"1822","insp_end_time":"1905","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6900 N SHEPHEARD DR","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":"2024-06-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9311992","transaction_code":"A","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-06-28 21:40:00","snet_input_date":"2024-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-28 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:23:45.000000Z","updated_at":"2025-03-17T20:23:45.000000Z","inspection_violations":[{"id":9475659,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_violation_id":"260377335","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"201648580","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"39375A1"},{"id":9475660,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_violation_id":"260377336","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201648580","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"39347E"},{"id":9475661,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_violation_id":"260377337","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201648580","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"39347E"},{"id":9475662,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_violation_id":"260377338","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201648580","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"39353B"},{"id":9475663,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_violation_id":"260377339","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201648580","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"3963A1"},{"id":9475664,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_violation_id":"260377340","seq_no":"6","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"201648580","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":9832659,"change_date":"2024-06-28 21:40:00","inspection_id":"81995133","insp_unit_id":"201648580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"SKW4599","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV34LL96997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":5931532,"change_date":"2024-06-06 21:41:00","inspection_id":"81808191","dot_number":"3481812","report_state":"TX","report_number":"6VLB9DJZKI","insp_date":"2024-05-27 00:00:00","insp_start_time":"1121","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  GRAND VILLAGE D","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR TRUCKING SERVICE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9293116","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9553866,"change_date":"2024-06-06 21:41:00","inspection_id":"81808191","insp_unit_id":"201272458","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5720221,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","dot_number":"3481812","report_state":"TX","report_number":"6V1C9DBA85","insp_date":"2024-05-07 00:00:00","insp_start_time":"1205","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12800  HOMESTEAD ROA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR TRUCKING SERVICE","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-05-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9270139","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-05-10 21:39:00","snet_input_date":"2024-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-10 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:16:15.000000Z","updated_at":"2025-03-17T20:16:15.000000Z","inspection_violations":[{"id":8850910,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","insp_violation_id":"259435227","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200833851","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3922"},{"id":8850911,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","insp_violation_id":"259435228","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200833851","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3963A1"},{"id":8850912,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","insp_violation_id":"259435229","seq_no":"3","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"200833851","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39355D1"},{"id":8850913,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","insp_violation_id":"259435230","seq_no":"4","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"200833851","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39351"},{"id":8850914,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","insp_violation_id":"259435231","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200833851","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9213306,"change_date":"2024-05-10 21:39:00","inspection_id":"81578810","insp_unit_id":"200833851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"SKW4599","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV34LL96997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"}]},{"id":5634139,"change_date":"2024-04-30 21:42:00","inspection_id":"81485299","dot_number":"3481812","report_state":"TX","report_number":"6UPE9DJVBF","insp_date":"2024-04-25 00:00:00","insp_start_time":"1404","insp_end_time":"1431","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN HARRIS CO. (492-528","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9259858","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-04-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8712129,"change_date":"2024-04-30 21:42:00","inspection_id":"81485299","insp_violation_id":"259229748","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200653683","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39378"},{"id":8712130,"change_date":"2024-04-30 21:42:00","inspection_id":"81485299","insp_violation_id":"259229749","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200653683","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9075328,"change_date":"2024-04-30 21:42:00","inspection_id":"81485299","insp_unit_id":"200653683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"SXY4215","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJF0CV57LW53225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"}]},{"id":5373113,"change_date":"2024-03-26 21:43:00","inspection_id":"81200300","dot_number":"3481812","report_state":"TX","report_number":"V241344810","insp_date":"2024-03-20 00:00:00","insp_start_time":"1003","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 45\/ LOUETTA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR TRUCKING SERVICE","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-03-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9232054","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-03-26 21:43:00","snet_input_date":"2024-03-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-26 21:43:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:09:05.000000Z","updated_at":"2025-03-17T20:09:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8653475,"change_date":"2024-03-26 21:43:00","inspection_id":"81200300","insp_unit_id":"200098134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"012","insp_unit_license":"SXY4215","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJF0CV57LW53225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:29.000000Z","updated_at":"2025-03-17T23:13:29.000000Z"}]},{"id":5260358,"change_date":"2024-03-11 21:44:00","inspection_id":"81077489","dot_number":"3481812","report_state":"TX","report_number":"6T3E9DJNZR","insp_date":"2024-02-27 00:00:00","insp_start_time":"1354","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5700 W GULF BANK RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9219138","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:07:02.000000Z","updated_at":"2025-03-17T20:07:02.000000Z","inspection_violations":[{"id":8111464,"change_date":"2024-03-11 21:44:00","inspection_id":"81077489","insp_violation_id":"258320257","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199857195","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8470812,"change_date":"2024-03-11 21:44:00","inspection_id":"81077489","insp_unit_id":"199857195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STEM","insp_unit_company":"010","insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:47.000000Z","updated_at":"2025-03-17T23:11:47.000000Z"}]},{"id":5155485,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","dot_number":"3481812","report_state":"TX","report_number":"6SWD9DBGM5","insp_date":"2024-02-20 00:00:00","insp_start_time":"1340","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11702  CYPRESS N HOU","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WM TRUCKING","shipping_paper_number":"337953","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9209533","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[{"id":7952319,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_violation_id":"258090564","seq_no":"1","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"199644926","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39355C2"},{"id":7952320,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_violation_id":"258090565","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199644926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7952321,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_violation_id":"258090566","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199644926","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39360C"},{"id":7952322,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_violation_id":"258090567","seq_no":"4","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"199644926","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393203"},{"id":7952323,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_violation_id":"258090568","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199644926","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3965B"},{"id":7952324,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_violation_id":"258090569","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199644926","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":8301207,"change_date":"2024-02-28 21:42:00","inspection_id":"80963271","insp_unit_id":"199644926","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"SKW4599","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CV34LL96997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:14.000000Z","updated_at":"2025-03-17T23:10:14.000000Z"}]},{"id":4886515,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","dot_number":"3481812","report_state":"TX","report_number":"6RYE9DCEIW","insp_date":"2024-01-17 00:00:00","insp_start_time":"1434","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7300  DENNY ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALL GOOD CONSTRUCTION","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9178898","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2024-01-23 21:45:00","snet_input_date":"2024-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T19:59:36.000000Z","updated_at":"2025-03-17T19:59:36.000000Z","inspection_violations":[{"id":7529205,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","insp_violation_id":"257459284","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"39141A"},{"id":7529206,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","insp_violation_id":"257459285","seq_no":"2","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:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"38323A2"},{"id":7529207,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","insp_violation_id":"257459286","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199075670","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"39378"},{"id":7529208,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","insp_violation_id":"257459287","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199075670","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"3939A"},{"id":7529209,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","insp_violation_id":"257459288","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199075670","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7862500,"change_date":"2024-01-23 21:45:00","inspection_id":"80669211","insp_unit_id":"199075670","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"010","insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:16.000000Z","updated_at":"2025-03-17T23:06:16.000000Z"}]},{"id":3994708,"change_date":"2023-09-18 21:39:00","inspection_id":"79686991","dot_number":"3481812","report_state":"TX","report_number":"6OEF9DCP65","insp_date":"2023-09-11 00:00:00","insp_start_time":"1509","insp_end_time":"1525","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7500  EASTEX FWY EAS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9076943","transaction_code":"A","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2023-09-18 21:39:00","snet_input_date":"2023-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-18 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T19:41:39.000000Z","updated_at":"2025-03-17T19:41:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6423677,"change_date":"2023-09-18 21:39:00","inspection_id":"79686991","insp_unit_id":"197105236","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STER","insp_unit_company":null,"insp_unit_license":"PSX5845","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FWJA3AS44AM92514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:56.000000Z","updated_at":"2025-03-17T22:53:56.000000Z"}]},{"id":4344380,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","dot_number":"3481812","report_state":"TX","report_number":"6O8C9DAXSG","insp_date":"2023-09-05 00:00:00","insp_start_time":"1205","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0249 IN HARRIS CO. (450-470","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLEN TROUT","shipping_paper_number":"091530","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-11-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"15","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"14","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9116228","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T19:49:05.000000Z","updated_at":"2025-03-17T19:49:05.000000Z","inspection_violations":[{"id":6720997,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196944","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:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"38323A2"},{"id":6720998,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196945","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"3922"},{"id":6720999,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196946","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"3939A"},{"id":6721000,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196947","seq_no":"4","part_no":"393","part_no_section":"26","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39326"},{"id":6721001,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196948","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39378"},{"id":6721002,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196949","seq_no":"6","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"393203A"},{"id":6721003,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196950","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39395A"},{"id":6721004,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196951","seq_no":"8","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"393203"},{"id":6721005,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196952","seq_no":"9","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39311"},{"id":6721006,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196953","seq_no":"10","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39345B2"},{"id":6721007,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196954","seq_no":"12","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"3965B"},{"id":6721008,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196955","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"3963A1"},{"id":6721009,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196956","seq_no":"14","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39375B"},{"id":6721010,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196957","seq_no":"15","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"393209E"},{"id":6721011,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_violation_id":"256196958","seq_no":"16","part_no":"393","part_no_section":"209(b)","insp_viol_unit":"1","insp_unit_id":"197885841","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"393209B"}],"inspection_per_units":[{"id":6987015,"change_date":"2023-11-02 21:42:00","inspection_id":"80074248","insp_unit_id":"197885841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"901","insp_unit_license":"RRG8075","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X2YJ839430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:39.000000Z","updated_at":"2025-03-17T22:58:39.000000Z"}]},{"id":2957690,"change_date":"2023-05-03 21:42:00","inspection_id":"78522684","dot_number":"3481812","report_state":"TX","report_number":"6KN69DJV7V","insp_date":"2023-04-29 00:00:00","insp_start_time":"0713","insp_end_time":"0743","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GREENS RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8969327","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2023-05-03 21:42:00","snet_input_date":"2023-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[{"id":4541004,"change_date":"2023-05-03 21:42:00","inspection_id":"78522684","insp_violation_id":"252605740","seq_no":"2","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"194733799","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39351"},{"id":4541005,"change_date":"2023-05-03 21:42:00","inspection_id":"78522684","insp_violation_id":"252605741","seq_no":"3","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"194733799","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3929A2"},{"id":4541006,"change_date":"2023-05-03 21:42:00","inspection_id":"78522684","insp_violation_id":"252605742","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194733799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4759432,"change_date":"2023-05-03 21:42:00","inspection_id":"78522684","insp_unit_id":"194733799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"900","insp_unit_license":"RGR5441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X9XR819693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"}]},{"id":2889201,"change_date":"2023-12-18 21:42:00","inspection_id":"78445393","dot_number":"3481812","report_state":"TX","report_number":"V231011091","insp_date":"2023-04-20 00:00:00","insp_start_time":"1100","insp_end_time":"1133","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL 336 N @ 3083","county_code_state":"TX","county_code":"339","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","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-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8963561","transaction_code":"C","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[{"id":4434754,"change_date":"2023-12-18 21:42:00","inspection_id":"78445393","insp_violation_id":"256947622","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:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":4648914,"change_date":"2023-12-18 21:42:00","inspection_id":"78445393","insp_unit_id":"198561119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"12","insp_unit_license":"RVC9146","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y5YW126775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":2889820,"change_date":"2023-12-18 21:42:00","inspection_id":"78446077","dot_number":"3481812","report_state":"TX","report_number":"V231011089","insp_date":"2023-04-20 00:00:00","insp_start_time":"0825","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL 336 N AT FM 3083","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A QUALITY","shipping_paper_number":"8371","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-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8964283","transaction_code":"C","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[{"id":4436535,"change_date":"2023-12-18 21:42:00","inspection_id":"78446077","insp_violation_id":"256947619","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:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"38323A2"},{"id":4436536,"change_date":"2023-12-18 21:42:00","inspection_id":"78446077","insp_violation_id":"256947620","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198561118","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3965B"},{"id":4436537,"change_date":"2023-12-18 21:42:00","inspection_id":"78446077","insp_violation_id":"256947621","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4649987,"change_date":"2023-12-18 21:42:00","inspection_id":"78446077","insp_unit_id":"198561118","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"12","insp_unit_license":"RVC9146","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y5YW126775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":1049401,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","dot_number":"3481812","report_state":"TX","report_number":"6DIE9DJN5P","insp_date":"2022-08-15 00:00:00","insp_start_time":"1415","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6600  LONG POINT RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8745351","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T18:46:11.000000Z","updated_at":"2025-03-17T18:46:11.000000Z","inspection_violations":[{"id":1654104,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","insp_violation_id":"247751951","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190339749","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39395A"},{"id":1654105,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","insp_violation_id":"247751952","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190339749","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"3939A"},{"id":1654106,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","insp_violation_id":"247751953","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"190339749","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39319"},{"id":1654107,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","insp_violation_id":"247751954","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190339749","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"3939A"},{"id":1654108,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","insp_violation_id":"247751955","seq_no":"5","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":"99","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":1688751,"change_date":"2022-08-16 21:39:00","inspection_id":"76334901","insp_unit_id":"190339749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"901","insp_unit_license":"RRG8075","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X2YJ839430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":1010247,"change_date":"2022-08-10 21:39:00","inspection_id":"76289460","dot_number":"3481812","report_state":"TX","report_number":"6CR99DNAKN","insp_date":"2022-07-19 00:00:00","insp_start_time":"0845","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5900  MORTON RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"POWELL CONST","shipping_paper_number":"6098-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8738506","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03481812","upload_search_indicator":"M","census_search_date":"2022-08-10 21:39:00","snet_input_date":"2022-07-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"ANGEL ERNESTO AGUIRRE OLIVO","insp_carrier_street":"11735 GLEN DR APT 617","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77099","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0999202","created_at":"2025-03-17T18:45:26.000000Z","updated_at":"2025-03-17T18:45:26.000000Z","inspection_violations":[{"id":1590568,"change_date":"2022-08-10 21:39:00","inspection_id":"76289460","insp_violation_id":"247638520","seq_no":"2","part_no":"391","part_no_section":"49(j)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39149J"},{"id":1590569,"change_date":"2022-08-10 21:39:00","inspection_id":"76289460","insp_violation_id":"247638521","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190244542","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1625351,"change_date":"2022-08-10 21:39:00","inspection_id":"76289460","insp_unit_id":"190244542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"900","insp_unit_license":"RGR5441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X9XR819693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3481812\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3481812\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3481812\/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\/3481812\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}