{"current_page":1,"data":[{"id":6195056,"change_date":"2024-07-11 21:41:00","inspection_id":"82092307","dot_number":"1282143","report_state":"NY","report_number":"SPA0360543","insp_date":"2024-07-10 00:00:00","insp_start_time":"1422","insp_end_time":"1456","registration_date":null,"region":"ET","ci_status_code":"C","location":"80881A","location_desc":"WAWAYANDA (EB)","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ATLAS ROOFING","shipping_paper_number":"142421","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-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122300","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":"2935980","transaction_code":"A","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":"M","census_search_date":"2024-07-11 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:25.000000Z","updated_at":"2025-03-17T20:25:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9979955,"change_date":"2024-07-11 21:41:00","inspection_id":"82092307","insp_unit_id":"201835727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102","insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:22.000000Z","updated_at":"2025-03-17T23:26:22.000000Z"},{"id":9979956,"change_date":"2024-07-11 21:41:00","inspection_id":"82092307","insp_unit_id":"201835728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"48102","insp_unit_license":"5072230","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9629KH126001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:22.000000Z","updated_at":"2025-03-17T23:26:22.000000Z"}]},{"id":5379513,"change_date":"2024-03-27 21:42:00","inspection_id":"81207181","dot_number":"1282143","report_state":"NY","report_number":"SPF0270021","insp_date":"2024-03-25 00:00:00","insp_start_time":"0000","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"80865","location_desc":"WALLKILL (EB)","county_code_state":"NY","county_code":"071","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KEOLIS COMMUTER SERVICE LLC","shipping_paper_number":"0890533800","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123300","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":"2913180","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":null,"census_search_date":"2024-03-27 21:42:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:07.000000Z","updated_at":"2025-03-17T20:09:07.000000Z","inspection_violations":[{"id":8302901,"change_date":"2024-03-27 21:42:00","inspection_id":"81207181","insp_violation_id":"258609891","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200110600","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:12.000000Z","updated_at":"2025-03-17T21:46:12.000000Z","normalized_code":"39347E"},{"id":8302902,"change_date":"2024-03-27 21:42:00","inspection_id":"81207181","insp_violation_id":"258609892","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200110600","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:12.000000Z","updated_at":"2025-03-17T21:46:12.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8663626,"change_date":"2024-03-27 21:42:00","inspection_id":"81207181","insp_unit_id":"200110599","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"101","insp_unit_license":"73985A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLD63FSGT5981","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"},{"id":8663627,"change_date":"2024-03-27 21:42:00","inspection_id":"81207181","insp_unit_id":"200110600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"48101","insp_unit_license":"5160039","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9622GH729248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":4835801,"change_date":"2024-01-16 21:44:00","inspection_id":"80613738","dot_number":"1282143","report_state":"NY","report_number":"SPF0241420","insp_date":"2024-01-11 00:00:00","insp_start_time":"1145","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":"80865B","location_desc":"WALLKILL (WB)","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","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-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122300","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":"2899512","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":"M","census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[{"id":7456507,"change_date":"2024-01-16 21:44:00","inspection_id":"80613738","insp_violation_id":"257345625","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198965599","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":7780043,"change_date":"2024-01-16 21:44:00","inspection_id":"80613738","insp_unit_id":"198965599","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102","insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"},{"id":7780044,"change_date":"2024-01-16 21:44:00","inspection_id":"80613738","insp_unit_id":"198965600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"48102","insp_unit_license":"5072230","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9629KH126001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"}]},{"id":3483318,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","dot_number":"1282143","report_state":"CT","report_number":"3019004540","insp_date":"2023-07-12 00:00:00","insp_start_time":"1453","insp_end_time":"1518","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"680247","transaction_code":"C","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":null,"census_search_date":"2023-07-12 21:40:00","snet_input_date":"2023-07-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:02.000000Z","updated_at":"2025-03-17T19:32:02.000000Z","inspection_violations":[{"id":5372374,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","insp_violation_id":"254029725","seq_no":"1","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39522H1"},{"id":5372375,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","insp_violation_id":"254029726","seq_no":"2","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39522H2"},{"id":5372376,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","insp_violation_id":"254029727","seq_no":"3","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39522H3"},{"id":5372377,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","insp_violation_id":"254029728","seq_no":"4","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":"Y997615-1","created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5601457,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","insp_unit_id":"195970371","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"},{"id":5601458,"change_date":"2023-07-13 21:41:00","inspection_id":"79115550","insp_unit_id":"195970372","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5072230","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9629KH126001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"}]},{"id":2913717,"change_date":"2023-05-15 21:42:00","inspection_id":"78473300","dot_number":"1282143","report_state":"PA","report_number":"R414311609","insp_date":"2023-04-26 00:00:00","insp_start_time":"1515","insp_end_time":"1550","registration_date":"2023-05-15 00:00:00","region":"ET","ci_status_code":"C","location":"311","location_desc":"I84 EB MM 25.3 PALMYRA TWP - E","county_code_state":"PA","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"USG","shipping_paper_number":"9434451","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-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"2341303","transaction_code":"C","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-26 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:27.000000Z","updated_at":"2025-03-17T19:20:27.000000Z","inspection_violations":[{"id":4471485,"change_date":"2023-05-15 21:42:00","inspection_id":"78473300","insp_violation_id":"252837334","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"194935786","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":4687808,"change_date":"2023-05-15 21:42:00","inspection_id":"78473300","insp_unit_id":"194935786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102","insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:57.000000Z","updated_at":"2025-03-17T22:39:57.000000Z"},{"id":4687809,"change_date":"2023-05-15 21:42:00","inspection_id":"78473300","insp_unit_id":"194935787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"48102","insp_unit_license":"5072230","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9629KH126001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:57.000000Z","updated_at":"2025-03-17T22:39:57.000000Z"}]},{"id":2581640,"change_date":"2023-03-15 21:41:00","inspection_id":"78095794","dot_number":"1282143","report_state":"CT","report_number":"3090003173","insp_date":"2023-03-15 00:00:00","insp_start_time":"1123","insp_end_time":"1144","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"HOME DEPOT","shipping_paper_number":"9308997","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"669322","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":null,"census_search_date":"2023-03-15 21:41:00","snet_input_date":"2023-03-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-15 21:41:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:26.000000Z","updated_at":"2025-03-17T19:14:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4155274,"change_date":"2023-03-15 21:41:00","inspection_id":"78095794","insp_unit_id":"193880917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102","insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:48.000000Z","updated_at":"2025-03-17T22:35:48.000000Z"},{"id":4155275,"change_date":"2023-03-15 21:41:00","inspection_id":"78095794","insp_unit_id":"193880918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5160039","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9622GH729248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:48.000000Z","updated_at":"2025-03-17T22:35:48.000000Z"}]},{"id":2144245,"change_date":"2023-02-09 21:40:00","inspection_id":"77597024","dot_number":"1282143","report_state":"PA","report_number":"N310301107","insp_date":"2023-01-11 00:00:00","insp_start_time":"0639","insp_end_time":"0705","registration_date":"2023-02-09 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I80 E AT MM 281.0","county_code_state":"PA","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"USG","shipping_paper_number":"000009123138","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-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"59000","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":"2314769","transaction_code":"C","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":null,"census_search_date":"2023-01-13 21:40:00","snet_input_date":"2023-01-11 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:14.000000Z","updated_at":"2025-03-17T19:06:14.000000Z","inspection_violations":[{"id":3317602,"change_date":"2023-02-09 21:40:00","inspection_id":"77597024","insp_violation_id":"251055112","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:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3450809,"change_date":"2023-02-09 21:40:00","inspection_id":"77597024","insp_unit_id":"193326057","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102","insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"},{"id":3450810,"change_date":"2023-02-09 21:40:00","inspection_id":"77597024","insp_unit_id":"193326058","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"48102","insp_unit_license":"5072230","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRDM9629KH126001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"}]},{"id":2051008,"change_date":"2023-01-03 21:40:00","inspection_id":"77490123","dot_number":"1282143","report_state":"NJ","report_number":"SPQFI03065","insp_date":"2022-12-30 00:00:00","insp_start_time":"0652","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"2113","location_desc":"KNOWLTON SCALE","county_code_state":"NJ","county_code":"041","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"9095838","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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1136497","transaction_code":"A","transaction_date":"2022-12-30 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01282143","upload_search_indicator":null,"census_search_date":"2023-01-03 21:40:00","snet_input_date":"2022-12-30 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-01-03 21:40:00","insp_carrier_name":"MERCADO TRANSPORT LLC","insp_carrier_street":"92 ROCKY HILL AVE","insp_carrier_city":"NEW BRITAIN","insp_carrier_state":"CT","insp_carrier_zip_code":"06051","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:23.000000Z","updated_at":"2025-03-17T19:04:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3299075,"change_date":"2023-01-03 21:40:00","inspection_id":"77490123","insp_unit_id":"192661003","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"73452A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGLDR9JSJK0385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:36.000000Z","updated_at":"2025-03-17T22:29:36.000000Z"},{"id":3299076,"change_date":"2023-01-03 21:40:00","inspection_id":"77490123","insp_unit_id":"192661004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"3143155","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"13N148209D1555657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:36.000000Z","updated_at":"2025-03-17T22:29:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1282143\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1282143\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1282143\/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\/1282143\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}