{"current_page":1,"data":[{"id":9220681,"change_date":"2025-07-23 21:41:00","inspection_id":"85290770","dot_number":"3000049","report_state":"OH","report_number":"3247000916","insp_date":"2025-07-21 00:00:00","insp_start_time":"1019","insp_end_time":"1055","registration_date":null,"region":"ED","ci_status_code":"C","location":"TRUCK","location_desc":"ASHLAND OH","county_code_state":"OH","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ANHEUSER BUSCH LLC","shipping_paper_number":"8086351","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-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2028705","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":"2025-07-23 21:41:00","snet_input_date":"2025-07-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-23 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:25.000000Z","updated_at":"2025-07-27T10:41:25.000000Z","inspection_violations":[{"id":14918430,"change_date":"2025-07-23 21:41:00","inspection_id":"85290770","insp_violation_id":"267582293","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-07-26T10:43:16.000000Z","updated_at":"2025-07-27T10:42:34.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":15167932,"change_date":"2025-07-23 21:41:00","inspection_id":"85290770","insp_unit_id":"208020999","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"07","insp_unit_license":"R60741","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHD49XX9D778311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:23.000000Z","updated_at":"2025-07-27T09:45:26.000000Z"},{"id":15167933,"change_date":"2025-07-23 21:41:00","inspection_id":"85290770","insp_unit_id":"208021000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R03","insp_unit_license":"107C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0621EW703336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:23.000000Z","updated_at":"2025-07-27T09:45:26.000000Z"}]},{"id":8690123,"change_date":"2025-05-20 21:41:00","inspection_id":"84730367","dot_number":"3000049","report_state":"NE","report_number":"T288000052","insp_date":"2025-05-17 00:00:00","insp_start_time":"0728","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON UNNAMED STREET, 497 FEET WE","county_code_state":"NE","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LAMB WESTON SALES LLC","shipping_paper_number":"478549","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":"2025-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"815217","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-19 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:04:21.000000Z","updated_at":"2025-05-24T10:05:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14198906,"change_date":"2025-05-20 21:41:00","inspection_id":"84730367","insp_unit_id":"206968885","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R345373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2GJ499943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:13.000000Z","updated_at":"2025-05-24T09:51:20.000000Z"},{"id":14198907,"change_date":"2025-05-20 21:41:00","inspection_id":"84730367","insp_unit_id":"206968886","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"244C432","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536GU615395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:13.000000Z","updated_at":"2025-05-24T09:51:20.000000Z"}]},{"id":8151653,"change_date":"2025-03-19 21:40:00","inspection_id":"84163371","dot_number":"3000049","report_state":"UT","report_number":"25XA001334","insp_date":"2025-03-18 00:00:00","insp_start_time":"1527","insp_end_time":"1606","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT51","location_desc":"ST. GEORGE UT","county_code_state":"UT","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WORLD VARIETY PRODUCE","shipping_paper_number":"04450965","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-03-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","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":"1489453","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":"2025-03-19 21:40:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-19 21:40:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:29:48.000000Z","updated_at":"2025-03-23T10:43:01.000000Z","inspection_violations":[{"id":12760199,"change_date":"2025-03-19 21:40:00","inspection_id":"84163371","insp_violation_id":"265119200","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"205871917","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:45:18.000000Z","updated_at":"2025-03-22T10:58:46.000000Z","normalized_code":"3922SLLIFTA"},{"id":12760200,"change_date":"2025-03-19 21:40:00","inspection_id":"84163371","insp_violation_id":"265119201","seq_no":"2","part_no":"383","part_no_section":"51A-LCDLRSWD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:45:33.000000Z","updated_at":"2025-03-22T10:59:13.000000Z","normalized_code":"38351ALCDLRSWD"}],"inspection_per_units":[{"id":13168324,"change_date":"2025-03-19 21:40:00","inspection_id":"84163371","insp_unit_id":"205871917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"10","insp_unit_license":"R703080","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8LJ384921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:01:45.000000Z","updated_at":"2025-03-23T09:55:32.000000Z"},{"id":13168325,"change_date":"2025-03-19 21:40:00","inspection_id":"84163371","insp_unit_id":"205871918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"162894","insp_unit_license":"244C432","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536GU615395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:01:45.000000Z","updated_at":"2025-03-23T09:55:32.000000Z"}]},{"id":7260402,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","dot_number":"3000049","report_state":"MI","report_number":"HOLLM04109","insp_date":"2024-11-20 00:00:00","insp_start_time":"0755","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202044","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":11350210,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","insp_violation_id":"263045670","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4457659","created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922SLLS3"},{"id":11350211,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","insp_violation_id":"263045671","seq_no":"2","part_no":"395","part_no_section":"8H5-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3958H5HOSM"},{"id":11350212,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","insp_violation_id":"263045672","seq_no":"3","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4457659","created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3953A1HOSPD"},{"id":11350213,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","insp_violation_id":"263045673","seq_no":"4","part_no":"392","part_no_section":"2-SLLIRP","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":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":11711047,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","insp_unit_id":"204014278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R607417","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X6PJ235317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"},{"id":11711048,"change_date":"2024-11-22 21:41:00","inspection_id":"83226644","insp_unit_id":"204014279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"154C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2538L8904422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":6861814,"change_date":"2024-10-01 21:42:00","inspection_id":"82803889","dot_number":"3000049","report_state":"KY","report_number":"CV41515064","insp_date":"2024-10-01 00:00:00","insp_start_time":"0940","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"9806","location_desc":"ELIZABETHTOWN","county_code_state":"KY","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"BELLISIO FOODS","shipping_paper_number":"81385028","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":"2024-10-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2248084","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-01 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:22.000000Z","updated_at":"2025-03-17T20:39:22.000000Z","inspection_violations":[{"id":10687302,"change_date":"2024-10-01 21:42:00","inspection_id":"82803889","insp_violation_id":"262123924","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":"EU17266","created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3922"},{"id":10687303,"change_date":"2024-10-01 21:42:00","inspection_id":"82803889","insp_violation_id":"262123925","seq_no":"2","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":"EU17266","created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3922"},{"id":10687304,"change_date":"2024-10-01 21:42:00","inspection_id":"82803889","insp_violation_id":"262123926","seq_no":"3","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":11065503,"change_date":"2024-10-01 21:42:00","inspection_id":"82803889","insp_unit_id":"203212658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R703080","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8LJ384921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:37.000000Z","updated_at":"2025-03-17T23:37:37.000000Z"},{"id":11065504,"change_date":"2024-10-01 21:42:00","inspection_id":"82803889","insp_unit_id":"203212659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R03","insp_unit_license":"107C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0621EW703336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:37.000000Z","updated_at":"2025-03-17T23:37:37.000000Z"}]},{"id":6590378,"change_date":"2024-08-29 21:41:00","inspection_id":"82514773","dot_number":"3000049","report_state":"TN","report_number":"I033J30079","insp_date":"2024-08-22 00:00:00","insp_start_time":"0724","insp_end_time":"0944","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"LINEAGE","shipping_paper_number":"1256465","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":"U","pen_cen_match":"I","final_status_date":"2024-08-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"793736","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":"2024-08-29 21:41:00","snet_input_date":"2024-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-29 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:40.000000Z","updated_at":"2025-03-17T20:33:40.000000Z","inspection_violations":[{"id":10248049,"change_date":"2024-08-29 21:41:00","inspection_id":"82514773","insp_violation_id":"261478877","seq_no":"1","part_no":"392","part_no_section":"5(a)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3925A3"},{"id":10248050,"change_date":"2024-08-29 21:41:00","inspection_id":"82514773","insp_violation_id":"261478878","seq_no":"2","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":10624981,"change_date":"2024-08-29 21:41:00","inspection_id":"82514773","insp_unit_id":"202641095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"09","insp_unit_license":"R672094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6LJ417026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:01.000000Z","updated_at":"2025-03-17T23:33:01.000000Z"},{"id":10624982,"change_date":"2024-08-29 21:41:00","inspection_id":"82514773","insp_unit_id":"202641096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"162894","insp_unit_license":"244C432","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536GU615395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:01.000000Z","updated_at":"2025-03-17T23:33:01.000000Z"}]},{"id":6381382,"change_date":"2024-08-03 21:31:00","inspection_id":"82291855","dot_number":"3000049","report_state":"IL","report_number":"4127820146","insp_date":"2024-08-02 00:00:00","insp_start_time":"0934","insp_end_time":"1031","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GIUMARRA AVOCADO","shipping_paper_number":"TRF019511","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":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-03 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"2343877","transaction_code":"A","transaction_date":"2024-08-02 00:00:00","upload_date":"2024-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-02 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-08-03 21:31:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:27.000000Z","updated_at":"2025-03-17T20:29:27.000000Z","inspection_violations":[{"id":9904511,"change_date":"2024-08-03 21:31:00","inspection_id":"82291855","insp_violation_id":"260991871","seq_no":"1","part_no":"395","part_no_section":"34(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"39534A1"}],"inspection_per_units":[{"id":10283721,"change_date":"2024-08-03 21:31:00","inspection_id":"82291855","insp_unit_id":"202216829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"R345373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2GJ499943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:30.000000Z","updated_at":"2025-03-17T23:29:30.000000Z"},{"id":10283722,"change_date":"2024-08-03 21:31:00","inspection_id":"82291855","insp_unit_id":"202216830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"RT03","insp_unit_license":"107C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0621EW703336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:30.000000Z","updated_at":"2025-03-17T23:29:30.000000Z"}]},{"id":6169422,"change_date":"2024-07-08 21:43:00","inspection_id":"82064821","dot_number":"3000049","report_state":"TX","report_number":"V241473837","insp_date":"2024-07-02 00:00:00","insp_start_time":"1205","insp_end_time":"1255","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":"N\/A","shipping_paper_number":"7437960","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"9318200","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":"0949098","created_at":"2025-03-17T20:25:00.000000Z","updated_at":"2025-03-17T20:25:00.000000Z","inspection_violations":[{"id":9579322,"change_date":"2024-07-08 21:43:00","inspection_id":"82064821","insp_violation_id":"260522487","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201781038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39311"},{"id":9579323,"change_date":"2024-07-08 21:43:00","inspection_id":"82064821","insp_violation_id":"260522488","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201781038","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9938485,"change_date":"2024-07-08 21:43:00","inspection_id":"82064821","insp_unit_id":"201781038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":"10","insp_unit_license":"R703080","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8LJ384921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"},{"id":9938486,"change_date":"2024-07-08 21:43:00","inspection_id":"82064821","insp_unit_id":"201781039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"162281","insp_unit_license":"244C431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2530GM411482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"}]},{"id":5243200,"change_date":"2024-03-13 21:41:00","inspection_id":"81058702","dot_number":"3000049","report_state":"ME","report_number":"3998011770","insp_date":"2024-03-06 00:00:00","insp_start_time":"1710","insp_end_time":"1741","registration_date":null,"region":"ET","ci_status_code":"C","location":"000018","location_desc":"OLD TOWN - SCALES SB","county_code_state":"ME","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCCAIN","shipping_paper_number":"31214460","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":"2024-03-08 21:39: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":"376530","transaction_code":"C","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:39.000000Z","updated_at":"2025-03-17T20:06:39.000000Z","inspection_violations":[{"id":8084705,"change_date":"2024-03-13 21:41:00","inspection_id":"81058702","insp_violation_id":"258355305","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:45:05.000000Z","updated_at":"2025-03-17T21:45:05.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":8442937,"change_date":"2024-03-13 21:41:00","inspection_id":"81058702","insp_unit_id":"199887999","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"R703080","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8LJ384921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:30.000000Z","updated_at":"2025-03-17T23:11:30.000000Z"},{"id":8442938,"change_date":"2024-03-13 21:41:00","inspection_id":"81058702","insp_unit_id":"199888000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"162281","insp_unit_license":"244C431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2530GM411482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:30.000000Z","updated_at":"2025-03-17T23:11:30.000000Z"}]},{"id":4268908,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","dot_number":"3000049","report_state":"MD","report_number":"2203000629","insp_date":"2023-10-24 00:00:00","insp_start_time":"0345","insp_end_time":"0432","registration_date":"2023-11-09 00:00:00","region":"ET","ci_status_code":"C","location":"056","location_desc":"WASHINGTON COUNTY","county_code_state":"MD","county_code":"043","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCCFOO","shipping_paper_number":"4-116745","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-10-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"2671180","transaction_code":"C","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-24 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-10-24 21:39:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:26.000000Z","updated_at":"2025-03-17T19:47:26.000000Z","inspection_violations":[{"id":6603737,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","insp_violation_id":"256407385","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"3922"},{"id":6603738,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","insp_violation_id":"256407386","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198070666","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"3939A"},{"id":6603739,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","insp_violation_id":"256407387","seq_no":"3","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:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"3958E1"},{"id":6603740,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","insp_violation_id":"256407388","seq_no":"4","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":6865402,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","insp_unit_id":"198070666","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"R534941","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4GJ499944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:34.000000Z","updated_at":"2025-03-17T22:57:34.000000Z"},{"id":6865403,"change_date":"2023-11-15 21:41:00","inspection_id":"79990709","insp_unit_id":"198070667","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R5","insp_unit_license":"116B614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0620EW702596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:34.000000Z","updated_at":"2025-03-17T22:57:34.000000Z"}]},{"id":4255357,"change_date":"2023-11-20 21:40:00","inspection_id":"79975647","dot_number":"3000049","report_state":"MS","report_number":"5018012608","insp_date":"2023-10-20 00:00:00","insp_start_time":"0901","insp_end_time":"0931","registration_date":"2023-11-20 00:00:00","region":"ET","ci_status_code":"C","location":"34","location_desc":"I59 NORTH","county_code_state":"MS","county_code":"067","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"COAST TROPICAL","shipping_paper_number":"00649585","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":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1050602","transaction_code":"C","transaction_date":"2023-10-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-23 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:05.000000Z","updated_at":"2025-03-17T19:47:05.000000Z","inspection_violations":[{"id":6588877,"change_date":"2023-11-20 21:40:00","inspection_id":"79975647","insp_violation_id":"256486925","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":6843245,"change_date":"2023-11-20 21:40:00","inspection_id":"79975647","insp_unit_id":"198141846","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"R534941","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4GJ499944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:22.000000Z","updated_at":"2025-03-17T22:57:22.000000Z"},{"id":6843246,"change_date":"2023-11-20 21:40:00","inspection_id":"79975647","insp_unit_id":"198141847","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R05","insp_unit_license":"116B614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0620EW702596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:22.000000Z","updated_at":"2025-03-17T22:57:22.000000Z"}]},{"id":3894284,"change_date":"2023-09-04 21:31:00","inspection_id":"79575254","dot_number":"3000049","report_state":"US","report_number":"0904000301","insp_date":"2023-09-01 00:00:00","insp_start_time":"1904","insp_end_time":"1934","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX13","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":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-09-04 21:31: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":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"48577","transaction_code":"A","transaction_date":"2023-09-04 00:00:00","upload_date":"2023-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":"2023-09-04 21:31:00","snet_input_date":"2023-09-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-04 21:31:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[{"id":6019292,"change_date":"2023-09-04 21:31:00","inspection_id":"79575254","insp_violation_id":"255061621","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"196878478","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":6261237,"change_date":"2023-09-04 21:31:00","inspection_id":"79575254","insp_unit_id":"196878478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"R343280","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8FJ418733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:36.000000Z","updated_at":"2025-03-17T22:52:36.000000Z"},{"id":6261238,"change_date":"2023-09-04 21:31:00","inspection_id":"79575254","insp_unit_id":"196878479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"59UN3B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1GRAA0626CW700249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:36.000000Z","updated_at":"2025-03-17T22:52:36.000000Z"}]},{"id":3147338,"change_date":"2023-05-26 21:39:00","inspection_id":"78736576","dot_number":"3000049","report_state":"US","report_number":"0904000134","insp_date":"2023-05-24 00:00:00","insp_start_time":"1626","insp_end_time":"1656","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROMATX","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COMERCIALIZADORA EMBERS","shipping_paper_number":"1142","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-05-26 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":"18222","transaction_code":"A","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":"2023-05-26 21:39:00","snet_input_date":"2023-05-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-05-26 21:39:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:20.000000Z","updated_at":"2025-03-17T19:25:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5062029,"change_date":"2023-05-26 21:39:00","inspection_id":"78736576","insp_unit_id":"195155973","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"R343280","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8FJ418733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:54.000000Z","updated_at":"2025-03-17T22:42:54.000000Z"},{"id":5062030,"change_date":"2023-05-26 21:39:00","inspection_id":"78736576","insp_unit_id":"195155974","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"59UN3B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1GRAA0626CW700249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:54.000000Z","updated_at":"2025-03-17T22:42:54.000000Z"}]},{"id":2915927,"change_date":"2023-04-28 21:38:00","inspection_id":"78475759","dot_number":"3000049","report_state":"AR","report_number":"768C000545","insp_date":"2023-04-27 00:00:00","insp_start_time":"0251","insp_end_time":"0320","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"WALLACE","shipping_paper_number":"WBL0136850","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":"2023-04-28 21:38: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":"1455068","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-28 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-04-28 21:38:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:28.000000Z","updated_at":"2025-03-17T19:20:28.000000Z","inspection_violations":[{"id":4475853,"change_date":"2023-04-28 21:38:00","inspection_id":"78475759","insp_violation_id":"252501325","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:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":4691219,"change_date":"2023-04-28 21:38:00","inspection_id":"78475759","insp_unit_id":"194639750","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"09","insp_unit_license":"R320784","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6LJ417026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"},{"id":4691220,"change_date":"2023-04-28 21:38:00","inspection_id":"78475759","insp_unit_id":"194639751","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"RT02","insp_unit_license":"107C930","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536DM530648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"}]},{"id":2915076,"change_date":"2023-04-28 21:38:00","inspection_id":"78474807","dot_number":"3000049","report_state":"US","report_number":"1019000081","insp_date":"2023-04-13 00:00:00","insp_start_time":"1930","insp_end_time":"2002","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"RIO GRANDE CITYTX","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WENCESLAO COLUNGA RUIZ","shipping_paper_number":"14728","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-04-28 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":"11109","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":"2023-04-28 21:38:00","snet_input_date":"2023-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-04-28 21:38:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:28.000000Z","updated_at":"2025-03-17T19:20:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4690001,"change_date":"2023-04-28 21:38:00","inspection_id":"78474807","insp_unit_id":"194638134","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"R343280","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8FJ418733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"},{"id":4690002,"change_date":"2023-04-28 21:38:00","inspection_id":"78474807","insp_unit_id":"194638135","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"59UN3B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1GRAA0626CW700249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"}]},{"id":2483995,"change_date":"2023-03-01 21:42:00","inspection_id":"77984711","dot_number":"3000049","report_state":"WA","report_number":"W538000304","insp_date":"2023-02-21 00:00:00","insp_start_time":"0615","insp_end_time":"0650","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"DOCTOR D'S","shipping_paper_number":"822353","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":"N","pen_cen_match":"I","final_status_date":"2023-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"2555664","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-28 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:30.000000Z","updated_at":"2025-03-17T19:12:30.000000Z","inspection_violations":[{"id":3822219,"change_date":"2023-03-01 21:42:00","inspection_id":"77984711","insp_violation_id":"251424210","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:24:59.000000Z","updated_at":"2025-03-17T21:24:59.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":3997453,"change_date":"2023-03-01 21:42:00","inspection_id":"77984711","insp_unit_id":"193657458","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"R345373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2GJ499943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"},{"id":3997454,"change_date":"2023-03-01 21:42:00","inspection_id":"77984711","insp_unit_id":"193657459","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"154C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2538L8904422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"}]},{"id":2415676,"change_date":"2023-02-21 21:42:00","inspection_id":"77907086","dot_number":"3000049","report_state":"NV","report_number":"7033021494","insp_date":"2023-02-18 00:00:00","insp_start_time":"1431","insp_end_time":"1447","registration_date":null,"region":"PT","ci_status_code":"C","location":"3","location_desc":"IR80 W\/B MM312","county_code_state":"NV","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DOCTOR D'S PROBIOTIC DRINK","shipping_paper_number":"822359","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-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"730944","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-18 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:06.000000Z","updated_at":"2025-03-17T19:11:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3887628,"change_date":"2023-02-21 21:42:00","inspection_id":"77907086","insp_unit_id":"193502092","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"R345373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2GJ499943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:50.000000Z","updated_at":"2025-03-17T22:33:50.000000Z"}]},{"id":2377987,"change_date":"2023-02-15 21:38:00","inspection_id":"77863946","dot_number":"3000049","report_state":"GA","report_number":"1335002602","insp_date":"2023-02-15 00:00:00","insp_start_time":"1045","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"273","location_desc":"COLUMBIA CO I\/S EB","county_code_state":"GA","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"BETTER PRODUCE","shipping_paper_number":"97177","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":"2023-02-15 21:38: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":"1952427","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-15 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-02-15 21:38:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:23.000000Z","updated_at":"2025-03-17T19:10:23.000000Z","inspection_violations":[{"id":3662029,"change_date":"2023-02-15 21:38:00","inspection_id":"77863946","insp_violation_id":"251151017","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:17.000000Z","updated_at":"2025-03-17T21:24:17.000000Z","normalized_code":"38351A"}],"inspection_per_units":[{"id":3826351,"change_date":"2023-02-15 21:38:00","inspection_id":"77863946","insp_unit_id":"193412503","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6995","insp_unit_license":"R342661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X7FJ436995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:25.000000Z","updated_at":"2025-03-17T22:33:25.000000Z"},{"id":3826352,"change_date":"2023-02-15 21:38:00","inspection_id":"77863946","insp_unit_id":"193412504","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"3337","insp_unit_license":"116B615","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0623EW703337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:25.000000Z","updated_at":"2025-03-17T22:33:25.000000Z"}]},{"id":2439093,"change_date":"2023-06-02 21:42:00","inspection_id":"77933625","dot_number":"3000049","report_state":"TX","report_number":"V231000268","insp_date":"2023-02-11 00:00:00","insp_start_time":"1320","insp_end_time":"1554","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 69C, SOUTH OF RAM","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-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8912032","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":"03000049","upload_search_indicator":"M","census_search_date":"2023-06-02 21:42:00","snet_input_date":"2023-02-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-23 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"1500 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":"0949098","created_at":"2025-03-17T19:11:29.000000Z","updated_at":"2025-03-17T19:11:29.000000Z","inspection_violations":[{"id":3756152,"change_date":"2023-06-02 21:42:00","inspection_id":"77933625","insp_violation_id":"253248122","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195288276","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39378"},{"id":3756153,"change_date":"2023-06-02 21:42:00","inspection_id":"77933625","insp_violation_id":"253248123","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"195288276","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39383G"},{"id":3756154,"change_date":"2023-06-02 21:42:00","inspection_id":"77933625","insp_violation_id":"253248124","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195288276","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3925556,"change_date":"2023-06-02 21:42:00","inspection_id":"77933625","insp_unit_id":"195288276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"R343280","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X8FJ418733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:07.000000Z","updated_at":"2025-03-17T22:34:07.000000Z"}]},{"id":2019445,"change_date":"2022-12-27 21:40:00","inspection_id":"77454262","dot_number":"3000049","report_state":"TX","report_number":"6H5A0XRWBU","insp_date":"2022-12-24 00:00:00","insp_start_time":"1000","insp_end_time":"1025","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":"DELIVERY","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-27 21:40: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":"8861797","transaction_code":"A","transaction_date":"2022-12-27 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-27 21:40:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":"0949098","created_at":"2025-03-17T19:03:44.000000Z","updated_at":"2025-03-17T19:03:44.000000Z","inspection_violations":[{"id":3133431,"change_date":"2022-12-27 21:40:00","inspection_id":"77454262","insp_violation_id":"250277281","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"192591385","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39360D"},{"id":3133432,"change_date":"2022-12-27 21:40:00","inspection_id":"77454262","insp_violation_id":"250277282","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192591385","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":3249387,"change_date":"2022-12-27 21:40:00","inspection_id":"77454262","insp_unit_id":"192591385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"R534941","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4GJ499944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:14.000000Z","updated_at":"2025-03-17T22:29:14.000000Z"},{"id":3249388,"change_date":"2022-12-27 21:40:00","inspection_id":"77454262","insp_unit_id":"192591386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R01","insp_unit_license":"116B615","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0623EW703337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:14.000000Z","updated_at":"2025-03-17T22:29:14.000000Z"}]},{"id":1907699,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","dot_number":"3000049","report_state":"CA","report_number":"NDOG003528","insp_date":"2022-12-07 00:00:00","insp_start_time":"1109","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"PIT SCALES","county_code_state":"CA","county_code":"111","insp_level_id":"1","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":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"14701163","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:51.000000Z","updated_at":"2025-03-17T19:01:51.000000Z","inspection_violations":[{"id":2968118,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","insp_violation_id":"250007319","seq_no":"2","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"192340332","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1","created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"39360E"},{"id":2968117,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","insp_violation_id":"250007318","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"192340332","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"39360C"},{"id":2968119,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","insp_violation_id":"250007320","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192340333","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3922"},{"id":2968120,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","insp_violation_id":"250007321","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192340332","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3070373,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","insp_unit_id":"192340332","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R607417","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X6PJ235317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:02.000000Z","updated_at":"2025-03-17T22:28:02.000000Z"},{"id":3070374,"change_date":"2022-12-08 21:41:00","inspection_id":"77326125","insp_unit_id":"192340333","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"215C756","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2533N8617301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:02.000000Z","updated_at":"2025-03-17T22:28:02.000000Z"}]},{"id":1799285,"change_date":"2022-11-22 21:41:00","inspection_id":"77202465","dot_number":"3000049","report_state":"SD","report_number":"0020086044","insp_date":"2022-11-21 00:00:00","insp_start_time":"1150","insp_end_time":"1209","registration_date":null,"region":"CT","ci_status_code":"C","location":"MC20","location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"NEENAH INC","shipping_paper_number":"ARC111822","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"631824","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":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:42.000000Z","updated_at":"2025-03-17T18:59:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2894290,"change_date":"2022-11-22 21:41:00","inspection_id":"77202465","insp_unit_id":"192092609","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"R3453736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2GJ499943","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":2894291,"change_date":"2022-11-22 21:41:00","inspection_id":"77202465","insp_unit_id":"192092610","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R06","insp_unit_license":"154C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2538L8904422","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":1453712,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","dot_number":"3000049","report_state":"ME","report_number":"3998010063","insp_date":"2022-10-05 00:00:00","insp_start_time":"1905","insp_end_time":"1932","registration_date":null,"region":"ET","ci_status_code":"C","location":"000018","location_desc":"OLD TOWN - SCALES SB","county_code_state":"ME","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"MCCAIN","shipping_paper_number":"6502070207","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-10-06 21:39: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":"354639","transaction_code":"C","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-10-06 21:39:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:27.000000Z","updated_at":"2025-03-17T18:53:27.000000Z","inspection_violations":[{"id":2289655,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","insp_violation_id":"253460728","seq_no":"1","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:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39111B2"},{"id":2289656,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","insp_violation_id":"253460729","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195460710","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3922"},{"id":2289657,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","insp_violation_id":"253460730","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:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39524D"},{"id":2289658,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","insp_violation_id":"253460731","seq_no":"4","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:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":2340451,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","insp_unit_id":"195460709","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7","insp_unit_license":"R607417","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X6PJ235317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"},{"id":2340452,"change_date":"2023-06-13 21:41:00","inspection_id":"76804884","insp_unit_id":"195460710","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1","insp_unit_license":"116B614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0620EW702596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"}]},{"id":1295619,"change_date":"2022-09-15 21:40:00","inspection_id":"76621251","dot_number":"3000049","report_state":"OH","report_number":"1441000090","insp_date":"2022-09-15 00:00:00","insp_start_time":"1145","insp_end_time":"1204","registration_date":null,"region":"ET","ci_status_code":"C","location":"097070","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MILNE SALES","shipping_paper_number":"15670","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1616342","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2085470,"change_date":"2022-09-15 21:40:00","inspection_id":"76621251","insp_unit_id":"190923465","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"R342661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X7FJ436995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:19.000000Z","updated_at":"2025-03-17T22:21:19.000000Z"},{"id":2085471,"change_date":"2022-09-15 21:40:00","inspection_id":"76621251","insp_unit_id":"190923466","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"90298","insp_unit_license":"107C930","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536DM530648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:19.000000Z","updated_at":"2025-03-17T22:21:19.000000Z"}]},{"id":365354,"change_date":"2022-05-11 21:39:00","inspection_id":"75528444","dot_number":"3000049","report_state":"ME","report_number":"3998009490","insp_date":"2022-05-10 00:00:00","insp_start_time":"1415","insp_end_time":"1443","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"LINEAGE LOGISTICS","shipping_paper_number":"NA","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-11 21:39: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":"345981","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-11 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-11 21:39:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:59.000000Z","updated_at":"2025-03-17T18:33:59.000000Z","inspection_violations":[{"id":572992,"change_date":"2022-05-11 21:39:00","inspection_id":"75528444","insp_violation_id":"245718641","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"3953A3I"},{"id":572993,"change_date":"2022-05-11 21:39:00","inspection_id":"75528444","insp_violation_id":"245718642","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":590713,"change_date":"2022-05-11 21:39:00","inspection_id":"75528444","insp_unit_id":"188621923","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"R320784","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6EJ361222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:49.000000Z","updated_at":"2025-03-17T22:11:49.000000Z"},{"id":590714,"change_date":"2022-05-11 21:39:00","inspection_id":"75528444","insp_unit_id":"188621924","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2","insp_unit_license":"107C930","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536DM530648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:49.000000Z","updated_at":"2025-03-17T22:11:49.000000Z"}]},{"id":299365,"change_date":"2022-05-02 21:40:00","inspection_id":"75450293","dot_number":"3000049","report_state":"TN","report_number":"TCME000397","insp_date":"2022-05-01 00:00:00","insp_start_time":"0012","insp_end_time":"0048","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-81","county_code_state":"TN","county_code":"163","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"LINEAGE","shipping_paper_number":"17-0072842","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":"I","final_status_date":"2022-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1569524","transaction_code":"A","transaction_date":"2022-05-01 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03000049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-02 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-05-02 21:40:00","insp_carrier_name":"ALEXMAR WATERMELON LLC","insp_carrier_street":"2501 DUKE AVE","insp_carrier_city":"MCALLEN","insp_carrier_state":"TX","insp_carrier_zip_code":"78504","insp_colonia":null,"docket_number":"28489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:38.000000Z","updated_at":"2025-03-17T18:32:38.000000Z","inspection_violations":[{"id":465690,"change_date":"2022-05-02 21:40:00","inspection_id":"75450293","insp_violation_id":"245507980","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W22002854","created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":484279,"change_date":"2022-05-02 21:40:00","inspection_id":"75450293","insp_unit_id":"188451376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"R534941","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X4GJ499944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:10.000000Z","updated_at":"2025-03-17T22:11:10.000000Z"},{"id":484280,"change_date":"2022-05-02 21:40:00","inspection_id":"75450293","insp_unit_id":"188451377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"116B614","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0620EW702596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:10.000000Z","updated_at":"2025-03-17T22:11:10.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3000049\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3000049\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3000049\/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\/3000049\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}