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.
121-11765-1( )Outer Reveal155-11153-1( )Lavatory Light Lens155-11134-1( )Lavatory Assist Handle155-11153-6( )Lavatory Light Lens121-31300-01190Dust Cover155-11153-2( )Lavatory Light Lens155-11135-1( )Lavatory Assist Handle122-11177-1( )Window Shade Assy121-11747-1( )Cabin Wash Light Lens121-11760-1( )Reveal Spacer121-11746-30( )Window Reveal Assy STA 1470 RH121-11746-11( )Window Reveal Assy Standard125-11261-1( )Assist Handle121-11746-1( )Window Reveal Assy Standard155-11134-2()Lavatory Assist Handle122-11177-11( )Window Shade Assy121-11761-1( )Outer Reveal125-11262-1( )Handle Nut121-11747-9( )Cabin Wash Light Lens121-11747-2( )Cabin Wash Light Lens155-11135-2( )Lavatory Assist Handle121-11747-7( )Cabin Wash Light Lens121-11759-3( )Inner Reveal121-11766-1( )Outer Reveal121-11746-20( )Window Reveal Assy Window 1-4122-11176-1( )Shade Assy121-11747-4( )Cabin Wash Light Lens121-11746-22( )Window Reveal Assy STA 1470 RH155-11153-7( )Lavatory Light Lens121-11759-1( )Inner Reveal121-11767-1( )Outer Reveal121-11746-6( )Window Reveal Assy STA 1470 RH121-11746-38( )Window Reveal Assy STA 1470 RH121-11747-8( )Cabin Wash Light Lens125-11261-2( )Assist Handle121-11747-3( )Cabin Wash Light Lens121-11746-12( )Window Reveal Assy Window 1-4121-31300-01195Dust Cover121-11746-19( )Window Reveal Assy Standard121-11746-21( )Window Reveal Assy STA 1470 LH121-11746-28( )Window Reveal Assy Window 1-4155-11153-5( )Lavatory Light Lens121-11746-2( )Window Reveal Assy Window 1-4155-11153-8( )Lavatory Light Lens121-11764-1Clip155-11153-4( )Lavatory Light Lens155-11153-3( )Lavatory Light Lens121-11746-5( )Window Reveal Assy STA 1470 LH121-11747-5( )Cabin Wash Light Lens121-11746-31( )Window Reveal Assy Standard
Back to Boeing 747-400D