N123UW
Service difficulty reports · 292
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 = 'N123UW' 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 = 'N123UW' 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 AALA201702289001Lens · brokenEMERGENCY EXIT LIGHT LENS IS BROKEN AND FALLING OUT. REPLACED THE LENS.SDR AALA201611039002Box Beam · crackedRIGHT SIDE BOX BEAM UPPER FLANGE AFT TWO FASTENER HOLES HAVE CRACK INDINCATIONS AT FRAME 43 AND -Y1622. REPAIRED THE BOX BEAM IAW EO 5315Y066.SDR AALA201611039001Box Beam · crackedLEFT HAND SIDE BOX BEAM UPPER FLANGE AFT TWO FASTENER HOLES HAVE CRACK INDINCATIONS AT FR 43 AND +Y1622. REPAIRED THE BOX BEAM IAW EO 5315Y066.SDR AALA201608129018Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: RT TANK FUEL PUMP NR 1 INOPERATIVE. REPLACED NR 1 FUEL PUMP SWITCH 14QA IAW ESPM 20-15-11 AND ACCOMPLISHED A SATISFACTORY OPS CHECK.SDR AALA201608019009Slide · unsecureAIRCRAFT WAS GROUNDED, 1L DOOR SLIDE DROPPED OUT INTO JETWAY AND BECAME UNPACKED. REPLACED L1 DOOR SLIDE IAW TASK CARD 26L000025011.SDR AALA201605159002Battery · defectiveAIRCRAFT WAS NOT GNDED. POST SLIDE INSTALLATION TEST REVEALS DEFECTIVE EMER POWER SUPPLY UNIT BATTERY AT POSITION 13WL AFT. REPLACED BATTERY & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38-400-002-A.SDR AALA201604199005Lens · brokenAIRCRAFT WAS NOT GNDED. EXIT LIGHT COVER BROKEN AT RT OVERWING EXIT. REPLACED LENS.SDR AALA201510199003Reservoir · brokenC8 CHECK, LT OFF WING SLIDE INFLATION RESERVOIR KNURLED SLEEVE FOR PULL CABLE SAFETY WIRE HOLE BROKEN OUT. REPLACED LT OFF WING SLIDE INFLATION RESERVOIR IAW AMM 25-62-46 & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201504229010Light · inoperativeEMERGENCY FLOOR PATH LIGHT AT SEAT 20A INOPERATIVE, RELAMP NO HELP. DEFERRED USING MEL PROCEDURES. REPLACED THE LIGHT ASSEMBLY AT SEAT ROW 20ABC.SDR USAA2015021500022Hydraulic System · lowTHE CREW RECEIVED A HYD BLUE SYS LOW PRESS ECAM MSG WHILE ENROUTE. THE CREW DECLARED AN EMER AS A PRECAUTION. THE BLUE HYD SYS WAS FOUND LOW. SERVICED IAW AMM 12-12-29-611-001-A. NO LEAKS NOTED FOR ALL HYD SYS IAW AMM 29-00-00-790-001A. ACFT OK FOR SERVICSDR USAA2015010800007Control Unit · faultyEMERGENCY LANDING, CAPTAIN HAD PAXS BRACE FOR LANDING FOR A LGCIU 1 FAULT ALONG WITH RED UNLOCK ON LG, HAD ALL 3 GREEN DOWN INDICATIONS. AFTER SAFE LANDING RED UNLOCK LIGHT WENT OUT. FLIGHT LANDED WITHOUT ANY INCIDENT & WAS ABLE TO TAXI TO GATE. ACCOMPLISHEDSDR USAA2014072800006Connecting Rod · bentRIGHT OVERWING SLIDE NOT ARMED. REPLACED ACTUATING ROD TO RT FWD OVERWING EXIT TO RELEASE MECHANISM PROXIMITY DETECTOR ASSEMBLY IAW AMM 25-62-43-000-003-A.SDR USAA2014070700021Floor Panel · delaminatedC3 CHECK AFT CARGO FLOOR PANEL 151DF DELAMINATED. R & R PANEL IAW AMM 53-42-14 PB 401.SDR USAA2014062000008Slide Raft · defectivePERFORMING EO 2514Y110, FOUND CONTACT BETWEEN THE SLIDE RAFT COVER AT DOOR L1 & THE FUSELAGE. NO DAMAGE FOUND. REPLACED SLIDE IAW TASK CARD 26L00025011. SLIDE COVER NO LONGER CONTACTS FUSELAGE. SECTION 5 UPDATED WITH PART INFORMATION.SDR USAA2014050600009Floor Panel · delaminatedRON VISIT DELAMINATION ON CARGO FLOOR PANEL 151GF BETWEEN FRAME 53 TO FRAME 56 & BETWEEN STRINGER 35L TO STRINGER 35R. REPLACED CARGO FLOOR PANEL 151GF IAW AMM 53-42-14-400-001.SDR USAA2014040300005Unknown · odorODOR REPORTED BY FLIGHT ATTENDANT DURING CLIMB, CRUISE & DESCENT. FLEW ACFT PRIOR, TWO LEGS WITH NO ODOR. TROUBLESHOT CABIN AIR QUALITY, NO ODOR NOTED. NO THIRTY DAY HISTORY, ACFT OK FOR SERVICE AT THIS TIME.SDR USAA2013101400010Power Supply · inoperativeFORWARD EMERGENCY EXIT LIGHT POWER SUPPLY TESTS BAD. REPLACED POWER SUPPLY.SDR USAA2013011600003Lens · missingEMERGENCY LIGHT LENS COVER MISSING AT ROW 11. REPLACED LENS COVER AT ROW 11.SDR USAA2013010300016Spring · lack of lubeR1 DOOR VERY HARD TO DISARM. LUBED GIRT BAR RETRACT SPRINGS. DOOR ARMS NORMALLY.SDR USAA2012112800028Power Supply · faultyGOGO MOD - AFT CABIN LIGHT EMERGENCY POWER SUPPLY SHOWS UNIT FAULT MESSAGE. REPLACED AFT CABIN EMERGENCY LIGHT POWER SUPPLY UNIT IAW A320 AMM 33-51-38. PERFORMED SATISFACTORY BITE CHECK ON POWER SUPPLY UNIT IAW A320 AMM 33-51-38.SDR USAA2012112800027Power Supply · inoperativeGOGO MOD - LEFT AFT EMERGENCY LIGHT CONTROL BOX IS INOP PER BITE TEST. REPLACED AFT CABIN EMERGENCY LIGHT POWER SUPPLY UNIT IAW A320 AMM 33-51-38. PERFORMED SATISFACTORY BITE CHECK ON POWER SUPPLY UNIT IAW A320 AMM 33-51-38.SDR USAA2012081700015Cover · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON AFT CARGO COVER SHEET BETWEEN FR52A TO FR56 & BETWEEN S38R TO S41R. REPLACED AFT CARGO COVER SHEET BETWEEN FR52A TO FR56 & BETWEEN S38R TO S41R IAW EA 134690.SDR USAA2012080600010Skin · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FUSELAGE SKIN BETWEEN FR63 TO FR64 & BETWEEN S41R TO S42R. REPAIRED FUSELAGE SKIN BETWEEN FR63 TO FR64 & BETWEEN S41R TO S42R EA 134687.SDR USAA2012080600009Skin · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FUSELAGE SKIN BETWEEN FR63 TO FR64 & BETWEEN S41L TO S42L. REPAIRED FUSELAGE SKIN BETWEEN FR63 TO FR64 & BETWEEN S41L TO S42L EA 134688.SDR USAA2012080300002Lens · broken2S CHECK - WALL MOUNTED EMERGENCY EXIT LIGHT AT L1 DOOR OUTBOARD OF FLIGHT ATTENDANT SEATS HAS BROKEN LENS. REPLACED L1 DOOR EMERGENCY EXIT LIGHT LENS IAW A320 AMM 33-51-13 ME-470.SDR USAA2012080600008Profile · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON PROFILE CORNER BETWEEN FR48 TO FR52, S38R. REPLACED PROFILE CORNER BETWEEN FR48 TO FR52, S38R IAW A320 SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2012080600005Panel · cracked2S CHECK - CRACK ON NR 2 PYLON RIGHT LATERAL PANEL LOWER AFT HOLE ELONGATED & CRACKED AT PYLON STA 4594, RIB 5. REPAIRED NR 2 PYLON RIGHT LATERAL PANEL IAW A320 SRM 54-57-11 FIG 201 & 51-42-11.SDR USAA2012080100018Receptacle · broken2S CHECK - CABIN EMERGENCY ESCAPE PATH LIGHT ELECTRICAL RECEPTACLE ON LOWER PANEL ROW 12 SEAT ABC IS BROKEN. REPLACED CABIN EMERGENCY ESCAPE PATH LIGHT ELECTRICAL RECEPTACLE ON LOWER PANEL ROW 12 SEAT ABC IAW ESPM 20-44-10 AND OPS CHECK GOOD IAW A320 AMM 33-5SDR USAA2012073100010Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL NR 261PF BETWEEN FR68 TO FR69 & BETWEEN -Y765 TO Y765. REPLACED FLOOR PANEL NR 261PF IAW A320 SRM 53-02-00 FIG 209.SDR USAA2012072600028Floorbeam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y765 IAW A320 SRM 51-42-11 & 51-72-11.SDR USAA2012072700011Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR64 TO FR66, Y765. REPLACED SEAT TRACK BETWEEN FR64 TO FR66, Y765 IAW A320 SRM 51-74-00, 53-41-15, 51-42-11 & 51-72-11.SDR USAA2012072600042Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR25 TO FR26, -Y765. REPLACED SEAT TRACK BETWEEN FR25 TO FR26, -Y765 IAW A320 SRM 51-00-15 FIG 101 & 51-42-11.SDR USAA2012072600048Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK AT FR20, Y1292. REPLACED SEAT TRACK AT FR20, Y1292 IAW A320 SRM 51-42-11 & 53-11-14.SDR USAA2012072600045Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR20 TO FR24, -Y765. REPLACED SEAT TRACK BETWEEN FR20 TO FR24, -Y765 IAW A320 SRM 53-11-14, 51-74-00 & 51-42-11.SDR USAA2012072600043Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR16 TO FR18, Y765. REPLACED SEAT TRACK BETWEEN FR16 TO FR18, Y765 IAW A320 SRM 51-00-15 FIG 101 & 51-42-11.SDR USAA2012072600041Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR16 TO FR21, -Y1292. REPLACED SEAT TRACK BETWEEN FR16 TO FR21, -Y1292 IAW A320 SRM 53-00-15, 51-74-00 & 51-42-11.SDR USAA2012072600032Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR16 TO FR23, Y254. REPLACED LONGITUDINAL BEAM BETWEEN FR16 TO FR23, Y254 IAW A320 SRM 53-11-14, 51-74-00 & 51-42-11.SDR USAA2012072600031Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR16 TO FR24, -Y254. REPLACED LONGITUDINAL BEAM BETWEEN FR16 TO FR24, -Y254 IAW A320 SRM 53-11-14, 51-74-00, 51-42-11.SDR USAA2012072600030Floor Panel · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOOR PANEL 221FF BETWEEN FR16 TO FR20 & BETWEEN Y1292 TO Y1732. REPLACED FLOOR PANEL 221FF IAW A320 SRM 51-72-11.SDR USAA2012072600029Floor Panel · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON FLOOR PANEL 222FF BETWEEN FR16 TO FR20 & BETWEEN -Y1292 TO -Y1732. REPLACED FLOOR PANEL 222FF IAW A320 SRM 51-72-11.SDR USAA2012072600027Dummy Rail · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON DUMMY RAIL BETWEEN FR20 TO FR24, -Y189. REPLACED DUMMY RAIL BETWEEN FR20 TO FR24, -Y189 IAW A320 SRM 53-11-14, 51-74-00 & 51-42-11.SDR USAA2012080100006Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR68 TO FR69, Y1292. REPLACED LONGITUDINAL BEAM BETWEEN FR68 TO FR69, Y1292 IAW SRM 53-41-15 FIG 102 & 51-42-11.SDR USAA2012073100008Shear Plate · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SHEAR PLATE BETWEEN FR69 TO FR70, S23L. REPLACED SHEAR PLATE BETWEEN FR69 TO FR70, S23L IAW A320 SRM 53-00-15 FIG 101, 51-42-11, 51-75-12.SDR USAA2012073100007Shear Plate · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SHEAR PLATE BETWEEN FR69 TO FR70, S23R. REPLACED SHEAR PLATE BETWEEN FR69 TO FR70, S23R IAW A320 SRM 53-00-15 FIG 101, 51-42-11, 51-75-12.SDR USAA2012072600047Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR64 TO FR66, -Y1292. REPLACED SEAT TRACK BETWEEN FR64 TO FR66, -Y1292 IAW A320 SRM 51-42-11 & 51-42-11.SDR USAA2012072600044Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR64 TO FR66, Y1292. REPLACED SEAT TRACK BETWEEN FR64 TO FR66, Y1292 IAW A320 SRM 53-41-15 FIG 102 & 51-42-11.SDR USAA2012072600038Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LOGITUDINAL BEAM BETWEEN FR66 TO FR68, Y1292. REPLACED LONGITUDINAL BEAM BETWEEN FR66 TO FR68, Y1292 IAW A320 SRM 53-41-15 FIG 102 & 51-42-11.SDR USAA2012072400029Floorbeam · corroded2S CHECK - GALVANIC CORROSION ON LONGITUDINAL FLOORBEAM AT FR66, -Y1732. REPLACED LONGITUDINAL FLOORBEAM AT FR66, -Y1732 IAW A320 SRM 53-41-15 FIGURE 102, 51-42-11.SDR USAA2012073100006Shear Plate · cracked2S CHECK - CRACK ON SHEAR PLATE BETWEEN FR68 TO FR69, S23L. REPLACED SHEAR PLATE BETWEEN FR68 TO FR69, S23L IAW A320 SRM 51-42-11.SDR USAA2012072600040Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR49 TO FR50, -Y1292. REPLACED SEAT TRACK BETWEEN FR49 TO FR50, -Y1292 IAW A320 SRM 53-41-15 FIG 101 & 51-42-11.
Back to N123UW