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.
65B83251-79SHIM-LAMINATED65B14240-98ANGLE69B80168-8WASHER65B70721-4BOX-69B14568-6CHANNEL65B84896-1HAND HOLD ASSY65B70721-12COVER ASSY65B83254-3BRACKET ASSY69B42183-1SUPPORT ASSY65B05160-64COMPLETE T.L ASSY65B01356-7FRAME - MECHANICAL T69B00259-2BUSHING69B40340-1GIMBLE ASSY-65B14240-64FILLER65B14240-47SKIN69B14583-2ANGLE65B70287-159CONDUIT69B13377-1BUSHING, BEARING69B80886-4CLIP69B80655-5BRACKET69B80037-1NUT69B70997-7FAIRLEAD ASSY-65B80113-3BRACKET65B82177-9PULLEY BRKT ASSY65B01585-17BRACKET69B00286-2BUSHING65B05350-3BUSHING69B80640-1WASHER65B01498-6BEARING65B14240-17TEE65B82177-9PULLEY BRKT ASSY65B70518-36CONDUIT ASSY-69B70619-2GUSSET65B82045-11ZEE65B01529-29TUBE ASSY69B71234-1PLATE65B80129-7HOSE ASSY65B84896-6BRACKET69B00237-3BUSHING65B14240-62ANGLE69B00314-1BUSHING65B01585-16BRACKET69B14581-2ANGLE65B01498-6BEARING65B01585-33BRACKET ASSY69B80226-1BEARING65B14240-112FILLER69B70732-2BOSS65B19941-7FITTING69B00216-3BUSHING
Back to Boeing 747-230B