{"current_page":1,"data":[{"id":11899173,"change_date":"2026-05-13 21:42:00","inspection_id":"87837805","dot_number":"196861","report_state":"NC","report_number":"0006874090","insp_date":"2026-05-11 00:00:00","insp_start_time":"1340","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":"US-1 N","location_desc":"US-1 NEAR NC-177","county_code_state":"NC","county_code":"153","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PIEDMONT NATURAL GAS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2404382","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-12 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:58.000000Z","updated_at":"2026-05-24T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20687397,"change_date":"2026-05-13 21:42:00","inspection_id":"87837805","insp_unit_id":"213532033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA158463","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFEXNDNF9836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:38.000000Z","updated_at":"2026-05-24T09:04:59.000000Z"},{"id":20687398,"change_date":"2026-05-13 21:42:00","inspection_id":"87837805","insp_unit_id":"213532034","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"AH49326","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUP30207J1009242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:38.000000Z","updated_at":"2026-05-24T09:04:59.000000Z"}]},{"id":11376749,"change_date":"2026-03-14 21:34:00","inspection_id":"87290677","dot_number":"196861","report_state":"NC","report_number":"0006856169","insp_date":"2026-03-13 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 17","location_desc":"US 17 NEAR PRICE RD","county_code_state":"NC","county_code":"013","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-14 21:34: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":"2386641","transaction_code":"A","transaction_date":"2026-03-13 00:00:00","upload_date":"2026-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2026-03-14 21:34:00","snet_input_date":"2026-03-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-03-14 21:34:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-17T09:38:35.000000Z","updated_at":"2026-03-25T09:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19480536,"change_date":"2026-03-14 21:34:00","inspection_id":"87290677","insp_unit_id":"212136259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA159129","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFE7MDMK9208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-17T09:14:11.000000Z","updated_at":"2026-03-25T09:03:57.000000Z"},{"id":19480537,"change_date":"2026-03-14 21:34:00","inspection_id":"87290677","insp_unit_id":"212136260","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CN33192","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24200M1001596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-17T09:14:11.000000Z","updated_at":"2026-03-25T09:03:57.000000Z"}]},{"id":11274734,"change_date":"2026-03-03 21:35:00","inspection_id":"87189139","dot_number":"196861","report_state":"NC","report_number":"0006852852","insp_date":"2026-03-02 00:00:00","insp_start_time":"1515","insp_end_time":"1555","registration_date":null,"region":"ET","ci_status_code":"C","location":"UNITED","location_desc":"UNITED STATES HIGHWAY 321 SOUT","county_code_state":"NC","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-03 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"61000","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":"2383123","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2026-03-03 21:35:00","snet_input_date":"2026-03-03 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-03-03 21:35:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-06T10:39:39.000000Z","updated_at":"2026-03-14T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19281679,"change_date":"2026-03-03 21:35:00","inspection_id":"87189139","insp_unit_id":"211936720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"43408","insp_unit_license":"YA188197","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVAC4FT1SHVP5348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:04.000000Z","updated_at":"2026-03-14T09:02:52.000000Z"},{"id":19281680,"change_date":"2026-03-03 21:35:00","inspection_id":"87189139","insp_unit_id":"211936721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"AJ31641","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24203R1002636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:04.000000Z","updated_at":"2026-03-14T09:02:52.000000Z"}]},{"id":11142749,"change_date":"2026-02-16 21:35:00","inspection_id":"87056859","dot_number":"196861","report_state":"NC","report_number":"0006847716","insp_date":"2026-02-15 00:00:00","insp_start_time":"1127","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":"ASHEVI","location_desc":"ASHEVILLE WEIGH STATION, I-40,","county_code_state":"NC","county_code":"021","insp_level_id":"3","service_center":"SH","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":"2026-02-16 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2377959","transaction_code":"A","transaction_date":"2026-02-15 00:00:00","upload_date":"2026-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2026-02-16 21:35:00","snet_input_date":"2026-02-16 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-02-16 21:35:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-19T10:37:12.000000Z","updated_at":"2026-02-27T10:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19007983,"change_date":"2026-02-16 21:35:00","inspection_id":"87056859","insp_unit_id":"211646090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"DD4977","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVACWFE1RHVB3290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:52.000000Z","updated_at":"2026-02-27T10:02:47.000000Z"},{"id":19007984,"change_date":"2026-02-16 21:35:00","inspection_id":"87056859","insp_unit_id":"211646091","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"DB60678","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"5E7HP2521PA002673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:52.000000Z","updated_at":"2026-02-27T10:02:47.000000Z"}]},{"id":10192248,"change_date":"2025-11-13 21:39:00","inspection_id":"86312602","dot_number":"196861","report_state":"NC","report_number":"0006818490","insp_date":"2025-11-12 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"95","location_desc":"95","county_code_state":"NC","county_code":"127","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-13 21:39: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":"2348438","transaction_code":"A","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2025-11-13 21:39:00","snet_input_date":"2025-11-13 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:56.000000Z","updated_at":"2025-11-17T10:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16976611,"change_date":"2025-11-13 21:39:00","inspection_id":"86312602","insp_unit_id":"210010892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VH7802","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FD0X4HN3REG00963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:28.000000Z","updated_at":"2025-11-17T10:00:58.000000Z"},{"id":16976612,"change_date":"2025-11-13 21:39:00","inspection_id":"86312602","insp_unit_id":"210010893","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"DC75178","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD23204R1002641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:28.000000Z","updated_at":"2025-11-17T10:00:58.000000Z"}]},{"id":10172907,"change_date":"2025-11-12 21:40:00","inspection_id":"86292281","dot_number":"196861","report_state":"TN","report_number":"I033R70045","insp_date":"2025-11-10 00:00:00","insp_start_time":"1348","insp_end_time":"1414","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"NASHVILLE TN","county_code_state":"TN","county_code":"037","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10900","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":"2529770","transaction_code":"A","transaction_date":"2025-11-11 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"4720 PIEDMONT ROW DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:32.000000Z","updated_at":"2025-11-16T10:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16940841,"change_date":"2025-11-12 21:40:00","inspection_id":"86292281","insp_unit_id":"209962024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H470029","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FD8X3A60MED57699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:28.000000Z","updated_at":"2025-11-16T10:00:20.000000Z"}]},{"id":9899550,"change_date":"2025-10-09 21:41:00","inspection_id":"86003916","dot_number":"196861","report_state":"NC","report_number":"0006806218","insp_date":"2025-10-08 00:00:00","insp_start_time":"1025","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"NC43 N","location_desc":"NC43 NEAR US70","county_code_state":"NC","county_code":"049","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-09 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":"2336038","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2025-10-09 21:41:00","snet_input_date":"2025-10-09 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-10-09 21:41:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:02:01.000000Z","updated_at":"2025-10-13T10:01:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16427503,"change_date":"2025-10-09 21:41:00","inspection_id":"86003916","insp_unit_id":"209387119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA159129","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFE7MDMK9208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:23.000000Z","updated_at":"2025-10-13T09:46:25.000000Z"},{"id":16427504,"change_date":"2025-10-09 21:41:00","inspection_id":"86003916","insp_unit_id":"209387120","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CN33192","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24200M1001596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:23.000000Z","updated_at":"2025-10-13T09:46:25.000000Z"}]},{"id":9140361,"change_date":"2025-07-14 21:40:00","inspection_id":"85206672","dot_number":"196861","report_state":"NC","report_number":"0006775053","insp_date":"2025-07-12 00:00:00","insp_start_time":"1213","insp_end_time":"1313","registration_date":null,"region":"ET","ci_status_code":"C","location":"DUPLIN","location_desc":"DUPLIN COUNTY, FAISON","county_code_state":"NC","county_code":"061","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34500","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":"0","hazmat_oos_total":"0","snet_sequence_id":"2306154","transaction_code":"A","transaction_date":"2025-07-12 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:44.000000Z","updated_at":"2025-07-18T10:45:44.000000Z","inspection_violations":[{"id":14744294,"change_date":"2025-07-14 21:40:00","inspection_id":"85206672","insp_violation_id":"267387762","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"207853791","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3307995","created_at":"2025-07-17T10:47:08.000000Z","updated_at":"2025-07-18T10:47:11.000000Z","normalized_code":"393100A"},{"id":14744295,"change_date":"2025-07-14 21:40:00","inspection_id":"85206672","insp_violation_id":"267387763","seq_no":"2","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"207853791","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3307995","created_at":"2025-07-17T10:47:08.000000Z","updated_at":"2025-07-18T10:47:11.000000Z","normalized_code":"393100A"},{"id":14744296,"change_date":"2025-07-14 21:40:00","inspection_id":"85206672","insp_violation_id":"267387764","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"207853791","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3307995","created_at":"2025-07-17T10:47:08.000000Z","updated_at":"2025-07-18T10:47:11.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":15009203,"change_date":"2025-07-14 21:40:00","inspection_id":"85206672","insp_unit_id":"207853790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA169801","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FD0X4HT7KEF23177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:30.000000Z","updated_at":"2025-07-18T09:45:44.000000Z"},{"id":15009204,"change_date":"2025-07-14 21:40:00","inspection_id":"85206672","insp_unit_id":"207853791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HUDS","insp_unit_company":null,"insp_unit_license":"AA92466","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"10HHTD1D5P1000234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:30.000000Z","updated_at":"2025-07-18T09:45:44.000000Z"}]},{"id":9039977,"change_date":"2025-07-01 21:38:00","inspection_id":"85100673","dot_number":"196861","report_state":"NC","report_number":"0006770443","insp_date":"2025-06-30 00:00:00","insp_start_time":"0900","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 1 @","location_desc":"US 1 @ DERBY RD","county_code_state":"NC","county_code":"153","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PIEDMONT NATURAL GAS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","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":"2301984","transaction_code":"A","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2025-07-01 21:38:00","snet_input_date":"2025-07-01 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-07-01 21:38:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-04T10:01:12.000000Z","updated_at":"2025-07-07T10:06:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14829498,"change_date":"2025-07-01 21:38:00","inspection_id":"85100673","insp_unit_id":"207657050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA93660","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3FRXW7FG5AV279127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-04T09:46:30.000000Z","updated_at":"2025-07-05T09:45:35.000000Z"},{"id":14829499,"change_date":"2025-07-01 21:38:00","inspection_id":"85100673","insp_unit_id":"207657051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"AM46665","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24208M1001720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-04T09:46:30.000000Z","updated_at":"2025-07-05T09:45:35.000000Z"}]},{"id":8732815,"change_date":"2025-05-25 21:34:00","inspection_id":"84775617","dot_number":"196861","report_state":"TN","report_number":"I033910050","insp_date":"2025-05-23 00:00:00","insp_start_time":"1310","insp_end_time":"1341","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WATERTOWN TN","county_code_state":"TN","county_code":"189","insp_level_id":"3","service_center":"SH","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":"2025-05-25 21:34: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":"1778229","transaction_code":"A","transaction_date":"2025-05-25 00:00:00","upload_date":"2025-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2025-05-25 21:34:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-25 21:34:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"4720 PIEDMONT ROW DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-28T10:00:25.000000Z","updated_at":"2025-05-29T10:00:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14277135,"change_date":"2025-05-25 21:34:00","inspection_id":"84775617","insp_unit_id":"207056753","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"H707080","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVAC4DX4HHHW9048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-28T09:45:27.000000Z","updated_at":"2025-05-29T09:45:21.000000Z"}]},{"id":8381646,"change_date":"2025-04-15 21:41:00","inspection_id":"84405549","dot_number":"196861","report_state":"NC","report_number":"0006748436","insp_date":"2025-04-15 00:00:00","insp_start_time":"0828","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"SR 122","location_desc":"SR 1225 NEAR US 70","county_code_state":"NC","county_code":"049","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-15 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":"2280547","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-15 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:26:33.000000Z","updated_at":"2025-04-19T10:16:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13604397,"change_date":"2025-04-15 21:41:00","inspection_id":"84405549","insp_unit_id":"206323278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA159129","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFE7MDMK9208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:13:25.000000Z","updated_at":"2025-04-19T09:59:07.000000Z"},{"id":13604398,"change_date":"2025-04-15 21:41:00","inspection_id":"84405549","insp_unit_id":"206323279","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CN33192","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24200M1001596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:13:25.000000Z","updated_at":"2025-04-19T09:59:07.000000Z"}]},{"id":8350231,"change_date":"2025-04-11 21:40:00","inspection_id":"84372389","dot_number":"196861","report_state":"TN","report_number":"I033GS1060","insp_date":"2025-04-09 00:00:00","insp_start_time":"1429","insp_end_time":"1455","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MT. JULIET TN","county_code_state":"TN","county_code":"189","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PIEDMONT NATURAL","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-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"74000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1582256","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"4720 PIEDMONT ROW DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:30.000000Z","updated_at":"2025-04-15T10:14:37.000000Z","inspection_violations":[{"id":13151777,"change_date":"2025-04-11 21:40:00","inspection_id":"84372389","insp_violation_id":"265562304","seq_no":"1","part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T10:57:56.000000Z","updated_at":"2025-04-15T10:26:56.000000Z","normalized_code":"38395ALCDL"},{"id":13151778,"change_date":"2025-04-11 21:40:00","inspection_id":"84372389","insp_violation_id":"265562305","seq_no":"2","part_no":"393","part_no_section":"130B-CHVE","insp_viol_unit":"2","insp_unit_id":"206261984","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-13T10:57:56.000000Z","updated_at":"2025-04-15T10:26:56.000000Z","normalized_code":"393130BCHVE"}],"inspection_per_units":[{"id":13548573,"change_date":"2025-04-11 21:40:00","inspection_id":"84372389","insp_unit_id":"206261983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"H707073","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVAC4FTXLHLW4375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:11:51.000000Z","updated_at":"2025-04-15T09:55:20.000000Z"},{"id":13548574,"change_date":"2025-04-11 21:40:00","inspection_id":"84372389","insp_unit_id":"206261984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"058319T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"00000000000000000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:11:51.000000Z","updated_at":"2025-04-15T09:55:20.000000Z"}]},{"id":6989058,"change_date":"2024-10-18 21:42:00","inspection_id":"82939235","dot_number":"196861","report_state":"NC","report_number":"0006692659","insp_date":"2024-10-17 00:00:00","insp_start_time":"1145","insp_end_time":"1211","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 74B","location_desc":"US 74B","county_code_state":"NC","county_code":"157","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","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":"2225074","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-18 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"4720 PIEDMONT ROW DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11272745,"change_date":"2024-10-18 21:42:00","inspection_id":"82939235","insp_unit_id":"203473230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RE7108","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FD8X3G69NED80214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"},{"id":11272746,"change_date":"2024-10-18 21:42:00","inspection_id":"82939235","insp_unit_id":"203473231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"DC60784","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD23203R1002694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6989136,"change_date":"2024-10-18 21:42:00","inspection_id":"82939314","dot_number":"196861","report_state":"NC","report_number":"0006692669","insp_date":"2024-10-17 00:00:00","insp_start_time":"1214","insp_end_time":"1232","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 74","location_desc":"US 74","county_code_state":"NC","county_code":"157","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","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":"2225064","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-18 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"4720 PIEDMONT ROW DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11272865,"change_date":"2024-10-18 21:42:00","inspection_id":"82939314","insp_unit_id":"203473353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA93660","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3FRXW7FG5AV279127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"},{"id":11272866,"change_date":"2024-10-18 21:42:00","inspection_id":"82939314","insp_unit_id":"203473354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"C BU","insp_unit_company":null,"insp_unit_license":"AM46665","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24208M1001720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6609354,"change_date":"2024-10-04 21:39:00","inspection_id":"82535238","dot_number":"196861","report_state":"NC","report_number":"0006680133","insp_date":"2024-08-27 00:00:00","insp_start_time":"0739","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":"CUMBER","location_desc":"CUMBERLAND COUNTY, HOPE MILLS","county_code_state":"NC","county_code":"051","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51900","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":"2215032","transaction_code":"C","transaction_date":"2024-10-04 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2024-08-30 21:40:00","snet_input_date":"2024-08-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:04.000000Z","updated_at":"2025-03-17T20:34:04.000000Z","inspection_violations":[{"id":10279298,"change_date":"2024-10-04 21:39:00","inspection_id":"82535238","insp_violation_id":"262192863","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"203273565","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:44.000000Z","updated_at":"2025-03-17T21:55:44.000000Z","normalized_code":"39617C"},{"id":10279299,"change_date":"2024-10-04 21:39:00","inspection_id":"82535238","insp_violation_id":"262192864","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203273565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:44.000000Z","updated_at":"2025-03-17T21:55:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10655977,"change_date":"2024-10-04 21:39:00","inspection_id":"82535238","insp_unit_id":"203273564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA170892","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVAC4FT7LHLW4379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:22.000000Z","updated_at":"2025-03-17T23:33:22.000000Z"},{"id":10655978,"change_date":"2024-10-04 21:39:00","inspection_id":"82535238","insp_unit_id":"203273565","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"HUDS","insp_unit_company":null,"insp_unit_license":"AA82340","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"10HHTHBG2C1000010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:22.000000Z","updated_at":"2025-03-17T23:33:22.000000Z"}]},{"id":6526646,"change_date":"2024-08-21 21:42:00","inspection_id":"82446980","dot_number":"196861","report_state":"NC","report_number":"0006677256","insp_date":"2024-08-19 00:00:00","insp_start_time":"1104","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"NC 24","location_desc":"NC 24 NEAR SR 1119, CARTERET C","county_code_state":"NC","county_code":"031","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-21 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":"2210971","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2024-08-21 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-08-21 21:42:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:20.000000Z","updated_at":"2025-03-17T20:32:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10521146,"change_date":"2024-08-21 21:42:00","inspection_id":"82446980","insp_unit_id":"202509996","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA124995","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVACXFEXKHKN1219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:59.000000Z","updated_at":"2025-03-17T23:31:59.000000Z"},{"id":10521147,"change_date":"2024-08-21 21:42:00","inspection_id":"82446980","insp_unit_id":"202509997","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"CN33194","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24209M1001595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:59.000000Z","updated_at":"2025-03-17T23:31:59.000000Z"}]},{"id":4461900,"change_date":"2023-11-20 21:40:00","inspection_id":"80204009","dot_number":"196861","report_state":"NC","report_number":"0006595466","insp_date":"2023-11-17 00:00:00","insp_start_time":"1450","insp_end_time":"1512","registration_date":null,"region":"ET","ci_status_code":"C","location":"MM 133","location_desc":"MM 133","county_code_state":"NC","county_code":"103","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"2129537","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2023-11-20 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-11-20 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:23.000000Z","updated_at":"2025-03-17T19:51:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7175557,"change_date":"2023-11-20 21:40:00","inspection_id":"80204009","insp_unit_id":"198142100","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA152160","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVACWFC7JHJV5958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"},{"id":7175558,"change_date":"2023-11-20 21:40:00","inspection_id":"80204009","insp_unit_id":"198142101","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CN53505","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24207M1001594","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"}]},{"id":4160808,"change_date":"2023-10-10 21:41:00","inspection_id":"79871305","dot_number":"196861","report_state":"NC","report_number":"0006582922","insp_date":"2023-10-10 00:00:00","insp_start_time":"0840","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 17","location_desc":"US 17 NEAR US 70","county_code_state":"NC","county_code":"049","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"2116542","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:25.000000Z","updated_at":"2025-03-17T19:45:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6689997,"change_date":"2023-10-10 21:41:00","inspection_id":"79871305","insp_unit_id":"197472771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA152160","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVACWFC7JHJV5958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:05.000000Z","updated_at":"2025-03-17T22:56:05.000000Z"},{"id":6689998,"change_date":"2023-10-10 21:41:00","inspection_id":"79871305","insp_unit_id":"197472772","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CN53505","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24207M1001594","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:05.000000Z","updated_at":"2025-03-17T22:56:05.000000Z"}]},{"id":4012665,"change_date":"2023-09-20 21:39:00","inspection_id":"79706785","dot_number":"196861","report_state":"TN","report_number":"TEXA001969","insp_date":"2023-09-19 00:00:00","insp_start_time":"1035","insp_end_time":"1054","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"N MT. JULIET RD\/ STONEGATE DR","county_code_state":"TN","county_code":"189","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"PIEDMONT NATURAL GAS COMPANY INC","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":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"57600","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":"1674712","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:02.000000Z","updated_at":"2025-03-17T19:42:02.000000Z","inspection_violations":[{"id":6208866,"change_date":"2023-09-20 21:39:00","inspection_id":"79706785","insp_violation_id":"255372140","seq_no":"1","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"2","insp_unit_id":"197142892","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"393130B"}],"inspection_per_units":[{"id":6452041,"change_date":"2023-09-20 21:39:00","inspection_id":"79706785","insp_unit_id":"197142891","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32392","insp_unit_license":"H707084","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVAC4DXXJHJW8181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"},{"id":6452042,"change_date":"2023-09-20 21:39:00","inspection_id":"79706785","insp_unit_id":"197142892","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"32865","insp_unit_license":"058317T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1H9FP2529LR612038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"}]},{"id":3942335,"change_date":"2023-09-11 21:40:00","inspection_id":"79628796","dot_number":"196861","report_state":"NC","report_number":"0006574459","insp_date":"2023-09-11 00:00:00","insp_start_time":"1047","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-95 S","location_desc":"I-95 SB","county_code_state":"NC","county_code":"195","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"49000","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":"2107953","transaction_code":"A","transaction_date":"2023-09-11 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2023-09-11 21:40:00","snet_input_date":"2023-09-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-09-11 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:47.000000Z","updated_at":"2025-03-17T19:40:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6338800,"change_date":"2023-09-11 21:40:00","inspection_id":"79628796","insp_unit_id":"196986043","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA158609","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFE1MDMR4829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:14.000000Z","updated_at":"2025-03-17T22:53:14.000000Z"},{"id":6338801,"change_date":"2023-09-11 21:40:00","inspection_id":"79628796","insp_unit_id":"196986044","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"AE70175","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD23205H1008763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:14.000000Z","updated_at":"2025-03-17T22:53:14.000000Z"}]},{"id":3722497,"change_date":"2023-08-11 21:38:00","inspection_id":"79383493","dot_number":"196861","report_state":"TN","report_number":"TFCD000224","insp_date":"2023-08-11 00:00:00","insp_start_time":"0640","insp_end_time":"0705","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I65 SB 109","county_code_state":"TN","county_code":"147","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"PIEDMONT GAS COMPANY","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":"I","final_status_date":"2023-08-11 21:38: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":"1667159","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2023-08-11 21:38:00","snet_input_date":"2023-08-11 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-08-11 21:38:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5739943,"change_date":"2023-08-11 21:38:00","inspection_id":"79383493","insp_violation_id":"254602308","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196486408","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:33.000000Z","updated_at":"2025-03-17T21:33:33.000000Z","normalized_code":"3939A"},{"id":5739944,"change_date":"2023-08-11 21:38:00","inspection_id":"79383493","insp_violation_id":"254602309","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196486408","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:33.000000Z","updated_at":"2025-03-17T21:33:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5985351,"change_date":"2023-08-11 21:38:00","inspection_id":"79383493","insp_unit_id":"196486408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32389","insp_unit_license":"H707074","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVAC4DX8JHJW8163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":1752492,"change_date":"2022-11-16 21:40:00","inspection_id":"77148548","dot_number":"196861","report_state":"NC","report_number":"0006475292","insp_date":"2022-11-16 00:00:00","insp_start_time":"1030","insp_end_time":"1059","registration_date":null,"region":"ET","ci_status_code":"C","location":"US401","location_desc":"US401 AT FORD DR","county_code_state":"NC","county_code":"165","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PIEDMONT NATURAL GAS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-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":"2008911","transaction_code":"A","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-11-16 21:40:00","snet_input_date":"2022-11-16 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-11-16 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:57.000000Z","updated_at":"2025-03-17T18:58:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2819481,"change_date":"2022-11-16 21:40:00","inspection_id":"77148548","insp_unit_id":"191983640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA93651","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3FRXW7FG6AV279122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:17.000000Z","updated_at":"2025-03-17T22:26:17.000000Z"},{"id":2819482,"change_date":"2022-11-16 21:40:00","inspection_id":"77148548","insp_unit_id":"191983641","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CP18736","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24201M1001719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:17.000000Z","updated_at":"2025-03-17T22:26:17.000000Z"}]},{"id":1445319,"change_date":"2022-10-05 21:40:00","inspection_id":"76795026","dot_number":"196861","report_state":"NC","report_number":"0006462412","insp_date":"2022-10-05 00:00:00","insp_start_time":"0910","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"I95","location_desc":"I95","county_code_state":"NC","county_code":"155","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1996252","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-10-05 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-10-05 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:24.000000Z","updated_at":"2025-03-17T18:53:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2326724,"change_date":"2022-10-05 21:40:00","inspection_id":"76795026","insp_unit_id":"191278852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA164827","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FD0X4HT9KEF23178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:56.000000Z","updated_at":"2025-03-17T22:22:56.000000Z"},{"id":2326725,"change_date":"2022-10-05 21:40:00","inspection_id":"76795026","insp_unit_id":"191278853","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"AE18954","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD21206F1008019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:56.000000Z","updated_at":"2025-03-17T22:22:56.000000Z"}]},{"id":1313713,"change_date":"2022-09-19 21:39:00","inspection_id":"76642642","dot_number":"196861","report_state":"SC","report_number":"B341001219","insp_date":"2022-09-19 00:00:00","insp_start_time":"0825","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"107","location_desc":"I-85 NB ROADSIDE","county_code_state":"SC","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-19 21:39: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":"1050511","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":null,"census_search_date":"2022-09-19 21:39:00","snet_input_date":"2022-09-19 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"4720 PIEDMONT ROW DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:52.000000Z","updated_at":"2025-03-17T18:50:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2114827,"change_date":"2022-09-19 21:39:00","inspection_id":"76642642","insp_unit_id":"190969493","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"29001","insp_unit_license":"P530901","insp_unit_license_state":"SC","insp_unit_vehicle_id_number":"3FRXF7FL9BV613819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:29.000000Z","updated_at":"2025-03-17T22:21:29.000000Z"},{"id":2114828,"change_date":"2022-09-19 21:39:00","inspection_id":"76642642","insp_unit_id":"190969494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":"01","insp_unit_license":"66817PT","insp_unit_license_state":"SC","insp_unit_vehicle_id_number":"1BUD24209L1001207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:29.000000Z","updated_at":"2025-03-17T22:21:29.000000Z"}]},{"id":1227701,"change_date":"2022-09-07 21:40:00","inspection_id":"76542641","dot_number":"196861","report_state":"NC","report_number":"0006454714","insp_date":"2022-09-06 00:00:00","insp_start_time":"1305","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION I-95 N","county_code_state":"NC","county_code":"155","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51900","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":"1988493","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-09-07 21:40:00","snet_input_date":"2022-09-07 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-09-07 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:19.000000Z","updated_at":"2025-03-17T18:49:19.000000Z","inspection_violations":[{"id":1944377,"change_date":"2022-09-07 21:40:00","inspection_id":"76542641","insp_violation_id":"248252619","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:15:59.000000Z","updated_at":"2025-03-17T21:15:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1975439,"change_date":"2022-09-07 21:40:00","inspection_id":"76542641","insp_unit_id":"190759729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32397","insp_unit_license":"YA152126","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVAC4FT7LHLW4379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:35.000000Z","updated_at":"2025-03-17T22:20:35.000000Z"},{"id":1975440,"change_date":"2022-09-07 21:40:00","inspection_id":"76542641","insp_unit_id":"190759730","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"HUDS","insp_unit_company":null,"insp_unit_license":"AA82340","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"10HHTHBG2C1000010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:35.000000Z","updated_at":"2025-03-17T22:20:35.000000Z"}]},{"id":1132418,"change_date":"2022-08-25 21:42:00","inspection_id":"76432160","dot_number":"196861","report_state":"NC","report_number":"0006451126","insp_date":"2022-08-24 00:00:00","insp_start_time":"1408","insp_end_time":"1449","registration_date":null,"region":"ET","ci_status_code":"C","location":"CITY S","location_desc":"CITY STREET","county_code_state":"NC","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PNG","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-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":"1984811","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-25 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:35.000000Z","updated_at":"2025-03-17T18:47:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1821162,"change_date":"2022-08-25 21:42:00","inspection_id":"76432160","insp_unit_id":"190536024","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32385","insp_unit_license":"YA117441","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVAC4DX4JHJL3278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:33.000000Z","updated_at":"2025-03-17T22:19:33.000000Z"}]},{"id":954756,"change_date":"2022-08-03 21:42:00","inspection_id":"76224769","dot_number":"196861","report_state":"NC","report_number":"0006443523","insp_date":"2022-08-02 00:00:00","insp_start_time":"1429","insp_end_time":"1444","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-40","location_desc":"I-40","county_code_state":"NC","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"1977081","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-08-03 21:42:00","snet_input_date":"2022-08-03 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:26.000000Z","updated_at":"2025-03-17T18:44:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1536129,"change_date":"2022-08-03 21:42:00","inspection_id":"76224769","insp_unit_id":"190111620","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA93603","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3FRXF75G88V645531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:41.000000Z","updated_at":"2025-03-17T22:17:41.000000Z"}]},{"id":694451,"change_date":"2022-06-27 21:40:00","inspection_id":"75919999","dot_number":"196861","report_state":"NC","report_number":"0006431466","insp_date":"2022-06-24 00:00:00","insp_start_time":"1540","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 421","location_desc":"US 421 NB","county_code_state":"NC","county_code":"067","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 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":"1965144","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-27 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:51.000000Z","updated_at":"2025-03-17T18:39:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1115336,"change_date":"2022-06-27 21:40:00","inspection_id":"75919999","insp_unit_id":"189464836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32405","insp_unit_license":"YA152121","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVAC4FT8LHLW4245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:04.000000Z","updated_at":"2025-03-17T22:15:04.000000Z"}]},{"id":562797,"change_date":"2022-06-15 21:40:00","inspection_id":"75763690","dot_number":"196861","report_state":"NC","report_number":"0006424783","insp_date":"2022-06-07 00:00:00","insp_start_time":"1050","insp_end_time":"1125","registration_date":"2022-06-15 00:00:00","region":"ET","ci_status_code":"C","location":"US70","location_desc":"US70","county_code_state":"NC","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PIEDMONT GAS","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-06-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"1959556","transaction_code":"C","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-06-08 21:40:00","snet_input_date":"2022-06-07 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-06-08 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:44.000000Z","updated_at":"2025-03-17T18:37:44.000000Z","inspection_violations":[{"id":884758,"change_date":"2022-06-15 21:40:00","inspection_id":"75763690","insp_violation_id":"246478987","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189262371","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:11.000000Z","updated_at":"2025-03-17T21:11:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":905314,"change_date":"2022-06-15 21:40:00","inspection_id":"75763690","insp_unit_id":"189262370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YA145220","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVAC4FT2KHKU3516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"},{"id":905315,"change_date":"2022-06-15 21:40:00","inspection_id":"75763690","insp_unit_id":"189262371","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"CH11492","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24201C1006353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"}]},{"id":471714,"change_date":"2022-05-24 21:43:00","inspection_id":"75655586","dot_number":"196861","report_state":"NC","report_number":"0006421490","insp_date":"2022-05-24 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"STANLY","location_desc":"STANLY COUNTY","county_code_state":"NC","county_code":"167","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-24 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":"1955151","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:58.000000Z","updated_at":"2025-03-17T18:35:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":758373,"change_date":"2022-05-24 21:43:00","inspection_id":"75655586","insp_unit_id":"188881888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32923","insp_unit_license":"YA159128","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFE5MDMK9207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:51.000000Z","updated_at":"2025-03-17T22:12:51.000000Z"},{"id":758374,"change_date":"2022-05-24 21:43:00","inspection_id":"75655586","insp_unit_id":"188881889","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BUTL","insp_unit_company":null,"insp_unit_license":"AJ68140","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1BUD24204K1009701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:51.000000Z","updated_at":"2025-03-17T22:12:51.000000Z"}]},{"id":79304,"change_date":"2022-03-31 21:40:00","inspection_id":"75185164","dot_number":"196861","report_state":"NC","report_number":"0006406386","insp_date":"2022-03-30 00:00:00","insp_start_time":"1430","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROWAN","location_desc":"ROWAN COUNTY US-70 N","county_code_state":"NC","county_code":"159","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56740","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":"1939922","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00196861","upload_search_indicator":"M","census_search_date":"2022-03-31 21:40:00","snet_input_date":"2022-03-31 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-03-31 21:40:00","insp_carrier_name":"PIEDMONT NATURAL GAS COMPANY INC","insp_carrier_street":"P O BOX 33068","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28233","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:51.000000Z","updated_at":"2025-03-17T18:28:51.000000Z","inspection_violations":[{"id":117696,"change_date":"2022-03-31 21:40:00","inspection_id":"75185164","insp_violation_id":"244884615","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"187915254","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3279456","created_at":"2025-03-17T21:07:36.000000Z","updated_at":"2025-03-17T21:07:36.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":128425,"change_date":"2022-03-31 21:40:00","inspection_id":"75185164","insp_unit_id":"187915254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YA011663","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3FRXW7FG4AV279118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:00.000000Z","updated_at":"2025-03-17T22:09:00.000000Z"},{"id":128426,"change_date":"2022-03-31 21:40:00","inspection_id":"75185164","insp_unit_id":"187915255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HUD","insp_unit_company":null,"insp_unit_license":"AA92416","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"10HHTD1E3A1000006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:00.000000Z","updated_at":"2025-03-17T22:09:00.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/196861\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/196861\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/196861\/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\/196861\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}