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.
61426Tape, Carpet5872-3Top, Lamp Hsg, w/Flanges5872-2Top, Lamp Hsg, w/Flanges5872-1Top, Lamp Hsg, w/Flanges8152-1Photoluminescent Insert with Shell 25" Long5872-10Top, Lamp Hsg, w/Flanges8163-1Floor Track Assembly, Pl Insert, 75" long8170-1Floor Track Assembly for End Cap PL Insert w/Arrows, 45" Long8169-1Floor Track Assembly for End Cap PL Insert, 35" Long61901RTV Adhesive Sealant8164-1Floor Track Assembly, PL Insert w/Arrows, 50" Long8153-1Photoluminescent Insert with Shell and Arrows, 25" Long8165-1Galley Light, Photoluminescent 64.21" Long w/Arrows8170-2Bloor Track Assembly for End Cap PL Insert w/Arrows, 35" Long20050-40MMotorized Conference TableME4ANDEBearing, Rod End23088-006BDC GeneratorLHSSE4DEBearing, Spherical16032-511Shrouded Pipe AssemblyBR9120CWLamp, Cool WhiteMDL-99T033L001Expanded Flight Data Parameters For Teledyne DFDAU446253-1Smoke Detector4426X-2-12Radome2316M-40-2Control Switch, RotaryLHSSE5DEBearingLHSSE3DEBearingLHSSE416DEBearingFSSE4DBearingMSSE3DBCBearingNSS724ABearingLHSSE6DEBearingLHSSE10DEBearingLHSSE16DEBearingLHSSE419DEBearingWE5DEBearingFBE39C27BBearingNSS624ABearing AssyMSSE4DBBearingLHSSE12DEBearingWE8DEBearingLHSSE830DEBearingFSSE3DABearingMSSE3DBBBearingMSSE3DBABearingMSSKE4DBBearingFSSE3DBearingATF14DH2BearingLHSSE520DEBearingWE4DEBearingMSSE5DEBearing
Back to Boeing DHC-8-301