Boeing 737-476
PMA parts · 66,360
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-400 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-400 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.
Chomerics P/N: 15-20201GasketBAC29PPS23717MarkerBAC27DCC348MarkerBAC29PPS22971MarkerBAC27DCC3065MarkerBAC27NEL0190MarkerBAC27DEL1259MarkerBAC27NEL0191MarkerBAC29PPS22873MarkerChomerics P/N: 15-20020GasketBAC29PPS22876MarkerBAC27DCC2750MarkerBAC27DEL1257MarkerBAC27DEL1258MarkerBAC27DEX6452MarkerBAC29PPS23735MarkerBAC29PPS22955MarkerBAC29PPS23060MarkerBAC29PPS23728MarkerBAC27NEL0187MarkerBAC29PPS22951MarkerBAC27DCC346MarkerChomerics P/N: 15-20036GasketBAC27DEX5879MarkerBAC27DEL1259MarkerBAC27DEL1258MarkerBAC27DCC2829MarkerBAC27NEL0189MarkerBAC27DCC3080MarkerBAC27DCC3067MarkerBAC27DCC3079MarkerBAC27DCC2831MarkerBAC27DEX6266Marker841A4401-1MarkerBAC27DCC3082Marker841A4401-2MarkerBAC27DEL1255MarkerBAC27DCC2745MarkerBAC29PPS22871MarkerBAC27DCC2747MarkerBAC29PPS22867MarkerBAC27DEL1256MarkerBAC27DCC2930MarkerBAC27DCC3069MarkerBAC27DEL1261MarkerBAC27DCC2960MarkerBAC27NEL0192MarkerBAC27DEX6446MarkerChomerics P/N: 15-20001 REV CGasketBAC27DCC2744Marker
Back to Boeing 737-476