N701UW
Service difficulty reports · 286
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 = 'N701UW' 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 = 'N701UW' 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 USAA920081816Support Bracket · corrodedPIT - S4 - MAJOR REPAIR, LEVEL 2 EXFOLIATION CORROSION ON SUPPORT BRACKET AT LOWER AFT CORNER OF R1 DOOR CUTOUT. REPLACED SUPPORT BRACKET AT LOWER AFT CORNER OF R1 DOOR CUTOUT IAW A319 SRM 51-72-11 .SDR USAA920081792Seat Track · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON SEAT TRACK FR 20, -Y1292. REPLACED SEAT TRACK, FR 20, -Y1292 IAW A319 SRM 51-42-11.SDR USAA920081786Floorbeam · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM FR 68 - FR 69, -Y1292. REPLACED FLOORBEAM, FR 68 - FR 69, -Y1292 IAW A319 SRM 51-72-11.SDR USAA920081787Floorbeam · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM FR 66 - FR 68, -Y1292. REPLACED FLOORBEAM, FR 66 - FR 68, -Y1292 IAW A319 SRM 51-72-11.SDR USAA920081788Floorbeam · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM FR 64, -Y1292. REPLACED FLOORBEAM, FR 64, -Y1292 IAW A319 SRM 51-72-11.SDR USAA920081789Floorbeam · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM FR 66, -Y465. REPLACED FLOORBEAM, FR 66, -Y465 IAW A319 SRM 51-72-11.SDR USAA920081790Floorbeam · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM FR 65 - FR 66, -Y765. REPLACED FLOORBEAM, FR 65 - FR 66, -Y765 IAW A319 SRM 51-72-11.SDR USAA920081791Seat Track · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON SEAT TRACK FR 20, -Y765. REPLACED SEAT TRACK, FR 20, -Y765 IAW A319 SRM 51-42-11.SDR USAA920081795Shear Tie · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON RT SHEAR TIE PLATE, FR 69- FR 70, S23R. REPLACED RT SHEAR TIE PLATE, FR 69- FR 70, S23R IAW US AIRWAYS EO 5307Y284.SDR USAA920081712Floorbeam · corrodedPIT - S4 -MAJOR REPAIR, LEVEL 2 EXFOLIATION CORROSION ON UPPER SURFACE OF FLOORBEAM AT FR 69 TO FR 70, S23L. REPLACED FLOORBEAM AT FR 69 TO FR 70, S23L IAW A319 SRM 51-42-11.SDR USAA920081793Angle · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON ANGLE, FR 12+4, IN FRONT OF RT SEAT TRACKS. REPLACED ANGLE, FR 12+4, IAW SRM 51-72-11.SDR USAA920081794Shear Tie · corrodedPIT - MAJOR REPAIR - S4 CHECK, LEVEL 2 CORROSION ON RT SHEAR TIE PLATE, FR 69- FR 70, S23L. REPLACED RT SHEAR TIE PLATE, FR 69- FR 70, S23L IAW US AIRWAYS EO 5307Y284.SDR USAA920081718Floorbeam · corrodedPIT - S4 -MAJOR REPAIR, LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT -Y765, AFT OF FR 64. REPLACED FLOORBEAM AT -Y765, AFT OF FR 64 IAW A319 SRM 51-72-11.SDR USAA920081717Floorbeam · corrodedPIT - S4 -MAJOR REPAIR, LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT -Y765, BETWEEN FR 66 TO FR 68. REPLACED FLOORBEAM AT -Y765, BETWEEN FR 66 TO FR 68 IAW A319 SRM 51-72-11.SDR USAA920081715Floorbeam · corrodedPIT - S4 -MAJOR REPAIR, CORROSION ON FLOORBEAM BETWEEN FR 64 & FR 66, Y765. REPLACED FLOORBEAM BETWEEN FR 64 & FR 66, Y765 IAW A319 SRM 51-72-11.SDR USAA920081713Support Angle · corrodedPIT - S4 - MAJOR REPAIR, LEVEL 2 GALVANIC CORROSION ON SUPPORT ANGLE AT L2 DOOR SILL AFT DOOR FRAME. REPLACED SUPPORT ANGLE AT L2 DOOR SILL AFT DOOR FRAME IAW SRM 53-41-14 REPAIR NR 5.SDR SA05124Light · inoperativeTPA - THE RED EMERGENCY SEAT LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE RIGHT SIDE, MID CABIN EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR SA05095Light · inoperativeBDL - THE AFT RIGHT EXIT ROW EMERGENCY LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPAIRED THE BROKEN WIRING. OPERATIONALLY CHECKS OK.SDR SA05002Windshield · crackedDURING CRUISE AT FL 370, THE FIRST OFFICER'S WINDSHIELD BEGAN TO ARC AND DELAMINATE DIAGONALLY THE ENTIRE LENGTH OF WINDSHIELD. FOLLOWED THE QRH PROCEDURES AND PULLED CIRCUIT BREAKERS AF10 AND X14. FLIGHT CONTINUED AND LANDED WITHOUT FURTHER INCIDENT. MAINTSDR SA04090Battery Pack · dischargedCLT - THE EMERGENCY LIGHTS TEST FAILED WITH MESSAGE "EPSU UNIT AFT L". MAINTENANCE REPLACED THE AFT EMERGENCY POWER SUPPLY UNIT BATTERY PACK.SDR SA04089Battery · dischargedCLT - AIRCRAFT FAILED THE EMERGENCY LIGHTS TEST WITH MESSAGE "EPSU UNIT EMER L". MAINTENANCE REPLACED THE BATTERY PACK THE LEFT, OVERWING EXIT EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR USAA040242Floorbeam · corrodedPIT- FOUND BEAM ASSEMBLY CORRODED 1.5 INCHES LONG BY 1.3 INCH BY .65 INCH AREA, FRAME 64-66, -Y1300, Z240. REMOVED AND REPLACED BEAM ASSEMBLY PER SRM 51-42-11, 53-00-14, EA 95512. (M)SDR USAA040241Floorbeam · corrodedFOUND BEAM CORRODED 1.5 INCHES LONG BY 2 INCHES WIDE BY .029 INCH DEEP, FRAME 64-66, Y1375, Z240. REMOVED AND REPLACED BEAM ASSEMBLY PER SRM 53-41-14, 51-42-11, 51-23-11 AND EA 95512. (M)SDR USAA040240Sill · corrodedDOOR SILL, 1.0 INCH L X 1.2 INCH W X .08 INCH D. REMOVED AND REPLACED DOOR SILL IAW SRM.SDR USAA040239Floor Support · corrodedFLOOR SUPPORT, 1.5 INCH X 1.2 INCH X .055 INCH DEEP, CORROSION; LEVEL 2. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM.SDR USAA040238Floorbeam · corrodedFLOORBEAM, 1.3 INCH X 1.9 INCH X .35 INCH DEEP, CORROSION; LEVEL 2; TASK NR JA26053500, FR68, Y1300MM, Z240. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR USAA040237Support Angle · corrodedSUPPORT ANGLE ASSY, .95 INCH X .50 INCH AREA, CORROSION; LEVEL 2 Z240,Y1732, X=843. REMOVED AND REPLACED SUPPORT ANGLE ASSY IAW SRM.SDR USAA040233Girt Bar · corrodedPLATE (GIRT BAR) 1.30 INCHES X .50 INCH AREA. CORROSION; LEVEL 2; TASK NR JA-26053500, FR 68, Z240, Y1230. EXFOLIATED ON OB EDGE, REMOVED AND REPLACED PLATE IAW SRM.SDR USAA040235Floorbeam · corrodedFLOORBEAM, 1.0 INCH X 0.950 INCH X 0.055 INCH DEEP, CORROSION; LEVEL 2; TASK NR JA260535, FR 66-68, Y1200, Z240. REPLACED WITH NEW FRAME IAW SRM.SDR USAA040234Shear Web · corrodedSHEAR WEB, 8 INCHES X 3 INCHES X .040 INCH DEEP. CORROSION THRU WEB FR 69-70, Y200, Z240. REMOVED AND REPLACED SHEAR WEB IAW SRM.SDR USAA040236Frame · corrodedFRAME, 1.100 INCH X 1.00 INCH X 0.62 INCH, CORROSION. REPLACED NEW FRAME IAW SRM.SDR USAASA03042Light · failedEMERGENCY LIGHTS WOULD NOT TEST. MAINTENANCE REPLACED THE LEFT MID EPSU. (M)SDR USAASA0202072Battery · inoperativeTPA - AFT LEFT EMERGENCY BATTERY FAULTED ON TEST. MAINTENANCE REPLACED THE BATTERY. (M)SDR USAASA02072Battery · will not testTPA - AFT LEFT EMERGENCY BATTERY FAULTED ON TEST. MAINTENANCE REPLACED THE BATTERY. (M)SDR USAASA02071Latch · fodENROUTE, THE 2L SLIDE DISARMS IN FLIGHT. MAINTENANCE CLEANED FOREIGN OBJECT DAMAGE FROM GIRT BAR LATCHES. OPERATIONALLY CHECKS GOOD.SDR USAASA99004Power Suply · inoperableTPA - THE LEFT WING EMERGENCY EXIT OVERHEAD LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT AT THE LEFT WING EMERGENCY EXIT. (X)
Back to N701UW