N914AW, cancelled Aug 21, 2013
Service difficulty reports · 127
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 = 'N914AW' AND deregistration_id = 'N914AW-2013-08-21' 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 = 'N914AW' AND deregistration_id = 'N914AW-2013-08-21' 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 USAABB08116ALight · inoperativeLOWER PROX LIGHT AT SEAT 5C INOP. INSTALLED EMERGENCY ESCAPE PATH LIGHT AT POSITION 5C. OPS CHECK GOOD.SDR USAABB08108Connector · disconnectedPHX - THE EMERGENCY LIGHT ON SEAT 6C WAS FOUND INOPERATIVE. MAINTENANCE RECONNECTED THE SEAT EMERGENCY LIGHT CONNECTOR AT SEAT 6C AND SECURED THE CABLE. OPERATIONAL CHECKS OK. (S)SDR BB08057Light · brokenPHX - THE EMERGENCY PATH LIGHT AT ROW 5L WAS FOUND BROKEN. MAINTENANCE REPLACED THE EMERGENCY PATH LIGHT ASSEMBLY AT ROW 5L. OPERATIONALLY CHECKS OK.SDR BB07094Actuator · failedFLT 304 PHX - CLT AFTER TAKEOFF FROM PHX, THE FLT CREW GOT A LANDING GEAR DISAGREE INDICATION AND A LANDING GEAR DOOR OPEN INDICATION. CYCLED GEAR AND STILL HAD INDICATION. RETURNED TO PHX. AN EMERGANCY WAS DECLARED, FLIGHT LANDED WITHOUT INCIDENT. MAINTENSDR AWXA200700906Stringer · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5961743, CRACKED STRINGER, BS 655, S16L. REPAIRED STRINGER, BS 655, S16L IAW USAIRWAYS EA120101.SDR AWXA200700926Wedge · separatedMCN - MAJOR REPAIR - C-12 - CHECK - RIGHT WING NR 6 SLAT TRAILING EDGE WEDGE SEPARATED, SS 133.15 - SS 134.15. REPAIRED RIGHT WING NR 6 SLAT TRAILING EDGE, SS 133.15 - SS 134.15 IAW B757-200 SRM 51-70-10-2R4.SDR AWXA200700903Floor Support · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5998957, CORROSION ON AFT CARGO COMPARTMENT DOOR SILL FLOOR SUPPORT "Z" ANGLE BS 1380 - BS 1440, RBL 22, S27R, WL 156.80. REPLACED AFT CARGO COMPARTMENT DOOR SILL FLOOR SUPPORT "Z" ANGLE BS 1380 - BS 1440, RBL 22, S27R, WSDR AWXA200700939Web · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5956473, CORROSION ON LEFT HORIZONTAL STABILIZER TRAILING EDGE WEB, STABILIZER STATION 224. REPLACED LEFT HORIZONTAL STABILIZER TRAILING EDGE WEB, STABILIZER STATION 224 IAW B757-200 SRM 51-40-02.SDR AWXA200700856Attach Angle · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950589, CORROSION ON ATTACH ANGLE, BS 1360 +16", RBL 24. REPLACED ATTACH ANGLE, BS 1360 +16", RBL 24 IAW B757-200 SRM 51-40-02.SDR AWXA200700857Intercostal · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5979102, CORROSION ON INTERCOSTAL, BS 1435 - BS 1440, S27R - S28R. REPLACED INTERCOSTAL, BS 1435 - BS 1440, S27R - S28R IAW B757-200 SRM 51-40-02.SDR AWXA200700845Rib · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5956488, CRACKED LEFT HORIZONTAL STABILIZER TRAILING EDGE RIB WEB, STABILIZER STATION 244.501. REPLACED LEFT HORIZONTAL STABILIZER TRAILING EDGE RIB WEB, STABILIZER STATION 244.501 IAW B757-200 SRM 51-40-02.SDR AWXA200700937Spar · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5956471, CORROSION ON THE LEFT HORIZONTAL REAR AFT SPAR, STABILIZER STATION 224 - 366. REPAIRED THE LEFT HORIZONTAL REAR AFT SPAR, STABILIZER STATION 224 - 366 IAW USAIRWAYS EA 120107.SDR AWXA200700936Beam · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5956472, CORROSION ON THE LEFT HORIZONTAL REAR AFT BEAM, STABILIZER STATION 224 - 366. REPAIRED THE LEFT HORIZONTAL REAR AFT BEAM, STABILIZER STATION 224 - 366 IAW USAIRWAYS EA 120102 .SDR AWXA200700935Structure · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5956477, CORROSION ON THE LEFT HORIZONTAL TRAILING EDGE WEB UPPER CHORD, STABILIZER STATION 318.9. REPLACED THE LEFT HORIZONTAL TRAILING EDGE WEB UPPER CHORD, STABILIZER STATION 318.9 IAW B757-200 SRM 51-40-02.SDR AWXA200700855Intercostal · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950599, CORROSION ON INTERCOSTAL, BS 1360 - BS 1380, S26R - S27R. REPLACED INTERCOSTAL, BS 1360 - BS 1380, S26R - S27R IAW B757-200 SRM 51-40-02.SDR AWXA200700851Web · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950598, CORROSION ON WEB, BS 1360 - BS 1380, S27R. REPLACED WEB, BS 1360 - BS 1380, S27R IAW B757-200 SRM 51-40-02.SDR AWXA200700858Attach Angle · corrodedMCN - MAJOR REPAIR - C-12 CHECK - FOUND CORROSION ON ATTACH ANGLE, BS 1400, S26R - S27R. REPLACED ATTACH ANGLE, BS 1400, S26R - S27R IAW B757-200 SRM 51-40-02.SDR AWXA200700852Shear Tie · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950591, CORROSION ON SHEAR TIE, BS 1360 + 16", RBL 26, WL 158. REPLACED SHEAR TIE, BS 1360 + 16", RBL 26, WL 158 IAW B757-200 SRM 51-40-02.SDR AWXA200700880Stringer · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950467, CRACKED STRINGER, BS 640, S16L. REPAIRED STRINGER, BS 640, S16L IAW B757-200 SRM 53-00-03-2R1.SDR AWXA200700842Door Frame · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950466, AFT CARGO DOOR CUT OUT WEB CRACKED, BS 1440, S25R - S26R AT THE NR 6 STOP UPPER INBOARD HOLE. REPAIRED AFT CARGO DOOR CUT OUT WEB, BS 1440, S25R - S26R AT THE NR 6 STOP UPPER INBOARD HOLE IAW B757-200 SRM 53-00-07SDR AWXA200700822Stringer Clip · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950483, CRACKED STRINGER CLIP, BS 840, S25L. REPLACED STRINGER CLIP, BS 840, S25L IAW B737-300 SRM 51-40-02.SDR AWXA200700809Attach Angle · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950465, FORWARD CARGO COMPARTMENT DOOR CUT OUT FRAME CHORD ATTACH ANGLE CRACKED, BS 560, S20R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT FRAME CHORD ATTACH ANGLE, BS 560. S20R IAW B757-200 SRM 51-40-02.SDR AWXA200700905Threshold · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5978998, CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD "T" CAP, BS 1380 - BS 1440, RBL 22, S27R, WL 156.80. REPLACED AFT CARGO COMPARTMENT DOOR THRESHOLD "T" CAP, BS 1380 - BS 1440, RBL 22, S27R, WL 156.80 IAW 757-200SDR AWXA200700854Web · corrodedMCN - MAJOR REPAIR - C-12 CHECK - CORROSION ON AFT CARGO COMPARTMENT WEB, BS 1400 - BS 1420, RBL 21, WL 156.80. REPLACED AFT CARGO COMPARTMENT WEB, BS 1400 - BS 1420, RBL 21, WL 156.80 IAW B757-200 SRM 51-40-02.SDR AWXA200700853Shear Tie · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5979000, CORROSION ON AFT CARGO COMPARTMENT SHEAR CLIP, BS 1420, RBL 21, WL 156.80. REPLACED AFT CARGO COMPARTMENT SHEAR CLIP, BS 1420, RBL 21, WL 156.80 IAW B757-200 SRM 51-40-02.SDR AWXA200700847Skin · delaminatedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950929, RIGHT WING AILERON INBOARD LOWER SURFACE IS DELAMINATED, WS 667 - WS 668. REPAIRED RIGHT WING AILERON INBOARD LOWER SURFACE, WS 667 - WS 668 IAW B757-200 SRM 51-70-04.SDR AWXA200700832Web · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5978954, FORWARD CARGO COMPARTMENT DOOR CUT OUT WEB CRACKED, BS 560, S19R - S21R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT WEB, BS 560, S19R - S21R IAW B757-200 SRM 51-40-02.SDR AWXA200700831Skin · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950909, RIGHT WING NR 9 SLAT COVE SKIN CRACKED, WS 677.5 - WS 705.5. REPLACED RIGHT WING NR 9 SLAT COVE SKIN, WS 677.5 - WS 705.5 IAW B757-200 SRM 51-40-02.SDR AWXA200700907Panel · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950875, CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL SIDE PLATE PANEL, BS 1310 - BS 1377, RBL 25, WL 156.80. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL SIDE PLATE PANEL, BS 1310 - BS 1377, RBL 25SDR AWXA200601032Control Unit · faultedFLT 005 - CREW REPORTED, DURING FINAL APPROACH RT ENG LOST OIL PRESS IND. RECEIVED LP FUEL PUMP AND R GEN OFF EICAS MESSAGE. ENG WAS REPORTED TO NOT RESPOND WHEN THROTTLES WERE ADVANCED. DECLARED EMERG INTO PHX AND LANDED. EGT WAS REPORTED TO BE AT 887 AFTSDR AWXA200600990Switch · failedMCN - EEL - NR 5920952 - DURING C11 CHECK THE AFT CABIN EMERGENCY LIGHTS TEST SWITCH DID NOT WORK. MAINTENANCE REMOVED AND REPLACED THE AFT CABIN EMERGENCY LIGHT TEST SWITCH IAW BOEING SWPM 20-84-14 PARA 3. OPERATIONAL CHECKS WERE GOOD IAW BOEING 757-200 AMMSDR AWXA200600947Spar Cap · corrodedNR 5921066 - DURING C11 CHECK DISCOVERED CORROSION ON THE RT WING REAR SPAR UPPER CAP, APPROXIMATELY 36 INCHES FROM WING TO BODY FAIRINGS AT WS 170R. CORROSION WAS FOUND TO BE OUT OF SRM LIMITS. MAINTENANCE REPAIRED THE RT WING REAR SPAR UPPER CAP AT WS 170RSDR AWXA200600959Angle · corrodedNR 5920646 - DURING C11 CHECK DISCOVERED CORROSION ON ANGLE INSIDE FWD OPENING OF THE ELEVATOR CONTROL ACCESS DOOR BETWEEN HINGES AT BS 1862.7 AND STR 29R. CORROSION WAS BEYOND LIMITS. MAINT REPAIRED ANGLE INSIDE FWD OPENING OF ELEVATOR CONTROL ACCESS DOOR BSDR AWXA200600867Frame · crackedMCN - DURING C11 CHECK DISCOVERED FRAME CRACKED, .750 INCHES, AT FASTENER HOLE AT BS 1380, SEVEN INCHES ABOVE THE LOWER FORWARD CORNER OF AFT CARGO DOOR OPENING. MAINTENANCE REMOVED DAMAGED SECTION IAW BOEING 757-200 SRM 53-00-07-2R2. FABRICATED REPAIR PLATESDR AWXA200600866Intercostal · crackedMCN - DURING C11 CHECK DISCOVERED THE MAIN CABIN INTERCOSTAL CRACKED, .75 INCHES, AT RT B/S 1320 BELOW STR 13R AT THE NR 3 DOOR STOP. MAINTENANCE REMOVED AND INSTALLED FABRICATED REPLACEMENT INTERCOSTAL AT RT BS 1320, BELOW STR 13R AT THE NR 3 DOOR STOP IAW BSDR AWXA200600864Stringer Clip · crackedMCN - DURING C11 CHECK DISCOVERED RT STRINGER CLIP CRACKED, .5 INCHES, AT BS 1380 AND STR 16R. MAINTENANCE REMOVED AND INSTALLED NEW STRINGER CLIP AT BS 1380 AND STR 16R IAW BOEING 757-200 SRM 51-40-02-0G FIG 8, 51-40-05-0G FIG 2, AND 51-20-01-0G PAR 4G.SDR AWXA200600954Clip · crackedNR 5920542 - DURING C11 CHECK DISCOVERED UPPER INTERCOSTAL ANGLE CLIP CRACKED, 3 TOTAL LENGTH 2.0 INCHES, AT BS 1661 TO BS 1681 AND BL 10R. MAINTENANCE REMOVED AND INSTALLED NEW ANGLE CLIP AT BS 1661 TO BS 1681 AND AT BL 10R IAW SRM 51-40-02-0G FIG 12.SDR AWXA200600953Intercostal · crackedNR 5920506 - DURING C11 CHECK DISCOVERED CRACK, .5 INCHES, ON INTERCOSTAL FORWARD OF THE UPPER DOOR HINGE R2 DOOR. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL WEB FORWARD OF THE UPPER DOOR HINGE, R2 DOOR, IAW TASK CARD M1C53606.SDR AWXA200600951Intercostal · crackedNR 5920503 - DURING C11 CHECK DISCOVERED INTERCOSTAL CRACKED FORWARD OF THE NR 3 DOOR STOP FOR THE L2 DOOR. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL FORWARD OF THE NR 3 DOOR STOP FOR THE L2 DOOR IAW TASK CARD M1C53614.SDR AWXA200600950Intercostal · crackedNR 5920502 - DURING C11 CHECK DISCOVERED INTERCOSTAL CRACKED, .75 INCHES, FORWARD OF THE NR 6 DOOR STOP FOR THE R2 DOOR. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL WEB FORWARD OF THE NO. 6 DOOR STOP FOR THE R2 DOOR IAW TASK CARD M1C53614.SDR AWXA200600949Intercostal · crackedNR 5920504 - DURING C11 CHECK DISCOVERED CRACKED, .375 INCHES, INTERCOSTAL FORWARD OF THE NR 4 DOOR STOP FOR THE L2 DOOR. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL FORWARD OF THE NR 4 DOOR STOP FOR THE L2 DOOR IAW CARD M1C3608.SDR AWXA200600946Intercostal · crackedNR 5920502 - DURING C11 CHECK DISCOVERED END OF INTERCOSTAL, FORWARD OF THE NR 6 DOOR STOP FOR THE R2 DOOR CRACKED, .75 INCHES. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL WEB, FORWARD OF THE NR 6 DOOR STOP FOR THE 42 DOOR IAW TASK CARD M1C53614.SDR AWXA200600882Intercostal · crackedMCN - DURING C-11 CHECK FOUND INTERCOSTAL CRACK FORWARD OF UPPER DOOR HINGE OF L2 DOOR AT BS 660 TO BS 686 AND AT STR 11L. MAINTENANCE REMOVED AND REPLACED INTERCOSTAL UPPER DOOR HINGE OF L2 DOOR AT BS 660 TO BS 686 AND AT STR 11L IAW AMERICA WEST AIRLINES TASDR AWXA200600880Intercostal · crackedMCN - DURING C-11 CHECK FOUND INTERCOSTAL WEB CRACKED, .5 INCHES, FORWARD OF THE NR 3 DOOR STOP FOR THE R2 DOOR AT BS 660 TO BS 686 AT STR 11R. MAINTENANCE REMOVED AND INSTALLED FABRICATED INTERCOSTAL WEB AND CLIP FWD OF NR 3 DOOR STOP FOR THE R2 DOOR AT BS 6SDR AWXA200600869Channel · corrodedMCN - DURING C11 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON HAT CHANNEL AT BS 1688 TO BS 1716 AND BL 5.5L. NO CORROSION REMOVAL LIMITS WERE AVAILABLE IN THE SRM. MAINTENANCE REMOVED, FABRICATED AND REPLACED HAT CHANNEL AT BS 1688 TO BS 1716 AND BL 5.5SDR AWXA200600868Channel · corrodedMCN - DURING C11 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON HAT CHANNEL AT BS 1688 TO BS 1716 AND BL 5.5R. NO CORROSION REMOVAL LIMITS WERE AVAILABLE IN THE SRM. MAINTENANCE REMOVED, FABRICATED AND REPLACED HAT CHANNEL AT BS 1688 TO BS 1716 IAW BOEINGSDR AWXA200600865Plate · corrodedMCN - DURING C11 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON THE DECK PLATE AT BS 1681 TO BS 1720 AND FROM BL 51.5L TO BL 51.5R. CORROSION WAS REMOVED AND FOUND TO BE OUT OF LIMITS. MAINTENANCE REPAIRED DECK PLATE AT BS 1681 TO BS 1720 AND FROM BL 51.5SDR AWXA200600956Skin · delaminatedNR 5865365 - DURING C11 CHECK DISCOVERED RT WING, NR 9 SLAT WEDGE, OB UPPER SKIN IS DELAMINATED AT WING STATION 698R TO WING STATION 705R. MAINTENANCE REPAIRED DELAMINATED AREA ON THE RT WING, NR 9 SLAT WEDGE, OB UPPER SKIN IAW SRM 51-70-10-2R REPAIR 4 FIG 20SDR AWXA200600463Fuse · defectivePHX - EEL - DURING OVERNIGHT MAINTENANCE DISCOVERED EMERGENCY EXIT LIGHTS INOPERATIVE FROM ROW 27 TO ROW 34. MAINTENANCE REPLACED FUSE ON AFT POWER SUPPLY AND REPLACED LIGHT AT ROW 27 IAW BOEING 757-200 AMM 33-51-00, OPERATIONAL TESTS WERE GOOD.SDR AWXA200600128Skin · bulgedMX DISCOVERED DURING A CHECK POSSIBLE PILLOWING CORROSION STR 28L AT BS 1460 BULGE IN SKIN RIVETS HEADS DAMAGED. MAINTENANCE REMOVED EXISTING SPLICE AT STA 1452-1465 AND STR 28L. CUTOUT STRINGER 28L AT STA 1455 TO STA 1459, CORROSION WAS OUT OF LIMITS. REMO
Back to N914AW, cancelled Aug 21, 2013