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.
69B70614-1BUSHING, (SINTERED)65B01514-13BUSHING69B70442-8WASHER65B01585-35FILLER69B83355-4BRACKET69B19329-2SLEEVE-BODY GEAR65B08800-1TOW FITTING ASSY65B19932-2CARRIER HALF65B70338-5TUBE65B01585-23CHANNEL65B81899-5LINK ASSY65B05316-5TUBE ASSY69B13122-1CHANNEL ASSY65B84896-10BACKING69B04144-1WASHER69B00175-1PLUG65B01585-23CHANNEL65B01361-4LEVER ASSY65B14240-109SPLICE CHANNEL69B14297-2ANGLE69B80682-1STUD PIN69B00178-1BUSHING69B14296-1INTERCOSTAL69B14300-3CLIP65B26611-2SPINDLE - ROUGH MACH69B80997-9BRACKET ASSY65B70338-9LINKWELD ASSY-UPPER69B13325-2BUSHING65B01367-1PUSH ROD ASSY65B80122-2CASTING69B70231-11BOX CONNECTOR65B83251-52STRAP69B00223-4BUSHING65B14240-6BOX ASSY-RIGHT69B70613-9BRACKET65B05187-29OUTER CYLINDER69B13121-1CUSHION65B70509-10CHANNEL69B80682-1STUD PIN69B04005-2BUSHING65B19932-3CARRIER HALF65B05316-7TUBE ASSY69B80643-3BRACKET65B14240-14ANGLE65B83251-56PAD, RUBBER69B14568-4FILLER65B16450-3STRAP65B20253-3VALVE ASSY - POPPET69B04069-1BUSHING69B81791-4BUSHING
Back to Boeing 747-230B