{"current_page":1,"data":[{"id":12220705,"change_date":"2026-06-18 21:41:00","inspection_id":"88178444","dot_number":"943816","report_state":"NY","report_number":"M602100220","insp_date":"2026-06-17 00:00:00","insp_start_time":"0900","insp_end_time":"0917","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3569894","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:34.000000Z","updated_at":"2026-06-29T09:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21224021,"change_date":"2026-06-18 21:41:00","inspection_id":"88178444","insp_unit_id":"214169038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"1820","insp_unit_license":"77930PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBR59J176241","insp_unit_decal":"Y","insp_unit_decal_number":"36368123","created_at":"2026-06-21T09:19:23.000000Z","updated_at":"2026-06-29T09:01:34.000000Z"}]},{"id":12175758,"change_date":"2026-06-12 21:42:00","inspection_id":"88130649","dot_number":"943816","report_state":"PA","report_number":"E919616355","insp_date":"2026-06-12 00:00:00","insp_start_time":"1240","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"UPPER ALLEN TOWNSHIP PA","county_code_state":"PA","county_code":"041","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA","shipping_paper_number":"2109934","cargo_tank":"306","hazmat_placard_req":"Y","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-06-12 21:42: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":"3533243","transaction_code":"A","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2026-06-12 21:42:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"NY","created_at":"2026-06-16T09:43:40.000000Z","updated_at":"2026-06-23T09:31:24.000000Z","inspection_violations":[{"id":21189703,"change_date":"2026-06-12 21:42:00","inspection_id":"88130649","insp_violation_id":"274881402","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":"2026-06-16T10:06:23.000000Z","updated_at":"2026-06-23T09:43:11.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":21148989,"change_date":"2026-06-12 21:42:00","inspection_id":"88130649","insp_unit_id":"214077540","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1912","insp_unit_license":"ZSP6645","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHC5DV1NHNE4948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:48.000000Z","updated_at":"2026-06-23T09:03:18.000000Z"}]},{"id":12148113,"change_date":"2026-06-10 21:44:00","inspection_id":"88096978","dot_number":"943816","report_state":"PA","report_number":"E919616138","insp_date":"2026-06-10 00:00:00","insp_start_time":"0840","insp_end_time":"0915","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SOUTH MIDDLETON TOWNSHIP PA","county_code_state":"PA","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETROLEUM","shipping_paper_number":"NONE","cargo_tank":"331","hazmat_placard_req":"Y","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-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3509131","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":"00943816","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"NY","created_at":"2026-06-13T09:41:28.000000Z","updated_at":"2026-06-21T09:31:03.000000Z","inspection_violations":[{"id":21144377,"change_date":"2026-06-10 21:44:00","inspection_id":"88096978","insp_violation_id":"274816609","seq_no":"1","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"214015442","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:39.000000Z","updated_at":"2026-06-21T09:45:26.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":21104233,"change_date":"2026-06-10 21:44:00","inspection_id":"88096978","insp_unit_id":"214015442","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1925","insp_unit_license":"AG46114","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACXDT1GHHG3555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:53.000000Z","updated_at":"2026-06-21T09:02:15.000000Z"}]},{"id":11572457,"change_date":"2026-04-06 21:37:00","inspection_id":"87496406","dot_number":"943816","report_state":"NY","report_number":"1L36000627","insp_date":"2026-03-30 00:00:00","insp_start_time":"0944","insp_end_time":"1009","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"AMSTERDAM NY","county_code_state":"NY","county_code":"057","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":"Y","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-04-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"3117142","transaction_code":"A","transaction_date":"2026-04-05 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-09T09:49:02.000000Z","updated_at":"2026-04-17T09:32:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19834244,"change_date":"2026-04-06 21:37:00","inspection_id":"87496406","insp_unit_id":"212556264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:51.000000Z","updated_at":"2026-04-18T09:14:36.000000Z"}]},{"id":11497920,"change_date":"2026-03-27 21:39:00","inspection_id":"87417889","dot_number":"943816","report_state":"NY","report_number":"M607800341","insp_date":"2026-03-27 00:00:00","insp_start_time":"0919","insp_end_time":"0934","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","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":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"3078528","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2026-03-27 21:39:00","snet_input_date":"2026-03-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-27 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:37.000000Z","updated_at":"2026-04-07T09:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19696995,"change_date":"2026-03-27 21:39:00","inspection_id":"87417889","insp_unit_id":"212376686","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"S-528","insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:19.000000Z","updated_at":"2026-04-07T09:07:42.000000Z"}]},{"id":11292856,"change_date":"2026-03-05 21:39:00","inspection_id":"87208162","dot_number":"943816","report_state":"NY","report_number":"SPG3050686","insp_date":"2026-02-26 00:00:00","insp_start_time":"0849","insp_end_time":"0933","registration_date":"2026-02-27 00:00:00","region":"ES","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2963570","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2026-03-05 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-05 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:01.000000Z","updated_at":"2026-03-16T09:30:05.000000Z","inspection_violations":[{"id":18991642,"change_date":"2026-03-05 21:39:00","inspection_id":"87208162","insp_violation_id":"272208271","seq_no":"1","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"211976854","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-08T10:08:09.000000Z","updated_at":"2026-03-16T09:39:28.000000Z","normalized_code":"39311A1LCHL"},{"id":18991643,"change_date":"2026-03-05 21:39:00","inspection_id":"87208162","insp_violation_id":"272208272","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211976854","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-08T10:08:09.000000Z","updated_at":"2026-03-16T09:39:28.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":19315299,"change_date":"2026-03-05 21:39:00","inspection_id":"87208162","insp_unit_id":"211976854","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1831","insp_unit_license":"20042PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDC97HX41532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:09.000000Z","updated_at":"2026-03-16T09:02:08.000000Z"}]},{"id":11119380,"change_date":"2026-02-12 21:40:00","inspection_id":"87032361","dot_number":"943816","report_state":"PA","report_number":"E903604226","insp_date":"2026-02-11 00:00:00","insp_start_time":"1245","insp_end_time":"1324","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"AT SR222 WEIGH STATION","county_code_state":"PA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-02-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2573985","transaction_code":"A","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2026-02-12 21:40:00","snet_input_date":"2026-02-11 00:00:00","source_office":"1PAS001","mcmis_add_date":"2026-02-12 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:48.000000Z","updated_at":"2026-02-23T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18964557,"change_date":"2026-02-12 21:40:00","inspection_id":"87032361","insp_unit_id":"211594409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1989","insp_unit_license":"AG81564","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3AKJGEFG2KDKM1370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:09.000000Z","updated_at":"2026-02-23T10:03:26.000000Z"},{"id":18964558,"change_date":"2026-02-12 21:40:00","inspection_id":"87032361","insp_unit_id":"211594410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"1993","insp_unit_license":"XDA2319","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"4J8T04328TT016703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:09.000000Z","updated_at":"2026-02-23T10:03:26.000000Z"}]},{"id":10378777,"change_date":"2025-12-08 21:39:00","inspection_id":"86508029","dot_number":"943816","report_state":"PA","report_number":"E912534272","insp_date":"2025-12-08 00:00:00","insp_start_time":"0917","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON UNNAMED STREET 0 FEET NORTH","county_code_state":"PA","county_code":"133","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATI","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"2559823","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-12-08 21:39:00","snet_input_date":"2025-12-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-12-08 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:36.000000Z","updated_at":"2025-12-12T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17349693,"change_date":"2025-12-08 21:39:00","inspection_id":"86508029","insp_unit_id":"210480517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1981","insp_unit_license":"AH51540","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3HSPCAPT2RN156919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:33.000000Z","updated_at":"2025-12-12T10:00:59.000000Z"},{"id":17349694,"change_date":"2025-12-08 21:39:00","inspection_id":"86508029","insp_unit_id":"210480518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"XDA2319","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"4J8T04328TT016703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:33.000000Z","updated_at":"2025-12-12T10:00:59.000000Z"}]},{"id":10299445,"change_date":"2025-11-27 21:33:00","inspection_id":"86425088","dot_number":"943816","report_state":"NY","report_number":"D103101353","insp_date":"2025-11-20 00:00:00","insp_start_time":"1220","insp_end_time":"1255","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"306","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-27 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"2592686","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-11-27 21:33:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-27 21:33:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-30T10:31:13.000000Z","updated_at":"2025-12-01T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17198317,"change_date":"2025-11-27 21:33:00","inspection_id":"86425088","insp_unit_id":"210290644","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"18763PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT26J314700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-30T10:01:25.000000Z","updated_at":"2025-12-01T10:00:08.000000Z"}]},{"id":10179513,"change_date":"2025-11-12 21:41:00","inspection_id":"86299303","dot_number":"943816","report_state":"PA","report_number":"E966531494","insp_date":"2025-11-10 00:00:00","insp_start_time":"1129","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":"206","location_desc":"I83 NB MM 33 NEWBERRY TWP - I8","county_code_state":"PA","county_code":"133","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LEFFLER ENERGY","shipping_paper_number":"2069199","cargo_tank":null,"hazmat_placard_req":"Y","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-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"2554400","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-10 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:49.000000Z","updated_at":"2025-11-16T10:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16954178,"change_date":"2025-11-12 21:41:00","inspection_id":"86299303","insp_unit_id":"209982437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1912","insp_unit_license":"ZSP6645","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHC5DV1NHNE4948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:41.000000Z","updated_at":"2025-11-16T10:01:26.000000Z"}]},{"id":9969056,"change_date":"2025-10-17 21:39:00","inspection_id":"86077586","dot_number":"943816","report_state":"NY","report_number":"D103500410","insp_date":"2025-10-14 00:00:00","insp_start_time":"1315","insp_end_time":"1340","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WATERVLIET NY","county_code_state":"NY","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-17 21:39: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":"2424676","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:51.000000Z","updated_at":"2025-10-21T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16553012,"change_date":"2025-10-17 21:39:00","inspection_id":"86077586","insp_unit_id":"209522763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"S522","insp_unit_license":"49413MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRNBL4GG138556","insp_unit_decal":"Y","insp_unit_decal_number":"35747917","created_at":"2025-10-20T09:47:03.000000Z","updated_at":"2025-10-21T09:45:44.000000Z"}]},{"id":9562334,"change_date":"2025-09-23 21:42:00","inspection_id":"85650565","dot_number":"943816","report_state":"NY","report_number":"D103001509","insp_date":"2025-08-27 00:00:00","insp_start_time":"1020","insp_end_time":"1046","registration_date":"2025-08-29 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"RENSSELAER NY","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"2","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":"2209273","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:58.000000Z","updated_at":"2025-09-26T10:00:13.000000Z","inspection_violations":[{"id":16019409,"change_date":"2025-09-23 21:42:00","inspection_id":"85650565","insp_violation_id":"268862224","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"209091763","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:34.000000Z","updated_at":"2025-09-27T10:15:24.000000Z","normalized_code":"3939ALFTSI"},{"id":16019410,"change_date":"2025-09-23 21:42:00","inspection_id":"85650565","insp_violation_id":"268862225","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209091763","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:34.000000Z","updated_at":"2025-09-27T10:15:24.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":16149011,"change_date":"2025-09-23 21:42:00","inspection_id":"85650565","insp_unit_id":"209091763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1815","insp_unit_license":"18763PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT26J314700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:00.000000Z","updated_at":"2025-09-27T09:45:13.000000Z"}]},{"id":9506837,"change_date":"2025-09-23 21:42:00","inspection_id":"85591855","dot_number":"943816","report_state":"NY","report_number":"M608500109","insp_date":"2025-08-26 00:00:00","insp_start_time":"0800","insp_end_time":"0845","registration_date":"2025-08-29 00:00:00","region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PETROLEUM HEAT AND POWER","shipping_paper_number":"337530","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"2","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":"2178538","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-08-26 21:40:00","snet_input_date":"2025-08-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:59.000000Z","updated_at":"2025-09-26T10:00:12.000000Z","inspection_violations":[{"id":16018919,"change_date":"2025-09-23 21:42:00","inspection_id":"85591855","insp_violation_id":"268861477","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"209091189","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:33.000000Z","updated_at":"2025-09-27T10:15:23.000000Z","normalized_code":"39383G"},{"id":16018920,"change_date":"2025-09-23 21:42:00","inspection_id":"85591855","insp_violation_id":"268861478","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209091189","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:33.000000Z","updated_at":"2025-09-27T10:15:23.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":16148745,"change_date":"2025-09-23 21:42:00","inspection_id":"85591855","insp_unit_id":"209091189","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRANSTAR","insp_unit_company":"1800","insp_unit_license":"18271PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT49J093900","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:00.000000Z","updated_at":"2025-09-27T09:45:12.000000Z"}]},{"id":9288695,"change_date":"2025-07-30 21:40:00","inspection_id":"85362624","dot_number":"943816","report_state":"PA","report_number":"L412521028","insp_date":"2025-07-29 00:00:00","insp_start_time":"0700","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"LANCASTER PIKE AT NORTHBOUND W","county_code_state":"PA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LEFFLER ENERGY","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"43120","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":"2533257","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-29 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:15.000000Z","updated_at":"2025-08-04T10:01:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15292981,"change_date":"2025-07-30 21:40:00","inspection_id":"85362624","insp_unit_id":"208160282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1908","insp_unit_license":"AH54720","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACYCY0FHGN2890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:28.000000Z","updated_at":"2025-08-03T09:45:59.000000Z"}]},{"id":8107424,"change_date":"2025-03-13 21:43:00","inspection_id":"84116789","dot_number":"943816","report_state":"MD","report_number":"2379002484","insp_date":"2025-03-13 00:00:00","insp_start_time":"1200","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":"015","location_desc":"I-83","county_code_state":"MD","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"2025582","cargo_tank":"331","hazmat_placard_req":"Y","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-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2786268","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-03-13 21:43:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1MDS001","mcmis_add_date":"2025-03-13 21:43:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:51.000000Z","updated_at":"2025-03-17T21:06:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13090133,"change_date":"2025-03-13 21:43:00","inspection_id":"84116789","insp_unit_id":"205783987","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREI","insp_unit_company":null,"insp_unit_license":"AG75742","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FUJGEBG3HLJH7602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:44.000000Z","updated_at":"2025-03-17T23:59:44.000000Z"},{"id":13090134,"change_date":"2025-03-13 21:43:00","inspection_id":"84116789","insp_unit_id":"205783988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ENDER","insp_unit_company":null,"insp_unit_license":"PT960E4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"432890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:44.000000Z","updated_at":"2025-03-17T23:59:44.000000Z"}]},{"id":8162540,"change_date":"2025-03-20 21:41:00","inspection_id":"84174688","dot_number":"943816","report_state":"NY","report_number":"1L43000363","insp_date":"2025-03-13 00:00:00","insp_start_time":"1105","insp_end_time":"1148","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","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":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-20 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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1491149","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-03-20 21:41:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-20 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:44:03.000000Z","updated_at":"2025-03-24T10:23:42.000000Z","inspection_violations":[{"id":12783297,"change_date":"2025-03-20 21:41:00","inspection_id":"84174688","insp_violation_id":"265142783","seq_no":"1","part_no":"393","part_no_section":"95A3","insp_viol_unit":"1","insp_unit_id":"205892666","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0302K45JFG","created_at":"2025-03-22T10:59:54.000000Z","updated_at":"2025-03-23T11:26:47.000000Z","normalized_code":"39395A3"},{"id":12783298,"change_date":"2025-03-20 21:41:00","inspection_id":"84174688","insp_violation_id":"265142784","seq_no":"2","part_no":"172","part_no_section":"519B4-HMPMC","insp_viol_unit":"1","insp_unit_id":"205892666","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0302K45JW0","created_at":"2025-03-22T10:59:54.000000Z","updated_at":"2025-03-23T11:26:47.000000Z","normalized_code":"172519B4HMPMC"}],"inspection_per_units":[{"id":13189646,"change_date":"2025-03-20 21:41:00","inspection_id":"84174688","insp_unit_id":"205892666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"90225NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRNBLXHG727693","insp_unit_decal":"Y","insp_unit_decal_number":"34943933","created_at":"2025-03-23T10:08:37.000000Z","updated_at":"2025-03-24T09:52:22.000000Z"}]},{"id":8093486,"change_date":"2025-03-12 21:40:00","inspection_id":"84102090","dot_number":"943816","report_state":"NY","report_number":"M607900084","insp_date":"2025-03-12 00:00:00","insp_start_time":"1033","insp_end_time":"1117","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","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":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"1461480","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:18.000000Z","updated_at":"2025-03-17T21:06:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13067618,"change_date":"2025-03-12 21:40:00","inspection_id":"84102090","insp_unit_id":"205754029","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:27.000000Z","updated_at":"2025-03-17T23:59:27.000000Z"}]},{"id":8150262,"change_date":"2025-03-19 21:40:00","inspection_id":"84161888","dot_number":"943816","report_state":"NY","report_number":"SPG3040393","insp_date":"2025-03-12 00:00:00","insp_start_time":"1323","insp_end_time":"1328","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1488059","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-03-19 21:40:00","snet_input_date":"2025-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-19 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:28:37.000000Z","updated_at":"2025-03-23T10:41:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13165904,"change_date":"2025-03-19 21:40:00","inspection_id":"84161888","insp_unit_id":"205868983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"18762PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN15H106782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:00:05.000000Z","updated_at":"2025-03-23T09:53:05.000000Z"}]},{"id":8131352,"change_date":"2025-03-17 21:40:00","inspection_id":"84142034","dot_number":"943816","report_state":"NY","report_number":"SPK3030185","insp_date":"2025-03-10 00:00:00","insp_start_time":"0906","insp_end_time":"0921","registration_date":null,"region":"ED","ci_status_code":"C","location":"80577","location_desc":"NEW LEBANON NY","county_code_state":"NY","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-17 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":"1479642","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-03-17 21:40:00","snet_input_date":"2025-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:18:07.000000Z","updated_at":"2025-03-21T10:18:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13131157,"change_date":"2025-03-17 21:40:00","inspection_id":"84142034","insp_unit_id":"205830389","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"77279PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC5DV6KHKR1156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:51:59.000000Z","updated_at":"2025-03-21T10:00:28.000000Z"}]},{"id":7903661,"change_date":"2025-02-19 21:40:00","inspection_id":"83902744","dot_number":"943816","report_state":"NY","report_number":"D102600821","insp_date":"2025-02-18 00:00:00","insp_start_time":"1325","insp_end_time":"1405","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HALFMOON NY","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1377280","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:20.000000Z","updated_at":"2025-03-17T21:02:20.000000Z","inspection_violations":[{"id":12351326,"change_date":"2025-02-19 21:40:00","inspection_id":"83902744","insp_violation_id":"264584286","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205388865","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":12757974,"change_date":"2025-02-19 21:40:00","inspection_id":"83902744","insp_unit_id":"205388865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"EAGLE INTE","insp_unit_company":null,"insp_unit_license":"20046PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSJT5AJ286286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"}]},{"id":7812075,"change_date":"2025-02-07 21:40:00","inspection_id":"83806635","dot_number":"943816","report_state":"NY","report_number":"D102600803","insp_date":"2025-02-05 00:00:00","insp_start_time":"1036","insp_end_time":"1130","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LATHAM NY","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62555","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1336853","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:21.000000Z","updated_at":"2025-03-17T21:00:21.000000Z","inspection_violations":[{"id":12208992,"change_date":"2025-02-07 21:40:00","inspection_id":"83806635","insp_violation_id":"264395664","seq_no":"1","part_no":"177","part_no_section":"801-LEAK","insp_viol_unit":"1","insp_unit_id":"205209187","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":"0CT2K0BBQ5","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"177801LEAK"}],"inspection_per_units":[{"id":12607500,"change_date":"2025-02-07 21:40:00","inspection_id":"83806635","insp_unit_id":"205209187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"72937PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC5DV4FHGM1084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:16.000000Z","updated_at":"2025-03-17T23:54:16.000000Z"}]},{"id":7799665,"change_date":"2025-02-06 21:40:00","inspection_id":"83793531","dot_number":"943816","report_state":"NY","report_number":"SPG3060218","insp_date":"2025-01-30 00:00:00","insp_start_time":"1726","insp_end_time":"1800","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LATHAM NY","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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":"U","pen_cen_match":"I","final_status_date":"2025-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"1329645","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-02-06 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-06 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:58.000000Z","updated_at":"2025-03-17T20:59:58.000000Z","inspection_violations":[{"id":12188685,"change_date":"2025-02-06 21:40:00","inspection_id":"83793531","insp_violation_id":"264367192","seq_no":"1","part_no":"392","part_no_section":"82DUMT","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:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"39282DUMT"},{"id":12188686,"change_date":"2025-02-06 21:40:00","inspection_id":"83793531","insp_violation_id":"264367193","seq_no":"2","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"205183545","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8G82JZPZ8V","created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":12587079,"change_date":"2025-02-06 21:40:00","inspection_id":"83793531","insp_unit_id":"205183545","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1834","insp_unit_license":"72934PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXFC8JDJW2610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:03.000000Z","updated_at":"2025-03-17T23:54:03.000000Z"}]},{"id":7556837,"change_date":"2025-01-06 21:39:00","inspection_id":"83538423","dot_number":"943816","report_state":"PA","report_number":"XL00064648","insp_date":"2025-01-03 00:00:00","insp_start_time":"0953","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"BLANDON RD MEASURING 42 FEET W","county_code_state":"PA","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43120","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":"2488373","transaction_code":"A","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-03 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANS INC DBA JOHN R LEFFLER","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:56.000000Z","updated_at":"2025-03-17T20:54:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12192998,"change_date":"2025-01-06 21:39:00","inspection_id":"83538423","insp_unit_id":"204668306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1901","insp_unit_license":"ZGB6282","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACYCYXEHFW4315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:36.000000Z","updated_at":"2025-03-17T23:49:36.000000Z"}]},{"id":7494623,"change_date":"2024-12-24 21:35:00","inspection_id":"83473185","dot_number":"943816","report_state":"PA","report_number":"E946435861","insp_date":"2024-12-23 00:00:00","insp_start_time":"1100","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"215","location_desc":"SR4019 AND SR997 GREENE TWP -","county_code_state":"PA","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PATRIOT","shipping_paper_number":"12-23-24","cargo_tank":"331","hazmat_placard_req":"Y","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-12-24 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2486857","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-12-24 21:35:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-12-24 21:35:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:21.000000Z","updated_at":"2025-03-17T20:52:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12090750,"change_date":"2024-12-24 21:35:00","inspection_id":"83473185","insp_unit_id":"204545285","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1925","insp_unit_license":"AG46114","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACXDT1GHHG3555","insp_unit_decal":"Y","insp_unit_decal_number":"03456490","created_at":"2025-03-17T23:48:31.000000Z","updated_at":"2025-03-17T23:48:31.000000Z"}]},{"id":7473527,"change_date":"2024-12-20 21:40:00","inspection_id":"83450952","dot_number":"943816","report_state":"PA","report_number":"E958435531","insp_date":"2024-12-20 00:00:00","insp_start_time":"0645","insp_end_time":"0730","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"SR222NB AT COUNTY LINE WEIGH S","county_code_state":"PA","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION I","shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","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-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2486423","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-12-20 21:40:00","snet_input_date":"2024-12-20 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:58.000000Z","updated_at":"2025-03-17T20:51:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12056985,"change_date":"2024-12-20 21:40:00","inspection_id":"83450952","insp_unit_id":"204506114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1974","insp_unit_license":"ZVA7185","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FV6HJAA3TL701462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"}]},{"id":7198661,"change_date":"2024-11-15 21:42:00","inspection_id":"83161359","dot_number":"943816","report_state":"PA","report_number":"M236000046","insp_date":"2024-11-13 00:00:00","insp_start_time":"1049","insp_end_time":"1155","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LEBANON PA","county_code_state":"PA","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM","shipping_paper_number":"3986235","cargo_tank":"306","hazmat_placard_req":"Y","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":"2024-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1055130","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-11-15 21:42:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-15 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:04.000000Z","updated_at":"2025-03-17T20:46:04.000000Z","inspection_violations":[{"id":11249605,"change_date":"2024-11-15 21:42:00","inspection_id":"83161359","insp_violation_id":"262906245","seq_no":"1","part_no":"173","part_no_section":"24B1-HMBPMC","insp_viol_unit":"1","insp_unit_id":"203890544","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"E1001948-3","created_at":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"17324B1HMBPMC"}],"inspection_per_units":[{"id":11611397,"change_date":"2024-11-15 21:42:00","inspection_id":"83161359","insp_unit_id":"203890544","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1912","insp_unit_license":"ZSP6645","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVHC5DV1NHNE4948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:20.000000Z","updated_at":"2025-03-17T23:43:20.000000Z"}]},{"id":7129199,"change_date":"2024-11-06 21:39:00","inspection_id":"83087839","dot_number":"943816","report_state":"NY","report_number":"SPG3010156","insp_date":"2024-10-30 00:00:00","insp_start_time":"1552","insp_end_time":"1621","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN RAY AND SONS","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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":"2024-11-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32996","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1024297","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-11-06 21:39:00","snet_input_date":"2024-10-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-06 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:40.000000Z","updated_at":"2025-03-17T20:44:40.000000Z","inspection_violations":[{"id":11136166,"change_date":"2024-11-06 21:39:00","inspection_id":"83087839","insp_violation_id":"262747563","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"203751969","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"3939ALTSI"},{"id":11136167,"change_date":"2024-11-06 21:39:00","inspection_id":"83087839","insp_violation_id":"262747564","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"203751969","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39345DB"},{"id":11136168,"change_date":"2024-11-06 21:39:00","inspection_id":"83087839","insp_violation_id":"262747565","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203751969","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":11498558,"change_date":"2024-11-06 21:39:00","inspection_id":"83087839","insp_unit_id":"203751969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1834","insp_unit_license":"72934PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXFC8JDJW2610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"}]},{"id":7101385,"change_date":"2024-11-01 21:39:00","inspection_id":"83058391","dot_number":"943816","report_state":"NY","report_number":"M602100084","insp_date":"2024-10-28 00:00:00","insp_start_time":"0925","insp_end_time":"0942","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","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":"Y","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":"2024-11-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1010712","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-11-01 21:39:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-01 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:14.000000Z","updated_at":"2025-03-17T20:44:14.000000Z","inspection_violations":[{"id":11088122,"change_date":"2024-11-01 21:39:00","inspection_id":"83058391","insp_violation_id":"262681411","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203696625","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":11453337,"change_date":"2024-11-01 21:39:00","inspection_id":"83058391","insp_unit_id":"203696625","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"S-528","insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"Y","insp_unit_decal_number":"34638929","created_at":"2025-03-17T23:41:36.000000Z","updated_at":"2025-03-17T23:41:36.000000Z"}]},{"id":6907887,"change_date":"2024-10-08 21:41:00","inspection_id":"82852876","dot_number":"943816","report_state":"NY","report_number":"M607200138","insp_date":"2024-10-07 00:00:00","insp_start_time":"1150","insp_end_time":"1222","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GLOBAL","shipping_paper_number":"1648101","cargo_tank":"406","hazmat_placard_req":"Y","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":"2024-10-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"922234","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-10-08 21:41:00","snet_input_date":"2024-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:13.000000Z","updated_at":"2025-03-17T20:40:13.000000Z","inspection_violations":[{"id":10763954,"change_date":"2024-10-08 21:41:00","inspection_id":"82852876","insp_violation_id":"262233372","seq_no":"1","part_no":"173","part_no_section":"24(b)(1)","insp_viol_unit":"1","insp_unit_id":"203308054","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"17324B1"},{"id":10763955,"change_date":"2024-10-08 21:41:00","inspection_id":"82852876","insp_violation_id":"262233373","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203308054","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11140845,"change_date":"2024-10-08 21:41:00","inspection_id":"82852876","insp_unit_id":"203308054","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1813","insp_unit_license":"29901PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMKAAN23H590867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"}]},{"id":6846362,"change_date":"2024-09-30 21:40:00","inspection_id":"82787483","dot_number":"943816","report_state":"NY","report_number":"SPG3040036","insp_date":"2024-09-23 00:00:00","insp_start_time":"1025","insp_end_time":"1040","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"896881","transaction_code":"A","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-09-30 21:40:00","snet_input_date":"2024-09-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-30 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:59.000000Z","updated_at":"2025-03-17T20:38:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11040945,"change_date":"2024-09-30 21:40:00","inspection_id":"82787483","insp_unit_id":"203182152","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"20044PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWCADR25J038351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:21.000000Z","updated_at":"2025-03-17T23:37:21.000000Z"}]},{"id":6752717,"change_date":"2024-09-18 21:41:00","inspection_id":"82687537","dot_number":"943816","report_state":"NY","report_number":"SPG3050026","insp_date":"2024-09-11 00:00:00","insp_start_time":"1106","insp_end_time":"1122","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","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":"U","pen_cen_match":"I","final_status_date":"2024-09-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"857078","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-09-18 21:41:00","snet_input_date":"2024-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-18 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:57.000000Z","updated_at":"2025-03-17T20:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10888798,"change_date":"2024-09-18 21:41:00","inspection_id":"82687537","insp_unit_id":"202995266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1831","insp_unit_license":"20042PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDC97HX41532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:46.000000Z","updated_at":"2025-03-17T23:35:46.000000Z"}]},{"id":6317115,"change_date":"2024-07-26 21:38:00","inspection_id":"82223124","dot_number":"943816","report_state":"NY","report_number":"D102600452","insp_date":"2024-07-25 00:00:00","insp_start_time":"0744","insp_end_time":"0817","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WATERVLIET NY","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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":"2024-07-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"687961","transaction_code":"A","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-07-26 21:38:00","snet_input_date":"2024-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-26 21:38:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10178786,"change_date":"2024-07-26 21:38:00","inspection_id":"82223124","insp_unit_id":"202085188","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"EAGLE INTE","insp_unit_company":null,"insp_unit_license":"25436PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGSSJT7DJ298904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"}]},{"id":6271442,"change_date":"2024-07-22 21:41:00","inspection_id":"82174414","dot_number":"943816","report_state":"NY","report_number":"SPG0215863","insp_date":"2024-07-16 00:00:00","insp_start_time":"0820","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"2938855","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2024-07-22 21:41:00","snet_input_date":"2024-07-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-22 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:01.000000Z","updated_at":"2025-03-17T20:27:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10104488,"change_date":"2024-07-22 21:41:00","inspection_id":"82174414","insp_unit_id":"201992367","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1820","insp_unit_license":"77930PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBR59J176241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:41.000000Z","updated_at":"2025-03-17T23:27:41.000000Z"}]},{"id":5717868,"change_date":"2024-05-10 21:38:00","inspection_id":"81576183","dot_number":"943816","report_state":"NY","report_number":"SPG0215677","insp_date":"2024-05-02 00:00:00","insp_start_time":"0735","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PETROLEUM HEAT","shipping_paper_number":"6709432","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"62556","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":"2922716","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2024-05-10 21:38:00","snet_input_date":"2024-05-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-10 21:38:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:56.000000Z","updated_at":"2025-03-17T20:15:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9209424,"change_date":"2024-05-10 21:38:00","inspection_id":"81576183","insp_unit_id":"200828378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1832","insp_unit_license":"72937PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC5DV4FHGM1084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:41.000000Z","updated_at":"2025-03-17T23:18:41.000000Z"}]},{"id":5654150,"change_date":"2024-05-02 21:42:00","inspection_id":"81506938","dot_number":"943816","report_state":"NY","report_number":"SPD0272220","insp_date":"2024-05-01 00:00:00","insp_start_time":"1452","insp_end_time":"1508","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"2921330","transaction_code":"A","transaction_date":"2024-05-02 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2024-05-02 21:42:00","snet_input_date":"2024-05-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-02 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:44.000000Z","updated_at":"2025-03-17T20:14:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9106844,"change_date":"2024-05-02 21:42:00","inspection_id":"81506938","insp_unit_id":"200694317","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"S-528","insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:45.000000Z","updated_at":"2025-03-17T23:17:45.000000Z"}]},{"id":5675314,"change_date":"2024-05-06 21:43:00","inspection_id":"81530033","dot_number":"943816","report_state":"NY","report_number":"SPG0261403","insp_date":"2024-04-30 00:00:00","insp_start_time":"1444","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753A","location_desc":"SCHODACK (WB)","county_code_state":"NY","county_code":"083","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"2922085","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2024-05-06 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-06 21:43:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:07.000000Z","updated_at":"2025-03-17T20:15:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9140859,"change_date":"2024-05-06 21:43:00","inspection_id":"81530033","insp_unit_id":"200738911","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"251803","insp_unit_license":"19131PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHLJ9XXNM474045","insp_unit_decal":"Y","insp_unit_decal_number":"34017813","created_at":"2025-03-17T23:18:04.000000Z","updated_at":"2025-03-17T23:18:04.000000Z"}]},{"id":5397105,"change_date":"2024-03-29 21:38:00","inspection_id":"81226287","dot_number":"943816","report_state":"NY","report_number":"SPG0206779","insp_date":"2024-03-28 00:00:00","insp_start_time":"1248","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697B","location_desc":"QUEENSBURY (SB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"2913857","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:30.000000Z","updated_at":"2025-03-17T20:09:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8692375,"change_date":"2024-03-29 21:38:00","inspection_id":"81226287","insp_unit_id":"200151353","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"S-528","insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:51.000000Z","updated_at":"2025-03-17T23:13:51.000000Z"}]},{"id":5188134,"change_date":"2024-03-01 21:39:00","inspection_id":"80998380","dot_number":"943816","report_state":"NY","report_number":"SPG0206715","insp_date":"2024-02-22 00:00:00","insp_start_time":"0845","insp_end_time":"0926","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2909764","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-03-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","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":[{"id":7995755,"change_date":"2024-03-01 21:39:00","inspection_id":"80998380","insp_violation_id":"258150004","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199707272","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8353593,"change_date":"2024-03-01 21:39:00","inspection_id":"80998380","insp_unit_id":"199707272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"S522","insp_unit_license":"49413MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRNBL4GG138556","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":4669407,"change_date":"2023-12-20 21:41:00","inspection_id":"80431971","dot_number":"943816","report_state":"NY","report_number":"D103100092","insp_date":"2023-12-20 00:00:00","insp_start_time":"0917","insp_end_time":"0950","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","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":"Y","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":"2023-12-20 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":"138408","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2023-12-20 21:41:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-20 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:23.000000Z","updated_at":"2025-03-17T19:55:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7510177,"change_date":"2023-12-20 21:41:00","inspection_id":"80431971","insp_unit_id":"198587947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"49413MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRNBL4GG138556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:09.000000Z","updated_at":"2025-03-17T23:03:09.000000Z"}]},{"id":4628325,"change_date":"2023-12-14 21:42:00","inspection_id":"80386920","dot_number":"943816","report_state":"NY","report_number":"SPWG050890","insp_date":"2023-12-13 00:00:00","insp_start_time":"1036","insp_end_time":"1052","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174","location_desc":"CLIFTON PARK","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","shipping_paper_number":"8130126","cargo_tank":null,"hazmat_placard_req":"Y","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-12-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2893293","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-12-14 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-14 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:33.000000Z","updated_at":"2025-03-17T19:54:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7444009,"change_date":"2023-12-14 21:42:00","inspection_id":"80386920","insp_unit_id":"198501417","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1825","insp_unit_license":"77929PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGSSJR8CJ583551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:34.000000Z","updated_at":"2025-03-17T23:02:34.000000Z"}]},{"id":4591483,"change_date":"2023-12-08 21:41:00","inspection_id":"80346548","dot_number":"943816","report_state":"PA","report_number":"J610334141","insp_date":"2023-12-07 00:00:00","insp_start_time":"0638","insp_end_time":"0744","registration_date":null,"region":"ET","ci_status_code":"C","location":"206","location_desc":"I83 NB MM 33 NEWBERRY TWP - I8","county_code_state":"PA","county_code":"133","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2404096","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-12-07 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:48.000000Z","updated_at":"2025-03-17T19:53:48.000000Z","inspection_violations":[{"id":7100949,"change_date":"2023-12-08 21:41:00","inspection_id":"80346548","insp_violation_id":"256795975","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198424294","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7384954,"change_date":"2023-12-08 21:41:00","inspection_id":"80346548","insp_unit_id":"198424294","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1981","insp_unit_license":"727167","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3HSPCAPT2RN156919","insp_unit_decal":"Y","insp_unit_decal_number":"03332955","created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"},{"id":7384955,"change_date":"2023-12-08 21:41:00","inspection_id":"80346548","insp_unit_id":"198424295","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"1993","insp_unit_license":"XDA2319","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"4J8T04328TT016703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"}]},{"id":4434697,"change_date":"2023-11-15 21:42:00","inspection_id":"80174156","dot_number":"943816","report_state":"PA","report_number":"J610331881","insp_date":"2023-11-14 00:00:00","insp_start_time":"0703","insp_end_time":"0726","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON US30 E AT LITITZ PIKE","county_code_state":"PA","county_code":"071","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2397238","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2023-11-15 21:42:00","snet_input_date":"2023-11-14 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-15 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:44.000000Z","updated_at":"2025-03-17T19:50:44.000000Z","inspection_violations":[{"id":6863505,"change_date":"2023-11-15 21:42:00","inspection_id":"80174156","insp_violation_id":"256418551","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:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7131803,"change_date":"2023-11-15 21:42:00","inspection_id":"80174156","insp_unit_id":"198080857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1915","insp_unit_license":"AH17922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3ALHG3FM5NDNL9209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"}]},{"id":4343649,"change_date":"2023-11-02 21:42:00","inspection_id":"80073417","dot_number":"943816","report_state":"PA","report_number":"M236003247","insp_date":"2023-11-01 00:00:00","insp_start_time":"1335","insp_end_time":"1357","registration_date":null,"region":"ET","ci_status_code":"C","location":"038","location_desc":"STEEL STREET AT COLEMANS PARK","county_code_state":"PA","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION LLC","shipping_paper_number":"TG#83432","cargo_tank":"406","hazmat_placard_req":"Y","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":"Y","pen_cen_match":"I","final_status_date":"2023-11-02 21:42: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":"2393834","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-11-02 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:05.000000Z","updated_at":"2025-03-17T19:49:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6985961,"change_date":"2023-11-02 21:42:00","inspection_id":"80073417","insp_unit_id":"197883970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1915","insp_unit_license":"AH17922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3ALHG3FM5NDNL9209","insp_unit_decal":"Y","insp_unit_decal_number":"33364450","created_at":"2025-03-17T22:58:39.000000Z","updated_at":"2025-03-17T22:58:39.000000Z"}]},{"id":4180254,"change_date":"2023-10-12 21:41:00","inspection_id":"79892717","dot_number":"943816","report_state":"NY","report_number":"SPG0174217","insp_date":"2023-10-11 00:00:00","insp_start_time":"0956","insp_end_time":"1021","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2877899","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:48.000000Z","updated_at":"2025-03-17T19:45:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6722147,"change_date":"2023-10-12 21:41:00","inspection_id":"79892717","insp_unit_id":"197515998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1800","insp_unit_license":"18271PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT49J093900","insp_unit_decal":"Y","insp_unit_decal_number":"33401473","created_at":"2025-03-17T22:56:22.000000Z","updated_at":"2025-03-17T22:56:22.000000Z"}]},{"id":4110730,"change_date":"2023-10-03 21:40:00","inspection_id":"79815941","dot_number":"943816","report_state":"NY","report_number":"1L39000141","insp_date":"2023-09-29 00:00:00","insp_start_time":"1210","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"10331","location_desc":"GLENRIDGE ROAD","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SPRAGUE OPERATING RESOURCES","shipping_paper_number":"305098","cargo_tank":"406","hazmat_placard_req":"Y","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":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2874562","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[{"id":6360983,"change_date":"2023-10-03 21:40:00","inspection_id":"79815941","insp_violation_id":"255617263","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197362711","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6609344,"change_date":"2023-10-03 21:40:00","inspection_id":"79815941","insp_unit_id":"197362711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1830","insp_unit_license":"77931PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGSSJT0DJ304400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":4110731,"change_date":"2023-10-03 21:40:00","inspection_id":"79815942","dot_number":"943816","report_state":"NY","report_number":"1L39000142","insp_date":"2023-09-29 00:00:00","insp_start_time":"1310","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"10331","location_desc":"GLENRIDGE ROAD","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"JOHN RAY AND SONS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"2874621","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[{"id":6360984,"change_date":"2023-10-03 21:40:00","inspection_id":"79815942","insp_violation_id":"255617264","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197362712","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4195H7JL9Z","created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6609345,"change_date":"2023-10-03 21:40:00","inspection_id":"79815942","insp_unit_id":"197362712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"S 528","insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":4110784,"change_date":"2023-10-03 21:40:00","inspection_id":"79815998","dot_number":"943816","report_state":"NY","report_number":"SPG0206331","insp_date":"2023-09-26 00:00:00","insp_start_time":"0930","insp_end_time":"0952","registration_date":null,"region":"ET","ci_status_code":"C","location":"10424","location_desc":"JACKSON FISHING P LOT","county_code_state":"NY","county_code":"115","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY AND SONS","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2874288","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6609412,"change_date":"2023-10-03 21:40:00","inspection_id":"79815998","insp_unit_id":"197362793","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1834","insp_unit_license":"72934PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXFC8JDJW2610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3549432,"change_date":"2023-09-07 21:41:00","inspection_id":"79189615","dot_number":"943816","report_state":"PA","report_number":"E915319940","insp_date":"2023-07-18 00:00:00","insp_start_time":"0935","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"I81 N 64.3","county_code_state":"PA","county_code":"041","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LEFFLER ENERGY","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-07-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2365907","transaction_code":"C","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2023-07-19 21:44:00","snet_input_date":"2023-07-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-07-19 21:44:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:09.000000Z","updated_at":"2025-03-17T19:33:09.000000Z","inspection_violations":[{"id":5471948,"change_date":"2023-09-07 21:41:00","inspection_id":"79189615","insp_violation_id":"255145129","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:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3922"},{"id":5471949,"change_date":"2023-09-07 21:41:00","inspection_id":"79189615","insp_violation_id":"255145130","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196952558","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5707395,"change_date":"2023-09-07 21:41:00","inspection_id":"79189615","insp_unit_id":"196952558","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1908","insp_unit_license":"AG38448","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACYCY0FHGN2890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:02.000000Z","updated_at":"2025-03-17T22:48:02.000000Z"}]},{"id":2473570,"change_date":"2023-03-01 21:41:00","inspection_id":"77972586","dot_number":"943816","report_state":"NY","report_number":"0122002788","insp_date":"2023-02-27 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"10208","location_desc":"COXSACKIE","county_code_state":"NY","county_code":"039","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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":"2023-03-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2803070","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-03-01 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:09.000000Z","updated_at":"2025-03-17T19:12:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3980780,"change_date":"2023-03-01 21:41:00","inspection_id":"77972586","insp_unit_id":"193633787","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1824","insp_unit_license":"20043PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGSSJRXCJ583552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:31.000000Z","updated_at":"2025-03-17T22:34:31.000000Z"}]},{"id":2364227,"change_date":"2023-02-14 21:40:00","inspection_id":"77847913","dot_number":"943816","report_state":"MD","report_number":"2512005250","insp_date":"2023-02-13 00:00:00","insp_start_time":"1032","insp_end_time":"1052","registration_date":null,"region":"ET","ci_status_code":"C","location":"015","location_desc":"I-83","county_code_state":"MD","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AMERIGAS","shipping_paper_number":"2015169","cargo_tank":"331","hazmat_placard_req":"Y","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-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2609327","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2023-02-14 21:40:00","snet_input_date":"2023-02-13 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-02-14 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:18.000000Z","updated_at":"2025-03-17T19:10:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3804789,"change_date":"2023-02-14 21:40:00","inspection_id":"77847913","insp_unit_id":"193382504","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREI","insp_unit_company":"1988","insp_unit_license":"AG75742","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FUJGEBG3HLJH7602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"},{"id":3804790,"change_date":"2023-02-14 21:40:00","inspection_id":"77847913","insp_unit_id":"193382505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":null,"insp_unit_license":"PT960E4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"432890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"}]},{"id":2250675,"change_date":"2023-01-30 21:43:00","inspection_id":"77718869","dot_number":"943816","report_state":"NY","report_number":"SPG0250950","insp_date":"2023-01-26 00:00:00","insp_start_time":"0810","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY AND SONS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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":"54000","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":"2792813","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":"00943816","upload_search_indicator":"M","census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","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":[],"inspection_per_units":[{"id":3622292,"change_date":"2023-01-30 21:43:00","inspection_id":"77718869","insp_unit_id":"193118131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1824","insp_unit_license":"20043PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGSSJRXCJ583552","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":2232509,"change_date":"2023-01-26 21:41:00","inspection_id":"77698075","dot_number":"943816","report_state":"NY","report_number":"1L38000088","insp_date":"2023-01-25 00:00:00","insp_start_time":"1006","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"12053","location_desc":"SCHENECTADY COMMUNITY COLLEGE","county_code_state":"NY","county_code":"093","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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":"2023-01-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2792463","transaction_code":"A","transaction_date":"2023-01-26 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-01-26 21:41:00","snet_input_date":"2023-01-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-26 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:45.000000Z","updated_at":"2025-03-17T19:07:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3593268,"change_date":"2023-01-26 21:41:00","inspection_id":"77698075","insp_unit_id":"193077327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"77279PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC5DV6KHKR1156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:45.000000Z","updated_at":"2025-03-17T22:31:45.000000Z"}]},{"id":2125280,"change_date":"2023-01-12 21:41:00","inspection_id":"77575040","dot_number":"943816","report_state":"NY","report_number":"1L38000082","insp_date":"2023-01-11 00:00:00","insp_start_time":"1042","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":"10331","location_desc":"1 MAALWYCK PARK","county_code_state":"NY","county_code":"093","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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":"2023-01-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2788358","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2023-01-12 21:41:00","snet_input_date":"2023-01-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-12 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:51.000000Z","updated_at":"2025-03-17T19:05:51.000000Z","inspection_violations":[{"id":3287543,"change_date":"2023-01-12 21:41:00","inspection_id":"77575040","insp_violation_id":"250526433","seq_no":"1","part_no":"180","part_no_section":"407(a)","insp_viol_unit":"1","insp_unit_id":"192830743","insp_violation_category_id":"35","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:34.000000Z","updated_at":"2025-03-17T21:22:34.000000Z","normalized_code":"180407A"}],"inspection_per_units":[{"id":3420210,"change_date":"2023-01-12 21:41:00","inspection_id":"77575040","insp_unit_id":"192830743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"77279PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC5DV6KHKR1156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:32.000000Z","updated_at":"2025-03-17T22:30:32.000000Z"}]},{"id":1963760,"change_date":"2022-12-16 21:40:00","inspection_id":"77390842","dot_number":"943816","report_state":"PA","report_number":"M276100070","insp_date":"2022-12-14 00:00:00","insp_start_time":"1345","insp_end_time":"1358","registration_date":null,"region":"ET","ci_status_code":"C","location":"36101","location_desc":"YORK RD AT RT 501","county_code_state":"PA","county_code":"071","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSP","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-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2308128","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-12-16 21:40:00","snet_input_date":"2022-12-14 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:55.000000Z","updated_at":"2025-03-17T19:02:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3159841,"change_date":"2022-12-16 21:40:00","inspection_id":"77390842","insp_unit_id":"192466200","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1953","insp_unit_license":"YFV2060","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1NKDLS9X8VJ737466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:37.000000Z","updated_at":"2025-03-17T22:28:37.000000Z"}]},{"id":1882529,"change_date":"2022-12-06 21:40:00","inspection_id":"77297790","dot_number":"943816","report_state":"PA","report_number":"H228233335","insp_date":"2022-11-29 00:00:00","insp_start_time":"0915","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"OTTO AVE MEASURING 158 FEET NO","county_code_state":"PA","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PATRIOT PROPANE","shipping_paper_number":"MULTIPLE","cargo_tank":"331","hazmat_placard_req":"Y","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-12-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2304315","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-12-06 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-12-06 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:27.000000Z","updated_at":"2025-03-17T19:01:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3030000,"change_date":"2022-12-06 21:40:00","inspection_id":"77297790","insp_unit_id":"192286120","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1925","insp_unit_license":"AG46114","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACXDT1GHHG3555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:44.000000Z","updated_at":"2025-03-17T22:27:44.000000Z"}]},{"id":1773540,"change_date":"2022-11-18 21:39:00","inspection_id":"77172859","dot_number":"943816","report_state":"PA","report_number":"M127100558","insp_date":"2022-11-17 00:00:00","insp_start_time":"0847","insp_end_time":"0929","registration_date":null,"region":"ET","ci_status_code":"C","location":"21404","location_desc":"5 PLEASANTVIEW DR","county_code_state":"PA","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION","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":"Y","pen_cen_match":"I","final_status_date":"2022-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2301661","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-11-18 21:39:00","snet_input_date":"2022-11-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-11-18 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:19.000000Z","updated_at":"2025-03-17T18:59:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2853464,"change_date":"2022-11-18 21:39:00","inspection_id":"77172859","insp_unit_id":"192035265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1202","insp_unit_license":"ZLP5011","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1HTMMAAN55H121043","insp_unit_decal":"Y","insp_unit_decal_number":"31977066","created_at":"2025-03-17T22:26:31.000000Z","updated_at":"2025-03-17T22:26:31.000000Z"}]},{"id":1774275,"change_date":"2022-11-18 21:39:00","inspection_id":"77173736","dot_number":"943816","report_state":"PA","report_number":"E947232028","insp_date":"2022-11-16 00:00:00","insp_start_time":"1430","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"207","location_desc":"I83 SB MM 34.1 NEWBERRY TWP -","county_code_state":"PA","county_code":"133","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LEFFLER ENERGY","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-18 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":"2301295","transaction_code":"A","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-11-18 21:39:00","snet_input_date":"2022-11-16 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-11-18 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:19.000000Z","updated_at":"2025-03-17T18:59:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2854498,"change_date":"2022-11-18 21:39:00","inspection_id":"77173736","insp_unit_id":"192036995","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1987","insp_unit_license":"AE70653","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1XKDDR9X9TS721974","insp_unit_decal":"Y","insp_unit_decal_number":"31975581","created_at":"2025-03-17T22:26:31.000000Z","updated_at":"2025-03-17T22:26:31.000000Z"}]},{"id":1664664,"change_date":"2022-11-03 21:41:00","inspection_id":"77047837","dot_number":"943816","report_state":"NY","report_number":"0117009654","insp_date":"2022-11-02 00:00:00","insp_start_time":"0847","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"12060","location_desc":"WATERVLIET ARSENAL","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2765894","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-11-03 21:41:00","snet_input_date":"2022-11-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-03 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:24.000000Z","updated_at":"2025-03-17T18:57:24.000000Z","inspection_violations":[{"id":2611180,"change_date":"2022-11-03 21:41:00","inspection_id":"77047837","insp_violation_id":"249412798","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"191786902","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":2677963,"change_date":"2022-11-03 21:41:00","inspection_id":"77047837","insp_unit_id":"191786902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":null,"insp_unit_license":"59865MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRNBL1GG220180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:21.000000Z","updated_at":"2025-03-17T22:25:21.000000Z"}]},{"id":1655257,"change_date":"2022-11-02 21:39:00","inspection_id":"77037050","dot_number":"943816","report_state":"NY","report_number":"SPT0376351","insp_date":"2022-11-01 00:00:00","insp_start_time":"1050","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","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":"Y","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"3","hazmat_oos_total":"3","snet_sequence_id":"2765417","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-11-02 21:39:00","snet_input_date":"2022-11-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-02 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:05.000000Z","updated_at":"2025-03-17T18:57:05.000000Z","inspection_violations":[{"id":2596715,"change_date":"2022-11-02 21:39:00","inspection_id":"77037050","insp_violation_id":"249387232","seq_no":"1","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"191765217","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"177817A"},{"id":2596716,"change_date":"2022-11-02 21:39:00","inspection_id":"77037050","insp_violation_id":"249387233","seq_no":"2","part_no":"172","part_no_section":"502(a)(1)","insp_viol_unit":"1","insp_unit_id":"191765217","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"172502A1"},{"id":2596717,"change_date":"2022-11-02 21:39:00","inspection_id":"77037050","insp_violation_id":"249387234","seq_no":"3","part_no":"172","part_no_section":"303(a)","insp_viol_unit":"1","insp_unit_id":"191765217","insp_violation_category_id":"33","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"172303A"}],"inspection_per_units":[{"id":2663055,"change_date":"2022-11-02 21:39:00","inspection_id":"77037050","insp_unit_id":"191765217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"S518","insp_unit_license":"11593MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WDNBL2CG326565","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:15.000000Z","updated_at":"2025-03-17T22:25:15.000000Z"}]},{"id":1557327,"change_date":"2022-10-20 21:40:00","inspection_id":"76924678","dot_number":"943816","report_state":"MD","report_number":"0246005003","insp_date":"2022-10-20 00:00:00","insp_start_time":"0804","insp_end_time":"0829","registration_date":null,"region":"ET","ci_status_code":"C","location":"038","location_desc":"BALTIMORE COUNTY","county_code_state":"MD","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","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":"2022-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"2582152","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-10-20 21:40:00","snet_input_date":"2022-10-20 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-10-20 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:15.000000Z","updated_at":"2025-03-17T18:55:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2505856,"change_date":"2022-10-20 21:40:00","inspection_id":"76924678","insp_unit_id":"191539589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"S828","insp_unit_license":"ZHS2916","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FDUF4HY1GEB17094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:11.000000Z","updated_at":"2025-03-17T22:24:11.000000Z"}]},{"id":1547338,"change_date":"2022-10-19 21:40:00","inspection_id":"76913029","dot_number":"943816","report_state":"NY","report_number":"0122002536","insp_date":"2022-10-18 00:00:00","insp_start_time":"1135","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"12053","location_desc":"SCHENECTADY COMMUNITY COLLEGE","county_code_state":"NY","county_code":"093","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14400","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":"2760561","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-10-19 21:40:00","snet_input_date":"2022-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-19 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:12.000000Z","updated_at":"2025-03-17T18:55:12.000000Z","inspection_violations":[{"id":2434479,"change_date":"2022-10-19 21:40:00","inspection_id":"76913029","insp_violation_id":"249110820","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191513346","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":2489911,"change_date":"2022-10-19 21:40:00","inspection_id":"76913029","insp_unit_id":"191513346","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"11593MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WDNBL2CG326565","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"}]},{"id":1483002,"change_date":"2022-10-11 21:41:00","inspection_id":"76838930","dot_number":"943816","report_state":"NY","report_number":"SPG0250793","insp_date":"2022-10-07 00:00:00","insp_start_time":"1113","insp_end_time":"1206","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY AND SONS","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-10-11 21:41: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":"2757231","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:06.000000Z","updated_at":"2025-03-17T18:54:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2386306,"change_date":"2022-10-11 21:41:00","inspection_id":"76838930","insp_unit_id":"191364127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1811","insp_unit_license":"85487PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALHC5DV0LDLY9493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"}]},{"id":1153006,"change_date":"2022-08-27 21:31:00","inspection_id":"76456097","dot_number":"943816","report_state":"PA","report_number":"C055001185","insp_date":"2022-08-25 00:00:00","insp_start_time":"1026","insp_end_time":"1038","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 41 AND 30 SOUTH","county_code_state":"PA","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MOCCASIN RUN","shipping_paper_number":"1488005","cargo_tank":"406","hazmat_placard_req":"Y","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-08-27 21:31: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":"2281564","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-08-27 21:31:00","snet_input_date":"2022-08-25 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-08-27 21:31:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:56.000000Z","updated_at":"2025-03-17T18:47:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1853814,"change_date":"2022-08-27 21:31:00","inspection_id":"76456097","insp_unit_id":"190582315","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1915","insp_unit_license":"AH17922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3ALHG3FM5NDNL9209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:45.000000Z","updated_at":"2025-03-17T22:19:45.000000Z"}]},{"id":1138688,"change_date":"2022-08-25 21:43:00","inspection_id":"76439506","dot_number":"943816","report_state":"PA","report_number":"L404223607","insp_date":"2022-08-24 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"SHOEMAKER AVE MEASURING 1254 F","county_code_state":"PA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION","shipping_paper_number":"107158","cargo_tank":"OTH","hazmat_placard_req":"Y","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-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2281127","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-08-25 21:43:00","snet_input_date":"2022-08-24 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-08-25 21:43:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:37.000000Z","updated_at":"2025-03-17T18:47:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1831388,"change_date":"2022-08-25 21:43:00","inspection_id":"76439506","insp_unit_id":"190550834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1949","insp_unit_license":"YFV2058","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"2NKMH77X9SM649483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:37.000000Z","updated_at":"2025-03-17T22:19:37.000000Z"}]},{"id":1142092,"change_date":"2022-08-26 21:39:00","inspection_id":"76443319","dot_number":"943816","report_state":"NY","report_number":"SPG0205242","insp_date":"2022-08-24 00:00:00","insp_start_time":"0817","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL","shipping_paper_number":"1512523","cargo_tank":"406","hazmat_placard_req":"Y","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2743584","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-08-26 21:39:00","snet_input_date":"2022-08-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-26 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:53.000000Z","updated_at":"2025-03-17T18:47:53.000000Z","inspection_violations":[{"id":1806731,"change_date":"2022-08-26 21:39:00","inspection_id":"76443319","insp_violation_id":"248015421","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190557789","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:24.000000Z","updated_at":"2025-03-17T21:15:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1836174,"change_date":"2022-08-26 21:39:00","inspection_id":"76443319","insp_unit_id":"190557789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1821","insp_unit_license":"18770PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMKAANX9H143583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:39.000000Z","updated_at":"2025-03-17T22:19:39.000000Z"}]},{"id":822453,"change_date":"2022-07-14 21:42:00","inspection_id":"76069948","dot_number":"943816","report_state":"PA","report_number":"XL00039586","insp_date":"2022-07-12 00:00:00","insp_start_time":"1319","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"MEMORIAL HWY MEASURING 106 FEE","county_code_state":"PA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION L","shipping_paper_number":"1488005","cargo_tank":null,"hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2022-07-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23413","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":"2270154","transaction_code":"A","transaction_date":"2022-07-12 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-07-14 21:42:00","snet_input_date":"2022-07-12 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1323529,"change_date":"2022-07-14 21:42:00","inspection_id":"76069948","insp_unit_id":"189788864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1915","insp_unit_license":"AH17922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3ALHG3FM5NDNL9209","insp_unit_decal":"Y","insp_unit_decal_number":"31664026","created_at":"2025-03-17T22:16:19.000000Z","updated_at":"2025-03-17T22:16:19.000000Z"}]},{"id":776243,"change_date":"2022-07-08 21:40:00","inspection_id":"76015808","dot_number":"943816","report_state":"NY","report_number":"SPF0195666","insp_date":"2022-07-06 00:00:00","insp_start_time":"1020","insp_end_time":"1047","registration_date":null,"region":"ET","ci_status_code":"C","location":"10566","location_desc":"87 NEW BALTIMORE EXIT 21B","county_code_state":"NY","county_code":"039","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2725030","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[{"id":1226805,"change_date":"2022-07-08 21:40:00","inspection_id":"76015808","insp_violation_id":"246968317","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189667347","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1248921,"change_date":"2022-07-08 21:40:00","inspection_id":"76015808","insp_unit_id":"189667347","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1800","insp_unit_license":"18271PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT49J093900","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]},{"id":601774,"change_date":"2022-06-14 21:42:00","inspection_id":"75810450","dot_number":"943816","report_state":"NY","report_number":"0122002368","insp_date":"2022-06-13 00:00:00","insp_start_time":"1200","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":"10331","location_desc":"GLENVILLE PARK AND RIDE","county_code_state":"NY","county_code":"093","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2716563","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-06-14 21:42:00","snet_input_date":"2022-06-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:24.000000Z","updated_at":"2025-03-17T18:38:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":967178,"change_date":"2022-06-14 21:42:00","inspection_id":"75810450","insp_unit_id":"189227244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1827","insp_unit_license":"26288PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN27H417558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:09.000000Z","updated_at":"2025-03-17T22:14:09.000000Z"}]},{"id":484208,"change_date":"2022-05-25 21:42:00","inspection_id":"75670554","dot_number":"943816","report_state":"PA","report_number":"E907214377","insp_date":"2022-05-23 00:00:00","insp_start_time":"1001","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"SR 222 NORTHBOUND WEIGH STATIO","county_code_state":"PA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PETRO;EUM TRANSPORTATION","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2258129","transaction_code":"A","transaction_date":"2022-05-23 00:00:00","upload_date":"2022-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":null,"census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-23 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:18.000000Z","updated_at":"2025-03-17T18:36:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":778768,"change_date":"2022-05-25 21:42:00","inspection_id":"75670554","insp_unit_id":"188915794","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1927","insp_unit_license":"AH15224","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACXFE4NHMR4139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:59.000000Z","updated_at":"2025-03-17T22:12:59.000000Z"}]},{"id":428652,"change_date":"2022-05-19 21:41:00","inspection_id":"75604100","dot_number":"943816","report_state":"NY","report_number":"SPG0204941","insp_date":"2022-05-18 00:00:00","insp_start_time":"0845","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN RAY AND SONS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2707653","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":"00943816","upload_search_indicator":"M","census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"JOHN RAY LEFFLER","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:09.000000Z","updated_at":"2025-03-17T18:35:09.000000Z","inspection_violations":[{"id":673516,"change_date":"2022-05-19 21:41:00","inspection_id":"75604100","insp_violation_id":"245908200","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"188780200","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":691195,"change_date":"2022-05-19 21:41:00","inspection_id":"75604100","insp_unit_id":"188780200","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"M211","insp_unit_license":"39214ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRNBLXHG727693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:27.000000Z","updated_at":"2025-03-17T22:12:27.000000Z"}]},{"id":355618,"change_date":"2022-05-10 21:40:00","inspection_id":"75517020","dot_number":"943816","report_state":"NY","report_number":"0117009315","insp_date":"2022-05-09 00:00:00","insp_start_time":"0946","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK REST AREA (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","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-05-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14400","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":"2704451","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-05-10 21:40:00","snet_input_date":"2022-05-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:41.000000Z","updated_at":"2025-03-17T18:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":574876,"change_date":"2022-05-10 21:40:00","inspection_id":"75517020","insp_unit_id":"188597977","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"11593MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WDNBL2CG326565","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:43.000000Z","updated_at":"2025-03-17T22:11:43.000000Z"}]},{"id":428456,"change_date":"2022-05-19 21:41:00","inspection_id":"75603878","dot_number":"943816","report_state":"NY","report_number":"SPG0204926","insp_date":"2022-05-09 00:00:00","insp_start_time":"0940","insp_end_time":"1022","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"1","hazmat_oos_total":"0","snet_sequence_id":"2708229","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":"00943816","upload_search_indicator":"M","census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","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":[{"id":673187,"change_date":"2022-05-19 21:41:00","inspection_id":"75603878","insp_violation_id":"245907762","seq_no":"1","part_no":"172","part_no_section":"407","insp_viol_unit":"1","insp_unit_id":"188779819","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"172407"}],"inspection_per_units":[{"id":690884,"change_date":"2022-05-19 21:41:00","inspection_id":"75603878","insp_unit_id":"188779819","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"S 528","insp_unit_license":"88181NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM5LH664828","insp_unit_decal":"Y","insp_unit_decal_number":"31444343","created_at":"2025-03-17T22:12:27.000000Z","updated_at":"2025-03-17T22:12:27.000000Z"}]},{"id":285023,"change_date":"2022-04-29 21:40:00","inspection_id":"75433251","dot_number":"943816","report_state":"NY","report_number":"SPH0050281","insp_date":"2022-04-27 00:00:00","insp_start_time":"0849","insp_end_time":"1004","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2700562","transaction_code":"A","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-04-29 21:40:00","snet_input_date":"2022-04-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-29 21:40:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:34.000000Z","updated_at":"2025-03-17T18:32:34.000000Z","inspection_violations":[{"id":444681,"change_date":"2022-04-29 21:40:00","inspection_id":"75433251","insp_violation_id":"245469444","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"188416903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39345D"},{"id":444682,"change_date":"2022-04-29 21:40:00","inspection_id":"75433251","insp_violation_id":"245469445","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188416903","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39347E"},{"id":444683,"change_date":"2022-04-29 21:40:00","inspection_id":"75433251","insp_violation_id":"245469446","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188416903","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39347E"},{"id":444684,"change_date":"2022-04-29 21:40:00","inspection_id":"75433251","insp_violation_id":"245469447","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188416903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":461409,"change_date":"2022-04-29 21:40:00","inspection_id":"75433251","insp_unit_id":"188416903","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1817","insp_unit_license":"18765PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT78J568499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:02.000000Z","updated_at":"2025-03-17T22:11:02.000000Z"}]},{"id":199818,"change_date":"2022-04-19 21:41:00","inspection_id":"75331156","dot_number":"943816","report_state":"NY","report_number":"SPT0431907","insp_date":"2022-04-18 00:00:00","insp_start_time":"0840","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"10071M","location_desc":"SELKIRK (BETHLEHEM EXIT 22)","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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-04-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2","hazmat_oos_total":"0","snet_sequence_id":"2696390","transaction_code":"A","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-04-19 21:41:00","snet_input_date":"2022-04-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-19 21:41:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"669 EAST ROSS STREET","insp_carrier_city":"LANCASTER","insp_carrier_state":"PA","insp_carrier_zip_code":"17602","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:55.000000Z","updated_at":"2025-03-17T18:30:55.000000Z","inspection_violations":[{"id":305718,"change_date":"2022-04-19 21:41:00","inspection_id":"75331156","insp_violation_id":"245225187","seq_no":"1","part_no":"172","part_no_section":"519","insp_viol_unit":"1","insp_unit_id":"188211007","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"172519"},{"id":305719,"change_date":"2022-04-19 21:41:00","inspection_id":"75331156","insp_violation_id":"245225188","seq_no":"2","part_no":"172","part_no_section":"332(c)","insp_viol_unit":"1","insp_unit_id":"188211007","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"172332C"}],"inspection_per_units":[{"id":323572,"change_date":"2022-04-19 21:41:00","inspection_id":"75331156","insp_unit_id":"188211007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1827","insp_unit_license":"26288PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN27H417558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:08.000000Z","updated_at":"2025-03-17T22:10:08.000000Z"}]},{"id":107791,"change_date":"2022-04-05 21:39:00","inspection_id":"75219656","dot_number":"943816","report_state":"NY","report_number":"0117009229","insp_date":"2022-04-01 00:00:00","insp_start_time":"0850","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK REST AREA (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"1488391","cargo_tank":"406","hazmat_placard_req":"Y","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-04-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"2691990","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00943816","upload_search_indicator":"M","census_search_date":"2022-04-05 21:39:00","snet_input_date":"2022-04-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-05 21:39:00","insp_carrier_name":"COLUMBIA PETROLEUM TRANSPORTATION INC","insp_carrier_street":"1000 WOODBURY ROAD SUITE 110","insp_carrier_city":"WOODBURY","insp_carrier_state":"NY","insp_carrier_zip_code":"11797","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":158135,"change_date":"2022-04-05 21:39:00","inspection_id":"75219656","insp_violation_id":"244959685","seq_no":"1","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"187983996","insp_violation_category_id":"16","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":"39355C2"}],"inspection_per_units":[{"id":174279,"change_date":"2022-04-05 21:39:00","inspection_id":"75219656","insp_unit_id":"187983996","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1826","insp_unit_license":"22364PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWYSBT25J045791","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"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/943816\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/943816\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/943816\/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\/943816\/inspections","per_page":100,"prev_page_url":null,"to":75,"total":75}