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.
BAC29PPS29304MarkerBAC29PPS16678MarkerBAC29PPS1827MarkerBAC29PPS29308MarkerBAC29PPS18192MarkerBAC29PPS29306MarkerBAC29PPS33024MarkerBAC29PPS14279MarkerBAC29PPS14262Marker0202175-001Lamp Module, Escape Path MarkerBAC29PPS29303MarkerBAC29PPS29282Marker0202175-003Lamp Module, Escape Path MarkerBAC29PPS18366MarkerBAC29PPS14274MarkerBAC29PPS29260MarkerBAC29PPS18203MarkerBAC29PPS14366MarkerBAC29PPS29320Marker0202175-004Lamp Module, Escape Path ModuleBAC29PPS29276MarkerBAC29PPS1831MarkerBAC29PPS16681MarkerBAC29PPS29295MarkerBAC29PPS1434MarkerBAC29PPS18190MarkerBAC29PPS29270MarkerBAC29PPS29271MarkerBAC29PPS29319MarkerBAC29PPS29316MarkerBAC29PPS29293MarkerBAC29PPS45367MarkerBAC29PPS14305MarkerBAC29PPS18202MarkerBAC29PPS14267MarkerM35240422-1Discharge OutletBAC29PPS29273MarkerBAC29PPS29264MarkerBAC29PPS62465Marker20131ALPBattery Assembly “D” Cell (Ni Cad)BAC29PPS1427MarkerBAC29PPS1832MarkerBAC29PPS29298MarkerBAC29PPS14277Marker0202360-001Lamp AssemblyBAC29PPS38275Marker0202150-101Lens, Escape Path Marker LightBAC29PPS18362Marker728800-251MEASURING STICK, FUEL LEVEL194792-4-1Cooler
Back to Boeing 737-476