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 MALA975562Power Supply · inoperativeDURING INSPECTION, FLOOR TRACK EMERGENCY LIGHTING INOP. MAINTENANCE REPLACED POWER SUPPLY AND BATTERY (P/N 61-0478-9). ALL CHECKS GOOD. (M)SDR MALA975561Fuel Heater · failedFLT 3220 - DURING CRUISE, LEFT ENGINE FUEL TEMP ROSE TO THE RED LINE. AIRCRAFT RETURNED TO MSP. MAINTENANCE REPLACED THE LEFT FUEL HEATER. OPS CHECK GOOD. (M)SDR PCAA9700500Light · inoperativeCOCKPIT EMERGENCY LIGHT WILL NOT HOLD A CHARGE. REMOVED AND REPLACED COCKPIT OVERHEAD EMERGENCY LIGHT WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700499Light · inoperativeLEFT CENTER AISLE EMERGENCY FLOOR PATH LIGHTING STRIP HAS ONE RED LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHTING STRIP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700498Light · inoperativeRIGHT FORWARD EMERGENCY FLOOR PATH LIGHTING STRIP HAS ONE LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHTING STRIP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700496Battery Pack · looseSEVERAL EMERGENCY FLOOR PATH LGHTS INOPERATIVE. FOUND BATTERY PACKS 3 AND 5 LOOSE. SECURED BATTERY PACKS. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700502Lamp · failedAFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. ACTC: 22,005. (X)SDR PCAA9700501Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975559O-Ring · failedFLT 2911 - LOST HYDRAULIC PRESSUR AND QTY ON RIGHT SIDE DURING DESCENT. EMERGENCY GEAR EXTENSION COMPLETED AND AIRCRAFT LANDED WITH NO INCIDENT. MAINTENANCE REPLACED O-RINGS AND RESECURED PRESS TRANSDUCER, SERVICED NR 2 HYDRAULICS. LEAKS CHECK GOOD. (M)SDR CA970806004Selector Valve · failed(CAN) LANDING GEAR DID NOT SELECT DOWN WHEN COMMANDED. ALTERNATE SELECTION CARRIED OUT. LANDIN GEAR SELECTOR VALVE FOUND AT FAULTSDR CA970731002Proximity Sensor · failed(CAN) AFTER LANDING THE RIGHT HAND GEAR UNSAFE LIGHT CAME ON AND THE GEAR UNSAFE HORN SOUNDED. RIGHT HAND PROXIMITY SENSOR HAD FAILED.SDR CA970731001Line · cracked(CAN) HYDRAULIC LINE FOUND CRACKED IN NR2 NACELLE. LINE CRACKE AT THE BEND RADIUS.SDR PCAA9700494Wire · brokenAFTER TAKEOFF FROM DCA, THE FLAPS FAILED TO RETRACT AIRCRAFT RETURNED TO FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE REPAIRED BROKEN WIRES AT THE FLAP SELECT HANDLE. OPERATIONAL CHECK PROVED SATISFACTORY. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975557Battery Pack · dischargedDURING INSPECTION, OVERHEAD EMERGENCY LIGHTS INOP. MAINTENANCE REPLACED BATTERY PACK. OPS CHECK GOOD. (M)SDR QXEA9700349Battery · dischargedPDX - AFT RIGHT EGRESS LIGHT AND CENTER CABIN EXIT LIGHT INOP. REPLACED BATTERY. OPERATIONAL CHECK GOOD.SDR QXEA9700348Power Supply · inoperativeSEA - NUMEROUS EMERGENCY LIGHTS INOP. REPLACED EMERGENCY POWER SUPPLY ABOVE SEAT 8 A/B. OPERATIONAL CHECK GOOD.SDR PCAA9700495Connector · brokenAFT SECTION OF LEFT EMERGENCY FLOOR PATH LIGHTING INOPERATIVE. REPAIRED BROKEN CONNECTOR IN AFT LIGHTING SECTION AND REPLACED TWO FUSES IN FORWARD BATTERY PACK. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700493Actuator · failedFORWARD LEFT MAIN GEAR DOOR REMAINED OPEN WHEN GEAR SELECTED UP. WHEN SELECTED DOWN LEFT MAIN INDICATED UNSAFE. PERFORMED ALTERNATE EXTENSION, AND LEFT MAIN INDICATED DOWN AND LOCKED. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT AND FOUND THE SDR PCAA9700492Connector · corrodedUPON RETRACTION OF LANDING GEAR, THE RIGHT MAIN SHOWED UNSAFE, THE LEFT MAIN AND NOSE SHOWED UP, GEAR DOORS SHOWED OPEN. FOUND RIGHT UPLOCK PROXIMITY SENSOR PLUG CORRODED. REMOVED AND REPLACED THE FORWARD GEAR DOOR PROXIMITY SENSOR AND ELECTRICAL CONNECTOR ISDR MALA975552Lamp · failedON INSPECTION, FOUND FLOOR TRACK LIGHT ROW 1 INOP. MAINTENANCE REPLACED LAMP MODULE. OPS CHECK GOOD. (M)SDR MALA975551Bulbs · failedON INSPECTION, FOUND TWO EMERGENCY FLOOR TRACK LIGHT BULBS INOP. MAINTENANCE REPLACED BULBS. OPS CHECK GOOD. (M)SDR MALA975550Lamp · failedDURING INSPECTION, FOUND EMERGENCY LIGHT 1C AND 4D AND 4E INOP. MAINTENANCE REPLACED LAMPS. OPS CHECK GOOD. (M)SDR MALA975546Lamp · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT INOP. RELAMPED BY MAINTENANCE. OPS CHECK GOOD. (M)SDR MALA975548Bulb · failedDURING INSPECTION, FOUND PASSENGER DOOR EMERGENCY EXIT LIGHT INOP. MAINTENANCE REPLACED BULB. OPS CHECKS GOOD. (M)SDR MALA975547Light · inoperativeDURING INSPECTION, FOUND SEAT 1E EMERGENCY LIGHT INOP. MAINTENANCE REPLACED. OPS CHECK GOOD. (M)SDR PCAA9700491Socket · inoperativeONE LIGHT INOPERATIVE IN EMERGENCY FLOOR PATH LIGHTING AT ROW 6DF. FOUND BULB SOCKET TO BE INOPERATIVE. REMOVED AND REPLCED SOCKET. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975541Bulb · failedDURING INSPECTION, TWO EMERGENCY FLOOR TRACK LIGHTS INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR CA970728021Oil Cooler · leaking(CAN) OIL COOLER LEAKING DURING CRUISE FLIGHT. LEAK FOUND AT BOTTOM RIGHT HAND FORWARD CORNER.SDR CA970728009Bearing · disintegrated(CAN) DURING INSPECTION OF THE LEFT HAND FLAP SECONDARY FLEX DRIVE COUPLING ASSEMBLY, THE OUTBOARD BEARING WAS FOUND TO HAVE DISINTEGRATED. IT HAD TRAVELLED ALONG THE SHAFT DRIVE COUPLING FOR ONE INCH SCORING THE SHAFT AND THE SLEEVE SPLIT HALVES TO A DEPTH OFSDR MALA975529Bulb · failedDURING INSPECTION, ROW 7 OVERHEAD EMERGENCY LIGHT INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR MALA975528Lamp · failedDURING INSPECTION, EMERGENCY FLOOR TRACK LIGHTS INOP. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR PCAA9700490Battery Pack · open circuitAFT LEFT EMERGENCY EGRESS LIGHT DOES NOT ILLUMINATE WHEN SELECTED ON. FOUND OPEN CIRCUIT AT EMERGENCY LIGHT BATTERY PACK AT POSITION PS3. REPAIRED CIRCUIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700489Inverter · failedEN ROUTE TO ROC, A/C DIVERTED INTO ALB DUE TO SMOKE IN COCKPIT. MAINTENANCE LOCATED SOURCE OF SMOKE TO BE COMING FROM AUX INVERTER. INVERTER WAS DEACTIVATED AND A/C WAS DISPATCHED UNDER MEL PROVISIONS. THE AUX INVERTER WAS REPLACED DURING RON MAINTENANCE. SDR MALA975538Breather Cowl · ventingFLT 3381 - JUST AFTER TAKEOFF, CREW RECEIVED CALL FROM AIRCRAFT ON GROUND THAT REPORTED FUEL COMING OUT OF RIGHT ENGINE. CREW NOTED FLUID LEAKING ON THE COWL OF ENGINE, DECLARED EMERGENCY AND LANDED IN ELM. MAINTENANCE CLEANED ENGINE COWL AND VERIFIED THAT ISDR MALA975535Connector · looseDURING INSPECTION, OVERHEAD EMERGENCY EXIT SIGN OVER ROW 4 INOP. MAINTENANCE RESECURED CANNON PLUG ON LIGHT ASSEMBLY. OPS CHECK GOOD. (M)SDR MALA975533Battery Pack · dischargedDURING INSPECTION, TWO FORWARD RED EMERGENCY LIGHTS INOP. MAINTENANCE REPLACED BATTERY PACK. OPS CHECK GOOD. (M)SDR MALA975532Bulb · failedDURING INSPECTION, TWO FLOOR TRACK EMERGENCY LIGHTS INOP. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR MALA975531Bulb · failedDURING INSPECTION, CABIN ROW 1 AND ROW 4 EMERGENCY LIGHTS INOP. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR MALA975530Probe · failedFLT 3453 - CREW REPORTED RIGHT RPM GAUGE FLUCTUATING. AIR TURN BACK TO DTW. MAINTENANCE REPLACED NR 2 NP SPEED SENSOR PROBE. ALL CHECKS GOOD. (M)SDR MALA975526Bulb · failedDURING INSPECTION, EXIT SIGN INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR MALA975525Bulb · failedDURING INSPECTION, ONE FLOOR TRACK LAMP INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR HNAA9794061Angle · crackedFOUND DURING PAHSE CHECK, THE UPPER RIGHT SIDEWALL OF THE NOSE LANDING GEAR WHEEL WELL HAS A CRACKED STIFFENER ANGLE. THE CORRECTIVE ACTION WAS TO REPAIR IAW ESR8-53-93-11. (M)SDR MALA975521Bulb · failedDURING INSPECTION, EXIT SIGNS WERE FOUND INOPERABLE ON SIDE WALL. MAINTENANCE RE-LAMPED. OPS CHECK GOOD. (X)SDR MALA975520Lamp · failedDURING INSPECTION, ONE FLOOR TRACK AND ONE SIDEWALL EMERGENCY LIGHT WERE FOUND INOPERABLE. MAINTENANCE RE-LAMPED BOTH LIGHTS. OPS CHECK OF SYSTEM GOOD. (X)SDR PCAA9700488Wire · brokenTHREE EMERGENCY FLOOR PATH LIGHTS INOPERATIVE. REPAIRED BROKEN WIRE UNDER CENTER AISLE FLOOR. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. ACTC: 21,901. (X)SDR MALA975519Wire Harness · failedDURING INSPECTION, ROW 1 EMERGENCY FLOOR TRACK RED LIGHTS WERE FOUND INOPERABLE. MAINTENANCE REPLACED EMERGENCY FLOOR TRACK HARNESS. OPS CHECK GOOD. (X)SDR MALA975518Control Mech · out of adjustMSP - FLT 3103 - ON APPROACH, AILERON ROLL COMMAND JAMMED. CREW DE-CLUTCHED AND NO FURTHER PROBLEMS NOTED. MAINTENANCE ADJUSTED TENSION ON PILOT'S CONTROL WHEEL. OPS CHECK OF AILERON CONTROL SYSTEM GOOD. (X)SDR PCAA9700487Lamps · failedSEVERAL FLOOR EMERGENCY PATH LIGHTS INOPERATIVE. REMOVED AND REPLACED LAMPS. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700486Light · inoperativeEMERGENCY FLOOR PATH LIGHTING AT ROW NINE INOPERTIVE. REMOVED AND REPLACED ROW NINE EMERGENCY FLOOR LIGHT FILAMENT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975517Lamp · failedDURING INSPECTION, EMERGENCY FLOOR TRACK LIGHT WAS FOUND INOPERABLE AT 8D. MAINTENANCE RE-LAMPED. OPS CHECK GOOD. (X)
Back to Boeing DHC-8-102