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.
BAC27EEL1146MARKERBAC27EEX1460FLIGHT DECK HANDSET MARKERBAC27EFS20DECALBAC27EEL1383MARKERBAC27ECT377MARKERBAC27ECA0821MARKERBAC27EEL1014MARKERBAC27EMC683POLYESTER MARKERBAC27ECA1032ALUMINUM MARKERBAC27EEL6127PLASTIC FILM DECALBAC27ECA987ALUM FOIL MARKERBAC27ELG0064DECAL-TIRE PRESSUREBAC27EEX1426MARKERBAC27ECC847DECALBAC27EFS6DECALBAC27ECC1300LAMINATED PLACARDBAC27EMC81MARKERBAC27EEL1416MARKERBAC27EAC0124MYLAR MARKERBAC27EEL2146ALUM FOIL MARKERBAC27EEL2211VINYL DECALBAC27ECT1007FOIL MARKERBAC27EEL9424VINYL DECALBAC27ECA1564MARKER, POLYESTER 4LBAC27EPP111MARKERBAC27ECA10MARKERBAC27EEL1813VINYL DECALBAC27ECA212ALUMINUM MARKERBAC27EFS173MARKER, MYLAR - CAUTION, FUEL TANK ACCESS DOOR WITH MEASURING STICKBAC27ECC5DECALBAC27ECT752MARKERBAC27EEL4815AL FOIL MARKER-(J27)BAC27EEL5288MARKER - (D3191J)BAC27EEL1403MARKERBAC27EHY65MARKERBAC27EPPS229UNIT IDENT PLACARDBAC27EBY0240DECALBAC27EEL8206MARKER - (D2019J)BAC27EPP0389GROUND MARKERBAC27ECC1761MARKERBAC27ECC1552DECALBAC27EMC337ALUMINUM MARKERBAC27EEL2325MARKER- AL FOILBAC27EBY72DECALBAC27EFS149DECAL/STENCILBAC27EEL1917MARKERBAC27EAC0166DECALBAC27ECA478MARKERBAC27EEL873MARKERBAC27ECT418VINYL DECAL
Back to Boeing 747-SR