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.
BAC1522-1141MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1204MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1158MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1192MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1123MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1172MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1189MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1173MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1209MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1121MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1162MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1197MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1196MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1136MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1167MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1160MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1166MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1176MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1177MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1199MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1170MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1180MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1159MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1161MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1188MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1142MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1206MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1163MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1175MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1185MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1193MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1165MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1135MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1183MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1182MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1164MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1171MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1208MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1191MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1200MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1198MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1201MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1194MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1128MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1146MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1187MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1144MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1179MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1184MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1145MISCELLANEOUS, PLASTIC, EXTRUDED
Back to Boeing 737-287C