{"current_page":1,"data":[{"id":11902792,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","dot_number":"1590616","report_state":"SC","report_number":"0286006663","insp_date":"2026-05-13 00:00:00","insp_start_time":"0741","insp_end_time":"0841","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TOWNVILLE SC","county_code_state":"SC","county_code":"007","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTORS","shipping_paper_number":"148659L","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-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3317100","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:45.000000Z","updated_at":"2026-05-25T09:30:30.000000Z","inspection_violations":[{"id":20704469,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","insp_violation_id":"274243570","seq_no":"2","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"213540422","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:34.000000Z","updated_at":"2026-05-25T09:41:55.000000Z","normalized_code":"39330B"},{"id":20704470,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","insp_violation_id":"274243571","seq_no":"3","part_no":"395","part_no_section":"8A","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":"2026-05-16T13:12:34.000000Z","updated_at":"2026-05-25T09:41:55.000000Z","normalized_code":"3958A"},{"id":20704471,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","insp_violation_id":"274243572","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213540422","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:34.000000Z","updated_at":"2026-05-25T09:41:55.000000Z","normalized_code":"39378AWS"},{"id":20704468,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","insp_violation_id":"274243569","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213540422","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:34.000000Z","updated_at":"2026-05-25T09:41:55.000000Z","normalized_code":"3939ALIL"},{"id":20704472,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","insp_violation_id":"274243573","seq_no":"5","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"213540422","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:34.000000Z","updated_at":"2026-05-25T09:41:55.000000Z","normalized_code":"393203BCBP"}],"inspection_per_units":[{"id":20693326,"change_date":"2026-05-14 21:42:00","inspection_id":"87841635","insp_unit_id":"213540422","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1","insp_unit_license":"YQF550","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JV8G4S54820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:37.000000Z","updated_at":"2026-05-25T09:02:39.000000Z"}]},{"id":11925482,"change_date":"2026-05-15 21:44:00","inspection_id":"87859850","dot_number":"1590616","report_state":"SC","report_number":"0222000421","insp_date":"2026-05-13 00:00:00","insp_start_time":"1228","insp_end_time":"1244","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SALUDA SC","county_code_state":"SC","county_code":"081","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-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3333419","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:29.000000Z","updated_at":"2026-05-26T09:31:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20739605,"change_date":"2026-05-15 21:44:00","inspection_id":"87859850","insp_unit_id":"213573706","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1","insp_unit_license":"YQF550","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JV8G4S54820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:39.000000Z","updated_at":"2026-05-26T09:03:15.000000Z"}]},{"id":11125484,"change_date":"2026-02-13 21:38:00","inspection_id":"87038637","dot_number":"1590616","report_state":"GA","report_number":"1430000754","insp_date":"2026-02-10 00:00:00","insp_start_time":"1450","insp_end_time":"1505","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALPHARETTA GA","county_code_state":"GA","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2026-02-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2881966","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2026-02-13 21:38:00","snet_input_date":"2026-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-13 21:38:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-16T10:38:30.000000Z","updated_at":"2026-02-24T10:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18975431,"change_date":"2026-02-13 21:38:00","inspection_id":"87038637","insp_unit_id":"211606796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"YQF550","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JV8G4S54820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:14:56.000000Z","updated_at":"2026-02-24T10:02:26.000000Z"}]},{"id":10833381,"change_date":"2026-01-22 21:39:00","inspection_id":"86861569","dot_number":"1590616","report_state":"AL","report_number":"2178000531","insp_date":"2026-01-22 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PERDIDO AL","county_code_state":"AL","county_code":"003","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TIENDA SANTA FE","shipping_paper_number":"21003940","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-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2801449","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2026-01-22 21:39:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-22 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-25T10:36:58.000000Z","updated_at":"2026-02-02T10:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18200282,"change_date":"2026-01-22 21:39:00","inspection_id":"86861569","insp_unit_id":"211228149","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"N\/A","insp_unit_license":"ZAH046","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV1L4S76695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:15.000000Z","updated_at":"2026-02-02T10:02:57.000000Z"}]},{"id":10790395,"change_date":"2026-01-16 21:39:00","inspection_id":"86816501","dot_number":"1590616","report_state":"MS","report_number":"N701000109","insp_date":"2026-01-15 00:00:00","insp_start_time":"1115","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"34","location_desc":"JONES COUNTY","county_code_state":"MS","county_code":"067","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTORS","shipping_paper_number":"2100146","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":"2026-01-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1136716","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-16 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:55.000000Z","updated_at":"2026-01-27T10:30:41.000000Z","inspection_violations":[{"id":18031367,"change_date":"2026-01-16 21:39:00","inspection_id":"86816501","insp_violation_id":"271255483","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:31.000000Z","updated_at":"2026-01-27T10:31:14.000000Z","normalized_code":"39395A1"},{"id":18031368,"change_date":"2026-01-16 21:39:00","inspection_id":"86816501","insp_violation_id":"271255484","seq_no":"2","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":"99","citation_number":null,"created_at":"2026-01-19T10:43:31.000000Z","updated_at":"2026-01-27T10:31:14.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":18116154,"change_date":"2026-01-16 21:39:00","inspection_id":"86816501","insp_unit_id":"211133619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1","insp_unit_license":"ZAH046","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV1L4S76695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:26.000000Z","updated_at":"2026-01-27T10:00:45.000000Z"}]},{"id":10457433,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","dot_number":"1590616","report_state":"AL","report_number":"1526001748","insp_date":"2025-12-17 00:00:00","insp_start_time":"0532","insp_end_time":"0716","registration_date":null,"region":"CS","ci_status_code":"C","location":"18","location_desc":"HEFLIN AL","county_code_state":"AL","county_code":"029","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"LA LXTAPITA TIENDA LATINO","shipping_paper_number":"142736L","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":"U","pen_cen_match":"I","final_status_date":"2025-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"8","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2670076","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-12-17 21:39:00","snet_input_date":"2025-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:40.000000Z","updated_at":"2025-12-28T10:30:38.000000Z","inspection_violations":[{"id":17544416,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734929","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210655649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"3939ALHLI"},{"id":17544417,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734930","seq_no":"2","part_no":"393","part_no_section":"95K-EE","insp_viol_unit":"1","insp_unit_id":"210655649","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"39395KEE"},{"id":17544418,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734931","seq_no":"3","part_no":"393","part_no_section":"9B-LRLIWR","insp_viol_unit":"1","insp_unit_id":"210655649","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"3939BLRLIWR"},{"id":17544419,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734932","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"210655649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"3939ALSML"},{"id":17544420,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734933","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210655649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"3939ALCL"},{"id":17544421,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734934","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210655649","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U7360896","created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"3922SLLSR"},{"id":17544422,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734935","seq_no":"7","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U7360897","created_at":"2025-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"38323A2LCDLN"},{"id":17544423,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_violation_id":"270734936","seq_no":"8","part_no":"392","part_no_section":"7A-D","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-12-20T10:32:15.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","normalized_code":"3927AD"}],"inspection_per_units":[{"id":17501239,"change_date":"2025-12-17 21:39:00","inspection_id":"86590245","insp_unit_id":"210655649","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"2165","insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:45.000000Z","updated_at":"2025-12-28T10:00:43.000000Z"}]},{"id":10418167,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","dot_number":"1590616","report_state":"FL","report_number":"4308005487","insp_date":"2025-12-10 00:00:00","insp_start_time":"0945","insp_end_time":"1110","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PENSACOLA FL","county_code_state":"FL","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTION","shipping_paper_number":"142398L","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-12-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"4","driver_viol_total":"5","driver_oos_total":"4","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2646906","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-12-12 21:40:00","snet_input_date":"2025-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-12 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-15T10:31:57.000000Z","updated_at":"2025-12-23T10:30:28.000000Z","inspection_violations":[{"id":17465021,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","insp_violation_id":"270643891","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":"000897560","created_at":"2025-12-15T10:33:33.000000Z","updated_at":"2025-12-23T10:30:54.000000Z","normalized_code":"3958A1HOSP"},{"id":17465022,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","insp_violation_id":"270643892","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"C","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:33.000000Z","updated_at":"2025-12-23T10:30:54.000000Z","normalized_code":"39141APC"},{"id":17465023,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","insp_violation_id":"270643893","seq_no":"3","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"000897560 & AJ4","created_at":"2025-12-15T10:33:33.000000Z","updated_at":"2025-12-23T10:30:54.000000Z","normalized_code":"39111B5LNCDLNVL"},{"id":17465024,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","insp_violation_id":"270643894","seq_no":"4","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"000897560","created_at":"2025-12-15T10:33:33.000000Z","updated_at":"2025-12-23T10:30:54.000000Z","normalized_code":"39111B2Q"},{"id":17465025,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","insp_violation_id":"270643895","seq_no":"5","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"000897560","created_at":"2025-12-15T10:33:33.000000Z","updated_at":"2025-12-23T10:30:54.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17424327,"change_date":"2025-12-12 21:40:00","inspection_id":"86549264","insp_unit_id":"210571975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"YQF550","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JV8G4S54820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:31.000000Z","updated_at":"2025-12-23T10:00:35.000000Z"}]},{"id":10359232,"change_date":"2025-12-05 21:42:00","inspection_id":"86487531","dot_number":"1590616","report_state":"AL","report_number":"1311001622","insp_date":"2025-12-03 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"COTTONDALE AL","county_code_state":"AL","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO","shipping_paper_number":"14200742L","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-12-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2615450","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-12-05 21:42:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-05 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:31:54.000000Z","updated_at":"2025-12-09T10:30:44.000000Z","inspection_violations":[{"id":17345498,"change_date":"2025-12-05 21:42:00","inspection_id":"86487531","insp_violation_id":"270482253","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-12-08T10:32:44.000000Z","updated_at":"2025-12-09T10:31:19.000000Z","normalized_code":"3958A1HOSP"},{"id":17345499,"change_date":"2025-12-05 21:42:00","inspection_id":"86487531","insp_violation_id":"270482254","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:44.000000Z","updated_at":"2025-12-09T10:31:19.000000Z","normalized_code":"39111B2Q"},{"id":17345500,"change_date":"2025-12-05 21:42:00","inspection_id":"86487531","insp_violation_id":"270482255","seq_no":"3","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"210433700","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:44.000000Z","updated_at":"2025-12-09T10:31:19.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":17314534,"change_date":"2025-12-05 21:42:00","inspection_id":"86487531","insp_unit_id":"210433700","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"ZAH046","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV1L4S76695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:02.000000Z","updated_at":"2025-12-09T10:00:52.000000Z"}]},{"id":10259566,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","dot_number":"1590616","report_state":"MS","report_number":"6610008947","insp_date":"2025-11-20 00:00:00","insp_start_time":"1308","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"COVINGTON COUNTY","county_code_state":"MS","county_code":"031","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MHD","shipping_paper_number":"14199972L","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":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"10","oos_total":"0","driver_viol_total":"9","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1130120","transaction_code":"A","transaction_date":"2025-11-20 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-21 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:42.000000Z","updated_at":"2025-11-25T10:30:34.000000Z","inspection_violations":[{"id":17068155,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126605","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210174813","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"39395A1"},{"id":17068156,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126606","seq_no":"2","part_no":"395","part_no_section":"8C-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958CHOSF"},{"id":17068157,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126607","seq_no":"3","part_no":"395","part_no_section":"8C-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958CHOSF"},{"id":17068158,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126608","seq_no":"4","part_no":"395","part_no_section":"8C-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958CHOSF"},{"id":17068159,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126609","seq_no":"5","part_no":"395","part_no_section":"8D2-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958D2HOSF"},{"id":17068160,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126610","seq_no":"6","part_no":"395","part_no_section":"8D2-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958D2HOSF"},{"id":17068161,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126611","seq_no":"7","part_no":"395","part_no_section":"8D3-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958D3HOSF"},{"id":17068162,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126612","seq_no":"8","part_no":"395","part_no_section":"8D10-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958D10HOSF"},{"id":17068163,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126613","seq_no":"9","part_no":"395","part_no_section":"8D5-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958D5HOSF"},{"id":17068164,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_violation_id":"270126614","seq_no":"10","part_no":"395","part_no_section":"8D5-HOSF","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-11-24T10:32:39.000000Z","updated_at":"2025-11-25T10:30:48.000000Z","normalized_code":"3958D5HOSF"}],"inspection_per_units":[{"id":17103656,"change_date":"2025-11-21 21:38:00","inspection_id":"86383215","insp_unit_id":"210174813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"ZAH046","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV1L4S76695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:56.000000Z","updated_at":"2025-11-25T10:00:39.000000Z"}]},{"id":10161737,"change_date":"2025-11-10 21:39:00","inspection_id":"86280553","dot_number":"1590616","report_state":"SC","report_number":"0399000959","insp_date":"2025-11-07 00:00:00","insp_start_time":"1514","insp_end_time":"1535","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ANDERSON SC","county_code_state":"SC","county_code":"007","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","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-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2524687","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-11-10 21:39:00","snet_input_date":"2025-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:40.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16920491,"change_date":"2025-11-10 21:39:00","inspection_id":"86280553","insp_unit_id":"209935729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"YQF550","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JV8G4S54820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:37.000000Z","updated_at":"2025-11-14T10:00:40.000000Z"}]},{"id":9831442,"change_date":"2025-10-02 21:41:00","inspection_id":"85932313","dot_number":"1590616","report_state":"SC","report_number":"0222000251","insp_date":"2025-10-01 00:00:00","insp_start_time":"1312","insp_end_time":"1342","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"JOHNSTON SC","county_code_state":"SC","county_code":"037","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":"2025-10-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2355480","transaction_code":"A","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-10-02 21:41:00","snet_input_date":"2025-10-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-02 21:41:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:01:28.000000Z","updated_at":"2025-10-05T10:01:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16300208,"change_date":"2025-10-02 21:41:00","inspection_id":"85932313","insp_unit_id":"209249746","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:45.000000Z","updated_at":"2025-10-05T09:46:45.000000Z"}]},{"id":8379708,"change_date":"2025-04-15 21:40:00","inspection_id":"84403535","dot_number":"1590616","report_state":"AL","report_number":"1928003081","insp_date":"2025-04-15 00:00:00","insp_start_time":"1208","insp_end_time":"1312","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ELMORE AL","county_code_state":"AL","county_code":"051","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EL CHARRITO","shipping_paper_number":"1886256","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-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","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":"1598277","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-04-15 21:40:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-15 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:25:52.000000Z","updated_at":"2025-04-19T10:15:32.000000Z","inspection_violations":[{"id":13207710,"change_date":"2025-04-15 21:40:00","inspection_id":"84403535","insp_violation_id":"265627981","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U6161278","created_at":"2025-04-18T10:54:56.000000Z","updated_at":"2025-04-18T11:00:06.000000Z","normalized_code":"39141APC"},{"id":13207711,"change_date":"2025-04-15 21:40:00","inspection_id":"84403535","insp_violation_id":"265627982","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206319084","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:54:56.000000Z","updated_at":"2025-04-18T11:00:06.000000Z","normalized_code":"39021TB2DOT"},{"id":13207712,"change_date":"2025-04-15 21:40:00","inspection_id":"84403535","insp_violation_id":"265627983","seq_no":"3","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"206319084","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:54:56.000000Z","updated_at":"2025-04-18T11:00:06.000000Z","normalized_code":"39311A1LCL"}],"inspection_per_units":[{"id":13599621,"change_date":"2025-04-15 21:40:00","inspection_id":"84403535","insp_unit_id":"206319084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"VIN 2027","insp_unit_license":"EXE884","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFC9JDKC2027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:10:21.000000Z","updated_at":"2025-04-19T09:54:30.000000Z"}]},{"id":7681420,"change_date":"2025-01-22 21:39:00","inspection_id":"83669289","dot_number":"1590616","report_state":"GA","report_number":"1265000854","insp_date":"2025-01-15 00:00:00","insp_start_time":"1543","insp_end_time":"1610","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LITHIA SPRINGS GA","county_code_state":"GA","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2025-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1274506","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:51.000000Z","updated_at":"2025-03-17T20:57:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12395028,"change_date":"2025-01-22 21:39:00","inspection_id":"83669289","insp_unit_id":"204952082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"VIN6695","insp_unit_license":"ZAH046","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV1L4S76695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:49.000000Z","updated_at":"2025-03-17T23:51:49.000000Z"}]},{"id":7144286,"change_date":"2024-11-07 21:40:00","inspection_id":"83103818","dot_number":"1590616","report_state":"AL","report_number":"1311000686","insp_date":"2024-11-06 00:00:00","insp_start_time":"1406","insp_end_time":"1427","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":null,"final_status_date":"2024-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1031533","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-11-07 21:40:00","snet_input_date":"2024-11-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-11-07 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:05.000000Z","updated_at":"2025-03-17T20:45:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11522748,"change_date":"2024-11-07 21:40:00","inspection_id":"83103818","insp_unit_id":"203781804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"ZAH046","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV1L4S76695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:23.000000Z","updated_at":"2025-03-17T23:42:23.000000Z"}]},{"id":6618607,"change_date":"2024-08-31 21:33:00","inspection_id":"82545021","dot_number":"1590616","report_state":"AL","report_number":"L266000238","insp_date":"2024-08-30 00:00:00","insp_start_time":"0915","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"COUNTY","county_code_state":"AL","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RIVERCHASE BP","shipping_paper_number":"69825455","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-08-31 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1021494","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-08-31 21:33:00","snet_input_date":"2024-08-30 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-31 21:33:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:07.000000Z","updated_at":"2025-03-17T20:34:07.000000Z","inspection_violations":[{"id":10292609,"change_date":"2024-08-31 21:33:00","inspection_id":"82545021","insp_violation_id":"261542370","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":"99","citation_number":"W000762","created_at":"2025-03-17T21:55:50.000000Z","updated_at":"2025-03-17T21:55:50.000000Z","normalized_code":"3958A1"},{"id":10292610,"change_date":"2024-08-31 21:33:00","inspection_id":"82545021","insp_violation_id":"261542371","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U5223902","created_at":"2025-03-17T21:55:50.000000Z","updated_at":"2025-03-17T21:55:50.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":10670851,"change_date":"2024-08-31 21:33:00","inspection_id":"82545021","insp_unit_id":"202699525","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:31.000000Z","updated_at":"2025-03-17T23:33:31.000000Z"}]},{"id":6174993,"change_date":"2024-07-30 21:43:00","inspection_id":"82070881","dot_number":"1590616","report_state":"AL","report_number":"1836002303","insp_date":"2024-07-09 00:00:00","insp_start_time":"0740","insp_end_time":"0835","registration_date":"2024-07-26 00:00:00","region":"CT","ci_status_code":"C","location":"13","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"019","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTORS LLC","shipping_paper_number":"67506","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-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1012805","transaction_code":"C","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-07-09 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:02.000000Z","updated_at":"2025-03-17T20:25:02.000000Z","inspection_violations":[{"id":9588689,"change_date":"2024-07-30 21:43:00","inspection_id":"82070881","insp_violation_id":"260916707","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202143683","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39395A"},{"id":9588690,"change_date":"2024-07-30 21:43:00","inspection_id":"82070881","insp_violation_id":"260916708","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202143683","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W001523","created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39021TB"},{"id":9588691,"change_date":"2024-07-30 21:43:00","inspection_id":"82070881","insp_violation_id":"260916709","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202143683","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3922"},{"id":9588692,"change_date":"2024-07-30 21:43:00","inspection_id":"82070881","insp_violation_id":"260916710","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"202143683","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9947542,"change_date":"2024-07-30 21:43:00","inspection_id":"82070881","insp_unit_id":"202143683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"VIN 2165","insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:05.000000Z","updated_at":"2025-03-17T23:26:05.000000Z"}]},{"id":5777044,"change_date":"2024-06-11 21:42:00","inspection_id":"81640318","dot_number":"1590616","report_state":"AL","report_number":"DJUA001169","insp_date":"2024-05-17 00:00:00","insp_start_time":"0510","insp_end_time":"0645","registration_date":"2024-06-07 00:00:00","region":"CT","ci_status_code":"C","location":"I020","location_desc":"WEIGH STATION","county_code_state":"AL","county_code":"029","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PUEBLO SUPERMARKET","shipping_paper_number":"28174","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":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1005728","transaction_code":"C","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-17 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:08.000000Z","updated_at":"2025-03-17T20:17:08.000000Z","inspection_violations":[{"id":8944479,"change_date":"2024-06-11 21:42:00","inspection_id":"81640318","insp_violation_id":"260017483","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"U4784357","created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"38323A2"},{"id":8944480,"change_date":"2024-06-11 21:42:00","inspection_id":"81640318","insp_violation_id":"260017484","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":"U4784358","created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9304698,"change_date":"2024-06-11 21:42:00","inspection_id":"81640318","insp_unit_id":"201332430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"YFP608","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV7K4S72035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:37.000000Z","updated_at":"2025-03-17T23:19:37.000000Z"}]},{"id":5643049,"change_date":"2024-06-12 21:42:00","inspection_id":"81494871","dot_number":"1590616","report_state":"AL","report_number":"SCHP008259","insp_date":"2024-05-01 00:00:00","insp_start_time":"0820","insp_end_time":"0856","registration_date":"2024-06-10 00:00:00","region":"CT","ci_status_code":"C","location":"39","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"071","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTORS","shipping_paper_number":"2597","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-05-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1003143","transaction_code":"C","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-05-01 21:42:00","snet_input_date":"2024-05-01 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-01 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:40.000000Z","updated_at":"2025-03-17T20:14:40.000000Z","inspection_violations":[{"id":8727603,"change_date":"2024-06-12 21:42:00","inspection_id":"81494871","insp_violation_id":"260044746","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":"99","citation_number":"U3994501","created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"3958A1"},{"id":8727604,"change_date":"2024-06-12 21:42:00","inspection_id":"81494871","insp_violation_id":"260044747","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"201357589","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":9089340,"change_date":"2024-06-12 21:42:00","inspection_id":"81494871","insp_unit_id":"201357589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:33.000000Z","updated_at":"2025-03-17T23:17:33.000000Z"}]},{"id":5606164,"change_date":"2024-05-31 21:39:00","inspection_id":"81454673","dot_number":"1590616","report_state":"MS","report_number":"5019010913","insp_date":"2024-04-25 00:00:00","insp_start_time":"0557","insp_end_time":"0639","registration_date":"2024-05-30 00:00:00","region":"ET","ci_status_code":"C","location":"38","location_desc":"LAUDERDALE COUNTY","county_code_state":"MS","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTIONS","shipping_paper_number":"2498","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1066201","transaction_code":"C","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-25 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[{"id":8668088,"change_date":"2024-05-31 21:39:00","inspection_id":"81454673","insp_violation_id":"259833981","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"500310863","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"38323A2"},{"id":8668089,"change_date":"2024-05-31 21:39:00","inspection_id":"81454673","insp_violation_id":"259833982","seq_no":"2","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":"4","citation_number":"500310864","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3958A1"},{"id":8668090,"change_date":"2024-05-31 21:39:00","inspection_id":"81454673","insp_violation_id":"259833983","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"50031065","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9030237,"change_date":"2024-05-31 21:39:00","inspection_id":"81454673","insp_unit_id":"201173737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:02.000000Z","updated_at":"2025-03-17T23:17:02.000000Z"}]},{"id":5466705,"change_date":"2024-04-09 21:40:00","inspection_id":"81302334","dot_number":"1590616","report_state":"GA","report_number":"1415000240","insp_date":"2024-04-03 00:00:00","insp_start_time":"1550","insp_end_time":"1615","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GROVETOWN GA","county_code_state":"GA","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","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-04-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","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":"382338","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-04-09 21:40:00","snet_input_date":"2024-04-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-09 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:09.000000Z","updated_at":"2025-03-17T20:11:09.000000Z","inspection_violations":[{"id":8440453,"change_date":"2024-04-09 21:40:00","inspection_id":"81302334","insp_violation_id":"258819280","seq_no":"1","part_no":"383","part_no_section":"71(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:54.000000Z","updated_at":"2025-03-17T21:46:54.000000Z","normalized_code":"38371C"},{"id":8440454,"change_date":"2024-04-09 21:40:00","inspection_id":"81302334","insp_violation_id":"258819281","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W01E233908","created_at":"2025-03-17T21:46:54.000000Z","updated_at":"2025-03-17T21:46:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8805578,"change_date":"2024-04-09 21:40:00","inspection_id":"81302334","insp_unit_id":"200301744","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"VIN-6233","insp_unit_license":"ELZ636","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JT7F4S56233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:55.000000Z","updated_at":"2025-03-17T23:14:55.000000Z"}]},{"id":4809318,"change_date":"2024-01-11 21:45:00","inspection_id":"80584709","dot_number":"1590616","report_state":"GA","report_number":"1405000014","insp_date":"2024-01-10 00:00:00","insp_start_time":"1825","insp_end_time":"1840","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MADISON GA","county_code_state":"GA","county_code":"211","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","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":"U","pen_cen_match":"I","final_status_date":"2024-01-11 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"169264","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-01-11 21:45:00","snet_input_date":"2024-01-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-11 21:45:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:02.000000Z","updated_at":"2025-03-17T19:58:02.000000Z","inspection_violations":[{"id":7417870,"change_date":"2024-01-11 21:45:00","inspection_id":"80584709","insp_violation_id":"257289160","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W01E076447","created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":7737714,"change_date":"2024-01-11 21:45:00","inspection_id":"80584709","insp_unit_id":"198912038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"VIN 2027","insp_unit_license":"EXE884","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFC9JDKC2027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:09.000000Z","updated_at":"2025-03-17T23:05:09.000000Z"}]},{"id":4821718,"change_date":"2024-01-12 21:42:00","inspection_id":"80598242","dot_number":"1590616","report_state":"GA","report_number":"0370000070","insp_date":"2024-01-04 00:00:00","insp_start_time":"1231","insp_end_time":"1316","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ELLIJAY GA","county_code_state":"GA","county_code":"123","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"98861","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-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"171739","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":"01590616","upload_search_indicator":null,"census_search_date":"2024-01-12 21:42:00","snet_input_date":"2024-01-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-12 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:24.000000Z","updated_at":"2025-03-17T19:58:24.000000Z","inspection_violations":[{"id":7435536,"change_date":"2024-01-12 21:42:00","inspection_id":"80598242","insp_violation_id":"257315369","seq_no":"1","part_no":"391","part_no_section":"41A1-MCOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:52.000000Z","updated_at":"2025-03-17T21:41:52.000000Z","normalized_code":"39141A1MCOOS"}],"inspection_per_units":[{"id":7757669,"change_date":"2024-01-12 21:42:00","inspection_id":"80598242","insp_unit_id":"198937554","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1","insp_unit_license":"ELZ636","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JT7F4S56233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:20.000000Z","updated_at":"2025-03-17T23:05:20.000000Z"}]},{"id":4744123,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","dot_number":"1590616","report_state":"SC","report_number":"B284004312","insp_date":"2023-12-31 00:00:00","insp_start_time":"0747","insp_end_time":"0832","registration_date":"2024-03-27 00:00:00","region":"ET","ci_status_code":"C","location":"107","location_desc":"I-85 NB ROADSIDE","county_code_state":"SC","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"98760","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":"2024-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"7","oos_total":"1","driver_viol_total":"5","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1122688","transaction_code":"C","transaction_date":"2023-12-31 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2024-01-02 21:43:00","snet_input_date":"2023-12-31 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[{"id":7322156,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612458","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"20232421034885","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"38323A2"},{"id":7322157,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612459","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":"WA52969","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"},{"id":7322158,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612460","seq_no":"3","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:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"},{"id":7322159,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612461","seq_no":"4","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:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"},{"id":7322160,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612462","seq_no":"5","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3958F1"},{"id":7322161,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612463","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200112936","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39395A"},{"id":7322162,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_violation_id":"258612464","seq_no":"7","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200112936","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":7631227,"change_date":"2024-03-27 21:42:00","inspection_id":"80513405","insp_unit_id":"200112936","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"6","insp_unit_license":"YFP608","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNJ8JV7K4S72035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4628546,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","dot_number":"1590616","report_state":"AL","report_number":"SKGG005339","insp_date":"2023-12-14 00:00:00","insp_start_time":"0820","insp_end_time":"0920","registration_date":"2024-01-12 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"053","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"100712","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-12-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"985154","transaction_code":"C","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-12-14 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-12-14 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:33.000000Z","updated_at":"2025-03-17T19:54:33.000000Z","inspection_violations":[{"id":7155031,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","insp_violation_id":"257346735","seq_no":"1","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:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"3958"},{"id":7155032,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","insp_violation_id":"257346736","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:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"3958"},{"id":7155033,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","insp_violation_id":"257346737","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198966289","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"39395A"},{"id":7155034,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","insp_violation_id":"257346738","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198966289","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"39378"},{"id":7155035,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","insp_violation_id":"257346739","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198966289","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":7444330,"change_date":"2024-01-16 21:44:00","inspection_id":"80387194","insp_unit_id":"198966289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"YQF550","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JV8G4S54820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:34.000000Z","updated_at":"2025-03-17T23:02:34.000000Z"}]},{"id":4472569,"change_date":"2023-11-21 21:40:00","inspection_id":"80215780","dot_number":"1590616","report_state":"TN","report_number":"TFGJ000057","insp_date":"2023-11-20 00:00:00","insp_start_time":"0835","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 1 KNOX SCALES- EAST","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MERCADO HISPANO","shipping_paper_number":"99726","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-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1690422","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-21 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:26.000000Z","updated_at":"2025-03-17T19:51:26.000000Z","inspection_violations":[{"id":6923165,"change_date":"2023-11-21 21:40:00","inspection_id":"80215780","insp_violation_id":"256511567","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198164721","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3963A1"},{"id":6923166,"change_date":"2023-11-21 21:40:00","inspection_id":"80215780","insp_violation_id":"256511568","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"198164721","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":7192919,"change_date":"2023-11-21 21:40:00","inspection_id":"80215780","insp_unit_id":"198164721","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:24.000000Z","updated_at":"2025-03-17T23:00:24.000000Z"}]},{"id":4450322,"change_date":"2024-01-29 21:39:00","inspection_id":"80191254","dot_number":"1590616","report_state":"AL","report_number":"1440001253","insp_date":"2023-11-17 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":"2024-01-12 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"99665","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-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"983097","transaction_code":"C","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-11-17 21:40:00","snet_input_date":"2023-11-17 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-11-17 21:40:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:04.000000Z","updated_at":"2025-03-17T19:51:04.000000Z","inspection_violations":[{"id":6889360,"change_date":"2024-01-29 21:39:00","inspection_id":"80191254","insp_violation_id":"257532083","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199142809","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:13.000000Z","updated_at":"2025-03-17T21:39:13.000000Z","normalized_code":"39395A"},{"id":6889361,"change_date":"2024-01-29 21:39:00","inspection_id":"80191254","insp_violation_id":"257532084","seq_no":"4","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"199142809","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:13.000000Z","updated_at":"2025-03-17T21:39:13.000000Z","normalized_code":"39021TA"},{"id":6889362,"change_date":"2024-01-29 21:39:00","inspection_id":"80191254","insp_violation_id":"257532085","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":"U4021068","created_at":"2025-03-17T21:39:13.000000Z","updated_at":"2025-03-17T21:39:13.000000Z","normalized_code":"3958A1"},{"id":6889363,"change_date":"2024-01-29 21:39:00","inspection_id":"80191254","insp_violation_id":"257532086","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","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:39:13.000000Z","updated_at":"2025-03-17T21:39:13.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":7156854,"change_date":"2024-01-29 21:39:00","inspection_id":"80191254","insp_unit_id":"199142809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:06.000000Z","updated_at":"2025-03-17T23:00:06.000000Z"}]},{"id":4012204,"change_date":"2023-09-20 21:39:00","inspection_id":"79706241","dot_number":"1590616","report_state":"SC","report_number":"G372000388","insp_date":"2023-09-20 00:00:00","insp_start_time":"0758","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"00729","location_desc":"US 29 ANDERSON COUNTY","county_code_state":"SC","county_code":"007","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTORS","shipping_paper_number":"97348","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-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1106540","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","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":6208383,"change_date":"2023-09-20 21:39:00","inspection_id":"79706241","insp_violation_id":"255371247","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197141782","insp_violation_category_id":"20","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":"3939A"},{"id":6208384,"change_date":"2023-09-20 21:39:00","inspection_id":"79706241","insp_violation_id":"255371248","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197141782","insp_violation_category_id":"20","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":"3939A"}],"inspection_per_units":[{"id":6451224,"change_date":"2023-09-20 21:39:00","inspection_id":"79706241","insp_unit_id":"197141782","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"EXE884","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFC9JDKC2027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"}]},{"id":3877220,"change_date":"2023-08-31 21:42:00","inspection_id":"79556185","dot_number":"1590616","report_state":"MS","report_number":"5013011314","insp_date":"2023-08-31 00:00:00","insp_start_time":"0707","insp_end_time":"0746","registration_date":null,"region":"CT","ci_status_code":"C","location":"51","location_desc":"NEWTON COUNTY","county_code_state":"MS","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO HISPANO DISTRIBUTORS","shipping_paper_number":"96554","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1044084","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-08-31 21:42:00","snet_input_date":"2023-08-31 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:25.000000Z","updated_at":"2025-03-17T19:39:25.000000Z","inspection_violations":[{"id":5992190,"change_date":"2023-08-31 21:42:00","inspection_id":"79556185","insp_violation_id":"255016262","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196838410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39021TB"},{"id":5992191,"change_date":"2023-08-31 21:42:00","inspection_id":"79556185","insp_violation_id":"255016263","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196838410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W500355278","created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6233169,"change_date":"2023-08-31 21:42:00","inspection_id":"79556185","insp_unit_id":"196838410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"TRUCK","insp_unit_license":"YJH946","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NP2HN6X3DM188825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:22.000000Z","updated_at":"2025-03-17T22:52:22.000000Z"}]},{"id":3876573,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","dot_number":"1590616","report_state":"GA","report_number":"0337007258","insp_date":"2023-08-25 00:00:00","insp_start_time":"0745","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MERCADO HISPANO DISTRIBUTORS","shipping_paper_number":"96326","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1997180","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-08-31 21:42:00","snet_input_date":"2023-08-30 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:24.000000Z","updated_at":"2025-03-17T19:39:24.000000Z","inspection_violations":[{"id":5991266,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014236","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E04761691","created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3922"},{"id":5991267,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014237","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3939A"},{"id":5991268,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014238","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39395A"},{"id":5991269,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014239","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39617C"},{"id":5991270,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014240","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39375C"},{"id":5991271,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014241","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39347A"},{"id":5991272,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_violation_id":"255014242","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196836598","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6232168,"change_date":"2023-08-31 21:42:00","inspection_id":"79555453","insp_unit_id":"196836598","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"VIN-8825","insp_unit_license":"YJH946","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NP2HN6X3DM188825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:22.000000Z","updated_at":"2025-03-17T22:52:22.000000Z"}]},{"id":3631274,"change_date":"2023-07-31 21:41:00","inspection_id":"79281331","dot_number":"1590616","report_state":"SC","report_number":"G222999835","insp_date":"2023-07-28 00:00:00","insp_start_time":"1143","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":"081121","location_desc":"SC 121 SALUDA COUNTY","county_code_state":"SC","county_code":"081","insp_level_id":"1","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":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1097405","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-07-31 21:41:00","snet_input_date":"2023-07-28 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-07-31 21:41:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:34.000000Z","updated_at":"2025-03-17T19:34:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5838241,"change_date":"2023-07-31 21:41:00","inspection_id":"79281331","insp_unit_id":"196276125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"YHJ434","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NKHHM6X6NM482165","insp_unit_decal":"Y","insp_unit_decal_number":"33140966","created_at":"2025-03-17T22:49:06.000000Z","updated_at":"2025-03-17T22:49:06.000000Z"}]},{"id":2975678,"change_date":"2023-05-05 21:42:00","inspection_id":"78543215","dot_number":"1590616","report_state":"SC","report_number":"T364000871","insp_date":"2023-05-05 00:00:00","insp_start_time":"0758","insp_end_time":"0818","registration_date":null,"region":"ET","ci_status_code":"C","location":"114","location_desc":"I-385 SB ROADSIDE","county_code_state":"SC","county_code":"045","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"LA UNICA","shipping_paper_number":"91903","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-05-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1082475","transaction_code":"A","transaction_date":"2023-05-05 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-05-05 21:42:00","snet_input_date":"2023-05-05 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-05-05 21:42:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:53.000000Z","updated_at":"2025-03-17T19:21:53.000000Z","inspection_violations":[{"id":4566852,"change_date":"2023-05-05 21:42:00","inspection_id":"78543215","insp_violation_id":"252650236","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194773882","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4787349,"change_date":"2023-05-05 21:42:00","inspection_id":"78543215","insp_unit_id":"194773882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"ELZ636","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNE8JT7F4S56233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:44.000000Z","updated_at":"2025-03-17T22:40:44.000000Z"}]},{"id":2177940,"change_date":"2023-01-19 21:43:00","inspection_id":"77635737","dot_number":"1590616","report_state":"GA","report_number":"0141003777","insp_date":"2023-01-18 00:00:00","insp_start_time":"1640","insp_end_time":"1655","registration_date":null,"region":"ET","ci_status_code":"C","location":"HCC","location_desc":"HIGH CRASH CORRIDOR","county_code_state":"GA","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1947423","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01590616","upload_search_indicator":null,"census_search_date":"2023-01-19 21:43:00","snet_input_date":"2023-01-19 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-01-19 21:43:00","insp_carrier_name":"MERCADO HISPANO DISTRIBUTORS LLC","insp_carrier_street":"4747 GRANITE DR SUITE B","insp_carrier_city":"TUCKER","insp_carrier_state":"GA","insp_carrier_zip_code":"30084","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[{"id":3365560,"change_date":"2023-01-19 21:43:00","inspection_id":"77635737","insp_violation_id":"250653501","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3505080,"change_date":"2023-01-19 21:43:00","inspection_id":"77635737","insp_unit_id":"192948571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2027","insp_unit_license":"EXE884","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFC9JDKC2027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:09.000000Z","updated_at":"2025-03-17T22:31:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1590616\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1590616\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1590616\/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\/1590616\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}