{"current_page":1,"data":[{"id":11261628,"change_date":"2026-03-13 21:37:00","inspection_id":"87175438","dot_number":"2913025","report_state":"CT","report_number":"3129006537","insp_date":"2026-02-28 00:00:00","insp_start_time":"0640","insp_end_time":"0721","registration_date":"2026-03-13 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-02 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"19450","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"766463","transaction_code":"C","transaction_date":"2026-02-28 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-02 21:37:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:38:49.000000Z","updated_at":"2026-03-24T09:30:07.000000Z","inspection_violations":[{"id":19150086,"change_date":"2026-03-13 21:37:00","inspection_id":"87175438","insp_violation_id":"272379546","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"212114947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-16T10:00:55.000000Z","updated_at":"2026-03-24T09:45:04.000000Z","normalized_code":"3939ALRLI"},{"id":19150087,"change_date":"2026-03-13 21:37:00","inspection_id":"87175438","insp_violation_id":"272379547","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","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-03-16T10:00:55.000000Z","updated_at":"2026-03-24T09:45:04.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":19460416,"change_date":"2026-03-13 21:37:00","inspection_id":"87175438","insp_unit_id":"212114947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BA17808","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H5JK006421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:50.000000Z","updated_at":"2026-03-24T09:03:18.000000Z"}]},{"id":11231833,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","dot_number":"2913025","report_state":"NY","report_number":"SPK3051023","insp_date":"2026-02-19 00:00:00","insp_start_time":"1356","insp_end_time":"1416","registration_date":"2026-03-03 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"PINE PLAINS NY","county_code_state":"NY","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2934702","transaction_code":"C","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:50.000000Z","updated_at":"2026-03-15T09:30:05.000000Z","inspection_violations":[{"id":18965834,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","insp_violation_id":"272185247","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211958669","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:15.000000Z","updated_at":"2026-03-15T09:40:12.000000Z","normalized_code":"39395A4EEUS"},{"id":18965835,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","insp_violation_id":"272185248","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211958669","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:15.000000Z","updated_at":"2026-03-15T09:40:12.000000Z","normalized_code":"3939ALCL"},{"id":18965836,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","insp_violation_id":"272185249","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211958669","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:15.000000Z","updated_at":"2026-03-15T09:40:12.000000Z","normalized_code":"3922SLLUCR"},{"id":18965837,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","insp_violation_id":"272185250","seq_no":"4","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"1","insp_unit_id":"211958669","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:15.000000Z","updated_at":"2026-03-15T09:40:12.000000Z","normalized_code":"393100CC"},{"id":18965838,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","insp_violation_id":"272185251","seq_no":"5","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"211958669","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:15.000000Z","updated_at":"2026-03-15T09:40:12.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":19292123,"change_date":"2026-03-04 21:40:00","inspection_id":"87144082","insp_unit_id":"211958669","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50081","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JV4G4S54491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:38.000000Z","updated_at":"2026-03-15T09:03:16.000000Z"}]},{"id":9979688,"change_date":"2025-10-20 21:38:00","inspection_id":"86088788","dot_number":"2913025","report_state":"CT","report_number":"3091006210","insp_date":"2025-10-20 00:00:00","insp_start_time":"0751","insp_end_time":"0816","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OLIVEIRA DELIVERY SERVICES LLC","shipping_paper_number":"103829984","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"755608","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-20 21:38:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:23.000000Z","updated_at":"2025-10-24T10:00:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16570286,"change_date":"2025-10-20 21:38:00","inspection_id":"86088788","insp_unit_id":"209543103","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50081","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JV4G4S54491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:31.000000Z","updated_at":"2025-10-24T09:45:10.000000Z"}]},{"id":8015459,"change_date":"2025-03-18 21:39:00","inspection_id":"84019941","dot_number":"2913025","report_state":"CT","report_number":"0511000367","insp_date":"2025-03-01 00:00:00","insp_start_time":"0647","insp_end_time":"0701","registration_date":"2025-03-18 00:00:00","region":"ET","ci_status_code":"C","location":"101","location_desc":"I-91 NORTH HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","shipping_paper_number":"DIGITAL","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":"2025-03-04 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":"733694","transaction_code":"C","transaction_date":"2025-03-01 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-04 21:38:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:32.000000Z","updated_at":"2025-03-22T10:26:17.000000Z","inspection_violations":[{"id":12735732,"change_date":"2025-03-18 21:39:00","inspection_id":"84019941","insp_violation_id":"265091855","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-21T10:51:28.000000Z","updated_at":"2025-03-21T11:01:57.000000Z","normalized_code":"3922SLLS2"},{"id":12735733,"change_date":"2025-03-18 21:39:00","inspection_id":"84019941","insp_violation_id":"265091856","seq_no":"2","part_no":"392","part_no_section":"2-MCSR","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-21T10:51:28.000000Z","updated_at":"2025-03-21T11:01:57.000000Z","normalized_code":"3922MCSR"}],"inspection_per_units":[{"id":13146007,"change_date":"2025-03-18 21:39:00","inspection_id":"84019941","insp_unit_id":"205847890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50124","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H2LK010865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:00:47.000000Z","updated_at":"2025-03-22T09:49:20.000000Z"}]},{"id":7696878,"change_date":"2025-01-28 21:38:00","inspection_id":"83685412","dot_number":"2913025","report_state":"CT","report_number":"3029002816","insp_date":"2025-01-24 00:00:00","insp_start_time":"0657","insp_end_time":"0706","registration_date":"2025-01-28 00:00:00","region":"ET","ci_status_code":"C","location":"080","location_desc":"MERIDEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OLIVEIRA DELIVERY SERVICES 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":"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":"2025-01-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"730535","transaction_code":"C","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-24 21:39:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:56.000000Z","updated_at":"2025-03-17T20:57:56.000000Z","inspection_violations":[{"id":12025891,"change_date":"2025-01-28 21:38:00","inspection_id":"83685412","insp_violation_id":"264203445","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":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12420104,"change_date":"2025-01-28 21:38:00","inspection_id":"83685412","insp_unit_id":"205032282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"}]},{"id":6497012,"change_date":"2024-08-19 21:41:00","inspection_id":"82415484","dot_number":"2913025","report_state":"CT","report_number":"3010003573","insp_date":"2024-08-15 00:00:00","insp_start_time":"0641","insp_end_time":"0707","registration_date":null,"region":"ET","ci_status_code":"C","location":"007","location_desc":"BERLIN","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BESTBUY","shipping_paper_number":"TRIP SLIP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"715511","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-03-17T20:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10472835,"change_date":"2024-08-19 21:41:00","inspection_id":"82415484","insp_unit_id":"202451748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"}]},{"id":5894938,"change_date":"2024-06-03 21:42:00","inspection_id":"81768040","dot_number":"2913025","report_state":"NY","report_number":"SPK0174901","insp_date":"2024-05-30 00:00:00","insp_start_time":"0830","insp_end_time":"0854","registration_date":null,"region":"ET","ci_status_code":"C","location":"80446","location_desc":"LAGRANGE","county_code_state":"NY","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":"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-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2927639","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"665 RIDGEWOOD RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[{"id":9140222,"change_date":"2024-06-03 21:42:00","inspection_id":"81768040","insp_violation_id":"259857505","seq_no":"1","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39115A"}],"inspection_per_units":[{"id":9494745,"change_date":"2024-06-03 21:42:00","inspection_id":"81768040","insp_unit_id":"201195467","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50124","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H2LK010865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]},{"id":4793097,"change_date":"2024-01-09 21:43:00","inspection_id":"80566916","dot_number":"2913025","report_state":"NY","report_number":"SPWK071200","insp_date":"2024-01-08 00:00:00","insp_start_time":"0735","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789","location_desc":"SOUTHEAST (W\/B)","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2897938","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-09 21:43:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:40.000000Z","updated_at":"2025-03-17T19:57:40.000000Z","inspection_violations":[{"id":7395510,"change_date":"2024-01-09 21:43:00","inspection_id":"80566916","insp_violation_id":"257253183","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198876724","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7711083,"change_date":"2024-01-09 21:43:00","inspection_id":"80566916","insp_unit_id":"198876724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50124","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H2LK010865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:56.000000Z","updated_at":"2025-03-17T23:04:56.000000Z"}]},{"id":4468391,"change_date":"2023-11-21 21:39:00","inspection_id":"80211167","dot_number":"2913025","report_state":"CT","report_number":"0513000063","insp_date":"2023-11-20 00:00:00","insp_start_time":"0814","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"005","location_desc":"BARKHAMSTED","county_code_state":"CT","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OLIVEIRA DELIVERY SERVICES 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":"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-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"692292","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-21 21:39:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:25.000000Z","updated_at":"2025-03-17T19:51:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7186364,"change_date":"2023-11-21 21:39:00","inspection_id":"80211167","insp_unit_id":"198155963","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"NONE","insp_unit_license":"AE24689","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JT9F4S56346","insp_unit_decal":"Y","insp_unit_decal_number":"33438972","created_at":"2025-03-17T23:00:22.000000Z","updated_at":"2025-03-17T23:00:22.000000Z"}]},{"id":4140956,"change_date":"2023-10-06 21:40:00","inspection_id":"79849395","dot_number":"2913025","report_state":"NY","report_number":"SPK0195428","insp_date":"2023-10-05 00:00:00","insp_start_time":"1035","insp_end_time":"1051","registration_date":null,"region":"ET","ci_status_code":"C","location":"80129","location_desc":"MAHOPAC","county_code_state":"NY","county_code":"079","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-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2876195","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:53.000000Z","updated_at":"2025-03-17T19:44:53.000000Z","inspection_violations":[{"id":6409888,"change_date":"2023-10-06 21:40:00","inspection_id":"79849395","insp_violation_id":"255694997","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197430361","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922"},{"id":6409889,"change_date":"2023-10-06 21:40:00","inspection_id":"79849395","insp_violation_id":"255694998","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197430361","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922"},{"id":6409890,"change_date":"2023-10-06 21:40:00","inspection_id":"79849395","insp_violation_id":"255694999","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197430361","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":6658244,"change_date":"2023-10-06 21:40:00","inspection_id":"79849395","insp_unit_id":"197430361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50124","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H2LK010865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":3658751,"change_date":"2023-08-08 21:40:00","inspection_id":"79312024","dot_number":"2913025","report_state":"CT","report_number":"3015002188","insp_date":"2023-08-03 00:00:00","insp_start_time":"0910","insp_end_time":"0925","registration_date":"2023-08-08 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I-95 S\/B BEFORE EXIT 74","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OLIVEIRA DELIVERY SERVICES 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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"682365","transaction_code":"C","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-03 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:59.000000Z","updated_at":"2025-03-17T19:34:59.000000Z","inspection_violations":[{"id":5640530,"change_date":"2023-08-08 21:40:00","inspection_id":"79312024","insp_violation_id":"254522868","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196414735","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:10.000000Z","updated_at":"2025-03-17T21:33:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5883005,"change_date":"2023-08-08 21:40:00","inspection_id":"79312024","insp_unit_id":"196414735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"N\/A","insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"}]},{"id":3605824,"change_date":"2023-07-27 21:40:00","inspection_id":"79252772","dot_number":"2913025","report_state":"NY","report_number":"SPK0195271","insp_date":"2023-07-22 00:00:00","insp_start_time":"0945","insp_end_time":"1001","registration_date":null,"region":"ET","ci_status_code":"C","location":"80129","location_desc":"MAHOPAC","county_code_state":"NY","county_code":"079","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-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2852439","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[{"id":5560371,"change_date":"2023-07-27 21:40:00","inspection_id":"79252772","insp_violation_id":"254308392","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196219710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5H059XR","created_at":"2025-03-17T21:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"3939A"},{"id":5560372,"change_date":"2023-07-27 21:40:00","inspection_id":"79252772","insp_violation_id":"254308393","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196219710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"3939A"},{"id":5560373,"change_date":"2023-07-27 21:40:00","inspection_id":"79252772","insp_violation_id":"254308394","seq_no":"3","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:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"39141A"},{"id":5560374,"change_date":"2023-07-27 21:40:00","inspection_id":"79252772","insp_violation_id":"254308395","seq_no":"4","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:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":5797457,"change_date":"2023-07-27 21:40:00","inspection_id":"79252772","insp_unit_id":"196219710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BA17808","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H5JK006421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3541664,"change_date":"2023-08-17 21:42:00","inspection_id":"79180746","dot_number":"2913025","report_state":"MA","report_number":"CW00001885","insp_date":"2023-07-19 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":"2023-08-17 00:00:00","region":"ET","ci_status_code":"C","location":"086H","location_desc":"H-DEERFIELD","county_code_state":"MA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GE","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-07-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"470392","transaction_code":"C","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":"2023-07-19 21:43:00","snet_input_date":"2023-07-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-07-19 21:43:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"9817","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:07.000000Z","updated_at":"2025-03-17T19:33:07.000000Z","inspection_violations":[{"id":5460510,"change_date":"2023-08-17 21:42:00","inspection_id":"79180746","insp_violation_id":"254700229","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:32:22.000000Z","updated_at":"2025-03-17T21:32:22.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5694474,"change_date":"2023-08-17 21:42:00","inspection_id":"79180746","insp_unit_id":"196572633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"}]},{"id":2969779,"change_date":"2023-05-15 21:41:00","inspection_id":"78536316","dot_number":"2913025","report_state":"CT","report_number":"3010002594","insp_date":"2023-05-04 00:00:00","insp_start_time":"1108","insp_end_time":"1140","registration_date":"2023-05-15 00:00:00","region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"673516","transaction_code":"C","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-05 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:51.000000Z","updated_at":"2025-03-17T19:21:51.000000Z","inspection_violations":[{"id":4557851,"change_date":"2023-05-15 21:41:00","inspection_id":"78536316","insp_violation_id":"252816162","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:13.000000Z","updated_at":"2025-03-17T21:28:13.000000Z","normalized_code":"39141A"},{"id":4557852,"change_date":"2023-05-15 21:41:00","inspection_id":"78536316","insp_violation_id":"252816163","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194917726","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:13.000000Z","updated_at":"2025-03-17T21:28:13.000000Z","normalized_code":"3922"},{"id":4557853,"change_date":"2023-05-15 21:41:00","inspection_id":"78536316","insp_violation_id":"252816164","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194917726","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:13.000000Z","updated_at":"2025-03-17T21:28:13.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4778456,"change_date":"2023-05-15 21:41:00","inspection_id":"78536316","insp_unit_id":"194917726","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24689","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JT9F4S56346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:39.000000Z","updated_at":"2025-03-17T22:40:39.000000Z"}]},{"id":2620064,"change_date":"2023-03-21 21:41:00","inspection_id":"78139374","dot_number":"2913025","report_state":"CT","report_number":"3132003684","insp_date":"2023-03-21 00:00:00","insp_start_time":"0724","insp_end_time":"0752","registration_date":null,"region":"ET","ci_status_code":"C","location":"028","location_desc":"COLCHESTER","county_code_state":"CT","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL ELECTRIC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"669882","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:08.000000Z","updated_at":"2025-03-17T19:15:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4217829,"change_date":"2023-03-21 21:41:00","inspection_id":"78139374","insp_unit_id":"193969554","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3CZ939","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAEUMMM0LL824758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"}]},{"id":2557303,"change_date":"2023-03-29 21:41:00","inspection_id":"78067812","dot_number":"2913025","report_state":"CT","report_number":"3129003839","insp_date":"2023-03-13 00:00:00","insp_start_time":"1344","insp_end_time":"1359","registration_date":"2023-03-29 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","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":"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":"2023-03-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"669151","transaction_code":"C","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-13 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[{"id":3934301,"change_date":"2023-03-29 21:41:00","inspection_id":"78067812","insp_violation_id":"251915296","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:27.000000Z","updated_at":"2025-03-17T21:25:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4116142,"change_date":"2023-03-29 21:41:00","inspection_id":"78067812","insp_unit_id":"194109635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"}]},{"id":2250748,"change_date":"2023-01-30 21:43:00","inspection_id":"77718949","dot_number":"2913025","report_state":"NY","report_number":"SPK0158111","insp_date":"2023-01-16 00:00:00","insp_start_time":"1032","insp_end_time":"1053","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST(E\/B","county_code_state":"NY","county_code":"079","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"2792620","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:08.000000Z","updated_at":"2025-03-17T19:08:08.000000Z","inspection_violations":[{"id":3476100,"change_date":"2023-01-30 21:43:00","inspection_id":"77718949","insp_violation_id":"250836652","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193118254","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3622400,"change_date":"2023-01-30 21:43:00","inspection_id":"77718949","insp_unit_id":"193118254","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24689","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JT9F4S56346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:58.000000Z","updated_at":"2025-03-17T22:31:58.000000Z"}]},{"id":2089476,"change_date":"2023-01-09 21:41:00","inspection_id":"77534127","dot_number":"2913025","report_state":"CT","report_number":"3016000091","insp_date":"2023-01-09 00:00:00","insp_start_time":"1145","insp_end_time":"1207","registration_date":null,"region":"ET","ci_status_code":"C","location":"017","location_desc":"RT. 229 BRISTOL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RXO LAST MILE","shipping_paper_number":"NSNBDLB5M010923","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-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"663087","transaction_code":"A","transaction_date":"2023-01-09 00:00:00","upload_date":"2023-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-01-09 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:08.000000Z","updated_at":"2025-03-17T19:05:08.000000Z","inspection_violations":[{"id":3233543,"change_date":"2023-01-09 21:41:00","inspection_id":"77534127","insp_violation_id":"250440232","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:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":3361949,"change_date":"2023-01-09 21:41:00","inspection_id":"77534127","insp_unit_id":"192749163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"0","insp_unit_license":"AE24689","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JT9F4S56346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:05.000000Z","updated_at":"2025-03-17T22:30:05.000000Z"}]},{"id":2150470,"change_date":"2023-01-17 21:41:00","inspection_id":"77604081","dot_number":"2913025","report_state":"NY","report_number":"SPK0174288","insp_date":"2022-12-29 00:00:00","insp_start_time":"1048","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","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-01-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"2789579","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-17 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:15.000000Z","updated_at":"2025-03-17T19:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3460090,"change_date":"2023-01-17 21:41:00","inspection_id":"77604081","insp_unit_id":"192887543","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:49.000000Z","updated_at":"2025-03-17T22:30:49.000000Z"}]},{"id":1792809,"change_date":"2022-11-30 21:40:00","inspection_id":"77194912","dot_number":"2913025","report_state":"CT","report_number":"3082000062","insp_date":"2022-11-22 00:00:00","insp_start_time":"0725","insp_end_time":"0804","registration_date":"2022-11-30 00:00:00","region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEST BUY","shipping_paper_number":"2319011C","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"659585","transaction_code":"C","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-22 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:40.000000Z","updated_at":"2025-03-17T18:59:40.000000Z","inspection_violations":[{"id":2804360,"change_date":"2022-11-30 21:40:00","inspection_id":"77194912","insp_violation_id":"249842240","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:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39145B"},{"id":2804361,"change_date":"2022-11-30 21:40:00","inspection_id":"77194912","insp_violation_id":"249842241","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192183845","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3939A"},{"id":2804362,"change_date":"2022-11-30 21:40:00","inspection_id":"77194912","insp_violation_id":"249842242","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192183845","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":2884116,"change_date":"2022-11-30 21:40:00","inspection_id":"77194912","insp_unit_id":"192183845","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:43.000000Z","updated_at":"2025-03-17T22:26:43.000000Z"}]},{"id":1724203,"change_date":"2022-11-14 21:41:00","inspection_id":"77116219","dot_number":"2913025","report_state":"NY","report_number":"0814016214","insp_date":"2022-11-10 00:00:00","insp_start_time":"1049","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789M","location_desc":"SOUTHEAST REST AREA (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2767621","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[{"id":2700805,"change_date":"2022-11-14 21:41:00","inspection_id":"77116219","insp_violation_id":"249560437","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191920186","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"3922"},{"id":2700806,"change_date":"2022-11-14 21:41:00","inspection_id":"77116219","insp_violation_id":"249560438","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191920186","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2773601,"change_date":"2022-11-14 21:41:00","inspection_id":"77116219","insp_unit_id":"191920186","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50124","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JHHSDM2H2LK010865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":1270439,"change_date":"2022-09-26 21:39:00","inspection_id":"76591905","dot_number":"2913025","report_state":"CT","report_number":"0613000708","insp_date":"2022-09-13 00:00:00","insp_start_time":"1557","insp_end_time":"1613","registration_date":"2022-09-26 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"I-84 EB EXIT 23","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"654070","transaction_code":"C","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-09-13 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:07.000000Z","updated_at":"2025-03-17T18:50:07.000000Z","inspection_violations":[{"id":2011702,"change_date":"2022-09-26 21:39:00","inspection_id":"76591905","insp_violation_id":"248626461","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2044562,"change_date":"2022-09-26 21:39:00","inspection_id":"76591905","insp_unit_id":"191080310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24689","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JT9F4S56346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:02.000000Z","updated_at":"2025-03-17T22:21:02.000000Z"}]},{"id":1031489,"change_date":"2022-08-15 21:37:00","inspection_id":"76314175","dot_number":"2913025","report_state":"CT","report_number":"3132003114","insp_date":"2022-08-08 00:00:00","insp_start_time":"1344","insp_end_time":"1405","registration_date":"2022-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","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":"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":"2022-08-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"650938","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-15 21:37:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:49.000000Z","updated_at":"2025-03-17T18:45:49.000000Z","inspection_violations":[{"id":1625572,"change_date":"2022-08-15 21:37:00","inspection_id":"76314175","insp_violation_id":"247698835","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:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1660073,"change_date":"2022-08-15 21:37:00","inspection_id":"76314175","insp_unit_id":"190295689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE50081","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JV4G4S54491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:28.000000Z","updated_at":"2025-03-17T22:18:28.000000Z"}]},{"id":901133,"change_date":"2022-08-15 21:37:00","inspection_id":"76161559","dot_number":"2913025","report_state":"CT","report_number":"3078001104","insp_date":"2022-07-26 00:00:00","insp_start_time":"0908","insp_end_time":"0948","registration_date":"2022-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"074","location_desc":"LITCHFIELD","county_code_state":"CT","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2022-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"649945","transaction_code":"C","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-27 21:40:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[{"id":1422141,"change_date":"2022-08-15 21:37:00","inspection_id":"76161559","insp_violation_id":"247698533","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"3922"},{"id":1422142,"change_date":"2022-08-15 21:37:00","inspection_id":"76161559","insp_violation_id":"247698534","seq_no":"2","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:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"39216A"},{"id":1422143,"change_date":"2022-08-15 21:37:00","inspection_id":"76161559","insp_violation_id":"247698535","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190295511","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1450774,"change_date":"2022-08-15 21:37:00","inspection_id":"76161559","insp_unit_id":"190295511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"}]},{"id":453281,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","dot_number":"2913025","report_state":"CT","report_number":"3014003031","insp_date":"2022-05-21 00:00:00","insp_start_time":"0744","insp_end_time":"0807","registration_date":"2022-06-07 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"2319011C","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-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"7","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"644883","transaction_code":"C","transaction_date":"2022-05-21 00:00:00","upload_date":"2022-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02913025","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-23 21:41:00","insp_carrier_name":"OLIVEIRA DELIVERY SERVICES LLC","insp_carrier_street":"1 YELLOW GREEN RD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"CT","insp_carrier_zip_code":"06457","insp_colonia":null,"docket_number":"981711","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:39.000000Z","updated_at":"2025-03-17T18:35:39.000000Z","inspection_violations":[{"id":718730,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278804","seq_no":"7","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"189095278","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"393205C"},{"id":718731,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278805","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189095278","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"3922"},{"id":718732,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278806","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189095278","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"3922"},{"id":718733,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278807","seq_no":"3","part_no":"392","part_no_section":"9(a)(3)","insp_viol_unit":"1","insp_unit_id":"189095278","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"3929A3"},{"id":718734,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278808","seq_no":"4","part_no":"392","part_no_section":"16(b)","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:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"39216B"},{"id":718735,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278809","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"3939A"},{"id":718736,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_violation_id":"246278810","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189095278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":730663,"change_date":"2022-06-07 21:38:00","inspection_id":"75633428","insp_unit_id":"189095278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"268","insp_unit_license":"AE24669","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV5J4S69908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:42.000000Z","updated_at":"2025-03-17T22:12:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2913025\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2913025\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2913025\/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\/2913025\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}