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 ZZDA2011079Light · inoperativeONE EMERGENCY ESCAPE PATH LIGHT ASSEMBLY ON SIDE OF SEAT 3D DOES NOT ILLUMINATE. RELAMPED & OPS CHECKED REF AMM 33-51.SDR ZZDA2011078Intercostal · corrodedAFT CARGO COMPARTMENT INTERCOSTAL SECTION, STA 1022 TO 1037, LONG L30, CORROSION. ACCOMPLISHED INTERCOSTAL SECTION REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011077Structure · crackedLEFT PYLON APRON LOWER AFT HINGE CUTOUT, CRACKED. ACCOMPLISHED AFT HINGE CUTOUT DOUBLER REPAIR PER TRA 17-54-TR00129.SDR ZZDA2011083Cover · missingCABIN OVERHEAD LIGHTED "EXIT" SIGN MISSING ABOVE ROW ONE. REPLACED "EXIT" SIGN COVER OVER ROW 1 AISLE IAW B717 MM 33-51. OPS GOOD.SDR ZZDA2011076Structure · crackedLEFT PYLON APRON LOWER NR 2 HINGE CUTOUT AREA, CRACKED. ACCOMPLISHED NR 2 HINGE CUTOUT AREA DOUBLER REPAIR PER TRA 17-54-TR00129.SDR ZZDA2011075Structure · crackedLEFT PYLON APRON UPPER AFT HINGE CUTOUT, CRACKED. ACCOMPLISHED AFT HINGE CUTOUT DOUBLER REPAIR PER TRA 17-54-TR00129.SDR ZZDA2011074Longeron · corrodedE/E COMPARTMENT LONGERON SECTION, STA 125, LONG L30, CORROSION. ACCOMPLISHED LONGERON SECTION REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011073Attach Fitting · corrodedGALLEY ENTRANCE FWD AND AFT GIRT BAR ATTACH FITTINGS, CORROSION. ACCOMPLISHED GIRT BAR ATTACH FITTINGS REPLACEMENT PER B717 SRM 51-41-01 AND B717 SRM 51-41-02.SDR ZZDA2011072Seat Track · corrodedCABIN SEAT TRACK, STA 237, RBL 22, CORROSION. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER BOEING DWG SR09530085.SDR ZZDA2011136Floor Support · corrodedCABIN FLOOR SUPPORT, STA 160 TO 200, RBL 53, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011068Floor Support · corrodedCABIN FLOOR SUPPORT, STA 179, LBL 15 TO LBL 37, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011063Scuff Plate · chafedFWD CARGO DOOR HANDLE CUTOUT, CHAFED. ACCOMPLISHED HANDLE CUTOUT SCUFF PLATE REPAIR PER B717 SRM 32-30-01 FIG 201 REPAIR 1.SDR ZZDA2011069Floor Support · corrodedCABIN FLOOR SUPPORT, STA 200, RBL 8 TO RBL 45, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011067Seat Track · corrodedCABIN SEAT TRACK, STA 148 TO 200, RBL 7, CORROSION. ACCOMPLISHED SEAT TRACK REPLACEMENT PER B717 SRM 51-41-01.SDR ZZDA2011066Floor Support · corrodedCABIN FLOOR SUPPORT, STA 200 TO 256, LBL 15, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011065Seat Track · corrodedCABIN SEAT TRACK, STA 148 TO 200, LBL 7, CORROSION. ACCOMPLISHED SEAT TRACK REPLACEMENT PER B717 SRM 51-41-01.SDR ZZDA2011064Floor Support · corrodedCABIN FLOOR SUPPORT, STA 200, LBL 5 TO RBL 5, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011062Strap · corrodedPASSENGER ENTRANCE SCUFF PLATE STRAP, CORROSION. ACCOMPLISHED SCUFF PLATE STRAP REPLACEMENT PER B717 SRM 51-40-02.SDR ZZDA2011060Longeron · corrodedAFT CARGO COMPARTMENT LONGERON SECTION, STA 1022 TO 1037, LONG L30, CORROSION. ACCOMPLISHED LONGERON SECTION REPLACEMENT PER B717 SRM 51-41-02 AND B717 SRM 51-41-05.SDR ZZDA2011058Floor Support · corrodedRIGHT FWD FUSELAGE BELOW CATERING DOOR FLOOR SUPPORT, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-01.SDR ZZDA2011061Seat Track · corrodedCABIN SEAT TRACK, STA 200 TO 256, RBL 22, CORROSION. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER BOEING DWG SR09530085 AND DC9 SRM 53-05 FIG 4F.SDR ZZDA2011059Seat Track · corrodedCABIN SEAT TRACK, STA 165, RBL 7, CORROSION. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER B717 SRM 51-41-01 AND B717 SRM 51-41-02.SDR ZZDA2011057Pan · corrodedFWD CARGO DOOR JAMB PAN, CORROSION. ACCOMPLISHED JAMB PAN SPLICE REPAIR PER B717 SRM 53-20-15 FIG 201 REPAIR 6.SDR ZZDA2011056Seat Track · corrodedCABIN SEAT TRACK, STA 237, RBL 44, CORROSION. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER DC9 SRM 53-05 FIG 4F.SDR ZZDA2011053Sign · crackedEXIT SIGN OVER ROW 1 IS CRACKED. REMOVED AND REPLACED EXIT SIGN REF SWPM 20-10, OPS CHECK GOOD REF MM 33-50.SDR ZZDA2011052Battery Pack · dischargedBOTH OVERWING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED OVERWING BATTERY PACK REF AMM 33-51.SDR ZZDA2011055Web · crackedCABIN LONGERON FINGER WEB, STA 196, LONG L15L, CRACKED. ACCOMPLISHED LONGERON FINGER WEB DOUBLER REPAIR PER B717 SRM 51-70-10 FIG 201 REPAIR 2.SDR ZZDA2011054Seat Track · corrodedCABIN SEAT TRACK, STA 165, LBL 7, CORROSION. ACCOMPLISHED SEAT TRACK SPLICE REPAIR PER B717 SRM 51-41-05.SDR ZZDA2011048Floor Support · corrodedCABIN FLOOR SUPPORT, STA 237, LBL 22 TO RBL 22, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011046Floor Support · corrodedCABIN FLOOR SUPPORT, STA 148 TO 169, LBL 7, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-01.SDR HALA2011011700120Bulkhead · corrodedLEVEL 2 CORROSION ON "AFT CARGO AFT BULKHEAD CENTER LOWER AREA ANGLE & DOUBLER.//REMOVED ANGLE, CLEANED CORROSION,TREATED AND PRIMED, REF. B717 SRM 51-10-04. REMOVED AND FABRICATED NEW BOUBLER & INSTALLED AT AFFECTED AREA, REF. B717 SRM 51-10-04.SDR ZZDA2011047Floor Support · corrodedCABIN FLOOR SUPPORT, STA 200, RBL 57, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011045Floor Support · corrodedCABIN FLOOR SUPPORT, STA 195, LBL 55, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-01.SDR ZZDA2011044Web · corrodedCABIN FLOOR WEB, STA 200, LBL 14, CORROSION. ACCOMPLISHED FLOOR WEB DOUBLER REPAIR PER B717 SRM 51-70-10 FIG 201 REPAIR 2.SDR ZZDA2011043Floor Support · corrodedCABIN FLOOR SUPPORT, STA 200, RBL 8 TO RBL 45, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011042Floor Support · corrodedCABIN FLOOR SUPPORT, STA 169, BL 0, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011041Floor Support · corrodedCABIN FLOOR SUPPORT, STA 148 TO 169, RBL 7, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-01.SDR ZZDA2011040Floor Support · corrodedCABIN FLOOR SUPPORT, STA 148, RBL 23 TO RBL 40, CORROSION. ACCOMPLISHED FLOOR SUPPORT REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2011030Proximity Sensor · out of adjustAFTER GEAR RETRACTION STILL HAD A LEFT GEAR UNSAFE LIGHT INDICATION. ADJUSTED LEFT MLG UP LATCH PROX SENSOR REF AMM 32-61-00 OPS CHECK GOOD.SDR ZZDA2011029Light · missingEMERGENCY ESCAPE PATH LIGHTING SEAT 3D HAS BULB MISSING. RELAMPED SEAT LAMP ASSEMBLY PER B717 AMM 33-51. OPS CHECK GOOD. CLEARS MDDR AND MEL.SDR ZZDA2011028Lens · missingCLEAR LIGHT LENS COVER MISSING 3D. INSTALLED LENS COVER ON EMERGENCY ESCAPE PATH LIGHTING AT SEAT 3D PER B717 AMM 33-51. CLEARS MDDR AND MEL.SDR ZZDA2011039Web · corrodedCABIN FLOOR WEB, STA 192, BL 0, CORROSION. ACCOMPLISHED FLOOR WEB DOUBLER REPAIR PER B717 SRM 51-70-10 FIG 201 REPAIR 2 AND B717 SRM 51-41-02.SDR ZZDA2011094Lanyard · unknownCHECK R1 EMERGENCY SLIDE INTEGRITY (PILOT REQUEST). REMOVED AND REPLACED R1 DOOR SLIDE GIRT BAR LANYARD REF AMM 25-61.SDR HALA2011011400075Seat Track · corrodedLEVEL 2 CORROSION AT CABIN SEAT TRACK STA 224, RBL 44. R & R SEAT TRACK AT STA 224, RBL 44, IAW DWG SR0953985.SDR HALA2011011400072Seat Track · corrodedLEVEL 2 CORROSION FOUND ON CABIN SEAT TRACK AT STA 224, RBL 22. REMOVED CORROSION IAW SRM 51-10-04, NDT ACCOMPLISHED, CHECKED LIMITS, FOUND TO BE OUT OF LIMITS IAW SRM 53-20-52. REMOVED SEAT TRACK IAW SRM 51-40-02. TRIMED NEW SEAT TRACK IAW DWG SR09530085, SDR HALA2011011300073Strap · corrodedLEVEL 2 CORROSION AT AFT CARGO COMPARTMENT STA 986 THRU 994, BETWEEN LONGERON 30 THRU 29R AREA WITH SPOT CORROSION. R & R STRAP AT AFT CARGO COMPARTMENT, STA 986 THUR 994 BETWEEN LONG 30 THRU 29R, IAW SRM 51-41-05 & 51-41-01.SDR ZZDA2011027Strap · detachedL1 DOOR GIRT BAR STRAP NOT ATTACHED. RE-INSTALLED GIRT BAR STRAP.SDR ZZDA2011026Cover · missingEMERGENCY EXIT COVER IN FIRST CLASS IS MISSING. INSTALLED MISSING EXIT SIGN COVER PER 717 AMM 33-51. OK FOR CONTINUED SERVICE.SDR ZZDA2011025Cover · missingROW 1 OVERHEAD EXIT SIGN COVER REMOVED FROM AIRCRAFT 719. INSTALLED EXIT SIGN LENSE COVER PER 717 AMM 33-51.SDR ZZDA2011089Support Fitting · corrodedGALLEY SUPPORT FITTING, STA 200 TO 216, RBL 57, CORROSION. ACCOMPLISHED SUPPORT FITTING REPLACEMENT PER B717 SRM 51-41-05.
Back to Boeing 717-200