Boeing 737-287C
PMA parts · 38,312
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 ('A16WE')
AND len(list_intersect(tcds_models, ['737-200C 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 ('A16WE')
AND len(list_intersect(tcds_models, ['737-200C 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.
TA027071SVClamp Loop Cushioned447883LAValve, Safety AssyPEX1522-655Raceway CoverPEX1522-686Raceway CoverPEX1522-678Raceway CoverPEX1522-689Raceway Cover8921082G5CWater HeaterHEM2609691WARNING PLATEHEM2614478SCREW, SELF-LOCKINGHEM2607266PACKING, PREFORMEDHEM40725DECAL, NAME PLATEBAC1522-1068MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1086MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1030MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-972MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1058MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-964MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-965MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1046MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1049MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1078MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1048MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1031MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-969MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1037MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1045MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1081MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1080MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1124MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1039MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1052MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-970MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1122MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1073MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-968MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1053MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1051MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1042MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1040MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1077MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-963MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-967MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1076MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-973MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-966MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1075MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1112MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1059MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1119MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1043MISCELLANEOUS, PLASTIC, EXTRUDED
Back to Boeing 737-287C