Boeing DHC-8-102
Service difficulty reports · 9,272
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DHC8102' ORDER BY difficulty_date 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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DHC8102' ORDER BY difficulty_date DESC
Run 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.
SDR HNAA2012020800559Bracket · corrodedUPPER STAIR AFT SUPPORT BRACKET IS CORRODED. REMOVED UPPER STAIR AFT SUPPORT BRACKET. MADE NEW BRACKET AND INSTALLED IAW DWG 85210303.SDR HNAA2012020800558Bracket · corrodedMID CROSS BRACE AFT BRACKET IS CORRODED. CLEANED LIGHT CORROSION, ALODINED AND PRIMED MID CROSS BRACE AFT BRACKET UNDER STAIRS.SDR HNAA2012020800556Stop · corrodedAFT NR 5 STOP IS WORN AND CORRODED. REMOVED OLD STOP ONLY. INSTALLED AFT NR 5 STOP.SDR CA120213005Shaft · corroded(CAN) ROLL CONTROL VERY STIFF. TENSIONED AILERON FUSELAGE CABLES AND LUBRICATED AILERON QUADRANT BEARINGS EXTERNALLY FOR TROUBLESHOOTING. OPS CHECK FLIGHT-ROLL CONTROL CHECKS GOOD. REPLACED LT AND RT BEARINGS IN AILERON QUADRANT. REPLACED BEARINGS IN LT AND SDR CA120210003Pulley · damaged(CAN) LEFT GEAR DOOR OPEN LIGHT ILLUMINATED WHEN GEAR SELECTED UP. ACFT CIRCLED AND RETURNED TO ORIGINATING DESTINATION AND LANDED WITH NO PROBLEMS. WHEN RETURNED TO GATE ACFT WAS TAKEN TO MAINTENANCE. UPON INSPECTION FOUND LT ALTERNATE RELEASE CABLE GUARD SDR HNAA2012020300554Hmu · failedPROGRESSIVE POWER LEVER SPLIT AFTER TAKEOFF APPROX 3 KNOB SPLIT, NR 1 POWER LEVER MAX TORQUE AT 70 PERCENT CHECKED RIGGING IAW 76-00-10Q, NO FIX. SWAPPED PROP GAUGES, NO FIX. SWAPPED GAUGES BACK TO ORIGINAL POSITION. R & R PCU IAW 61-10-10RQ, NO FIX. PROP GOSDR CA120203007Window · cracked(CAN) CABIN WINDOW LT 6 POSITION NOTED WITH MULTIPLE CRACKS IN THE VIEWING AREA. CABIN WINDOW REPLACED IAW AMM 56-20-11 PG 201.SDR HNAA2012020100548Keelbeam · damagedCORROSION FOUND IN WAFFLE DOUBLER BETWEEN FRAME STA X424 AND X434 UNDER STR 31S. HFEC INSPECTION AND BOND TEST CARRIED OUT ON AFFECTED AREA IAW EA09-2012-019. NO CRACKS OR DISBOND INDICATION FOUND. JOINT STRAP AND WAFFLE DOUBLER WERE BLENDED WITHIN LIMITS IASDR HNAA2012020105481Stringer · corrodedRT UNDERFLOOR CABIN STR 31 CORRODED BETWEEN STA X445.00 AND X467.00. REPLACED WITH NEW PARTS AND INSTALLED WITH SOLID RIVETS IAW RD8-53-1834, RD8-51-015 AND DWG 85330028.SDR HNAA2012020100525Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD. REINSTALLED PANEL.SDR HNAA2012020100524Timer · failedDEICE BOOT DO NOT WORK IN AUTO, FAST OR SLOW. MANUAL WORKS OK. R & R BOOT TIMER AND OPS CHECKED GOOD IAW MM 30-10-00.SDR HNAA2012013000522Frame · corrodedRT CABIN UNDERFLOOR FRAME STA 436 IS CORRODED BETWEEN STR 30 AND 31. REPAIRED IAW SRM 53-20-21 AND INSTALLED WITH SOLID RIVETS IAW SRM 51-42-05.SDR HNAA2012013000521Frame · corrodedRT CABIN UNDERFLOOR FRAME STA X445.00 IS CORRODED BETWEEN STR 30 AND 31R. REPAIRED FRAME IAW SRM 53-20-21 AND INSTALLED IAW SRM 51-42-05.SDR HNAA2012013000520Frame · corrodedRT UNDER FLOOR CABIN AT FRAME STA X488.00 IS CORRODED BETWEEN STR 30 AND 31R. REMOVED CORRODED FRAME IAW SRM 53-20-21 AND INSTALLED IAW SRM 51-42-05.SDR HNAA2012013000518Bulb · failedLEFT AFT EMERGENCY LIGHT IS INOPERATIVE. REMOVED LENS, R & R BULB AT SAID LOCATION. REINSTALLED LENS.SDR HNAA2012013000517Bulb · failedCEILING EMERGENCY LIGHT INOPERATIVE AT ROW 7. REMOVED LENS, R & R BULB AT ROW 7. REINSTALLED LENS.SDR HNAA2012013000516Panel · crackedMOST OTBD LIGHTNING HOLE UNDER OTBD ROLL SPOILER PANEL 632EB IS CRACKED. REPAIRED OTBD CRACKED LIGHTNING HOLE UNDER PANEL 632EB IAW EO8-57-12-0040.SDR HNAA2012013000515Connector · contaminatedRT AC BUSS FAILED INFLIGHT. INSPECTED NR 2 AC GENERATOR. FOUND CONTROL ELECTRICAL CONNECTOR TO BE FULL OF OIL. CLEANED CONNECTOR PLUG. INSPECTED NR 2 AC CONTACTOR BOX. NO DEFECTS NOTED. CREW GROUND RAN ACFT. AC SYS OPERATES NORMAL. OK FOR SERVICE IAW MM SDR HNAA2012012700514Light · inoperativeEMERGENCY FLOOR LIGHT UNDER TRIM AT ROW 8 IS INOPERATIVE. REPOSITIONED TRIM AND LIGHT. OPS CHECKED GOOD.SDR HNAA2012012700513Light · looseEMERGENCY FLOOR LIGHT LOOSE AT ROW 3. REPOSITION LIGHT ASSY. OPS CHECKED GOOD.SDR HNAA2012012700512Bulb · failedEMERGENCY FLOOR LIGHTS ARE INOP AT ROW 1,3 AND 9. R & R EMERGENCY FLOOR LIGHTS AT ROW 1,3 AND 9. OPS CHECKED GOOD.SDR HNAA2012012700511Stringer · corrodedSTRINGER BETWEEN X424 AND X436 AND STA 23S IS CORRODED. CLEANED CORROSION BETWEEN X424 AND X436, STA 23S IAW SRM 51-20-11. ALODINED AND PRIMED AS REQUIRED.SDR HNAA2012012700510Floor Support · corrodedAFT FLOOR SUPPORT AT X539 HAS CORROSION. CLEANED CORROSION AT AFT FLOOR SUPPORT AT X539 IAW SRM 51 20-11. ALODINED AND PRIMED AS REQUIRED.SDR HNAA2012012700509Stringer · corrodedSTRINGER FWD ON X445 AND STR 23S IS CORRODED. CLEANED CORROSION AT X445 FRAME AND STR 23S IAW SRM 51-20-11. ALODINED AND PRIMED AS REQUIRED.SDR HNAA2012012700508Structure · corrodedCORROSION FOUND ON FORWARD OF STR X539 FROM STR 24S. CLEANED CORROSION ON FORWARD STR X539 AND STR S4S IAW SRM 51-20-11. ALODINED AND PRIMED AREA AS REQUIRED.SDR HNAA2012012700507Stiffener · crackedBOTH VERTICAL STIFFNERS UNDER RADOME CRACKED AT TOP RIVET. TRIM DAMAGED AREA OUT ON BOTH STIFFNERS IAW RD8-53-7275. COMPLIED WITH HFEC INSPECTION. NO DEFECTS NOTED. COMPLETED REPAIRS AS REQUIRED IAW RD8-53-7275.SDR HNAA2012012600506Indicator · erraticNR 1 N/P INDICATOR VERY ERRATIC DIGITAL AND ANALOG AT 1050 RPM NR 1 PROP SOUNDED ERRATIC. SMOOTHED OUT AT 900 RPM. R & R INDICATOR IAW CHAPTER 20.SDR CA130108002Pulley · failed(CAN) AUTO PILOT SYS WOULD NOT STAY ENGAGED, FLIGHT CREW MANUALLY FLEW ACFT AND REPORTED STIFF AILERON CONTROL RESPONSE. SUBSEQUENT INVESTIGATION FOUND SOME SEIZED PULLEYS MS20220-3 IN AILERON CONTROL SYS. THESE PULLEYS WERE FOUND TO COATED WITH WHAT APPEARS SDR HNAA2012012500502Frame · crackedFRAME CRACKED IN FLIGHT COMPARTMENT RT SIDE AT STA X136.8 AND STR 15. R & R FRAME IN FLIGHT COMPARTMENT RT SIDE. INSTALLED WITH NEW SOLID RIVET AND HI-LOK IAW SRM 57-42-05 AND SRM 51-40-10.SDR HNAA2012012500504Wire · burnedTESTED CAPTAINS ICE DETECTION LIGHT SWITCH. SWITCH WAS STICKING AND ELECTRICAL ODOR DETECTED AFTER PRESSING SWITCH. SMALL TRACE OF SMOKE OBSERVED IN COCKPIT. ICE DETECTOR LIGHTS DAY OPS PERFORMED HIDDEN DAMAGE INSPECTION. NO DEFECTS FOUND. CAPPED AND STOWEDSDR HNAA2012012500503Frame · crackedFRAME CRACKED BS X136.8 AND STR 15. R & R IAW SRM 51-42-05 AND SRM 51-40-10.SDR HNAA2012012500501Module · wrong partLENS ON EMERGENCY FLOOR LIGHT AT ROW 8 IN NOT RED. R & R LENS COVER. OPS CHECKED GOOD.SDR HNAA2012012500500Battery Pack · failedLEFT AFT EGRESS LIGHT IS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY ON LT SIDE AT ROW 3AC IAW MM 33-51-00.SDR HNAA2012012500499Bulb · failedEMERGENCY OVERHEAD LIGHT IN ROW 7 IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2012012500498Bulb · failed1 FORWARD RED EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR KPVA 201201Trim System · malfunctionedON CLIMBOUT NOTICED HEAVY FLIGHT CONTROLS TO THE RIGHT. NOTICED AILERON TRIM INDICATOR SHOWING FULL LEFT. COMPLETED CHECKLIST FOR RUNAWAY TRIM, DECLARED EMERGENCY AND RETURNED TO LNY.SDR HNAA2011012300497Bulb · failedEMERGENCY EXIT DOOR SIGN IN ROW 4DF IS INOPERATIVE. RELAMPED EMERGENCY EXIT SIGN AT SEAT 4DF AND REINSTALLED LIGHT COVER.SDR HNAA2012012300495Wire · damagedCIRCUIT BREAKER 1Q FOR PFCS INDICATOR POPPED AFTER TAKEOFF. RETURN TO FIELD. INSTALLED TEMP WIRE IAW SP 24.4. LOCATED BETWEEN 9800J172 AND 2705P10. WIRE IDENT IS IAB22. OPS CHECKED GOOD.SDR HNAA2012012300494Unknown · failedDURING CRUISE, NR 2 ENGINE TORQUE REDUCED TO 30 TO 50 PERCENT WITH NOTICEABLE POWER LOSS. ALSO 7 TO 10 PERCENT POWER LOSS DURING APPROACH. NO CAUTION OR WARNING LIGHTS ILLUMINATED. R & R NR 2 EEC IAW PM MM72-01-10. GROUND RAN ACFT, COULD NOT DUPLICATE DISCRESDR HNAA2012011900493Caution Panel · failedNR 1 AC GENERATOR FAILED. RESET THEN FAILED AGAIN. R & R AC GCU IAW 24-21-02 AND AC GENERATOR IAW WORKCARD 24-20-11R. OPS AND LEAKED CHECKED GOOD. NR 1 AC GENERATOR CAUTION LIGHT ILLUMINATED IN FLIGHT 2 TIMES LASTING 3 SECONDS EACH WITH NO MASTER CAUTION LISDR HNAA2012011900492Battery Pack · failedLEFT EGRESS LIGHT IS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY ON LT SIDE AT ROW 3 IAW 33-51-00. OPS CHECKED GOOD.SDR HNAA2012011900491Bulb · failedFORWARD LEFT EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. R & R LIGHT BULB IAW 33-51-00. OPS CHECKED GOOD.SDR CA120119009Head · failed(CAN) NR 2 VHF COM HEAD WENT BLANK AND WAS UNABLE TO TRANSMITT ENROUTE. WHEN ARRIVED THE ACFT WAS GROUNDED. NR 2 VHF COM HEAD WAS REPLACED AND ACFT RETURNED TO SERVICE.SDR HNAA2012011800490Brake Assy · crackedCENTER CONSOLE PARK BRAKE QUADRANT FOUND CRACKED AT CABLE BALL END CONNECTING POINT. R & R CENTER PARK BRAKE QUADRANT.SDR HNAA2012011800489Power Supply · failedEMERGENCY LIGHTS WILL NOT OPERATE. R & R EMERGENCY LIGHT POWER SUPPLY IAW WORKCARD 33-50-05R. OPS CHECKED GOOD IAW WORKCARD 33-50-03Q.SDR HNAA2012012600505Structure · damagedTAIL STRUCK DEICING TRUCK BOOM. DAMAGE TO LT HORIZONTAL STABILIZER, LT ELEVATOR, LT TRIM TAB, AND LT L/E. R & R HORIZONTAL STAB IAW 55-10-00 AND WC 55-50-01.SDR HNAA2012011600488Seat Track · corrodedCORROSION FOUND AT LEFT INBD SEAT TRACK FROM STA X182 TO X526. R & R LT SEAT TRACK. REPLACED WITH NEW PARTS AND INSTALLED IAW SRM 51-42-05, SRM51-40-10, RD8-53-4473, RD8-53-1102 AND AMM20-14-01.SDR HNAA2012011600487Seat Track · corrodedCORROSION FOUND ON LT INBD SEAT TRACK IN CARGO AREA BETWEEN STA X526 TO X598. R & R LT SEAT TRACK IAW RD8-51-102,RD8-51-4472 AND SRM 51-42-05,SRM 51-40-10 AND AMM 20-14-01.SDR HNAA2012011600486Seat Track · corrodedCORROSION FOUND AT RT INBD SEAT TRACK FROM STA X182 TO X526. R & R RT SEAT TRACK. INSTALLED WITH SOLID RIVETS, LOCK FASTENERS AND BOLTS IAW SRM 51-42-05, SRM 51-40-10 AND AMM 20-14-01.SDR HNAA2012011600485Seat Track · corrodedLEFT OTBD SEAT TRACK BETWEEN STA 264 AND 504 IS CORRODED IN 10 LOCATIONS. REWORKED CORROSION TO WITHIN LIMITS IAW RD8-53-1342. LT SEAT TRACK BETWEEN STA X429 TO X504 WAS REPLACED WITH NEW ONE AND INSTALLED WITH SOLID RIVETS AND LOCK FASTENERS IAW SRM 51-42-0
Back to Boeing DHC-8-102