{"current_page":1,"data":[{"id":10079500,"change_date":"2025-10-30 21:42:00","inspection_id":"86193990","dot_number":"579952","report_state":"NH","report_number":"1436000002","insp_date":"2025-09-11 00:00:00","insp_start_time":"1603","insp_end_time":"1620","registration_date":null,"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":"Y","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":"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":"2482164","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":"00579952","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:14.000000Z","updated_at":"2025-11-03T11:01:03.000000Z","inspection_violations":[{"id":16693889,"change_date":"2025-10-30 21:42:00","inspection_id":"86193990","insp_violation_id":"269621850","seq_no":"1","part_no":"392","part_no_section":"16AD","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-02T11:18:00.000000Z","updated_at":"2025-11-03T11:16:21.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16755101,"change_date":"2025-10-30 21:42:00","inspection_id":"86193990","insp_unit_id":"209742128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"P-00","insp_unit_license":"5367986","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD39SEY7RF290966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:09.000000Z"}]},{"id":10078523,"change_date":"2025-10-30 21:42:00","inspection_id":"86192881","dot_number":"579952","report_state":"NH","report_number":"1128002682","insp_date":"2025-08-29 00:00:00","insp_start_time":"0730","insp_end_time":"0745","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"013","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":"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":"146000","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":"2480927","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":"00579952","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","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:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16753818,"change_date":"2025-10-30 21:42:00","inspection_id":"86192881","insp_unit_id":"209740586","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"27","insp_unit_license":"AF9421","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPTX4EX2LD638987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:05.000000Z"},{"id":16753819,"change_date":"2025-10-30 21:42:00","inspection_id":"86192881","insp_unit_id":"209740587","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"T628701","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1JKDLA509LM017919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:05.000000Z"}]},{"id":10078182,"change_date":"2025-10-30 21:42:00","inspection_id":"86192470","dot_number":"579952","report_state":"NH","report_number":"1201000073","insp_date":"2025-08-28 00:00:00","insp_start_time":"0913","insp_end_time":"0930","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"013","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":"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":"73000","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":"2481109","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":"00579952","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","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:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16753426,"change_date":"2025-10-30 21:42:00","inspection_id":"86192470","insp_unit_id":"209740083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"AH1632","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NKZXPTX0MJ422594","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:04.000000Z"}]},{"id":10078999,"change_date":"2025-10-30 21:42:00","inspection_id":"86193425","dot_number":"579952","report_state":"NH","report_number":"1292002621","insp_date":"2025-07-17 00:00:00","insp_start_time":"0757","insp_end_time":"0810","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","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":"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-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"82100","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":"2481543","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":"00579952","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:13.000000Z","updated_at":"2025-11-03T11:01:00.000000Z","inspection_violations":[{"id":16692599,"change_date":"2025-10-30 21:42:00","inspection_id":"86193425","insp_violation_id":"269620172","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-11-02T11:17:58.000000Z","updated_at":"2025-11-03T11:16:14.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":16754371,"change_date":"2025-10-30 21:42:00","inspection_id":"86193425","insp_unit_id":"209741280","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"AH2886","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NKZX4TX7PJ215686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:07.000000Z"}]},{"id":8908584,"change_date":"2025-06-16 21:39:00","inspection_id":"84962032","dot_number":"579952","report_state":"NH","report_number":"1128002618","insp_date":"2025-06-13 00:00:00","insp_start_time":"0916","insp_end_time":"0927","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT SIDE TOLLS","county_code_state":"NH","county_code":"013","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-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"285896","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:21.000000Z","updated_at":"2025-06-20T10:00:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14596289,"change_date":"2025-06-16 21:39:00","inspection_id":"84962032","insp_unit_id":"207403786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"65","insp_unit_license":"AH2870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3BKZXPTX1PF235688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:20.000000Z","updated_at":"2025-06-20T09:45:25.000000Z"}]},{"id":8988888,"change_date":"2025-06-26 21:40:00","inspection_id":"85047235","dot_number":"579952","report_state":"NH","report_number":"0963000003","insp_date":"2025-06-12 00:00:00","insp_start_time":"1340","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"021","location_desc":"HOOKSETT","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ADVANCED EXCAVATING & PAVING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-06-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"285915","transaction_code":"A","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-12 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-06-26 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:54.000000Z","updated_at":"2025-06-30T10:00:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14741313,"change_date":"2025-06-26 21:40:00","inspection_id":"85047235","insp_unit_id":"207562629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AF9421","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPTX4EX2LD638987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:12.000000Z","updated_at":"2025-07-01T09:47:10.000000Z"}]},{"id":8329056,"change_date":"2025-04-14 21:41:00","inspection_id":"84350064","dot_number":"579952","report_state":"VT","report_number":"51A0001146","insp_date":"2025-04-01 00:00:00","insp_start_time":"1150","insp_end_time":"1210","registration_date":"2025-04-11 00:00:00","region":"ET","ci_status_code":"C","location":"0909SB","location_desc":"RANDOLPH SB RA","county_code_state":"VT","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"215432","transaction_code":"C","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-01 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-04-09 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-12T10:24:15.000000Z","updated_at":"2025-04-18T10:22:14.000000Z","inspection_violations":[{"id":13185785,"change_date":"2025-04-14 21:41:00","inspection_id":"84350064","insp_violation_id":"265604295","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"206298309","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-17T10:23:50.000000Z","updated_at":"2025-04-18T10:39:52.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":13579596,"change_date":"2025-04-14 21:41:00","inspection_id":"84350064","insp_unit_id":"206298308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"P27","insp_unit_license":"5130295","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3YSEY3PF109452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:53:53.000000Z","updated_at":"2025-04-18T09:56:48.000000Z"},{"id":13579597,"change_date":"2025-04-14 21:41:00","inspection_id":"84350064","insp_unit_id":"206298309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"T733654","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5WFBF2224JW085336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:53:53.000000Z","updated_at":"2025-04-18T09:56:48.000000Z"}]},{"id":7248539,"change_date":"2024-11-21 21:41:00","inspection_id":"83214071","dot_number":"579952","report_state":"NH","report_number":"1292002295","insp_date":"2024-11-20 00:00:00","insp_start_time":"1246","insp_end_time":"1259","registration_date":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"280478","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:16.000000Z","updated_at":"2025-03-17T20:47:16.000000Z","inspection_violations":[{"id":11331082,"change_date":"2024-11-21 21:41:00","inspection_id":"83214071","insp_violation_id":"263016888","seq_no":"1","part_no":"392","part_no_section":"16AD","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-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":11691691,"change_date":"2024-11-21 21:41:00","inspection_id":"83214071","insp_unit_id":"203989156","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"AH2870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3BKZXPTX1PF235688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:11.000000Z","updated_at":"2025-03-17T23:44:11.000000Z"}]},{"id":7080345,"change_date":"2024-10-30 21:40:00","inspection_id":"83036040","dot_number":"579952","report_state":"NH","report_number":"1128002104","insp_date":"2024-10-29 00:00:00","insp_start_time":"1416","insp_end_time":"1441","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT","county_code_state":"NH","county_code":"013","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"198000","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":"279790","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-29 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:49.000000Z","updated_at":"2025-03-17T20:43:49.000000Z","inspection_violations":[{"id":11054189,"change_date":"2024-10-30 21:40:00","inspection_id":"83036040","insp_violation_id":"262634547","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","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:59:37.000000Z","updated_at":"2025-03-17T21:59:37.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":11418906,"change_date":"2024-10-30 21:40:00","inspection_id":"83036040","insp_unit_id":"203654362","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"14AP28","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1XKZP4TX3RJ370745","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:14.000000Z","updated_at":"2025-03-17T23:41:14.000000Z"},{"id":11418907,"change_date":"2024-10-30 21:40:00","inspection_id":"83036040","insp_unit_id":"203654363","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":"T1","insp_unit_license":"6117TW","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1E92988178E111038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:14.000000Z","updated_at":"2025-03-17T23:41:14.000000Z"}]},{"id":5379132,"change_date":"2024-03-27 21:42:00","inspection_id":"81206769","dot_number":"579952","report_state":"NH","report_number":"1128001586","insp_date":"2024-03-26 00:00:00","insp_start_time":"1534","insp_end_time":"1549","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT BY HEAD POND TRAIL","county_code_state":"NH","county_code":"013","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-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"273887","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-26 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:07.000000Z","updated_at":"2025-03-17T20:09:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8663123,"change_date":"2024-03-27 21:42:00","inspection_id":"81206769","insp_unit_id":"200109921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"22","insp_unit_license":"AH2886","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NKZX4TX7PJ215686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"},{"id":8663124,"change_date":"2024-03-27 21:42:00","inspection_id":"81206769","insp_unit_id":"200109922","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"INTER","insp_unit_company":null,"insp_unit_license":"T507319","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1JKDLA506HM015536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":5243336,"change_date":"2024-03-08 21:39:00","inspection_id":"81058849","dot_number":"579952","report_state":"NH","report_number":"1085003880","insp_date":"2024-03-08 00:00:00","insp_start_time":"0800","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ALLENSTOWN","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"273431","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-08 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:39.000000Z","updated_at":"2025-03-17T20:06:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8443137,"change_date":"2024-03-08 21:39:00","inspection_id":"81058849","insp_unit_id":"199821927","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"65","insp_unit_license":"AH2870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3BKZXPTX1PF235688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:30.000000Z","updated_at":"2025-03-17T23:11:30.000000Z"}]},{"id":4567336,"change_date":"2023-12-06 21:41:00","inspection_id":"80319961","dot_number":"579952","report_state":"NH","report_number":"1128001308","insp_date":"2023-12-05 00:00:00","insp_start_time":"1330","insp_end_time":"1347","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PEMBROKE","county_code_state":"NH","county_code":"013","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":"2023-12-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","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":"271393","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-06 21:41:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","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":[],"inspection_per_units":[{"id":7345801,"change_date":"2023-12-06 21:41:00","inspection_id":"80319961","insp_unit_id":"198369672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"AF3102","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NP5XBTX33N590250","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":4430318,"change_date":"2023-11-17 21:40:00","inspection_id":"80169240","dot_number":"579952","report_state":"NH","report_number":"1313000007","insp_date":"2023-11-14 00:00:00","insp_start_time":"0956","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":"031","location_desc":"81 CONTINENTAL BLVD MERRIMACK","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ADVANCED EXCAVATING & PAVING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-11-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"270955","transaction_code":"C","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-14 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:43.000000Z","updated_at":"2025-03-17T19:50:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7124610,"change_date":"2023-11-17 21:40:00","inspection_id":"80169240","insp_unit_id":"198115931","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"AH1632","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NKZXPTX0MJ422594","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:48.000000Z","updated_at":"2025-03-17T22:59:48.000000Z"}]},{"id":3896028,"change_date":"2023-09-05 21:40:00","inspection_id":"79577182","dot_number":"579952","report_state":"NH","report_number":"1128001011","insp_date":"2023-09-01 00:00:00","insp_start_time":"1253","insp_end_time":"1306","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT BY HEAD POND TRAIL","county_code_state":"NH","county_code":"013","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":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"268987","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6263885,"change_date":"2023-09-05 21:40:00","inspection_id":"79577182","insp_unit_id":"196882003","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"3476659","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3KZC89DF192250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":3762166,"change_date":"2023-08-17 21:42:00","inspection_id":"79427426","dot_number":"579952","report_state":"NH","report_number":"1085003402","insp_date":"2023-08-15 00:00:00","insp_start_time":"0910","insp_end_time":"0932","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ALLENSTOWN","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"268417","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:15.000000Z","updated_at":"2025-03-17T19:37:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6049175,"change_date":"2023-08-17 21:42:00","inspection_id":"79427426","insp_unit_id":"196573601","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"AF3102","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NP5XBTX33N590250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3484191,"change_date":"2023-09-06 21:42:00","inspection_id":"79116521","dot_number":"579952","report_state":"NH","report_number":"1128000923","insp_date":"2023-07-11 00:00:00","insp_start_time":"1804","insp_end_time":"1945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PARK & RIDE HOOKSETT SIDE TOLL","county_code_state":"NH","county_code":"013","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":"2023-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"27200","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"267533","transaction_code":"C","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-11 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:03.000000Z","updated_at":"2025-03-17T19:32:03.000000Z","inspection_violations":[{"id":5373660,"change_date":"2023-09-06 21:42:00","inspection_id":"79116521","insp_violation_id":"255097286","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:31:56.000000Z","updated_at":"2025-03-17T21:31:56.000000Z","normalized_code":"38323A2"},{"id":5373661,"change_date":"2023-09-06 21:42:00","inspection_id":"79116521","insp_violation_id":"255097287","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ARREST","created_at":"2025-03-17T21:31:56.000000Z","updated_at":"2025-03-17T21:31:56.000000Z","normalized_code":"3922"},{"id":5373662,"change_date":"2023-09-06 21:42:00","inspection_id":"79116521","insp_violation_id":"255097288","seq_no":"3","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":"23-887-000846","created_at":"2025-03-17T21:31:56.000000Z","updated_at":"2025-03-17T21:31:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5602737,"change_date":"2023-09-06 21:42:00","inspection_id":"79116521","insp_unit_id":"196911384","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"4205969","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3KYCY9HF180597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"},{"id":5602738,"change_date":"2023-09-06 21:42:00","inspection_id":"79116521","insp_unit_id":"196911385","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TOPHA","insp_unit_company":null,"insp_unit_license":"T606935","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"4R7BU2020KT188548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"}]},{"id":2997700,"change_date":"2023-05-09 21:41:00","inspection_id":"78567997","dot_number":"579952","report_state":"NH","report_number":"1085003052","insp_date":"2023-05-08 00:00:00","insp_start_time":"0717","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"265946","transaction_code":"A","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-08 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-05-09 21:41:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:18.000000Z","updated_at":"2025-03-17T19:22:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4823090,"change_date":"2023-05-09 21:41:00","inspection_id":"78567997","insp_unit_id":"194822672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"25","insp_unit_license":"AF7926","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPTX4EX2JD452170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:00.000000Z","updated_at":"2025-03-17T22:41:00.000000Z"}]},{"id":2836259,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","dot_number":"579952","report_state":"NH","report_number":"1128000776","insp_date":"2023-04-19 00:00:00","insp_start_time":"0624","insp_end_time":"0706","registration_date":"2023-04-25 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT","county_code_state":"NH","county_code":"013","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"211700","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"265707","transaction_code":"C","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-19 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-04-19 21:41:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:57.000000Z","updated_at":"2025-03-17T19:18:57.000000Z","inspection_violations":[{"id":4351138,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_violation_id":"252414266","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194562252","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3922"},{"id":4351139,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_violation_id":"252414267","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194562253","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3922"},{"id":4351140,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_violation_id":"252414268","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194562253","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3922"},{"id":4351141,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_violation_id":"252414269","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194562253","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3922"},{"id":4351142,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_violation_id":"252414270","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194562252","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4564985,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_unit_id":"194562252","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"AP2179","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1XPXD40X0AD796071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"},{"id":4564986,"change_date":"2023-04-25 21:39:00","inspection_id":"78385205","insp_unit_id":"194562253","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":"T-1","insp_unit_license":"6117TW","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1E92988178E111038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"}]},{"id":2813992,"change_date":"2023-04-26 21:41:00","inspection_id":"78360114","dot_number":"579952","report_state":"NH","report_number":"1128000758","insp_date":"2023-04-14 00:00:00","insp_start_time":"1022","insp_end_time":"1046","registration_date":"2023-04-26 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT INSPECTION PULLOFF","county_code_state":"NH","county_code":"013","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":"2023-04-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","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":"265586","transaction_code":"C","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-14 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-04-17 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:32.000000Z","updated_at":"2025-03-17T19:18:32.000000Z","inspection_violations":[{"id":4318210,"change_date":"2023-04-26 21:41:00","inspection_id":"78360114","insp_violation_id":"252442164","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:27:10.000000Z","updated_at":"2025-03-17T21:27:10.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":4529078,"change_date":"2023-04-26 21:41:00","inspection_id":"78360114","insp_unit_id":"194586180","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"P28","insp_unit_license":"5165426","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3YSEY3PF109130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:42.000000Z","updated_at":"2025-03-17T22:38:42.000000Z"},{"id":4529079,"change_date":"2023-04-26 21:41:00","inspection_id":"78360114","insp_unit_id":"194586181","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEHN","insp_unit_company":null,"insp_unit_license":"T732165","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"4L5ST2721PF067856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:42.000000Z","updated_at":"2025-03-17T22:38:42.000000Z"}]},{"id":1778532,"change_date":"2022-11-30 21:40:00","inspection_id":"77178516","dot_number":"579952","report_state":"NH","report_number":"1292000991","insp_date":"2022-11-18 00:00:00","insp_start_time":"0844","insp_end_time":"0905","registration_date":"2022-11-30 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":"2022-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"262312","transaction_code":"C","transaction_date":"2022-11-18 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-11-21 21:40:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:21.000000Z","updated_at":"2025-03-17T18:59:21.000000Z","inspection_violations":[{"id":2784097,"change_date":"2022-11-30 21:40:00","inspection_id":"77178516","insp_violation_id":"249842840","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:05.000000Z","updated_at":"2025-03-17T21:20:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2861307,"change_date":"2022-11-30 21:40:00","inspection_id":"77178516","insp_unit_id":"192184381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"AH2870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3BKZXPTX1PF235688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:35.000000Z","updated_at":"2025-03-17T22:26:35.000000Z"}]},{"id":1673873,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","dot_number":"579952","report_state":"NH","report_number":"1085002565","insp_date":"2022-11-03 00:00:00","insp_start_time":"1050","insp_end_time":"1151","registration_date":"2022-11-30 00:00:00","region":"ET","ci_status_code":"C","location":null,"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":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":"2022-11-04 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"27200","viol_total":"6","oos_total":"3","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"261939","transaction_code":"C","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00579952","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-03 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-11-04 21:37:00","insp_carrier_name":"ADVANCED EXCAVATING & PAVING LLC","insp_carrier_street":"166 GRANITE STREET","insp_carrier_city":"ALLENSTOWN","insp_carrier_state":"NH","insp_carrier_zip_code":"03275","insp_colonia":null,"docket_number":"746893","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:26.000000Z","updated_at":"2025-03-17T18:57:26.000000Z","inspection_violations":[{"id":2625360,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_violation_id":"249842870","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"38323A2"},{"id":2625361,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_violation_id":"249842871","seq_no":"2","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3927A"},{"id":2625362,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_violation_id":"249842872","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39216A"},{"id":2625363,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_violation_id":"249842873","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192184414","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3922"},{"id":2625364,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_violation_id":"249842874","seq_no":"5","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"192184414","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39341"},{"id":2625365,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_violation_id":"249842875","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192184415","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2692672,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_unit_id":"192184414","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"3476659","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3KZC89DF192250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"},{"id":2692673,"change_date":"2022-11-30 21:40:00","inspection_id":"77058487","insp_unit_id":"192184415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOPHA","insp_unit_company":null,"insp_unit_license":"T606935","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"4R7BU2020KT188548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/579952\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/579952\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/579952\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/579952\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}