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.
69B70731-3SOCKET-LOWER69B80887-1BRACKET ASSY65B05449-2BOLT UPPER TRIPOD69B14976-2BUSHING69B14601-1ANGLE65B83254-7SPACER-TAPERED65B05389-6INSERT65B01517-3PISTON69B15136-2CASTING, KEY65B19932-2CARRIER HALF65B80266-13VALVE ASSY65B14240-67ANGLE65B70327-10JUNCTION BOX65B14240-112FILLER69B00397-2NUT69B81783-11CLIP65B70468-4BOX SIDE65B11667-20CLAMP69B14297-5CLIP65B70287-158CONDUIT ASSEMBLY, WI69B40657-3STIFFENER65B01356-8FRAME - MECHANICAL T69B14568-5WEB65B40377-1BRACKET -65B70285-6PIN ASSY65B80452-6CASTING69B84222-1RETAINER65B05462-2STRUT - UPPER SIDE69B00359-3BUSHING65B14240-85SKIN69B80993-3RETAINER65B05316-6TUBE ASSY69B70812-3SEAL69B80993-3RETAINER69B80300-6STRAP65B80119-1BRACKET65B01553-1ADAPTER65B14240-108SPLICE CHANNEL65B01539-9ACTUATOR ASSY69B71131-2STRAP65B70514-2PULL BOX ASSY284T0743-1GUARD - SWITCH65B83248-10NAME TAG65B70347-3BRACKET ASSY69B80878-1BRACKET69B14580-2ANGLE65B70287-154CONDUIT ASSEMBLY, WI65B14240-63FILLER65B80129-11HOSE ASSY65B05411-2BUSHING - THREADED
Back to Boeing 747-230B