{"current_page":1,"data":[{"id":12430541,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","dot_number":"2847087","report_state":"NY","report_number":"D304300994","insp_date":"2026-07-06 00:00:00","insp_start_time":"0945","insp_end_time":"1042","registration_date":"2026-07-29 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"CLAY NY","county_code_state":"NY","county_code":"067","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"84500","viol_total":"6","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3737100","transaction_code":"C","transaction_date":"2026-07-12 00:00:00","upload_date":"2026-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2026-07-13 21:39:00","snet_input_date":"2026-07-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-13 21:39:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-16T09:40:21.000000Z","updated_at":"2026-08-27T09:33:29.000000Z","inspection_violations":[{"id":21639532,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_violation_id":"276236640","seq_no":"3","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T09:59:48.000000Z","updated_at":"2026-08-27T09:45:34.000000Z","normalized_code":"3922WG"},{"id":21639533,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_violation_id":"276236641","seq_no":"4","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T09:59:48.000000Z","updated_at":"2026-08-27T09:45:34.000000Z","normalized_code":"3922WG"},{"id":21639530,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_violation_id":"276236638","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"215249197","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T09:59:48.000000Z","updated_at":"2026-08-27T09:45:34.000000Z","normalized_code":"3922SLLIFTA"},{"id":21639531,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_violation_id":"276236639","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215249197","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3886LTCFNL","created_at":"2026-07-16T09:59:48.000000Z","updated_at":"2026-08-27T09:45:34.000000Z","normalized_code":"3922SLLSR"},{"id":21639534,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_violation_id":"276236642","seq_no":"5","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T09:59:48.000000Z","updated_at":"2026-08-27T09:45:34.000000Z","normalized_code":"3922WG"},{"id":21639535,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_violation_id":"276236643","seq_no":"6","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"215249197","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3886LTCF7D","created_at":"2026-07-16T09:59:48.000000Z","updated_at":"2026-08-27T09:45:34.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":21593493,"change_date":"2026-08-20 21:49:00","inspection_id":"88389484","insp_unit_id":"215249197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"RD22","insp_unit_license":"45028NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NK1X4TX6SJ178166","insp_unit_decal":"Y","insp_unit_decal_number":"36697714","created_at":"2026-07-16T09:16:26.000000Z","updated_at":"2026-08-27T09:06:38.000000Z"}]},{"id":12106237,"change_date":"2026-06-05 21:37:00","inspection_id":"88050827","dot_number":"2847087","report_state":"NY","report_number":"SPD4090059","insp_date":"2026-05-29 00:00:00","insp_start_time":"1310","insp_end_time":"1328","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CLAY NY","county_code_state":"NY","county_code":"067","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-06-05 21:37:00","post_acc_ind":"Y","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3473502","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2026-06-05 21:37:00","snet_input_date":"2026-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-05 21:37:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-08T09:41:02.000000Z","updated_at":"2026-06-16T09:33:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21034495,"change_date":"2026-06-05 21:37:00","inspection_id":"88050827","insp_unit_id":"213930046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"11067NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LU0X73D802648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-08T09:18:13.000000Z","updated_at":"2026-06-16T09:05:27.000000Z"}]},{"id":11824979,"change_date":"2026-05-05 21:39:00","inspection_id":"87759701","dot_number":"2847087","report_state":"NY","report_number":"SPT3101525","insp_date":"2026-04-28 00:00:00","insp_start_time":"1742","insp_end_time":"1751","registration_date":null,"region":"ED","ci_status_code":"C","location":"22058M","location_desc":"UTICA NY","county_code_state":"NY","county_code":"065","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":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"84500","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":"3260103","transaction_code":"A","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:26.000000Z","updated_at":"2026-05-15T12:18:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20566473,"change_date":"2026-05-05 21:39:00","inspection_id":"87759701","insp_unit_id":"213382625","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"RD22","insp_unit_license":"45028NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NK1X4TX6SJ178166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:15.000000Z","updated_at":"2026-05-15T11:57:30.000000Z"}]},{"id":10514832,"change_date":"2025-12-25 21:32:00","inspection_id":"86650222","dot_number":"2847087","report_state":"NY","report_number":"SPD4080002","insp_date":"2025-12-18 00:00:00","insp_start_time":"1437","insp_end_time":"1459","registration_date":"2025-12-18 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"JAMESVILLE NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-25 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2697188","transaction_code":"A","transaction_date":"2025-12-24 00:00:00","upload_date":"2025-12-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-12-25 21:32:00","snet_input_date":"2025-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-25 21:32:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-28T10:37:40.000000Z","updated_at":"2026-01-05T10:30:04.000000Z","inspection_violations":[{"id":17653267,"change_date":"2025-12-25 21:32:00","inspection_id":"86650222","insp_violation_id":"270890402","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-28T10:43:01.000000Z","updated_at":"2026-01-05T10:30:08.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":17609185,"change_date":"2025-12-25 21:32:00","inspection_id":"86650222","insp_unit_id":"210796244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"RD-15","insp_unit_license":"81071ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWLB0X3XJ830274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-28T10:08:18.000000Z","updated_at":"2026-01-05T10:00:07.000000Z"}]},{"id":10100284,"change_date":"2025-11-25 21:38:00","inspection_id":"86215805","dot_number":"2847087","report_state":"NY","report_number":"SPT3101048","insp_date":"2025-10-27 00:00:00","insp_start_time":"0715","insp_end_time":"0727","registration_date":"2025-11-24 00:00:00","region":"ED","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","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":"2025-11-02 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","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":"2492048","transaction_code":"C","transaction_date":"2025-11-02 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-11-02 21:33:00","snet_input_date":"2025-10-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-02 21:33:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-06T10:30:20.000000Z","updated_at":"2025-11-29T10:30:19.000000Z","inspection_violations":[{"id":17191657,"change_date":"2025-11-25 21:38:00","inspection_id":"86215805","insp_violation_id":"270282516","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210252109","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:33.000000Z","updated_at":"2025-11-29T10:30:19.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":17167402,"change_date":"2025-11-25 21:38:00","inspection_id":"86215805","insp_unit_id":"210252109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"RD17","insp_unit_license":"75873NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPFLBTX47N636741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:31.000000Z","updated_at":"2025-11-29T10:00:25.000000Z"}]},{"id":9932561,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","dot_number":"2847087","report_state":"NY","report_number":"SPD3061091","insp_date":"2025-10-03 00:00:00","insp_start_time":"1041","insp_end_time":"1036","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ROME NY","county_code_state":"NY","county_code":"065","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"REAL DEAL LANDSCAPING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-14 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"169000","viol_total":"24","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2405374","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:30.000000Z","updated_at":"2025-11-26T10:31:22.000000Z","inspection_violations":[{"id":17154479,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234241","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39311A1CSLRR"},{"id":17154480,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234242","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3922SLLEQP"},{"id":17154481,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234243","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3922SLLEQP"},{"id":17154482,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234244","seq_no":"4","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3965BHWSL"},{"id":17154483,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234245","seq_no":"5","part_no":"399","part_no_section":"211-CBP","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"399211CBP"},{"id":17154484,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234246","seq_no":"6","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39348ABIBD"},{"id":17154485,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234247","seq_no":"7","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39311A1LIL"},{"id":17154486,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234248","seq_no":"8","part_no":"393","part_no_section":"11A1-LSLM","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39311A1LSLM"},{"id":17154487,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234249","seq_no":"9","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39311A1LSML"},{"id":17154488,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234250","seq_no":"10","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39311A1LCL"},{"id":17154489,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234251","seq_no":"11","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39383G"},{"id":17154490,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234252","seq_no":"12","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3939ALCL"},{"id":17154491,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234253","seq_no":"13","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3939ALIL"},{"id":17154492,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234254","seq_no":"14","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3939ALRLI"},{"id":17154493,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234255","seq_no":"15","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3939ALSML"},{"id":17154494,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234256","seq_no":"16","part_no":"396","part_no_section":"3A1-CDFWC-MT20","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3963A1CDFWCMT20"},{"id":17154495,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234257","seq_no":"17","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3963A1TAOCV"},{"id":17154496,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234258","seq_no":"18","part_no":"393","part_no_section":"201A-VFC","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"393201AVFC"},{"id":17154497,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234259","seq_no":"19","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"393203CCBP"},{"id":17154498,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234260","seq_no":"20","part_no":"393","part_no_section":"207C-SBML","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"393207CSBML"},{"id":17154499,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234261","seq_no":"21","part_no":"393","part_no_section":"60B","insp_viol_unit":"1","insp_unit_id":"210213658","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39360B"},{"id":17154500,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234262","seq_no":"22","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"39311A1LTSM"},{"id":17154501,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234263","seq_no":"23","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"210213659","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"393207FSDAS"},{"id":17154502,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_violation_id":"270234264","seq_no":"24","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:51.000000Z","updated_at":"2025-11-26T10:37:41.000000Z","normalized_code":"3922SLLEWG2"}],"inspection_per_units":[{"id":17133226,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_unit_id":"210213658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"12996BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB9X4TN414166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:34.000000Z","updated_at":"2025-11-26T10:01:42.000000Z"},{"id":17133227,"change_date":"2025-11-22 21:50:00","inspection_id":"86038565","insp_unit_id":"210213659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC TRAILE","insp_unit_company":"T10","insp_unit_license":"CH74605","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3641GC036081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:34.000000Z","updated_at":"2025-11-26T10:01:42.000000Z"}]},{"id":8976844,"change_date":"2025-06-25 21:39:00","inspection_id":"85034494","dot_number":"2847087","report_state":"NY","report_number":"SPD4000099","insp_date":"2025-06-18 00:00:00","insp_start_time":"1122","insp_end_time":"1142","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CICERO NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"79200","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":"1910523","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:59.000000Z","updated_at":"2025-06-30T10:00:11.000000Z","inspection_violations":[{"id":14428807,"change_date":"2025-06-25 21:39:00","inspection_id":"85034494","insp_violation_id":"267026730","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207538270","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:46.000000Z","updated_at":"2025-06-29T10:15:18.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14718598,"change_date":"2025-06-25 21:39:00","inspection_id":"85034494","insp_unit_id":"207538270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"RD19","insp_unit_license":"11067NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LU0X73D802648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:09.000000Z","updated_at":"2025-06-29T09:45:18.000000Z"}]},{"id":8601106,"change_date":"2025-05-12 21:40:00","inspection_id":"84636759","dot_number":"2847087","report_state":"NY","report_number":"SPD3050689","insp_date":"2025-05-06 00:00:00","insp_start_time":"0752","insp_end_time":"0821","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1714757","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-05-12 21:40:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:02.000000Z","updated_at":"2025-05-17T10:04:02.000000Z","inspection_violations":[{"id":13666671,"change_date":"2025-05-12 21:40:00","inspection_id":"84636759","insp_violation_id":"266151717","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206798304","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D35K9WVXX","created_at":"2025-05-15T10:17:55.000000Z","updated_at":"2025-05-16T10:21:44.000000Z","normalized_code":"39395A1"},{"id":13666672,"change_date":"2025-05-12 21:40:00","inspection_id":"84636759","insp_violation_id":"266151718","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206798304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:17:55.000000Z","updated_at":"2025-05-16T10:21:44.000000Z","normalized_code":"3939ALIL"},{"id":13666673,"change_date":"2025-05-12 21:40:00","inspection_id":"84636759","insp_violation_id":"266151719","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"206798304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:17:55.000000Z","updated_at":"2025-05-16T10:21:44.000000Z","normalized_code":"3939ALCL"},{"id":13666674,"change_date":"2025-05-12 21:40:00","inspection_id":"84636759","insp_violation_id":"266151720","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"206798304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:17:55.000000Z","updated_at":"2025-05-16T10:21:44.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":14041251,"change_date":"2025-05-12 21:40:00","inspection_id":"84636759","insp_unit_id":"206798304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"RD-15","insp_unit_license":"81071ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWLB0X3XJ830274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:09.000000Z","updated_at":"2025-05-16T09:49:13.000000Z"}]},{"id":8435814,"change_date":"2025-04-22 21:40:00","inspection_id":"84462632","dot_number":"2847087","report_state":"NY","report_number":"SPD4000077","insp_date":"2025-04-15 00:00:00","insp_start_time":"1152","insp_end_time":"1216","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DEWITT NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68750","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":"1626598","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-04-22 21:40:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:40:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:26:27.000000Z","updated_at":"2025-04-26T10:26:27.000000Z","inspection_violations":[{"id":13319882,"change_date":"2025-04-22 21:40:00","inspection_id":"84462632","insp_violation_id":"265754269","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"206426413","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:45:31.000000Z","updated_at":"2025-04-25T10:52:48.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":13698838,"change_date":"2025-04-22 21:40:00","inspection_id":"84462632","insp_unit_id":"206426413","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"RD-15","insp_unit_license":"81071ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWLB0X3XJ830274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:05:29.000000Z","updated_at":"2025-04-26T09:52:03.000000Z"}]},{"id":8050133,"change_date":"2025-03-07 21:38:00","inspection_id":"84056348","dot_number":"2847087","report_state":"NY","report_number":"SPD4060078","insp_date":"2025-02-28 00:00:00","insp_start_time":"1330","insp_end_time":"1402","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"EAST SYRACUSE NY","county_code_state":"NY","county_code":"067","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-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"72500","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":"1439736","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":"02847087","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:25.000000Z","updated_at":"2025-03-17T21:05:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12996837,"change_date":"2025-03-07 21:38:00","inspection_id":"84056348","insp_unit_id":"205671849","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"71274ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBTX45N874775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:35.000000Z","updated_at":"2025-03-17T23:58:35.000000Z"}]},{"id":7974735,"change_date":"2025-02-27 21:40:00","inspection_id":"83977185","dot_number":"2847087","report_state":"NY","report_number":"SPE3080282","insp_date":"2025-02-20 00:00:00","insp_start_time":"1140","insp_end_time":"1202","registration_date":null,"region":"ES","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","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":"2025-02-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"1405461","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-02-27 21:40:00","snet_input_date":"2025-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-27 21:40:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:40.000000Z","updated_at":"2025-03-17T21:03:40.000000Z","inspection_violations":[{"id":12461296,"change_date":"2025-02-27 21:40:00","inspection_id":"83977185","insp_violation_id":"264728033","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:06:55.000000Z","updated_at":"2025-03-17T22:06:55.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":12874056,"change_date":"2025-02-27 21:40:00","inspection_id":"83977185","insp_unit_id":"205526717","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"RD21","insp_unit_license":"12996BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB9X4TN414166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"},{"id":12874057,"change_date":"2025-02-27 21:40:00","inspection_id":"83977185","insp_unit_id":"205526718","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC TRAILE","insp_unit_company":"T10","insp_unit_license":"CH74605","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3641GC036081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"}]},{"id":7733773,"change_date":"2025-01-29 21:40:00","inspection_id":"83724069","dot_number":"2847087","report_state":"NY","report_number":"SPT3090400","insp_date":"2025-01-22 00:00:00","insp_start_time":"1146","insp_end_time":"1154","registration_date":null,"region":"ES","ci_status_code":"C","location":"20895M","location_desc":"WESTMORELAND NY","county_code_state":"NY","county_code":"065","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":"2025-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1298339","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:43.000000Z","updated_at":"2025-03-17T20:58:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12480280,"change_date":"2025-01-29 21:40:00","inspection_id":"83724069","insp_unit_id":"205054613","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"81071ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWLB0X3XJ830274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:43.000000Z","updated_at":"2025-03-17T23:52:43.000000Z"}]},{"id":7280964,"change_date":"2024-11-26 21:40:00","inspection_id":"83248335","dot_number":"2847087","report_state":"NY","report_number":"SPT3030605","insp_date":"2024-11-19 00:00:00","insp_start_time":"0910","insp_end_time":"0930","registration_date":null,"region":"ES","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","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":"2024-11-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","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":"1093683","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2024-11-26 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-26 21:40:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:07.000000Z","updated_at":"2025-03-17T20:48:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11744466,"change_date":"2024-11-26 21:40:00","inspection_id":"83248335","insp_unit_id":"204057244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"RD-18","insp_unit_license":"71274ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBTX45N874775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":6006051,"change_date":"2024-06-17 21:43:00","inspection_id":"81889058","dot_number":"2847087","report_state":"NY","report_number":"SPT0442415","insp_date":"2024-06-14 00:00:00","insp_start_time":"0735","insp_end_time":"0759","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854A","location_desc":"VERONA (EXIT 33)","county_code_state":"NY","county_code":"065","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":"2024-06-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2930467","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2024-06-17 21:43:00","snet_input_date":"2024-06-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9673511,"change_date":"2024-06-17 21:43:00","inspection_id":"81889058","insp_unit_id":"201423839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RD15","insp_unit_license":"81071ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWLB0X3XJ830274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:15.000000Z","updated_at":"2025-03-17T23:23:15.000000Z"}]},{"id":5662884,"change_date":"2024-05-03 21:38:00","inspection_id":"81516433","dot_number":"2847087","report_state":"NY","report_number":"SPT0580096","insp_date":"2024-05-02 00:00:00","insp_start_time":"1018","insp_end_time":"1037","registration_date":null,"region":"ET","ci_status_code":"C","location":"20802R","location_desc":"HERKIMER INTERCHANGE","county_code_state":"NY","county_code":"043","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"REAL DEAL LANDSCAPING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"2921453","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2024-05-03 21:38:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-03 21:38:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:03.000000Z","updated_at":"2025-03-17T20:15:03.000000Z","inspection_violations":[{"id":8759865,"change_date":"2024-05-03 21:38:00","inspection_id":"81516433","insp_violation_id":"259301135","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200713729","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3922"},{"id":8759866,"change_date":"2024-05-03 21:38:00","inspection_id":"81516433","insp_violation_id":"259301136","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"200713728","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":9120669,"change_date":"2024-05-03 21:38:00","inspection_id":"81516433","insp_unit_id":"200713728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"53329NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GT02REG8GZ339809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:53.000000Z","updated_at":"2025-03-17T23:17:53.000000Z"},{"id":9120670,"change_date":"2024-05-03 21:38:00","inspection_id":"81516433","insp_unit_id":"200713729","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BF87371","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"43YDC1629DC100218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:53.000000Z","updated_at":"2025-03-17T23:17:53.000000Z"}]},{"id":5531901,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","dot_number":"2847087","report_state":"NY","report_number":"SPD0292001","insp_date":"2024-04-16 00:00:00","insp_start_time":"0902","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"20574","location_desc":"NEW HARTFORD","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2917625","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":"02847087","upload_search_indicator":"M","census_search_date":"2024-04-17 21:41:00","snet_input_date":"2024-04-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-17 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","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":8547255,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979718","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"200440436","insp_violation_category_id":"30","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":"39021B"},{"id":8547256,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979719","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200440436","insp_violation_category_id":"28","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":"39395A"},{"id":8547257,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979720","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200440436","insp_violation_category_id":"28","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":"39395F"},{"id":8547258,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979721","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200440436","insp_violation_category_id":"20","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":"3939A"},{"id":8547259,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979722","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200440436","insp_violation_category_id":"20","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":"3939A"},{"id":8547260,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979723","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200440437","insp_violation_category_id":"51","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":"3922"},{"id":8547261,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979724","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200440437","insp_violation_category_id":"29","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":"39617C"},{"id":8547262,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_violation_id":"258979725","seq_no":"8","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"200440437","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:25.000000Z","updated_at":"2025-03-17T21:47:25.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":8910667,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_unit_id":"200440436","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"39043MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRTAJ4MG673189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:56.000000Z","updated_at":"2025-03-17T23:15:56.000000Z"},{"id":8910668,"change_date":"2024-04-17 21:41:00","inspection_id":"81373875","insp_unit_id":"200440437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"CC10247","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JWY8182XNY023294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:56.000000Z","updated_at":"2025-03-17T23:15:56.000000Z"}]},{"id":5201069,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","dot_number":"2847087","report_state":"NY","report_number":"SPD0291935","insp_date":"2024-03-01 00:00:00","insp_start_time":"0709","insp_end_time":"0732","registration_date":null,"region":"ET","ci_status_code":"C","location":"20223","location_desc":"DEERFIELD","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2910141","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"133244114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:43.000000Z","updated_at":"2025-03-17T20:05:43.000000Z","inspection_violations":[{"id":8018393,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_violation_id":"258182226","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199733713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"3939A"},{"id":8018394,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_violation_id":"258182227","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199733713","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"3922"},{"id":8018395,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_violation_id":"258182228","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"199733713","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39021B"},{"id":8018396,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_violation_id":"258182229","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199733713","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39395A"},{"id":8018397,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_violation_id":"258182230","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199733713","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39395F"},{"id":8018398,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_violation_id":"258182231","seq_no":"6","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"199733713","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8374501,"change_date":"2024-03-04 21:41:00","inspection_id":"81012539","insp_unit_id":"199733713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"39043MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRTAJ4MG673189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:51.000000Z","updated_at":"2025-03-17T23:10:51.000000Z"}]},{"id":4515712,"change_date":"2023-11-29 21:42:00","inspection_id":"80263039","dot_number":"2847087","report_state":"NY","report_number":"SPD0281213","insp_date":"2023-11-28 00:00:00","insp_start_time":"0855","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"20757","location_desc":"SCHUYLER","county_code_state":"NY","county_code":"043","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"REAL DEAL LANDSCAPING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2889772","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2023-11-29 21:42:00","snet_input_date":"2023-11-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-29 21:42:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:14.000000Z","updated_at":"2025-03-17T19:52:14.000000Z","inspection_violations":[{"id":6987671,"change_date":"2023-11-29 21:42:00","inspection_id":"80263039","insp_violation_id":"256611644","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198258208","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6HFX1J8","created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"},{"id":6987672,"change_date":"2023-11-29 21:42:00","inspection_id":"80263039","insp_violation_id":"256611645","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198258208","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6HFX1TF","created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"},{"id":6987673,"change_date":"2023-11-29 21:42:00","inspection_id":"80263039","insp_violation_id":"256611646","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198258208","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"},{"id":6987674,"change_date":"2023-11-29 21:42:00","inspection_id":"80263039","insp_violation_id":"256611647","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198258208","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7262442,"change_date":"2023-11-29 21:42:00","inspection_id":"80263039","insp_unit_id":"198258208","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"RD-17","insp_unit_license":"71198ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPFLBTX47N636741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:00.000000Z","updated_at":"2025-03-17T23:01:00.000000Z"}]},{"id":4358813,"change_date":"2023-11-08 21:40:00","inspection_id":"80089970","dot_number":"2847087","report_state":"NY","report_number":"SPD0281137","insp_date":"2023-11-02 00:00:00","insp_start_time":"0804","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854","location_desc":"VERONA","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"REAL DEAL LANDSCAPING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2884700","transaction_code":"C","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":null,"census_search_date":"2023-11-06 21:41:00","snet_input_date":"2023-11-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-06 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:10.000000Z","updated_at":"2025-03-17T19:49:10.000000Z","inspection_violations":[{"id":6743488,"change_date":"2023-11-08 21:40:00","inspection_id":"80089970","insp_violation_id":"256284484","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197963371","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3922"},{"id":6743489,"change_date":"2023-11-08 21:40:00","inspection_id":"80089970","insp_violation_id":"256284485","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197963371","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"39617C"},{"id":6743490,"change_date":"2023-11-08 21:40:00","inspection_id":"80089970","insp_violation_id":"256284486","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"197963371","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"39021B"},{"id":6743491,"change_date":"2023-11-08 21:40:00","inspection_id":"80089970","insp_violation_id":"256284487","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"197963371","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":7010071,"change_date":"2023-11-08 21:40:00","inspection_id":"80089970","insp_unit_id":"197963371","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"71198ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPFLBTX47N636741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:51.000000Z","updated_at":"2025-03-17T22:58:51.000000Z"}]},{"id":4120166,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","dot_number":"2847087","report_state":"NY","report_number":"SPD0235127","insp_date":"2023-10-03 00:00:00","insp_start_time":"1241","insp_end_time":"1327","registration_date":null,"region":"ET","ci_status_code":"C","location":"20639","location_desc":"PARIS","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2875360","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2023-10-04 21:40:00","snet_input_date":"2023-10-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-04 21:40:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:24.000000Z","updated_at":"2025-03-17T19:44:24.000000Z","inspection_violations":[{"id":6376218,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642716","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39021B"},{"id":6376219,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642717","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39617C"},{"id":6376220,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642718","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39311"},{"id":6376221,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642719","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"3939A"},{"id":6376222,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642720","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"3922"},{"id":6376223,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642721","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39375C"},{"id":6376224,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_violation_id":"255642722","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197384583","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9H7ZCGB","created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6624269,"change_date":"2023-10-04 21:40:00","inspection_id":"79826407","insp_unit_id":"197384583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"RD17","insp_unit_license":"71198ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPFLBTX47N636741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:33.000000Z","updated_at":"2025-03-17T22:55:33.000000Z"}]},{"id":3762263,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","dot_number":"2847087","report_state":"NY","report_number":"SP3T200421","insp_date":"2023-08-16 00:00:00","insp_start_time":"0940","insp_end_time":"1001","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"REAL DEAL LANDSCAPING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2859301","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2023-08-17 21:42:00","snet_input_date":"2023-08-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:15.000000Z","updated_at":"2025-03-17T19:37:15.000000Z","inspection_violations":[{"id":5802418,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_violation_id":"254701717","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196573755","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"39617C"},{"id":5802419,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_violation_id":"254701718","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196573755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3922"},{"id":5802420,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_violation_id":"254701719","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196573755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0H2TB53","created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3939A"},{"id":5802421,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_violation_id":"254701720","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196573755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0H2TBBD","created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3939A"},{"id":5802422,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_violation_id":"254701721","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196573755","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"39345B2"},{"id":5802423,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_violation_id":"254701722","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196573755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:55.000000Z","updated_at":"2025-03-17T21:33:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6049300,"change_date":"2023-08-17 21:42:00","inspection_id":"79427528","insp_unit_id":"196573755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"71198ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPFLBTX47N636741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3692602,"change_date":"2023-08-08 21:41:00","inspection_id":"79350216","dot_number":"2847087","report_state":"NY","report_number":"SPD0261483","insp_date":"2023-08-07 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56500","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":"2856017","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2023-08-08 21:41:00","snet_input_date":"2023-08-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-08 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:42.000000Z","updated_at":"2025-03-17T19:35:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5936926,"change_date":"2023-08-08 21:41:00","inspection_id":"79350216","insp_unit_id":"196416665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"71197ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKDLU0X55J088279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:54.000000Z","updated_at":"2025-03-17T22:49:54.000000Z"}]},{"id":3112353,"change_date":"2023-05-23 21:41:00","inspection_id":"78697235","dot_number":"2847087","report_state":"NY","report_number":"SPT0334073","insp_date":"2023-05-22 00:00:00","insp_start_time":"0921","insp_end_time":"0938","registration_date":null,"region":"ET","ci_status_code":"C","location":"30739A","location_desc":"SALINA (EXIT 36)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"H AND B BRIDGE CONSTRUCTION","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"63983","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":"2828365","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2023-05-23 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-23 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:36.000000Z","updated_at":"2025-03-17T19:24:36.000000Z","inspection_violations":[{"id":4790491,"change_date":"2023-05-23 21:41:00","inspection_id":"78697235","insp_violation_id":"253005188","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195078810","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5006261,"change_date":"2023-05-23 21:41:00","inspection_id":"78697235","insp_unit_id":"195078810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RD-14","insp_unit_license":"71197ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKDLU0X55J088279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:28.000000Z","updated_at":"2025-03-17T22:42:28.000000Z"}]},{"id":3112542,"change_date":"2023-05-23 21:41:00","inspection_id":"78697449","dot_number":"2847087","report_state":"NY","report_number":"SP3T200114","insp_date":"2023-05-22 00:00:00","insp_start_time":"0821","insp_end_time":"0836","registration_date":null,"region":"ET","ci_status_code":"C","location":"30739A","location_desc":"SALINA (EXIT 36)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"REAL DEAL LANDSCAPING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2828403","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2023-05-23 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-23 21:41:00","insp_carrier_name":"REAL DEAL LANDSCAPING LLC","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:36.000000Z","updated_at":"2025-03-17T19:24:36.000000Z","inspection_violations":[{"id":4790987,"change_date":"2023-05-23 21:41:00","inspection_id":"78697449","insp_violation_id":"253005814","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195079134","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:18.000000Z","updated_at":"2025-03-17T21:29:18.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5006524,"change_date":"2023-05-23 21:41:00","inspection_id":"78697449","insp_unit_id":"195079134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RD15","insp_unit_license":"21603MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWLB0X3XJ830274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:28.000000Z","updated_at":"2025-03-17T22:42:28.000000Z"}]},{"id":470405,"change_date":"2022-06-02 21:41:00","inspection_id":"75653940","dot_number":"2847087","report_state":"NY","report_number":"SPWD080942","insp_date":"2022-05-23 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"20299","location_desc":"FRANKFORT","county_code_state":"NY","county_code":"043","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"-","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"27000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2710351","transaction_code":"C","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02847087","upload_search_indicator":"M","census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"REAL DEAL LANDSCAPING","insp_carrier_street":"787 FIGERT RD","insp_carrier_city":"COLD BROOK","insp_carrier_state":"NY","insp_carrier_zip_code":"13324-4114","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:58.000000Z","updated_at":"2025-03-17T18:35:58.000000Z","inspection_violations":[{"id":744681,"change_date":"2022-06-02 21:41:00","inspection_id":"75653940","insp_violation_id":"246205788","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8GTJFH","created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39216A"},{"id":744682,"change_date":"2022-06-02 21:41:00","inspection_id":"75653940","insp_violation_id":"246205789","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":756246,"change_date":"2022-06-02 21:41:00","inspection_id":"75653940","insp_unit_id":"189028432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"F7","insp_unit_license":"41198MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWF70J0SVA64759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:51.000000Z","updated_at":"2025-03-17T22:12:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2847087\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2847087\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2847087\/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\/2847087\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}