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.
BAC27EAC0362MARKERBAC27EEL24ALUM FOIL MARKER (RH WING GEAR DOWN LOCK S412)BAC27EEL935MARKERBAC27EEL8558VINYL MARKER, P135BAC27ECT146VINYL DECALBAC27ECT778PLACARDBAC27ECT1292MARKERBAC27EEL818MARKERBAC27ECA647ALUM FOIL MARKERBAC27EEL899MARKERBAC27EMC310MARKERBAC27EAC710MARKERBAC27EAC487MARKERBAC27ECT767VINYL DECALBAC27EEL248AL FOIL MARKERBAC27ECA382ALUMINUM MARKER-BAC27ECA1322MARKERBAC27EEL2173ALUM FOIL MARKERBAC27ECA373MARKERBAC27ECA275VINYL DECALBAC27ECC1217DECALBAC27ECA9DECALBAC27EPPS445PLACARDBAC27ECC1682LAMENT PLACARDBAC27EEL1185MARKERBAC27EEL761MARKERBAC27ECA1346POLYESTER MARKERBAC27ELG57DECAL-TIRE PRESSUREBAC27EEL2721MARKERBAC27EEL936MARKERBAC27EPPS67PLACARDBAC27EFS114DECALBAC27EAC16AL FOIL MARKERBAC27EEL1205MARKERBAC27EMC232ALUM FOIL MARKERBAC27EAC688MARKERBAC27ECC364DECALBAC27EEL2306MARKERBAC27EEL7188PLASTIC FILM DECALBAC27EPP0415GROUND MARKERBAC27EMC257MARKERBAC27EEL6141VINYL DECALBAC27ECC379PLACARDBAC27ECT1127MARKERBAC27ECA1470MARKER, PDU 21L2BAC27ECT1198MARKERBAC27EAC42DECALBAC27EEL5667PLASTIC FILM DECALBAC27EFS130MARKERBAC27EEL2185MARKER
Back to Boeing 747-SR