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.
BAC27EEL2151ALUM FOIL MARKERBAC27ECA1188MARKERBAC27EEL9486ALUM FOIL MARKERBAC27EMC348ALUM. FOIL MARKERBAC27ECT1139MARKERBAC27EPSC741AL.FOIL MARKERBAC27EEL285DECALBAC27EEL6993MARKERBAC27ECA265MARKERBAC27EAC675MARKERBAC27EAC0338MARKERBAC27EEL1737MARKERBAC27EPSC140MARKER (PE124B)BAC27EEL9317AL. FOIL MARKERBAC27EEL160MARKERBAC27EEL5266MARKERBAC27EEL1179MARKERBAC27EMC322PLACARDBAC27EEL1965MARKERBAC27ECA1345POLYESTER MARKERBAC27ECA71MYLAR DECALBAC27ECT134MARKERBAC27ECC1021DECALBAC27EEL8438MARKERBAC27ECA1341POLYESTER MARKERBAC27EAC69MARKERBAC27ECT1280ALUMINUM FOIL MARKERBAC27EEL1127MARKERBAC27EPP534AL FOIL MARKERBAC27EEL1806VINYL DECALBAC27EMC163MARKERBAC27EBY21MARKERBAC27EEL1025MARKERBAC27EWG30DECALBAC27EPPS879PLACARDBAC27EPP0410GROUND MARKERBAC27EEL6619DECALBAC27EEL1543MARKER-(D2241J)BAC27EEL1828MARKERBAC27ECC1775MARKER - LADDER STOW INSTRUCTIONSBAC27EPP0267MARKER GD6159DCBAC27EPSC554PLACARDBAC27EEL8193MARKERBAC27EFS109DECALBAC27ECA1266POLYESTER MARKERBAC27EEL840MARKERBAC27ECA38POLYESTER MARKER - DRIVEBAY 4BAC27ECT1118MARKERBAC27EEL2756MARKERBAC27ECT0972MARKER
Back to Boeing 747-SR