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 HNAA2011021500022Unknown · odorSTRONG ODOR OF FUEL IN CABIN WITH NO AIR CONDITION RUNNING. INSPECTED APU BAY, NO FUEL LEAKS NOTED. GROUND RAN NR 2 ENGINE WITH BLEEDS ON, FUEL ODOR DECREASED, OK FOR SERVICE AT THIS TIME.SDR HNAA2011021500012Light · inoperativeEMERGENCY FLOOR PATH LIGHT IS INOP AT ROW 1. R & R MARKER AS REQUIRED, OPS CHECKED.SDR HNAA2011021500021Switch · failedLT ELEVATOR HORN HEAT CAUTION LIGHT ILLUMINATED IN FLIGHT. REMOVED SWITCH 3015-S4 AND RETERMINATED WIRING 33A16-1 AND 9C16A-1 REF, WIRING DIAGRAM 30-25-02. OPS CHECKED GOOD IAW WORKCARD 30-10-10F.SDR HNAA2011021500020Valve · inoperativeNR 1 ENGINE OIL TEMP RUNNING AT 120 DEGREES. DEVERTED, R & R NR 1 OIL COOLER THERMO VALVE IAW CMM79-20-11, OPS CHECKED AND LEAK CHECKED GOOD.SDR HNAA2011021500019Unknown · odorELECTRICAL ODOR EMINATING IN CABIN AT ROW 2 AND 3. INSPECTED CABIN LIGHTS AND ASSOCIATED AREAS WITH NO OBVIOUS DEFECTS OR ODOR NOTED.SDR HNAA2011021500018Brake · wornSMOKE COMING FROM NR 4 BRAKE. INSPECTED RT BRAKE ASSY AND FOUND NR 3 BRAKE ASSY WORN PAST LIMITS. R & R NR 3 BRAKE ASSY IAW 8MM 32-42-11. NR 4 BRAKE CHECKED GOOD.SDR HNAA2011021500008Lamp · burned outROW 2 CEILING EMERGENCY LIGHT INOP. RELAMP ROW 2 CEILING EMERGENCY LIGHT, OPS CHECKED GOOD.SDR CA110127001Bearing · worn(CAN) PILOT REPORTED ON ARRIVAL, ON FLIGHT 8805 NR 1 ENGINE VIBRATION FELT IN POWER AND CONDITION LEVERS. MAINTENANCE STARTED TROUBLESHOOTING. MAINTENANCE FOUND THAT NR 1 ENGINE STARTER GENERATOR WITH WORN OUT BEARING. COOLING FAN CONTACTING THE FAN SHROUD. SDR HNAA2011021500016Power Supply · inoperativeEMERGENCY LIGHTS INOP. R & R EMERGENCY LIGHT BATTERIES IAW 33-50-03Q. AFT EGRESS LIGHT ON RT EMERGENCY EXIT INOP, R & R POWER SUPPLY PS6, OPS CHECKED GOOD IAW WORKCARD 33-50-05R AND 33-50-03Q.SDR HNAA2011021500006Bulb · burned outRT FUSELAGE EMERGENCY EXIT EGRESS LIGHT IS DIM. REMOVED LENS, REMOVED LAMP, INSTALLED NEW LAMP, REINSTALLED LENS USING RETAINED HARDWARE, OPS CHECKED GOOD.SDR HNAA2011021500005Bulb · burned out2 RED FLOOR EMERGENCY LIGHTS ARE INOP AT ROW 1. INSTALLED NEW BULBS, OPS CHECKED GOOD.SDR HNAA2011021500015Psu · shortedELECTRICAL ODOR IN CABIN, RETURNED TO FIELD. ISOLATED ODOR TO DEFECTIVE PSU AT ROW 4DF. PERFORMED SURROUNDING AREA INSP. NO DEFECTS. R & R PSU. OPS CHECKED GOOD.SDR HNAA2011021500004Bulb · burned outAFT EMERGENCY CEILING LIGHT INOP. R & R BULB, OPS CHECKED GOOD.SDR HNAA2011021500003Module · broken2 EMERGENCY ESCAPE PATH LIGHTS INOP. R & R ONE LIGHT BULB AT ROW 1, OPS CHECKED GOOD.INSTALLED NEW LIGHT MODULE AFTER REMOVING BROKEN MODULE AT ROW 9. OPS CHECKED GOOD.SDR HNAA2011021500002Bulb · burned outEMERGENCY FLOOR PATH LIGHT IS INOP AT ROW 1. R & R LIGHT BULB IAW 33-25-00.SDR HNAA2011021500001Lamp · burned outROW 7 CEILING EMERGENCY LIGHT INOP. RELAMPED ROW 7 CEILING EMERGENCY LIGHT, REF AMM 33-20-00.SDR CA110124004Housing · damaged(CAN) FLOW DIVIDER LEAKING AFTER 417.2 HOURS TSO. EXTERNAL VISUAL INSPECTION DAMAGE TO CHAMFER AND THREADS ON INLET PORT. FAILED EXTERNAL LEAKAGE TEST. FOUND THE LEAKAGE IS ATTRIBUTED TO THE DAMAGE ON THE CHAMFER AND THREADS OF THE INLET PORT. WORK PERFORMEDSDR HNAA2011010300006Buss · failedRT AC BUSS FAILED. INSPECTED NR 2 BRUSH BLOCK AND SLIP RINGS, CLEANED, INSPECTED AND RESEATED CONNECTOR PLUGS AT BOTH A/C GENERATORS AND GCUS. INSPECTED CURRENT LIMITERS AT A/C CONTACTOR BOXES. NO DEFECTS NOTED. R & R NR2 ACFT GENERATOR AND GCU FOR TROUBLESHOSDR HNAA2011010300005Light · missingEMERGENCY FLOOR PATH LIGHT IS MISSING AT ROW 4. INSTALLED EMERGENCY FLOOR PATH LIGHT AT ROW 4 LOCATION. OPS CHECKED GOOD.SDR HNAA2011010300003Unknown · odorELECTRIC ODOR IN GALLEY/COCKPIT AREA WHEN ACFT POWERED UP. INSPECTED ACFT WITH NO ELECTRICAL ODOR NOTED. R & R CAUTION PANEL AS PRECAUTION IAW 33-12-00.SDR HNAA2011010300002Lamp · inoperative2 EMERGENCY FLOOR PATH LIGHTS ARE INOP AT ROW 1. R & R NR1 AND 3 FLOOR LAMPS. OPS CHECKED GOOD.SDR CA101222001Pump · failed(CAN) FLIGHT 8795 DIVERTED DUE TO NR 1 HYDRAULIC BEGAN TO DROP. CREW RECEIVED CAUTION MESSAGE FOR HYDRAULIC ISO VALVE AND INBOARD SPOILER. ON APPROACH FLAPS WOULD NOT LOWER SO THE CREW EXECUTED A MISSED APPROACH AND SET UP FOR A FLAPLESS LANDING. FLIGHT LANDSDR HNAA2011010300001Connector · damagedON CLIMBOUT, EMERGENCY LIGHTS FLICKERED ON/OFF. ENGINE BYPASS DOOR AND PROP SYNC ADVISORY LIGHTS FLICKERED ALSO. WHEN SELECTION OF RT PROP HEAT A PHASE, RT SECONDARY VOLTS DROP TO 21.5. REPAIRED 3 WIRES AT NR 2 ACFT GENERATOR SMALL CONNECTOR PLUG. GROUND RASDR HNAA2010122100290Switch · inoperativeRT ELEVATOR HORN HEAT CAUTION LIGHT ILLUMINATED. CIRCUIT BREAKER POPPED. R & R ELEVATOR ALT HORN HEATER SWITCH. GROUND RAN, OPS CHECKED GOOD IAW RUNUP MANUAL AFTER RESETTING CIRCUIT BREAKER.SDR HNAA2010122100289Current Limiter · malfunctionedWHEN NR 2 PROP HEAT IS CYCLED TO 'A' PHASE,BOTH 'A' PHASE AND RT TRU CIRCUIT BREAKER POPPED AND THE RT ELEVATOR HORN HEAT CAUTION LIGHT ILLUMINATED. R & R NR 2 PROP LEADS, GROUND RAN ACFT, OPS CHECKED GOOD. WHEN NR 2 PROP HEAT CYCLED TO 'A' PHASE, THE RT TRUSDR HNAA2010122100288Lamp · inoperative2ND RED FLOOR LIGHT IS INOP. RELAMP, OPS CHECKED GOOD IAW MM 33-51-00.SDR HNAA20122100287Bulb · inoperativeROW 4DF AND 4AC EMERGENCY EXIT LIGHTS HAVE 1 BULB INOP. R & R BULB IN ROW 4 EMERGENCY EXIT LIGHTS. OPS CHECKED GOOD.SDR HNAA2010122100285Bulb · inoperativeEMERGENCY FLOOR PATH LIGHT IS INOP AT SEAT 5DF. R & R BULB IN EMERGENCY FLOOR PATH LIGHT AT ROW 5. OPS CKD GOOD.SDR HNAA2010122100282Lamp · inoperativeLT FWD FUSELAGE EMERGENCY LIGHT INOP. RELAMPED, OPS CHECKED GOOD MM 33-51-00.SDR HNAA2010122100281Bulb · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 5 IS OUT. REMOVED LENS, R & R BULB, OPS CHECKED GOOD, INSTALLED LENS WITH ATTACHED HARDWARE.SDR HNAA2010122100278Bulb · burned outOVERHEAD EMERGENCY LIGHT AT ROW 5 IS OUT. REMOVED LENS, R & R BULB, OPS CHECKED GOOD. INSTALLED LENS WITH ATTACHED HARDWARE.SDR HNAA2010122100277Control Box · inoperativeALL EMERGENCY LIGHTS IN CABIN FLICKERED (ON/OFF) AFTER DEPARTURE WITH EMERGENCY LIGHTS IN ARM POSITION. IN OFF POSITION LIGHTS REMAINED OFF. R & R EMERGENCY LIGHT CONTROL BOX. OPS CHECKED GOOD ON GROUND.SDR HNAA2010122100273Battery · inoperativePAX DOOR OVERHEAD EMERGENCY SIGN AND LT FUSELAGE FWD EMERGENCY LIGHT INOP. R & R EMERGENCY LIGHT BATTERY ON PSI IAW WORDCARD 33-51-00.SDR HNAA2010122100272Lamp · inoperative(1) FLOOR LEVEL EMERGENCY LIGHT AT ROW 13 IS INOP. R & R EMERGENCY LIGHT LAMP AT ROW 13. CLOSED ACCES PANEL.SDR HNAA2010122100270Light · inoperativeROW 9, EMERGENCY FLOOR PATH LIGHT INOP. R & R ROW 9 EMERGENCY PATH LIGHT. OPS CHECKED GOOD.SDR HNAA2010120300268Skin · puncturedSMALLHOLE ON RT SIDE OF TRAIL RUDDER, JUST ABOVE FUSELAGE. EVALUATED AND MAPPED DAMAGE. PERFORMED STEPS 1 THROUGH 5 OF WORKCARD 05-01-26I. REPAIRED IAW SRM55-40-28, SKIN SPLICE (EO8-55-10-0715) COMPLETED STEPS 6 THROUGH 9 ON WC 05-01-26I.SDR HNAA2010120300263Windscreen · smokePOPPING SOUND AND LIGHT SMOKE FROM LOWER PORTION OF CAPTAIN'S WINDSCREEN FOLLOWED BY BURNING RUBBER AND ELECTRICAL ODOR. R & R F/O'S RT WINDSCREEN IAW WC 56-00-00R.SDR CA101130008Window · failedWHILE IN CRUISE, THE CREW OBSERVED A SPARK/FLASH OF LIGHT THEN THE F/O`S FRONT WINDSCREEN SHATTERED. CREW OPTED TO DIVERT TO YLW AS IT WAS CLOSER AND THEY DECLARED AN EMERGENCY. FLIGHT LANDED SAFELY. PASSENGERS WERE SENT TO YKA VIA GROUND TRANSPORT. CREW WSDR HNAA2010120300262Bleed Valve · failedINTERMITTENT STRONG ODOR IN FRONT CABIN AND FLIGHT DECK. IN FLIGHT AND GROUND, STRONG SOUR BURNED TOAST ODOR MORE PREVALENT WITH ENGINE BLEEDS. OPERATED BLEED, FOUND ODOR FROM NR 2 ENGINE AND BLEED NOT OPERATING NORMAL, SUSPECT SOLNOID ON HP VALVE BAD. R & SDR HNAA2010120300261Ballast · failedF/A REPORTS ELECTRICAL ODOR IN FWD PART OF CABIN. CABIN INTERIOR NORMAL LIGHTING SYS OVERHEAD LIGHTS DEACTIVATED IAW SP33.1 P & C CIRCUIT BREAKERS RT MAIN BUSS S1,S2,R2 (BALLAST CONNECTOR AT 3AC IS MELTED) R & R BALLAST AND LIGHT SOCKET. OPS CHECKED GOOD AT SDR HNAA2010120300260Terminal · looseEMERGENCY LIGHTS FLICKERED DURING FLIGHT. CREW REPORTED SEEING DEFLECTOR DOOR AND PROP SYNC LIGHTS BLINKING WITH EMERGENCY LIGHTS. THESE ARE ALL ON THE SAME RT SECONDARY BUSS FEED. FOUND LOOSE TERMINAL ON SECONDARY INPUT BREAKER E10 WHICH WOULD NOT TIGHTEN SDR HNAA2010120300257Bulb · inoperativeEMERGENCY FLOOR PATH LIGHT AT ROW 8 WILL NOT ILLUMINATE. R & R EMERGENCY FLOOR PATH MINIATURE BULB LIGHT ASSY AT ROW 8.SDR CA101130006Alternator · failedON FLIGHT 8703 , AIRCRAFT WAS STRUCK BY LIGHTNING, HOWEVER NO INSTRUMENTS WERE LOST. THE CREW WAS THEN INFORMED THAT THE WINDS WERE GUSTING TO 40 KTS AND THEY ELECTED TO GO AROUND AND TRY ANOTHER APPROACH. IN THE GO AROUND THEY WERE AGAIN STRUCK BY LIGHTNING SDR HNAA2010112200255Circuit Breaker · failedEMERGENCY LIGHTS FLICKERED IN FLIGHT. FOUND SCREW MISSING FROM CIRCUIT BREAKER C-3 ( RT SECONDARY BUSS) AT BUSS BAR. R & R CIRCUIT BREAKER C-3 AND L-1 EMERGENCY LIGHTS. OPS CHECKED GOOD AT THIS TIME, IAW AMM 33-52-00.SDR HNAA2010112200253Switch · inoperativeEMERGENCY LIGHTS FLICKERED IN FLIGHT IN THE ARM POSITION. R & R F/A'S EMERGENCY LIGHT SWITCH BY SWAPPING WIRE FOR WIRE. COMPLIED WITH WC 33-50-06, BLOCKING DIODES, OPS CHECKED AND WC 33-50-03 EMERGENCY LIGHTS OPS CHECKED. SYS OPS CHECKED GOOD.SDR HNAA2010112200251Control Box · inoperativeEMERGENCY LIGHTS FLICKERED ON CLIMBOUT, WENT OUT DURING CRUISE FLGHT. R & R EMERGENCY LIGHTS CONTROL BOX, OPS CHECKED GOOD AT THIS TIME. OK FOR SERVICE IAW DASH 0 MM 33-12-01.SDR HNAA2010112200250Connector · failedRT ELEVATOR HORN HEAT CAUTION LIGHT ON IN FLIGHT. R & R RT ELEVATOR HORN HEAT CONNECTOR PLUG AND PINS. OPS CHECKED GOOD.SDR HNAA2010112200249Relay · failedPAX DOOR WARNING LIGHT ILLUMINATED AT DEPARTURE TIME. SYS WAS DEACTIVATED IAW MEL 52-5, APPENDIX 5, EARLIER THAT DAY. CIRCUIT BREAKER PULLED AND COLLARED. MX INSPECTED PAX DOOR SENSORS AND MASTER WARNING PANEL CONNECTOR. RESEATED CONNECTOR. NO FIX. R & R SDR HNAA2010112200248Proximity Sensor · malfunctionedAFTER TAKEOFF, PAX DOOR WARNING LIGHT ILLUMINATED. R & R DOOR CLOSED PROX SENSOR IAW MM 52-10-00. OPS CHECKED GOOD.SDR HNAA2010112200247Computer · malfunctionedON ROTATION, STICK SHAKER ACTIVATED FOR REMAINDER OF FLIGHT. R & R NR 1 COMPUTER AND CALIBRATED IAW MM 27-33-00. RECONNECTED SHAKERS, OPS CHECKED GOOD.
Back to Boeing DHC-8-102