N117UW
Service difficulty reports · 343
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 = 'N117UW' 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 = 'N117UW' 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 USAA2011102600019Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK AT FR34 PLUS 7 INCHES, Y1292. REPLACED SEAT TRACK AT FR34 PLUS 7 INCHES, Y1292 IAW A320 SRM 51-72-11 AND AIRBUS DRAWING D53110920.SDR USAA2011102500001Floorbeam · corrodedDURING 2S CHECK FOUND LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR65 TO 66, Y1500. REPLACED FLOORBEAM IAW SRM 51-72-11 & DRAWING D53474250.SDR USAA2011102500009Dummy Rail · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON RAIL DUMMY BETWEEN FR12 TO FR16, Y503.2. REPLACED RAIL DUMMY BETWEEN FR12 TO FR16, Y503.2 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53110984.SDR USAA2011102500008Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, Y765. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, Y765 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53110920.SDR USAA2011102500007Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 PLUS 16 INCHES TO FR69 PLUS 5 INCHES, Y1162. REPLACED FLOORBEAM BETWEEN FR67 PLUS 16 INCHES TO FR69 PLUS 5 INCHES, Y1162 IAW A320 SRM 51-72-11, 51-42-11 & AIRBUS DRAWING D53472780.SDR USAA2011102500006Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y254 TO Y165. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y254 TO Y165 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472780.SDR USAA2011102500005Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 PLUS 16 INCHES TO FR69 PLUS 5 INCHES, -Y1162. REPLACED FLOORBEAM BETWEEN FR67 PLUS 16 INCHES TO FR69 PLUS 5 INCHES, -Y1162 IAW A320 SRM 51-72-11, 51-42-11 AND AIRBUS DRAWING D53472780.SDR USAA2011102500004Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR70, Y165. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, Y165 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472780.SDR USAA2011102500003Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66 PLUS 5 INCHES, -Y292. REPLACED FLOORBEAM BETWEEN FR64 TO FR66 PLUS 5 INCHES, -Y292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472816.SDR USAA2011102500002Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 PLUS 5 INCHES TO FR67 PLUS 16 INCHES, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 PLUS 5 INCHES TO FR67 PLUS 16 INCHES, -Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472815.SDR USAA2011102300010Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR70, Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, Y765 IAW A320 SRM 51-72-1 & AIRBUS DRAWING 53472816.SDR USAA2011102300002Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON RAIL SEAT BEAM BETWEEN FR64 TO FR66 PLUS 5 INCHES, -Y765. REPLACED RAIL SEAT BEAM BETWEEN FR64 TO FR66 PLUS 5 INCHES, -Y765 IAW A320 SRM 51-72-11 AND AIRBUS DRAWING D53472816.SDR USAA2011102300001Dummy Rail · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON RAIL DUMMY BETWEEN FR12 TO FR16, -Y81. REPLACED RAIL DUMMY BETWEEN FR12 TO FR16, -Y81 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53112828.SDR USAA2011110900010Skin · saturated2S CHECK - LIQUID INGRESS ON LEFT ELEVATOR UPPER SKIN BETWEEN HORIZONTAL STABILIZER STA466 TO STA 527, BETWEEN RIB 11 TO 12, APPROX 5 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SKIN BETWEEN HORIZONTAL STABILIZER STA 466 TO STA 527, BETWEEN RIB 11SDR USAA2011110800031Skin · saturated2S CHECK - LIQUID INGRESS ON LEFT ELEVATOR UPPER SKIN BETWEEN HORIZONTAL STABILIZER STATION 342 TO STA 404, BETWEEN RIB 9 TO RIB 10 APPROX 6 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SKIN BETWEEN HORIZONTAL STABILIZER STATION 342 TO STA 404, BETSDR USAA2011110800030Skin · saturated2S CHECK - LIQUID INGRESS ON LEFT ELEVATOR UPPER SKIN BETWEEN STABILIZER STATION 342 TO STA 404, BETWEEN RIB 9 TO RIB 10 APPROX 8 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SKIN BETWEEN STABILIZER STATION 342 TO STA 404, BETWEEN RIB 9 TO RIB 10 ASDR USAA2011110800021Skin · saturated2S CHECK - LIQUID INGRESS ON LEFT ELEVATOR UPPER SKIN AT STABILIZER STATION 589, RIB 13, 3.75 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SKIN AT STABILIZER STATION 589, RIB 13, 3.75 INCHES FROM TRAILING EDGE IAW A320 SRM 55-21-11.SDR USAA2011110800009Skin · saturated2S CHECK - LIQUID INGRESS ON RIGHT ELEVATOR UPPER SKIN BETWEEN STABILIZER STATION 227 TO STABILIZER STATION 271, BETWEEN RIB 6 TO RIB 7, 4 INCHES FROM TRAILING EDGE. REPAIRED RIGHT ELEVATOR UPPER SKIN BETWEEN STABILIZER STATION 227 TO STABILIZER STATION 271SDR USAA2011110800008Skin · saturated2S CHECK - LIQUID INGRESS ON LEFT ELEVATOR UPPER SKIN BETWEEN STABILIZER STATION 342 TO STABILIZER STATION 404, BETWEEN RIB 9 TO RIB 10, 8.75 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SKIN BETWEEN STABILIZER STATION 342 TO STABILIZER STATION 404SDR USAA2011110600012Skin Panel · saturated2S CHECK - WATER INGRESS FOUND ON RIGHT ELEVATOR TOP SKIN PANEL BETWEEN STAB STATION 527 TO STAB STATION 589, BETWEEN RIB 12 TO RIB 13, 5.5 INCHES FROM LEADING EDGE. REPAIRED RIGHT ELEVATOR TOP SKIN PANEL BETWEEN STAB STATION 527 TO STAB STATION 589, BETWEEN SDR USAA2011102100021Support Angle · cracked2S CHECK - CRACK ON SUPPORT ANGLE AT FR68 BETWEEN S13R TO S14R. REPLACED SUPPORT ANGLE AT FR68 BETWEEN S13R TO S14R IAW A320 SRM 51-72-11.SDR USAA2011042891667Socket · unsecureFLT 1525 - DEN - EEL - LAST FLOOR LEVEL EMERGENCY EXIT LIGHT, AIRCRAFT LEFT, SOCKET IS POPPED OUT / PROTRUDING - WON`T STAY IN PLACE. MAINTENANCE RE-SECURED EMERGENCY EXIT LIGHT SOCKET ASSEMBLY.SDR USAA2010080491593Lens · missingFLT 1967 - MSP - CLT - EMERGENCY LIGHTS - EMERGENCY LIGHT LENS MISSING AT ROW 10F. REPLACED LENS AT ROW 10F. OPERATIONAL CHECK WAS GOOD.SDR USAA2009020690285Proximity Sensor · faultyFLT 1161 PHX - EMERGENCY EQUIPMENT - SLIDE AT R1 DOOR DISARMED DURING DESCENT. MAINTENANCE REMOVED AND REPLACED THE R1 DOOR PROXIMITY DETECTOR (4WN2) IAW AIRBUS MAINTENANCE MANUAL 52-73-11.SDR USAA2008122392300Proximity Switch · out of adjustPIT - C11 - EEL - NR 6072591 - LEFT FORWARD EMERGENCY EXIT DOES NOT ACTIVATE OVERWING LIGHTS WHEN REMOVED. ADJUSTED PROX SWITCH 1AWV1 IAW A320 AMM 33-51-15.SDR USAA920081430Lanyard · unsecurePIT - EES - DROP IN MAINTENANCE - R2 DOOR SLIDE SAFETY LANYARD NOT SECURED. RE-RIG LANYARD. (S)SDR USAA92081431Lanyard · unsecurePIT - EES - DROP IN MAINTENANCE - L2 DOOR SLIDE SAFETY LANYARD NOT SECURED. RE-RIG LANYARD. (S)SDR USAA920080873Cover · out of positionFLT 1196 CLT - EEL - POWER SUPPLY SEAT 11C INOP. MAINTENANCE FOUND COVER POPPED OUT. REINSTALLED COVER. POWER SUPPLY SEAT 11C OPERATIONAL CHECK NORMAL.SDR SA07042Pressure Switch · inoperativeMCO FLT 1576 EN ROUTE FLL TO CLT - DURING ORIGINATION OF FLIGHT, THE NUMBER ONE GENERATOR FAILED. THE FLIGHT CONTINUED WITH THE APU GENERATOR ON-LINE, AND ALTITUDE RESTRICTIONS. WHILE STILL SOUTH OF MCO, THE APU AUTO-SHUTDOWN WITH AN -LP FUEL VALVE FAULT-.SDR SA07001Bottle · reads lowPHX - A CIDS WARNING WAS GENERATED ON THE FORWARD FLIGHT ATTENDANT'S PANEL FOR THE LEFT OVERWING SLIDE INFLATION BOTTLE. MAINTENANCE REPLACED THE LEFT OVERWING SLIDE INFLATION BOTTLE. OK FOR SERVICE.SDR SA06088Bottle · dischargedDEN - WHILE AT THE GATE, A -CIDS- CAUTION LIGHT CAME ON. MAINTENANCE PERFORMED A BITE CHECK OF THE CIDS SYSTEM AND DETERMINED THAT THE LEFT, OVERWING, EMERGENCY EXIT SLIDE BOTTLE INDICATED IN THE RED BAND. THE AIRCRAFT WAS MAINTENANCE FERRIED TO PHL AND THE SDR USAA060172Beam · corrodedFOUND CORROSION FWD END OF RT AFT DOOR SILL -Y1732. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 53-41-14; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1" BY 1/2".SDR USAA060171Floor Support · corrodedFOUND FLOOR SUPPORT CORRODED RT FLOOR SUPPORT -Y1292, FS 66-69. REMOVED AND REPLACED FLOORBEAM PER SRM 51-42-21, 51-72-11; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1 SQ INCH.SDR USAA060170Frame · corrodedFOUND CORROSION FRAME C66 - Y765 ATTACH HOLE. REMOVED AND REPLACED PER SRM 51-72-11, DEFECT SIZE: 1" BY 1" APPROX .040" DEEP.SDR USAA060169Floorbeam · corrodedFOUND CORROSION FLOOR SUPPORT BEAM Y254 NEAR FRAME 16. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11; CORROSION LEV 1; TASK JA-220-53500 DEFECT SIZE: 1/2" DIA (3 EA.)SDR USAA060168Floorbeam · corrodedFOUND FLOORBEAM Y1292 FRAME C65-C69. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 53-41-14 AND DWG D53472092; TASK JA-260-53500, DEFECT SIZE: 1" BY 1-1/2" ON EACH SEGMENT OF BEAM.SDR USAA060167Floorbeam · corrodedFOUND FLOORBEAM CORRODED C66 AT Y1732. INSTALLED ANGLES AND FILLERS PER SRM 53-41-14 FIG. 201; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1/2" X 1-1/2".SDR USAA060166Seat Track · corrodedFOUND CORROSION ON DUMMY RAIL 503.2 5 SPOTS ON TOP OF BEAM. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-11; CORROSION LEVEL 1; TASK JA-220-53500, DEFECT SIZE: 1" BY 2".SDR SA05019Power Supply · inoperativeFOUND FAULT ON LEFT AFT EMERGENCY EXIT LIGHT. MAINTENANCE REPLACED THE EPSU.SDR USA2004F00030Ecu · failedENROUTE, DURING APPROACH, RECEIVED ECAM MESSAGE, (ENG 1 FAIL), WHILE AIRCRAFT WAS AT 6,000 FEET WITH IDLE THRUST SELECTED. THE CREW TRIED, UNSUCCESSFULLY, TO RESTART THE ENGINE. AN EMERGENCY WAS DECLARED AND THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. SINGLSDR USAASA04015Wire Harness · inoperativeTPA - THE EMERGENCY LIGHT WAS INOPERATIVE AT SEAT ROW 21 LT. MAINTENANCE REPLACED THE SEAT HARNESS. OPERAITONALLY CHECKS OK. (M)SDR USAASA01061Odor · detectedDEN - FLT 133 - EN ROUTE PIT-DEN. DURING APPROACH, THE FLIGHT ATTENDANTS NOTED A BURNING SMELL IN THE FORWARD GALLEY, WITH ALL OVENS OFF. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE RESET THE POPPED CIRCUIT BREAKER FOR THE POTABLE WASTE WATER HESDR USAASA00044Sensor · faultyPIT-BWI - FLT 1626 - ON CLIMB-OUT FROM PIT, RECEIVED AN ECAM MESSAGE FOR HOT BRAKES. THE LANDING GEAR WAS LOWERED AND THE BRAKE FAN WAS ACTIVATED FOR THREE TO FIVE MINUTES UNTIL THE BRAKES WERE COOL. THE FLIGHT CONTINUED ON TO BWI AND LANDED WITHOUT INCIDENT
Back to N117UW