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 AALA201705099011Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON FORWARD GALLEY FLOOR PANEL 222CF. REPLACED FLOOR PANEL PER AMM 53-12-12.SDR AALA201705049012Splice · damagedELONGATED HOLE ON FORWARD GALLEY OUTBOARD SPLICE AT Y765 AND FRAME 24. REPLACED THE SPLICE IAW SRM 51-72-11.SDR AALA201705039033Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT GALLEY FLOOR PANEL 261DF. REPLACED FLOOR PANEL 261DF PER AMM 53-42-12-400-002-A.SDR AALA201705029018Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON PASSENGER CABIN FLOOR PANEL 232AH. REPLACED FLOOR PANEL PER SRM 53-02-00 AND IRM 9701 REVISION G.SDR AALA201705029017Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT CARGO COMPARTMENT FLOOR PANEL 151CE. REPLACED FLOOR PANEL 151CE PER SRM 53-02-00 AND IRM 9701 REVISION G.SDR AALA201705029016Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT GALLEY FLOOR PANEL 261BG. REPLACED FLOOR PANEL PER SRM 53-02-00 AND IRM 9701 REVISION G.SDR AALA201705029015Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT GALLEY FLOOR PANEL 261PF. REPLACED FLOOR PANEL 261PF PER SRM 53-02-00 AND IRM 9701 REVISION G.SDR AALA201705029012Floor Panel · delaminatedDELAMINATION ON AFT GALLEY FLOOR PANEL 262BG. REPLACED THE FLOOR PANEL IAW AMM 53-42-12-400-002-A.SDR AALA201705029010Floor Panel · delaminatedDELAMINATION ON AFT CARGO BAY FLOOR PANEL 151ZG. REPLACED THE FLOOR PANEL IAW SRM 53-02-00.SDR AALA201705029009Floor Panel · delaminatedDELAMINATION ON AFT GALLEY FLOOR PANEL 261AG. REPLACED THE FLOOR PANEL IAW SRM 53-02-00.SDR AALA201705029008Floor Panel · delaminatedDELAMINATION ON FORWARD GALLEY FLOOR PANEL 221PF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00 .SDR AALA201705019056Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON FORWARD GALLEY FLOOR PANEL 221DF. REPLACED FLOOR PANEL 221DF PER SRM 53-12-00 AND IRM 9701 REVISION G.SDR AALA201703089006Lens · missingAFT L, DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201610189005Megaphone · inoperativeF/A MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE IAW GPM NO TECH REF SEE TEXT FOR MAINT OR REPAIR DONE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201602299012Box Beam · crackedAIRCRAFT IN BASE MX. RT SIDE BOX BEAM FLANGE, AFT 2 HOLES HAVE CRACK INDICATION, AT FRAME 43 & -Y1622. REPAIRED IAW EO 5315Y066.SDR AALA201602299011Box Beam · crackedAIRCRAFT IN BASE MX. LT SIDE BOX BEAM FLANGE, AFT 2 HOLES HAVE CRACK INDICATION, AT FRAME 43 & Y1622. REPAIRED IAW EO 5315Y066.SDR AALA201512159010Control Servo · faultyDIVERTED & ACFT WAS GNDED. ACFT EXPERIENCED AN UNCOMMANDED FLIGHT MOVEMENT, ACFT NOSE PUSHED OVER 500 FPM FOLLOWED BY AN ECAM FLIGHT CONTROL LT ELEVATOR FAULT AT FL 390. PERFORMED TSM 27-93-00-810-864-A & FOUND THE LT ELEVATOR SERVO CONTROL VLV, 34CE1, FAULTSDR AALA201505209004Battery · weakFLASHLIGHT AT DOOR 2L HAS WEAK BATTERY. REPLACED THE BATTERY IN FLASHLIGHT AT DOOR 2L.SDR USAA2014120800004Battery · dischargedFLASHLIGHT UNDER AFT RT JUMP SEAT 22 SECONDS BETWEEN FLASHES, SLOW TO CHARGE. REPLACED BATTERY AFT EMER FLASHLIGHT RT SIDE. OPERATIONS CHECKED NORMAL.SDR USAA2014070700009Slide · unserviceableTHE L1 SLIDE COVER CONTACTING FUSELAGE. R & R L1 ESCAPE SLIDE IAW EO 2514Y110 IAW JOB CARD 26L00025011.SDR USAA2014070300009Skin · contaminatedDURING C11 CHECK, RT ELEVATOR TOP SKIN HAS NUMEROUS AREAS OF TRAPPED WATER BETWEEN 0.5 INCHES & 2.0 INCHES IN DIAMETER & LOCATED BETWEEN 166.5 INCHES & 34 INCHES FROM THE INBD END & BETWEEN 20.5 INCHES & 9 INCHES FROM THE TE. REMOVED WATER, REPAIRED & SEALEDSDR USAA2014051900037Slide Raft · unserviceableUNABLE TO INSTALL L1 SLIDE SAFETY PIN FOR SCHEDULED SLIDE REPLACEMENT. R & R L1 SLIDE IAW JOB CARD 26L00025011.SDR USAA2014012100015Cover · unsecureRIGHT EMERGENCY EXIT INDICATION AFTER LANDING. SECURED RT EXIT HANDLE COVER AT RT OVERWING ACCESS. COVER CHECKED OK, EMERGENCY EXIT INDICATION OK ON ECAM.SDR USAA2014011300001Unknown · odorUNKNOWN FUMES & ODOR IN FLIGHT DECK AS WELL AS CTR OF ACFT WHILE AT THE GATE. REMOVED PAXS & CREW FROM ACFT . COMPLIED WITH JOB CARD 26L00021001. TROUBLESHOOT CABIN AIR QUALITY, NO FINDINGS FOUND. NO FURTHER ACTION REQUIRED.SDR USAA2013110100005Floor Panel · wornEXCESSIVE WEAR ON FLOOR PANEL 151ZG BETWEEN FRAMES 52 TO 56, S19L. REPLACED FLOOR PANEL IAW AMM 53-42-14-400-001-A.SDR USAA2013100200005Lens · missingEMERGENCY LIGHT COVER LENS AT 10ABC MISSING. INSTALLED RED LENS COVER AT SEAT 10ABC.SDR USAA2013081400002Cover · missingCREW REPORTED CABIN ROW 10C RED FLOOR/LOW LEVEL LIGHTING FOR EMERGENCY EXIT COVER MISSING. MX REPLACED MISSING COVER IAW MPPM 54-01-10.SDR USAA2013032200030Epsu · faultyMAINTENANCE REPORTS THE EPSU (11WL) FAULTED. MAINTENANCE REMOVED AND REPLACED EPSU (11WL) PER AMM 33-51-38. OPS CHECK GOOD.SDR USAA2013022800013Nut · looseMAINTENANCE REPORTED THE L1 PASSENGER DOOR INTERIOR ARMING HANDLE LOOSE. MAINTENANCE RE-TIGHTENED NUT PER AMM 51-49-00.SDR USAA2012120300026Light · inoperativeR-1 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED R1 DOOR EMERGENCY LIGHT ASSEMBLY. OPS CHECKED GOOD.SDR USAA2012042300021Lens · missingEMERGENCY LIGHT LENS COVER AT ROW 9 RIGHT SIDE IS MISSING. INSTALLED LENS COVER ON SEAT 9 PER AMM 33-51-19.SDR USAA2012031600011Unknown · odorAPU PUTTING OIL SMELL INTO CABIN (STRONG FISHY SMELL). ACCOMPLISHED JOBCARD 26L00021001, 26L00021002 AND 26L31049009 AND FOUND APU TO BE BAD. REMOVED AND REPLACED APU FOR OIL ISSUES. OPS CHECKED GOOD AND NO ODORS NOTED. SUP WILL SUBMIT APU TEARDOWN REPORT SDR USAA2011111700013Battery · dischargedFORWARD SAFETY FLASHLIIGHT INBOARD SEAT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY. OPS CHECKED GOOD.SDR USAA2011082300005Connector · disconnectedEMERGENCY LIGHTS ROWS 4 & 7 CEILING AND SEAT 10D INOPERATIVE. REINSTATED ALL CONNECTORS. ALL EMERGENCY LIGHTS OPS CHECKED NORMAL.SDR USAA2011061600001Lens · missingCLT-ATL - EEL - EMERGENCY EXIT LENS MISSING AT R1 DOOR. REPLACED EXIT LENS AT R1 DOOR.SDR USAA2011053100052Seat Track · corrodedCWF - S4 CHECK - CORROSION ON SEAT TRACK BETWEEN FR16 TO FR20, STR 23R, WL 0, BL -Y245. REPLACED SEAT TRACK BETWEEN FR16 TO FR20, STR 23R, WL 0, BL -Y245 IAW A319 SRM 51-22-11, PARA 6.SDR USAA2011051391849Connector · not seatedCWF - S4 - L-1 DOOR EMERGENCY EXIT LIGHT IS INOP. RESEATED CIRCULAR CONNECTOR 2758VCA IAW AIRBUS ESPM 20-44-10 & A 319 AMM 33-51-17-400-050.SDR USAA2011051391848Seat Track · corrodedCWF - S4 - LEVEL 2 INTERGRANULAR CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, Y1292. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, Y1292 IAW A319 SRM 53-00-15.SDR USAA2011051691859Plate · corrodedCWF - S4 - CORROSION ON R1 DOOR GIRT BAR ATTACHMENT FITTING MOUNT PLATE. REPLACED R1 DOOR GIRT BAR ATTACHMENT FITTING MOUNT PLATE IAW A319 SRM 51-72-11.SDR USAA2011051291835Sill · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON R2 DOOR SILL AT FR66, S23R, -Y732. REPLACED R2 DOOR SILL AT FR66, S23R, -Y732 IAW A319 SRM 51-72-11.SDR USAA2011051091826Seat Track · corrodedCWF - S4 - CORROSION ON SEAT TRACK BETWEEN FR24 TO FR34 + 15 INCHES, S23R, -Y1292. REPLACED SEAT TRACK BETWEEN FR24 TO FR34 + 15 INCHES, S23R, -Y1292 IAW A319 SRM 51-42-11.SDR USAA2011051091825Profile · corrodedCWF - S4 - SURFACE CORROSION ON CORNER PROFILE ASSEMBLY BETWEEN FR52 TO FR55A, S38R, -Y623. REPLACED CORNER PROFILE ASSEMBLY BETWEEN FR52 TO FR55A, S38R, -Y623 IAW A319 SRM 51-72-11.SDR USAA2011050991817Floor Panel · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION FLOOR PANEL 221FF BETWEEN FR20 TO FR24 & BETWEEN Y765 TO Y1292. REPLACED FLOOR PANEL 221FF BETWEEN FR20 TO FR24 & BETWEEN Y765 TO Y1292 IAW A319 SRM 51-72-11.SDR USAA2011050991814Floor Panel · crackedCWF - S4 - CRACKED CORNER & PULLED INSERT ON CABIN FLOOR PANEL 262BF LOCATED BETWEEN FR64 TO FR69 & BETWEEN Y765 TO Y1723. REPLACED CABIN FLOOR PANEL 262BF LOCATED BETWEEN FR64 TO FR69 & BETWEEN Y765 TO Y1723 IAW MCGILL IRM 9701 REV G.SDR USAA2011050991812Floor Panel · damagedCWF - S4 - COMPOSIT MATERIAL MISSING ON CABIN FLOOR PANEL 151ZG LOCATED BETWEEN FR56 TO FR58 & BETWEEN -Y254 TO Y254. REPLACED CABIN FLOOR PANEL 151ZG LOCATED BETWEEN FR56 TO FR58 & BETWEEN -Y254 TO Y254 IAW MCGILL IRM 9701 REV G.SDR USAA2011050991803Floorbeam · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR12 TO FR16, S23R, -Y81. REPLACED FLOORBEAM BETWEEN FR12 TO FR16, S23R, -Y81 IAW A319 SRM 51-42-11.SDR USAA2011050991802Floor Support · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT AT FR65 + 20 INCHES, S23R, -Y1292. REPLACED FLOOR SUPPORT AT FR65 + 20 INCHES, S23R, -Y1292 IAW A319 SRM 51-42-11 & AIRBUS DRAWING D53472190.SDR USAA2011050991800Seat Track · corrodedCWF - S4 - LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK AT FR21 + 12 INCHES, S23R, -Y765. REPLACED SEAT TRACK AT FR21 + 12, S23R, -Y765 IAW A319 SRM 51-42-11.SDR USAA2011050991799Seat Track · corrodedCWF - S4 - LEVEL 2 INTERGRANULAR CORROSION ON TRACK ASSEMBLY AT FR16, S23L, Y508. REPLACED TRACK ASSEMBLY AT FR16, S23L, Y508 IAW A319 SRM 53-11-14.SDR USAA2011051091827Access Door · corrodedCWF - S4 - CORROSION ON LOWER LEFT WING FUEL ACCESS DOOR NR 540EB BETWEEN RIB 10 TO RIB 11. REPLACED LOWER LEFT WING FUEL ACCESS DOOR NR 540EB BETWEEN RIB 10 TO RIB 11 IAW A319 AMM 57-27-11-400-001.
Back to N717UW