{"current_page":1,"data":[{"id":11789251,"change_date":"2026-05-04 21:39:00","inspection_id":"87720968","dot_number":"2917470","report_state":"NH","report_number":"0996001171","insp_date":"2026-04-14 00:00:00","insp_start_time":"1308","insp_end_time":"1350","registration_date":"2026-04-29 00:00:00","region":"ED","ci_status_code":"C","location":"011","location_desc":"NH","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":"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":"2026-04-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3235249","transaction_code":"C","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02917470","upload_search_indicator":null,"census_search_date":"2026-04-30 21:40:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-30 21:40:00","insp_carrier_name":"WILLIAM P DAVIS EXCAVATION LLC","insp_carrier_street":"19 LAFAYETTE ROAD","insp_carrier_city":"HAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03842","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:50.000000Z","updated_at":"2026-05-14T12:30:15.000000Z","inspection_violations":[{"id":20501819,"change_date":"2026-05-04 21:39:00","inspection_id":"87720968","insp_violation_id":"274026619","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":"2026-05-03T10:01:26.000000Z","updated_at":"2026-05-14T12:42:37.000000Z","normalized_code":"3922SLLTCD"},{"id":20501821,"change_date":"2026-05-04 21:39:00","inspection_id":"87720968","insp_violation_id":"274026621","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"1","insp_unit_id":"213368112","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-03T10:01:26.000000Z","updated_at":"2026-05-14T12:42:37.000000Z","normalized_code":"393110B3C"},{"id":20501822,"change_date":"2026-05-04 21:39:00","inspection_id":"87720968","insp_violation_id":"274026622","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213368112","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:26.000000Z","updated_at":"2026-05-14T12:42:37.000000Z","normalized_code":"39395A1"},{"id":20501820,"change_date":"2026-05-04 21:39:00","inspection_id":"87720968","insp_violation_id":"274026620","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213368112","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:26.000000Z","updated_at":"2026-05-14T12:42:37.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20508128,"change_date":"2026-05-04 21:39:00","inspection_id":"87720968","insp_unit_id":"213368112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"5033420","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1HTKJPVK6LH682108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:38.000000Z","updated_at":"2026-05-14T11:47:35.000000Z"}]},{"id":9958736,"change_date":"2025-10-29 21:40:00","inspection_id":"86066717","dot_number":"2917470","report_state":"MA","report_number":"BV00007992","insp_date":"2025-10-15 00:00:00","insp_start_time":"1620","insp_end_time":"1644","registration_date":"2025-10-29 00:00:00","region":"ET","ci_status_code":"C","location":"142H","location_desc":"H-HAVERHILL","county_code_state":"MA","county_code":"009","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":"2025-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"531536","transaction_code":"C","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02917470","upload_search_indicator":"M","census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"WILLIAM P DAVIS EXCAVATION LLC","insp_carrier_street":"19 LAFAYETTE ROAD","insp_carrier_city":"HAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03842","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:40.000000Z","updated_at":"2025-11-02T11:00:24.000000Z","inspection_violations":[{"id":16661113,"change_date":"2025-10-29 21:40:00","inspection_id":"86066717","insp_violation_id":"269590412","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-01T10:17:42.000000Z","updated_at":"2025-11-02T11:15:40.000000Z","normalized_code":"3922SLLLR"},{"id":16661114,"change_date":"2025-10-29 21:40:00","inspection_id":"86066717","insp_violation_id":"269590413","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:42.000000Z","updated_at":"2025-11-02T11:15:40.000000Z","normalized_code":"39141APC"},{"id":16661115,"change_date":"2025-10-29 21:40:00","inspection_id":"86066717","insp_violation_id":"269590414","seq_no":"3","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-01T10:17:42.000000Z","updated_at":"2025-11-02T11:15:40.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16723278,"change_date":"2025-10-29 21:40:00","inspection_id":"86066717","insp_unit_id":"209714390","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"4156316","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3KYCGXGF147713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:57.000000Z","updated_at":"2025-11-02T10:45:32.000000Z"}]},{"id":10077574,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","dot_number":"2917470","report_state":"NH","report_number":"0996000898","insp_date":"2025-09-24 00:00:00","insp_start_time":"0601","insp_end_time":"1000","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"5","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":"Y","gross_comb_veh_wt":"60000","viol_total":"5","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2480004","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":"02917470","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"WILLIAM P DAVIS EXCAVATION LLC","insp_carrier_street":"19 LAFAYETTE ROAD","insp_carrier_city":"HAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03842","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:11.000000Z","updated_at":"2025-11-03T11:00:51.000000Z","inspection_violations":[{"id":16691250,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","insp_violation_id":"269617728","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209739167","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-02T11:17:56.000000Z","updated_at":"2025-11-03T11:16:08.000000Z","normalized_code":"39375A3TAOL"},{"id":16691251,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","insp_violation_id":"269617729","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209739167","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-02T11:17:56.000000Z","updated_at":"2025-11-03T11:16:08.000000Z","normalized_code":"39375A3TAOL"},{"id":16691252,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","insp_violation_id":"269617730","seq_no":"3","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"209739167","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-02T11:17:56.000000Z","updated_at":"2025-11-03T11:16:08.000000Z","normalized_code":"393207ASAPPAS"},{"id":16691253,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","insp_violation_id":"269617731","seq_no":"4","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"209739167","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-02T11:17:56.000000Z","updated_at":"2025-11-03T11:16:08.000000Z","normalized_code":"393207ASAPPAS"},{"id":16691254,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","insp_violation_id":"269617732","seq_no":"5","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"209739167","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:56.000000Z","updated_at":"2025-11-03T11:16:08.000000Z","normalized_code":"39311A1LCHL"}],"inspection_per_units":[{"id":16752735,"change_date":"2025-10-30 21:42:00","inspection_id":"86191728","insp_unit_id":"209739167","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"8AP452","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2P324C51M056723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:01.000000Z"}]},{"id":7380061,"change_date":"2024-12-30 21:38:00","inspection_id":"83352848","dot_number":"2917470","report_state":"MA","report_number":"BV00007048","insp_date":"2024-12-09 00:00:00","insp_start_time":"1642","insp_end_time":"1701","registration_date":"2024-12-30 00:00:00","region":"ET","ci_status_code":"C","location":"142H","location_desc":"H-HAVERHILL","county_code_state":"MA","county_code":"009","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-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"504999","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02917470","upload_search_indicator":"M","census_search_date":"2024-12-10 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-10 21:41:00","insp_carrier_name":"WILLIAM P DAVIS EXCAVATION LLC","insp_carrier_street":"19 LAFAYETTE ROAD","insp_carrier_city":"HAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03842","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:15.000000Z","updated_at":"2025-03-17T20:50:15.000000Z","inspection_violations":[{"id":11530006,"change_date":"2024-12-30 21:38:00","inspection_id":"83352848","insp_violation_id":"263689436","seq_no":"1","part_no":"393","part_no_section":"9B-LIL","insp_viol_unit":"1","insp_unit_id":"204588462","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3939BLIL"}],"inspection_per_units":[{"id":11905249,"change_date":"2024-12-30 21:38:00","inspection_id":"83352848","insp_unit_id":"204588462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"5033420","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTKJPVK6LH682108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:28.000000Z","updated_at":"2025-03-17T23:46:28.000000Z"}]},{"id":7091954,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","dot_number":"2917470","report_state":"NH","report_number":"0850001542","insp_date":"2024-10-30 00:00:00","insp_start_time":"1145","insp_end_time":"1425","registration_date":null,"region":"ED","ci_status_code":"C","location":"237","location_desc":"NH","county_code_state":"NH","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WILLIAM P DAVIS EXCAVATION 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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"29450","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2660611","transaction_code":"C","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02917470","upload_search_indicator":null,"census_search_date":"2024-10-31 21:42:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-31 21:42:00","insp_carrier_name":"WILLIAM P DAVIS EXCAVATION LLC","insp_carrier_street":"252 WINNACUNNET RD","insp_carrier_city":"HAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03842","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:52.000000Z","updated_at":"2025-12-26T10:30:14.000000Z","inspection_violations":[{"id":11073963,"change_date":"2024-12-30 21:39:00","inspection_id":"83048336","insp_violation_id":"263690503","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"204589482","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"3922SLLSR"},{"id":17493967,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_violation_id":"270681661","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210606045","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:36.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","normalized_code":"39395A1"},{"id":17493968,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_violation_id":"270681662","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"210606045","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:36.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","normalized_code":"39395F"},{"id":17493969,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_violation_id":"270681663","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210606045","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:36.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","normalized_code":"3922SLLSR"},{"id":17493970,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_violation_id":"270681664","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210606046","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:36.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","normalized_code":"3922SLLSR"},{"id":17493971,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_violation_id":"270681665","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210606046","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:36.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","normalized_code":"3922SLLSR"},{"id":17493972,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_violation_id":"270681666","seq_no":"6","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-12-18T10:30:36.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":17452262,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_unit_id":"210606045","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"12","insp_unit_license":"5033420","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1HTKJPVK6LH682108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:26.000000Z","updated_at":"2025-12-26T10:00:22.000000Z"},{"id":17452263,"change_date":"2025-12-15 21:39:00","inspection_id":"83048336","insp_unit_id":"210606046","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"T762393","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"58CB1EK20GC002370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:26.000000Z","updated_at":"2025-12-26T10:00:22.000000Z"}]},{"id":4649681,"change_date":"2023-12-20 21:41:00","inspection_id":"80410316","dot_number":"2917470","report_state":"NH","report_number":"1325000013","insp_date":"2023-12-15 00:00:00","insp_start_time":"0951","insp_end_time":"1037","registration_date":"2023-12-20 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 125 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-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"31800","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":"271703","transaction_code":"C","transaction_date":"2023-12-15 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02917470","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"WILLIAM P DAVIS EXCAVATION LLC","insp_carrier_street":"19 LAFAYETTE ROAD","insp_carrier_city":"HAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03842","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:58.000000Z","updated_at":"2025-03-17T19:54:58.000000Z","inspection_violations":[{"id":7188655,"change_date":"2023-12-20 21:41:00","inspection_id":"80410316","insp_violation_id":"256978812","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:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"39216A"},{"id":7188656,"change_date":"2023-12-20 21:41:00","inspection_id":"80410316","insp_violation_id":"256978813","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7478128,"change_date":"2023-12-20 21:41:00","inspection_id":"80410316","insp_unit_id":"198590447","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"5033420","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1HTKJPVK6LH682108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"},{"id":7478129,"change_date":"2023-12-20 21:41:00","inspection_id":"80410316","insp_unit_id":"198590448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"T479069","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5FTCE2620M1000136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2917470\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2917470\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2917470\/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\/2917470\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}