Boeing DHC-8-301
PMA parts · 505
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 ('A13NM')
AND len(list_intersect(tcds_models, ['DHC-8-301'])) > 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 ('A13NM')
AND len(list_intersect(tcds_models, ['DHC-8-301'])) > 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.
BF5-0572-954Lens AssemblyBC5-0393-278Lens AssyBF5-0572-901LensBC5-0393-282Lens AssyBF5-0573-915Exit LensBF5-0572-913Exit LensBF5-0572-955Lens AssemblyBC5-0393-281Lens AssyBF5-0573-919Exit LensBF5-0575-919Lens AssemblyBVO3302-12-150LampholderBR6303-104-3Light Strip Assy LavBVO3302-11-150LampholderBF5-0572-919Vertical Exit LensBR9070-005Exit SignBF5-0572-907Exit LensBF5-0572-915Lens German/EnglishBF5-0595-904Lens AssemblyBR6303-104-1Light Strip Assy LavBF5-0573-907Exit LensBF5-0572-923Vertical Exit LensBF5-0566-903LensBF5-0575-903Lens German/EnglishBF5-0572-926LensBF5-0575-909Lens English/JapaneseBF5-0572-962Exit LensBF5-0572-925LensBF5-0572-961Exit LensBC5-0393-277Lens Assy804-0500secureLINK1252-A-3700-01HD-7101252-A-3600-01HD-710804-0500-003secureLink2610508K-1Securelink Installation KitAD-55-2198-1Battery PackAD-21740Receptacle Connector02T1050-13PLACARD02T1015-1DOOR ASSY02T1020-3LATCH ASSY02T1044-19BOTTOM DOOR STOP02T1044-21FILLER PLATE02T1032-3BEARING BLOCK ASSY02T1050-11PLACARD02T1000-105FOAM GUARD388-14-000GASH TRAY ASSY02T1044-57HINGE GUARD WELDMENT ASSY02T1032-5BEARING BLOCK ASSY02T1044-29HANDLE GUARD02T1050-15PLACARD02T1050-17PLACARD
Back to Boeing DHC-8-301