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.
S010442AerFilm LHRS7133AerFilm LHRS2874AerTrim LWS012810AerFilm LHRS8317AerFilm LHRS08010-001-P2AerFilm LHRS05009-001-P2AerFilm LHRS51903-002-P2AerFilm LHRS09974-002-P2AerTrim LWS6944AerFilm LHRS1286AerTrim LWS015044AerFilm LHRS010143AerFilm LHRS6909AerFilm LHRS50076-001-P2AerFilm LHRS3454AerTrim LWS012512AerFilm LHRS4672AerFilm LHRS5872AerFilm LHRS009543AerTrim LWS010029AerFilm LHRS4089AerFilm LHRS5549AerTrim LWS009144AerFilm LHRS7736AerFilm LHRS05440-005-P2AerTrim LWS011636AerFilm LHRS13252-002-P2AerTrim LWS8742AerFilm LHRS012128AerFilm LHRS011654AerFilm LHRS05434-001-P2AerFilm LHRS06076-001-P2AerFilm LHRS03584-005-P2AerTrim LWS013183AerFilm LHRS5356AerFilm LHRS1864AerFilm LHRS013411AerFilm LHRP00624GasketP00226Pin-BoltP00240Ring Set, PistonP00753Spring SetP00132LinkP00444Spring, ExpanderP00430Ring Set, SealP00438Diaphragm, AirP00440Bushing, Wear95A10451-6D1Grommet95A10451-5B3AGrommet95A10451-3D1Grommet
Back to Boeing 747-221F