diff --git a/databases/py-pyarrow/Makefile b/databases/py-pyarrow/Makefile
index c45a8f00e7a7..69e7983079f5 100644
--- a/databases/py-pyarrow/Makefile
+++ b/databases/py-pyarrow/Makefile
@@ -1,28 +1,28 @@
 PORTNAME=	pyarrow
-PORTVERSION=	21.0.0
-PORTREVISION=	1
+PORTVERSION=	24.0.0
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
 
 MAINTAINER=	sunpoet@FreeBSD.org
 COMMENT=	Python library for Apache Arrow
 WWW=		https://arrow.apache.org/ \
 		https://github.com/apache/arrow/tree/main/python
 
 LICENSE=	APACHE20
 
 BUILD_DEPENDS=	arrow>=${PORTVERSION}<${PORTVERSION}_99:databases/arrow \
+		${PYTHON_PKGNAMEPREFIX}libcst>=1.8.6:devel/py-libcst@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}numpy>=1.25,1:math/py-numpy@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}setuptools>=61:devel/py-setuptools@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}scikit-build-core>=0:devel/py-scikit-build-core@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}setuptools-scm>=8:devel/py-setuptools-scm@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}wheel>=0:devel/py-wheel@${PY_FLAVOR}
 LIB_DEPENDS=	libarrow.so:databases/arrow
 
 USES=		cmake:indirect python
 USE_PYTHON=	autoplist concurrent cython pep517
 
 post-install:
 	${FIND} ${STAGEDIR}${PYTHON_SITELIBDIR} -name '*.so' -exec ${STRIP_CMD} {} +
 
 .include <bsd.port.mk>
diff --git a/databases/py-pyarrow/distinfo b/databases/py-pyarrow/distinfo
index 8c68d5145ef0..33b8b1a8ba9d 100644
--- a/databases/py-pyarrow/distinfo
+++ b/databases/py-pyarrow/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1753266046
-SHA256 (pyarrow-21.0.0.tar.gz) = 5051f2dccf0e283ff56335760cbc8622cf52264d67e359d5569541ac11b6d5bc
-SIZE (pyarrow-21.0.0.tar.gz) = 1133487
+TIMESTAMP = 1777904950
+SHA256 (pyarrow-24.0.0.tar.gz) = 85fe721a14dd823aca09127acbb06c3ca723efbd436c004f16bca601b04dcc83
+SIZE (pyarrow-24.0.0.tar.gz) = 1180261
diff --git a/databases/py-pyarrow/files/patch-CMakeLists.txt b/databases/py-pyarrow/files/patch-CMakeLists.txt
deleted file mode 100644
index 980d0832c7c4..000000000000
--- a/databases/py-pyarrow/files/patch-CMakeLists.txt
+++ /dev/null
@@ -1,31 +0,0 @@
---- CMakeLists.txt.orig	2025-01-11 06:20:05 UTC
-+++ CMakeLists.txt
-@@ -489,8 +489,6 @@ target_compile_definitions(arrow_python PRIVATE ARROW_
- endif()
- target_link_libraries(arrow_python PUBLIC Python3::NumPy)
- target_compile_definitions(arrow_python PRIVATE ARROW_PYTHON_EXPORTING)
--set_target_properties(arrow_python PROPERTIES VERSION "${PYARROW_FULL_SO_VERSION}"
--                                              SOVERSION "${PYARROW_SO_VERSION}")
- install(TARGETS arrow_python
-         ARCHIVE DESTINATION .
-         LIBRARY DESTINATION .
-@@ -506,9 +504,6 @@ else()
-                                                                  ${PARQUET_LINK_LIBS})
-     target_compile_definitions(arrow_python_parquet_encryption
-                                PRIVATE ARROW_PYTHON_PARQUET_ENCRYPTION_EXPORTING)
--    set_target_properties(arrow_python_parquet_encryption
--                          PROPERTIES VERSION "${PYARROW_FULL_SO_VERSION}"
--                                     SOVERSION "${PYARROW_SO_VERSION}")
-     install(TARGETS arrow_python_parquet_encryption
-             ARCHIVE DESTINATION .
-             LIBRARY DESTINATION .
-@@ -539,9 +534,6 @@ if(PYARROW_BUILD_FLIGHT)
-   target_link_libraries(arrow_python_flight PUBLIC arrow_python
-                                                    ArrowFlight::arrow_flight_shared)
-   target_compile_definitions(arrow_python_flight PRIVATE ARROW_PYFLIGHT_EXPORTING)
--  set_target_properties(arrow_python_flight
--                        PROPERTIES VERSION "${PYARROW_FULL_SO_VERSION}"
--                                   SOVERSION "${PYARROW_SO_VERSION}")
-   install(TARGETS arrow_python_flight
-           ARCHIVE DESTINATION .
-           LIBRARY DESTINATION .
diff --git a/databases/py-pyarrow/files/patch-pyproject.toml b/databases/py-pyarrow/files/patch-pyproject.toml
index 2fd201c04f25..48fb3b0ee83d 100644
--- a/databases/py-pyarrow/files/patch-pyproject.toml
+++ b/databases/py-pyarrow/files/patch-pyproject.toml
@@ -1,11 +1,15 @@
---- pyproject.toml.orig	2024-07-11 08:59:52 UTC
+--- pyproject.toml.orig	2022-11-09 12:37:21 UTC
 +++ pyproject.toml
-@@ -27,7 +27,7 @@ requires = [
-     # configuring setuptools_scm in pyproject.toml requires
-     # versions released after 2022
-     "setuptools_scm[toml]>=8",
--    "setuptools>=64",
-+    "setuptools>=61",
- ]
- build-backend = "setuptools.build_meta"
- 
+@@ -35,11 +35,7 @@ readme = {file = "README.md", content-type = "text/mar
+ requires-python = ">=3.10"
+ description = "Python library for Apache Arrow"
+ readme = {file = "README.md", content-type = "text/markdown"}
+-license = "Apache-2.0"
+-license-files = [
+-    "LICENSE.txt",
+-    "NOTICE.txt",
+-]
++license = {text = "Apache-2.0"}
+ classifiers  = [
+     'Programming Language :: Python :: 3.10',
+     'Programming Language :: Python :: 3.11',