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.
65B40387-3TUBE69B00357-2NUT-SPECIAL65B01529-19CUSHION69B70997-12SUB KIT ASSY65B01585-18BRACKET65B11667-5ATTACH FTG ASSY65B70509-12BRACKET69B14584-2ANGLE65B05135-5TORSION LINK ASSY -69B80647-2BRACKET69B00228-2BUSHING65B01477-2ROD - ROUGH MACH.69B00365-2BUSHING65B70338-9LINKWELD ASSY-UPPER69B71005-1BRACKET65B14240-103FILLER69B00224-3BUSHING69B00368-1BUSHING69B14925-1WASHER65B84896-10BACKING69B00346-2BUSHING69B04120-2BUSHING65B08826-2FOLLOWER69B00259-2BUSHING65B83251-64PAD, RUBBER69B14296-3ANGLE65B70410-19END PLATE65B01585-13BRACKET ASSY65B84896-11ANGLE65B05279-3BRACE, ROUGH MACHINE69B00149-1NUT69B70660-1CLEVIS ASSY65B14240-9COVER65B08854-9OUTER RACE HALF69B80877-3PLATE65B14240-97ANGLE65B14240-35ANGLE65B20253-2VALVE - POPPET69B17175-1ORIFICE65B80119-2CASTING, BRACKET69B80877-6TUBE69B80076-1SEAL RETAINER65B01356-8FRAME - MECHANICAL T65B70869-14SUPPORT69B14580-1ANGLE65B70491-3CONDUIT ASSY69B00213-2BUSHING65B70338-8TUBE69B13325-1BUSHING65B14240-39ANGLE
Back to Boeing 747-230B