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.
65B10197-18WASHER65B23268-11Shied65B81853-6GUARD69B04154-2NUT65B83251-56PAD, RUBBER69B04013-1KEY-UPPER CAM69B13316-2ROLLER65B10197-1WASHER65B19998-1RETAINER BOLT69-12359-1Fitting-Drain65B40862-33INSERT65B08104-27BUSHING-FLANGED65B08895-5PLUG ASSY69B11234-3SUPPORT PIN65B70287-157CONDUIT ASSEMBLY69B04079-1WASHER65B05389-5INSERT LUB ASSY65B70287-183CONDUIT ASSY-BODY65B70287-172CONDUIT ASSEMBLY65B40379-12BRACKET69B19175-2WASHER-SPECIAL65B08857-3BOLT ASSY69B04037-1PAD65B83251-79SHIM-LAMINATED65B05469-1NUT69B70997-7FAIRLEAD ASSY-65B70468-1BOX ASSY65B70287-158CONDUIT ASSEMBLY65B08104-70BUSHING-FLANGED65B08103-262Bushing-Plain69B00107-1BUSHING65B84896-8ROD65B08104-77BUSHING-FLANGED69B04102-1WASHER-TANG65B05471-4PIVOT PIN69B00177-2WASHER66-12688-1Bushing65B18247-1BULKHEAD ASSY69B14927-2REDUCER69B04139-1NUT65B05190-1WASHER69B70488-6FAIRLEAD313T3371-19Seal69B04027-1NUT65B05489-1COUPLING69B40660-13SHIM69B04108-3NUT, SPECIAL65B05271-3BRACE ASSY65B70518-25CONDUIT ASSEMBLY69B83911-4PLATE
Back to Boeing 747-230B