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.
RD-AM6003-05Seat Harness AssemblyRD-AK1109020CMEU SOFTWARERD-AA6191-03PCUIS60816-05SEAT CONFIGURATION KITIS60204-03SYSTEM 3000 SEAT EQUIPMENT CONFIGURATIONRD-AM7300-101HARNESS ASSEMBLY DSEB TO SDU, RJURD-AM6755-1SEAT HARNESSRD-AM7126-40HARNESS ASSEMBLY SWD TO SEATRD-AX5902-APSUD Termination PlugIS70107-02SYSTEM EX2 STRUCTURAL INSTALLATIONRD-AA902187-13INSTALLATION KIT, FLIP SCREEN 30X40 IMAGEIW30149-01WBC UPGRADE WIRING INSTALLATIONRD-AX6801PCURD-FA2011-01AREA DISTRIBUTION BOXIS60172-08SYSTEM 3000 SEAT EQUIPMENT CONFIGURATIONRD-AV9123Rack Frame Assy, VCP 8mm Single CellIS60172-04SYSTEM 3000 SEAT EQUIPMENT CONFIGURATIONRD-AM7304-76Harness Assembly Seatback SDU, TPLRD-AA5002-23VIDEO MODULATOR UNITRD-AK02TG002DATABASE SOFTWARERD-AM7300-C9HARNESS ASSEMBLY DSEB TO SDU, RJURD-FA2064-01MULTIBAND ANTENNA ASSEMBLYIW60175-08PC POWER PASSENGER CABIN WIRINGRD-FA2064-01MULTIBAND ANTENNA ASSEMBLYRD-FM7036-076HARNESS ASSEMBLY DISC TO SDU (SGL)RD-FA1041-01ETHERNET SWITCHRD-FA1061-01MEDIA SERVERRD-AA903104-09INSTALLATION ASSEMBLY KIT, GCS RACK, B747RD-AM7391-32HARNESS ASSEMBLY DISC TO RIGHT HAND IN-ARM SDURD-AM6092-07SEAT HARNESS ASSEMBLYWM13440-003-0185CABLE ASSY, LEAKY FEEDER ANTENNARD-AM7303-21HARNESS ASSEMBLY SEATBACK SDURD-AK1155006QMCU OPS SoftwareIS60204-04SYSTEM 3000 SEAT EQUIPMENT CONFIGURATIONRD-FA2051-01TAPPING UNITRD-AM6271-21CABLE ASSEMBLY, VASEB TO VASEBRD-FA2051-01TAPPING UNITRD-AK1151047DSDU OPS SoftwareWM2145-017CABLE ASSEMBLY DISC TO LCDRD-AM6003-111Seat Harness AssemblyRD-AM6214-06HARNESS ASSEMBLY IVASEB TO DISC (SDU)RD-FE7800-11SMART MONITORTL10629-01S3000i SYSTEM INSTALLATIONRD-AA902111FLOPPY DISC DRIVE UNIT/CREDIT CARD READERRD-KA6405-03RJMRD-FA2062-01WIRELESS ACCESS POINTRD-AM6062-46SEAT HARNESSRD-AM6560-02Relay Harness530000-206-315Software IndexRD-AX6436-25RJU
Back to Boeing 747-400D