Boeing 747-SR
PMA parts · 38,389
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, ['747SR 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, ['747SR 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.
BAC27EPPS396LAMINATED PLACARDBAC27EPP452MARKER GD10197SBAC27EMC164MARKERBAC27EEL8682ALUM FOIL MARKERBAC27EEL8201MARKERBAC27EEL8549VINYL DECALBAC27EEL192MARKERBAC27EEL7038VINYL MARKERBAC27ECA699MARKERBAC27EEL205ALUM FOIL MARKERBAC27EEL2504DECAL, D1970JBAC27ECC1671PLACARDBAC27EEL6990MARKERBAC27ECC1745MARKERBAC27ECA974ALUM FOIL MARKERBAC27EPP0290GROUND MARKERBAC27EEL5738DECAL (DB138A)BAC27EEX1002MARKERBAC27ECC197MYLAR DECALBAC27EBY0248DECALBAC27EEL5862DECALBAC27ECC40DECALBAC27EEL2635MARKERBAC27EEL8302MARKERBAC27EWG22MYLAR DECALBAC27EEL8289MARKERBAC27EEL148ALUM FOIL MARKERBAC27EEL6363PLASTIC FILM DECALBAC27EPP92MARKERBAC27EPP0394GROUND MARKERBAC27EEL2443MARKERBAC27EWG14DECAL-TRACK NO. 5BAC27ELG24NAMEPLATEBAC27EMC621POLYESTER MARKERBAC27EEX1013MARKERBAC27EEL13ALUM FOIL MARKER, NOSE GEAR UP S396BAC27ECT168MARKERBAC27EMC44AL. FOIL MARKERBAC27ECA1425MARKER, PDU 9R1BAC27EEL5465ALUM FOIL MARKERBAC27EEL9472ALUM FOIL MARKER - L501BAC27ECA380ALUM MARKERBAC27EEL5452ALUM FOIL MARKERBAC27EEL434MARKERBAC27EAC668MARKERBAC27EEL1130MARKERBAC27EEL71DECALBAC27EMC194MARKERBAC27EEL4980ALUM FOIL MARKERBAC27EFS39DECAL
Back to Boeing 747-SR