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 CA991103008Indicator · fluctuated(CAN) FLIGHT CREW REPORTED THAT THE NR 1 FUEL GAUGE WAS INTERMITTENTLY INDICATING 400 TO 500 POUNDS HIGH. MAINTENANCE REPLACED THE GAUGE.SDR CA991209054Pseu · malfunctioned(CAN) DURING DESCENT, THE LEFT LANDING GEAR DOWN AND LOCKED LIGHT (GREEN) CAME ON INTERMITTENTLY UNTIL THE LANDING GEAR WAS SELECTED DOWN. MAINTENANCE REPLACED THE PSEU AND GROUND CHECKED THE SYSTEM WITH NO FURTHER FAULTS FOUND.SDR QXEA9902253Skin · chafedPDX - RIGHT NACELLE EXHAUST FINGERNAIL DECK HAS 1 .5 BY .75 HOLE CHAFED THROUGH AT STATION XN 224.76. REPAIRED IAW DHC-8 SRM 51-40-00, PAGE 1 THROUGH 4.SDR QXEA9902252Skin · chafedPDX - RIGHT NACELLE EXHAUST FINGERNAIL DECK HAS DEEP CHAFE MARKS AT STATION XN 224.76. REPAIRED IAW DHC-8 SRM 51-40-00, PAGE 1 THROUGH 4.SDR AU991040Tscu · faulty(AUS) RIGHT ENGINE TORQUE SIGNAL CONDITIONER (TSCU) FAULTY. THE FAILURE WAS FOUND TO BE IN THE ENGINE INDICATION SYSTEM OF THE TSCU.SDR QXEA9902298Seat Track · corrodedPDX - LEFT OUTBOARD CABIN SEAT TRACK BETWEEN FUSELAGE STATION 436.500 AND 456.500 HAS CORROSION ON TOP SURFACE AND INSIDE CHANNEL. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902297Seat Track · corrodedPDX - LEFT OUTBOARD CABIN SEAT TRACK BETWEEN FUSELAGE STATION 291.400 AND 366.000 HAS CORROSION ON TOP SURFACE AND INSIDE CHANNEL. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902295Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK BETWEEN FUSELAGE STATION 182.500 AND 240.500 HAS CORROSION ON TOP SURFACE AND AROUND 4 SCREW HOLES. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA9902288Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK AT STATION 597.000 HAS CORROSION ON TOP SURFACE AROUND TIE DOWN PEG HOLES. REPAIRED IAW DHC-8 SRM 51-40-00, TABLE 4.SDR QXEA9902269Seat Track · corrodedPDX - NUMEROUS CORROSION AND DAMAGE DISCREPANCIES ON RIGHT CENTER SEAT TRACK. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA9902266Threshold · corrodedPDX - MAIN CABIN DOOR THRESHOLD BEAM AND NUTPLATES HAVE CORROSION TOP SIDE AND UNDER SIDE X224 TO X248 Z100. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902251Skin · chafedPDX - RIGHT NACELLE UPPER DECK FOR EXHAUST FINGERNAIL IS CORRODED AND HAS SEVERAL AREAS WITH DEEP CHAFE MARKS. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902258Frame · corrodedPDX - PITTING CORROSION ON TOP HOLE OF LEFT MAIN LANDING GEAR FRAME WHERE MAIN LANDING GEAR RETRACTION ACTUATOR ATTACHMENT FITTING IS MOUNTED. REPAIRED IAW HORIZON AIR EA 9-54-213.SDR CA991112010Pseu · failed(CAN) AFTER THE CREW SELECTED LANDING GEAR DOWN, THE WEIGHT ON -ON-WHEELS CAUTION LIGHT REMAINED ON. THE CREW CARRIED OUT AN ALTERNATE GEAR EXTENSION AND LANDED SAFELY. THE PROXIMITY SENSOR ELECTRONIC UNIT (PSEU) WAS REPLACED.SDR QXEA9902283Skin · corrodedPDX - AFT LOWER TCAS ANTENNA HAS CORROSION AROUND ANTENNA MOUNT HOLES UNDER DOUBLER. REPAIRED IAW DHC-8 SRM 53-00-16, PAGE 3, TABLE 1.SDR QXEA9902256Firewall · crackedPDX - THERE IS A CRACK IN THE AFT FIREWALL OF THE NR 1 ENGINE, ON THE INBOARD SIDE, AT THE BEND IN MATERIAL JUST ABOVE THE FIRE DETECTION LOOP BRACKET. REPAIRED IAW RD 8-54-806.SDR CA991103002Oil Cooler · failed(CAN) OIL TEMPERATURE NEAR MAX. OIL COOLER REPLACED.SDR QXEA9902299Seat Track · corrodedPDX - LEFT OUTBOARD CABIN SEAT TRACK BETWEEN FUSELAGE STATION 467.000 AND 513.500 HAS CORROSION ON TOP SURFACE AND INSIDE CHANNEL. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA9902268Seat Track · corrodedPDX - NUMEROUS CORROSION DISCREPANCIES ON RIGHT OUTBOARD FORWARD SEAT TRACK. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA9902281Frame · corrodedPDX - FRAME 467 HAS CORROSION ALONG TOP OF FRAME BETWEEN FLOOR SUPPORT Y9.250R AND FRAME. REPAIRED IAW PSM CHAPTER PARAGRAPH 9B.SDR QXEA9902277Frame · corrodedPDX - THERE IS CORROSION AT THE TOP OF FRAME 510 BETWEEN FLOOR SUPPORT Y9.250 RIGHT AND FRAME. REPAIRED IAW PSM CHAPTER 4.SDR QXEA9902263Strip · chafedPDX - FORE RUDDER TOP LEADING EDGE CHAFE STRIP HAS HEAVY CHAFE DAMAGE. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902262Skin · chafedPDX - FORE RUDDER UPPER LEADING EDGE, NEAR RUDDER RIB 11A LOCATION, HAS LOCATIONS OF HEAVY CHAFE DAMAGE TO LEFT SIDE OF LEADING EDGE. REPAIRED IAW DHC-8 SRM 55-40-28, FIGURE 2 AND SRM 51-40-11.SDR QXEA9902259Skin · dentedPDX - LEFT SIDE REAR FUSELAGE SKIN HAS DENT APPROXIMATELY .500 IN DIAMETER AND .045 DEEP AT APPROXIMATELY STATION 653.349. REPAIRED IAW RD 8-53-2181 AND SRM 53-30-24, PAGE 1.SDR QXEA9902245Plate · corrodedPDX - LADDER PLATE FOR 522AT HAS CORROSION AROUND SCREW HOLES. REPAIRED IAW HORIZON AIR EO 9-57-68D, PAGE 9 OF 19, DHC-8 SRM 51-20-16 AND RD 8-57-114.SDR CA991027031Power Supply · failed(CAN) DURING INSPECTION, IT WAS NOTED THAT SEVERAL EMERGENCY LIGHTS WERE INOPERATIVE. POWER SUPPLY REPLACED.SDR CA991027030Line · leaking(CAN) RIGHT BRAKE LINE BLEW OFF AS BRAKES WERE BEING APPLIED WHEN PARKING. LINE FAILED AT THE BRAKE UNIT END WHERE THE BRAIDED LINE ENTERS THE FITTING.SDR CA991103041Line · leaking(CAN) DURING MAINTENANCE, A HYDRAULIC LEAK WAS NOTED AT THE RIGHT WING ROOT. FOUND HYDRAULIC LINE LEAKING AT FITTING.SDR QXEA9902246Plate · corrodedPDX - LADDER PLATE 521AT HAS CORROSION AROUND SCREW HOLES. REPAIRED IAW SRM 51-20-36, RD 8-57-592 AND DHC-8 PSM 1-8-7A 51-00-06.SDR QXEA9902244Plate · corrodedPDX - LEFT FORWARD CORNER OF LADDER PLATE FOR PANEL 521AT HAS TWO CORROSION PITS AT STATIONS YW39.00 AND 39.75. REPAIRED IAW HORIZON AIR EA 9-57-459.SDR CA991103042Line · chafed(CAN) DURING MAINTENANCE, THE PRESSURE LINE FOR THE RIGHT ENGINE AIR INLET DEICE BOOT WAS FOUND CHAFED AGAINST STRUCTURE. LINE REPLACED AND SECURED TO PREVENT CONTACT WITH STRUCTURE.SDR CA991103040Line · chafed(CAN) DURING SCHEDULED MAINTENANCE, HYDRAULIC FLUID WAS FOUND TO BE LEAKING FROM THE FRONT OF THE RIGHT HAND WHEELWELL AREA. THE STAINLESS STEEL CASE DRAIN AND FLUID SUPPLY LINE FOR THE ENGINE DRIVEN PUMP WERE FOUND LEAKING FROM CHAFING WEAR.SDR QXEA9902284Seat Track · misinstalledPDX - RIGHT OUTBOARD CABIN SEAT TRACK HAS FOUR IMPROPER AN TYPE BOLTS ATTACHING SEAT TRACK TO FUSELAGE FRAMES AT STATION 387.350 AND STATION 426.974. REPLACED BOLTS IAW IAC 53-41-00, FIGURE 10, ITEM 50.SDR QXEA9902239Patch · corrodedPDX - OUTBOARD FLAP UPPER SURFACE AT STATION YW232.200 PREVIOUS REPAIR CHAFE PATCH IS CHAFFED APPROXIMATELY .010. REPAIRED IAW RD 8-57-037.SDR CA991103039Rod · broken(CAN) UPON ARRIVAL, THE LEFT HAND CENTER AND AFT MAIN LANDING GEAR DOORS REMAINED OPEN WITH NO CORRESPONDING WARNING. MAINTENANCE FOUND THE DOOR CONNECTING ROD FROM THE DOOR ACTUATOR BELLCRANK TO THE LEFT/AFT DOOR HAD BROKEN JUST ABOVE THE LOWER SWAGE. THE ESDR CA991027018Starter · failed(CAN) NR 2 STARTER HAD TO BE DE-ELECTED MANUALLY. GCU REPLACED FOR TROUBLESHOOTING WITH NO RESULTS AND THEN STARTER REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR CA991027014Valve · stuck(CAN) DURING DE-ICE SYSTEM CHECK, RIGHT NR 4 BOOT WOULD NOT DEFLATE. DISTRIBUTOR VALVE REPLACED.SDR QXEA9902278Stringer · corrodedPDX - STRINGER 31S IS CORRODED BETWEEN FRAME 467 AND 488.5. CLEANED AREA AND FOUND CRYSTALLIZED HARDCOAT. NO CORROSION FOUND. REAPPLIED HARDCOAT AS NECESSARY.SDR QXEA9902264Skin · dentedPDX - THERE ARE TWO DENTS IN RIGHT EXTERNAL FUSELAGE SKIN AT STRINGER 2 AND STATION X600. REPAIRED IAW RD 8-53-436.SDR QXEA9902261Skin · chafedPDX - TRAILING RUDDER TOP LEFT EDGE OF SKIN HAS CHAFE DAMAGE. REPAIRED IAW DHC-8 SRM 55-40-16, TABLE 2 AND SRM 51-20-11.SDR QXEA9902260Castellation · crackedPDX - REAR FUSELAGE FRAME CASTELLATION AT FRAME 3 AND AT APPROXIMATELY TOP 12 O'CLOCK POSITION IS CRACKED. REPAIRED IAW SRM 53-20-21, PAGE 5.SDR QXEA9902254Web · chafedPDX - RIGHT NACELLE AFT WALL OF WHEEL WELL IS CHAFED WHERE LOWER PORTION OF GRAVEL GUARD ATTACHES. REPAIRED IAW RD 8-54-041.SDR QXEA9902243Spar · damagedPDX - LEFT WING INBOARD FORWARD SPAR INBOARD END HAS SMALL FRETTING DAMAGE TO END. REPAIRED IAW RD 8-57-811, STEPS 5 THROUGH 7.SDR QXEA9902240Skin · corrodedPDX - FRETTING CORROSION ON SURFACE THAT THE ANTI-FRET RING CONTACTS. REPAIRED IAW HORIZON AIR EA 9-57-457.SDR QXEA9902126Mechanism · lack of lubeSEA- MAIN CABIN DOOR DIFFICULT TO OPEN. LUBED DOOR STOP/RAMPS, OPERATIONAL CHECKS OK. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR AU991048Bracket · broken(AUS) LEFT AC CONTACTOR BOX CIRCUIT BREAKER PANEL BROKEN ALLOWING THE CIRCUIT BREAKER TERMINALS TO SHORT CIRCUIT ONTO THE CONTACTOR BOX AND CAUSING THE NR 1 AC GENERATOR TO FAIL.SDR AU990969Bracket · broken(AUS) CIRCUIT BREAKER PANEL LOCATED IN LT AC CONTACTOR BOX BROKEN ALLOWING THE TERMINALS TO SHORT CIRCUIT TO THE BOX AND CAUSING THE AC GENERATOR TO FAIL.SDR QXEA9902291Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK BETWEEN STATION 426.974 AND 488.500 HAS CORROSION AND GOUGE MARKS ON TOP SURFACE AND INSIDE CHANNEL. REPLACED SEAT TRACK.SDR QXEA9902290Seat Track · gougedPDX - RIGHT INBOARD CABIN SEAT TRACK BETWEEN STATION 510.000 AND 545.000 HAS GOUGE MARKS ON TOP SURFACE WITH CORROSION AND INSIDE CHANNEL HAS CORROSION. REPLACED SEAT TRACK.SDR QXEA9902289Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK BETWEEN STATION 545.000 AND 597.600 HAS CORROSION ON TOP SURFACE OF OUTBOARD FLANGE. REPLACED SEAT TRACK.
Back to Boeing DHC-8-102