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 QXEA9800134Plate · damagedPDX - THE ELEVENTH HOLE FROM THE INBOARD SIDE ON THE FORWARD SIDE OF LADDER PLATE FOR 624AT IS ELONGATED APPROXIMATELY .030. REPAIRED IAW EA 9-57-337.SDR QXEA9800033Elect Syst · damagedEN ROUTE, ACFT EXPERIENCED ST ELMOS FIRE ON THE WINDSHIELD WITH SOME PRECIPITATION STATIC. THE MASTER CAUTION LIGHT CAME ON. STARTED THE EMERGENCY CHECKLIST. PULLED LT TRU CIRCUIT BREAKER. 1 MIN LATER, EXPERIENCED LOSS OF PANEL LIGHT ON THE OVERHEAD, GLARESDR PCAA9800696Bulb · failedONE LIGHT INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9800695Bulb · failedLIGHT IN FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH IS INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975892Lamp · failedDURING INSPECTION A CENTER AISLE EMERGENCY LIGHT INOP. MAINTENANCE RELAMPED EMERGENCY LIGHT, OPS CHECK GOOD.SDR HNAA9890804Control Box · failedPHL/PHF - FLT 3175 - DURING PRE-FLIGHT CHECKS, THE CABIN EMERGENCY LIGHTS CYCLE ON AND OFF INTERMITTENTLY. REMOVED AND REPLACED EMERGENCY LIGHTS CONTROL BOX. (X)SDR QXEA9800031Light · failedCABIN OVERHEAD LIGHT AT ROW 2 HAS ACRID SMELL. MAINTENANCE REMOVED LAMP, DISCONNECTED CONNECTOR, AND PLACED ON MEL. MEL CLEARED BY REPLACING RECEPTACLE AND LAMP, OPERATIONAL CHECKS GOOD.SDR MALA975887Lamp · failedDURING INSPECTION, ONE AFT FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED FLOOR TRACK LIGHT, OPS CHECK GOOD.SDR QXEA9800026Bushing · wornGEAR DOOR ON NR 1 SIDE WAS HANGING DOWN IN-FLIGHT, 10 TO 12 BOLT FOUND TO BE LOOSE ON GEAR DOOR. SECURED ROD END BOLT TO DOOR BRACKET PIVOT POINT WITH .032 STAINLESS SAFETY WIRE. FERRIED AIRCRAFT TO PDX. AT PDX, INSPECTED DOOR AREA FOR DAMAGE, NO DAMAGE FOUSDR PCAA9800693Bulb · failedONE LIGHT INOPERATIVE IN FLOOR EMERGENCY IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975886Lamp · failedDURING INSPECTION, EMERGENCY FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED FLOOR TRACK LIGHT, OPS CHECK GOOD.SDR HNAA9893803Power Supply · inoperativePHF/PIT - FLT 3163 - DURING PRE-FLIGHT CHECKS, FOUND THE FIRST TWO RED ESCAPE PATH LIGHTS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY 3352-PS2. (X)SDR QXEA9800137H Member · chafedPDX - NR 1 MAIN LANDING GEAR H-MEMBER CHAFFED FROM CONTACT WITH STANDBY PUMP HYDRAULIC PRESSURE FLEX LINE. REPAIRED IAW EA 9-32-62.SDR PCAA9800692Bulb · failedRIGHT AFT EXTERIOR EMERGENCY EGRESS LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9800691Bulb · failedLEFT AFT EXTERIOR EMERGENCY EGRESS LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9800690Bulb · failedFORWARD CABIN EMERGENCY SIGN HAS ONE INOPERATIVE BULB. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR QXEA9800133Skin · dentedPDX - MAIN CABIN DOOR EXTERIOR SKIN HAS TWO SMOOTH DENTS BOTH .035 BY 1.5 WITHIN ON INCH OF FASTENERS ON THE TOP BEAM. REPAIRED IAW EA 9-52-77.SDR PCAA9800689Connector · looseFORWARD RED EMERGENCY FLOOR PROXIMITY SYSTEM LIGHTS INOPERATIVE. SECURED UNDERFLOOR CONNECTOR. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975875Lamp · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED FLOOR TRACK LIGHT, OPS CHECK GOOD.SDR MALA975874Lamp · failedDURING INSPECTION, ONE RED FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED FLOOR TRACK LIGHT, ALL CHECKS GOOD.SDR QXEA9800135Skin · dentedPDX - UPPER SKIN ON OUTBOARD FLAP HAS A SMALL DENT AND CHAFE AT INBOARD END OF FLAP. REPAIRED IAW EA 9-57-336.SDR MALA975881Wow Sensor · failedAFTER TAKEOFF, THE WEIGHT ON WHEELS LIGHT STAYED ILLUMINATED. AIRCRAFT RETURNED TO MSP. MAINTENANCE REPLACED THE NOSE LANDING GEAR RIGHT WOW SENSOR TARGET AND HT RIGHT MAIN LANDING GEAR LEFT WOW SENSOR. COMPLETED GEAR SWINGS AND OPS CHECKS GOOD.SDR MALA975877Battery Pack · dischargedDURING INSPECTION, ALL EMERGENCY LIGHTS INOP. MAINTENANCE REPLACED ALL SIX BATTERY PACKS, OPS CHECK GOOD.SDR QXEA9800136Fitting · corrodedPDX - RIGHT MAIN LANDING GEAR RETRACTION ACTUATOR ATTACHMENT FITTING MATING SURFACE ON NACELLE FIREWALL AND MAIN LANDING GEAR FRAME STRUCTURAL ASSEMBLY HAS FRETTING CORROSION. REPAIRED IAW EA 9-54-152.SDR QXEA9800018Autofeather Syst · failed testEUG- AUTOFEATHER WILL NOT TEST PROPERLY. CYCLED POWER LEVERS AND PERFORMED AUTOFEATHER TEST AGAIN. TESTED GOOD, AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA9800016Hyd Line · leakingAFTER TAKEOFF, NOTICED AN ODORLESS CHEMICAL IRRITANT IN THE COCKPIT. THE IRRITANT WAS NOTICED IN THE COCKPIT FOR A PERIOD OF ABOUT 20 SECONDS. MX PERFORMED AN ENGINE RUN WITH BLEEDS ON AND TEMP HOT FROM IDLE TO TAKEOFF POWER RPM. NO IRRITANT NOTED. PRESSURSDR PCAA980687Connector · corrodedDURING CLIMB-OUT FROM LGA, THE FLAP DRIVE CAUTION LIGHT ILLUMINATED. A/C RETURNED TO FIELD. MAINTENANCE TROUBLESHOT SYSTEM. FOUND MOISTURE AT 2752-P4 TORQUE SENSOR CANNON PLUG CLEANED. ALSO, FOUND SLIGHT CORRSION AT 2752-P5. REPLACED CANNON PLUG. A/C RETSDR PCAA9800688Wire · failedFORWARD CENTER AISLE CABIN FLOOR EMERGENCY PROXIMITY LIGHTS INOPERATIVE. REPAIRED FORWARD CENTER AISLE FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM WIRING. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975878Lamp · failedDURING INSPECTION, FORWARD OVERHEAD EMERGENCY LIGHT INOP. MAINTENANCE RELAMPED OVERHEAD LIGHT, OPS CHECK GOOD.SDR PCAA9800684Bulb · failedCOCKPIT PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975873Lens · missingDURING INSPECTION, TWO EMERGENCY LIGHTS INOP AND AN EMERGENCY EXIT LIGHT COVER IS MISSING BY PASSENGER STAIRS. MAINTENANCE RELAMPED EMERGENCY LIGHTS (PN MS25231-316) AND REPLACED EXIT SIGN WITH A NEW LENS, ALL CHECKS GOOD.SDR CA980317004Rivets · sheared(CAN) RIGHT HAND NACELLE SURGE DAMPER ATTACH BRACKET RIVETS SHEARED. AIRCRAFT TT: 18,688 HOURS.SDR QXEA9800012Switch · inoperativePDX - FLIGHT ATTENDANT EMERGENCY LIGHTING SWITCH NORM LIGHT INOP. REPLACED SWITCH, OPERATIONAL CHECK GOOD.SDR QXEA9800011Light · inoperativeSEA - EMERGENCY EXIT LIGHT AT MAIN CABIN DOOR FLOOR INOP. REPAIRED DEFECTIVE WIRING, NO PARTS REPLACED. OPERATIONAL CHECK GOOD.SDR PCAA9800686Light · failedCOCKPIT PORTABLE EMERGENCY LIGHT COMES ON IN FLIGHT. REMOVED AND REPLACED COCKPIT PORTABLE EMERGENY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9800683Bulb · failedTHREE LIGHTS INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED BULBS. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975860Lamp · failedDURING INSPECTION, ONE EMERGENCY FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED EMERGENCY FLOOR TRACK LIGHT, ALL CHECKS GOOD.SDR MALA975852Light · inoperativeDURING INSPECTION, EMERGENCY FLOOR TRACK LIGHT INOP. MAINTENANCE REPLACED EMERGENCY FLOOR TRACK LIGHT, OPS CHECK GOOD.SDR QXEA9800007Battery · dischargedPDX - FLIGHT ATTENDANT FLASHLIGHT DOES NOT TEST. REPLACED FLASHLIGHT BATTERY, OPERATIONAL CHECK GOOD.SDR PCAA9800682Light · failedCOCKPIT PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9800677Selector Valve · failedUPON APPROACH INTO BTV, THE LANDING GEAR WOULD NOT EXTEND NORMALLY. ALTERNATE GEAR EXTENSION PERFORMED. MAINTENANCE TROUBLESHOT SYSTEM. FOUND THE LANDING GEAR SELECTOR VALVE AT FAULT. REMOVED AND REPLACED VALVE IAW DHC MANUAL, SYSTEM OPERATIONALLY CHECKED SDR HNAA9893701Battery · dischargedPHL/DCA - FLT 3095 - DURING PRE-FLIGHT WALK-AROUNDS, FOUND TWO RED AND ONE WHITE EMERGENCY FLOOR LIGHTS INOPERABLE. REMOVED AND REPLACED EMERGENCY BATTERY 3352-PS2. (X)SDR PCAA9800681Bulb · failedONE LIGHT INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975847Bulb · failedDURING INSPECTION THE EMERGENCY FLOOR TRACK LIGHT BULB INOP. MAINTENANCE RELAMPED, OPS CHECKS GOOD.SDR QXEA9800003Light · odorPDX - AFTER TAKEOFF FLIGHT ATTENDANT SMELLED BURNING SMELL AND OBSERVED OVERHEAD CABIN LIGHTS ON RIGHTHAND SIDE WENT OUT. INSPECTED ALL RIGHTHAND CEILING LIGHTS AND BALLAST ASSEMBLY. NO DEFECTS NOTED. NO PARTS REPLACED.SDR MALA975848Lamp · failedDURING INSPECTION EMERGENCY FLOOR TRACK LIGHT INOP BY MAIN EXIT. MAINTENANCE RELAMPED EMERGENCY FLOOR TRACK LIGHT, OPS CHECK GOOD.SDR QXEA9800001Bulb · failedBOI- SMOKE DETECTOR WARNING LIGHT DOES NOT TEST IN THE NR 1 POSITION. RELAMPED SMOKE DETECTOR, OPERATIONAL CHECKS GOOD.SDR PCAA9800679Battery · dischargedBOTH CABIN CEILING AND LEFT AFT EXTERIOR EMERGENCY LIGHTS INOPERATIVE FROM FLIGHT ATTENDANTS SWITCH. REMOVED AND REPLACED BATTERY PACK AT POSITION 3351-P3. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR MALA975850Retract Mech · malfunctionedDURING LANDING GEAR RETRACTION OUT OF DTW, THE RIGHT MAIN LANDING GEAR FAILED TO RETRACT. THE RED UNSAFE LIGHT WAS ILLUMINATED ALONG WITH THE GEAR HANDLE IN TRANSIT LIGHT. ONCE LEVELED OFF THE RIGHT MAIN LANDING GEAR DID RETRACT. AIRCRAFT RETURNED TO DTW WISDR MALA975849Socket · looseDURING PREFLIGHT, NOTED SMOKE FROM PASSENGER DOOR STEP LIGHTING. MAINTENANCE FOUND TOP AIRSTAIR LIGHT SOCKET LOOSE. REPLACED AIRSTAIR LIGHT ASSEMBLY, OPS CHECK GOOD.
Back to Boeing DHC-8-102