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.
BAC27EMC28AL FOIL MARKERSBAC27ECC67DECALBAC27EEL400MARKERBAC27ECT723VINYL DECALBAC27EEL5944MARKERBAC27EAC684MARKERBAC27EEL8657ALUM. FOIL MARKERBAC27ECT524DECALBAC27EHY0152DECALBAC27EEL6359PLASTIC FILM DECALBAC27EPSC950MARKERBAC27ECA1460MARKER, PDU 16L2BAC27ECT1004DECALBAC27EEL6989GDX11 MARKERBAC27EEL2673MARKERBAC27EEL6276MARKERBAC27EPPS245LAMINATED PLACARDBAC27ECT1217MARKER (S191)BAC27ECA1443MARKER, PDU 12R3BAC27EPPS351PLACARDBAC27EEL720PLACARDBAC27EMC329MARKERBAC27ECA1089POLYESTER MARKERBAC27ECT755MARKERBAC27ECC295DECALBAC27ECC1587PLACARDBAC27ECT233MARKERBAC27EEL1389MARKERBAC27ECA956VINYL DECALBAC27EPP0254MARKER GD6127DCBAC27EEL366AL FOIL MARKERBAC27ECA958VINYL DECALBAC27EEL2651MARKERBAC27EEX564MARKERBAC27EEL8273MARKERBAC27ECC1785MARKER, CREW ONLY CHINESEBAC27ECA189AL FOIL MARKERBAC27ECA982ALUM FOIL MARKERBAC27ECT348VINYL DECALBAC27ECA579MARKERBAC27EEL1397MARKERBAC27ECA50MARKERBAC27EAC724MARKERBAC27EEL1415MARKERBAC27EFS53DECAL/STENCILBAC27EPP519MARKERBAC27EPP27MARKERBAC27EEL2197ALUM FOIL MARKERBAC27ECA631FOIL MARKERBAC27ECA1472MARKER, PDU 22L1
Back to Boeing 747-SR