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.
BAC29PPS19798MarkerBAC29PPS19772MarkerBAC29PPS12860MarkerBAC29PPS19791MarkerBAC29PPS19697MarkerBAC29PPS19725MarkerBAC29PPS19693MarkerBAC29PPS19877MarkerBAC29PPS19797MarkerBAC29PPS19842MarkerBAC29PPS19692MarkerBAC29PPS19754MarkerBAC29PPS19756MarkerBAC29PPS19801MarkerBAC29PPS19790MarkerBAC29PPS19722MarkerBAC29PPS1286MarkerBAC29PPS19778MarkerBAC29PPS19799MarkerBAC29PPS19793MarkerBAC29PPS12832MarkerBAC29PPS19703MarkerBAC29PPS19874MarkerBAC29PPS19763MarkerBAC29PPS12852MarkerBAC29PPS19715MarkerBAC29PPS19841MarkerBAC29PPS19727MarkerBAC29PPS19764MarkerBAC29PPS1282MarkerBAC29PPS19718MarkerBAC29PPS19704MarkerBAC29PPS19709MarkerBAC29PPS19689MarkerBAC29PPS19777MarkerBAC29PPS19694MarkerBAC29PPS19761MarkerBAC29PPS19691MarkerBAC29PPS19690MarkerBAC29PPS19707MarkerBAC29PPS19686MarkerBAC29PPS19730MarkerBAC29PPS13561MarkerBAC29PPS13539MarkerBAC29PPS12983MarkerBAC29PPS13110MarkerBAC29PPS13515MarkerBAC29PPS13531MarkerBAC29PPS12995MarkerBAC29PPS13538Marker
Back to Boeing 737-476