{"current_page":1,"data":[{"id":8828591,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","dot_number":"3283740","report_state":"TX","report_number":"75SB9DNA8J","insp_date":"2025-05-29 00:00:00","insp_start_time":"1100","insp_end_time":"1200","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"3003157","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-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9599657","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-05-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-06-09T10:01:07.000000Z","updated_at":"2025-06-09T10:01:07.000000Z","inspection_violations":[{"id":14132665,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_violation_id":"266689769","seq_no":"1","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"207248835","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:19.000000Z","normalized_code":"39381"},{"id":14132666,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_violation_id":"266689770","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207248835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:19.000000Z","normalized_code":"3939"},{"id":14132667,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_violation_id":"266689771","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207248835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:19.000000Z","normalized_code":"3939"},{"id":14132668,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_violation_id":"266689772","seq_no":"4","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"207248835","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:19.000000Z","normalized_code":"39347A"},{"id":14132669,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_violation_id":"266689773","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207248835","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:19.000000Z","normalized_code":"39347E"},{"id":14132670,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_violation_id":"266689774","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207248835","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:03.000000Z","updated_at":"2025-06-09T10:16:19.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":14454254,"change_date":"2025-06-05 21:41:00","inspection_id":"84877009","insp_unit_id":"207248835","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"WFZ3533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:28.000000Z","updated_at":"2025-06-09T09:46:00.000000Z"}]},{"id":8759545,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","dot_number":"3283740","report_state":"TX","report_number":"75MA9DNO4S","insp_date":"2025-05-23 00:00:00","insp_start_time":"1044","insp_end_time":"1134","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"9591463","transaction_code":"C","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-05-31T10:01:39.000000Z","updated_at":"2025-06-04T10:01:09.000000Z","inspection_violations":[{"id":14035091,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_violation_id":"266579651","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207154153","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:16.000000Z","updated_at":"2025-06-03T10:17:39.000000Z","normalized_code":"39347E"},{"id":14035092,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_violation_id":"266579652","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207154153","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:16.000000Z","updated_at":"2025-06-03T10:17:39.000000Z","normalized_code":"39353B"},{"id":14035093,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_violation_id":"266579653","seq_no":"3","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"207154153","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:16.000000Z","updated_at":"2025-06-03T10:17:39.000000Z","normalized_code":"39383G"},{"id":14035094,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_violation_id":"266579654","seq_no":"4","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207154153","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:16.000000Z","updated_at":"2025-06-03T10:17:39.000000Z","normalized_code":"39345B2UV"},{"id":14035095,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_violation_id":"266579655","seq_no":"5","part_no":"393","part_no_section":"201D","insp_viol_unit":"2","insp_unit_id":"207154154","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:16.000000Z","updated_at":"2025-06-03T10:17:39.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":14365958,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_unit_id":"207154153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"717","insp_unit_license":"1M19673","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X05J095816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:23.000000Z","updated_at":"2025-06-03T09:45:54.000000Z"},{"id":14365959,"change_date":"2025-05-30 21:41:00","inspection_id":"84803837","insp_unit_id":"207154154","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"207B812","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B1YM000341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:23.000000Z","updated_at":"2025-06-03T09:45:54.000000Z"}]},{"id":8690897,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","dot_number":"3283740","report_state":"TX","report_number":"75CB9DNO41","insp_date":"2025-05-13 00:00:00","insp_start_time":"1108","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9583965","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-05-23T10:04:24.000000Z","updated_at":"2025-05-24T10:06:02.000000Z","inspection_violations":[{"id":13848229,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357312","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"39021A"},{"id":13848230,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357313","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"3922RG"},{"id":13848231,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357314","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"3939H"},{"id":13848232,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357315","seq_no":"4","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"39375A1"},{"id":13848233,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357316","seq_no":"5","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"39375A1"},{"id":13848234,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357317","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"3939"},{"id":13848235,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357318","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"3939"},{"id":13848236,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357319","seq_no":"8","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"3965BHWSLIW"},{"id":13848237,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357320","seq_no":"9","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"3965B"},{"id":13848238,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_violation_id":"266357321","seq_no":"10","part_no":"393","part_no_section":"47D","insp_viol_unit":"1","insp_unit_id":"206970850","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:47.000000Z","normalized_code":"39347D"}],"inspection_per_units":[{"id":14200136,"change_date":"2025-05-20 21:41:00","inspection_id":"84731191","insp_unit_id":"206970850","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"818","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:15.000000Z","updated_at":"2025-05-24T09:51:33.000000Z"}]},{"id":8632826,"change_date":"2025-05-14 21:42:00","inspection_id":"84670012","dot_number":"3283740","report_state":"TX","report_number":"75779DIA1H","insp_date":"2025-05-08 00:00:00","insp_start_time":"0747","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2300  SOUTH LOOP W","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE","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-05-14 21:42: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":"9577270","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-05-17T10:05:22.000000Z","updated_at":"2025-05-18T10:06:18.000000Z","inspection_violations":[{"id":13728277,"change_date":"2025-05-14 21:42:00","inspection_id":"84670012","insp_violation_id":"266222942","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"206858954","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:33:58.000000Z","normalized_code":"39375C"},{"id":13728278,"change_date":"2025-05-14 21:42:00","inspection_id":"84670012","insp_violation_id":"266222943","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206858954","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:33:58.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":14096536,"change_date":"2025-05-14 21:42:00","inspection_id":"84670012","insp_unit_id":"206858954","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:19.000000Z","updated_at":"2025-05-18T09:51:54.000000Z"}]},{"id":8607803,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","dot_number":"3283740","report_state":"TX","report_number":"75479DCGRH","insp_date":"2025-05-05 00:00:00","insp_start_time":"0650","insp_end_time":"0725","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  CAVALCADE","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-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"63000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9573157","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-05-12 21:41:00","snet_input_date":"2025-05-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-12 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-05-15T10:01:19.000000Z","updated_at":"2025-05-17T10:06:02.000000Z","inspection_violations":[{"id":13678584,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_violation_id":"266167362","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206811491","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:57.000000Z","updated_at":"2025-05-16T10:28:28.000000Z","normalized_code":"39347E"},{"id":13678585,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_violation_id":"266167363","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206811491","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:57.000000Z","updated_at":"2025-05-16T10:28:28.000000Z","normalized_code":"39347E"},{"id":13678586,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_violation_id":"266167364","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206811491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:57.000000Z","updated_at":"2025-05-16T10:28:28.000000Z","normalized_code":"39353B"},{"id":13678587,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_violation_id":"266167365","seq_no":"4","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"206811491","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:57.000000Z","updated_at":"2025-05-16T10:28:28.000000Z","normalized_code":"3963A1BOS"},{"id":13678588,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_violation_id":"266167366","seq_no":"5","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"206811491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:57.000000Z","updated_at":"2025-05-16T10:28:28.000000Z","normalized_code":"3963A1B"},{"id":13678589,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_violation_id":"266167367","seq_no":"6","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206811491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:57.000000Z","updated_at":"2025-05-16T10:28:29.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":14052345,"change_date":"2025-05-12 21:41:00","inspection_id":"84643783","insp_unit_id":"206811491","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:21.000000Z","updated_at":"2025-05-16T09:51:26.000000Z"}]},{"id":8463335,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","dot_number":"3283740","report_state":"TX","report_number":"V251835659","insp_date":"2025-04-15 00:00:00","insp_start_time":"1252","insp_end_time":"1342","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KICKAPOO ROAD NEAR U","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","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-04-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"11","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9560484","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-04-24 21:38:00","snet_input_date":"2025-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-24 21:38:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-04-27T10:28:36.000000Z","updated_at":"2025-04-28T10:12:56.000000Z","inspection_violations":[{"id":13379248,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821293","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:28.000000Z","normalized_code":"39347E"},{"id":13379249,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821294","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:28.000000Z","normalized_code":"39353B"},{"id":13379250,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821295","seq_no":"3","part_no":"393","part_no_section":"60E-WS","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"39360EWS"},{"id":13379251,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821296","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"39378"},{"id":13379252,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821297","seq_no":"5","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"39381"},{"id":13379253,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821298","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"3939"},{"id":13379254,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821299","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"3939"},{"id":13379255,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821300","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"3939"},{"id":13379256,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821301","seq_no":"9","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"39395B"},{"id":13379257,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821302","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"39617C"},{"id":13379258,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_violation_id":"265821303","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206480143","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:08:23.000000Z","updated_at":"2025-04-28T10:33:29.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13749687,"change_date":"2025-04-24 21:38:00","inspection_id":"84491690","insp_unit_id":"206480143","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"WFZ3533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:19:04.000000Z","updated_at":"2025-04-28T10:01:43.000000Z"}]},{"id":8321123,"change_date":"2025-04-09 21:41:00","inspection_id":"84341720","dot_number":"3283740","report_state":"TX","report_number":"749B9DGAA9","insp_date":"2025-04-04 00:00:00","insp_start_time":"1148","insp_end_time":"1247","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":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"1002454","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-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9543671","transaction_code":"C","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-04-11T10:12:23.000000Z","updated_at":"2025-04-14T10:24:59.000000Z","inspection_violations":[{"id":13112963,"change_date":"2025-04-09 21:41:00","inspection_id":"84341720","insp_violation_id":"265524159","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206227875","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:51:45.000000Z","updated_at":"2025-04-12T10:43:40.000000Z","normalized_code":"39617C"},{"id":13112964,"change_date":"2025-04-09 21:41:00","inspection_id":"84341720","insp_violation_id":"265524160","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"206227875","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:51:45.000000Z","updated_at":"2025-04-12T10:43:40.000000Z","normalized_code":"39360D"},{"id":13112965,"change_date":"2025-04-09 21:41:00","inspection_id":"84341720","insp_violation_id":"265524161","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"206227875","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:51:45.000000Z","updated_at":"2025-04-12T10:43:40.000000Z","normalized_code":"39330"},{"id":13112966,"change_date":"2025-04-09 21:41:00","inspection_id":"84341720","insp_violation_id":"265524162","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206227875","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-11T10:51:45.000000Z","updated_at":"2025-04-12T10:43:40.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":13512336,"change_date":"2025-04-09 21:41:00","inspection_id":"84341720","insp_unit_id":"206227875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-883","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-12T10:10:49.000000Z","updated_at":"2025-04-13T10:01:53.000000Z"}]},{"id":8320939,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","dot_number":"3283740","report_state":"TX","report_number":"74589DTG9K","insp_date":"2025-03-31 00:00:00","insp_start_time":"0836","insp_end_time":"1010","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":"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-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9543440","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-04-11T10:12:23.000000Z","updated_at":"2025-04-12T10:22:20.000000Z","inspection_violations":[{"id":13094830,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500106","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206205917","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39617C"},{"id":13094831,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500107","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"206205918","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39617C"},{"id":13094832,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500108","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206205917","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39375A3"},{"id":13094833,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500109","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206205917","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39375A3"},{"id":13094834,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500110","seq_no":"5","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"206205917","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39311TL"},{"id":13094835,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500111","seq_no":"6","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"206205917","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39311TU"},{"id":13094836,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500112","seq_no":"7","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"2","insp_unit_id":"206205918","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"3965BHWSLIW"},{"id":13094837,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500113","seq_no":"8","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"2","insp_unit_id":"206205918","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"3965BHWSLIW"},{"id":13094838,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500114","seq_no":"9","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"2","insp_unit_id":"206205918","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"3965BHWSLIW"},{"id":13094839,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_violation_id":"265500115","seq_no":"10","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"206205918","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:22.000000Z","updated_at":"2025-04-11T10:48:46.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":13495264,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_unit_id":"206205917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7171","insp_unit_license":"1M19673","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X05J095816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:05:48.000000Z","updated_at":"2025-04-12T10:01:10.000000Z"},{"id":13495265,"change_date":"2025-04-08 21:40:00","inspection_id":"84341523","insp_unit_id":"206205918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"207B812","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B1YM000341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:05:48.000000Z","updated_at":"2025-04-12T10:01:10.000000Z"}]},{"id":8122306,"change_date":"2025-03-14 21:41:00","inspection_id":"84132448","dot_number":"3283740","report_state":"TX","report_number":"73899DJV28","insp_date":"2025-02-26 00:00:00","insp_start_time":"0930","insp_end_time":"1002","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":"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-14 21:41: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":"9522821","transaction_code":"A","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-03-14 21:41:00","snet_input_date":"2025-02-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-14 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T21:07:03.000000Z","updated_at":"2025-03-17T21:07:03.000000Z","inspection_violations":[{"id":12701518,"change_date":"2025-03-14 21:41:00","inspection_id":"84132448","insp_violation_id":"265053263","seq_no":"1","part_no":"393","part_no_section":"205A","insp_viol_unit":"1","insp_unit_id":"205813425","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:08:14.000000Z","updated_at":"2025-03-17T22:08:14.000000Z","normalized_code":"393205A"}],"inspection_per_units":[{"id":13114256,"change_date":"2025-03-14 21:41:00","inspection_id":"84132448","insp_unit_id":"205813425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:58.000000Z","updated_at":"2025-03-17T23:59:58.000000Z"}]},{"id":7946085,"change_date":"2025-02-24 21:40:00","inspection_id":"83947229","dot_number":"3283740","report_state":"TX","report_number":"72V79DGA7V","insp_date":"2025-02-13 00:00:00","insp_start_time":"0758","insp_end_time":"0856","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":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9505230","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[{"id":12415041,"change_date":"2025-02-24 21:40:00","inspection_id":"83947229","insp_violation_id":"264667988","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205471222","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39395F"},{"id":12415042,"change_date":"2025-02-24 21:40:00","inspection_id":"83947229","insp_violation_id":"264667989","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205471222","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39360C"},{"id":12415043,"change_date":"2025-02-24 21:40:00","inspection_id":"83947229","insp_violation_id":"264667990","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205471222","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39347E"},{"id":12415044,"change_date":"2025-02-24 21:40:00","inspection_id":"83947229","insp_violation_id":"264667991","seq_no":"4","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"205471222","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":12827300,"change_date":"2025-02-24 21:40:00","inspection_id":"83947229","insp_unit_id":"205471222","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"V-546","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":7896044,"change_date":"2025-02-18 21:40:00","inspection_id":"83894765","dot_number":"3283740","report_state":"TX","report_number":"72UF9DJX1Y","insp_date":"2025-02-12 00:00:00","insp_start_time":"1538","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"61000","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":"9499560","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12745366,"change_date":"2025-02-18 21:40:00","inspection_id":"83894765","insp_unit_id":"205374820","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"}]},{"id":7911963,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","dot_number":"3283740","report_state":"TX","report_number":"72UB9DGBMK","insp_date":"2025-02-12 00:00:00","insp_start_time":"1022","insp_end_time":"1137","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":"2025-02-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9502125","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T21:02:23.000000Z","updated_at":"2025-03-17T21:02:23.000000Z","inspection_violations":[{"id":12360545,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597168","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"39378"},{"id":12360546,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597169","seq_no":"2","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"39381"},{"id":12360547,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597170","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"3939"},{"id":12360548,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597171","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"39347E"},{"id":12360549,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597172","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"39353B"},{"id":12360550,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597173","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"3922RG"},{"id":12360551,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597174","seq_no":"8","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"39375GLOAD"},{"id":12360552,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597175","seq_no":"9","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"3922W"},{"id":12360553,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_violation_id":"264597176","seq_no":"10","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"205405431","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:23.000000Z","updated_at":"2025-03-17T22:06:23.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12771548,"change_date":"2025-02-19 21:41:00","inspection_id":"83911428","insp_unit_id":"205405431","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"RXS7614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7845087,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","dot_number":"3283740","report_state":"TX","report_number":"72L79DJM1V","insp_date":"2025-02-03 00:00:00","insp_start_time":"0739","insp_end_time":"0840","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":"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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"11","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9494544","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[{"id":12258714,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465062","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39347E"},{"id":12258715,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465063","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39353B"},{"id":12258716,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465064","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922RG"},{"id":12258717,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465065","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922RG"},{"id":12258718,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465066","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922RG"},{"id":12258719,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465067","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922RG"},{"id":12258720,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465068","seq_no":"9","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39381"},{"id":12258721,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465069","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39378"},{"id":12258722,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465070","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3939"},{"id":12258723,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465071","seq_no":"12","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39311"},{"id":12258724,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_violation_id":"264465072","seq_no":"13","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"205275829","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":12661358,"change_date":"2025-02-11 21:40:00","inspection_id":"83841332","insp_unit_id":"205275829","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"RXS7614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7775124,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","dot_number":"3283740","report_state":"TX","report_number":"72FC9DKYB6","insp_date":"2025-01-28 00:00:00","insp_start_time":"1218","insp_end_time":"1318","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":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"321613","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-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"8","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9487954","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-01-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[{"id":12149491,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313468","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205135308","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39021A"},{"id":12149492,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313469","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205135308","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39021A"},{"id":12149493,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313470","seq_no":"4","part_no":"393","part_no_section":"55D3","insp_viol_unit":"2","insp_unit_id":"205135309","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39355D3"},{"id":12149494,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313471","seq_no":"6","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":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922W"},{"id":12149495,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313472","seq_no":"7","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"205135308","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39382"},{"id":12149496,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313473","seq_no":"8","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205135308","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39311TL"},{"id":12149497,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313474","seq_no":"9","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"205135308","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39311TU"},{"id":12149498,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_violation_id":"264313475","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205135308","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12548100,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_unit_id":"205135308","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"0","insp_unit_license":"1M19673","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X05J095816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"},{"id":12548101,"change_date":"2025-02-03 21:39:00","inspection_id":"83767827","insp_unit_id":"205135309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"0","insp_unit_license":"207B812","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B1YM000341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":7618612,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","dot_number":"3283740","report_state":"TX","report_number":"V251731944","insp_date":"2025-01-13 00:00:00","insp_start_time":"1211","insp_end_time":"1238","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SAM HOUSTON TLWY EB","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"318603","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-14 21:55: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":"9473787","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2025-01-14 21:55:00","snet_input_date":"2025-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-14 21:55:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:56:10.000000Z","updated_at":"2025-03-17T20:56:10.000000Z","inspection_violations":[{"id":11910059,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","insp_violation_id":"264002057","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204833207","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"39021A"},{"id":11910060,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","insp_violation_id":"264002058","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204833207","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3939"},{"id":11910061,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","insp_violation_id":"264002059","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204833207","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3939"},{"id":11910062,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","insp_violation_id":"264002060","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204833207","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3939"},{"id":11910063,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","insp_violation_id":"264002061","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204833207","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12293069,"change_date":"2025-01-14 21:55:00","inspection_id":"83603363","insp_unit_id":"204833207","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:40.000000Z","updated_at":"2025-03-17T23:50:40.000000Z"}]},{"id":7520096,"change_date":"2024-12-30 21:39:00","inspection_id":"83499851","dot_number":"3283740","report_state":"TX","report_number":"71FF9DBC76","insp_date":"2024-12-23 00:00:00","insp_start_time":"1527","insp_end_time":"1540","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"318001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9460985","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[{"id":11753028,"change_date":"2024-12-30 21:39:00","inspection_id":"83499851","insp_violation_id":"263696684","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":12132214,"change_date":"2024-12-30 21:39:00","inspection_id":"83499851","insp_unit_id":"204595020","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"}]},{"id":7329800,"change_date":"2024-12-03 21:40:00","inspection_id":"83299914","dot_number":"3283740","report_state":"TX","report_number":"70GA9DGPFJ","insp_date":"2024-11-18 00:00:00","insp_start_time":"1008","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST 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":"2024-12-03 21:40: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":"9441630","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-11-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11460712,"change_date":"2024-12-03 21:40:00","inspection_id":"83299914","insp_violation_id":"263202530","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204156829","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39021A"},{"id":11460713,"change_date":"2024-12-03 21:40:00","inspection_id":"83299914","insp_violation_id":"263202531","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"204156829","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":11824269,"change_date":"2024-12-03 21:40:00","inspection_id":"83299914","insp_unit_id":"204156829","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7186348,"change_date":"2024-11-14 21:41:00","inspection_id":"83148397","dot_number":"3283740","report_state":"TX","report_number":"V241685393","insp_date":"2024-11-11 00:00:00","insp_start_time":"1030","insp_end_time":"1102","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM523 AT SH35","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":"2024-11-13 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":"9427070","transaction_code":"C","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-03-17T20:46:00.000000Z","inspection_violations":[{"id":11231317,"change_date":"2024-11-14 21:41:00","inspection_id":"83148397","insp_violation_id":"262899831","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"203884827","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":11591390,"change_date":"2024-11-14 21:41:00","inspection_id":"83148397","insp_unit_id":"203884827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"}]},{"id":7015681,"change_date":"2024-10-22 21:42:00","inspection_id":"82967492","dot_number":"3283740","report_state":"TX","report_number":"V241655475","insp_date":"2024-10-19 00:00:00","insp_start_time":"1350","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH69 NB SVC RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"314055","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"63500","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":"9409127","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-10-22 21:42:00","snet_input_date":"2024-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-22 21:42:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:42:18.000000Z","updated_at":"2025-03-17T20:42:18.000000Z","inspection_violations":[{"id":10948084,"change_date":"2024-10-22 21:42:00","inspection_id":"82967492","insp_violation_id":"262490118","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"203528288","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39330"},{"id":10948085,"change_date":"2024-10-22 21:42:00","inspection_id":"82967492","insp_violation_id":"262490119","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"203528288","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39360D"},{"id":10948086,"change_date":"2024-10-22 21:42:00","inspection_id":"82967492","insp_violation_id":"262490120","seq_no":"3","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"203528288","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":11315663,"change_date":"2024-10-22 21:42:00","inspection_id":"82967492","insp_unit_id":"203528288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"108","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:11.000000Z","updated_at":"2025-03-17T23:40:11.000000Z"}]},{"id":6770967,"change_date":"2024-09-20 21:43:00","inspection_id":"82707172","dot_number":"3283740","report_state":"TX","report_number":"6XZF9DBVRU","insp_date":"2024-08-21 00:00:00","insp_start_time":"1525","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-19 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":"9380987","transaction_code":"C","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:37:20.000000Z","updated_at":"2025-03-17T20:37:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10918604,"change_date":"2024-09-20 21:43:00","inspection_id":"82707172","insp_unit_id":"203055913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:06.000000Z","updated_at":"2025-03-17T23:36:06.000000Z"}]},{"id":6540446,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","dot_number":"3283740","report_state":"TX","report_number":"6XX69DCRX4","insp_date":"2024-08-19 00:00:00","insp_start_time":"0652","insp_end_time":"0750","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9357721","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-08-22 21:43:00","snet_input_date":"2024-08-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:32:44.000000Z","updated_at":"2025-03-17T20:32:44.000000Z","inspection_violations":[{"id":10161012,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355651","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"39378"},{"id":10161013,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355652","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"393203C"},{"id":10161014,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355653","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3939A"},{"id":10161015,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355654","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3939A"},{"id":10161016,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355655","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3939A"},{"id":10161017,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355656","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3939A"},{"id":10161018,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355657","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3939A"},{"id":10161019,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355658","seq_no":"8","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"39319"},{"id":10161020,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355659","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3922"},{"id":10161021,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355660","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"39617C"},{"id":10161022,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355661","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"39347E"},{"id":10161023,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_violation_id":"261355662","seq_no":"12","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202538942","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10543663,"change_date":"2024-08-22 21:43:00","inspection_id":"82461680","insp_unit_id":"202538942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"RXS7614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":6168500,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","dot_number":"3283740","report_state":"TX","report_number":"V241464427","insp_date":"2024-06-27 00:00:00","insp_start_time":"1622","insp_end_time":"1824","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6012 IH10 EB SVC RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"H&N CONSTRUCTION","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":"2024-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9319036","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-07-08 21:43:00","snet_input_date":"2024-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:25:00.000000Z","updated_at":"2025-03-17T20:25:00.000000Z","inspection_violations":[{"id":9577039,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_violation_id":"260519746","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"201779269","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39375G"},{"id":9577040,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_violation_id":"260519747","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"201779269","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39375G"},{"id":9577041,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_violation_id":"260519748","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"201779269","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39375G"},{"id":9577042,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_violation_id":"260519749","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201779269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"3965B"},{"id":9577043,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_violation_id":"260519750","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201779269","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"3922"},{"id":9577044,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_violation_id":"260519751","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201779269","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9936908,"change_date":"2024-07-08 21:43:00","inspection_id":"82063848","insp_unit_id":"201779269","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"RXS7614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"}]},{"id":6073991,"change_date":"2024-06-25 21:42:00","inspection_id":"81962274","dot_number":"3283740","report_state":"TX","report_number":"6W699DJVH9","insp_date":"2024-06-17 00:00:00","insp_start_time":"0909","insp_end_time":"0924","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":"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-06-25 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":"9307770","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-06-25 21:42:00","snet_input_date":"2024-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:23:00.000000Z","updated_at":"2025-03-17T20:23:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9782904,"change_date":"2024-06-25 21:42:00","inspection_id":"81962274","insp_unit_id":"201585537","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"VGP8843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8YR831883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"}]},{"id":5811821,"change_date":"2024-05-21 21:47:00","inspection_id":"81678302","dot_number":"3283740","report_state":"TX","report_number":"V241419368","insp_date":"2024-05-16 00:00:00","insp_start_time":"0753","insp_end_time":"0814","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX75 AT BELINOWSKI R","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"818 DESPERADO TRUCKING LLC","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-05-21 21:47: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":"9280612","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-05-21 21:47:00","snet_input_date":"2024-05-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-21 21:47:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:17:53.000000Z","updated_at":"2025-03-17T20:17:53.000000Z","inspection_violations":[{"id":9003498,"change_date":"2024-05-21 21:47:00","inspection_id":"81678302","insp_violation_id":"259656627","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201022521","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9360315,"change_date":"2024-05-21 21:47:00","inspection_id":"81678302","insp_unit_id":"201022521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:12.000000Z","updated_at":"2025-03-17T23:20:12.000000Z"}]},{"id":5858610,"change_date":"2024-05-28 21:44:00","inspection_id":"81728809","dot_number":"3283740","report_state":"TX","report_number":"V241426133","insp_date":"2024-05-15 00:00:00","insp_start_time":"0731","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"818 DESPERADO TRUCKING LLC","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-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9286277","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-05-28 21:44:00","snet_input_date":"2024-05-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-28 21:44:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:18:43.000000Z","updated_at":"2025-03-17T20:18:43.000000Z","inspection_violations":[{"id":9082386,"change_date":"2024-05-28 21:44:00","inspection_id":"81728809","insp_violation_id":"259770006","seq_no":"1","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"201118937","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"393205A"},{"id":9082387,"change_date":"2024-05-28 21:44:00","inspection_id":"81728809","insp_violation_id":"259770007","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201118937","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9435967,"change_date":"2024-05-28 21:44:00","inspection_id":"81728809","insp_unit_id":"201118937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"}]},{"id":5770072,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","dot_number":"3283740","report_state":"TX","report_number":"6V189DCGB7","insp_date":"2024-05-07 00:00:00","insp_start_time":"0810","insp_end_time":"0840","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":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"61000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9274528","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:17:06.000000Z","updated_at":"2025-03-17T20:17:06.000000Z","inspection_violations":[{"id":8933263,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","insp_violation_id":"259555906","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200936938","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39375A3"},{"id":8933264,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","insp_violation_id":"259555907","seq_no":"5","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"200936938","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39382"},{"id":8933265,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","insp_violation_id":"259555908","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200936938","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39347E"},{"id":8933266,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","insp_violation_id":"259555909","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200936938","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39353B"},{"id":8933267,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","insp_violation_id":"259555910","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200936938","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":9293713,"change_date":"2024-05-16 21:41:00","inspection_id":"81632890","insp_unit_id":"200936938","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RSH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5341185,"change_date":"2024-03-21 21:41:00","inspection_id":"81165687","dot_number":"3283740","report_state":"TX","report_number":"6TND9DNA1I","insp_date":"2024-03-18 00:00:00","insp_start_time":"1315","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  MORRIS OLIVER W","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","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-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9229391","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:08:38.000000Z","updated_at":"2025-03-17T20:08:38.000000Z","inspection_violations":[{"id":8242907,"change_date":"2024-03-21 21:41:00","inspection_id":"81165687","insp_violation_id":"258520984","seq_no":"1","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200030896","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39347A"},{"id":8242908,"change_date":"2024-03-21 21:41:00","inspection_id":"81165687","insp_violation_id":"258520985","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200030896","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"3939A"},{"id":8242909,"change_date":"2024-03-21 21:41:00","inspection_id":"81165687","insp_violation_id":"258520986","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200030896","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8601923,"change_date":"2024-03-21 21:41:00","inspection_id":"81165687","insp_unit_id":"200030896","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:01.000000Z","updated_at":"2025-03-17T23:13:01.000000Z"}]},{"id":5341341,"change_date":"2024-03-21 21:41:00","inspection_id":"81165859","dot_number":"3283740","report_state":"TX","report_number":"V241348172","insp_date":"2024-03-15 00:00:00","insp_start_time":"1415","insp_end_time":"1529","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29  37'15.41\"N L","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DESPERADO TRUCKING LLC","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":"2024-03-21 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":"9228840","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:08:38.000000Z","updated_at":"2025-03-17T20:08:38.000000Z","inspection_violations":[{"id":8243439,"change_date":"2024-03-21 21:41:00","inspection_id":"81165859","insp_violation_id":"258521643","seq_no":"1","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"200031221","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"393203B"},{"id":8243440,"change_date":"2024-03-21 21:41:00","inspection_id":"81165859","insp_violation_id":"258521644","seq_no":"2","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"200031221","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39382"},{"id":8243441,"change_date":"2024-03-21 21:41:00","inspection_id":"81165859","insp_violation_id":"258521645","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"200031221","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":8602187,"change_date":"2024-03-21 21:41:00","inspection_id":"81165859","insp_unit_id":"200031221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:01.000000Z","updated_at":"2025-03-17T23:13:01.000000Z"}]},{"id":5055080,"change_date":"2024-02-14 21:42:00","inspection_id":"80853593","dot_number":"3283740","report_state":"TX","report_number":"V241327158","insp_date":"2024-02-09 00:00:00","insp_start_time":"1030","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 WB SVC RD AT EX","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE","shipping_paper_number":"1","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-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9197383","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7792427,"change_date":"2024-02-14 21:42:00","inspection_id":"80853593","insp_violation_id":"257849068","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"199431250","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"393207A"},{"id":7792428,"change_date":"2024-02-14 21:42:00","inspection_id":"80853593","insp_violation_id":"257849069","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"199431250","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"393209E"},{"id":7792429,"change_date":"2024-02-14 21:42:00","inspection_id":"80853593","insp_violation_id":"257849070","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199431250","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8137218,"change_date":"2024-02-14 21:42:00","inspection_id":"80853593","insp_unit_id":"199431250","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"RXS7614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0XX5N849646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":4727998,"change_date":"2024-12-06 21:44:00","inspection_id":"80495914","dot_number":"3283740","report_state":"TX","report_number":"V231239851","insp_date":"2023-12-27 00:00:00","insp_start_time":"1310","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 610","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"818 DESPERADO TRUCKING LLC","shipping_paper_number":"658","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-28 21:45: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":"9161494","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":"03283740","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7605379,"change_date":"2024-12-06 21:44:00","inspection_id":"80495914","insp_unit_id":"204237140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:00.000000Z","updated_at":"2025-03-17T23:04:00.000000Z"}]},{"id":4757400,"change_date":"2024-12-05 21:37:00","inspection_id":"80527909","dot_number":"3283740","report_state":"TX","report_number":"6RDE9DCKUH","insp_date":"2023-12-27 00:00:00","insp_start_time":"1453","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-01-03 21:44: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":"9164402","transaction_code":"C","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2024-01-03 21:44:00","snet_input_date":"2023-12-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"2900 GARROW ST APT 1","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7653324,"change_date":"2024-12-05 21:37:00","inspection_id":"80527909","insp_unit_id":"204206789","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":3870941,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","dot_number":"3283740","report_state":"TX","report_number":"6NW99DBTSI","insp_date":"2023-08-24 00:00:00","insp_start_time":"0933","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CRUSHED CONCRETE LLC","shipping_paper_number":"295369","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-30 21:45: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":"9063384","transaction_code":"C","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2023-08-30 21:45:00","snet_input_date":"2023-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-30 21:45:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"470 MAXEY RD APT 1804","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77013-5032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T19:39:23.000000Z","updated_at":"2025-03-17T19:39:23.000000Z","inspection_violations":[{"id":5980695,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","insp_violation_id":"255032924","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196853466","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:59.000000Z","updated_at":"2025-03-17T21:34:59.000000Z","normalized_code":"39311"},{"id":5980696,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","insp_violation_id":"255032925","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196853466","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:59.000000Z","updated_at":"2025-03-17T21:34:59.000000Z","normalized_code":"39378"},{"id":5980697,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","insp_violation_id":"255032926","seq_no":"3","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"196853466","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:59.000000Z","updated_at":"2025-03-17T21:34:59.000000Z","normalized_code":"393201A"},{"id":5980698,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","insp_violation_id":"255032927","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196853466","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:59.000000Z","updated_at":"2025-03-17T21:34:59.000000Z","normalized_code":"3922"},{"id":5980699,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","insp_violation_id":"255032928","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196853466","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:59.000000Z","updated_at":"2025-03-17T21:34:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6223316,"change_date":"2023-08-31 21:43:00","inspection_id":"79549322","insp_unit_id":"196853466","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:17.000000Z","updated_at":"2025-03-17T22:52:17.000000Z"}]},{"id":3792736,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","dot_number":"3283740","report_state":"TX","report_number":"6NMA9DCOPB","insp_date":"2023-08-14 00:00:00","insp_start_time":"1023","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  HOLMES RD","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"818 DESPARADO TRUCKING","shipping_paper_number":"315","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-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9056553","transaction_code":"A","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"470 MAXEY RD APT 1804","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77013-5032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T19:37:42.000000Z","updated_at":"2025-03-17T19:37:42.000000Z","inspection_violations":[{"id":5850823,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","insp_violation_id":"254781546","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:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"38323A2"},{"id":5850824,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","insp_violation_id":"254781547","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"1","insp_unit_id":"196644601","insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39141A"},{"id":5850825,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","insp_violation_id":"254781548","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"196644601","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39360D"},{"id":5850826,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","insp_violation_id":"254781549","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196644601","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3922"},{"id":5850827,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","insp_violation_id":"254781550","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196644601","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6098519,"change_date":"2023-08-21 21:42:00","inspection_id":"79461860","insp_unit_id":"196644601","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:14.000000Z","updated_at":"2025-03-17T22:51:14.000000Z"}]},{"id":3391046,"change_date":"2023-06-29 21:43:00","inspection_id":"79011712","dot_number":"3283740","report_state":"TX","report_number":"V231030187","insp_date":"2023-06-22 00:00:00","insp_start_time":"1500","insp_end_time":"1556","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 610","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DESPERADO TRUCKING","shipping_paper_number":"3688","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-28 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":"9016091","transaction_code":"C","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03283740","upload_search_indicator":"M","census_search_date":"2023-06-28 21:43:00","snet_input_date":"2023-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-28 21:43:00","insp_carrier_name":"818 DESPERADO TRUCKING LLC","insp_carrier_street":"470 MAXEY RD APT 1804","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77013-5032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1055275","created_at":"2025-03-17T19:30:11.000000Z","updated_at":"2025-03-17T19:30:11.000000Z","inspection_violations":[{"id":5229032,"change_date":"2023-06-29 21:43:00","inspection_id":"79011712","insp_violation_id":"253803719","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195769798","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"39311"},{"id":5229033,"change_date":"2023-06-29 21:43:00","inspection_id":"79011712","insp_violation_id":"253803720","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195769798","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5452057,"change_date":"2023-06-29 21:43:00","inspection_id":"79011712","insp_unit_id":"195769798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"315","insp_unit_license":"RXH2154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHGMR1RC089546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3283740\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3283740\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3283740\/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\/3283740\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}