{"current_page":1,"data":[{"id":11593487,"change_date":"2026-04-08 21:37:00","inspection_id":"87519499","dot_number":"2817223","report_state":"NY","report_number":"0L11900522","insp_date":"2026-04-01 00:00:00","insp_start_time":"1505","insp_end_time":"1521","registration_date":"2026-04-06 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY 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":"2026-04-08 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"3125645","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2026-04-08 21:37:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-08 21:37:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:30.000000Z","updated_at":"2026-04-19T09:30:35.000000Z","inspection_violations":[{"id":19603866,"change_date":"2026-04-08 21:37:00","inspection_id":"87519499","insp_violation_id":"272930197","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"212599531","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070LH4SLK","created_at":"2026-04-11T10:03:06.000000Z","updated_at":"2026-04-18T10:46:48.000000Z","normalized_code":"39021TB1MC"},{"id":19603867,"change_date":"2026-04-08 21:37:00","inspection_id":"87519499","insp_violation_id":"272930198","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"212599531","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070LH4T7N","created_at":"2026-04-11T10:03:06.000000Z","updated_at":"2026-04-18T10:46:48.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":19871224,"change_date":"2026-04-08 21:37:00","inspection_id":"87519499","insp_unit_id":"212599531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"75289NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC6JDJK1970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:37.000000Z","updated_at":"2026-04-18T09:34:48.000000Z"}]},{"id":11317395,"change_date":"2026-03-19 21:38:00","inspection_id":"87233854","dot_number":"2817223","report_state":"NY","report_number":"0L80001889","insp_date":"2026-03-03 00:00:00","insp_start_time":"0751","insp_end_time":"0812","registration_date":"2026-03-18 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"WOODBURY 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":"2026-03-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2976147","transaction_code":"C","transaction_date":"2026-03-06 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2026-03-07 21:34:00","snet_input_date":"2026-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-07 21:34:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-10T09:41:36.000000Z","updated_at":"2026-03-30T09:30:05.000000Z","inspection_violations":[{"id":19244485,"change_date":"2026-03-19 21:38:00","inspection_id":"87233854","insp_violation_id":"272487564","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:59.000000Z","normalized_code":"39141APC"},{"id":19244486,"change_date":"2026-03-19 21:38:00","inspection_id":"87233854","insp_violation_id":"272487565","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K158LD12KB","created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:59.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":19546948,"change_date":"2026-03-19 21:38:00","inspection_id":"87233854","insp_unit_id":"212209680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"NOT DISPLAYED","insp_unit_license":"57308MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3G3CG3D1194367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:20.000000Z","updated_at":"2026-03-30T09:04:35.000000Z"}]},{"id":11157095,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","dot_number":"2817223","report_state":"NY","report_number":"0L10001767","insp_date":"2026-02-12 00:00:00","insp_start_time":"1229","insp_end_time":"1318","registration_date":"2026-02-20 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"MASSAPEQUA NY","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-18 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"7","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2898401","transaction_code":"C","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2026-02-18 21:37:00","snet_input_date":"2026-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-18 21:37:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-21T10:37:47.000000Z","updated_at":"2026-03-06T10:30:12.000000Z","inspection_violations":[{"id":18779931,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950542","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"211759930","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"K122LB0Z22","created_at":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"3939ALTSI"},{"id":18779932,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950543","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211759930","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K122LB0Z51","created_at":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"39617CPI"},{"id":18779933,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950544","seq_no":"3","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"211759930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K122LB0XWR","created_at":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"3939ALHWS"},{"id":18779934,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950545","seq_no":"4","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"211759930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K122LB0Z02","created_at":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"3939ALSLI"},{"id":18779935,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950546","seq_no":"5","part_no":"393","part_no_section":"75A4-PBME","insp_viol_unit":"1","insp_unit_id":"211759930","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K122LB0XBT","created_at":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"39375A4PBME"},{"id":18779936,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950547","seq_no":"6","part_no":"391","part_no_section":"11B5-LNCDLNVE","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"39111B5LNCDLNVE"},{"id":18779937,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_violation_id":"271950548","seq_no":"7","part_no":"392","part_no_section":"2-SLLTCD","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":"2026-02-26T10:50:32.000000Z","updated_at":"2026-03-06T10:40:09.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19126215,"change_date":"2026-02-23 21:38:00","inspection_id":"87071992","insp_unit_id":"211759930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"09","insp_unit_license":"23522NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W165K7K00422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:07.000000Z","updated_at":"2026-03-06T10:02:39.000000Z"}]},{"id":10266673,"change_date":"2025-12-03 21:38:00","inspection_id":"86390609","dot_number":"2817223","report_state":"NY","report_number":"0L10001680","insp_date":"2025-11-21 00:00:00","insp_start_time":"0912","insp_end_time":"0939","registration_date":"2025-12-02 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","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":"U","pen_cen_match":"I","final_status_date":"2025-11-22 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2571675","transaction_code":"C","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-11-22 21:50:00","snet_input_date":"2025-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-22 21:50:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-25T10:32:16.000000Z","updated_at":"2025-12-07T10:30:08.000000Z","inspection_violations":[{"id":17295168,"change_date":"2025-12-03 21:38:00","inspection_id":"86390609","insp_violation_id":"270420922","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"210378330","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K122L14VCJ","created_at":"2025-12-06T10:32:13.000000Z","updated_at":"2025-12-07T10:30:18.000000Z","normalized_code":"39395F"},{"id":17295169,"change_date":"2025-12-03 21:38:00","inspection_id":"86390609","insp_violation_id":"270420923","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-06T10:32:13.000000Z","updated_at":"2025-12-07T10:30:18.000000Z","normalized_code":"39141APC"},{"id":17295170,"change_date":"2025-12-03 21:38:00","inspection_id":"86390609","insp_violation_id":"270420924","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210378330","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K122L14V1N","created_at":"2025-12-06T10:32:13.000000Z","updated_at":"2025-12-07T10:30:18.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":17265960,"change_date":"2025-12-03 21:38:00","inspection_id":"86390609","insp_unit_id":"210378330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MERCEDES B","insp_unit_company":null,"insp_unit_license":"17285NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"W1Y8NC3Y7RT177708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-06T10:01:21.000000Z","updated_at":"2025-12-07T10:00:10.000000Z"}]},{"id":10195957,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","dot_number":"2817223","report_state":"NY","report_number":"0L69000351","insp_date":"2025-11-07 00:00:00","insp_start_time":"1028","insp_end_time":"1055","registration_date":"2025-12-02 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"PORT WASHINGTON NY","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"150040","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2539641","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-11-14 21:39:00","snet_input_date":"2025-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-14 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:15.000000Z","updated_at":"2025-12-07T10:30:07.000000Z","inspection_violations":[{"id":17294770,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_violation_id":"270425377","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"210381847","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88KZN7R6","created_at":"2025-12-06T10:32:12.000000Z","updated_at":"2025-12-07T10:30:16.000000Z","normalized_code":"3922SLLIFTA"},{"id":17294771,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_violation_id":"270425378","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210381848","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-06T10:32:12.000000Z","updated_at":"2025-12-07T10:30:16.000000Z","normalized_code":"3939ALIL"},{"id":17294772,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_violation_id":"270425379","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210381847","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-06T10:32:12.000000Z","updated_at":"2025-12-07T10:30:16.000000Z","normalized_code":"39395A1"},{"id":17294773,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_violation_id":"270425380","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"210381848","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-06T10:32:12.000000Z","updated_at":"2025-12-07T10:30:16.000000Z","normalized_code":"3939ALRLI"},{"id":17294774,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_violation_id":"270425381","seq_no":"5","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"210381848","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"PW88KZN84Q","created_at":"2025-12-06T10:32:12.000000Z","updated_at":"2025-12-07T10:30:16.000000Z","normalized_code":"3939ALTSI"},{"id":17294775,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_violation_id":"270425382","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"210381848","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88KZN8GL","created_at":"2025-12-06T10:32:12.000000Z","updated_at":"2025-12-07T10:30:16.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":17265749,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_unit_id":"210381847","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"83357NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKDX4TX0DJ350773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-06T10:01:21.000000Z","updated_at":"2025-12-07T10:00:09.000000Z"},{"id":17265750,"change_date":"2025-12-03 21:38:00","inspection_id":"86316520","insp_unit_id":"210381848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"CE22572","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7UZAP3034SL010683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-06T10:01:21.000000Z","updated_at":"2025-12-07T10:00:09.000000Z"}]},{"id":9692734,"change_date":"2025-10-09 21:40:00","inspection_id":"85787080","dot_number":"2817223","report_state":"NY","report_number":"0L11900296","insp_date":"2025-09-10 00:00:00","insp_start_time":"0812","insp_end_time":"0830","registration_date":"2025-09-23 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"HICKSVILLE 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-09-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2282337","transaction_code":"C","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:58.000000Z","updated_at":"2025-10-13T10:00:12.000000Z","inspection_violations":[{"id":16316102,"change_date":"2025-10-09 21:40:00","inspection_id":"85787080","insp_violation_id":"269197510","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209379521","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:11.000000Z","updated_at":"2025-10-13T10:15:16.000000Z","normalized_code":"3922SLLSR"},{"id":16316103,"change_date":"2025-10-09 21:40:00","inspection_id":"85787080","insp_violation_id":"269197511","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","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-10-12T10:17:11.000000Z","updated_at":"2025-10-13T10:15:16.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":16414692,"change_date":"2025-10-09 21:40:00","inspection_id":"85787080","insp_unit_id":"209379521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"09","insp_unit_license":"69348ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W165K7K00422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:05.000000Z","updated_at":"2025-10-13T09:45:11.000000Z"}]},{"id":9666313,"change_date":"2025-10-03 21:39:00","inspection_id":"85759146","dot_number":"2817223","report_state":"NY","report_number":"0L94000812","insp_date":"2025-09-08 00:00:00","insp_start_time":"0901","insp_end_time":"0915","registration_date":"2025-09-16 00:00:00","region":"ED","ci_status_code":"C","location":"00001Z","location_desc":"WESTHAMPTON NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TAP ENTERPRISES OF LI INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"2268340","transaction_code":"C","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:12.000000Z","updated_at":"2025-10-08T10:00:08.000000Z","inspection_violations":[{"id":16210126,"change_date":"2025-10-03 21:39:00","inspection_id":"85759146","insp_violation_id":"269081940","seq_no":"1","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"209285197","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-05T10:17:56.000000Z","updated_at":"2025-10-08T10:15:15.000000Z","normalized_code":"177834AHMC"},{"id":16210127,"change_date":"2025-10-03 21:39:00","inspection_id":"85759146","insp_violation_id":"269081941","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209285197","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:56.000000Z","updated_at":"2025-10-08T10:15:15.000000Z","normalized_code":"39378"},{"id":16210128,"change_date":"2025-10-03 21:39:00","inspection_id":"85759146","insp_violation_id":"269081942","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209285197","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:56.000000Z","updated_at":"2025-10-08T10:15:15.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16324702,"change_date":"2025-10-03 21:39:00","inspection_id":"85759146","insp_unit_id":"209285197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"26345NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5J166K7900541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:07.000000Z","updated_at":"2025-10-08T09:45:08.000000Z"}]},{"id":9592394,"change_date":"2025-09-04 21:40:00","inspection_id":"85681750","dot_number":"2817223","report_state":"NY","report_number":"0L12100216","insp_date":"2025-09-02 00:00:00","insp_start_time":"1033","insp_end_time":"1049","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-09-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"2222051","transaction_code":"A","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-09-04 21:40:00","snet_input_date":"2025-09-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-04 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:26.000000Z","updated_at":"2025-09-10T10:45:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15837528,"change_date":"2025-09-04 21:40:00","inspection_id":"85681750","insp_unit_id":"208747659","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"23","insp_unit_license":"23913MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FL7EDA55488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:48.000000Z","updated_at":"2025-09-10T09:45:43.000000Z"}]},{"id":9592251,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","dot_number":"2817223","report_state":"NY","report_number":"0L84001027","insp_date":"2025-09-01 00:00:00","insp_start_time":"0831","insp_end_time":"1110","registration_date":"2025-11-04 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"HAUPPAUGE 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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"15","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2221813","transaction_code":"C","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-09-04 21:40:00","snet_input_date":"2025-09-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-04 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:25.000000Z","updated_at":"2025-11-09T10:30:06.000000Z","inspection_violations":[{"id":16781708,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737734","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H924KQHNCD","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3922SLLSR"},{"id":16781709,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737735","seq_no":"2","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"H928KQHQML","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3963A1TAOCV"},{"id":16781710,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737736","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHTHB","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"39021TB1MC"},{"id":16781711,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737737","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHQXQ","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3922SLLSR"},{"id":16781712,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737738","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H924KQHPMD","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3922SLLSR"},{"id":16781713,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737739","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHR57","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3922SLLSR"},{"id":16781714,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737740","seq_no":"7","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHJ5X","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3922SLLIFTA"},{"id":16781715,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737741","seq_no":"8","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"393100BC"},{"id":16781716,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737742","seq_no":"9","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"393134BCRHLC"},{"id":16781717,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737743","seq_no":"10","part_no":"393","part_no_section":"203A-CBP","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHPS0","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"393203ACBP"},{"id":16781718,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737744","seq_no":"11","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHQ4V","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3939ALFTSI"},{"id":16781719,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737745","seq_no":"12","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHQCM","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3939ALHLI"},{"id":16781720,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737746","seq_no":"13","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHQC7F","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:09.000000Z","normalized_code":"3939ALHWS"},{"id":16781721,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737747","seq_no":"14","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"H928KQHQH0","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:10.000000Z","normalized_code":"3939ALSLIWR"},{"id":16781722,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_violation_id":"269737748","seq_no":"15","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209847986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H928KQHPGK","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:10.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":16842401,"change_date":"2025-11-05 21:40:00","inspection_id":"85681586","insp_unit_id":"209847986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"75100NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHALCG37DX46685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:00.000000Z","updated_at":"2025-11-09T10:00:08.000000Z"}]},{"id":9418670,"change_date":"2025-11-05 21:40:00","inspection_id":"85499050","dot_number":"2817223","report_state":"NY","report_number":"0L95001765","insp_date":"2025-08-08 00:00:00","insp_start_time":"1459","insp_end_time":"1509","registration_date":"2025-11-04 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"JERICHO 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-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"2131296","transaction_code":"C","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-08-15 21:38:00","snet_input_date":"2025-08-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-15 21:38:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:30.000000Z","updated_at":"2025-11-09T10:30:05.000000Z","inspection_violations":[{"id":16781474,"change_date":"2025-11-05 21:40:00","inspection_id":"85499050","insp_violation_id":"269737579","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209847909","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310KMZL8C","created_at":"2025-11-08T10:32:19.000000Z","updated_at":"2025-11-09T10:30:08.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16842302,"change_date":"2025-11-05 21:40:00","inspection_id":"85499050","insp_unit_id":"209847909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"26345NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5J166K7900541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:01:59.000000Z","updated_at":"2025-11-09T10:00:07.000000Z"}]},{"id":8813098,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","dot_number":"2817223","report_state":"NY","report_number":"D012102211","insp_date":"2025-06-04 00:00:00","insp_start_time":"1142","insp_end_time":"1229","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HUNTINGTON STATION NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"88040","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1821024","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:03.000000Z","updated_at":"2025-06-09T10:00:25.000000Z","inspection_violations":[{"id":14104962,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655964","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H923KF1810","created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"39617CPI"},{"id":14104963,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655965","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H923KF17F8","created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"3922SLLIFTA"},{"id":14104964,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655966","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"H923KF17WL","created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"39375A3TAOL"},{"id":14104965,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655967","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"39378AWS"},{"id":14104966,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655968","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"39378"},{"id":14104967,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655969","seq_no":"7","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H923KF183X","created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"3963A1BALAC"},{"id":14104968,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_violation_id":"266655970","seq_no":"3","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"207218356","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-07T10:16:50.000000Z","updated_at":"2025-06-08T10:17:23.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":14427256,"change_date":"2025-06-04 21:41:00","inspection_id":"84860607","insp_unit_id":"207218356","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"83357NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKDX4TX0DJ350773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:14.000000Z","updated_at":"2025-06-08T09:45:33.000000Z"}]},{"id":8053341,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","dot_number":"2817223","report_state":"NY","report_number":"D012101907","insp_date":"2025-03-05 00:00:00","insp_start_time":"0910","insp_end_time":"0934","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","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":"U","pen_cen_match":"I","final_status_date":"2025-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"6","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":"1443009","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:26.000000Z","updated_at":"2025-03-17T21:05:26.000000Z","inspection_violations":[{"id":12586552,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_violation_id":"264888517","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205677792","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BHTG9","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39021TB1MC"},{"id":12586553,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_violation_id":"264888518","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"205677792","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BHVG9","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39021TB2DOT"},{"id":12586554,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_violation_id":"264888519","seq_no":"3","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"205677792","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BJ1G9","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39311A1LCHL"},{"id":12586555,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_violation_id":"264888520","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205677792","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BHWG9","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39378AWS"},{"id":12586556,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_violation_id":"264888521","seq_no":"5","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205677792","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BHXG9","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"3922SLLEQP"},{"id":12586557,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_violation_id":"264888522","seq_no":"6","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040BJ0G9","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":13002155,"change_date":"2025-03-07 21:38:00","inspection_id":"84059748","insp_unit_id":"205677792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"74829MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B2JS811949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:38.000000Z","updated_at":"2025-03-17T23:58:38.000000Z"}]},{"id":7648193,"change_date":"2025-01-17 21:39:00","inspection_id":"83634329","dot_number":"2817223","report_state":"NY","report_number":"0L95001351","insp_date":"2025-01-17 00:00:00","insp_start_time":"0830","insp_end_time":"0856","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-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1259767","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2025-01-17 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-17 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:01.000000Z","updated_at":"2025-03-17T20:57:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12340812,"change_date":"2025-01-17 21:39:00","inspection_id":"83634329","insp_unit_id":"204889086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"54206NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD8W3G6XEEB57344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:13.000000Z","updated_at":"2025-03-17T23:51:13.000000Z"}]},{"id":7484693,"change_date":"2024-12-23 21:39:00","inspection_id":"83462757","dot_number":"2817223","report_state":"NY","report_number":"0L78000648","insp_date":"2024-12-23 00:00:00","insp_start_time":"0943","insp_end_time":"1001","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FARMINGDALE 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":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1188763","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:18.000000Z","updated_at":"2025-03-17T20:52:18.000000Z","inspection_violations":[{"id":11700591,"change_date":"2024-12-23 21:39:00","inspection_id":"83462757","insp_violation_id":"263628577","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","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-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":12074998,"change_date":"2024-12-23 21:39:00","inspection_id":"83462757","insp_unit_id":"204526910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"69312ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5J168K7300801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:19.000000Z","updated_at":"2025-03-17T23:48:19.000000Z"}]},{"id":6910244,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","dot_number":"2817223","report_state":"NY","report_number":"D012101329","insp_date":"2024-10-08 00:00:00","insp_start_time":"0927","insp_end_time":"1011","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","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":"U","pen_cen_match":"I","final_status_date":"2024-10-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"12","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"924843","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2024-10-08 21:41:00","snet_input_date":"2024-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:14.000000Z","updated_at":"2025-03-17T20:40:14.000000Z","inspection_violations":[{"id":10768494,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238843","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7GG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39347E"},{"id":10768495,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238844","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"10040B7JG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39375A3"},{"id":10768496,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238845","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7HG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39353B"},{"id":10768497,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238846","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"10040B7PG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3963A1"},{"id":10768498,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238847","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7FG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39345D"},{"id":10768499,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238848","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"10040B7NG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3963A1"},{"id":10768500,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238849","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7LG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3939A"},{"id":10768501,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238850","seq_no":"8","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7BG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39021TB1"},{"id":10768502,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238851","seq_no":"9","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7DG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39311A1"},{"id":10768503,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238852","seq_no":"10","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"10040B7KG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39375A3"},{"id":10768504,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238853","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7MG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39617C"},{"id":10768505,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_violation_id":"262238854","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203312310","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7CG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11144623,"change_date":"2024-10-08 21:41:00","inspection_id":"82855389","insp_unit_id":"203312310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"75100NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHALCG37DX46685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"}]},{"id":6055033,"change_date":"2024-06-24 21:41:00","inspection_id":"81941851","dot_number":"2817223","report_state":"NY","report_number":"0L79000676","insp_date":"2024-06-18 00:00:00","insp_start_time":"0835","insp_end_time":"0858","registration_date":null,"region":"ED","ci_status_code":"C","location":"3052","location_desc":"FARMINGDALE 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":"2024-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"593541","transaction_code":"A","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2024-06-24 21:41:00","snet_input_date":"2024-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-24 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:39.000000Z","updated_at":"2025-03-17T20:22:39.000000Z","inspection_violations":[{"id":9392519,"change_date":"2024-06-24 21:41:00","inspection_id":"81941851","insp_violation_id":"260254316","seq_no":"1","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"201544858","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:25.000000Z","updated_at":"2025-03-17T21:51:25.000000Z","normalized_code":"39021TB2"},{"id":9392520,"change_date":"2024-06-24 21:41:00","inspection_id":"81941851","insp_violation_id":"260254317","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201544858","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:25.000000Z","updated_at":"2025-03-17T21:51:25.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9752563,"change_date":"2024-06-24 21:41:00","inspection_id":"81941851","insp_unit_id":"201544858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"47227ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZAANBW32CJ10196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:02.000000Z","updated_at":"2025-03-17T23:24:02.000000Z"}]},{"id":5530732,"change_date":"2024-04-17 21:41:00","inspection_id":"81372590","dot_number":"2817223","report_state":"NY","report_number":"0L80001046","insp_date":"2024-04-15 00:00:00","insp_start_time":"0801","insp_end_time":"0823","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SYOSSET 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":"2024-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17900","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":"405294","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2024-04-17 21:41:00","snet_input_date":"2024-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-17 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:21.000000Z","updated_at":"2025-03-17T20:12:21.000000Z","inspection_violations":[{"id":8545171,"change_date":"2024-04-17 21:41:00","inspection_id":"81372590","insp_violation_id":"258976342","seq_no":"1","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:25.000000Z","updated_at":"2025-03-17T21:47:25.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8908952,"change_date":"2024-04-17 21:41:00","inspection_id":"81372590","insp_unit_id":"200438031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"21173ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDE5C1E35F521037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:53.000000Z","updated_at":"2025-03-17T23:15:53.000000Z"}]},{"id":4502850,"change_date":"2023-11-28 21:41:00","inspection_id":"80248913","dot_number":"2817223","report_state":"NY","report_number":"0L98000043","insp_date":"2023-11-24 00:00:00","insp_start_time":"0847","insp_end_time":"0857","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SYOSSET NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"109190","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-11-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:10.000000Z","updated_at":"2025-03-17T19:52:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7242152,"change_date":"2023-11-28 21:41:00","inspection_id":"80248913","insp_unit_id":"198231580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"69312ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5J168K7300801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4417015,"change_date":"2023-11-14 21:41:00","inspection_id":"80154624","dot_number":"2817223","report_state":"NY","report_number":"0L55000023","insp_date":"2023-11-14 00:00:00","insp_start_time":"0755","insp_end_time":"0823","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":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","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":"95349","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2023-11-14 21:41:00","snet_input_date":"2023-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-14 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:20.000000Z","updated_at":"2025-03-17T19:50:20.000000Z","inspection_violations":[{"id":6835037,"change_date":"2023-11-14 21:41:00","inspection_id":"80154624","insp_violation_id":"256372453","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198041421","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"L144HDF38B","created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"39617CPI"},{"id":6835038,"change_date":"2023-11-14 21:41:00","inspection_id":"80154624","insp_violation_id":"256372454","seq_no":"2","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"198041421","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"39330B"},{"id":6835039,"change_date":"2023-11-14 21:41:00","inspection_id":"80154624","insp_violation_id":"256372455","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"198041421","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"39378AWS"},{"id":6835040,"change_date":"2023-11-14 21:41:00","inspection_id":"80154624","insp_violation_id":"256372456","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"198041421","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":7103667,"change_date":"2023-11-14 21:41:00","inspection_id":"80154624","insp_unit_id":"198041421","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"74829MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B2JS811949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"}]},{"id":4290349,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","dot_number":"2817223","report_state":"NY","report_number":"0L69000808","insp_date":"2023-10-25 00:00:00","insp_start_time":"1802","insp_end_time":"1926","registration_date":null,"region":"ET","ci_status_code":"C","location":"01427R","location_desc":"TOWN OF N. HEMPSTEAD LOT #4","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54500","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2882380","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:52.000000Z","updated_at":"2025-03-17T19:47:52.000000Z","inspection_violations":[{"id":6636849,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057084","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"PW88HBBHQV","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"39375G"},{"id":6636850,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057085","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"PW88HBBJKQ","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"39375G"},{"id":6636851,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057086","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3939A"},{"id":6636852,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057087","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"39311"},{"id":6636853,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057088","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88HBBJR9","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3922"},{"id":6636854,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057089","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88HBBJWG","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3922"},{"id":6636855,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057090","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88HBBK3Z","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3922"},{"id":6636856,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057091","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88HBBKB2","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3922"},{"id":6636857,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057092","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88HBBKDS","created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3922"},{"id":6636858,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_violation_id":"256057093","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197758023","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":6899888,"change_date":"2023-10-26 21:41:00","inspection_id":"80014471","insp_unit_id":"197758023","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"12399ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHALCG37DX46685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:50.000000Z","updated_at":"2025-03-17T22:57:50.000000Z"}]},{"id":3885787,"change_date":"2023-09-01 21:39:00","inspection_id":"79565730","dot_number":"2817223","report_state":"NY","report_number":"1021002242","insp_date":"2023-08-31 00:00:00","insp_start_time":"1029","insp_end_time":"1054","registration_date":null,"region":"ET","ci_status_code":"C","location":"00386","location_desc":"LEVITTOWN TRI COUNTY LOT","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MR PIPE PLUMBING AND HEATING CORP","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2864594","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:42.000000Z","updated_at":"2025-03-17T19:39:42.000000Z","inspection_violations":[{"id":6005684,"change_date":"2023-09-01 21:39:00","inspection_id":"79565730","insp_violation_id":"255038328","seq_no":"1","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:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39141A1"},{"id":6005685,"change_date":"2023-09-01 21:39:00","inspection_id":"79565730","insp_violation_id":"255038329","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196858166","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39395A"},{"id":6005686,"change_date":"2023-09-01 21:39:00","inspection_id":"79565730","insp_violation_id":"255038330","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196858166","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6247216,"change_date":"2023-09-01 21:39:00","inspection_id":"79565730","insp_unit_id":"196858166","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"69325ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5J166K7900541","insp_unit_decal":"Y","insp_unit_decal_number":"33074110","created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"}]},{"id":2754608,"change_date":"2023-04-07 21:38:00","inspection_id":"78292987","dot_number":"2817223","report_state":"NY","report_number":"SPL0191450","insp_date":"2023-04-05 00:00:00","insp_start_time":"1430","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":"00421R","location_desc":"GREAT RIVER","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":"N","pen_cen_match":null,"final_status_date":"2023-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2813674","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2023-04-07 21:38:00","snet_input_date":"2023-04-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:22.000000Z","updated_at":"2025-03-17T19:17:22.000000Z","inspection_violations":[{"id":4227738,"change_date":"2023-04-07 21:38:00","inspection_id":"78292987","insp_violation_id":"252097542","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194274029","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4433424,"change_date":"2023-04-07 21:38:00","inspection_id":"78292987","insp_unit_id":"194274029","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"69306ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B7HS807938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:54.000000Z","updated_at":"2025-03-17T22:37:54.000000Z"}]},{"id":2598851,"change_date":"2023-03-17 21:41:00","inspection_id":"78115507","dot_number":"2817223","report_state":"NY","report_number":"0L49000582","insp_date":"2023-03-16 00:00:00","insp_start_time":"1222","insp_end_time":"1253","registration_date":null,"region":"ET","ci_status_code":"C","location":"01171","location_desc":"FLORAL PARK, PLAINFIELD AVE","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2807216","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2023-03-17 21:41:00","snet_input_date":"2023-03-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-17 21:41:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"55 EVERGREEN STREET","insp_carrier_city":"WEST BABYLON","insp_carrier_state":"NY","insp_carrier_zip_code":"11704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:31.000000Z","updated_at":"2025-03-17T19:14:31.000000Z","inspection_violations":[{"id":3998348,"change_date":"2023-03-17 21:41:00","inspection_id":"78115507","insp_violation_id":"251721145","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193923519","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BG0337702","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"39395A"},{"id":3998349,"change_date":"2023-03-17 21:41:00","inspection_id":"78115507","insp_violation_id":"251721146","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193923519","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BG0337691","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"},{"id":3998350,"change_date":"2023-03-17 21:41:00","inspection_id":"78115507","insp_violation_id":"251721147","seq_no":"3","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":null,"created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4183000,"change_date":"2023-03-17 21:41:00","inspection_id":"78115507","insp_unit_id":"193923519","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"69306ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B7HS807938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"}]},{"id":2032696,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","dot_number":"2817223","report_state":"NY","report_number":"1021001338","insp_date":"2022-12-28 00:00:00","insp_start_time":"0902","insp_end_time":"0929","registration_date":null,"region":"ET","ci_status_code":"C","location":"00386","location_desc":"UNIONDALE NASSAU COLISEUM","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MR PIPE PLUMBING AND HEATING CORP","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"3","hazmat_oos_total":"2","snet_sequence_id":"2783563","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-12-29 21:39:00","snet_input_date":"2022-12-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-29 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:02.000000Z","updated_at":"2025-03-17T19:04:02.000000Z","inspection_violations":[{"id":3151367,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","insp_violation_id":"250304943","seq_no":"1","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"192619978","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"177817A"},{"id":3151368,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","insp_violation_id":"250304944","seq_no":"2","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"192619978","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"172602C1"},{"id":3151369,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","insp_violation_id":"250304945","seq_no":"4","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"192619978","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"177834A"},{"id":3151370,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","insp_violation_id":"250304946","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192619978","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"39395A"},{"id":3151371,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","insp_violation_id":"250304947","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192619978","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3270257,"change_date":"2022-12-29 21:39:00","inspection_id":"77468968","insp_unit_id":"192619978","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"69325ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5J166K7900541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:25.000000Z","updated_at":"2025-03-17T22:29:25.000000Z"}]},{"id":1857222,"change_date":"2022-12-02 21:40:00","inspection_id":"77268583","dot_number":"2817223","report_state":"NY","report_number":"SPWL051232","insp_date":"2022-11-29 00:00:00","insp_start_time":"1147","insp_end_time":"1223","registration_date":null,"region":"ET","ci_status_code":"C","location":"01185","location_desc":"FREEPORT-RT 27","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MR PIPE PLUMBING AND HEATING CORP","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-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2775653","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-12-02 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-02 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:47.000000Z","updated_at":"2025-03-17T19:00:47.000000Z","inspection_violations":[{"id":2894177,"change_date":"2022-12-02 21:40:00","inspection_id":"77268583","insp_violation_id":"249883853","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192225544","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5G53LWD","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3922"},{"id":2894178,"change_date":"2022-12-02 21:40:00","inspection_id":"77268583","insp_violation_id":"249883854","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":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39141A"},{"id":2894179,"change_date":"2022-12-02 21:40:00","inspection_id":"77268583","insp_violation_id":"249883855","seq_no":"3","part_no":"383","part_no_section":"25(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"38325A1"},{"id":2894180,"change_date":"2022-12-02 21:40:00","inspection_id":"77268583","insp_violation_id":"249883856","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2988386,"change_date":"2022-12-02 21:40:00","inspection_id":"77268583","insp_unit_id":"192225544","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"12624ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAM0EH468366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"}]},{"id":1525889,"change_date":"2022-10-17 21:40:00","inspection_id":"76888356","dot_number":"2817223","report_state":"NY","report_number":"0L88000221","insp_date":"2022-10-14 00:00:00","insp_start_time":"0744","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"LIE@EXIT48 PLV","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MR PIPE PLUMBING AND HEATING CORP","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":"I","final_status_date":"2022-10-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"2759613","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-10-17 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-17 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:49.000000Z","updated_at":"2025-03-17T18:54:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2455154,"change_date":"2022-10-17 21:40:00","inspection_id":"76888356","insp_unit_id":"191464361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"69308ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W161J7K00710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:50.000000Z","updated_at":"2025-03-17T22:23:50.000000Z"}]},{"id":1525941,"change_date":"2022-10-17 21:40:00","inspection_id":"76888415","dot_number":"2817223","report_state":"NY","report_number":"0L82000226","insp_date":"2022-10-14 00:00:00","insp_start_time":"0808","insp_end_time":"0811","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LIE WB EXIT 44 (SYOSSET)","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MR PIPE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-10-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2759579","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-10-17 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-17 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:49.000000Z","updated_at":"2025-03-17T18:54:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2455210,"change_date":"2022-10-17 21:40:00","inspection_id":"76888415","insp_unit_id":"191464427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"74829MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B2JS811949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:50.000000Z","updated_at":"2025-03-17T22:23:50.000000Z"}]},{"id":1525966,"change_date":"2022-10-17 21:40:00","inspection_id":"76888445","dot_number":"2817223","report_state":"NY","report_number":"1019007634","insp_date":"2022-10-14 00:00:00","insp_start_time":"0952","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"00386","location_desc":"UNIONDALE NASSAU COLISEUM","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2759569","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-10-17 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-17 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:49.000000Z","updated_at":"2025-03-17T18:54:49.000000Z","inspection_violations":[{"id":2402518,"change_date":"2022-10-17 21:40:00","inspection_id":"76888445","insp_violation_id":"249056673","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"191464466","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:09.000000Z","updated_at":"2025-03-17T21:18:09.000000Z","normalized_code":"39021TA"},{"id":2402519,"change_date":"2022-10-17 21:40:00","inspection_id":"76888445","insp_violation_id":"249056674","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191464466","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:09.000000Z","updated_at":"2025-03-17T21:18:09.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2455240,"change_date":"2022-10-17 21:40:00","inspection_id":"76888445","insp_unit_id":"191464466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"57308MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3G3CG3D1194367","insp_unit_decal":"Y","insp_unit_decal_number":"32008804","created_at":"2025-03-17T22:23:50.000000Z","updated_at":"2025-03-17T22:23:50.000000Z"}]},{"id":1443367,"change_date":"2022-10-05 21:40:00","inspection_id":"76792732","dot_number":"2817223","report_state":"NY","report_number":"0L81000332","insp_date":"2022-10-04 00:00:00","insp_start_time":"1132","insp_end_time":"1143","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"N\/B RT 135 EXIT 14W SYOSSET","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2755860","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-10-05 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-05 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:23.000000Z","updated_at":"2025-03-17T18:53:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2323440,"change_date":"2022-10-05 21:40:00","inspection_id":"76792732","insp_unit_id":"191273771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"70121NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT2HED89323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"}]},{"id":1351993,"change_date":"2022-09-23 21:37:00","inspection_id":"76687050","dot_number":"2817223","report_state":"NY","report_number":"0L78000134","insp_date":"2022-09-22 00:00:00","insp_start_time":"0750","insp_end_time":"0804","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"RT 135 N\/B EXIT 13W","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-09-23 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2752158","transaction_code":"A","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-09-23 21:37:00","snet_input_date":"2022-09-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-23 21:37:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:38.000000Z","updated_at":"2025-03-17T18:51:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2176787,"change_date":"2022-09-23 21:37:00","inspection_id":"76687050","insp_unit_id":"191060816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"69306ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B7HS807938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:54.000000Z","updated_at":"2025-03-17T22:21:54.000000Z"}]},{"id":635186,"change_date":"2022-06-17 21:39:00","inspection_id":"75850004","dot_number":"2817223","report_state":"NY","report_number":"SPWL071265","insp_date":"2022-06-15 00:00:00","insp_start_time":"1005","insp_end_time":"1025","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":"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-06-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2717187","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-06-17 21:39:00","snet_input_date":"2022-06-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-17 21:39:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:50.000000Z","updated_at":"2025-03-17T18:38:50.000000Z","inspection_violations":[{"id":998517,"change_date":"2022-06-17 21:39:00","inspection_id":"75850004","insp_violation_id":"246542624","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:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3922"},{"id":998518,"change_date":"2022-06-17 21:39:00","inspection_id":"75850004","insp_violation_id":"246542625","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"189314201","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":1020935,"change_date":"2022-06-17 21:39:00","inspection_id":"75850004","insp_unit_id":"189314201","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"57308MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3G3CG3D1194367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:28.000000Z","updated_at":"2025-03-17T22:14:28.000000Z"}]},{"id":498851,"change_date":"2022-05-27 21:40:00","inspection_id":"75687848","dot_number":"2817223","report_state":"NY","report_number":"0L88000038","insp_date":"2022-05-26 00:00:00","insp_start_time":"0811","insp_end_time":"0816","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"SOB EXPWY EXIT 13","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MR PIPE PLUMBING","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":"I","final_status_date":"2022-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2711704","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02817223","upload_search_indicator":"M","census_search_date":"2022-05-27 21:40:00","snet_input_date":"2022-05-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-27 21:40:00","insp_carrier_name":"MR PIPE PLUMBING AND HEATING CORP","insp_carrier_street":"147 SUNRISE HIGHWAY","insp_carrier_city":"AMITYVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"11701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:23.000000Z","updated_at":"2025-03-17T18:36:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":802248,"change_date":"2022-05-27 21:40:00","inspection_id":"75687848","insp_unit_id":"188952555","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"74829MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B2JS811949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2817223\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2817223\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2817223\/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\/2817223\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}