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.
BAC27EEL8585VINYL DECAL (M809)BAC27EPSC138MARKER (PD123B)BAC27EEL8ALUM FOIL MARKERBAC27EEL8680AL FOIL MARKERBAC27EEL1495MARKERBAC27EPP0275MARKER GD6327DCBAC27ECC1700PLACARDBAC27ECC1380VINYL DECAL EQUIPBAC27EMC334MARKERBAC27EEL164ALUMINUM FOIL MARKER, DB18ABAC27EPPS869METALCALBAC27ECC477DECALBAC27ECA322ALUMINUM MARKERBAC27ECC1680DECALBAC27EAC714MARKERBAC27ECA1467MARKER, PDU 20R2BAC27EEX1213MARKERBAC27EEL2784MARKERBAC27ECC1388DECALBAC27EPPS203AL FOIL MARKERBAC27EEL2476MARKERBAC27EEL6226MARKERBAC27EPPS420PLACARDBAC27ECA604ALUM FOIL MARKERBAC27EEX1262MARKERBAC27EEL5242MARKERBAC27ECA984VINYL DECALBAC27EEL1422MARKERBAC27EEL20ALUM FOIL MARKER (RH BODY GEAR DOWN LOCK S403)BAC27EEL1427MARKERBAC27ECA1512POLYESTER MARKER - 47BAC27EEL980MARKERBAC27ECA295VINYL DECALBAC27ECA1503POLYESTER MARKER - 36BAC27EMC668MARKERBAC27ECC915DECAL VINYLBAC27EBY0241DECALBAC27EEX10DECALBAC27ECT278MARKERBAC27ECA624FOIL MARKERBAC27ECA241ALUMINUM MARKERBAC27EAC506MARKERBAC27ECT0977METAL DECAL S1875BAC27EPP0291GROUND MARKERBAC27EFS41MARKERBAC27EEL518DECALBAC27EEL1740MARKERBAC27ECT317MARKERBAC27ECA1600MARKERBAC27ECA0891ALUMINUM MARKER
Back to Boeing 747-SR