{"current_page":1,"data":[{"id":11975248,"change_date":"2026-06-12 21:41:00","inspection_id":"87912251","dot_number":"2957361","report_state":"NH","report_number":"1292002899","insp_date":"2026-05-20 00:00:00","insp_start_time":"1231","insp_end_time":"1254","registration_date":"2026-05-21 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"003","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":"Y","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3370767","transaction_code":"C","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:59.000000Z","updated_at":"2026-06-20T09:37:27.000000Z","inspection_violations":[{"id":20831896,"change_date":"2026-06-12 21:41:00","inspection_id":"87912251","insp_violation_id":"274874083","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:12.000000Z","updated_at":"2026-06-20T09:52:03.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20820060,"change_date":"2026-06-12 21:41:00","inspection_id":"87912251","insp_unit_id":"214071106","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"5437562","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD39SE76RF388278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:33.000000Z","updated_at":"2026-06-20T09:12:15.000000Z"}]},{"id":11383717,"change_date":"2026-03-18 21:38:00","inspection_id":"87297966","dot_number":"2957361","report_state":"NH","report_number":"1274003906","insp_date":"2026-03-02 00:00:00","insp_start_time":"1245","insp_end_time":"1330","registration_date":"2026-03-13 00:00:00","region":"ES","ci_status_code":"C","location":"238","location_desc":"NH","county_code_state":"NH","county_code":"003","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3010937","transaction_code":"C","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2026-03-16 21:38:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-16 21:38:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-19T09:37:43.000000Z","updated_at":"2026-03-29T09:31:25.000000Z","inspection_violations":[{"id":19230149,"change_date":"2026-03-18 21:38:00","inspection_id":"87297966","insp_violation_id":"272475107","seq_no":"1","part_no":"392","part_no_section":"16B-DPASS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:29.000000Z","updated_at":"2026-03-29T09:56:02.000000Z","normalized_code":"39216BDPASS"},{"id":19230150,"change_date":"2026-03-18 21:38:00","inspection_id":"87297966","insp_violation_id":"272475108","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"212199448","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:29.000000Z","updated_at":"2026-03-29T09:56:02.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":19535181,"change_date":"2026-03-18 21:38:00","inspection_id":"87297966","insp_unit_id":"212199448","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"L6","insp_unit_license":"4888994","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDUF5HY7GEC27041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:18.000000Z","updated_at":"2026-03-29T09:17:24.000000Z"}]},{"id":11145756,"change_date":"2026-02-17 21:38:00","inspection_id":"87060100","dot_number":"2957361","report_state":"NH","report_number":"1274003880","insp_date":"2026-02-12 00:00:00","insp_start_time":"1050","insp_end_time":"1140","registration_date":"2026-02-17 00:00:00","region":"ES","ci_status_code":"C","location":"238","location_desc":"NH","county_code_state":"NH","county_code":"003","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2897723","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2026-02-17 21:38:00","snet_input_date":"2026-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-17 21:38:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:42.000000Z","updated_at":"2026-02-28T10:30:20.000000Z","inspection_violations":[{"id":18676121,"change_date":"2026-02-17 21:38:00","inspection_id":"87060100","insp_violation_id":"271834744","seq_no":"1","part_no":"391","part_no_section":"11B2-S","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:29.000000Z","updated_at":"2026-02-28T10:40:25.000000Z","normalized_code":"39111B2S"},{"id":18676122,"change_date":"2026-02-17 21:38:00","inspection_id":"87060100","insp_violation_id":"271834745","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"211654271","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-20T10:52:29.000000Z","updated_at":"2026-02-28T10:40:25.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":19014074,"change_date":"2026-02-17 21:38:00","inspection_id":"87060100","insp_unit_id":"211654271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"L3","insp_unit_license":"5232710","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD39SE79PF130401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:26.000000Z","updated_at":"2026-02-28T10:02:59.000000Z"}]},{"id":10295008,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","dot_number":"2957361","report_state":"ME","report_number":"9438000864","insp_date":"2025-11-25 00:00:00","insp_start_time":"0734","insp_end_time":"0756","registration_date":"2026-02-17 00:00:00","region":"ET","ci_status_code":"C","location":"000225","location_desc":"ELIOT","county_code_state":"ME","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23150","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"405119","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:36.000000Z","updated_at":"2026-03-01T10:30:12.000000Z","inspection_violations":[{"id":18701877,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","insp_violation_id":"271872204","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:39:35.000000Z","normalized_code":"39111B2Q"},{"id":18701878,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","insp_violation_id":"271872205","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211686018","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:39:35.000000Z","normalized_code":"39378AWS"},{"id":18701879,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","insp_violation_id":"271872206","seq_no":"3","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"211686018","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:39:35.000000Z","normalized_code":"3939ALTSIR"},{"id":18701880,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","insp_violation_id":"271872207","seq_no":"4","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"211686018","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:39:35.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":19049849,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","insp_unit_id":"211686018","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"33","insp_unit_license":"560CQV","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD32TCG8KF260904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:05.000000Z","updated_at":"2026-03-01T10:03:55.000000Z"},{"id":19049850,"change_date":"2026-02-18 21:38:00","inspection_id":"86420436","insp_unit_id":"211686019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOME","insp_unit_company":"-","insp_unit_license":"C196332","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HABE2026MN098892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:05.000000Z","updated_at":"2026-03-01T10:03:55.000000Z"}]},{"id":10295032,"change_date":"2026-02-18 21:38:00","inspection_id":"86420463","dot_number":"2957361","report_state":"ME","report_number":"3969004976","insp_date":"2025-11-25 00:00:00","insp_start_time":"0740","insp_end_time":"0807","registration_date":"2026-02-17 00:00:00","region":"ET","ci_status_code":"C","location":"000225","location_desc":"ELIOT","county_code_state":"ME","county_code":"031","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":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"20200","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":"405131","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:36.000000Z","updated_at":"2026-03-01T10:30:12.000000Z","inspection_violations":[{"id":18701886,"change_date":"2026-02-18 21:38:00","inspection_id":"86420463","insp_violation_id":"271872093","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211685939","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:39:35.000000Z","normalized_code":"39395A1"},{"id":18701887,"change_date":"2026-02-18 21:38:00","inspection_id":"86420463","insp_violation_id":"271872094","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"211685939","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:39:35.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":19049855,"change_date":"2026-02-18 21:38:00","inspection_id":"86420463","insp_unit_id":"211685939","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"-","insp_unit_license":"558CQV","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD32TCG4KF231612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:05.000000Z","updated_at":"2026-03-01T10:03:55.000000Z"},{"id":19049856,"change_date":"2026-02-18 21:38:00","inspection_id":"86420463","insp_unit_id":"211685940","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"-","insp_unit_license":"B890641","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HABE2028LN080389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:05.000000Z","updated_at":"2026-03-01T10:03:55.000000Z"}]},{"id":10144980,"change_date":"2025-11-13 21:39:00","inspection_id":"86262906","dot_number":"2957361","report_state":"NH","report_number":"1086002332","insp_date":"2025-11-05 00:00:00","insp_start_time":"0705","insp_end_time":"0730","registration_date":"2025-11-06 00:00:00","region":"ES","ci_status_code":"C","location":"002","location_desc":"NH","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"10250","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":"2535967","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:36.000000Z","updated_at":"2025-11-17T10:30:10.000000Z","inspection_violations":[{"id":16920472,"change_date":"2025-11-13 21:39:00","inspection_id":"86262906","insp_violation_id":"269922162","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-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"39141AMCPC"},{"id":16920473,"change_date":"2025-11-13 21:39:00","inspection_id":"86262906","insp_violation_id":"269922163","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","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-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16966038,"change_date":"2025-11-13 21:39:00","inspection_id":"86262906","insp_unit_id":"210001066","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"B07","insp_unit_license":"5463075","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GT39LE7XRF435144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:11.000000Z"}]},{"id":10144981,"change_date":"2025-11-13 21:39:00","inspection_id":"86262907","dot_number":"2957361","report_state":"NH","report_number":"1086002333","insp_date":"2025-11-05 00:00:00","insp_start_time":"0730","insp_end_time":"0745","registration_date":"2025-11-06 00:00:00","region":"ES","ci_status_code":"C","location":"002","location_desc":"NH","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15500","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":"2535961","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:36.000000Z","updated_at":"2025-11-17T10:30:10.000000Z","inspection_violations":[{"id":16920474,"change_date":"2025-11-13 21:39:00","inspection_id":"86262907","insp_violation_id":"269922254","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16966039,"change_date":"2025-11-13 21:39:00","inspection_id":"86262907","insp_unit_id":"210001124","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"B8","insp_unit_license":"348CQQ","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD4USE75SF149846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:11.000000Z"},{"id":16966040,"change_date":"2025-11-13 21:39:00","inspection_id":"86262907","insp_unit_id":"210001125","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CROFT","insp_unit_company":"2","insp_unit_license":"T791826","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1C9UK041XP1685556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:11.000000Z"}]},{"id":9664232,"change_date":"2025-09-12 21:48:00","inspection_id":"85756898","dot_number":"2957361","report_state":"NH","report_number":"1086002159","insp_date":"2025-09-10 00:00:00","insp_start_time":"1325","insp_end_time":"1400","registration_date":"2025-09-11 00:00:00","region":"ED","ci_status_code":"C","location":"024","location_desc":"NH","county_code_state":"NH","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-12 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"2261873","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-09-12 21:48:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-12 21:48:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:47:55.000000Z","updated_at":"2025-09-16T10:47:55.000000Z","inspection_violations":[{"id":15832625,"change_date":"2025-09-12 21:48:00","inspection_id":"85756898","insp_violation_id":"268639032","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"208901243","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:34.000000Z","updated_at":"2025-09-16T10:50:10.000000Z","normalized_code":"39395A4EEUS"},{"id":15832626,"change_date":"2025-09-12 21:48:00","inspection_id":"85756898","insp_violation_id":"268639033","seq_no":"2","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"208901244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:34.000000Z","updated_at":"2025-09-16T10:50:10.000000Z","normalized_code":"39348ABIHE"}],"inspection_per_units":[{"id":15982973,"change_date":"2025-09-12 21:48:00","inspection_id":"85756898","insp_unit_id":"208901243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"B09","insp_unit_license":"5594425","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3YSE71RF420663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:51.000000Z","updated_at":"2025-09-16T09:55:22.000000Z"},{"id":15982974,"change_date":"2025-09-12 21:48:00","inspection_id":"85756898","insp_unit_id":"208901244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"BTR24","insp_unit_license":"T748417","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"16VPX182592E35255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:51.000000Z","updated_at":"2025-09-16T09:55:22.000000Z"}]},{"id":9664821,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","dot_number":"2957361","report_state":"NH","report_number":"1086002134","insp_date":"2025-09-03 00:00:00","insp_start_time":"1535","insp_end_time":"1625","registration_date":"2025-09-11 00:00:00","region":"ED","ci_status_code":"C","location":"024","location_desc":"NH","county_code_state":"NH","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2266719","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:09.000000Z","updated_at":"2025-09-16T10:48:09.000000Z","inspection_violations":[{"id":15839271,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","insp_violation_id":"268647638","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208909989","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:47.000000Z","updated_at":"2025-09-16T10:50:42.000000Z","normalized_code":"39617CPI"},{"id":15839272,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","insp_violation_id":"268647639","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"208909989","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:47.000000Z","updated_at":"2025-09-16T10:50:42.000000Z","normalized_code":"3939ALSLI"},{"id":15839273,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","insp_violation_id":"268647640","seq_no":"4","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"208909989","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-14T11:57:47.000000Z","updated_at":"2025-09-16T10:50:42.000000Z","normalized_code":"3939ALTSI"},{"id":15839274,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","insp_violation_id":"268647641","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"1","insp_unit_id":"208909988","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-14T11:57:47.000000Z","updated_at":"2025-09-16T10:50:42.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":15986899,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","insp_unit_id":"208909988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"L5","insp_unit_license":"5117801","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD39SE74NF243251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:54.000000Z","updated_at":"2025-09-16T09:55:37.000000Z"},{"id":15986900,"change_date":"2025-09-12 21:49:00","inspection_id":"85757577","insp_unit_id":"208909989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"BTR3","insp_unit_license":"T806452","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"4RWBT222XSH055934","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:54.000000Z","updated_at":"2025-09-16T09:55:37.000000Z"}]},{"id":9726968,"change_date":"2025-09-19 21:38:00","inspection_id":"85823076","dot_number":"2957361","report_state":"NH","report_number":"1292002680","insp_date":"2025-08-28 00:00:00","insp_start_time":"1257","insp_end_time":"1316","registration_date":"2025-09-19 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"003","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-09-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2299681","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-09-19 21:38:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-19 21:38:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:40.000000Z","updated_at":"2025-09-23T10:02:40.000000Z","inspection_violations":[{"id":15970973,"change_date":"2025-09-19 21:38:00","inspection_id":"85823076","insp_violation_id":"268803016","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-09-22T10:18:20.000000Z","updated_at":"2025-09-23T10:15:59.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":16107774,"change_date":"2025-09-19 21:38:00","inspection_id":"85823076","insp_unit_id":"209043098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"5005018","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"54DC4W1D0LS209703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:00.000000Z","updated_at":"2025-09-23T09:45:42.000000Z"}]},{"id":9471131,"change_date":"2025-09-29 21:39:00","inspection_id":"85554332","dot_number":"2957361","report_state":"ME","report_number":"9195000391","insp_date":"2025-08-20 00:00:00","insp_start_time":"1542","insp_end_time":"1628","registration_date":"2025-09-26 00:00:00","region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"401323","transaction_code":"C","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-08-21 21:40:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-08-21 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:51.000000Z","updated_at":"2025-10-03T10:00:30.000000Z","inspection_violations":[{"id":16124515,"change_date":"2025-09-29 21:39:00","inspection_id":"85554332","insp_violation_id":"268980440","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-02T10:15:22.000000Z","updated_at":"2025-10-03T10:15:46.000000Z","normalized_code":"38323A2LCDLN"},{"id":16124516,"change_date":"2025-09-29 21:39:00","inspection_id":"85554332","insp_violation_id":"268980441","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"209199213","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-02T10:15:22.000000Z","updated_at":"2025-10-03T10:15:46.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":16248555,"change_date":"2025-09-29 21:39:00","inspection_id":"85554332","insp_unit_id":"209199212","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1D6930","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3YSE74PF253535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:18.000000Z","updated_at":"2025-10-03T09:45:36.000000Z"},{"id":16248556,"change_date":"2025-09-29 21:39:00","inspection_id":"85554332","insp_unit_id":"209199213","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"B816164","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4ZETD2027J1160382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:18.000000Z","updated_at":"2025-10-03T09:45:36.000000Z"}]},{"id":10078082,"change_date":"2025-10-30 21:42:00","inspection_id":"86192334","dot_number":"2957361","report_state":"NH","report_number":"1086002017","insp_date":"2025-07-30 00:00:00","insp_start_time":"0825","insp_end_time":"0850","registration_date":null,"region":"ED","ci_status_code":"C","location":"043","location_desc":"NH","county_code_state":"NH","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2480641","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:12.000000Z","updated_at":"2025-11-03T11:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16753313,"change_date":"2025-10-30 21:42:00","inspection_id":"86192334","insp_unit_id":"209739911","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB4KSE7XSF145077","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:03.000000Z"}]},{"id":8578733,"change_date":"2025-05-09 21:41:00","inspection_id":"84613165","dot_number":"2957361","report_state":"NH","report_number":"0996000618","insp_date":"2025-05-07 00:00:00","insp_start_time":"1043","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EXETER, NH","county_code_state":"NH","county_code":"015","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20200","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"284778","transaction_code":"C","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-05-08 21:40:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-05-08 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-11T10:21:12.000000Z","updated_at":"2025-05-13T10:01:53.000000Z","inspection_violations":[{"id":13637566,"change_date":"2025-05-09 21:41:00","inspection_id":"84613165","insp_violation_id":"266131186","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:25:23.000000Z","updated_at":"2025-05-13T10:19:30.000000Z","normalized_code":"39111B2Q"},{"id":13637567,"change_date":"2025-05-09 21:41:00","inspection_id":"84613165","insp_violation_id":"266131187","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206778426","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:25:23.000000Z","updated_at":"2025-05-13T10:19:30.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":14012745,"change_date":"2025-05-09 21:41:00","inspection_id":"84613165","insp_unit_id":"206778426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"2B0902","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD32VCG9HZ167134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:18.000000Z","updated_at":"2025-05-13T09:46:55.000000Z"},{"id":14012746,"change_date":"2025-05-09 21:41:00","inspection_id":"84613165","insp_unit_id":"206778427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"C140796","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4ZEUT2025J1159268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:18.000000Z","updated_at":"2025-05-13T09:46:55.000000Z"}]},{"id":8547390,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","dot_number":"2957361","report_state":"NH","report_number":"1325000947","insp_date":"2025-05-02 00:00:00","insp_start_time":"1209","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEWINGTON","county_code_state":"NH","county_code":"015","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"9","oos_total":"6","driver_viol_total":"7","driver_oos_total":"5","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"284715","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:33.000000Z","updated_at":"2025-05-09T10:22:26.000000Z","inspection_violations":[{"id":13544564,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007248","seq_no":"7","part_no":"392","part_no_section":"3-I","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"3923I"},{"id":13544558,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007242","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"3922SLLTL"},{"id":13544559,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007243","seq_no":"2","part_no":"392","part_no_section":"2-SLLRD","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-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"3922SLLRD"},{"id":13544560,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007244","seq_no":"3","part_no":"392","part_no_section":"3-I","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ARRESTED","created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"3923I"},{"id":13544561,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007245","seq_no":"4","part_no":"392","part_no_section":"4A-DOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ARRESTED","created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"3924ADOSP"},{"id":13544562,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007246","seq_no":"5","part_no":"392","part_no_section":"5A3-IDUI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ARRESTED","created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"3925A3IDUI"},{"id":13544563,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007247","seq_no":"6","part_no":"391","part_no_section":"15A-LNCDLNSRW","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ARRESTED","created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"39115ALNCDLNSRW"},{"id":13544565,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007249","seq_no":"8","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206642333","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"39395A4EEUS"},{"id":13544566,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_violation_id":"266007250","seq_no":"9","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"206642334","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-08T10:25:31.000000Z","updated_at":"2025-05-09T10:43:40.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":13900563,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_unit_id":"206642333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"7C6601","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD49SE71MF124169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:54:21.000000Z","updated_at":"2025-05-09T09:58:49.000000Z"},{"id":13900564,"change_date":"2025-05-05 21:40:00","inspection_id":"84580374","insp_unit_id":"206642334","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"B816164","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4ZETD2027J1160382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:54:21.000000Z","updated_at":"2025-05-09T09:58:49.000000Z"}]},{"id":8428931,"change_date":"2025-05-05 21:40:00","inspection_id":"84455449","dot_number":"2957361","report_state":"NH","report_number":"1086001721","insp_date":"2025-04-18 00:00:00","insp_start_time":"0805","insp_end_time":"0835","registration_date":"2025-05-05 00:00:00","region":"ET","ci_status_code":"C","location":"217","location_desc":"TILTON","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"284435","transaction_code":"C","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:03:02.000000Z","updated_at":"2025-05-09T10:21:37.000000Z","inspection_violations":[{"id":13540619,"change_date":"2025-05-05 21:40:00","inspection_id":"84455449","insp_violation_id":"266007177","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25-887-000788","created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:33.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":13897519,"change_date":"2025-05-05 21:40:00","inspection_id":"84455449","insp_unit_id":"206642300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"93","insp_unit_license":"7C-2568","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FD8X3H69KEG79339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:29.000000Z","updated_at":"2025-05-09T09:55:10.000000Z"}]},{"id":8403122,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","dot_number":"2957361","report_state":"NH","report_number":"1086001709","insp_date":"2025-04-16 00:00:00","insp_start_time":"1615","insp_end_time":"1650","registration_date":"2025-05-05 00:00:00","region":"ET","ci_status_code":"C","location":"002","location_desc":"BELMONT","county_code_state":"NH","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2025-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"284273","transaction_code":"C","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-16 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:28:19.000000Z","updated_at":"2025-05-09T10:21:36.000000Z","inspection_violations":[{"id":13540543,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_violation_id":"266007171","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"206642299","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:32.000000Z","normalized_code":"39341BNPB"},{"id":13540544,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_violation_id":"266007172","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206642299","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:32.000000Z","normalized_code":"39360C"},{"id":13540545,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_violation_id":"266007173","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206642299","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:32.000000Z","normalized_code":"39395A4EEUS"},{"id":13540546,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_violation_id":"266007174","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"206642299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:32.000000Z","normalized_code":"3939ALSML"},{"id":13540547,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_violation_id":"266007175","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206642299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:32.000000Z","normalized_code":"3939ALIL"},{"id":13540548,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_violation_id":"266007176","seq_no":"6","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"206642299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:32.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":13897470,"change_date":"2025-05-05 21:40:00","inspection_id":"84428173","insp_unit_id":"206642299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"B-51","insp_unit_license":"5262446","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3KYC87FF153573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:29.000000Z","updated_at":"2025-05-09T09:55:09.000000Z"}]},{"id":8352164,"change_date":"2025-05-05 21:40:00","inspection_id":"84374461","dot_number":"2957361","report_state":"NH","report_number":"1325000905","insp_date":"2025-04-10 00:00:00","insp_start_time":"1326","insp_end_time":"1337","registration_date":"2025-05-05 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"EAST WEIGH STATION EPPING","county_code_state":"NH","county_code":"015","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"284049","transaction_code":"C","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:36.000000Z","updated_at":"2025-05-09T10:21:34.000000Z","inspection_violations":[{"id":13540381,"change_date":"2025-05-05 21:40:00","inspection_id":"84374461","insp_violation_id":"266007221","seq_no":"1","part_no":"391","part_no_section":"45A-MCMC","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-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:29.000000Z","normalized_code":"39145AMCMC"}],"inspection_per_units":[{"id":13897365,"change_date":"2025-05-05 21:40:00","inspection_id":"84374461","insp_unit_id":"206642320","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"9C2372","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3YSE71RF159437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:29.000000Z","updated_at":"2025-05-09T09:55:08.000000Z"}]},{"id":8166827,"change_date":"2025-03-31 21:40:00","inspection_id":"84179332","dot_number":"2957361","report_state":"NH","report_number":"0996000517","insp_date":"2025-03-19 00:00:00","insp_start_time":"1303","insp_end_time":"1310","registration_date":"2025-03-31 00:00:00","region":"ET","ci_status_code":"C","location":"017","location_desc":"DURHAM WEIGH STATION","county_code_state":"NH","county_code":"017","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"283474","transaction_code":"C","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-03-20 21:41:00","snet_input_date":"2025-03-19 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-03-20 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:48:09.000000Z","updated_at":"2025-04-04T10:16:40.000000Z","inspection_violations":[{"id":12957007,"change_date":"2025-03-31 21:40:00","inspection_id":"84179332","insp_violation_id":"265351141","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:19:32.000000Z","updated_at":"2025-04-04T10:29:26.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":13350993,"change_date":"2025-03-31 21:40:00","inspection_id":"84179332","insp_unit_id":"206077080","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"5284131","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD39SE72RF141517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:50:01.000000Z","updated_at":"2025-04-04T09:51:02.000000Z"}]},{"id":7803422,"change_date":"2025-02-06 21:40:00","inspection_id":"83797528","dot_number":"2957361","report_state":"NH","report_number":"1292002423","insp_date":"2025-02-05 00:00:00","insp_start_time":"1109","insp_end_time":"1211","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OSSIPEE","county_code_state":"NH","county_code":"003","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"4","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"282135","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2025-02-06 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-06 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:18.000000Z","updated_at":"2025-03-17T21:00:18.000000Z","inspection_violations":[{"id":12195045,"change_date":"2025-02-06 21:40:00","inspection_id":"83797528","insp_violation_id":"264374784","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25-887-000281","created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3922SLLEWG3"},{"id":12195046,"change_date":"2025-02-06 21:40:00","inspection_id":"83797528","insp_violation_id":"264374785","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"205190609","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"39375GTAOW"},{"id":12195047,"change_date":"2025-02-06 21:40:00","inspection_id":"83797528","insp_violation_id":"264374786","seq_no":"3","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"205190609","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"39375GTAOW"},{"id":12195048,"change_date":"2025-02-06 21:40:00","inspection_id":"83797528","insp_violation_id":"264374787","seq_no":"4","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"205190609","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":12593415,"change_date":"2025-02-06 21:40:00","inspection_id":"83797528","insp_unit_id":"205190609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"4888993","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDRF3H61HEC59333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:06.000000Z","updated_at":"2025-03-17T23:54:06.000000Z"}]},{"id":7336542,"change_date":"2024-12-04 21:41:00","inspection_id":"83307003","dot_number":"2957361","report_state":"ME","report_number":"2659001551","insp_date":"2024-12-03 00:00:00","insp_start_time":"1124","insp_end_time":"1142","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"389555","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:01.000000Z","updated_at":"2025-03-17T20:49:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11834983,"change_date":"2024-12-04 21:41:00","inspection_id":"83307003","insp_unit_id":"204174729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"4944045","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"54DCDW1D9LS207593","insp_unit_decal":"Y","insp_unit_decal_number":"34696211","created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"}]},{"id":7124298,"change_date":"2024-11-20 21:40:00","inspection_id":"83082649","dot_number":"2957361","report_state":"NH","report_number":"1086001431","insp_date":"2024-11-04 00:00:00","insp_start_time":"1645","insp_end_time":"1735","registration_date":"2024-11-20 00:00:00","region":"ET","ci_status_code":"C","location":"002","location_desc":"BELMONT","county_code_state":"NH","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2024-11-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"31970","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"280024","transaction_code":"C","transaction_date":"2024-11-11 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-11-05 21:39:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-11-05 21:39:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[{"id":11127039,"change_date":"2024-11-20 21:40:00","inspection_id":"83082649","insp_violation_id":"262996545","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:00.000000Z","updated_at":"2025-03-17T22:00:00.000000Z","normalized_code":"38323A2LCDLN"},{"id":11127040,"change_date":"2024-11-20 21:40:00","inspection_id":"83082649","insp_violation_id":"262996546","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"203969852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:00.000000Z","updated_at":"2025-03-17T22:00:00.000000Z","normalized_code":"3939ALRLI"},{"id":11127041,"change_date":"2024-11-20 21:40:00","inspection_id":"83082649","insp_violation_id":"262996547","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"203969852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:00.000000Z","updated_at":"2025-03-17T22:00:00.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":11490600,"change_date":"2024-11-20 21:40:00","inspection_id":"83082649","insp_unit_id":"203969851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"93","insp_unit_license":"7C2568","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FD8X3H69KEG79339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:04.000000Z","updated_at":"2025-03-17T23:42:04.000000Z"},{"id":11490601,"change_date":"2024-11-20 21:40:00","inspection_id":"83082649","insp_unit_id":"203969852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HDSN","insp_unit_company":null,"insp_unit_license":"T748418","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"10HHTMBG5A1000024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:04.000000Z","updated_at":"2025-03-17T23:42:04.000000Z"}]},{"id":7012623,"change_date":"2024-11-08 21:40:00","inspection_id":"82964214","dot_number":"2957361","report_state":"NH","report_number":"1274003348","insp_date":"2024-10-21 00:00:00","insp_start_time":"1229","insp_end_time":"1250","registration_date":"2024-11-08 00:00:00","region":"ET","ci_status_code":"C","location":"162","location_desc":"MOULTONBORO","county_code_state":"NH","county_code":"003","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":"Y","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-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"279628","transaction_code":"C","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[{"id":10942505,"change_date":"2024-11-08 21:40:00","inspection_id":"82964214","insp_violation_id":"262805007","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-03-17T21:59:05.000000Z","updated_at":"2025-03-17T21:59:05.000000Z","normalized_code":"39216D"},{"id":10942506,"change_date":"2024-11-08 21:40:00","inspection_id":"82964214","insp_violation_id":"262805008","seq_no":"2","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-17T21:59:05.000000Z","updated_at":"2025-03-17T21:59:05.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":11310681,"change_date":"2024-11-08 21:40:00","inspection_id":"82964214","insp_unit_id":"203800739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L6","insp_unit_license":"4888994","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDUF5HY7GEC27041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:07.000000Z","updated_at":"2025-03-17T23:40:07.000000Z"},{"id":11310682,"change_date":"2024-11-08 21:40:00","inspection_id":"82964214","insp_unit_id":"203800740","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CROT","insp_unit_company":null,"insp_unit_license":"T791825","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1C9UK0410P1685534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:07.000000Z","updated_at":"2025-03-17T23:40:07.000000Z"}]},{"id":6583690,"change_date":"2024-08-28 21:42:00","inspection_id":"82507678","dot_number":"2957361","report_state":"ME","report_number":"2659001435","insp_date":"2024-08-27 00:00:00","insp_start_time":"1610","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"384996","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:37.000000Z","updated_at":"2025-03-17T20:33:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10613949,"change_date":"2024-08-28 21:42:00","inspection_id":"82507678","insp_unit_id":"202626209","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"4","insp_unit_license":"1D6930","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3YSE74PF253535","insp_unit_decal":"Y","insp_unit_decal_number":"34384875","created_at":"2025-03-17T23:32:56.000000Z","updated_at":"2025-03-17T23:32:56.000000Z"}]},{"id":6070636,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","dot_number":"2957361","report_state":"NH","report_number":"1292002033","insp_date":"2024-06-24 00:00:00","insp_start_time":"1219","insp_end_time":"1324","registration_date":"2024-07-05 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"MOULTONBOROUGH","county_code_state":"NH","county_code":"003","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25250","viol_total":"18","oos_total":"7","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"17","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"276143","transaction_code":"C","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-06-25 21:42:00","snet_input_date":"2024-06-24 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:59.000000Z","updated_at":"2025-03-17T20:22:59.000000Z","inspection_violations":[{"id":9419048,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478673","seq_no":"1","part_no":"391","part_no_section":"11(b)(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:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39111B2"},{"id":9419049,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478674","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"201742898","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39341"},{"id":9419050,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478675","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201742898","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39395A"},{"id":9419051,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478676","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201742898","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39395F"},{"id":9419052,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478677","seq_no":"5","part_no":"393","part_no_section":"25(e)","insp_viol_unit":"1","insp_unit_id":"201742898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39325E"},{"id":9419053,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478678","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39617C"},{"id":9419054,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478679","seq_no":"7","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"393205C"},{"id":9419055,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478680","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3939A"},{"id":9419056,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478681","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3939A"},{"id":9419057,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478682","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3939A"},{"id":9419058,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478683","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3939A"},{"id":9419059,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478684","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3963A1"},{"id":9419060,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478685","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3963A1"},{"id":9419061,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478686","seq_no":"14","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39343"},{"id":9419062,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478687","seq_no":"15","part_no":"393","part_no_section":"25(e)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39325E"},{"id":9419063,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478688","seq_no":"16","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39367C7V"},{"id":9419064,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478689","seq_no":"17","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3963A1"},{"id":9419065,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_violation_id":"260478690","seq_no":"18","part_no":"393","part_no_section":"40","insp_viol_unit":"2","insp_unit_id":"201742899","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"39340"}],"inspection_per_units":[{"id":9777566,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_unit_id":"201742898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"4888994","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDUF5HY7GEC27041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"},{"id":9777567,"change_date":"2024-07-05 21:36:00","inspection_id":"81958638","insp_unit_id":"201742899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FINN","insp_unit_company":null,"insp_unit_license":"65069","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1F9AS1429BF135206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"}]},{"id":5708226,"change_date":"2024-05-09 21:42:00","inspection_id":"81565762","dot_number":"2957361","report_state":"ME","report_number":"5144005045","insp_date":"2024-05-09 00:00:00","insp_start_time":"1531","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"9900","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":"379688","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-09 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:53.000000Z","updated_at":"2025-03-17T20:15:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9194152,"change_date":"2024-05-09 21:42:00","inspection_id":"81565762","insp_unit_id":"200808124","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"21","insp_unit_license":"7A6157","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD07RF7XN1142924","insp_unit_decal":"Y","insp_unit_decal_number":"34070046","created_at":"2025-03-17T23:18:33.000000Z","updated_at":"2025-03-17T23:18:33.000000Z"}]},{"id":4928815,"change_date":"2024-02-01 21:43:00","inspection_id":"80715252","dot_number":"2957361","report_state":"NH","report_number":"1274002928","insp_date":"2024-01-26 00:00:00","insp_start_time":"0809","insp_end_time":"0825","registration_date":"2024-02-01 00:00:00","region":"ET","ci_status_code":"C","location":"035","location_desc":"OSSIPEE","county_code_state":"NH","county_code":"003","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"272555","transaction_code":"C","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2024-01-30 21:41:00","snet_input_date":"2024-01-26 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[{"id":7591667,"change_date":"2024-02-01 21:43:00","inspection_id":"80715252","insp_violation_id":"257606717","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"3922"},{"id":7591668,"change_date":"2024-02-01 21:43:00","inspection_id":"80715252","insp_violation_id":"257606718","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":7931673,"change_date":"2024-02-01 21:43:00","inspection_id":"80715252","insp_unit_id":"199215227","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"L5","insp_unit_license":"5117801","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD39SE74NF243251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"}]},{"id":4567252,"change_date":"2024-01-17 21:44:00","inspection_id":"80319870","dot_number":"2957361","report_state":"ME","report_number":"1767005117","insp_date":"2023-12-06 00:00:00","insp_start_time":"1049","insp_end_time":"1125","registration_date":"2024-01-16 00:00:00","region":"ET","ci_status_code":"C","location":"000006","location_desc":"BIDDEFORD","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"372818","transaction_code":"C","transaction_date":"2023-12-06 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":"M","census_search_date":"2023-12-06 21:41:00","snet_input_date":"2023-12-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-12-06 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:23.000000Z","updated_at":"2025-03-17T19:53:23.000000Z","inspection_violations":[{"id":7065515,"change_date":"2024-01-17 21:44:00","inspection_id":"80319870","insp_violation_id":"257372625","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198991059","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"3922"},{"id":7065516,"change_date":"2024-01-17 21:44:00","inspection_id":"80319870","insp_violation_id":"257372626","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198991059","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7345690,"change_date":"2024-01-17 21:44:00","inspection_id":"80319870","insp_unit_id":"198991059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"4","insp_unit_license":"2B0907","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDRF3H65HEC91282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:44.000000Z","updated_at":"2025-03-17T23:01:44.000000Z"}]},{"id":4019154,"change_date":"2023-09-21 21:40:00","inspection_id":"79713894","dot_number":"2957361","report_state":"NH","report_number":"1078007041","insp_date":"2023-09-20 00:00:00","insp_start_time":"0809","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"SANBORNTON","county_code_state":"NH","county_code":"001","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-09-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","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":"269346","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2023-09-21 21:40:00","snet_input_date":"2023-09-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-09-21 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:05.000000Z","updated_at":"2025-03-17T19:42:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6462405,"change_date":"2023-09-21 21:40:00","inspection_id":"79713894","insp_unit_id":"197156812","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"961077","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1M2AX09C2JM037053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:15.000000Z","updated_at":"2025-03-17T22:54:15.000000Z"}]},{"id":3743340,"change_date":"2023-08-15 21:42:00","inspection_id":"79406637","dot_number":"2957361","report_state":"NH","report_number":"1274002719","insp_date":"2023-08-14 00:00:00","insp_start_time":"1236","insp_end_time":"1311","registration_date":null,"region":"ET","ci_status_code":"C","location":"238","location_desc":"WOLFEBORO","county_code_state":"NH","county_code":"003","insp_level_id":"3","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"268391","transaction_code":"A","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2023-08-15 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-15 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:52.000000Z","updated_at":"2025-03-17T19:36:52.000000Z","inspection_violations":[{"id":5773002,"change_date":"2023-08-15 21:42:00","inspection_id":"79406637","insp_violation_id":"254653213","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":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39216A"},{"id":5773003,"change_date":"2023-08-15 21:42:00","inspection_id":"79406637","insp_violation_id":"254653214","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":6018939,"change_date":"2023-08-15 21:42:00","inspection_id":"79406637","insp_unit_id":"196531045","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"4888993","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDRF3H61HEC59333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:34.000000Z","updated_at":"2025-03-17T22:50:34.000000Z"}]},{"id":3627833,"change_date":"2023-08-17 21:42:00","inspection_id":"79277480","dot_number":"2957361","report_state":"NH","report_number":"1292001466","insp_date":"2023-07-28 00:00:00","insp_start_time":"1137","insp_end_time":"1159","registration_date":"2023-08-17 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCHESTER","county_code_state":"NH","county_code":"017","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10500","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"267987","transaction_code":"C","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2023-07-31 21:40:00","snet_input_date":"2023-07-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[{"id":5595001,"change_date":"2023-08-17 21:42:00","inspection_id":"79277480","insp_violation_id":"254701328","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39141A"},{"id":5595002,"change_date":"2023-08-17 21:42:00","inspection_id":"79277480","insp_violation_id":"254701329","seq_no":"3","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39216A"},{"id":5595003,"change_date":"2023-08-17 21:42:00","inspection_id":"79277480","insp_violation_id":"254701330","seq_no":"4","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39111B2"},{"id":5595000,"change_date":"2023-08-17 21:42:00","inspection_id":"79277480","insp_violation_id":"254701327","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5832863,"change_date":"2023-08-17 21:42:00","inspection_id":"79277480","insp_unit_id":"196573536","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"5117832","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GC5YLE72LF224474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3339438,"change_date":"2023-06-22 21:41:00","inspection_id":"78953651","dot_number":"2957361","report_state":"ME","report_number":"1121009022","insp_date":"2023-06-21 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"366154","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-21 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5368711,"change_date":"2023-06-22 21:41:00","inspection_id":"78953651","insp_unit_id":"195616832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"93","insp_unit_license":"7C2568","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FD8X3H69KEG79339","insp_unit_decal":"Y","insp_unit_decal_number":"32762125","created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"}]},{"id":3128543,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","dot_number":"2957361","report_state":"NH","report_number":"1292001324","insp_date":"2023-05-23 00:00:00","insp_start_time":"1145","insp_end_time":"1219","registration_date":"2023-06-05 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"PORTSMOUTH","county_code_state":"NH","county_code":"015","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20200","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"266284","transaction_code":"C","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2023-05-24 21:40:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-05-24 21:40:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:57.000000Z","updated_at":"2025-03-17T19:24:57.000000Z","inspection_violations":[{"id":4816097,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_violation_id":"253268975","seq_no":"1","part_no":"392","part_no_section":"7(a)","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:29:24.000000Z","updated_at":"2025-03-17T21:29:24.000000Z","normalized_code":"3927A"},{"id":4816098,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_violation_id":"253268976","seq_no":"2","part_no":"393","part_no_section":"25(e)","insp_viol_unit":"1","insp_unit_id":"195304253","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:24.000000Z","updated_at":"2025-03-17T21:29:24.000000Z","normalized_code":"39325E"},{"id":4816099,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_violation_id":"253268977","seq_no":"3","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"195304254","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:24.000000Z","updated_at":"2025-03-17T21:29:24.000000Z","normalized_code":"3929"},{"id":4816100,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_violation_id":"253268978","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195304254","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:24.000000Z","updated_at":"2025-03-17T21:29:24.000000Z","normalized_code":"3922"},{"id":4816101,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_violation_id":"253268979","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195304254","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:24.000000Z","updated_at":"2025-03-17T21:29:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5031928,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_unit_id":"195304253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"4C8709","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD32TCG1KF107720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:40.000000Z","updated_at":"2025-03-17T22:42:40.000000Z"},{"id":5031929,"change_date":"2023-06-05 21:42:00","inspection_id":"78715419","insp_unit_id":"195304254","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOME","insp_unit_company":null,"insp_unit_license":"B661708","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HABE2022GN048821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:40.000000Z","updated_at":"2025-03-17T22:42:40.000000Z"}]},{"id":3049407,"change_date":"2023-05-25 21:41:00","inspection_id":"78626494","dot_number":"2957361","report_state":"ME","report_number":"4469002910","insp_date":"2023-05-16 00:00:00","insp_start_time":"0645","insp_end_time":"0730","registration_date":"2023-05-25 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","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":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"29575","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"364313","transaction_code":"C","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":"M","census_search_date":"2023-05-16 21:41:00","snet_input_date":"2023-05-16 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-05-16 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4686837,"change_date":"2023-05-25 21:41:00","inspection_id":"78626494","insp_violation_id":"253070782","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"38323A2"},{"id":4686838,"change_date":"2023-05-25 21:41:00","inspection_id":"78626494","insp_violation_id":"253070783","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195134742","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39617C"},{"id":4686839,"change_date":"2023-05-25 21:41:00","inspection_id":"78626494","insp_violation_id":"253070784","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195134741","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4905871,"change_date":"2023-05-25 21:41:00","inspection_id":"78626494","insp_unit_id":"195134741","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"5C7649","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDUF5HT0LDA03825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:41.000000Z","updated_at":"2025-03-17T22:41:41.000000Z"},{"id":4905872,"change_date":"2023-05-25 21:41:00","inspection_id":"78626494","insp_unit_id":"195134742","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"34048","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"4FMUS1817MR515746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:41.000000Z","updated_at":"2025-03-17T22:41:41.000000Z"}]},{"id":1599824,"change_date":"2023-01-06 21:38:00","inspection_id":"76973515","dot_number":"2957361","report_state":"ME","report_number":"0242001718","insp_date":"2022-10-25 00:00:00","insp_start_time":"0738","insp_end_time":"0801","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"355480","transaction_code":"C","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":"M","census_search_date":"2022-10-26 21:38:00","snet_input_date":"2022-10-25 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-10-26 21:38:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:59.000000Z","updated_at":"2025-03-17T18:55:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2574127,"change_date":"2023-01-06 21:38:00","inspection_id":"76973515","insp_unit_id":"192728198","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2B0907","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDRF3H65HEC91282","insp_unit_decal":"Y","insp_unit_decal_number":"32070805","created_at":"2025-03-17T22:24:38.000000Z","updated_at":"2025-03-17T22:24:38.000000Z"}]},{"id":1493188,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","dot_number":"2957361","report_state":"NH","report_number":"1274002378","insp_date":"2022-10-11 00:00:00","insp_start_time":"1441","insp_end_time":"1521","registration_date":"2022-10-25 00:00:00","region":"ET","ci_status_code":"C","location":"238","location_desc":"WOLFEBORO","county_code_state":"NH","county_code":"003","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"7","oos_total":"2","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"261360","transaction_code":"C","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2022-10-12 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICES LLC","insp_carrier_street":"26 MACLELLEN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:09.000000Z","updated_at":"2025-03-17T18:54:09.000000Z","inspection_violations":[{"id":2350345,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217212","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":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"39216A"},{"id":2350346,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217213","seq_no":"2","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"39282A1"},{"id":2350347,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217214","seq_no":"3","part_no":"391","part_no_section":"11(b)(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:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"39111B2"},{"id":2350348,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217215","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191611399","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"39617C"},{"id":2350349,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217216","seq_no":"5","part_no":"392","part_no_section":"7(a)","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:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3927A"},{"id":2350350,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217217","seq_no":"6","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191611399","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3929A"},{"id":2350351,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_violation_id":"249217218","seq_no":"7","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"191611399","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":2402968,"change_date":"2022-10-25 21:40:00","inspection_id":"76850857","insp_unit_id":"191611399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"L9","insp_unit_license":"5005018","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"54DC4W1D0LS209703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"}]},{"id":1050137,"change_date":"2022-09-09 21:38:00","inspection_id":"76335751","dot_number":"2957361","report_state":"ME","report_number":"1121008428","insp_date":"2022-08-17 00:00:00","insp_start_time":"1200","insp_end_time":"1225","registration_date":"2022-09-08 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"13500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"351590","transaction_code":"C","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":"M","census_search_date":"2022-08-17 21:39:00","snet_input_date":"2022-08-17 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-08-17 21:39:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:11.000000Z","updated_at":"2025-03-17T18:46:11.000000Z","inspection_violations":[{"id":1655180,"change_date":"2022-09-09 21:38:00","inspection_id":"76335751","insp_violation_id":"248298624","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39111B5"}],"inspection_per_units":[{"id":1689844,"change_date":"2022-09-09 21:38:00","inspection_id":"76335751","insp_unit_id":"190800736","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"8C5919","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD411CG4FF546105","insp_unit_decal":"Y","insp_unit_decal_number":"31737217","created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":653668,"change_date":"2022-07-08 21:40:00","inspection_id":"75871758","dot_number":"2957361","report_state":"NH","report_number":"0865002854","insp_date":"2022-06-20 00:00:00","insp_start_time":"0800","insp_end_time":"0833","registration_date":"2022-07-08 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"EPPING W\/B WEIGHT STATION","county_code_state":"NH","county_code":"015","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"257789","transaction_code":"C","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2022-06-21 21:41:00","snet_input_date":"2022-06-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-06-21 21:41:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:12.000000Z","updated_at":"2025-03-17T18:39:12.000000Z","inspection_violations":[{"id":1029443,"change_date":"2022-07-08 21:40:00","inspection_id":"75871758","insp_violation_id":"246967346","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189666836","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":1050626,"change_date":"2022-07-08 21:40:00","inspection_id":"75871758","insp_unit_id":"189666836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"43","insp_unit_license":"2B0919","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDRF3H68HEC86853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:40.000000Z","updated_at":"2025-03-17T22:14:40.000000Z"}]},{"id":413626,"change_date":"2022-05-18 21:43:00","inspection_id":"75586312","dot_number":"2957361","report_state":"ME","report_number":"1494005237","insp_date":"2022-05-18 00:00:00","insp_start_time":"0841","insp_end_time":"0914","registration_date":null,"region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"347014","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":667655,"change_date":"2022-05-18 21:43:00","inspection_id":"75586312","insp_unit_id":"188745207","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"5C7628","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDRF3H67KEG79296","insp_unit_decal":"Y","insp_unit_decal_number":"31390072","created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":403819,"change_date":"2022-05-17 21:42:00","inspection_id":"75574631","dot_number":"2957361","report_state":"ME","report_number":"0452004719","insp_date":"2022-05-17 00:00:00","insp_start_time":"1604","insp_end_time":"1623","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"20350","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":"346728","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-17 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICE LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":651975,"change_date":"2022-05-17 21:42:00","inspection_id":"75574631","insp_unit_id":"188716114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"19","insp_unit_license":"7C6612","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GD39SE71MF251130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"},{"id":651976,"change_date":"2022-05-17 21:42:00","inspection_id":"75574631","insp_unit_id":"188716115","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"-","insp_unit_license":"C196332","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HABE2026MN098892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"}]},{"id":1843,"change_date":"2022-03-24 21:31:00","inspection_id":"75079488","dot_number":"2957361","report_state":"NH","report_number":"1095000349","insp_date":"2022-03-17 00:00:00","insp_start_time":"0756","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DOVER","county_code_state":"NH","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"255681","transaction_code":"C","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02957361","upload_search_indicator":null,"census_search_date":"2022-03-18 21:31:00","snet_input_date":"2022-03-17 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-03-18 21:31:00","insp_carrier_name":"PISCATAQUA LANDSCAPING & TREE SERVICES LLC","insp_carrier_street":"26 MACLELLAN LANE","insp_carrier_city":"ELIOT","insp_carrier_state":"ME","insp_carrier_zip_code":"03903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:42.000000Z","updated_at":"2025-03-17T18:27:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2890,"change_date":"2022-03-24 21:31:00","inspection_id":"75079488","insp_unit_id":"187796660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2","insp_unit_license":"8C5902","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDRF3H67FEC17777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:16.000000Z","updated_at":"2025-03-17T22:08:16.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2957361\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2957361\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2957361\/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\/2957361\/inspections","per_page":100,"prev_page_url":null,"to":40,"total":40}