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 HNAA0700037Bracket · corrodedSURFACE CORROSION FOUND IN PAX DOOR AFT GOOSENECK DRAIN PAN. REPLACED BRACKET.SDR HNAA0700229Bracket · corrodedCORROSION FOUND ON BRACKET AND CARGO FLOOR AT X598 ZONE 144 NEAR ENTRANCE AFT. CORROSION ON CARGO FLOOR REMOVED AND BRACKET REPLACED.SDR HNAA0700228Seat Track · corrodedSURFACE CORROSION ON LEFT INBOARD SEAT TRACK IN CARGO AREA. REPLACED LEFT INBOARD SEAT TRACK AFT CARGO BAY.SDR HNAA0700227Seat Track · corrodedCORROSION ON RIGHT INBOARD SEAT TRACK AT X201.00. REPLACED SEAT RAIL.SDR HNAA0700226Frame · corrodedCORROSION FOUND ON FRAME UNDERFLOOR AT X201.1560 BETWEEN STR 32S AND 30S. REPAIRED FRAME IAW ENGINEERING ORDER.SDR HNAA0700225Seat Track · corrodedCORROSION ON FORWARD LEFT SEAT RAIL. REMOVED CORROSION AND RETREATED RAIL.SDR HNAA0600212Pressure Panel · crackedON EXTENSION GEAR UNSAFE LIGHT ILLUMINATED ACCOMPANIED BY NOISE. CYCLED GEAR A SECOND TIME AND ALL INDICATIONS NORMAL. FOUND NOSE GEAR UPPER DECK (WEB) FAILED.SDR HNAA0600218Engine · odorDURING DESCENT WITH POWER LEVERS AT FLIGHT IDLE THE FLIGHT ATTENDANT NOTICED SMOKE IN FORWARD SECTION OF CABIN, SHUT DOWN RIGHT HAND BLEED WITHOUT IMPROVEMENT, SHUT DOWN BOTH BLEEDS AND SMOKE DISSIPATED. REMOVED AND REPLACED NR 1 ENGINE. MAINTENANCE EVALUATISDR HNAA0600217Engine · overservicedSTRONG BURNING ODOR IN FLIGHT DECK AND CABIN AFTER REDUCING POWER ON APPROACH. SELECTED BLEEDS OFF AND ODOR WENT AWAY. SELECTED BLEEDS BACK ON, ON GROUND NO BURNING ODOR NOTICED. INSPECTED AND FOUND NR 2 ENGINE OIL LEVEL ONE QUART OVER SERVICED. SERVICED TSDR HNAA0600216Unknown · odorDURING DESCENT WITH POWER AT OR NEAR FLIGHT IDLE OILY ODOR IN AIRCRAFT BLEEDS, WHEN POWER IS INCREASED, ODOR WENT AWAY. INSPECTED AIR SWITCHING VALVE AND NL DUMMY PROBE, NO OIL NOTED. REMOVED AND REPLACED STARTER GENERATOR GARLOCK SEAL. REMOVED AND REPLACEDSDR HNAA0600210Unknown · odorBURNING SMELL IN CABIN APPEARS STRONGEST IN COAT CLOSET. SUSPECT P/A AMP CAUSING ODOR, OPS CHECK GOOD.SDR HNAA0600211Socket · burnedFOUND SOCKET FOR OVERHEAD LIGHT AT SEAT 4AC BURNED. REPLACED SOCKET.SDR HNAA0600215Unknown · smokeSMOKE IN COCKPIT AND CABIN DURING FLIGHT. GROUND RAN AIRCRAFT WITH BLEEDS ON, INSPECTED APU AREA FOR LEAKS, NONE FOUND. INSPECTED ALL INTERIOR LIGHTS FOR CONDITION AND PROPER OPERATION. NO DEFECTS NOTED AT THIS TIME.SDR HNAA0600209Unknown · smokeSMOKE IN COCKPIT AND CABIN DURING FLIGHT. GROUND RAN AIRCRAFT WITH BLEEDS ON INSPECTED APU AREA FOR LEAKS OF ANY KIND, NONE FOUND. INSPECTED ALL INTERIOR LIGHTS FOR CONDITION AND PROPER OPERATION NO DEFECTS FOUND AT THIS TIME. NOTE: HEAT EXCHANGER WAS CHANSDR HNAA06002089Unknown · smokeSMOKE IN COCKPIT AND CABIN DURING FLIGHT. GROUND RAN AIRCRAFT WITH BLEEDS ON INSPECTED APU AREA FOR LEAKS OF ANY KIND, NONE FOUND. INSPECTED ALL INTERIOR LIGHTS FOR CONDITION AND PROPER OPERATION NO DEFECTS FOUND AT THIS TIME. NOTE: HEAT EXCHANGER WAS CHANSDR HNAA0700007Seat Track · corrodedRIGHT HAND OUTBOARD SEAT RAIL HAS CORROSION AT SEAT LEG LOCATIONS. REPLACED SEAT RAIL.SDR HNAA0700006Seat Track · corrodedRIGHT HAND OUTBOARD SEAT RAIL CORRODED. REPLACED SEAT RAIL.SDR FDKA200612367Lamp · inoperativeFDM 5970 BTV-JFK (0415 PHX LCL). TWO LIGHTS ON 1ST FLOOR EMERGENCY LIGHT STRIP INOP. MX RELAMPED.SDR HNAA0700008Seat Track · corrodedLEFT HAND OUTBOARD FORWARD SEAT RAIL HAS CORROSION AT SEAT LEG LOCATION.SDR HNAA0600214Unknown · odorODOR OF OIL IN CABIN. ODOR CLEARED BEFORE TAKEOFF THEN RETURNED LAST MIN OF APPROACH. CHECKED NR 1 AND NR 2 ENGINE OIL AND ACM OIL QUANTITY, PERFORMED ENGINE RUN WITH BLEEDS BOTH ON AND OFF UNABLE TO DUPLICATE ON GROUND.SDR HNAA0600208Hydraulic Line · misinstalledGEAR UNSAFE, CYCLED GEAR LEFT GEAR INDICATION REMAINED UNSAFE. NR 2 HYDRAULIC SYSTEM PRESSURE AT 2200, ALTERNATE GEAR EXTENSION PERFORMED WITH ALL GREEN INDICATION AND NR 2 HYDRAULIC SYSTEM AT 3000. FOUND PREVIOUSLY INSTALLED TEMP FLEX HYDRAULIC LINES SWAPPESDR CA061218018Rod · misinstalled(CAN) DURING C-CHECK, A INSPECTOR FOUND THE AILERON INPUT ROD NOT PROPERLY INSTALLED ON BOTH SIDE LT AND RT AILERON. THE ROD END WAS FABRICATED WITH A CUT OUT FOR AVOID THE CONTACT BETWEEN THE ROD END AND THE QUADRANT SHAFT. ON THE SAME A/C, WE FOUND THE BOTSDR HNAA0700009Seat Track · corrodedRIGHT HAND OUTBOARD AFT SEAT RAIL HAS CORROSION AT SEAT LEG ATTACH LOCATIONS. REPLACED SEAT RAIL.SDR FDKA200612359Lamp · inoperativeFDM 6121 JFK-ORF (1318 PHX LCL). LT UNDERWING EMERGENCY EXIT LIGHT INOP. MX RELAMPED.SDR CA061212006Sequence Valve · ruptured(CAN) UPON RETRACTION OF THE LANDING GEAR THE CREW HEARD A STRANGE NOISE FOLLOWED BY HYDRAULIC FLUID QUANTITY LOSS IN THE NR 2 SYSTEM. THE CREW CARRIED OUT THE APPLICABLE PROCEDURES TO EXTEND THE LANDING GEAR BUT WERE NOT ABLE TO GET THE NOSE LANDING GEAR TO ESDR FDKA200612358Wire · damagedFDM 6131 JFK-PWM (1312 PHX LCL). ONBD ROLL SPOILER NOT INDICATING DEPLOYED. MX REPAIRED SPOILER SYSTEM WIRING. OPS CHECK GOOD.SDR HNAA0600207Unknown · odorELECTRICAL ODOR IN CABIN. ITEM PREVIOUSLY DEFERRED RESET C/B'S, SIDEWALL LTS OPS NORMAL, MEL CLEARED. NO ELECTRICAL ODOR NOTED, PERFORMED VISUAL INSP OF SIDEWALL LTS, NO DISCREPANCIES NOTED.SDR CA061213005Oil Cooler · cracked(CAN) OIL COOLER SEAM WELD CRACKED DURING FLIGHT ALLOWING LEAKAGE AND LOW ENGINE OIL PX. (TC NR 20061213005)SDR CA061211007Computer · faulted(CAN) LEVELING OFF AT 4000 FT, AFCS FAILED, ID802 SHOWED LINES, YD AND FLIGHT DIRECTOR FAILED, CAPT AND F/O ADI`S FLAGGED OFF. AIRCRAFT RETURNED TO ORIGINATING AIRPORT FOR NORMAL LANDING. MAINTENANCE INSPECTION OF FLIGHT FAULT SUMMARY SHOWED FAILURE OF RIGHT SDR FDKA200612353Oil System · lowFDM 6175 SYR-JFK (0520 PHX LCL). ABORTED T/O FOR NR 2 ENGINE LOW OIL PRESSURE WARNING LIGHT ILLUMINATED. MX INSPECTED ALL AREAS AND FOUND NO OIL IN THE SIGHT GLASS, NO OBVIOUS LEAKS ANY WHERE TO BE FOUND. MX SERVICED THE ENGINE OIL WITH 6 QTS AND RAN ENGINESDR HNAA0700001Angle · crackedCRACK FOUND ON LEFT HAND CLOSING ANGLE ON FASTENER AT VERTICAL FLANGE STRINGER 5P. REPLACED CLOSING ANGLE.SDR CA061204008Hydraulic Line · damaged(CAN) SMALL PIN HOLE IN BEND RADIUS OF NR DIAMETER 4 TUBE ASSY, NR 1 GROUNDING ITEM IS THE HYDRUALIC LINES ON THE DASH 8`S. (TC NR 20061204008)SDR HNAA0600149Stringer Splice · corrodedCABIN UNDER FLOOR STATION 488 STRINGER SPLICE ON STRINGER 28S IS CORRODED. REPLACED SPLICE.SDR FDKA200611337Pressure Switch · malfunctionedFDM 6195 PDM-JFK (0520 PHX LCL). ABORTED TAKEOFF DUE TO A NR 1 ENGINE OIL PRESSURE WARNING. MX REMOVED AND REPLACED OIL PRESS SWITCH.SDR HNAA0600179Stringer Splice · corrodedSTRINGER TIE AT 424 STRINGER 24S WAS REPLACED DUE TO CORROSION.SDR HNAA0600165Strap · corrodedLONG STRAP AT TOP OF INTERCOSTAL IS CORRODED. FABRICATED NEW STRAP AND INSTALLED PER 85320462.SDR HNAA0600163Attach Fitting · corrodedCLEAT ATTACHING INTERCOSTAL TO FORWARD MAIN DOOR FRAME ON INBOARD SIDE REMOVED DUE TO CORROSION. FABRICATED AND REPLACED CLEAT.SDR HNAA0600204Stringer Clip · corrodedSTRINGER TIE AT X424 STRINGER 26S WAS REPLACED DUE TO CORROSION.SDR HNAA0600203Stringer Clip · corrodedSTRINGER TIE ON 27S AT X424 WAS REPLACED DUE TO CORROSION.SDR HNAA0600202Stringer · corrodedSTRINGER 31 R/S BETWEEN 424 AND 434 WAS REPLACED DUE TO CORROSION.SDR HNAA0600201Doubler · corrodedREINFORCING DOUBLER FOR MARKER ANTENNA BETWEEN X467 AND X488 WAS REPLACED DUE TO CORROSION.SDR HNAA0600200Strap · corrodedINTERNAL JOINT STRAP AT X424 FROM STR 29 TO 29 REPLACED DUE TO CORROSION.SDR HNAA0600199Stringer Splice · corrodedSTRINGER TIE ON STRINGER 28S AT X424 WAS REPLACED DUE TO CORROSION.SDR HNAA0600197Stringer Splice · corrodedSTRINGER TIE ON STRINGER 29S X424 WAS REPLACED DUE TO CORROSION.SDR HNAA0600196Stringer Splice · corrodedSTRINGER TIE ON STRINGER 29S AT X424 REPLACED DUE TO CORROSION.SDR HNAA0600195Stringer Splice · corrodedFWD SIDE OF STRINGER TIE AT X424 STRINGER 31S WAS REPLACED DUE TO CORROSION.SDR HNAA0600194Anchor Fitting · corrodedATTACH CLEAT ON STRINGER 29S AT X434 IS CORRODED. REMOVED AND REPLACED CLEAT.SDR HNAA0600193Stringer Splice · corrodedSTRINGER SPLICE AT X488 STRINGER 29S WAS REPLACED DUE TO CORROSION.SDR HNAA0600192Stringer Splice · corrodedSTRINGER SPLICE ON STRINGER 30 AT X488 R/S WAS REPLACED DUE TO CORROSION.SDR HNAA0600191Stringer Splice · corrodedSTRINGER SPLICE AT X488 STRINGER 32S WAS REPLACED DUE TO CORROSION.
Back to Boeing DHC-8-102