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