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.
65B15085-238Channel, Seal, Support69B12260-1Tie Rod Assembly65B15256-611Shim65B14963-38Panel Assembly - Upper, INBD Nacelle, Wing Leading Edge65B14058-1Beam65B10920-164Seal69B13198-1Pivot Plate Assembly66-17207-5Retainer Strap65B11513-42Seal65B15629-6Web65B15000-23Seal65B12727-9Stiffener Channel66-17207-6Retainer Strap65B15696-126Stiffener015U0817-601Bracket69B15700-2Fitting65B14063-6Channel65B11752-9Reveal Assembly69B13974-2Bracket65B15000-30Seal65B11655-9Lens65B15629-29Web69B12100-4Fitting69B10157-1Fitting69B11514-1Plate65B08318-19Stop Fitting69B70420-4Support Bracket65B12092-9Tie Rod Assembly65B12915-2Retainer65B15089-5Filler65B12727-12Stiffener Channel69B11618-6Plate65B15000-26Seal65B10505-13Support Fitting Assy65B15181-14Brace65B15460-1Fitting65B22858-17Support69B10471-6Bracket Assembly69B11350-9Link Assembly65B22858-12Support65B11752-10Reveal Assembly65B12246-100Stiffener69B15392-4Retainer65B22858-13Support65B14054-1Fitting65B10007-601Pocket Assembly65B15069-643Angle65B12246-8Chord - Middle69B14501-3Fitting Assembly65B10000-1Bushing Assembly
Back to Boeing 747-230B