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 QXEA9700639Brake · malfunctionPDX - DEPARTING GATE BRAKES GRABBED SEVERLY SHAKING AIRCRAFT. RETURNED TO GATE. REPLACED NR 1 AND NR 2 BRAKES, SERIAL NUMBERS 0220 AND 0686R. TIME SINCE NEW ON SERIAL NUMBER 0686R IS 690 HOURS AND 959 CYCLES. OPERATIONAL CHECK GOOD.SDR PCAA9700569Strut · failedLEFT ENGINE OUTBOARD AFT VERTICLE MOUNT STRUT CRACKED COMPLETELY THROUGH ENTIRE STRUT. REMOVED AND REPLACED LEFT ENGINE AFT OUTBOARD VERTICLE MOUNT STRUT WITH SERVICEABLE UNIT. A/C RETURNED TO SERVICE. (M)SDR MALA975684Bulb · failedDURING INSPECTION ONE FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR MALA975683Sign · looseDURING INSPECTION EXIT ROW EMERGENCY EXIT SIGN HANGING. MAINTENANCE REATTACHED EXIT SIGN. ALL CHECKS GOOD. (M)SDR QXEA9700862Skin · damagedPDX - IMPACT DAMAGE AFT OF REFUEL DOOR ON OUTBOARD SIDE OF RIGHT NACELLE. REPAIRED DAMAGE IAW DEHAVILLAND SRM 51-70-00 PAGE 401 REPAIR 4.SDR QXEA9700634Smoke Detector · no testPDX - NUMBER 2 SMOKE DETECTOR WILL NOT TEST. PLACED ON MEL. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9700568Bulb · failedONE LIGHT INOPERATIVE IN EMERGENCY FLOOR PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED LAMP. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700566Bracket · bentCOCKPIT PORTABLE EMERGENCY LIGHT COMES ON WHEN AIRCRAFT IS SHUT DOWN. FOUND AFT TAB ON MOUNTING BRACKET TO BE BENT. ADJUSTED AFT TAB AND RESECURED LIGHT ASSEMBLY. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700563Battery · dischargedLEFT AFT CABIN EMERGENCY EGRESS LIGHT INOPERATIVE. FOUND NR 3 BATTERY PACK TO BE AT FAULT. REPLACED BATTERY PACK WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. A/C RETURNED TO SERVICE. (M)SDR CA971016003Brake Line · worn(CAN) NR3 BRAKE LINE LEAKING FLUID AFTER PARK BRAKE SET. BRAKE LINE WORN INTERNALLY AT END OF FITTING. OUTER SURFACE SHOWED NO DAMAGESDR QXEA9700631Warning · soundedEUG - ABORTED TAKEOFF. TAKE OFF WARNING SOUNDED DURING TAKEOFF ROLL. MAINTENANCE CONTROL HAD CREW CYCLE FLAPS FULL DOWN, THEN FULL UP, THEN SET TO 5 DEGREES. TAKEOFF WARNING DID NOT RE-OCCUR. NO COMPONENTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9700565Light · inoperativeFLIGHT DECK OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED COCKPIT PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700564Battery Pack · dischargedTWO LIGHT IN EMERGENCY FLOOR PROXIMITY LIGHTING INOPERATIVE. FOUND BATTERY PACK TO BE AT FAULT. REMOVED AND REPLACED BATTERY PACK WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975687Bulb · failedDURING INSPECTION, EMERGENCY LIGHTS INOP. MAINTENANCE RELAMPED ALL INOP EMERGENCY LIGHTS. ALL CHECKS GOOD. (M)SDR QXEA9700635Battery Pack · dischargedPDX - LEFT AFT EMERGENCY LIGHT INOP. REPLACED LAMP, MATRIX BLOCK AND BATTERY PACK. OPERATIONAL CHECK GOOD.SDR PCAA9700567Bulb · failedCENTER CABIN EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR CA971015061Plug · missing(CAN) WHILE TAXIING TO MAINTENANCE AFTER A FUEL HEATER REPLACEMENT THE NR1 ENGINE CAUGHT FIRE. THE FIRE BOTTLES WERE DISCHARGED AND THE ENGINE SHUTDOWN. A PLUG WAS MISSING FROM THE NEWLY INSTALLED FUEL HEATER. INVESTIGATION BEING CARRIED OUT BY MANUFACTURER ANSDR QXEA9700629Doors · crackedPDX- BOTH NOSE LANDING GEAR DOORS ARE DAMAGED (FORWARD DOORS), AND CRACKED. REPLACED BOTH FORWARD NOSE GEAR DOORS, OPERATIONAL CHECKS GOOD. DOORS (S/N 22BAC083) RT (TSN 50750) (S/N 22BACA0003) LT (TSN 4467).SDR PCAA9700562Wire · failed1 RED LIGHT INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REPAIRED WIRING TO LIGHT ASSEMBLY. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700561Battery · dischargedTWO LIGHTS INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM AND FORWARD LOWER EMERGENCY EXIT SIGN INOPERATIVE. FOUND BATTERY PACK AT POSITION 400 TO BE AT FAULT REMOVED AND REPLACED BATTERY PACK. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9700560Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR CA971015010Ferrules · worn(CAN) A FAIR AMOUNT OF WEAR BEYOND LIMITS WAS FOUND ON THE END OF THE FERRULES OF THE SECONDARY FLAP DRIVES IT APPEARS THAT THE BEARINGS IN THE COUPLINGS ARE SPINNING AGAINST THE FERRULES AND CAUSING THE WEAR. IT WAS NOTED THAT SEVERAL OTHER SECTIONS OF THE SSDR CA971015009Ferrules · cracked(CAN) THE OUTER CASING FOR THE CENTRE SECONDARY FLAP DRIVE CABLE WAS FOUND CRACKED AT THE FERRULES IN SEVERAL PLACES IN THE AREA OF THE SWAGESSDR PCAA9700559Bulb · failedTWO LIGHTS IN FLOOR EMERGENCY PROXIMITY LIGHTING INOPERATIVE. REMOVED AND REPLACED LAMPS. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700557Bulb · failedTWO LIGHTS IN FLOOR EMERGENCY PROXIMITY LIGHTING INOPERATIVE. REMOVED AND REPLACED LAMPS. OPERATIONAL TESTS NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975679Light · inoperativeDURING INSPECTION, TWO EMERGENCY LIGHTS OUT, ONE FLOOR TRACK, P/N 7239410-802, AND ONE EXIT, P/N 3071BPEGPL. MAINTENANCE RELAMPED BOTH EMERGENCY LIGHTS. ALL CHECKS GOOD. (M)SDR CA971020004Pseu · failed(CAN) LEFT GEAR NOT RETRACTING PROPERLY. INSPECTION FOUND NO FAULTS. PSEU SENT TO ELDEC FOR CHECK AS THIS PARTICULAR UNIT HAD A HISTORY OF DIFFICULTIES. MORE INFO TO FOLLOW.SDR CA971015006Shaft · corroded(CAN) RIGHT HAND WING INBOARD AND OUTBOARD FLAP TRACK ROLLER SHAFTS FOUND INTERNALLY CORRODED.SDR 97ZZZM1076Light · inoperativeDURING INSPECTION, TWO EMERGENCY LIGHTS OUT, ONE FLOOR TRACK, P/N 7239410-802, AND ONE EXIT, P/N 3071BPEGPL. MAINTENANCE RELAMPED BOTH EMERGENCY LIGHTS. ALL CHECKS GOOD. (M)SDR QXEA9700591Light · inoperativePDX - COCKPIT EMERGENCY LIGHT DOES NOT ILLUMINATE WHEN EMERGENCY LIGHTS TURNED ON. REPLACED COCKPIT EMERGENCY LIGHT ASSEMBLY, OPERATIONAL CHECK GOOD.SDR MALA975674Bulb · failedDURING INSPECTION, 2 MAIN ENTRY EMERGENCY OVERHEAD LIGHTS FOUND INOPERATIVE. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (X)SDR QXEA9700865Seat Track · corrodedPDX - SEAT TRACK NR 4 HAS SURFACE CORROSION UNDER THE WARDROBE FLOOR ENTRY. REPAIRED IAW HORIZON EA 9-53-331.SDR QXEA9700864Ladder Plate · corrodedPDX - LEFT WING LADDER PLATE FOR FUEL PANEL 524AT HAS LIGHT FRETTING CORROSION ON INBOARD AND OUTBOARD ENDS. REPAIRED IAW HORIZON EA 9-57-297.SDR QXEA9700863Ladder Plate · corrodedPDX - LEFT WING LADDER PLATE FOR FUEL PANEL 524BT HAS LIGHT FRETTING CORROSION ON OUTBOARD END. REPAIRED IAW EA 9-57-298.SDR QXEA9700866Seat Track · corrodedPDX - CORROSION ON RIGHT INBOARD SEAT TRACK JUST AFT OF THE BIFFY. REPAIRED IAW HORIZON EA 9-53-331.SDR QXEA9700589Lamp · failedPDX - BAGGAGE SMOKE WARNING TEST NR 1 INTERMITTENTLY INOP. RELAMPED NR 1 SMOKE DETECTOR, OPERATIONAL CHECK GOOD.SDR PCAA9700556Battery Pack · dischargedTWO FORWARD FLOOR EMERGENCY PROXIMITY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AT POSITION NR 500. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975671Radar Rt Unit · failedFLT 3193 - DURING CRUISE FLIGHT, THE WEATHER RADAR WENT INOP EN ROUTE TO FARGO. AIRCRAFT RETURNED TO MSP DUE TO WEATHER CONDITIONS. MAINTENANCE REPLACED WEATHER RADAR R/T. OPS CHECK GOOD. (M)SDR MALA975669Bulb · failedDURING INSPECTION, TWO FLOOR TRACK LIGHTS INOP. MAINTENANCE RELAMPED FLOOR TRACK LIGHTS. ALL CHECKS GOOD. (M)SDR CA971015004Line · leaking(CAN) HYDRAULIC LEAK FROM LANDING GEAR DOOR SEQUENCING VALVE IN NOSE GEAR AREA.SDR QXEA9700590Lamp · failedSEA - NR 1 SMOKE DETECTOR WILL NOT TEST. RELAMPED NR 1 SMOKE DETECTOR, OPERATIONAL CHECK GOOD.SDR MALA975667Battery Pack · dischargedDURING INSPECTION, ONE EMERGENCY EXIT LIGHT AND ONE FLOOR TRACK LIGHT INOP. MAINTENANCE REPLACED BATTERY PACK. OPS CHECK GOOD. (M)SDR PCAA9700555Wire · damagedTHREE BULBS INOPERATIVE IN FORWARD PORTION OF EMERGENCY FLOOR PROXIMITY LIGHTING. REPAIRED PINCHED WIRE IN EMERGENCY FLOOR PROXIMITY LIGHTING CIRCUIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975662Bulb · failedDURING INSPECTION, FOUND EMERGENCY SIDE WALL LIGHT INOPERABLE. MAINTENANCE RE-LAMPED SIDE WALL LIGHT. ALL CHECKS GOOD. (X)SDR MALA975659Battery Pack · dischargedDURING INSPECTION, FOUND EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED 6 BATTERY PACKS FOR EMERGENCY LIGHT SYSTEM. OPS CHECK GOOD. (X)SDR MALA975658Bulb · failedDURING INSPECTION, TWO EMERGENCY EXIT SIGNS FOUND INOPERABLE. MAINTENANCE RE-LAMPED EXIT SIGNS. ALL CHECKS GOOD. (X)SDR MALA975657Lamp · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT FOUND INOPERABLE. MAINTENANCE RE-LAMPED FLOOR TRACK LIGHT. ALL CHECKS GOOD. (X)SDR CA971007006Hose · leaking(CAN) AIRCRAFT LOST HYDRAULIC FLUID WHILE TAXIING FROM NR1 SYSTEM. WHILE APPROACHING THE GATE AND USING HAND EMERGENCY BRAKE, THE NR2 SYSTEM STARTED TO DEPLETE. NO 3 FLEX BRAKE LINE FOUND LEAKING.SDR PCAA9700554Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700552Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)
Back to Boeing DHC-8-102