N717UW
Service difficulty reports · 314
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N717UW' AND registry_match = 'registration' 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 n_number = 'N717UW' AND registry_match = 'registration' 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 USAA2011050991810Profile · corrodedCWF - S4 - CORROSION ON PROFILE BETWEEN FR54 TO FR56, Y623. REPLACED PROFILE BETWEEN FR54 TO FR56, Y623 IAW A319 SRM 51-72-11.SDR USAA2011050991815Floor Panel · corrodedCWF - S4 - CORROSION ON CABIN FLOOR PANEL 222FF LOCATED BETWEEN FR16 TO FR20 & BETWEEN -Y765 TO -Y1292. REPLACED CABIN FLOOR PANEL 222FF LOCATED BETWEEN FR16 TO FR20 & BETWEEN -Y765 TO -Y1292 IAW A319 SRM 51-42-21.SDR USAA2011050991813Floor Panel · delaminatedCWF - S4 - DELAMINATION ON CABIN FLOOR PANEL 261DF LOCATED BETWEEN FR66 TO FR68 & BETWEEN -Y765 TO Y765. REPLACED CABIN FLOOR PANEL 261DF LOCATED BETWEEN FR66 TO FR68 & BETWEEN -Y765 TO Y765 IAW MCGILL IRM 9701 REV G.SDR USAA2011050991805Profile · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON PROFILE AT FR52, S32R. REPLACED PROFILE AT FR52, S32R IAW A319 SRM 51-72-11.SDR USAA2011050991801Plate · corrodedCWF - S4 - LEVEL 2 GALVANIC CORROSION ON SUPPORT PLATE AT FR68, S23R, -Y765. REPLACED SUPPORT PLATE AT FR68, S23R, -Y765 IAW A319 SRM 51-42-11.SDR USAA2011050691792Seat Track · corrodedCWF - S4 - CORROSION ON SEAT TRACK AT FR35, Y254. REPAIRED SEAT TRACK AT FR35, Y254 IAW A319 SRM 53-00-14.SDR USAA2011051691860Splice Plate · corrodedCWF - S4 - CORROSION ON R1 DOOR SPLICE PLATE LOWER SURFACE. REPLACED R1 DOOR SPLICE PLATE IAW JOB CARD 26C22053014.SDR USAA2011050991816Floor Panel · corrodedCWF - S4 - LEVEL 2 INTERGRANULAR CORROSION FLOOR PANEL 221DF INSERTS BETWEEN FR16 TO FR20 & BETWEEN -Y254 TO Y254. REPLACED FLOOR PANEL 221DF INSERTS BETWEEN FR16 TO FR20 & BETWEEN -Y254 TO Y254 IAW MCGILL IRM 9701 REV G.SDR USAA2011050991811Floor Panel · damagedCWF - S4 - COMPOSITE MATERIAL MISSING ON CABIN FLOOR PANEL 242HF LOCATED BETWEEN FR36 TO FR42 & BETWEEN -Y1292 TO Y1732. REPLACED CABIN FLOOR PANEL 242HF LOCATED BETWEEN FR36 TO FR42 & BETWEEN -Y1292 TO Y1732 IAW MCGILL AIM 9701.SDR USAA2011050991804Longeron · corrodedCWF - S4 - LEVEL 2 GALVANIC CORROSION ON LONGERON AT FR23, S23L, Y254. REPLACED LONGERON AT FR23, S23L, Y254 IAW A319 SRM 51-72-11.SDR USAA2011050691796Floor Support · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT BETWEEN FR20 TO FR23, Y345. REPLACED FLOOR SUPPORT BETWEEN FR20 TO FR23, Y345 IAW A319 SRM 51-72-11.SDR USAA2011050691795Floor Support · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT BETWEEN FR64 TO FR66, -Y765. REPLACED FLOOR SUPPORT BETWEEN FR64 TO FR66, -Y765 IAW A319 SRM51-72-11.SDR USAA2011050691794Floor Support · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT AT FR66 + 4 INCHES, -Y384. REPLACED FLOOR SUPPORT AT FR66 + 4 INCHES, -Y384 IAW A319 SRM 51-42-11.SDR USAA2011050691789Angle · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON Z-ANGLE AT FR20 + 2 INCHES, -Y1646. REPLACED Z-ANGLE AT FR20 + 2 INCHES, -Y1646 IAW A319 SRM 51-72-11.SDR USAA2011050691787Profile · corrodedCWF - S4 - CORROSION ON BULK CARGO FLOOR PROFILE AT FR61 BETWEEN S38L TO S38R. REPLACED BULK CARGO FLOOR PROFILE AT FR61 BETWEEN S38L TO S38R IAW A319 SRM 51-42-11 & 51-72-11.SDR USAA2011050691785Profile · corrodedCWF - S4 - CORROSION ON AFT CARGO FLOOR PROFILE AT FR56, Y=0. REPLACED AFT CARGO FLOOR PROFILE AT FR56, Y=0 IAW A319 SRM 51-72-11.SDR USAA2011051091830Floor Panel · delaminatedCWF - S4 - DELAMINATION ON FLOOR PANEL 261HG BETWEEN FR64 TO FR66, S23L & BETWEEN Y1292 TO Y765. REPLACED FLOOR PANEL 241HG IAW MCGILL IRM 9701 REV G.SDR USAA2011050691793Seat Track · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, -Y765. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, -Y765 IAW A319 SRM 51-72-11.SDR USAA2011050691791Seat Track · corrodedCWF - S4 - CORROSION ON SEAT TRACK AT FR62 + 4 INCHES, -Y1292. REPLACED SEAT TRACK AT FR62 + 4 INCHES, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2011050691790Seat Track · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, -Y1292. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, -Y1292 IAW A319 SRM 51-42-11.SDR USAA2011050691788Angle · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON Z-ANGLE AT FR24, -Y1774. REPLACED Z-ANGLE AT FR24, -Y1774 IAW A319 SRM 51-72-11.SDR USAA2011050691786Profile · crackedCWF - S4 - CRACK ON AFT CARGO FLOOR PROFILE AT FR59 BETWEEN S38L TO S38R & BETWEEN Y623 TO -Y623. REPLACED AFT CARGO FLOOR PROFILE AT FR59 BETWEEN S38L TO S38R & BETWEEN Y623 TO -Y623 IAW A319 SRM 51-72-11 & 51-42-11.SDR USAA2011051691863Floorboard · corrodedCWF - S4 - CORROSION ON FLOORBOARD NR 232FF FORWARD MOUNT FLANGE AT FR20. REPLACED FLOORBOARD NR 232FF IAW A319 SRM 51-42-11.SDR USAA2011051691862Floor Panel · corrodedCWF - S4 - CORROSION ON FLOORBOARD NR 222FF FORWARD LANDING OUTBOARD SECTION AT FR16. REPLACED FLOORBOARD NR 222FF IAW A319 AMM 53-12-12-400-001.SDR USAA2011051091829Floor Panel · brokenCWF - S4 - MISSING COMPOSIT CORE ON FLOOR PANEL 241MF BETWEEN FR42 TO FR47, S23L & BETWEEN Y1292 TO Y1732. REPLACED FLOOR PANEL 241MF IAW MCGILL IRM 9701 REV G.SDR USAA2011051091828Floor Panel · brokenCWF - S4 - MISSING COMPOSITE ON FLOOR PANEL 241LF BETWEEN FR42 TO FR47, S23L & BETWEEN Y766 TO Y1292. REPLACED FLOOR PANEL 241LF IAW MCGILL IRM 9701 REV G.SDR USAA2011051691861Splice Plate · corrodedCWF - S4 - CORROSION ON L1 DOOR FLOOR SPLICE PLATE ON LOWER SIDE. RECEIVED NEW SPLICE PLATE.SDR USAA2010112492664Battery · dischargedFLT 1153 -PHL - EEL - FORWARD FLASHLIGHT BATTERY IS OUT. MAINTENANCE REPLACED FLASHLIGHT BATTERY AND STRAP.SDR USAA2010070991390Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, Y1292 IAW AIRBUS DRAWING D5347217220290.SDR USAA2010070991389Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y140. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 IAW AIRBUS DRAWING D534721722039.SDR USAA2010070991388Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR67, -Y765. REPLACED FLOORBEAM AT FR67, -Y765 IAW AIRBUS DRAWING D5347209300000.SDR USAA2010070991387Gusset · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOOR WEB GUSSET BETWEEN FR68 TO FR70, Y1292. REPLACED FLOOR WEB GUSSET BETWEEN FR68 TO FR70, Y1292 IAW AIRBUS DRAWING D5347112420200.SDR USAA2010070991386Gusset · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOOR WEB GUSSET BETWEEN FR68 TO FR70, -Y1292. REPLACED FLOOR WEB GUSSET BETWEEN FR68 TO FR70, -Y1292 IAW AIRBUS DRAWING D5347112320300.SDR USAA2010070891379Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW AIRBUS DRAWING D5347218920400.SDR USAA2010070891378Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR66, Y1292. REPLACED FLOORBEAM AT FR66, Y1292 IAW AIRBUS DRAWING D5347209001000.SDR USAA2010070891377Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68, Y1292. REPLACED FLOOR BEAM AT FR68, Y1292 IAW AIRBUS DRAWING D5347214220000.SDR USAA2010070891376Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR67, Y765. REPLACED FLOORBEAM AT FR67, Y765 IAW AIRBUS DRAWING D5347219220000.SDR USAA2010070891375Sill · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON R-2 DOOR SILL OUTBOARD CHORD AT FR68. REPLACED R-2 DOOR SILL OUTBOARD CHORD AT FR68 IAW AIRBUS DRAWING D5348004800104.SDR USAA2010070891374Fitting · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON R-2 DOOR AFT LOWER CORNER SILL AREA AT FR68, -Y1292. REPLACED R-2 DOOR AFT LOWER CORNER SILL FITTING AT FR68, -Y1292 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D5348004220701.SDR USAA2009100992748Skin · crackedMAJOR REPAIR - AREA OF CORROSION WITH CRACK IN FUSELAGE SKIN AT FR21, S39L. REPAIRED AREA OF CORROSION & CRACK IN FUSELAGE SKIN AT FR21, S39L IAW SRM 53-11-11. REPAIR COMPLETED.SDR USAA2009030490501Pin · corrodedPIT - LRN - MAJOR REPAIR - PITTING CORROSION ON RIGHT MAIN LANDING GEAR PINTLE PIN. REPLACED RIGHT MAIN LANDING GEAR PINTLE PIN IAW US AIRWAYS JOB CARD 26T00032001.SDR SA08002Wire · shortedPHL - NUMEROUS SEAT MOUNTED EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE REPAIRED WIRE AT SEAT 20 LT, AND REPLACED EMERGENCY POWER SUPPLY UNIT, FIN 11WL. OPERATIONALLY CHECKS OK.SDR USAA050698Sill · corrodedPIT - FOUND SILL CORRODED 3 SQUARE INCHES, L2 DOOR SILL. CORROSION LEVEL 1, TASK JA-260-53500. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11 PAGE 1 AND 2. (M)SDR USAA050725Sill · corrodedPIT - FOUND FLOOR SILL PLATE CORRODED, C-66, FORWARD END OF RIGHT SILL PLATE. MACHINED REPAIR ANGLES AND FILLER PER SRM 53-41-14 REP NR 6. MACHINED REPAIR ANGLES AND FILLER PER SRM 53-41-14 REP NR 6. CORROSION LEVEL 2, TASK JA-260-53500. (M)SDR USAA050719Floor Support · corrodedFOUND FLOOR SUPPORTS CORRODED 2 INCHES BY 2 INCHES, Y1292 R BETWEEN FRAME 66 AND 69. CORROSION LEVEL 2, TASK JA-260-53500. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR USAA050697Floor Support · corrodedPIT - FOUND FLOOR SUPPORT CORRODED 2 INCHES BY 10 INCHES, Y1292 FLOOR SUPPORT FROM C-66 TO C-70. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-72-11 AND DWG D53472815. (M)SDR USAA050722Floor Support · corrodedPIT - FOUND FLOOR SUPPORT CORRODED 1 INCH DIAMETER AREA, FLOOR SUPPORT AT Y765 AND C-66. CORROSION LEVEL 2, TASK JA-260-53500. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11. (M)SDR USAA050723Clip · corrodedPIT - FOUND CLIP CORRODED 2 INCH BY 2 INCH AREA, FRAME 19, Y 66 INCH. FABRICATED NEW CLIP PER SRM 53-11-14. FABRICATED NEW CLIP PER SRM 53-11-14, ITEM 190. (M)SDR USAA050721Frame · corrodedPIT - FOUND FRAME CORRODED 2 INCH BY 1 INCH AREA, TOP OF FRAME 17 - Y31. FABRICATED REPAIR ANGLES PER SRM 53-11-15. (M)SDR USAA050720Floorbeam · corrodedPIT - FOUND FLOORBEAM ANGLE BRACKET CORRODED 2 INCHES BY 1 INCH, FRAME 17 - Y 31 INCH. CORROSION LEVEL 2, TASK JA-220-53500. FABRICATED ANGLE BRACKET PER SRM 53-11-15. (M)
Back to N717UW