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.
S1208AerFilm LHRS016754AerFilm LHRS011483AerFilm LHRS05060-002-H5AerFilm LHRS010279AerFilm CGS017063AerFilm LHRS04933-001-H5AerFilm LHRS4128AerFilm LHRS04139-001-H5AerFilm LHRS009550AerFilm LHRS010492AerFilm LHRS016461AerFilm LHRS05060-001-H5AerFilm LHRS09265-002-H5AerFilm LHRS016365AerFilm LHRS012104AerFilm LHRS03992-003-H5AerFilm LHRS1846AerFilm LHRS7037AerFilm LHRS6233AerFilm LHRS011532AerFilm LHRS7739AerFilm LHRS8606AerFilm LHRS05021-003-H5AerFilm LHRS7014AerFilm LHRS04900-013-H5AerFilm LHRS013073AerFilm LHRS04128-015-H5AerFilm LHRS6615AerFilm LHRS2529AerFilm LHRS011758AerFilm LHRS010457AerFilm LHRS7749AerFilm LHRS011416AerFilm LHRS3762AerFilm LHRS015660AerFilm LHRS014000AerFilm LHRS012019AerFilm LHRS011518AerFilm CGS7461AerFilm LHRS016908AerFilm LHRS8608AerFilm LHRS014295AerFilm LHRS04901-003-H5AerFilm LHRS012484AerFilm LHRS016909AerFilm LHRS4897AerFilm LHRS009167AerFilm LHRS8722AerFilm LHRS04016-007-H5AerFilm LHR
Back to Boeing 737-377