{"current_page":1,"data":[{"id":12019868,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","dot_number":"1706080","report_state":"TX","report_number":"7FQB9DNNAN","insp_date":"2026-05-22 00:00:00","insp_start_time":"1148","insp_end_time":"1238","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEFCO ENTERPRISES","shipping_paper_number":"J267213","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9967798","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-26 21:40:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2026-05-29T09:40:01.000000Z","updated_at":"2026-06-06T09:32:09.000000Z","inspection_violations":[{"id":20912742,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505242","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213756937","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"3922RG"},{"id":20912743,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505243","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213756938","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"3922RG"},{"id":20912744,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505244","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213756938","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"3922RG"},{"id":20912745,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505245","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213756937","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"39617C"},{"id":20912746,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505246","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213756938","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"39617C"},{"id":20912747,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505247","seq_no":"6","part_no":"393","part_no_section":"75A2","insp_viol_unit":"1","insp_unit_id":"213756937","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"39375A2"},{"id":20912748,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_violation_id":"274505248","seq_no":"7","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"213756937","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-29T09:59:40.000000Z","updated_at":"2026-06-06T09:44:26.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":20893205,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_unit_id":"213756937","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:40.000000Z","updated_at":"2026-06-06T09:04:20.000000Z"},{"id":20893206,"change_date":"2026-05-26 21:40:00","inspection_id":"87959421","insp_unit_id":"213756938","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:40.000000Z","updated_at":"2026-06-06T09:04:20.000000Z"}]},{"id":11251758,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","dot_number":"1706080","report_state":"TX","report_number":"7D5A9DRB55","insp_date":"2026-02-18 00:00:00","insp_start_time":"1051","insp_end_time":"1106","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN WALLER CO. (794-804","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENERGY ALLOY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9865346","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-02-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-27 21:42:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2026-03-02T10:39:50.000000Z","updated_at":"2026-03-10T09:31:29.000000Z","inspection_violations":[{"id":18904505,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100342","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211887839","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:00.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"39360C"},{"id":18904506,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100343","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"211887839","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:00.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"3939TS"},{"id":18904507,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100344","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211887839","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:00.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"3939"},{"id":18904508,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100345","seq_no":"4","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"211887840","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:00.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"39355E"},{"id":18904509,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100346","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211887839","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:01.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"39617C"},{"id":18904510,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100347","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"211887840","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:01.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"39617C"},{"id":18904511,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_violation_id":"272100348","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211887840","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:01.000000Z","updated_at":"2026-03-10T09:44:45.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19238657,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_unit_id":"211887839","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:28.000000Z","updated_at":"2026-03-10T09:06:13.000000Z"},{"id":19238658,"change_date":"2026-02-27 21:42:00","inspection_id":"87165048","insp_unit_id":"211887840","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:28.000000Z","updated_at":"2026-03-10T09:06:13.000000Z"}]},{"id":9206326,"change_date":"2025-07-21 21:41:00","inspection_id":"85275817","dot_number":"1706080","report_state":"TX","report_number":"773C9DGBQE","insp_date":"2025-07-15 00:00:00","insp_start_time":"1151","insp_end_time":"1225","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"9643817","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-07-25T10:45:32.000000Z","updated_at":"2025-07-25T10:45:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15135030,"change_date":"2025-07-21 21:41:00","inspection_id":"85275817","insp_unit_id":"207989161","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32562","insp_unit_license":"R234527","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK67DX37247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:38.000000Z","updated_at":"2025-07-25T09:46:11.000000Z"},{"id":15135031,"change_date":"2025-07-21 21:41:00","inspection_id":"85275817","insp_unit_id":"207989162","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"A1022","insp_unit_license":"224248C","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"13N1482C4J1524483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:38.000000Z","updated_at":"2025-07-25T09:46:11.000000Z"}]},{"id":9485823,"change_date":"2025-08-22 21:39:00","inspection_id":"85569724","dot_number":"1706080","report_state":"TX","report_number":"7858HQE1LH","insp_date":"2025-06-19 00:00:00","insp_start_time":"0911","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN GALVESTON CO. (502-","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":"5883515-001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9675138","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-22 21:39:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-08-25T10:43:27.000000Z","updated_at":"2025-08-26T10:46:00.000000Z","inspection_violations":[{"id":15461498,"change_date":"2025-08-22 21:39:00","inspection_id":"85569724","insp_violation_id":"268200164","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"208541631","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-25T10:45:48.000000Z","updated_at":"2025-08-26T10:47:40.000000Z","normalized_code":"393100A"},{"id":15461499,"change_date":"2025-08-22 21:39:00","inspection_id":"85569724","insp_violation_id":"268200165","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"208541631","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-25T10:45:48.000000Z","updated_at":"2025-08-26T10:47:40.000000Z","normalized_code":"3939H"},{"id":15461500,"change_date":"2025-08-22 21:39:00","inspection_id":"85569724","insp_violation_id":"268200166","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208541631","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-25T10:45:48.000000Z","updated_at":"2025-08-26T10:47:40.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":15647500,"change_date":"2025-08-22 21:39:00","inspection_id":"85569724","insp_unit_id":"208541631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TZS2648","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVACXDA24HN00213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:45.000000Z","updated_at":"2025-08-26T09:46:17.000000Z"}]},{"id":7896027,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","dot_number":"1706080","report_state":"TX","report_number":"72TC9DJX1R","insp_date":"2025-02-11 00:00:00","insp_start_time":"1205","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9499534","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[{"id":12337197,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_violation_id":"264567373","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205374793","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"39378"},{"id":12337198,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_violation_id":"264567374","seq_no":"2","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"205374793","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"39355D1"},{"id":12337199,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_violation_id":"264567375","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205374793","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"3939"},{"id":12337200,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_violation_id":"264567376","seq_no":"4","part_no":"393","part_no_section":"104F3","insp_viol_unit":"2","insp_unit_id":"205374794","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"393104F3"},{"id":12337201,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_violation_id":"264567377","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"205374794","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":12745339,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_unit_id":"205374793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0716","insp_unit_license":"R300939","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGBDV2ALAN6261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"},{"id":12745340,"change_date":"2025-02-18 21:40:00","inspection_id":"83894748","insp_unit_id":"205374794","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"224251C","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"13N1482C7J1524493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"}]},{"id":7383418,"change_date":"2024-12-12 21:42:00","inspection_id":"83356353","dot_number":"1706080","report_state":"TX","report_number":"V241684415","insp_date":"2024-11-26 00:00:00","insp_start_time":"0814","insp_end_time":"0847","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A101","location_desc":"IH10 EB BROOKSHIRE SCALE","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BELLVILLE TUBE","shipping_paper_number":"005279","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9443858","transaction_code":"C","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-10 21:42:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T20:50:16.000000Z","updated_at":"2025-03-17T20:50:16.000000Z","inspection_violations":[{"id":11535277,"change_date":"2024-12-12 21:42:00","inspection_id":"83356353","insp_violation_id":"263428451","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204353818","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":11910541,"change_date":"2024-12-12 21:42:00","inspection_id":"83356353","insp_unit_id":"204353818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:32.000000Z","updated_at":"2025-03-17T23:46:32.000000Z"},{"id":11910542,"change_date":"2024-12-12 21:42:00","inspection_id":"83356353","insp_unit_id":"204353819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"001-T","insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:32.000000Z","updated_at":"2025-03-17T23:46:32.000000Z"}]},{"id":6668355,"change_date":"2024-09-06 21:41:00","inspection_id":"82598004","dot_number":"1706080","report_state":"TX","report_number":"6YD89DNA4N","insp_date":"2024-09-04 00:00:00","insp_start_time":"0745","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  KATY FT BEND R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9371193","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-06 21:41:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T20:35:13.000000Z","updated_at":"2025-03-17T20:35:13.000000Z","inspection_violations":[{"id":10377503,"change_date":"2024-09-06 21:41:00","inspection_id":"82598004","insp_violation_id":"261664563","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"202803867","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10751526,"change_date":"2024-09-06 21:41:00","inspection_id":"82598004","insp_unit_id":"202803866","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:20.000000Z","updated_at":"2025-03-17T23:34:20.000000Z"},{"id":10751527,"change_date":"2024-09-06 21:41:00","inspection_id":"82598004","insp_unit_id":"202803867","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"GC001","insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:20.000000Z","updated_at":"2025-03-17T23:34:20.000000Z"}]},{"id":5647226,"change_date":"2024-05-01 21:43:00","inspection_id":"81499484","dot_number":"1706080","report_state":"TX","report_number":"6UN99DCIS2","insp_date":"2024-04-23 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN HARRIS CO. (806-862","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BELLVILLE TUBE CO","shipping_paper_number":"42324006","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9262014","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[{"id":8734108,"change_date":"2024-05-01 21:43:00","inspection_id":"81499484","insp_violation_id":"259260728","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"200680238","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"393209D"},{"id":8734109,"change_date":"2024-05-01 21:43:00","inspection_id":"81499484","insp_violation_id":"259260729","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"200680239","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"393205C"},{"id":8734110,"change_date":"2024-05-01 21:43:00","inspection_id":"81499484","insp_violation_id":"259260730","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200680239","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9096132,"change_date":"2024-05-01 21:43:00","inspection_id":"81499484","insp_unit_id":"200680238","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"},{"id":9096133,"change_date":"2024-05-01 21:43:00","inspection_id":"81499484","insp_unit_id":"200680239","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":4207645,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","dot_number":"1706080","report_state":"TX","report_number":"6P9F9DAZBO","insp_date":"2023-10-13 00:00:00","insp_start_time":"0749","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"30500  OLD WASHINGTO","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9101592","transaction_code":"A","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T19:46:14.000000Z","updated_at":"2025-03-17T19:46:14.000000Z","inspection_violations":[{"id":6515235,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255863998","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197580163","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39311"},{"id":6515236,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255863999","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197580164","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39375A3"},{"id":6515237,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255864000","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197580164","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39375A3"},{"id":6515238,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255864001","seq_no":"4","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"197580163","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"393203C"},{"id":6515239,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255864002","seq_no":"5","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"197580163","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39355D1"},{"id":6515240,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255864003","seq_no":"6","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"197580163","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39355D2"},{"id":6515241,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_violation_id":"255864004","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197580164","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6766839,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_unit_id":"197580163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:44.000000Z","updated_at":"2025-03-17T22:56:44.000000Z"},{"id":6766840,"change_date":"2023-10-16 21:43:00","inspection_id":"79923169","insp_unit_id":"197580164","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:44.000000Z","updated_at":"2025-03-17T22:56:44.000000Z"}]},{"id":3699513,"change_date":"2023-08-08 21:42:00","inspection_id":"79357937","dot_number":"1706080","report_state":"TX","report_number":"V231107980","insp_date":"2023-08-07 00:00:00","insp_start_time":"1015","insp_end_time":"1048","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 736 MM EB","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BELLVILLE TUBE","shipping_paper_number":"080723-006","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9048547","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-08 21:42:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T19:35:44.000000Z","updated_at":"2025-03-17T19:35:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5948392,"change_date":"2023-08-08 21:42:00","inspection_id":"79357937","insp_unit_id":"196432414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"001","insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"},{"id":5948393,"change_date":"2023-08-08 21:42:00","inspection_id":"79357937","insp_unit_id":"196432415","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"}]},{"id":3677148,"change_date":"2023-08-04 21:41:00","inspection_id":"79333082","dot_number":"1706080","report_state":"TX","report_number":"6NA89DNAW9","insp_date":"2023-08-02 00:00:00","insp_start_time":"0715","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN WALLER CO. (794-804","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9044852","transaction_code":"A","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[{"id":5669691,"change_date":"2023-08-04 21:41:00","inspection_id":"79333082","insp_violation_id":"254486871","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"196379890","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39375A3"},{"id":5669692,"change_date":"2023-08-04 21:41:00","inspection_id":"79333082","insp_violation_id":"254486872","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196379889","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5912135,"change_date":"2023-08-04 21:41:00","inspection_id":"79333082","insp_unit_id":"196379889","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"R499226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW28413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"},{"id":5912136,"change_date":"2023-08-04 21:41:00","inspection_id":"79333082","insp_unit_id":"196379890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"GC001","insp_unit_license":"058C621","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N15320XG1514801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"}]},{"id":683858,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","dot_number":"1706080","report_state":"TX","report_number":"6BYB0XVQAC","insp_date":"2022-06-20 00:00:00","insp_start_time":"1100","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH 10 WESTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JOB SITE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"18","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"18","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8693716","transaction_code":"C","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01706080","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"C & Q ENTERPRISES INC","insp_carrier_street":"505 N SAM HOUSTON PKW EAST SUITE 505C","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"754503","insp_interstate":"Y","insp_carrier_state_id":"0869632","created_at":"2025-03-17T18:39:48.000000Z","updated_at":"2025-03-17T18:39:48.000000Z","inspection_violations":[{"id":1076941,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712836","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076942,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712837","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39378"},{"id":1076943,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712838","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39345D"},{"id":1076944,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712839","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39345"},{"id":1076945,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712840","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39311"},{"id":1076946,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712841","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076947,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712842","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076948,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712843","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076949,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712844","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076950,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712845","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076951,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712846","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076952,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712847","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"},{"id":1076953,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712848","seq_no":"13","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39311"},{"id":1076954,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712849","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39375A3"},{"id":1076955,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712850","seq_no":"15","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3965B"},{"id":1076956,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712851","seq_no":"16","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39348A"},{"id":1076957,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712852","seq_no":"17","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189455139","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39375C"},{"id":1076958,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_violation_id":"246712853","seq_no":"18","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"189455138","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":1099074,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_unit_id":"189455138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M19822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG73LK45442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"},{"id":1099075,"change_date":"2022-06-24 21:39:00","inspection_id":"75907341","insp_unit_id":"189455139","insp_unit_type_id":"8","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"U537189","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1TTF48204X2004565","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1706080\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1706080\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1706080\/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\/1706080\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}