{"current_page":1,"data":[{"id":12212626,"change_date":"2026-06-17 21:41:00","inspection_id":"88169945","dot_number":"2169156","report_state":"NC","report_number":"0006886193","insp_date":"2026-06-17 00:00:00","insp_start_time":"1335","insp_end_time":"1355","registration_date":null,"region":"ED","ci_status_code":"C","location":"CATAWB","location_desc":"HICKORY NC","county_code_state":"NC","county_code":"035","insp_level_id":"2","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-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3564320","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2026-06-17 21:41:00","snet_input_date":"2026-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-17 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-20T09:43:45.000000Z","updated_at":"2026-06-28T09:31:02.000000Z","inspection_violations":[{"id":21254387,"change_date":"2026-06-17 21:41:00","inspection_id":"88169945","insp_violation_id":"274969098","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214153490","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3324121","created_at":"2026-06-19T10:05:52.000000Z","updated_at":"2026-06-28T09:41:33.000000Z","normalized_code":"39375A3TAOL"},{"id":21254388,"change_date":"2026-06-17 21:41:00","inspection_id":"88169945","insp_violation_id":"274969099","seq_no":"2","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"214153490","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3324121","created_at":"2026-06-19T10:05:52.000000Z","updated_at":"2026-06-28T09:41:33.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":21210623,"change_date":"2026-06-17 21:41:00","inspection_id":"88169945","insp_unit_id":"214153490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2720","insp_unit_license":"NM5497","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX04C3JM041698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:22:04.000000Z","updated_at":"2026-06-28T09:02:25.000000Z"}]},{"id":11333690,"change_date":"2026-03-10 21:38:00","inspection_id":"87250932","dot_number":"2169156","report_state":"NC","report_number":"0006854828","insp_date":"2026-03-09 00:00:00","insp_start_time":"1034","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"I77","location_desc":"I77","county_code_state":"NC","county_code":"119","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":"N","pen_cen_match":null,"final_status_date":"2026-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"2385526","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2026-03-10 21:38:00","snet_input_date":"2026-03-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-03-10 21:38:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:46.000000Z","updated_at":"2026-03-21T09:31:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19393690,"change_date":"2026-03-10 21:38:00","inspection_id":"87250932","insp_unit_id":"212062627","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MX7625","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX32C7GM011021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:22.000000Z","updated_at":"2026-03-21T09:11:04.000000Z"}]},{"id":10883479,"change_date":"2026-01-29 21:38:00","inspection_id":"86914075","dot_number":"2169156","report_state":"NC","report_number":"0006843294","insp_date":"2026-01-28 00:00:00","insp_start_time":"0820","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-485","location_desc":"I-485","county_code_state":"NC","county_code":"119","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":"N","pen_cen_match":null,"final_status_date":"2026-01-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2373816","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2026-01-29 21:38:00","snet_input_date":"2026-01-29 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-01-29 21:38:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:57.000000Z","updated_at":"2026-02-10T10:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18295252,"change_date":"2026-01-29 21:38:00","inspection_id":"86914075","insp_unit_id":"211342593","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"VV5064","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP8LJ0X7SM714588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:44.000000Z","updated_at":"2026-02-09T10:01:49.000000Z"}]},{"id":10834158,"change_date":"2026-01-22 21:39:00","inspection_id":"86862382","dot_number":"2169156","report_state":"NC","report_number":"0006842023","insp_date":"2026-01-21 00:00:00","insp_start_time":"1353","insp_end_time":"1414","registration_date":null,"region":"ET","ci_status_code":"C","location":"US INT","location_desc":"US INTERSTATE","county_code_state":"NC","county_code":"119","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONST CLEAN UP","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2372460","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":"02169156","upload_search_indicator":"M","census_search_date":"2026-01-22 21:39:00","snet_input_date":"2026-01-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-01-22 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-25T10:36:59.000000Z","updated_at":"2026-02-02T10:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18201507,"change_date":"2026-01-22 21:39:00","inspection_id":"86862382","insp_unit_id":"211230373","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"31","insp_unit_license":"NH1398","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X5KM465279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:17.000000Z","updated_at":"2026-02-02T10:03:02.000000Z"}]},{"id":10470238,"change_date":"2025-12-18 21:41:00","inspection_id":"86603635","dot_number":"2169156","report_state":"NC","report_number":"0006830272","insp_date":"2025-12-17 00:00:00","insp_start_time":"1024","insp_end_time":"1041","registration_date":null,"region":"ET","ci_status_code":"C","location":"US HWY","location_desc":"US HWY","county_code_state":"NC","county_code":"071","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONST","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2361042","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-12-18 21:41:00","snet_input_date":"2025-12-18 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-12-18 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-21T10:31:53.000000Z","updated_at":"2025-12-29T10:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17526473,"change_date":"2025-12-18 21:41:00","inspection_id":"86603635","insp_unit_id":"210691435","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"54","insp_unit_license":"VV5064","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP8LJ0X7SM714588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:46.000000Z","updated_at":"2025-12-29T10:01:13.000000Z"}]},{"id":10420531,"change_date":"2025-12-12 21:41:00","inspection_id":"86551727","dot_number":"2169156","report_state":"NC","report_number":"0006828747","insp_date":"2025-12-12 00:00:00","insp_start_time":"0837","insp_end_time":"0846","registration_date":null,"region":"ET","ci_status_code":"C","location":"DAVIDS","location_desc":"DAVIDSON COUNTY, I-85 NORTHBOU","county_code_state":"NC","county_code":"057","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":"N","pen_cen_match":null,"final_status_date":"2025-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"2359251","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2025-12-12 21:41:00","snet_input_date":"2025-12-12 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-12-12 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-15T10:32:07.000000Z","updated_at":"2025-12-23T10:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17429831,"change_date":"2025-12-12 21:41:00","inspection_id":"86551727","insp_unit_id":"210577906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"NM5497","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX04C3JM041698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:44.000000Z","updated_at":"2025-12-23T10:00:58.000000Z"}]},{"id":10387844,"change_date":"2025-12-09 21:39:00","inspection_id":"86517487","dot_number":"2169156","report_state":"NC","report_number":"0006827131","insp_date":"2025-12-08 00:00:00","insp_start_time":"1010","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"CABARR","location_desc":"CABARRUS COUNTY, I-85, S","county_code_state":"NC","county_code":"025","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":"N","pen_cen_match":null,"final_status_date":"2025-12-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2358007","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-12-09 21:39:00","snet_input_date":"2025-12-09 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-12-09 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-12T10:31:38.000000Z","updated_at":"2025-12-13T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17366448,"change_date":"2025-12-09 21:39:00","inspection_id":"86517487","insp_unit_id":"210503187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"NE1277","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X2JM465254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:29.000000Z","updated_at":"2025-12-13T10:00:58.000000Z"}]},{"id":10261200,"change_date":"2025-11-21 21:38:00","inspection_id":"86384918","dot_number":"2169156","report_state":"NC","report_number":"0006821592","insp_date":"2025-11-21 00:00:00","insp_start_time":"0701","insp_end_time":"0723","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 421","location_desc":"US 421 NEAR MAIN STREET","county_code_state":"NC","county_code":"067","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":"N","pen_cen_match":null,"final_status_date":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2351977","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-21 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:44.000000Z","updated_at":"2025-11-25T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17106164,"change_date":"2025-11-21 21:38:00","inspection_id":"86384918","insp_unit_id":"210177589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"NV6622","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AV04C7JM018740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:57.000000Z","updated_at":"2025-11-25T10:00:49.000000Z"}]},{"id":9654000,"change_date":"2025-09-11 21:41:00","inspection_id":"85747797","dot_number":"2169156","report_state":"NC","report_number":"0006796854","insp_date":"2025-09-10 00:00:00","insp_start_time":"0955","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"FORSYT","location_desc":"FORSYTH COUNTY, US 52 N","county_code_state":"NC","county_code":"067","insp_level_id":"2","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":"2025-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2327741","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:58.000000Z","updated_at":"2025-09-16T10:46:57.000000Z","inspection_violations":[{"id":15811018,"change_date":"2025-09-11 21:41:00","inspection_id":"85747797","insp_violation_id":"268611455","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3311026","created_at":"2025-09-14T11:56:58.000000Z","updated_at":"2025-09-14T11:56:58.000000Z","normalized_code":"38323A2"},{"id":15811019,"change_date":"2025-09-11 21:41:00","inspection_id":"85747797","insp_violation_id":"268611456","seq_no":"2","part_no":"392","part_no_section":"9BA-INACTIVEINTRA","insp_viol_unit":"1","insp_unit_id":"208874562","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3311026","created_at":"2025-09-14T11:56:58.000000Z","updated_at":"2025-09-14T11:56:58.000000Z","normalized_code":"3929BAINACTIVEINTRA"}],"inspection_per_units":[{"id":15953221,"change_date":"2025-09-11 21:41:00","inspection_id":"85747797","insp_unit_id":"208874562","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"NH1398","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X5KM465279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:37.000000Z","updated_at":"2025-09-15T09:53:21.000000Z"}]},{"id":9413570,"change_date":"2025-08-14 21:40:00","inspection_id":"85493702","dot_number":"2169156","report_state":"NC","report_number":"0006785911","insp_date":"2025-08-13 00:00:00","insp_start_time":"0703","insp_end_time":"0737","registration_date":null,"region":"ET","ci_status_code":"C","location":"US INT","location_desc":"US INTERSTATE","county_code_state":"NC","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2318220","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:20.000000Z","updated_at":"2025-08-20T10:44:04.000000Z","inspection_violations":[{"id":15313118,"change_date":"2025-08-14 21:40:00","inspection_id":"85493702","insp_violation_id":"268030984","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVEINTRA","insp_viol_unit":"1","insp_unit_id":"208400031","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:22.000000Z","updated_at":"2025-08-18T10:44:07.000000Z","normalized_code":"3929BAINACTIVEINTRA"}],"inspection_per_units":[{"id":15516767,"change_date":"2025-08-14 21:40:00","inspection_id":"85493702","insp_unit_id":"208400031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"54","insp_unit_license":"VV5064","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP8LJ0X7SM714588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:27.000000Z","updated_at":"2025-08-18T09:45:56.000000Z"}]},{"id":9175983,"change_date":"2025-07-17 21:42:00","inspection_id":"85243862","dot_number":"2169156","report_state":"NC","report_number":"0006776780","insp_date":"2025-07-16 00:00:00","insp_start_time":"1045","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"TWIN O","location_desc":"TWIN OAKS DR","county_code_state":"NC","county_code":"097","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2307884","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-17 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:17.000000Z","updated_at":"2025-07-21T10:43:17.000000Z","inspection_violations":[{"id":14819257,"change_date":"2025-07-17 21:42:00","inspection_id":"85243862","insp_violation_id":"267471847","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"207927246","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3308210","created_at":"2025-07-21T10:45:42.000000Z","updated_at":"2025-07-21T10:45:42.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":15078770,"change_date":"2025-07-17 21:42:00","inspection_id":"85243862","insp_unit_id":"207927246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"NH1398","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X5KM465279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:30.000000Z","updated_at":"2025-07-21T09:45:57.000000Z"}]},{"id":8296674,"change_date":"2025-04-04 21:40:00","inspection_id":"84315990","dot_number":"2169156","report_state":"NC","report_number":"0006744875","insp_date":"2025-04-03 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"DAVIDS","location_desc":"DAVIDSON COUNTY, I-85, S","county_code_state":"NC","county_code":"057","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":"N","pen_cen_match":null,"final_status_date":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"2277156","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:07.000000Z","updated_at":"2025-04-08T10:09:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13451720,"change_date":"2025-04-04 21:40:00","inspection_id":"84315990","insp_unit_id":"206158726","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MX7625","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX32C7GM011021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:10:33.000000Z","updated_at":"2025-04-08T09:57:55.000000Z"}]},{"id":8273715,"change_date":"2025-04-02 21:41:00","inspection_id":"84291928","dot_number":"2169156","report_state":"SC","report_number":"0344002577","insp_date":"2025-04-02 00:00:00","insp_start_time":"1219","insp_end_time":"1238","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FORT MILL SC","county_code_state":"SC","county_code":"091","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1545084","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:39.000000Z","updated_at":"2025-04-06T10:23:39.000000Z","inspection_violations":[{"id":13003368,"change_date":"2025-04-02 21:41:00","inspection_id":"84291928","insp_violation_id":"265394592","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206114853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:03:56.000000Z","updated_at":"2025-04-05T10:38:32.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":13392716,"change_date":"2025-04-02 21:41:00","inspection_id":"84291928","insp_unit_id":"206114853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"2720","insp_unit_license":"NM5497","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX04C3JM041698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:08:36.000000Z","updated_at":"2025-04-06T09:56:04.000000Z"}]},{"id":8070924,"change_date":"2025-03-10 21:39:00","inspection_id":"84078484","dot_number":"2169156","report_state":"NC","report_number":"0006735329","insp_date":"2025-03-06 00:00:00","insp_start_time":"0740","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"I85","location_desc":"I85","county_code_state":"NC","county_code":"119","insp_level_id":"2","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":"2025-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2268715","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-03-10 21:39:00","snet_input_date":"2025-03-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-03-10 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:51.000000Z","updated_at":"2025-03-17T21:05:51.000000Z","inspection_violations":[{"id":12615126,"change_date":"2025-03-10 21:39:00","inspection_id":"84078484","insp_violation_id":"264923633","seq_no":"1","part_no":"393","part_no_section":"75A","insp_viol_unit":"1","insp_unit_id":"205711466","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3302541","created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"39375A"},{"id":12615127,"change_date":"2025-03-10 21:39:00","inspection_id":"84078484","insp_violation_id":"264923634","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205711466","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3302541","created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"3939TS"},{"id":12615128,"change_date":"2025-03-10 21:39:00","inspection_id":"84078484","insp_violation_id":"264923635","seq_no":"3","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"205711466","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3302541","created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":13031464,"change_date":"2025-03-10 21:39:00","inspection_id":"84078484","insp_unit_id":"205711466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"35","insp_unit_license":"NK3891","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X4LM633561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:01.000000Z","updated_at":"2025-03-17T23:59:01.000000Z"}]},{"id":7842395,"change_date":"2025-02-11 21:40:00","inspection_id":"83838543","dot_number":"2169156","report_state":"NC","report_number":"0006727037","insp_date":"2025-02-11 00:00:00","insp_start_time":"0915","insp_end_time":"0923","registration_date":null,"region":"ET","ci_status_code":"C","location":"FORSYT","location_desc":"FORSYTH CO., NC 74 @ US 421","county_code_state":"NC","county_code":"067","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2259148","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:09.000000Z","updated_at":"2025-03-17T21:01:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12656626,"change_date":"2025-02-11 21:40:00","inspection_id":"83838543","insp_unit_id":"205270095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"51","insp_unit_license":"NV6622","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AV04C7JM018740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:48.000000Z","updated_at":"2025-03-17T23:54:48.000000Z"}]},{"id":7742559,"change_date":"2025-01-30 21:40:00","inspection_id":"83733293","dot_number":"2169156","report_state":"SC","report_number":"0353002892","insp_date":"2025-01-29 00:00:00","insp_start_time":"0735","insp_end_time":"0817","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FORT MILL SC","county_code_state":"SC","county_code":"091","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1300503","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2025-01-30 21:40:00","snet_input_date":"2025-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-30 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":12097761,"change_date":"2025-01-30 21:40:00","inspection_id":"83733293","insp_violation_id":"264245672","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205071905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3939ALIL"},{"id":12097762,"change_date":"2025-01-30 21:40:00","inspection_id":"83733293","insp_violation_id":"264245673","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLTL"},{"id":12097763,"change_date":"2025-01-30 21:40:00","inspection_id":"83733293","insp_violation_id":"264245674","seq_no":"3","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"205071905","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA74525","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":12494531,"change_date":"2025-01-30 21:40:00","inspection_id":"83733293","insp_unit_id":"205071905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"27","insp_unit_license":"MX7625","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX32C7GM011021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7484721,"change_date":"2025-01-14 21:53:00","inspection_id":"83462788","dot_number":"2169156","report_state":"SC","report_number":"0270006497","insp_date":"2024-12-16 00:00:00","insp_start_time":"0725","insp_end_time":"0812","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FORT MILL SC","county_code_state":"SC","county_code":"091","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO'S CONSTRUCTION CLEAN UP INC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188884","transaction_code":"C","transaction_date":"2024-12-23 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:18.000000Z","updated_at":"2025-03-17T20:52:18.000000Z","inspection_violations":[{"id":11700644,"change_date":"2025-01-14 21:53:00","inspection_id":"83462788","insp_violation_id":"263926259","seq_no":"1","part_no":"393","part_no_section":"87A-FPLR","insp_viol_unit":"1","insp_unit_id":"204793731","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39387AFPLR"},{"id":11700645,"change_date":"2025-01-14 21:53:00","inspection_id":"83462788","insp_violation_id":"263926260","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204793731","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39395F"},{"id":11700646,"change_date":"2025-01-14 21:53:00","inspection_id":"83462788","insp_violation_id":"263926261","seq_no":"3","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA73455","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":12075040,"change_date":"2025-01-14 21:53:00","inspection_id":"83462788","insp_unit_id":"204793731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"34","insp_unit_license":"JV2497","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"J8BC4B14847001531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:21.000000Z","updated_at":"2025-03-17T23:48:21.000000Z"}]},{"id":6610305,"change_date":"2024-08-30 21:40:00","inspection_id":"82536222","dot_number":"2169156","report_state":"NC","report_number":"0006681073","insp_date":"2024-08-28 00:00:00","insp_start_time":"1945","insp_end_time":"2015","registration_date":null,"region":"ET","ci_status_code":"C","location":"GASTON","location_desc":"GASTON COUNTY WEIGH STATION I-","county_code_state":"NC","county_code":"071","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"29000","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":"2214105","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2024-08-30 21:40:00","snet_input_date":"2024-08-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:04.000000Z","updated_at":"2025-03-17T20:34:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10657362,"change_date":"2024-08-30 21:40:00","inspection_id":"82536222","insp_unit_id":"202682653","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:22.000000Z","updated_at":"2025-03-17T23:33:22.000000Z"}]},{"id":6273662,"change_date":"2024-07-22 21:41:00","inspection_id":"82176767","dot_number":"2169156","report_state":"NC","report_number":"0006668521","insp_date":"2024-07-22 00:00:00","insp_start_time":"0826","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"CITY S","location_desc":"CITY STREET","county_code_state":"NC","county_code":"119","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2202258","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2024-07-22 21:41:00","snet_input_date":"2024-07-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-07-22 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:02.000000Z","updated_at":"2025-03-17T20:27:02.000000Z","inspection_violations":[{"id":9744306,"change_date":"2024-07-22 21:41:00","inspection_id":"82176767","insp_violation_id":"260764640","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"3922"},{"id":9744307,"change_date":"2024-07-22 21:41:00","inspection_id":"82176767","insp_violation_id":"260764641","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201996825","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10108057,"change_date":"2024-07-22 21:41:00","inspection_id":"82176767","insp_unit_id":"201996825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"51","insp_unit_license":"NV6622","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AV04C7JM018740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:44.000000Z","updated_at":"2025-03-17T23:27:44.000000Z"}]},{"id":6273571,"change_date":"2024-07-22 21:41:00","inspection_id":"82176670","dot_number":"2169156","report_state":"NC","report_number":"0006663248","insp_date":"2024-07-17 00:00:00","insp_start_time":"0818","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"RIGHT","location_desc":"RIGHT SHOULDER","county_code_state":"NC","county_code":"119","insp_level_id":"2","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":"2024-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2202089","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2024-07-22 21:41:00","snet_input_date":"2024-07-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-07-22 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:02.000000Z","updated_at":"2025-03-17T20:27:02.000000Z","inspection_violations":[{"id":9744252,"change_date":"2024-07-22 21:41:00","inspection_id":"82176670","insp_violation_id":"260764567","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"201996673","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3137987","created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"393134"},{"id":9744253,"change_date":"2024-07-22 21:41:00","inspection_id":"82176670","insp_violation_id":"260764568","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"201996673","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3137987","created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"39375A3"},{"id":9744254,"change_date":"2024-07-22 21:41:00","inspection_id":"82176670","insp_violation_id":"260764569","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"201996673","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3137987","created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"39375A3"},{"id":9744255,"change_date":"2024-07-22 21:41:00","inspection_id":"82176670","insp_violation_id":"260764570","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201996673","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":10107917,"change_date":"2024-07-22 21:41:00","inspection_id":"82176670","insp_unit_id":"201996673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"27","insp_unit_license":"MX7625","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX32C7GM011021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:44.000000Z","updated_at":"2025-03-17T23:27:44.000000Z"}]},{"id":6229995,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","dot_number":"2169156","report_state":"SC","report_number":"S391000151","insp_date":"2024-07-16 00:00:00","insp_start_time":"0832","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"05972","location_desc":"SC 72 LAURENS COUNTY","county_code_state":"SC","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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-07-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1154738","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-07-16 21:43:00","snet_input_date":"2024-07-16 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-07-16 21:43:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:12.000000Z","updated_at":"2025-03-17T20:26:12.000000Z","inspection_violations":[{"id":9677899,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","insp_violation_id":"260668649","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"201908369","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"39021TB"},{"id":9677900,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","insp_violation_id":"260668650","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201908369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"3939A"},{"id":9677901,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","insp_violation_id":"260668651","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201908369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"3939A"},{"id":9677902,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","insp_violation_id":"260668652","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201908369","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"39395A"},{"id":9677903,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","insp_violation_id":"260668653","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201908369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":10037809,"change_date":"2024-07-16 21:43:00","inspection_id":"82129895","insp_unit_id":"201908369","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"32","insp_unit_license":"NE7157","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3BPZL00XX7F717366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:00.000000Z","updated_at":"2025-03-17T23:27:00.000000Z"}]},{"id":5919597,"change_date":"2024-06-05 21:42:00","inspection_id":"81795111","dot_number":"2169156","report_state":"SC","report_number":"S391000084","insp_date":"2024-06-05 00:00:00","insp_start_time":"1108","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"05972","location_desc":"SC 72 LAURENS COUNTY","county_code_state":"SC","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147594","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:53.000000Z","updated_at":"2025-03-17T20:19:53.000000Z","inspection_violations":[{"id":9179225,"change_date":"2024-06-05 21:42:00","inspection_id":"81795111","insp_violation_id":"259919600","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201247623","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9179226,"change_date":"2024-06-05 21:42:00","inspection_id":"81795111","insp_violation_id":"259919601","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201247623","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9179227,"change_date":"2024-06-05 21:42:00","inspection_id":"81795111","insp_violation_id":"259919602","seq_no":"3","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"201247623","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":9534472,"change_date":"2024-06-05 21:42:00","inspection_id":"81795111","insp_unit_id":"201247623","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:52.000000Z","updated_at":"2025-03-17T23:21:52.000000Z"}]},{"id":5511443,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","dot_number":"2169156","report_state":"SC","report_number":"A339002353","insp_date":"2024-04-12 00:00:00","insp_start_time":"1331","insp_end_time":"1441","registration_date":null,"region":"ET","ci_status_code":"C","location":"091161","location_desc":"SC 161 YORK COUNTY","county_code_state":"SC","county_code":"091","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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-04-15 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"26000","viol_total":"11","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1139250","transaction_code":"C","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-04-15 21:41:00","snet_input_date":"2024-04-12 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-04-15 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:57.000000Z","updated_at":"2025-03-17T20:11:57.000000Z","inspection_violations":[{"id":8514047,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304036","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA61230","created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"},{"id":8514048,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304037","seq_no":"2","part_no":"391","part_no_section":"41(a)","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:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39141A"},{"id":8514049,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304038","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA61231","created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39617C"},{"id":8514050,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304039","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39348A"},{"id":8514051,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304040","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39353B"},{"id":8514052,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304041","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39348A"},{"id":8514053,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304042","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3963A1"},{"id":8514054,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304043","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3939A"},{"id":8514055,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304044","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3939A"},{"id":8514056,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304045","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3939A"},{"id":8514057,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_violation_id":"259304046","seq_no":"11","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200716528","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":8877854,"change_date":"2024-05-03 21:38:00","inspection_id":"81351479","insp_unit_id":"200716528","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"JN9147","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVACWDC67HX75891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:35.000000Z","updated_at":"2025-03-17T23:15:35.000000Z"}]},{"id":5266380,"change_date":"2024-03-12 21:38:00","inspection_id":"81083955","dot_number":"2169156","report_state":"NC","report_number":"0006630792","insp_date":"2024-03-12 00:00:00","insp_start_time":"0701","insp_end_time":"0724","registration_date":null,"region":"ET","ci_status_code":"C","location":"US INT","location_desc":"US INTERSTATE","county_code_state":"NC","county_code":"119","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONST CLEAN UP","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2164212","transaction_code":"A","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2024-03-12 21:38:00","snet_input_date":"2024-03-12 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-03-12 21:38:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:04.000000Z","updated_at":"2025-03-17T20:07:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8480400,"change_date":"2024-03-12 21:38:00","inspection_id":"81083955","insp_unit_id":"199869625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"}]},{"id":5152904,"change_date":"2024-02-28 21:41:00","inspection_id":"80960440","dot_number":"2169156","report_state":"NC","report_number":"0006626302","insp_date":"2024-02-28 00:00:00","insp_start_time":"0625","insp_end_time":"0645","registration_date":null,"region":"ET","ci_status_code":"C","location":"I77","location_desc":"I77","county_code_state":"NC","county_code":"119","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":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"2159470","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2024-02-28 21:41:00","snet_input_date":"2024-02-28 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-02-28 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:34.000000Z","updated_at":"2025-03-17T20:04:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8296841,"change_date":"2024-02-28 21:41:00","inspection_id":"80960440","insp_unit_id":"199638412","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:12.000000Z","updated_at":"2025-03-17T23:10:12.000000Z"}]},{"id":4876071,"change_date":"2024-01-22 21:43:00","inspection_id":"80657730","dot_number":"2169156","report_state":"SC","report_number":"T197017150","insp_date":"2024-01-22 00:00:00","insp_start_time":"1117","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"065221","location_desc":"US 221 MCCORMICK COUNTY","county_code_state":"SC","county_code":"065","insp_level_id":"2","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":"2024-01-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125673","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-01-22 21:43:00","snet_input_date":"2024-01-22 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-01-22 21:43:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:16.000000Z","updated_at":"2025-03-17T19:59:16.000000Z","inspection_violations":[{"id":7513090,"change_date":"2024-01-22 21:43:00","inspection_id":"80657730","insp_violation_id":"257434047","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199052210","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39021TB"},{"id":7513091,"change_date":"2024-01-22 21:43:00","inspection_id":"80657730","insp_violation_id":"257434048","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199052210","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3939A"},{"id":7513092,"change_date":"2024-01-22 21:43:00","inspection_id":"80657730","insp_violation_id":"257434049","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199052210","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39311"},{"id":7513093,"change_date":"2024-01-22 21:43:00","inspection_id":"80657730","insp_violation_id":"257434050","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199052210","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7845386,"change_date":"2024-01-22 21:43:00","inspection_id":"80657730","insp_unit_id":"199052210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"232","insp_unit_license":"NE7157","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3BPZL00XX7F717366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:08.000000Z","updated_at":"2025-03-17T23:06:08.000000Z"}]},{"id":4802454,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","dot_number":"2169156","report_state":"SC","report_number":"A339002186","insp_date":"2024-01-10 00:00:00","insp_start_time":"0759","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"106","location_desc":"I-77 SB ROADSIDE","county_code_state":"SC","county_code":"091","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14001","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1124084","transaction_code":"A","transaction_date":"2024-01-10 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-10 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:59.000000Z","updated_at":"2025-03-17T19:57:59.000000Z","inspection_violations":[{"id":7408102,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_violation_id":"257273264","seq_no":"1","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:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3922"},{"id":7408103,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_violation_id":"257273265","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198897434","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA54084","created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39617C"},{"id":7408104,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_violation_id":"257273266","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198897434","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39395A"},{"id":7408105,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_violation_id":"257273267","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198897434","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39395F"},{"id":7408106,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_violation_id":"257273268","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198897434","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3939A"},{"id":7408107,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_violation_id":"257273269","seq_no":"6","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198897434","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":7726682,"change_date":"2024-01-10 21:44:00","inspection_id":"80577187","insp_unit_id":"198897434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"JV2497","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"J8BC4B14847001531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4755913,"change_date":"2024-01-03 21:44:00","inspection_id":"80526244","dot_number":"2169156","report_state":"SC","report_number":"B376000539","insp_date":"2024-01-03 00:00:00","insp_start_time":"1411","insp_end_time":"1436","registration_date":null,"region":"ET","ci_status_code":"C","location":"047225","location_desc":"SC 225 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADO'S CONSTRUCTION CLEAN UP INC","shipping_paper_number":"9","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-01-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1123144","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2024-01-03 21:44:00","snet_input_date":"2024-01-03 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:55.000000Z","updated_at":"2025-03-17T19:56:55.000000Z","inspection_violations":[{"id":7338731,"change_date":"2024-01-03 21:44:00","inspection_id":"80526244","insp_violation_id":"257165181","seq_no":"1","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"198794066","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA52868","created_at":"2025-03-17T21:41:24.000000Z","updated_at":"2025-03-17T21:41:24.000000Z","normalized_code":"393134B3"}],"inspection_per_units":[{"id":7650897,"change_date":"2024-01-03 21:44:00","inspection_id":"80526244","insp_unit_id":"198794066","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"ND6099","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2P267C8XM042166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":4733750,"change_date":"2023-12-29 21:40:00","inspection_id":"80502135","dot_number":"2169156","report_state":"SC","report_number":"B376000527","insp_date":"2023-12-29 00:00:00","insp_start_time":"0707","insp_end_time":"0721","registration_date":null,"region":"ET","ci_status_code":"C","location":"047221","location_desc":"US 221 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","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":"2023-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1122544","transaction_code":"A","transaction_date":"2023-12-29 00:00:00","upload_date":"2023-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-29 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:34.000000Z","updated_at":"2025-03-17T19:56:34.000000Z","inspection_violations":[{"id":7309033,"change_date":"2023-12-29 21:40:00","inspection_id":"80502135","insp_violation_id":"257118095","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7614367,"change_date":"2023-12-29 21:40:00","inspection_id":"80502135","insp_unit_id":"198740114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:03.000000Z","updated_at":"2025-03-17T23:04:03.000000Z"}]},{"id":4549274,"change_date":"2023-12-04 21:41:00","inspection_id":"80300154","dot_number":"2169156","report_state":"SC","report_number":"H270005835","insp_date":"2023-12-01 00:00:00","insp_start_time":"1515","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":"016","location_desc":"I-77 SB YORK COUNTY","county_code_state":"SC","county_code":"091","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1119161","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-12-04 21:41:00","snet_input_date":"2023-12-01 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-12-04 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:59.000000Z","updated_at":"2025-03-17T19:52:59.000000Z","inspection_violations":[{"id":7037555,"change_date":"2023-12-04 21:41:00","inspection_id":"80300154","insp_violation_id":"256692042","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198330788","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"39378"},{"id":7037556,"change_date":"2023-12-04 21:41:00","inspection_id":"80300154","insp_violation_id":"256692043","seq_no":"2","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"198330788","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA52470","created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":7316705,"change_date":"2023-12-04 21:41:00","inspection_id":"80300154","insp_unit_id":"198330788","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:28.000000Z","updated_at":"2025-03-17T23:01:28.000000Z"}]},{"id":4406532,"change_date":"2023-11-13 21:41:00","inspection_id":"80143082","dot_number":"2169156","report_state":"SC","report_number":"B353001908","insp_date":"2023-11-10 00:00:00","insp_start_time":"0948","insp_end_time":"1033","registration_date":null,"region":"ET","ci_status_code":"C","location":"91121","location_desc":"YORK CNTY SECONDARY ROADS","county_code_state":"SC","county_code":"091","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1115912","transaction_code":"A","transaction_date":"2023-11-10 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-11-13 21:41:00","snet_input_date":"2023-11-10 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-11-13 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:17.000000Z","updated_at":"2025-03-17T19:50:17.000000Z","inspection_violations":[{"id":6819730,"change_date":"2023-11-13 21:41:00","inspection_id":"80143082","insp_violation_id":"256348964","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3922"},{"id":6819731,"change_date":"2023-11-13 21:41:00","inspection_id":"80143082","insp_violation_id":"256348965","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:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39141A1"},{"id":6819732,"change_date":"2023-11-13 21:41:00","inspection_id":"80143082","insp_violation_id":"256348966","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":"WA51748","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7086427,"change_date":"2023-11-13 21:41:00","inspection_id":"80143082","insp_unit_id":"198018991","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RH1191","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2MDBAA6PS006985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:30.000000Z","updated_at":"2025-03-17T22:59:30.000000Z"}]},{"id":4033446,"change_date":"2023-09-22 21:39:00","inspection_id":"79729912","dot_number":"2169156","report_state":"SC","report_number":"B353001748","insp_date":"2023-09-22 00:00:00","insp_start_time":"1138","insp_end_time":"1217","registration_date":null,"region":"ET","ci_status_code":"C","location":"016","location_desc":"I-77 SB YORK COUNTY","county_code_state":"SC","county_code":"091","insp_level_id":"2","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-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1107228","transaction_code":"A","transaction_date":"2023-09-22 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-09-22 21:39:00","snet_input_date":"2023-09-22 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[{"id":6243520,"change_date":"2023-09-22 21:39:00","inspection_id":"79729912","insp_violation_id":"255425471","seq_no":"1","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3903E"},{"id":6243521,"change_date":"2023-09-22 21:39:00","inspection_id":"79729912","insp_violation_id":"255425472","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197187064","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3939A"},{"id":6243522,"change_date":"2023-09-22 21:39:00","inspection_id":"79729912","insp_violation_id":"255425473","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197187064","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39395F"},{"id":6243523,"change_date":"2023-09-22 21:39:00","inspection_id":"79729912","insp_violation_id":"255425474","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197187064","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6484737,"change_date":"2023-09-22 21:39:00","inspection_id":"79729912","insp_unit_id":"197187064","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"46","insp_unit_license":"NS1653","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2TE2GC6KM001297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:24.000000Z","updated_at":"2025-03-17T22:54:24.000000Z"}]},{"id":3888010,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","dot_number":"2169156","report_state":"SC","report_number":"F368000715","insp_date":"2023-08-31 00:00:00","insp_start_time":"1708","insp_end_time":"1738","registration_date":"2023-10-05 00:00:00","region":"ET","ci_status_code":"C","location":"05972","location_desc":"SC 72 LAURENS COUNTY","county_code_state":"SC","county_code":"059","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103343","transaction_code":"C","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-08-31 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[{"id":6008427,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","insp_violation_id":"255701554","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3922"},{"id":6008428,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","insp_violation_id":"255701555","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"197437604","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39345D"},{"id":6008429,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","insp_violation_id":"255701556","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197437604","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3963A1"},{"id":6008430,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","insp_violation_id":"255701557","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197437604","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39395A"},{"id":6008431,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","insp_violation_id":"255701558","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197437604","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":6250826,"change_date":"2023-10-06 21:40:00","inspection_id":"79568303","insp_unit_id":"197437604","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:31.000000Z","updated_at":"2025-03-17T22:52:31.000000Z"}]},{"id":3722454,"change_date":"2023-08-11 21:38:00","inspection_id":"79383444","dot_number":"2169156","report_state":"SC","report_number":"L347001491","insp_date":"2023-08-11 00:00:00","insp_start_time":"0724","insp_end_time":"0744","registration_date":null,"region":"ET","ci_status_code":"C","location":"05972","location_desc":"SC 72 LAURENS COUNTY","county_code_state":"SC","county_code":"059","insp_level_id":"2","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-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1100243","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-08-11 21:38:00","snet_input_date":"2023-08-11 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-08-11 21:38:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5739898,"change_date":"2023-08-11 21:38:00","inspection_id":"79383444","insp_violation_id":"254602257","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196486317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:33.000000Z","updated_at":"2025-03-17T21:33:33.000000Z","normalized_code":"3939A"},{"id":5739899,"change_date":"2023-08-11 21:38:00","inspection_id":"79383444","insp_violation_id":"254602258","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196486317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:33.000000Z","updated_at":"2025-03-17T21:33:33.000000Z","normalized_code":"3939A"},{"id":5739900,"change_date":"2023-08-11 21:38:00","inspection_id":"79383444","insp_violation_id":"254602259","seq_no":"3","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"196486317","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:33.000000Z","updated_at":"2025-03-17T21:33:33.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":5985278,"change_date":"2023-08-11 21:38:00","inspection_id":"79383444","insp_unit_id":"196486317","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"ND6099","insp_unit_license_state":"SC","insp_unit_vehicle_id_number":"1M2P267C8XM042166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3685399,"change_date":"2023-08-07 21:42:00","inspection_id":"79342243","dot_number":"2169156","report_state":"SC","report_number":"L347001474","insp_date":"2023-08-07 00:00:00","insp_start_time":"1003","insp_end_time":"1021","registration_date":null,"region":"ET","ci_status_code":"C","location":"04772","location_desc":"SC 72 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","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-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099223","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-08-07 21:42:00","snet_input_date":"2023-08-07 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[{"id":5682364,"change_date":"2023-08-07 21:42:00","inspection_id":"79342243","insp_violation_id":"254507167","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196399990","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3939A"},{"id":5682365,"change_date":"2023-08-07 21:42:00","inspection_id":"79342243","insp_violation_id":"254507168","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196399990","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3939A"},{"id":5682366,"change_date":"2023-08-07 21:42:00","inspection_id":"79342243","insp_violation_id":"254507169","seq_no":"3","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"196399990","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":5925226,"change_date":"2023-08-07 21:42:00","inspection_id":"79342243","insp_unit_id":"196399990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"MR6078","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2P267C0XM047328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"}]},{"id":3662071,"change_date":"2023-08-03 21:40:00","inspection_id":"79316064","dot_number":"2169156","report_state":"NC","report_number":"0006562991","insp_date":"2023-08-03 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"HARRIS","location_desc":"HARRIS BLVD AT 77","county_code_state":"NC","county_code":"119","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":"N","pen_cen_match":null,"final_status_date":"2023-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2096654","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-08-03 21:40:00","snet_input_date":"2023-08-03 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-08-03 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:15.000000Z","updated_at":"2025-03-17T19:35:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5887819,"change_date":"2023-08-03 21:40:00","inspection_id":"79316064","insp_unit_id":"196345013","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"NK3891","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X4LM633561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:30.000000Z","updated_at":"2025-03-17T22:49:30.000000Z"}]},{"id":3630377,"change_date":"2023-07-31 21:41:00","inspection_id":"79280343","dot_number":"2169156","report_state":"NC","report_number":"0006560862","insp_date":"2023-07-28 00:00:00","insp_start_time":"0741","insp_end_time":"0752","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-73","location_desc":"I-73","county_code_state":"NC","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":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"2094332","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-07-31 21:41:00","snet_input_date":"2023-07-31 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-07-31 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","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":5836752,"change_date":"2023-07-31 21:41:00","inspection_id":"79280343","insp_unit_id":"196274400","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"27","insp_unit_license":"MX7625","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX32C7GM011021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:05.000000Z","updated_at":"2025-03-17T22:49:05.000000Z"}]},{"id":3576841,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","dot_number":"2169156","report_state":"SC","report_number":"B087004518","insp_date":"2023-07-21 00:00:00","insp_start_time":"0920","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"045146","location_desc":"SC 146 GREENVILLE COUNTY","county_code_state":"SC","county_code":"045","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-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"12","oos_total":"9","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"9","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1095809","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-21 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:35.000000Z","updated_at":"2025-03-17T19:33:35.000000Z","inspection_violations":[{"id":5514758,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232783","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39347E"},{"id":5514759,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232784","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39353B"},{"id":5514760,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232785","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3939A"},{"id":5514761,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232786","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39311"},{"id":5514762,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232787","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39311"},{"id":5514763,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232788","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39311"},{"id":5514764,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232789","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3939A"},{"id":5514765,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232790","seq_no":"9","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA44499","created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39375A"},{"id":5514766,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232791","seq_no":"10","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39375A"},{"id":5514767,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232792","seq_no":"11","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"393209D"},{"id":5514768,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232793","seq_no":"12","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"393134B3"},{"id":5514769,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_violation_id":"254232794","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196153942","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":5750947,"change_date":"2023-07-24 21:42:00","inspection_id":"79220366","insp_unit_id":"196153942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"}]},{"id":3499631,"change_date":"2023-07-13 21:42:00","inspection_id":"79133791","dot_number":"2169156","report_state":"SC","report_number":"O261003893","insp_date":"2023-07-13 00:00:00","insp_start_time":"1321","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"04772","location_desc":"SC 72 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","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":"N","pen_cen_match":null,"final_status_date":"2023-07-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1094315","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-07-13 21:42:00","snet_input_date":"2023-07-13 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-07-13 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:08.000000Z","updated_at":"2025-03-17T19:32:08.000000Z","inspection_violations":[{"id":5395618,"change_date":"2023-07-13 21:42:00","inspection_id":"79133791","insp_violation_id":"254037939","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"},{"id":5395619,"change_date":"2023-07-13 21:42:00","inspection_id":"79133791","insp_violation_id":"254037940","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195979407","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5627155,"change_date":"2023-07-13 21:42:00","inspection_id":"79133791","insp_unit_id":"195979407","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"MR6078","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2P267C0XM047328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:25.000000Z","updated_at":"2025-03-17T22:47:25.000000Z"}]},{"id":3430387,"change_date":"2023-07-05 21:41:00","inspection_id":"79055634","dot_number":"2169156","report_state":"NC","report_number":"0006552252","insp_date":"2023-07-01 00:00:00","insp_start_time":"1042","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"CITY S","location_desc":"CITY STREET","county_code_state":"NC","county_code":"119","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2086494","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-07-05 21:41:00","snet_input_date":"2023-07-05 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-07-05 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:57.000000Z","updated_at":"2025-03-17T19:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5515305,"change_date":"2023-07-05 21:41:00","inspection_id":"79055634","insp_unit_id":"195819971","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"N\/A","insp_unit_license":"NH1398","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X5KM465279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:33.000000Z","updated_at":"2025-03-17T22:46:33.000000Z"}]},{"id":3201205,"change_date":"2023-06-02 21:41:00","inspection_id":"78797692","dot_number":"2169156","report_state":"SC","report_number":"R367000592","insp_date":"2023-06-02 00:00:00","insp_start_time":"1222","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":"108","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":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1086758","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-06-02 21:41:00","snet_input_date":"2023-06-02 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-06-02 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:26.000000Z","updated_at":"2025-03-17T19:26:26.000000Z","inspection_violations":[{"id":4931334,"change_date":"2023-06-02 21:41:00","inspection_id":"78797692","insp_violation_id":"253236369","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"195278872","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":5148725,"change_date":"2023-06-02 21:41:00","inspection_id":"78797692","insp_unit_id":"195278872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:33.000000Z","updated_at":"2025-03-17T22:43:33.000000Z"}]},{"id":3065731,"change_date":"2023-05-17 21:43:00","inspection_id":"78644749","dot_number":"2169156","report_state":"NC","report_number":"0006535552","insp_date":"2023-05-16 00:00:00","insp_start_time":"1358","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"1113","location_desc":"1113","county_code_state":"NC","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONSTRUCTION CLE","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-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"2069404","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:45.000000Z","updated_at":"2025-03-17T19:23:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4931750,"change_date":"2023-05-17 21:43:00","inspection_id":"78644749","insp_unit_id":"194977968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:53.000000Z","updated_at":"2025-03-17T22:41:53.000000Z"}]},{"id":3022453,"change_date":"2023-07-07 21:41:00","inspection_id":"78596063","dot_number":"2169156","report_state":"SC","report_number":"C361000714","insp_date":"2023-05-11 00:00:00","insp_start_time":"1019","insp_end_time":"1046","registration_date":"2023-07-07 00:00:00","region":"ET","ci_status_code":"C","location":"04734","location_desc":"SC 34 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1083404","transaction_code":"C","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-11 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[{"id":4641961,"change_date":"2023-07-07 21:41:00","inspection_id":"78596063","insp_violation_id":"253927803","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"195880554","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"39375A"},{"id":4641962,"change_date":"2023-07-07 21:41:00","inspection_id":"78596063","insp_violation_id":"253927804","seq_no":"2","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"195880554","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"393134B3"}],"inspection_per_units":[{"id":4862419,"change_date":"2023-07-07 21:41:00","inspection_id":"78596063","insp_unit_id":"195880554","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":2622854,"change_date":"2023-03-21 21:41:00","inspection_id":"78142584","dot_number":"2169156","report_state":"NC","report_number":"0006515946","insp_date":"2023-03-20 00:00:00","insp_start_time":"1425","insp_end_time":"1537","registration_date":null,"region":"ET","ci_status_code":"C","location":"1113","location_desc":"1113","county_code_state":"NC","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONSTRUCTION CLE","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-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2049637","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-03-21 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:09.000000Z","updated_at":"2025-03-17T19:15:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4221919,"change_date":"2023-03-21 21:41:00","inspection_id":"78142584","insp_unit_id":"193976162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"ND6099","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2P267C8XM042166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:17.000000Z","updated_at":"2025-03-17T22:36:17.000000Z"}]},{"id":2575747,"change_date":"2023-03-14 21:41:00","inspection_id":"78089097","dot_number":"2169156","report_state":"NC","report_number":"0006513661","insp_date":"2023-03-14 00:00:00","insp_start_time":"0832","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"1113","location_desc":"1113","county_code_state":"NC","county_code":"081","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONSTRUCTION CLE","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-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"2047448","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-03-14 21:41:00","snet_input_date":"2023-03-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-03-14 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:07.000000Z","updated_at":"2025-03-17T19:14:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4145421,"change_date":"2023-03-14 21:41:00","inspection_id":"78089097","insp_unit_id":"193863719","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"}]},{"id":2422283,"change_date":"2023-02-22 21:40:00","inspection_id":"77914608","dot_number":"2169156","report_state":"NC","report_number":"0006507358","insp_date":"2023-02-22 00:00:00","insp_start_time":"1220","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"DAVIDS","location_desc":"DAVIDSON COUNTY I-85 N","county_code_state":"NC","county_code":"057","insp_level_id":"2","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-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"2040637","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:24.000000Z","updated_at":"2025-03-17T19:11:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3898524,"change_date":"2023-02-22 21:40:00","inspection_id":"77914608","insp_unit_id":"193517016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:55.000000Z","updated_at":"2025-03-17T22:33:55.000000Z"}]},{"id":2265481,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","dot_number":"2169156","report_state":"SC","report_number":"H270004923","insp_date":"2023-01-31 00:00:00","insp_start_time":"1023","insp_end_time":"1118","registration_date":"2023-03-20 00:00:00","region":"ET","ci_status_code":"C","location":"017","location_desc":"I-77 NB YORK COUNTY","county_code_state":"SC","county_code":"091","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MERCADOS CONSTRUCTION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1067221","transaction_code":"C","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-31 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:28.000000Z","updated_at":"2025-03-17T19:08:28.000000Z","inspection_violations":[{"id":3495668,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","insp_violation_id":"251777791","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193977909","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39378"},{"id":3495669,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","insp_violation_id":"251777792","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193977909","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39375A3"},{"id":3495670,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","insp_violation_id":"251777793","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193977909","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39395A"},{"id":3495671,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","insp_violation_id":"251777794","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193977909","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA37410","created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39375A3"},{"id":3495672,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","insp_violation_id":"251777795","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193977909","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3646607,"change_date":"2023-03-21 21:41:00","inspection_id":"77735625","insp_unit_id":"193977909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"348-110","insp_unit_license":"NH1398","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP3LJ0X5KM465279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"}]},{"id":1889394,"change_date":"2022-12-07 21:40:00","inspection_id":"77305549","dot_number":"2169156","report_state":"SC","report_number":"H294004363","insp_date":"2022-12-07 00:00:00","insp_start_time":"0955","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"04525","location_desc":"US 25 GREENVILLE COUNTY","county_code_state":"SC","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1060951","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-12-07 21:40:00","snet_input_date":"2022-12-07 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-12-07 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:29.000000Z","updated_at":"2025-03-17T19:01:29.000000Z","inspection_violations":[{"id":2939101,"change_date":"2022-12-07 21:40:00","inspection_id":"77305549","insp_violation_id":"249964634","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"20222421009342","created_at":"2025-03-17T21:20:58.000000Z","updated_at":"2025-03-17T21:20:58.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3040643,"change_date":"2022-12-07 21:40:00","inspection_id":"77305549","insp_unit_id":"192301298","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"42","insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:50.000000Z","updated_at":"2025-03-17T22:27:50.000000Z"}]},{"id":1495364,"change_date":"2022-10-12 21:41:00","inspection_id":"76853367","dot_number":"2169156","report_state":"NC","report_number":"0006464926","insp_date":"2022-10-12 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"CHARLO","location_desc":"CHARLOTTE WEIGH STATION I-85 S","county_code_state":"NC","county_code":"119","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1998548","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-10-12 21:41:00","snet_input_date":"2022-10-12 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:10.000000Z","updated_at":"2025-03-17T18:54:10.000000Z","inspection_violations":[{"id":2353382,"change_date":"2022-10-12 21:41:00","inspection_id":"76853367","insp_violation_id":"248976505","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191395583","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"3939A"},{"id":2353383,"change_date":"2022-10-12 21:41:00","inspection_id":"76853367","insp_violation_id":"248976506","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191395583","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2406408,"change_date":"2022-10-12 21:41:00","inspection_id":"76853367","insp_unit_id":"191395583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"27","insp_unit_license":"MX7625","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX32C7GM011021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:29.000000Z","updated_at":"2025-03-17T22:23:29.000000Z"}]},{"id":1457551,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","dot_number":"2169156","report_state":"SC","report_number":"A253006731","insp_date":"2022-10-06 00:00:00","insp_start_time":"0832","insp_end_time":"0854","registration_date":"2022-10-26 00:00:00","region":"ET","ci_status_code":"C","location":"04772","location_desc":"SC 72 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","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":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"7","oos_total":"6","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"6","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1053239","transaction_code":"C","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-06 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:28.000000Z","updated_at":"2025-03-17T18:53:28.000000Z","inspection_violations":[{"id":2295009,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712536","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39617C"},{"id":2295010,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712537","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375A3"},{"id":2295011,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712538","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375A3"},{"id":2295012,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712539","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375A3"},{"id":2295013,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712540","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375A3"},{"id":2295014,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712541","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375A3"},{"id":2295015,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_violation_id":"249712542","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192058746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2346238,"change_date":"2022-11-21 21:41:00","inspection_id":"76809431","insp_unit_id":"192058746","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":1214400,"change_date":"2022-09-06 21:42:00","inspection_id":"76527377","dot_number":"2169156","report_state":"NC","report_number":"0006454597","insp_date":"2022-09-06 00:00:00","insp_start_time":"1045","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"CAMPBE","location_desc":"CAMPBELL RD NEAR WOODLEAF RD","county_code_state":"NC","county_code":"159","insp_level_id":"2","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":"2022-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1988178","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-09-06 21:42:00","snet_input_date":"2022-09-06 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:00.000000Z","updated_at":"2025-03-17T18:49:00.000000Z","inspection_violations":[{"id":1924042,"change_date":"2022-09-06 21:42:00","inspection_id":"76527377","insp_violation_id":"248219586","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"190729304","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3138783","created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":1953364,"change_date":"2022-09-06 21:42:00","inspection_id":"76527377","insp_unit_id":"190729304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"NV6622","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AV04C7JM018740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:25.000000Z","updated_at":"2025-03-17T22:20:25.000000Z"}]},{"id":982546,"change_date":"2022-08-30 21:40:00","inspection_id":"76257281","dot_number":"2169156","report_state":"SC","report_number":"O261003506","insp_date":"2022-08-08 00:00:00","insp_start_time":"0901","insp_end_time":"0925","registration_date":"2022-08-30 00:00:00","region":"ET","ci_status_code":"C","location":"047246","location_desc":"SC 246 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","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":"2022-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1044834","transaction_code":"C","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-08-08 21:39:00","snet_input_date":"2022-08-08 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-08-08 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:03.000000Z","updated_at":"2025-03-17T18:45:03.000000Z","inspection_violations":[{"id":1547857,"change_date":"2022-08-30 21:40:00","inspection_id":"76257281","insp_violation_id":"248091949","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190620057","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39360D"},{"id":1547858,"change_date":"2022-08-30 21:40:00","inspection_id":"76257281","insp_violation_id":"248091950","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190620057","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39395A"},{"id":1547859,"change_date":"2022-08-30 21:40:00","inspection_id":"76257281","insp_violation_id":"248091951","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190620057","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1581196,"change_date":"2022-08-30 21:40:00","inspection_id":"76257281","insp_unit_id":"190620057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:58.000000Z","updated_at":"2025-03-17T22:17:58.000000Z"}]},{"id":932872,"change_date":"2022-08-01 21:39:00","inspection_id":"76199264","dot_number":"2169156","report_state":"SC","report_number":"C361000142","insp_date":"2022-07-29 00:00:00","insp_start_time":"1458","insp_end_time":"1527","registration_date":null,"region":"ET","ci_status_code":"C","location":"047246","location_desc":"SC 246 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MERCADOS CONSTRUCTION CLEAN UP","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":"N","pen_cen_match":null,"final_status_date":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1043348","transaction_code":"A","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-07-29 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1472137,"change_date":"2022-08-01 21:39:00","inspection_id":"76199264","insp_violation_id":"247428647","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"190060699","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":1501419,"change_date":"2022-08-01 21:39:00","inspection_id":"76199264","insp_unit_id":"190060699","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"MW7318","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX33C9FM010496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]},{"id":817127,"change_date":"2022-07-14 21:41:00","inspection_id":"76063555","dot_number":"2169156","report_state":"NC","report_number":"0006437661","insp_date":"2022-07-14 00:00:00","insp_start_time":"1225","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 77","location_desc":"I 77","county_code_state":"NC","county_code":"119","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":"N","pen_cen_match":null,"final_status_date":"2022-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1970981","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-07-14 21:41:00","snet_input_date":"2022-07-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-07-14 21:41:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:00.000000Z","updated_at":"2025-03-17T18:42:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1314408,"change_date":"2022-07-14 21:41:00","inspection_id":"76063555","insp_unit_id":"189775060","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"50","insp_unit_license":"NV2860","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"2NP8LJ0X1NM822337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:16.000000Z","updated_at":"2025-03-17T22:16:16.000000Z"}]},{"id":738267,"change_date":"2022-07-01 21:38:00","inspection_id":"75971490","dot_number":"2169156","report_state":"NC","report_number":"0006433443","insp_date":"2022-07-01 00:00:00","insp_start_time":"1230","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"421","location_desc":"421","county_code_state":"NC","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":"N","pen_cen_match":null,"final_status_date":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1966840","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:35.000000Z","updated_at":"2025-03-17T18:40:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1186215,"change_date":"2022-07-01 21:38:00","inspection_id":"75971490","insp_unit_id":"189572780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"20","insp_unit_license":"MP2992","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2P267C9YM050486","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:28.000000Z","updated_at":"2025-03-17T22:15:28.000000Z"}]},{"id":679210,"change_date":"2022-06-23 21:40:00","inspection_id":"75901852","dot_number":"2169156","report_state":"NC","report_number":"0006430810","insp_date":"2022-06-23 00:00:00","insp_start_time":"0855","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROWAN","location_desc":"ROWAN COUNTY I-85 NB","county_code_state":"NC","county_code":"159","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":"N","pen_cen_match":null,"final_status_date":"2022-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1964549","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-06-23 21:40:00","snet_input_date":"2022-06-23 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:34.000000Z","updated_at":"2025-03-17T18:39:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1091226,"change_date":"2022-06-23 21:40:00","inspection_id":"75901852","insp_unit_id":"189424969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"NM5497","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AX04C3JM041698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:55.000000Z","updated_at":"2025-03-17T22:14:55.000000Z"}]},{"id":549562,"change_date":"2022-06-06 21:40:00","inspection_id":"75748102","dot_number":"2169156","report_state":"SC","report_number":"D149005455","insp_date":"2022-06-02 00:00:00","insp_start_time":"1112","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"04725","location_desc":"US 25 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"TRK53","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1035307","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-06-06 21:40:00","snet_input_date":"2022-06-02 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-06-06 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILLE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:26.000000Z","updated_at":"2025-03-17T18:37:26.000000Z","inspection_violations":[{"id":864787,"change_date":"2022-06-06 21:40:00","inspection_id":"75748102","insp_violation_id":"246261681","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"189079293","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":884010,"change_date":"2022-06-06 21:40:00","inspection_id":"75748102","insp_unit_id":"189079293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"NK8144","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2K189C97M036804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:38.000000Z","updated_at":"2025-03-17T22:13:38.000000Z"}]},{"id":233614,"change_date":"2022-04-22 21:43:00","inspection_id":"75371561","dot_number":"2169156","report_state":"NC","report_number":"0006412783","insp_date":"2022-04-22 00:00:00","insp_start_time":"0853","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 421","location_desc":"US 421 NB @ MM 159","county_code_state":"NC","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":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1946381","transaction_code":"A","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-04-22 21:43:00","snet_input_date":"2022-04-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-04-22 21:43:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:35.000000Z","updated_at":"2025-03-17T18:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":378585,"change_date":"2022-04-22 21:43:00","inspection_id":"75371561","insp_unit_id":"188292708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"NM5496","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2AG11CX7M056945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:32.000000Z","updated_at":"2025-03-17T22:10:32.000000Z"}]},{"id":70717,"change_date":"2022-03-30 21:40:00","inspection_id":"75174644","dot_number":"2169156","report_state":"SC","report_number":"T197014780","insp_date":"2022-03-30 00:00:00","insp_start_time":"1127","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"047221","location_desc":"US 221 GREENWOOD COUNTY","county_code_state":"SC","county_code":"047","insp_level_id":"2","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":"2022-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1027423","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-03-30 21:40:00","snet_input_date":"2022-03-30 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-03-30 21:40:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILEE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:48.000000Z","updated_at":"2025-03-17T18:28:48.000000Z","inspection_violations":[{"id":103446,"change_date":"2022-03-30 21:40:00","inspection_id":"75174644","insp_violation_id":"244859043","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"187894376","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"39395A"},{"id":103447,"change_date":"2022-03-30 21:40:00","inspection_id":"75174644","insp_violation_id":"244859044","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"20222421003444","created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":114742,"change_date":"2022-03-30 21:40:00","inspection_id":"75174644","insp_unit_id":"187894376","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"35","insp_unit_license":"NK8144","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2K189C97M036804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:54.000000Z","updated_at":"2025-03-17T22:08:54.000000Z"}]},{"id":34724,"change_date":"2022-03-24 21:31:00","inspection_id":"75129850","dot_number":"2169156","report_state":"NC","report_number":"0006404570","insp_date":"2022-03-24 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 85 N","location_desc":"I 85 NORTH ROADSIDE","county_code_state":"NC","county_code":"119","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1937935","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":"M","census_search_date":"2022-03-24 21:31:00","snet_input_date":"2022-03-24 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"P O BOX 786","insp_carrier_city":"HUNTERSVILLE","insp_carrier_state":"NC","insp_carrier_zip_code":"28070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:07.000000Z","updated_at":"2025-03-17T18:28:07.000000Z","inspection_violations":[{"id":49757,"change_date":"2022-03-24 21:31:00","inspection_id":"75129850","insp_violation_id":"244758870","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":55829,"change_date":"2022-03-24 21:31:00","inspection_id":"75129850","insp_unit_id":"187801592","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"47","insp_unit_license":"HT8821","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"JALE5B1U5P3001172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"}]},{"id":3285,"change_date":"2022-03-18 21:31:00","inspection_id":"75081714","dot_number":"2169156","report_state":"SC","report_number":"O261003279","insp_date":"2022-03-18 00:00:00","insp_start_time":"0852","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"059221","location_desc":"US 221 LAURENS COUNTY","county_code_state":"SC","county_code":"059","insp_level_id":"2","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":"2022-03-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1026180","transaction_code":"A","transaction_date":"2022-03-18 00:00:00","upload_date":"2022-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02169156","upload_search_indicator":null,"census_search_date":"2022-03-18 21:31:00","snet_input_date":"2022-03-18 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-03-18 21:31:00","insp_carrier_name":"MERCADOS CONSTRUCTION CLEAN UP INC","insp_carrier_street":"9327 OLD STATESVILEE RD","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:43.000000Z","updated_at":"2025-03-17T18:27:43.000000Z","inspection_violations":[{"id":4091,"change_date":"2022-03-18 21:31:00","inspection_id":"75081714","insp_violation_id":"244646367","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"20222421003305","created_at":"2025-03-17T21:07:09.000000Z","updated_at":"2025-03-17T21:07:09.000000Z","normalized_code":"3922"},{"id":4092,"change_date":"2022-03-18 21:31:00","inspection_id":"75081714","insp_violation_id":"244646368","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187701701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:09.000000Z","updated_at":"2025-03-17T21:07:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5230,"change_date":"2022-03-18 21:31:00","inspection_id":"75081714","insp_unit_id":"187701701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"MR6078","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1M2P267C0XM047328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:18.000000Z","updated_at":"2025-03-17T22:08:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2169156\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2169156\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2169156\/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\/2169156\/inspections","per_page":100,"prev_page_url":null,"to":61,"total":61}