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.
BAC27ECA369VINYL DECALBAC27ECC1645VINYL MARKERBAC27ECT670MARKERBAC27ECT1061MARKERBAC27ECA1069POLYESTER MARKER - 7BAC27EEL1164MARKERBAC27EEL2485MARKERBAC27EEL2378VINYL DECALBAC27EEL1165MARKERBAC27ECT1290MARKERBAC27ECT671MARKERBAC27EEL9286MARKERBAC27EEL4994VINYL MARKER, TB206BAC27ECA1035ALUMINUM MARKERBAC27ECT1051MARKERBAC27EEL2131ALUM FOIL MARKERBAC27EEL1790MARKERBAC27EAC0127MYLAR MARKERBAC27ECT786DECALBAC27EEL9433VINYL MARKER, X909BAC27ECA1597MARKER, POLYESTER J2BAC27EHY127MARKERBAC27EPPS330PLACARDBAC27EEL2032METALCALBAC27EEL1294MARKERBAC27EPP471MARKER GD10814DCBAC27EAC712MARKERBAC27EEL63VINYL DECALBAC27EEL370ALUMINUM FOIL MARKER, L116 LIGHT ASSY USE LAMP 311BAC27EEL8355MARKERBAC27ECC1392DECALBAC27EEL2139ALUM FOIL MARKERBAC27EEL163MARKERBAC27EMC266MARKERBAC27EEL5082VINYL CALBAC27EMC111AL FOIL MARKER - CA122BAC27ECA681ALUMINUM MARKERBAC27ECT1153FOIL MARKERBAC27ECA1501POLYESTER MARKER - 34BAC27ECT948VINYL DECALBAC27ECA328ALUMINUM MARKERBAC27EFS101DECALBAC27ECA1401POLYESTER MARKER - BAR STA 800BAC27EEL776METAL CALBAC27ECA1352POLYESTER MARKERBAC27ECT518MARKERBAC27EEL137ALUM FOIL MARKERBAC27EPP12NAME PLATEBAC27EPSC410AL FOIL MARKERBAC27EAC0184ALUM MARKER
Back to Boeing 747-SR