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.
BAC27EPPS71PLACARDBAC27ECT1183MARKERBAC27EAC592MARKERBAC27EEL913MARKERBAC27ECA1582MARKER, POLYESTER 13LBAC27EEL8699ALUM FOIL MARKERBAC27EAC489MARKERBAC27EEL2282PLASTIC FILM DECALBAC27EEL8542DECALBAC27EEL1143MARKERBAC27EEL9427VINYL DECALBAC27ECA294VINYL DECALBAC27EEL1858MARKERBAC27ECA925VINYL DECALBAC27EPPS322PLACARDBAC27ECA273VINYL DECALBAC27EAC0210MARKERBAC27EMC279ALUMINUM FOIL MARKERBAC27EEL8218MARKER - (D2031J)BAC27ECT1274FOIL MARKERBAC27EEL8688ALUM FOIL MARKERBAC27EMC256MARKERBAC27EEL706MARKERBAC27EEL5427MARKERBAC27EEL7250VINYL DECALBAC27EEX381DECALBAC27ECA1397MARKER, PALLET POSITION P21 BAR P11BAC27ECA0890ALUMINUM MARKERBAC27EAC490MARKERBAC27EAC0344MARKERBAC27EAC0354MARKERBAC27EEL2313MARKERBAC27EAC708MARKERBAC27EMC106AL FOIL MARKER - CA115BAC27EEX42MARKERBAC27ECT832DECALBAC27ECT216MARKERBAC27EFS190MARKERBAC27EEL184MARKERBAC27EMC391ALUM. FOIL MARKERBAC27EAC0180MARKERBAC27EEL2329ALUM FOIL MARKERBAC27EAC439DECALBAC27EPPS197ALUM FOIL MARKERBAC27ECC1563PLACARDBAC27EEL2112VINYL DECAL (12)BAC27EEL91MARKERBAC27EEL1435MARKERBAC27ECA1127ALUMINUM MARKERBAC27ECA1482MARKER, PDU STEERABLE 24
Back to Boeing 747-SR