{"current_page":1,"data":[{"id":12148832,"change_date":"2026-06-10 21:44:00","inspection_id":"88097773","dot_number":"525535","report_state":"NH","report_number":"1085005021","insp_date":"2026-01-20 00:00:00","insp_start_time":"1256","insp_end_time":"1310","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"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":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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44: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":"3510057","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:29.000000Z","updated_at":"2026-06-21T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21105188,"change_date":"2026-06-10 21:44:00","inspection_id":"88097773","insp_unit_id":"214016533","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"85","insp_unit_license":"AF3104","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2GR4GC3KM003641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:55.000000Z","updated_at":"2026-06-21T09:02:19.000000Z"}]},{"id":12148523,"change_date":"2026-06-10 21:44:00","inspection_id":"88097435","dot_number":"525535","report_state":"NH","report_number":"1230001907","insp_date":"2026-01-14 00:00:00","insp_start_time":"1000","insp_end_time":"1044","registration_date":null,"region":"ES","ci_status_code":"C","location":"004","location_desc":"NH","county_code_state":"NH","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","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":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3509719","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:28.000000Z","updated_at":"2026-06-21T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21104812,"change_date":"2026-06-10 21:44:00","inspection_id":"88097435","insp_unit_id":"214016094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"20","insp_unit_license":"2190530","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDUF5HT8JEC81234","insp_unit_decal":"Y","insp_unit_decal_number":"36125817","created_at":"2026-06-13T09:17:54.000000Z","updated_at":"2026-06-21T09:02:19.000000Z"}]},{"id":9726936,"change_date":"2025-09-19 21:38:00","inspection_id":"85823040","dot_number":"525535","report_state":"NH","report_number":"1078008653","insp_date":"2025-09-05 00:00:00","insp_start_time":"1140","insp_end_time":"1220","registration_date":"2025-09-19 00:00:00","region":"ED","ci_status_code":"C","location":"105","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":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":"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-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"2299487","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":"00525535","upload_search_indicator":null,"census_search_date":"2025-09-19 21:38:00","snet_input_date":"2025-09-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-19 21:38:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","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":15970918,"change_date":"2025-09-19 21:38:00","inspection_id":"85823040","insp_violation_id":"268802154","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-09-22T10:18:20.000000Z","updated_at":"2025-09-23T10:15:58.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":16107725,"change_date":"2025-09-19 21:38:00","inspection_id":"85823040","insp_unit_id":"209042651","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"AF3104","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2GR4GC3KM003641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:00.000000Z","updated_at":"2025-09-23T09:45:39.000000Z"}]},{"id":10079068,"change_date":"2025-10-30 21:42:00","inspection_id":"86193500","dot_number":"525535","report_state":"NH","report_number":"1325001044","insp_date":"2025-07-17 00:00:00","insp_start_time":"1120","insp_end_time":"1131","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":"Y","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":"84180","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":"2481957","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":"00525535","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":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","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:01.000000Z","inspection_violations":[{"id":16692779,"change_date":"2025-10-30 21:42:00","inspection_id":"86193500","insp_violation_id":"269620397","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:17:58.000000Z","updated_at":"2025-11-03T11:16:16.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16754466,"change_date":"2025-10-30 21:42:00","inspection_id":"86193500","insp_unit_id":"209741383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"AH2157","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX1PD850059","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":8642738,"change_date":"2025-05-30 21:40:00","inspection_id":"84680453","dot_number":"525535","report_state":"NH","report_number":"1086001808","insp_date":"2025-05-14 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":"2025-05-30 00:00:00","region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","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-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"285054","transaction_code":"C","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2025-05-15 21:43:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-05-15 21:43:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:04:14.000000Z","updated_at":"2025-06-04T10:00:59.000000Z","inspection_violations":[{"id":14021762,"change_date":"2025-05-30 21:40:00","inspection_id":"84680453","insp_violation_id":"266573821","seq_no":"1","part_no":"392","part_no_section":"8-D","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-06-02T10:16:54.000000Z","updated_at":"2025-06-03T10:16:39.000000Z","normalized_code":"3928D"}],"inspection_per_units":[{"id":14353756,"change_date":"2025-05-30 21:40:00","inspection_id":"84680453","insp_unit_id":"207148555","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"02","insp_unit_license":"3372568","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GD32VC83GF159958","insp_unit_decal":"Y","insp_unit_decal_number":"35284143","created_at":"2025-06-02T09:46:16.000000Z","updated_at":"2025-06-03T09:45:09.000000Z"}]},{"id":7929272,"change_date":"2025-02-21 21:40:00","inspection_id":"83929577","dot_number":"525535","report_state":"NH","report_number":"1291004068","insp_date":"2025-02-20 00:00:00","insp_start_time":"1048","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"170958","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-02-21 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":"282505","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2025-02-21 21:40:00","snet_input_date":"2025-02-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-21 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:50.000000Z","updated_at":"2025-03-17T21:02:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12799793,"change_date":"2025-02-21 21:40:00","inspection_id":"83929577","insp_unit_id":"205438902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"89","insp_unit_license":"AH2156","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX8PD850060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:22.000000Z","updated_at":"2025-03-17T23:56:22.000000Z"}]},{"id":6720376,"change_date":"2024-09-13 21:41:00","inspection_id":"82653258","dot_number":"525535","report_state":"NH","report_number":"1078007861","insp_date":"2024-09-12 00:00:00","insp_start_time":"0750","insp_end_time":"0809","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","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-09-13 21:41: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":"278560","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-09-13 21:41:00","snet_input_date":"2024-09-12 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-09-13 21:41:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:28.000000Z","updated_at":"2025-03-17T20:36:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10836204,"change_date":"2024-09-13 21:41:00","inspection_id":"82653258","insp_unit_id":"202910752","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AH2533","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCL40XXPD850058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"},{"id":10836205,"change_date":"2024-09-13 21:41:00","inspection_id":"82653258","insp_unit_id":"202910753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"T499604","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5FTFA3732H1000151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"}]},{"id":5992598,"change_date":"2024-06-14 21:40:00","inspection_id":"81874406","dot_number":"525535","report_state":"NH","report_number":"1128001798","insp_date":"2024-06-10 00:00:00","insp_start_time":"1022","insp_end_time":"1033","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GILFORD","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":"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-06-14 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":"275860","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:29.000000Z","updated_at":"2025-03-17T20:21:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9652189,"change_date":"2024-06-14 21:40:00","inspection_id":"81874406","insp_unit_id":"201396643","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"89","insp_unit_license":"AH2156","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX8PD850060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:02.000000Z","updated_at":"2025-03-17T23:23:02.000000Z"}]},{"id":5618585,"change_date":"2024-04-29 21:43:00","inspection_id":"81468308","dot_number":"525535","report_state":"NH","report_number":"1078007500","insp_date":"2024-04-11 00:00:00","insp_start_time":"1127","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"260","location_desc":"THORNTON","county_code_state":"NH","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:43: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":"274275","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-04-29 21:43:00","snet_input_date":"2024-04-11 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9050808,"change_date":"2024-04-29 21:43:00","inspection_id":"81468308","insp_unit_id":"200620359","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AH2156","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX8PD850060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":5243325,"change_date":"2024-03-08 21:39:00","inspection_id":"81058835","dot_number":"525535","report_state":"NH","report_number":"1291003287","insp_date":"2024-03-07 00:00:00","insp_start_time":"1104","insp_end_time":"1122","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"151167","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-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"273434","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-03-07 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","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":8443127,"change_date":"2024-03-08 21:39:00","inspection_id":"81058835","insp_unit_id":"199821910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"87","insp_unit_license":"AE7643","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C1HM034397","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":5224027,"change_date":"2024-03-06 21:40:00","inspection_id":"81037504","dot_number":"525535","report_state":"NH","report_number":"1230001235","insp_date":"2024-03-05 00:00:00","insp_start_time":"1037","insp_end_time":"1045","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":"NA","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-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"273362","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-03-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:11.000000Z","updated_at":"2025-03-17T20:06:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8412214,"change_date":"2024-03-06 21:40:00","inspection_id":"81037504","insp_unit_id":"199780486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"85","insp_unit_license":"AF3104","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2GR4GC3KM003641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:14.000000Z","updated_at":"2025-03-17T23:11:14.000000Z"}]},{"id":4984041,"change_date":"2024-02-06 21:41:00","inspection_id":"80775813","dot_number":"525535","report_state":"NH","report_number":"1078007354","insp_date":"2024-02-05 00:00:00","insp_start_time":"1117","insp_end_time":"1131","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-06 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":"272698","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-02-06 21:41:00","snet_input_date":"2024-02-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-02-06 21:41:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:36.000000Z","updated_at":"2025-03-17T20:01:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8021477,"change_date":"2024-02-06 21:41:00","inspection_id":"80775813","insp_unit_id":"199282248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AH2156","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX8PD850060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:42.000000Z","updated_at":"2025-03-17T23:07:42.000000Z"}]},{"id":4823121,"change_date":"2024-01-12 21:43:00","inspection_id":"80599780","dot_number":"525535","report_state":"NH","report_number":"1085003780","insp_date":"2024-01-11 00:00:00","insp_start_time":"1204","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","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-01-12 21:43: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":"272306","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2024-01-12 21:43:00","snet_input_date":"2024-01-11 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-01-12 21:43:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:24.000000Z","updated_at":"2025-03-17T19:58:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7759821,"change_date":"2024-01-12 21:43:00","inspection_id":"80599780","insp_unit_id":"198940177","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"82","insp_unit_license":"3120AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C1HM034366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:20.000000Z","updated_at":"2025-03-17T23:05:20.000000Z"}]},{"id":4680681,"change_date":"2023-12-21 21:38:00","inspection_id":"80444303","dot_number":"525535","report_state":"NH","report_number":"1059004599","insp_date":"2023-12-20 00:00:00","insp_start_time":"0813","insp_end_time":"0842","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","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-12-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"126700","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":"271817","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2023-12-21 21:38:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-21 21:38:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:44.000000Z","updated_at":"2025-03-17T19:55:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7528154,"change_date":"2023-12-21 21:38:00","inspection_id":"80444303","insp_unit_id":"198612906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AH2533","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCL40XXPD850058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:18.000000Z","updated_at":"2025-03-17T23:03:18.000000Z"},{"id":7528155,"change_date":"2023-12-21 21:38:00","inspection_id":"80444303","insp_unit_id":"198612907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"T499604","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5FTFA3732H1000151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:18.000000Z","updated_at":"2025-03-17T23:03:18.000000Z"}]},{"id":4567364,"change_date":"2023-12-06 21:41:00","inspection_id":"80319993","dot_number":"525535","report_state":"NH","report_number":"1291003123","insp_date":"2023-12-05 00:00:00","insp_start_time":"1047","insp_end_time":"1104","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"149127","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":"2023-12-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"271463","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":"00525535","upload_search_indicator":null,"census_search_date":"2023-12-06 21:41:00","snet_input_date":"2023-12-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-06 21:41:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","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":[],"inspection_per_units":[{"id":7345835,"change_date":"2023-12-06 21:41:00","inspection_id":"80319993","insp_unit_id":"198369714","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"85","insp_unit_license":"AF3104","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2GR4GC3KM003641","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":4545448,"change_date":"2023-12-04 21:40:00","inspection_id":"80295923","dot_number":"525535","report_state":"NH","report_number":"1078007228","insp_date":"2023-12-01 00:00:00","insp_start_time":"0946","insp_end_time":"1006","registration_date":null,"region":"ET","ci_status_code":"C","location":"080","location_desc":"CONCORD","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-04 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":"271350","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2023-12-04 21:40:00","snet_input_date":"2023-12-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-04 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:58.000000Z","updated_at":"2025-03-17T19:52:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7310455,"change_date":"2023-12-04 21:40:00","inspection_id":"80295923","insp_unit_id":"198322392","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AH2157","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX1PD850059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"}]},{"id":3669063,"change_date":"2023-08-04 21:40:00","inspection_id":"79323853","dot_number":"525535","report_state":"NH","report_number":"1058002269","insp_date":"2023-08-03 00:00:00","insp_start_time":"0728","insp_end_time":"0822","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BROX","shipping_paper_number":"138758","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-08-04 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":"268206","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2023-08-04 21:40:00","snet_input_date":"2023-08-03 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-04 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:17.000000Z","updated_at":"2025-03-17T19:35:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5898885,"change_date":"2023-08-04 21:40:00","inspection_id":"79323853","insp_unit_id":"196360766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84","insp_unit_license":"AH2157","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX1PD850059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:35.000000Z","updated_at":"2025-03-17T22:49:35.000000Z"}]},{"id":2652092,"change_date":"2023-03-28 21:40:00","inspection_id":"78175515","dot_number":"525535","report_state":"NH","report_number":"1085002940","insp_date":"2023-03-23 00:00:00","insp_start_time":"0957","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SANBORNTON","county_code_state":"NH","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-28 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":"265076","transaction_code":"C","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":"M","census_search_date":"2023-03-28 21:40:00","snet_input_date":"2023-03-23 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-03-24 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:33.000000Z","updated_at":"2025-03-17T19:15:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4269704,"change_date":"2023-03-28 21:40:00","inspection_id":"78175515","insp_unit_id":"194088738","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"59","insp_unit_license":"2125992","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1GB3CYCG2GF153020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:37.000000Z","updated_at":"2025-03-17T22:36:37.000000Z"}]},{"id":2620998,"change_date":"2023-03-21 21:41:00","inspection_id":"78140415","dot_number":"525535","report_state":"NH","report_number":"1078006552","insp_date":"2023-03-20 00:00:00","insp_start_time":"0745","insp_end_time":"0801","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-03-21 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":"264979","transaction_code":"A","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2023-03-21 21:41:00","snet_input_date":"2023-03-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:08.000000Z","updated_at":"2025-03-17T19:15:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4219071,"change_date":"2023-03-21 21:41:00","inspection_id":"78140415","insp_unit_id":"193971579","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"AE7644","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C3HM034398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"}]},{"id":2176489,"change_date":"2023-01-19 21:43:00","inspection_id":"77634063","dot_number":"525535","report_state":"NH","report_number":"1292001068","insp_date":"2023-01-18 00:00:00","insp_start_time":"0845","insp_end_time":"0901","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":"2023-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"263660","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2023-01-19 21:43:00","snet_input_date":"2023-01-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-01-19 21:43:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3502871,"change_date":"2023-01-19 21:43:00","inspection_id":"77634063","insp_unit_id":"192944825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AH2533","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCL40XXPD850058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":2001458,"change_date":"2022-12-23 21:33:00","inspection_id":"77433739","dot_number":"525535","report_state":"NH","report_number":"1085002702","insp_date":"2022-12-21 00:00:00","insp_start_time":"1410","insp_end_time":"1432","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","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":"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":"2022-12-22 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":"262987","transaction_code":"C","transaction_date":"2022-12-22 00:00:00","upload_date":"2022-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-12-22 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-12-22 21:39:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:38.000000Z","updated_at":"2025-03-17T19:03:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3219873,"change_date":"2022-12-23 21:33:00","inspection_id":"77433739","insp_unit_id":"192567480","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"90","insp_unit_license":"AE7644","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C3HM034398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:02.000000Z","updated_at":"2025-03-17T22:29:02.000000Z"}]},{"id":1969171,"change_date":"2022-12-19 21:40:00","inspection_id":"77396905","dot_number":"525535","report_state":"NH","report_number":"1085002679","insp_date":"2022-12-15 00:00:00","insp_start_time":"0748","insp_end_time":"0804","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","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":"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":"2022-12-19 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":"262878","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-12-19 21:40:00","snet_input_date":"2022-12-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-12-19 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:56.000000Z","updated_at":"2025-03-17T19:02:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3168140,"change_date":"2022-12-19 21:40:00","inspection_id":"77396905","insp_unit_id":"192476826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"85","insp_unit_license":"AF3104","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2GR4GC3KM003641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"}]},{"id":1969183,"change_date":"2022-12-19 21:40:00","inspection_id":"77396918","dot_number":"525535","report_state":"NH","report_number":"1291002588","insp_date":"2022-12-15 00:00:00","insp_start_time":"1030","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","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":"125812","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-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"262850","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-12-19 21:40:00","snet_input_date":"2022-12-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-12-19 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:56.000000Z","updated_at":"2025-03-17T19:02:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3168155,"change_date":"2022-12-19 21:40:00","inspection_id":"77396918","insp_unit_id":"192476854","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"90","insp_unit_license":"AE7644","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C3HM034398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"}]},{"id":1778545,"change_date":"2022-11-21 21:40:00","inspection_id":"77178532","dot_number":"525535","report_state":"NH","report_number":"1078006330","insp_date":"2022-11-18 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","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":"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-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"262348","transaction_code":"A","transaction_date":"2022-11-18 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-11-21 21:40:00","snet_input_date":"2022-11-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-11-21 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","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":[],"inspection_per_units":[{"id":2861322,"change_date":"2022-11-21 21:40:00","inspection_id":"77178532","insp_unit_id":"192045572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2190530","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDUF5HT8JEC81234","insp_unit_decal":"Y","insp_unit_decal_number":"32075957","created_at":"2025-03-17T22:26:35.000000Z","updated_at":"2025-03-17T22:26:35.000000Z"}]},{"id":1299702,"change_date":"2022-10-05 21:40:00","inspection_id":"76626247","dot_number":"525535","report_state":"NH","report_number":"1085999855","insp_date":"2022-09-15 00:00:00","insp_start_time":"1500","insp_end_time":"1517","registration_date":"2022-10-05 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","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":"N","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-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"260627","transaction_code":"C","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-09-16 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:31.000000Z","updated_at":"2025-03-17T18:50:31.000000Z","inspection_violations":[{"id":2056491,"change_date":"2022-10-05 21:40:00","inspection_id":"76626247","insp_violation_id":"248836902","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:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2092056,"change_date":"2022-10-05 21:40:00","inspection_id":"76626247","insp_unit_id":"191273651","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"85","insp_unit_license":"AF3104","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2GR4GC3KM003641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:21.000000Z","updated_at":"2025-03-17T22:21:21.000000Z"}]},{"id":1166584,"change_date":"2022-08-30 21:40:00","inspection_id":"76471788","dot_number":"525535","report_state":"NH","report_number":"1085002360","insp_date":"2022-08-29 00:00:00","insp_start_time":"0737","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","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":"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":"2022-08-30 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":"259898","transaction_code":"A","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-08-30 21:40:00","snet_input_date":"2022-08-29 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:17.000000Z","updated_at":"2025-03-17T18:48:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1875960,"change_date":"2022-08-30 21:40:00","inspection_id":"76471788","insp_unit_id":"190613696","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"89","insp_unit_license":"AH2156","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1NPCX4TX8PD850060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:55.000000Z","updated_at":"2025-03-17T22:19:55.000000Z"}]},{"id":869976,"change_date":"2022-07-22 21:39:00","inspection_id":"76125346","dot_number":"525535","report_state":"NH","report_number":"0876004382","insp_date":"2022-07-20 00:00:00","insp_start_time":"1230","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ANDREWS CONSTRUCTION CO INC","shipping_paper_number":"114603","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":"2022-07-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"258790","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-07-22 21:39:00","snet_input_date":"2022-07-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-22 21:39:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1400458,"change_date":"2022-07-22 21:39:00","inspection_id":"76125346","insp_unit_id":"189909543","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"82","insp_unit_license":"3120AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C1HM034366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:48.000000Z","updated_at":"2025-03-17T22:16:48.000000Z"}]},{"id":852832,"change_date":"2022-08-04 21:42:00","inspection_id":"76105289","dot_number":"525535","report_state":"NH","report_number":"1085002273","insp_date":"2022-07-19 00:00:00","insp_start_time":"1455","insp_end_time":"1513","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","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":"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":"2022-07-20 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":"258616","transaction_code":"C","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-07-20 21:41:00","snet_input_date":"2022-07-19 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-20 21:41:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:41.000000Z","updated_at":"2025-03-17T18:42:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1372718,"change_date":"2022-08-04 21:42:00","inspection_id":"76105289","insp_unit_id":"190129093","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"87","insp_unit_license":"AE7643","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C1HM034397","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:37.000000Z","updated_at":"2025-03-17T22:16:37.000000Z"}]},{"id":667039,"change_date":"2022-06-22 21:40:00","inspection_id":"75887625","dot_number":"525535","report_state":"NH","report_number":"1085002215","insp_date":"2022-06-22 00:00:00","insp_start_time":"0632","insp_end_time":"0653","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NORTHFIELD","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":"2022-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"257826","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-06-22 21:40:00","snet_input_date":"2022-06-22 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-06-22 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:30.000000Z","updated_at":"2025-03-17T18:39:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1072062,"change_date":"2022-06-22 21:40:00","inspection_id":"75887625","insp_unit_id":"189394849","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"T-87","insp_unit_license":"AE7643","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C1HM034397","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:47.000000Z","updated_at":"2025-03-17T22:14:47.000000Z"}]},{"id":667017,"change_date":"2022-06-22 21:40:00","inspection_id":"75887595","dot_number":"525535","report_state":"NH","report_number":"1274002227","insp_date":"2022-06-21 00:00:00","insp_start_time":"1434","insp_end_time":"1453","registration_date":null,"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":"OSSIPEE AGGREAGATES CORP","shipping_paper_number":"1035565","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":"2022-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"257824","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00525535","upload_search_indicator":null,"census_search_date":"2022-06-22 21:40:00","snet_input_date":"2022-06-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-06-22 21:40:00","insp_carrier_name":"ANDREWS CONSTRUCTION CO INC","insp_carrier_street":"392 NH RTE 49","insp_carrier_city":"CAMPTON","insp_carrier_state":"NH","insp_carrier_zip_code":"03223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:30.000000Z","updated_at":"2025-03-17T18:39:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1072038,"change_date":"2022-06-22 21:40:00","inspection_id":"75887595","insp_unit_id":"189394807","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"T-82","insp_unit_license":"3120AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1M2AX07C1HM034366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:47.000000Z","updated_at":"2025-03-17T22:14:47.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/525535\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/525535\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/525535\/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\/525535\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}