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.
BAC29PPS19067MarkerBAC29PPS19062MarkerBAC29PPS18962MarkerBAC29PPS19041MarkerBAC29PPS19005MarkerBAC29PPS18981MarkerBAC29PPS19127MarkerBAC29PPS19053MarkerBAC29PPS18982MarkerBAC29PPS19050MarkerBAC29PPS19124MarkerBAC29PPS19133MarkerBAC29PPS19031MarkerBAC29PPS19025MarkerBAC29PPS19009MarkerBAC29PPS19123MarkerBAC29PPS19120MarkerBAC29PPS19126MarkerBAC29PPS19058MarkerBAC29PPS19061MarkerBAC29PPS19014MarkerBAC29PPS19060MarkerBAC29PPS19038MarkerBAC29PPS19131MarkerBAC29PPS19034MarkerBAC29PPS19059MarkerBAC29PPS19066MarkerBAC29PPS19028MarkerBAC29PPS19017MarkerBAC29PPS18972MarkerBAC29PPS18978MarkerBAC29PPS19048MarkerBAC29PPS19070MarkerBAC29PPS19068MarkerBAC29PPS19137MarkerBAC29PPS19122MarkerBAC29PPS19047MarkerBAC29PPS19008MarkerBAC29PPS19032MarkerBAC29PPS19130MarkerBAC29PPS19057MarkerBAC29PPS19063MarkerBAC29PPS19019MarkerBAC29PPS18963MarkerAW233030009-1035.0” LCD MonitorBAC29PPS19139MarkerBAC29PPS18994MarkerBAC29PPS19044MarkerBAC29PPS19040MarkerBAC29PPS19054Marker
Back to Boeing 737-476