{"current_page":1,"data":[{"id":12401652,"change_date":"2026-07-09 21:42:00","inspection_id":"88358725","dot_number":"3045831","report_state":"NC","report_number":"0006893521","insp_date":"2026-07-09 00:00:00","insp_start_time":"1344","insp_end_time":"1359","registration_date":null,"region":"ED","ci_status_code":"C","location":"US 70","location_desc":"KINSTON NC","county_code_state":"NC","county_code":"107","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":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3718818","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:25.000000Z","updated_at":"2026-07-20T09:31:19.000000Z","inspection_violations":[{"id":21579115,"change_date":"2026-07-09 21:42:00","inspection_id":"88358725","insp_violation_id":"275382388","seq_no":"1","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3325067","created_at":"2026-07-13T09:55:59.000000Z","updated_at":"2026-07-20T09:45:22.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":21544301,"change_date":"2026-07-09 21:42:00","inspection_id":"88358725","insp_unit_id":"214518388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:47.000000Z","updated_at":"2026-07-20T09:02:54.000000Z"}]},{"id":12401977,"change_date":"2026-07-09 21:42:00","inspection_id":"88359079","dot_number":"3045831","report_state":"NC","report_number":"0006893571","insp_date":"2026-07-09 00:00:00","insp_start_time":"1459","insp_end_time":"1515","registration_date":null,"region":"ED","ci_status_code":"C","location":"NC58","location_desc":"MAYSVILLE NC","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":"U","pen_cen_match":"I","final_status_date":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3719388","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:26.000000Z","updated_at":"2026-07-20T09:31:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21544797,"change_date":"2026-07-09 21:42:00","inspection_id":"88359079","insp_unit_id":"214518946","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:48.000000Z","updated_at":"2026-07-20T09:02:58.000000Z"}]},{"id":12325305,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","dot_number":"3045831","report_state":"NC","report_number":"0006890491","insp_date":"2026-06-30 00:00:00","insp_start_time":"1230","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":"264","location_desc":"MIDDLESEX NC","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":"U","pen_cen_match":"I","final_status_date":"2026-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3655403","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-30 21:40:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-03T09:41:27.000000Z","updated_at":"2026-07-11T09:30:59.000000Z","inspection_violations":[{"id":21451539,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","insp_violation_id":"275224110","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"214373334","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-03T10:02:33.000000Z","updated_at":"2026-07-11T09:41:24.000000Z","normalized_code":"3922SLLIFTA"},{"id":21451540,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","insp_violation_id":"275224111","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"214373334","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-03T10:02:33.000000Z","updated_at":"2026-07-11T09:41:24.000000Z","normalized_code":"3939ALSLI"},{"id":21451541,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","insp_violation_id":"275224112","seq_no":"3","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"214373334","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3324663","created_at":"2026-07-03T10:02:33.000000Z","updated_at":"2026-07-11T09:41:24.000000Z","normalized_code":"3939ALTSIR"},{"id":21451542,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","insp_violation_id":"275224113","seq_no":"4","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3324663","created_at":"2026-07-03T10:02:33.000000Z","updated_at":"2026-07-11T09:41:24.000000Z","normalized_code":"39111B2Q"},{"id":21451543,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","insp_violation_id":"275224114","seq_no":"5","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3324663","created_at":"2026-07-03T10:02:33.000000Z","updated_at":"2026-07-11T09:41:24.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":21405978,"change_date":"2026-06-30 21:40:00","inspection_id":"88283452","insp_unit_id":"214373334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:05.000000Z","updated_at":"2026-07-11T09:02:15.000000Z"}]},{"id":10307425,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","dot_number":"3045831","report_state":"SC","report_number":"0314005509","insp_date":"2025-11-26 00:00:00","insp_start_time":"0939","insp_end_time":"1100","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FORT MILL SC","county_code_state":"SC","county_code":"091","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ANDREAS POOLS INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-30 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2599701","transaction_code":"A","transaction_date":"2025-11-29 00:00:00","upload_date":"2025-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2025-11-30 21:32:00","snet_input_date":"2025-11-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-30 21:32:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-03T10:30:20.000000Z","updated_at":"2025-12-04T10:30:04.000000Z","inspection_violations":[{"id":17240562,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_violation_id":"270341281","seq_no":"5","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"210305376","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"20252421014934","created_at":"2025-12-03T10:30:26.000000Z","updated_at":"2025-12-04T10:30:05.000000Z","normalized_code":"3922SLLIRP"},{"id":17240563,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_violation_id":"270341282","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA94163","created_at":"2025-12-03T10:30:26.000000Z","updated_at":"2025-12-04T10:30:05.000000Z","normalized_code":"3922SLLLR"},{"id":17240564,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_violation_id":"270341283","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"20252421014933","created_at":"2025-12-03T10:30:26.000000Z","updated_at":"2025-12-04T10:30:05.000000Z","normalized_code":"38323A2LCDLN"},{"id":17240565,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_violation_id":"270341284","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"210305376","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA94164","created_at":"2025-12-03T10:30:26.000000Z","updated_at":"2025-12-04T10:30:05.000000Z","normalized_code":"39617CPI"},{"id":17240566,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_violation_id":"270341285","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"210305377","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA94165","created_at":"2025-12-03T10:30:26.000000Z","updated_at":"2025-12-04T10:30:05.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":17211910,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_unit_id":"210305377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"1","insp_unit_license":"CP26559","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"5VGFP2423NL008419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-03T10:00:23.000000Z","updated_at":"2025-12-04T10:00:05.000000Z"},{"id":17211909,"change_date":"2025-11-30 21:32:00","inspection_id":"86433541","insp_unit_id":"210305376","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"LJE5330","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3C7WRMEL1GG348151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-03T10:00:23.000000Z","updated_at":"2025-12-04T10:00:05.000000Z"}]},{"id":9925818,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","dot_number":"3045831","report_state":"NC","report_number":"0006807697","insp_date":"2025-10-10 00:00:00","insp_start_time":"1330","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 40 W","location_desc":"I 40 WB","county_code_state":"NC","county_code":"067","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-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"4","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2336723","transaction_code":"A","transaction_date":"2025-10-10 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-13 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"282695755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:39.000000Z","updated_at":"2025-10-17T10:00:45.000000Z","inspection_violations":[{"id":16380083,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","insp_violation_id":"269263175","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3312610","created_at":"2025-10-16T10:15:57.000000Z","updated_at":"2025-10-17T10:16:06.000000Z","normalized_code":"39111B2Q"},{"id":16380084,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","insp_violation_id":"269263176","seq_no":"2","part_no":"391","part_no_section":"11B4-DEN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3312610","created_at":"2025-10-16T10:15:57.000000Z","updated_at":"2025-10-17T10:16:06.000000Z","normalized_code":"39111B4DEN"},{"id":16380085,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","insp_violation_id":"269263177","seq_no":"3","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3312610","created_at":"2025-10-16T10:15:57.000000Z","updated_at":"2025-10-17T10:16:06.000000Z","normalized_code":"38323A2"},{"id":16380086,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","insp_violation_id":"269263178","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209437732","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:15:57.000000Z","updated_at":"2025-10-17T10:16:06.000000Z","normalized_code":"39395A"},{"id":16380087,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","insp_violation_id":"269263179","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"209437732","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3312610","created_at":"2025-10-16T10:15:57.000000Z","updated_at":"2025-10-17T10:16:06.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":16474063,"change_date":"2025-10-13 21:37:00","inspection_id":"86031546","insp_unit_id":"209437732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"104","insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:55.000000Z","updated_at":"2025-10-17T09:45:52.000000Z"}]},{"id":9884647,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","dot_number":"3045831","report_state":"SC","report_number":"0365003057","insp_date":"2025-10-08 00:00:00","insp_start_time":"0739","insp_end_time":"0810","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GASTON SC","county_code_state":"SC","county_code":"017","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":"U","pen_cen_match":"I","final_status_date":"2025-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2380821","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:43.000000Z","updated_at":"2025-10-12T10:00:39.000000Z","inspection_violations":[{"id":16298421,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168788","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"39141APC"},{"id":16298422,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168789","seq_no":"2","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209357378","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"39395A4EENA"},{"id":16298423,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168790","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"209357378","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"3939ALTSI"},{"id":16298424,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168791","seq_no":"4","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"20252421011889","created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"38323A2LCDLN"},{"id":16298425,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168792","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"209357378","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"3939ALSLI"},{"id":16298426,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168793","seq_no":"6","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"209357378","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"3939ALHWS"},{"id":16298427,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_violation_id":"269168794","seq_no":"7","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:17:56.000000Z","updated_at":"2025-10-12T10:15:49.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":16400555,"change_date":"2025-10-08 21:40:00","inspection_id":"85988299","insp_unit_id":"209357378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"103","insp_unit_license":"ND7581","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1HTMSAAR2BH368721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:10.000000Z","updated_at":"2025-10-12T09:45:47.000000Z"}]},{"id":7114065,"change_date":"2024-11-04 21:40:00","inspection_id":"83071980","dot_number":"3045831","report_state":"NC","report_number":"0006697150","insp_date":"2024-11-04 00:00:00","insp_start_time":"0826","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-04 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":"2229351","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-11-04 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:18.000000Z","updated_at":"2025-03-17T20:44:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11473803,"change_date":"2024-11-04 21:40:00","inspection_id":"83071980","insp_unit_id":"203721177","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"105","insp_unit_license":"NS1175","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFCXLDLJ6219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:51.000000Z","updated_at":"2025-03-17T23:41:51.000000Z"}]},{"id":7071573,"change_date":"2024-10-29 21:42:00","inspection_id":"83026771","dot_number":"3045831","report_state":"NC","report_number":"0006694877","insp_date":"2024-10-25 00:00:00","insp_start_time":"1355","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"I85 SB","location_desc":"I85 SB NEAR YOUNGS MILL RD","county_code_state":"NC","county_code":"081","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-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2227858","transaction_code":"A","transaction_date":"2024-10-28 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-28 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:27.000000Z","updated_at":"2025-03-17T20:43:27.000000Z","inspection_violations":[{"id":11038654,"change_date":"2024-10-29 21:42:00","inspection_id":"83026771","insp_violation_id":"262614119","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203637364","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"39617C"},{"id":11038655,"change_date":"2024-10-29 21:42:00","inspection_id":"83026771","insp_violation_id":"262614120","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"203637364","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"39395A"},{"id":11038656,"change_date":"2024-10-29 21:42:00","inspection_id":"83026771","insp_violation_id":"262614121","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"203637364","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"39395F"},{"id":11038657,"change_date":"2024-10-29 21:42:00","inspection_id":"83026771","insp_violation_id":"262614122","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203637364","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3184196","created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":11404728,"change_date":"2024-10-29 21:42:00","inspection_id":"83026771","insp_unit_id":"203637364","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ND7581","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1HTMSAAR2BH368721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:04.000000Z","updated_at":"2025-03-17T23:41:04.000000Z"}]},{"id":6574470,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","dot_number":"3045831","report_state":"SC","report_number":"H294006164","insp_date":"2024-08-26 00:00:00","insp_start_time":"1145","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"107","location_desc":"I-85 NB ROADSIDE","county_code_state":"SC","county_code":"021","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1160338","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-26 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10217748,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435402","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39021TB"},{"id":10217749,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435403","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA68796","created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39345B2"},{"id":10217750,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435404","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3963A1"},{"id":10217751,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435405","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3963A1"},{"id":10217752,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435406","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3963A1"},{"id":10217753,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435407","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"},{"id":10217754,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435408","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"},{"id":10217755,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_violation_id":"261435409","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202607604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10598949,"change_date":"2024-08-27 21:42:00","inspection_id":"82497906","insp_unit_id":"202607604","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"104","insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:47.000000Z","updated_at":"2025-03-17T23:32:47.000000Z"}]},{"id":5896473,"change_date":"2024-06-25 21:42:00","inspection_id":"81770016","dot_number":"3045831","report_state":"SC","report_number":"H270006170","insp_date":"2024-06-03 00:00:00","insp_start_time":"0546","insp_end_time":"0618","registration_date":"2024-06-25 00:00:00","region":"ET","ci_status_code":"C","location":"016","location_desc":"I-77 SB YORK COUNTY","county_code_state":"SC","county_code":"091","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ANDREA'S POOLS LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1146959","transaction_code":"C","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-06-03 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:30.000000Z","updated_at":"2025-03-17T20:19:30.000000Z","inspection_violations":[{"id":9142927,"change_date":"2024-06-25 21:42:00","inspection_id":"81770016","insp_violation_id":"260296467","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3922"},{"id":9142928,"change_date":"2024-06-25 21:42:00","inspection_id":"81770016","insp_violation_id":"260296468","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201580567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3939A"},{"id":9142929,"change_date":"2024-06-25 21:42:00","inspection_id":"81770016","insp_violation_id":"260296469","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"201580567","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA63831","created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":9497186,"change_date":"2024-06-25 21:42:00","inspection_id":"81770016","insp_unit_id":"201580567","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"104","insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"}]},{"id":5709547,"change_date":"2024-05-09 21:42:00","inspection_id":"81567210","dot_number":"3045831","report_state":"NC","report_number":"0006646100","insp_date":"2024-05-08 00:00:00","insp_start_time":"1530","insp_end_time":"1546","registration_date":null,"region":"ET","ci_status_code":"C","location":"US74 E","location_desc":"US74 EXIT 190","county_code_state":"NC","county_code":"165","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ANDREAS POOL PLASTER","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-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2179653","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-09 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:53.000000Z","updated_at":"2025-03-17T20:15:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9196148,"change_date":"2024-05-09 21:42:00","inspection_id":"81567210","insp_unit_id":"200811172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5470279,"change_date":"2024-04-09 21:41:00","inspection_id":"81306453","dot_number":"3045831","report_state":"NC","report_number":"0006637970","insp_date":"2024-04-08 00:00:00","insp_start_time":"1400","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2171406","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2024-04-09 21:41:00","snet_input_date":"2024-04-09 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-04-09 21:41:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:10.000000Z","updated_at":"2025-03-17T20:11:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8811243,"change_date":"2024-04-09 21:41:00","inspection_id":"81306453","insp_unit_id":"200309596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"104","insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:58.000000Z","updated_at":"2025-03-17T23:14:58.000000Z"}]},{"id":5256239,"change_date":"2024-03-11 21:43:00","inspection_id":"81072990","dot_number":"3045831","report_state":"NC","report_number":"0006630102","insp_date":"2024-03-07 00:00:00","insp_start_time":"1405","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 485","location_desc":"I 485","county_code_state":"NC","county_code":"025","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-03-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2163862","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":null,"census_search_date":"2024-03-11 21:43:00","snet_input_date":"2024-03-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-03-11 21:43:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"282695755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:43.000000Z","updated_at":"2025-03-17T20:06:43.000000Z","inspection_violations":[{"id":8106288,"change_date":"2024-03-11 21:43:00","inspection_id":"81072990","insp_violation_id":"258311490","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"199847845","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3263513","created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"39375A"},{"id":8106289,"change_date":"2024-03-11 21:43:00","inspection_id":"81072990","insp_violation_id":"258311491","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199847845","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8463773,"change_date":"2024-03-11 21:43:00","inspection_id":"81072990","insp_unit_id":"199847845","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:41.000000Z","updated_at":"2025-03-17T23:11:41.000000Z"}]},{"id":4491558,"change_date":"2023-11-27 21:41:00","inspection_id":"80236578","dot_number":"3045831","report_state":"NC","report_number":"0006598552","insp_date":"2023-11-27 00:00:00","insp_start_time":"1050","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2131900","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-11-27 21:41:00","snet_input_date":"2023-11-27 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:49.000000Z","updated_at":"2025-03-17T19:51:49.000000Z","inspection_violations":[{"id":6950882,"change_date":"2023-11-27 21:41:00","inspection_id":"80236578","insp_violation_id":"256556296","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3251469","created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"38351A"}],"inspection_per_units":[{"id":7223394,"change_date":"2023-11-27 21:41:00","inspection_id":"80236578","insp_unit_id":"198207387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"105","insp_unit_license":"NS1175","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFCXLDLJ6219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"}]},{"id":4090064,"change_date":"2023-09-29 21:39:00","inspection_id":"79793012","dot_number":"3045831","report_state":"NC","report_number":"0006579633","insp_date":"2023-09-28 00:00:00","insp_start_time":"1325","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2112892","transaction_code":"A","transaction_date":"2023-09-29 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-09-29 21:39:00","snet_input_date":"2023-09-29 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-09-29 21:39:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:38.000000Z","updated_at":"2025-03-17T19:43:38.000000Z","inspection_violations":[{"id":6330893,"change_date":"2023-09-29 21:39:00","inspection_id":"79793012","insp_violation_id":"255569722","seq_no":"1","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"197315426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39324A"},{"id":6330894,"change_date":"2023-09-29 21:39:00","inspection_id":"79793012","insp_violation_id":"255569723","seq_no":"2","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"197315426","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3176947","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":6575601,"change_date":"2023-09-29 21:39:00","inspection_id":"79793012","insp_unit_id":"197315426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:11.000000Z","updated_at":"2025-03-17T22:55:11.000000Z"}]},{"id":3411577,"change_date":"2023-06-30 21:40:00","inspection_id":"79034712","dot_number":"3045831","report_state":"NC","report_number":"0006551633","insp_date":"2023-06-29 00:00:00","insp_start_time":"1329","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2085397","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:35.000000Z","updated_at":"2025-03-17T19:30:35.000000Z","inspection_violations":[{"id":5259315,"change_date":"2023-06-30 21:40:00","inspection_id":"79034712","insp_violation_id":"253812925","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195777832","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3187671","created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5484938,"change_date":"2023-06-30 21:40:00","inspection_id":"79034712","insp_unit_id":"195777832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"}]},{"id":3384411,"change_date":"2023-06-28 21:42:00","inspection_id":"79004166","dot_number":"3045831","report_state":"NC","report_number":"0006550599","insp_date":"2023-06-28 00:00:00","insp_start_time":"0710","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-40","location_desc":"I-40","county_code_state":"NC","county_code":"135","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-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2084505","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-28 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:08.000000Z","updated_at":"2025-03-17T19:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5440722,"change_date":"2023-06-28 21:42:00","inspection_id":"79004166","insp_unit_id":"195716875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:56.000000Z","updated_at":"2025-03-17T22:45:56.000000Z"}]},{"id":3282438,"change_date":"2023-06-14 21:41:00","inspection_id":"78889445","dot_number":"3045831","report_state":"NC","report_number":"0006545064","insp_date":"2023-06-13 00:00:00","insp_start_time":"1335","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 85 S","location_desc":"I 85 SB NEAR ALAMANCE CHURCH R","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":"2023-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2078862","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-06-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-06-14 21:41:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:06.000000Z","updated_at":"2025-03-17T19:28:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5277502,"change_date":"2023-06-14 21:41:00","inspection_id":"78889445","insp_unit_id":"195491710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:36.000000Z","updated_at":"2025-03-17T22:44:36.000000Z"}]},{"id":3161823,"change_date":"2023-05-30 21:42:00","inspection_id":"78753011","dot_number":"3045831","report_state":"NC","report_number":"0006539736","insp_date":"2023-05-30 00:00:00","insp_start_time":"0702","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2073644","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:41.000000Z","updated_at":"2025-03-17T19:25:41.000000Z","inspection_violations":[{"id":4869574,"change_date":"2023-05-30 21:42:00","inspection_id":"78753011","insp_violation_id":"253131851","seq_no":"1","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"1","insp_unit_id":"195187520","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":5085149,"change_date":"2023-05-30 21:42:00","inspection_id":"78753011","insp_unit_id":"195187520","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:05.000000Z","updated_at":"2025-03-17T22:43:05.000000Z"}]},{"id":2840506,"change_date":"2023-04-19 21:42:00","inspection_id":"78390144","dot_number":"3045831","report_state":"NC","report_number":"0006526204","insp_date":"2023-04-19 00:00:00","insp_start_time":"0801","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2060134","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2023-04-19 21:42:00","snet_input_date":"2023-04-19 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:14.000000Z","updated_at":"2025-03-17T19:19:14.000000Z","inspection_violations":[{"id":4357819,"change_date":"2023-04-19 21:42:00","inspection_id":"78390144","insp_violation_id":"252314900","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194472673","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3132209","created_at":"2025-03-17T21:27:20.000000Z","updated_at":"2025-03-17T21:27:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4571288,"change_date":"2023-04-19 21:42:00","inspection_id":"78390144","insp_unit_id":"194472673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NS1175","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFCXLDLJ6219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:03.000000Z","updated_at":"2025-03-17T22:39:03.000000Z"}]},{"id":1900850,"change_date":"2022-12-08 21:40:00","inspection_id":"77318348","dot_number":"3045831","report_state":"NC","report_number":"0006482899","insp_date":"2022-12-08 00:00:00","insp_start_time":"1155","insp_end_time":"1209","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 40 W","location_desc":"I 40 WB NEAR MT WILLING RD","county_code_state":"NC","county_code":"135","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":"2022-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2016564","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2022-12-08 21:40:00","snet_input_date":"2022-12-08 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:48.000000Z","updated_at":"2025-03-17T19:01:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3058731,"change_date":"2022-12-08 21:40:00","inspection_id":"77318348","insp_unit_id":"192325081","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:56.000000Z","updated_at":"2025-03-17T22:27:56.000000Z"}]},{"id":1782926,"change_date":"2022-11-21 21:40:00","inspection_id":"77183723","dot_number":"3045831","report_state":"NC","report_number":"0006476025","insp_date":"2022-11-17 00:00:00","insp_start_time":"1430","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 85 S","location_desc":"I 85 SB","county_code_state":"NC","county_code":"057","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":"2022-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2010254","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2022-11-21 21:40:00","snet_input_date":"2022-11-21 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-11-21 21:40:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:37.000000Z","updated_at":"2025-03-17T18:59:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2867840,"change_date":"2022-11-21 21:40:00","inspection_id":"77183723","insp_unit_id":"192055170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"104","insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:37.000000Z","updated_at":"2025-03-17T22:26:37.000000Z"}]},{"id":1359505,"change_date":"2022-09-24 21:30:00","inspection_id":"76695791","dot_number":"3045831","report_state":"NC","report_number":"0006459442","insp_date":"2022-09-22 00:00:00","insp_start_time":"1220","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 85 S","location_desc":"I 85 SB","county_code_state":"NC","county_code":"159","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-24 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1993201","transaction_code":"A","transaction_date":"2022-09-24 00:00:00","upload_date":"2022-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2022-09-24 21:30:00","snet_input_date":"2022-09-24 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-09-24 21:30:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:41.000000Z","updated_at":"2025-03-17T18:51:41.000000Z","inspection_violations":[{"id":2151346,"change_date":"2022-09-24 21:30:00","inspection_id":"76695791","insp_violation_id":"248625458","seq_no":"1","part_no":"393","part_no_section":"25(f)","insp_viol_unit":"1","insp_unit_id":"191079095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"39325F"},{"id":2151347,"change_date":"2022-09-24 21:30:00","inspection_id":"76695791","insp_violation_id":"248625459","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191079095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3939A"},{"id":2151348,"change_date":"2022-09-24 21:30:00","inspection_id":"76695791","insp_violation_id":"248625460","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191079095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3939A"},{"id":2151349,"change_date":"2022-09-24 21:30:00","inspection_id":"76695791","insp_violation_id":"248625461","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191079095","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3149471","created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2189050,"change_date":"2022-09-24 21:30:00","inspection_id":"76695791","insp_unit_id":"191079095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"104","insp_unit_license":"NL1727","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1FVHCYBS3CHBP9753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:59.000000Z","updated_at":"2025-03-17T22:21:59.000000Z"}]},{"id":955026,"change_date":"2022-08-03 21:42:00","inspection_id":"76225091","dot_number":"3045831","report_state":"NC","report_number":"0006443666","insp_date":"2022-08-03 00:00:00","insp_start_time":"0810","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-40","location_desc":"I-40","county_code_state":"NC","county_code":"135","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":"Y","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":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1977506","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":"03045831","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":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","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":[{"id":1505317,"change_date":"2022-08-03 21:42:00","inspection_id":"76225091","insp_violation_id":"247487943","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3132809","created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"38323A2"},{"id":1505318,"change_date":"2022-08-03 21:42:00","inspection_id":"76225091","insp_violation_id":"247487944","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":1536537,"change_date":"2022-08-03 21:42:00","inspection_id":"76225091","insp_unit_id":"190112244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"105","insp_unit_license":"NS1175","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFCXLDLJ6219","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":481477,"change_date":"2022-05-25 21:41:00","inspection_id":"75667233","dot_number":"3045831","report_state":"NC","report_number":"0006421847","insp_date":"2022-05-25 00:00:00","insp_start_time":"0715","insp_end_time":"0729","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION I-4","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1955647","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03045831","upload_search_indicator":"M","census_search_date":"2022-05-25 21:41:00","snet_input_date":"2022-05-25 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-05-25 21:41:00","insp_carrier_name":"ANDREA'S POOLS LLC","insp_carrier_street":"3608 ALEXANDER FOREST DR","insp_carrier_city":"CHARLOTTE","insp_carrier_state":"NC","insp_carrier_zip_code":"28269-5755","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:17.000000Z","updated_at":"2025-03-17T18:36:17.000000Z","inspection_violations":[{"id":761799,"change_date":"2022-05-25 21:41:00","inspection_id":"75667233","insp_violation_id":"246067288","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":774191,"change_date":"2022-05-25 21:41:00","inspection_id":"75667233","insp_unit_id":"188907534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"105","insp_unit_license":"NS1175","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"3ALACXFCXLDLJ6219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:57.000000Z","updated_at":"2025-03-17T22:12:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3045831\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3045831\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3045831\/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\/3045831\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}