{"current_page":1,"data":[{"id":12202043,"change_date":"2026-06-16 21:40:00","inspection_id":"88158848","dot_number":"278485","report_state":"NH","report_number":"0850002296","insp_date":"2026-06-16 00:00:00","insp_start_time":"1429","insp_end_time":"1500","registration_date":null,"region":"ES","ci_status_code":"C","location":"237","location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MIRRA CO LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"3556661","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:41.000000Z","updated_at":"2026-06-27T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21193174,"change_date":"2026-06-16 21:40:00","inspection_id":"88158848","insp_unit_id":"214132526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2626","insp_unit_license":"V85899","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FS0KDC43904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:20.000000Z","updated_at":"2026-06-27T09:02:03.000000Z"}]},{"id":12190614,"change_date":"2026-06-15 21:41:00","inspection_id":"88146546","dot_number":"278485","report_state":"NH","report_number":"0850002292","insp_date":"2026-06-15 00:00:00","insp_start_time":"1224","insp_end_time":"1235","registration_date":null,"region":"ES","ci_status_code":"C","location":"237","location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MIRRA CO LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"3546988","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-18T09:40:59.000000Z","updated_at":"2026-06-26T09:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21173840,"change_date":"2026-06-15 21:41:00","inspection_id":"88146546","insp_unit_id":"214107426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2637","insp_unit_license":"1AH83N","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN1NDC17312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:49.000000Z","updated_at":"2026-06-26T09:02:07.000000Z"}]},{"id":11896986,"change_date":"2026-05-13 21:42:00","inspection_id":"87835517","dot_number":"278485","report_state":"NH","report_number":"1094005063","insp_date":"2026-05-13 00:00:00","insp_start_time":"1255","insp_end_time":"1406","registration_date":null,"region":"ES","ci_status_code":"C","location":"042","location_desc":"NH","county_code_state":"NH","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"WILD FLOWER WAY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3314919","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:55.000000Z","updated_at":"2026-05-24T09:31:17.000000Z","inspection_violations":[{"id":20693530,"change_date":"2026-05-13 21:42:00","inspection_id":"87835517","insp_violation_id":"274227328","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:16.000000Z","updated_at":"2026-05-24T09:44:57.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20683945,"change_date":"2026-05-13 21:42:00","inspection_id":"87835517","insp_unit_id":"213527591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":null,"insp_unit_license":"T57551","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHM6X7LM398661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:33.000000Z","updated_at":"2026-05-24T09:04:31.000000Z"}]},{"id":11856621,"change_date":"2026-05-08 21:38:00","inspection_id":"87792892","dot_number":"278485","report_state":"MA","report_number":"DS00002852","insp_date":"2026-05-08 00:00:00","insp_start_time":"0738","insp_end_time":"0748","registration_date":null,"region":"ES","ci_status_code":"C","location":"281H","location_desc":"MA","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3284384","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:40:00.000000Z","updated_at":"2026-05-19T09:30:42.000000Z","inspection_violations":[{"id":20622099,"change_date":"2026-05-08 21:38:00","inspection_id":"87792892","insp_violation_id":"274128068","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:49.000000Z","updated_at":"2026-05-19T09:42:11.000000Z","normalized_code":"3922SLLTCD"},{"id":20622100,"change_date":"2026-05-08 21:38:00","inspection_id":"87792892","insp_violation_id":"274128069","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:49.000000Z","updated_at":"2026-05-19T09:42:11.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20618055,"change_date":"2026-05-08 21:38:00","inspection_id":"87792892","insp_unit_id":"213445920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"V26959","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W161L7301156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:21.000000Z","updated_at":"2026-05-19T09:02:48.000000Z"}]},{"id":11855211,"change_date":"2026-05-08 21:38:00","inspection_id":"87791413","dot_number":"278485","report_state":"ME","report_number":"4387004139","insp_date":"2026-05-07 00:00:00","insp_start_time":"1951","insp_end_time":"2006","registration_date":null,"region":"ES","ci_status_code":"C","location":"000295","location_desc":"ME","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3283152","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:39:58.000000Z","updated_at":"2026-05-19T09:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20615843,"change_date":"2026-05-08 21:38:00","inspection_id":"87791413","insp_unit_id":"213443475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"W87206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRNBL1NG299783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:19.000000Z","updated_at":"2026-05-19T09:02:32.000000Z"}]},{"id":11452813,"change_date":"2026-03-23 21:51:00","inspection_id":"87370387","dot_number":"278485","report_state":"MA","report_number":"EL00000217","insp_date":"2026-03-19 00:00:00","insp_start_time":"1744","insp_end_time":"1800","registration_date":null,"region":"ET","ci_status_code":"C","location":"329H","location_desc":"H-TAUNTON","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":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"542399","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2026-03-23 21:51:00","snet_input_date":"2026-03-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:39.000000Z","updated_at":"2026-04-03T09:32:59.000000Z","inspection_violations":[{"id":19325115,"change_date":"2026-03-23 21:51:00","inspection_id":"87370387","insp_violation_id":"272578856","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","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-03-26T10:02:08.000000Z","updated_at":"2026-04-03T09:51:03.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":19615281,"change_date":"2026-03-23 21:51:00","inspection_id":"87370387","insp_unit_id":"212283944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2658","insp_unit_license":"X26412","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT4NDA18055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:48.000000Z","updated_at":"2026-04-03T09:06:29.000000Z"},{"id":19615282,"change_date":"2026-03-23 21:51:00","inspection_id":"87370387","insp_unit_id":"212283945","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ANAI","insp_unit_company":null,"insp_unit_license":"F47661","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"7H6BY11A8MA003195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:48.000000Z","updated_at":"2026-04-03T09:06:29.000000Z"}]},{"id":11265632,"change_date":"2026-03-02 21:38:00","inspection_id":"87179667","dot_number":"278485","report_state":"MA","report_number":"CX00002043","insp_date":"2026-03-02 00:00:00","insp_start_time":"1032","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"310H","location_desc":"H-SPENCER","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":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"82360","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"541169","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:39:01.000000Z","updated_at":"2026-03-13T09:31:05.000000Z","inspection_violations":[{"id":18934000,"change_date":"2026-03-02 21:38:00","inspection_id":"87179667","insp_violation_id":"272136598","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWPB","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-03-05T10:56:59.000000Z","updated_at":"2026-03-13T09:45:02.000000Z","normalized_code":"3922SLLEWPB"},{"id":18934001,"change_date":"2026-03-02 21:38:00","inspection_id":"87179667","insp_violation_id":"272136599","seq_no":"2","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-03-05T10:56:59.000000Z","updated_at":"2026-03-13T09:45:02.000000Z","normalized_code":"3922SLLTCD"},{"id":18934002,"change_date":"2026-03-02 21:38:00","inspection_id":"87179667","insp_violation_id":"272136600","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"211917575","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:59.000000Z","updated_at":"2026-03-13T09:45:02.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":19264722,"change_date":"2026-03-02 21:38:00","inspection_id":"87179667","insp_unit_id":"211917575","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2228","insp_unit_license":"1AA35R","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALMGNDV1PDUH3410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:43.000000Z","updated_at":"2026-03-13T09:06:55.000000Z"}]},{"id":12149467,"change_date":"2026-06-10 21:44:00","inspection_id":"88098503","dot_number":"278485","report_state":"NH","report_number":"1128002886","insp_date":"2026-01-30 00:00:00","insp_start_time":"1734","insp_end_time":"1758","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"3510612","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-01-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:30.000000Z","updated_at":"2026-06-21T09:31:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21105935,"change_date":"2026-06-10 21:44:00","inspection_id":"88098503","insp_unit_id":"214017407","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2225","insp_unit_license":"5139B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X2NM767472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:57.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"},{"id":21105936,"change_date":"2026-06-10 21:44:00","inspection_id":"88098503","insp_unit_id":"214017408","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"D52061","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V349GL081258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:57.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"}]},{"id":10789886,"change_date":"2026-01-16 21:39:00","inspection_id":"86815973","dot_number":"278485","report_state":"MA","report_number":"DS00002515","insp_date":"2026-01-15 00:00:00","insp_start_time":"1902","insp_end_time":"1912","registration_date":null,"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":"2026-01-16 21:39: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":"538524","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:55.000000Z","updated_at":"2026-01-27T10:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18115338,"change_date":"2026-01-16 21:39:00","inspection_id":"86815973","insp_unit_id":"211132670","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AH94X","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NK5LJ0X7PM263906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:25.000000Z","updated_at":"2026-01-27T10:00:42.000000Z"}]},{"id":10409574,"change_date":"2025-12-15 21:39:00","inspection_id":"86540238","dot_number":"278485","report_state":"MA","report_number":"BV00008123","insp_date":"2025-12-11 00:00:00","insp_start_time":"0445","insp_end_time":"0503","registration_date":"2025-12-15 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-12-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"535966","transaction_code":"C","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-12-11 21:44:00","snet_input_date":"2025-12-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-11 21:44:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:46.000000Z","updated_at":"2025-12-26T10:30:24.000000Z","inspection_violations":[{"id":17497702,"change_date":"2025-12-15 21:39:00","inspection_id":"86540238","insp_violation_id":"270684690","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-12-18T10:30:44.000000Z","updated_at":"2025-12-26T10:30:49.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17454761,"change_date":"2025-12-15 21:39:00","inspection_id":"86540238","insp_unit_id":"210608385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1AF92E","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN9RDD07443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:31.000000Z","updated_at":"2025-12-26T10:00:32.000000Z"}]},{"id":10216260,"change_date":"2025-11-17 21:39:00","inspection_id":"86337814","dot_number":"278485","report_state":"NH","report_number":"1128002791","insp_date":"2025-11-17 00:00:00","insp_start_time":"0612","insp_end_time":"0629","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"289794","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2025-11-17 21:39:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-11-17 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:32.000000Z","updated_at":"2025-11-21T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17019857,"change_date":"2025-11-17 21:39:00","inspection_id":"86337814","insp_unit_id":"210064693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1679","insp_unit_license":"V11584","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2GB2KREG5K1151019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:34.000000Z","updated_at":"2025-11-21T10:00:46.000000Z"},{"id":17019858,"change_date":"2025-11-17 21:39:00","inspection_id":"86337814","insp_unit_id":"210064694","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"KTRL","insp_unit_company":null,"insp_unit_license":"D93840","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2RYKBCG29JM019064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:34.000000Z","updated_at":"2025-11-21T10:00:46.000000Z"}]},{"id":10144983,"change_date":"2025-11-13 21:39:00","inspection_id":"86262909","dot_number":"278485","report_state":"NH","report_number":"1094004945","insp_date":"2025-11-06 00:00:00","insp_start_time":"1524","insp_end_time":"1555","registration_date":"2025-11-10 00:00:00","region":"ES","ci_status_code":"C","location":"042","location_desc":"NH","county_code_state":"NH","county_code":"017","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"JOB#252504","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2535764","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:36.000000Z","updated_at":"2025-11-17T10:30:10.000000Z","inspection_violations":[{"id":16920475,"change_date":"2025-11-13 21:39:00","inspection_id":"86262909","insp_violation_id":"269921931","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"210000877","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":16966041,"change_date":"2025-11-13 21:39:00","inspection_id":"86262909","insp_unit_id":"210000877","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2676","insp_unit_license":"Y29388","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC0RDVJ1099","insp_unit_decal":"Y","insp_unit_decal_number":"35826479","created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:11.000000Z"}]},{"id":10162429,"change_date":"2025-11-14 21:40:00","inspection_id":"86281288","dot_number":"278485","report_state":"MA","report_number":"DL00001480","insp_date":"2025-11-06 00:00:00","insp_start_time":"1905","insp_end_time":"1922","registration_date":"2025-11-14 00:00:00","region":"ET","ci_status_code":"C","location":"333H","location_desc":"H-TOPSFIELD","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-11-10 21:39: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":"533291","transaction_code":"C","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2025-11-10 21:39:00","snet_input_date":"2025-11-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:41.000000Z","updated_at":"2025-11-18T10:30:29.000000Z","inspection_violations":[{"id":16941620,"change_date":"2025-11-14 21:40:00","inspection_id":"86281288","insp_violation_id":"269949750","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210025314","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-17T10:31:53.000000Z","updated_at":"2025-11-18T10:30:57.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16986201,"change_date":"2025-11-14 21:40:00","inspection_id":"86281288","insp_unit_id":"210025313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1497","insp_unit_license":"3281A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZXPTXXJJ194714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:16.000000Z","updated_at":"2025-11-18T10:00:47.000000Z"},{"id":16986202,"change_date":"2025-11-14 21:40:00","inspection_id":"86281288","insp_unit_id":"210025314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"E79471","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V349KL083939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:16.000000Z","updated_at":"2025-11-18T10:00:47.000000Z"}]},{"id":10017926,"change_date":"2025-10-23 21:39:00","inspection_id":"86129023","dot_number":"278485","report_state":"MA","report_number":"EG00000574","insp_date":"2025-10-23 00:00:00","insp_start_time":"0835","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","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":"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-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"532094","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:53.000000Z","updated_at":"2025-10-27T10:00:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16641770,"change_date":"2025-10-23 21:39:00","inspection_id":"86129023","insp_unit_id":"209619986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1494","insp_unit_license":"98695","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHJ7X5JM189820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:08.000000Z","updated_at":"2025-10-27T09:46:06.000000Z"},{"id":16641771,"change_date":"2025-10-23 21:39:00","inspection_id":"86129023","insp_unit_id":"209619987","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":"2706","insp_unit_license":"E33571","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V340JL083035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:08.000000Z","updated_at":"2025-10-27T09:46:06.000000Z"}]},{"id":10078519,"change_date":"2025-10-30 21:42:00","inspection_id":"86192877","dot_number":"278485","report_state":"NH","report_number":"1128002702","insp_date":"2025-09-05 00:00:00","insp_start_time":"1616","insp_end_time":"1633","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"2480944","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-09-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:12.000000Z","updated_at":"2025-11-03T11:00:58.000000Z","inspection_violations":[{"id":16692039,"change_date":"2025-10-30 21:42:00","inspection_id":"86192877","insp_violation_id":"269619108","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209740578","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:58.000000Z","updated_at":"2025-11-03T11:16:12.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16753811,"change_date":"2025-10-30 21:42:00","inspection_id":"86192877","insp_unit_id":"209740578","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2225","insp_unit_license":"5139B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X2NM767472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:05.000000Z"},{"id":16753812,"change_date":"2025-10-30 21:42:00","inspection_id":"86192877","insp_unit_id":"209740579","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"D52061","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V349GL081258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:05.000000Z"}]},{"id":9437257,"change_date":"2025-08-18 21:39:00","inspection_id":"85518754","dot_number":"278485","report_state":"MA","report_number":"DQ00002567","insp_date":"2025-08-15 00:00:00","insp_start_time":"0111","insp_end_time":"0136","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","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-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"525988","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:46.000000Z","updated_at":"2025-08-23T10:45:46.000000Z","inspection_violations":[{"id":15362469,"change_date":"2025-08-18 21:39:00","inspection_id":"85518754","insp_violation_id":"268086347","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-08-21T10:42:27.000000Z","updated_at":"2025-08-22T10:43:39.000000Z","normalized_code":"3922SLLLR"},{"id":15362470,"change_date":"2025-08-18 21:39:00","inspection_id":"85518754","insp_violation_id":"268086348","seq_no":"2","part_no":"392","part_no_section":"2-SLLFC","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-08-21T10:42:27.000000Z","updated_at":"2025-08-22T10:43:39.000000Z","normalized_code":"3922SLLFC"},{"id":15362471,"change_date":"2025-08-18 21:39:00","inspection_id":"85518754","insp_violation_id":"268086349","seq_no":"3","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-08-21T10:42:27.000000Z","updated_at":"2025-08-22T10:43:39.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15559661,"change_date":"2025-08-18 21:39:00","inspection_id":"85518754","insp_unit_id":"208445267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"V97741","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W16XM7300590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:38.000000Z","updated_at":"2025-08-22T09:45:46.000000Z"}]},{"id":9202597,"change_date":"2025-07-21 21:41:00","inspection_id":"85271892","dot_number":"278485","report_state":"MA","report_number":"DA00003630","insp_date":"2025-07-20 00:00:00","insp_start_time":"1855","insp_end_time":"1910","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":"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":"N","pen_cen_match":null,"final_status_date":"2025-07-21 21:41: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":"523480","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:28.000000Z","updated_at":"2025-07-25T10:45:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15129162,"change_date":"2025-07-21 21:41:00","inspection_id":"85271892","insp_unit_id":"207981609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2204","insp_unit_license":"1309B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKDX4EX4LJ384811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:34.000000Z","updated_at":"2025-07-25T09:45:51.000000Z"}]},{"id":8295650,"change_date":"2025-04-04 21:40:00","inspection_id":"84314918","dot_number":"278485","report_state":"MA","report_number":"CL00004050","insp_date":"2025-04-03 00:00:00","insp_start_time":"1625","insp_end_time":"1652","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WOOD TRUCKING CORP.","shipping_paper_number":"388807","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"514045","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:02.000000Z","updated_at":"2025-04-08T10:09:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13450160,"change_date":"2025-04-04 21:40:00","inspection_id":"84314918","insp_unit_id":"206156816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2205","insp_unit_license":"278485","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3BKBLJ0X6LF384851","insp_unit_decal":"Y","insp_unit_decal_number":"35009146","created_at":"2025-04-07T10:09:18.000000Z","updated_at":"2025-04-08T09:56:30.000000Z"}]},{"id":8295744,"change_date":"2025-04-04 21:40:00","inspection_id":"84315018","dot_number":"278485","report_state":"MA","report_number":"CT00003301","insp_date":"2025-04-03 00:00:00","insp_start_time":"1825","insp_end_time":"1855","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20200","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":"514042","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:04.000000Z","updated_at":"2025-04-08T10:09:21.000000Z","inspection_violations":[{"id":13044470,"change_date":"2025-04-04 21:40:00","inspection_id":"84315018","insp_violation_id":"265442659","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"206156953","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:48:43.000000Z","updated_at":"2025-04-07T10:55:52.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":13450281,"change_date":"2025-04-04 21:40:00","inspection_id":"84315018","insp_unit_id":"206156952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2618","insp_unit_license":"W17011","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ5LG241972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:09:18.000000Z","updated_at":"2025-04-08T09:56:32.000000Z"},{"id":13450282,"change_date":"2025-04-04 21:40:00","inspection_id":"84315018","insp_unit_id":"206156953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SULL","insp_unit_company":null,"insp_unit_license":"E79499","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"201909040104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:09:18.000000Z","updated_at":"2025-04-08T09:56:32.000000Z"}]},{"id":8222769,"change_date":"2025-03-27 21:41:00","inspection_id":"84238226","dot_number":"278485","report_state":"MA","report_number":"CJ00002420","insp_date":"2025-03-26 00:00:00","insp_start_time":"1403","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82360","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":"513322","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:21.000000Z","updated_at":"2025-03-31T10:28:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13301548,"change_date":"2025-03-27 21:41:00","inspection_id":"84238226","insp_unit_id":"206016991","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2228","insp_unit_license":"1AA35R","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALMGNDV1PDUH3410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:19:19.000000Z","updated_at":"2025-03-31T09:57:15.000000Z"}]},{"id":8069882,"change_date":"2025-03-10 21:38:00","inspection_id":"84077360","dot_number":"278485","report_state":"MA","report_number":"DX00000129","insp_date":"2025-03-07 00:00:00","insp_start_time":"0030","insp_end_time":"0050","registration_date":null,"region":"ET","ci_status_code":"C","location":"270H","location_desc":"H-RAYNHAM","county_code_state":"MA","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":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-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"511476","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:51.000000Z","updated_at":"2025-03-17T21:05:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13029988,"change_date":"2025-03-10 21:38:00","inspection_id":"84077360","insp_unit_id":"205709491","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2658","insp_unit_license":"X26412","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT4NDA18055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:58.000000Z","updated_at":"2025-03-17T23:58:58.000000Z"}]},{"id":7485605,"change_date":"2024-12-23 21:39:00","inspection_id":"83463720","dot_number":"278485","report_state":"NH","report_number":"1292002351","insp_date":"2024-12-20 00:00:00","insp_start_time":"1419","insp_end_time":"1437","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OSSIPEE","county_code_state":"NH","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":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-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"281151","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:18.000000Z","updated_at":"2025-03-17T20:52:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12076480,"change_date":"2024-12-23 21:39:00","inspection_id":"83463720","insp_unit_id":"204528837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V59468","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FS8KDC43908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:21.000000Z","updated_at":"2025-03-17T23:48:21.000000Z"}]},{"id":7292658,"change_date":"2024-11-27 21:39:00","inspection_id":"83260766","dot_number":"278485","report_state":"MA","report_number":"BV00007005","insp_date":"2024-11-26 00:00:00","insp_start_time":"1531","insp_end_time":"1547","registration_date":null,"region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","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-11-27 21:39: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":"504291","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:10.000000Z","updated_at":"2025-03-17T20:48:10.000000Z","inspection_violations":[{"id":11403075,"change_date":"2024-11-27 21:39:00","inspection_id":"83260766","insp_violation_id":"263123960","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:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11763519,"change_date":"2024-11-27 21:39:00","inspection_id":"83260766","insp_unit_id":"204083924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3281A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZXPTXXJJ194714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:55.000000Z","updated_at":"2025-03-17T23:44:55.000000Z"}]},{"id":7274527,"change_date":"2024-11-25 21:43:00","inspection_id":"83241556","dot_number":"278485","report_state":"NH","report_number":"1292002308","insp_date":"2024-11-22 00:00:00","insp_start_time":"1449","insp_end_time":"1501","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WAKEFIELD","county_code_state":"NH","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"280493","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2024-11-25 21:43:00","snet_input_date":"2024-11-22 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-11-25 21:43:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:44.000000Z","updated_at":"2025-03-17T20:47:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11733892,"change_date":"2024-11-25 21:43:00","inspection_id":"83241556","insp_unit_id":"204043743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"S19812","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHM6XXGM486870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:36.000000Z","updated_at":"2025-03-17T23:44:36.000000Z"}]},{"id":7237883,"change_date":"2024-12-05 21:37:00","inspection_id":"83202855","dot_number":"278485","report_state":"MA","report_number":"DL00000559","insp_date":"2024-11-20 00:00:00","insp_start_time":"1533","insp_end_time":"1553","registration_date":"2024-12-05 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":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"503956","transaction_code":"C","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[{"id":11314621,"change_date":"2024-12-05 21:37:00","inspection_id":"83202855","insp_violation_id":"263250027","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":11674624,"change_date":"2024-12-05 21:37:00","inspection_id":"83202855","insp_unit_id":"204198036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2226","insp_unit_license":"5865B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3BKBLJ0X4MF441159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":7228792,"change_date":"2024-11-19 21:40:00","inspection_id":"83193288","dot_number":"278485","report_state":"NH","report_number":"1274003373","insp_date":"2024-11-18 00:00:00","insp_start_time":"0800","insp_end_time":"0816","registration_date":null,"region":"ET","ci_status_code":"C","location":"035","location_desc":"OSSIPEE","county_code_state":"NH","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19490","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":"280323","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:49.000000Z","updated_at":"2025-03-17T20:46:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11659876,"change_date":"2024-11-19 21:40:00","inspection_id":"83193288","insp_unit_id":"203950739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2601","insp_unit_license":"V26210","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2GT22NEG3K1154733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:49.000000Z","updated_at":"2025-03-17T23:43:49.000000Z"},{"id":11659877,"change_date":"2024-11-19 21:40:00","inspection_id":"83193288","insp_unit_id":"203950740","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"HDSN","insp_unit_company":"2990","insp_unit_license":"TZ64157","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"10HHSL161M2000090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:49.000000Z","updated_at":"2025-03-17T23:43:49.000000Z"}]},{"id":7069271,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","dot_number":"278485","report_state":"MA","report_number":"CX00001121","insp_date":"2024-10-28 00:00:00","insp_start_time":"1350","insp_end_time":"1434","registration_date":"2024-11-04 00:00:00","region":"ET","ci_status_code":"C","location":"021S","location_desc":"S-AUBURN","county_code_state":"MA","county_code":"027","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-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"6","oos_total":"3","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"502372","transaction_code":"C","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:26.000000Z","updated_at":"2025-03-17T20:43:26.000000Z","inspection_violations":[{"id":11036247,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_violation_id":"262706846","seq_no":"2","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"203717833","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"39375GLOAD"},{"id":11036248,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_violation_id":"262706847","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"203717833","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3922SLLEWG3"},{"id":11036249,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_violation_id":"262706848","seq_no":"3","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"203717833","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"39375GLOAD"},{"id":11036250,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_violation_id":"262706849","seq_no":"4","part_no":"393","part_no_section":"100B","insp_viol_unit":"1","insp_unit_id":"203717833","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"393100B"},{"id":11036251,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_violation_id":"262706850","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWPB","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"974857AC","created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3922SLLEWPB"},{"id":11036252,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_violation_id":"262706851","seq_no":"6","part_no":"392","part_no_section":"9","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":11401236,"change_date":"2024-11-04 21:40:00","inspection_id":"83024320","insp_unit_id":"203717833","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1475","insp_unit_license":"2140A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHLJ9X2JM203541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:04.000000Z","updated_at":"2025-03-17T23:41:04.000000Z"}]},{"id":6733109,"change_date":"2024-10-04 21:39:00","inspection_id":"82666766","dot_number":"278485","report_state":"MA","report_number":"DQ00001252","insp_date":"2024-09-13 00:00:00","insp_start_time":"1705","insp_end_time":"1722","registration_date":"2024-10-04 00:00:00","region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"2024-09-16 21:42: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":"499568","transaction_code":"C","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-09-16 21:42:00","snet_input_date":"2024-09-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-16 21:42:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:32.000000Z","updated_at":"2025-03-17T20:36:32.000000Z","inspection_violations":[{"id":10483889,"change_date":"2024-10-04 21:39:00","inspection_id":"82666766","insp_violation_id":"262190696","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:47.000000Z","updated_at":"2025-03-17T21:56:47.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":10857264,"change_date":"2024-10-04 21:39:00","inspection_id":"82666766","insp_unit_id":"203271331","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1456","insp_unit_license":"T53221","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHM6X5KM250524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:28.000000Z","updated_at":"2025-03-17T23:35:28.000000Z"}]},{"id":6719996,"change_date":"2024-09-19 21:41:00","inspection_id":"82652851","dot_number":"278485","report_state":"MA","report_number":"DS00001003","insp_date":"2024-09-12 00:00:00","insp_start_time":"1639","insp_end_time":"1651","registration_date":"2024-09-19 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":"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-09-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"499439","transaction_code":"C","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-09-13 21:41:00","snet_input_date":"2024-09-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-13 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:09.000000Z","updated_at":"2025-03-17T20:36:09.000000Z","inspection_violations":[{"id":10461108,"change_date":"2024-09-19 21:41:00","inspection_id":"82652851","insp_violation_id":"261916719","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10835743,"change_date":"2024-09-19 21:41:00","inspection_id":"82652851","insp_unit_id":"203023514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"5139B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X2NM767472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"}]},{"id":6454024,"change_date":"2024-08-13 21:42:00","inspection_id":"82369625","dot_number":"278485","report_state":"MA","report_number":"CE00007243","insp_date":"2024-08-13 00:00:00","insp_start_time":"0626","insp_end_time":"0641","registration_date":null,"region":"ET","ci_status_code":"C","location":"325H","location_desc":"H-SUTTON","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"497439","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","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":10402854,"change_date":"2024-08-13 21:42:00","inspection_id":"82369625","insp_unit_id":"202364004","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"W16961","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ3LG241968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"}]},{"id":6217112,"change_date":"2024-07-15 21:41:00","inspection_id":"82115992","dot_number":"278485","report_state":"MA","report_number":"DD00001698","insp_date":"2024-07-13 00:00:00","insp_start_time":"1219","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"386H","location_desc":"H-WORCESTER","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":"2024-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"495828","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:49.000000Z","updated_at":"2025-03-17T20:25:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10016572,"change_date":"2024-07-15 21:41:00","inspection_id":"82115992","insp_unit_id":"201882175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2622","insp_unit_license":"W17443","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ3LG241971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:48.000000Z","updated_at":"2025-03-17T23:26:48.000000Z"},{"id":10016573,"change_date":"2024-07-15 21:41:00","inspection_id":"82115992","insp_unit_id":"201882176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SULLA","insp_unit_company":null,"insp_unit_license":"E61019","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"201809210067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:48.000000Z","updated_at":"2025-03-17T23:26:48.000000Z"}]},{"id":6100749,"change_date":"2024-06-28 21:39:00","inspection_id":"81990964","dot_number":"278485","report_state":"NH","report_number":"1086999699","insp_date":"2024-06-27 00:00:00","insp_start_time":"0820","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"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":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"276307","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:43.000000Z","updated_at":"2025-03-17T20:23:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9826243,"change_date":"2024-06-28 21:39:00","inspection_id":"81990964","insp_unit_id":"201640399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2665","insp_unit_license":"X51789","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN3RDD17482","insp_unit_decal":"Y","insp_unit_decal_number":"34078216","created_at":"2025-03-17T23:24:48.000000Z","updated_at":"2025-03-17T23:24:48.000000Z"}]},{"id":6044430,"change_date":"2024-06-21 21:38:00","inspection_id":"81930374","dot_number":"278485","report_state":"MA","report_number":"DC00001753","insp_date":"2024-06-20 00:00:00","insp_start_time":"1719","insp_end_time":"1728","registration_date":null,"region":"ET","ci_status_code":"C","location":"219H","location_desc":"H-NEEDHAM","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-06-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"494407","transaction_code":"A","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-06-21 21:38:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-21 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:35.000000Z","updated_at":"2025-03-17T20:22:35.000000Z","inspection_violations":[{"id":9376175,"change_date":"2024-06-21 21:38:00","inspection_id":"81930374","insp_violation_id":"260227498","seq_no":"1","part_no":"392","part_no_section":"2","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-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3922"},{"id":9376176,"change_date":"2024-06-21 21:38:00","inspection_id":"81930374","insp_violation_id":"260227499","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9735220,"change_date":"2024-06-21 21:38:00","inspection_id":"81930374","insp_unit_id":"201521066","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W72897","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT9NED20340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"}]},{"id":5274605,"change_date":"2024-03-19 21:44:00","inspection_id":"81092905","dot_number":"278485","report_state":"MA","report_number":"CD00007208","insp_date":"2024-03-13 00:00:00","insp_start_time":"0608","insp_end_time":"0623","registration_date":"2024-03-19 00:00:00","region":"ET","ci_status_code":"C","location":"083H","location_desc":"H-DANVERS","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"487521","transaction_code":"C","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-03-13 21:41:00","snet_input_date":"2024-03-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-13 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:06.000000Z","updated_at":"2025-03-17T20:07:06.000000Z","inspection_violations":[{"id":8133933,"change_date":"2024-03-19 21:44:00","inspection_id":"81092905","insp_violation_id":"258456905","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:18.000000Z","updated_at":"2025-03-17T21:45:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8493916,"change_date":"2024-03-19 21:44:00","inspection_id":"81092905","insp_unit_id":"199976853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"W15852","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ1LG241970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:58.000000Z","updated_at":"2025-03-17T23:11:58.000000Z"}]},{"id":5264984,"change_date":"2024-03-19 21:44:00","inspection_id":"81082435","dot_number":"278485","report_state":"MA","report_number":"CD00007203","insp_date":"2024-03-11 00:00:00","insp_start_time":"1639","insp_end_time":"1653","registration_date":"2024-03-19 00:00:00","region":"ET","ci_status_code":"C","location":"385H","location_desc":"H-WOBURN","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-03-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"487337","transaction_code":"C","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-03-12 21:38:00","snet_input_date":"2024-03-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-12 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:03.000000Z","updated_at":"2025-03-17T20:07:03.000000Z","inspection_violations":[{"id":8119627,"change_date":"2024-03-19 21:44:00","inspection_id":"81082435","insp_violation_id":"258456904","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:13.000000Z","updated_at":"2025-03-17T21:45:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8478297,"change_date":"2024-03-19 21:44:00","inspection_id":"81082435","insp_unit_id":"199976852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W72897","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT9NED20340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:50.000000Z","updated_at":"2025-03-17T23:11:50.000000Z"}]},{"id":5187743,"change_date":"2024-03-01 21:39:00","inspection_id":"80997948","dot_number":"278485","report_state":"MA","report_number":"DG00000113","insp_date":"2024-02-29 00:00:00","insp_start_time":"1445","insp_end_time":"1458","registration_date":null,"region":"ET","ci_status_code":"C","location":"237H","location_desc":"H-NORTHBORO","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"486464","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8353010,"change_date":"2024-03-01 21:39:00","inspection_id":"80997948","insp_unit_id":"199706353","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"W11696","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ0LG241975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"},{"id":8353011,"change_date":"2024-03-01 21:39:00","inspection_id":"80997948","insp_unit_id":"199706354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AIRME","insp_unit_company":"2943","insp_unit_license":"F47659","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"7H6BY11A8MA003214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4996108,"change_date":"2024-02-07 21:40:00","inspection_id":"80789057","dot_number":"278485","report_state":"ME","report_number":"1121009499","insp_date":"2024-02-06 00:00:00","insp_start_time":"1525","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"375201","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-02-07 21:40:00","snet_input_date":"2024-02-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-02-07 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":7695828,"change_date":"2024-02-07 21:40:00","inspection_id":"80789057","insp_violation_id":"257707640","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":8041313,"change_date":"2024-02-07 21:40:00","inspection_id":"80789057","insp_unit_id":"199307745","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2637","insp_unit_license":"1AH83N","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN1NDC17312","insp_unit_decal":"Y","insp_unit_decal_number":"33746193","created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4874100,"change_date":"2024-01-23 21:44:00","inspection_id":"80655551","dot_number":"278485","report_state":"NH","report_number":"1292001726","insp_date":"2024-01-12 00:00:00","insp_start_time":"1437","insp_end_time":"1507","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCHESTER","county_code_state":"NH","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"272382","transaction_code":"C","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2024-01-22 21:43:00","snet_input_date":"2024-01-12 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-01-22 21:43:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:16.000000Z","updated_at":"2025-03-17T19:59:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7842301,"change_date":"2024-01-23 21:44:00","inspection_id":"80655551","insp_unit_id":"199066902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X51789","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN3RDD17482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:05.000000Z","updated_at":"2025-03-17T23:06:05.000000Z"}]},{"id":4762358,"change_date":"2024-01-18 21:45:00","inspection_id":"80533230","dot_number":"278485","report_state":"MA","report_number":"CD00006993","insp_date":"2024-01-03 00:00:00","insp_start_time":"1553","insp_end_time":"1644","registration_date":"2024-01-18 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","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-01-04 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"482071","transaction_code":"C","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2024-01-04 21:47:00","snet_input_date":"2024-01-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-04 21:47:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:14.000000Z","updated_at":"2025-03-17T19:57:14.000000Z","inspection_violations":[{"id":7349236,"change_date":"2024-01-18 21:45:00","inspection_id":"80533230","insp_violation_id":"257391488","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199009298","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7661556,"change_date":"2024-01-18 21:45:00","inspection_id":"80533230","insp_unit_id":"199009297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1478","insp_unit_license":"4824A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHJ7X1JM214597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:29.000000Z","updated_at":"2025-03-17T23:04:29.000000Z"},{"id":7661557,"change_date":"2024-01-18 21:45:00","inspection_id":"80533230","insp_unit_id":"199009298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"E33571","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V340JL083035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:29.000000Z","updated_at":"2025-03-17T23:04:29.000000Z"}]},{"id":4649334,"change_date":"2023-12-18 21:41:00","inspection_id":"80409936","dot_number":"278485","report_state":"MA","report_number":"DD00001089","insp_date":"2023-12-16 00:00:00","insp_start_time":"1400","insp_end_time":"1412","registration_date":null,"region":"ET","ci_status_code":"C","location":"300H","location_desc":"H-SHREWSBURY","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":"2023-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"481080","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7477656,"change_date":"2023-12-18 21:41:00","inspection_id":"80409936","insp_unit_id":"198545379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2624","insp_unit_license":"W11696","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ0LG241975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"},{"id":7477657,"change_date":"2023-12-18 21:41:00","inspection_id":"80409936","insp_unit_id":"198545380","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AIRME","insp_unit_company":"2943","insp_unit_license":"F47659","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"7H6BY11A8MA003214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"}]},{"id":4190705,"change_date":"2023-10-13 21:40:00","inspection_id":"79904286","dot_number":"278485","report_state":"MA","report_number":"DK00000067","insp_date":"2023-10-13 00:00:00","insp_start_time":"1040","insp_end_time":"1053","registration_date":null,"region":"ET","ci_status_code":"C","location":"386H","location_desc":"H-WORCESTER","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-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"131000","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":"476264","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[{"id":6488652,"change_date":"2023-10-13 21:40:00","inspection_id":"79904286","insp_violation_id":"255818811","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197540557","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"227823AC","created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6739357,"change_date":"2023-10-13 21:40:00","inspection_id":"79904286","insp_unit_id":"197540557","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"EAGL","insp_unit_company":null,"insp_unit_license":"E25130","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V343LL084179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"},{"id":6739358,"change_date":"2023-10-13 21:40:00","inspection_id":"79904286","insp_unit_id":"197540558","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"5818B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPTX4TX3MD767390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":4029209,"change_date":"2023-09-29 21:39:00","inspection_id":"79725043","dot_number":"278485","report_state":"MA","report_number":"DD00000907","insp_date":"2023-09-22 00:00:00","insp_start_time":"0845","insp_end_time":"0925","registration_date":"2023-09-29 00:00:00","region":"ET","ci_status_code":"C","location":"386S","location_desc":"S-WORCESTER","county_code_state":"MA","county_code":"027","insp_level_id":"2","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":"2023-09-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"474534","transaction_code":"C","transaction_date":"2023-09-22 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-09-22 21:38:00","snet_input_date":"2023-09-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-09-22 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:24.000000Z","updated_at":"2025-03-17T19:42:24.000000Z","inspection_violations":[{"id":6236788,"change_date":"2023-09-29 21:39:00","inspection_id":"79725043","insp_violation_id":"255563914","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"197310417","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"39375G"},{"id":6236789,"change_date":"2023-09-29 21:39:00","inspection_id":"79725043","insp_violation_id":"255563915","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197310417","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"194312AC","created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"3922"},{"id":6236790,"change_date":"2023-09-29 21:39:00","inspection_id":"79725043","insp_violation_id":"255563916","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197310417","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"194312AC","created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6478522,"change_date":"2023-09-29 21:39:00","inspection_id":"79725043","insp_unit_id":"197310417","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2211","insp_unit_license":"3575B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZX4TX4LJ421817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:22.000000Z","updated_at":"2025-03-17T22:54:22.000000Z"}]},{"id":3960138,"change_date":"2023-09-13 21:40:00","inspection_id":"79648490","dot_number":"278485","report_state":"MA","report_number":"BV00006445","insp_date":"2023-09-12 00:00:00","insp_start_time":"1634","insp_end_time":"1654","registration_date":null,"region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","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":"2023-09-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"473814","transaction_code":"A","transaction_date":"2023-09-13 00:00:00","upload_date":"2023-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-09-13 21:40:00","snet_input_date":"2023-09-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-09-13 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:09.000000Z","updated_at":"2025-03-17T19:41:09.000000Z","inspection_violations":[{"id":6124713,"change_date":"2023-09-13 21:40:00","inspection_id":"79648490","insp_violation_id":"255233961","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:37.000000Z","updated_at":"2025-03-17T21:35:37.000000Z","normalized_code":"39141A"},{"id":6124714,"change_date":"2023-09-13 21:40:00","inspection_id":"79648490","insp_violation_id":"255233962","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:37.000000Z","updated_at":"2025-03-17T21:35:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6367759,"change_date":"2023-09-13 21:40:00","inspection_id":"79648490","insp_unit_id":"197024968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V85899","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FS0KDC43904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:29.000000Z","updated_at":"2025-03-17T22:53:29.000000Z"}]},{"id":3720370,"change_date":"2023-08-23 21:39:00","inspection_id":"79381109","dot_number":"278485","report_state":"MA","report_number":"DD00000825","insp_date":"2023-08-11 00:00:00","insp_start_time":"0816","insp_end_time":"0833","registration_date":"2023-08-23 00:00:00","region":"ET","ci_status_code":"C","location":"386S","location_desc":"S-WORCESTER","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":"2023-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"471900","transaction_code":"C","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-08-11 21:38:00","snet_input_date":"2023-08-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-08-11 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:27.000000Z","updated_at":"2025-03-17T19:36:27.000000Z","inspection_violations":[{"id":5737172,"change_date":"2023-08-23 21:39:00","inspection_id":"79381109","insp_violation_id":"254820614","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196677857","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"122446AC","created_at":"2025-03-17T21:33:33.000000Z","updated_at":"2025-03-17T21:33:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5981868,"change_date":"2023-08-23 21:39:00","inspection_id":"79381109","insp_unit_id":"196677857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2224","insp_unit_license":"5819B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X2MM767471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:16.000000Z","updated_at":"2025-03-17T22:50:16.000000Z"}]},{"id":3572643,"change_date":"2023-07-24 21:41:00","inspection_id":"79215634","dot_number":"278485","report_state":"NH","report_number":"0953006355","insp_date":"2023-07-20 00:00:00","insp_start_time":"1500","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM","county_code_state":"NH","county_code":"015","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"267855","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:33.000000Z","updated_at":"2025-03-17T19:33:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5744360,"change_date":"2023-07-24 21:41:00","inspection_id":"79215634","insp_unit_id":"196143071","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W83954","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT7NED20336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:19.000000Z","updated_at":"2025-03-17T22:48:19.000000Z"}]},{"id":3410415,"change_date":"2023-07-13 21:41:00","inspection_id":"79033408","dot_number":"278485","report_state":"NH","report_number":"1078006848","insp_date":"2023-06-29 00:00:00","insp_start_time":"0825","insp_end_time":"0915","registration_date":"2023-07-13 00:00:00","region":"ET","ci_status_code":"C","location":"002","location_desc":"BELMONT","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"267251","transaction_code":"C","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-29 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:35.000000Z","updated_at":"2025-03-17T19:30:35.000000Z","inspection_violations":[{"id":5257991,"change_date":"2023-07-13 21:41:00","inspection_id":"79033408","insp_violation_id":"254031267","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"38323A2"},{"id":5257992,"change_date":"2023-07-13 21:41:00","inspection_id":"79033408","insp_violation_id":"254031268","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"39141A1"},{"id":5257993,"change_date":"2023-07-13 21:41:00","inspection_id":"79033408","insp_violation_id":"254031269","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195971878","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23-887-000760","created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5483140,"change_date":"2023-07-13 21:41:00","inspection_id":"79033408","insp_unit_id":"195971878","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"4357A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NPTL40XXFM258359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"}]},{"id":3393393,"change_date":"2023-06-29 21:41:00","inspection_id":"79014254","dot_number":"278485","report_state":"NH","report_number":"1292001394","insp_date":"2023-06-28 00:00:00","insp_start_time":"0736","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCHESTER DOT SHEDS","county_code_state":"NH","county_code":"017","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"267204","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2023-06-29 21:41:00","snet_input_date":"2023-06-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-06-29 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:11.000000Z","updated_at":"2025-03-17T19:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5455518,"change_date":"2023-06-29 21:41:00","inspection_id":"79014254","insp_unit_id":"195737607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"T57551","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"2NKHHM6X7LM398661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:03.000000Z","updated_at":"2025-03-17T22:46:03.000000Z"}]},{"id":3218075,"change_date":"2023-06-13 21:41:00","inspection_id":"78816669","dot_number":"278485","report_state":"MA","report_number":"BV00006283","insp_date":"2023-06-05 00:00:00","insp_start_time":"1531","insp_end_time":"1547","registration_date":"2023-06-13 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":"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-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"467397","transaction_code":"C","transaction_date":"2023-06-06 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-06-06 21:43:00","snet_input_date":"2023-06-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-06-06 21:43:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:31.000000Z","updated_at":"2025-03-17T19:26:31.000000Z","inspection_violations":[{"id":4960513,"change_date":"2023-06-13 21:41:00","inspection_id":"78816669","insp_violation_id":"253458356","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5175444,"change_date":"2023-06-13 21:41:00","inspection_id":"78816669","insp_unit_id":"195458843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V85727","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FS3KDC43900","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:48.000000Z","updated_at":"2025-03-17T22:43:48.000000Z"}]},{"id":2737734,"change_date":"2023-06-13 21:41:00","inspection_id":"78273761","dot_number":"278485","report_state":"MA","report_number":"BV00006181","insp_date":"2023-04-05 00:00:00","insp_start_time":"1611","insp_end_time":"1631","registration_date":"2023-06-13 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-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"463448","transaction_code":"C","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:01.000000Z","updated_at":"2025-03-17T19:17:01.000000Z","inspection_violations":[{"id":4203074,"change_date":"2023-06-13 21:41:00","inspection_id":"78273761","insp_violation_id":"253458264","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4203075,"change_date":"2023-06-13 21:41:00","inspection_id":"78273761","insp_violation_id":"253458265","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195458785","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4406872,"change_date":"2023-06-13 21:41:00","inspection_id":"78273761","insp_unit_id":"195458785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"T88537","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRNBJ8JG212373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:41.000000Z","updated_at":"2025-03-17T22:37:41.000000Z"}]},{"id":2300527,"change_date":"2023-03-02 21:40:00","inspection_id":"77775470","dot_number":"278485","report_state":"ME","report_number":"0242001874","insp_date":"2023-02-06 00:00:00","insp_start_time":"0645","insp_end_time":"0710","registration_date":"2023-02-21 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MIRRA CO LLC","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"360200","transaction_code":"C","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2023-02-06 21:40:00","snet_input_date":"2023-02-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-02-06 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:12.000000Z","updated_at":"2025-03-17T19:09:12.000000Z","inspection_violations":[{"id":3546186,"change_date":"2023-03-02 21:40:00","inspection_id":"77775470","insp_violation_id":"251434069","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":3703004,"change_date":"2023-03-02 21:40:00","inspection_id":"77775470","insp_unit_id":"193666342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1AD95M","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FS0KDC34491","insp_unit_decal":"Y","insp_unit_decal_number":"32395264","created_at":"2025-03-17T22:32:31.000000Z","updated_at":"2025-03-17T22:32:31.000000Z"}]},{"id":2291828,"change_date":"2023-02-03 21:40:00","inspection_id":"77765516","dot_number":"278485","report_state":"NH","report_number":"0995000756","insp_date":"2023-02-02 00:00:00","insp_start_time":"0945","insp_end_time":"1008","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"264038","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2023-02-03 21:40:00","snet_input_date":"2023-02-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-02-03 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:53.000000Z","updated_at":"2025-03-17T19:08:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3688509,"change_date":"2023-02-03 21:40:00","inspection_id":"77765516","insp_unit_id":"193213806","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W22971","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN1NDC17312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:25.000000Z","updated_at":"2025-03-17T22:32:25.000000Z"}]},{"id":2210765,"change_date":"2023-01-24 21:42:00","inspection_id":"77673120","dot_number":"278485","report_state":"ME","report_number":"0242001858","insp_date":"2023-01-24 00:00:00","insp_start_time":"1308","insp_end_time":"1332","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":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MIRRA CO LLC","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"359602","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2023-01-24 21:42:00","snet_input_date":"2023-01-24 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-01-24 21:42:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:22.000000Z","updated_at":"2025-03-17T19:07:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3558018,"change_date":"2023-01-24 21:42:00","inspection_id":"77673120","insp_unit_id":"193023291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1AD27M","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FN3NDC17313","insp_unit_decal":"Y","insp_unit_decal_number":"32395244","created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"}]},{"id":2071683,"change_date":"2023-01-05 21:39:00","inspection_id":"77513660","dot_number":"278485","report_state":"NH","report_number":"1078006405","insp_date":"2023-01-04 00:00:00","insp_start_time":"1310","insp_end_time":"1321","registration_date":null,"region":"ET","ci_status_code":"C","location":"002","location_desc":"BELMONT","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-01-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"263314","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2023-01-05 21:39:00","snet_input_date":"2023-01-04 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-01-05 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:46.000000Z","updated_at":"2025-03-17T19:04:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3332930,"change_date":"2023-01-05 21:39:00","inspection_id":"77513660","insp_unit_id":"192708595","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AD99H","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZXPTXXGJ492866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"}]},{"id":1897776,"change_date":"2023-02-16 21:41:00","inspection_id":"77314816","dot_number":"278485","report_state":"MA","report_number":"CD00005748","insp_date":"2022-12-01 00:00:00","insp_start_time":"0609","insp_end_time":"0630","registration_date":"2023-02-16 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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"456533","transaction_code":"C","transaction_date":"2022-12-08 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2022-12-08 21:40:00","snet_input_date":"2022-12-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:32.000000Z","updated_at":"2025-03-17T19:01:32.000000Z","inspection_violations":[{"id":2953118,"change_date":"2023-02-16 21:41:00","inspection_id":"77314816","insp_violation_id":"251167026","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193426812","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39617C"},{"id":2953119,"change_date":"2023-02-16 21:41:00","inspection_id":"77314816","insp_violation_id":"251167027","seq_no":"2","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"193426812","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":3054163,"change_date":"2023-02-16 21:41:00","inspection_id":"77314816","insp_unit_id":"193426811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1495","insp_unit_license":"4122A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHLJ0X3JM191235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"},{"id":3054164,"change_date":"2023-02-16 21:41:00","inspection_id":"77314816","insp_unit_id":"193426812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"E42849","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V343KL083824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"}]},{"id":1897676,"change_date":"2023-02-16 21:41:00","inspection_id":"77314695","dot_number":"278485","report_state":"MA","report_number":"BV00006000","insp_date":"2022-11-28 00:00:00","insp_start_time":"1603","insp_end_time":"1619","registration_date":"2023-02-16 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":"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-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"456310","transaction_code":"C","transaction_date":"2022-12-08 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2022-12-08 21:40:00","snet_input_date":"2022-11-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:32.000000Z","updated_at":"2025-03-17T19:01:32.000000Z","inspection_violations":[{"id":2952836,"change_date":"2023-02-16 21:41:00","inspection_id":"77314695","insp_violation_id":"251167330","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":3054042,"change_date":"2023-02-16 21:41:00","inspection_id":"77314695","insp_unit_id":"193426946","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"V97742","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W165M7300576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"}]},{"id":1803517,"change_date":"2022-11-23 21:39:00","inspection_id":"77207279","dot_number":"278485","report_state":"MA","report_number":"CD00005724","insp_date":"2022-11-23 00:00:00","insp_start_time":"0858","insp_end_time":"0933","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-11-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"455980","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2022-11-23 21:39:00","snet_input_date":"2022-11-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-11-23 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:57.000000Z","updated_at":"2025-03-17T18:59:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2901157,"change_date":"2022-11-23 21:39:00","inspection_id":"77207279","insp_unit_id":"192102271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"V71421","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W162L7306429","insp_unit_decal":"Y","insp_unit_decal_number":"32075422","created_at":"2025-03-17T22:26:52.000000Z","updated_at":"2025-03-17T22:26:52.000000Z"}]},{"id":1599384,"change_date":"2022-10-26 21:38:00","inspection_id":"76973015","dot_number":"278485","report_state":"MA","report_number":"CR00002585","insp_date":"2022-10-26 00:00:00","insp_start_time":"1311","insp_end_time":"1334","registration_date":null,"region":"ET","ci_status_code":"C","location":"205S","location_desc":"S-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-10-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"454169","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2022-10-26 21:38:00","snet_input_date":"2022-10-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-10-26 21:38:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:59.000000Z","updated_at":"2025-03-17T18:55:59.000000Z","inspection_violations":[{"id":2514395,"change_date":"2022-10-26 21:38:00","inspection_id":"76973015","insp_violation_id":"249249789","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"3922"},{"id":2514396,"change_date":"2022-10-26 21:38:00","inspection_id":"76973015","insp_violation_id":"249249790","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191638795","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":2573528,"change_date":"2022-10-26 21:38:00","inspection_id":"76973015","insp_unit_id":"191638795","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"KWMH","insp_unit_company":"2211","insp_unit_license":"3575B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZX4TX4LJ421817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:38.000000Z","updated_at":"2025-03-17T22:24:38.000000Z"}]},{"id":979548,"change_date":"2022-08-18 21:39:00","inspection_id":"76253695","dot_number":"278485","report_state":"NH","report_number":"0945002967","insp_date":"2022-08-08 00:00:00","insp_start_time":"0712","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MIRRA CO LLC","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":"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":"18000","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":"259250","transaction_code":"C","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-08-08 21:39:00","snet_input_date":"2022-08-08 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-08-08 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","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":1576126,"change_date":"2022-08-18 21:39:00","inspection_id":"76253695","insp_unit_id":"190391815","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"S71485","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W167G7901170","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":940107,"change_date":"2022-08-02 21:39:00","inspection_id":"76207573","dot_number":"278485","report_state":"NH","report_number":"1085002301","insp_date":"2022-08-02 00:00:00","insp_start_time":"0707","insp_end_time":"0726","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":"2022-08-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"259105","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-08-02 21:39:00","snet_input_date":"2022-08-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-08-02 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:21.000000Z","updated_at":"2025-03-17T18:44:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1513306,"change_date":"2022-08-02 21:39:00","inspection_id":"76207573","insp_unit_id":"190077551","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"1623","insp_unit_license":"S71485","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W167G7901170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:31.000000Z","updated_at":"2025-03-17T22:17:31.000000Z"}]},{"id":825704,"change_date":"2022-08-19 21:35:00","inspection_id":"76073609","dot_number":"278485","report_state":"NH","report_number":"1274002272","insp_date":"2022-07-15 00:00:00","insp_start_time":"0446","insp_end_time":"0508","registration_date":"2022-08-19 00:00:00","region":"ET","ci_status_code":"C","location":"035","location_desc":"OSSIPEE","county_code_state":"NH","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-15 21:40: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":"258482","transaction_code":"C","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-07-15 21:40:00","snet_input_date":"2022-07-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:17.000000Z","updated_at":"2025-03-17T18:42:17.000000Z","inspection_violations":[{"id":1301339,"change_date":"2022-08-19 21:35:00","inspection_id":"76073609","insp_violation_id":"247844713","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1328292,"change_date":"2022-08-19 21:35:00","inspection_id":"76073609","insp_unit_id":"190418873","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"KWMH","insp_unit_company":"1632","insp_unit_license":"1AB82S","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHM6X5KM234534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"}]},{"id":427583,"change_date":"2022-05-19 21:41:00","inspection_id":"75602874","dot_number":"278485","report_state":"ME","report_number":"3031002802","insp_date":"2022-05-19 00:00:00","insp_start_time":"0702","insp_end_time":"0732","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":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"-","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":"I","final_status_date":"2022-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"347214","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833-0499","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:08.000000Z","updated_at":"2025-03-17T18:35:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":689618,"change_date":"2022-05-19 21:41:00","inspection_id":"75602874","insp_unit_id":"188778240","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1632","insp_unit_license":"1AB82S","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NKHHM6X5KM234534","insp_unit_decal":"Y","insp_unit_decal_number":"31389943","created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"}]},{"id":413082,"change_date":"2022-05-18 21:43:00","inspection_id":"75585679","dot_number":"278485","report_state":"US","report_number":"1435000272","insp_date":"2022-05-18 00:00:00","insp_start_time":"0750","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY, NH","county_code_state":"NH","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"35388","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1MDD001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"MIRRA CO INC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833-0499","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":666921,"change_date":"2022-05-18 21:43:00","inspection_id":"75585679","insp_unit_id":"188744025","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2623","insp_unit_license":"W11697","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRMCJ9LLG24197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":412932,"change_date":"2022-05-18 21:43:00","inspection_id":"75585496","dot_number":"278485","report_state":"MA","report_number":"CD00005136","insp_date":"2022-05-17 00:00:00","insp_start_time":"1001","insp_end_time":"1038","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"446260","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":666738,"change_date":"2022-05-18 21:43:00","inspection_id":"75585496","insp_unit_id":"188743761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"V79377","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W160L7302816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":107455,"change_date":"2022-04-12 21:42:00","inspection_id":"75219252","dot_number":"278485","report_state":"NH","report_number":"0945002638","insp_date":"2022-04-04 00:00:00","insp_start_time":"0745","insp_end_time":"0830","registration_date":"2022-04-12 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":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MIRRA CO LLC","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":"2022-04-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"4","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"256210","transaction_code":"C","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-04-05 21:39:00","snet_input_date":"2022-04-04 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-04-05 21:39:00","insp_carrier_name":"MIRRA CO LLC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:28.000000Z","updated_at":"2025-03-17T18:29:28.000000Z","inspection_violations":[{"id":157742,"change_date":"2022-04-12 21:42:00","inspection_id":"75219252","insp_violation_id":"245093381","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"39216A"},{"id":157743,"change_date":"2022-04-12 21:42:00","inspection_id":"75219252","insp_violation_id":"245093382","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"22-887-000890","created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"3922"},{"id":157744,"change_date":"2022-04-12 21:42:00","inspection_id":"75219252","insp_violation_id":"245093383","seq_no":"3","part_no":"391","part_no_section":"11(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"39111B1"},{"id":157745,"change_date":"2022-04-12 21:42:00","inspection_id":"75219252","insp_violation_id":"245093384","seq_no":"4","part_no":"396","part_no_section":"1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"3961"}],"inspection_per_units":[{"id":173883,"change_date":"2022-04-12 21:42:00","inspection_id":"75219252","insp_unit_id":"188099537","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"V71421","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W162L7306429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:16.000000Z","updated_at":"2025-03-17T22:09:16.000000Z"}]},{"id":23961,"change_date":"2022-03-29 21:41:00","inspection_id":"75113620","dot_number":"278485","report_state":"NH","report_number":"1274002130","insp_date":"2022-03-22 00:00:00","insp_start_time":"1759","insp_end_time":"1822","registration_date":"2022-03-28 00:00:00","region":"ET","ci_status_code":"C","location":"166","location_desc":"NEW DURHAM","county_code_state":"NH","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-23 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"255803","transaction_code":"C","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":null,"census_search_date":"2022-03-23 21:31:00","snet_input_date":"2022-03-22 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-03-23 21:31:00","insp_carrier_name":"MIRRA CO INC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:04.000000Z","updated_at":"2025-03-17T18:28:04.000000Z","inspection_violations":[{"id":33474,"change_date":"2022-03-29 21:41:00","inspection_id":"75113620","insp_violation_id":"244823941","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"187863341","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:16.000000Z","updated_at":"2025-03-17T21:07:16.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":38607,"change_date":"2022-03-29 21:41:00","inspection_id":"75113620","insp_unit_id":"187863341","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2614","insp_unit_license":"V59468","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE3FS8KDC43908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:30.000000Z","updated_at":"2025-03-17T22:08:30.000000Z"}]},{"id":23,"change_date":"2022-10-11 21:40:00","inspection_id":"75070162","dot_number":"278485","report_state":"MA","report_number":"CR00001895","insp_date":"2022-03-17 00:00:00","insp_start_time":"0555","insp_end_time":"0605","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","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":"2022-03-17 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"443325","transaction_code":"C","transaction_date":"2022-03-17 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00278485","upload_search_indicator":"M","census_search_date":"2022-03-17 21:31:00","snet_input_date":"2022-03-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-03-17 21:31:00","insp_carrier_name":"MIRRA CO INC","insp_carrier_street":"6 NORINO WAY","insp_carrier_city":"GEORGETOWN","insp_carrier_state":"MA","insp_carrier_zip_code":"01833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:42.000000Z","updated_at":"2025-03-17T18:27:42.000000Z","inspection_violations":[{"id":53,"change_date":"2022-10-11 21:40:00","inspection_id":"75070162","insp_violation_id":"248928853","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191355466","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:09.000000Z","updated_at":"2025-03-17T21:07:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":29,"change_date":"2022-10-11 21:40:00","inspection_id":"75070162","insp_unit_id":"191355466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"1454","insp_unit_license":"T56960","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5J167J7901101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:16.000000Z","updated_at":"2025-03-17T22:08:16.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/278485\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/278485\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/278485\/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\/278485\/inspections","per_page":100,"prev_page_url":null,"to":66,"total":66}