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.
65B70287-180CONDUIT ASSEMBLY65B08103-88BUSHING-PLAIN65B08800-1TOW FITTING ASSY69B70828-3BRACKET ASSY-69B13382-2WASHER69B71104-1HANGER ASSY30-0423-11FLOODLIGHT30-2175-1FLOODLIGHT140U4001-6Spring Clip65B01557-3Actuator Assy140T2810-28Retainer30-0434-11FLOODLIGHT30-0407-3LIGHT ASSEMBLY65B01557-7Actuator Assy161U0002-1Pin-Lower Bearing140U4001-3Spring ClipA6850C5LIGHT ASSEMBLY58-0084-1TRANSFORMER6001-0237SDSeal - Door112N4508-1WasherSP3810-07-1075Diffuser AssemblySP3810-09-1090Spring, Compression30-2175-2FLOODLIGHT162U1520-1Bolt161U0002-2Pin-Lower BearingSP2511-12-11109PT100 Sensor740925-7WDBall, Valve728775WDSleeve-PumpKT56560Barrel, Cylinder3168987-4WEFilter-Air69B15392Y5RETAINER65B12091Y9FITTING ASSY69B15392Y1RETAINER69B10566Y9HINGE ASSY65B08175U18CHORD65B22858U5SUPPORT65B08175U17CHORD65B12091Y10FITTING ASSY69B13823Y4FITTING ASSY65B14056U1BEAM69B15392Y3RETAINER65B15629Y6WEB65B11744U4FITTING69B15392Y4RETAINER69B13823Y3FITTING ASSY69B11630Y5FITTING ASSY65B15629Y5WEB69B15392Y2RETAINER5500500-103Actuator, Flap Load Relief500700-301Flap Load Relief Actuator (3 POSITION)
Back to Boeing 747-230B