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 FDKA200702076Line · crackedFDM 6166 JFK-MHT (1722 PHX LCL). NR 2 HYDRAULIC QUANTITY DROPPED TO 2 QUARTS. MX FOUND NR 4 BRAKE LINE CRACKED. MX REPLACED THE BRAKE LINE ON THE NR 4 BRAKE, OPS/LEAK CHECK GOOD.SDR FDKA200702073Smoke Detector · malfunctionedFDM 6190 JFK-BDL (1255 PHX LCL). LAVATORY SMOKE DETECTOR BEEPED. PILOT DE-POWERED AND RE-POWERED THE ACFT AND THE FLIGHT ATTENDANT TESTED THE SMOKE DETECTOR AND NO DEFECTS WERE NOTED.SDR HNAA0700040Bleed Air Sys · odorSTRONG OIL SMELL IN FLIGHT DECK WITH APU BLEED ON. RAN APU OPERATED BLEEDS FOR SEVERAL MINUTES, NO SMELL DETECTED.SDR HNAA0700012Threshold · corrodedCORROSION FOUND ON PAX DOOR THRESHOLD AROUND ANCHOR NUT. REPLACED PAX DOOR THRESHOLD.SDR HNAA0700033Unknown · smokeSMOKE IN COCKPIT WHEN SELECTED APU BLEED AND INVERTERS IN. GROUND RAN APU AND NR 2 ENGINE SMOKE DISSIPATED NO OTHER DEFECTS NOTED. INSPECTED FLIGHT DECK, NO DEFECT NOTED.SDR HNAA0700039Intercostal · corrodedCORROSION FOUND AT INTERCOSTAL AT PAX DOOR ENTRANCE. REPLACED INTERCOSTAL.SDR HNAA0700036Control Box · faultyEMERGENCY LIGHTS CYCLE ON AND OFF DURING TAXI. REMOVED AND REPLACED EMERGENCY LIGHT CONTROL BOX.SDR HNAA0700030Angle · crackedCRACK FOUND ON ANGLE AT X136.80 AND STR 14P. REPLACED ANGLE.SDR HNAA0700029Seat Track · corrodedSEAT TRACK RIGHT HAND CENTER FROM X240.50 TO 291.40 HAS AREAS OF CORROSION. REPLACED SEAT TRACK.SDR HNAA0700028Seat Track · corrodedSEAT TRACK RIGHT HAND CENTER FROM X201.15 TO X222.00 IS CORRODED. REPLACED SEAT TRACK.SDR HNAA0700026Skin Panel · corrodedSTRINGER 30 IS DISBONDED DUE TO CORROSION FROM X424.124 TO X488.50. REPLACED SKIN PANEL FROM X424 TO 488 AND FROM STR 29R TO 29S.SDR HNAA0700027Skin Panel · corrodedFOUND CORROSION BETWEEN FRAME STATION 424.124 AND 434.50 JUST OUTBOARD OF STR 31S ON SKIN PANEL.SDR HNAA0700023Tension Tie · corrodedFOUND CORROSION AT FRAME STATION X387.35 AND STRINGER 31S. REPLACED TENSION FITTING.SDR HNAA0700024Floorbeam · corrodedFORWARD CENTER FLOORBOARD SUPPORT AT FRAME X182.00 IS CORRODED. REPLACED SUPPORT.SDR HNAA0700025Support Fitting · corrodedFLOOR PANEL SUPPORT AT PAX DOOR THRESHOLD IS CORRODED.SDR HNAA0700022Seat Track · corrodedRIGHT HAND INBOARD AFT SEAT RAIL HAS CORROSION AT SEAT LEG LOCATIONS. REPLACED SEAT RAIL.SDR HNAA0700021Seat Track · corrodedLEFT HAND INBOARD SEAT RAIL HAS CORROSION AT SEAT LEG LOCATIONS. REPLACED SEAT RAIL.SDR HNAA0700020Seat Track · corrodedLEFT HAND INBOARD MIDDLE SEAT RAIL HAS CORROSION AT SEAT LEG LOCATIONS.SDR HNAA0700019Seat Track · corrodedLEFT HAND INBOARD AFT SEAT RAIL HAS CORROSION AT SEAT LEG LOCATIONS. REPLACED SEAT RAILS.SDR HNAA0700018Seat Track · corrodedRIGHT HAND INBOARD MIDDLE SEAT RAIL HAS CORROSION AT SEAT LEG LOCATIONS. REPLACED SEAT RAIL.SDR HNAA0700017Seat Track · corrodedRIGHT HAND INBOARD SEAT RAIL HAS CORROSION AT PAX SEAT LEG LOCATIONS. REPLACED RAIL.SDR HNAA0700011Frame · crackedFRAME ON DOUBLER IS CRACKED AT X129.00 AND X136.800. REPAIRED PER ED8-53-3541.SDR HNAA0700016Floorbeam · corrodedLEFT HAND FLOORBOARD SUPPORT CAP ANGLE AT X600.000 IS CORRODED.SDR HNAA0700015Floor Support · corrodedRIGHT HAND FLOORBOARD SUPPORT ANGLE AT X600.00 IS CORRODED. REPLACED ANGLE.SDR HNAA0700014Mount · corrodedCORROSION ON ANTENNA MOUNTING BOX. REMOVED AND REPLACED MOUNTING BOX.SDR HNAA0700013Fitting · corrodedCORROSION ON TENSION FITTING. REPLACED TENSION FITTING.SDR HNAA0700035Garlock Seal · leakingNR 2 ENGINE OIL PRESSURE FLUCTUATED FROM 40 TO 60 PSI IN FLIGHT. ENGINE WAS SERVICED WITH 6 QUARTS OF OIL TO BRING TO BOTTOM OF SIGHT GAUGE. FOUND STARTER GENERATOR GARLOCK SEAL LEAKING. REPLACED ENGINE.SDR FDKA200702061Housing · looseFDM 6023 JFK-MHT (1621 PHX LCL). CREW EXPERIENCED A LOSS OF OIL PRESSURE IN THE NR 1 ENGINE. COMPLETED AN IN FLIGHT SHUTDOWN AND FEATHERED THE PROPELLER. CONTRACT MX FOUND THE RGB SCAVANGE OIL FILTER HOUSING LOOSE AND THE FILTER MISSING. MX REMOVED AND REPSDR FDKA200702046Control Box · malfunctionedFDM 6175 JFK (0758 PHX LCL) CAPTAIN REPORTED THAT NO EMERGENCY LIGHT WOULD TURN ON. MX REMOVED AND REPLACED EMERGENCY CONTROL BOX.SDR FDKA200702045Warning System · malfunctionedFDM 208 JFK-PVD (2136 PHX LCL). ABORTED TAKEOFF DUE TO TAKEOFF WARNING HORN SOUNDED. MX TROUBLESHOT AND OPS CHECKED GOOD.SDR HNAA0700031Stiffener · corrodedCORROSION ON FRAME X182.00 ON HORIZONTAL BEAM ADJACENT TO SEAT TRACK ON THE RIGHT SIDE. REPLACED HORIZONTAL STIFFENER.SDR FDKA200701034Trim System · malfunctionedFDM 6055 SYR-JFK (1248 PHX LCL). RUDDER TRIM INOP. MX RESET SYSTEM AND OPS CHECKED GOOD.SDR HNAA0700232Psu · burnedFLIGHT ATTENDANT NOTICED SMOKE COMING FROM AROUND PSU AT 2AC. FOUND CIRCUIT CARD BURNED, REMOVED AND REPLACED PSU AT 2AC.SDR CA070129005Lock · damaged(CAN) AFTER TAKEOFF THE NOSE LANDING GEAR FAILED TO RETRACT. FLIGHT CONTINUED AND LANDED TO THE DESTINATION AIRPORT WITHOUT FURTHER INCIDENT. MAINTENANCE INSPECTED THE AIRCRAFT AFTER ARRIVAL AND FOUND THE NOSE GEAR GROUND LOCK OUT, AND IN LOCK POSITION. (TC SDR FDKA200701029Bulb · inoperativeFDM 6023 BTV-JFK (1615 PHX LCL), 1 BULB OUT IN ESCAPE PATH LIGHTS. MX REPLACED THE LIGHT.SDR HNAA0700002Angle · crackedCRACK FOUND ON RIGHT HAND CLOSING ANGLE ON FASTENERS AT VERTICAL FLANGE BETWEEN STR 4S AND 5S. REPLACED CLOSING ANGLE.SDR FDKA200701022Flap · malfunctionedFDM 6204 PVD-JFK (0500 PHX LCL). FLAPS STUCK AT ZERO. MX RESET THE SYSTEM AND ALL OPS CHECKS WERE GOOD.SDR FDKA200701024Cowling · damagedFDM 6212 SYR-JFK (1824 PHX LCL). APPARENT ICE DAMAGE TO NR 2 INLET COWL FIBER GLASS IS TORN. MX CHANGED THE LOWER COWLING.SDR CA070125003Smoke Detector · false indication(CAN) ON DEPARTURE THROUGH 4000 FT, FLT CREW RECEIVED A MASTER WARNING BAGGAGE SMOKE INDICATION. FLIGHT CREW DECLARED AN EMERGENCY AND ELECTED TO RETURN TO DEPARTURE AIRPORT. THERE WAS A COMPANY LINE CHECK CAPTAIN ON BOARD WHO WITH THE FLIGHT ATTENDANT WENT TOSDR HNAA0700005Stiffener · corrodedHORIZONTAL STIFFENER CORRODED WHERE RIGHT SEAT RAIL ATTACHES. REPLACED STIFFENER.SDR HNAA0700004Angle · crackedCRACKS FOUND ON CLOSING ANGLE BETWEEN STR 5S AND 6S. REPLACED ANGLE.SDR FDKA200701015Indicator · out of adjustFDM 6195 JFK-PWM (0335 PHX LCL) ELEV TRIM WILL NOT GO FULL RANGE OF MOTION. MX ADJUSTED INDICATOR ON CONT WHEEL.SDR HNAA0700224Threshold · corrodedAIR STAIR DOOR MAIN ENTRANCE THRESHOLD MEMBER CORRODED. REPLACED THRESHOLD.SDR CA070126008Smoke Detector · malfunctioned(CAN) ON GOING REPORTS OF LAVATORY SMOKE DETECTOR ACTIVATION. PROBLEM APPEARS TO HAVE BEGUN ON JANUARY 17, 2007 WITH A PILOT REPORT OF THE NR 2 ENGINE WILL NOT START AFTER (3) ATTEMPTS AND THEN AN OIL LEAK. MAINTENANCE REPLACED THE ENGINE IGNITERS AND CLEANED SDR HNAA0700003Angle · crackedCRACKS FOUND ON REAL CLOSING ANGLE BETWEEN STR 4P AND 5P CRACKED AT FASTENER. REPLACED ANGLE.SDR HNAA0700230Line · leakingAFTER STARTING NR 2 ENGINE WITH BLEEDS SELECTED ON, THERE WAS A STRONG FUEL SMELL IN CABIN. FOUND WASTE FUEL DRAIN LINE LEAKING IN NR 2 COMBUSTOR SECTION. INSTALLED TEMPORARY FLEX LINE IN ACCORDANCE WITH MP&P 20.1.SDR HNAA0600221Carrier Assy · burnedELECTICAL BURNING ODOR AT ROW 9 LEFT SIDE, CREW FOUND SIDEWALL LIGHT SOCKET BURNED. REPLACED LAMP CARRIER.SDR HNAA0600220Unknown · odorF/A REPORTS BURNING ODOR FROM GALLEY OVERHEAD GASPER VENT. INSPECTED ASSOCIATED AREA NO HIDDEN DAMAGE NOTED, RAN APU WITH BLEEDS ON AND ALL LIGHTS ON, NO DEFECTS NOTED AT THIS TIME.SDR HNAA0600219Unknown · odorELECTRICAL BURNING ODOR LT CABIN BETWEEN ROWS 1 AND 2. AFTER SELECTING OVERHEAD LIGHTS OFF ODOR DISSIPATED, ISSUED MEL. MORE TO FOLLOW.SDR CA070112004Relay · faulty(CAN) WHEN AIRCRAFT POWER APPLIED, BLADES NR 2 AND NR 4 ON LT PROP HEATED AND BURNED OUT THE HEATER ELEMENTS. FOR PRECAUTION RELAYS P/N KC-D4N AND E-387-C1 WERE REPLACED AND AIRCRAFT WAS TESTED WITH NO FAULTS FOUND. AIRFRAME HOURS=44789:11. CYCLES=48426. (TC
Back to Boeing DHC-8-102