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.
65B08885-4RING ASSY-ADJUST310U2073-1Bolt65B41664-2CUSHION65B14161-1SUPPORT LINK ASSY65B84896-13PAD69B71108-2RUB STRIP65B05261-3RETAINER ASSY65B05220-2BOLT69B00179-1SHIM69B70422-2HEX NUT69B42739-1RADIUS FILLER65B08887-2NUT69B04105-1LOCKTAB65B17078-1SUPPORT LINK ASSY65B01366-1STRIKER69B04119-2NUT65B10197-22WASHER69B04144-1WASHER65B83251-62PAD, RUBBER69B15002-2RETAINER65B19932-1CARRIER ASSY69B80877-1GUIDE ASSY69B04010-1SCREW65B01553-2ADAPTER69B04054-1RING, RESTRICT69B04125-1BOLT-ACTUATOR69B13125-8SEAL65B01487-7OUTER RACE ASSY65B10713-13BRACKET ASSY69B04059-1BOLT, DOOR ROLLER65B05482-4INSERT412N1156-21Hinge Chassis Assy65B05433-2NUT-GLAND69B04045-3BOLT ASSY69B04031-2SLEEVE69B70254-1BRACKET69B70942-18NUT, COUPLING65B05484-2ACTUATOR PIN65B08104-52BUSHING69B82574-8SUPPORT ASSY69B70981-1FILLER-INBD69B00397-2NUT66-12688-4BushingBACB28YE029BUSHING, PLAIN65B08866-7INSERT ASSY65B70509-9CHANNEL65B01476-3RETAINER ASSY69B04046-4SPRING65B05485-2TUBE-METERING ROD69B00308-1LOCK TAB
Back to Boeing 747-230B