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.
GM6425Transducer, PLALA140U4005 -1, -3, -5, -7, -9, -10, -11, -13, -14, -15, -17, -18, 19 & -20Pane, Outer, Passenger WindowLA140U4005 -1, -3, -5, -7, -9, -10, -11, -13, -14, -15, -17, -18, 19 & -20Pane, Outer, Passenger Window107STC-232EVAS(r)107STC-231EVAS(r)5737-13GasketSF15-103-296SEALH-1727-36HOSE, FLUSH LINEH-1727-26HOSE, FLUSH LINE5673-233SEALS-13117-120SealBACP20BAPLUG-FILLER5673-232SEALBACG20AF10D2AGROMMETSF15-103-235SEAL9562SEALH-1727-27HOSE, FLUSH LINES-13117-7SealBACG20AF7B1AGROMMETS-13117-305SEALS-16954SEALSF15-103-234SEALS-13117-212Seal-PlugSF15-103-295SEALH-1727-22HOSE, FLUSH LINE800-206SealS-13117-304SEALS-13117-312SEAL6565-24Seal800-236SEAL, AERODYNAMICS-13117-121SealB-5132-8RUBBER BOOT ASSY5673-7SealS-13117-298SEALH-1727-37HOSE FLUSH LINES-17381-2SEAL ASSYS-13117-213Seal-PlugBACG20AF11D1GROMMETS-13117-301SEALS-13117-297SEAL800-120Seal5673-515BLADE SEALSF15-103-419SEALBACG20AF3C1GROMMETS-13117-306SEAL800-121SealS-13117-307SEALS-13117-515SEAL5673-849SEALD-5207-1FSEAL
Back to Boeing 747-230B