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.
BAC29PPS1319MarkerBAC29PPS11398Marker72184003Water Heater DR40-1BAC29PPS11397MarkerBAC29PPS11391MarkerBAC29PPS18721MarkerBAC29PPS10330MarkerBAC29PPS18602MarkerBAC29PPS18724MarkerBAC29PPS10338MarkerBAC29PPS10344MarkerBAC29PPS18584MarkerBAC29PPS18616MarkerBAC29PPS18574MarkerBAC29PPS18734MarkerBAC29PPS18701MarkerBAC29PPS10325MarkerBAC29PPS10329MarkerBAC29PPS10317MarkerBAC29PPS18714MarkerBAC29PPS10394MarkerBAC29PPS18732MarkerBAC29PPS0350MarkerBAC29PPS18716MarkerBAC29PPS18598MarkerBAC29PPS18650MarkerBAC29PPS10401MarkerBAC29PPS0347MarkerBAC29PPS18704MarkerBAC29PPS18618MarkerBAC29PPS18589MarkerBAC29PPS18653MarkerBAC29PPS18608MarkerBAC29PPS18581MarkerBAC29PPS18617MarkerBAC29PPS0205MarkerBAC29PPS18600MarkerBAC29PPS10386MarkerBAC29PPS18569MarkerBAC29PPS10397MarkerBAC29PPS0204MarkerBAC29PPS10345MarkerBAC29PPS18710MarkerBAC29PPS10340MarkerBAC29PPS10315MarkerBAC29PPS18661MarkerBAC29PPS18606MarkerBAC29PPS18622MarkerBAC29PPS18597MarkerBAC29PPS18718Marker
Back to Boeing 737-476