{"current_page":1,"data":[{"id":9999221,"change_date":"2025-10-21 21:39:00","inspection_id":"86109331","dot_number":"3564109","report_state":"TX","report_number":"79NG9DBZ3P","insp_date":"2025-10-15 00:00:00","insp_start_time":"1629","insp_end_time":"1659","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18000  LEE RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","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":"9732684","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2025-10-21 21:39:00","snet_input_date":"2025-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-21 21:39:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-10-24T10:01:57.000000Z","updated_at":"2025-10-25T10:01:00.000000Z","inspection_violations":[{"id":16524791,"change_date":"2025-10-21 21:39:00","inspection_id":"86109331","insp_violation_id":"269429319","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209582229","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:18:03.000000Z","updated_at":"2025-10-25T10:16:26.000000Z","normalized_code":"39378"},{"id":16524792,"change_date":"2025-10-21 21:39:00","inspection_id":"86109331","insp_violation_id":"269429320","seq_no":"2","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"209582229","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:18:03.000000Z","updated_at":"2025-10-25T10:16:26.000000Z","normalized_code":"39379"}],"inspection_per_units":[{"id":16606212,"change_date":"2025-10-21 21:39:00","inspection_id":"86109331","insp_unit_id":"209582229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"587","insp_unit_license":"TKZ5775","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y61W137945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:08.000000Z","updated_at":"2025-10-25T09:46:10.000000Z"}]},{"id":9889535,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","dot_number":"3564109","report_state":"TX","report_number":"79AD9DCQ81","insp_date":"2025-10-02 00:00:00","insp_start_time":"1349","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3700  WILL CLAYTON P","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-10-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9718761","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2025-10-08 21:41:00","snet_input_date":"2025-10-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-08 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-10-11T10:01:50.000000Z","updated_at":"2025-10-12T10:01:14.000000Z","inspection_violations":[{"id":16307323,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181437","seq_no":"1","part_no":"392","part_no_section":"16","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-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"39216"},{"id":16307324,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181438","seq_no":"2","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"39379"},{"id":16307325,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181439","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"39351"},{"id":16307326,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181440","seq_no":"4","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"3939H"},{"id":16307327,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181441","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"3939"},{"id":16307328,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181442","seq_no":"6","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"39383H"},{"id":16307329,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181443","seq_no":"8","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"3929"},{"id":16307330,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181444","seq_no":"9","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"39355D1"},{"id":16307331,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_violation_id":"269181445","seq_no":"7","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"209367462","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-11T10:18:10.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":16408567,"change_date":"2025-10-08 21:41:00","inspection_id":"85993453","insp_unit_id":"209367462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"588","insp_unit_license":"XGL7077","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y8XW106972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:15.000000Z","updated_at":"2025-10-12T09:46:33.000000Z"}]},{"id":8818044,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","dot_number":"3564109","report_state":"TX","report_number":"V251900513","insp_date":"2025-05-30 00:00:00","insp_start_time":"1000","insp_end_time":"1022","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX573 LOOP NB TX573","county_code_state":"TX","county_code":"291","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PIT","shipping_paper_number":"35947","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-04 21:41: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":"9598765","transaction_code":"C","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-05-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-06-07T10:01:09.000000Z","updated_at":"2025-06-09T10:01:00.000000Z","inspection_violations":[{"id":14119963,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","insp_violation_id":"266690934","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207249534","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:45.000000Z","updated_at":"2025-06-09T10:15:25.000000Z","normalized_code":"39347E"},{"id":14119964,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","insp_violation_id":"266690935","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207249534","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:45.000000Z","updated_at":"2025-06-09T10:15:25.000000Z","normalized_code":"39353B"},{"id":14119965,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","insp_violation_id":"266690936","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"207249534","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:45.000000Z","updated_at":"2025-06-09T10:15:25.000000Z","normalized_code":"3939H"},{"id":14119966,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","insp_violation_id":"266690937","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207249534","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:45.000000Z","updated_at":"2025-06-09T10:15:25.000000Z","normalized_code":"3939"},{"id":14119967,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","insp_violation_id":"266690938","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207249534","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:45.000000Z","updated_at":"2025-06-09T10:15:25.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14441999,"change_date":"2025-06-05 21:41:00","inspection_id":"84865804","insp_unit_id":"207249534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"588","insp_unit_license":"VTX8209","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y8XW106972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:21.000000Z","updated_at":"2025-06-09T09:45:16.000000Z"}]},{"id":8691366,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","dot_number":"3564109","report_state":"TX","report_number":"V251881465","insp_date":"2025-05-14 00:00:00","insp_start_time":"0840","insp_end_time":"0913","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1960 AT ENTRY RAMP","county_code_state":"TX","county_code":"291","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PIT","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":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9584219","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":"03564109","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-05-23T10:04:26.000000Z","updated_at":"2025-05-24T10:06:09.000000Z","inspection_violations":[{"id":13849837,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359596","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"39345B2UV"},{"id":13849838,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359597","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"39347E"},{"id":13849839,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359598","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"39353B"},{"id":13849840,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359599","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"39378"},{"id":13849841,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359600","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"3939"},{"id":13849842,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359601","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"3922RG"},{"id":13849836,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_violation_id":"266359595","seq_no":"1","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"206971910","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:37:52.000000Z","updated_at":"2025-05-24T10:27:21.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":14200933,"change_date":"2025-05-20 21:41:00","inspection_id":"84731688","insp_unit_id":"206971910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"589","insp_unit_license":"VTX8208","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13YXWW096343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:18.000000Z","updated_at":"2025-05-24T09:51:41.000000Z"}]},{"id":8691365,"change_date":"2025-05-21 21:42:00","inspection_id":"84731687","dot_number":"3564109","report_state":"TX","report_number":"V251881460","insp_date":"2025-05-14 00:00:00","insp_start_time":"0825","insp_end_time":"0857","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1960 AT ENTRY RAMP","county_code_state":"TX","county_code":"291","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PIT","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":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9584234","transaction_code":"C","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-05-23T10:04:26.000000Z","updated_at":"2025-05-25T10:05:41.000000Z","inspection_violations":[{"id":13866964,"change_date":"2025-05-21 21:42:00","inspection_id":"84731687","insp_violation_id":"266389055","seq_no":"1","part_no":"383","part_no_section":"23A2","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-05-24T10:27:27.000000Z","updated_at":"2025-05-25T10:23:31.000000Z","normalized_code":"38323A2"},{"id":13866965,"change_date":"2025-05-21 21:42:00","inspection_id":"84731687","insp_violation_id":"266389056","seq_no":"2","part_no":"393","part_no_section":"104D","insp_viol_unit":"1","insp_unit_id":"206997589","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-24T10:27:27.000000Z","updated_at":"2025-05-25T10:23:31.000000Z","normalized_code":"393104D"}],"inspection_per_units":[{"id":14216227,"change_date":"2025-05-21 21:42:00","inspection_id":"84731687","insp_unit_id":"206997589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"590","insp_unit_license":"WFW9446","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y2WW092450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:42.000000Z","updated_at":"2025-05-25T09:51:10.000000Z"}]},{"id":8298447,"change_date":"2025-04-04 21:41:00","inspection_id":"84317882","dot_number":"3564109","report_state":"TX","report_number":"73ZD9DBV1B","insp_date":"2025-03-25 00:00:00","insp_start_time":"1336","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18000  LEE RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9541181","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-03-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-04-07T10:22:18.000000Z","updated_at":"2025-04-08T10:09:51.000000Z","inspection_violations":[{"id":13049501,"change_date":"2025-04-04 21:41:00","inspection_id":"84317882","insp_violation_id":"265449316","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"206162539","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:52:30.000000Z","updated_at":"2025-04-07T11:00:51.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":13455044,"change_date":"2025-04-04 21:41:00","inspection_id":"84317882","insp_unit_id":"206162539","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"586","insp_unit_license":"WDH6365","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:12:47.000000Z","updated_at":"2025-04-08T10:01:05.000000Z"}]},{"id":7845128,"change_date":"2025-02-11 21:40:00","inspection_id":"83841377","dot_number":"3564109","report_state":"TX","report_number":"V251725261","insp_date":"2025-01-28 00:00:00","insp_start_time":"1414","insp_end_time":"1444","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"HWY 6","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARVAJAL TRUCK 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":"2025-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9494975","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":"03564109","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-01-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[{"id":12258846,"change_date":"2025-02-11 21:40:00","inspection_id":"83841377","insp_violation_id":"264465272","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"205275909","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":"3939H"},{"id":12258847,"change_date":"2025-02-11 21:40:00","inspection_id":"83841377","insp_violation_id":"264465273","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205275909","insp_violation_category_id":"29","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":"39617C"}],"inspection_per_units":[{"id":12661415,"change_date":"2025-02-11 21:40:00","inspection_id":"83841377","insp_unit_id":"205275909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"588","insp_unit_license":"VTX8209","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y8XW106972","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":6953078,"change_date":"2024-10-14 21:37:00","inspection_id":"82900995","dot_number":"3564109","report_state":"TX","report_number":"6ZDH9DCODL","insp_date":"2024-10-10 00:00:00","insp_start_time":"1754","insp_end_time":"1807","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  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-10-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9400599","transaction_code":"A","transaction_date":"2024-10-14 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:41:02.000000Z","updated_at":"2025-03-17T20:41:02.000000Z","inspection_violations":[{"id":10841616,"change_date":"2024-10-14 21:37:00","inspection_id":"82900995","insp_violation_id":"262337723","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203398511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:34.000000Z","updated_at":"2025-03-17T21:58:34.000000Z","normalized_code":"3939A"},{"id":10841617,"change_date":"2024-10-14 21:37:00","inspection_id":"82900995","insp_violation_id":"262337724","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"203398511","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:34.000000Z","updated_at":"2025-03-17T21:58:34.000000Z","normalized_code":"39383G"},{"id":10841618,"change_date":"2024-10-14 21:37:00","inspection_id":"82900995","insp_violation_id":"262337725","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203398511","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:34.000000Z","updated_at":"2025-03-17T21:58:34.000000Z","normalized_code":"3963A1"},{"id":10841619,"change_date":"2024-10-14 21:37:00","inspection_id":"82900995","insp_violation_id":"262337726","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203398511","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:34.000000Z","updated_at":"2025-03-17T21:58:34.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":11214884,"change_date":"2024-10-14 21:37:00","inspection_id":"82900995","insp_unit_id":"203398511","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"586","insp_unit_license":"TBV7362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:05.000000Z","updated_at":"2025-03-17T23:39:05.000000Z"}]},{"id":6178291,"change_date":"2024-07-16 21:44:00","inspection_id":"82074476","dot_number":"3564109","report_state":"TX","report_number":"V241461218","insp_date":"2024-07-05 00:00:00","insp_start_time":"1057","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CRIGHTON RD","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HONEYBEE TRUCKING","shipping_paper_number":"437113","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-09 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","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":"9321299","transaction_code":"C","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-07-09 21:44:00","snet_input_date":"2024-07-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-09 21:44:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9594725,"change_date":"2024-07-16 21:44:00","inspection_id":"82074476","insp_violation_id":"260673030","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201912312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9953018,"change_date":"2024-07-16 21:44:00","inspection_id":"82074476","insp_unit_id":"201912312","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"587","insp_unit_license":"TKZ5775","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y61W137945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":6119548,"change_date":"2024-07-01 21:44:00","inspection_id":"82011176","dot_number":"3564109","report_state":"TX","report_number":"6W779DJZLV","insp_date":"2024-06-18 00:00:00","insp_start_time":"0756","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  GRAND VILLAGE B","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARVAJAL 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-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"39720","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9313181","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:23:49.000000Z","updated_at":"2025-03-17T20:23:49.000000Z","inspection_violations":[{"id":9500176,"change_date":"2024-07-01 21:44:00","inspection_id":"82011176","insp_violation_id":"260412519","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"201680915","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39345"},{"id":9500177,"change_date":"2024-07-01 21:44:00","inspection_id":"82011176","insp_violation_id":"260412520","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201680915","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39395A"},{"id":9500178,"change_date":"2024-07-01 21:44:00","inspection_id":"82011176","insp_violation_id":"260412521","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201680915","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39378"},{"id":9500179,"change_date":"2024-07-01 21:44:00","inspection_id":"82011176","insp_violation_id":"260412522","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201680915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9857003,"change_date":"2024-07-01 21:44:00","inspection_id":"82011176","insp_unit_id":"201680915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"TBV7362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"}]},{"id":6019915,"change_date":"2024-06-18 21:43:00","inspection_id":"81903950","dot_number":"3564109","report_state":"TX","report_number":"6VZ69DCGCU","insp_date":"2024-06-10 00:00:00","insp_start_time":"0650","insp_end_time":"0710","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","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-06-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9302659","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-06-18 21:43:00","snet_input_date":"2024-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-18 21:43:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:21:55.000000Z","updated_at":"2025-03-17T20:21:55.000000Z","inspection_violations":[{"id":9339982,"change_date":"2024-06-18 21:43:00","inspection_id":"81903950","insp_violation_id":"260175954","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201472194","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":9696012,"change_date":"2024-06-18 21:43:00","inspection_id":"81903950","insp_unit_id":"201472194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"92P605M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13YXWW096343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:29.000000Z","updated_at":"2025-03-17T23:23:29.000000Z"}]},{"id":5931382,"change_date":"2024-06-06 21:41:00","inspection_id":"81808027","dot_number":"3564109","report_state":"TX","report_number":"6VLB9DJZKJ","insp_date":"2024-05-27 00:00:00","insp_start_time":"1146","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  GRAND VILLAGE D","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEINY CARVAJAL","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-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9293117","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":9198260,"change_date":"2024-06-06 21:41:00","inspection_id":"81808027","insp_violation_id":"259947405","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201272181","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"3939A"},{"id":9198261,"change_date":"2024-06-06 21:41:00","inspection_id":"81808027","insp_violation_id":"259947406","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"201272181","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":9553618,"change_date":"2024-06-06 21:41:00","inspection_id":"81808027","insp_unit_id":"201272181","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"15P581M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13YXWW096343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5578089,"change_date":"2024-04-23 21:41:00","inspection_id":"81424176","dot_number":"3564109","report_state":"TX","report_number":"6UJ69DBA7H","insp_date":"2024-04-19 00:00:00","insp_start_time":"0630","insp_end_time":"0645","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARVAJAL TRUCK 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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-23 21:41: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":"9254824","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:13:11.000000Z","updated_at":"2025-03-17T20:13:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8985296,"change_date":"2024-04-23 21:41:00","inspection_id":"81424176","insp_unit_id":"200535239","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"586","insp_unit_license":"TBV7362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:37.000000Z","updated_at":"2025-03-17T23:16:37.000000Z"}]},{"id":5288647,"change_date":"2024-03-14 21:42:00","inspection_id":"81108285","dot_number":"3564109","report_state":"TX","report_number":"V241349404","insp_date":"2024-03-12 00:00:00","insp_start_time":"0846","insp_end_time":"0907","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1462 EB AT TX288 N","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARVAJAL","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9222759","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[{"id":8154853,"change_date":"2024-03-14 21:42:00","inspection_id":"81108285","insp_violation_id":"258389847","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199920100","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8516695,"change_date":"2024-03-14 21:42:00","inspection_id":"81108285","insp_unit_id":"199920100","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"506","insp_unit_license":"TBV7362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:11.000000Z","updated_at":"2025-03-17T23:12:11.000000Z"}]},{"id":4712715,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","dot_number":"3564109","report_state":"TX","report_number":"6R4E9DCKTJ","insp_date":"2023-12-18 00:00:00","insp_start_time":"1427","insp_end_time":"1512","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9155710","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":"03564109","upload_search_indicator":"M","census_search_date":"2023-12-27 21:42:00","snet_input_date":"2023-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-27 21:42:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T19:56:11.000000Z","updated_at":"2025-03-17T19:56:11.000000Z","inspection_violations":[{"id":7276221,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","insp_violation_id":"263292710","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"204235042","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3963A1"},{"id":7276222,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","insp_violation_id":"263292711","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204235042","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39395F"},{"id":7276223,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","insp_violation_id":"263292712","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204235042","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39617C"},{"id":7276224,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","insp_violation_id":"263292713","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204235042","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939TS"},{"id":7276225,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","insp_violation_id":"263292714","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204235042","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":7580168,"change_date":"2024-12-06 21:44:00","inspection_id":"80479416","insp_unit_id":"204235042","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"TBV7362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:47.000000Z","updated_at":"2025-03-17T23:03:47.000000Z"}]},{"id":4727891,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","dot_number":"3564109","report_state":"TX","report_number":"6R4E9DJNVV","insp_date":"2023-12-18 00:00:00","insp_start_time":"1415","insp_end_time":"1515","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","viol_total":"10","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9159700","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[{"id":7299765,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231937","seq_no":"9","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39311"},{"id":7299766,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231938","seq_no":"10","part_no":"392","part_no_section":"9A2","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3929A2"},{"id":7299767,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231939","seq_no":"1","part_no":"383","part_no_section":"23A2","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:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"38323A2"},{"id":7299768,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231940","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39141A"},{"id":7299769,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231941","seq_no":"3","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39355D1"},{"id":7299770,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231942","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39395F"},{"id":7299771,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231943","seq_no":"5","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39330"},{"id":7299772,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231944","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39378"},{"id":7299773,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231945","seq_no":"7","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39345B2UV"},{"id":7299774,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_violation_id":"263231946","seq_no":"8","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"204183729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3963A1B"}],"inspection_per_units":[{"id":7605205,"change_date":"2024-12-04 21:41:00","inspection_id":"80495796","insp_unit_id":"204183729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"587","insp_unit_license":"TKZ5775","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y61W137945","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":741130,"change_date":"2022-07-01 21:38:00","inspection_id":"75974976","dot_number":"3564109","report_state":"TX","report_number":"6C079DJZAG","insp_date":"2022-06-22 00:00:00","insp_start_time":"0749","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  AIRPORT RD","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARVAJAL TRUCK 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":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8700833","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T18:40:51.000000Z","updated_at":"2025-03-17T18:40:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1191052,"change_date":"2022-07-01 21:38:00","inspection_id":"75974976","insp_unit_id":"189581026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RPZ2096","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:30.000000Z","updated_at":"2025-03-17T22:15:30.000000Z"}]},{"id":649746,"change_date":"2022-06-28 21:43:00","inspection_id":"75867259","dot_number":"3564109","report_state":"TX","report_number":"6BS99DGP6D","insp_date":"2022-06-14 00:00:00","insp_start_time":"0854","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9400  NORTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOCAL CONSTRUCTION SITE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"8688261","transaction_code":"C","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03564109","upload_search_indicator":"M","census_search_date":"2022-06-28 21:43:00","snet_input_date":"2022-06-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-20 21:36:00","insp_carrier_name":"CARVAJAL TRUCK LLC","insp_carrier_street":"18204 CHISHOLM TRL APT 133","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1029742","created_at":"2025-03-17T18:39:10.000000Z","updated_at":"2025-03-17T18:39:10.000000Z","inspection_violations":[{"id":1024337,"change_date":"2022-06-28 21:43:00","inspection_id":"75867259","insp_violation_id":"246772425","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189507094","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"3939A"},{"id":1024338,"change_date":"2022-06-28 21:43:00","inspection_id":"75867259","insp_violation_id":"246772426","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189507094","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39347E"},{"id":1024339,"change_date":"2022-06-28 21:43:00","inspection_id":"75867259","insp_violation_id":"246772427","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189507094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":1044799,"change_date":"2022-06-28 21:43:00","inspection_id":"75867259","insp_unit_id":"189507094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"586","insp_unit_license":"RPZ2096","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y87N007354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:36.000000Z","updated_at":"2025-03-17T22:14:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3564109\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3564109\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3564109\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3564109\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}