Boeing 747-367
PMA parts · 58,851
Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.
Query with SQL
duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
AND len(list_intersect(tcds_models, ['747-300 Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
AND len(list_intersect(tcds_models, ['747-300 Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
BACB10Y8BACB10Y8Rod EndHSB28-104Bearing-Plain, SphericalHSBY6-112BearingBACB10A180M2BACB10A180M2BearingHU20-108HU20-108Bearing-Plain, SphericalBACB10X8TBearing-Plain, SphericalBACB10CL12BACB10CL12BearingHSP32-112HSP32-112Bearing-Plain, SphericalBACB10Y10MBACB10Y10MRod EndBACB10A189M2BACB10A189M2BearingBACB10A187BACB10A187BearingBACB10AG12BACB10AG12BearingBACB10Y4TBACB10Y4TRod EndBACB10CL7Bearing-Plain, SphericalHSP64-105HSP64-105Bearing-Plain, SphericalBACB10CN3BACB10CN3BearingBACB10AG3Bearing-Plain, SphericalBACB10Z3BACB10A180M2LRod EndBACB10AG10MBACB10AG10MBearingHSP26-103Bearing-Self AligningHSU32-103Bearing-BallHU14-109HU14-109Bearing-Plain, SphericalBACB10Y16BACB10Y16Rod EndBACB10X5MTBACB10X5MTBearingBACB10X4MTBACB10X4MTBearingBACB10-180Rod EndBACB10X4TDBearing-Plain, SphericalBACB10A223M2LBACB10A223M2LBearingBACB10A187M2BearingHSP26-103HSP26-103Bearing-Plain, SphericalBACB10AB5MBACB10AB5MBearingBACB10AB4BACB10AB4BearingBACB10AG7MBACB10AG7MBearingBACB10AB10MBACB10AB10MBearingBACB10A180BACB10A180Rod EndBACB10W10TBACB10W10TBearingHB4TL107 HB4TL107Rod EndHSP64-103HSP64-103Bearing-Plain, SphericalBACB10Y4BACB10Y4BearingHU4DU106Bearing-AssemblyBACB10A192M2BACB10A192M2BearingBACB10X3TDBearing-Plain, SphericalBACB10X9TBACB10X9TBearingBACB10AB14MBACB10AB14MBearingBACB10AB10BACB10AB10BearingHSP72-104HSP72-104Bearing-Plain, SphericalHB4ETL115 HB4ETL115Rod EndBACB10X3TMBearing-Plain, SphericalBACB10AB12MBACB10AB12MBearingBACB10X4TBearing-Plain, Spherical
Back to Boeing 747-367