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 HNAA0600190Floor Support · corrodedRIGHT FLOOR SUPPORT AT X488 REPLACED DUE TO CORROSION.SDR HNAA0600189Strap · corrodedINTERNAL JOINT STRAP AT X424 BETWEEN STRINGERS 31 AND 32 R/S WAS REPLACED DUE TO CORROSION.SDR HNAA0600188Skin Panel · corrodedSEVERAL AREAS OF CORROSION ON SKIN PANEL BETWEEN X434 TO X488 REPLACED PANEL.SDR HNAA0600187Stringer · corrodedSTRINGER 31 IS CORRODED JUST AFT OF TENSION FITTING BETWEEN X424 AND X436 R/S. REPLACED STRINGER.SDR HNAA0600186Angle · corrodedCENTER AISLE AFT SIDE OF FRAME AT X424 INBOARD FWD ANGLE ON RT KEEL BEAM WEB WAS REPLACED DUE TO CORROSION.SDR HNAA0600185Frame · corrodedFRAME LEG BETWEEN STR 31 AND 30 R/S AT X531 REPLACED DUE TO CORROSION.SDR HNAA0600184Doubler · corrodedDOUBLER ON AFT SIDE OF SPAR BETWEEN STRINGERS 28 AND 30S AT X424 WAS REPLACED DUE TO CORROSION.SDR HNAA0600183Strap · corrodedINTERNAL LONGITUDINAL STRAP RT SIDE AT X424 BETWEEN STRINGERS 27 AND 28 WAS REPLACED DUE TO CORROSION.SDR HNAA0600182Intercostal · corrodedINTERCOSTAL BETWEEN 424 AND 434 WAS REPLACED DUE TO CORROSION.SDR HNAA0600181Strap · corrodedJOINT STRAP AT 424 BETWEEN STRINGERS 28 AND 30 R/S WAS REPLACED DUE TO CORROSION.SDR HNAA0600180Stringer Splice · corrodedSTRINGER TIE REPLACED DUE TO CORROSION AT X424 STRINGER 23 RT.SDR HNAA0600178Stringer Splice · corrodedSTRINGER TIE REPLACED AT X424 STRINGER 25 DUE TO CORROSION.SDR HNAA0600177Stringer Splice · corrodedSTRINGER TIE REPLACED DUE TO CORROSION AT X424 STR 26S.SDR HNAA0600173Frame · corrodedFRAME AT X510 BETWEEN STRINGER 31S AND 31P HAS BEEN REPLACED DUE TO CORROSION.SDR HNAA0600162Stringer · corrodedSTRINGER 32 BETWEEN STATION 488 AND 531 REPLACED DUE TO HEAVY CORROSION.SDR HNAA0600160Fitting · corrodedVERTICAL LEG OF TENSION FITTING AT X531 IS BARE AND PITTED. REPLACED FITTING.SDR HNAA0600159Intercostal · corrodedAT PAX DOOR THRESHOLD FIRST STRINGER/INTERCOSTAL WAS REPLACED DUE TO CORROSION.SDR HNAA0600158Floorbeam · corrodedCABIN UNDER FLOOR FRAME LEG BETWEEN 32-33 L/S AT FRAME BEHIND RECIRC FAN MOUNT IS CORRODED AT X291. CLEANED AREA OF FRAME LEG AND FOUND MINOR CORROSION AROUND I/B MOST RIVET. CLEANED ALODINED AND PRIMED AREA.SDR HNAA0600157Angle · corrodedCLEAT REPLACED DUE TO CORROSION AND CRACKING AT X354 STRINGER 23P.SDR HNAA0600156Seat Track · corrodedCLEAT REPLACED DUE TO BEING CRACKED AND CORRODED AT X312 STR 23P AT SEAT RAIL ATTACH POINT LT SIDE.SDR HNAA0600155Seat Track · corrodedRIGHT REAR SEAT RAIL REPLACED DUE TO CORROSION.SDR HNAA0600145Threshold · corrodedPAX DOOR THRESHOLD FRAME REPLACED DUE TO CORROSION.SDR HNAA0600154Intercostal · corrodedAT PAX THRESHOLD FIRST STRINGER INTERCOSTAL INBOARD OF DOOR OPENING WAS REPLACED DUE TO CORROSION ON FORWARD END.SDR HNAA0600175Frame · corrodedFRAME LEG IS CORRODED BETWEEN STRINGERS 31 AND 32 AT X467 R/S. REPLACED LOWER FRAME SEGMENT.SDR HNAA0600176Frame · corrodedCORROSION TO FRAME LEGS AT X445 BETWEEN STRINGERS 26 THROUGH 31. REPLACED FRAME SECTION.SDR HNAA0600174Stringer Splice · corrodedSTRINGER SPLICE ON STR 26S AT X445 WAS REPLACED DUE TO CORROSION.SDR HNAA0600172Stringer Splice · corrodedSTRINGER SPLICE ON STRINGER 25S AT X488 HAS BEEN REPLACED DUE TO CORROSION.SDR HNAA0600171Angle · corrodedREINFORCING ANGLE AT 467 ON LOWER RIGHT HAND FRAME SEGMENT IS CORRODED. REPLACED ANGLE.SDR HNAA0600170Plate · corrodedREINFORCING PLATE AT 467 WAS REPLACED DUE TO CORROSION.SDR HNAA0600169Attach Angle · corrodedAT PAX DOOR ANGLE ATTACHING INTERCOSTAL TO FWD FRAME CASTING REPLACED DUE TO CORROSION.SDR HNAA0600168Angle · corrodedCLEAT ATTACHING INTERCOSTAL TO FWD MAIN DOOR FRAME REMOVED AND REPLACED DUE TO CORROSION.SDR HNAA0600167Shear Tie · corrodedCLEAT ATTACHING FORWARD FRAME TO SKIN REMOVED AND REPLACED DUE TO CORROSION.SDR HNAA0600166Strap · corrodedSHORT AFT STRAP LOCATED ON TOP OF INTERCOSTAL WAS REPLACED DUE TO CORROSION.SDR HNAA0600164Bracket · corrodedBRACKET ATTACHING INTERCOSTAL TO AFT FRAME CASTING REMOVED AND REPLACED DUE TO CORROSION.SDR HNAA0600153Frame · corrodedFRAME LEGS BETWEEN STR 32 AND 26 ARE CORRODED AT 434. REPLACED FRAME SEGMENT.SDR HNAA0600152Frame · corrodedFRAME LEGS BETWEEN STRINGERS 24 THROUGH 31 ARE CORRODED. REPLACED FRAME SEGMENT.SDR HNAA0600151Floor Support · corrodedBOTTOM OF RIGHT FLOOR SUPPORT AT 445 IS CORRODED. REPLACED SUPPORT.SDR HNAA0600150Floor Support · corrodedBOTTOM OF RIGHT FLOOR SUPPORT AT STATION 467 IS CORRODED. REPLACED FLOOR SUPPORT.SDR HNAA0600144Intercostal · corrodedPAX DOOR ENTRANCE UNDER FLOOR INTERCOSTALS HAS SEVERAL AREAS WITH CORROSION. REPLACED INTERCOSTALS.SDR HNAA0600142Stringer Splice · corrodedUNDER FLOOR CORROSION ON STRINGER SPLICE AT STRINGER 29 AND X201. REPLACED SPLICE.SDR HNAA0600141Skin Panel · corrodedLOWER SILL ON LAV SERVICE AREA CORRODED. REPAIRED IN ACCORDANCE WITH ENGINEERING ORDER EO8-53-06-0420.SDR HNAA0600140Frame · corrodedCENTER AISLE UNDER FLOOR FRAME LEG CORRODED BETWEEN STRINGERS 31 AND 32 AT FRAME 436. REMOVED AND REPLACED RIGHT HAND BOTTOM FRAME SEGMENT.SDR HNAA0600136Frame · corrodedCABIN UNDER FLOOR FORWARD SIDE OF FRAME LEG CORRODED AT X270 BETWEEN STRINGERS 27 28 R/S. REMOVED AFFECTED CHINE FRAME, INSTALLED CHINE FRAME, (NEW) IAW DRWG 5 85320210 85321385.SDR HNAA0600135Floorbeam · corrodedCABIN UNDER FLOOR CORROSION ON FRAME LEG BETWEEN STR 30 AND 31 AT X370 R/S. CLEANED AREA & FOUND MINOR CORROSION AROUND RIVET FASTENER REPAIRED IAW SRM 51-20-11, ALODINED & PRIMED IAW SRM 51-20-16 & 51-20-36.SDR HNAA0600134Frame · corrodedCABIN UNDER FLOOR FRAME LEG IS CORRODED AT X436 BETWEEN STRINGERS 30 AND 31. REMOVED AND REPLACED RIGHT HAND BOTTOM FRAME SEGMENT AT STA X434 IAW DEHAVILLAND DRAWINGS 85330057 AND 85330012.SDR CA061121003Line · split(CAN) WHILE CARRYING OUT ZONAL INSPECTION 263 AND 264, BOTH WING ROOT DRAIN LINES WERE FOUND BLOCKED AT THE BELLY DRAINS. THE ACCUMULATED WATER IN THE DRAIN LINE IN TURN FROZE AND SPLIT THE DRAIN LINE CAUSING PRESSURIZATION LEAK AND WATER AND SKYDROL TO LEAK ISDR FDKA200611325Relay · malfunctionedFDM 6212 JFK-PWM (2315 PHX LCL). CREW ABORTED TAKEOFF DUE TO AUTOFEATHER WOULD NOT ARM. MX REMOVED AND REPLACED RELAYS 6121K5 & 6121K11.SDR FDKA200611324Connector · dirtyFDM 6142 BTV-JFK (1454 PHX LCL). ABORTED TAKEOFF DUE TO NR 1 ENGINE OIL PRESSURE CAUTION. CONTRACT MX CLEANED OIL PRESSURE SENSOR ELECTRICAL CONNECTOR AND PERFORMED ENGINE RUNS. NO FURTHER DEFECTS NOTED.SDR HNAA0600129Valve · stickingUPON RETARDING POWER LEVERS TO FLIGHT IDLE THE CREW NOTICED OIL SMELL IN COCKPIT. REMOVED, CLEANED AND REINSTALLED BLEED SWITCHING VALVES.SDR HNAA0600130Unknown · smokeAT 12,000 FEET WHILE REDUCING POWER THE CREW NOTICED SMOKE IN THE FLIGHT DECK FOLLOWED BY SMOKE IN THE CABIN. FOUND BOTH ENGINES OVERSERVICED WITH OIL. SERVICED TO PROPER LEVEL AND PERFORMED GROUND RUN, NO DEFECTS NOTED.
Back to Boeing DHC-8-102