{"current_page":1,"data":[{"id":12602428,"change_date":"2026-07-31 21:41:00","inspection_id":"88572014","dot_number":"398426","report_state":"MA","report_number":"DA00004771","insp_date":"2026-07-30 00:00:00","insp_start_time":"1626","insp_end_time":"1638","registration_date":null,"region":"ED","ci_status_code":"C","location":"341H","location_desc":"MA","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3878383","transaction_code":"A","transaction_date":"2026-07-31 00:00:00","upload_date":"2026-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-07-31 21:41:00","snet_input_date":"2026-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-31 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-03T09:41:15.000000Z","updated_at":"2026-08-11T09:32:42.000000Z","inspection_violations":[{"id":21940474,"change_date":"2026-07-31 21:41:00","inspection_id":"88572014","insp_violation_id":"275851946","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-08-03T10:01:33.000000Z","updated_at":"2026-08-11T09:43:42.000000Z","normalized_code":"3922SLLTCD"},{"id":21940475,"change_date":"2026-07-31 21:41:00","inspection_id":"88572014","insp_violation_id":"275851947","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214919411","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:33.000000Z","updated_at":"2026-08-11T09:43:42.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21879118,"change_date":"2026-07-31 21:41:00","inspection_id":"88572014","insp_unit_id":"214919411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AG77L","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3HJ7X7MM722887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-03T09:21:22.000000Z","updated_at":"2026-08-11T09:02:22.000000Z"}]},{"id":12591752,"change_date":"2026-07-30 21:42:00","inspection_id":"88560910","dot_number":"398426","report_state":"MA","report_number":"DZ00001967","insp_date":"2026-07-30 00:00:00","insp_start_time":"0544","insp_end_time":"0600","registration_date":null,"region":"ED","ci_status_code":"C","location":"372H","location_desc":"MA","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-07-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","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":"3870951","transaction_code":"A","transaction_date":"2026-07-30 00:00:00","upload_date":"2026-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-07-30 21:42:00","snet_input_date":"2026-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-30 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-02T09:41:19.000000Z","updated_at":"2026-08-11T09:31:04.000000Z","inspection_violations":[{"id":21922619,"change_date":"2026-07-30 21:42:00","inspection_id":"88560910","insp_violation_id":"275829837","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":"2026-08-02T10:02:39.000000Z","updated_at":"2026-08-10T09:43:05.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21861742,"change_date":"2026-07-30 21:42:00","inspection_id":"88560910","insp_unit_id":"214899890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"253","insp_unit_license":"7075B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKBHN8X3EJ369516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-03T09:20:31.000000Z","updated_at":"2026-08-10T09:02:26.000000Z"}]},{"id":12432986,"change_date":"2026-07-13 21:39:00","inspection_id":"88392079","dot_number":"398426","report_state":"VT","report_number":"3800004620","insp_date":"2026-07-13 00:00:00","insp_start_time":"0741","insp_end_time":"0802","registration_date":null,"region":"ED","ci_status_code":"C","location":"0405","location_desc":"VT","county_code_state":"VT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CASELLA","shipping_paper_number":"251154","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":"U","pen_cen_match":"I","final_status_date":"2026-07-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3739033","transaction_code":"A","transaction_date":"2026-07-13 00:00:00","upload_date":"2026-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-07-13 21:39:00","snet_input_date":"2026-07-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-13 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-16T09:40:28.000000Z","updated_at":"2026-07-24T09:30:42.000000Z","inspection_violations":[{"id":21644155,"change_date":"2026-07-13 21:39:00","inspection_id":"88392079","insp_violation_id":"275463438","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T10:00:02.000000Z","updated_at":"2026-07-24T09:43:37.000000Z","normalized_code":"3922SLLS2"},{"id":21644156,"change_date":"2026-07-13 21:39:00","inspection_id":"88392079","insp_violation_id":"275463439","seq_no":"2","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T10:00:02.000000Z","updated_at":"2026-07-24T09:43:37.000000Z","normalized_code":"3958D11HOSF"}],"inspection_per_units":[{"id":21597608,"change_date":"2026-07-13 21:39:00","inspection_id":"88392079","insp_unit_id":"214581706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"236","insp_unit_license":"1501B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXGGGG30D654918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:16:59.000000Z","updated_at":"2026-07-24T09:01:58.000000Z"},{"id":21597609,"change_date":"2026-07-13 21:39:00","inspection_id":"88392079","insp_unit_id":"214581707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"T88","insp_unit_license":"1826A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S388KR068092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:16:59.000000Z","updated_at":"2026-07-24T09:01:58.000000Z"}]},{"id":12314487,"change_date":"2026-06-29 21:42:00","inspection_id":"88272184","dot_number":"398426","report_state":"MA","report_number":"DZ00001875","insp_date":"2026-06-29 00:00:00","insp_start_time":"1530","insp_end_time":"1546","registration_date":null,"region":"ED","ci_status_code":"C","location":"295H","location_desc":"MA","county_code_state":"MA","county_code":"021","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":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","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":"3648515","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:40.000000Z","updated_at":"2026-07-10T09:31:23.000000Z","inspection_violations":[{"id":21430577,"change_date":"2026-06-29 21:42:00","inspection_id":"88272184","insp_violation_id":"275199175","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-02T10:00:56.000000Z","updated_at":"2026-07-10T09:42:57.000000Z","normalized_code":"3922SLLS2"},{"id":21430578,"change_date":"2026-06-29 21:42:00","inspection_id":"88272184","insp_violation_id":"275199176","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":"2026-07-02T10:00:56.000000Z","updated_at":"2026-07-10T09:42:57.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21388062,"change_date":"2026-06-29 21:42:00","inspection_id":"88272184","insp_unit_id":"214353569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"141","insp_unit_license":"99334","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:38.000000Z","updated_at":"2026-07-10T09:02:44.000000Z"},{"id":21388063,"change_date":"2026-06-29 21:42:00","inspection_id":"88272184","insp_unit_id":"214353570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"MA-157","insp_unit_license":"SM1827A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XGR057814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:38.000000Z","updated_at":"2026-07-10T09:02:44.000000Z"}]},{"id":12341454,"change_date":"2026-07-02 21:40:00","inspection_id":"88300885","dot_number":"398426","report_state":"RI","report_number":"0203001046","insp_date":"2026-06-26 00:00:00","insp_start_time":"0904","insp_end_time":"1015","registration_date":null,"region":"ED","ci_status_code":"C","location":"I0I95","location_desc":"PROVIDENCE RI","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3668149","transaction_code":"A","transaction_date":"2026-07-01 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-07-02 21:40:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-02 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-05T09:42:07.000000Z","updated_at":"2026-07-14T09:30:25.000000Z","inspection_violations":[{"id":21481019,"change_date":"2026-07-02 21:40:00","inspection_id":"88300885","insp_violation_id":"275265543","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"26001517707","created_at":"2026-07-05T10:05:16.000000Z","updated_at":"2026-07-14T09:41:38.000000Z","normalized_code":"3922SLLEWG3"},{"id":21481020,"change_date":"2026-07-02 21:40:00","inspection_id":"88300885","insp_violation_id":"275265544","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-05T10:05:16.000000Z","updated_at":"2026-07-14T09:41:38.000000Z","normalized_code":"3922SLLEWA3"},{"id":21481021,"change_date":"2026-07-02 21:40:00","inspection_id":"88300885","insp_violation_id":"275265545","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-05T10:05:16.000000Z","updated_at":"2026-07-14T09:41:38.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":21432769,"change_date":"2026-07-02 21:40:00","inspection_id":"88300885","insp_unit_id":"214412074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"262","insp_unit_license":"3705B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X9LD661674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:35.000000Z","updated_at":"2026-07-14T09:01:33.000000Z"},{"id":21432770,"change_date":"2026-07-02 21:40:00","inspection_id":"88300885","insp_unit_id":"214412075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":"T-78","insp_unit_license":"95167","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2M285JR062287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:35.000000Z","updated_at":"2026-07-14T09:01:33.000000Z"}]},{"id":12072266,"change_date":"2026-06-02 21:40:00","inspection_id":"88014488","dot_number":"398426","report_state":"RI","report_number":"0203001031","insp_date":"2026-05-27 00:00:00","insp_start_time":"1102","insp_end_time":"1145","registration_date":null,"region":"ED","ci_status_code":"C","location":"I0I95","location_desc":"PROVIDENCE RI","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139000","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":"3444863","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-06-02 21:40:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:19.000000Z","updated_at":"2026-06-13T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21523271,"change_date":null,"inspection_id":"88014488","insp_unit_id":"sms-backfill-792130392-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"98685","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA340890000000000","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21530695,"change_date":null,"inspection_id":"88014488","insp_unit_id":"sms-backfill-792130392-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":null,"insp_unit_license":"1575A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S386KR068091","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11969235,"change_date":"2026-06-18 21:41:00","inspection_id":"87905873","dot_number":"398426","report_state":"NY","report_number":"SPE3091164","insp_date":"2026-05-13 00:00:00","insp_start_time":"1019","insp_end_time":"1058","registration_date":"2026-06-17 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"PALMYRA NY","county_code_state":"NY","county_code":"117","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"W. L. FRENCH","shipping_paper_number":"108074MA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134200","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":"3365414","transaction_code":"C","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-05-20 21:40:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:48.000000Z","updated_at":"2026-06-29T09:30:03.000000Z","inspection_violations":[{"id":21330032,"change_date":"2026-06-18 21:41:00","inspection_id":"87905873","insp_violation_id":"274994105","seq_no":"1","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"214173422","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T09:51:58.000000Z","updated_at":"2026-06-29T09:42:51.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":21279391,"change_date":"2026-06-18 21:41:00","inspection_id":"87905873","insp_unit_id":"214173423","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"T-91","insp_unit_license":"1568A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1B9A13837LB180269","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:08:21.000000Z","updated_at":"2026-06-29T09:00:44.000000Z"},{"id":21279390,"change_date":"2026-06-18 21:41:00","inspection_id":"87905873","insp_unit_id":"214173422","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"396","insp_unit_license":"1AG53M","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPED40X0TD755668","insp_unit_decal":"Y","insp_unit_decal_number":"36371375","created_at":"2026-06-26T09:08:21.000000Z","updated_at":"2026-06-29T09:00:44.000000Z"}]},{"id":11945737,"change_date":"2026-05-17 21:35:00","inspection_id":"87881111","dot_number":"398426","report_state":"RI","report_number":"0070001624","insp_date":"2026-05-12 00:00:00","insp_start_time":"0435","insp_end_time":"0510","registration_date":null,"region":"ED","ci_status_code":"C","location":"I0095N","location_desc":"EXETER RI","county_code_state":"RI","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"76650","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3349963","transaction_code":"A","transaction_date":"2026-05-17 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-05-17 21:35:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-17 21:35:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-20T09:41:11.000000Z","updated_at":"2026-05-28T09:30:22.000000Z","inspection_violations":[{"id":21566374,"change_date":null,"inspection_id":"87881111","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":21525338,"change_date":null,"inspection_id":"87881111","insp_unit_id":"sms-backfill-790929999-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"1AJ45P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCL40X8SD730445","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11882615,"change_date":"2026-05-12 21:39:00","inspection_id":"87820299","dot_number":"398426","report_state":"RI","report_number":"M015000423","insp_date":"2026-05-06 00:00:00","insp_start_time":"0730","insp_end_time":"0905","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SMITHFIELD RI","county_code_state":"RI","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"3302501","transaction_code":"A","transaction_date":"2026-05-11 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:25.000000Z","updated_at":"2026-05-23T09:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340148,"change_date":null,"inspection_id":"87820299","insp_unit_id":"sms-backfill-790382691-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"1AD79S","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X2ND796899","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"},{"id":21342396,"change_date":null,"inspection_id":"87820299","insp_unit_id":"sms-backfill-790382691-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":null,"insp_unit_license":"21P7","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2M280NR077267","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11550723,"change_date":"2026-04-02 21:38:00","inspection_id":"87473542","dot_number":"398426","report_state":"RI","report_number":"0084001098","insp_date":"2026-03-27 00:00:00","insp_start_time":"0959","insp_end_time":"1046","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LINCOLN RI","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"3103900","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-04-02 21:38:00","snet_input_date":"2026-03-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-02 21:38:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:56:34.000000Z","updated_at":"2026-04-13T09:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20724916,"change_date":null,"inspection_id":"87473542","insp_unit_id":"sms-backfill-787261878-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"7389B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0MD768971","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"},{"id":20727726,"change_date":null,"inspection_id":"87473542","insp_unit_id":"sms-backfill-787261878-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":null,"insp_unit_license":"23F1","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XMR074947","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11464284,"change_date":"2026-03-24 21:40:00","inspection_id":"87382512","dot_number":"398426","report_state":"VT","report_number":"60A0001574","insp_date":"2026-02-12 00:00:00","insp_start_time":"1201","insp_end_time":"1217","registration_date":null,"region":"ES","ci_status_code":"C","location":"0307SB","location_desc":"VT","county_code_state":"VT","county_code":"005","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":"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":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39010","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":"3059555","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:25.000000Z","updated_at":"2026-04-04T09:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20327316,"change_date":null,"inspection_id":"87382512","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"1AA83Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCL40X8PD840175","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":10879988,"change_date":"2026-01-29 21:37:00","inspection_id":"86910390","dot_number":"398426","report_state":"NY","report_number":"SPT3031860","insp_date":"2026-01-22 00:00:00","insp_start_time":"1138","insp_end_time":"1152","registration_date":null,"region":"ES","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WASTE MANAGEMENT","shipping_paper_number":"1656830","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-29 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"158200","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":"2822317","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":"2026-01-29 21:37:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-29 21:37:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:41.000000Z","updated_at":"2026-02-10T10:30:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19085284,"change_date":null,"inspection_id":"86910390","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"1AE39K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40XXRD602562","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19091949,"change_date":null,"inspection_id":"86910390","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"93198","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1B9A140378B180300","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10375839,"change_date":"2025-12-08 21:38:00","inspection_id":"86504959","dot_number":"398426","report_state":"MA","report_number":"EG00000672","insp_date":"2025-12-08 00:00:00","insp_start_time":"0944","insp_end_time":"0954","registration_date":null,"region":"ET","ci_status_code":"C","location":"085H","location_desc":"H-DEDHAM","county_code_state":"MA","county_code":"021","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-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"535603","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-12-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:29.000000Z","updated_at":"2025-12-12T10:30:35.000000Z","inspection_violations":[{"id":18489574,"change_date":null,"inspection_id":"86504959","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18751543,"change_date":null,"inspection_id":"86504959","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"98839","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33842","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18836181,"change_date":null,"inspection_id":"86504959","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"27L7","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D4R387NR077126","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9970522,"change_date":"2025-10-17 21:39:00","inspection_id":"86079128","dot_number":"398426","report_state":"MA","report_number":"EI00000180","insp_date":"2025-10-17 00:00:00","insp_start_time":"1023","insp_end_time":"1047","registration_date":null,"region":"ET","ci_status_code":"C","location":"294H","location_desc":"H-SEEKONK","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"145200","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":"531721","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:53.000000Z","updated_at":"2025-10-21T10:00:41.000000Z","inspection_violations":[{"id":18482858,"change_date":null,"inspection_id":"86079128","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":18668665,"change_date":null,"inspection_id":"86079128","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AD34X","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X1PD857310","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18830630,"change_date":null,"inspection_id":"86079128","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"SM1575A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S386KR068091","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9816096,"change_date":"2025-10-15 21:39:00","inspection_id":"85916283","dot_number":"398426","report_state":"MA","report_number":"DF00002698","insp_date":"2025-09-30 00:00:00","insp_start_time":"0942","insp_end_time":"1004","registration_date":"2025-10-15 00:00:00","region":"ET","ci_status_code":"C","location":"268H","location_desc":"H-QUINCY","county_code_state":"MA","county_code":"021","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-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","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":"530150","transaction_code":"C","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-09-30 21:39:00","snet_input_date":"2025-09-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-30 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-03T10:01:49.000000Z","updated_at":"2025-10-19T10:00:21.000000Z","inspection_violations":[{"id":18480403,"change_date":null,"inspection_id":"85916283","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"11B1-A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39111B1A"},{"id":18480404,"change_date":null,"inspection_id":"85916283","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"},{"id":18480405,"change_date":null,"inspection_id":"85916283","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18744597,"change_date":null,"inspection_id":"85916283","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X66624","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDFF6LT0RDA10112","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8882006,"change_date":"2025-06-12 21:41:00","inspection_id":"84933610","dot_number":"398426","report_state":"MA","report_number":"CU00003613","insp_date":"2025-06-11 00:00:00","insp_start_time":"1545","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"085H","location_desc":"H-DEDHAM","county_code_state":"MA","county_code":"021","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-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","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":"520441","transaction_code":"A","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-06-12 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-12 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-15T10:01:08.000000Z","updated_at":"2025-06-16T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18733111,"change_date":null,"inspection_id":"84933610","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"1AH96D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5KKMBPFE6RPVC2461","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8628317,"change_date":"2025-05-14 21:41:00","inspection_id":"84665455","dot_number":"398426","report_state":"MA","report_number":"EF00000036","insp_date":"2025-05-13 00:00:00","insp_start_time":"1617","insp_end_time":"1634","registration_date":null,"region":"ET","ci_status_code":"C","location":"327H","location_desc":"H-SWANSEA","county_code_state":"MA","county_code":"005","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-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"517360","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:59.000000Z","updated_at":"2025-05-18T10:05:06.000000Z","inspection_violations":[{"id":18451234,"change_date":null,"inspection_id":"84665455","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18729772,"change_date":null,"inspection_id":"84665455","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V30798","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD8X3H65KEE28429","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8510950,"change_date":"2025-04-30 21:52:00","inspection_id":"84541925","dot_number":"398426","report_state":"NH","report_number":"1086001757","insp_date":"2025-04-29 00:00:00","insp_start_time":"1155","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"167","location_desc":"NEW HAMPTON","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52: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":"284665","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-29 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:01.000000Z","updated_at":"2025-05-04T10:39:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18650460,"change_date":null,"inspection_id":"84541925","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"6023B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCL40X0ND780647","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8414092,"change_date":"2025-04-18 21:40:00","inspection_id":"84439695","dot_number":"398426","report_state":"NH","report_number":"1078008346","insp_date":"2025-04-17 00:00:00","insp_start_time":"0844","insp_end_time":"0901","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":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"284317","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-17 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:06.000000Z","updated_at":"2025-04-23T10:03:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18726823,"change_date":null,"inspection_id":"84439695","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AG44Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X3RD681864","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18809581,"change_date":null,"inspection_id":"84439695","insp_unit_id":"2","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"97946","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV8HLJB7700","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8413916,"change_date":"2025-04-18 21:40:00","inspection_id":"84439504","dot_number":"398426","report_state":"MA","report_number":"DD00002261","insp_date":"2025-04-17 00:00:00","insp_start_time":"1608","insp_end_time":"1618","registration_date":null,"region":"ET","ci_status_code":"C","location":"042H","location_desc":"H-BOYLSTON","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF\/SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","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":"515214","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-04-18 21:40:00","snet_input_date":"2025-04-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:06.000000Z","updated_at":"2025-04-23T10:03:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18726780,"change_date":null,"inspection_id":"84439504","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"7075B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKBHN8X3EJ369516","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8144052,"change_date":"2025-03-27 21:41:00","inspection_id":"84155347","dot_number":"398426","report_state":"MA","report_number":"CR00003555","insp_date":"2025-03-18 00:00:00","insp_start_time":"0556","insp_end_time":"0604","registration_date":"2025-03-27 00:00:00","region":"ET","ci_status_code":"C","location":"307H","location_desc":"H-SOUTHBOROUGH","county_code_state":"MA","county_code":"027","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-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"512492","transaction_code":"C","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:32:34.000000Z","updated_at":"2025-03-31T10:27:48.000000Z","inspection_violations":[{"id":18442869,"change_date":null,"inspection_id":"84155347","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18723336,"change_date":null,"inspection_id":"84155347","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V69661","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDRF3H63JEC14352","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7692099,"change_date":"2025-01-23 21:38:00","inspection_id":"83680425","dot_number":"398426","report_state":"MA","report_number":"DA00002978","insp_date":"2025-01-23 00:00:00","insp_start_time":"0619","insp_end_time":"0637","registration_date":null,"region":"ET","ci_status_code":"C","location":"057H","location_desc":"H-CANTON","county_code_state":"MA","county_code":"021","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-01-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"507827","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2025-01-23 21:38:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-23 21:38:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:55.000000Z","updated_at":"2025-03-17T20:57:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18717408,"change_date":null,"inspection_id":"83680425","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"7389B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0MD768971","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18799213,"change_date":null,"inspection_id":"83680425","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"SM23F1","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XMR074947","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7000160,"change_date":"2024-10-31 21:42:00","inspection_id":"82951061","dot_number":"398426","report_state":"MA","report_number":"DS00001130","insp_date":"2024-10-19 00:00:00","insp_start_time":"0945","insp_end_time":"1002","registration_date":"2024-10-31 00:00:00","region":"ET","ci_status_code":"C","location":"053H","location_desc":"H-BURLINGTON","county_code_state":"MA","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":"2024-10-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"501749","transaction_code":"C","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-10-21 21:40:00","snet_input_date":"2024-10-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-10-21 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:13.000000Z","updated_at":"2025-03-17T20:42:13.000000Z","inspection_violations":[{"id":18424497,"change_date":null,"inspection_id":"82951061","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18707746,"change_date":null,"inspection_id":"82951061","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1288B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPTXPEX5HD350521","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6485354,"change_date":"2024-08-16 21:39:00","inspection_id":"82402980","dot_number":"398426","report_state":"MA","report_number":"CD00007656","insp_date":"2024-08-16 00:00:00","insp_start_time":"0549","insp_end_time":"0609","registration_date":null,"region":"ET","ci_status_code":"C","location":"053H","location_desc":"H-BURLINGTON","county_code_state":"MA","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":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"497760","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:33.000000Z","updated_at":"2025-03-17T20:31:33.000000Z","inspection_violations":[{"id":18415000,"change_date":null,"inspection_id":"82402980","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A1-NPH","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39141A1NPH"},{"id":18415001,"change_date":null,"inspection_id":"82402980","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2LV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922LV"},{"id":18415002,"change_date":null,"inspection_id":"82402980","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":18700780,"change_date":null,"inspection_id":"82402980","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X26423","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDXE4FN6PDD23784","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6454638,"change_date":"2024-08-14 21:38:00","inspection_id":"82370270","dot_number":"398426","report_state":"ME","report_number":"9566000617","insp_date":"2024-08-13 00:00:00","insp_start_time":"0825","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"98200","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":"384164","transaction_code":"C","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-13 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:43.000000Z","updated_at":"2025-03-17T20:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18622705,"change_date":null,"inspection_id":"82370270","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AE39K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40XXRD602562","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18780644,"change_date":null,"inspection_id":"82370270","insp_unit_id":"2","insp_unit_type_id":"1","insp_unit_number":"2","insp_unit_make":"VANHO","insp_unit_company":null,"insp_unit_license":"93198","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"YE2TC62B2X2043684","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6205165,"change_date":"2024-07-12 21:39:00","inspection_id":"82103153","dot_number":"398426","report_state":"VT","report_number":"59A0003870","insp_date":"2024-07-09 00:00:00","insp_start_time":"0913","insp_end_time":"0952","registration_date":null,"region":"ET","ci_status_code":"C","location":"1005","location_desc":"COVENTRY","county_code_state":"VT","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"W L FRENCH EXCAVATING CORP","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-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"159000","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":"207689","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-09 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:45.000000Z","updated_at":"2025-03-17T20:25:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18696999,"change_date":null,"inspection_id":"82103153","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AF16F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X1RD681863","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18776935,"change_date":null,"inspection_id":"82103153","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"SMN","insp_unit_company":null,"insp_unit_license":"93198","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1B9A140378B180300","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6161853,"change_date":"2024-07-08 21:42:00","inspection_id":"82056616","dot_number":"398426","report_state":"NH","report_number":"1128001822","insp_date":"2024-07-05 00:00:00","insp_start_time":"0744","insp_end_time":"0757","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BOW","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"198000","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":"276536","transaction_code":"A","transaction_date":"2024-07-05 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:58.000000Z","updated_at":"2025-03-17T20:24:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18618727,"change_date":null,"inspection_id":"82056616","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AE39K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40XXRD602562","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18776246,"change_date":null,"inspection_id":"82056616","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"1575A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S386KR068091","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5947504,"change_date":"2024-07-05 21:36:00","inspection_id":"81825367","dot_number":"398426","report_state":"NH","report_number":"1325000214","insp_date":"2024-06-06 00:00:00","insp_start_time":"1509","insp_end_time":"1530","registration_date":"2024-07-05 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCHESTER","county_code_state":"NH","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","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":"275624","transaction_code":"C","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-10 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:39.000000Z","updated_at":"2025-03-17T20:20:39.000000Z","inspection_violations":[{"id":18404781,"change_date":null,"inspection_id":"81825367","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":18693276,"change_date":null,"inspection_id":"81825367","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AD34X","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X1PD857310","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18772816,"change_date":null,"inspection_id":"81825367","insp_unit_id":"2","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"1827A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XGR057814","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5789725,"change_date":"2024-05-20 21:42:00","inspection_id":"81653984","dot_number":"398426","report_state":"NH","report_number":"1085004044","insp_date":"2024-05-16 00:00:00","insp_start_time":"1332","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"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":"2024-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"275205","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-16 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-05-20 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:30.000000Z","updated_at":"2025-03-17T20:17:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18613340,"change_date":null,"inspection_id":"81653984","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"7389B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0MD768971","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18770345,"change_date":null,"inspection_id":"81653984","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"23F1","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XMR074947","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5284316,"change_date":"2024-03-21 21:40:00","inspection_id":"81103445","dot_number":"398426","report_state":"MA","report_number":"CD00007213","insp_date":"2024-03-14 00:00:00","insp_start_time":"0646","insp_end_time":"0734","registration_date":"2024-03-21 00:00:00","region":"ET","ci_status_code":"C","location":"345H","location_desc":"H-WALTHAM","county_code_state":"MA","county_code":"017","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-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"487618","transaction_code":"C","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:27.000000Z","updated_at":"2025-03-17T20:07:27.000000Z","inspection_violations":[{"id":18391138,"change_date":null,"inspection_id":"81103445","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375GLOAD"}],"inspection_per_units":[{"id":18606096,"change_date":null,"inspection_id":"81103445","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"97720","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXGGGG90D339251","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18762589,"change_date":null,"inspection_id":"81103445","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TALBE","insp_unit_company":null,"insp_unit_license":"1555A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"40FSK523XK1037395","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5242830,"change_date":"2024-03-14 21:41:00","inspection_id":"81058297","dot_number":"398426","report_state":"MA","report_number":"DS00000487","insp_date":"2024-03-08 00:00:00","insp_start_time":"1002","insp_end_time":"1015","registration_date":"2024-03-14 00:00:00","region":"ET","ci_status_code":"C","location":"287S","location_desc":"S-SALEM","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":"2024-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"487067","transaction_code":"C","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-03-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18683197,"change_date":null,"inspection_id":"81058297","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"3251B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPWXPEX2ED231981","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5133212,"change_date":"2024-03-04 21:41:00","inspection_id":"80938879","dot_number":"398426","report_state":"MA","report_number":"CP00003967","insp_date":"2024-02-26 00:00:00","insp_start_time":"1410","insp_end_time":"1420","registration_date":"2024-03-04 00:00:00","region":"ET","ci_status_code":"C","location":"369H","location_desc":"H-WESTMINSTER","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"486080","transaction_code":"C","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-02-26 21:41:00","snet_input_date":"2024-02-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-26 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[{"id":18388490,"change_date":null,"inspection_id":"80938879","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":18603921,"change_date":null,"inspection_id":"80938879","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"3549B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPWXPEX2ED231978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5084084,"change_date":"2024-02-20 21:41:00","inspection_id":"80885264","dot_number":"398426","report_state":"MA","report_number":"DA00001790","insp_date":"2024-02-20 00:00:00","insp_start_time":"0636","insp_end_time":"0658","registration_date":null,"region":"ET","ci_status_code":"C","location":"057H","location_desc":"H-CANTON","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"485682","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:26.000000Z","updated_at":"2025-03-17T20:03:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18680963,"change_date":null,"inspection_id":"80885264","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"97720","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXGGGG90D339251","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18759392,"change_date":null,"inspection_id":"80885264","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"SM1555A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"40FSK523XK1037395","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4908433,"change_date":"2024-02-14 21:41:00","inspection_id":"80693038","dot_number":"398426","report_state":"MA","report_number":"CD00007078","insp_date":"2024-01-26 00:00:00","insp_start_time":"1321","insp_end_time":"1343","registration_date":"2024-02-14 00:00:00","region":"ET","ci_status_code":"C","location":"041H","location_desc":"H-BOXFORD","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-01-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"483796","transaction_code":"C","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2024-01-26 21:39:00","snet_input_date":"2024-01-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-26 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:02.000000Z","updated_at":"2025-03-17T20:00:02.000000Z","inspection_violations":[{"id":18384166,"change_date":null,"inspection_id":"80693038","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39360D"},{"id":18384167,"change_date":null,"inspection_id":"80693038","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18678367,"change_date":null,"inspection_id":"80693038","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"92496","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X7FD269605","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18756465,"change_date":null,"inspection_id":"80693038","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"27L7","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D4R387NR077126","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4585500,"change_date":"2024-01-03 21:43:00","inspection_id":"80339881","dot_number":"398426","report_state":"MA","report_number":"CP00003721","insp_date":"2023-12-04 00:00:00","insp_start_time":"1433","insp_end_time":"1445","registration_date":"2024-01-03 00:00:00","region":"ET","ci_status_code":"C","location":"369H","location_desc":"H-WESTMINSTER","county_code_state":"MA","county_code":"027","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-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"480182","transaction_code":"C","transaction_date":"2023-12-08 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-12-08 21:40:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-12-08 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:46.000000Z","updated_at":"2025-03-17T19:53:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4478880,"change_date":"2023-12-12 21:41:00","inspection_id":"80222631","dot_number":"398426","report_state":"MA","report_number":"BV00006596","insp_date":"2023-11-22 00:00:00","insp_start_time":"0628","insp_end_time":"0655","registration_date":"2023-12-12 00:00:00","region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","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":"2023-11-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"479386","transaction_code":"C","transaction_date":"2023-11-22 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-11-22 21:38:00","snet_input_date":"2023-11-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-22 21:38:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:28.000000Z","updated_at":"2025-03-17T19:51:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4429745,"change_date":"2023-11-21 21:39:00","inspection_id":"80168617","dot_number":"398426","report_state":"MA","report_number":"DC00001160","insp_date":"2023-11-14 00:00:00","insp_start_time":"1025","insp_end_time":"1117","registration_date":"2023-11-21 00:00:00","region":"ET","ci_status_code":"C","location":"085H","location_desc":"H-DEDHAM","county_code_state":"MA","county_code":"021","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":"2023-11-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"195224","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"478741","transaction_code":"C","transaction_date":"2023-11-15 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-11-15 21:41:00","snet_input_date":"2023-11-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:43.000000Z","updated_at":"2025-03-17T19:50:43.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4339738,"change_date":"2023-11-02 21:41:00","inspection_id":"80069018","dot_number":"398426","report_state":"NH","report_number":"1128001144","insp_date":"2023-11-01 00:00:00","insp_start_time":"0735","insp_end_time":"0810","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":"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-11-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"198000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"270537","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-11-02 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:47.000000Z","updated_at":"2025-03-17T19:48:47.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4279382,"change_date":"2023-10-25 21:41:00","inspection_id":"80002308","dot_number":"398426","report_state":"NH","report_number":"1078007141","insp_date":"2023-10-24 00:00:00","insp_start_time":"0901","insp_end_time":"0921","registration_date":null,"region":"ET","ci_status_code":"C","location":"027","location_desc":"LINCOLN","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":"2023-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"270334","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-24 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:30.000000Z","updated_at":"2025-03-17T19:47:30.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4278881,"change_date":"2023-10-31 21:39:00","inspection_id":"80001770","dot_number":"398426","report_state":"MA","report_number":"CV00002602","insp_date":"2023-10-24 00:00:00","insp_start_time":"1621","insp_end_time":"1634","registration_date":"2023-10-31 00:00:00","region":"ET","ci_status_code":"C","location":"167H","location_desc":"H-LEE","county_code_state":"MA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"477107","transaction_code":"C","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:30.000000Z","updated_at":"2025-03-17T19:47:30.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4098520,"change_date":"2023-10-24 21:39:00","inspection_id":"79802340","dot_number":"398426","report_state":"MA","report_number":"DF00000339","insp_date":"2023-10-02 00:00:00","insp_start_time":"0459","insp_end_time":"0512","registration_date":"2023-10-24 00:00:00","region":"ET","ci_status_code":"C","location":"044H","location_desc":"H-BRAINTREE","county_code_state":"MA","county_code":"021","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-10-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"475134","transaction_code":"C","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-10-02 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-02 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:41.000000Z","updated_at":"2025-03-17T19:43:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3875429,"change_date":"2023-08-31 21:42:00","inspection_id":"79554155","dot_number":"398426","report_state":"NY","report_number":"SPE0320891","insp_date":"2023-08-30 00:00:00","insp_start_time":"0916","insp_end_time":"0939","registration_date":null,"region":"ET","ci_status_code":"C","location":"30494","location_desc":"ONTARIO CENTER RD","county_code_state":"NY","county_code":"117","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"2864244","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:24.000000Z","updated_at":"2025-03-17T19:39:24.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3615069,"change_date":"2023-07-28 21:40:00","inspection_id":"79263154","dot_number":"398426","report_state":"MA","report_number":"DA00001060","insp_date":"2023-07-28 00:00:00","insp_start_time":"0623","insp_end_time":"0636","registration_date":null,"region":"ET","ci_status_code":"C","location":"372H","location_desc":"H-WESTWOOD","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"471056","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-07-28 21:40:00","snet_input_date":"2023-07-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-07-28 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:15.000000Z","updated_at":"2025-03-17T19:34:15.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3496279,"change_date":"2023-08-01 21:41:00","inspection_id":"79130003","dot_number":"398426","report_state":"NH","report_number":"1094004393","insp_date":"2023-07-12 00:00:00","insp_start_time":"1042","insp_end_time":"1147","registration_date":"2023-08-01 00:00:00","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":"MINARDI METROWEST PROPERTIES","shipping_paper_number":"2-22321","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"267583","transaction_code":"C","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-12 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-07-13 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:07.000000Z","updated_at":"2025-03-17T19:32:07.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3309661,"change_date":"2023-06-19 21:36:00","inspection_id":"78920347","dot_number":"398426","report_state":"NH","report_number":"1128000883","insp_date":"2023-06-19 00:00:00","insp_start_time":"0605","insp_end_time":"0628","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"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":"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-06-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"155000","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":"266955","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-19 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-06-19 21:36:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:32.000000Z","updated_at":"2025-03-17T19:28:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3267937,"change_date":"2023-06-21 21:42:00","inspection_id":"78872807","dot_number":"398426","report_state":"MA","report_number":"CK00002759","insp_date":"2023-06-12 00:00:00","insp_start_time":"1530","insp_end_time":"1542","registration_date":"2023-06-21 00:00:00","region":"ET","ci_status_code":"C","location":"372H","location_desc":"H-WESTWOOD","county_code_state":"MA","county_code":"021","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-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","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":"467959","transaction_code":"C","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-06-13 21:41:00","snet_input_date":"2023-06-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-06-13 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3245713,"change_date":"2023-06-09 21:40:00","inspection_id":"78847765","dot_number":"398426","report_state":"NH","report_number":"1078006796","insp_date":"2023-06-08 00:00:00","insp_start_time":"1150","insp_end_time":"1209","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-06-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"266671","transaction_code":"A","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-08 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3009918,"change_date":"2023-07-31 21:40:00","inspection_id":"78581728","dot_number":"398426","report_state":"RI","report_number":"0084001053","insp_date":"2023-05-09 00:00:00","insp_start_time":"0640","insp_end_time":"0711","registration_date":null,"region":"ET","ci_status_code":"C","location":"91","location_desc":"RT 295N @ EXIT 12 (RT 44)","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SPRING LEDGE FARM","shipping_paper_number":"575464N","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":"I","final_status_date":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"185000","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":"81954","transaction_code":"C","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-07-31 21:40:00","snet_input_date":"2023-05-10 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-05-10 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3018027,"change_date":"2023-06-08 21:41:00","inspection_id":"78590931","dot_number":"398426","report_state":"MA","report_number":"CW00001647","insp_date":"2023-05-09 00:00:00","insp_start_time":"1626","insp_end_time":"1640","registration_date":"2023-06-08 00:00:00","region":"ET","ci_status_code":"C","location":"322S","location_desc":"S-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"465420","transaction_code":"C","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-05-11 21:41:00","snet_input_date":"2023-05-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-11 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:40.000000Z","updated_at":"2025-03-17T19:22:40.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2904710,"change_date":"2023-06-13 21:41:00","inspection_id":"78462957","dot_number":"398426","report_state":"MA","report_number":"DD00000626","insp_date":"2023-04-27 00:00:00","insp_start_time":"0745","insp_end_time":"0831","registration_date":"2023-06-13 00:00:00","region":"ET","ci_status_code":"C","location":"348H","location_desc":"H-WARREN","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WL FRENCH","shipping_paper_number":"BWSC112","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-04-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"464562","transaction_code":"C","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-04-27 21:42:00","snet_input_date":"2023-04-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-04-27 21:42:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:24.000000Z","updated_at":"2025-03-17T19:20:24.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2671485,"change_date":"2023-03-28 21:40:00","inspection_id":"78197359","dot_number":"398426","report_state":"MA","report_number":"CV00001980","insp_date":"2023-03-27 00:00:00","insp_start_time":"1316","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"284H","location_desc":"H-RUSSELL","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"498994NH","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-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","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":"462862","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-03-28 21:40:00","snet_input_date":"2023-03-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-28 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:53.000000Z","updated_at":"2025-03-17T19:15:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2582261,"change_date":"2023-03-15 21:41:00","inspection_id":"78096465","dot_number":"398426","report_state":"NH","report_number":"1085002909","insp_date":"2023-03-13 00:00:00","insp_start_time":"0833","insp_end_time":"0850","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"264849","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-03-15 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:26.000000Z","updated_at":"2025-03-17T19:14:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2549148,"change_date":"2023-03-10 21:40:00","inspection_id":"78058489","dot_number":"398426","report_state":"MA","report_number":"DD00000554","insp_date":"2023-03-10 00:00:00","insp_start_time":"1240","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"348H","location_desc":"H-WARREN","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"G. GREENE","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-03-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"461993","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-03-10 21:40:00","snet_input_date":"2023-03-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-10 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2508820,"change_date":"2023-03-30 21:40:00","inspection_id":"78012729","dot_number":"398426","report_state":"ME","report_number":"1767004745","insp_date":"2023-03-06 00:00:00","insp_start_time":"1144","insp_end_time":"1402","registration_date":"2023-03-30 00:00:00","region":"ET","ci_status_code":"C","location":"000505","location_desc":"WELLS","county_code_state":"ME","county_code":"031","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"152000","viol_total":"6","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":"361463","transaction_code":"C","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-03-20 21:40:00","snet_input_date":"2023-03-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:55.000000Z","updated_at":"2025-03-17T19:12:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2539273,"change_date":"2023-03-09 21:41:00","inspection_id":"78047235","dot_number":"398426","report_state":"NY","report_number":"SPE0310560","insp_date":"2023-02-16 00:00:00","insp_start_time":"1350","insp_end_time":"1426","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504A","location_desc":"MANCHESTER","county_code_state":"NY","county_code":"069","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-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145200","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":"2804397","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-09 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2312122,"change_date":"2023-02-21 21:40:00","inspection_id":"77788418","dot_number":"398426","report_state":"MA","report_number":"CP00002782","insp_date":"2023-02-06 00:00:00","insp_start_time":"1553","insp_end_time":"1608","registration_date":"2023-02-21 00:00:00","region":"ET","ci_status_code":"C","location":"369H","location_desc":"H-WESTMINSTER","county_code_state":"MA","county_code":"027","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-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"460014","transaction_code":"C","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-02-07 21:40:00","snet_input_date":"2023-02-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-02-07 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:16.000000Z","updated_at":"2025-03-17T19:09:16.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2124399,"change_date":"2023-02-09 21:39:00","inspection_id":"77574045","dot_number":"398426","report_state":"MA","report_number":"CK00002475","insp_date":"2023-01-12 00:00:00","insp_start_time":"1105","insp_end_time":"1115","registration_date":"2023-02-09 00:00:00","region":"ET","ci_status_code":"C","location":"085H","location_desc":"H-DEDHAM","county_code_state":"MA","county_code":"021","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","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":"458646","transaction_code":"C","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-01-12 21:41:00","snet_input_date":"2023-01-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-12 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:51.000000Z","updated_at":"2025-03-17T19:05:51.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2124435,"change_date":"2023-02-14 21:40:00","inspection_id":"77574089","dot_number":"398426","report_state":"MA","report_number":"CB00007830","insp_date":"2023-01-11 00:00:00","insp_start_time":"1515","insp_end_time":"1544","registration_date":"2023-02-14 00:00:00","region":"ET","ci_status_code":"C","location":"269H","location_desc":"H-RANDOLPH","county_code_state":"MA","county_code":"021","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"180000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"458620","transaction_code":"C","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2023-01-12 21:41:00","snet_input_date":"2023-01-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-12 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:51.000000Z","updated_at":"2025-03-17T19:05:51.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2102376,"change_date":"2023-01-10 21:40:00","inspection_id":"77548928","dot_number":"398426","report_state":"VT","report_number":"2149003015","insp_date":"2023-01-05 00:00:00","insp_start_time":"0827","insp_end_time":"0837","registration_date":null,"region":"ET","ci_status_code":"C","location":"0316WC","location_desc":"WATERFORD WELCOME CENTER","county_code_state":"VT","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"W L FRENCH","shipping_paper_number":"598001N","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-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"196133","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-05 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:29.000000Z","updated_at":"2025-03-17T19:05:29.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1758588,"change_date":"2023-02-16 21:41:00","inspection_id":"77155623","dot_number":"398426","report_state":"MA","report_number":"CQ00002478","insp_date":"2022-11-17 00:00:00","insp_start_time":"1232","insp_end_time":"1249","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"363H","location_desc":"H-WEST SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"158000","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":"455462","transaction_code":"C","transaction_date":"2022-11-17 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2022-11-17 21:39:00","snet_input_date":"2022-11-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-11-17 21:39:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:59.000000Z","updated_at":"2025-03-17T18:58:59.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1682544,"change_date":"2023-02-16 21:41:00","inspection_id":"77068454","dot_number":"398426","report_state":"MA","report_number":"CV00001633","insp_date":"2022-11-07 00:00:00","insp_start_time":"0948","insp_end_time":"1003","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"366H","location_desc":"H-WESTFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"STEWARD HEALTH CARE SYSTEMS","shipping_paper_number":"729","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"454900","transaction_code":"C","transaction_date":"2022-11-07 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2022-11-07 21:40:00","snet_input_date":"2022-11-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-11-07 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:43.000000Z","updated_at":"2025-03-17T18:57:43.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1643217,"change_date":"2022-11-01 21:40:00","inspection_id":"77023358","dot_number":"398426","report_state":"NY","report_number":"SPT0441081","insp_date":"2022-10-24 00:00:00","insp_start_time":"1355","insp_end_time":"1418","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504A","location_desc":"MANCHESTER","county_code_state":"NY","county_code":"069","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":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138900","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":"2764619","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:01.000000Z","updated_at":"2025-03-17T18:57:01.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1394582,"change_date":"2022-09-30 21:39:00","inspection_id":"76736211","dot_number":"398426","report_state":"NH","report_number":"1078006222","insp_date":"2022-09-28 00:00:00","insp_start_time":"0914","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","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":"2022-09-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"261017","transaction_code":"C","transaction_date":"2022-09-30 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-09-29 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"498898","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:22.000000Z","updated_at":"2025-03-17T18:52:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1166440,"change_date":"2022-08-30 21:40:00","inspection_id":"76471618","dot_number":"398426","report_state":"MA","report_number":"CU00001434","insp_date":"2022-08-29 00:00:00","insp_start_time":"1742","insp_end_time":"1800","registration_date":null,"region":"ET","ci_status_code":"C","location":"028H","location_desc":"H-BEDFORD","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","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":"451119","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":"00398426","upload_search_indicator":"M","census_search_date":"2022-08-30 21:40:00","snet_input_date":"2022-08-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","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":1091910,"change_date":"2022-10-06 21:39:00","inspection_id":"76385006","dot_number":"398426","report_state":"MA","report_number":"CD00005422","insp_date":"2022-08-19 00:00:00","insp_start_time":"1047","insp_end_time":"1106","registration_date":"2022-10-06 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"185000","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":"450663","transaction_code":"C","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2022-08-22 21:41:00","snet_input_date":"2022-08-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-22 21:41:00","insp_carrier_name":"W L FRENCH EXCAVATING CORP","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:55.000000Z","updated_at":"2025-03-17T18:46:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1083154,"change_date":"2022-10-11 21:40:00","inspection_id":"76374682","dot_number":"398426","report_state":"MA","report_number":"CY00000026","insp_date":"2022-08-18 00:00:00","insp_start_time":"1456","insp_end_time":"1502","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"077H","location_desc":"H-CONCORD","county_code_state":"MA","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":"2022-08-19 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"450612","transaction_code":"C","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00398426","upload_search_indicator":"M","census_search_date":"2022-08-19 21:35:00","snet_input_date":"2022-08-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-19 21:35:00","insp_carrier_name":"W L FRENCH EXCAVATING CORPORATION","insp_carrier_street":"14 STERLING ROAD","insp_carrier_city":"NORTH BILLERICA","insp_carrier_state":"MA","insp_carrier_zip_code":"01862","insp_colonia":null,"docket_number":"4988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:52.000000Z","updated_at":"2025-03-17T18:46:52.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/398426\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/398426\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/398426\/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\/398426\/inspections","per_page":100,"prev_page_url":null,"to":66,"total":66}