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.
310U2041-1RETAINER BASE ASSY65B01856-130SEAL DEPRESSOR69B15089Y6RUB STRIP65B01856-132SEAL DEPRESSOR65B60995-1HANGER69B47882-1JACK-COVER, ASSY314U2110-1LOCATING PIN CF6-80C65B04507Y4DEPRESSOR748819-1WDWasher, Thrust270T0002-42BALL-BEARING65B01855-63SEAL DEPRESSOR69B00095-1SPRING-PIN RETAINER65B08437-41SEAL ASSY65B62115-2GUTTER69B15227-1BUSHING69B12847-3SEAL RETAINER66-9236SAFETY GUIDE-65B93108-1ROD9095-112WEPacking69B00501-1PLATE ASSY69B02762-16CABLE ASSY69B14108-9HOOK ASSY69B52215-1BEARING65B50232-2SHADE69B90801-1GASKET69B04631-1SEAL69B56683-1PIN AND STREAMER ASY60B00179-100BEARING, BALL332U2801-1HOSE SHIELD ASSY - F69B90801-2GASKET65C16899-6SPRING-TORSION65B15650-13SHAFT ASSY69B60598-1COVER ASSY314U2109-1TRANSITION DUCT ASSY69B15036-4BEARING65B01855-62SEAL DEPRESSOR65B51429-3STRAP ASSY69-68855-2SPRING60B00179-2BEARING, BALL69B13594-1WASHER65B04500Y7DEPRESSOR69-12359-4FITTING-NUT65B80202-6CLIP69B13765-6SEAL RETAINER- OUTBD69B50620-1TRACK CAP69B15228-1WASHERAD-3105Battery Pack302T0200-15GBushing - Nacelle Strut302T0200-96GBushing - Nacelle Strut302T0200-152GBushing - Nacelle Strut
Back to Boeing 747-230B