{"current_page":1,"data":[{"id":12627576,"change_date":"2026-08-11 21:40:00","inspection_id":"88598482","dot_number":"1078689","report_state":"NY","report_number":"SPA3051735","insp_date":"2026-07-28 00:00:00","insp_start_time":"1602","insp_end_time":"1614","registration_date":"2026-08-10 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH TONAWANDA NY","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MAJESTIC POOLS","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-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3900614","transaction_code":"C","transaction_date":"2026-08-03 00:00:00","upload_date":"2026-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2026-08-04 21:39:00","snet_input_date":"2026-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-04 21:39:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-07T09:39:38.000000Z","updated_at":"2026-08-15T09:39:38.000000Z","inspection_violations":[{"id":21984898,"change_date":"2026-08-11 21:40:00","inspection_id":"88598482","insp_violation_id":"276054359","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:09.000000Z","updated_at":"2026-08-15T09:59:57.000000Z","normalized_code":"39141APC"},{"id":21984899,"change_date":"2026-08-11 21:40:00","inspection_id":"88598482","insp_violation_id":"276054360","seq_no":"2","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"215089329","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:09.000000Z","updated_at":"2026-08-15T09:59:57.000000Z","normalized_code":"39381H"},{"id":21984900,"change_date":"2026-08-11 21:40:00","inspection_id":"88598482","insp_violation_id":"276054361","seq_no":"3","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"215089329","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:09.000000Z","updated_at":"2026-08-15T09:59:57.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":21921118,"change_date":"2026-08-11 21:40:00","inspection_id":"88598482","insp_unit_id":"215089329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"8","insp_unit_license":"25389ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDLF47F9VEC19090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:17.000000Z","updated_at":"2026-08-15T09:14:46.000000Z"}]},{"id":12158192,"change_date":"2026-07-07 21:40:00","inspection_id":"88107735","dot_number":"1078689","report_state":"NY","report_number":"SPA3051617","insp_date":"2026-06-04 00:00:00","insp_start_time":"0822","insp_end_time":"0911","registration_date":"2026-07-06 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"CLARENCE NY","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MAJESTIC POOLS","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":"2026-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3518223","transaction_code":"C","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2026-06-11 21:41:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:41:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:29.000000Z","updated_at":"2026-07-18T09:30:09.000000Z","inspection_violations":[{"id":21160390,"change_date":"2026-07-07 21:40:00","inspection_id":"88107735","insp_violation_id":"275327734","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214469327","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:02:40.000000Z","updated_at":"2026-07-18T09:41:17.000000Z","normalized_code":"3922SLLSR"},{"id":21160392,"change_date":"2026-07-07 21:40:00","inspection_id":"88107735","insp_violation_id":"275327736","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"214469327","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:02:40.000000Z","updated_at":"2026-07-18T09:41:17.000000Z","normalized_code":"3922SLLIFTA"},{"id":21160391,"change_date":"2026-07-07 21:40:00","inspection_id":"88107735","insp_violation_id":"275327735","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWPB","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S260912141","created_at":"2026-06-15T10:02:40.000000Z","updated_at":"2026-07-18T09:41:17.000000Z","normalized_code":"3922SLLEWPB"},{"id":21160393,"change_date":"2026-07-07 21:40:00","inspection_id":"88107735","insp_violation_id":"275327737","seq_no":"4","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:02:40.000000Z","updated_at":"2026-07-18T09:41:17.000000Z","normalized_code":"3922WG"}],"inspection_per_units":[{"id":21119846,"change_date":"2026-07-07 21:40:00","inspection_id":"88107735","insp_unit_id":"214469327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"99241ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGLA6T0NH441104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:16.000000Z","updated_at":"2026-07-18T09:01:05.000000Z"}]},{"id":11994490,"change_date":"2026-07-07 21:40:00","inspection_id":"87932603","dot_number":"1078689","report_state":"NY","report_number":"5L47000437","insp_date":"2026-05-18 00:00:00","insp_start_time":"1217","insp_end_time":"1235","registration_date":"2026-07-06 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER NY","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"3384338","transaction_code":"C","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:13.000000Z","updated_at":"2026-07-18T09:30:04.000000Z","inspection_violations":[{"id":20867384,"change_date":"2026-07-07 21:40:00","inspection_id":"87932603","insp_violation_id":"275328427","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"214470056","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:43.000000Z","updated_at":"2026-07-18T09:41:22.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20851456,"change_date":"2026-07-07 21:40:00","inspection_id":"87932603","insp_unit_id":"214470056","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"25384ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDAF57P66EC06630","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:19.000000Z","updated_at":"2026-07-18T09:01:05.000000Z"}]},{"id":10213385,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","dot_number":"1078689","report_state":"NY","report_number":"D507901815","insp_date":"2025-11-10 00:00:00","insp_start_time":"1002","insp_end_time":"1027","registration_date":"2025-11-17 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"LANCASTER NY","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2550018","transaction_code":"C","transaction_date":"2025-11-16 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2025-11-17 21:39:00","snet_input_date":"2025-11-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-17 21:39:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:27.000000Z","updated_at":"2025-11-23T10:30:13.000000Z","inspection_violations":[{"id":16997067,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_violation_id":"270025844","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-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"39141APC"},{"id":16997068,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_violation_id":"270025845","seq_no":"2","part_no":"393","part_no_section":"75B-TFV","insp_viol_unit":"1","insp_unit_id":"210087467","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"39375BTFV"},{"id":16997069,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_violation_id":"270025846","seq_no":"3","part_no":"172","part_no_section":"401B-HML","insp_viol_unit":"1","insp_unit_id":"210087467","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"172401BHML"},{"id":16997070,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_violation_id":"270025847","seq_no":"4","part_no":"393","part_no_section":"75B-TFV","insp_viol_unit":"1","insp_unit_id":"210087467","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"39375BTFV"},{"id":16997071,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_violation_id":"270025848","seq_no":"5","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"210087467","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"3939AHLLH"},{"id":16997072,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_violation_id":"270025849","seq_no":"6","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210087467","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":17036538,"change_date":"2025-11-18 21:38:00","inspection_id":"86334789","insp_unit_id":"210087467","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"74315NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GD37TCG2G1270494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:49.000000Z","updated_at":"2025-11-23T10:00:17.000000Z"}]},{"id":9446951,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","dot_number":"1078689","report_state":"NY","report_number":"D507704982","insp_date":"2025-08-18 00:00:00","insp_start_time":"0931","insp_end_time":"0953","registration_date":"2025-08-25 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BLASDELL NY","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21900","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2148399","transaction_code":"C","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:22.000000Z","updated_at":"2025-09-16T10:46:24.000000Z","inspection_violations":[{"id":15800124,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604369","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208868617","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"39617CPI"},{"id":15800125,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604370","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208868616","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"3922SLLSR"},{"id":15800126,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604371","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"208868616","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"3922SLLIFTA"},{"id":15800127,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604372","seq_no":"4","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"208868616","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"39381H"},{"id":15800128,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604373","seq_no":"5","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"208868617","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"39348ABIHE"},{"id":15800129,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604374","seq_no":"6","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"208868617","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"39343DB"},{"id":15800130,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_violation_id":"268604375","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208868617","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-14T11:56:42.000000Z","updated_at":"2025-09-14T11:56:42.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15944043,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_unit_id":"208868616","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"86433MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDAF56S32EC80152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:31.000000Z","updated_at":"2025-09-15T09:52:47.000000Z"},{"id":15944044,"change_date":"2025-09-11 21:41:00","inspection_id":"85528896","insp_unit_id":"208868617","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CC38730","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4TCSS2187RA020551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:31.000000Z","updated_at":"2025-09-15T09:52:47.000000Z"}]},{"id":7235509,"change_date":"2024-11-20 21:40:00","inspection_id":"83200359","dot_number":"1078689","report_state":"NY","report_number":"SPA3060131","insp_date":"2024-11-13 00:00:00","insp_start_time":"1355","insp_end_time":"1423","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BUFFALO NY","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MAJESTIC POOLS & SPAS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15120","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1072396","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[{"id":11310477,"change_date":"2024-11-20 21:40:00","inspection_id":"83200359","insp_violation_id":"262989767","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLL"},{"id":11310478,"change_date":"2024-11-20 21:40:00","inspection_id":"83200359","insp_violation_id":"262989768","seq_no":"2","part_no":"393","part_no_section":"110B2II-C","insp_viol_unit":"2","insp_unit_id":"203964172","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"393110B2IIC"}],"inspection_per_units":[{"id":11670691,"change_date":"2024-11-20 21:40:00","inspection_id":"83200359","insp_unit_id":"203964172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KARAVAN TR","insp_unit_company":null,"insp_unit_license":"CE38011","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KTSC242X1F007697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"},{"id":11670692,"change_date":"2024-11-20 21:40:00","inspection_id":"83200359","insp_unit_id":"203964173","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"40435MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDKE37H2THB63001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":7066641,"change_date":"2024-10-29 21:41:00","inspection_id":"83021473","dot_number":"1078689","report_state":"NY","report_number":"5L47000102","insp_date":"2024-10-28 00:00:00","insp_start_time":"1407","insp_end_time":"1443","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER NY","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15120","viol_total":"3","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":"995125","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:25.000000Z","updated_at":"2025-03-17T20:43:25.000000Z","inspection_violations":[{"id":11031102,"change_date":"2024-10-29 21:41:00","inspection_id":"83021473","insp_violation_id":"262602675","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"203627344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":11031103,"change_date":"2024-10-29 21:41:00","inspection_id":"83021473","insp_violation_id":"262602676","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"203627345","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3939ALLPL"},{"id":11031104,"change_date":"2024-10-29 21:41:00","inspection_id":"83021473","insp_violation_id":"262602677","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"203627345","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":11397007,"change_date":"2024-10-29 21:41:00","inspection_id":"83021473","insp_unit_id":"203627344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"60","insp_unit_license":"40435MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDKE37H2THB63001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:00.000000Z","updated_at":"2025-03-17T23:41:00.000000Z"},{"id":11397008,"change_date":"2024-10-29 21:41:00","inspection_id":"83021473","insp_unit_id":"203627345","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KARAVAN TR","insp_unit_company":null,"insp_unit_license":"CE38011","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KTSC242X1F007697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:00.000000Z","updated_at":"2025-03-17T23:41:00.000000Z"}]},{"id":6162487,"change_date":"2024-07-08 21:42:00","inspection_id":"82057307","dot_number":"1078689","report_state":"NY","report_number":"SPA0360512","insp_date":"2024-07-02 00:00:00","insp_start_time":"0803","insp_end_time":"0826","registration_date":null,"region":"ET","ci_status_code":"C","location":"50448","location_desc":"LANCASTER","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MAJESTIC POOLS 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":null,"final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"2934701","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":"M","census_search_date":"2024-07-08 21:42:00","snet_input_date":"2024-07-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:58.000000Z","updated_at":"2025-03-17T20:24:58.000000Z","inspection_violations":[{"id":9565496,"change_date":"2024-07-08 21:42:00","inspection_id":"82057307","insp_violation_id":"260503870","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39141A"},{"id":9565497,"change_date":"2024-07-08 21:42:00","inspection_id":"82057307","insp_violation_id":"260503871","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"201766640","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39021B"},{"id":9565498,"change_date":"2024-07-08 21:42:00","inspection_id":"82057307","insp_violation_id":"260503872","seq_no":"3","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"201766640","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":9926780,"change_date":"2024-07-08 21:42:00","inspection_id":"82057307","insp_unit_id":"201766640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"8","insp_unit_license":"25389ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDLF47F9VEC19090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:54.000000Z","updated_at":"2025-03-17T23:25:54.000000Z"}]},{"id":5882173,"change_date":"2024-05-31 21:38:00","inspection_id":"81754117","dot_number":"1078689","report_state":"NY","report_number":"D507005159","insp_date":"2024-05-30 00:00:00","insp_start_time":"1331","insp_end_time":"1359","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER NY","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-31 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"528679","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":null,"census_search_date":"2024-05-31 21:38:00","snet_input_date":"2024-05-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-31 21:38:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:25.000000Z","updated_at":"2025-03-17T20:19:25.000000Z","inspection_violations":[{"id":9119885,"change_date":"2024-05-31 21:38:00","inspection_id":"81754117","insp_violation_id":"259826008","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"201167030","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"39348A"},{"id":9119886,"change_date":"2024-05-31 21:38:00","inspection_id":"81754117","insp_violation_id":"259826009","seq_no":"2","part_no":"392","part_no_section":"7(a)","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:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"3927A"},{"id":9119887,"change_date":"2024-05-31 21:38:00","inspection_id":"81754117","insp_violation_id":"259826010","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201167030","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"3939A"},{"id":9119888,"change_date":"2024-05-31 21:38:00","inspection_id":"81754117","insp_violation_id":"259826011","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201167030","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9473860,"change_date":"2024-05-31 21:38:00","inspection_id":"81754117","insp_unit_id":"201167030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"WHITE","insp_unit_license":"99241ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTGLA6T0NH441104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":5585063,"change_date":"2024-04-24 21:41:00","inspection_id":"81431649","dot_number":"1078689","report_state":"NY","report_number":"SPT0356896","insp_date":"2024-04-23 00:00:00","insp_start_time":"1047","insp_end_time":"1116","registration_date":null,"region":"ET","ci_status_code":"C","location":"50830A","location_desc":"TONAWANDA (S GRAND IS. BR)","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MAJESTIC POOLS","shipping_paper_number":"S431458","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-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2919272","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":"M","census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:29.000000Z","updated_at":"2025-03-17T20:13:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8996156,"change_date":"2024-04-24 21:41:00","inspection_id":"81431649","insp_unit_id":"200548053","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4125","insp_unit_license":"25387ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2P264CX2M034180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"}]},{"id":1092645,"change_date":"2022-08-22 21:41:00","inspection_id":"76385860","dot_number":"1078689","report_state":"NY","report_number":"SPA0274737","insp_date":"2022-08-09 00:00:00","insp_start_time":"1255","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2742358","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":"M","census_search_date":"2022-08-22 21:41:00","snet_input_date":"2022-08-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-22 21:41:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:55.000000Z","updated_at":"2025-03-17T18:46:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1757145,"change_date":"2022-08-22 21:41:00","inspection_id":"76385860","insp_unit_id":"190440515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"75360NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJG31R9Y1122834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:06.000000Z","updated_at":"2025-03-17T22:19:06.000000Z"}]},{"id":992831,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","dot_number":"1078689","report_state":"NY","report_number":"0518000526","insp_date":"2022-08-05 00:00:00","insp_start_time":"0957","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":"50152","location_desc":"CHEEKTOWAGA 1","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17620","viol_total":"13","oos_total":"6","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"11","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2736016","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":"M","census_search_date":"2022-08-09 21:40:00","snet_input_date":"2022-08-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-09 21:40:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:07.000000Z","updated_at":"2025-03-17T18:45:07.000000Z","inspection_violations":[{"id":1565242,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592865","seq_no":"1","part_no":"392","part_no_section":"9","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3929"},{"id":1565243,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592866","seq_no":"2","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3927A"},{"id":1565244,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592867","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190202567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3939A"},{"id":1565245,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592868","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190202567","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39345B2"},{"id":1565246,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592869","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39617C"},{"id":1565247,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592870","seq_no":"7","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CH18FQQ8QN","created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39343D"},{"id":1565248,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592871","seq_no":"8","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"393110"},{"id":1565249,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592872","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CH18FQQ9F0","created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3939A"},{"id":1565250,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592873","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3939A"},{"id":1565251,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592874","seq_no":"11","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39311"},{"id":1565252,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592875","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3939A"},{"id":1565253,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592876","seq_no":"13","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"393201A"},{"id":1565254,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_violation_id":"247592877","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190202568","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1597597,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_unit_id":"190202567","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"92879NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB4KZCG2EF142741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:04.000000Z","updated_at":"2025-03-17T22:18:04.000000Z"},{"id":1597598,"change_date":"2022-08-09 21:40:00","inspection_id":"76269080","insp_unit_id":"190202568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KARA","insp_unit_company":null,"insp_unit_license":"CE38011","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KTSC242X1F007697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:04.000000Z","updated_at":"2025-03-17T22:18:04.000000Z"}]},{"id":786076,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","dot_number":"1078689","report_state":"NY","report_number":"0519000289","insp_date":"2022-07-08 00:00:00","insp_start_time":"0949","insp_end_time":"1034","registration_date":null,"region":"ET","ci_status_code":"C","location":"50448","location_desc":"LANCASTER","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2725653","transaction_code":"A","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":"M","census_search_date":"2022-07-11 21:41:00","snet_input_date":"2022-07-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-11 21:41:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:34.000000Z","updated_at":"2025-03-17T18:41:34.000000Z","inspection_violations":[{"id":1239669,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992686","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"39375A3"},{"id":1239670,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992687","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"3939A"},{"id":1239671,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992688","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"39378"},{"id":1239672,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992689","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"39311"},{"id":1239673,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992690","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"39345B2"},{"id":1239674,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992691","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"3963A1"},{"id":1239675,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992692","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"39348A"},{"id":1239676,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_violation_id":"246992693","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189691564","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1264589,"change_date":"2022-07-11 21:41:00","inspection_id":"76027200","insp_unit_id":"189691564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"32200NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2M2P138C1HC015053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"}]},{"id":190978,"change_date":"2022-04-18 21:39:00","inspection_id":"75320736","dot_number":"1078689","report_state":"NY","report_number":"0519000021","insp_date":"2022-04-15 00:00:00","insp_start_time":"1019","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"50448","location_desc":"LANCASTER","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2696132","transaction_code":"A","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01078689","upload_search_indicator":"M","census_search_date":"2022-04-18 21:39:00","snet_input_date":"2022-04-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-18 21:39:00","insp_carrier_name":"MAJESTIC POOLS INC","insp_carrier_street":"4370 WALDEN AVE","insp_carrier_city":"LANCASTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14086","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:52.000000Z","updated_at":"2025-03-17T18:30:52.000000Z","inspection_violations":[{"id":291908,"change_date":"2022-04-18 21:39:00","inspection_id":"75320736","insp_violation_id":"245201622","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":309243,"change_date":"2022-04-18 21:39:00","inspection_id":"75320736","insp_unit_id":"188190058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"30505NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GD37TCG2G1270494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:03.000000Z","updated_at":"2025-03-17T22:10:03.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1078689\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1078689\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1078689\/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\/1078689\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}