Boeing 737-377
PMA parts · 72,475
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-300 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-300 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.
S7530AerFilm LHRS011523AerFilm LHRS011564AerFilm LHRS4198AerFilm LHRS010832AerFilm LHRS5733AerFilm LHRS52241-001-H5AerFilm LHRS04013-001-H5AerFilm LHRS7739AerFilm LHRS07400-001-H5AerFilm LHRS00000-005-H5AerFilm LHRS011711AerFilm LHRS3274AerFilm LHRS04900-018-H5AerFilm LHRS08201-001-H5AerFilm LHRS4970AerFilm LHRS010195AerFilm LHRS010134AerFilm LHRS010516AerFilm LHRS1731AerFilm LHRS4090AerFilm LHRS1733AerFilm LHRS3443AerFilm LHRS04127-001-H5AerFilm LHRS016373AerFilm LHRS7487AerFilm LHRS09409-001-H5AerFilm LHRS010919AerFilm LHRS011423AerFilm LHRS8051AerFilm LHRS07017-001-H5AerFilm LHRS013646AerFilm CG w/ HA211S04900-019-H5AerFilm LHRS1206AerFilm LHRS011483AerFilm LHRS5338AerFilm LHRS2301AerFilm LHRS011419AerFilm LHRS009209AerFilm LHRS011055AerFilm LHRS04933-001-H5AerFilm LHRS05077-002-H5AerFilm LHRS2154AerFilm LHRS009820AerFilm CG w/ HA211S7297AerFilm LHRS04139-001-H5AerFilm LHRS4033AerFilm LHRS10256-004-H5AerFilm LHRS3060AerFilm LHRS5492AerFilm LHR
Back to Boeing 737-377