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 USAA2012072600039Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR66 TO FR68, -Y1292. REPLACED LONGITUDINAL BEAM BETWEEN FR66 TO FR68, -Y1292 IAW A320 SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2012072600037Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR65 TO FR67, -Y318. REPLACED LONGITUDINAL BEAM BETWEEN FR65 TO FR67, -Y318 IAW A320 SRM 53-41-14 FIG 102 & 51-42-11.SDR USAA2012072600036Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR65 TO FR66, Y1732. REPLACED LONGITUDINAL BEAM BETWEEN FR65 TO FR66, Y1732 IAW A320 SRM 53-41-14 FIG 102 & 51-42-11.SDR USAA2012072600033Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM AT FR66, -Y465. REPLACED LONGITUDINAL BEAM AT FR66, -Y465 IAW A320 SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2012072400028Floorbeam · corroded2S CHECK - GALVANIC CORROSION ON LONGITUDINAL FLOORBEAM BETWEEN FR65 TO FR66, -Y465. REPLACED LONGITUDINAL FLOORBEAM BETWEEN FR65 TO FR66, -Y465 IAW A320 SRM 53-00-14 FIGURE 102, 51-42-11.SDR USAA2012072400026Floorbeam · corroded2S CHECK - GALVANIC CORROSION ON LONGITUDINAL FLOORBEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED LONGITUDINAL FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW A320 SRM 53-00-14 FIGURE 102, 51-42-11.SDR USAA2012072600034Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM AT FR66, -Y160. REPLACED LONGITUDINAL BEAM AT FR66, -Y160 IAW A320 SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2012072400025Floorbeam · corroded2S CHECK - GALVANIC CORROSION ON LONGITUDINAL FLOORBEAM BETWEEN FR69 TO FR70, -Y160. REPLACED LONGITUDINAL FLOORBEAM BETWEEN FR69 TO FR70, -Y160 IAW SRM 53-00-14 FIGURE 102, 51-42-11.SDR USAA2012072700009Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON R2 DOOR SILL BEAM BETWEEN FR66 TO FR68, -Y1732. REPLACED R2 DOOR SILL BEAM BETWEEN FR66 TO FR68, -Y1732 IAW A320 SRM 53-41-14 FIG 101, 51-42-11, 51-74-00 & EA 134682.SDR USAA2012072700010Sill · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON L2 DOOR SILL BEAM BETWEEN FR66 TO FR68, Y1732. REPLACED L2 DOOR SILL BEAM BETWEEN FR66 TO FR68, Y1732 IAW A320 SRM 53-41-14 FIG 101, 51-42-11 & EA 134682.SDR USAA2012072600035Beam · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LONGITUDINAL BEAM BETWEEN FR66 TO FR70, Y160. REPLACED LONGITUDINAL BEAM BETWEEN FR66 TO FR70, Y160 IAW A320 SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2012072400024Floor Panel · chipped2S CHECK - CHIPPED FASTENER HOLES ON FLOOR PANEL BETWEEN FR64 TO FR66, -Y254. REPAIRED FASTENER HOLES ON FLOOR PANEL BETWEEN FR64 TO FR66, -Y254 IAW A320 SRM 53-02-03.SDR USAA2012072600026Dummy Rail · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON DUMMY RAIL BETWEEN FR12 TO FR16, -Y81. REPLACED DUMMY RAIL BETWEEN FR12 TO FR16, -Y81 IAW A320 SRM 53-11-14 FIG 101 & 51-41-11.SDR USAA2012072400023Seat Track · corroded2S CHECK - GALVANIC CORROSION ON SEAT TRACK BETWEEN FR59 TO FR60, -Y1292. REPLACED SEAT TRACK BETWEEN FR59 TO FR60, -Y1292 IAW A320 SRM 51-74-00, SRM 53-41-15.SDR USAA2012072400022Seat Track · corroded2S CHECK - GALVANIC CORROSION ON SEAT TRACK AT FR57, -Y1292. REPLACED SEAT TRACK AT FR57, -Y1292 IAW A320 SRM 51-74-00, SRM 53-41-15.SDR USAA2012072300029Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR55 TO FR56, -Y1292. REPLACED SEAT TRACK BETWEEN FR55 TO FR56, -Y1292 IAW A320 SRM 51-74-00 & 53-41-15.SDR USAA2012073100009Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR60 TO FR61, -Y1292. REPLACED SEAT TRACK BETWEEN FR60 TO FR61, -Y1292 IAW A320 SRM-51-74-00 & 53-41-15.SDR USAA2012072700012Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR66 TO FR70, Y765. REPLACED SEAT TRACK BETWEEN FR66 TO FR70, Y765 IAW A320 SRM 51-74-00, 53-00-14 & 51-42-11.SDR USAA2012072600046Seat 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-00-14 & 51-42-11.SDR USAA2012072400021Seat Track · corroded2S CHECK - GALVANIC CORROSION ON SEAT TRACK AT FR58, -Y1292. REPLACED SEAT TRACK AT FR58, -Y1292 IAW A320 SRM 51-74-00, SRM 53-41-15, SRM 51-42-11.SDR USAA2012051000023Iru · faultyON TAKEOFF ROLL NEAR V1 SPEED, CAPTAIN'S AIRSPEED INDICATION WAS READING NEAR ZERO. F/O'S INDICATION WAS NORMAL. REJECTED TAKEOFF AND RETURNED TO GATE. MAINTENANCE FOUND DEBRIS IN CAPTAIN'S PITOT PROBE. FLUSHED PROBE AND REPLACED NR 1 AIR DATA INERTIAL REFSDR USAA2012021300001Tire · burstPILOT REPORT - LEFT INBOARD FLAP DAMAGED BEYOND ALLOWABLE LIMITS PER A320 SRM 57-52-00 DUE TO TIRE BURST REF LP 7763805 & 7763807. REPLACED LEFT INBOARD FLAP ASSEMBLY IAW A320 AMM 27-54-61-04. OPS CHECK GOOD.SDR USAA2012021300026Tire · blownDUAL LEFT MAIN TIRE FAILURE ON LANDING ROLLOUT IN PHL. CAPTAIN REPORTED THE LANDING WAS NORMAL. PASSENGERS WERE DEPLANED BEFORE TOWING AIRCRAFT TO GATE. MAINTENANCE REPLACED NR 1 AND NR 2 MAIN WHEEL ASSEMBLIES IAW AIRBUS MAINTENANCE MANUAL 32-41-000-0064. SDR USAA2012021300017Tire · blownDUAL LEFT MAIN TIRE FAILURE ON LANDING ROLLOUT IN PHL. CAPTAIN REPORTED THE LANDING WAS NORMAL. PASSENGERS WERE DEPLANED BEFORE TOWING AIRCRAFT TO GATE. MAINTENANCE REPLACED NR 1 AND 2 MAIN WHEEL ASSEMBLIES IAW AIRBUS MAINTENANCE MANUAL 32-41-000-0064. ACCSDR USAA2011030790985Lens · missingMX - LAX - EEL - FIRST CLASS LEFT SIDE MURAL MISSING EMERGENCY LIGHT LENS. MAINTENANCE REPLACED EMERGENCY LIGHT LENS.SDR USAA2010102992442Battery · dischargedFLT 1731 - PHL - EEL - AFT RIGHT FLIGHT ATTENDANT STATION FLASHLIGHT NEEDS TO BE REPLACED. MAINTENANCE REPLACED BATTERY IN FLIGHT ATTENDANT'S EMERGENCY FLASHLIGHT.SDR USAA2010081791693Lens · missingFLT 894 - ATL - EEL - EMERGENCY LIGHT LENS MISSING AT R-1 DOOR. MAINTENANCE REPLACED EMERGENCY LIGHT LENS AT R-1 DOOR.SDR USAA2010081191643Skin Panel · saturatedPIT - TRIPLE GEAR CHANGE - MAJOR REPAIR - LEFT ELEVATOR UPPER SKIN PANEL HAS SUSPECTED WATER INCLUSION 9 INCHES AFT OF FORWARD EDGE & AT 47 & 64 INCHES FROM OUTBOARD END, ALSO THREE AREAS 10 INCHES AFT OF LEADING EDGE AT 24, 38 & 63 INCHES INBOARD OF TIP. ACCSDR USAA2010081391660Skin Panel · saturatedPIT - TRIPLE GEAR CHANGE - MAJOR REPAIR - RIGHT ELEVATOR UPPER SKIN PANEL HAS SUSPECTED WATER INCLUSION IN TWO AREAS 9 INCHES AFT OF FORWARD EDGE & AT 47 & 64 INCHES FROM OUTBOARD END, ALSO THREE AREAS 10 INCHES AFT OF LEADING EDGE AT 24, 38 & 63 INCHES INBOARSDR USAA2010061591122Line · brokenFLT 1437 - ENGINE 1 REVERSER FAULT IMMEDIATELY AFTER LIFTOFF. CREW DIVERTED TO PHL FOR MAINTENANCE AND DECLARED AN EMERGENCY FOR LANDING - AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE LANDING GEAR CONTROL INTERFACE UNIT BAD PER THE POST FLIGHT REPSDR USAA2009110392999Power Supply · dischargedCLT - EEL - LEFT OVERWING EMERGENCY EXIT LIGHT PACK WON'T TEST. MAINTENANCE REMOVED AND REPLACED LEFT OVERWING EMERGENCY EXIT LIGHT POWER SUPPLY PER AIRBUS MAINTENANCE MANUAL 33-51-38.SDR USAA920082066Power Supply · failedLOG PAGE 4440750 FLT NR 1145 PHL-SAN EEL L3 EMERGENCY LIGHT POWER SUPPLY FAILED OPS CHECK. MX R&R THE L3 EMERGENCY POWER SUPPLY UNIT. OPS CHECK WAS GOOD.SDR USAA920081413Flashlight · defectiveFLT 845 BOS-ORD EE FORWARD BREAKAWAY FLASHLIGHT USED. MAINTENANCE REMOVED AND REPLACED THE FORWARD INBOARD FLASHLIGHT AND SEAL WITH SERVICEABLE UNIT. OPERATIONAL CHECK WAS GOOD. (A)SDR SA07012Ecu · failedCLT FLT 1576 EN ROUTE FLL TO CLT. THE LEFT ENGINE WENT TO IDLE THRUST IN FLIGHT. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE PERFORMED AN ELECTICAL CHECK ON THE J4 HARNESS AND WIRING. NO FAULTS WERE FOUND. MAINTENANCE REPLACED THE LEFT ENGINE SDR SA06059Lanyard · misroutedPIT - THE FORWARD RIGHT SIDE SERVICE DOOR EMERGENCY ESCAPE SLIDE YELLOW AND WHITE LANYARDS WERE FOUND INCORRECTLY ROUTED THROUGH THE SLIDER HANDLE. MAINTENANCE CORRECTLY ROUTED THE LANYARDS.SDR SA06058Lanyard · misroutedPIT - THE AFT LEFT ENTRANCE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE THE YELLOW AND WHITE LANYARDS POSITIONED INCORRECTLY THROUGH THE SLIDER HANDLE DURING INSPECTION. MAINTENANCE CORRECTLY REPOSITIONED THE LANYARDS.SDR USAA060986Beam · corrodedFOUND BEAM CORROSION LT BEAM 129B, STA 66-69, ON TOP SIDE OF BEAM AROUND SEVERAL NUT PLATE HOLES. REPLACED BEAM PER SRM 51-72-11; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1.5" DIA.SDR USAA060989Floorbeam · corrodedFOUND FLOORBEAM CORRODED, STA 16 AND 18, 9 LEFT OF CENTER. REMOVED AND REPLACED BEAM PER SRM 51-72-11; CORROSIOIN LEVEL 1; TASK JA-220-53500, DEFECT SIZE: 1" BY 1" (2 PLACES).SDR USAA060987Floorbeam · corrodedFOUND CORROSION Y-765 FLOORBEAM. REMOVED AND REPLACED BEAM PER AIRBUS DWG NR D53472815; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1" BY 1".SDR USAA060985Beam · corrodedFOUND CORROSION STA 66 BEAM 173.2, SPOT ON TOP OF BEAM. REPAIR ANGLES INSTALLED PER SRM 53-41-14; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 2" DIA.SDR USAA060988Floorbeam · corrodedFOUND CORROSION TOP SIDE OF FLOORBEAM NR 1292 BETWEEN FS 66 AND 68. REMOVED AND REPLACED BEAM PER SRM 51-72-11; CORROSION TASK JA-260-53500; LEVEL 1 DEFECT SIZE:SDR SA05045Odor · detectedDURING FLIGHT, PASSENGERS AND CABIN CREW NOTICED A BURNING ODOR NEAR SEAT ROW 11. CREW ELECTED TO DIVERT TO FLL FOR MAINTENANCE ACTION. MAINTENANCE OPERATIONALLY CHECKED THE AIRCONDITIONING SYSTEM. OPERATIONALLY CHECKED OK.
Back to N123UW