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 HNAA2013122500638Pump · leakingNR 2 HYDRAULIC QTY SLOWLY DROPPED. ISOLATION LIGHT ILLUMINATED FOR APPROX 2 MINUTES, THEN EXTINGUISHED. ENGINE DRIVEN PUMP CAUTION LIGHT ILLUMINATED AND REMAINED ON. INSPECTED AND FOUND NR 2 ENGINE HYDRAULIC PUMP LEAKING. R & R PUMP IAW 72-00-04L. ALSO, RSDR HNAA2013122500637Drain · corrodedCORROSION FOUND AT NOSE WATER DRAIN AT STA X167.00. REPAIRED IAW EA15-2013-525 AND EO8-53-13-0733.SDR HNAA2013122500636Bulb · dimEMERGENCY SIDEWALL LIGHT IS DIM AT ROW 4DF. R & R BULB IN EMERGENCY SIDEWALL AT ROW 4DF. OPS CHECKED GOOD.SDR HNAA2013122500635Bulb · inoperativeEMERGENCY CEILING LIGHT IS INOPERATIVE AT ROW 5DF. R & R EMERGENCY CEILING LIGHT BULB AT ROW 5DF. OPS CHECKED GOOD.SDR HNAA2013122300634Bulb · inoperativeEMERGENCY SIDEWALL LIGHT IS DIM AT ROW 4DF. R & R BULBS IN EMERGENCY SIDEWALL LIGHT. OPS CHECKED GOOD.SDR HNAA2013122300633Bulb · inoperativeAFT RT FUSELAGE EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013122300632Light · weakLEFT BETA EMERGENCY LIGHT IS WEAK/ DIM. R & R LT BETA EMERGENCY LIGHT IAW AMM 33-51-00.SDR HNAA2013122300631Light · weakRIGHT AFT EMERGENCY EXIT BETA LIGHT IS WEAK/ DIM. R & R AFT EMERGENCY EXIT BETA LIGHT IAW H33-51-00.SDR HNAA2013122300630Bulb · dimLEFT AFT FUSELAGE EMERGENCY LIGHT IS DIM. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013122300629Bulb · inoperativeFLOOR EMERGENCY PATH LIGHT IS INOPERATIVE AT ROWS 5DF. CHANGED BULBS. OPS CHECKED GOOD.SDR HNAA2013122300628Unknown · odorODOR IN FLIGHT DECK DURING DECENT. SELECTED BLEEDS OFF. ODOR DISIPATED, INSPECTED ACM. NO DEFECTS NOTED. GROUND RAN BOTH ENGINES WITH BOTH BLEEDS ON AND THEN ONE AT A TIME. NO ODOR NOTICED BY CREW OR MAINTENANCE ON FLIGHT DECK.SDR HNAA2013122300627Warning Horn · false activationBETA LOCKOUT HORN CAME ON AFTER 50 FEET CONTINUOUSLY. RETURN TO FIELD, FUNCTION CHECKED SYSTEM. OPS CHECKED OK IAW 61-20-10.SDR HNAA2013122300626Computer · malfunctionedSTICK SHAKER ACTIVATED AT 130 KNOTS ON CLIMB OUT, AGAIN DURING RETURN TO FIELD, FLAPS TOO LOW VERBAL WARNING SOUNDED. FIRST FLIGHT AFTER SPAR REPAIR WAS COMPLETED. R & R STALL WARNING COMPUTER AND LIFT TRANSDUCER IAW AMM 27-33-00. OPS CHECKED GOOD.SDR HNAA2013122300625Unknown · smokeDURING FLIGHT, OIL ODOR ENTERED THE CABIN AND FLIGHT DECK WITH ASSOCIATED SMOKEY HAZE IN THE CABIN. SWITCHED THE BLEEDS OFF AND ODOR AND SMOKE DISIPATED. INSPECTED BOTH ENGINES, INTAKES AND OIL LEVELS. GROUND RAN ACFT WITH BOTH ENGINE BLEEDS AND APU BLEEDS.SDR HNAA2013122300624Oil System · lowNR 1 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED DURING TAKEOFF ROLL. ABORTED TAKEOFF AND REDUCED POWER. LIGHT EXTINGUISHED AND PRESSURE APPEARED NORMAL BEFORE ENGINE SHUTDOWN. CHECKED NR 1 ENGINE OIL LEVEL AND SERVICED WITH 2 OUARTS. INSPECTED, CLEANED ASDR HNAA2013121800623Lamp · inoperativeROW 1 FLOOR EMERGENCY PATH LIGHT IS INOPERATIVE. REPLACED LAMP. OPS CHECKED GOOD.SDR HNAA2013121800622Bulb · inoperativeFOUR EMERGENCY FLOOR PATH LIGHTS ARE INOPERATIVE. R & R BULBS. OPS CHECKED GOOD.SDR HNAA2013121800621Bulb · inoperativeEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE THIRD FROM FRONT. R & R BULB, OPS CHECKED GOOD.SDR HNAA2013121600618Wire · damagedEMERGENCY LIGHT INOPERATIVE AT ROW 8. FOUND BROKEN WIRES, SPLICED IN NEW LIGHT ASSEMBLY IAW AMM 20-45-06.SDR HNAA2013121600617Connector · dirtyRUDDER TRIM INOPERATIVE. INSPECTED AND CLEANED ACTUATOR CONNECTOR. OPS CHECKED GOOD.SDR HNAA2013121600616Brush Block · dirtyNR 1 AC GENERATOR CAUTION LIGHT ILLUMINATED ON TAKEOFF RUN. CREW ABORTED TAKEOFF. CYCLED NR 1 AC GENERATOR SWITCH IAW CHECKLIST. CAUTION LIGHT EXTINGUISHED. OPS NORMAL. R & R NR 1 BRUSH BLOCK ASSEMBLY AND CLEANED BRUSH BLOCK CONNECTOR. SEATED CONNECTOR. GROSDR CA131218018Control Unit · malfunctioned(CAN) DURING PRE-FLIGHT AUTOFEATHER/UPTRIM TEST, FLIGHT CREW REPORTED 154 PERCENT OF TORQUE ON THE NR 1 ENGINE. DECISION WAS TAKEN TO FEATHER THE PROPELLER AND RETURN TO GATE BUT LATER ATTEMPTS TO FEATHER THE PROPELLER CAUSED RAPID INCREASE OF TORQUE. FLIGHSDR CA131216026Line · leaking(CAN) WHILE COMPLETING A MAINTENANCE INSPECTION FOUND HYDRAULIC LINE LEAKING FROM PIN HOLE ON THE AFTER VERTICAL SPAR. HYDRAULIC LINE REPLACED, AND CHECKED SERVICEABLE. ACFT RETURNED TO SERVICE.SDR CA131213004Actuator · cracked(CAN) PILOT REPORTED THAT LT OTBD ROLL SPOILER WILL NOT EXTEND BUT THE INBD IS OK. MAINTENANCE DISCOVERED THAT THE LT OTBD ACTUATOR HSG WAS CRACKED. THE ACTUATOR WAS REPLACED IAW THE AMM AND THE ACFT RETURNED TO SERVICE, PN A44700-009, SN 0186.SDR CA131213002Connector · overheated(CAN) DURING SCHEDULED ROUTINE INSPECTION, THE LT APPROACH LANDING LIGHT WAS FOUND INOPERATIVE. DURING TROUBLESHOOTING, RELAY 3341-K1 MOUNTED ON RELAY PANEL NR 2 LOCATED IN THE WARDROBE BEHIND THE FLIGHT DECK WAS FOUND AT FAULT. VISUAL INSPECTION REVEALED SISDR HNAA2013121100615Bulb · inoperativeCEILING EMERGENCY LIGHT AT ROW 8 IS INOPERATIVE. REMOVED LENS, R & R BULB, REINSTALLED LENS. OPS CHECKED GOOD.SDR HNAA2013121100614Bulb · dimLEFT AFT EXTERIOR FUSELAGE EMERGENCY LIGHT IS DIM. REMOVED LENS, R & R BULB, AT SAID LOCATION, REINSTALLED LENS. OPS CHECKED GOOD.SDR HNAA2013120600599Generator · malfunctionedAFTER DEPARTURE, NR 1 AC GENERATOR CAUTION LIGHT ILLUMINATED AND WILL NOT RESET. R & R NR 1 AC GENERATOR AND NR 1 AC GCU IAW WC 24-20-11R. GROUND RAN AIRCRAFT. OPS CHECKED GOOF AT THIS TIME. OK FOR SERVICE.SDR HNAA2013120600608Bulb · inoperativeMOST AFT EMERGENCY CEILING LIGHT IS INOPERATIVE. R & R BULB AT MOST AFT CEILING LIGHT. OPS CHECKED GOOD.SDR HNAA2013120600607Bulb · inoperativeCEILING EMERGENCY LIGHT IS INOPERATIVE AT ROW 8. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013120600606Seat Track · corrodedCORROSION ON RT FORWARD SEAT TRACK IN AREA OF LAVATORY AND GALLEY. REPAIRED RT SEAT TRACK IAW RD8-53-3074.SDR HNAA2013120600605Threshold · corrodedPAX DOOR THRESHOLD MEMBER CORRODED. R & R PAX DOOR THRESHOLD ASSY IAW DWG 85321241.SDR HNAA2013120600604Skin · damagedINBD SIDE OF NR 2 NACELLE HAS SEVERAL RIVET HEADS WORN AT LOWER FWD CORNER OF SKIN. REMOVED RIVETS AND INSTALLED PATH ON INBD FORWARD SIDE SKIN OF NR 2 NACELLE IAW RD8-54-1045. COMPLIED WITH HFEC INSPECTION.SDR HNAA2013120600603Angle · crackedCRACKED ANGLE ON FORWARD SIDE OF NR 2 NACELLE HORSE COLLAR ABOVE OTBD BOLT. COMPLIED WITH EO8-54-13-0677.SDR HNAA2013120600602Battery Pack · inoperativeRT EMERGENCY EGRESS LIGHT IS INOPERATIVE AT ROW 4. R & R RT EMERGENCY LIGHT BATTERY AT PS4. OPS CHECKED GOOD.SDR HNAA2013120600601Warning Light · illuminatedAFTER ROTATION, NR 2 AC GENERATOR CAUTION LIGHT ILLUMINATED. AFTER THREE MINUTES, NR 2 AC GENERATOR HOT LIGHT ILLUMINATED. CYCLED GENERATOR OFF IAW CHECK LIST. OIL PRESSURE WAS FLOATING BETWEEN 45 AND 55. FEATHERED NR 2 ENGINE AND PRESSURE STABILIZED AT 50SDR HNAA2013120600600Bleed Air Sys · hazeLIGHT SMOKEY HAZE IN ACFT WITH APU BLEED SELECTED. GROUND RAN ACFT. CONFIRMED HAZE TO BE PRODUCT OF APU BLEED. ENGINE BLEEDS CHECKED GOOD.SDR HNAA2013120400598Generator · failedAFTER ROTATION, NR 2 AC GENERATOR CAUTION LIGHT ILLUMINATED. ABOUT 3 MINUTES LATER, NR 2 AC GENERATOR HOT CAUTION LIGHT ILLUMINATED. CYCLED GENERATOR OFF IAW CHECK LIST. NR 2 ENGINE OIL PRESSURE WAS FLOATING BETWEEN 45 AND 55. FEATHERED NR 2 ENGINE AND PRESDR HNAA2013120400596Bleed Air Sys · smokeLIGHT SMOKEY HAZE IN ACFT WITH APU BLEED SELECTED. GROUND RAN ACFT, CONFIRMED HAZE TO BE PRODUCT OF APU BLEED. ENGINE BLEEDS CHECKED GOOD.SDR HNAA2013120200596Unknown · odorDURING TAXI OUT WITH ENGINE BLEEDS SELECTED ON, A BURNING OIL ODOR IN FLIGHT DECK AND CABIN. WHEN BLEEDS WERE SELECTED OFF, ODOR STARTED TO DIMISHED. GROUND RAN BOTH ENGINES AND APU FOR ABOUT 20 MINUTES. WITH BLEEDS SELECTED ON AND OFF MULTIPLE TIMES, CHANGSDR CA131202010Signal Cond Unit · malfunctioned(CAN) SHORTLY AFTER TAKEOFF, NR 2 ENGINE FEATHERED. FLIGHT CREW SHUTDOWN THE ENGINE AND DECLARED AN EMERGENCY. THE ACFT RETURNED AND LANDED WITHOUT FURTHER INCIDENT. FLIGHT CREW REPORTED 155 PERCENT TORQUE ON THE NR 2 ENGINE. FLIGHT DATA RECORDER WAS DOWNLOSDR CA131202007Autofeather Sys · malfunctioned(CAN) DURING THE TAKEOFF ROLL, NR 1 ENGINE PROPELLER AUTOFEATHERED UNCOMMANDED. THE TAKEOFF WAS ABORTED WITHOUT INCIDENT AND THE ACFT RETURNED TO THE GATE.SDR HNAA2013112700593Acm · failedACM FAILED AND NOISES ARE HEARD WHEN APU OR ENGINE BLEED IS SELECTED ON.SDR CA131126009Actuator · fractured(CAN) CREW REPORTED LOSS OF BRAKE PRESSURE WITH THE SELECTION OF SPOILERS ALSO THE HYDRAULIC ISO VALVE LIGHT CAME ON. VISIBLE HYDRAULIC LEAK IN THE LT WING/NACELLE AREA. MAINTENANCE DISCOVERED THAT THE LT, INBD SPOILER ACTUATOR HOUSING WAS FRACTURED. THE ACTUSDR HNAA2013112500591Bleed Air Sys · smokeAPU BLEED AIR CAUSED SMOKE IN CABIN, CLEARED WHEN APU BLEED SELECTED OFF. NO SMOKE OFF ENGINE BLEEDS. APU BLEED AIR.SDR HNAA2013112500590Hydraulic System · contaminatedDURING GEAR RETRACTION, NR 2 ENGINE HYDRAULIC PUMP CAUTION LIGHT ILLUMINATED. BOTH MAIN AND STANDBY PSI DROPPED TO 2000 PSI AND RUDDER FULL CAUTION LIGHT ILLUMINATED. AFTER THREE SECONDS, BOTH CAUTION LIGHTS EXTINGUISHED AND PRESSURE RETURNED TO NORMAL. ACFTSDR HNAA2013112500588Smoke Detector · activatedLAVATORY SMOKE DETECTOR SOUNDED DURING TAXI OUT. SELECTED ENGINE BLEEDS OFF DURING RETURN TO GATE AND LAVATORY ALARM STOPPED. GROUND RAN BOTH ENGINES AND APU. OPERATED BLEEDS ON FOR 15 MINUTES. NO SMOKE OR ODORS DETECTED. NO SMOKE ALARM SOUNDED.SDR HNAA2013112500587Pump · failedDURING GEAR RETRACTION, NR 2 HYDRAULIC PRESSURE DROPPED TO 2000 PSI WITH NR 2 ENGINE HYDRAULIC PUMP CAUTION LIGHT. R & R NR 2 ENGINE DRIVEN HYDRAULIC PUMP AND SHAFT IAW WC 29-00-00R, 72-00-04L AND MM 29-10-11, PAGE 201.SDR HNAA2013112500585Gcu · failedNR 1 AC GENERATOR CAUTION LIGHT ILLUMINATED. WOULD NOT RESET. R & R AC GENERATOR GCU DUE TO NR 1 AC GENERATOR FAILURE. OPS CHECKED GOOD.SDR HNAA2013112200584Bulb · inoperativeCABIN-ROW 1DF EMERGENCY SIDEWALL LIGHT HAS AN INOPERATIVE BULB. R & R BULB.
Back to Boeing DHC-8-102