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 HNAA0300050Warning Light · illuminatedPAX DOOR WARNING LIGHT ILLUMINATED IN FLIGHT. DIVERTED INTO CAE. VERIFICATION OF NORMAL OPERATION OF PASSENGER ENTRY DOOR IAW MEL 52-2. CLT MAINTENANCE CERIFIED NORMAL OPERATION CHECK GOOD.SDR PCAA0309109Cover · crackedCREW REPORTED THAT THE NOSE LANDING GEAR DID NOT EXTEND & THE RED UNSAFE LIGHT HAD ILLUMINATED. AN EMERGENCY WAS DECLARED AND THE ALTERNATE EXTENSION DID WORK. THE CHECKLIST WAS COMPLETED WITH GEAR LOCKED AND PINNED. MAINTENANCE INSTALLED A NEW UPPER PROXIMITYSDR PCAA0309108Battery Pack · defectiveDURING ROUTINE MAINTENANCE VISIT LEFT FUSELAGE EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. AFTER TROUBLESHOOTING SYSTEM IT WAS DISCOVERED THAT THE EMERGERGENCY LIGHT BATTERY IN POSITION 100 WAS DEFECTIVE. EMERGENCY LIGHT BATTERY WAS REPLACED. OPERATIONALSDR AUS20030935Oil System · low(AUS) NR 1 ENGINE OIL SYSTEM LOW QUANTITY. TWO QUARTS OF ENGINE OIL WERE ADDED TO TOP UP OIL QUANTITY.SDR PCAA0309107Wire · brokenDURING A ROUTINE MAINTENANCE VISIT SEVERAL EMERGENCY FLOOR EXIT LIGHTS WERE FOUND TO BE INOPERATIVE. A BROKEN WIRE WAS DISCOVERED AT THE MID-CABIN FLOOR AREA. WIRING WAS SPLICE REPAIRED, AND SEVERAL BULBS WERE REPLACED. OPERATIONAL CHECK WAS GOOD. AIRCRAFT WASSDR HNAA0300046Skin · dentedDURING C CHECK, CONTACT FROM PERSONNEL LIFT CAUSED GOUGE AND DENT.SDR HNAA0300045Skin · dentedAIRCRAFT SUSTAINED DAMAGE FROM GROUND EQUIPMENT CAUSING MAJOR REPAIR.SDR PCAA0309110Socket · burnedCREW REPORTED THAT THE OVERHEAD LIGHT AT SEAT 7D WAS GLOWING, SPARKING, AND SMOKING. MAINTENANCE REMOVED BULB AT SEAT 7D, AND ISSUED A DEFERRAL. ON 15 SEPTEMBER 2003 MAINTENANCE INSPECTED WIRING AND SOCKETS AT 7DF AND 9EF. SOCKET AT POSITION 7DF WAS FOUND TO BSDR AUS20030897Actuator · failed(AUS) LT OUTBOARD SPOILER ACTUATOR BODY FAILED. LOSS OF NR 2 HYDRAULIC SYSTEM FLUID.SDR CA030922005Windshield · cracked(CAN) DURING CRUISE FLIGHT AT 25,000 FT THE LT WINDSHIELD STARTED ARCING WITH SUBSEQUENT SHATTERING OF THE WINDSHIELD OUTER PLY. AIRCRAFT REQUESTED ALOWER ALTITUDE TO DESEND BELOW ICING CONDITIONS , AND CONTINUED TO DESTINATION. MAINTENANCE REPLACED WINDSHIELDSDR PCAA0309105Line · brokenWHILE ON DEICING PAD CREW REPORTED THAT A HYDRAULIC LINE WAS LEAKING IN THE CABIN AT SEATS 5DF AND 6DF. EMERGENCY WAS DECLARED. FLIGHT ATTENDANT AND ONE PASSENGER WERE TAKEN TO HOSPITAL DUE TO AFFECT OF HYDRAULIC FLUID IN THE CABIN. MAINTENANCE REPLACED A HSDR PCAA0309106Wire · looseDURING ROUTINE MAINTENANCE VISIT THE EMERGENCY FLOOR LIGHTS WERE FOUND TO BE INOPERATIVE. AFTER INSPECTION A BROKEN WIRE WAS DISCOVERED. WIRE WAS RESECURED, AND THE OPERATIONAL CHECK WAS GOOD. AIRCRAFT WAS RETURNED TO SERVICE.SDR HNAA0300047Battery · dischargedRED FLOOR EMERGENCY LIGHTS 1 AND 2 INOPERATIVE. REPLACED BATTERY AND POWER SUPPLY 3352-PS2, OPS CHECK GOOD.SDR PCAA0309104Wire · brokenDURING ROUTINE MAINTENANCE VISIT, AN EMERGENCY FLOOR LIGHT WAS FOUND TO BE INOPERATIVE AT ROW 9DF. A WIRE WAS FOUND BROKEN AT THE LIGHT ASSEMBLY. A NEW FLOOR LIGHT ASSEMBLY WAS RESPLICED INTO WIRING. OPERATIONAL CHECK WAS GOOD. AIRCRAFT WAS RETURNED TO SERVICESDR AUS20031006Sensor · out of adjust(AUS) LT MAIN LANDING GEAR REAR DOOR SENSOR OUT OF ADJUSTMENT.SDR PCAA0308103Handle · inoperativeCREW REPORTED THAT DURING APPROACH, WHEN SELECTING GEAR HANDLE DOWN GEAR DID NOT EXTEND. MANUAL EXTENSION WAS PERFORMED AND EMERGENCY WAS DECLARED. AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE GEAR HANDLE AND USED A HYDRAULIC MULE FOR SDR PCAA0308102Wire · brokenDURING ROUTINE MAINTENANCE, VISIT ROW 8 WAS FOUND TO HAVE 2 EMERGENCY FLOOR PATH LIGHTS INOPERATIVE. A BROKEN WIRE WAS FOUND AND REPAIRED. AIRCRAFT WAS RETURNED TO SERVICE.SDR AUS20030894Connecting Rod · broken(AUS) LT MAIN LANDING GEAR CONNECTING ROD BROKEN AT NECK END.SDR HNAA0300044Control Box · defectiveEMERGENCY LIGHTS COMES ON AND REMAINS ON IN FLIGHT. REPLACED EMERGENCY LIGHT CONTROL BOX.SDR CA030825003Boss · cracked(CAN) DURING REINSTALLATION OF THE NOSE LANDING GEAR CENTERING MECHANISM A CRACK WAS NOTICED IN THE MAIN BODY BEHIND THE MOUNTING BOSS OF THE CENTRING MECHANISM, THE CRACK AS 3/4 INCH IN LENGTH. THE LOCATION OF THE CRACK DOES NOT ALLOW IT TO BE VISIBLE WITH OUSDR AUS20030857Starter Gen · faulty(AUS) NR 1 STARTER-GENERATOR FAULTY. STARTER-GENERATOR HAD ONLY JUST BEEN REPLACED.SDR PCAA0308101Strut · brokenDURING AN -A- LEVEL INSPECTION, THE RT ENGINE INBOARD AFT HORIZONTAL MOUNT STRUT ASSY WAS FOUND TO BE BROKEN. THE AFT HORIZONTAL MOUNT STRUT ASSY WAS REPLACED, AND AIRCRAFT HAS RETURNED TO SERVICE.SDR CA031204002Mount · cracked(CAN) WHILE THE AILERON WAS IN THE SHOP FOR REPAIR OF DAMAGE UNRELATED TO THIS INCIDENT, CRACKS WERE DISCOVERED ON THE RT AILERONS SPAR WEB AND DOUBLER BEHIND THE THE SPRING TAB MOUNTING BRACKET P/N 85740011-101. THE FINDINGS WERE REPORTED TO MFG AND RD8-57-1SDR AUS20030864Brushes · wrong part(AUS) NR 1 STARTER-GENERATOR FAILED. INVESTIGATION FOUND BRUSHES SHATTERED. SUSPECT BRUSHES WERE TOO LONG. SUSPECT UNAPPROVED PART.SDR PCAA0308100B-Nut · leakingCREW REPORTED THAT THE RT ENGINE OIL PRESSURE FLUXUATED BETWEEN 40 AND 50 PSI AT CRUISE FLT OF 11,000 FT. NR 2 ENGINE WAS SHUT DOWN AND FLIGHT DIVERTED TO ACY. MAINTENANCE TROUBLESHOT AIRCRAFT AND FOUND A B-NUT FOR THE OIL PRESSURE TRANSMITTER TO BE LOOSE. SDR PCAA0308099Diode · failedDURING ROUTINE MAINTENANCE VISIT FOUR RED FLOOR EMERGENCY LIGHTS AT ROW 4 WERE FOUND TO BE INOPERATIVE. ALSO, FORWARD AND AFT LEFT AND RIGHT UPPER SIDEWALL EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. EMERGENCY LIGHTING SYSTEM WAS TROUBLESHOT AND A BURNT WIRSDR PCAA0308097Light · disconnectedDURING ROUTINE MAINTENANCE VISIT THE EMERGENCY LIGHT IN AISLE ABOVE SEATS 4AC AND 4DF WAS FOUND NOT TO BE ILLUMINATING. CEILING PANEL WAS REMOVED ABOVE EMERGENCY LIGHT AND FOUND THAT A PLUG WAS DISCONNECTED. PLUG WAS RECONNECTED, AND THE OPERATIONAL CHECK WAS SDR PCAA0308096Power Supply · inoperativeCREW REPORTED EMERGENCY LIGHTS ON FLOOR AT ROW 4 HAS SEVERAL LIGHT BULBS BAD. MAINTENANCE TROUBLESHOT SYSTEM AND FOUND POWER SUPPLY 33-52-PS2 TO BE BAD IN RIGHT FORWARD OVERHEAD POSITION. RIGHT FORWARD OVERHEAD EMERGENCY LIGHT POWER SUPPLY WAS REPLACED. OPERATSDR HNAA0300038Frame · corrodedDURING 40K INSPECTION FRAME LEG WAS FOUND WITH CORROSION AT STATION X510 AND BETWEEN STR 32S AND STR 31S. A NEW FRAME WAS SPLICED IN AS PER EO 8-53-03-0782.SDR CA030811004Bolt · broken(CAN) WHILE ASSEMBLING THE MAIN WHEEL, THE WHEEL BOLTS WERE TORQUED IN THE PROPER SEQUENCE AND TO PROPER TORQUE AS PER MM, THE BOLTS WERE THENCHECKED TO VERIFY THE TORQUE AND THE NUTWOULD TURN ABOUT 1/8 OF A TURN BEFOREREACHING THE TORQUE. A SECOND VERIFICATIOSDR AUS20030821Line · chafed(AUS) LT LIFT DUMP PRESSURE LINE CHAFED AGAINST SPOILER SELECT PRESSURE LINE DUE TO FAILURE OF GROUND SPOILER PRESSURE LINE SUPPORT BRACKET. LOSS OF NR 1 SYSTEM HYDRAULIC FLUID.SDR PCAA0308095Wire · brokenDURING ROUTINE MAINTENANCE VISIT ONE EMERGENCY FLOOR LIGHT WAS FOUND TO BE INOPERATIVE BY ROW 8DF. MAINTENANCE REPLACED THE BULB AND REPAIRED A BROKEN WIRE AT THE BULB SOCKET. OPERATIONAL CHECK WAS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0308094Odor · detectedCREW REPORTED AN ELECTRICAL ODOR IN THE CABIN AREA. MAINTENANCE INSPECTED AREA AND REPORTED NO ODOR WITH THE OVERHEAD LIGHT OFF. MEL 33-02 WAS ISSUED. AIRCRAFT RETURNED TO SERVICE. DURING NEXT OVERNIGHT MAINTENANCE VISIT ALL LAMPS AND FIXTURES FOR OVERHEAD LIGSDR CA030805010Tire · ruptured(CAN) LARGE RUPTURE ON SIDEWALL OF TIRE FOUND AFTER LANDING OF AIRCRAFT ON THE NR 1 POSTION RECAPPED TIRE.SDR CA030805009Tire · failed(CAN) MULTIPLE FAILURES OF THE NR 1 & 3 MAIN WHEEL TIRES, 6 INCH LONG RUPTURES FOUND ON SIDEWALLS OF TIRES DURING A LINE CHECK. TIRES STILL HELD AIR BUT INNER CORDS WERE FULLY EXPOSED.SDR PCAA0308093Engine · leakingITH-FLIGHT NR 3682. CREW REPORTED A STRONG BURNING ODOR ON INITIAL POWER REDUCTION ON DECENT. SUSPECT BLEEDS. MAINTENANCE REMOVED AND REPLACED THE RIGHT ENGINE IAW AIRLINES JOBCARD 008-71-01-349. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0308091Warning Light · false indicationCREW REPORTED THAT THE SMOKE WARNING LIGHT ILLUMINATED FOR THE CARGO COMPARTMENT. MAINTENANCE PERFORMED A OPERATIONAL TEST OF THE BAGGAGE SMOKE DETECTION SYSTEM IN ACCORDANCE WITH THE DEHAVILLAND DASH 8 MAINTENENCE MANUAL. NO DEFECTS WERE NOTED. OPERATIONAL CHSDR PCAA0308090Generator · lightning strike20 MINUTES PRIOR TO LANDING AT BDL A/C EXPERIENCED A LIGHTNING STRIKE. BOTH DC GEN WENT OFF LINE. ONE GEN WAS ABLE TO RESET. FLT CONTINUED TO BDL & LANDED WITHOUT FURTHER INCIDENCE. MAINT PERFORMED A LIGHTNING STRIKE INSPECTION IAW DEHAV DASH 8 MM, PWA MM, & HSDR PCAA0308089Connector · looseCREW REPORTED THAT THE EMERGENCY LIGHTS FLICKER ON AND OFF IN FLIGHT. MAINTENANCE CLEANED AND INSPECTED THE CONNECTOR ON THE EMERGENCY LIGHTS CONTROL BOX. OPERATIONAL CHECK WAS GOOD ON THE GROUND. AIRCRAFT RETURNED TO SERVICE. AS A FOLLOW UP MAINTENANCE REPLACSDR PCAA0307088Socket · damagedLGA-FLIGHT 3800. CREW REPORTED THAT THE REAR SECTION OF EMERGENCY FLOOR LIGHTS WERE INOPERATIVE. MAINTENANCE INSPECTED WIRING ON FLOOR AND RECONNECTED ONE CANNON PLUG, AFTER WHICH THE LAST RED FLOOR LIGHT WAS FOUND TO BE STILL INOPERATIVE. MEL 33-13 WAS ISSUEDSDR PCAA0308092Control Cable · out of rigCREW REPORT THAT ELEV TRIM APPEARS TO BE OUT OF RIG. MAINT CHECKED RIGGING OF ELEV TRIM AND SPRING TAB SYSTEM IAW MM. ALL TENSIONS AND REQUIRMENTS WERE WITHIN LIMITS. ELEV JACKSCREW ACT WERE LUBED. TEST FLT WAS OK. AC WAS RETNED TO SERVICE. FLT NR 3736. CREW SDR PCAA0307087Control Panel · faultyALB-FLIGHT 3583. CREW REPORTED THAT THE EMERGENCY LIGHTS WERE FLICKERING ON AND OFF DURING FLIGHT. MAINTENANCE REPLACED THE FLIGHT ATTENDANTS SWITCH PANEL. OPERATIONAL CHECK WAS GOOD. AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA0307086Socket · meltedBUF-FLIGHT 3597 CREW REPORTED A BURNING SMELL IN THE CABIN, PROMINENT AROUND SEATS 4DF & 5DF. MAINTENANCE FOUND THE PLUNGER ABOVE 4DF OVERHEAD LIGHT WAS MELTED. PLUNGER AND SOCKET ASSEMBLY WERE REPLACED. OPERATIONAL CHECK WAS GOOD. AIRCRAFT WAS RETURNED TOSDR PCAA0308098Seat Track · corrodedDURING C INSPECTION A FLOOR SUPPORT FLANGE AT THE RT INBOARD SEAT TRACK LOCATION WAS FOUND CORRODED BETWEEN STATION 182.0 AND 270.5. CORROSION WAS REMOVED IN ACCORDANCE WITH THE DEHAVILLAND DASH 8 STRUCTURAL REPAIR MANUAL 51-20-11. AREA WAS REINSPECTED AND FOUSDR PCAA0307085Light · inoperativeDURING A ROUTINE MAINTENANCE VISIT 2 AFT FLOOR EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. LIGHT ASSEMBLY PART NUMBER 10-1307-9 WAS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0307084Wire · brokenDURING A ROUTINE MAINTENANCE VISIT 1 FLOOR PATH EMERGENCY LIGHT WAS FOUND INOPERATIVE AT ROW 7. A BROKEN WIRE WAS REPAIRED IN EMERGENCY LIGHTING SYSTEM. OPERATIONAL CHECK WAS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AUS20030724Pressure Switch · failed(AUS) RT AUXILIARY FUEL PUMP INDICATOR PRESSURE SWITCH FAILED.SDR CA030717002Line · leaking(CAN) DURING INSPECTION FOR MINOR HYDRAULIC LEAK FROM THE NR 2 NACELLE , SERVERAL HYDRAULIC LINES WERE REMOVED FOR INSPECTION . CHAFE DAMAGE WAS FOUND ON THE NR 2 NACELLE OUTBOARD MAIN LANDING GEAR FRAME , AND ON SOME STAINLESS STEEL HYDRAULIC LINES. ALL CHAFESDR HNAA0300031Battery · defectiveTHREE EACH EMERGENCY LIGHTS ILLUMINATE WHEN SELECTED OFF AND AIRCRAFT BATTERIES ARE ON. RIGHT EMERGENCY EXIT ROW 1 AND EXIT CENTER AISLE AND CEILING LIGHT FORWARD. REPLACED BATTERY BASE AND POWER SUPPLY.SDR PCAA0307083Line · severedFLT NR 3544. CREW REPORTED UNKNOWN FUMES IN CABIN NEAR AISLE 2. MAINT INSPECTED AIRCRAFT OVERHEAD LIGHTING AND UNDER FLOOR NEAR AHARS UNIT. OVERHEAD LIGHTING WAS SUSPECT. LIGHT BULBS ABOVE ROWS 2 AND 3 LT AND RT SIDE WERE REPLACED. BOTH ENGINES WERE GROUND RA
Back to Boeing DHC-8-102