{"current_page":1,"data":[{"id":5856934,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","dot_number":"3733087","report_state":"TX","report_number":"6VH99DGA0O","insp_date":"2024-05-23 00:00:00","insp_start_time":"0918","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0003 IN GALVESTON CO. (492-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"124200","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":"9284695","transaction_code":"C","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2024-05-28 21:44:00","snet_input_date":"2024-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-28 21:44:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T20:18:42.000000Z","updated_at":"2025-03-17T20:18:42.000000Z","inspection_violations":[{"id":9077128,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818684","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"39617C"},{"id":9077129,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818685","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201160559","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"3922"},{"id":9077130,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818686","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"39395A"},{"id":9077131,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818687","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"39378"},{"id":9077132,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818688","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"3939A"},{"id":9077133,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818689","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201160559","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"39347E"},{"id":9077134,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818690","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"201160559","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"39353B"},{"id":9077135,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818691","seq_no":"8","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"3929A2"},{"id":9077136,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818692","seq_no":"9","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"393203C"},{"id":9077137,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_violation_id":"259818693","seq_no":"10","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201160558","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:51.000000Z","updated_at":"2025-03-17T21:49:51.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9433187,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_unit_id":"201160558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-420","insp_unit_license":"R695595","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP0X8FJ971420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:52.000000Z","updated_at":"2025-03-17T23:20:52.000000Z"},{"id":9433188,"change_date":"2024-05-30 21:43:00","inspection_id":"81727028","insp_unit_id":"201160559","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"V-567","insp_unit_license":"CT1140","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3421L1038567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:52.000000Z","updated_at":"2025-03-17T23:20:52.000000Z"}]},{"id":5633959,"change_date":"2024-05-01 21:43:00","inspection_id":"81485097","dot_number":"3733087","report_state":"TX","report_number":"6URA9DKY4P","insp_date":"2024-04-27 00:00:00","insp_start_time":"1037","insp_end_time":"1104","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  LOOP 197 N","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":"OPEN","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-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9260446","transaction_code":"C","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8711519,"change_date":"2024-05-01 21:43:00","inspection_id":"81485097","insp_violation_id":"259260414","seq_no":"1","part_no":"392","part_no_section":"2","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-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9075043,"change_date":"2024-05-01 21:43:00","inspection_id":"81485097","insp_unit_id":"200680086","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"R695526","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP4D49X1CD154046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"},{"id":9075044,"change_date":"2024-05-01 21:43:00","inspection_id":"81485097","insp_unit_id":"200680087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CYCK","insp_unit_company":null,"insp_unit_license":"CY7282","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4Z4515424XP001827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"}]},{"id":5647141,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","dot_number":"3733087","report_state":"TX","report_number":"6UR79DTG0C","insp_date":"2024-04-27 00:00:00","insp_start_time":"0725","insp_end_time":"0831","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500 N 25TH AVE AVE","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":"OPEN","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-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"260001","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":"9262105","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[{"id":8733857,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","insp_violation_id":"261504925","seq_no":"1","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"202665142","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39355D2"},{"id":8733858,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","insp_violation_id":"261504926","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202665141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"3939A"},{"id":8733859,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","insp_violation_id":"261504927","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202665141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"3939A"},{"id":8733860,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","insp_violation_id":"261504928","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202665141","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9095985,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","insp_unit_id":"202665141","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"110","insp_unit_license":"R695591","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X8FJ461601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"},{"id":9095986,"change_date":"2024-08-29 21:43:00","inspection_id":"81499385","insp_unit_id":"202665142","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"CT1138","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3421L1038326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5633979,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","dot_number":"3733087","report_state":"TX","report_number":"6UQ89DKY4H","insp_date":"2024-04-26 00:00:00","insp_start_time":"0859","insp_end_time":"0959","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2797  21 ST N","county_code_state":"TX","county_code":"167","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"14","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9259884","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-04-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8711589,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229130","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39347E"},{"id":8711590,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229131","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39353B"},{"id":8711591,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229132","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39617C"},{"id":8711592,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229133","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200653379","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39378"},{"id":8711593,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229134","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200653379","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39311"},{"id":8711594,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229135","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200653379","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39311"},{"id":8711595,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229136","seq_no":"7","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"393207A"},{"id":8711596,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229137","seq_no":"8","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39375C"},{"id":8711597,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229138","seq_no":"9","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39375C"},{"id":8711598,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229139","seq_no":"11","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"393201A"},{"id":8711599,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229140","seq_no":"12","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200653379","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39345"},{"id":8711600,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229141","seq_no":"13","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200653380","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3922"},{"id":8711601,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229142","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200653379","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39617C"},{"id":8711602,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_violation_id":"259229143","seq_no":"15","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":9075072,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_unit_id":"200653379","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"R695594","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X5HD445101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"},{"id":9075073,"change_date":"2024-04-30 21:42:00","inspection_id":"81485120","insp_unit_id":"200653380","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ARMC","insp_unit_company":"0","insp_unit_license":"CU7053","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"56EA75C26FA000613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"}]},{"id":4562683,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","dot_number":"3733087","report_state":"TX","report_number":"6QL99DKYRQ","insp_date":"2023-11-29 00:00:00","insp_start_time":"0857","insp_end_time":"0932","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":"OPEN","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-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"9139581","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2023-12-05 21:43:00","snet_input_date":"2023-11-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-05 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:53:22.000000Z","updated_at":"2025-03-17T19:53:22.000000Z","inspection_violations":[{"id":7057170,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_violation_id":"256726162","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"198360840","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39355D2"},{"id":7057171,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_violation_id":"256726163","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"198360841","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39355D3"},{"id":7057172,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_violation_id":"256726164","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198360840","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39311"},{"id":7057173,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_violation_id":"256726165","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"198360841","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39345B2"},{"id":7057174,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_violation_id":"256726166","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198360841","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39375C"},{"id":7057175,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_violation_id":"256726167","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198360841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7338421,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_unit_id":"198360840","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"108","insp_unit_license":"R695592","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X1EJ419186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"},{"id":7338422,"change_date":"2023-12-05 21:43:00","inspection_id":"80314993","insp_unit_id":"198360841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BALT","insp_unit_company":"0","insp_unit_license":"CT1139","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3423L1038389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"}]},{"id":4563025,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","dot_number":"3733087","report_state":"TX","report_number":"6QL79DKYRO","insp_date":"2023-11-29 00:00:00","insp_start_time":"0742","insp_end_time":"0820","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":"OPEN","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-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"13","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9139579","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2023-12-05 21:43:00","snet_input_date":"2023-11-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-05 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:53:22.000000Z","updated_at":"2025-03-17T19:53:22.000000Z","inspection_violations":[{"id":7058247,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727918","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3922"},{"id":7058248,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727919","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39395A"},{"id":7058249,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727920","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39378"},{"id":7058250,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727921","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3939A"},{"id":7058251,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727922","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3939A"},{"id":7058252,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727923","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3939A"},{"id":7058253,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727924","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3939A"},{"id":7058254,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727925","seq_no":"9","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39319"},{"id":7058255,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727926","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39311"},{"id":7058256,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727927","seq_no":"11","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39311"},{"id":7058257,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727928","seq_no":"12","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"198361599","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39345B2"},{"id":7058258,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727929","seq_no":"13","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"198361599","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39355D3"},{"id":7058259,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_violation_id":"256727930","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198361598","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7338992,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_unit_id":"198361598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"R695595","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP0X8FJ971420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"},{"id":7338993,"change_date":"2023-12-05 21:43:00","inspection_id":"80315362","insp_unit_id":"198361599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BALT","insp_unit_company":"0","insp_unit_license":"CT1140","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3421L1038567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"}]},{"id":4581304,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","dot_number":"3733087","report_state":"TX","report_number":"6Q1C9DHP5I","insp_date":"2023-11-09 00:00:00","insp_start_time":"1258","insp_end_time":"1331","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":"2023-12-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"94600","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":"9142203","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2023-12-07 21:41:00","snet_input_date":"2023-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-07 21:41:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:53:45.000000Z","updated_at":"2025-03-17T19:53:45.000000Z","inspection_violations":[{"id":7085722,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","insp_violation_id":"256773602","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198403340","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"39378"},{"id":7085723,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","insp_violation_id":"256773603","seq_no":"4","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"198403340","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"39382"},{"id":7085724,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","insp_violation_id":"256773604","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198403341","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"},{"id":7085725,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","insp_violation_id":"256773605","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198403341","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7368704,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","insp_unit_id":"198403340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"R695526","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP4D49X1CD154046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:55.000000Z","updated_at":"2025-03-17T23:01:55.000000Z"},{"id":7368705,"change_date":"2023-12-07 21:41:00","inspection_id":"80335377","insp_unit_id":"198403341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"076C361","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4Z4515424XP001827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:55.000000Z","updated_at":"2025-03-17T23:01:55.000000Z"}]},{"id":4137296,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","dot_number":"3733087","report_state":"TX","report_number":"V231162452","insp_date":"2023-09-29 00:00:00","insp_start_time":"0830","insp_end_time":"0902","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"SH 288 NB ANGLETON","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66","shipping_paper_number":"02356","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9093088","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":null,"census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-09-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[{"id":6405003,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688059","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197423569","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39311"},{"id":6405004,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688060","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"197423569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"393203C"},{"id":6405005,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688061","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197423569","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39375A3"},{"id":6405006,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688062","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197423569","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39378"},{"id":6405007,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688063","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197423569","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3939A"},{"id":6405008,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688064","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197423570","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3939A"},{"id":6405009,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_violation_id":"255688065","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197423569","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6652719,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_unit_id":"197423569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"109","insp_unit_license":"37W186V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP0X8FJ971420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"},{"id":6652720,"change_date":"2023-10-05 21:40:00","inspection_id":"79845396","insp_unit_id":"197423570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"109T","insp_unit_license":"44W186V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3P9KT3423L1038389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"}]},{"id":3917863,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","dot_number":"3733087","report_state":"TX","report_number":"6O299DAP3B","insp_date":"2023-08-30 00:00:00","insp_start_time":"0918","insp_end_time":"0942","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"134200","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9069055","transaction_code":"A","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-09-06 21:43:00","snet_input_date":"2023-08-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-06 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:40:08.000000Z","updated_at":"2025-03-17T19:40:08.000000Z","inspection_violations":[{"id":6054655,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120153","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196931436","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39378"},{"id":6054656,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120154","seq_no":"2","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"196931436","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3929"},{"id":6054657,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120155","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"196931437","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39355D3"},{"id":6054658,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120156","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196931437","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39347E"},{"id":6054659,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120157","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196931437","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39353B"},{"id":6054660,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120158","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196931437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3922"},{"id":6054661,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120159","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196931437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3922"},{"id":6054662,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_violation_id":"255120160","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196931437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6299960,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_unit_id":"196931436","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"59R241M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP0X8FJ971420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:55.000000Z","updated_at":"2025-03-17T22:52:55.000000Z"},{"id":6299961,"change_date":"2023-09-06 21:43:00","inspection_id":"79601589","insp_unit_id":"196931437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"BW3489","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3421L1038567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:55.000000Z","updated_at":"2025-03-17T22:52:55.000000Z"}]},{"id":3936291,"change_date":"2023-09-08 21:41:00","inspection_id":"79622109","dot_number":"3733087","report_state":"TX","report_number":"6NNE9DDA0J","insp_date":"2023-08-15 00:00:00","insp_start_time":"1402","insp_end_time":"1424","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2400  MEYER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"9070801","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:40:30.000000Z","updated_at":"2025-03-17T19:40:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6329382,"change_date":"2023-09-08 21:41:00","inspection_id":"79622109","insp_unit_id":"196973650","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"41U233M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5D49X36D651866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"},{"id":6329383,"change_date":"2023-09-08 21:41:00","inspection_id":"79622109","insp_unit_id":"196973651","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"36P233M","insp_unit_license":"36P233M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C25FA000568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3345835,"change_date":"2023-06-22 21:42:00","inspection_id":"78960956","dot_number":"3733087","report_state":"TX","report_number":"6LYC9DNN5O","insp_date":"2023-06-15 00:00:00","insp_start_time":"1211","insp_end_time":"1232","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":"2023-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132200","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":"9011244","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:29:20.000000Z","updated_at":"2025-03-17T19:29:20.000000Z","inspection_violations":[{"id":5159656,"change_date":"2023-06-22 21:42:00","inspection_id":"78960956","insp_violation_id":"253654196","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195632889","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"3922"},{"id":5159657,"change_date":"2023-06-22 21:42:00","inspection_id":"78960956","insp_violation_id":"253654197","seq_no":"3","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"195632888","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":5378898,"change_date":"2023-06-22 21:42:00","inspection_id":"78960956","insp_unit_id":"195632888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"107","insp_unit_license":"57N136M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X9DJ360886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:25.000000Z","updated_at":"2025-03-17T22:45:25.000000Z"},{"id":5378899,"change_date":"2023-06-22 21:42:00","inspection_id":"78960956","insp_unit_id":"195632889","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"56Y083V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3420KR156894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:25.000000Z","updated_at":"2025-03-17T22:45:25.000000Z"}]},{"id":2992300,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","dot_number":"3733087","report_state":"TX","report_number":"6KQG9DCOJ6","insp_date":"2023-05-02 00:00:00","insp_start_time":"1621","insp_end_time":"1640","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"189","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-05-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"14","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8971622","transaction_code":"A","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-05-08 21:43:00","snet_input_date":"2023-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-08 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:22:17.000000Z","updated_at":"2025-03-17T19:22:17.000000Z","inspection_violations":[{"id":4594311,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695968","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39355D1"},{"id":4594312,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695969","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39355D2"},{"id":4594313,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695970","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39378"},{"id":4594314,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695971","seq_no":"4","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39379"},{"id":4594315,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695972","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39311"},{"id":4594316,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695973","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39311"},{"id":4594317,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695974","seq_no":"7","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39319"},{"id":4594318,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695975","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39311"},{"id":4594319,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695976","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"3939A"},{"id":4594320,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695977","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"3939A"},{"id":4594321,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695978","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"3939A"},{"id":4594322,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695979","seq_no":"12","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194812676","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39355E"},{"id":4594323,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695980","seq_no":"13","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194812676","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39375A3"},{"id":4594324,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_violation_id":"252695981","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194812675","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:24.000000Z","updated_at":"2025-03-17T21:28:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4814558,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_unit_id":"194812675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"113","insp_unit_license":"64S093M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HSHXSJR5CJ546354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:55.000000Z","updated_at":"2025-03-17T22:40:55.000000Z"},{"id":4814559,"change_date":"2023-05-08 21:43:00","inspection_id":"78562147","insp_unit_id":"194812676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"012","insp_unit_license":"67S093M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C26FA000613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:55.000000Z","updated_at":"2025-03-17T22:40:55.000000Z"}]},{"id":2876950,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","dot_number":"3733087","report_state":"TX","report_number":"6KD99DNHVX","insp_date":"2023-04-19 00:00:00","insp_start_time":"0849","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"8961238","transaction_code":"A","transaction_date":"2023-04-24 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-04-24 21:41:00","snet_input_date":"2023-04-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-24 21:41:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:19:43.000000Z","updated_at":"2025-03-17T19:19:43.000000Z","inspection_violations":[{"id":4416854,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_violation_id":"252406770","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194553833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"39311"},{"id":4416855,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_violation_id":"252406771","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194553833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"39311"},{"id":4416856,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_violation_id":"252406772","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194553833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"3939A"},{"id":4416857,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_violation_id":"252406773","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194553833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"39311"},{"id":4416858,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_violation_id":"252406774","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194553833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"39311"},{"id":4416859,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_violation_id":"252406775","seq_no":"6","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"194553833","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":4629373,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_unit_id":"194553833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"113","insp_unit_license":"45U074M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HSHXSJR5CJ546354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:30.000000Z","updated_at":"2025-03-17T22:39:30.000000Z"},{"id":4629374,"change_date":"2023-04-24 21:41:00","inspection_id":"78431429","insp_unit_id":"194553834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"012","insp_unit_license":"48U074M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C26FA000613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:30.000000Z","updated_at":"2025-03-17T22:39:30.000000Z"}]},{"id":2821859,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","dot_number":"3733087","report_state":"TX","report_number":"6K5A9DGB8V","insp_date":"2023-04-11 00:00:00","insp_start_time":"1002","insp_end_time":"1053","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0646 IN GALVESTON CO. (586-","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":"2023-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","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":"8955142","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-04-17 21:41:00","snet_input_date":"2023-04-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:18:52.000000Z","updated_at":"2025-03-17T19:18:52.000000Z","inspection_violations":[{"id":4329891,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_violation_id":"252270785","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194432157","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39345D"},{"id":4329892,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_violation_id":"252270786","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"194432157","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39355D2"},{"id":4329893,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_violation_id":"252270787","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194432158","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"},{"id":4329894,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_violation_id":"252270788","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194432158","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"},{"id":4329895,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_violation_id":"252270789","seq_no":"7","part_no":"396","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"194432157","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"396"}],"inspection_per_units":[{"id":4542097,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_unit_id":"194432157","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-886","insp_unit_license":"20P069M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X9DJ360886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:48.000000Z","updated_at":"2025-03-17T22:38:48.000000Z"},{"id":4542098,"change_date":"2023-04-17 21:41:00","inspection_id":"78369140","insp_unit_id":"194432158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"V-894","insp_unit_license":"242764F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"591SD3420KR156894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:48.000000Z","updated_at":"2025-03-17T22:38:48.000000Z"}]},{"id":2778349,"change_date":"2023-04-11 21:40:00","inspection_id":"78320006","dot_number":"3733087","report_state":"TX","report_number":"6JZ99DGANJ","insp_date":"2023-04-05 00:00:00","insp_start_time":"0903","insp_end_time":"0957","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0646 IN GALVESTON CO. (586-","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":"2023-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"8950664","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-04-11 21:40:00","snet_input_date":"2023-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:17:44.000000Z","updated_at":"2025-03-17T19:17:44.000000Z","inspection_violations":[{"id":4265257,"change_date":"2023-04-11 21:40:00","inspection_id":"78320006","insp_violation_id":"252159355","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194329307","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:57.000000Z","updated_at":"2025-03-17T21:26:57.000000Z","normalized_code":"3922"},{"id":4265258,"change_date":"2023-04-11 21:40:00","inspection_id":"78320006","insp_violation_id":"252159356","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"194329307","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:57.000000Z","updated_at":"2025-03-17T21:26:57.000000Z","normalized_code":"39355D2"}],"inspection_per_units":[{"id":4472547,"change_date":"2023-04-11 21:40:00","inspection_id":"78320006","insp_unit_id":"194329306","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-886","insp_unit_license":"58Y037V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X9DJ360886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:14.000000Z","updated_at":"2025-03-17T22:38:14.000000Z"},{"id":4472548,"change_date":"2023-04-11 21:40:00","inspection_id":"78320006","insp_unit_id":"194329307","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"V-894","insp_unit_license":"242764F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"591SD3420KR156894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:14.000000Z","updated_at":"2025-03-17T22:38:14.000000Z"}]},{"id":2887989,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","dot_number":"3733087","report_state":"TX","report_number":"6JZA9DHP1L","insp_date":"2023-04-05 00:00:00","insp_start_time":"1047","insp_end_time":"1117","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1650  GUN RANGE RD","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":"2023-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102500","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":"8962159","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[{"id":4431492,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_violation_id":"252429628","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194576729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3939A"},{"id":4431493,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_violation_id":"252429629","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194576729","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39617C"},{"id":4431494,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_violation_id":"252429630","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194576729","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39378"},{"id":4431495,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_violation_id":"252429631","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194576729","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39360C"},{"id":4431496,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_violation_id":"252429632","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194576729","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3965B"},{"id":4431497,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_violation_id":"252429633","seq_no":"5","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"194576729","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39379"}],"inspection_per_units":[{"id":4646801,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_unit_id":"194576729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"68Y037V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HSHXSJR5CJ546354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"},{"id":4646802,"change_date":"2023-04-25 21:40:00","inspection_id":"78444013","insp_unit_id":"194576730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"70Y037V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C26FA000613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":2668370,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","dot_number":"3733087","report_state":"TX","report_number":"6JL99DGX7L","insp_date":"2023-03-22 00:00:00","insp_start_time":"0850","insp_end_time":"0951","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8200  RED BLUFF N\/B","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-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"8938046","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:15:52.000000Z","updated_at":"2025-03-17T19:15:52.000000Z","inspection_violations":[{"id":4102295,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888175","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194081965","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"},{"id":4102296,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888176","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194081964","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39345D"},{"id":4102297,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888177","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194081964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3965B"},{"id":4102298,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888178","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194081965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3939A"},{"id":4102299,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888179","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194081965","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39375A3"},{"id":4102300,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888180","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194081964","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"},{"id":4102301,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888181","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194081965","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"},{"id":4102302,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888182","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194081965","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"},{"id":4102303,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_violation_id":"251888183","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194081964","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4296764,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_unit_id":"194081964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"108","insp_unit_license":"33P034M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X1EJ419186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"},{"id":4296765,"change_date":"2023-03-27 21:40:00","inspection_id":"78194018","insp_unit_id":"194081965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BW3487","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3423L1038389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]},{"id":2667794,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","dot_number":"3733087","report_state":"TX","report_number":"6JJ89DNHUG","insp_date":"2023-03-20 00:00:00","insp_start_time":"0715","insp_end_time":"0847","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-03-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127200","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":"8937820","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-03-27 21:39:00","snet_input_date":"2023-03-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-27 21:39:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:15:51.000000Z","updated_at":"2025-03-17T19:15:51.000000Z","inspection_violations":[{"id":4100497,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_violation_id":"251885977","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194080797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3939A"},{"id":4100498,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_violation_id":"251885978","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194080797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39378"},{"id":4100499,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_violation_id":"251885979","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194080797","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39347E"},{"id":4100500,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_violation_id":"251885980","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"194080798","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"393205C"},{"id":4100501,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_violation_id":"251885981","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194080797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39311"},{"id":4100502,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_violation_id":"251885982","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194080797","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4295809,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_unit_id":"194080797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"109","insp_unit_license":"55S030M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP0X8FJ971420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"},{"id":4295810,"change_date":"2023-03-27 21:39:00","inspection_id":"78193389","insp_unit_id":"194080798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BW3489","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3421L1038567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]},{"id":2569512,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","dot_number":"3733087","report_state":"TX","report_number":"6J9B9DGX6J","insp_date":"2023-03-10 00:00:00","insp_start_time":"1102","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5000  NASA RD 1","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PORT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"17","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"17","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8927995","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[{"id":3953737,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640413","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"},{"id":3953738,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640414","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"},{"id":3953739,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640415","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"},{"id":3953740,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640416","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"},{"id":3953741,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640417","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39383G"},{"id":3953742,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640418","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39345D"},{"id":3953743,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640419","seq_no":"7","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39345"},{"id":3953744,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640420","seq_no":"8","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39360C"},{"id":3953745,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640421","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39347E"},{"id":3953746,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640422","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39353B"},{"id":3953747,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640423","seq_no":"11","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39355C2"},{"id":3953748,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640424","seq_no":"12","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39375A3"},{"id":3953749,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640425","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3939A"},{"id":3953750,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640426","seq_no":"14","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39345B2"},{"id":3953751,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640427","seq_no":"15","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"393100A"},{"id":3953752,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640428","seq_no":"16","part_no":"396","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"193851263","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"396"},{"id":3953753,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_violation_id":"251640429","seq_no":"17","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193851264","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4135736,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_unit_id":"193851263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"38P023M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5D49X36D651866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:39.000000Z","updated_at":"2025-03-17T22:35:39.000000Z"},{"id":4135737,"change_date":"2023-03-13 21:43:00","inspection_id":"78082145","insp_unit_id":"193851264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"139C877","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C25FA000568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:39.000000Z","updated_at":"2025-03-17T22:35:39.000000Z"}]},{"id":2569927,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","dot_number":"3733087","report_state":"TX","report_number":"6J9A9DGX6I","insp_date":"2023-03-10 00:00:00","insp_start_time":"1006","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5000  NASA RD 1","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PORT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"8927994","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[{"id":3955103,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642036","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193852035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"},{"id":3955104,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642037","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193852035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"},{"id":3955105,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642038","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193852034","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39345B2"},{"id":3955106,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642039","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193852034","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3965B"},{"id":3955107,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642040","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193852034","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39378"},{"id":3955108,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642041","seq_no":"6","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"193852034","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"393100A"},{"id":3955109,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642042","seq_no":"7","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193852034","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39383G"},{"id":3955110,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642043","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193852035","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39347E"},{"id":3955111,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_violation_id":"251642044","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"193852035","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":4136385,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_unit_id":"193852034","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"108","insp_unit_license":"25P023M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X1EJ419186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:39.000000Z","updated_at":"2025-03-17T22:35:39.000000Z"},{"id":4136386,"change_date":"2023-03-13 21:43:00","inspection_id":"78082597","insp_unit_id":"193852035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BW3487","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3423L1038389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:39.000000Z","updated_at":"2025-03-17T22:35:39.000000Z"}]},{"id":2534734,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","dot_number":"3733087","report_state":"TX","report_number":"6IZ99DGX5Y","insp_date":"2023-02-28 00:00:00","insp_start_time":"0915","insp_end_time":"1002","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5000  NASA RD 1","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-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"16","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"15","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8922782","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-02-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T19:13:22.000000Z","updated_at":"2025-03-17T19:13:22.000000Z","inspection_violations":[{"id":3896787,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548466","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39347E"},{"id":3896788,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548467","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39353B"},{"id":3896789,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548468","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3963A1"},{"id":3896790,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548469","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3939A"},{"id":3896791,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548470","seq_no":"12","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39360C"},{"id":3896792,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548471","seq_no":"13","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39378"},{"id":3896793,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548472","seq_no":"14","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"193773427","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39355C2"},{"id":3896794,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548473","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3963A1"},{"id":3896795,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548474","seq_no":"16","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39383G"},{"id":3896796,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548475","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:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"38323A2"},{"id":3896797,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548476","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"},{"id":3896798,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548477","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"},{"id":3896799,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548478","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193773427","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"},{"id":3896800,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548479","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193773427","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39617C"},{"id":3896801,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548480","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39347A"},{"id":3896802,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_violation_id":"251548481","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193773426","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":4080041,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_unit_id":"193773426","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5D49X36D651866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"},{"id":4080042,"change_date":"2023-03-08 21:41:00","inspection_id":"78042225","insp_unit_id":"193773427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"139C877","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C2XFA000288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"}]},{"id":1617165,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","dot_number":"3733087","report_state":"TX","report_number":"6FBD9DAWRG","insp_date":"2022-10-19 00:00:00","insp_start_time":"1441","insp_end_time":"1513","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3900  FM 528","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","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":"8812318","transaction_code":"A","transaction_date":"2022-10-27 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2022-10-27 21:41:00","snet_input_date":"2022-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-27 21:41:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T18:56:21.000000Z","updated_at":"2025-03-17T18:56:21.000000Z","inspection_violations":[{"id":2541339,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_violation_id":"249296733","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191681376","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"3922"},{"id":2541340,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_violation_id":"249296734","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191681377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"3922"},{"id":2541341,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_violation_id":"249296735","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191681377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"3922"},{"id":2541342,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_violation_id":"249296736","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191681376","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"39617C"},{"id":2541343,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_violation_id":"249296737","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191681377","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"39617C"},{"id":2541344,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_violation_id":"249296738","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191681376","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":2602402,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_unit_id":"191681376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"107","insp_unit_license":"558276G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X9DJ360886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:50.000000Z","updated_at":"2025-03-17T22:24:50.000000Z"},{"id":2602403,"change_date":"2022-10-27 21:41:00","inspection_id":"76993678","insp_unit_id":"191681377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"242764F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"591SD3420KR156894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:50.000000Z","updated_at":"2025-03-17T22:24:50.000000Z"}]},{"id":1370823,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","dot_number":"3733087","report_state":"TX","report_number":"6EKB9DGB6Y","insp_date":"2022-09-22 00:00:00","insp_start_time":"1133","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0646 IN GALVESTON CO. (586-","county_code_state":"TX","county_code":"167","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"8782427","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2022-09-26 21:40:00","snet_input_date":"2022-09-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-26 21:40:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T18:51:59.000000Z","updated_at":"2025-03-17T18:51:59.000000Z","inspection_violations":[{"id":2168808,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","insp_violation_id":"248656406","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191107074","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"39617C"},{"id":2168809,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","insp_violation_id":"248656407","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191107073","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3922"},{"id":2168810,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","insp_violation_id":"248656408","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191107074","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3922"},{"id":2168811,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","insp_violation_id":"248656409","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191107074","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2207673,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","insp_unit_id":"191107073","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"731F2G1","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X8FJ461601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:07.000000Z","updated_at":"2025-03-17T22:22:07.000000Z"},{"id":2207674,"change_date":"2022-09-26 21:40:00","inspection_id":"76708812","insp_unit_id":"191107074","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"V-8326","insp_unit_license":"0795A40","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3P9KT3421L1038326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:07.000000Z","updated_at":"2025-03-17T22:22:07.000000Z"}]},{"id":887045,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","dot_number":"3733087","report_state":"TX","report_number":"6CTA9DGB5E","insp_date":"2022-07-21 00:00:00","insp_start_time":"1004","insp_end_time":"1102","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0646 IN GALVESTON CO. (586-","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":"2022-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8722749","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2022-07-25 21:40:00","snet_input_date":"2022-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-25 21:40:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T18:43:22.000000Z","updated_at":"2025-03-17T18:43:22.000000Z","inspection_violations":[{"id":1397630,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295141","seq_no":"5","part_no":"392","part_no_section":"8","insp_viol_unit":"1","insp_unit_id":"189950202","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3928"},{"id":1397631,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295142","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189950202","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"39345D"},{"id":1397632,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295143","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189950202","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"39617C"},{"id":1397633,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295144","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189950203","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"39617C"},{"id":1397634,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295145","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189950202","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"},{"id":1397635,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295146","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189950202","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"},{"id":1397636,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295147","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189950203","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"},{"id":1397637,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_violation_id":"247295148","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189950202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1428255,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_unit_id":"189950202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"-1866","insp_unit_license":"316035G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5D49X36D651866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:58.000000Z","updated_at":"2025-03-17T22:16:58.000000Z"},{"id":1428256,"change_date":"2022-07-25 21:40:00","inspection_id":"76145182","insp_unit_id":"189950203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ARMC","insp_unit_company":"V0568","insp_unit_license":"139C877","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C2XFA000288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:58.000000Z","updated_at":"2025-03-17T22:16:58.000000Z"}]},{"id":410084,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","dot_number":"3733087","report_state":"TX","report_number":"6ATB9DAWM0","insp_date":"2022-05-10 00:00:00","insp_start_time":"1113","insp_end_time":"1140","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100 N FRIENDSWOOD DR","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8656033","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03733087","upload_search_indicator":"M","census_search_date":"2022-05-17 21:43:00","snet_input_date":"2022-05-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"FRANCISCO J GONZALEZ SANCHEZ","insp_carrier_street":"11319 SAGEHILL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1013410","created_at":"2025-03-17T18:34:47.000000Z","updated_at":"2025-03-17T18:34:47.000000Z","inspection_violations":[{"id":641962,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852271","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188736232","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39378"},{"id":641963,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852272","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"188736233","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39355D2"},{"id":641964,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852273","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188736232","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39311"},{"id":641965,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852274","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"188736233","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39345B2"},{"id":641966,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852275","seq_no":"5","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"188736232","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"393209E"},{"id":641967,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852276","seq_no":"6","part_no":"392","part_no_section":"2","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-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"},{"id":641968,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852277","seq_no":"7","part_no":"392","part_no_section":"2","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-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"},{"id":641969,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_violation_id":"245852278","seq_no":"9","part_no":"392","part_no_section":"2","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-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":662221,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_unit_id":"188736232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"123681G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDP9X1EJ419186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"},{"id":662222,"change_date":"2022-05-17 21:43:00","inspection_id":"75582246","insp_unit_id":"188736233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BP2747","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3P9KT3423L1038389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3733087\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3733087\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3733087\/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\/3733087\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}