Boeing 717-200
Service difficulty reports · 18,771
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 = '717200' 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 = '717200' 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 HALA0800310Frame · crackedCRACK ON O/B SECTION OF NR 3 FORMER LT WING BELOW CENTER SECTION, VIEWED FROM 4TH WITNESS HOLE. REPAIR IN WORK.SDR HALA0800309Frame · crackedCRACK ON O/B SECTION OF MOST FWD FORMER LEFT WING BELOW CENTER SECTION, VIEWED FROM 2ND WITNESS HOLE. REPAIR IN WORK.SDR HALA0800328Door · corrodedLEVEL 1 CORROSION ON INNER SURFACE OF RT MLG OUTBOARD DOOR. REPAIR IN WORK.SDR HALA0800327Panel · corrodedLEVEL 1 CORROSION, NUMEROUS FASTENERS HOLES, ON LOWER SURFACE OF THE LT HORIZ STAB L/E PANEL. REPAIR IN WORK.SDR HALA0800312Skin · corrodedLEVEL 1 CORROSION ON BELLY, JUST LEFT OF MLG DOOR BY PASS CUTOUT. REPAIR IN WORK.SDR HALA0800313Frame · crackedCRACK ON O/B SECTION OF MOST FWD FORMER RIGHT WING BELOW CENTER SECTION, VIEW FROM 2ND WITNESS HOLE. REPAIR IN WORK.SDR HALA0800317Skin · corrodedLEVEL 1 CORROSION AND PAINT PEEL, NR 1 ENGINE, TOP COWL EXTERIOR AT FAN AIR VALVE EXIT AND 1 PLACE AT COWL HALF. REPAIR IN WORK.SDR HALA0800316Skin · corrodedLEVEL 1 CORROSION ON TOP COWL NR 1 ENGINE, ALONG L/E AND HINGE EDGE. REPAIR IN WORK.SDR HALA0800314Frame · crackedCRACK ON O/B SECTION OF FORMER NR 2 RIGHT WING BELOW CENTER SECTION, VIEWED FROM 2ND WITNESS HOLE. REPAIR IN WORK. REPAIR IN WORK.SDR HALA0800331Structure · corrodedLEVEL 1 CORROSION, ON LT HORIZ STAB INBD L/E LOWER INBD ATTACH AFT END. REPAIR IN WORK.SDR HALA0800330Structure · corrodedLEVEL 1 CORROSION, NUMEROUS FASTENERS ON OTBD END OF LT HORIZ STAB INNER BOX AREA. REPAIR IN WORK.SDR HALA0800332Track · corrodedLEVEL 1 CORROSION ON VERTICAL STAB RT EXTERIOR SURFACE AFT OF HORIZ STAB ROLLER TRACK. REPAIR IN WORK.SDR HALA0800320Structure · corrodedLEVEL 1 CORROSION, RT HORIZ STAB 1 RUSTED NUT O/B AFT SIDE OF HORIZ INTERNAL STRUCTURE AT STA XHS 221. REPAIR IN WORK.SDR HALA0800319Structure · corrodedLEVEL 1 CORROSION ON RT HORIZ 2. RUSTED NUTS AFT SIDE OF HORIZ INTERNAL STRUCTURE AT STA XHS 103. REPAIR IN WORK.SDR HALA0800329Door · corrodedLEVEL 1 CORROSION ON THE EXTERIOR SURFACE OF THE RT MLG OTBD DOOR. REPAIR IN WORK.SDR HALA0800315Cargo Track · corrodedLEVEL 1 CORROSION IN AFT CARGO BAY, ON FASTENER ON LEFT CARGO TIE DOWN TRACK AT STA 851. REPAIR IN WORK.SDR ZZDA2008070Pan · crackedWHILE PREPARING TO TAXI A/C FOUND AFT PIT DOOR FWD PAN CRACKED. FABRICATED .063" 2024-T42 REPAIR ANGLE AND .050" 301 1/2 HARD DOUBLER. INSTALLED REPAIR PARTS WITH HLT 434-6 AND HLT 334-6 REFERENCE EA 17-52-01010IR AND SRM CHAPTER 51.SDR HALA0800291Skin · cracked2 CRACKS ON RIGHT MLG DOOR CUTOUT JUST ABOVE DOOR SENSOR. REPAIR IN WORK.SDR HALA0800296Structure · corrodedSURFACE CORROSION AND PAINT PEELING ON LT MLG DOOR ON LEADING EDGE, REPAIR IN WORK.SDR HALA0800297Panel · corrodedNUMEROUS BOLT HEADS CORRODED ON LT ENGINE, ON TRAPEZOIDAL PANEL ABOVE AND I/B SIDE OF FWD MOVEABLE VANE. REPAIR IN WORK.SDR HALA0800294Skin · corrodedRT MLG DOOR HAS SURFACE CORROSION ON OUTER SKIN. REPAIR IN WORK.SDR HALA0800293Intercostal · crackedRT MLG DOOR INTERCOSTAL CRACKED SEEN INSIDE FWD MID ACCESS PANEL. REPAIR IN WORK.SDR HALA0800295Skin · corrodedLT MLG DOOR HAS SURFACE CORROSION ON OUTER SKIN. REPAIR IN WORK.SDR HALA0800292Door · crackedRT MLG DOOR RAMP CRACKED AT INBD MOUNT BRACKET. REPAIR IN WORK.SDR HALA0800264Boot · looseWHEN ENTERING COCKPIT ON CREW CHANGE, FOUND TAIL TEMP HIGH LIGHT ON. A/C PACKS SHUTOFF. FOUND RT ACM EXHAUST DUCT BOOT LOOSE AND LEAKING. RESECURED RT PACK EXHAUST BOOT. OPS CK LEAK CK GOOD.SDR MWEA080033Dimmer · faultyCIRCUIT BREAKER K-14 POPPED DURING COCKPIT PREP CHECK. REMOVED AND REPLACED DIMMER.SDR MWEA080031Relay · failedBUSS AC "EMERGENCY OFF" LIGHT ILLUMINATED. REMOVED AND REPLACED RELAY.SDR MWEA080030Frame · crackedRIGHT ENGINE THRUST REVERSER UPPER DEFLECTOR DOOR ZEE FRAME HAS TWO CRACKS AT THE RIGHT SIDE 1 EACH IN THE RADIUS AT THE END AND 1 EACH BETWEEN 2 FASTENERS, ALSO EXTENDING FROM 1 OF THE RIVETS LOCATED APPROXIMATLEY 4 INCHES INBOARD 26.666. REMOVED DAMAGED SECSDR MWEA080029B-Nut · disconnectedLEFT ENGINE FIRE SUPPRESSION LINE AFT "B" NUT DISCONNECTED. RECONNECTED "B" NUT. SURPRESSIONSDR ZZDA2008069Frame · crackedSMALL CRACK AFT FUSELAGE INTERNAL LT CANTED FRAME STA 1200.019. INSTALLED REPAIR 15" X 2" AS REQ 51-70-11 MATERIAL USED 7075.0 .063 HEAT TREATMENT TO 7075 T6 .063 AS PER SRM 51-32.01.SDR ZZDA2008078Frame · crackedCRACK NOTICED AFT FUSELAGE INT LEFT CANTED FRAME AREA STA 1178.225 BELOW L16L AFT OF HYD S/O VALVE. INSTALLED ANGLE REPAIR AT LEFT CANTED FRAME STA 1178.225 BELOW L161L, AFT OF HYD S/O VALVE IAW B717 SRM 51-70-11 FIG 201 REPAIR 1. MATERIAL USED 7075-0 .080 SSDR ZZDA2008072Frame · crackedCRACK NOTICED AT AFT FUSELAGE INT LEFT CANTED BLKD STA 1178.225 L16L AFT OF HYD S/O VALVE. INSTALLED DOUBLE REPAIR AT AFT FUSELAGE INTERNAL LT CANTED BLKD STA 1178.225 L16L IAW B717 SRM 51-70-11 FIG 201 REPAIR 1, MEASURE 12" X 3".SDR ZZDA2008067Skin · gougedGOUGES IN FUSELAGE SKIN FS 215-244 LONGERON 16L. BLENDED DAMAGE, FABRICATED AND INSTALLED INTERNAL DOUBLER IAW B717 SRM 53-00-01 REPAIR 2.SDR ZZDA2008066Pan · corrodedAFT CARGO DOOR CUT OUT LOWER PAN HAS CORROSION. FOUND CORROSION OUT OF LIMITS TRIMED OUT DAMAGE SECTION AND INSTALLED NEW SECTION AND SPLICES IAW B717 SRM 53-20-15 FIG 201.SDR ZZDA2008068Pan · corrodedAFT CARGO DOOR JAM CUT OUT LOWER PAN HAS CORROSION. CUT OUT LOWER JAM SECTION AND INSTALLED LOWER JAM SECTION AND SPLICES AT AFT CARGO COMP IAW B717 SRM 53-20-15 REP 7.SDR MWEA080027Door Frame · crackedLOWER DEFLECTOR DOOR Z-FRAME IS CRACKED AT STATION 35.669 (RIGHT). FABRICATED AND INSTALLED Z-FRAME.SDR MWEA080026Door Frame · crackedLOWER DEFLECTOR DOOR Z-FRAME CRACKED AT STATION 35.669 (LEFT). FABRICATED AND INSTALLED ANGLE.SDR MWEA080025Door Frame · crackedLOWER DEFLECTOR DOOR Z-FRAME IS CRACKED AT STATION 26.666 (LEFT). FABRICATED AND INSTALLED ANGLE.SDR MWEA080024Frame · crackedUPPER BUCKET Z-FRAME LEFT END AT STATION 35.669 IS CRACKED. FABRICATED AND INSTALLED Z-FRAME.SDR MWEA080023Frame · crackedUPPER BUCKET Z-FRAME LEFT END AT STATION 26.666 IS CRACKED. FABRICATED AND INSTALLED Z-FRAME.SDR HALA0800034Control Unit · failedANTI-SKID FAIL AFTER GEAR EXTENSION - ATB. TROUBLESHOT IAW FIM 32-45, TASK 807. REMOVED AND REPLACED DCU IAW AMM 31-43-02. OPS CHECK GOOD. MIC SHEET CLEARED. PLACARD REMOVED.SDR HALA0800033Control Unit · failedANTI-SKID FAIL IN FLT - ATB. REPLACED BCU PER AMM 32-45-01. RETURN TO SERVICE TEST PASSED.SDR ZZDA2008062Wire · brokenTEST OF EMERGENCY LIGHTS FOR SERVICE CHECK, TC601 STEP 34, REVEALED LIGHT INOPERATIVE AT SEAT 23D. REPAIRED BROKEN WIRE AT SEAT 23D IAW GMM 12-00-00, SYS CHECKS GOOD.SDR MWEA080021Skin · bentFORWARD ENTRANCE DOOR, FORWARD LOWER CORNER SKIN IS BENT. FABRICATED AND INSTALLED DOUBLER.SDR MWEA080020Doubler · corrodedCORROSION ON STAR DOUBLER LOCATED ON TOP OF FRAME AT STATION 944 AND LONGERON 29 RIGHT. BLENDED CORROSION, FABRICATED AND INSTALLED DOUBLER.SDR MWEA080019Skin · damagedFORWARD PASSENGER DOOR, AFT LOWER CORNER EXIT HAS SKIN DAMAGE. FABRICATED AND INSTALLED DOUBLER.SDR ZZDA2008064Frame · crackedCRACK AT TAIL COMPARTMENT, RIGHT CANTED FRAME 1178.225 BETWEEN LONG 13 AND 14 R. INSTALLED FORMED CHANNEL REPAIR ON RIGHT CANTED 1178.225 PER SRM 41-70-11 F 201.SDR ZZDA2008063Frame · crackedTWO CRACKS FOUND AT INT TAIL COMP LT SIDE CANTED FRAME STA 1178.225 BETWEEN LONG 13L AND 14L. INSTALLED FORMED CHANNEL REPAIR ON CANTED FRAME LT STA 1178.225 PER B717 SRM 51-70-11 FIG 201.SDR HALA0800027Engine · failedAIR TURN BACK AT KOA STATION DUE LOUD BANG, ENGINE SHUTDOWN, TGT 1149.5 DEGREES. PERFORMED CHECK LIST AND FIRED 1 FIRE BOTTLE. RETURN TO AIRPORT. REMOVED NR 1 ENGINE PER M144-717 REF LG PG 216722/75. INSTALLED NR 1 ENG PER HALM 143-717 GROUND RUNUP & LEAK SDR MWEA080018Battery · dischargedFORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD EMERGENCY FLASHLIGHT BATTERY.
Back to Boeing 717-200