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.
65B54685-2BRACKET69B51509-5PULLEY ASSY69B52215-3BEARING65B57619-3PACKBOARD65B54580-17NET65B57391-122SLIDE PACK ASSY69B52058-1PLATE ASSY69B52851-1HOOKPLATE65B67367-15NET-ARTICLE RETAINER65B57636-70PACKBOARD ASSY69B53506-2BRACKET65B57391-39SLIDE PACK ASSY65B52480-3COVER65B57636-34PACKBOARD ASSY65B52726-98COVER69B53599-2BEARING416U6035-6POUCH ASSY65B54026-17REINFORCING STRIP65B57619-10RUB STRIP65B54685-12FILLER416U6037-27SIDE COVER65B57619-21BUMPER65B57634-15FILLER BLOCK65B52726-79STRAP65B60810-8NET ASSY416U6037-11WEBBING65B57636-73SHELL ASSY65B57619-32BUMPER69B55637-1STIFFENER BRACKET65B52751-11CORD65B57391-152SLIDE PACK ASSY65B57692-12PIVOT BRACKET ASSY65B58537-3TOP COVER ASSY65B52480-1COVER ASSEMBLY65B57636-53PACKBOARD ASSY69B52867-1PLATE65B57634-31COVER65B58546-30COVER ASSY416U6042-1SAFETY PIN ASSY-416U6014-4BRACKET65B52479-11PACKBOARD ASSEMBLY69B40501-1STRAP ASSY OF65B60165-17NET ASSY65B57638-53CROSS COVER ASSY65B60166-30NET ASSY416U6037-5STIFFENER65B52726-139COVER65B52726-119COVER65B57391-131SLIDE PACK ASSY69B52096-7CABLE ASSY
Back to Boeing 747-230B