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.
BAC27EHY67MARKERBAC27ECC1443PLACARDBAC27EEL9476ALUM FOIL MARKER - L505BAC27ECC1601LAMINATED PLACARDBAC27EPP553ALUMINUM FOIL MARKER, MOBIL JET OIL 291BAC27EMC338ALUMINUM MARKERBAC27EAC20METAL MARKERBAC27EPP439MARKER GD10791DCBAC27EEL5202MARKERBAC27EPSC678MARKER (PE311A)BAC27EAC620MARKERBAC27ECA346AL FOIL MARKERBAC27ECA175AL FOIL MARKERBAC27EAC670MARKERBAC27ECA495ALUM FOIL MARKERBAC27EFS139DECALBAC27EMC651MARKERBAC27EHY31NAME-PLATEBAC27EEL401DECALBAC27EPPS41ALUM FOIL MARKERBAC27EEL5430METAL DECALBAC27EEL202ALUM FOIL MARKERBAC27EPP0476DECALBAC27EEL1177MARKERBAC27EEL1124MARKERBAC27EFS599OVERRIDE/JETTISON PUMP TANK NO. 2-FWD M222 PUMP MOTOR/IMPELLER REMOVALBAC27EEL86MARKERBAC27ECC1543PLACARDBAC27ECT834DECALBAC27EEX1212MARKERBAC27EEX0824VINYL CALBAC27ECC1672DECALBAC27ECC1729MARKERBAC27EFS606FUEL BOOST PUMP TANK NO. 2-FWD M29 PUMP MOTOR/IMPELLER REMOVALBAC27EAC622MARKERBAC27EMC57ALUMINUM FOIL MARKERBAC27EPPS419PLACARDBAC27EMC172MARKERBAC27ECA1359POLYESTER MARKERBAC27EEL6407MARKERBAC27EMC414AL FOIL MARKERBAC27ECC1494LAMINATED PLACARDBAC27ECA1273POLYESTER MARKERBAC27EEL9203ALUM. FOIL MARKERBAC27ECA416MYLAR DECALBAC27EFS34MARKER, AL FOIL - MANUAL DEFUELING VALVEBAC27EAC713MARKERBAC27EEL6641VINYL DECALBAC27EEL4653METAL-CALBAC27EEL5901PLASTIC FILM DECALS
Back to Boeing 747-SR