Boeing 747-221F
PMA parts · 57,567
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-200F 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-200F 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.
S5696AerFilm LHRS04909-009-P2AerFilm LHRS08267-015-P2AerFilm LHRS1188AerFilm LHRS7001AerFilm LHRS6896AerFilm LHRS3730AerFilm LHRS013482AerFilm LHRS5110AerFilm LHRS1686AerFilm LHRS8960AerFilm LHRS011629AerFilm LHRS7446AerFilm LHRS012748AerTrim LWS6286AerTrim LWS1576AerFilm LHRS1596AerFilm LHRS5572AerTrim LWS8726AerTrim LWS07293-004-P2AerFilm LHRS015549AerTrim LWS06029-001-P2AerFilm LHRS3499AerTrim LWS013487AerFilm LHRS5474AerFilm LHRS010079AerFilm LHRS4279AerTrim LWS08236-001-P2AerFilm LHRS013625AerFilm LHRS2929AerTrim LWS03935-010-P2AerTrim LWS50470-001-P2AerFilm LHRS011128AerFilm LHRS04920-010-P2AerFilm LHRS04018-001-P2AerFilm LHRS8146AerFilm LHRS05078-014-P2AerFilm LHRS012436AerTrim LWS07073-001-P2AerTrim LWS010863AerTrim LWH11272-01Cap Assy.S011251AerTrim LWS6317AerFilm LHRS5314AerFilm LHRS3927AerFilm LHRS04083-008-P2AerFilm LHRS6566AerFilm LHRS6660AerFilm LHRS5637AerFilm LHRS011683AerFilm LHR
Back to Boeing 747-221F