{"current_page":1,"data":[{"id":12798463,"change_date":"2026-08-23 21:38:00","inspection_id":"88772937","dot_number":"1937602","report_state":"TX","report_number":"7I8B9DHP5D","insp_date":"2026-08-20 00:00:00","insp_start_time":"1013","insp_end_time":"1024","registration_date":null,"region":"CS","ci_status_code":"C","location":"R","location_desc":"TX","county_code_state":"TX","county_code":"167","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":"U","pen_cen_match":"I","final_status_date":"2026-08-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"4059634","transaction_code":"A","transaction_date":"2026-08-23 00:00:00","upload_date":"2026-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":null,"census_search_date":"2026-08-23 21:38:00","snet_input_date":"2026-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-23 21:38:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"\\S908 YAUPON AV\\S","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-26T09:38:11.000000Z","updated_at":"2026-09-02T09:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22212744,"change_date":"2026-08-23 21:38:00","inspection_id":"88772937","insp_unit_id":"215299547","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"YHD2013","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-26T09:14:48.000000Z","updated_at":"2026-09-02T09:02:36.000000Z"}]},{"id":12501582,"change_date":"2026-07-20 21:40:00","inspection_id":"88465411","dot_number":"1937602","report_state":"TX","report_number":"7H3A9DGRQ7","insp_date":"2026-07-10 00:00:00","insp_start_time":"1018","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7200  CLINTON DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MC2","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":"2026-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"10035716","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2026-07-20 21:40:00","snet_input_date":"2026-07-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-20 21:40:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2026-07-23T09:41:20.000000Z","updated_at":"2026-07-31T09:31:15.000000Z","inspection_violations":[{"id":21762310,"change_date":"2026-07-20 21:40:00","inspection_id":"88465411","insp_violation_id":"275620725","seq_no":"2","part_no":"393","part_no_section":"11LR","insp_viol_unit":"1","insp_unit_id":"214721825","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:46.000000Z","updated_at":"2026-07-31T09:43:49.000000Z","normalized_code":"39311LR"}],"inspection_per_units":[{"id":21711821,"change_date":"2026-07-20 21:40:00","inspection_id":"88465411","insp_unit_id":"214721825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:18:05.000000Z","updated_at":"2026-07-31T09:02:48.000000Z"}]},{"id":11095398,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","dot_number":"1937602","report_state":"TX","report_number":"7CT89DNOHX","insp_date":"2026-02-06 00:00:00","insp_start_time":"0826","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","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":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9844579","transaction_code":"C","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2026-02-13T10:37:53.000000Z","updated_at":"2026-02-22T10:30:48.000000Z","inspection_violations":[{"id":18597237,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","insp_violation_id":"271740316","seq_no":"1","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"211571077","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:19.000000Z","updated_at":"2026-02-22T10:39:31.000000Z","normalized_code":"393201D"},{"id":18597238,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","insp_violation_id":"271740317","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211571077","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:19.000000Z","updated_at":"2026-02-22T10:39:31.000000Z","normalized_code":"3939"},{"id":18597239,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","insp_violation_id":"271740318","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"211571077","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:19.000000Z","updated_at":"2026-02-22T10:39:31.000000Z","normalized_code":"39378"},{"id":18597240,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","insp_violation_id":"271740319","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211571077","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:19.000000Z","updated_at":"2026-02-22T10:39:31.000000Z","normalized_code":"3922RG"},{"id":18597241,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","insp_violation_id":"271740320","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"211571077","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-02-14T10:52:19.000000Z","updated_at":"2026-02-22T10:39:31.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":18939854,"change_date":"2026-02-11 21:39:00","inspection_id":"87007233","insp_unit_id":"211571077","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:34.000000Z","updated_at":"2026-02-22T10:03:14.000000Z"}]},{"id":11151454,"change_date":"2026-02-17 21:39:00","inspection_id":"87066102","dot_number":"1937602","report_state":"TX","report_number":"7CTC9DVC0J","insp_date":"2026-02-06 00:00:00","insp_start_time":"1320","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","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":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9850912","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2026-02-20T10:37:51.000000Z","updated_at":"2026-02-28T10:30:57.000000Z","inspection_violations":[{"id":18686376,"change_date":"2026-02-17 21:39:00","inspection_id":"87066102","insp_violation_id":"271847659","seq_no":"1","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"211666952","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:50.000000Z","updated_at":"2026-02-28T10:41:28.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":19024632,"change_date":"2026-02-17 21:39:00","inspection_id":"87066102","insp_unit_id":"211666952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:32.000000Z","updated_at":"2026-02-28T10:03:57.000000Z"}]},{"id":10814607,"change_date":"2026-01-20 21:40:00","inspection_id":"86841880","dot_number":"1937602","report_state":"TX","report_number":"7C5A9DUW23","insp_date":"2026-01-13 00:00:00","insp_start_time":"1007","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0003 IN GALVESTON CO. (492-","county_code_state":"TX","county_code":"167","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":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9821679","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2026-01-20 21:40:00","snet_input_date":"2026-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2026-01-23T10:36:28.000000Z","updated_at":"2026-01-31T10:30:58.000000Z","inspection_violations":[{"id":18078900,"change_date":"2026-01-20 21:40:00","inspection_id":"86841880","insp_violation_id":"271316548","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"211189026","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:49.000000Z","updated_at":"2026-01-31T10:38:28.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":18161342,"change_date":"2026-01-20 21:40:00","inspection_id":"86841880","insp_unit_id":"211189026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-400","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:24.000000Z","updated_at":"2026-01-31T10:03:32.000000Z"}]},{"id":9548315,"change_date":"2025-08-29 21:41:00","inspection_id":"85635859","dot_number":"1937602","report_state":"TX","report_number":"789G9DJW18","insp_date":"2025-08-26 00:00:00","insp_start_time":"1610","insp_end_time":"1631","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","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-08-29 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":"9680378","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-08-29 21:41:00","snet_input_date":"2025-08-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-29 21:41:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-09-06T10:42:35.000000Z","updated_at":"2025-09-06T10:42:35.000000Z","inspection_violations":[{"id":15589687,"change_date":"2025-08-29 21:41:00","inspection_id":"85635859","insp_violation_id":"268352348","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208663939","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:26.000000Z","updated_at":"2025-09-06T10:46:26.000000Z","normalized_code":"39378"},{"id":15589688,"change_date":"2025-08-29 21:41:00","inspection_id":"85635859","insp_violation_id":"268352349","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208663939","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-06T10:46:26.000000Z","updated_at":"2025-09-06T10:46:26.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15760078,"change_date":"2025-08-29 21:41:00","inspection_id":"85635859","insp_unit_id":"208663939","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:55.000000Z","updated_at":"2025-09-09T09:46:55.000000Z"}]},{"id":9440805,"change_date":"2025-08-18 21:39:00","inspection_id":"85522565","dot_number":"1937602","report_state":"TX","report_number":"V251966764","insp_date":"2025-08-14 00:00:00","insp_start_time":"1014","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8006  C E KING PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TX MATERIAL","shipping_paper_number":"3890-21","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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9668474","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-08-23T10:46:02.000000Z","updated_at":"2025-08-23T10:46:02.000000Z","inspection_violations":[{"id":15369538,"change_date":"2025-08-18 21:39:00","inspection_id":"85522565","insp_violation_id":"268096507","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"208453530","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-08-21T10:42:36.000000Z","updated_at":"2025-08-22T10:44:12.000000Z","normalized_code":"393209D"},{"id":15369539,"change_date":"2025-08-18 21:39:00","inspection_id":"85522565","insp_violation_id":"268096508","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208453530","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:36.000000Z","updated_at":"2025-08-22T10:44:12.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15565612,"change_date":"2025-08-18 21:39:00","inspection_id":"85522565","insp_unit_id":"208453530","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:47.000000Z","updated_at":"2025-08-22T09:46:10.000000Z"}]},{"id":9440806,"change_date":"2025-08-18 21:39:00","inspection_id":"85522566","dot_number":"1937602","report_state":"TX","report_number":"V251966765","insp_date":"2025-08-14 00:00:00","insp_start_time":"1113","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12818  TIDWELL RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","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-08-18 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":"9668483","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"EDUARDO GUZMAN RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-08-23T10:46:02.000000Z","updated_at":"2025-08-23T10:46:02.000000Z","inspection_violations":[{"id":15369540,"change_date":"2025-08-18 21:39:00","inspection_id":"85522566","insp_violation_id":"268096509","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208453531","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:36.000000Z","updated_at":"2025-08-22T10:44:12.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":15565613,"change_date":"2025-08-18 21:39:00","inspection_id":"85522566","insp_unit_id":"208453531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:47.000000Z","updated_at":"2025-08-22T09:46:10.000000Z"}]},{"id":8258273,"change_date":"2025-03-31 21:41:00","inspection_id":"84275682","dot_number":"1937602","report_state":"TX","report_number":"V251804672","insp_date":"2025-03-28 00:00:00","insp_start_time":"1117","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5102  SPENCER HWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","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-03-31 21:41: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":"9537274","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-03-31 21:41:00","snet_input_date":"2025-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-31 21:41:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-04-03T10:04:38.000000Z","updated_at":"2025-04-04T10:20:05.000000Z","inspection_violations":[{"id":12972175,"change_date":"2025-03-31 21:41:00","inspection_id":"84275682","insp_violation_id":"265361391","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"206085801","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:30:38.000000Z","updated_at":"2025-04-04T10:44:01.000000Z","normalized_code":"39383G"},{"id":12972176,"change_date":"2025-03-31 21:41:00","inspection_id":"84275682","insp_violation_id":"265361392","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206085801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:30:38.000000Z","updated_at":"2025-04-04T10:44:01.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13364366,"change_date":"2025-03-31 21:41:00","inspection_id":"84275682","insp_unit_id":"206085801","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T10:01:14.000000Z","updated_at":"2025-04-04T10:03:47.000000Z"}]},{"id":8257564,"change_date":"2025-03-31 21:41:00","inspection_id":"84274928","dot_number":"1937602","report_state":"TX","report_number":"73OC9DNH6N","insp_date":"2025-03-14 00:00:00","insp_start_time":"1216","insp_end_time":"1242","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYPORT TERMINAL","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-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9536180","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-03-31 21:41:00","snet_input_date":"2025-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-31 21:41:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-04-03T10:04:33.000000Z","updated_at":"2025-04-04T10:19:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13363218,"change_date":"2025-03-31 21:41:00","inspection_id":"84274928","insp_unit_id":"206084455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:59:52.000000Z","updated_at":"2025-04-04T10:02:38.000000Z"}]},{"id":8138122,"change_date":"2025-03-17 21:41:00","inspection_id":"84149366","dot_number":"1937602","report_state":"TX","report_number":"V251804630","insp_date":"2025-03-08 00:00:00","insp_start_time":"0829","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB AT EXIT 30","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","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-03-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":"9524857","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-03-17 21:41:00","snet_input_date":"2025-03-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-17 21:41:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-21T10:24:13.000000Z","updated_at":"2025-03-21T10:24:13.000000Z","inspection_violations":[{"id":12732216,"change_date":"2025-03-17 21:41:00","inspection_id":"84149366","insp_violation_id":"265088763","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"205844366","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:48:59.000000Z","updated_at":"2025-03-21T10:58:19.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":13142279,"change_date":"2025-03-17 21:41:00","inspection_id":"84149366","insp_unit_id":"205844366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:58:11.000000Z","updated_at":"2025-03-21T10:09:06.000000Z"}]},{"id":8138152,"change_date":"2025-03-17 21:41:00","inspection_id":"84149396","dot_number":"1937602","report_state":"TX","report_number":"V251804634","insp_date":"2025-03-08 00:00:00","insp_start_time":"1031","insp_end_time":"1106","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5810 SAM HOUSTON TLW","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","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-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48900","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":"9524859","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-03-17 21:41:00","snet_input_date":"2025-03-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-17 21:41:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-21T10:24:14.000000Z","updated_at":"2025-03-21T10:24:14.000000Z","inspection_violations":[{"id":12732322,"change_date":"2025-03-17 21:41:00","inspection_id":"84149396","insp_violation_id":"265088876","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205844423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:48:59.000000Z","updated_at":"2025-03-21T10:58:21.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13142333,"change_date":"2025-03-17 21:41:00","inspection_id":"84149396","insp_unit_id":"205844423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:58:28.000000Z","updated_at":"2025-03-21T10:09:24.000000Z"}]},{"id":7719896,"change_date":"2025-01-27 21:40:00","inspection_id":"83709583","dot_number":"1937602","report_state":"TX","report_number":"V251758196","insp_date":"2025-01-18 00:00:00","insp_start_time":"0904","insp_end_time":"0949","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM521 NB AT FELLOWS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRING AND SAND","shipping_paper_number":"70171703","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48900","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":"9484118","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T20:58:21.000000Z","updated_at":"2025-03-17T20:58:21.000000Z","inspection_violations":[{"id":12062628,"change_date":"2025-01-27 21:40:00","inspection_id":"83709583","insp_violation_id":"264200050","seq_no":"1","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"205028534","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39375GLOAD"},{"id":12062629,"change_date":"2025-01-27 21:40:00","inspection_id":"83709583","insp_violation_id":"264200051","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"205028534","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3922W"},{"id":12062630,"change_date":"2025-01-27 21:40:00","inspection_id":"83709583","insp_violation_id":"264200052","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"205028534","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12458020,"change_date":"2025-01-27 21:40:00","inspection_id":"83709583","insp_unit_id":"205028534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","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":7673343,"change_date":"2025-01-21 21:40:00","inspection_id":"83660865","dot_number":"1937602","report_state":"TX","report_number":"721F9DJW0N","insp_date":"2025-01-14 00:00:00","insp_start_time":"1544","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":"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-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48900","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":"9477330","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11988818,"change_date":"2025-01-21 21:40:00","inspection_id":"83660865","insp_violation_id":"264103260","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204937694","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39347E"},{"id":11988819,"change_date":"2025-01-21 21:40:00","inspection_id":"83660865","insp_violation_id":"264103261","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204937694","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39353B"},{"id":11988820,"change_date":"2025-01-21 21:40:00","inspection_id":"83660865","insp_violation_id":"264103262","seq_no":"4","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204937694","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":12381905,"change_date":"2025-01-21 21:40:00","inspection_id":"83660865","insp_unit_id":"204937694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7096268,"change_date":"2024-10-31 21:43:00","inspection_id":"83052941","dot_number":"1937602","report_state":"TX","report_number":"6ZQ89DBQ8M","insp_date":"2024-10-23 00:00:00","insp_start_time":"0813","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1900  PEARLAND PKWY","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MCCARTY","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-10-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9415459","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2024-10-31 21:43:00","snet_input_date":"2024-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-31 21:43:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T20:43:54.000000Z","updated_at":"2025-03-17T20:43:54.000000Z","inspection_violations":[{"id":11080740,"change_date":"2024-10-31 21:43:00","inspection_id":"83052941","insp_violation_id":"262671994","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"203687008","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11445026,"change_date":"2024-10-31 21:43:00","inspection_id":"83052941","insp_unit_id":"203687008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:33.000000Z","updated_at":"2025-03-17T23:41:33.000000Z"}]},{"id":6819938,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","dot_number":"1937602","report_state":"TX","report_number":"6YSF9DIAQW","insp_date":"2024-09-19 00:00:00","insp_start_time":"1509","insp_end_time":"1540","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED","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-09-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9385993","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2024-09-25 21:42:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-25 21:42:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10621097,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","insp_violation_id":"262035715","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203131468","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3922"},{"id":10621098,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","insp_violation_id":"262035716","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203131468","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39378"},{"id":10621099,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","insp_violation_id":"262035717","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203131468","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3939A"},{"id":10621100,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","insp_violation_id":"262035718","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203131468","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39617C"},{"id":10621101,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","insp_violation_id":"262035719","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203131468","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10997897,"change_date":"2024-09-25 21:42:00","inspection_id":"82759547","insp_unit_id":"203131468","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":4715979,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","dot_number":"1937602","report_state":"TX","report_number":"V231271923","insp_date":"2023-12-22 00:00:00","insp_start_time":"0541","insp_end_time":"0604","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB @ FM 518","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EDDY'S TRUCKING","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":"2023-12-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9157186","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2023-12-27 21:43:00","snet_input_date":"2023-12-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-27 21:43:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T19:56:12.000000Z","updated_at":"2025-03-17T19:56:12.000000Z","inspection_violations":[{"id":7284921,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","insp_violation_id":"263243082","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"204190649","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"39375A3"},{"id":7284922,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","insp_violation_id":"263243083","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204190649","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"39378"},{"id":7284923,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","insp_violation_id":"263243084","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204190649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"3939"},{"id":7284924,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","insp_violation_id":"263243085","seq_no":"4","part_no":"396","part_no_section":"3A1-FA","insp_viol_unit":"1","insp_unit_id":"204190649","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"3963A1FA"},{"id":7284925,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","insp_violation_id":"263243086","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204190649","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":7585665,"change_date":"2024-12-04 21:42:00","inspection_id":"80482841","insp_unit_id":"204190649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:50.000000Z","updated_at":"2025-03-17T23:03:50.000000Z"}]},{"id":4365178,"change_date":"2023-11-06 21:42:00","inspection_id":"80097135","dot_number":"1937602","report_state":"TX","report_number":"6PUD9DCOVQ","insp_date":"2023-11-02 00:00:00","insp_start_time":"1328","insp_end_time":"1345","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VAUGHN CO","shipping_paper_number":"701","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-06 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":"9118166","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-11-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T19:49:30.000000Z","updated_at":"2025-03-17T19:49:30.000000Z","inspection_violations":[{"id":6753726,"change_date":"2023-11-06 21:42:00","inspection_id":"80097135","insp_violation_id":"256246079","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"197930332","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345"},{"id":6753727,"change_date":"2023-11-06 21:42:00","inspection_id":"80097135","insp_violation_id":"256246080","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197930332","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3939A"},{"id":6753728,"change_date":"2023-11-06 21:42:00","inspection_id":"80097135","insp_violation_id":"256246081","seq_no":"3","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"197930332","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":7020779,"change_date":"2023-11-06 21:42:00","inspection_id":"80097135","insp_unit_id":"197930332","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"}]},{"id":4376046,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","dot_number":"1937602","report_state":"TX","report_number":"6PUA9DBTVZ","insp_date":"2023-11-02 00:00:00","insp_start_time":"1019","insp_end_time":"1054","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-07 21:41: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":"9119330","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2023-11-07 21:41:00","snet_input_date":"2023-11-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-07 21:41:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T19:49:34.000000Z","updated_at":"2025-03-17T19:49:34.000000Z","inspection_violations":[{"id":6769466,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","insp_violation_id":"256271658","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197953661","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39347E"},{"id":6769467,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","insp_violation_id":"256271659","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197953661","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39347E"},{"id":6769468,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","insp_violation_id":"256271660","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197953661","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39353B"},{"id":6769469,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","insp_violation_id":"256271661","seq_no":"4","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"197953661","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"393201A"},{"id":6769470,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","insp_violation_id":"256271662","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197953661","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7038050,"change_date":"2023-11-07 21:41:00","inspection_id":"80109539","insp_unit_id":"197953661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:04.000000Z","updated_at":"2025-03-17T22:59:04.000000Z"}]},{"id":1441180,"change_date":"2022-10-10 21:34:00","inspection_id":"76790278","dot_number":"1937602","report_state":"TX","report_number":"6ERE9DJM6O","insp_date":"2022-09-29 00:00:00","insp_start_time":"1435","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6200  JOYNER","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-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8789865","transaction_code":"C","transaction_date":"2022-10-10 00:00:00","upload_date":"2022-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2022-10-04 21:41:00","snet_input_date":"2022-09-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T18:53:23.000000Z","updated_at":"2025-03-17T18:53:23.000000Z","inspection_violations":[{"id":2271227,"change_date":"2022-10-10 21:34:00","inspection_id":"76790278","insp_violation_id":"248918322","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:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"38323A2"},{"id":2271228,"change_date":"2022-10-10 21:34:00","inspection_id":"76790278","insp_violation_id":"248918323","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191347886","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"3965B"},{"id":2271229,"change_date":"2022-10-10 21:34:00","inspection_id":"76790278","insp_violation_id":"248918324","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"1","insp_unit_id":"191347886","insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":2320198,"change_date":"2022-10-10 21:34:00","inspection_id":"76790278","insp_unit_id":"191347886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"701","insp_unit_license":"DCR0296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X01J878772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"}]},{"id":450501,"change_date":"2022-05-26 21:43:00","inspection_id":"75630042","dot_number":"1937602","report_state":"TX","report_number":"6B0A0XMNXG","insp_date":"2022-05-17 00:00:00","insp_start_time":"1014","insp_end_time":"1034","registration_date":"2022-05-26 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN BRAZORIA CO. (486-5","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FRANCO","shipping_paper_number":"138148","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8661419","transaction_code":"C","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01937602","upload_search_indicator":"M","census_search_date":"2022-05-20 21:42:00","snet_input_date":"2022-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-20 21:42:00","insp_carrier_name":"EDUARDO RODRIGUEZ","insp_carrier_street":"908 YAUPON AVE","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77506","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0224907","created_at":"2025-03-17T18:35:38.000000Z","updated_at":"2025-03-17T18:35:38.000000Z","inspection_violations":[{"id":714406,"change_date":"2022-05-26 21:43:00","inspection_id":"75630042","insp_violation_id":"246110912","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188940953","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":726316,"change_date":"2022-05-26 21:43:00","inspection_id":"75630042","insp_unit_id":"188940953","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"703","insp_unit_license":"FWG2672","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J102400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:40.000000Z","updated_at":"2025-03-17T22:12:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1937602\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1937602\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1937602\/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\/1937602\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}