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.

65B10197-18WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B10197-18 · Mar 25, 201365B23268-11ShiedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B23268-11 · Mar 25, 201365B81853-6GUARDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B81853-6 · Mar 25, 201369B04154-2NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04154-2 · Mar 25, 201365B83251-56PAD, RUBBERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-56 · Mar 25, 201369B04013-1KEY-UPPER CAMAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04013-1 · Mar 25, 201369B13316-2ROLLERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B13316-2 · Mar 25, 201365B10197-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B10197-1 · Mar 25, 201365B19998-1RETAINER BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B19998-1 · Mar 25, 201369-12359-1Fitting-DrainAviation Materials Management Inc · PMA PQ4098CE · Replaces 69-12359-1 · Mar 25, 201365B40862-33INSERTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B40862-33 · Mar 25, 201365B08104-27BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-27 · Mar 25, 201365B08895-5PLUG ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08895-5 · Mar 25, 201369B11234-3SUPPORT PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B11234-3 · Mar 25, 201365B70287-157CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-157 · Mar 25, 201369B04079-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04079-1 · Mar 25, 201365B05389-5INSERT LUB ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05389-5 · Mar 25, 201365B70287-183CONDUIT ASSY-BODYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-183 · Mar 25, 201365B70287-172CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-172 · Mar 25, 201365B40379-12BRACKETAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B40379-12 · Mar 25, 201369B19175-2WASHER-SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B19175-2 · Mar 25, 201365B08857-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08857-3 · Mar 25, 201369B04037-1PADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04037-1 · Mar 25, 201365B83251-79SHIM-LAMINATEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-79 · Mar 25, 201365B05469-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05469-1 · Mar 25, 201369B70997-7FAIRLEAD ASSY-Aviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70997-7 · Mar 25, 201365B70468-1BOX ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70468-1 · Mar 25, 201365B70287-158CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-158 · Mar 25, 201365B08104-70BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-70 · Mar 25, 201365B08103-262Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-262 · Mar 25, 201369B00107-1BUSHINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00107-1 · Mar 25, 201365B84896-8RODAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B84896-8 · Mar 25, 201365B08104-77BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-77 · Mar 25, 201369B04102-1WASHER-TANGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04102-1 · Mar 25, 201365B05471-4PIVOT PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05471-4 · Mar 25, 201369B00177-2WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00177-2 · Mar 25, 201366-12688-1BushingAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-12688-1 · Mar 25, 201365B18247-1BULKHEAD ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B18247-1 · Mar 25, 201369B14927-2REDUCERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B14927-2 · Mar 25, 201369B04139-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04139-1 · Mar 25, 201365B05190-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05190-1 · Mar 25, 201369B70488-6FAIRLEADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70488-6 · Mar 25, 2013313T3371-19SealAviation Materials Management Inc · PMA PQ4098CE · Replaces 313T3371-19 · Mar 25, 201369B04027-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04027-1 · Mar 25, 201365B05489-1COUPLINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05489-1 · Mar 25, 201369B40660-13SHIMAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B40660-13 · Mar 25, 201369B04108-3NUT, SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04108-3 · Mar 25, 201365B05271-3BRACE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05271-3 · Mar 25, 201365B70518-25CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70518-25 · Mar 25, 201369B83911-4PLATEAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B83911-4 · Mar 25, 2013
Back to Boeing 747-230B