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.
BAC27EAC547ALUMINUM FOIL MARKERBAC27EEL5101MARKERBAC27ECA1286POLYESTER MARKERBAC27EAC738MARKERBAC27EEL938MARKERBAC27ECC1763DECALBAC27EFS19MARKERBAC27ECT1187MARKERBAC27ECA235ALUM FOIL MARKERBAC27ECC586VINYL DECALBAC27EEL8346MARKERBAC27EAC736MARKERBAC27EAC38MARKERBAC27ECT0973MARKERBAC27EEL1955MARKERBAC27EEL4298METAL-CALBAC27EPP0247MARKER GD6235SBAC27EEL1425MARKERBAC27EEL422MARKERBAC27EPP0215MARKERBAC27EEL9277MARKERBAC27EEL5059VINYL MARKER, T0398BAC27ECA1100POLYESTER MARKERBAC27EFS0374DECALBAC27EMC98ALUM FOIL MARKER - CA107BAC27ECA11ALUMINUM MARKERBAC27EEL175MARKERBAC27ECA1290POLYESTER MARKERBAC27EAC0325MARKERBAC27ECC917DECALBAC27EPPS686PLACARD FBAC27ECA249MARKERBAC27EEX209DECALBAC27EEL900MARKERBAC27EEL2237DECAL T148BAC27EEX0852ALUM FOIL MARKERBAC27EFS73DECAL/STENCILBAC27EPP0387GROUND MARKERBAC27EEL7010MARKERBAC27ECA682ALUMINUM MARKERBAC27ECT230MARKERBAC27ECA157PLACARDBAC27ECT1196MARKERBAC27ECT1281ALUMINUM FOIL MARKERBAC27ECT1189MARKERBAC27EEL1542MARKER - (D2240J)BAC27EPPS68PLACARDBAC27ECA199ALUMINUM MARKERBAC27EAC0316MARKERBAC27EEL428ALUM FOIL MARKER
Back to Boeing 747-SR