{"current_page":1,"data":[{"id":11239084,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","dot_number":"3464880","report_state":"TX","report_number":"7D0C9DGRKS","insp_date":"2026-02-13 00:00:00","insp_start_time":"1239","insp_end_time":"1307","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  OLD SPANISH TR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RELIANT","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":"2026-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"9861425","transaction_code":"C","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2026-03-01T10:39:03.000000Z","updated_at":"2026-03-10T09:31:24.000000Z","inspection_violations":[{"id":18902298,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099494","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"3922RG"},{"id":18902299,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099495","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"3922RG"},{"id":18902300,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099496","seq_no":"4","part_no":"393","part_no_section":"83E","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"39383E"},{"id":18902301,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099497","seq_no":"5","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"393203C"},{"id":18902302,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099498","seq_no":"6","part_no":"393","part_no_section":"203A","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"393203A"},{"id":18902303,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099499","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"3939"},{"id":18902304,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099500","seq_no":"8","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"3939T"},{"id":18902305,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099501","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"3939"},{"id":18902306,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099502","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"3939"},{"id":18902307,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_violation_id":"272099503","seq_no":"11","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"211887508","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-02T10:58:55.000000Z","updated_at":"2026-03-10T09:44:32.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":19236883,"change_date":"2026-02-27 21:42:00","inspection_id":"87151702","insp_unit_id":"211887508","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HXX3173","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X32R883640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:27.000000Z","updated_at":"2026-03-10T09:06:02.000000Z"}]},{"id":9251199,"change_date":"2025-07-25 21:40:00","inspection_id":"85323008","dot_number":"3464880","report_state":"TX","report_number":"77979DHZ2W","insp_date":"2025-07-21 00:00:00","insp_start_time":"0715","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11600  S SAM HOUSTON","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9647714","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-07-30T10:01:23.000000Z","updated_at":"2025-07-30T10:01:23.000000Z","inspection_violations":[{"id":14983179,"change_date":"2025-07-25 21:40:00","inspection_id":"85323008","insp_violation_id":"267661554","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:51.000000Z","updated_at":"2025-07-29T10:43:46.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":15225031,"change_date":"2025-07-25 21:40:00","inspection_id":"85323008","insp_unit_id":"208086600","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HXX3173","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X32R883640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:37.000000Z","updated_at":"2025-07-29T09:46:05.000000Z"}]},{"id":9178175,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","dot_number":"3464880","report_state":"TX","report_number":"V251941135","insp_date":"2025-07-15 00:00:00","insp_start_time":"0742","insp_end_time":"0823","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5916 SAM HOUSTON TLW","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9640762","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-07-21T10:43:19.000000Z","updated_at":"2025-07-21T10:43:19.000000Z","inspection_violations":[{"id":14822329,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476852","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"393209D"},{"id":14822330,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476853","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"39347E"},{"id":14822331,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476854","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"39351"},{"id":14822332,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476855","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"39353B"},{"id":14822333,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476856","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"39378"},{"id":14822334,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476857","seq_no":"6","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"39383G"},{"id":14822335,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476858","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"3939"},{"id":14822336,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476859","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"3939"},{"id":14822337,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_violation_id":"267476860","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207932454","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:46.000000Z","updated_at":"2025-07-21T10:45:46.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":15082427,"change_date":"2025-07-17 21:42:00","inspection_id":"85246161","insp_unit_id":"207932454","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"20","insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:32.000000Z","updated_at":"2025-07-21T09:46:10.000000Z"}]},{"id":8384563,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","dot_number":"3464880","report_state":"TX","report_number":"V251832364","insp_date":"2025-04-10 00:00:00","insp_start_time":"1243","insp_end_time":"1331","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9500 HALL RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9551095","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-04-18T10:26:44.000000Z","updated_at":"2025-04-19T10:17:44.000000Z","inspection_violations":[{"id":13220363,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642458","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39021A"},{"id":13220364,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642459","seq_no":"2","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"393209D"},{"id":13220365,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642460","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39347E"},{"id":13220366,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642461","seq_no":"4","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39351"},{"id":13220367,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642462","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39353B"},{"id":13220368,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642463","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39378"},{"id":13220369,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642464","seq_no":"7","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39378"},{"id":13220370,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642465","seq_no":"8","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39383G"},{"id":13220371,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642466","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"3939"},{"id":13220372,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642467","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"3939"},{"id":13220373,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642468","seq_no":"11","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"39395A"},{"id":13220374,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_violation_id":"265642469","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206329495","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:03:50.000000Z","updated_at":"2025-04-18T11:14:20.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13609291,"change_date":"2025-04-15 21:41:00","inspection_id":"84408592","insp_unit_id":"206329495","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"20","insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:16:55.000000Z","updated_at":"2025-04-19T10:04:18.000000Z"}]},{"id":9962902,"change_date":"2025-10-16 21:40:00","inspection_id":"86071090","dot_number":"3464880","report_state":"TX","report_number":"745A9DCB2Z","insp_date":"2025-03-31 00:00:00","insp_start_time":"1010","insp_end_time":"1044","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5200  MESA DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LBJ PROJECT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9727874","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-10-19T10:01:48.000000Z","updated_at":"2025-10-20T10:01:16.000000Z","inspection_violations":[{"id":16453095,"change_date":"2025-10-16 21:40:00","inspection_id":"86071090","insp_violation_id":"269346769","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209511523","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:49.000000Z","updated_at":"2025-10-20T10:16:56.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16541387,"change_date":"2025-10-16 21:40:00","inspection_id":"86071090","insp_unit_id":"209511523","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"624","insp_unit_license":"VVC8393","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y3XW106331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:00.000000Z","updated_at":"2025-10-20T09:46:30.000000Z"}]},{"id":7971045,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","dot_number":"3464880","report_state":"TX","report_number":"737C9DJW35","insp_date":"2025-02-25 00:00:00","insp_start_time":"1248","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"18","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"16","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9508091","transaction_code":"C","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12454847,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746565","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"38323A2"},{"id":12454848,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746566","seq_no":"2","part_no":"391","part_no_section":"11B4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39111B4"},{"id":12454849,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746567","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39021A"},{"id":12454850,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746568","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3922RG"},{"id":12454851,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746569","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39617C"},{"id":12454852,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746570","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3922RG"},{"id":12454853,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746571","seq_no":"7","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39395A"},{"id":12454854,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746572","seq_no":"8","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39395F"},{"id":12454855,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746573","seq_no":"9","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39378"},{"id":12454856,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746574","seq_no":"10","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3939H"},{"id":12454857,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746575","seq_no":"11","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3939TS"},{"id":12454858,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746576","seq_no":"12","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3939TS"},{"id":12454859,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746577","seq_no":"13","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3939"},{"id":12454860,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746578","seq_no":"14","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39328"},{"id":12454861,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746579","seq_no":"15","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3939"},{"id":12454862,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746580","seq_no":"17","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3922RG"},{"id":12454863,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746581","seq_no":"18","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3939"},{"id":12454864,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_violation_id":"264746582","seq_no":"19","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"205545065","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":12868158,"change_date":"2025-02-27 21:42:00","inspection_id":"83973349","insp_unit_id":"205545065","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7946009,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","dot_number":"3464880","report_state":"TX","report_number":"73089DCK19","insp_date":"2025-02-18 00:00:00","insp_start_time":"0844","insp_end_time":"0903","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6300 S LAKE HOUSTON","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARO HERNANDEZ","shipping_paper_number":"10","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"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":"9505249","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[{"id":12414794,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667466","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39395A"},{"id":12414795,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667467","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39378"},{"id":12414796,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667468","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39351"},{"id":12414797,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667469","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3939"},{"id":12414798,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667470","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3939H"},{"id":12414799,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667471","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39311"},{"id":12414800,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667472","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39311"},{"id":12414801,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667473","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39311"},{"id":12414802,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_violation_id":"264667474","seq_no":"10","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205471062","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12827195,"change_date":"2025-02-24 21:40:00","inspection_id":"83947147","insp_unit_id":"205471062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"HXX3173","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X32R883640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":7574499,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","dot_number":"3464880","report_state":"TX","report_number":"71P99DJVXD","insp_date":"2025-01-02 00:00:00","insp_start_time":"0912","insp_end_time":"0949","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9468630","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-08 21:39:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T20:55:18.000000Z","updated_at":"2025-03-17T20:55:18.000000Z","inspection_violations":[{"id":11841194,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263818995","seq_no":"1","part_no":"383","part_no_section":"25A1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"38325A1"},{"id":11841195,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263818996","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"3922RG"},{"id":11841196,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263818997","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"39360C"},{"id":11841197,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263818998","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"3939"},{"id":11841198,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263818999","seq_no":"5","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"3965B"},{"id":11841199,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263819000","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"39347E"},{"id":11841200,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263819001","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"39347E"},{"id":11841201,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263819002","seq_no":"9","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"39353B"},{"id":11841202,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_violation_id":"263819003","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"204708627","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":12221349,"change_date":"2025-01-08 21:39:00","inspection_id":"83557046","insp_unit_id":"204708627","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"VVC8393","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y3XW106331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:55.000000Z","updated_at":"2025-03-17T23:49:55.000000Z"}]},{"id":4386089,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","dot_number":"3464880","report_state":"TX","report_number":"6PZA9DCCAY","insp_date":"2023-11-07 00:00:00","insp_start_time":"1010","insp_end_time":"1102","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5835  MYKAWA RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"18","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"18","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9120551","transaction_code":"A","transaction_date":"2023-11-08 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2023-11-08 21:41:00","snet_input_date":"2023-11-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T19:49:51.000000Z","updated_at":"2025-03-17T19:49:51.000000Z","inspection_violations":[{"id":6786025,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297701","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39347E"},{"id":6786026,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297702","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39353B"},{"id":6786027,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297703","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3922"},{"id":6786028,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297704","seq_no":"5","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39375B"},{"id":6786029,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297705","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39375C"},{"id":6786030,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297706","seq_no":"8","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39375A1"},{"id":6786031,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297707","seq_no":"9","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39378"},{"id":6786032,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297708","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39378"},{"id":6786033,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297709","seq_no":"11","part_no":"393","part_no_section":"209(b)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"393209B"},{"id":6786034,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297710","seq_no":"12","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"393203C"},{"id":6786035,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297711","seq_no":"13","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"999"},{"id":6786036,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297712","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3939A"},{"id":6786037,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297713","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3939A"},{"id":6786038,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297714","seq_no":"16","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3939A"},{"id":6786039,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297715","seq_no":"17","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39311"},{"id":6786040,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297716","seq_no":"18","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39375A3"},{"id":6786041,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297717","seq_no":"19","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"393209D"},{"id":6786042,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_violation_id":"256297718","seq_no":"20","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197975369","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7054038,"change_date":"2023-11-08 21:41:00","inspection_id":"80120600","insp_unit_id":"197975369","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"}]},{"id":3612184,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","dot_number":"3464880","report_state":"TX","report_number":"6MZ99DIA2N","insp_date":"2023-07-22 00:00:00","insp_start_time":"0912","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9800  SOUTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9038384","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2023-07-27 21:41:00","snet_input_date":"2023-07-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-27 21:41:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T19:34:14.000000Z","updated_at":"2025-03-17T19:34:14.000000Z","inspection_violations":[{"id":5571761,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327131","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"},{"id":5571762,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327132","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5571763,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327133","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5571764,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327134","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39311"},{"id":5571765,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327135","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5571766,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327136","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39375C"},{"id":5571767,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_violation_id":"254327137","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196234971","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5807825,"change_date":"2023-07-27 21:41:00","inspection_id":"79260067","insp_unit_id":"196234971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"20","insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:51.000000Z","updated_at":"2025-03-17T22:48:51.000000Z"}]},{"id":3004263,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","dot_number":"3464880","report_state":"TX","report_number":"6KR79DBQ03","insp_date":"2023-05-03 00:00:00","insp_start_time":"0643","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4900  MASSEY OAKS TR","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"15","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8974525","transaction_code":"C","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2023-05-09 21:43:00","snet_input_date":"2023-05-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T19:22:36.000000Z","updated_at":"2025-03-17T19:22:36.000000Z","inspection_violations":[{"id":4613973,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812762","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39395A"},{"id":4613974,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812763","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39378"},{"id":4613975,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812764","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39378"},{"id":4613976,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812765","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3939A"},{"id":4613977,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812766","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3939A"},{"id":4613978,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812767","seq_no":"6","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"393203C"},{"id":4613979,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812768","seq_no":"7","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"393209D"},{"id":4613980,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812769","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3939A"},{"id":4613981,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812770","seq_no":"9","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39311"},{"id":4613982,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812771","seq_no":"10","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"393203A"},{"id":4613983,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812772","seq_no":"11","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39375A3"},{"id":4613984,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812773","seq_no":"12","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39375C"},{"id":4613985,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812774","seq_no":"13","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3922"},{"id":4613986,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812775","seq_no":"14","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3922"},{"id":4613987,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_violation_id":"252812776","seq_no":"15","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194913424","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4833905,"change_date":"2023-05-12 21:43:00","inspection_id":"78575527","insp_unit_id":"194913424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"20","insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:04.000000Z","updated_at":"2025-03-17T22:41:04.000000Z"}]},{"id":1297576,"change_date":"2022-09-15 21:40:00","inspection_id":"76623834","dot_number":"3464880","report_state":"TX","report_number":"6E6D9DBQ91","insp_date":"2022-09-08 00:00:00","insp_start_time":"1306","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3200  HARKEY RD","county_code_state":"TX","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAZORIA DRNG DST 4","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8773262","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2022-09-15 21:40:00","snet_input_date":"2022-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T18:50:31.000000Z","updated_at":"2025-03-17T18:50:31.000000Z","inspection_violations":[{"id":2053231,"change_date":"2022-09-15 21:40:00","inspection_id":"76623834","insp_violation_id":"248450138","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190929912","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"3922"},{"id":2053232,"change_date":"2022-09-15 21:40:00","inspection_id":"76623834","insp_violation_id":"248450139","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190929912","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"3922"},{"id":2053233,"change_date":"2022-09-15 21:40:00","inspection_id":"76623834","insp_violation_id":"248450140","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190929912","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2088795,"change_date":"2022-09-15 21:40:00","inspection_id":"76623834","insp_unit_id":"190929912","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"20","insp_unit_license":"HXX3174","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9XX2R883652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:19.000000Z","updated_at":"2025-03-17T22:21:19.000000Z"}]},{"id":886973,"change_date":"2022-07-25 21:40:00","inspection_id":"76145101","dot_number":"3464880","report_state":"TX","report_number":"6CT90AIMRN","insp_date":"2022-07-21 00:00:00","insp_start_time":"0851","insp_end_time":"0923","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0069 IN JEFFERSON CO. (514-","county_code_state":"TX","county_code":"245","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":"N","pen_cen_match":null,"final_status_date":"2022-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8722543","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":"03464880","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":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T18:43:22.000000Z","updated_at":"2025-03-17T18:43:22.000000Z","inspection_violations":[{"id":1397273,"change_date":"2022-07-25 21:40:00","inspection_id":"76145101","insp_violation_id":"247294730","seq_no":"1","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"189950051","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":"393203"},{"id":1397274,"change_date":"2022-07-25 21:40:00","inspection_id":"76145101","insp_violation_id":"247294731","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189950051","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"},{"id":1397275,"change_date":"2022-07-25 21:40:00","inspection_id":"76145101","insp_violation_id":"247294732","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189950051","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":1428124,"change_date":"2022-07-25 21:40:00","inspection_id":"76145101","insp_unit_id":"189950051","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"71","insp_unit_license":"BSD0552","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y3XW106331","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":620300,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","dot_number":"3464880","report_state":"TX","report_number":"6BL80AMWNC","insp_date":"2022-06-07 00:00:00","insp_start_time":"0830","insp_end_time":"0908","registration_date":"2022-06-30 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"BISSONNET","county_code_state":"TX","county_code":"157","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":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8681931","transaction_code":"C","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T18:38:45.000000Z","updated_at":"2025-03-17T18:38:45.000000Z","inspection_violations":[{"id":974992,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836370","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39351"},{"id":974993,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836371","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39378"},{"id":974994,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836372","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39021A"},{"id":974995,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836373","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3939A"},{"id":974996,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836374","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39311"},{"id":974997,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836375","seq_no":"6","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"393203C"},{"id":974998,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836376","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39348A"},{"id":974999,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836377","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39348A"},{"id":975000,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836378","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39348A"},{"id":975001,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836379","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3963A1"},{"id":975002,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836380","seq_no":"11","part_no":"393","part_no_section":"83(b)","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39383B"},{"id":975003,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_violation_id":"246836381","seq_no":"12","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"189558185","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":997732,"change_date":"2022-06-30 21:42:00","inspection_id":"75832381","insp_unit_id":"189558185","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"HXX3173","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X32R883640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]},{"id":323609,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","dot_number":"3464880","report_state":"TX","report_number":"6AHG9DBSCB","insp_date":"2022-04-28 00:00:00","insp_start_time":"1647","insp_end_time":"1723","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7400  AIRPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK UP SITE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"13","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8644731","transaction_code":"C","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03464880","upload_search_indicator":"M","census_search_date":"2022-05-04 21:42:00","snet_input_date":"2022-04-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-04 21:42:00","insp_carrier_name":"ALVARO HERRERA HERNANDEZ","insp_carrier_street":"235 PINEMONT DR","insp_carrier_city":"SOUR LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77659-9260","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0993039","created_at":"2025-03-17T18:33:18.000000Z","updated_at":"2025-03-17T18:33:18.000000Z","inspection_violations":[{"id":506253,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681004","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39021A"},{"id":506254,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681005","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39360C"},{"id":506255,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681006","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39378"},{"id":506256,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681007","seq_no":"4","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39351"},{"id":506257,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681008","seq_no":"5","part_no":"393","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39324D"},{"id":506258,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681009","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"3939A"},{"id":506259,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681010","seq_no":"7","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39319"},{"id":506260,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681011","seq_no":"8","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"393203C"},{"id":506261,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681012","seq_no":"9","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39367C7V"},{"id":506262,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681013","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39311"},{"id":506263,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681014","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"3939A"},{"id":506264,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681015","seq_no":"12","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39375C"},{"id":506265,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_violation_id":"245681016","seq_no":"13","part_no":"393","part_no_section":"83(a)","insp_viol_unit":"1","insp_unit_id":"188588116","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39383A"}],"inspection_per_units":[{"id":523679,"change_date":"2022-05-09 21:42:00","inspection_id":"75478980","insp_unit_id":"188588116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HXX3173","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X32R883640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:24.000000Z","updated_at":"2025-03-17T22:11:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3464880\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3464880\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3464880\/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\/3464880\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}