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.
69B00240-2BUSHING69B71108-1RUB STRIP69B00238-3BUSHING69B70732-1PLATE65B01585-33BRACKET ASSY69B14810-2SPACER65B08807-9INSERT ASSY65B70509-8BRACKET69B70660-3PLUG69B70621-2RADIUS BLOCK69B70612-1BRACKET-69B04005-2BUSHING65B82558-2ACTUATOR ASSY69B40657-9BRACKET65B83254-8SPACER-TAPERED69B00273-1BUSHING69B80649-1GROMMET69B16428-1STOP65B70287-160CONDUIT65B80143-14SLEEVE69B70613-3BRACKET ASSY69B14607-1ANGLE69B80037-1NUT65B01481-5ROLLER SUPPORT ASSY69B00175-1PLUG69B00202-3BUSHING69B04144-1WASHER69B40657-8BRACKET ASSY-65B70338-10LINKWELD ASSY-LWR69B83355-4BRACKET65B84896-12PLATE65B01381-1WASHER69B00209-2BUSHING69B70613-4BRACKET ASSY65B05345-3BUSHING65B05451-5INSERT ASSY69B80646-4HOSE BRACKET ASSY69B71005-1BRACKET69B04153-2NUT WALKING BEAM69B71108-2RUB STRIP69B14584-5ANGLE65B05172-14CASTING65B70509-9CHANNEL65B05262-7BOLT ASSY69B70442-4WASHER69B14551-4FILLER-RADIUS65B14240-120ANGLE69B04116-1BUSHING69B00150-1BUSHING65B01518-22ROD ASSY
Back to Boeing 747-230B