{"current_page":1,"data":[{"id":12798958,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","dot_number":"2827961","report_state":"TX","report_number":"V262549122","insp_date":"2026-08-21 00:00:00","insp_start_time":"0900","insp_end_time":"0928","registration_date":null,"region":"CS","ci_status_code":"C","location":"R","location_desc":"TX","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","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":"52000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"4060813","transaction_code":"C","transaction_date":"2026-08-26 00:00:00","upload_date":"2026-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","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":"DEYANIRA LOPEZ","insp_carrier_street":"\\S8115 INDIAN SPRING TRAIL\\S","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","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-08-29T09:39:13.000000Z","inspection_violations":[{"id":22279339,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383378","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3939AHLLH"},{"id":22279340,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383379","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3939ALFTSI"},{"id":22279341,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383380","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3939ALFTSI"},{"id":22279342,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383381","seq_no":"5","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3939ALLPL"},{"id":22279343,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383382","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"39617CPI"},{"id":22279338,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383385","seq_no":"1","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"39375A1TEPBM"},{"id":22279344,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383383","seq_no":"7","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3965BL"},{"id":22279345,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_violation_id":"276383384","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215372261","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-26T18:56:48.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":22213615,"change_date":"2026-08-26 21:56:00","inspection_id":"88773445","insp_unit_id":"215372261","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"2","insp_unit_license":"VLY7966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6EDFS3071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-26T09:14:49.000000Z","updated_at":"2026-08-29T09:14:48.000000Z"}]},{"id":12832716,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","dot_number":"2827961","report_state":"TX","report_number":"V262438569","insp_date":"2026-08-20 00:00:00","insp_start_time":"0845","insp_end_time":"0919","registration_date":null,"region":"CS","ci_status_code":"C","location":"R","location_desc":"TX","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOPEZ","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-26 21:56:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"4060777","transaction_code":"A","transaction_date":"2026-08-26 00:00:00","upload_date":"2026-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":null,"census_search_date":"2026-08-26 21:56:00","snet_input_date":"2026-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-26 21:56:00","insp_carrier_name":"DEYANIRA LOPEZ","insp_carrier_street":"\\S8115 INDIAN SPRING TRAIL\\S","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-29T09:39:49.000000Z","updated_at":"2026-08-29T09:39:49.000000Z","inspection_violations":[{"id":22341390,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383179","seq_no":"1","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"393104BC"},{"id":22341391,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383180","seq_no":"2","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"393134BCRHLC"},{"id":22341392,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383181","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"39360C"},{"id":22341393,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383182","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"39378AWS"},{"id":22341394,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383183","seq_no":"5","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3939ALLPL"},{"id":22341395,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383184","seq_no":"6","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3965BL"},{"id":22341396,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383185","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215372140","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3922SLLSR"},{"id":22341397,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_violation_id":"276383186","seq_no":"8","part_no":"392","part_no_section":"2SLFYEMV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-29T09:57:36.000000Z","updated_at":"2026-08-29T09:57:36.000000Z","normalized_code":"3922SLFYEMV"}],"inspection_per_units":[{"id":22270035,"change_date":"2026-08-26 21:56:00","inspection_id":"88809310","insp_unit_id":"215372140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"6","insp_unit_license":"VZS2536","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-29T09:16:23.000000Z","updated_at":"2026-08-29T09:16:23.000000Z"}]},{"id":12141397,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","dot_number":"2827961","report_state":"TX","report_number":"7G399DUW79","insp_date":"2026-06-04 00:00:00","insp_start_time":"0902","insp_end_time":"0951","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","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-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"9985734","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2026-06-09 21:42:00","snet_input_date":"2026-06-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-09 21:42:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2026-06-12T09:40:09.000000Z","updated_at":"2026-06-20T09:33:24.000000Z","inspection_violations":[{"id":21131175,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","insp_violation_id":"274798908","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214002008","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:52.000000Z","updated_at":"2026-06-19T09:48:44.000000Z","normalized_code":"3922RG"},{"id":21131176,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","insp_violation_id":"274798909","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"214002008","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:52.000000Z","updated_at":"2026-06-19T09:48:44.000000Z","normalized_code":"39617C"},{"id":21131177,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","insp_violation_id":"274798910","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"214002008","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:52.000000Z","updated_at":"2026-06-19T09:48:44.000000Z","normalized_code":"3965B"},{"id":21131178,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","insp_violation_id":"274798911","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"214002008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:52.000000Z","updated_at":"2026-06-19T09:48:44.000000Z","normalized_code":"39311"},{"id":21131179,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","insp_violation_id":"274798912","seq_no":"5","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"214002008","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:52.000000Z","updated_at":"2026-06-19T09:48:44.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":21093181,"change_date":"2026-06-09 21:42:00","inspection_id":"88089769","insp_unit_id":"214002008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-263","insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:16:04.000000Z","updated_at":"2026-06-20T09:05:38.000000Z"}]},{"id":12043643,"change_date":"2026-05-28 21:42:00","inspection_id":"87984362","dot_number":"2827961","report_state":"TX","report_number":"7FOG9DCAM6","insp_date":"2026-05-20 00:00:00","insp_start_time":"1610","insp_end_time":"1625","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  SONORA","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-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9971863","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2026-05-28 21:42:00","snet_input_date":"2026-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-28 21:42:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2026-06-01T09:40:03.000000Z","updated_at":"2026-06-08T09:31:44.000000Z","inspection_violations":[{"id":20955494,"change_date":"2026-05-28 21:42:00","inspection_id":"87984362","insp_violation_id":"274562965","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213804770","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:44.000000Z","updated_at":"2026-06-08T09:44:04.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":20932735,"change_date":"2026-05-28 21:42:00","inspection_id":"87984362","insp_unit_id":"213804770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:21.000000Z","updated_at":"2026-06-08T09:04:05.000000Z"}]},{"id":11851773,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","dot_number":"2827961","report_state":"TX","report_number":"7F989DCALF","insp_date":"2026-05-05 00:00:00","insp_start_time":"0805","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9900  SOUTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54200","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":"9946244","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2026-05-10T09:39:37.000000Z","updated_at":"2026-05-18T09:31:15.000000Z","inspection_violations":[{"id":20612006,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115678","seq_no":"2","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"393201D"},{"id":20612009,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115681","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"3939"},{"id":20612010,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115682","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"39347E"},{"id":20612005,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115677","seq_no":"1","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"39324A"},{"id":20612007,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115679","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"3939"},{"id":20612008,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115680","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"3939"},{"id":20612011,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115683","seq_no":"7","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"39348A"},{"id":20612012,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115684","seq_no":"8","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"39353B"},{"id":20612013,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_violation_id":"274115685","seq_no":"9","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"213436668","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-10T09:59:02.000000Z","updated_at":"2026-05-18T09:42:57.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":20609956,"change_date":"2026-05-07 21:40:00","inspection_id":"87787925","insp_unit_id":"213436668","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:57.000000Z","updated_at":"2026-05-18T09:03:51.000000Z"}]},{"id":11760439,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","dot_number":"2827961","report_state":"TX","report_number":"V262290706","insp_date":"2026-04-23 00:00:00","insp_start_time":"1017","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14795  TX105","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOPEZ DEMOLITION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"10","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9932558","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2026-04-30T09:39:39.000000Z","updated_at":"2026-05-08T09:31:06.000000Z","inspection_violations":[{"id":20447390,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882346","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"39319"},{"id":20447391,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882347","seq_no":"2","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"39375GLOAD"},{"id":20447392,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882348","seq_no":"3","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"39375GLOAD"},{"id":20447393,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882349","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"39378"},{"id":20447394,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882350","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"3939"},{"id":20447395,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882351","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"3939"},{"id":20447396,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882352","seq_no":"7","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"3939TS"},{"id":20447397,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882353","seq_no":"8","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"3922W"},{"id":20447398,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882354","seq_no":"9","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"3922W"},{"id":20447399,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_violation_id":"273882355","seq_no":"10","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213249205","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:09.000000Z","updated_at":"2026-05-08T09:42:34.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20460912,"change_date":"2026-04-27 21:39:00","inspection_id":"87690811","insp_unit_id":"213249205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"VLY7966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6EDFS3071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:41.000000Z","updated_at":"2026-05-08T09:03:51.000000Z"}]},{"id":10281386,"change_date":"2025-11-24 21:40:00","inspection_id":"86406111","dot_number":"2827961","report_state":"TX","report_number":"V252122439","insp_date":"2025-11-21 00:00:00","insp_start_time":"0749","insp_end_time":"0827","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX8 BELTWAY NB SVC R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RESIDENTIAL ORDER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9767200","transaction_code":"A","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-11-24 21:40:00","snet_input_date":"2025-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-24 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-11-27T10:30:52.000000Z","updated_at":"2025-11-28T10:31:20.000000Z","inspection_violations":[{"id":17186966,"change_date":"2025-11-24 21:40:00","inspection_id":"86406111","insp_violation_id":"270272293","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"210244924","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-11-27T10:31:11.000000Z","updated_at":"2025-11-28T10:32:11.000000Z","normalized_code":"393134"},{"id":17186967,"change_date":"2025-11-24 21:40:00","inspection_id":"86406111","insp_violation_id":"270272294","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210244924","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:11.000000Z","updated_at":"2025-11-28T10:32:11.000000Z","normalized_code":"39360D"},{"id":17186968,"change_date":"2025-11-24 21:40:00","inspection_id":"86406111","insp_violation_id":"270272295","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"210244924","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:11.000000Z","updated_at":"2025-11-28T10:32:11.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":17161746,"change_date":"2025-11-24 21:40:00","inspection_id":"86406111","insp_unit_id":"210244924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6","insp_unit_license":"VZS2536","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:44.000000Z","updated_at":"2025-11-28T10:01:21.000000Z"}]},{"id":10107997,"change_date":"2025-11-03 21:39:00","inspection_id":"86223921","dot_number":"2827961","report_state":"TX","report_number":"7A1G9DJW56","insp_date":"2025-10-29 00:00:00","insp_start_time":"1619","insp_end_time":"1650","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5300  MCCARTY ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LANDFILL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9744405","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-11-06T10:30:43.000000Z","updated_at":"2025-11-07T10:30:52.000000Z","inspection_violations":[{"id":16750944,"change_date":"2025-11-03 21:39:00","inspection_id":"86223921","insp_violation_id":"269695254","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"209808768","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:01.000000Z","updated_at":"2025-11-07T10:31:01.000000Z","normalized_code":"39021A"},{"id":16750945,"change_date":"2025-11-03 21:39:00","inspection_id":"86223921","insp_violation_id":"269695255","seq_no":"2","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"209808768","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:01.000000Z","updated_at":"2025-11-07T10:31:01.000000Z","normalized_code":"393201D"},{"id":16750946,"change_date":"2025-11-03 21:39:00","inspection_id":"86223921","insp_violation_id":"269695256","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209808768","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:01.000000Z","updated_at":"2025-11-07T10:31:01.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16809829,"change_date":"2025-11-03 21:39:00","inspection_id":"86223921","insp_unit_id":"209808768","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:38.000000Z","updated_at":"2025-11-07T10:01:08.000000Z"}]},{"id":9912967,"change_date":"2025-10-15 21:39:00","inspection_id":"86017959","dot_number":"2827961","report_state":"TX","report_number":"V252059041","insp_date":"2025-10-09 00:00:00","insp_start_time":"1110","insp_end_time":"1148","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BELTWAY 8 @ GENERATI","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9722285","transaction_code":"C","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-10-13T10:02:11.000000Z","updated_at":"2025-10-19T10:00:25.000000Z","inspection_violations":[{"id":16421047,"change_date":"2025-10-15 21:39:00","inspection_id":"86017959","insp_violation_id":"269325774","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"209491338","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:51.000000Z","updated_at":"2025-10-19T10:15:48.000000Z","normalized_code":"393209E"},{"id":16421048,"change_date":"2025-10-15 21:39:00","inspection_id":"86017959","insp_violation_id":"269325775","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209491338","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:51.000000Z","updated_at":"2025-10-19T10:15:48.000000Z","normalized_code":"3939"},{"id":16421049,"change_date":"2025-10-15 21:39:00","inspection_id":"86017959","insp_violation_id":"269325776","seq_no":"3","part_no":"396","part_no_section":"5B-HLIW","insp_viol_unit":"1","insp_unit_id":"209491338","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:51.000000Z","updated_at":"2025-10-19T10:15:48.000000Z","normalized_code":"3965BHLIW"},{"id":16421050,"change_date":"2025-10-15 21:39:00","inspection_id":"86017959","insp_violation_id":"269325777","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"209491338","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:51.000000Z","updated_at":"2025-10-19T10:15:48.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16510605,"change_date":"2025-10-15 21:39:00","inspection_id":"86017959","insp_unit_id":"209491338","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"TBZ3017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:09.000000Z","updated_at":"2025-10-19T09:45:30.000000Z"}]},{"id":9852004,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","dot_number":"2827961","report_state":"TX","report_number":"V252037374","insp_date":"2025-10-02 00:00:00","insp_start_time":"1126","insp_end_time":"1203","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11906 SAM HOUSTON TL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SCOTTBENDS","shipping_paper_number":"N.A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9714997","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-10-03 21:40:00","snet_input_date":"2025-10-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-03 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-10-05T10:02:26.000000Z","updated_at":"2025-10-08T10:01:13.000000Z","inspection_violations":[{"id":16227206,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091177","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"39347E"},{"id":16227207,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091178","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"39347E"},{"id":16227208,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091179","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"39353B"},{"id":16227209,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091180","seq_no":"4","part_no":"393","part_no_section":"75A","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"39375A"},{"id":16227210,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091181","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"3939TS"},{"id":16227211,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091182","seq_no":"6","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"39395B"},{"id":16227212,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091183","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"39617C"},{"id":16227213,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091184","seq_no":"8","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"3963A1BOS"},{"id":16227214,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_violation_id":"269091185","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209292359","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:24.000000Z","updated_at":"2025-10-08T10:17:11.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16338966,"change_date":"2025-10-03 21:40:00","inspection_id":"85953875","insp_unit_id":"209292359","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"XGB9314","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY5FDGR6050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:18.000000Z","updated_at":"2025-10-08T09:46:30.000000Z"}]},{"id":9697750,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","dot_number":"2827961","report_state":"TX","report_number":"V252006272","insp_date":"2025-09-12 00:00:00","insp_start_time":"1003","insp_end_time":"1114","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"EAST SAM HOUSTON PKW","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOPEZ DEMOLITION","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9697438","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-09-18T10:01:03.000000Z","updated_at":"2025-09-23T10:01:17.000000Z","inspection_violations":[{"id":15912614,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736853","seq_no":"1","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"39348A"},{"id":15912615,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736854","seq_no":"2","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"39375GLOAD"},{"id":15912616,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736855","seq_no":"3","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"39381"},{"id":15912617,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736856","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"3939"},{"id":15912618,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736857","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"3939TS"},{"id":15912619,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736858","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"3939TS"},{"id":15912620,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736859","seq_no":"7","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"39395B"},{"id":15912621,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736860","seq_no":"8","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"39617C"},{"id":15912622,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_violation_id":"268736861","seq_no":"10","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208984858","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:01.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16053420,"change_date":"2025-09-16 21:40:00","inspection_id":"85792177","insp_unit_id":"208984858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"VJX3093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS1DHFH7525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:44.000000Z","updated_at":"2025-09-20T09:45:36.000000Z"}]},{"id":9687510,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","dot_number":"2827961","report_state":"TX","report_number":"V252012900","insp_date":"2025-09-11 00:00:00","insp_start_time":"1219","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11850  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":"RESIDENTIAL","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9695518","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[{"id":15888456,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709275","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"39347E"},{"id":15888457,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709276","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"39347E"},{"id":15888458,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709277","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"39353B"},{"id":15888459,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709278","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"39378"},{"id":15888460,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709279","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3939"},{"id":15888461,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709280","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3939"},{"id":15888462,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709281","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3939"},{"id":15888463,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709282","seq_no":"8","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3939TS"},{"id":15888464,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709283","seq_no":"9","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3963A1BOS"},{"id":15888465,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709284","seq_no":"10","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3965B"},{"id":15888466,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709285","seq_no":"11","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3922WC"},{"id":15888467,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_violation_id":"268709286","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208964305","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:04.000000Z","updated_at":"2025-09-18T10:21:04.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16034317,"change_date":"2025-09-15 21:41:00","inspection_id":"85781653","insp_unit_id":"208964305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"VLY7966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6EDFS3071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"}]},{"id":9156868,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","dot_number":"2827961","report_state":"TX","report_number":"76XA9DCK5T","insp_date":"2025-07-09 00:00:00","insp_start_time":"1005","insp_end_time":"1050","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":"2025-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9637581","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-07-15 21:41:00","snet_input_date":"2025-07-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-15 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-07-18T10:46:07.000000Z","updated_at":"2025-07-19T10:42:15.000000Z","inspection_violations":[{"id":14776323,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424628","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"3939"},{"id":14776324,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424629","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"39347E"},{"id":14776325,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424630","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"39347E"},{"id":14776326,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424631","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"39353B"},{"id":14776327,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424632","seq_no":"5","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"3963A1BOS"},{"id":14776328,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424633","seq_no":"6","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"39345B2UV"},{"id":14776329,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_violation_id":"267424634","seq_no":"7","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"207886532","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-18T10:48:24.000000Z","updated_at":"2025-07-18T10:48:24.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":15039783,"change_date":"2025-07-15 21:41:00","inspection_id":"85223731","insp_unit_id":"207886532","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:42.000000Z","updated_at":"2025-07-19T09:46:01.000000Z"}]},{"id":9033629,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","dot_number":"2827961","report_state":"TX","report_number":"V251927717","insp_date":"2025-06-24 00:00:00","insp_start_time":"1300","insp_end_time":"1354","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 69 NEAR SH 99","county_code_state":"TX","county_code":"339","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEYANIRA LOPEZ","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9621314","transaction_code":"A","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-06-30 21:39:00","snet_input_date":"2025-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-30 21:39:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-07-03T10:01:56.000000Z","updated_at":"2025-07-04T10:00:52.000000Z","inspection_violations":[{"id":14526243,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137580","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"38323A2"},{"id":14526244,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137581","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"39141APC"},{"id":14526245,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137582","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"39345B2UV"},{"id":14526246,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137583","seq_no":"4","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"39345B2UV"},{"id":14526247,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137584","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"39347E"},{"id":14526248,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137585","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"39347E"},{"id":14526249,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137586","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"39347E"},{"id":14526250,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137587","seq_no":"8","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"3963A1"},{"id":14526251,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_violation_id":"267137588","seq_no":"9","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207645427","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-03T10:15:59.000000Z","updated_at":"2025-07-04T10:17:58.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14817791,"change_date":"2025-06-30 21:39:00","inspection_id":"85094019","insp_unit_id":"207645427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"TSW9788","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY5HDJG4387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:42.000000Z","updated_at":"2025-07-04T09:46:11.000000Z"}]},{"id":8922445,"change_date":"2025-06-17 21:41:00","inspection_id":"84976646","dot_number":"2827961","report_state":"TX","report_number":"764G9DBT43","insp_date":"2025-06-10 00:00:00","insp_start_time":"1551","insp_end_time":"1635","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400  E LOOP N","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-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9608682","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-06-20T10:00:58.000000Z","updated_at":"2025-06-22T10:00:46.000000Z","inspection_violations":[{"id":14313903,"change_date":"2025-06-17 21:41:00","inspection_id":"84976646","insp_violation_id":"266896822","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"207431909","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:57.000000Z","normalized_code":"39355D1"},{"id":14313904,"change_date":"2025-06-17 21:41:00","inspection_id":"84976646","insp_violation_id":"266896823","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207431909","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:57.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14621124,"change_date":"2025-06-17 21:41:00","inspection_id":"84976646","insp_unit_id":"207431909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"05","insp_unit_license":"TPL5813","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPVD09X5AD108875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:07.000000Z","updated_at":"2025-06-22T09:46:03.000000Z"}]},{"id":8864262,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","dot_number":"2827961","report_state":"TX","report_number":"75Z79DCP2K","insp_date":"2025-06-05 00:00:00","insp_start_time":"0725","insp_end_time":"0757","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9602327","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-06-10 21:41:00","snet_input_date":"2025-06-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-10 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-06-14T10:00:48.000000Z","updated_at":"2025-06-14T10:00:48.000000Z","inspection_violations":[{"id":14199759,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","insp_violation_id":"266766013","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207316791","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:56.000000Z","updated_at":"2025-06-14T10:16:06.000000Z","normalized_code":"3922RG"},{"id":14199760,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","insp_violation_id":"266766014","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207316791","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:56.000000Z","updated_at":"2025-06-14T10:16:06.000000Z","normalized_code":"39378"},{"id":14199761,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","insp_violation_id":"266766015","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207316791","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:56.000000Z","updated_at":"2025-06-14T10:16:06.000000Z","normalized_code":"3922RG"},{"id":14199762,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","insp_violation_id":"266766016","seq_no":"4","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"207316791","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:56.000000Z","updated_at":"2025-06-14T10:16:06.000000Z","normalized_code":"393205C"},{"id":14199763,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","insp_violation_id":"266766017","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207316791","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:56.000000Z","updated_at":"2025-06-14T10:16:06.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14516588,"change_date":"2025-06-10 21:41:00","inspection_id":"84914862","insp_unit_id":"207316791","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBZ3017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:45.000000Z","updated_at":"2025-06-14T09:45:53.000000Z"}]},{"id":8781581,"change_date":"2025-05-30 21:41:00","inspection_id":"84827199","dot_number":"2827961","report_state":"TX","report_number":"75QA9DBA3M","insp_date":"2025-05-27 00:00:00","insp_start_time":"1000","insp_end_time":"1034","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEYANIRA LOPEZ","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-05-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9594821","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-05-30 21:41:00","snet_input_date":"2025-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-30 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-06-04T10:01:11.000000Z","updated_at":"2025-06-04T10:01:11.000000Z","inspection_violations":[{"id":14038682,"change_date":"2025-05-30 21:41:00","inspection_id":"84827199","insp_violation_id":"266582329","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"1","insp_unit_id":"207155584","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:22.000000Z","updated_at":"2025-06-03T10:17:54.000000Z","normalized_code":"3922C"},{"id":14038683,"change_date":"2025-05-30 21:41:00","inspection_id":"84827199","insp_violation_id":"266582330","seq_no":"2","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"207155584","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:22.000000Z","updated_at":"2025-06-03T10:17:54.000000Z","normalized_code":"393205C"},{"id":14038684,"change_date":"2025-05-30 21:41:00","inspection_id":"84827199","insp_violation_id":"266582331","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207155584","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:22.000000Z","updated_at":"2025-06-03T10:17:54.000000Z","normalized_code":"3939"},{"id":14038685,"change_date":"2025-05-30 21:41:00","inspection_id":"84827199","insp_violation_id":"266582332","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207155584","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:22.000000Z","updated_at":"2025-06-03T10:17:54.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14368024,"change_date":"2025-05-30 21:41:00","inspection_id":"84827199","insp_unit_id":"207155584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBZ3017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:24.000000Z","updated_at":"2025-06-03T09:46:03.000000Z"}]},{"id":8024437,"change_date":"2025-03-04 21:39:00","inspection_id":"84029429","dot_number":"2827961","report_state":"TX","report_number":"73989DJNJA","insp_date":"2025-02-27 00:00:00","insp_start_time":"0803","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6200 N SHEPHERD 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":"2025-03-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9513054","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-03-04 21:39:00","snet_input_date":"2025-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T21:04:55.000000Z","updated_at":"2025-03-17T21:04:55.000000Z","inspection_violations":[{"id":12539593,"change_date":"2025-03-04 21:39:00","inspection_id":"84029429","insp_violation_id":"264827772","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205622320","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3922RG"},{"id":12539594,"change_date":"2025-03-04 21:39:00","inspection_id":"84029429","insp_violation_id":"264827773","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205622320","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12954837,"change_date":"2025-03-04 21:39:00","inspection_id":"84029429","insp_unit_id":"205622320","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6","insp_unit_license":"TBZ3017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:05.000000Z","updated_at":"2025-03-17T23:58:05.000000Z"}]},{"id":7957255,"change_date":"2025-02-25 21:40:00","inspection_id":"83958875","dot_number":"2827961","report_state":"TX","report_number":"730D9DJNII","insp_date":"2025-02-18 00:00:00","insp_start_time":"1336","insp_end_time":"1356","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8600  MESA 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":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9506385","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T21:03:18.000000Z","updated_at":"2025-03-17T21:03:18.000000Z","inspection_violations":[{"id":12434318,"change_date":"2025-02-25 21:40:00","inspection_id":"83958875","insp_violation_id":"264693117","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"205492594","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":12845293,"change_date":"2025-02-25 21:40:00","inspection_id":"83958875","insp_unit_id":"205492594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9","insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7760036,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","dot_number":"2827961","report_state":"TX","report_number":"V251758214","insp_date":"2025-01-29 00:00:00","insp_start_time":"1408","insp_end_time":"1447","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10655 SAM HOUSTON TL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOPEZ DEMOLITION","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"15","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9487746","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2025-01-31 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-31 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T20:59:29.000000Z","updated_at":"2025-03-17T20:59:29.000000Z","inspection_violations":[{"id":12124847,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282662","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"393134"},{"id":12124848,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282663","seq_no":"2","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"393134"},{"id":12124849,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282664","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39360D"},{"id":12124850,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282665","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39375A3"},{"id":12124851,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282666","seq_no":"5","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39375A3"},{"id":12124852,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282667","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39378"},{"id":12124853,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282668","seq_no":"7","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39378"},{"id":12124854,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282669","seq_no":"8","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3939H"},{"id":12124855,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282670","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3939"},{"id":12124856,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282671","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3939"},{"id":12124857,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282672","seq_no":"11","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39395A"},{"id":12124858,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282673","seq_no":"12","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3965B"},{"id":12124859,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282674","seq_no":"13","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3922RG"},{"id":12124860,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282675","seq_no":"14","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3922RG"},{"id":12124861,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_violation_id":"264282676","seq_no":"15","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205106344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12523012,"change_date":"2025-01-31 21:41:00","inspection_id":"83751838","insp_unit_id":"205106344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"TBZ3017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:14.000000Z","updated_at":"2025-03-17T23:53:14.000000Z"}]},{"id":7026653,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","dot_number":"2827961","report_state":"TX","report_number":"6ZLG9DJVRP","insp_date":"2024-10-18 00:00:00","insp_start_time":"1636","insp_end_time":"1710","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN HARRIS CO. (492-528","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-23 21:42: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":"9409412","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10966769,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","insp_violation_id":"262517067","seq_no":"1","part_no":"393","part_no_section":"55C2","insp_viol_unit":"1","insp_unit_id":"203550284","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39355C2"},{"id":10966770,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","insp_violation_id":"262517068","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203550284","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939TS"},{"id":10966771,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","insp_violation_id":"262517069","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"203550284","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39319"},{"id":10966772,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","insp_violation_id":"262517070","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203550284","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939"},{"id":10966773,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","insp_violation_id":"262517071","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203550284","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11332607,"change_date":"2024-10-23 21:42:00","inspection_id":"82979205","insp_unit_id":"203550284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"TSM9788","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3GCPYFED3MG321361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":5966134,"change_date":"2024-06-11 21:43:00","inspection_id":"81845704","dot_number":"2827961","report_state":"TX","report_number":"6VV89DAPES","insp_date":"2024-06-06 00:00:00","insp_start_time":"0854","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-11 21:43: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":"9297274","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2024-06-11 21:43:00","snet_input_date":"2024-06-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-11 21:43:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T20:21:03.000000Z","updated_at":"2025-03-17T20:21:03.000000Z","inspection_violations":[{"id":9254541,"change_date":"2024-06-11 21:43:00","inspection_id":"81845704","insp_violation_id":"260028023","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201343435","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"39347E"},{"id":9254542,"change_date":"2024-06-11 21:43:00","inspection_id":"81845704","insp_violation_id":"260028024","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201343435","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9609989,"change_date":"2024-06-11 21:43:00","inspection_id":"81845704","insp_unit_id":"201343435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TSW9788","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY5HDJG4387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:37.000000Z","updated_at":"2025-03-17T23:22:37.000000Z"}]},{"id":5319714,"change_date":"2024-03-19 21:45:00","inspection_id":"81142347","dot_number":"2827961","report_state":"TX","report_number":"6TDG9DCDK7","insp_date":"2024-03-08 00:00:00","insp_start_time":"1555","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"150 W CAVALCADE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9226326","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T20:07:57.000000Z","updated_at":"2025-03-17T20:07:57.000000Z","inspection_violations":[{"id":8207640,"change_date":"2024-03-19 21:45:00","inspection_id":"81142347","insp_violation_id":"258467294","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:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"38323A2"},{"id":8207641,"change_date":"2024-03-19 21:45:00","inspection_id":"81142347","insp_violation_id":"258467295","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8567502,"change_date":"2024-03-19 21:45:00","inspection_id":"81142347","insp_unit_id":"199985970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RXJ0834","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6EDFS3071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"}]},{"id":4296136,"change_date":"2023-10-26 21:42:00","inspection_id":"80021031","dot_number":"2827961","report_state":"TX","report_number":"6PFG9DCP8G","insp_date":"2023-10-18 00:00:00","insp_start_time":"1603","insp_end_time":"1620","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3600  COLLEY","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-10-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"65760","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9110561","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2023-10-26 21:42:00","snet_input_date":"2023-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-26 21:42:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:47:54.000000Z","updated_at":"2025-03-17T19:47:54.000000Z","inspection_violations":[{"id":6645979,"change_date":"2023-10-26 21:42:00","inspection_id":"80021031","insp_violation_id":"256073655","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197772256","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39378"},{"id":6645980,"change_date":"2023-10-26 21:42:00","inspection_id":"80021031","insp_violation_id":"256073656","seq_no":"2","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"197772256","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39324A"},{"id":6645981,"change_date":"2023-10-26 21:42:00","inspection_id":"80021031","insp_violation_id":"256073657","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"197772256","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"393205C"},{"id":6645982,"change_date":"2023-10-26 21:42:00","inspection_id":"80021031","insp_violation_id":"256073658","seq_no":"3","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"197772256","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":6909404,"change_date":"2023-10-26 21:42:00","inspection_id":"80021031","insp_unit_id":"197772256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:55.000000Z","updated_at":"2025-03-17T22:57:55.000000Z"}]},{"id":3891238,"change_date":"2023-09-01 21:40:00","inspection_id":"79571949","dot_number":"2827961","report_state":"TX","report_number":"6O179DCE5V","insp_date":"2023-08-29 00:00:00","insp_start_time":"0747","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8100  KATY FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"9066001","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2023-09-01 21:40:00","snet_input_date":"2023-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-01 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:39:44.000000Z","updated_at":"2025-03-17T19:39:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6256245,"change_date":"2023-09-01 21:40:00","inspection_id":"79571949","insp_unit_id":"196871941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:34.000000Z","updated_at":"2025-03-17T22:52:34.000000Z"}]},{"id":3771242,"change_date":"2023-08-17 21:44:00","inspection_id":"79437772","dot_number":"2827961","report_state":"TX","report_number":"6NN89DBAYK","insp_date":"2023-08-15 00:00:00","insp_start_time":"0855","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12809  HOMESTEAD ROA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEYANIRA LOPEZ","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-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"9054869","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:37:17.000000Z","updated_at":"2025-03-17T19:37:17.000000Z","inspection_violations":[{"id":5816599,"change_date":"2023-08-17 21:44:00","inspection_id":"79437772","insp_violation_id":"254727258","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196596112","insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:56.000000Z","updated_at":"2025-03-17T21:33:56.000000Z","normalized_code":"3922"},{"id":5816600,"change_date":"2023-08-17 21:44:00","inspection_id":"79437772","insp_violation_id":"254727259","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196596112","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:56.000000Z","updated_at":"2025-03-17T21:33:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6063495,"change_date":"2023-08-17 21:44:00","inspection_id":"79437772","insp_unit_id":"196596112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"TBJ9042","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ299623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"}]},{"id":3560074,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","dot_number":"2827961","report_state":"TX","report_number":"6MUF9DCP2E","insp_date":"2023-07-17 00:00:00","insp_start_time":"1505","insp_end_time":"1525","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7500  EASTEX FWY EAS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9032685","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:33:29.000000Z","updated_at":"2025-03-17T19:33:29.000000Z","inspection_violations":[{"id":5489169,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","insp_violation_id":"254189009","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196115435","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:28.000000Z","updated_at":"2025-03-17T21:32:28.000000Z","normalized_code":"39378"},{"id":5489170,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","insp_violation_id":"254189010","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196115435","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:28.000000Z","updated_at":"2025-03-17T21:32:28.000000Z","normalized_code":"3939A"},{"id":5489171,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","insp_violation_id":"254189011","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196115435","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:28.000000Z","updated_at":"2025-03-17T21:32:28.000000Z","normalized_code":"3922"},{"id":5489172,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","insp_violation_id":"254189012","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196115435","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:28.000000Z","updated_at":"2025-03-17T21:32:28.000000Z","normalized_code":"3939A"},{"id":5489173,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","insp_violation_id":"254189013","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196115435","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:28.000000Z","updated_at":"2025-03-17T21:32:28.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":5724828,"change_date":"2023-07-20 21:41:00","inspection_id":"79201525","insp_unit_id":"196115435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBZ3017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:10.000000Z","updated_at":"2025-03-17T22:48:10.000000Z"}]},{"id":3482250,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","dot_number":"2827961","report_state":"TX","report_number":"6MN99DCCY1","insp_date":"2023-07-10 00:00:00","insp_start_time":"0934","insp_end_time":"1008","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15100  LEE 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-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26001","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9026282","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-07-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:32:02.000000Z","updated_at":"2025-03-17T19:32:02.000000Z","inspection_violations":[{"id":5369524,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996911","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5369525,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996912","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5369526,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996913","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39617C"},{"id":5369527,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996914","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39360C"},{"id":5369528,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996915","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39378"},{"id":5369529,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996916","seq_no":"6","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39381"},{"id":5369530,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996917","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"},{"id":5369531,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_violation_id":"253996918","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195942306","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5599687,"change_date":"2023-07-11 21:42:00","inspection_id":"79114338","insp_unit_id":"195942306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"11","insp_unit_license":"NBF5583","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTMKAAN96H201565","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:11.000000Z","updated_at":"2025-03-17T22:47:11.000000Z"}]},{"id":2517462,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","dot_number":"2827961","report_state":"TX","report_number":"6J1A9DBVJA","insp_date":"2023-03-02 00:00:00","insp_start_time":"1030","insp_end_time":"1105","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":"LOPEZ CLEANUP","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-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8921574","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2023-03-06 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:12:58.000000Z","updated_at":"2025-03-17T19:12:58.000000Z","inspection_violations":[{"id":3872783,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_violation_id":"251507368","seq_no":"1","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"193733975","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"3929"},{"id":3872784,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_violation_id":"251507369","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"193733975","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"39355D1"},{"id":3872785,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_violation_id":"251507370","seq_no":"3","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"193733975","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"393134"},{"id":3872786,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_violation_id":"251507371","seq_no":"4","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"1","insp_unit_id":"193733975","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"393104F3"},{"id":3872787,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_violation_id":"251507372","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193733975","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"3939A"},{"id":3872788,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_violation_id":"251507373","seq_no":"6","part_no":"393","part_no_section":"86(b)(1)","insp_viol_unit":"1","insp_unit_id":"193733975","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"39386B1"}],"inspection_per_units":[{"id":4052276,"change_date":"2023-03-06 21:41:00","inspection_id":"78022707","insp_unit_id":"193733975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CAT","insp_unit_company":"9","insp_unit_license":"NSZ4983","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSJGTKR2FN734028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"}]},{"id":1905915,"change_date":"2022-12-08 21:41:00","inspection_id":"77324171","dot_number":"2827961","report_state":"TX","report_number":"6GIH9DCPMW","insp_date":"2022-12-01 00:00:00","insp_start_time":"1710","insp_end_time":"1725","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17100  EASTEX FWY WE","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-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8846165","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T19:01:50.000000Z","updated_at":"2025-03-17T19:01:50.000000Z","inspection_violations":[{"id":2964494,"change_date":"2022-12-08 21:41:00","inspection_id":"77324171","insp_violation_id":"250002492","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192336926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"},{"id":2964495,"change_date":"2022-12-08 21:41:00","inspection_id":"77324171","insp_violation_id":"250002493","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192336926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"},{"id":2964496,"change_date":"2022-12-08 21:41:00","inspection_id":"77324171","insp_violation_id":"250002494","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192336926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3067567,"change_date":"2022-12-08 21:41:00","inspection_id":"77324171","insp_unit_id":"192336926","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RXJ0834","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6EDFS3071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"}]},{"id":1790157,"change_date":"2022-11-21 21:41:00","inspection_id":"77192009","dot_number":"2827961","report_state":"TX","report_number":"6G480XQX34","insp_date":"2022-11-17 00:00:00","insp_start_time":"0846","insp_end_time":"0903","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2022-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"8832409","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2022-11-21 21:41:00","snet_input_date":"2022-11-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-21 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T18:59:39.000000Z","updated_at":"2025-03-17T18:59:39.000000Z","inspection_violations":[{"id":2801053,"change_date":"2022-11-21 21:41:00","inspection_id":"77192009","insp_violation_id":"249727487","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192072342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39311"},{"id":2801054,"change_date":"2022-11-21 21:41:00","inspection_id":"77192009","insp_violation_id":"249727488","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192072342","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3963A1"},{"id":2801055,"change_date":"2022-11-21 21:41:00","inspection_id":"77192009","insp_violation_id":"249727489","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192072342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3939A"},{"id":2801056,"change_date":"2022-11-21 21:41:00","inspection_id":"77192009","insp_violation_id":"249727490","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192072342","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2880071,"change_date":"2022-11-21 21:41:00","inspection_id":"77192009","insp_unit_id":"192072342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"RXJ0776","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS1DHFH7525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:43.000000Z","updated_at":"2025-03-17T22:26:43.000000Z"}]},{"id":1649300,"change_date":"2022-11-01 21:40:00","inspection_id":"77030462","dot_number":"2827961","report_state":"TX","report_number":"6FE99DJM7D","insp_date":"2022-10-22 00:00:00","insp_start_time":"0907","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8700  N LOOP E","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-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8815655","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-10-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2588279,"change_date":"2022-11-01 21:40:00","inspection_id":"77030462","insp_violation_id":"249375477","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191754253","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"39378"},{"id":2588280,"change_date":"2022-11-01 21:40:00","inspection_id":"77030462","insp_violation_id":"249375478","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191754253","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3965B"},{"id":2588281,"change_date":"2022-11-01 21:40:00","inspection_id":"77030462","insp_violation_id":"249375479","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"191754253","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2654012,"change_date":"2022-11-01 21:40:00","inspection_id":"77030462","insp_unit_id":"191754253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"RZZ1575","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL00X1BJ277113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":1520270,"change_date":"2022-10-14 21:39:00","inspection_id":"76882108","dot_number":"2827961","report_state":"TX","report_number":"6F2H9DCK3V","insp_date":"2022-10-10 00:00:00","insp_start_time":"1705","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  RANKIN RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":"UNK","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-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"8801064","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":"02827961","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T18:54:47.000000Z","updated_at":"2025-03-17T18:54:47.000000Z","inspection_violations":[{"id":2395337,"change_date":"2022-10-14 21:39:00","inspection_id":"76882108","insp_violation_id":"249046753","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191453953","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3939A"},{"id":2395338,"change_date":"2022-10-14 21:39:00","inspection_id":"76882108","insp_violation_id":"249046754","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191453953","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":2446731,"change_date":"2022-10-14 21:39:00","inspection_id":"76882108","insp_unit_id":"191453953","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RXJ0776","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS1DHFH7525","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":703241,"change_date":"2022-06-27 21:41:00","inspection_id":"75930487","dot_number":"2827961","report_state":"TX","report_number":"6C2C0AMX9A","insp_date":"2022-06-24 00:00:00","insp_start_time":"1157","insp_end_time":"1221","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0075 IN WALKER CO. (410-446","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8696757","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2022-06-27 21:41:00","snet_input_date":"2022-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T18:40:09.000000Z","updated_at":"2025-03-17T18:40:09.000000Z","inspection_violations":[{"id":1106257,"change_date":"2022-06-27 21:41:00","inspection_id":"75930487","insp_violation_id":"246748011","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39282A1"},{"id":1106258,"change_date":"2022-06-27 21:41:00","inspection_id":"75930487","insp_violation_id":"246748012","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189487001","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"3922"},{"id":1106259,"change_date":"2022-06-27 21:41:00","inspection_id":"75930487","insp_violation_id":"246748013","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189487001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1130617,"change_date":"2022-06-27 21:41:00","inspection_id":"75930487","insp_unit_id":"189487001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"46562L9","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6EDFS3071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"}]},{"id":711235,"change_date":"2022-06-28 21:43:00","inspection_id":"75939996","dot_number":"2827961","report_state":"TX","report_number":"6AHH9DJN0N","insp_date":"2022-04-28 00:00:00","insp_start_time":"1703","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  RANKIN 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-06-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"8696888","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02827961","upload_search_indicator":"M","census_search_date":"2022-06-28 21:43:00","snet_input_date":"2022-04-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-28 21:43:00","insp_carrier_name":"DEYANIRA CANTU LOPEZ","insp_carrier_street":"8115 INDIAN SPRING TRAILS","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77050","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0207438","created_at":"2025-03-17T18:40:12.000000Z","updated_at":"2025-03-17T18:40:12.000000Z","inspection_violations":[{"id":1117958,"change_date":"2022-06-28 21:43:00","inspection_id":"75939996","insp_violation_id":"246771792","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189506791","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"39617C"},{"id":1117959,"change_date":"2022-06-28 21:43:00","inspection_id":"75939996","insp_violation_id":"246771793","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189506791","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1143421,"change_date":"2022-06-28 21:43:00","inspection_id":"75939996","insp_unit_id":"189506791","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"46562U7","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS1DHFH7525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:13.000000Z","updated_at":"2025-03-17T22:15:13.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2827961\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2827961\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2827961\/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\/2827961\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}