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.
BAC29PPS0354MarkerBAC29PPS10299MarkerBAC29PPS18588MarkerBAC29PPS0356MarkerBAC29PPS18580MarkerBAC29PPS10298MarkerBAC29PPS18619MarkerBAC29PPS10302MarkerBAC29PPS10322MarkerBAC29PPS10405MarkerBAC29PPS18609MarkerBAC29PPS18733MarkerBAC29PPS10320MarkerBAC29PPS0351MarkerBAC29PPS0352MarkerBAC29PPS17763MarkerBAC29PPS17762MarkerBAC29PPS17767MarkerBAC29PPS17765MarkerBAC29PPS18161MarkerBAC29PPS17761MarkerBAC29PPS18135MarkerBAC29PPS17918MarkerBAC29PPS18162MarkerBAC29PPS18165MarkerBAC29PPS18160MarkerBAC29PPS18134MarkerBAC29PPS18163MarkerBAC29PPS18145MarkerBAC29PPS16175MarkerBAC29PPS17919MarkerBAC29PPS18164MarkerBAC29PPS29279MarkerBAC29PPS14281MarkerBAC29PPS14346MarkerBAC29PPS29285MarkerBAC29PPS1428MarkerBAC29PPS29305MarkerBAC29PPS14264MarkerBAC29PPS14273Marker0202175-006Lamp Module, Escape Path Marker LightBAC29PPS29300MarkerBAC29PPS14445MarkerBAC29PPS29321MarkerBAC29PPS14347MarkerBAC29PPS18191MarkerBAC29PPS14266MarkerBAC29PPS29294MarkerBAC29PPS29292MarkerBAC29PPS60170Marker
Back to Boeing 737-476