{"current_page":1,"data":[{"id":11515899,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","dot_number":"1146406","report_state":"LA","report_number":"LADRS09811","insp_date":"2026-03-27 00:00:00","insp_start_time":"0919","insp_end_time":"0951","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SULPHUR LA","county_code_state":"LA","county_code":null,"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"9","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3088484","transaction_code":"A","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":null,"census_search_date":"2026-03-30 21:39:00","snet_input_date":"2026-03-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-30 21:39:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-02T09:46:52.000000Z","updated_at":"2026-04-10T09:30:52.000000Z","inspection_violations":[{"id":19452388,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735094","seq_no":"9","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"212421749","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"39617CPI"},{"id":19452389,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735095","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"212421748","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"39021TB2DOT"},{"id":19452390,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735096","seq_no":"2","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-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"39141APC"},{"id":19452391,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735097","seq_no":"3","part_no":"392","part_no_section":"2-SLLED","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-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"3922SLLED"},{"id":19452392,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735098","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212421748","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"3922SLLSR"},{"id":19452393,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735099","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212421748","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"3922SLLSR"},{"id":19452394,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735100","seq_no":"6","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"212421748","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"39395A1"},{"id":19452395,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735101","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"212421748","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"39395F"},{"id":19452396,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_violation_id":"272735102","seq_no":"8","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212421748","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:16.000000Z","updated_at":"2026-04-09T09:51:16.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19729817,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_unit_id":"212421748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"8","insp_unit_license":"XDH0927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT0SED41825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:39.000000Z","updated_at":"2026-04-10T09:05:19.000000Z"},{"id":19729818,"change_date":"2026-03-30 21:39:00","inspection_id":"87436805","insp_unit_id":"212421749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS PRID","insp_unit_company":"NONE","insp_unit_license":"166736M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HCH2UGT9NB031070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:39.000000Z","updated_at":"2026-04-10T09:05:19.000000Z"}]},{"id":8340061,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","dot_number":"1146406","report_state":"LA","report_number":"LADRS09007","insp_date":"2025-04-09 00:00:00","insp_start_time":"0910","insp_end_time":"1000","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VINTON LA","county_code_state":"LA","county_code":null,"insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25400","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1578426","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:07.000000Z","updated_at":"2025-04-14T10:28:07.000000Z","inspection_violations":[{"id":13131083,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540554","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206242455","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"3922SLLSR"},{"id":13131084,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540555","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206242455","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"39395A1"},{"id":13131085,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540556","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"1","insp_unit_id":"206242455","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"39343DB"},{"id":13131086,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540557","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206242455","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"3922SLLSR"},{"id":13131087,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540558","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"206242456","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"39617CPI"},{"id":13131088,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540559","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206242455","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"39617CPI"},{"id":13131089,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540560","seq_no":"7","part_no":"392","part_no_section":"2-SLLED","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-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"3922SLLED"},{"id":13131090,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_violation_id":"265540561","seq_no":"8","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-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:37.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":13529583,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_unit_id":"206242455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"B7","insp_unit_license":"RZG0931","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8X2AT4NEE81058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:13:05.000000Z","updated_at":"2025-04-14T09:57:16.000000Z"},{"id":13529584,"change_date":"2025-04-10 21:41:00","inspection_id":"84361608","insp_unit_id":"206242456","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS PRID","insp_unit_company":"NONE","insp_unit_license":"J201952","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"7HCGF3528PB044092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:13:05.000000Z","updated_at":"2025-04-14T09:57:16.000000Z"}]},{"id":6836512,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","dot_number":"1146406","report_state":"LA","report_number":"LANV002493","insp_date":"2024-09-25 00:00:00","insp_start_time":"1013","insp_end_time":"1114","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"053","insp_level_id":"2","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"6","oos_total":"4","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1221649","transaction_code":"C","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2024-09-27 21:40:00","snet_input_date":"2024-09-27 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:38.000000Z","updated_at":"2025-03-17T20:38:38.000000Z","inspection_violations":[{"id":10648511,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_violation_id":"262124840","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203213756","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"3922"},{"id":10648512,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_violation_id":"262124841","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"203213756","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"39343"},{"id":10648513,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_violation_id":"262124842","seq_no":"3","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"203213756","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"3929A2"},{"id":10648514,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_violation_id":"262124843","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"3958A1"},{"id":10648515,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_violation_id":"262124844","seq_no":"5","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:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"39141A1"},{"id":10648516,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_violation_id":"262124845","seq_no":"6","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"39115A"}],"inspection_per_units":[{"id":11024855,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_unit_id":"203213756","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"RZG0931","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8X2AT4NEE81058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:09.000000Z","updated_at":"2025-03-17T23:37:09.000000Z"},{"id":11024856,"change_date":"2024-10-01 21:42:00","inspection_id":"82777075","insp_unit_id":"203213757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"NONE","insp_unit_license":"166736M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HCH2UGT9NB031070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:09.000000Z","updated_at":"2025-03-17T23:37:09.000000Z"}]},{"id":5983200,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","dot_number":"1146406","report_state":"LA","report_number":"LADR008362","insp_date":"2024-06-11 00:00:00","insp_start_time":"0910","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"019","insp_level_id":"2","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"30400","viol_total":"9","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1205904","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-13 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:26.000000Z","updated_at":"2025-03-17T20:21:26.000000Z","inspection_violations":[{"id":9282482,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067971","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":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"38323A2"},{"id":9282483,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067972","seq_no":"2","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:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39141A1"},{"id":9282484,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067973","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201378030","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39617C"},{"id":9282485,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067974","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201378030","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"},{"id":9282486,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067975","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201378030","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39395F"},{"id":9282487,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067976","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201378030","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"},{"id":9282488,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067977","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201378031","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39617C"},{"id":9282489,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067978","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201378031","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"},{"id":9282490,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_violation_id":"260067979","seq_no":"10","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"201378030","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":9637115,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_unit_id":"201378030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"B7","insp_unit_license":"RZG0931","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8X2AT4NEE81058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:53.000000Z","updated_at":"2025-03-17T23:22:53.000000Z"},{"id":9637116,"change_date":"2024-06-13 21:42:00","inspection_id":"81864265","insp_unit_id":"201378031","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"NONE","insp_unit_license":"166736M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HCH2UGT9NB031070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:53.000000Z","updated_at":"2025-03-17T23:22:53.000000Z"}]},{"id":5285749,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","dot_number":"1146406","report_state":"LA","report_number":"LADR008249","insp_date":"2024-03-12 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"019","insp_level_id":"2","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25400","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1196163","transaction_code":"C","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-14 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:28.000000Z","updated_at":"2025-03-17T20:07:28.000000Z","inspection_violations":[{"id":8150636,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_violation_id":"258407868","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199934563","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3922"},{"id":8150637,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_violation_id":"258407869","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199934563","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39395A"},{"id":8150638,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_violation_id":"258407870","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199934563","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39395F"},{"id":8150639,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_violation_id":"258407871","seq_no":"4","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199934564","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39343"},{"id":8150640,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_violation_id":"258407872","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199934564","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39617C"},{"id":8150641,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_violation_id":"258407873","seq_no":"6","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:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":8511756,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_unit_id":"199934563","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"B7","insp_unit_license":"RZG0931","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8X2AT4NEE81058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"},{"id":8511757,"change_date":"2024-03-15 21:40:00","inspection_id":"81105028","insp_unit_id":"199934564","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"NONE","insp_unit_license":"L201951","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"7HCH2UGT5PB044093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"}]},{"id":3827521,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","dot_number":"1146406","report_state":"TX","report_number":"V231032697","insp_date":"2023-08-21 00:00:00","insp_start_time":"1056","insp_end_time":"1216","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX12 AT EVANGELINE L","county_code_state":"TX","county_code":"361","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COMPANY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"12","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9060442","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2023-08-24 21:42:00","snet_input_date":"2023-08-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-24 21:42:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0930382","created_at":"2025-03-17T19:38:30.000000Z","updated_at":"2025-03-17T19:38:30.000000Z","inspection_violations":[{"id":5911140,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875776","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":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"38323A2"},{"id":5911141,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875777","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"196720671","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39021A"},{"id":5911142,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875778","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39141A"},{"id":5911143,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875779","seq_no":"4","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"1","insp_unit_id":"196720671","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39343D"},{"id":5911144,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875780","seq_no":"5","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"196720672","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39375A"},{"id":5911145,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875781","seq_no":"6","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"196720672","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39375A"},{"id":5911146,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875782","seq_no":"7","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"2","insp_unit_id":"196720672","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39375G"},{"id":5911147,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875783","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196720671","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39378"},{"id":5911148,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875784","seq_no":"9","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196720671","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39395A"},{"id":5911149,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875785","seq_no":"10","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196720671","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39395F"},{"id":5911150,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875786","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196720671","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39617C"},{"id":5911151,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_violation_id":"254875787","seq_no":"12","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196720672","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6154073,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_unit_id":"196720671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"B7","insp_unit_license":"RZG0931","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8X2AT4NEE81058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"},{"id":6154074,"change_date":"2023-08-24 21:42:00","inspection_id":"79500716","insp_unit_id":"196720672","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"905130K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HCK2FGD2MB021439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"}]},{"id":3831273,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","dot_number":"1146406","report_state":"LA","report_number":"LADR007880","insp_date":"2023-08-16 00:00:00","insp_start_time":"1329","insp_end_time":"1414","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"019","insp_level_id":"2","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1178087","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":null,"census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-23 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:32.000000Z","updated_at":"2025-03-17T19:38:32.000000Z","inspection_violations":[{"id":5916831,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_violation_id":"254885641","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":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"38323A2"},{"id":5916832,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_violation_id":"254885642","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196728755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39021TB"},{"id":5916833,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_violation_id":"254885643","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196728755","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"3922"},{"id":5916834,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_violation_id":"254885644","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"196728755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"3969D2"},{"id":5916835,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_violation_id":"254885645","seq_no":"5","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"196728755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"39019B2"},{"id":5916836,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_violation_id":"254885646","seq_no":"6","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"1","insp_unit_id":"196728755","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":6159790,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_unit_id":"196728755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"NONE","insp_unit_license":"RCW6700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRSBJ9MG649687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:44.000000Z","updated_at":"2025-03-17T22:51:44.000000Z"},{"id":6159791,"change_date":"2023-08-25 21:41:00","inspection_id":"79504891","insp_unit_id":"196728756","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"NONE","insp_unit_license":"18347697","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"7HCH2UGT5PB044093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:44.000000Z","updated_at":"2025-03-17T22:51:44.000000Z"}]},{"id":3341175,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","dot_number":"1146406","report_state":"LA","report_number":"LAID006098","insp_date":"2023-06-20 00:00:00","insp_start_time":"1512","insp_end_time":"1621","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"001","insp_level_id":"1","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"8","oos_total":"3","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1171998","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:18.000000Z","updated_at":"2025-03-17T19:29:18.000000Z","inspection_violations":[{"id":5151900,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639460","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":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"38323A2"},{"id":5151901,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639461","seq_no":"2","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39115A"},{"id":5151902,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639462","seq_no":"3","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:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39141A1"},{"id":5151903,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639463","seq_no":"4","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"195620867","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39021TA"},{"id":5151904,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639464","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195620867","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39617C"},{"id":5151905,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639465","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195620867","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"3922"},{"id":5151906,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639466","seq_no":"7","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"195620868","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39343"},{"id":5151907,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_violation_id":"253639467","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195620868","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5371379,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_unit_id":"195620867","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"NONE","insp_unit_license":"RCW6700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRSBJ9MG649687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:23.000000Z","updated_at":"2025-03-17T22:45:23.000000Z"},{"id":5371380,"change_date":"2023-06-22 21:41:00","inspection_id":"78955614","insp_unit_id":"195620868","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"NONE","insp_unit_license":"VIN4093","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"7HCH2UGT5PB044093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:23.000000Z","updated_at":"2025-03-17T22:45:23.000000Z"}]},{"id":2632254,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","dot_number":"1146406","report_state":"LA","report_number":"LANV001563","insp_date":"2023-03-21 00:00:00","insp_start_time":"1622","insp_end_time":"1644","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"053","insp_level_id":"1","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","viol_total":"6","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1161936","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2023-03-22 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:12.000000Z","updated_at":"2025-03-17T19:15:12.000000Z","inspection_violations":[{"id":4046669,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_violation_id":"251799157","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":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"38323A2"},{"id":4046670,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_violation_id":"251799158","seq_no":"2","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:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"39141A1"},{"id":4046671,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_violation_id":"251799159","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3958A1"},{"id":4046672,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_violation_id":"251799160","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193998313","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3922"},{"id":4046673,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_violation_id":"251799161","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193998313","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"39021TB"},{"id":4046674,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_violation_id":"251799162","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193998313","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4237174,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_unit_id":"193998313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"RCW6700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRSBJ9MG649687","insp_unit_decal":"Y","insp_unit_decal_number":"32331274","created_at":"2025-03-17T22:36:24.000000Z","updated_at":"2025-03-17T22:36:24.000000Z"},{"id":4237175,"change_date":"2023-03-22 21:42:00","inspection_id":"78153119","insp_unit_id":"193998314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"1T","insp_unit_license":"905131K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HCGF3528MB021441","insp_unit_decal":"Y","insp_unit_decal_number":"32331275","created_at":"2025-03-17T22:36:24.000000Z","updated_at":"2025-03-17T22:36:24.000000Z"}]},{"id":2306617,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","dot_number":"1146406","report_state":"TX","report_number":"6I6B0XUQ7J","insp_date":"2023-01-30 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39990","viol_total":"11","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8896854","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01146406","upload_search_indicator":"M","census_search_date":"2023-02-06 21:41:00","snet_input_date":"2023-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-06 21:41:00","insp_carrier_name":"AQUAMARINE POOLS OF HOUSTON LLC","insp_carrier_street":"25730 I 45 NORTH","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0930382","created_at":"2025-03-17T19:09:14.000000Z","updated_at":"2025-03-17T19:09:14.000000Z","inspection_violations":[{"id":3555318,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974157","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39348A"},{"id":3555319,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974158","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39348A"},{"id":3555320,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974159","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39348A"},{"id":3555321,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974160","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39348A"},{"id":3555322,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974161","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3963A1"},{"id":3555323,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974162","seq_no":"6","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"193250744","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39021A"},{"id":3555324,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974163","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193250744","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39395A"},{"id":3555325,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974164","seq_no":"8","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"193250744","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39395B"},{"id":3555326,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974165","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193250744","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39617C"},{"id":3555327,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974166","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39617C"},{"id":3555328,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_violation_id":"250974167","seq_no":"13","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"193250745","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":3713193,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_unit_id":"193250744","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"RCW6700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRSBJ9MG649687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:35.000000Z","updated_at":"2025-03-17T22:32:35.000000Z"},{"id":3713194,"change_date":"2023-02-06 21:41:00","inspection_id":"77782381","insp_unit_id":"193250745","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"905130K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HCK2FGD2MB021439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:35.000000Z","updated_at":"2025-03-17T22:32:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1146406\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1146406\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1146406\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1146406\/inspections","per_page":100,"prev_page_url":null,"to":10,"total":10}