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 CA990817013Wire · broken(CAN) DURING CRUISE, NR 2 HYDRAULIC LOW PRESSURE CAUTION LIGHT ILLUMINATED ALONG WITH PRESSURE FLUCTUATION. PRESSURE INDICATION WAS CAUSED BY BROKEN WIRE AT THE TRANSDUCER. CAUTION LIGHT MALFUNCTIONED BECAUSE OF FAULTY SWITCH.SDR QXEA9901648Mechanism · dirtySEA- MAIN CABIN DOOR HARD TO OPEN FROM INSIDE. CLEANED MAIN CABIN DOOR SEAL AND DOOR LOCKING/UNLOCKING LEVERS. OPERATIONAL TEST GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR HNAA9900111Battery · dischargedNR 3 AND NR 4 RED FLOOR ESCAPE LTS INOP. REMOVED AND REPLACED LEFT AFT EMERGENCY LT BATTERY AND BASE. OPS CHECK GOOD.SDR AU990945Frame · cracked(AUS) RIGHT FUSELAGE FRAME LOCATED AT STN 354.25 CRACKED. THE CRACK RAN FROM THE CUT-OUT FOR STRINGER NR 22 AND PROGRESSED COMPLETELY THROUGH THE FRAME. CRACK LENGTH APPROXIMATELY 76.2 MM TO 101.6 MM (3 INCHES TO 4 INCHES).SDR QXEA990139Mechanism · out of adjustMWH- GEAR DOOR LIGHT ILLUMINATED. GEAR DOOR REMAIN OPEN. ADJUSTED RIGGING OF LEFT HAND MAIN LANDING GEAR REAR/CENTER DOOR ACTUATOR, FUNCTIONAL CHECK OF GEAR GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR PCAA9900027Mechanism · lack of lubeBWI - FLT 3900 - MAIN CABIN DOOR VERY DIFFICULT TO OPEN. MAINTENANCE LUBED AND INSPECTED THE AIRSTAIR DOOR LIFT MECHANISM IAW CHAPTER 52. CHECKED WITHIN LIMITS. AIRCRAFT RETURNED TO SERVICE.SDR CA990907055Valve · failed(CAN) ON APPROACH, LANDING GEAR FAILED TO EXTEND. ALTERNATE GEAR EXTENSION SELECTED. DURING TAXI, NOSE WHEEL STEERING ALSO FAILED. DOWN COIL IN LANDING SELECTOR VALVE WAS U/S.SDR CA990817012Hmu · malfunctioned(CAN) 10 PERCENT TORQUE FLUCTUATIONS EXPERIENCED IN CRUISE FLIGHT. ENGINE ELECTRONIC CONTROL TO MANUAL STABILIZED THE ENGINE. INSPECTION AND DIAGNOSTIC TESTING RESULTED IN HMU REPLACEMENT.SDR CA990915009O-Ring · deteriorated(CAN) DURING ROUTINE INSPECTION ,THE NR 1 BRAKE WAS FOUND TO BE LEAKING. TEAR DOWN OF THE BRAKE UNIT REVEALED DETERIORATED O-RINGS ON THREE OF THE BRAKE PISTONS, AND THE BACK-UP RINGS WERE FOLDED OVER THE PISTON, BETWEEN THE PISTON ASSY AND THE SLEEVE. THE BSDR AU990850Harness · worn(AUS) WIRING LOOM LOCATED IN FLAP RECESS INBOARD OF THE LT ENGINE WAS CHAFED AND BADLY BURNT. TWO POWER WIRES FOR THE LT STANDBY HYDRAULIC PUMP AND ONE POWER WIRE FOR THE RT STANDBY HYDRAULIC PUMP OPEN CIRCUITED. WIRE 7611-10006D22-2 (ECU WIRING) WAS ALSO OSDR AU990812Strut · cracked(AUS) ENGINE MOUNT VERTICAL STRUT CRACKED.SDR PCAA9900026Actuator · failedBTV - UPON DESCENT, THE LEFT MAIN GEAR DID NOT EXTEND WHEN SELECTED. GEAR EXTENDED 45 SECONDS LATER WITH DOWN AND LOCKED INDICATION. MAINTENANCE REMOVED AND RPELACED THE LEFT MAIN GEAR UPLOCK ACTUATOR IAW CHAPTER 32. CYCLED GEAR SEVERAL TIMES, OPERATIONAL CSDR CA990907054Connector · corroded(CAN) NR 2 AC GENERATOR DROPPED OFF-LINE DURING TAXI. CORROSION WAS FOUND ON CANNON PLUG AND ONE PIN FROM THE GCU WAS STUCK IN THE PLUG RECEPTACLE. PLUG AND GCU WERE REPLACED.SDR CA990817005Line · leaking(CAN) DURING CRUISE FLIGHT, NR 1 HYDRAULIC PRESSURE AND FLUID WERE LOST. LINE BETWEEN THE PRESSURE MANIFOLD AND ANTI-SKID CONTROL VALVE WAS LEAKING. LINE WAS PRE-MOD ALUMINUM. PUMP AND FILTERS REPLACED.SDR HNAA9900109Light · inopFLOOR EMERGENCY LIGHT 5TH LIGHT AFT IS INOP. REMOVED AND REPLACEDD LIGHT ASSY.SDR CA990817035Selector Valve · leaking(CAN) LOWER END CAP WAS FOUND LEAKING WHEN ACCOMPLISHING SB A8-32-145. VALVE REPLACED.SDR CA990817034Solenoid Valve · failed(CAN) NOSE GEAR FAILED TO EXTEND WHEN GEAR SELECTED DOWN WITH RED LIGHT ILLUMINATED. NOSE LANDING GEAR SOLENOID SEQUENCE VALVE REPLACED.SDR CA990817031Line · leaking(CAN) CREW NOTICED HYDRAULIC FLUID COMING FROM THE LEFT LOWER WING OUTBOARD SPOILER. SPOILER RETURN LINE HAD A PIN HOLE IN IT.SDR HNAA9900108Light · inopFIRST EMERGENCY LIGHT (FWD) ON FLOOR INOP. REMOVED AND REPLACED EMERGENCY LIGHT OPS CHECK GOOD.SDR CA990915006O-Ring · deteriorated(CAN) DURING ROUTINE INSPECTION,THE NR 1 BRAKE WAS FOUND TO BE LEAKING. TEAR DOWN OF THE BRAKE UNIT REVEALED DETERIORATED O-RINGS ON TWO OF THE BRAKE PISTONS, AND THE BACK-UP RINGS WERE FOLDED OVER THE PISTON, BETWEEN THE PISTON ASSY AND THE SLEEVE. THE BRAKSDR QXEA9901524Bolt · looseSEA - MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE RESECURED HANDRAIL SUPPORT PIVOT BOLT. OPERATIONAL CHECKS GOOD. NO PARTS REPLACED.SDR PCAA9900025Switch · malfunctionedMVY-LGA, FLT 3690-ON APPROACH INTO LGA, THE RIGHT MAIN GEAR LIGHT ILLUMINATED RED. CREW PERFORMED A GO AROUND, CYCLED THE GEAR AND THE LIGHT INDICATED DOWN AND LOCKED. MAINTENANCE PERFORMED A PSEU TEST AND FOUND NO FAULTS. CLEANED DRAG STAY PROXIMITY SWITCHSDR QXEA9901591Frame · corrodedPDX - NACELLE FRAME UNDER MAIN LANDING GEAR RETRACTION ACTUATOR FITTING HAS FRETTING CORROSION. REPAIRED IAW HORIZON AIR EA 9-54-203.SDR HNAA9900112Skin · crackedAFT FUSELAGE, SMALL CRACK IN SKIN APPROX 5 IN FWD OF FRAME 3 AT STR 33. TEMP REPAIRED IAW RD8-53-2181. TEMP REPAIRED PER ENGINEERING. FWD TO ENGINEERING FOR PERM REPAIR. DEFERED FOR 240HRS. ON 8/20/99, THIS DMT WAS CLEARED PER EO8-53-99-290.SDR CA990817032Generator · failed(CAN) NR 2 AC GENERATOR CAUTION LIGHT CAME ON DURING FLIGHT. GENERATOR HAD INTERNAL FAILURE.SDR CA990817003Tru · failed(CAN) DURING FLIGHT, NR 2 TRU ILLUMINATED AND WOULD NOT ACCEPT A LOAD ON THE GROUND. TRU REPLACEDSDR QXEA9901525Mechanism · lack of lubePDX - MAIN CABIN DOOR DIFFICULT TO OPEN. LUBRICATED MAIN CABIN DOOR MECHANISM. FLIGHT ATTENDANT OPERATED DOOR, NO EXCESSIVE EFFORT REQUIRED TO OPEN DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA9901523Controller · malfunctionedSEA - EMERGENCY EXIT TRACK LIGHTING ILLUMINATED IN FLIGHT, CYCLED SWITH WITH NO CHANGE. MAINTENANCE REPLACED THE LIGHTING CONTROLLER. DURING OPERATIONAL CHECK THE FORWARD EXIT LOCATOR LIGHTS WENT OUT. REPAIRED A BROKEN WIRE UNDER THE FLOOR.SDR HNAA9900107Prop · damagedWHEN DEPARTING DCA, ACFT VIBRATED BAD. NR 1 PROP, NR 2 BLADE DAMAGED. NR 1 ENG REQUIRES VISUAL INSP OF 1ST STAGE IMPELLER FOR EVIDENCE OF SOFT OR HARD MATERIAL INGESTION. NR 1 PROP NR 2 BLADE REQUIRES SB14SF-61-118 PERFORMED BEFORE REVENUE FLIGHT. INSPECTSDR AU990695Generator · failed(AUS) NR 2 ALTERNATE CURRENT GENERATOR FAILED INTERNALLY. DEBRIS FROM FAILED GENERATOR CONTAMINATED THE ENGINE OIL SYSTEM.SDR AU990724Connector · contaminated(AUS) LEFT ENGINE OIL PRESSURE SENDER UNIT CONNECTOR CONTAMINATED WITH OIL.SDR QXEA9901585Angle · crackedPDX - LEFT FORWARD WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW DHC8 SRM 51-40-00, PAGE 4, TABLE 4.SDR HNAA9900106Skin · crackedEXHAUST OUTLET SHROUD INNER SKIN CRACKED AT FORWARD O/B END. REPAIRED IAW RD8-54-331 AND EO8-54-99-255.SDR CA990804031Line · leaking(CAN) HYDRAULIC FLUID FROM NLG AREA. NLG DOOR CLOSE LINE WAS LEAKING UNDER PRESSURE.SDR QXEA9901605Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK HAS TWO GAUGES AT X268. REPAIRED IAW DHC-8 SRM 51-26-26.SDR QXEA9901600Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK AT X312 HAS CORROSION PITS. REPAIRED IAW RD 8-53-1342.SDR QXEA9901599Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK AT X327 HAS DEEP CORROSION PITS. REPAIRED IAW DHC8 SRM 51-26-26.SDR QXEA9901597Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION PITS IN THE HAT CHANNEL AT X364. REPAIRED IAW RD 8-53-1342.SDR QXEA9901596Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION PITS IN THE HAT CHANNEL AT X374. REPAIRED IAW RD 8-53-1342.SDR QXEA9901594Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK AT STATION 342 THERE IS CORROSION PITS. REPAIRED IAW RD 8-53-1342.SDR QXEA9901588Housing · chafedPDX - LEFT NR 5 FLAP CARRIAGE HOUSING ASSEMBLY IS CHAFED ON INBOARD SIDE WHERE FAIL/SAFE STRAP MOUNTS. REPAIRED IAW HORIZON AIR EA 9-57-437.SDR CA990817002O-Ring · deteriorated(CAN) DURING INSPECTION, NR 2 BRAKE WAS FOUND LEAKING FROM ONE PISTON. THE BACKUP O-RING WAS FOLDED OVER BETWEEN THE PISTON ASSY AND SLEEVE.SDR QXEA9901589Flap Track · out of adjustPDX - LEFT NR 4 FLAP TRACK ASSEMBLY TO CHECK GAPS. REPAIRED IAW HORIZON AIR EA 9-57-436.SDR QXEA9901584Flap Track · out of positionPDX- LEFT NR 4 FLAP TRACK AFT ATTACH GAPS DO NOT MEET MANUFACTURERS SPECS. REPAIRED IAW HORIZON AIR EA 9-57-436.SDR QXEA9901583Flap Track · out of positionPDX - LEFT NR 5 FLAP TRACK AFT ATTACH GAPS DO NOT MEET MANUFACTURER SPECS. REPAIRED IAW HORIZON AIR EA 9-57-436.SDR QXEA9901577Flap Track · out of adjustPDX - RIGHT NR 4 FLAP TRACK AFT MOUNT GAPS DO NOT MEET MANUFACTURERS GAP SPECS. REPAIRED IAW HORIZON AIR EA 9-57-436.SDR QXEA9901576Mount · out of adjustPDX - RIGHT NR 4 FLAP AFT MOUNT GAPS DO NOT MEET MANUFACTURERS GAP SPECS. REPAIRED IAW HORIZON AIR EA 9-57-436.SDR CA990804023Hose · cracked(CAN) PITOT STATIC TEST FOUND A LARGE LEAK AT STANDBY ALT STATIC HOSE. FOUND BADLY DETERIORATED AND CRACKED.SDR HNAA9900099Power Supply · inoperativeAFT OVERHEAD DOWN, MID CABIN EXIT AND EXTERIOR AFT LT EGRESS EMERGENCY LTS INOP. REMOVED AND REPLACED POWER SUPPLY.SDR QXEA9901582Skin · damagedPDX - LEFT OUTBOARD FLAP ASSEMBLY INBOARD SIDE HAS COMPOSITE DAMAGE. REPAIRED IAW DHC8 SRM 51-40-00, PAGE 201, FIGURE 2.
Back to Boeing DHC-8-102