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 QXEA9902697Stringer · damagedPDX - HOLE IN STRINGER XN176.5 AT STATION ZN17.04. REPAIRED IAW HORIZON AIR EA 9-54-238, FIGURE 2.SDR QXEA9902694Stringer · crackedPDX - EXHAUST DECK AFT LATERAL STRINGER HAS ONE CRACK. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-40-11.SDR QXEA9902660Stringer · corrodedPDX - CORROSION INBOARD SIDE OF RIGHT-HAND STRINGER 32 AT FRAME STATION 488. INSTALLED NEW STRINGER SPLICE IAW DHC-8 SRM 51-40-11.SDR QXEA9902683Splice · corrodedPDX - CORROSION ON STRINGER SPLICE AT STATION 488.5 AND STRINGER 30RH. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902682Splice · corrodedPDX - CORROSION ON STRINGER SPLICE AT STATION 488.5, STRINGER 29RH. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902651Floor Panel · corrodedPDX - MAIN ENTRY THRESHOLD WHERE FLOOR PANEL ATTACHES HAD NUMEROUS SPOTS OF CORROSION. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902692Ice Shield · scratchedPDX - TWO DEEP SCRATCHES FOUND ABOVE RIGHT ICE SHIELD. REPAIRED IAW HORIZON AIR EA 9-53-530.SDR QXEA9902691Threshold · corrodedPDX - MINOR SURFACE CORROSION AROUND NUT PLATES UNDER MAIN CABIN DOOR THRESHOLD. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 6, PARAGRAPH 2C.SDR QXEA9902622Controller · malfunctionedPDX- ON APPROACH, A STRONG SMELL WAS NOTED IN THE COCKPIT. AFTER LANDING AND ENGINE SHUT DOWN, SMELL LINGERED. SMOKE AND SMELL WAS NOTED IN THE COCKPIT ONLY, NOT THE CABIN. MAINTENANCE REPLACED THE PILOT'S WINDSHIELD AND WINDSHIELD HEAT CONTROLLER. OPERATISDR QXEA9902720Fitting · corrodedPDX - RIGHT MAIN LANDING GEAR RETRACTION ACTUATOR FITTING HAS FRETTING CORROSION ON H MEMBER MOUNTING PADS. REPAIRED IAW HORIZON AIR EA 9-54-233 AND EA 9-54-233A.SDR QXEA9902719Fitting · corrodedPDX - LEFT MAIN LANDING GEAR RETRACTION ACTUATOR FITTING HAS FRETTING CORROSION ON H MEMBER. REPAIRED IAW HORIZON AIR EA 9-54-233 AND EA 9-54-233A.SDR QXEA9902687Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK CHAFFED AND LUG LIP WORN AT APPROXIMATELY STATION 282. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA9902653Splice · corrodedPDX - CORROSION ON STRINGER SPLICE AT STATION 531 AND STRINGER 30 RT. REPAIRED IAW DHC-8 SRM 51-20-16, SRM 51-40-11 AND SRM 51-20-36.SDR QXEA9902643Clip · corrodedPDX - CLIP CORROSION BETWEEN LEFT-HAND STRINGER 32 AND 33 AT FRAME STATION 445. REPAIRED IAW DHC-8 SRM 53-20-21, FIGURE 1.SDR QXEA9902642Clip · corrodedPDX - CLIP CORROSION BETWEEN RIGHT-HAND STRINGER 32 AND 33 AT FRAME STATION 445. REPAIRED IAW DHC-8 SRM 53-20-21, FIGURE 1.SDR CA000110046Line · leaking(CAN) WHEN TOPPING UP THE HYDRAULIC SYSTEM, A LEAK WAS NOTICED ON THE RIGHT WING. INVESTIGATION REVEALED THAT IT WAS COMING FROM A PINHOLE LEAK IN THE RIGHT HAND LIFT DUMP PRESSURE LINE.SDR QXEA9902690Sill · damagedPDX - NICKS BELOW CARGO DOOR SILL. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-2, PARAGRAPH 1 AND 2.SDR QXEA9902672Skin · chafedPDX - CHAFE DAMAGE AT STATION 262.400 AND STRINGER 11S, ABOVE RIGHT FORWARD EXIT, IT IS APPROXIMATELY .003 DEEP. REMOVAL WAS .001. FOUND TO BE WITHIN LIMITS IAW DHC-8 SRM PAGE 4, TABLE 2.SDR QXEA9902668Frame · gougedPDX - GOUGE AT FRAME X618.0, BETWEEN STRINGERS 21S AND 20S. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902644Connector · corrodedPDX - INSPECT DEICE DISTRIBUTOR CANNON PLUGS AND PRESSURE SWITCHES FOR CORROSION AND SERVICEABILITY. REMOVED AND REPLACED PRESSURE SWITCHES. (S/N 6503, 3509, 7020 AND 6951).SDR QXEA9902689Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK CHAFFED AND LUG LIP WORN AT STATION 300. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902688Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK CHAFFED IN BOTTOM OF TRACK APPROXIMATELY AT STATION 330. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902686Seat Track · gougedPDX - SMALL GOUGE IN BOTTOM OF LEFT INBOARD SEAT TRACK, APPROXIMATELY STATION 377. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902664Seat Track · chafedPDX - LEFT OUTBOARD SEAT TRACK HAS CHAFING PITS ON INBOARD LIP APPROXIMATELY STATION 242. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR CA991229010Rod End · loose(CAN) DURING SCHEDULED INSPECTION, THE NR 2 ENGINE CONDITION CONTROL ROD FROM THE TERMINAL QUADRANT TO THE HYDROMECHANICAL FUEL CONTROL UNIT WAS FOUND TO HAVE A LOOSE ROD END AND WAS MISSING A RETAINING RIVIT. THE ROD WAS REPLACED.SDR PCAA9900062Rod End · out of adjustBGM-FLIGHT 3576, RETURNED TO THE FIELD AFTER THE RIGHT MAIN LANDING GEAR DOOR LIGHT REMAINED ON AFTER GEAR RETRACTION. MAINTENANCE INSPECTED AND FOUND THE RIGHT FORWARD GEAR DOOR ACTUATOR ROD END REQUIRING ADJUSTMENT. MAINTENANCE ADJUSTED THE ROD END IAW DHC SDR CA991229009Hydraulic Line · leaking(CAN) WHILE INVESTIGATING A REPORTED HYDRAULIC LEAK IN THE NR2 ENGINE NACELLE, THE NR2 SYSTEM RUDDER RETURN LINE WAS FOUND CHAFED AND LEAKING.SDR QXEA9902693Seat Track · corrodedPDX - LIGHT SURFACE CORROSION ON RIVET HEADS AND WEB PLATE FROM RIGHT-HAND OUTBOARD SEAT TRACK TO STRINGER 23, BETWEEN FRAMES 387.350 AND 405.737. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902639Stringer · corrodedPDX - CORROSION AROUND RIVET LEFT-HAND SIDE OF STRINGER 33 AT FRAME STATION 488. REPAIRED IAW DHC-8 SRM 51-40-11.SDR CA991229011Coffeemaker · overheated(CAN) FLIGHT ATTENDANT REPORTED A BURNING/ELECTRICAL SMELL IN THE GALLEY AREA. LIGHTING AND GALLEY EQUIPMENT WAS SWITCHED OFF AND THE SMELL DISSIPATED. MAINTENANCE INVESTIGATION REVEALED THAT THE SMELL WAS COMING FROM THE COFFEE WARMER AND REPLACED IT.SDR QXEA9902685Frame · corrodedPDX - CORROSION ON FRAME FLANGE AT STATION 531 BETWEEN STRINGERS 30 AND 31 RT. REMOVED LIGHT CORROSION IAW PSM 1-GEN-5, CHAPTER 4, PAGE 4-21, PARAGRAPH 8D. FOUND WITHIN LIMITS IAW DHC-8 SRM 53-00-16, PAGE 4, TABLE 2.SDR QXEA9902684Frame · corrodedPDX - CORROSION ON FRAME FLANGE AT STATION 510 BETWEEN STRINGERS 30 AND 31 RT. REPAIRED IAW 20-32-02, PAGE 2, PARAGRAPH A, B AND C.SDR QXEA9902667Frame · corrodedPDX - CORROSION NUMEROUS PLACED AROUND RIVETS ON TOP OF FRAME X653.349, BETWEEN STRINGER 23S AND 23P. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-2, PARAGRAPH 1 AND 2, SRM 51-20-11, PAGE 6, PARAGRAPH 2C AND SRM 51-40-11.SDR QXEA9902661Clip · corrodedPDX - CLIP HAS CORROSION BETWEEN RIGHT-HAND STRINGER 31 AND 32 AT FRAME STATION 531. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-2, PARAGRAPH 1 AND 2 AND SRM 51-20-11, PAGE 6, PARAGRAPH 2C.SDR QXEA9902655Splice · corrodedPDX - MINOR CORROSION ON TOP FLANGE OF STRINGER SPLICE AT STATION 531 AND STRINGER 28 RT. ACID ETCHED, ALODINED, AND PRIMED. REMOVED CORROSION FOUND TO BE WITHIN LIMITS IAW DHC-8 SRM 53-00-16, PAGE 4, TABLE 2.SDR QXEA9902654Splice · corrodedPDX - CORROSION ON STRINGER SPLICE AT STATION 531 AND STRINGER 29 RT. REPAIRED IAW PSM 1-GEN-5, CHAPTER 4, PAGE 4-21, PARAGRAPH 8D AND DHC-8 SRM 53-00-16, PAGE 4, TABLE 2.SDR QXEA9902681Bracket · corrodedPDX - CORROSION IN AND AROUND NUT PLATE AND BRACKET AT FRAME X618.0, STRINGER 21S. REMOVED SURFACE CORROSION AROUND BRACKET AND IN NUT PLATE. FOUND TO BE WITHIN LIMITS OF DHC-8 SRM 53-00-16, PAGE 4, TABLE 2.SDR QXEA9902671Bracket · corrodedPDX - CORROSION ON UPPER AND LOWER ANGLE BRACKETS, FRAME X636.0, STRINGER 22P. REPAIRED IAW DHC-8 SRM 51-20-41, SRM 51-20-16 AND SRM 51-20-26.SDR QXEA9902670Frame · corrodedPDX - CORROSION ON FRAME X636.0 AT STRINGER 22P. REPAIRED IAW DHC-8 SRM 51-20-26.SDR QXEA9902662Clip · corrodedPDX - CLIP HAS CORROSION OUTBOARD END BETWEEN RIGHT-HAND STRINGER 32 AND 33 AT FRAME STATION 531. REPAIRED IAW PSMI-GEN-5, CHAPTER 4, PART 2, PARAGRAPH 3, 1, PAGE 4-4.SDR QXEA9902659Seat Track · corrodedPDX - MINOR CORROSION ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902658Seat Track · corrodedPDX - MINOR CORROSION ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 471. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902657Seat Track · corrodedPDX - MINOR CORROSION ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 531. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902656Seat Track · corrodedPDX - PITTING CORROSION AND NICKS ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 540-543. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902650Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL AT STATION 488.500. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902649Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL 4 AFT OF STATION 467.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902648Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL BETWEEN STRINGER 467.000 AND 445.500, LESS THAN 1 INCH LONG. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902647Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL AT STATION 405.737. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902646Bracket · chafedPDX - A .25 INCH CHAFE MARK ON TIE IN BRACKET AT FRAME X636.0 AND STRINGER 22S. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-26.SDR QXEA9902645Angle · crackedPDX - LEFT-HAND FORWARD CONNECTION ANGLE WAS CRACKED THROUGH THE OUTBOARD RADIUS. REPAIRED IAW HORIZON AIR EA 9-53-348A.
Back to Boeing DHC-8-102