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 HNAA2011112200001Bulb · inoperativeROW 1 AND ROW 8 EMERGENCY FLOOR PATH LIGHTS ARE INOPERATIVE. R & R BULBS. OPS CHECKED GOOD.SDR HNAA2011112100394Actuator · crackedNR 1 HYD ISOLATION LIGHT ILLUMINATED ALONG WITH INBD ROLL SPOILER HYD CAUTION LIGHT. NR 1 HYD QUANTITY AT 1.1. FOUND BACK SIDE OF ACTUATOR CRACKED. R & R SPOILER ACTUATOR IAW MM 27-14-05. PERFORMED OPS CHECK IAW AMM 27-14-00. LEAKED CHECKED GOOD.SDR HNAA20111100393Engine · overspeedDURING APPROACH, BRINGING CONDITION LEVERS UP TO MAX, NR 2 NP WENT TO 1360 AND NR1 TO 1200. VERY LITTLE TQ INCREASE WHEN POWER LEVER ADVANCED, NP CONTINUED TO INCREASE. R & R NR 2 ENGINE IAW WORKCARD 71-00-01R AND 71-00-02R. OPS CHECKED AND LEAKED CHECKED GSDR HNAA2011112100391Tru · malfunctionedRT AC BUSS CAUTION LIGHT ILLUMINATED INFLIGHT. PULLED CIRCUIT BREAKER FOR RT TRU. GROUND RAN ACFT. RT AC BUSS CAUTION LIGHT REMAINED EXTINGUISHED.SDR HNAA2011112100390Lamp · failedEMERGENCY EXIT LOWER LIGHTED EXIT SIGNS HAVE INOPERATIVE LAMPS. R & R LAMPS. OPS CHECKED GOOD.SDR HNAA2011112100389Bulb · failedEMERGENCY FLOOR PATH LIGHT INOPERATIVE AT ROW 4DF. R & R BULB IAW MM 33-51-11.SDR HNAA2011112100388Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R LAMP.SDR CA111123005Actuator · failed(CAN) EN-ROUTE, FLIGHT CREW FELT LIKE IF THE FLAPS WERE EXTENDED. THE SPEED WAS REDUCED, THE FLAP SELECTOR CYCLED FROM 0 TO 5 DEGREES & BACK TO 0 DEGREES. HOWEVER THERE WAS NO FLAP MOVEMENT DETECTED. FLAPS POSITION WERE VISUALLY CONFIRMED & FOUND EXTENDED. SDR HNAA2011111700387Sign · dislodgedEXIT SIGN AT F/A JUMPSEAT IS FALLING OFF. R & R EMERGENCY EXIT LIGHT ASSY OPS CHECKED GOOD. CLEARED MEL.SDR HNAA2011111700386Lens · misinstalledEXIT LIGHT LENS COVER ABOVE RT FORWARD EMERGENCY EXIT NOT PROPERLY INSTALLED, CANNOT REMOVE EXIT FROM OPENING. REMOVED EXIT LENS COVER AND REINSTALLED DOOR CORRECTLY. OPERATES NORMALLY.SDR CA111116002Oil System · low(CAN) JUST AFTER TAKEOFF THE NR 1 ENG OIL PRESS WARNING LIGHT ILLUMINATED & THE OIL PRESS GAUGE WAS FLUCTUATING BELOW 40 PSI. AN IN-FLIGHT ENG SHUTDOWN WAS CARRIED OUT & EMER DECLARED. THE ACFT SAFELY RETURNED TO THE DEPARTURE AIRPORT. INVESTIGATION FOUND TSDR CA111115014Bracket · cracked(CAN) ON A 2C-CHECK WHILE PERFORMING A VISUAL INSPECTION OF RT WING AREA, BYW45.00 TO WING BOX OTBD END, IAW CARD 04-55-31I, RT WING OTBD SPOILER ACTUATOR BRACKET FOUND CRACKED, DWG 85711503.SDR CA111114006Pcu · leaking(CAN) ON CLIMB OUT THE ENG OIL PRESS WARNING LIGHT ILLUMINATED & THE CREW ELECTED TO RETURN. THE ACFT LANDED WITHOUT FURTHER INCIDENT. THE CREW PERFORMED A VISUAL INSPECTION OF THE ENG & FOUND EVIDENCE OF OIL LEAK. INSPECTED THE ENG, REPLACED THE PROPELLER SDR HNAA2011111000364Seat Track · corrodedCORROSION ON RT INBD SEAT TRACK AT BS 215 AROUND NUT PLATE HOLE. AREA IS REMOVED DUE TO SEAT TRACK SPLICE, IAW RD8-53-3074.SDR HNAA2011111000361Seat Track · corrodedLIGHT CORROSION AT RT OTBD SEAT TRACK AT BS 295. BLENDED AREA TO WITHIN LIMITS IAW RD8-53-1342.SDR HNAA2011111000380Skin · crackedPAX DOOR SKIN NR5 BEAM CRACKED AT FORWARD INBD MOUNT AREA. R & R PAX DOOR SKIN.SDR HNAA2011111000379Frame · corrodedCORROSION ON BACK SIDE OF FRAME JOINT STRAP BELOW LT MID EMERGENCY EXIT DOOR AT STA X370.80. CLEANED CORROSION, INSPECTED AND ALODINED JOINT STRAP. PRIMED AS REQUIRED.SDR HNAA2011111000378Frame · corrodedCORROSION ON FRAME MEMBER BELOW RT FORWARD EMERGENCY EXIT DOOR AT STA X252.30. REMOVED VERY MINOR CORROSION. CORROSION NOT PASSED THE PROTECTIVE COATING. ALODINED AND PRIMED WORKED AREA.SDR HNAA2011111000377Seat Track · corrodedLT INBD SEAT TRACK CORRODED OUT OF LIMITS IAW RD8-53-4936 AT AFT CARGO FITTING ATTACH AREA. CUT SEAT TRACK IAW RD8-53-1599. INSTALLED NEW SPLICE SECTION OF SEAT RAIL IAW EO8-53-11-0709.SDR HNAA2011111000376Fitting · corrodedLIGHT CORROSION ON TENSION FITTING AT STR 31P AND STA X201.3. REMOVED CORROSION. ALODINED, PRIMED AND APPLIED CORROSION PREVENTITIVE COMPOUND IAW SRM 51-20-11.SDR HNAA2011111000375Seat Track · corrodedCORROSION ON LT INBD SEAT TRACK FROM STA X270.500 THRU X302.400. R & R SEAT TRACK.SDR HNAA2011111000374Seat Track · corrodedCORROSION ON LT INBD SEAT TRACK AT STA X330.00. BLENDED AREA. FOUND TO BE OUT OF LIMITS IAW RD8-53-1339. R & R SEAT TRACK IAW DWG 85320490SDR HNAA2011111000373Seat Track · corrodedLIGHT CORROSION ON LT INBD SEAT TRACK AT STA X360.00. R & R LT INBD SEAT TRACK.SDR HNAA2011111000372Seat Track · corrodedLIGHT CORROSION ON LT INBD SEAT TRACK AT STA X455.00. BLENDED CORROSION AWAY IAW RD8-53-1339. FOUND TO BE WITHIN LIMITS. NDT'D AND NO CRACKS NOTED. ALODINED AND PRIMED SEAT TRACK.SDR HNAA2011111000371Seat Track · corrodedLIGHT CORROSION ON LT INBD SEAT TRACK AT STA X488.00. BLENDED AWAY CORROSION TO WITHIN LIMITS OF RD8-53-1339. NDT'D AND NO CRACKS NOTED. ALODINED AND PRIMED.SDR HNAA2011111000370Seat Track · corrodedLIGHT CORROSION ON LT INBD SEAT TRACK AT STA X501.00. BLENDED CORROSION AWAY WITHIN LIMITS OF RD8-53-1339. NDT AND NO CRACKS NOTED. ALODINE AND PRIMED.SDR HNAA2011111000369Seat Track · corrodedLIGHT CORROSION ON LT INBD SEAT TRACK AT STA X519.00. BLENDED CORROSION AWAY WITHIN LIMITS OF RD8-53-1339. NDT AND NO CRACKS NOTED. ALODINED AND PRIMED.SDR HNAA2011111000368Seat Track · corrodedLIGHT CORROSION ON LT OTBD SEAT TRACK AT STA X 539.00. BLENDED AREA OF CORROSION TO WITHIN LIMITS OF RD8-53-3644. ALODINED AND PRIMED.SDR HNAA2011111000367Seat Track · corrodedLT INBD SEAT TRACK CORRODED AT SEVERAL SPOTS FROM STAX 201.3 THRU X 222.7. R & R SEAT TRACK.SDR HNAA2011111000365Seat Track · corrodedCORROSION AT LT AND INBD SEAT TRACK FROM STA X251 THRU X 265. R & R SEAT TRACK.SDR HNAA2011111000363Seat Track · corrodedCORROSION AT RT INBD SEAT TRACK AT STA X268.00. BLENDED AREA IAW RD8-53-1339. FOUND TO BE OUT OF LIMITS. R & R RT INBD FORWARD SEAT TRACK IAW DWG 85320079.SDR HNAA2011111000362Seat Track · corrodedCORROSION AT RT INBD SEAT RAIL AT STA X280.00. BLENDED AREA TO WITHIN LIMITS IAW RD8-53-1339.SDR HNAA2011111000360Seat Track · corrodedLIGHT CORROSION AT RT INBD AND OTBD SEAT TRACK AT STA X312.350. BLENDED AREAS TO WITHIN LIMITS IAW RD8-53-1339 FOR INBD AND RD8-53-1342 FOR OTBD.SDR HNAA2011111000359Seat Track · corrodedLIGHT CORROSION AT RT INBD AND OTBD SEAT SEAT TRACK AT STA X330.00. BLENDED AREAS TO WITHIN LIMITS IAW RD8-53-1339 INBD AND RD8-53-1342 FOR OTBD.SDR HNAA2011111000358Seat Track · corrodedLIGHT CORROSION AT RT OTBD SEAT TRACK AT STA X342.300. BLENDED AREA TO WITHIN LIMITS IAW RD8-53-1342.SDR HNAA2011111000357Seat Track · corrodedLIGHT CORROSION AT RT OTBD SEAT TRACK AT STA X405.737. BLENDED AREA TO WITHIN LIMITS IAW RD8-53-1342.SDR HNAA2011111000356Seat Track · corrodedLIGHT CORROSION AT RT INBD SEAT TRACK STA.X488.500. BLENDED AREA TO WITHIN LIMITS IAW RD8-53-1339.SDR HNAA2011111000355Seat Track · corrodedLIGHT CORROSION AT RT HAND INBD AND OTBD SEAT TRACK AT STA X518.00. BLENDED AREA TO WITHIN LIMITS IAW RD8-53-3644 FOR OTBD AND RD8-53-1339 FOR THE INBD.SDR HNAA2011111000354Threshold · corrodedPAX DOOR THRESHOLD IS CORRODED. REMOVED THRESHOLD, INSTALLED NEW PAX DOOR THRESHOLD IAW DWG 8532141.SDR HNAA2011110900352Bulb · failedSECOND FLOOR PATH LIGHT IS INOPERATIVE. R & R LAMP IAW 33-51-00.SDR HNAA2011110900351Bulb · failedROW 2 CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED LENS, R & R BULB AT SAID LOCATION. REINSTALLED LENS.SDR CA111109002Access Panel · departed(CAN) ENGINE TOP PANEL 412CT WAS FOUND NEAR A RUNWAY THRESHOLD BY LOCAL AIRPORT AUTHORITY. IT WAS QUICKLY TRACED BACK TO THE AIRCRAFT. THE PANEL WAS INSPECTED AND FOUND SERVICEABLE. IT WAS SHIPPED TO THE STATION WHERE THE AIRCRAFT WAS SITTING AND INSTALLED. THSDR HNAA2011110400349Inverter · failedODOR IN COCKPIT. R & R PRIMARY INVERTER IAW 24-22-00. OPS CHECKED GOOD.SDR CA111102002Filter · inoperative(CAN) ENROUTE, CREW RECEIVED NR 2 FUEL FILTER BYPASS CAUTION LIGHT. FLIGHT RETURNED TO DEPARTURE FOR REPAIR. FUEL FILTER AND BYPASS SWITCH REPLACED, GROUND RUNS COMPLETED, CHECKED SERV. SWITCH, PN: 59055-88. FILTER, PN: 7589141.SDR HNAA2011110200347Wire · failedAPU FIRE BOTTLE TEST LIGHT WILL NOT ILLUMINATE. FILAMENT TESTED OK. APU COMPARTMENT FOUND WIRES GOING INTO DIODE BELOW SQUIB CONNECTOR PLUG TO NOT BE PROPERLY SEATED. R & R DIODE AND PROPERLY SEATED WIRES.SDR HNAA2011110200346Bulb · failedLT FORWARD EGRESS LIGHT IS DIM. R & R BULB IAW 33-51-00.SDR HNAA2011110200344Oil System · lowNR 1 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED ON TAKEOFF ROLL. LIGHT EXTINGUISHED AFTER ABORTED TAKEOFF. CLEANED OIL PRESSURE SWITCH AND TRANSDUCER. FOUND ENGINE 4 QUARTS LOW ON OIL. SERVICED ENGINE. GROUND RAN ACFT AT FULL POWER. OPS CHECK GOOD. OK FSDR HNAA2011110200343Actuator · out of adjustLT MAIN GEAR DOOR AMBER LIGHT ILLUMINATED AFTER GEAR RETRACTION. RECYCLED GEAR IAW CHECK LIST. AMBER LIGHT RE-ILLUMINATED. ADJUSTED FORWARD LT GEAR DOOR ACTUATOR AND INSTALLED NEW PROX SWITCH FOR GEAR DOOR IAW MM 32-10-36. SWUNG GEAR SEVERAL TIMES. OPS CHESDR CA111028006Electrical Box · inoperative(CAN) PILOT REPORTED WHILE DOING PRE-FLIGHT CHECKS ALL AVIONICS UNSERVICEABLE, EXCEPT FOR UNS GPS, AND INTERPHONE. NO RADIOS. FOUND REU TO BE AT FAULT AND ODOR COMING FROM IT. REPLACED REU, SYSTEMS CHECKED SERVICEABLE AND ACFT RETURNED TO SERVICE. REU TO BSDR CA111028005Sensor · faulty(CAN) AFTER TAKEOFF WOW CAUTION LIGHT ILLUMINATED FOR APPROX 10 SECONDS, THEN EXTINGUISHED. FLIGHT CONTINUED WITH NO FURTHER FAULTS. TESTED SYS AND FOUND NR 2(RT) NLG WOW SENSOR AT FAULT. REPLACED NLG WOW 2 SENSOR ASSY. INTERMITTENT OPEN ON FAULTY WOW SENSO
Back to Boeing DHC-8-102