{"current_page":1,"data":[{"id":12262034,"change_date":"2026-06-23 21:39:00","inspection_id":"88220922","dot_number":"2935539","report_state":"TX","report_number":"V262437598","insp_date":"2026-06-19 00:00:00","insp_start_time":"1452","insp_end_time":"1531","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6336 US77","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADOS FREIGHT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10003833","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2026-06-26T09:41:00.000000Z","updated_at":"2026-07-04T09:31:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21293220,"change_date":"2026-06-23 21:39:00","inspection_id":"88220922","insp_unit_id":"214248122","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R706355","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:32.000000Z","updated_at":"2026-07-05T09:05:04.000000Z"},{"id":21293221,"change_date":"2026-06-23 21:39:00","inspection_id":"88220922","insp_unit_id":"214248123","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COMM","insp_unit_company":"03","insp_unit_license":"150C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532B5BL367265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:32.000000Z","updated_at":"2026-07-05T09:05:04.000000Z"}]},{"id":12261401,"change_date":"2026-06-23 21:39:00","inspection_id":"88220267","dot_number":"2935539","report_state":"TX","report_number":"V262415870","insp_date":"2026-06-17 00:00:00","insp_start_time":"1627","insp_end_time":"1642","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH186","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"111000","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":"10003474","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2026-06-26T09:40:59.000000Z","updated_at":"2026-07-04T09:31:09.000000Z","inspection_violations":[{"id":21342689,"change_date":"2026-06-23 21:39:00","inspection_id":"88220267","insp_violation_id":"275084266","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214246912","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:44.000000Z","updated_at":"2026-07-04T09:44:04.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":21292092,"change_date":"2026-06-23 21:39:00","inspection_id":"88220267","insp_unit_id":"214246912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:30.000000Z","updated_at":"2026-07-05T09:04:56.000000Z"},{"id":21292093,"change_date":"2026-06-23 21:39:00","inspection_id":"88220267","insp_unit_id":"214246913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"40","insp_unit_license":"36US5X","insp_unit_license_state":"NL","insp_unit_vehicle_id_number":"1UYVS2530K2752417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:30.000000Z","updated_at":"2026-07-05T09:04:56.000000Z"}]},{"id":12130393,"change_date":"2026-06-09 10:50:00","inspection_id":"88076438","dot_number":"2935539","report_state":"TX","report_number":"V262383250","insp_date":"2026-06-03 00:00:00","insp_start_time":"2103","insp_end_time":"2140","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"710M US77 NB","county_code_state":"TX","county_code":"273","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RCF DISTRIBUTORS LLC","shipping_paper_number":"556790","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-09 10:50:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9983389","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-09 10:50:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2026-06-12T09:39:53.000000Z","updated_at":"2026-06-20T09:31:50.000000Z","inspection_violations":[{"id":21112475,"change_date":"2026-06-09 10:50:00","inspection_id":"88076438","insp_violation_id":"274772623","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:58:43.000000Z","updated_at":"2026-06-19T09:45:38.000000Z","normalized_code":"3922W"},{"id":21112476,"change_date":"2026-06-09 10:50:00","inspection_id":"88076438","insp_violation_id":"274772624","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:58:43.000000Z","updated_at":"2026-06-19T09:45:38.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21075144,"change_date":"2026-06-09 10:50:00","inspection_id":"88076438","insp_unit_id":"213977109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:32.000000Z","updated_at":"2026-06-20T09:03:21.000000Z"},{"id":21075145,"change_date":"2026-06-09 10:50:00","inspection_id":"88076438","insp_unit_id":"213977110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"2417","insp_unit_license":"36US5X","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2530K2752417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:32.000000Z","updated_at":"2026-06-20T09:03:21.000000Z"}]},{"id":12043978,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","dot_number":"2935539","report_state":"TX","report_number":"V262368420","insp_date":"2026-05-24 00:00:00","insp_start_time":"1529","insp_end_time":"1627","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"21410 IH45 SB SVC RD","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9972074","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-28 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2026-06-01T09:40:04.000000Z","updated_at":"2026-06-08T09:31:49.000000Z","inspection_violations":[{"id":20956462,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","insp_violation_id":"274564466","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"213805568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"39319"},{"id":20956463,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","insp_violation_id":"274564467","seq_no":"2","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"213805568","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"39355C1"},{"id":20956464,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","insp_violation_id":"274564468","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213805568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"3939"},{"id":20956465,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","insp_violation_id":"274564469","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"213805568","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"3939TS"},{"id":20956466,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","insp_violation_id":"274564470","seq_no":"5","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"3958E"}],"inspection_per_units":[{"id":20933303,"change_date":"2026-05-28 21:42:00","inspection_id":"87984709","insp_unit_id":"213805568","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R706355","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:22.000000Z","updated_at":"2026-06-08T09:04:09.000000Z"}]},{"id":12031413,"change_date":"2026-05-27 21:40:00","inspection_id":"87971631","dot_number":"2935539","report_state":"TX","report_number":"V262347642","insp_date":"2026-05-23 00:00:00","insp_start_time":"2317","insp_end_time":"2331","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH186 E FM88","county_code_state":"TX","county_code":"489","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNRISE PRODUCE LLC","shipping_paper_number":"SP378636","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-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9971687","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2026-05-30T09:39:37.000000Z","updated_at":"2026-06-07T09:31:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20912363,"change_date":"2026-05-27 21:40:00","inspection_id":"87971631","insp_unit_id":"213780331","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:45.000000Z","updated_at":"2026-06-07T09:03:20.000000Z"},{"id":20912364,"change_date":"2026-05-27 21:40:00","inspection_id":"87971631","insp_unit_id":"213780332","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"40","insp_unit_license":"36US5X","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2530K2752417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:45.000000Z","updated_at":"2026-06-07T09:03:20.000000Z"}]},{"id":11645116,"change_date":"2026-04-14 21:39:00","inspection_id":"87574527","dot_number":"2935539","report_state":"TX","report_number":"V262299277","insp_date":"2026-04-12 00:00:00","insp_start_time":"1644","insp_end_time":"1656","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 186 W FM 493","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119320","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9918681","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-14 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2026-04-25T09:31:13.000000Z","updated_at":"2026-04-25T09:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20256159,"change_date":"2026-04-14 21:39:00","inspection_id":"87574527","insp_unit_id":"213013310","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R706355","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:04:05.000000Z","updated_at":"2026-04-25T09:04:05.000000Z"},{"id":20256160,"change_date":"2026-04-14 21:39:00","inspection_id":"87574527","insp_unit_id":"213013311","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"181B093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538FU185870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:04:05.000000Z","updated_at":"2026-04-25T09:04:05.000000Z"}]},{"id":11615452,"change_date":"2026-04-10 21:38:00","inspection_id":"87543145","dot_number":"2935539","report_state":"LA","report_number":"LARGS01629","insp_date":"2026-04-08 00:00:00","insp_start_time":"1149","insp_end_time":"1200","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BREAUX BRIDGE LA","county_code_state":"LA","county_code":null,"insp_level_id":"3","service_center":"SH","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":"U","pen_cen_match":"I","final_status_date":"2026-04-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3140330","transaction_code":"A","transaction_date":"2026-04-10 00:00:00","upload_date":"2026-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2026-04-10 21:38:00","snet_input_date":"2026-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-10 21:38:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-13T10:09:28.000000Z","updated_at":"2026-04-21T09:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20202516,"change_date":"2026-04-10 21:38:00","inspection_id":"87543145","insp_unit_id":"212945132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"01","insp_unit_license":"R707164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X7HF406982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-13T10:01:42.000000Z","updated_at":"2026-04-21T09:03:55.000000Z"},{"id":20202517,"change_date":"2026-04-10 21:38:00","inspection_id":"87543145","insp_unit_id":"212945133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"15","insp_unit_license":"267B014","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2537T8516503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-13T10:01:42.000000Z","updated_at":"2026-04-21T09:03:55.000000Z"}]},{"id":9916406,"change_date":"2025-10-11 21:33:00","inspection_id":"86021585","dot_number":"2935539","report_state":"GA","report_number":"1178000133","insp_date":"2025-10-04 00:00:00","insp_start_time":"2217","insp_end_time":"2314","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LAGRANGE GA","county_code_state":"GA","county_code":"285","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SMITHFIELD","shipping_paper_number":"4304160450","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":"U","pen_cen_match":"I","final_status_date":"2025-10-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2396517","transaction_code":"A","transaction_date":"2025-10-11 00:00:00","upload_date":"2025-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2025-10-11 21:33:00","snet_input_date":"2025-10-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-11 21:33:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-14T10:01:33.000000Z","updated_at":"2025-10-15T10:00:17.000000Z","inspection_violations":[{"id":16363467,"change_date":"2025-10-11 21:33:00","inspection_id":"86021585","insp_violation_id":"269244782","seq_no":"1","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:33.000000Z","updated_at":"2025-10-15T10:15:29.000000Z","normalized_code":"39522GELDMFV"}],"inspection_per_units":[{"id":16456972,"change_date":"2025-10-11 21:33:00","inspection_id":"86021585","insp_unit_id":"209419555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-14T09:46:58.000000Z","updated_at":"2025-10-15T09:45:22.000000Z"},{"id":16456973,"change_date":"2025-10-11 21:33:00","inspection_id":"86021585","insp_unit_id":"209419556","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"6503","insp_unit_license":"267B014","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2537T8516503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-14T09:46:58.000000Z","updated_at":"2025-10-15T09:45:22.000000Z"}]},{"id":9570784,"change_date":"2025-09-02 21:40:00","inspection_id":"85659499","dot_number":"2935539","report_state":"TX","report_number":"V252003423","insp_date":"2025-08-28 00:00:00","insp_start_time":"1045","insp_end_time":"1137","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6361  US281 SB","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADOS FREIGHT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9682019","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-02 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-09-06T10:43:07.000000Z","updated_at":"2025-09-06T10:43:07.000000Z","inspection_violations":[{"id":18474047,"change_date":null,"inspection_id":"85659499","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18474048,"change_date":null,"inspection_id":"85659499","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"},{"id":18474049,"change_date":null,"inspection_id":"85659499","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3958"},{"id":18474046,"change_date":null,"inspection_id":"85659499","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":15798420,"change_date":"2025-09-02 21:40:00","inspection_id":"85659499","insp_unit_id":"208706093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R707164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X7HF406982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:20.000000Z","updated_at":"2025-09-09T09:47:20.000000Z"},{"id":15798421,"change_date":"2025-09-02 21:40:00","inspection_id":"85659499","insp_unit_id":"208706094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"10","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:20.000000Z","updated_at":"2025-09-09T09:47:20.000000Z"}]},{"id":9020947,"change_date":"2025-06-29 21:33:00","inspection_id":"85080645","dot_number":"2935539","report_state":"GA","report_number":"1178000104","insp_date":"2025-06-22 00:00:00","insp_start_time":"1651","insp_end_time":"1710","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEWNAN GA","county_code_state":"GA","county_code":"077","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HM PRODUCE","shipping_paper_number":"065030","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":"U","pen_cen_match":"I","final_status_date":"2025-06-29 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1928188","transaction_code":"A","transaction_date":"2025-06-28 00:00:00","upload_date":"2025-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2025-06-29 21:33:00","snet_input_date":"2025-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-29 21:33:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-03T10:01:26.000000Z","updated_at":"2025-07-03T10:01:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14795273,"change_date":"2025-06-29 21:33:00","inspection_id":"85080645","insp_unit_id":"207620878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"11","insp_unit_license":"R775403","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-02T09:45:21.000000Z","updated_at":"2025-07-03T09:45:07.000000Z"},{"id":14795274,"change_date":"2025-06-29 21:33:00","inspection_id":"85080645","insp_unit_id":"207620879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"NL","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-02T09:45:21.000000Z","updated_at":"2025-07-03T09:45:07.000000Z"}]},{"id":8923603,"change_date":"2025-06-17 21:42:00","inspection_id":"84977842","dot_number":"2935539","report_state":"TX","report_number":"V251915779","insp_date":"2025-06-13 00:00:00","insp_start_time":"2138","insp_end_time":"2206","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JSC PRODUCE","shipping_paper_number":"9559","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119320","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9609279","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-17 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-06-20T10:01:00.000000Z","updated_at":"2025-06-22T10:00:51.000000Z","inspection_violations":[{"id":14317091,"change_date":"2025-06-17 21:42:00","inspection_id":"84977842","insp_violation_id":"266900807","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"207434386","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-20T10:16:49.000000Z","updated_at":"2025-06-21T10:18:09.000000Z","normalized_code":"3929A2C"},{"id":14317092,"change_date":"2025-06-17 21:42:00","inspection_id":"84977842","insp_violation_id":"266900808","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"207434386","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:49.000000Z","updated_at":"2025-06-21T10:18:09.000000Z","normalized_code":"39355E"},{"id":14317093,"change_date":"2025-06-17 21:42:00","inspection_id":"84977842","insp_violation_id":"266900809","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207434386","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:49.000000Z","updated_at":"2025-06-21T10:18:09.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14623263,"change_date":"2025-06-17 21:42:00","inspection_id":"84977842","insp_unit_id":"207434385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R706355","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:08.000000Z","updated_at":"2025-06-22T09:46:11.000000Z"},{"id":14623264,"change_date":"2025-06-17 21:42:00","inspection_id":"84977842","insp_unit_id":"207434386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"181B093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538FU185870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:08.000000Z","updated_at":"2025-06-22T09:46:11.000000Z"}]},{"id":8229480,"change_date":"2025-03-27 21:42:00","inspection_id":"84245261","dot_number":"2935539","report_state":"TX","report_number":"V251799913","insp_date":"2025-03-23 00:00:00","insp_start_time":"0146","insp_end_time":"0216","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRESH VEG","shipping_paper_number":"20564-B","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9532457","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-30T10:38:48.000000Z","updated_at":"2025-03-31T10:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13312744,"change_date":"2025-03-27 21:42:00","inspection_id":"84245261","insp_unit_id":"206029677","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"R707164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X7HF406982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:28:03.000000Z","updated_at":"2025-03-31T10:08:41.000000Z"},{"id":13312745,"change_date":"2025-03-27 21:42:00","inspection_id":"84245261","insp_unit_id":"206029678","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:28:03.000000Z","updated_at":"2025-03-31T10:08:41.000000Z"}]},{"id":7729014,"change_date":"2025-01-28 21:39:00","inspection_id":"83719104","dot_number":"2935539","report_state":"TX","report_number":"V251766168","insp_date":"2025-01-25 00:00:00","insp_start_time":"1103","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US77 AT E COUNTY ROA","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADOS FREIGHT SERVICES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9485512","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-01-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:58:42.000000Z","updated_at":"2025-03-17T20:58:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12472627,"change_date":"2025-01-28 21:39:00","inspection_id":"83719104","insp_unit_id":"205046162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:37.000000Z","updated_at":"2025-03-17T23:52:37.000000Z"},{"id":12472628,"change_date":"2025-01-28 21:39:00","inspection_id":"83719104","insp_unit_id":"205046163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"03","insp_unit_license":"150C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532B5BL367265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:37.000000Z","updated_at":"2025-03-17T23:52:37.000000Z"}]},{"id":7546098,"change_date":"2025-01-08 21:39:00","inspection_id":"83527097","dot_number":"2935539","report_state":"TX","report_number":"71OA9DCDOK","insp_date":"2025-01-01 00:00:00","insp_start_time":"1018","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9464341","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-01-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:54:53.000000Z","updated_at":"2025-03-17T20:54:53.000000Z","inspection_violations":[{"id":11793595,"change_date":"2025-01-08 21:39:00","inspection_id":"83527097","insp_violation_id":"263818266","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204708376","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922RG"},{"id":11793596,"change_date":"2025-01-08 21:39:00","inspection_id":"83527097","insp_violation_id":"263818267","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204708377","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12175139,"change_date":"2025-01-08 21:39:00","inspection_id":"83527097","insp_unit_id":"204708376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R630430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:26.000000Z","updated_at":"2025-03-17T23:49:26.000000Z"},{"id":12175140,"change_date":"2025-01-08 21:39:00","inspection_id":"83527097","insp_unit_id":"204708377","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:26.000000Z","updated_at":"2025-03-17T23:49:26.000000Z"}]},{"id":8928962,"change_date":"2025-06-18 21:41:00","inspection_id":"84983643","dot_number":"2935539","report_state":"TN","report_number":"I033AG1260","insp_date":"2024-12-03 00:00:00","insp_start_time":"2300","insp_end_time":"2320","registration_date":null,"region":"ES","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"BROWN BAKERY","shipping_paper_number":"PIC1123295","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":"U","pen_cen_match":"I","final_status_date":"2025-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1120435","transaction_code":"A","transaction_date":"2024-12-05 00:00:00","upload_date":"2025-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2025-06-18 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-18 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:01:02.000000Z","updated_at":"2025-06-22T10:01:02.000000Z","inspection_violations":[{"id":14329605,"change_date":"2025-06-18 21:41:00","inspection_id":"84983643","insp_violation_id":"266912545","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-21T10:17:01.000000Z","updated_at":"2025-06-22T10:17:27.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":14633820,"change_date":"2025-06-18 21:41:00","inspection_id":"84983643","insp_unit_id":"207444453","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"08","insp_unit_license":"R550093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:18.000000Z","updated_at":"2025-06-22T09:46:18.000000Z"},{"id":14633821,"change_date":"2025-06-18 21:41:00","inspection_id":"84983643","insp_unit_id":"207444454","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"68UK3Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:18.000000Z","updated_at":"2025-06-22T09:46:18.000000Z"}]},{"id":6991252,"change_date":"2024-10-18 21:42:00","inspection_id":"82941531","dot_number":"2935539","report_state":"TX","report_number":"V241646609","insp_date":"2024-10-15 00:00:00","insp_start_time":"1300","insp_end_time":"1406","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9405667","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11276422,"change_date":"2024-10-18 21:42:00","inspection_id":"82941531","insp_unit_id":"203477679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"Y","insp_unit_decal_number":"34537417","created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"},{"id":11276423,"change_date":"2024-10-18 21:42:00","inspection_id":"82941531","insp_unit_id":"203477680","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"40","insp_unit_license":"36US5X","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2530K2752417","insp_unit_decal":"Y","insp_unit_decal_number":"34537418","created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"}]},{"id":6839665,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","dot_number":"2935539","report_state":"TX","report_number":"V241587097","insp_date":"2024-09-26 00:00:00","insp_start_time":"0930","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US S 77 MM 708","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARDOS FREIGHT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9388956","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:38:39.000000Z","updated_at":"2025-03-17T20:38:39.000000Z","inspection_violations":[{"id":10653933,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","insp_violation_id":"262079096","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"203170112","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39375C"},{"id":10653934,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","insp_violation_id":"262079097","seq_no":"2","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39522H2"},{"id":10653935,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","insp_violation_id":"262079098","seq_no":"3","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39524D"},{"id":10653936,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","insp_violation_id":"262079099","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":11030066,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","insp_unit_id":"203170111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"},{"id":11030067,"change_date":"2024-09-27 21:40:00","inspection_id":"82780438","insp_unit_id":"203170112","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"40","insp_unit_license":"36US5X","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2530K2752417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":6738767,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","dot_number":"2935539","report_state":"TX","report_number":"V241538161","insp_date":"2024-09-10 00:00:00","insp_start_time":"1333","insp_end_time":"1401","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US77 SB","county_code_state":"TX","county_code":"409","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9378210","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:36:34.000000Z","updated_at":"2025-03-17T20:36:34.000000Z","inspection_violations":[{"id":10493478,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_violation_id":"261833954","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"202951245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"39311"},{"id":10493479,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_violation_id":"261833955","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202951244","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"39360C"},{"id":10493480,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_violation_id":"261833956","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202951244","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"39378"},{"id":10493481,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_violation_id":"261833957","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202951244","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3939A"},{"id":10493482,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_violation_id":"261833958","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202951245","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10866510,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_unit_id":"202951244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"09","insp_unit_license":"R630431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDMAPR3FN194403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:34.000000Z","updated_at":"2025-03-17T23:35:34.000000Z"},{"id":10866511,"change_date":"2024-09-16 21:43:00","inspection_id":"82672803","insp_unit_id":"202951245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04","insp_unit_license":"123B397","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537GM418607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:34.000000Z","updated_at":"2025-03-17T23:35:34.000000Z"}]},{"id":6164882,"change_date":"2024-07-08 21:42:00","inspection_id":"82059933","dot_number":"2935539","report_state":"SC","report_number":"B315004118","insp_date":"2024-07-07 00:00:00","insp_start_time":"1049","insp_end_time":"1104","registration_date":null,"region":"ET","ci_status_code":"C","location":"102","location_desc":"I-20 WB ROADSIDE","county_code_state":"SC","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SMITHFIELD","shipping_paper_number":"4303543753","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1152806","transaction_code":"A","transaction_date":"2024-07-07 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-07 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:59.000000Z","updated_at":"2025-03-17T20:24:59.000000Z","inspection_violations":[{"id":9568510,"change_date":"2024-07-08 21:42:00","inspection_id":"82059933","insp_violation_id":"260507977","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9930718,"change_date":"2024-07-08 21:42:00","inspection_id":"82059933","insp_unit_id":"201771446","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R706355","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:56.000000Z","updated_at":"2025-03-17T23:25:56.000000Z"},{"id":9930719,"change_date":"2024-07-08 21:42:00","inspection_id":"82059933","insp_unit_id":"201771447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"181B093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538FU185870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:56.000000Z","updated_at":"2025-03-17T23:25:56.000000Z"}]},{"id":6121217,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","dot_number":"2935539","report_state":"TX","report_number":"V241468280","insp_date":"2024-06-29 00:00:00","insp_start_time":"1050","insp_end_time":"2344","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:27   10' 57.3N","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GARCIA FRESH VEGGIES","shipping_paper_number":"16544","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9314869","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:24:09.000000Z","updated_at":"2025-03-17T20:24:09.000000Z","inspection_violations":[{"id":9505093,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_violation_id":"260419015","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"201684347","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"39311"},{"id":9505094,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_violation_id":"260419016","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201684346","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3939A"},{"id":9505095,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_violation_id":"260419017","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3922"},{"id":9505096,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_violation_id":"260419018","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3922"},{"id":9505097,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_violation_id":"260419019","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9859855,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_unit_id":"201684346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"R630430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:09.000000Z","updated_at":"2025-03-17T23:25:09.000000Z"},{"id":9859856,"change_date":"2024-07-01 21:44:00","inspection_id":"82012952","insp_unit_id":"201684347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"68","insp_unit_license":"150C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532B5BL367265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:09.000000Z","updated_at":"2025-03-17T23:25:09.000000Z"}]},{"id":6009416,"change_date":"2024-06-17 21:46:00","inspection_id":"81892704","dot_number":"2935539","report_state":"TX","report_number":"V241450051","insp_date":"2024-06-15 00:00:00","insp_start_time":"2145","insp_end_time":"2215","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BAGLEY PRODUCE","shipping_paper_number":"97344","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9302491","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-17 21:46:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:21:52.000000Z","updated_at":"2025-03-17T20:21:52.000000Z","inspection_violations":[{"id":9324654,"change_date":"2024-06-17 21:46:00","inspection_id":"81892704","insp_violation_id":"260153163","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:08.000000Z","updated_at":"2025-03-17T21:51:08.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":9679137,"change_date":"2024-06-17 21:46:00","inspection_id":"81892704","insp_unit_id":"201450483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"R550093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"},{"id":9679138,"change_date":"2024-06-17 21:46:00","inspection_id":"81892704","insp_unit_id":"201450484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04","insp_unit_license":"68UK3Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":5789114,"change_date":"2024-05-20 21:41:00","inspection_id":"81653309","dot_number":"2935539","report_state":"US","report_number":"0904000781","insp_date":"2024-05-20 00:00:00","insp_start_time":"1436","insp_end_time":"1505","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX13","location_desc":"ROMA TX","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2024-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"497313","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2024-05-20 21:41:00","snet_input_date":"2024-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-20 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:30.000000Z","updated_at":"2025-03-17T20:17:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9324278,"change_date":"2024-05-20 21:41:00","inspection_id":"81653309","insp_unit_id":"200974449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"01","insp_unit_license":"2017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X7HF406982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:48.000000Z","updated_at":"2025-03-17T23:19:48.000000Z"},{"id":9324279,"change_date":"2024-05-20 21:41:00","inspection_id":"81653309","insp_unit_id":"200974450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"10","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:48.000000Z","updated_at":"2025-03-17T23:19:48.000000Z"}]},{"id":5668177,"change_date":"2024-05-04 21:31:00","inspection_id":"81522222","dot_number":"2935539","report_state":"US","report_number":"0904000745","insp_date":"2024-05-03 00:00:00","insp_start_time":"1412","insp_end_time":"1448","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX13","location_desc":"ROMA TX","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2024-05-04 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"451906","transaction_code":"A","transaction_date":"2024-05-04 00:00:00","upload_date":"2024-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2024-05-04 21:31:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-04 21:31:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:05.000000Z","updated_at":"2025-03-17T20:15:05.000000Z","inspection_violations":[{"id":8768470,"change_date":"2024-05-04 21:31:00","inspection_id":"81522222","insp_violation_id":"259314491","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200725310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:25.000000Z","updated_at":"2025-03-17T21:48:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9129311,"change_date":"2024-05-04 21:31:00","inspection_id":"81522222","insp_unit_id":"200725309","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"08","insp_unit_license":"R550093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:56.000000Z","updated_at":"2025-03-17T23:17:56.000000Z"},{"id":9129312,"change_date":"2024-05-04 21:31:00","inspection_id":"81522222","insp_unit_id":"200725310","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"04","insp_unit_license":"68UK3Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:56.000000Z","updated_at":"2025-03-17T23:17:56.000000Z"}]},{"id":5362472,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","dot_number":"2935539","report_state":"TX","report_number":"V241362827","insp_date":"2024-03-23 00:00:00","insp_start_time":"0122","insp_end_time":"0157","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US281 NB","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADOS FREIGHT SERVICES INC","shipping_paper_number":"0530960","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119320","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9231536","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:09:01.000000Z","updated_at":"2025-03-17T20:09:01.000000Z","inspection_violations":[{"id":8275792,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569859","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200075781","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39378"},{"id":8275793,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569860","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200075781","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8275794,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569861","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200075782","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8275795,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569862","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200075781","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8275796,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569863","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200075781","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3922"},{"id":8275797,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569864","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200075782","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3922"},{"id":8275798,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569865","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200075781","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3922"},{"id":8275799,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_violation_id":"258569866","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200075781","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8636272,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_unit_id":"200075781","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R706355","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"},{"id":8636273,"change_date":"2024-03-25 21:41:00","inspection_id":"81188763","insp_unit_id":"200075782","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"181B093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538FU185870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"}]},{"id":5333382,"change_date":"2024-03-20 21:43:00","inspection_id":"81157101","dot_number":"2935539","report_state":"TX","report_number":"V241350225","insp_date":"2024-03-19 00:00:00","insp_start_time":"1330","insp_end_time":"1354","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 77 SB IN RIVIERA","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DELIVERY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9228128","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8589101,"change_date":"2024-03-20 21:43:00","inspection_id":"81157101","insp_unit_id":"200014266","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"},{"id":8589102,"change_date":"2024-03-20 21:43:00","inspection_id":"81157101","insp_unit_id":"200014267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"17840","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"}]},{"id":5297776,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","dot_number":"2935539","report_state":"TX","report_number":"V241343864","insp_date":"2024-03-14 00:00:00","insp_start_time":"0027","insp_end_time":"0055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:27   10' 57.3N","county_code_state":"TX","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FRESHQUITA","shipping_paper_number":"6324","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9223939","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-15 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:07:32.000000Z","updated_at":"2025-03-17T20:07:32.000000Z","inspection_violations":[{"id":8170498,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_violation_id":"258414166","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199940313","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39617C"},{"id":8170499,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_violation_id":"258414167","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"},{"id":8170500,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_violation_id":"258414168","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"},{"id":8170501,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_violation_id":"258414169","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"},{"id":8170502,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_violation_id":"258414170","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8531623,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_unit_id":"199940313","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"R550093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:20.000000Z","updated_at":"2025-03-17T23:12:20.000000Z"},{"id":8531624,"change_date":"2024-03-15 21:40:00","inspection_id":"81118258","insp_unit_id":"199940314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"04","insp_unit_license":"68UK3Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:20.000000Z","updated_at":"2025-03-17T23:12:20.000000Z"}]},{"id":5147206,"change_date":"2024-02-27 21:40:00","inspection_id":"80954230","dot_number":"2935539","report_state":"TX","report_number":"V241317700","insp_date":"2024-02-22 00:00:00","insp_start_time":"2320","insp_end_time":"2353","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US281 SB SVC RD AT E","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADOS FREIGHT","shipping_paper_number":"2\/22\/2024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9209038","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-27 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T20:04:32.000000Z","updated_at":"2025-03-17T20:04:32.000000Z","inspection_violations":[{"id":7938680,"change_date":"2024-02-27 21:40:00","inspection_id":"80954230","insp_violation_id":"258069931","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"199627013","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:19.000000Z","updated_at":"2025-03-17T21:44:19.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":8287548,"change_date":"2024-02-27 21:40:00","inspection_id":"80954230","insp_unit_id":"199627012","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"},{"id":8287549,"change_date":"2024-02-27 21:40:00","inspection_id":"80954230","insp_unit_id":"199627013","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"}]},{"id":4827383,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","dot_number":"2935539","report_state":"TX","report_number":"V241289422","insp_date":"2024-01-09 00:00:00","insp_start_time":"1335","insp_end_time":"1411","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US S 281 MM 732","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARDO'S FREIGHT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9172025","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-12 21:43:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:58:26.000000Z","updated_at":"2025-03-17T19:58:26.000000Z","inspection_violations":[{"id":7443533,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_violation_id":"257327248","seq_no":"1","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"2","insp_unit_id":"198949367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"39313C3"},{"id":7443534,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_violation_id":"257327249","seq_no":"2","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"39522H1"},{"id":7443535,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_violation_id":"257327250","seq_no":"3","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"39522H2"},{"id":7443536,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_violation_id":"257327251","seq_no":"4","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"39524D"},{"id":7443537,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_violation_id":"257327252","seq_no":"5","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":7766808,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_unit_id":"198949366","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"},{"id":7766809,"change_date":"2024-01-12 21:43:00","inspection_id":"80604467","insp_unit_id":"198949367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":null,"insp_unit_license":"36US5X","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2530K2752417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"}]},{"id":4564962,"change_date":"2023-12-06 21:41:00","inspection_id":"80317404","dot_number":"2935539","report_state":"US","report_number":"0904000520","insp_date":"2023-12-05 00:00:00","insp_start_time":"1652","insp_end_time":"1722","registration_date":null,"region":"CS","ci_status_code":"C","location":"USTX13","location_desc":"ROMA TX","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-12-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119998","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"118908","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2023-12-06 21:41:00","snet_input_date":"2023-12-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-06 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:22.000000Z","updated_at":"2025-03-17T19:53:22.000000Z","inspection_violations":[{"id":7061305,"change_date":"2023-12-06 21:41:00","inspection_id":"80317404","insp_violation_id":"256732144","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198365301","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:08.000000Z","updated_at":"2025-03-17T21:40:08.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":7342097,"change_date":"2023-12-06 21:41:00","inspection_id":"80317404","insp_unit_id":"198365301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"09","insp_unit_license":"R630431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDMAPR3FN194403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:41.000000Z","updated_at":"2025-03-17T23:01:41.000000Z"},{"id":7342098,"change_date":"2023-12-06 21:41:00","inspection_id":"80317404","insp_unit_id":"198365302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"03","insp_unit_license":"150C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532B5BL367265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:41.000000Z","updated_at":"2025-03-17T23:01:41.000000Z"}]},{"id":4081066,"change_date":"2023-09-28 21:41:00","inspection_id":"79783042","dot_number":"2935539","report_state":"SC","report_number":"B087004634","insp_date":"2023-09-28 00:00:00","insp_start_time":"0915","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"107","location_desc":"I85 NORTHBOUND","county_code_state":"SC","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GAINESVILLE GA FRESH","shipping_paper_number":"0834480093","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108484","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-28 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-09-28 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:35.000000Z","updated_at":"2025-03-17T19:43:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6561334,"change_date":"2023-09-28 21:41:00","inspection_id":"79783042","insp_unit_id":"197293652","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"39","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:04.000000Z","updated_at":"2025-03-17T22:55:04.000000Z"},{"id":6561335,"change_date":"2023-09-28 21:41:00","inspection_id":"79783042","insp_unit_id":"197293653","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"17840","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:04.000000Z","updated_at":"2025-03-17T22:55:04.000000Z"}]},{"id":4073231,"change_date":"2023-09-27 21:42:00","inspection_id":"79774372","dot_number":"2935539","report_state":"TX","report_number":"V231152884","insp_date":"2023-09-21 00:00:00","insp_start_time":"1612","insp_end_time":"1631","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MILITARY RD AND FM 1","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-09-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117241","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":"9086917","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-27 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:43:13.000000Z","updated_at":"2025-03-17T19:43:13.000000Z","inspection_violations":[{"id":6305846,"change_date":"2023-09-27 21:42:00","inspection_id":"79774372","insp_violation_id":"255527218","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":6549302,"change_date":"2023-09-27 21:42:00","inspection_id":"79774372","insp_unit_id":"197277357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"R668835","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF35644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:57.000000Z","updated_at":"2025-03-17T22:54:57.000000Z"},{"id":6549303,"change_date":"2023-09-27 21:42:00","inspection_id":"79774372","insp_unit_id":"197277358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"10","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:57.000000Z","updated_at":"2025-03-17T22:54:57.000000Z"}]},{"id":4011161,"change_date":"2024-01-30 21:41:00","inspection_id":"79705066","dot_number":"2935539","report_state":"AL","report_number":"MBJP005708","insp_date":"2023-09-19 00:00:00","insp_start_time":"1635","insp_end_time":"1705","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CREOLA","county_code_state":"AL","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ACCELLA POLYURETANE SYSTEMS","shipping_paper_number":"2263241","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"973393","transaction_code":"C","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":"2023-09-25 21:40:00","snet_input_date":"2023-09-20 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:02.000000Z","updated_at":"2025-03-17T19:42:02.000000Z","inspection_violations":[{"id":6207256,"change_date":"2024-01-30 21:41:00","inspection_id":"79705066","insp_violation_id":"257557749","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3922"},{"id":6207257,"change_date":"2024-01-30 21:41:00","inspection_id":"79705066","insp_violation_id":"257557750","seq_no":"2","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39111B2"},{"id":6207258,"change_date":"2024-01-30 21:41:00","inspection_id":"79705066","insp_violation_id":"257557751","seq_no":"3","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":6449551,"change_date":"2024-01-30 21:41:00","inspection_id":"79705066","insp_unit_id":"199169551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R326300","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X0JF501471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:08.000000Z","updated_at":"2025-03-17T22:54:08.000000Z"},{"id":6449552,"change_date":"2024-01-30 21:41:00","inspection_id":"79705066","insp_unit_id":"199169552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"71UD4B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS25329M761618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:08.000000Z","updated_at":"2025-03-17T22:54:08.000000Z"}]},{"id":3827108,"change_date":"2023-08-24 21:42:00","inspection_id":"79500268","dot_number":"2935539","report_state":"TX","report_number":"V231126268","insp_date":"2023-08-22 00:00:00","insp_start_time":"1617","insp_end_time":"1641","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US281 SB AT MILLER R","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-08-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9060279","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-24 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:38:30.000000Z","updated_at":"2025-03-17T19:38:30.000000Z","inspection_violations":[{"id":5910035,"change_date":"2023-08-24 21:42:00","inspection_id":"79500268","insp_violation_id":"254873641","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39522H4"},{"id":5910036,"change_date":"2023-08-24 21:42:00","inspection_id":"79500268","insp_violation_id":"254873642","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39524D"},{"id":5910037,"change_date":"2023-08-24 21:42:00","inspection_id":"79500268","insp_violation_id":"254873643","seq_no":"4","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":6153387,"change_date":"2023-08-24 21:42:00","inspection_id":"79500268","insp_unit_id":"196719567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"R630430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"},{"id":6153388,"change_date":"2023-08-24 21:42:00","inspection_id":"79500268","insp_unit_id":"196719568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"30","insp_unit_license":"86UN5C","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532W06L994657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"}]},{"id":3604422,"change_date":"2023-07-27 21:39:00","inspection_id":"79251220","dot_number":"2935539","report_state":"US","report_number":"0904000244","insp_date":"2023-07-25 00:00:00","insp_start_time":"1440","insp_end_time":"1531","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROMATX","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WENCESLAO COLUNGNA RUIZ","shipping_paper_number":"19728","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":"U","pen_cen_match":"I","final_status_date":"2023-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"35114","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":"02935539","upload_search_indicator":null,"census_search_date":"2023-07-27 21:39:00","snet_input_date":"2023-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-27 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:11.000000Z","updated_at":"2025-03-17T19:34:11.000000Z","inspection_violations":[{"id":5557866,"change_date":"2023-07-27 21:39:00","inspection_id":"79251220","insp_violation_id":"254303557","seq_no":"1","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"1","insp_unit_id":"196216444","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39323LEU"},{"id":5557867,"change_date":"2023-07-27 21:39:00","inspection_id":"79251220","insp_violation_id":"254303558","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":5795478,"change_date":"2023-07-27 21:39:00","inspection_id":"79251220","insp_unit_id":"196216444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"},{"id":5795479,"change_date":"2023-07-27 21:39:00","inspection_id":"79251220","insp_unit_id":"196216445","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"181B093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538FU185870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3378907,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","dot_number":"2935539","report_state":"TX","report_number":"V231027582","insp_date":"2023-06-24 00:00:00","insp_start_time":"1155","insp_end_time":"1226","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 281 SB","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118850","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9014911","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-27 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:29:49.000000Z","updated_at":"2025-03-17T19:29:49.000000Z","inspection_violations":[{"id":5211179,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_violation_id":"253736370","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39145B"},{"id":5211180,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_violation_id":"253736371","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195705975","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39311"},{"id":5211181,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_violation_id":"253736372","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195705974","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39360D"},{"id":5211182,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_violation_id":"253736373","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195705975","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3939A"},{"id":5211183,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_violation_id":"253736374","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195705974","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3939A"},{"id":5211184,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_violation_id":"253736375","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195705974","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5432135,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_unit_id":"195705974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"R630430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:51.000000Z","updated_at":"2025-03-17T22:45:51.000000Z"},{"id":5432136,"change_date":"2023-06-27 21:41:00","inspection_id":"78998096","insp_unit_id":"195705975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"30","insp_unit_license":"86UN5C","insp_unit_license_state":"NL","insp_unit_vehicle_id_number":"1JJV532W06L994657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:51.000000Z","updated_at":"2025-03-17T22:45:51.000000Z"}]},{"id":2947347,"change_date":"2023-06-05 21:43:00","inspection_id":"78511075","dot_number":"2935539","report_state":"TX","report_number":"V231021074","insp_date":"2023-04-29 00:00:00","insp_start_time":"1140","insp_end_time":"1203","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 77 MM 656","county_code_state":"TX","county_code":"409","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADO'S FREIGHT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8968833","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4742593,"change_date":"2023-06-05 21:43:00","inspection_id":"78511075","insp_unit_id":"195329746","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"},{"id":4742594,"change_date":"2023-06-05 21:43:00","inspection_id":"78511075","insp_unit_id":"195329747","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"03","insp_unit_license":"150C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532B5BL367265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"}]},{"id":2877551,"change_date":"2023-06-05 21:43:00","inspection_id":"78432096","dot_number":"2935539","report_state":"TX","report_number":"V231014206","insp_date":"2023-04-19 00:00:00","insp_start_time":"1435","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM396 SB","county_code_state":"TX","county_code":"215","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8961632","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-24 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:19:43.000000Z","updated_at":"2025-03-17T19:19:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4630416,"change_date":"2023-06-05 21:43:00","inspection_id":"78432096","insp_unit_id":"195325171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"R326300","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X0JF501471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:32.000000Z","updated_at":"2025-03-17T22:39:32.000000Z"},{"id":4630417,"change_date":"2023-06-05 21:43:00","inspection_id":"78432096","insp_unit_id":"195325172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"123B397","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537GM418607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:32.000000Z","updated_at":"2025-03-17T22:39:32.000000Z"}]},{"id":2556054,"change_date":"2023-06-02 21:42:00","inspection_id":"78066409","dot_number":"2935539","report_state":"TX","report_number":"V231002800","insp_date":"2023-03-03 00:00:00","insp_start_time":"1256","insp_end_time":"1331","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 493 S SH 186","county_code_state":"TX","county_code":"215","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-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8926715","transaction_code":"C","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4114339,"change_date":"2023-06-02 21:42:00","inspection_id":"78066409","insp_unit_id":"195289836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"64N017M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X5PF535644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"},{"id":4114340,"change_date":"2023-06-02 21:42:00","inspection_id":"78066409","insp_unit_id":"195289837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":2336637,"change_date":"2023-02-09 21:39:00","inspection_id":"77816516","dot_number":"2935539","report_state":"SC","report_number":"T324001510","insp_date":"2023-02-09 00:00:00","insp_start_time":"0828","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"011","location_desc":"I-20 WB LEXINGTON COUNTY","county_code_state":"SC","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"0006083606","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1068292","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-09 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:40.000000Z","updated_at":"2025-03-17T19:09:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3759677,"change_date":"2023-02-09 21:39:00","inspection_id":"77816516","insp_unit_id":"193318545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:55.000000Z","updated_at":"2025-03-17T22:32:55.000000Z"},{"id":3759678,"change_date":"2023-02-09 21:39:00","inspection_id":"77816516","insp_unit_id":"193318546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:55.000000Z","updated_at":"2025-03-17T22:32:55.000000Z"}]},{"id":2036612,"change_date":"2023-01-17 21:41:00","inspection_id":"77473673","dot_number":"2935539","report_state":"LA","report_number":"LAPN000835","insp_date":"2022-12-23 00:00:00","insp_start_time":"1240","insp_end_time":"1303","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"103","insp_level_id":"3","service_center":"SH","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":"U","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1153024","transaction_code":"C","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-29 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:03.000000Z","updated_at":"2025-03-17T19:04:03.000000Z","inspection_violations":[{"id":3156760,"change_date":"2023-01-17 21:41:00","inspection_id":"77473673","insp_violation_id":"250596495","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3276051,"change_date":"2023-01-17 21:41:00","inspection_id":"77473673","insp_unit_id":"192892483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R294154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X7HF406982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:27.000000Z","updated_at":"2025-03-17T22:29:27.000000Z"},{"id":3276052,"change_date":"2023-01-17 21:41:00","inspection_id":"77473673","insp_unit_id":"192892484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:27.000000Z","updated_at":"2025-03-17T22:29:27.000000Z"}]},{"id":1990231,"change_date":"2022-12-20 21:41:00","inspection_id":"77420989","dot_number":"2935539","report_state":"TX","report_number":"6GYE0VMAIN","insp_date":"2022-12-17 00:00:00","insp_start_time":"1420","insp_end_time":"1451","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-069C IN HIDALGO CO. (0-12)","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8857221","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T19:03:19.000000Z","updated_at":"2025-03-17T19:03:19.000000Z","inspection_violations":[{"id":3090832,"change_date":"2022-12-20 21:41:00","inspection_id":"77420989","insp_violation_id":"250208134","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192525729","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3202391,"change_date":"2022-12-20 21:41:00","inspection_id":"77420989","insp_unit_id":"192525729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"},{"id":3202392,"change_date":"2022-12-20 21:41:00","inspection_id":"77420989","insp_unit_id":"192525730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1797434,"change_date":"2022-11-22 21:41:00","inspection_id":"77200357","dot_number":"2935539","report_state":"TN","report_number":"TEUE000276","insp_date":"2022-11-21 00:00:00","insp_start_time":"2330","insp_end_time":"0017","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BROAD ST AND CUMMINGS HWY","county_code_state":"TN","county_code":"065","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"PILGRIM'S PRIDE CORPORATION","shipping_paper_number":"FR857001547460","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117340","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1613068","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:41.000000Z","updated_at":"2025-03-17T18:59:41.000000Z","inspection_violations":[{"id":2810189,"change_date":"2022-11-22 21:41:00","inspection_id":"77200357","insp_violation_id":"249741948","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"3958A1"},{"id":2810190,"change_date":"2022-11-22 21:41:00","inspection_id":"77200357","insp_violation_id":"249741949","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"3922"},{"id":2810191,"change_date":"2022-11-22 21:41:00","inspection_id":"77200357","insp_violation_id":"249741950","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2891139,"change_date":"2022-11-22 21:41:00","inspection_id":"77200357","insp_unit_id":"192087514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R512475","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"},{"id":2891140,"change_date":"2022-11-22 21:41:00","inspection_id":"77200357","insp_unit_id":"192087515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04","insp_unit_license":"123B397","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537GM418607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]},{"id":1689444,"change_date":"2022-11-07 21:41:00","inspection_id":"77076542","dot_number":"2935539","report_state":"US","report_number":"1168014129","insp_date":"2022-11-04 00:00:00","insp_start_time":"1415","insp_end_time":"1458","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"ROMA POE","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"WENCESLAO RUIZ","shipping_paper_number":"9458","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":"I","final_status_date":"2022-11-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1275369","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-07 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-11-07 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:46.000000Z","updated_at":"2025-03-17T18:57:46.000000Z","inspection_violations":[{"id":2648943,"change_date":"2022-11-07 21:41:00","inspection_id":"77076542","insp_violation_id":"249475936","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191844560","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2718300,"change_date":"2022-11-07 21:41:00","inspection_id":"77076542","insp_unit_id":"191844559","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"R630430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:37.000000Z","updated_at":"2025-03-17T22:25:37.000000Z"},{"id":2718301,"change_date":"2022-11-07 21:41:00","inspection_id":"77076542","insp_unit_id":"191844560","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:37.000000Z","updated_at":"2025-03-17T22:25:37.000000Z"}]},{"id":1595956,"change_date":"2022-10-25 21:41:00","inspection_id":"76969214","dot_number":"2935539","report_state":"TX","report_number":"6F2J0AOD5C","insp_date":"2022-10-10 00:00:00","insp_start_time":"1840","insp_end_time":"1910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 83 AND LEO AVE","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VALLEALTO","shipping_paper_number":"31814","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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8808873","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-25 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:55:58.000000Z","updated_at":"2025-03-17T18:55:58.000000Z","inspection_violations":[{"id":2508037,"change_date":"2022-10-25 21:41:00","inspection_id":"76969214","insp_violation_id":"249240747","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191631753","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39395A"},{"id":2508038,"change_date":"2022-10-25 21:41:00","inspection_id":"76969214","insp_violation_id":"249240748","seq_no":"2","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"2","insp_unit_id":"191631754","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39313C3"}],"inspection_per_units":[{"id":2568126,"change_date":"2022-10-25 21:41:00","inspection_id":"76969214","insp_unit_id":"191631753","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"R630430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD49X4DF841652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:36.000000Z","updated_at":"2025-03-17T22:24:36.000000Z"},{"id":2568127,"change_date":"2022-10-25 21:41:00","inspection_id":"76969214","insp_unit_id":"191631754","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:36.000000Z","updated_at":"2025-03-17T22:24:36.000000Z"}]},{"id":1368492,"change_date":"2022-09-26 21:40:00","inspection_id":"76706248","dot_number":"2935539","report_state":"US","report_number":"1168013976","insp_date":"2022-09-20 00:00:00","insp_start_time":"1604","insp_end_time":"1635","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"ROMA POE","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"WENCESLAO RUIZ","shipping_paper_number":"7747","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":"I","final_status_date":"2022-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1268614","transaction_code":"A","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-26 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-09-26 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:58.000000Z","updated_at":"2025-03-17T18:51:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2203869,"change_date":"2022-09-26 21:40:00","inspection_id":"76706248","insp_unit_id":"191101492","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:05.000000Z","updated_at":"2025-03-17T22:22:05.000000Z"},{"id":2203870,"change_date":"2022-09-26 21:40:00","inspection_id":"76706248","insp_unit_id":"191101493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"R326300","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X0JF501471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:05.000000Z","updated_at":"2025-03-17T22:22:05.000000Z"}]},{"id":1251835,"change_date":"2022-09-09 21:39:00","inspection_id":"76570434","dot_number":"2935539","report_state":"TX","report_number":"6DZJ0XIMA8","insp_date":"2022-09-01 00:00:00","insp_start_time":"1926","insp_end_time":"1951","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WENCESLAO C RUIZ","shipping_paper_number":"7117","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-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8767409","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-09 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:49:44.000000Z","updated_at":"2025-03-17T18:49:44.000000Z","inspection_violations":[{"id":1982697,"change_date":"2022-09-09 21:39:00","inspection_id":"76570434","insp_violation_id":"248320661","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"190818797","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:08.000000Z","updated_at":"2025-03-17T21:16:08.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2014854,"change_date":"2022-09-09 21:39:00","inspection_id":"76570434","insp_unit_id":"190818796","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"R550093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:50.000000Z","updated_at":"2025-03-17T22:20:50.000000Z"},{"id":2014855,"change_date":"2022-09-09 21:39:00","inspection_id":"76570434","insp_unit_id":"190818797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04","insp_unit_license":"68UK3Y","insp_unit_license_state":"TA","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:50.000000Z","updated_at":"2025-03-17T22:20:50.000000Z"}]},{"id":1037593,"change_date":"2022-08-15 21:38:00","inspection_id":"76321311","dot_number":"2935539","report_state":"US","report_number":"0904013716","insp_date":"2022-08-13 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"ROMA POE","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2022-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1261484","transaction_code":"A","transaction_date":"2022-08-13 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-15 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-08-15 21:38:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:51.000000Z","updated_at":"2025-03-17T18:45:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1670163,"change_date":"2022-08-15 21:38:00","inspection_id":"76321311","insp_unit_id":"190310311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"R550093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:32.000000Z","updated_at":"2025-03-17T22:18:32.000000Z"},{"id":1670164,"change_date":"2022-08-15 21:38:00","inspection_id":"76321311","insp_unit_id":"190310312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04","insp_unit_license":"68UK3Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:32.000000Z","updated_at":"2025-03-17T22:18:32.000000Z"}]},{"id":1081131,"change_date":"2022-08-18 21:40:00","inspection_id":"76372431","dot_number":"2935539","report_state":"TX","report_number":"6DG20ALTG8","insp_date":"2022-08-13 00:00:00","insp_start_time":"0217","insp_end_time":"0306","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0077 IN KLEBERG CO. (690-70","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADOS FREIGHT SERVICES INC","shipping_paper_number":"20111","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8746953","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-18 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:46:51.000000Z","updated_at":"2025-03-17T18:46:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1739014,"change_date":"2022-08-18 21:40:00","inspection_id":"76372431","insp_unit_id":"190414675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R512475","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:58.000000Z","updated_at":"2025-03-17T22:18:58.000000Z"},{"id":1739015,"change_date":"2022-08-18 21:40:00","inspection_id":"76372431","insp_unit_id":"190414676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"253","insp_unit_license":"346624G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537GM418607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:58.000000Z","updated_at":"2025-03-17T22:18:58.000000Z"}]},{"id":924973,"change_date":"2022-07-29 21:39:00","inspection_id":"76190068","dot_number":"2935539","report_state":"US","report_number":"1168013857","insp_date":"2022-07-28 00:00:00","insp_start_time":"1531","insp_end_time":"1601","registration_date":null,"region":"CT","ci_status_code":"C","location":"12","location_desc":"RIO GRANDE CITY POE","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2022-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259446","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-29 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-07-29 21:39:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:02.000000Z","updated_at":"2025-03-17T18:44:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1489383,"change_date":"2022-07-29 21:39:00","inspection_id":"76190068","insp_unit_id":"190043575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"R425547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD40X1AF828687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:21.000000Z","updated_at":"2025-03-17T22:17:21.000000Z"},{"id":1489384,"change_date":"2022-07-29 21:39:00","inspection_id":"76190068","insp_unit_id":"190043576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02","insp_unit_license":"71UD4B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS25329M761618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:21.000000Z","updated_at":"2025-03-17T22:17:21.000000Z"}]},{"id":959402,"change_date":"2022-08-03 21:42:00","inspection_id":"76230262","dot_number":"2935539","report_state":"TX","report_number":"6D0D0AJROZ","insp_date":"2022-07-28 00:00:00","insp_start_time":"1343","insp_end_time":"1403","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0396 IN HIDALGO CO. (724-72","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RCF DISTRIBUTORS LLC","shipping_paper_number":"0531809","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-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8732247","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:44:27.000000Z","updated_at":"2025-03-17T18:44:27.000000Z","inspection_violations":[{"id":1512344,"change_date":"2022-08-03 21:42:00","inspection_id":"76230262","insp_violation_id":"247501913","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190124298","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"39378"},{"id":1512345,"change_date":"2022-08-03 21:42:00","inspection_id":"76230262","insp_violation_id":"247501914","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190124298","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"3939A"},{"id":1512346,"change_date":"2022-08-03 21:42:00","inspection_id":"76230262","insp_violation_id":"247501915","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190124299","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":1543998,"change_date":"2022-08-03 21:42:00","inspection_id":"76230262","insp_unit_id":"190124298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R507198","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDD49X6LF413402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:43.000000Z","updated_at":"2025-03-17T22:17:43.000000Z"},{"id":1543999,"change_date":"2022-08-03 21:42:00","inspection_id":"76230262","insp_unit_id":"190124299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"181B093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2538FU185870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:43.000000Z","updated_at":"2025-03-17T22:17:43.000000Z"}]},{"id":959146,"change_date":"2022-08-03 21:42:00","inspection_id":"76229967","dot_number":"2935539","report_state":"TX","report_number":"6CHE0AHES0","insp_date":"2022-07-09 00:00:00","insp_start_time":"1420","insp_end_time":"1442","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IMPORTACONES EXPORTACIONES","shipping_paper_number":"AFEEBJG01306819","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8731749","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:44:27.000000Z","updated_at":"2025-03-17T18:44:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1543559,"change_date":"2022-08-03 21:42:00","inspection_id":"76229967","insp_unit_id":"190123096","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"R425547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD40X1AF828687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:43.000000Z","updated_at":"2025-03-17T22:17:43.000000Z"},{"id":1543560,"change_date":"2022-08-03 21:42:00","inspection_id":"76229967","insp_unit_id":"190123097","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"125477","insp_unit_license":"68UK3Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538FM219578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:43.000000Z","updated_at":"2025-03-17T22:17:43.000000Z"}]},{"id":673804,"change_date":"2022-07-01 21:38:00","inspection_id":"75895643","dot_number":"2935539","report_state":"TX","report_number":"6BSM0AJRGB","insp_date":"2022-06-14 00:00:00","insp_start_time":"2157","insp_end_time":"2219","registration_date":"2022-07-01 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1016 IN HIDALGO CO. (724-73","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PALANQUE FOODS","shipping_paper_number":"E01561-01","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8692287","transaction_code":"C","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-22 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:39:32.000000Z","updated_at":"2025-03-17T18:39:32.000000Z","inspection_violations":[{"id":1060996,"change_date":"2022-07-01 21:38:00","inspection_id":"75895643","insp_violation_id":"246864080","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189580296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:00.000000Z","updated_at":"2025-03-17T21:12:00.000000Z","normalized_code":"3939A"},{"id":1060997,"change_date":"2022-07-01 21:38:00","inspection_id":"75895643","insp_violation_id":"246864081","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189580296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:00.000000Z","updated_at":"2025-03-17T21:12:00.000000Z","normalized_code":"3939A"},{"id":1060998,"change_date":"2022-07-01 21:38:00","inspection_id":"75895643","insp_violation_id":"246864082","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189580296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:00.000000Z","updated_at":"2025-03-17T21:12:00.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1083013,"change_date":"2022-07-01 21:38:00","inspection_id":"75895643","insp_unit_id":"189580296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R294154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKYD40X7HF406982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:51.000000Z","updated_at":"2025-03-17T22:14:51.000000Z"},{"id":1083014,"change_date":"2022-07-01 21:38:00","inspection_id":"75895643","insp_unit_id":"189580297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:51.000000Z","updated_at":"2025-03-17T22:14:51.000000Z"}]},{"id":463098,"change_date":"2022-05-23 21:43:00","inspection_id":"75645341","dot_number":"2935539","report_state":"TX","report_number":"6ASJ0XQF29","insp_date":"2022-05-09 00:00:00","insp_start_time":"1851","insp_end_time":"1912","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0083 IN HIDALGO CO. (840-88","county_code_state":"TX","county_code":"215","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"COVE2254TSOL7","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-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8662179","transaction_code":"A","transaction_date":"2022-05-23 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-23 21:43:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:35:56.000000Z","updated_at":"2025-03-17T18:35:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":746185,"change_date":"2022-05-23 21:43:00","inspection_id":"75645341","insp_unit_id":"188864729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"08","insp_unit_license":"32AS7Y","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3WKYD49X0NF523575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"},{"id":746186,"change_date":"2022-05-23 21:43:00","inspection_id":"75645341","insp_unit_id":"188864730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"253","insp_unit_license":"123B397","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537GM418607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"}]},{"id":322428,"change_date":"2022-05-04 21:41:00","inspection_id":"75477654","dot_number":"2935539","report_state":"US","report_number":"0904013444","insp_date":"2022-05-02 00:00:00","insp_start_time":"1545","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"ROMA POE","county_code_state":"TX","county_code":"427","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2022-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246214","transaction_code":"A","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-04 00:00:00","source_office":"2TXD001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:17.000000Z","updated_at":"2025-03-17T18:33:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":521704,"change_date":"2022-05-04 21:41:00","inspection_id":"75477654","insp_unit_id":"188510258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"R425547","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKAD40X1AF828687","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"},{"id":521705,"change_date":"2022-05-04 21:41:00","inspection_id":"75477654","insp_unit_id":"188510259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"69UM1H","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2538GM513726","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"}]},{"id":313046,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","dot_number":"2935539","report_state":"TX","report_number":"6AKC0XJR0P","insp_date":"2022-05-01 00:00:00","insp_start_time":"1130","insp_end_time":"1220","registration_date":"2022-05-12 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0285 IN KLEBERG CO. (534-54","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVARADO'S","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-05-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8643784","transaction_code":"C","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-03 21:40:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:32:58.000000Z","updated_at":"2025-03-17T18:32:58.000000Z","inspection_violations":[{"id":489351,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","insp_violation_id":"245785876","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"188679817","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39524D"},{"id":489352,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","insp_violation_id":"245785877","seq_no":"2","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"1","insp_unit_id":"188679817","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39522H2"},{"id":489353,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","insp_violation_id":"245785878","seq_no":"3","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"1","insp_unit_id":"188679817","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39522H3"},{"id":489354,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","insp_violation_id":"245785879","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188679817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":506698,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","insp_unit_id":"188679817","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R512475","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"},{"id":506699,"change_date":"2022-05-13 21:40:00","inspection_id":"75466643","insp_unit_id":"188679818","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"87923","insp_unit_license":"71UD4B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS25329M761618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"}]},{"id":196787,"change_date":"2022-04-29 21:41:00","inspection_id":"75327701","dot_number":"2935539","report_state":"TX","report_number":"6A1M0VMGVZ","insp_date":"2022-04-12 00:00:00","insp_start_time":"2228","insp_end_time":"2315","registration_date":"2022-04-29 00:00:00","region":"CT","ci_status_code":"C","location":"3C399","location_desc":"US-0281 IN BROOKS CO. (708-742","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BANANERA MUCHACHITA LLC","shipping_paper_number":"3720-BM","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-04-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122320","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8625836","transaction_code":"C","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02935539","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-18 21:43:00","insp_carrier_name":"ALVARADOS FREIGHT SERVICES INC","insp_carrier_street":"2305 AIRLINE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77009","insp_colonia":null,"docket_number":"991836","insp_interstate":"Y","insp_carrier_state_id":"0923997","created_at":"2025-03-17T18:30:54.000000Z","updated_at":"2025-03-17T18:30:54.000000Z","inspection_violations":[{"id":302254,"change_date":"2022-04-29 21:41:00","inspection_id":"75327701","insp_violation_id":"245489203","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"3922"},{"id":302255,"change_date":"2022-04-29 21:41:00","inspection_id":"75327701","insp_violation_id":"245489204","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188434081","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":319126,"change_date":"2022-04-29 21:41:00","inspection_id":"75327701","insp_unit_id":"188434081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"R512475","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0LJ344753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:06.000000Z","updated_at":"2025-03-17T22:10:06.000000Z"},{"id":319127,"change_date":"2022-04-29 21:41:00","inspection_id":"75327701","insp_unit_id":"188434082","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"02","insp_unit_license":"42TZ9L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532B8AL349695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:06.000000Z","updated_at":"2025-03-17T22:10:06.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2935539\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2935539\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2935539\/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\/2935539\/inspections","per_page":100,"prev_page_url":null,"to":56,"total":56}