Boeing 747-230B
PMA parts · 62,097
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-200B 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-200B 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.
3179383-1KTBearing887986-4JAClip, Retaining887986-2JAClip, Retaining887986-3JAClip, Retaining887986-6JAClip, Retaining887986-5JAClip, Retaining3239106-3JAStator20800-002Indicator Light Assembly20800-150Indicator Light Assembly20800-344Indicator Light Assembly20800-121Indicator Light AssemblyMLF483Knob20800-155Indicator Light Assembly20800-184Indicator Light Assembly20800-188Indicator Light Assembly20800-324Indicator Light Assembly20800-151Indicator Light Assembly20800-195Indicator Light AssemblyMLF628Knob20800-187Indicator Light Assembly20800-149Indicator Light Assembly20800-118Indicator Light Assembly20800-190Indicator Light Assembly20800-163Indicator Light Assembly120890K-1avWiFi Installation (Short Shelf) Kit120890K-2avWiFi Installation (Long Shelf) Kit650-0500-01avWiFi, Wireless Router, 802.11 a/b/g/n, 32G SSD650-0500-03avWiFi, Wireless Router, 802.11 a/b/g/n, 128G SSD650-0500-04avWiFi, Wireless Router, 802.11 a/b/g/n, 256G SSD120890K-3avWiFi Installation (Stand-Alone) Kit650-0500-02avWiFi, Wireless Router, 802.11 a/b/g/n, 64G SSD650-0500-00avWiFi, Wireless Router, 802.11 a/b/g/n, No SSD859749-001JASpring-HingeBAC27WPPS268MarkerBAC27WPPS267Marker20106-012JAO-Ring10004-904JAO-Ring20106-011JAO-Ring115529-106Waterline Heater115529-115Waterline Heater116290-14Water Line Heater Assy116290-5Heater Assy., Water Line3239107-2JABrake Release Link116290-33Water Line Heater Assy115529-108Waterline Heater115529-103Waterline Heater115529-109Waterline Heater115529-117Waterline Heater115529-113Waterline Heater115529-107Waterline Heater
Back to Boeing 747-230B