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.
69B52819-1HOOK65B52726-123STRAP65B57391-34SLIDE PACK ASSY65B52728-17PANEL416U5021-4PACKBOARD AND416U6037-7FLAP69B53551-1BRACKET65B57692-15PIVOT BRACKET ASSY65B52752-37PACK65B52474-8SLIDE PACK ASSY65B60166-29NET ASSYBACS10A3WEB SLIDE65B56055-1PANEL69B53275-1CRADLE69B51442-3CABLE65B52474-20SLIDE PACK ASSY69B40093-8STRAP ASSY65B58187-15SUPPORT, CLAMP65B54219-28PACK65B57633-14MOUNTING PLATE ASSY65B57391-31SLIDE PACK ASSY69B55905-3SLIDER69B53240-1GUARD65B54556-15MECH65B58188-11PLATE65B58490-11CABLE ASSY65B54025-25RUB STRIP65B57692-3PIVOT BRACKET ASSY69B55920-1BRACKET65B57636-55PACKBOARD ASSY65B58188-7SUPPORT65B53933-60KNITTED NET69B53546-1CRANK65B16202-2CORD65B52726-102COVER65B52726-36STIFFENER65B47735-1BAG ASSY69B55486-3FOAM65B54685-3BRACKET65B52752-11PACK65B54026-4REINFORCING STRIP65B54931-18COVER65B57636-49PACKBOARD ASSY65B54931-10COVER65B57636-66PACKBOARD ASSY65B52512-10PANEL65B54931-6ROD69B63583-1STRAP65B57636-18PACKBOARD ASSY65B54685-8BRACKET
Back to Boeing 747-230B