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 HNAA2013081900470Socket · failedOVERHEAD LIGHT AT ROW 8 IS INOPERATIVE. REMOVED PANEL, FOUND MELTED SOCKET, R & R SOCKET AND BALLAST. REINSTALLED PANEL. OPS CHECKED GOOD IAW CMM 33-21-19.SDR HNAA2013081900469Oil System · lowMASTER WARNING LIGHT ILLUMINATED AND SUSPECT NR 1 OR NR 2 ENGINE OIL PRESSURE LIGHT WAS ILLUMINATED DURING TAKEOFF ROLL. INSPECTED NR 1 AND NR 2 ENGINES. SERVICED NR 1 WITH 3 QUARTS AND NR 2 WITH 2 QUARTS OF OIL. GROUND RAN ACFT AT HIGH POWER. NO DEFECTS NSDR HNAA2013081900466Apu · odorSTRONG FUEL ODOR IN CABIN. GROUND RAN BOTH NR 1 AND NR 2 ENGINES, NO FUEL ODOR NOTED. VERFIED ODOR COMING FROM APU.SDR CA130826017Oil Cooler · leaking(CAN) DURING CRUISE THE RT ENGINE LOST OIL AT A RATE THAT CAUSED THE PILOT TO SHUT THE ENGINE DOWN. ON INVESTIGATION, THE ENGINEERS FOUND THAT ONE OF THE HELICOILS ON THE OIL COOLER INLET FITTING HAD DISLODGED, CREATING AN ESCAPE PATH FOR THE ENGINE OIL. THSDR HNAA2013081400463Bulb · failedEMERGENCY CEILING LIGHT AT ROW 2 IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013081200459Acm · odorOIL ODOR IN COCKPIT WITH BLEEDS ON AND POWER AT FLIGHT IDLE. NO ODOR WITH BLEEDS OFF. R & R ACM IAW MM 21-50-11. OPS CHECKED GOOD.SDR HNAA2013081200458Switch · inoperativeAT 300 FEET, BETA LOCKOUT CYCLED NR 2 PROPELLER. RETURNED TO FIELD. ACTIVATED BETA LOCKOUT SYS. BOTH BETA LOCKOUT SWITCHES MOVED TO ENABLE. R & R SWITCH 6141-S4. GROUND RAN, OPS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIME.SDR CA130813003Transmitter · malfunctioned(CAN) ON TAKEOFF ROLL L1 SPOILER ON PFCS FAILED TO RETRACT. ALL PFCS INDICATIONS NORMAL ON FLIGHT CONTROL CHECK PRIOR TO TAKEOFF RUN. DID RUN UP IN THE TAKEOFF CONFIGURATION AND THE SPOILER DOES RETRACT AS POWER LEVER ABLE IS ADVANCED TOWARD TAKEOFF POWER HOSDR CA130812001Indicator · shorted(CAN) AFTER ENGINE START AND DC EXTERNAL POWER DISCONNECTED THE CREW RECEIVED A DC BUS, A NR 1 DC GENERATOR AND THE AUXILIARY INV CAUTION LIGHTS. WHILE ACTIONING THE QRH, SMOKE BEGAN TO EMIT FROM THE LT GLARESHIELD AREA. THE ACFT WAS SHUTDOWN AND PASSENGERS SDR HNAA2013080900457Bulb · inoperativeEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 3. R & R BULB. OPS CHECKED GOOD IAW MM 33-51-11.SDR HNAA2013080900456Indicator · inoperativeSTANDBY ATTITUDE INDICATOR WILL NOT CAGE AND SHOWS INVERTED. R & R STANDBY INDICATOR IAW MM 34-22-01. OK FOR SERVICE.SDR HNAA2013080900455Smoke Detector · false activationCARGO BAY SMOKE DETECTION WARNING LIGHT ILLUMINATED FOR ABOUT FIVE SECONDS AND EXTINGUISHED. CARGO DOOR WAS OPEN BOTH SYS TESTED NORMAL. R & R FORWARD SMOKE DETECTOR WITH NEW. OPS CHECKED GOOD.SDR HNAA2013080700453Power Supply · failedTHIRD AND FOURTH FLOOR LEVEL EMERGENCY LIGHTS ARE INOPERATIVE. R & R POWER SUPPLY PS2 IAW MM 33-53-01. OPS CHECKED GOOD.SDR HNAA2013080500449Bulb · inoperativeTWO FLOOR EMERGENCY LIGHTS ARE INOPERATIVE AT ROWS 1 AND 8. R & R BULBS. OPS CHECKED GOOD.SDR HNAA2013080500448Bulb · inoperativeNORMAL GREEN LIGHT ON EMERGENCY PUSH BUTTON ON F/A PANEL IS INOPERATIVE. R & R NORMAL GREEN LIGHT BULB ON F/A PANEL. OPS CHECKED GOOD.SDR HNAA2013080500447Warning Light · false activationON ROLL OUT AFTER LANDING, NOSE GEAR INDICATED RED UNSAFE. ACFT WAS STOPPED ASAP AND RED INDICATION SELF CLEARED TO GREEN. DISCREPANCY WAS ASSOCIATED WITH WOW CAUTION LIGHT. CHECKED PSEU FOR FAULT CODES. NO CODES INVALID NOTED. CHECKED SENSOR GAP CLEARENCESDR HNAA2013080200443Bulb · inoperativeEMERGENCY PATH LIGHT IS INOPERATIVE AT ROW 1. R & R BULB FOR EMERGENCY PATH LIGHT AT ROW 1. OPS CHECKED GOOD.SDR HNAA2013080200442Radar · faultedPOSSIBLE LIGHTNING STRIKE. ACFT WAS DIVERTED, DUE TO POSSIBLE RADAR FAULT.SDR HNAA2013080200441Control Box · inoperativeNR 1 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED CONTINUOUSLY ON CLIMB. OIL PRESSURE INDICATED NORMAL- IN GREEN ARC. ENGINE WAS SHUTDOWN IN FLIGHT. CREW REPORTED OIL/FUEL TEMPS NORMAL AND DID DECLARE AN EMERGENCY. CONNECTOR LIGHT REMAINS ON. JUMPED CONNSDR HNAA2013080200440Transceiver · failedWEATHER RADAR IS INOPERATIVE. MESSAGE APPEARS IN LOWER RT, NO RETURNS PAINTED. R & R RADAR R/T IAW MM 34-41-04. OPS CHECKED GOOD.SDR HNAA2013073100438Terminal · burnedSTRONG ELECTRICAL ODOR IN CABIN. INSPECTED AND FOUND L2 RING TERMINAL ON F/O WINDSCREEN BURNED. R & R RING TERMINAL. CHECKED ALL RESISTANCE VALVES AT WINDOW. NO DEFECTS NOTED. OPERATED WINDSCREEN HEAT. OPS CHECKED GOOD AT THIS TIME.SDR CA130731004Tube · leaking(CAN) DURING CRUISE FLIGHT, INBOUND TO A MAINTENANCE BASE, THE NR 1 HYDRAULIC SYSTEM LOST ALL OF ITS FLUID WITH ASSOCIATED LOSS OF THE NR 1 HYDRAULIC SERVICES. THE ACFT LANDED WITH FLAPS AT ZERO AND NO NORMAL BRAKES AVAILABLE. THE CREW DECLARED AN EMERGENCY SDR HNAA2013073000436Battery · failedLEFT AFT EMERGENCY EGRESS LIGHT IS INOPERATIVE. FOUND MULTIPLE EMERGENCY LIGHTS INOP. R & R BATTERY AT ROW 3. CEILING LEFT BATTERY (PS3). OPS CHECKED GOOD.SDR HNAA2013073000434Trim System · out of adjustREJECTED TAKEOFF AT 20 KNOTS FOR WARNING HORN. ADJUSTED ELEVATOR TRIM, OPS NORMAL. PERFORMED WC 31-50-00Q, TAKEOFF WARNING SYS OPS CHECKED GOOD.SDR HNAA2013072600432Engine · power lossAFTER TAKEOFF, SHORTLY AFTER GEAR RETRACTION, NR 1 ENGINE MADE A LOUD SOUND, THEN NOTICED NR 1 PROP AT APPROX 400 RPM AND TORQUE 125, PLUS FOR APPROX 30-60 SECONDS BEFORE CREW SHUTDOWN ENGINE, AUTOFEATHER SELECTED AND ARMED. NO UPTRIM INITIATED. INSPECTED NRSDR HNAA2013072600431Module · failedTWO EMERGENCY LIGHTS ARE INOPERATIVE AT ROW 4. R & R 2 FLOOR LIGHT MODULES AT ROW 4 FLOOR EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR HNAA2013072600430Bulb · failedRED FWD EMERGENCY LIGHT IS INOPERATIVE AT ROW 1. REMOVED LENS, R & R BULB, OPS CHECKED GOOD. REINSTALLED LENS.SDR CA130805005Engine · failed(CAN) DURING REVENUE FLIGHT, THE CREW REPORTED SMOKE IN THE CABIN THAT SMELLED LIKE PLASTIC. THEY ALSO HAD A LAVATORY SMOKE CAUTION INDICATION. THE CREW DISCHARGED THE AFT CARGO FIRE BOTTLE. THEY DECLARED AN EMERGENCY AND LANDED SAFELY, AFTER WHICH THE PASSESDR CA130805004Engine · malfunctioned(CAN) AFTER TAKEOFF AND GEAR RETRACTED, THE NR 1 ENGINE PROPELLER SPEED, NP WENT TO APPROXIMATELY 400 RPM AND THE TORQUE INCREASED MORE THAN 125 PERCENT. THE CREW SHUTDOWN ENGINE AND RETURNED TO THE DEPARTURE POINT WHERE AN UNEVENTFUL SINGLE ENGINE LANDING WASDR 39LA2013072900004Warning Light · false activationDURING GEAR UP, RED NOSE GEAR UNSAFE LIGHT AND AMBER GEAR HANDLE TRANSIENT LIGHT ILLUMINATED TWICE AFTER GEAR WAS FULLY RETRACTED. BOTH LIGHTS ILLUMINATED THREE MORE TIMES WITHIN THE NEXT TWO MINUTES. DIVERTED, DECLARED EMERGENCY AND PERFORMED THE ALTERNATE LSDR HNAA2013072400423Actuator · out of adjustLEFT MAIN GEAR DOOR LIGHT ILLUMINATED DURING CRUISE FLIGHT. GEAR DOOR WAS VERFIED TO BE OPEN WITH GEAR UP AND LOCKED. R & R LT MAIN FORWARD GEAT DOOR ACTUATOR. FOUND BUSHING WORN IN ACTUATOR LEVER. RIGGED FWD DOOR ACTUATOR IAW AMM 32-10-36. OPS AND LEAKED SDR HNAA2013072400429Threshold · corrodedPAX DOOR THRESHOLD IS CORRODED INCLUDING NUT PLATES ON BOTTOM SIDE. R & R BOTH THRESHOLD MEMBER AND RUBBER STRIP IAW DWG 85321241.SDR HNAA2013072400428Seat Track · corrodedCORROSION AT RT INBD SEAT TRACK IN FRONT OF GALLEY AT BS 222.700. CORROSION FOUND TO BE OUT OF LIMITS IAW RD8-53 4698. REMOVED SEAT TRACK. INSTALLED NEW SECTION OF SEAT TRACK IAW DWG 85320019.SDR HNAA2013072400424Transceiver · failedWEATHER RADAR FAILS WHEN ADJUSTING TILT. R & R RADAR R/T IAW MM 34-41-04. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2013072400421Smoke Detector · false activationSMOKE WARNING LIGHT ILLUMINATED DURING TAXI, NO SMOKE SEEN. LIGHT STILL ILLUMINATED. TESTED AND OPS CHECKED GOOD. R & R NR 2 BAG BAY SMOKE DETECTOR IAW AMM 26-12-01. OPS CHECKED GOOD.SDR V0XR2013072200001Skin · corrodedLIGHT CORROSION AT NR 2 DME X455.5 - X467.0 BETWEEN STRINGERS 32P - 32S. PERMANENT REPAIR MADE USING RD 8-53-9127.SDR HNAA201307220419Control Head · intermittentNR 2 COMM HEAD BLANK AND INTERMITTENTLY SHOWS TEST MESSAGE ON SCREEN. R & R NR 2 COMM CONTROL HEAD. OPS CHECKED GOOD IAW MM 23-21-04.SDR HNAA2013072200417Garlock Seal · damagedNR 1 OIL PRESSURE FLUCTUATED AND STEADILY FELL. FEATHERED NR 1 ENGINE AFTER PRESSURE FELL BELOW 55 PSI AND SHUTDOWN AFTER CONTINOUS ILLUMINATION OF CAUTION LIGHT. FOUND DRAIN LINE AT INBD IGNITER BAY CONNECTED TO PROP SHAFT DRAIN LEAKING. R & R PROP SHAFT SESDR HNAA2013072200416Linkage · malfunctionedPSCS SHOWS RT INBD SPOILER DEPLOYED. FOUND RT INBD SPOILER SYNCRO TRANSMITTER LINKAGE OVER CENTERED. REPOSITION AND CHECKED SECURITY. GROUND RAN AND OPS CHECKED GOOD.SDR HNAA2013072200414Bulb · failed4TH RED EMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R BULB FOR RED EMERGENCY FLOOR PATH LIGHT. OPS CHECKED GOOD.SDR HNAA2013072200413Bulb · failedAFT CEILING EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013071900412Proximity Sensor · malfunctionedAFTER MLG RETRACTION, LEFT AMBER DOOR LIGHT ILLUMINATED. CYCLED LANDING GEAR HANDLE AND AFTER GEAR RETRACTION, BOTH AMBER LIGHTS FLICKERED AND STAYED OUT. R & R AFT PROXIMITY SENSOR AND GAPED IAW MM 32-10-21. OPS CHECKED GOOD ON RT SIDE SURGE DAMPER WAS REPASDR CA130719009Processor · failed(CAN) TCAS SYSTEM WOULD NOT TEST AND FOUND TO BE UNSERVICEABLE. TCAS PROCESSOR FOUND TO BE AT FAULT, TCAS PROCESSOR REPLACED AND FUNCTION CHECKED SERVICEABLE.SDR HNAA2013071700411Autofeather Sys · malfunctionedAUTOFEATHER DID NOT ARM ON TAKEOFF. GROUND RAN ACFT AND COULD NOT DUPLICATE. OPS CHECKED GOOD.SDR HNAA2013071700410Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 9. R & R BULB AT ROW 9. OPS CHECKED GOOD.SDR CA130716001Bearing · damaged(CAN) DURING A FUNCTION CHECK OF THE FLAPS, A MAINTENANCE WORKER NOTICED THAT A PHONELIC BEARING SEAL ON THE LT WING OTBD FLAP ACTUATOR, OF THE OTBD FLAP, HAD POPPED OUT LEAVING THE BEARINGS EXPOSED. THE ACTUATOR WAS REPLACED WITH A SERVICEABLE UNIT. AC HOURSDR HNAA2013071500409Bulb · failedONE EMERGENCY FLOOR LIGHT IS INOPERATIVE AT ROW 9. R & R BULB AT ROW 9 EMERGENCY FLOOR PATH LIGHTING. OPS CHECKED GOOD.SDR HNAA2013071200408Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 1. R & R BULB IN ROW 1 EMERGENCY FLOOR PATH LIGHT. OPS CHECKED GOOD IAW AMM 33-57-00.SDR HNAA2013071000407Windshield · failedSMOKE COMING FROM TOP OD F/O'S WINDSHIELD IN WARM UP MODE. CREW TURNED OFF WINDSHIELD HEAT AND SMOKE DISSIPATED. R & R F/O'S WINDSHIELD IAW WC 56-00-00R. OPS CHECKED GOOD.SDR HNAA2013071000406Contactor · failedAPU FAILED. CIRCUIT BREAKER N-8 TRIPPED. R & R APU START CONTACTOR. RESET CIRCUIT BREAKER N-8. OPS CHECKED GOOD.
Back to Boeing DHC-8-102