{"current_page":1,"data":[{"id":11577672,"change_date":"2026-04-06 21:38:00","inspection_id":"87501950","dot_number":"3254716","report_state":"TX","report_number":"7EC79DBAD8","insp_date":"2026-04-02 00:00:00","insp_start_time":"0715","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1900  ALDINE BENDER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE SERVICE PROVIDERS INC","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-04-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9907916","transaction_code":"A","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2026-04-06 21:38:00","snet_input_date":"2026-04-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-06 21:38:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2026-04-09T09:49:15.000000Z","updated_at":"2026-04-17T09:41:52.000000Z","inspection_violations":[{"id":19574570,"change_date":"2026-04-06 21:38:00","inspection_id":"87501950","insp_violation_id":"272896813","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"212567276","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-08T10:13:37.000000Z","updated_at":"2026-04-18T10:39:15.000000Z","normalized_code":"393134"},{"id":19574571,"change_date":"2026-04-06 21:38:00","inspection_id":"87501950","insp_violation_id":"272896814","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"212567276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:37.000000Z","updated_at":"2026-04-18T10:39:15.000000Z","normalized_code":"39345B2UV"},{"id":19574572,"change_date":"2026-04-06 21:38:00","inspection_id":"87501950","insp_violation_id":"272896815","seq_no":"3","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"212567276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:37.000000Z","updated_at":"2026-04-18T10:39:16.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":19843068,"change_date":"2026-04-06 21:38:00","inspection_id":"87501950","insp_unit_id":"212567276","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"201","insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:43:05.000000Z","updated_at":"2026-04-18T09:26:45.000000Z"}]},{"id":11408380,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","dot_number":"3254716","report_state":"TX","report_number":"7DT79DJMGQ","insp_date":"2026-03-14 00:00:00","insp_start_time":"0709","insp_end_time":"0728","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8500  CITY PARK LOOP","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE","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-03-18 21:38: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":"9887856","transaction_code":"A","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2026-03-18 21:38:00","snet_input_date":"2026-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-18 21:38:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2026-03-21T09:47:03.000000Z","updated_at":"2026-03-29T09:32:13.000000Z","inspection_violations":[{"id":19237051,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","insp_violation_id":"272479691","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"212203726","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:44.000000Z","updated_at":"2026-03-29T09:58:12.000000Z","normalized_code":"39355D1"},{"id":19237052,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","insp_violation_id":"272479692","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212203726","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:44.000000Z","updated_at":"2026-03-29T09:58:12.000000Z","normalized_code":"3939"},{"id":19237053,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","insp_violation_id":"272479693","seq_no":"3","part_no":"393","part_no_section":"75B","insp_viol_unit":"1","insp_unit_id":"212203726","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:44.000000Z","updated_at":"2026-03-29T09:58:12.000000Z","normalized_code":"39375B"},{"id":19237054,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","insp_violation_id":"272479694","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212203726","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:44.000000Z","updated_at":"2026-03-29T09:58:12.000000Z","normalized_code":"39617C"},{"id":19237055,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","insp_violation_id":"272479695","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212203726","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:44.000000Z","updated_at":"2026-03-29T09:58:12.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19541189,"change_date":"2026-03-18 21:38:00","inspection_id":"87323746","insp_unit_id":"212203726","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"203","insp_unit_license":"XVK2045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C49M005795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:22.000000Z","updated_at":"2026-03-29T09:18:49.000000Z"}]},{"id":10057430,"change_date":"2025-10-28 21:40:00","inspection_id":"86170611","dot_number":"3254716","report_state":"TX","report_number":"79U79DCPGG","insp_date":"2025-10-22 00:00:00","insp_start_time":"0719","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-28 21:40: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":"9739098","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2025-10-28 21:40:00","snet_input_date":"2025-10-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-28 21:40:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-11-01T10:02:05.000000Z","updated_at":"2025-11-01T10:02:05.000000Z","inspection_violations":[{"id":16649491,"change_date":"2025-10-28 21:40:00","inspection_id":"86170611","insp_violation_id":"269570444","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209700030","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:55.000000Z","normalized_code":"3939"},{"id":16649492,"change_date":"2025-10-28 21:40:00","inspection_id":"86170611","insp_violation_id":"269570445","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"209700030","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:55.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":16714981,"change_date":"2025-10-28 21:40:00","inspection_id":"86170611","insp_unit_id":"209700030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"203","insp_unit_license":"TKX1576","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C49M005795","insp_unit_decal":"Y","insp_unit_decal_number":"35652940","created_at":"2025-10-31T09:47:13.000000Z","updated_at":"2025-11-01T09:46:30.000000Z"}]},{"id":9686817,"change_date":"2025-09-15 21:41:00","inspection_id":"85780861","dot_number":"3254716","report_state":"TX","report_number":"78N89DGP5P","insp_date":"2025-09-09 00:00:00","insp_start_time":"0849","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10000  SOUTH FREEWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-15 21:41: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":"9695272","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":"03254716","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[{"id":15886148,"change_date":"2025-09-15 21:41:00","inspection_id":"85780861","insp_violation_id":"268706012","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"208962727","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"3963A1"},{"id":15886149,"change_date":"2025-09-15 21:41:00","inspection_id":"85780861","insp_violation_id":"268706013","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"208962727","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":16033121,"change_date":"2025-09-15 21:41:00","inspection_id":"85780861","insp_unit_id":"208962727","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"203","insp_unit_license":"TKX1576","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C49M005795","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":8940312,"change_date":"2025-06-19 21:37:00","inspection_id":"84995652","dot_number":"3254716","report_state":"TX","report_number":"76689DCA3W","insp_date":"2025-06-12 00:00:00","insp_start_time":"0815","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2900  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":"2025-06-19 21:37: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":"9611316","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2025-06-19 21:37:00","snet_input_date":"2025-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-19 21:37:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-06-22T10:01:16.000000Z","updated_at":"2025-06-23T10:00:34.000000Z","inspection_violations":[{"id":14350474,"change_date":"2025-06-19 21:37:00","inspection_id":"84995652","insp_violation_id":"266938272","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207466834","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:51.000000Z","updated_at":"2025-06-23T10:15:54.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":14652534,"change_date":"2025-06-19 21:37:00","inspection_id":"84995652","insp_unit_id":"207466834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"TKX1576","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C49M005795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:29.000000Z","updated_at":"2025-06-23T09:45:42.000000Z"}]},{"id":8257634,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","dot_number":"3254716","report_state":"TX","report_number":"74079DJV4X","insp_date":"2025-03-26 00:00:00","insp_start_time":"0739","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","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-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9536440","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2025-03-31 21:41:00","snet_input_date":"2025-03-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-31 21:41:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-04-03T10:04:34.000000Z","updated_at":"2025-04-04T10:19:47.000000Z","inspection_violations":[{"id":12970034,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358699","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"3922RG"},{"id":12970035,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358700","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"3922RG"},{"id":12970036,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358701","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"39617C"},{"id":12970037,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358702","seq_no":"4","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"39351"},{"id":12970038,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358703","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"3939TS"},{"id":12970039,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358704","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"3939"},{"id":12970040,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358705","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"3939"},{"id":12970041,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358706","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"3939"},{"id":12970042,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_violation_id":"265358707","seq_no":"9","part_no":"393","part_no_section":"75B","insp_viol_unit":"1","insp_unit_id":"206084585","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:14.000000Z","updated_at":"2025-04-04T10:42:09.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":13363332,"change_date":"2025-03-31 21:41:00","inspection_id":"84275002","insp_unit_id":"206084585","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T10:00:27.000000Z","updated_at":"2025-04-04T10:02:40.000000Z"}]},{"id":6313633,"change_date":"2024-07-25 21:44:00","inspection_id":"82219499","dot_number":"3254716","report_state":"TX","report_number":"6X7D9DBA9Q","insp_date":"2024-07-24 00:00:00","insp_start_time":"1349","insp_end_time":"1405","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":"ACE SERVICE PROVIDERS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54800","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":"9334613","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2024-07-25 21:44:00","snet_input_date":"2024-07-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-25 21:44:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T20:27:52.000000Z","updated_at":"2025-03-17T20:27:52.000000Z","inspection_violations":[{"id":9804162,"change_date":"2024-07-25 21:44:00","inspection_id":"82219499","insp_violation_id":"260851543","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202079154","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9804163,"change_date":"2024-07-25 21:44:00","inspection_id":"82219499","insp_violation_id":"260851544","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202079154","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3939A"},{"id":9804164,"change_date":"2024-07-25 21:44:00","inspection_id":"82219499","insp_violation_id":"260851545","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202079154","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39378"},{"id":9804165,"change_date":"2024-07-25 21:44:00","inspection_id":"82219499","insp_violation_id":"260851546","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202079154","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":10173271,"change_date":"2024-07-25 21:44:00","inspection_id":"82219499","insp_unit_id":"202079154","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"203","insp_unit_license":"TKX1576","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C49M005795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:22.000000Z","updated_at":"2025-03-17T23:28:22.000000Z"}]},{"id":4581373,"change_date":"2024-12-09 21:41:00","inspection_id":"80335452","dot_number":"3254716","report_state":"TX","report_number":"6QS79DCG3C","insp_date":"2023-12-06 00:00:00","insp_start_time":"0714","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-07 21:41: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":"9142643","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2023-12-07 21:41:00","snet_input_date":"2023-12-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-07 21:41:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:53:45.000000Z","updated_at":"2025-03-17T19:53:45.000000Z","inspection_violations":[{"id":7085975,"change_date":"2024-12-09 21:41:00","inspection_id":"80335452","insp_violation_id":"263333446","seq_no":"1","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"204272935","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"39375A1"},{"id":7085976,"change_date":"2024-12-09 21:41:00","inspection_id":"80335452","insp_violation_id":"263333447","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204272935","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"39378"},{"id":7085977,"change_date":"2024-12-09 21:41:00","inspection_id":"80335452","insp_violation_id":"263333448","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204272935","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":7368808,"change_date":"2024-12-09 21:41:00","inspection_id":"80335452","insp_unit_id":"204272935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"TKX1576","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C49M005795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:55.000000Z","updated_at":"2025-03-17T23:01:55.000000Z"}]},{"id":4475676,"change_date":"2023-11-21 21:40:00","inspection_id":"80219217","dot_number":"3254716","report_state":"TX","report_number":"6Q0G9DGTCV","insp_date":"2023-11-08 00:00:00","insp_start_time":"1610","insp_end_time":"1636","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10100  BEAUMONT HWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE WASTE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9129873","transaction_code":"A","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:51:27.000000Z","updated_at":"2025-03-17T19:51:27.000000Z","inspection_violations":[{"id":6928612,"change_date":"2023-11-21 21:40:00","inspection_id":"80219217","insp_violation_id":"256520455","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198172040","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"},{"id":6928613,"change_date":"2023-11-21 21:40:00","inspection_id":"80219217","insp_violation_id":"256520456","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198172040","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7198162,"change_date":"2023-11-21 21:40:00","inspection_id":"80219217","insp_unit_id":"198172040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"201","insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:27.000000Z","updated_at":"2025-03-17T23:00:27.000000Z"}]},{"id":4176281,"change_date":"2023-10-11 21:41:00","inspection_id":"79888457","dot_number":"3254716","report_state":"TX","report_number":"6P6I9DCP7E","insp_date":"2023-10-09 00:00:00","insp_start_time":"1800","insp_end_time":"1815","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15700  EASTEX FWY EA","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9097392","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2023-10-11 21:41:00","snet_input_date":"2023-10-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-11 21:41:00","insp_carrier_name":"ACE SERVICE PROVIDERS INC","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:45:30.000000Z","updated_at":"2025-03-17T19:45:30.000000Z","inspection_violations":[{"id":6465662,"change_date":"2023-10-11 21:41:00","inspection_id":"79888457","insp_violation_id":"255782349","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:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"38323A2"},{"id":6465663,"change_date":"2023-10-11 21:41:00","inspection_id":"79888457","insp_violation_id":"255782350","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:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":6715873,"change_date":"2023-10-11 21:41:00","inspection_id":"79888457","insp_unit_id":"197508199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:19.000000Z","updated_at":"2025-03-17T22:56:19.000000Z"}]},{"id":3368200,"change_date":"2023-06-26 21:41:00","inspection_id":"78985991","dot_number":"3254716","report_state":"TX","report_number":"V231037654","insp_date":"2023-06-20 00:00:00","insp_start_time":"0830","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 @ 730","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"X","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-06-26 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":"9013753","transaction_code":"A","transaction_date":"2023-06-26 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2023-06-26 21:41:00","snet_input_date":"2023-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"ACE WASTE","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:29:45.000000Z","updated_at":"2025-03-17T19:29:45.000000Z","inspection_violations":[{"id":5195603,"change_date":"2023-06-26 21:41:00","inspection_id":"78985991","insp_violation_id":"253710274","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195681587","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:06.000000Z","updated_at":"2025-03-17T21:31:06.000000Z","normalized_code":"39345D"},{"id":5195604,"change_date":"2023-06-26 21:41:00","inspection_id":"78985991","insp_violation_id":"253710275","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195681587","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:06.000000Z","updated_at":"2025-03-17T21:31:06.000000Z","normalized_code":"39360C"},{"id":5195605,"change_date":"2023-06-26 21:41:00","inspection_id":"78985991","insp_violation_id":"253710276","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195681587","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:06.000000Z","updated_at":"2025-03-17T21:31:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5414810,"change_date":"2023-06-26 21:41:00","inspection_id":"78985991","insp_unit_id":"195681587","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"201","insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:42.000000Z","updated_at":"2025-03-17T22:45:42.000000Z"}]},{"id":2461208,"change_date":"2023-02-27 21:42:00","inspection_id":"77958737","dot_number":"3254716","report_state":"TX","report_number":"6IT90XNOCE","insp_date":"2023-02-22 00:00:00","insp_start_time":"0923","insp_end_time":"0942","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1093 IN FORT BEND CO. (646-","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HARDY TRANSFER STATION","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":"2023-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"8914681","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":null,"census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:12:05.000000Z","updated_at":"2025-03-17T19:12:05.000000Z","inspection_violations":[{"id":3788971,"change_date":"2023-02-27 21:42:00","inspection_id":"77958737","insp_violation_id":"251365280","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"193605509","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":3961200,"change_date":"2023-02-27 21:42:00","inspection_id":"77958737","insp_unit_id":"193605509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"201","insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2069172,"change_date":"2023-01-04 21:40:00","inspection_id":"77510870","dot_number":"3254716","report_state":"TX","report_number":"6H089DCI8E","insp_date":"2022-12-19 00:00:00","insp_start_time":"0845","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN HARRIS CO. (806-862","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE","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-01-04 21:40: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":"8867590","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":null,"census_search_date":"2023-01-04 21:40:00","snet_input_date":"2022-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-04 21:40:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:04:45.000000Z","updated_at":"2025-03-17T19:04:45.000000Z","inspection_violations":[{"id":3203570,"change_date":"2023-01-04 21:40:00","inspection_id":"77510870","insp_violation_id":"250391426","seq_no":"1","part_no":"393","part_no_section":"26","insp_viol_unit":"1","insp_unit_id":"192703079","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:12.000000Z","updated_at":"2025-03-17T21:22:12.000000Z","normalized_code":"39326"}],"inspection_per_units":[{"id":3328953,"change_date":"2023-01-04 21:40:00","inspection_id":"77510870","insp_unit_id":"192703079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:49.000000Z","updated_at":"2025-03-17T22:29:49.000000Z"}]},{"id":1949731,"change_date":"2022-12-14 21:40:00","inspection_id":"77374764","dot_number":"3254716","report_state":"TX","report_number":"6GIE9DJNAT","insp_date":"2022-12-01 00:00:00","insp_start_time":"1422","insp_end_time":"1444","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"20500  TOWNSEN BLVD","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-14 21:40: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":"8850846","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":null,"census_search_date":"2022-12-14 21:40:00","snet_input_date":"2022-12-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-14 21:40:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T19:02:34.000000Z","updated_at":"2025-03-17T19:02:34.000000Z","inspection_violations":[{"id":3028222,"change_date":"2022-12-14 21:40:00","inspection_id":"77374764","insp_violation_id":"250105434","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192432772","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3137310,"change_date":"2022-12-14 21:40:00","inspection_id":"77374764","insp_unit_id":"192432772","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"201","insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:29.000000Z","updated_at":"2025-03-17T22:28:29.000000Z"}]},{"id":1554796,"change_date":"2022-10-19 21:42:00","inspection_id":"76921878","dot_number":"3254716","report_state":"TX","report_number":"6F789DGQ7G","insp_date":"2022-10-15 00:00:00","insp_start_time":"0847","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10800  NORTH 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":"2022-10-19 21:42: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":"8805330","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":null,"census_search_date":"2022-10-19 21:42:00","snet_input_date":"2022-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-19 21:42:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T18:55:14.000000Z","updated_at":"2025-03-17T18:55:14.000000Z","inspection_violations":[{"id":2446069,"change_date":"2022-10-19 21:42:00","inspection_id":"76921878","insp_violation_id":"249134357","seq_no":"2","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"191535047","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"39379"},{"id":2446070,"change_date":"2022-10-19 21:42:00","inspection_id":"76921878","insp_violation_id":"249134358","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"191535047","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"393205C"},{"id":2446071,"change_date":"2022-10-19 21:42:00","inspection_id":"76921878","insp_violation_id":"249134359","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"191535047","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":2501989,"change_date":"2022-10-19 21:42:00","inspection_id":"76921878","insp_unit_id":"191535047","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"201","insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:09.000000Z","updated_at":"2025-03-17T22:24:09.000000Z"}]},{"id":1266410,"change_date":"2022-09-22 21:40:00","inspection_id":"76587411","dot_number":"3254716","report_state":"TX","report_number":"6DXE9DJVEC","insp_date":"2022-08-30 00:00:00","insp_start_time":"1431","insp_end_time":"1503","registration_date":"2022-09-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GREENS RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8768630","transaction_code":"C","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2022-09-12 21:43:00","snet_input_date":"2022-08-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-12 21:43:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T18:50:05.000000Z","updated_at":"2025-03-17T18:50:05.000000Z","inspection_violations":[{"id":2004996,"change_date":"2022-09-22 21:40:00","inspection_id":"76587411","insp_violation_id":"248593621","seq_no":"2","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"191050813","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"393205A"}],"inspection_per_units":[{"id":2037977,"change_date":"2022-09-22 21:40:00","inspection_id":"76587411","insp_unit_id":"191050813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PWF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"WVGAV7AX0BW507695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:00.000000Z","updated_at":"2025-03-17T22:21:00.000000Z"}]},{"id":1172695,"change_date":"2022-09-22 21:40:00","inspection_id":"76478969","dot_number":"3254716","report_state":"TX","report_number":"6DKF9DCNMS","insp_date":"2022-08-17 00:00:00","insp_start_time":"1521","insp_end_time":"1603","registration_date":"2022-09-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE WASTE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-30 21:41: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":"8756606","transaction_code":"C","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2022-08-30 21:41:00","snet_input_date":"2022-08-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-30 21:41:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T18:48:19.000000Z","updated_at":"2025-03-17T18:48:19.000000Z","inspection_violations":[{"id":1860002,"change_date":"2022-09-22 21:40:00","inspection_id":"76478969","insp_violation_id":"248594561","seq_no":"1","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"191051273","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:37.000000Z","updated_at":"2025-03-17T21:15:37.000000Z","normalized_code":"393203C"},{"id":1860003,"change_date":"2022-09-22 21:40:00","inspection_id":"76478969","insp_violation_id":"248594562","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191051273","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:37.000000Z","updated_at":"2025-03-17T21:15:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1885939,"change_date":"2022-09-22 21:40:00","inspection_id":"76478969","insp_unit_id":"191051273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:58.000000Z","updated_at":"2025-03-17T22:19:58.000000Z"}]},{"id":181209,"change_date":"2022-04-22 21:46:00","inspection_id":"75309257","dot_number":"3254716","report_state":"TX","report_number":"6A2E9DCP8Y","insp_date":"2022-04-13 00:00:00","insp_start_time":"1445","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3600  GAGER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-04-14 21:43: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":"8623833","transaction_code":"C","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03254716","upload_search_indicator":"M","census_search_date":"2022-04-14 21:43:00","snet_input_date":"2022-04-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-14 21:43:00","insp_carrier_name":"JOSE PORTILLO","insp_carrier_street":"18335 DESERT MARIGOLD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77073-4489","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0969946","created_at":"2025-03-17T18:30:49.000000Z","updated_at":"2025-03-17T18:30:49.000000Z","inspection_violations":[{"id":277079,"change_date":"2022-04-22 21:46:00","inspection_id":"75309257","insp_violation_id":"245331764","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188303120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:18.000000Z","updated_at":"2025-03-17T21:08:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":293868,"change_date":"2022-04-22 21:46:00","inspection_id":"75309257","insp_unit_id":"188303120","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PMF5888","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2P270CX2M063951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3254716\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3254716\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3254716\/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\/3254716\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}