{"current_page":1,"data":[{"id":12012675,"change_date":"2026-05-26 21:39:00","inspection_id":"87951808","dot_number":"1295809","report_state":"RI","report_number":"0084001224","insp_date":"2026-05-20 00:00:00","insp_start_time":"1213","insp_end_time":"1324","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PROVIDENCE 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-05-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"3398877","transaction_code":"A","transaction_date":"2026-05-25 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":"2026-05-26 21:39:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-26 21:39:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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-29T09:39:50.000000Z","updated_at":"2026-06-06T09:31:07.000000Z","inspection_violations":[{"id":20901061,"change_date":"2026-05-26 21:39:00","inspection_id":"87951808","insp_violation_id":"274488361","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"26001514333","created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20881612,"change_date":"2026-05-26 21:39:00","inspection_id":"87951808","insp_unit_id":"213742079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":null,"insp_unit_license":"3373B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T386LR071222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:12.000000Z","updated_at":"2026-06-06T09:02:34.000000Z"},{"id":20881611,"change_date":"2026-05-26 21:39:00","inspection_id":"87951808","insp_unit_id":"213742078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"1AA12F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0ND794343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:12.000000Z","updated_at":"2026-06-06T09:02:34.000000Z"}]},{"id":11775783,"change_date":"2026-04-29 21:39:00","inspection_id":"87706783","dot_number":"1295809","report_state":"RI","report_number":"0050000270","insp_date":"2026-04-23 00:00:00","insp_start_time":"1012","insp_end_time":"1042","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"JOHNSTON RI","county_code_state":"RI","county_code":"007","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"151350","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":"3227818","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":"2026-04-29 21:39:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:39:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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-02T09:40:55.000000Z","updated_at":"2026-05-10T09:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20486185,"change_date":"2026-04-29 21:39:00","inspection_id":"87706783","insp_unit_id":"213279747","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"5936A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA34091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:03.000000Z","updated_at":"2026-05-10T09:02:24.000000Z"},{"id":20486186,"change_date":"2026-04-29 21:39:00","inspection_id":"87706783","insp_unit_id":"213279748","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":null,"insp_unit_license":"38A6","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S387RR081202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:03.000000Z","updated_at":"2026-05-10T09:02:24.000000Z"}]},{"id":11705971,"change_date":"2026-04-21 21:38:00","inspection_id":"87632653","dot_number":"1295809","report_state":"RI","report_number":"0084001145","insp_date":"2026-04-15 00:00:00","insp_start_time":"0845","insp_end_time":"0921","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEWPORT RI","county_code_state":"RI","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-21 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":"3186576","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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-27T09:37:22.000000Z","updated_at":"2026-05-02T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20371215,"change_date":"2026-04-21 21:38:00","inspection_id":"87632653","insp_unit_id":"213131078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"1AG61M","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPED40X0SD755667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:28.000000Z","updated_at":"2026-05-02T09:02:34.000000Z"},{"id":20371216,"change_date":"2026-04-21 21:38:00","inspection_id":"87632653","insp_unit_id":"213131079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST SO TR","insp_unit_company":null,"insp_unit_license":"52E4","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S388SR086883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:28.000000Z","updated_at":"2026-05-02T09:02:34.000000Z"}]},{"id":11649451,"change_date":"2026-04-15 21:38:00","inspection_id":"87578954","dot_number":"1295809","report_state":"RI","report_number":"0084001127","insp_date":"2026-04-09 00:00:00","insp_start_time":"1250","insp_end_time":"1407","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"JOHNSTON 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-15 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":"3157849","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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-26T09:30:13.000000Z","updated_at":"2026-04-26T09:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20263831,"change_date":"2026-04-15 21:38:00","inspection_id":"87578954","insp_unit_id":"213021356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"97206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:23.000000Z","updated_at":"2026-04-26T09:02:23.000000Z"}]},{"id":10648348,"change_date":"2026-01-14 21:40:00","inspection_id":"86790140","dot_number":"1295809","report_state":"MA","report_number":"DZ00001418","insp_date":"2026-01-14 00:00:00","insp_start_time":"0609","insp_end_time":"0624","registration_date":null,"region":"ET","ci_status_code":"C","location":"115H","location_desc":"H-FOXBORO","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":"2026-01-14 21:40: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":"538349","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2026-01-14 21:40:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-14 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-17T10:36:31.000000Z","updated_at":"2026-01-25T10:30:45.000000Z","inspection_violations":[{"id":17918271,"change_date":"2026-01-14 21:40:00","inspection_id":"86790140","insp_violation_id":"271200113","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-01-17T10:43:39.000000Z","updated_at":"2026-01-25T10:31:12.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":17864708,"change_date":"2026-01-14 21:40:00","inspection_id":"86790140","insp_unit_id":"211079274","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"237","insp_unit_license":"9767A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXGGGGX0D654916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-17T10:09:07.000000Z","updated_at":"2026-01-25T10:00:55.000000Z"},{"id":17864709,"change_date":"2026-01-14 21:40:00","inspection_id":"86790140","insp_unit_id":"211079275","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"T-95 MA-189","insp_unit_license":"3352B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T388LR071223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-17T10:09:07.000000Z","updated_at":"2026-01-25T10:00:55.000000Z"}]},{"id":10575707,"change_date":"2026-01-06 21:38:00","inspection_id":"86713872","dot_number":"1295809","report_state":"MA","report_number":"CX00001905","insp_date":"2026-01-06 00:00:00","insp_start_time":"0920","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY WEIGH STATION","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NATIONAL GRID","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":"2026-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"537707","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2026-01-06 21:38:00","snet_input_date":"2026-01-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-06 21:38:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:23.000000Z","updated_at":"2026-01-17T10:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17722709,"change_date":"2026-01-06 21:38:00","inspection_id":"86713872","insp_unit_id":"210925617","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"121","insp_unit_license":"97207","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:52.000000Z","updated_at":"2026-01-17T10:00:40.000000Z"},{"id":17722710,"change_date":"2026-01-06 21:38:00","inspection_id":"86713872","insp_unit_id":"210925618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-98","insp_unit_license":"SM11V8","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2S380MR073317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:52.000000Z","updated_at":"2026-01-17T10:00:40.000000Z"}]},{"id":10361843,"change_date":"2025-12-05 21:42:00","inspection_id":"86490295","dot_number":"1295809","report_state":"ME","report_number":"3552004434","insp_date":"2025-12-04 00:00:00","insp_start_time":"1151","insp_end_time":"1238","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GREEN SITE SERVICES","shipping_paper_number":"524965ME","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-05 21:42: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":"405489","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-04 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-12-05 21:42:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:31:58.000000Z","updated_at":"2025-12-09T10:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17318744,"change_date":"2025-12-05 21:42:00","inspection_id":"86490295","insp_unit_id":"210441113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"122","insp_unit_license":"97206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:05.000000Z","updated_at":"2025-12-09T10:01:12.000000Z"},{"id":17318745,"change_date":"2025-12-05 21:42:00","inspection_id":"86490295","insp_unit_id":"210441114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EASE","insp_unit_company":"T-107","insp_unit_license":"36E9","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S385NR078146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:05.000000Z","updated_at":"2025-12-09T10:01:12.000000Z"}]},{"id":9615284,"change_date":"2025-09-08 21:37:00","inspection_id":"85708222","dot_number":"1295809","report_state":"RI","report_number":"0084000847","insp_date":"2025-09-03 00:00:00","insp_start_time":"0726","insp_end_time":"0856","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PROVIDENCE 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":"2025-09-08 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","viol_total":"1","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":"2235148","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":"2025-09-08 21:37:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-08 21:37:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"2025-09-10T10:46:01.000000Z","updated_at":"2025-09-11T10:45:53.000000Z","inspection_violations":[{"id":15724709,"change_date":"2025-09-08 21:37:00","inspection_id":"85708222","insp_violation_id":"268515899","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":"25001619325","created_at":"2025-09-11T10:47:54.000000Z","updated_at":"2025-09-12T10:49:31.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":15881750,"change_date":"2025-09-08 21:37:00","inspection_id":"85708222","insp_unit_id":"208795669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"97206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2532H7129408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:33.000000Z","updated_at":"2025-09-12T10:46:27.000000Z"},{"id":15881751,"change_date":"2025-09-08 21:37:00","inspection_id":"85708222","insp_unit_id":"208795670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EASTERN-BI","insp_unit_company":null,"insp_unit_license":"36E9","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S385NR078146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:33.000000Z","updated_at":"2025-09-12T10:46:27.000000Z"}]},{"id":8959060,"change_date":"2025-07-18 21:39:00","inspection_id":"85015685","dot_number":"1295809","report_state":"MA","report_number":"DL00001210","insp_date":"2025-06-19 00:00:00","insp_start_time":"1408","insp_end_time":"1427","registration_date":"2025-07-18 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:40: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":"520989","transaction_code":"C","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2025-06-23 21:40:00","snet_input_date":"2025-06-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-23 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:30.000000Z","updated_at":"2025-07-22T10:44:38.000000Z","inspection_violations":[{"id":14829198,"change_date":"2025-07-18 21:39:00","inspection_id":"85015685","insp_violation_id":"267498480","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:56.000000Z","updated_at":"2025-07-22T10:45:35.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":15088293,"change_date":"2025-07-18 21:39:00","inspection_id":"85015685","insp_unit_id":"207949360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"122","insp_unit_license":"97206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:29.000000Z","updated_at":"2025-07-22T09:45:06.000000Z"},{"id":15088294,"change_date":"2025-07-18 21:39:00","inspection_id":"85015685","insp_unit_id":"207949361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"T-107","insp_unit_license":"SM36E9","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S385NR078146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:29.000000Z","updated_at":"2025-07-22T09:45:06.000000Z"}]},{"id":8414096,"change_date":"2025-04-18 21:40:00","inspection_id":"84439699","dot_number":"1295809","report_state":"NH","report_number":"1085004676","insp_date":"2025-04-17 00:00:00","insp_start_time":"0814","insp_end_time":"0829","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","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":"143200","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":"284343","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":"01295809","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 JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:06.000000Z","updated_at":"2025-04-23T10:03:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13661282,"change_date":"2025-04-18 21:40:00","inspection_id":"84439699","insp_unit_id":"206384583","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"122","insp_unit_license":"97206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:13:51.000000Z","updated_at":"2025-04-22T09:58:54.000000Z"},{"id":13661283,"change_date":"2025-04-18 21:40:00","inspection_id":"84439699","insp_unit_id":"206384584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T107","insp_unit_license":"36E9","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S385NR078146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:13:51.000000Z","updated_at":"2025-04-22T09:58:54.000000Z"}]},{"id":8352171,"change_date":"2025-05-05 21:40:00","inspection_id":"84374469","dot_number":"1295809","report_state":"NH","report_number":"1325000909","insp_date":"2025-04-10 00:00:00","insp_start_time":"1520","insp_end_time":"1542","registration_date":"2025-05-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":"2025-04-11 21:40: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":"284007","transaction_code":"C","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:36.000000Z","updated_at":"2025-05-09T10:21:34.000000Z","inspection_violations":[{"id":13540383,"change_date":"2025-05-05 21:40:00","inspection_id":"84374469","insp_violation_id":"266007222","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:22:58.000000Z","updated_at":"2025-05-09T10:39:29.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":13897367,"change_date":"2025-05-05 21:40:00","inspection_id":"84374469","insp_unit_id":"206642321","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"97207","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:29.000000Z","updated_at":"2025-05-09T09:55:08.000000Z"},{"id":13897368,"change_date":"2025-05-05 21:40:00","inspection_id":"84374469","insp_unit_id":"206642322","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"11V8","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2S380MR073317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:29.000000Z","updated_at":"2025-05-09T09:55:08.000000Z"}]},{"id":7622491,"change_date":"2025-01-15 21:41:00","inspection_id":"83607393","dot_number":"1295809","report_state":"NY","report_number":"SPE3060295","insp_date":"2025-01-08 00:00:00","insp_start_time":"1035","insp_end_time":"1056","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":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":"2025-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","viol_total":"1","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":"1249046","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"2025-03-17T20:56:30.000000Z","updated_at":"2025-03-17T20:56:30.000000Z","inspection_violations":[{"id":11914877,"change_date":"2025-01-15 21:41:00","inspection_id":"83607393","insp_violation_id":"264008616","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:02.000000Z","updated_at":"2025-03-17T22:04:02.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":12299268,"change_date":"2025-01-15 21:41:00","inspection_id":"83607393","insp_unit_id":"204840625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"161","insp_unit_license":"5936A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA34091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:43.000000Z","updated_at":"2025-03-17T23:50:43.000000Z"},{"id":12299269,"change_date":"2025-01-15 21:41:00","inspection_id":"83607393","insp_unit_id":"204840626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":"MA-189","insp_unit_license":"38A6","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S387RR081202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:43.000000Z","updated_at":"2025-03-17T23:50:43.000000Z"}]},{"id":7389614,"change_date":"2024-12-23 21:39:00","inspection_id":"83362820","dot_number":"1295809","report_state":"MA","report_number":"CY00002910","insp_date":"2024-12-11 00:00:00","insp_start_time":"1331","insp_end_time":"1343","registration_date":"2024-12-23 00:00:00","region":"ET","ci_status_code":"C","location":"338H","location_desc":"H-TYNGSBOROUGH","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-12-11 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":"505126","transaction_code":"C","transaction_date":"2024-12-11 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2024-12-11 21:40:00","snet_input_date":"2024-12-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-11 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:18.000000Z","updated_at":"2025-03-17T20:50:18.000000Z","inspection_violations":[{"id":11545358,"change_date":"2024-12-23 21:39:00","inspection_id":"83362820","insp_violation_id":"263630390","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11920773,"change_date":"2024-12-23 21:39:00","inspection_id":"83362820","insp_unit_id":"204528649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"161","insp_unit_license":"5936A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA34091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:38.000000Z","updated_at":"2025-03-17T23:46:38.000000Z"},{"id":11920774,"change_date":"2024-12-23 21:39:00","inspection_id":"83362820","insp_unit_id":"204528650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ESMC","insp_unit_company":"MA-189","insp_unit_license":"SM38A6","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S387RR081202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:38.000000Z","updated_at":"2025-03-17T23:46:38.000000Z"}]},{"id":7238516,"change_date":"2024-11-20 21:40:00","inspection_id":"83203534","dot_number":"1295809","report_state":"ME","report_number":"8980004962","insp_date":"2024-11-19 00:00:00","insp_start_time":"1323","insp_end_time":"1331","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":"-","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":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"145200","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":"388893","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-19 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:53.000000Z","updated_at":"2025-03-17T20:46:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11675490,"change_date":"2024-11-20 21:40:00","inspection_id":"83203534","insp_unit_id":"203969769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"329","insp_unit_license":"1AA12F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0ND794343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:01.000000Z","updated_at":"2025-03-17T23:44:01.000000Z"},{"id":11675491,"change_date":"2024-11-20 21:40:00","inspection_id":"83203534","insp_unit_id":"203969770","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-93","insp_unit_license":"3373B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T386LR071222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:01.000000Z","updated_at":"2025-03-17T23:44:01.000000Z"}]},{"id":7153180,"change_date":"2024-11-26 21:41:00","inspection_id":"83113199","dot_number":"1295809","report_state":"MA","report_number":"DR00001204","insp_date":"2024-11-08 00:00:00","insp_start_time":"1243","insp_end_time":"1251","registration_date":"2024-11-26 00:00:00","region":"ET","ci_status_code":"C","location":"036H","location_desc":"H-BLANDFORD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"503168","transaction_code":"C","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2024-11-08 21:40:00","snet_input_date":"2024-11-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-08 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:08.000000Z","updated_at":"2025-03-17T20:45:08.000000Z","inspection_violations":[{"id":11175196,"change_date":"2024-11-26 21:41:00","inspection_id":"83113199","insp_violation_id":"263099190","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:13.000000Z","updated_at":"2025-03-17T22:00:13.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11537356,"change_date":"2024-11-26 21:41:00","inspection_id":"83113199","insp_unit_id":"204063188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"122","insp_unit_license":"97206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:33.000000Z","updated_at":"2025-03-17T23:42:33.000000Z"},{"id":11537357,"change_date":"2024-11-26 21:41:00","inspection_id":"83113199","insp_unit_id":"204063189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"96234","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XHR059340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:33.000000Z","updated_at":"2025-03-17T23:42:33.000000Z"}]},{"id":6412386,"change_date":"2024-08-07 21:41:00","inspection_id":"82325175","dot_number":"1295809","report_state":"NY","report_number":"SPT0560756","insp_date":"2024-08-06 00:00:00","insp_start_time":"1501","insp_end_time":"1519","registration_date":null,"region":"ET","ci_status_code":"C","location":"12201","location_desc":"INTERSTATE 87 N\/B","county_code_state":"NY","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-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2943021","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-07 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:54.000000Z","updated_at":"2025-03-17T20:29:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10334322,"change_date":"2024-08-07 21:41:00","inspection_id":"82325175","insp_unit_id":"202279402","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"161","insp_unit_license":"5936A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA34091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:04.000000Z","updated_at":"2025-03-17T23:30:04.000000Z"},{"id":10334323,"change_date":"2024-08-07 21:41:00","inspection_id":"82325175","insp_unit_id":"202279403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"38A6","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S387RR081202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:04.000000Z","updated_at":"2025-03-17T23:30:04.000000Z"}]},{"id":6318739,"change_date":"2024-09-10 21:39:00","inspection_id":"82224865","dot_number":"1295809","report_state":"ME","report_number":"9270002404","insp_date":"2024-07-24 00:00:00","insp_start_time":"1344","insp_end_time":"1410","registration_date":"2024-09-09 00:00:00","region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TORMEO","shipping_paper_number":"6901","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"383456","transaction_code":"C","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-24 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-07-26 21:39:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[{"id":9812079,"change_date":"2024-09-10 21:39:00","inspection_id":"82224865","insp_violation_id":"261707960","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202842633","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10181417,"change_date":"2024-09-10 21:39:00","inspection_id":"82224865","insp_unit_id":"202842633","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"121","insp_unit_license":"97207","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:28.000000Z","updated_at":"2025-03-17T23:28:28.000000Z"},{"id":10181418,"change_date":"2024-09-10 21:39:00","inspection_id":"82224865","insp_unit_id":"202842634","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-98","insp_unit_license":"11V8","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2S380MR073317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:28.000000Z","updated_at":"2025-03-17T23:28:28.000000Z"}]},{"id":5618560,"change_date":"2024-04-29 21:43:00","inspection_id":"81468279","dot_number":"1295809","report_state":"NH","report_number":"1078007491","insp_date":"2024-04-09 00:00:00","insp_start_time":"1009","insp_end_time":"1026","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:43: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":"274189","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-09 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9050782,"change_date":"2024-04-29 21:43:00","inspection_id":"81468279","insp_unit_id":"200620328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"98611","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"},{"id":9050783,"change_date":"2024-04-29 21:43:00","inspection_id":"81468279","insp_unit_id":"200620329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"97255","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S381HR059095","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":4928273,"change_date":"2024-01-30 21:41:00","inspection_id":"80714668","dot_number":"1295809","report_state":"MA","report_number":"CU00002932","insp_date":"2024-01-26 00:00:00","insp_start_time":"1120","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":"279S","location_desc":"S-ROSLINDALE","county_code_state":"MA","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"47740","viol_total":"4","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":"483999","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2024-01-30 21:41:00","snet_input_date":"2024-01-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[{"id":7590948,"change_date":"2024-01-30 21:41:00","inspection_id":"80714668","insp_violation_id":"257552788","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199164450","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"3965B"},{"id":7590949,"change_date":"2024-01-30 21:41:00","inspection_id":"80714668","insp_violation_id":"257552789","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"199164450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"39355D2"},{"id":7590950,"change_date":"2024-01-30 21:41:00","inspection_id":"80714668","insp_violation_id":"257552790","seq_no":"3","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"199164450","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"393209D"},{"id":7590951,"change_date":"2024-01-30 21:41:00","inspection_id":"80714668","insp_violation_id":"257552791","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"199164450","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":7930926,"change_date":"2024-01-30 21:41:00","inspection_id":"80714668","insp_unit_id":"199164450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"365","insp_unit_license":"X64195","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2AG08C56M001432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"}]},{"id":4928806,"change_date":"2024-01-30 21:41:00","inspection_id":"80715242","dot_number":"1295809","report_state":"NH","report_number":"1078007330","insp_date":"2024-01-22 00:00:00","insp_start_time":"1151","insp_end_time":"1207","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:41: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":"272556","transaction_code":"A","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-22 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7931662,"change_date":"2024-01-30 21:41:00","inspection_id":"80715242","insp_unit_id":"199166660","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AH64H","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X1RD602563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"},{"id":7931663,"change_date":"2024-01-30 21:41:00","inspection_id":"80715242","insp_unit_id":"199166661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"1828A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XKR068093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"}]},{"id":4930298,"change_date":"2024-02-06 21:41:00","inspection_id":"80716876","dot_number":"1295809","report_state":"VT","report_number":"60A0000030","insp_date":"2023-12-06 00:00:00","insp_start_time":"1424","insp_end_time":"1456","registration_date":"2024-02-05 00:00:00","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:41: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":"202678","transaction_code":"C","transaction_date":"2023-12-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-06 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:28.000000Z","updated_at":"2025-03-17T20:00:28.000000Z","inspection_violations":[{"id":7593730,"change_date":"2024-02-06 21:41:00","inspection_id":"80716876","insp_violation_id":"257681888","seq_no":"1","part_no":"395","part_no_section":"24(c)(2)(ii)","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":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"39524C2II"}],"inspection_per_units":[{"id":7933833,"change_date":"2024-02-06 21:41:00","inspection_id":"80716876","insp_unit_id":"199284243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"249","insp_unit_license":"9971A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2XPXD40X3LM706389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"},{"id":7933834,"change_date":"2024-02-06 21:41:00","inspection_id":"80716876","insp_unit_id":"199284244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-93","insp_unit_license":"3373B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T386LR071222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"}]},{"id":4111040,"change_date":"2023-10-03 21:40:00","inspection_id":"79816269","dot_number":"1295809","report_state":"NY","report_number":"SPT0441669","insp_date":"2023-09-29 00:00:00","insp_start_time":"1020","insp_end_time":"1043","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-10-03 21:40: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":"2874790","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6609798,"change_date":"2023-10-03 21:40:00","inspection_id":"79816269","insp_unit_id":"197363216","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"329","insp_unit_license":"1AA12F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0ND794343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"},{"id":6609799,"change_date":"2023-10-03 21:40:00","inspection_id":"79816269","insp_unit_id":"197363217","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"T73","insp_unit_license":"96234","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XHR059340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3896400,"change_date":"2023-09-05 21:40:00","inspection_id":"79577591","dot_number":"1295809","report_state":"NY","report_number":"SPE0311195","insp_date":"2023-08-28 00:00:00","insp_start_time":"1420","insp_end_time":"1450","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":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139220","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":"2864760","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[{"id":6022435,"change_date":"2023-09-05 21:40:00","inspection_id":"79577591","insp_violation_id":"255066861","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196882643","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:11.000000Z","updated_at":"2025-03-17T21:35:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6264326,"change_date":"2023-09-05 21:40:00","inspection_id":"79577591","insp_unit_id":"196882643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"329","insp_unit_license":"1AA12F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0ND794343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"},{"id":6264327,"change_date":"2023-09-05 21:40:00","inspection_id":"79577591","insp_unit_id":"196882644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"3373B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T386LR071222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":2473042,"change_date":"2023-03-01 21:41:00","inspection_id":"77971974","dot_number":"1295809","report_state":"MA","report_number":"CW00001396","insp_date":"2023-03-01 00:00:00","insp_start_time":"0912","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"071S","location_desc":"S-CHICOPEE","county_code_state":"MA","county_code":"013","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":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-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","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":"461350","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":"M","census_search_date":"2023-03-01 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"171","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:09.000000Z","updated_at":"2025-03-17T19:12:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3980145,"change_date":"2023-03-01 21:41:00","inspection_id":"77971974","insp_unit_id":"193632967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"329","insp_unit_license":"1AA12F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPXD40X0ND794343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:31.000000Z","updated_at":"2025-03-17T22:34:31.000000Z"},{"id":3980146,"change_date":"2023-03-01 21:41:00","inspection_id":"77971974","insp_unit_id":"193632968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-76","insp_unit_license":"97948","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T385HR059361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:31.000000Z","updated_at":"2025-03-17T22:34:31.000000Z"}]},{"id":2364588,"change_date":"2023-02-16 21:41:00","inspection_id":"77848339","dot_number":"1295809","report_state":"NH","report_number":"0953006019","insp_date":"2023-02-10 00:00:00","insp_start_time":"0834","insp_end_time":"0855","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"264292","transaction_code":"C","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:18.000000Z","updated_at":"2025-03-17T19:10:18.000000Z","inspection_violations":[{"id":3641762,"change_date":"2023-02-16 21:41:00","inspection_id":"77848339","insp_violation_id":"251172668","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193430157","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:12.000000Z","updated_at":"2025-03-17T21:24:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3805262,"change_date":"2023-02-16 21:41:00","inspection_id":"77848339","insp_unit_id":"193430157","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9767A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXGGGGX0D654916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:16.000000Z","updated_at":"2025-03-17T22:33:16.000000Z"},{"id":3805263,"change_date":"2023-02-16 21:41:00","inspection_id":"77848339","insp_unit_id":"193430158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"SM1828A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XKR068093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:16.000000Z","updated_at":"2025-03-17T22:33:16.000000Z"}]},{"id":979578,"change_date":"2022-08-08 21:39:00","inspection_id":"76253727","dot_number":"1295809","report_state":"NH","report_number":"1230000670","insp_date":"2022-08-04 00:00:00","insp_start_time":"1148","insp_end_time":"1203","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"SANBORNTON","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-08 21:39: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":"259266","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-04 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-08-08 21:39:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:49.000000Z","updated_at":"2025-03-17T18:44:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1576154,"change_date":"2022-08-08 21:39:00","inspection_id":"76253727","insp_unit_id":"190172495","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"121","insp_unit_license":"97207","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MA33838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:56.000000Z","updated_at":"2025-03-17T22:17:56.000000Z"},{"id":1576155,"change_date":"2022-08-08 21:39:00","inspection_id":"76253727","insp_unit_id":"190172496","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T73","insp_unit_license":"96234","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1F9S38XHR059340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:56.000000Z","updated_at":"2025-03-17T22:17:56.000000Z"}]},{"id":950040,"change_date":"2022-08-12 21:39:00","inspection_id":"76219167","dot_number":"1295809","report_state":"NH","report_number":"1078006107","insp_date":"2022-08-02 00:00:00","insp_start_time":"1004","insp_end_time":"1028","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":"2022-08-03 21:41: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":"259125","transaction_code":"C","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01295809","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-08-03 21:41:00","insp_carrier_name":"W L FRENCH JR TRUCKING CO","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":"17160","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:24.000000Z","updated_at":"2025-03-17T18:44:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1529771,"change_date":"2022-08-12 21:39:00","inspection_id":"76219167","insp_unit_id":"190275275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9971A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2XPXD40X3LM706389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"},{"id":1529772,"change_date":"2022-08-12 21:39:00","inspection_id":"76219167","insp_unit_id":"190275276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"3373B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1E1D2T386LR071222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1295809\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1295809\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1295809\/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\/1295809\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}