{"current_page":1,"data":[{"id":9808922,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","dot_number":"1943517","report_state":"TX","report_number":"793E9DBH5V","insp_date":"2025-09-25 00:00:00","insp_start_time":"1408","insp_end_time":"1438","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIED CONCRETE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9708788","transaction_code":"C","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":null,"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-09-29 21:39:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-10-02T10:00:25.000000Z","updated_at":"2025-10-05T10:01:12.000000Z","inspection_violations":[{"id":16177634,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035151","seq_no":"1","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"209244642","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:39.000000Z","normalized_code":"39345B2PC"},{"id":16177635,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035152","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209244642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:39.000000Z","normalized_code":"3939"},{"id":16177636,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035153","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"209244642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:39.000000Z","normalized_code":"3939TS"},{"id":16177637,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035154","seq_no":"4","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209244643","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:39.000000Z","normalized_code":"39355E"},{"id":16177638,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035155","seq_no":"5","part_no":"393","part_no_section":"11LR","insp_viol_unit":"1","insp_unit_id":"209244642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:39.000000Z","normalized_code":"39311LR"},{"id":16177639,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035156","seq_no":"6","part_no":"393","part_no_section":"50D","insp_viol_unit":"1","insp_unit_id":"209244642","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:40.000000Z","normalized_code":"39350D"},{"id":16177640,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_violation_id":"269035157","seq_no":"7","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209244642","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:57.000000Z","updated_at":"2025-10-05T10:16:40.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":16294643,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_unit_id":"209244642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"1M19260","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X9AJ271622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:47:08.000000Z","updated_at":"2025-10-05T09:46:27.000000Z"},{"id":16294644,"change_date":"2025-10-01 21:40:00","inspection_id":"85908819","insp_unit_id":"209244643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"T259","insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:47:08.000000Z","updated_at":"2025-10-05T09:46:27.000000Z"}]},{"id":7694953,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","dot_number":"1943517","report_state":"TX","report_number":"724A9DJY1T","insp_date":"2025-01-17 00:00:00","insp_start_time":"1005","insp_end_time":"1030","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-01-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9481292","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2025-01-23 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-23 21:39:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"3811 HERALD ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T20:57:55.000000Z","updated_at":"2025-03-17T20:57:55.000000Z","inspection_violations":[{"id":12023197,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","insp_violation_id":"264147254","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204979085","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39617C"},{"id":12023198,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","insp_violation_id":"264147255","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"204979086","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39355E"},{"id":12023199,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","insp_violation_id":"264147256","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204979086","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3939"},{"id":12023200,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","insp_violation_id":"264147257","seq_no":"4","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"204979086","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":12417093,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","insp_unit_id":"204979085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:02.000000Z","updated_at":"2025-03-17T23:52:02.000000Z"},{"id":12417094,"change_date":"2025-01-23 21:39:00","inspection_id":"83683421","insp_unit_id":"204979086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:02.000000Z","updated_at":"2025-03-17T23:52:02.000000Z"}]},{"id":6760280,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","dot_number":"1943517","report_state":"TX","report_number":"6YP99DCGFK","insp_date":"2024-09-16 00:00:00","insp_start_time":"0853","insp_end_time":"0930","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":"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-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9379993","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2024-09-18 21:43:00","snet_input_date":"2024-09-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-18 21:43:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"3811 HERALD ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T20:37:17.000000Z","updated_at":"2025-03-17T20:37:17.000000Z","inspection_violations":[{"id":10526959,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901302","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203011062","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39378"},{"id":10526960,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901303","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203011062","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"3965B"},{"id":10526961,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901304","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"203011063","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"3965B"},{"id":10526962,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901305","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203011063","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39347E"},{"id":10526963,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901306","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203011063","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39347E"},{"id":10526964,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901307","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"203011063","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39353B"},{"id":10526965,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_violation_id":"261901308","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"203011063","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10901254,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_unit_id":"203011062","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"},{"id":10901255,"change_date":"2024-09-18 21:43:00","inspection_id":"82695731","insp_unit_id":"203011063","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"}]},{"id":6480111,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","dot_number":"1943517","report_state":"TX","report_number":"6XR99DCQT0","insp_date":"2024-08-13 00:00:00","insp_start_time":"0935","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  N SHEPHERD","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-08-15 21:43:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9351092","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2024-08-15 21:43:00","snet_input_date":"2024-08-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-15 21:43:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"3811 HERALD ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T20:31:31.000000Z","updated_at":"2025-03-17T20:31:31.000000Z","inspection_violations":[{"id":10062265,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218031","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"3939A"},{"id":10062266,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218032","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"3939A"},{"id":10062267,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218033","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39319"},{"id":10062268,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218034","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39347E"},{"id":10062269,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218035","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39347E"},{"id":10062270,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218036","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39353B"},{"id":10062271,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218037","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202418200","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"3963A1"},{"id":10062272,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218038","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202418201","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39347E"},{"id":10062273,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218039","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202418201","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39353B"},{"id":10062274,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218040","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202418201","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39348A"},{"id":10062275,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_violation_id":"261218041","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202418201","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":10445117,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_unit_id":"202418200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"811","insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:15.000000Z","updated_at":"2025-03-17T23:31:15.000000Z"},{"id":10445118,"change_date":"2024-08-15 21:43:00","inspection_id":"82397427","insp_unit_id":"202418201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"T259","insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:15.000000Z","updated_at":"2025-03-17T23:31:15.000000Z"}]},{"id":5770118,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","dot_number":"1943517","report_state":"TX","report_number":"6V789DCGBC","insp_date":"2024-05-13 00:00:00","insp_start_time":"0818","insp_end_time":"0856","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":"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-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9274570","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T20:17:06.000000Z","updated_at":"2025-03-17T20:17:06.000000Z","inspection_violations":[{"id":8933400,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556159","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39378"},{"id":8933401,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556160","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39395F"},{"id":8933402,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556161","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3963A1"},{"id":8933403,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556162","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39347E"},{"id":8933404,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556163","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39347E"},{"id":8933405,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556164","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39353B"},{"id":8933406,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556165","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200937050","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3963A1"},{"id":8933407,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_violation_id":"259556166","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200937051","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9293783,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_unit_id":"200937050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19260","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X9AJ271622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"},{"id":9293784,"change_date":"2024-05-16 21:41:00","inspection_id":"81632938","insp_unit_id":"200937051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"124B960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMS14127G5014581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5911563,"change_date":"2024-06-04 21:42:00","inspection_id":"81786392","dot_number":"1943517","report_state":"TX","report_number":"6V239DBE2A","insp_date":"2024-05-08 00:00:00","insp_start_time":"0315","insp_end_time":"0335","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIED CONCRETE","shipping_paper_number":"842277632","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9291296","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2024-06-04 21:42:00","snet_input_date":"2024-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-04 21:42:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T20:19:51.000000Z","updated_at":"2025-03-17T20:19:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9521607,"change_date":"2024-06-04 21:42:00","inspection_id":"81786392","insp_unit_id":"201231470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:46.000000Z","updated_at":"2025-03-17T23:21:46.000000Z"},{"id":9521608,"change_date":"2024-06-04 21:42:00","inspection_id":"81786392","insp_unit_id":"201231471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:46.000000Z","updated_at":"2025-03-17T23:21:46.000000Z"}]},{"id":5217184,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","dot_number":"1943517","report_state":"TX","report_number":"6T6A9DCRR9","insp_date":"2024-03-01 00:00:00","insp_start_time":"1009","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  MAE DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARGOS","shipping_paper_number":"9083506","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"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":"9214283","transaction_code":"C","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-03-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8040042,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_violation_id":"258239974","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"199787670","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"393205C"},{"id":8040043,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_violation_id":"258239975","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199787670","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39311"},{"id":8040044,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_violation_id":"258239976","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199787670","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3939A"},{"id":8040045,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_violation_id":"258239977","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199787670","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3939A"},{"id":8040046,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_violation_id":"258239978","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199787670","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8401100,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_unit_id":"199787670","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"811","insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"},{"id":8401101,"change_date":"2024-03-06 21:40:00","inspection_id":"81030119","insp_unit_id":"199787671","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"T259","insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"}]},{"id":3145471,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","dot_number":"1943517","report_state":"TX","report_number":"V231030269","insp_date":"2023-05-17 00:00:00","insp_start_time":"1350","insp_end_time":"1431","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"REST AREA BS 288","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8988970","transaction_code":"C","transaction_date":"2023-06-06 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2023-05-25 21:42:00","snet_input_date":"2023-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T19:25:20.000000Z","updated_at":"2025-03-17T19:25:20.000000Z","inspection_violations":[{"id":4843864,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338266","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39319"},{"id":4843865,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338267","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39347E"},{"id":4843866,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338268","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39347E"},{"id":4843867,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338269","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39353B"},{"id":4843868,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338270","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"39378"},{"id":4843869,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338271","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"},{"id":4843870,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338272","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"},{"id":4843871,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338273","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"},{"id":4843872,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_violation_id":"253338274","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195357342","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5059204,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_unit_id":"195357342","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"45811","insp_unit_license":"1M73917","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCHAER9YC045811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"},{"id":5059205,"change_date":"2023-06-06 21:45:00","inspection_id":"78734599","insp_unit_id":"195357343","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"127","insp_unit_license":"Y53499","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17032840722154422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"}]},{"id":2957248,"change_date":"2023-05-08 21:42:00","inspection_id":"78522195","dot_number":"1943517","report_state":"TX","report_number":"6KLE9DJV7N","insp_date":"2023-04-27 00:00:00","insp_start_time":"1408","insp_end_time":"1436","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":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8969112","transaction_code":"C","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2023-05-03 21:42:00","snet_input_date":"2023-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[{"id":4539707,"change_date":"2023-05-08 21:42:00","inspection_id":"78522195","insp_violation_id":"252694368","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194811676","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39378"},{"id":4539708,"change_date":"2023-05-08 21:42:00","inspection_id":"78522195","insp_violation_id":"252694369","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194811676","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4758679,"change_date":"2023-05-08 21:42:00","inspection_id":"78522195","insp_unit_id":"194811676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19260","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X9AJ271622","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":4758680,"change_date":"2023-05-08 21:42:00","inspection_id":"78522195","insp_unit_id":"194811677","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"160B136","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1H4B04125EL014612","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":1627589,"change_date":"2022-10-28 21:40:00","inspection_id":"77005519","dot_number":"1943517","report_state":"TX","report_number":"6FGE9DJVLS","insp_date":"2022-10-24 00:00:00","insp_start_time":"1401","insp_end_time":"1429","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":"2022-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8813225","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2022-10-28 21:40:00","snet_input_date":"2022-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T18:56:40.000000Z","updated_at":"2025-03-17T18:56:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2618554,"change_date":"2022-10-28 21:40:00","inspection_id":"77005519","insp_unit_id":"191703104","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"},{"id":2618555,"change_date":"2022-10-28 21:40:00","inspection_id":"77005519","insp_unit_id":"191703105","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"124B960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMS14127G5014581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"}]},{"id":1627443,"change_date":"2022-10-28 21:40:00","inspection_id":"77005363","dot_number":"1943517","report_state":"TX","report_number":"6F999DJVL3","insp_date":"2022-10-17 00:00:00","insp_start_time":"0917","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","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-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"8812881","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2022-10-28 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T18:56:40.000000Z","updated_at":"2025-03-17T18:56:40.000000Z","inspection_violations":[{"id":2555315,"change_date":"2022-10-28 21:40:00","inspection_id":"77005363","insp_violation_id":"249319436","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191702791","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:01.000000Z","updated_at":"2025-03-17T21:19:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2618313,"change_date":"2022-10-28 21:40:00","inspection_id":"77005363","insp_unit_id":"191702790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"},{"id":2618314,"change_date":"2022-10-28 21:40:00","inspection_id":"77005363","insp_unit_id":"191702791","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"124B960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMS14127G5014581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"}]},{"id":1519749,"change_date":"2022-10-14 21:39:00","inspection_id":"76881525","dot_number":"1943517","report_state":"TX","report_number":"6EZ39DAXHV","insp_date":"2022-10-07 00:00:00","insp_start_time":"0340","insp_end_time":"0355","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CISCO CEMENT","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8800831","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T18:54:33.000000Z","updated_at":"2025-03-17T18:54:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2445872,"change_date":"2022-10-14 21:39:00","inspection_id":"76881525","insp_unit_id":"191452865","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"622","insp_unit_license":"1M19260","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X9AJ271622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"},{"id":2445873,"change_date":"2022-10-14 21:39:00","inspection_id":"76881525","insp_unit_id":"191452866","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"T259","insp_unit_license":"178C829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422185T36976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"}]},{"id":987285,"change_date":"2022-08-08 21:40:00","inspection_id":"76262817","dot_number":"1943517","report_state":"TX","report_number":"6D4F9DJVAD","insp_date":"2022-08-01 00:00:00","insp_start_time":"1527","insp_end_time":"1601","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":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8735857","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[{"id":1556872,"change_date":"2022-08-08 21:40:00","inspection_id":"76262817","insp_violation_id":"247581640","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190192561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1589242,"change_date":"2022-08-08 21:40:00","inspection_id":"76262817","insp_unit_id":"190192561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37423","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG93LL10033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:00.000000Z","updated_at":"2025-03-17T22:18:00.000000Z"},{"id":1589243,"change_date":"2022-08-08 21:40:00","inspection_id":"76262817","insp_unit_id":"190192562","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"124B960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMS14127G5014581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:00.000000Z","updated_at":"2025-03-17T22:18:00.000000Z"}]},{"id":167437,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","dot_number":"1943517","report_state":"TX","report_number":"69UC9DBHXO","insp_date":"2022-04-05 00:00:00","insp_start_time":"1236","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16800  BECKER RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","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":"2022-04-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8619251","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T18:30:29.000000Z","updated_at":"2025-03-17T18:30:29.000000Z","inspection_violations":[{"id":251559,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134940","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3922"},{"id":251560,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134941","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188135206","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3922"},{"id":251561,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134942","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188135206","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3922"},{"id":251562,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134943","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188135206","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"39617C"},{"id":251563,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134944","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188135207","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"39617C"},{"id":251564,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134945","seq_no":"6","part_no":"393","part_no_section":"203","insp_viol_unit":"2","insp_unit_id":"188135207","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"393203"},{"id":251565,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_violation_id":"245134946","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188135206","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":271308,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_unit_id":"188135206","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"773877F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X9AJ271622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:50.000000Z","updated_at":"2025-03-17T22:09:50.000000Z"},{"id":271309,"change_date":"2022-04-13 21:40:00","inspection_id":"75292711","insp_unit_id":"188135207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"14612","insp_unit_license":"160B136","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1H4B04125EL014612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:50.000000Z","updated_at":"2025-03-17T22:09:50.000000Z"}]},{"id":130618,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","dot_number":"1943517","report_state":"TX","report_number":"69T89DCP8B","insp_date":"2022-04-04 00:00:00","insp_start_time":"0755","insp_end_time":"0825","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12200  EAST FWY NORT","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-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8613925","transaction_code":"A","transaction_date":"2022-04-07 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01943517","upload_search_indicator":"M","census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"RICARDO ALFREDO PORTILLO ZAVALA","insp_carrier_street":"10525 PALESTINE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0778771","created_at":"2025-03-17T18:29:50.000000Z","updated_at":"2025-03-17T18:29:50.000000Z","inspection_violations":[{"id":193391,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_violation_id":"245031452","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188045707","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39378"},{"id":193392,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_violation_id":"245031453","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188045707","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"},{"id":193393,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_violation_id":"245031454","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188045708","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"},{"id":193394,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_violation_id":"245031455","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188045707","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39617C"},{"id":193395,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_violation_id":"245031456","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188045707","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":211696,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_unit_id":"188045707","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"773877F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X9AJ271622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"},{"id":211697,"change_date":"2022-04-07 21:39:00","inspection_id":"75248626","insp_unit_id":"188045708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"160B136","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1H4B04125EL014612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1943517\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1943517\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1943517\/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\/1943517\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}