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.
S5200AerFilm LHRS8712AerFilm LHRS012258AerTrim LWS012367AerFilm LHRS51431-006-P2AerFilm LHRS50320-001-P2AerFilm LHRS5518AerFilm LHRS03992-002-P2AerFilm LHRS1586AerTrim LWS51970-001-P2AerFilm LHRS3729AerFilm LHRS1802AerFilm LHRS09266-006-P2AerFilm LHRS07921-002-P2AerTrim LWS7540AerFilm LHRS011443AerFilm LHRS013535AerFilm LHRS08267-017-P2AerFilm LHRS1275AerTrim LWS08267-005-P2AerFilm LHRS011918AerFilm LHRS16231-001-P2AerFilm LHRS07219-001-P2AerFilm LHRS05915-001-P2AerFilm LHRS012779AerFilm LHRS7557AerFilm LHRS04074-002-P2AerFilm LHRS011730AerFilm LHRS52259-001-P2AerFilm LHRS011252AerFilm LHRS3688AerFilm LHRS011888AerFilm LHRS010424AerFilm LHRS4755AerTrim LWS3470AerFilm LHRS2147AerFilm LHRS09221-001-P2AerFilm LHRS009284AerFilm LHRS011026AerTrim LWS02946-002-P2AerFilm LHRS015676AerFilm LHRS8134AerTrim LWS3354AerFilm LHRS8871AerTrim LWS013178AerFilm LHRH803129Seat AssemblyS2287AerTrim LWS51431-011-P2AerFilm LHRS011630AerFilm LHRS7639AerFilm LHR
Back to Boeing 747-221F