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 AALA201709129047Floor Support · corrodedCORROSION ON AFT GALLEY FLOOR SUPPORT AT -Y465 BETWEEN FRAMES 64 AND 67.SDR AALA201709129045Seat Track · corrodedCORROSION FOUND ON THE FORWARD GALLEY SEAT TRACK AT -Y1292, STRINGER 23R, BETWEEN FRAMES 20 AND 21. REPLACED THE SEAT TRACK IAW SRM 51-72-11, SRM 51-42-11, DRAWINGS D53112812 AND D53110984.SDR AALA201709129044Floor Panel · delaminatedDELAMINATION ON COCKPIT FLOOR PANEL 212EF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201709129043Floor Panel · delaminatedDELAMINTANION ON COCKPIT FLOOR PANEL 211EF TOP LAYER. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201709129042Seat Track · corrodedCORROSION ON FORWARD GALLEY SEAT TRACK AT -Y1292 AND STRINGER 23R, BETWEEN FRAMES 20 AND 21. REPLACED THE SEAT TRACK IAW SRM 51-72-11, SRM 51-42-11, DRAWINGS D53112812 AND D53110984.SDR AALA201709129041Seat Track · corrodedCORROSION FOUND ON THE FORWARD GALLEY SEAT TRACK AT Y1292 BETWEEN FRAMES 20 AND 21. REPLACED THE SEAT TRACK IAW SRM 51-72-11, DRAWINGS D53112812 AND D53110984.SDR AALA201709089008Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON FORWARD GALLEY FLOOR PANEL 221LF, TOP LAYER. REPLACED FLOOR PANEL PER SRM 53-12-00 AND IRM 9701 REVISION G.SDR AALA201709089006Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON PASSENGER CABIN FLOOR PANEL 241EF, TOP LAYER. REPLACED FLOOR PANEL PER SRM 53-02-00 AND IRM 9701 REVISION G.SDR AALA201709079013Floor Support · corrodedCORROSION ON AFT GALLEY FLOOR SUPPORT, BETWEEN FRAMES 65 AND 67. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DRAWING 53472814.SDR AALA201709229020Skin · contaminatedTRAPPED WATER INDICATION ON THE LT ELEVATOR UPPER SKIN HONECOMB CORE CELLS BETWEEN RIBS 1 AND 10, BETWEEN 8.3 INCHES AND 27 INCHES FROM TRAILING EDGE. REPLACED THE ELEVATOR.SDR AALA201709259001Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON PASSENGER CABIN FORWARD GALLEY FLOOR PANEL 221PF, TOP LAYER. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011 AND IRM 9701 REVISION G.SDR AALA201709209014Floor Panel · delaminatedDELAMINATION ON PASSENGER CABIN FORWARD GALLEY FLOOR PANEL 222FF, TOP LAYER. REPLACED THE FLOOR PANEL IAW AMM 53-12-12-400-001-A..SDR AALA201709189009Floor Panel · delaminatedDELAMINATION ON COCKPIT FLOOR PANEL 211FF, TOP LAYER. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006, AND IRM 9701 REVISION G.SDR AALA201709189007Floor Panel · delaminatedDELAMINATION FOUND ON THE PASSENGER CABIN FORWARD GALLEY FLOOR PANEL 231AF. REPLACED THE FLOOR PANEL IAW AMM 53-12-12-000-001-A, AND SRM 53-12-00.SDR AALA201709189003Floor Panel · delaminatedDELAMINATION FOUN ON THE CABIN FLOOR PANEL 222CF, TOP LAYER. REPLACED THE FLOOR PANEL IAW AMM 53-12-12-400-001-A.SDR AALA201709089007Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON PASSENGER CABIN FLOOR PANEL 231FF, TOP LAYER. REPLACED FLOOR PANEL PER SRM 53-12-00 AND IRM 9701 REVISION G.SDR AALA201709089005Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON PASSENGER CABIN FLOOR PANEL 261AG, TOP LAYER. REPLACED FLOOR PANEL PER SRM 53-02-00 AND IRM 9701 REVISION G.SDR AALA201709079012Floor Panel · delaminatedDELAMINATION ON PASSENGER CABIN FLOOR PANEL 262BG. REPLACED THE FLOOR PANEL IAW SRM 53-02-00.SDR AALA201705229008Fan · malfunctionedAIRCRAFT WAS GROUNDED. ACRID ELECTRICAL ODOR AND LOUD NOISE AND VIBRATION UNDER GALLEY FLOOR. REMOVED AND REPLACED EXTRACT FAN 18HQ IAW AMM 21-26-51.SDR AALA201705159029Selector Valve · unserviceableAIRCRAFT NOT GROUNDED. PARKING BRAKE WON'T SET WITH BATTERY PWR. WILL ONLY SET WITH GROUND PWR ON.SDR AALA201705119022Warning Light · false activationECAM CAUTION BELOW 80 KTS, ABORTED TAKE-OFF. CONDUCTED BITE CHECK, NO FAULTS NOTED. PERFORMED SATISFACTORY AUTOLAND CHECK IAW AMM 22-97-00.SDR AALA201703209027Line · failedAFTER LANDING, OILY ODOR OCCURRED AFTER APU TURNED ON. HINT OF ODOR IN-FLIGHT, GOT A-LOT WORSE AFTER APU START. MAINTENANCE ACCOMPLISHED JOB CARD 26L00021001 AND 26L00021002. FOUND OIL IN APU TAIL PIPE; APU SOURCE OF ODOR. . MAINTENANCE FOUND DETERIORATED ANDSDR AALA201701269013Ballast · failedELECTRICAL BURNING ODOR IN THE AFT CABIN. MAINTENANCE FOUND FAULTY BALLAST AT ROW 21DEF AND REPLACED. ACCOMPLISHED CABIN AIR QUALITY CHECK IAW 26L00021001. AIRCRAFT WAS GROUNDED.SDR AALA201612089005Seal · too largeAFTER LANDING, RECEIVED ECAM EMERGENCY EXIT DOOR. LEFT FORWARD EXIT SHOWS ARMED. MAINTENANCE TRIMMED EXCESS SEAL FROM FORWARD LEFT OVERWING EXIT DOOR. ACCOMPLISHED SATISFACTORY CHECK PER AMM 52-21-11.SDR AALA201612059005Box Beam · crackedBOX BEAM CRACKED IN UPPER FLANGE, FRAME 43 AND -Y1622. REPAIRED THE BOX BEAM IAW EO 5315Y066. AIRCRAFT WAS GROUNDED.SDR AALA201612059004Box Beam · crackedCRACK ON LEFT SIDE BOX BEAM UPPER FLANGE, FIRST AND FOURTH HOLES AT FRAME 43 AND Y1622. REPAIRED THE BOX BEAM IAW EO 5315Y066. AIRCRAFT WAS GROUNDED.SDR AALA201608159006Lens · brokenR2 DOOR EXIT LIGHT LENS COVER BROKEN. REPLACED THE LENS COVER IAW AMM 33-51-16.SDR AALA201607209004Battery · failedACFT WAS NOT GROUNDED: LEFT EMERGENCY POWER SUPPLY UNIT BATTERY FAILS SELF TEST. REPLACED LEFT EMERGENCY POWER SUPPLY UNIT BATTERY IAW AMM 35-51-38-400-001-A.SDR AALA201603219005Bypass Valve · leakingRETURNED, ACFT WAS GNDED, DURING CLIMB THE FLIGHT CREW GOT AN ECAM MSG, HYD G RSVR LOW LVL, & TURNED OFF ENG 1 HYD PUMP PB IAW ECAM PROCEDURE. THE CREW DECLARED AN EMER & RETURNED WHERE THE ACFT LANDED SAFELY & WAS TOWED BACK TO THE GATE, DUE TO NO NOSE WHEESDR AALA201512289004Lens · missingAIRCRAFT WAS NOT GNDED. EMER LIGHT LENS MISSING AT 4C. INSTALLED LENS AT 4C.SDR AALA201511189002Lens · missingDOOR 1R EMER EXIT LIGHT COVER & LIGHT MISSING. INSTALLED EMER LIGHT COVER IAW AMM 33-51-13.SDR USAA2015033100013Rib · corrodedCORROSION AROUND FASTENERS ON RT WING MLG RIB 5 LOWER FLANGE. REMOVED CORROSION & REPAIRED IAW EA 209622.SDR USAA2015033100012Rib · corrodedCORROSION AROUND FASTENERS ON LT WING MLG RIB 5 LOWER FLANGE. REMOVED CORROSION & REPAIRED IAW EA 209635.SDR USAA2015012200001Light · failedC11 CHECK SLIDE FAILED EMER LIGHT CHECK ON CIDS. FOUND INTEGRAL LIGHTING OF SLIDE FAILED. REPLACED FWD LT RAFT SLIDE IAW JC 26L00025011.SDR USAA2014111100002Slide · defectiveR1 DOOR DIFFICULT TO ENGAGE & DISENGAGE GUST LOCK DUE TO INTERFERENCE OF SLIDE COVER TO FUSELAGE. ACCOMPLISHED TR 320-5210-14-0838. REPLACED SLIDE RAFT AT DOOR R1 IAW JC 26L0002501.SDR USAA2014091600003Sensor · inoperativeREJECTED TAKE OFF AFTER NR 2 ENG FAILED TO SPOOL UP. REPLACED ENG NR 2 FWC T12 SENSOR.SDR USAA2014061200024Slide Raft · bulgedPERFORMING EO 2514Y110 FOUND CONTACT BETWEEN THE SLIDE RAFT COVER AT DOOR L1 & THE FUSELAGE, NO DAMAGE FOUND. PLACED ON MONITOR, REINSPECT EVERY 100 HRS. REPLACED SLIDE AT NEXT HEAVY CHECK. REPLACED SLIDE RAFT AT L1 DOOR IAW JC 26L00025011.SDR USAA2014060900013Battery · discharged2 AFT BREAK AWAY EMER FLASHLIGHTS BATTERY INDICATOR NOT FLASHING. REPLACED 2 AFT EMER FLASHLIGHT BATTERIES.SDR USAA2014040700016Chiller · faultyFLIGHT ATTENDANT REPORTED AN ELEC OR PLASTIC SMELL NEAR ROWS 2 & 3 WHILE INFLIGHT. SMELL SEEMED TO DISSIPATE AFTER LANDING. ACCOMPLISHED JOB CARD 26L0002100 & FOUND FWD CHILLER WITH ELEC ODOR. REPLACED FWD GALLEY CHILLER IAW AMM 25-34-51-000-001-A & 25-34-5SDR USAA2014032500007Cover · missingDOOR L2 EMERGENCY LIGHT COVER PLATE MISSING. REPLACE DOOR L2 EMERGENCY LIGHT COVER PLATE IAW AMM 33-50-00.SDR USAA2014032500004Cover · missingDOOR R1 EMERGENCY LIGHT COVER PLATE MISSING. REPLACED DOOR R1 EMERGENCY LIGHT COVER PLATE IAW AMM 33-50-00.SDR USAA2014020600002Wire Harness · burnedDIVERTED TO CLT FOR AUTO BRAKE FAULT, CONSULTED WITH CREW IT HAPPENED ON GEAR RETRACTION. FOUND HOLE BURNT IN FLEX CONDUIT, BURNT BRAKE FAN WIRES IN RT MLG HARNESS 2M, BURNT & SEVERED WHEEL 4 TACH WIRING. REPLACED TACH 4 WIRING FROM D4030VC-LGAB4 A IAW WDM 3SDR USAA2014011300012Lens · missingFLOOR EMERGENCY LIGHT LENS MISSING AT SEAT 3C. REPLACED FLOOR EMERGENCY LIGHT LENS AT SEAT 3C.SDR USAA2013122400009Hydraulic Line · leakingEN ROUTE FROM CLT TO PHL, CREW REPORTED LOSS OF GREEN HYD FLUID IN FLIGHT. CREW DECLARED AN EMERGENCY & LOWERED THE GEAR MANUALLY. LANDING WAS UNEVENTFUL & THE ACFT WAS TOWED TO THE GATE. REPLACED GREEN SYS HCU LINE IAW A320 AMM 29-11-49-400, LEAK CHECKED GSDR USAA2013072300008Fire Bottle · emptyAFT LT LAVATORY TRASH BIN FIRE EXTINGUISHER GAUGE READS EMPTY. R & R EXTINGUISHER IAW AMM 26-25-41.SDR USAA2013022500003Lens · brokenSEAT 3C EMERGENCY FLOOR LIGHT LENS COVER BROKEN. REPLACED SEAT 3C EMERGENCY LIGHT LENS COVER.SDR USAA2013010700001Sign · wrong partAFT CABIN AND 2R DOOR EXIT SIGNS INCORRECT (ARROW SIGN SHOULD BE IN OVERHEAD AISLE). REPLACED DOOR 2R EMERGENCY EXIT SIGN.SDR USAA2012122400020Fastener · looseL-2 DOOR SLIDE WILL NOT ARM. FOUND LOOSE HARDWARE ON L-2 DOOR SILL THRESHHOLD. INSTALLED SCREWS IN SILL PLATE. DOOR CLOSED AND SLIDE ARMS PROPERLY.SDR USAA2012121700022Flashlight · missingFORWARD INBOARD EMERGENCY FLASHLIGHT ASSEMBLY / HOLDER REMOVED. REPLACED FORWARD INBOARD EMERGENCY FLASHLIGHT ASSEMBLY.SDR USAA2012112300007Wire · misinstalledEMERGENCY EXIT LIGHTS COME ON WITH THE SWITCH SELECTED TO THE OFF POSITION. FOUND WIRE 1A NOT PROPERLY INSTALLED - RESET WIRE - EMERGENCY LIGHTS OPERATE NORMALLY IN ALL POSITIONS.
Back to N117UW