N703UW
Service difficulty reports · 305
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 = 'N703UW' 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 = 'N703UW' 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 USAA2012040200020Lens · missingR1 DOOR EXIT SIDE MARKER LENS COVER MISSING. INSTALLED LENS ON R1 DOOR SIDE MARKER HOUSING PER AMM 33-51-13.SDR USAA2012040200019Connector · disconnectedSEAT 18C EMERGENCY WHITE TRACK LIGHTING NOT WORKING. FOUND CONNECTOR DISCONNECTED, CONNECTED CONNECTOR, LIGHT OPS CHECKED GOOD.SDR USAA2012011700034Hydraulic Line · brokenLOSS OF GREEN HYDRAULIC SYSTEM, RESULTED IN LOSS OF THRUST REVERSERS AND NOSE WHEEL STEERING. DECLARED EMERGENCY. REMOVED AND REPLACED BROKEN HYDRAULIC LINE UNDER PYLON. ALSO REMOVED AND REPLACED LEFT ENGINE HYDRAULIC PUMP AND FILTERS. OPS CHECKED GOOD.SDR USAA2011060100001Pin · missingCLT - EES - D-RING MISSING ON PINS FOR COCKPIT DOOR EMERGENCY ACCESS PANEL (DECOMPRESSION / EGRESS PANEL). REMOVED COCKPIT DOOR ACCESS PANEL PINS AND INSTALLED SERVICABLE PINS.SDR USAA2010111092580Lens · missingFLT 1649 - TPA - EEL - RIGHT OVERWING EMERGENCY EXIT DOOR SLIDE ARMED LIGHT LENS IS MISSING. MAINTENANCE INSTALLED NEW LENS.SDR USAA2010092792109Skin · saturatedPIT - GDFA - MAJOR REPAIR - RIGHT ELEVATOR THERMOGRAPHIC INSPECTION SHOWS SUSPECT WATER SPOT 14 INCHES FROM TRAILING EDGE & 22.5 INCHES FROM INBOARD END. REPLACED RIGHT ELEVATOR IAW A319 AMM 27-34-41-420-051 & 27-34-41-400-001.SDR USAA2009111793137Power Supply · dischargedFLT 1291 - TPA - EEL - AFT LEFT EMERGENCY POWER SUPPLY INOPERATIVE. MAINTENANCE REPLACED THE AFT LEFT EMERGENCY LIGHTS POWER SUPPLY UNIT.SDR USAA2009082692253Slide · failedFLT 996 - FORWARD LEFT DOOR SLIDE EXTERIOR EMERGENCY LIGHTS FAILED CHECK. REMOVED AND REPLACED FORWARD LEFT DOOR SLIDE. DOOR SLIDE WAS OVERHAULED AND INSPECTED - PASSED ALL FUNCTIONAL, LIGHTING AND INTEGRITY TESTS.SDR USAA2009020990312Panel · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON LT WING FUEL PLATE PANEL NR 540KB. REPLACED LT WING FUEL PLATE PANEL NR 540KB IAW A319 SRM 57-27-11 & AMM 57-27-11-04.SDR USAA2009020990311Panel · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON LT WING FUEL PLATE PANEL NR 540MB. REPLACED LT WING FUEL PLATE PANEL NR 540MB IAW A319 SRM 57-27-11 & AMM 57-27-11-04.SDR USAA2009020690296Access Panel · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON LEFT WING FUEL PLATE PANEL 540DB IN SEAL GROOVE. REPLACED LEFT WING FUEL PLATE PANEL 540DB IAW A319 AMM 57-27-11-04.SDR USAA2009020690295Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR20 TO FR24, Y765. REPLACED FLOORBEAM BETWEEN FR20 TO FR24, Y765 IAW A319 SRM 51-72-11.SDR USAA2009020690297Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, Y704. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y704 IAW A319 SRM 53-41-04.SDR USAA2009020490282Beam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON DOOR SILL SHAPE BEAM AT FR68, -Y1400. REPLACED DOOR SILL SHAPE BEAM AT FR68, -Y1400 IAW A319 SRM 51-72-11.SDR USAA2009020490279Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR64 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR69, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490278Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR67 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR67 TO FR68, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490276Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490273Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR20 TO FR24, -Y1292. REPLACED FLOORBEAM BETWEEN FR20 TO FR24, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490270Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM AT FR14, Y1292. REPLACED FLOORBEAM AT FR14, Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490277Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR67 TO FR68, Y1292. REPAIRED FLOORBEAM BETWEEN FR67 TO FR68, Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490272Angle · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON L-ANGLE BETWEEN FR20 TO FR21, -Y1732. REPLACED L-ANGLE BETWEEN FR20 TO FR21, -Y1732 IAW A319 SRM 51-72-11.SDR USAA2009020490280Shear Plate · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON AFT LEFT LATERAL SHEAR PLATE BETWEEN FR69 TO FR70, Y1292. REPAIRED AFT LEFT LATERAL SHEAR PLATE BETWEEN FR69 TO FR70, Y1292 IAW US AIRWAYS EO 5307Y284.SDR USAA2009020490275Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR69, -Y1292. REPAIRED FLOORBEAM BETWEEN FR66 TO FR69, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020390262Floorbeam · corrodedCLT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490281Shear Plate · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON RIGHT LATERAL SHEAR PLATE BETWEEN FR69 TO FR70, -Y1292. REPAIRED RIGHT LATERAL SHEAR PLATE BETWEEN FR69 TO FR70, -Y1292 IAW US AIRWAYS EO 5307Y284.SDR USAA2009020490271Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR18 TO FR21, Y254. REPAIRED FLOORBEAM BETWEEN FR18 TO FR21, Y254 IAW A319 SRM 51-72-11.SDR USAA2009020490274Sill · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON DOOR SILL BEAM BETWEEN FR66 TO FR68, -Y1300, S21R. REPLACED DOOR SILL BEAM BETWEEN FR66 TO FR68, -Y1300, S21R IAW A319 SRM 51-72-11.SDR USAA2009012290129Sill · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION AT AFT LEFT DOOR SILL BEAM ASSEMBLY AT FR66, Y1300. REPAIRED AFT LEFT DOOR SILL BEAM ASSEMBLY AT FR66, Y1300 IAW A319 SRM 53-41-14.SDR USAA920081419Warning Light · false activationFLT 1062 CREW REPORTED `FUEL RT WING TANK LOW LVL` AND FUEL RT XFER VALVE FAULT WHILE ENROUTE. CAPTAIN ADVISED, COULD NOT GET FUEL TO TRANSFER FROM THE OUTER CELL TO THE INNER CELL OF BOTH WINGS. ACFT DIVERTED AND LANDED WITHOUT INCIDENT. MX ACCOMPLISHED TASDR USAA920081300Flashlight · failedDCA- FLT1880 - LT AFT F/A`S FLASHLIGHT WAS NOT CHARGING. MX REPLACED THE F/A`S FLASHLIGHT. OPERATIONAL CHECK WAS GOOD. (S)SDR SA08001Control Servo · failedMCO FLT 1120 - EN ROUTE RSW TO DCA. AFTER TAKEOFF FROM RSW, THE AIRFRAME BEGAN TO SHUTTER FIVE TIMES. FLIGHT DIVERTED TO MCO WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE LEFT HAND ELEVATOR GREEN SYSTEM, AND RIGHT HAND ELEVATOR BLUE SYSTEM SERVOS. OPESDR USAA200708006Flap · delaminatedA 25 X 11 INCH DELAMINATION AT RIGHT O/B FLAP T/E AREA. REPAIRED IN ACCORDANCE WITH SRM 57-53-00 & EA 84951 & SRM 57-53-00.SDR SA07013Cable · misroutedPIT - MAINTENANCE REPORTED THE L1 DOOR ESCAPE SLIDE CABLE ROUTED INCORRECTLY. MAINTENANCE REROUTED THE CABLE TO PROPER POSITION FOR LEFT-HAND DOOR INSTALLATION.SDR SA06069Windshield · crackedSJU - FLT 1037 EN ROUTE PHL-SJU. AT FL370, THE RIGHT WINDSHIELD ARCED AND THEN SHATTERED. PRESSURIZATION REMAINED NORMAL. FLIGHT LANDED AT SJU WITHOUT FURTHER INCIDENT. MAINTENANCE REMOVED AND REPLACED THE RIGHT WINDSHIELD IN ASSOCIATION WITH TASK 56-11-12SDR SA06062Slide · unserviceablePHL - DURING TROUBLESHOOTING OF THE AFT LEFT ENTRY DOOR EMERGENCY ESCAPE SLIDE COVER FALLING OFF, THE SLIDE ASSEMBLY WAS FOUND TO BE COMING UNRAVELED. MAINTENANCE REPLACED THE AFT LEFT ENTRY DOOR EMERGENCY ESCAPE SLIDE. OK FOR SERVICE.SDR SA05010Windshield · crackedCLT - FLT 1140 EN-ROUTE BZE - CLT. THE CAPTAIN'S OUTER WINDSHIELD PANE CRACKED AT 11,000 FT. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE CAPTAIN'S WINDSHIELD. WINDSHIELD ANTI-ICE OPERATIONALLY CHECKS OK.SDR USAASA04083Slide · damagedBFM - THE ESCAPE SLIDE WAS REMOVED FOR TIME. MAINTENANCE FOUND THE JUNCTION SEAM BRIDGING IS COMING APART AT RUNWAY END UPPER TUBE. SLIDE WAS RETURNED TO VENDOR FOR REPAIR. THE SLIDE WAS REPAIRED AT THE VENDOR AND RETURNED TO THE SLIDE SHOP. THE SLIDE OVERSDR USAA040198Beam · corrodedBEAM, 2.5 INCH X 1.5 INCH X .031 INCH AREA, CORROSION, LEVEL 2; TASK NR JA-260-53500 FLOOR SUPPORT, FRAME 66, Y1292, Z240. REMOVED AND REPLACED BEAM IAW SRM.SDR USAA040197Plate · corrodedDOOR SEAL PLATE, 1 INCH X .8 INCH X .50 INCH DEEP, CORROSION; LEVEL 2; TASK NR JA-260-53500, BEAM C66, Y1732, Z240. REMOVED AND REPLACED SCUFF PLATE.SDR USAA040196Beam · corrodedBEAM, 2.5 INCH X 1.5 INCH X .028 INCH, CORROSION; LEVEL 2, TASK NR JA-260-53500, BL Y1292, FR 66, Z240. DEFECTIVE PART REPLACED WITH IDENT PN IAW EA 95469 AND SRM.SDR USAA040195Sill · corrodedSILL, 1 INCH X .75 INCH X .052 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, L-2 DOOR SILL PLATE FRAME 66-68, Z240. REMOVED AND REPLACED SILL IAW SRM.SDR USAA040194Frame · corrodedFRAME, 1.5 INCHES L X 2.0 INCHES W AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, Y1292, C68, Z240. REMOVED AND REPLACED FRAME IAW SRM.SDR USAA040193Beam · corrodedBEAM, 2.0 INCHES L X 1.5 INCHES W X .055 INCH DEEP, CORROSION; LEVEL 2; TASK NR JA-260-53500, BEAM, FR 68, Y1292, Z240. REPLACED BEAM.SDR USAA040192Track · corrodedTRACK, 2.5 INCHES X 1.5 INCHES X .090 INCHES DEEP AREA, CORROSION; LEVEL 2; TASK NR JA-220-53500, FR14, Y503.2, Z240. REMOVED AND REPLACED TRACK IAW SRM.SDR USAA040186Seat Track · corrodedSEAT TRACK, 2 INCHES X 1.6 INCHES X .038 INCHES DEEP AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, FR68, Y1292, Z240. REMOVED AND REPLACED SEAT TRACK IAW SRM.SDR USAA040185Beam · corrodedBEAM, 3 INCH X 1.5 INCHES X .032 INCH DEEP AREA, CORROSION; LEVEL 2; TASK JA-260-53500 BETWEEN FR 68, 69, Y1292, Z240. REMOVED AND REPLACED BEAM IAW SRM.SDR USAA040184Plate · corrodedPLATE, 2.00 INCH LONG X .05 INCH AREA, EXFOLIATED CORROSION; LEVEL 2; TACK NR JA-260-53500 R2 DOOR, AFT GIRT BAR PLATE ASSY, FR 68-Y1292. INSTALLED NEW PLATE IAW SRM.SDR USAA040183Panel · crackedPANEL, 5 INCHES LONG, CRACKED, FR64, Y1732, Z240. FABRICATED NEW PANEL IAW SRM 53-02-00, FIG 209.SDR USAASA03019Engine · malfunctionedSJU - FLT 8910 - EN ROUTE SJU-CLT, ON CLIMB-OUT OF SJU, CREW RECEIVED ECAM MESSAGE 'ENG 2 FUEL CTL FAULT' AND 'ENG 2 N2 OVER LIMIT'. THE CREW SHUT DOWN THE NR 2 ENGIEN AND RETUREND TO SJU. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. TOTAL SINGLE ENGINE TIME SDR USAASA02035Wire · brokenAN EMERGENCY LIGHT WAS INOPERATIVE AT SEAT 9D. MAINTENANCE REPAIRED A BROKEN WIRE. OPERATIONALLY CHECKED OK.
Back to N703UW