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.
0340-53-0003-19STA 727B Floor Beam Reinforcement0340-53-0032-13Angle0340-53-0030-39STA 727D Floor Beam Reinforcement0340-53-0029-259Track Instl, Lat, Left (STA 559)0340-53-0004-1Angle0340-53-0036-24Ramp007-09505-657Channel007-09505-637Tee0340-53-0033-45Strap007-04405-301Bracket007-04404-260Panel007-04405-151Panel - Headliner0340-53-0033-55Strap0340-53-0010-15Seat Track0340-53-0001-59Floor Beam Reinforcement Inst FS 500D007-04405-1083Zee007-04405-933Angle0340-53-0010-1Seat Track0340-53-0030-139STA 867 Floor Beam Reinforcement007-09505-737Angle0340-53-0010-5Seat Track0340-53-0010-57Seat Track007-09505-642Tee0340-53-0028-59Floor Beam Reinforcement Inst. FS 500D007-09505-625Filler0340-53-0003-209STA 1006 Floor Beam Reinforcement0340-53-0010-13Seat Track007-04404-270Panel0340-53-0028-29Floor Beam Reinforcement Inst. FS 4200340-53-0029-329Track Instl, Lat, Left (STA 706)0340-53-0002-309Track Instl Lat Left (STA 663.75)007-09505-639Angle007-09505-661Tee0340-53-0033-37Clip0340-53-0032-5Filler007-09505-547Lower Strap0340-53-0003-79STA 747 Floor Beam Reinforcement0340-53-0001-139Drain System Installation Left Hand0340-53-0033-33Doubler007-04405-891Bracket0340-53-0029-9Floor Modification Freighter (STA 520 – STA 727B)007-09505-641Tee0340-53-0002-9Floor Modification Freighter (STA520 – STA727B)007-04405-707Cover007-09505-723Lower Strap0340-53-0003-139STA 867 Floor Beam Reinforcement0340-53-0001-109Longitudinal Track Installation LBL 0.0 FS 344 – 520007-04405-157Panel - Headliner007-09505-527Lower Strap007-09505-507Channel
Back to Boeing 737-476