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.
S8603AerFilm LHRS2872AerTrim LWS4059AerTrim LWS6994AerTrim LWS1222AerFilm LHRS05446-004-P2AerFilm LHRS1055AerFilm LHRS010389AerTrim LWS013817AerFilm LHRS2596AerFilm LHRS011957AerFilm LHRS05003-010-P2AerFilm LHRS6345AerFilm LHRS05097-001-P2AerFilm LHRS015331AerFilm LHRS2828AerTrim LWS8274AerFilm LHRS013379AerTrim LWS013543AerFilm LHRS011955AerFilm LHRS3355AerFilm LHRS05462-001-P2AerFilm LHRS13270-002-P2AerFilm LHRS6291AerFilm LHRS010299AerFilm LHRS011866AerTrim LWS07922-003-P2AerTrim LWS010472AerTrim LWS5190AerTrim LWS2991AerFilm LHRS010544AerFilm LHRS009467AerTrim LWS13205-002-P2AerFilm LHRS8202AerFilm LHRS1296AerFilm LHRRFO225AerFilm LHRS7364AerTrim LWS010281AerTrim LWS011323AerFilm LHRS51431-013-P2AerFilm LHRS05048-001-P2AerFilm LHRS7159AerFilm LHRS009382AerFilm LHRS00000-075-P2AerFilm LHRS05923-002-P2AerFilm LHRS012567AerFilm LHRS5301AerFilm LHRS013075AerTrim LWS3453AerTrim LWS5953AerFilm LHR
Back to Boeing 747-221F