{"current_page":1,"data":[{"id":12584747,"change_date":"2026-07-29 21:42:00","inspection_id":"88553492","dot_number":"2025658","report_state":"TX","report_number":"V262489975","insp_date":"2026-07-25 00:00:00","insp_start_time":"0905","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"W SAM HOUSTON PARKWA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND & CLAY","shipping_paper_number":"70233481","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"10049324","transaction_code":"A","transaction_date":"2026-07-29 00:00:00","upload_date":"2026-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2026-07-29 21:42:00","snet_input_date":"2026-07-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-29 21:42:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2026-08-01T09:41:45.000000Z","updated_at":"2026-08-09T09:31:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21850012,"change_date":"2026-07-29 21:42:00","inspection_id":"88553492","insp_unit_id":"214886522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3115","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:56.000000Z","updated_at":"2026-08-09T09:03:58.000000Z"}]},{"id":12573615,"change_date":"2026-07-28 21:42:00","inspection_id":"88541761","dot_number":"2025658","report_state":"TX","report_number":"V262484456","insp_date":"2026-07-24 00:00:00","insp_start_time":"1415","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"490M TX288 SB","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"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":"2026-07-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10047816","transaction_code":"A","transaction_date":"2026-07-28 00:00:00","upload_date":"2026-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2026-07-28 21:42:00","snet_input_date":"2026-07-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-28 21:42:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2026-07-31T09:41:37.000000Z","updated_at":"2026-08-08T09:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21831689,"change_date":"2026-07-28 21:42:00","inspection_id":"88541761","insp_unit_id":"214864885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1778","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:26.000000Z","updated_at":"2026-08-08T09:03:43.000000Z"}]},{"id":11999394,"change_date":"2026-05-22 21:38:00","inspection_id":"87937777","dot_number":"2025658","report_state":"TX","report_number":"7FM89DBQF7","insp_date":"2026-05-18 00:00:00","insp_start_time":"0758","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3500  BROADWAY ST","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT","shipping_paper_number":"68043132","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-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9965674","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2026-05-25T09:41:20.000000Z","updated_at":"2026-06-02T09:32:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20859414,"change_date":"2026-05-22 21:38:00","inspection_id":"87937777","insp_unit_id":"213715928","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1778","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:34.000000Z","updated_at":"2026-06-02T09:06:21.000000Z"}]},{"id":9300318,"change_date":"2025-07-31 21:41:00","inspection_id":"85374875","dot_number":"2025658","report_state":"TX","report_number":"V251966735","insp_date":"2025-07-29 00:00:00","insp_start_time":"1101","insp_end_time":"1124","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14522  FM521","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9652724","transaction_code":"A","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2025-07-31 21:41:00","snet_input_date":"2025-07-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-31 21:41:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2025-08-04T10:01:35.000000Z","updated_at":"2025-08-04T10:01:35.000000Z","inspection_violations":[{"id":15085327,"change_date":"2025-07-31 21:41:00","inspection_id":"85374875","insp_violation_id":"267776707","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208183475","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-03T10:45:10.000000Z","updated_at":"2025-08-04T10:45:41.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":15314508,"change_date":"2025-07-31 21:41:00","inspection_id":"85374875","insp_unit_id":"208183475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1778","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-03T09:46:27.000000Z","updated_at":"2025-08-04T09:46:11.000000Z"}]},{"id":7221800,"change_date":"2024-11-18 21:41:00","inspection_id":"83185955","dot_number":"2025658","report_state":"TX","report_number":"70689DAWJW","insp_date":"2024-11-08 00:00:00","insp_start_time":"0852","insp_end_time":"0918","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","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-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9429380","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2025-03-17T20:46:47.000000Z","updated_at":"2025-03-17T20:46:47.000000Z","inspection_violations":[{"id":11287912,"change_date":"2024-11-18 21:41:00","inspection_id":"83185955","insp_violation_id":"262959623","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203937885","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39347E"},{"id":11287913,"change_date":"2024-11-18 21:41:00","inspection_id":"83185955","insp_violation_id":"262959624","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203937885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":11648939,"change_date":"2024-11-18 21:41:00","inspection_id":"83185955","insp_unit_id":"203937885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":5898378,"change_date":"2024-06-03 21:42:00","inspection_id":"81772122","dot_number":"2025658","report_state":"TX","report_number":"6VG89DHP7Q","insp_date":"2024-05-23 00:00:00","insp_start_time":"0945","insp_end_time":"1004","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0270 IN GALVESTON CO. (698-","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":"2024-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9290209","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2025-03-17T20:19:30.000000Z","updated_at":"2025-03-17T20:19:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9500310,"change_date":"2024-06-03 21:42:00","inspection_id":"81772122","insp_unit_id":"201203832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:34.000000Z","updated_at":"2025-03-17T23:21:34.000000Z"}]},{"id":5758052,"change_date":"2024-08-29 21:43:00","inspection_id":"81619911","dot_number":"2025658","report_state":"TX","report_number":"6UZA9DTG0U","insp_date":"2024-05-08 00:00:00","insp_start_time":"0742","insp_end_time":"0801","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN GALVESTON CO. (502-","county_code_state":"TX","county_code":"167","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9273496","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2025-03-17T20:16:44.000000Z","updated_at":"2025-03-17T20:16:44.000000Z","inspection_violations":[{"id":8913128,"change_date":"2024-08-29 21:43:00","inspection_id":"81619911","insp_violation_id":"261505459","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202665337","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9274308,"change_date":"2024-08-29 21:43:00","inspection_id":"81619911","insp_unit_id":"202665337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3115","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5462173,"change_date":"2024-04-08 21:44:00","inspection_id":"81297502","dot_number":"2025658","report_state":"TX","report_number":"V241354423","insp_date":"2024-04-03 00:00:00","insp_start_time":"0945","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6  \/ HURRICANE LA","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-08 21:44: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":"9243321","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2024-04-08 21:44:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2025-03-17T20:11:07.000000Z","updated_at":"2025-03-17T20:11:07.000000Z","inspection_violations":[{"id":8434015,"change_date":"2024-04-08 21:44:00","inspection_id":"81297502","insp_violation_id":"258811382","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200293835","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39347E"},{"id":8434016,"change_date":"2024-04-08 21:44:00","inspection_id":"81297502","insp_violation_id":"258811383","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200293835","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8798574,"change_date":"2024-04-08 21:44:00","inspection_id":"81297502","insp_unit_id":"200293835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1778","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"}]},{"id":4634512,"change_date":"2024-12-06 21:44:00","inspection_id":"80393825","dot_number":"2025658","report_state":"TX","report_number":"6QT99DCOYF","insp_date":"2023-12-07 00:00:00","insp_start_time":"0954","insp_end_time":"1007","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7700  RED ROBIN LN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND AND CLAY","shipping_paper_number":"70124461","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9146695","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02025658","upload_search_indicator":"M","census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"DAVID VILLARREAL","insp_carrier_street":"4106 CR 190","insp_carrier_city":"ROSHARON","insp_carrier_state":"TX","insp_carrier_zip_code":"77583","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0257138","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[{"id":7163674,"change_date":"2024-12-06 21:44:00","inspection_id":"80393825","insp_violation_id":"263293801","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204235561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3939"},{"id":7163675,"change_date":"2024-12-06 21:44:00","inspection_id":"80393825","insp_violation_id":"263293802","seq_no":"2","part_no":"396","part_no_section":"3A1-TC","insp_viol_unit":"1","insp_unit_id":"204235561","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3963A1TC"}],"inspection_per_units":[{"id":7454122,"change_date":"2024-12-06 21:44:00","inspection_id":"80393825","insp_unit_id":"204235561","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3115","insp_unit_license":"KFK7258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X7SN363115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2025658\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2025658\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2025658\/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\/2025658\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}