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 HNAA2012121001091Bulb · inoperativeFLIGHT ATTENDANT EMERGENCY LIGHT SWITCH BACK LIGHT INOPERATIVE. RELAMPED EMERGENCY LIGHT SWITCH. OPS CHECK GOOD, OK FOR SERVICE.SDR HNAA2012121001090Bulb · inoperativeINOPERATIVE FLOOR EMERGENCY LIGHT BETWEEN ROWS 6DF AND 6AC. R & R FLOOR EMERGENCY LIGHT BETWEEN ROWS 6AC AND 6DF.SDR HNAA2012120701089Acm · smokeWHILE ENROUTE, AT 16K, ENCOUNTERED ELECTRICAL ODOR IN FLIGHT DECK WITH F/A REPORTS ODOR IN CABIN TOO, WITH HAZE NOTED NEAR CEILING. INSPECTED ACFT. FOUND ACM AT FAULT. R & R ACM IAW WC 21-50-03I. OPS AND LEAKED CHECKED GOOD.SDR HNAA2012120501088Bulb · failedLEFT AFT FUSELAGE EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED LENS, R & R BULB, AT SAID LOCATION. OPS CHECKED GOOD.SDR HNAA2012120301087Windscreen · smokeIN FLIGHT, LT WINDSHIELD PRODUCED SMOKE AND WAS THEN TURNED OFF. HAD NO ASSOCIATED CAUTION LIGHTS. R & R CAPTAIN'S WINDSCREEN IAW WC 56-00-00R. OPS AND LEAKED CHECKED GOOD.SDR HNAA2012120301085Bulb · failedONE FLOOR LEVEL EMERGENCY LIGHT AT ROW 8 IS INOPERATIVE. R & R FLOOR LEVEL EMERGENCY LIGHT AT ROW 8. OPS CHECKED GOOD.SDR HNAA2012120301084Battery Pack · inoperativeLEFT AFT EMERGENCY EXIT, FORWARD ROW 4 AND 7 OVERHEAD LIGHTS ARE INOPERATIVE. R & R EMERGENCY LIGHT BATTERY IAW WC 33-50-05R. OPS CHECKED GOOD.SDR HNAA2012120301083Oil System · lowAFTER DEICING, ON TAKEOFF, NR 1 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED. ABORTED TAKEOFF AND SHUTDOWN NR 1 ENGINE. WARNING LIGHT WAS ILLUMINATED FOR APPR0X 5 SECONDS. INSPECTED NR 1 ENGINE AND FOUND ENGINE 3 QUARTS LOW. SERVICED ENGINE WITH 3 QUARTS OSDR HNAA2012113001082Bulb · failedOVERHEAD EMERGENCY LIGHT AT ROW 2 IS INOPERATIVE. REMOVED LENS PANEL, R & R BULB. OPS CHECKED GOOD.SDR HNAA2012113001081Bulb · failedEMERGENCY LIGHT SWITCH LIGHT IS INOPERATIVE IN NORMAL POSITION. R & R BULB FROM LIGHT SWITCH IN F/A PANEL. OPS CHECKED GOOD.SDR HNAA2012112901080Bulb · failedRT AFT FUSELAGE EXTERIOR EMERGENCY LIGHT IS DIM. R & R BULB, OPS CHECKED GOOD.SDR HNAA2012112901078Control Box · malfunctionedEMERGENCY LIGHTS FLICKERED ENROUTE. R & R EMERGENCY LIGHT CONTROL BOX IAW 61-10-11. OPS CHECKED GOOD. EMERGENCY LIGHTS DID NOT ILLUMINATED.SDR HNAA2012112901079Brush Block · inoperativeR & R NR 2 PROP BRUSH BLOCK IAW 61-10-11. OPS CHECKED GOOD.SDR HNAA2012112901077Bulb · failedROW TWO CEILING EMERGENCY LIGHT IS INOPERATIVE. R & R BULB.SDR CA121129005Circuit Breaker · intermittent(CAN) DURING COMPLETION OF TASK 2620/04, CONTINUITY CHECK OF FIRE BOTTLE DISCHARGE CARTRIDGES, 1 YEAR INTERVAL, ENGINEER FOUND 7 AMPS CIRCUIT BREAKER G2 FIRE EXT 1 & 2 INTERMITTENT. CIRCUIT BREAKER REPLACED AND SYS TESTED SERVICEABLE.SDR HNAA2012112701075Actuator · leakingHYDRAULIC QTY DROPPED TO 1QT. JUST BEFORE TAKEOFF AND ISO VALVE CAUTION LIGHT ILLUMINATED. SERVICED NR 1 HYD AND OPERATED NR1 HYD SYS AND FOUND RT INBD SPOILER ACTUATOR LEAKING. R & R RT INBD SPOILER ACTUATOR IAW MM 27-14-05. OPS AND LEAKED CHECKED GOOD.SDR HNAA2012112701074Switch · shortedEMERGENCY LIGHTS FLICKERED ON CLIMBOUT WITH PROP HEAT AND IGNITERS ON. LIGHTS DID NOT FLICKER DURING CRUISE OR IN DECENT. R & R F/A EMERGENCY LIGHT SWITCH. SYS CHECKED GOOD IAW AMM 33-52-00. OK FOR SERVICE. FOUND F/A SWITCH SHORTING DURING SYS INSPECTION.SDR HNAA2012112701073Warning Light · false activationNR 1 ITT INCREASED AND DECREASED ON CLIMBOUT. BOTH ANAOLOG AND DIGITAL. ALL OTHER PARAMETERS NORMAL. INSPECTED ENGINE WIRING FOR CONDITION AND SECURITY. CHECKED TRIM RESISTOR, READ WIRING FROM ENGINE TO GAUGE. CHECKED READING AT BOTH TERMINAL BLOCKS ON ENGISDR HNAA2012112601072Sensor · failedSTRONG ODOR IN AFT CABIN WITH ENGINE BLEEDS ON. RETURN TO GATE FOUND AUTO TEMP TO BE INOPERATIVE. MANUAL CONTROL OPS NORMAL. R & R CABIN ZONE TEMP SENSOR IAW MM 21-60-44. OPS CHECKED GOOD. NO ODOR.SDR HNAA2012112601071Brush Block · failedIN FLIGHT, RT AC BUSS CAUTION LIGHT ILLUMINATED WITH FAILURE OF ASSOCIATED SYS. REMOVED NR 2 PROP BRUSH BLOCK ASSY IAW AMM 61-10-11. OPS CHECKED SLIP RINGS ON NR 2 PROP IAW AMM 61-10-00. GROUND RAN ACFT. OPS CHECKED GOOD.SDR HNAA2012112601070Control Box · intermittentEMERGENCY LIGHTS FLICKERED ON /OFF IN FLIGHT OVERHEAD AND EXIT SIGNS. INSPECTED BOTH BRUSH BLOCKS. NO DEFECTS NOTED. R & R EMERGENCY LIGHT CONTROL BOX. OPS CHECKED GOOD IAW WC 33-50-03.SDR HNAA2012112601068Lens · dirtyEMERGENCY EXIT BETA LIGHT IS DIM. R & R BETA LIGHTS ON AFT EMERGENCY DOORS. CLEANED LENS COVER AND REINSTALLED. OPS CHECKED GOOD.SDR CA121204004Line · chafed(CAN) THE FLIGHT CREW REPORTED AN OIL LEAK ON THE NR N2 ENGINE. MAINTENANCE INVESTIGATION REVEALED THAT THE NR 6 & NR 7 BEARING PRESSURE OIL LINE WAS CHAFED AND LEAKING, WHERE IT PASSES THROUGH THE ENGINE FIRE SEAL. THE OIL LINE WAS REPLACED AND THE ACFT RETUSDR CA121127006Wire · chafed(CAN) AIRCRAFT DEPARTED, ENROUTE, APPROACHING FL20 BOTH AC GENERATOR CAUTION LIGHTS AS WELL AS BOTH TRU CAUTION LIGHTS AND ASSORTED AC HEATING SYS CAUTION LIGHTS ILLUMINATED. PILOT CONFIRMED LOSS OF ALL AC ELECTRICAL POWER AND FOLLOWED QRH FOR FAULT ALLEVIATIOSDR HNAA2012112101065Pump · failedNR 2 STANDBY PUMP CIRCUIT BREAKER TRIPPED IN FLIGHT. R & R NR 2 STANDBY HYD PUMP. OPS AND LEAKED CHECKED GOOD IAW MM 29-11-17.SDR HNAA2012112101063Brush Block · unknownEMERGENCY LIGHTS FLICKERED ON CLIMBOUT WITH NR 2 PROPELLER A PHASE. REMOVED FWD UPPER COWL PANEL ON NR 2 ENGINE. INSPECTED BRUSH BLOCK ASSY SLIP RINGS AND HEATER LEADS. NO FAULTS FOUND, REINSTALLED PANEL. REMOVED FORWARD UPPER COWL AND NR 1 ENGINE ENGINE ASDR HNAA2012111901062Combustion Head · odorAFTER STARTING APU, NOTICED STRONG FUEL ODOR FOLLOWED BY APU SHUTDOWN. INSPECTED, NO LEAKS FOUND, CONFIRMED PROBLEM WITH BLEEDS ON. R & R APU COMBUSTER IAW AMM 49-20-00. OPS AND LEAKED CHECKED GOOD. RAN APU WITH BLEEDS ON. NO FUEL ODOR NOTED. CLEARED MELSDR HNAA2012111901061Control Box · malfunctionedEMERGENCY LIGHTS FLICKERED ON AND OFF DURING TAXI. R & R EMERGENCY LIGHTS CONTROL BOX. GROUND RAN ACFT. OPS CHECKED GOOD AT THIS TIME. OK FOR SERVICE.SDR HNAA2012111601060Frame · corrodedFRAME CORRODED AND CRACKED. DOUBLER IS ALSO LIFTED. R & R FRAME SECTION AT BS 202 IAW EA 16-2012-013 AND DWG 85320004 AND EA 16-2012-014.SDR HNAA2012111601059Skin · corrodedLOWER FUSELEGE SKIN AT FRAME BS 354.25 AND S31S IS CORRODED. CLEANED CORROSION AND REPAIRED FRAME LEG AT BS 353.25 AND STR 31S IAW 53-20-21.SDR HNAA2012111601058Frame · crackedFRAME CRACK IN CORNER NEAR RIVET HEAD AT BS 222 AND S31S CABIN UNDERFLOOR. REPAIRED FRAME LEG IAW SRM 53-20-21.SDR HNAA2012111601057Seat Track · corrodedRT SEAT TRACK CORRDED AT LAVATORY ATTACH POINT. REPAIRED RT FORWARD INBD SEAT TRACK IAW RD 8-53-3074.SDR HNAA2012111601056Frame · crackedFRAME CRACKED AT LT SIDEWALL AT BS 545, AFT OF SEAT ROW 9, FORWARD OF BAG BAY DOOR TRACK. REMOVED FRAME MEMBER AND FABRICATED NEW ONE IAW DWG NR 85331201. HEAT TREATED, PERFORMED CONDUCTIVITY TEST ON FABRACATED PART. INSTALLED FRAME MEMBER AS REQUIRED.SDR HNAA2012111601055Step · corrodedBOTH GOOSENECKS SHOW CORROSION AT TOP EDGE OF PAX DOOR STEP ASSY. REMOVED PAX DOOR STEP ASSY, INSTALLED NEW PAX DOOR STEP ASSY IAW MM 52-10-00.SDR HNAA2012111501054Battery Pack · failedTWO FORWARD MOST FLOOR PATH EMERGENCY LIGHTS ARE INOPERATIVE. R & R BATTERIES IAW WC 33-50-05R. OPS CHECKED GOOD.SDR CA121203001Connector · failed(CAN) DURING CRUISE, NR 1 ENGINE HAD A LOW OIL PRESSURE INDICATION. THE CREW SHUT IT DOWN AND RETURNED TO THE DEPARTURE AIRPORT WHERE AN UNEVENTFUL SINGLE ENGINE LANDING WAS MADE. TROUBLESHOOTING FOUND THAT A CONNECTOR ON THE ENGINE CAUSED A FALSE INDICATIONSDR CA121119006Control Unit · faulted(CAN) SHORTLY AFTER TURNING ON THE ELECTRICAL POWER, FLIGHT CREW NOTICED AN ABNORMAL ELECTRICAL ODOR. ELECTRICAL POWER WAS TURNED OFF AND MAINTENANCE CONTACTED. THE ADVISORY LIGHT CONTROL UNIT WAS FOUND AT FAULT. IT WAS REPLACED, TESTED AND THE ACFT RELEASED SDR CA121114011Blade · cracked(CAN) REF: DEFECT-1085552, THE RT PROPELLER, NR 4 BLADE HAS AN APPROXIMATELY 3" CRACK EMANATING FROM UNDER THE EROSION STRIP AT APPROXIMATELY BS 46 ON THE CAMBER SIDE. RESOLVED ON WO: 360653, TASKCARD: NR-00008, RT 4 PROPELLER BLADE REPLACED IAW MM. PN- SFA13SDR HNAA2012111401053Sill · corrodedCORROSION AT AFT LOWER SILL OF FORWARD EMERGENCY EXIT DOOR. CLEANED CORROSION IAW SRM 51-20-11. ALODINED AND PRIMED EXPOSED METAL.SDR HNAA2012111401052Skin · corrodedCORROSION ON FORWARD PAX DOOR STOP ON CROSSBEAM NR 2. R & R PAX DOOR SKIN WITH NEW.SDR HNAA2012111401051Threshold · corrodedCORROSION IS PRESENT AT BOTTOM SIDE OF BAG BAY DOOR THRESHOLD, FORWARD END. REMOVED BAG BAY DOOR THRESHOLD. CLEANED CORROSION FROM BOTTOM SIDE, APPLIED ALODINE AND PRIMED. REINSTALLED THRESHOLD.SDR HNAA2012111401050Bearing Race · corrodedFORWARD SIDE OF AIRSTAIR HAS PITTED CROSSMEMBER BEARING RACE. R & R BEARING HOUSING AS NEEDED.SDR HNAA2012111401048Seat Track · corrodedRT INBD SEAT TRACK IN CARGO BAY IS CORRODED AT BS 564. R & R SEAT TRACK. DRILLED FASTENERS THROUGH WEBBING, INSTALLED NEW SEAT TRACK IAW DWG 85330129.SDR HNAA2012111401049Support Bracket · crackedFORWARD BAG BAY DOOR TRACK MID SUPPORT BRACKET IS CRACKED. R & R FORWARD BAG DOOR TRACK MID SUPPORT BRACKET USING RETAINED HARDWARD.SDR HNAA2012111401047Cable · corrodedSECOND CABLE, INBD CORRODED IN BAG BAY CABIN UNDER FLOOR. CLEANED CABLE ON RT SIDE OF BAG BAY UNDER FLOOR AS NEEDED IAW AMM 20-60-01. EVALUATED CABLE CONDITION AND DETERMINED IT WAS AIRWORTHY IAW BULLETIN 20-60-01.SDR HNAA2012111401046Cable · corrodedFIRST AND SECOND CABLE SHOWS SIGNS OF CORROSION AT X564 ON OTBD CABLES. CLEANED CABLES IAW MM 20-60-01. EVALUATED CABLES AND DETERMINED AIRWORTHY IAW BULLETIN 20-60-01.SDR HNAA2012111401044Windshield · smokeSMOKE EMITTED FROM F/O FORWARD WINDSCREEN AT HEAT WIRE CONNECTION. SMOKE STOPPED WHEN WINDSHIELD HEAT WAS TURNED OFF. REPLACED F/O WINDSHIELD IAW 56-00-00R.SDR HNAA2012111401043Unknown · malfunctionedON CLIMBOUT, RT AC BUSS, RT STALL WARNING, RT TRU AND ELEVATOR HORN HEAT CAUTION LIGHTS ILLUMINATED. CLEANED CONNECTOR PLUGS AT NR 2 AC GEN. R & R NR 2 AC GCU. OPS CHECKED GOOD IAW MM 24-21-00. OK FOR SERVICE. ON CLIMB OUT, RT AC BUSS, RT STALL WARNING, RTSDR CA121114008Actuator · cracked(CAN) ACFT WAS ROLLING WITH NORMAL BRAKES APPLIED, HAD TO USE EMERGENCY BRAKES TO STOP. ACFT RETURNED TO THE GATE. THE NR 1 HYDRAULIC SYS WAS VERY LOW ON FLUID AND THERE WAS A LEAK NEAR THE RT NACELLE. MAINTENANCE INVESTIGATION FOUND THE RT INBD ROLL SPOILERSDR HNAA2012111201042Wire · brokenNR 1 HYDRAULIC STANDBY PUMP INOPERATIVE, ZERO PRESSURE. FOUND WIRE 10009B22 BROKEN AT P4 CONNECTOR PLUG. REPAIRED WIRE USING STD MTC PRACTICE. OPS CHECKED GOOD.
Back to Boeing DHC-8-102