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.
S2301AerFilm LHRS012205AerFilm LHRS7475AerFilm LHRS010597AerFilm LHRS09204-004-H5AerFilm LHRS5670AerFilm LHRS4588AerFilm LHRS6611AerFilm LHRS02636-001-H5AerFilm LHRS2455AerFilm LHRS011563AerFilm LHRS5609AerFilm LHRS009751AerFilm LHRS05050-009-H5AerFilm LHRS009822AerFilm LHRS012237AerFilm LHRS009208AerFilm LHRS4025AerFilm LHRS016827AerFilm LHRS012084AerFilm LHRS03978-004-H5AerFilm LHRS06037-001-H5AerFilm LHRS009703AerFilm LHRS017349AerFilm LHRS017332AerFilm LHRS017361AerFilm LHRS017871AerFilm LHRS009827AerFilm LHRS011935AerFilm LHRS51294-001-H5AerFilm LHRS3157AerFilm LHRS08267-006-H5AerFilm LHRS3480AerFilm LHRS015320AerFilm LHRS016272AerFilm LHRS010842AerFilm LHRS1034AerFilm LHRS010931AerFilm LHRS2505AerFilm LHRS011977AerFilm LHRS7112AerFilm LHRS05051-011-H5AerFilm LHRS3196AerFilm LHRS2478AerFilm LHRS009311AerFilm LHRS017226AerFilm LHRS011988AerFilm LHRS010843AerFilm LHRS011256AerFilm CGS06985-001-H5AerFilm LHR
Back to Boeing 737-377