Boeing 747-400D
PMA parts · 105,720
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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D 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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D 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.
65B10990-12FITTING ASSY65B93100-22HINGE FITTING ASSY66-12687-1PIN65B08565-6FITTING ASSY5992Kit, Retrofit for Flush Valve Replacement14330-380Flush Valve Assembly, Orbital5993Kit, Retrofit for Vacuum Toilet Zero-Time Overhaul121-11747-2( )Cabin Wash Light Lens121-11747-9( )Cabin Wash Light Lens121-11746-22( )Window Reveal Assy STA 1470 RH122-11177-11( )Window Shade Assy121-11747-6( )Cabin Wash Light Lens121-11747-8( )Cabin Wash Light Lens121-11746-11( )Window Reveal Assy Standard121-11746-38( )Window Reveal Assy STA 1470 RH121-11764-1Clip121-11747-3( )Cabin Wash Light Lens121-11747-7( )Cabin Wash Light Lens122-11177-1( )Window Shade Assy121-11759-1( )Inner Reveal121-11746-14( )Window Reveal Assy STA 1470 RH121-11746-20( )Window Reveal Assy Window 1-4122-11176-1( )Shade Assy155-11153-8( )Lavatory Light Lens121-11759-3( )Inner Reveal121-11746-27( )Window Reveal Assy Standard155-11136-1( )Lavatory Assist Handle155-11136-2( )Lavatory Assist Handle121-11767-1( )Outer Reveal155-11153-7( )Lavatory Light Lens121-11747-4( )Cabin Wash Light Lens155-11135-2( )Lavatory Assist Handle121-11760-1( )Reveal Spacer121-11746-6( )Window Reveal Assy STA 1470 RH155-11153-2( )Lavatory Light Lens155-11134-1( )Lavatory Assist Handle121-11746-12( )Window Reveal Assy Window 1-4121-31300-01195Dust Cover121-11746-1( )Window Reveal Assy Standard121-11746-37( )Window Reveal Assy STA 1470 LH125-11261-2( )Assist Handle121-11746-2( )Window Reveal Assy Window 1-4122-11177-5( )Window Shade Assy121-11746-32( )Window Reveal Assy Window 1-4121-11746-19( )Window Reveal Assy Standard155-11134-2()Lavatory Assist Handle121-11761-1( )Outer Reveal122-11174-1( )Rigid Shade121-11765-1( )Outer Reveal121-11746-13( )Window Reveal Assy STA 1470 LH
Back to Boeing 747-400D