{"current_page":1,"data":[{"id":9864008,"change_date":"2025-10-06 21:40:00","inspection_id":"85966653","dot_number":"530193","report_state":"NJ","report_number":"SPPTI00885","insp_date":"2025-10-03 00:00:00","insp_start_time":"1047","insp_end_time":"1058","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE CVI","county_code_state":"NJ","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"OFFICE HISPANIC VENTURES","shipping_paper_number":"10138089","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-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1318189","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-10-06 21:40:00","snet_input_date":"2025-10-03 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:47.000000Z","updated_at":"2025-10-10T10:00:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16361172,"change_date":"2025-10-06 21:40:00","inspection_id":"85966653","insp_unit_id":"209315539","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"65631","insp_unit_license":"44007PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXFCXSDVS6351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:44.000000Z","updated_at":"2025-10-10T09:46:14.000000Z"}]},{"id":9389479,"change_date":"2025-08-12 21:39:00","inspection_id":"85468403","dot_number":"530193","report_state":"NJ","report_number":"SPQTI03531","insp_date":"2025-08-08 00:00:00","insp_start_time":"1147","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"1217","location_desc":"@I-287 NB MP 9.6","county_code_state":"NJ","county_code":"023","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1308359","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-08-12 21:39:00","snet_input_date":"2025-08-08 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-08-12 21:39:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:43.000000Z","updated_at":"2025-08-16T10:00:35.000000Z","inspection_violations":[{"id":15262432,"change_date":"2025-08-12 21:39:00","inspection_id":"85468403","insp_violation_id":"267975305","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1217W25077316","created_at":"2025-08-15T10:45:42.000000Z","updated_at":"2025-08-16T10:43:38.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":15471818,"change_date":"2025-08-12 21:39:00","inspection_id":"85468403","insp_unit_id":"208352673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57844PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT7H4S54601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:20.000000Z","updated_at":"2025-08-16T09:45:44.000000Z"}]},{"id":8917169,"change_date":"2025-10-07 21:41:00","inspection_id":"84971044","dot_number":"530193","report_state":"NY","report_number":"0L11000199","insp_date":"2025-06-10 00:00:00","insp_start_time":"1358","insp_end_time":"1428","registration_date":"2025-07-01 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"OCEANSIDE NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2025-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"1874110","transaction_code":"C","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:53.000000Z","updated_at":"2025-10-11T10:00:46.000000Z","inspection_violations":[{"id":16278885,"change_date":"2025-10-07 21:41:00","inspection_id":"84971044","insp_violation_id":"269149899","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209341429","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K393KFNPNN","created_at":"2025-10-10T10:18:32.000000Z","updated_at":"2025-10-11T10:16:30.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":16278886,"change_date":"2025-10-07 21:41:00","inspection_id":"84971044","insp_violation_id":"269149900","seq_no":"2","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"209341429","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"K393KFNP4D","created_at":"2025-10-10T10:18:32.000000Z","updated_at":"2025-10-11T10:16:30.000000Z","normalized_code":"3929BAINACTIVE"}],"inspection_per_units":[{"id":16384093,"change_date":"2025-10-07 21:41:00","inspection_id":"84971044","insp_unit_id":"209341429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:44.000000Z","updated_at":"2025-10-11T09:46:01.000000Z"}]},{"id":8711055,"change_date":"2025-05-22 21:41:00","inspection_id":"84752531","dot_number":"530193","report_state":"NY","report_number":"0L11800085","insp_date":"2025-05-22 00:00:00","insp_start_time":"1200","insp_end_time":"1217","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2025-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"1767391","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-05-22 21:41:00","snet_input_date":"2025-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-22 21:41:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-25T10:05:04.000000Z","updated_at":"2025-05-26T10:04:48.000000Z","inspection_violations":[{"id":13886719,"change_date":"2025-05-22 21:41:00","inspection_id":"84752531","insp_violation_id":"266401528","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"207009434","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:26:19.000000Z","updated_at":"2025-05-26T10:22:13.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":13886720,"change_date":"2025-05-22 21:41:00","inspection_id":"84752531","insp_violation_id":"266401529","seq_no":"2","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"207009434","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-25T10:26:19.000000Z","updated_at":"2025-05-26T10:22:13.000000Z","normalized_code":"3929BAINACTIVE"}],"inspection_per_units":[{"id":14235719,"change_date":"2025-05-22 21:41:00","inspection_id":"84752531","insp_unit_id":"207009434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:41.000000Z","updated_at":"2025-05-26T09:49:55.000000Z"}]},{"id":8484961,"change_date":"2025-04-29 21:48:00","inspection_id":"84514188","dot_number":"530193","report_state":"NY","report_number":"0L61000906","insp_date":"2025-04-25 00:00:00","insp_start_time":"1000","insp_end_time":"1009","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1642560","transaction_code":"A","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:20.000000Z","updated_at":"2025-05-02T13:48:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13789970,"change_date":"2025-04-29 21:48:00","inspection_id":"84514188","insp_unit_id":"206522091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57844PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT7H4S54601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:06:42.000000Z","updated_at":"2025-05-03T09:57:15.000000Z"}]},{"id":8398941,"change_date":"2025-04-17 21:41:00","inspection_id":"84423666","dot_number":"530193","report_state":"NY","report_number":"SPT3020948","insp_date":"2025-04-11 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"ED","ci_status_code":"C","location":"80342","location_desc":"TARRYTOWN NY","county_code_state":"NY","county_code":"119","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":"U","pen_cen_match":"I","final_status_date":"2025-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"1605911","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:41.000000Z","updated_at":"2025-04-21T10:21:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13634238,"change_date":"2025-04-17 21:41:00","inspection_id":"84423666","insp_unit_id":"206355980","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"43646","insp_unit_license":"33872PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEVTAR7PL677433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:07:58.000000Z","updated_at":"2025-04-21T09:52:00.000000Z"}]},{"id":7724847,"change_date":"2025-01-28 21:38:00","inspection_id":"83714750","dot_number":"530193","report_state":"NY","report_number":"0L11200039","insp_date":"2025-01-28 00:00:00","insp_start_time":"1223","insp_end_time":"1255","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BELLMORE NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2025-01-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1295212","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-01-28 21:38:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-28 21:38:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:40.000000Z","updated_at":"2025-03-17T20:58:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12465777,"change_date":"2025-01-28 21:38:00","inspection_id":"83714750","insp_unit_id":"205037210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:33.000000Z","updated_at":"2025-03-17T23:52:33.000000Z"}]},{"id":7662883,"change_date":"2025-01-20 21:34:00","inspection_id":"83649824","dot_number":"530193","report_state":"NY","report_number":"SPL3030218","insp_date":"2025-01-13 00:00:00","insp_start_time":"1125","insp_end_time":"1140","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DEER PARK NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2025-01-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1267690","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:25.000000Z","updated_at":"2025-03-17T20:57:25.000000Z","inspection_violations":[{"id":11971815,"change_date":"2025-01-20 21:34:00","inspection_id":"83649824","insp_violation_id":"264081433","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"204917389","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":12364911,"change_date":"2025-01-20 21:34:00","inspection_id":"83649824","insp_unit_id":"204917389","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:25.000000Z","updated_at":"2025-03-17T23:51:25.000000Z"}]},{"id":6877925,"change_date":"2024-10-03 21:42:00","inspection_id":"82820925","dot_number":"530193","report_state":"NY","report_number":"SPL3010086","insp_date":"2024-09-26 00:00:00","insp_start_time":"1048","insp_end_time":"1106","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DEER PARK NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2024-10-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"908176","transaction_code":"A","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2024-10-03 21:42:00","snet_input_date":"2024-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-03 21:42:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:28.000000Z","updated_at":"2025-03-17T20:39:28.000000Z","inspection_violations":[{"id":10713783,"change_date":"2024-10-03 21:42:00","inspection_id":"82820925","insp_violation_id":"262160393","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203246193","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:52.000000Z","updated_at":"2025-03-17T21:57:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11092318,"change_date":"2024-10-03 21:42:00","inspection_id":"82820925","insp_unit_id":"203246193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:52.000000Z","updated_at":"2025-03-17T23:37:52.000000Z"}]},{"id":5982638,"change_date":"2024-06-13 21:42:00","inspection_id":"81863616","dot_number":"530193","report_state":"NY","report_number":"SPE0229265","insp_date":"2024-06-11 00:00:00","insp_start_time":"1010","insp_end_time":"1031","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057A","location_desc":"BEDFORD (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY PAINT DBA POLLACK AND FIELD","shipping_paper_number":"30009470","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"2929515","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":"M","census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:26.000000Z","updated_at":"2025-03-17T20:21:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9636165,"change_date":"2024-06-13 21:42:00","inspection_id":"81863616","insp_unit_id":"201376500","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"43646","insp_unit_license":"33872PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEVTAR7PL677433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:53.000000Z","updated_at":"2025-03-17T23:22:53.000000Z"}]},{"id":4471081,"change_date":"2023-11-21 21:39:00","inspection_id":"80214129","dot_number":"530193","report_state":"NY","report_number":"SPT0531612","insp_date":"2023-11-20 00:00:00","insp_start_time":"0722","insp_end_time":"0739","registration_date":null,"region":"ET","ci_status_code":"C","location":"80843M","location_desc":"KINGSTON X19","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY PAINT","shipping_paper_number":"30008860","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-11-21 21:39: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":"2888869","transaction_code":"A","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":"M","census_search_date":"2023-11-21 21:39:00","snet_input_date":"2023-11-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-21 21:39:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:26.000000Z","updated_at":"2025-03-17T19:51:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7190416,"change_date":"2023-11-21 21:39:00","inspection_id":"80214129","insp_unit_id":"198161179","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"43646","insp_unit_license":"33872PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEVTAR7PL677433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:24.000000Z","updated_at":"2025-03-17T23:00:24.000000Z"}]},{"id":4403449,"change_date":"2023-11-13 21:41:00","inspection_id":"80139652","dot_number":"530193","report_state":"NY","report_number":"SPD0291529","insp_date":"2023-11-08 00:00:00","insp_start_time":"1115","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - NORTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2023-11-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2886377","transaction_code":"A","transaction_date":"2023-11-08 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2023-11-13 21:41:00","snet_input_date":"2023-11-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-13 21:41:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:16.000000Z","updated_at":"2025-03-17T19:50:16.000000Z","inspection_violations":[{"id":6815809,"change_date":"2023-11-13 21:41:00","inspection_id":"80139652","insp_violation_id":"256341405","seq_no":"1","part_no":"390","part_no_section":"21(e)","insp_viol_unit":"1","insp_unit_id":"198011301","insp_violation_category_id":"30","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":"39021E"},{"id":6815810,"change_date":"2023-11-13 21:41:00","inspection_id":"80139652","insp_violation_id":"256341406","seq_no":"2","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"198011301","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8HCSB0N","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":7081603,"change_date":"2023-11-13 21:41:00","inspection_id":"80139652","insp_unit_id":"198011301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:27.000000Z","updated_at":"2025-03-17T22:59:27.000000Z"}]},{"id":3752727,"change_date":"2023-08-16 21:38:00","inspection_id":"79416954","dot_number":"530193","report_state":"NY","report_number":"SPL0078588","insp_date":"2023-08-03 00:00:00","insp_start_time":"1152","insp_end_time":"1228","registration_date":null,"region":"ET","ci_status_code":"C","location":"01185","location_desc":"FREEPORT","county_code_state":"NY","county_code":"059","insp_level_id":"1","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":"2023-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2858955","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2023-08-16 21:38:00","snet_input_date":"2023-08-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-16 21:38:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:55.000000Z","updated_at":"2025-03-17T19:36:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6034037,"change_date":"2023-08-16 21:38:00","inspection_id":"79416954","insp_unit_id":"196553319","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"Y","insp_unit_decal_number":"99999999","created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":3281310,"change_date":"2023-06-14 21:41:00","inspection_id":"78888093","dot_number":"530193","report_state":"NY","report_number":"SP3T200162","insp_date":"2023-06-13 00:00:00","insp_start_time":"0655","insp_end_time":"0710","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"POLLACK PAINT AND FIELD","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-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2835804","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-06-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-14 21:41:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:06.000000Z","updated_at":"2025-03-17T19:28:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5275656,"change_date":"2023-06-14 21:41:00","inspection_id":"78888093","insp_unit_id":"195488531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"96351","insp_unit_license":"47580PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV5G4S55343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:36.000000Z","updated_at":"2025-03-17T22:44:36.000000Z"}]},{"id":3091187,"change_date":"2023-05-19 21:42:00","inspection_id":"78673423","dot_number":"530193","report_state":"NY","report_number":"SPL0182531","insp_date":"2023-05-18 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2827154","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[{"id":4753268,"change_date":"2023-05-19 21:42:00","inspection_id":"78673423","insp_violation_id":"252948415","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"195032009","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39021B"},{"id":4753269,"change_date":"2023-05-19 21:42:00","inspection_id":"78673423","insp_violation_id":"252948416","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195032009","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4972209,"change_date":"2023-05-19 21:42:00","inspection_id":"78673423","insp_unit_id":"195032009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":2672637,"change_date":"2023-03-28 21:40:00","inspection_id":"78198599","dot_number":"530193","report_state":"NY","report_number":"SPL0173001","insp_date":"2023-03-27 00:00:00","insp_start_time":"1017","insp_end_time":"1033","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"3","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":"2023-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2810802","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":"M","census_search_date":"2023-03-28 21:40:00","snet_input_date":"2023-03-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-28 21:40:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:53.000000Z","updated_at":"2025-03-17T19:15:53.000000Z","inspection_violations":[{"id":4107534,"change_date":"2023-03-28 21:40:00","inspection_id":"78198599","insp_violation_id":"251895221","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194089411","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4302932,"change_date":"2023-03-28 21:40:00","inspection_id":"78198599","insp_unit_id":"194089411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"}]},{"id":2405796,"change_date":"2023-02-21 21:40:00","inspection_id":"77895568","dot_number":"530193","report_state":"NY","report_number":"SPWL051263","insp_date":"2023-02-17 00:00:00","insp_start_time":"0023","insp_end_time":"1241","registration_date":null,"region":"ET","ci_status_code":"C","location":"01185","location_desc":"FREEPORT-RT 27 RIGHT SHOULDER","county_code_state":"NY","county_code":"059","insp_level_id":"3","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":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2800458","transaction_code":"A","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:02.000000Z","updated_at":"2025-03-17T19:11:02.000000Z","inspection_violations":[{"id":3703389,"change_date":"2023-02-21 21:40:00","inspection_id":"77895568","insp_violation_id":"251225887","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193480189","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5GFMNK9","created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3871379,"change_date":"2023-02-21 21:40:00","inspection_id":"77895568","insp_unit_id":"193480189","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2009361,"change_date":"2022-12-23 21:33:00","inspection_id":"77442730","dot_number":"530193","report_state":"NY","report_number":"SPK0158056","insp_date":"2022-12-22 00:00:00","insp_start_time":"1014","insp_end_time":"1029","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"3","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":"2022-12-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"2783052","transaction_code":"A","transaction_date":"2022-12-23 00:00:00","upload_date":"2022-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":"M","census_search_date":"2022-12-23 21:33:00","snet_input_date":"2022-12-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-23 21:33:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3232465,"change_date":"2022-12-23 21:33:00","inspection_id":"77442730","insp_unit_id":"192567727","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"64637","insp_unit_license":"34283PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALHCYCY0EDFZ6789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]},{"id":2051793,"change_date":"2023-01-03 21:40:00","inspection_id":"77490988","dot_number":"530193","report_state":"NY","report_number":"SPL0134812","insp_date":"2022-12-15 00:00:00","insp_start_time":"1135","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2023-01-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2784656","transaction_code":"A","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":"M","census_search_date":"2023-01-03 21:40:00","snet_input_date":"2023-01-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-03 21:40:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","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":3300149,"change_date":"2023-01-03 21:40:00","inspection_id":"77490988","insp_unit_id":"192662265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"92625","insp_unit_license":"23163PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV7AT0N5T50022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:38.000000Z","updated_at":"2025-03-17T22:29:38.000000Z"}]},{"id":1803943,"change_date":"2023-01-25 21:42:00","inspection_id":"77207780","dot_number":"530193","report_state":"NJ","report_number":"SPPUI00787","insp_date":"2022-11-22 00:00:00","insp_start_time":"1215","insp_end_time":"1232","registration_date":"2022-11-23 00:00:00","region":"ET","ci_status_code":"C","location":"1201","location_desc":"CARTERET","county_code_state":"NJ","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY","shipping_paper_number":"10107517","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-11-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1131443","transaction_code":"C","transaction_date":"2022-11-22 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":null,"census_search_date":"2022-11-23 21:39:00","snet_input_date":"2022-11-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2022-11-23 21:39:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:57.000000Z","updated_at":"2025-03-17T18:59:57.000000Z","inspection_violations":[{"id":2822247,"change_date":"2023-01-25 21:42:00","inspection_id":"77207780","insp_violation_id":"250763294","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"220924852","created_at":"2025-03-17T21:20:24.000000Z","updated_at":"2025-03-17T21:20:24.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":2901749,"change_date":"2023-01-25 21:42:00","inspection_id":"77207780","insp_unit_id":"193050942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57844PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT7H4S54601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:52.000000Z","updated_at":"2025-03-17T22:26:52.000000Z"}]},{"id":297388,"change_date":"2022-05-02 21:40:00","inspection_id":"75447849","dot_number":"530193","report_state":"NY","report_number":"SPB0370699","insp_date":"2022-04-28 00:00:00","insp_start_time":"1132","insp_end_time":"1153","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057A","location_desc":"BEDFORD (SB)","county_code_state":"NY","county_code":"119","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":"2022-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"2701529","transaction_code":"A","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00530193","upload_search_indicator":"M","census_search_date":"2022-05-02 21:40:00","snet_input_date":"2022-05-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-02 21:40:00","insp_carrier_name":"MERCURY PAINT CORPORATION","insp_carrier_street":"4808 FARRAGUT ROAD","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:38.000000Z","updated_at":"2025-03-17T18:32:38.000000Z","inspection_violations":[{"id":463248,"change_date":"2022-05-02 21:40:00","inspection_id":"75447849","insp_violation_id":"245502675","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188445575","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3922"},{"id":463249,"change_date":"2022-05-02 21:40:00","inspection_id":"75447849","insp_violation_id":"245502676","seq_no":"2","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"188445575","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"39375B"},{"id":463250,"change_date":"2022-05-02 21:40:00","inspection_id":"75447849","insp_violation_id":"245502677","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188445575","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1FD5KDG","created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":480927,"change_date":"2022-05-02 21:40:00","inspection_id":"75447849","insp_unit_id":"188445575","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"64637","insp_unit_license":"34283PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALHCYCY0EDFZ6789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:09.000000Z","updated_at":"2025-03-17T22:11:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/530193\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/530193\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/530193\/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\/530193\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}