Boeing 747-367
PMA parts · 58,851
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-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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-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.
BACC13AP3D2165Cable AssyBACC13Y3A65Cable AssyBACC2C3B02260BFCable AssyBACC2C3D04516EFCable AssyBACC2C4C08040FGCable AssyBACC13Y3A105Cable AssyBACC13AP3B269Cable AssyBACC2C3B07464CFCable AssyBACC13AA4T45A1795Cable AssyBACC2C4C03451FGCable AssyBACC2C3D01242EGCable AssyBACC2C4C04163EFCable AssyBACC13AP3B2167ACable AssyBACC2C4C00740EGCable AssyBACC2D3B03715EECable AssyBACC13AP4E7520Cable AssyBACC2C3B00280DGCable AssyBACC2C4A05371FGCable AssyBACC2C3D02122EGCable AssyBACC2C3D10740EFCable AssyBACC2C3B02117EGCable AssyBACC2C4A08264FGCable AssyBACC13AP3B1147Cable AssyBACC2D3B01805FGCable AssyBACC13AP3B1031Cable AssyBACC13AP3E10679ACable AssyBACC13AA3T45-7997Cable AssyBACC13AP3B269ACable AssyBACC2C3B00131BECable AssyBACC2C3B02991CFCable AssyBACC2C3D01651EGCable AssyBACC2C4A05771EFCable AssyBACC2C3D02473FGCable AssyBACC2C3B00688DGCable AssyBACC13AP3B1132Cable AssyBACC13AP3E2550ACable AssyBACC13AA3T47-2653ACable AssyBACC2C3B02155EGCable AssyBACC13AA4T84-7585Cable AssyBACC2C3B00638GGCable AssyBACC2C3B02846EFCable AssyBACC2C3D02503FGCable AssyBACC2C3D03669EFCable AssyBACC2C3B03491CFCable AssyBACC13AA4T44-9636Cable AssyBACC13AA3T45-15256Cable AssyBACC13AM3C137Cable AssyBACC2C4C03637EFCable AssyBACC2C3D05261CFCable AssyBACC2C3D04713EFCable Assy
Back to Boeing 747-367