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.
S011438AerTrim LWS7086AerFilm LHR8060AerFilm LHRS00000-077-P2AerTrim LWS009330AerFilm LHRS51966-001-P2AerFilm LHRS011950AerTrim LWS4162AerFilm LHRS7644AerFilm LHRS00000-044-P2AerFilm LHRS16205-002-P2AerTrim LWS010450AerTrim LWS7269AerTrim LWS08289-001-p2AerFilm LHRS2916AerTrim LWS012568AerTrim LWS05051-015-P2AerTrim LWS8257AerTrim LWS009541AerFilm LHRS3314AerFilm LHRS52267-007-P2AerFilm LHRS5908AerFilm LHRS009594AerTrim LWS2298AerFilm LHRS011164AerFilm LHRS009532AerFilm LHRS1718AerFilm LHRS011767AerFilm LHRS011022AerFilm LHRS6212AerFilm LHRS6228AerFilm LHRS015592AerFilm LHRS011257AerFilm LHRS011024AerTrim LWS4702AerFilm LHRS2048AerFilm LHRS013813AerFilm LHRS009389AerTrim LWS013649AerTrim LWS07283-003-P2AerFilm LHRS6610AerFilm LHRS012140AerFilm LHRS05915-003-P2AerFilm LHRS09203-007-P2AerFilm LHRS012098AerTrim LWS009429AerFilm LHRS009359AerFilm LHRS011808AerFilm LHRS3064AerFilm LHRS1704AerFilm LHR
Back to Boeing 747-221F