N939UW
Service difficulty reports · 156
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 = 'N939UW' 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 = 'N939UW' 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 USAA2014060300012Seat Track · corrodedC4 CHECK LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK BETWEEN BS 1540 TO BS 1640, RBL 45.5. REPLACED SEAT TRACK BETWEEN BS 1540 TO BS 1640, RBL 45.5 IAW SRM 53-00-52, FIG 101, DETAIL 1, 51-40-02 & DWG 146N5130.SDR USAA2014060300011Seat Track · corrodedC4 CHECK LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK BETWEEN BS 1540 TO BS 1640, LBL 24.75. REPLACED SEAT TRACK BETWEEN BS 1540 TO BS 1640, LBL 24.75 IAW SRM 53-00-52, FIG 101, DETAIL 1, 51-40-02 & DWG 146N5130.SDR USAA2014050900020Floor Support · corrodedC4 CHECK, LEVEL 2 EXFOLIATION CORROSION ON CABIN FLOOR SUPPORT BETWEEN BS 700 TO BS 720, LBL 63. REPLACED CABIN FLOOR SUPPORT BETWEEN BS 700 TO BS 720, LBL 63 IAW SRM 53-00-51, FIG 101 & 51-40-02.SDR USAA2014050900011Floorbeam · corrodedC4 CHECK, LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM UPPER T CHORD AT BS 1640 BETWEEN RBL 12 TO RBL 58. REPLACED FLOORBEAM AT BS 1640 BETWEEN RBL 12 TO RBL 58 IAW SRM 53-00-51-1A, FIG 101, 53-00-51-2R-7 & 51-40-02.SDR USAA2014050900009Channel · corrodedC4 CHECK, LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT CHANNEL BETWEEN BS 1661 TO BS 1681, RBL 58.22. REPLACED FLOOR SUPPORT CHANNEL BETWEEN BS 1661 TO BS 1681, RBL 58.22 IAW SRM 53-80-13-1A, FIG 101 & 51-40-02.SDR USAA2014050900008Stiffener · corrodedC4 CHECK, LEVEL 2 FILIFORM CORROSION ON HAT STIFFENER AT BS 1656, RBL 63. REPLACED HAT STIFFENER AT BS 1656, RBL 63 IAW SRM 51-40-02 & DWG 146N8016.SDR USAA2014050900007Stiffener · corrodedC4 CHECK LEVEL 2 FILIFORM CORROSION ON HAT STIFFENER AT BS 1656, LBL 63. REPLACED HAT STIFFENER AT BS 1656, LBL 63 IAW SRM 51-40-02 & DWG 146N8016.SDR USAA2014050900005Stiffener · corrodedC4 CHECK, LEVEL 2 FILIFORM CORROSION ON HAT STIFFENER AT BS 1673, RBL 63. REPLACED HAT STIFFENER AT BS 1673, RBL 63 IAW SRM 51-40-02 & DWG 146N8016.SDR USAA2014050900004Stiffener · corrodedC4 CHECK, LEVEL 2 FILIFORM CORROSION ON HAT STIFFENER AT BS 1673, LBL 63. REPLACED HAT STIFFENER AT BS 1673, LBL 63 IAW SRM 51-40-02 & DWG 146N8016.SDR USAA2014050900010Channel · corrodedC4 CHECK, CORROSION ON FLOOR SUPPORT CHANNEL BETWEEN BS 1661 TO BS 1640, BL0. REPLACED FLOOR SUPPORT CHANNEL BETWEEN BS 1661 TO BS 1640, BL0 IAW SRM 51-40-02 & DWG 146N5242.SDR USAA2014050600025Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CABIN RT CREASE BEAM INNER CHORD BETWEEN BS 725 TO BS 740, RBL 62. REPLACED CREASE BEAM BETWEEN BS 725 TO BS 740, RBL 62 IAW SRM 51-40-02.SDR USAA2014050600024Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CABIN LT CREASE BEAM INNER CHORD BETWEEN BS 1290 TO BS 1370, LBL 62. REPLACED CREASE BEAM BETWEEN BS 1290 TO BS 1370, LBL 62 IAW SRM 51-40-02.SDR USAA2014050600023Channel · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON AFT CABIN FLOOR CHANNEL BETWEEN BS 1661 TO BS 1681.1, BL0. REPLACED AFT CABIN FLOOR CHANNEL BETWEEN BS 1661 TO BS 1681.1, BL0 IAW SRM 51-10-02, 51-40-05 & 51-40-02.SDR USAA2014060300010Seat Track · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN BS 1540 TO BS 1640, LBL45.5. REPLACED SEAT TRACK BETWEEN BS 1540 TO BS 1640, LBL45.5 IAW SRM 53-00-52, FIG 101, DET 1, 51-40-02 & 51-21-00.SDR USAA2014050900022Fitting · corrodedC4 CHECK, LEVEL 2 GALVANIC CORROSION ON CABIN FLOOR SUPPORT CLIP BETWEEN BS 1674 TO BS 1680, LBL 53. REPLACED CABIN FLOOR SUPPORT CLIP BETWEEN BS 1674 TO BS 1680, LBL 53 IAW SRM 51-40-02.SDR USAA2013091600001Cover · detachedEXIT LIGHT COVER ON 1R DOOR NOT ATTACHED. REPLACED EXIT LIGHT COVER 1R DOOR.SDR USAA2013080600001Switch · failedENROUTE, WHEN FWD LAV DOOR WAS CLOSED AND LOCKED, THE FLUORESCENT LIGHT IN LAVATORY WENT OUT. BLACK SMOKE CAME THRU DOOR FRAME. MX FOUND THE FWD LAV DOOR FRAME LIGHT SWITCH MELTED AND SHORTED. MX REPLACED THE FWD LAV DOOR FRAME LIGHT SWITCH. OPS CHECKED OKSDR USAA2013071900002Light · looseEMERGENCY LIGHTS ON FLOOR, LT SIDE ROW 1-2 LOOSE. REPLACED DAMAGED AND MISSING SECTION.SDR USAA2013071700001Light · buckledFLOOR TRACK LIGHTING IN FIRST CLASS IS PROTRUDING UPWARD. REPLACED DAMAGED SECTION OF FLOOR TRACK.SDR USAA2013070300001Cover · brokenEXIT LIGHT COVER AT 4R DOOR BROKEN MISSING. REINSTALLED EXIT LIGHT COVER.SDR USAA2013052400003Wire Harness · faultyENROUTE, LT GEN OFF LIGHT ILLUMINATED. BUS ISOLATED. ACARS OH DISPLAYED. SYS OPERATED NORMALLY AFTER GEN CONTROL RESET. BUS TIE RESET NOT ATTEMPTED. THE FLIGHT DECLARED AN EMERGENCY AND RETURNED TO FIELD. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. MX PLSDR USAA2013050300006Slide · out of positionCLT - DOOR MOUNTED EMERGENCY SLIDE OUT OF CONTAINER AT DOOR NR 1L. REMOVED AND REPLACED DOOR NR L1 ESCAPE SLIDE/RAFT.SDR USAA2013050100003Light · looseCLT - ESCAPE PATH LIGHTING STRIP ADJACENT TO SEAT 1C IS LOOSE. SECURED PATH LIGHTING STRIP AT 1C.SDR USAA2013040100005Lens · out of alignmentCLT - DOOR 1L VIEWING LENSE OUT OF POSITION. REPOSITIONED TRIM BEZEL TO ALIGN WITH VIEWPORT AT 1L DOOR, CHECKS NORMAL.SDR USAA2013032200003Light · inoperativePHX - EMERGENCY EXIT ROW LIGHTS INOP AT ROW 2 LEFT SIDE A/C. REMOVED AND REPLACED EMERGENCY EXIT ROW OVERHEAD BIN LIGHT FOR ROWS 2 LEFT, OPS NORMAL.SDR USAA2012080800018Reservoir · low pressureC3 CHECK - R2 DOOR EMERGENCY POWER RESERVOIR PRESSURE LOW. REMOVED AND REPLACED RESERVOIR PER JOB CARD 19C84252003.SDR USAA2012052100009Screw · missingPHL - EMERGENCY LIGHT PANEL MID A/C OVERHEAD IS FALLING APART/ MISSING SCREWS. PROPERLY RE-SECURED EMERGENCY LIGHT PANEL ON A/C MID OVERHEAD.SDR USAA2012041900004Flow Valve · debondedPHL - FLT 1451 PHL TO PUJ. ABORT TAKEOFF AT 80 KNOTS. AT 80 KNOTS, DID NOT HAVE 1.4 EPR ON RIGHT ENGINE. AT 80 KNOTS, RIGHT EEC LIGHT & RIGHT ENGINE LIMITER LIGHT ON. REPLACED RIGHT FUEL FLOW GOVERNOR. OP'S & LEAK CHECK OK. P4 ORIFICE DEBONDED.SDR USAA2012030900014Module · faultyFLT 1035. WHILE RETURNING FOR A HYDRAULIC INDICATION PROBLEM, THE FLIGHT EXPERIENCED A FLIGHT CONTROL ANOMALY DURING THE APPROACH. AT 3000FT DESCENDING TO 2,500, WITH APP ARMED AND ALL 3 AUTO PILOTS ENGAGED, AUTO PILOT WENT INTO NOSE DOWN HARDOVER ABOUT .75 SDR USAA2011121200021Circuit Breaker · poppedPHL - FLT 751 EN ROUTE BRU TO PHL. ON DESCENT, THE FLIGHT DECLARED AN EMERGENCY DUE TO EICAS MESSAGES "APU BLEED VAL", "L HYD ELE PUMP", "C HYD ELE 2", "ANTI-SKID", "PROBE HEAT", "RT UTIL BUS OFF", "R RECIRC FAN", AND "L ENG EEC". THE CIRCUIT BREAKER FOR THSDR USAA2011080800018Fan · malfunctionedDUB - FLT 724 EN ROUTE PHL TO DUB. L RECIRC FAN DISPLAYED AND RECIRC FAN INOP LIGHT ILLUM WITH SWITCH POSITION TO ON. ELECTRICAL BURNING SMELL DESCENDING INTO DUB. REMOVED AND REPLACED L RECIRC FAN.SDR USAA2011071500002Fan · malfunctionedMCO - FLT 1857 EN-ROUTE CLT TO MCO. AFTER ENG SHUT DOWN AT THE GATE THERE WAS A PUNGENT ODOR LIKE BURNT MATTRESS IN FIRST CLASS AND REST OF CABIN. TWENTY MINUTES FROM MCO HAZE AND ODOR, TURNED OF RECERC AND HAZE WENT AWAY. PERFORMED VISUAL INSPECTION OF ASDR USAA2011011390198Angle · crackedCLT - C2 - MAJOR REPAIR - CRACK IN SHEAR ANGLE AT BS 1300, S21L. REPLACED SHEAR ANGLE AT BS 1300, S21L IAW B757 SRM 51-40-02.SDR USAA20100812BB047Fuse · blownPHX - THE EMERGENCY LIGHT AT ROW 15DEF WAS INOPERATIVE. REPLACED THE FUSE IN EPSU BASE 10699.SDR USAA20100716BB042Circuit Board · faultedPHL FLT 740 EN ROUTE SJU TO PHL. DURING APPROACH, RECEIVED "L ENG LP PUMP" MESSAGE. THE LEFT ENGINE UNSPOOLED AND THE LEFT ENGINE OIL PRESSURE WENT TO 16 PSI AND WITHIN 45 SECONDS CAME BACK TO ALL NORMAL INDICATIONS. THE FLIGHT LANDED WITHOUT FURTHER INCISDR USAA20100331BB023Charger · inoperativePHL - THE EXTERNAL EMERGENCY LIGHT AT DOOR L4 WAS INOPERATIVE. CLEANED THE TERMINAL AT LIGHT ASSEMBLY AT DOOR L4. ALSO, REMOVED AND REPLACED THE BATTERY PACK AND CHARGER.SDR USAA2011011390197Panel · delaminatedCLT - C2 - MAJOR REPAIR - DELAMINATION ON RIGHT VERTICAL STABILIZER PANEL AT FIN STA 116 APPROX 12 INCHES AFT OF LEADING EDGE. REPLACED RIGHT VERTICAL STABILIZER PANEL IAW B757 SRM 55-30-01.SDR USAA2009040890839Mechanism · malfunctionedMCN - C1 - EES - L-1 DOOR POWER ASSIST PIN WILL NOT ENGAGE IN RELEASE FORK. REPLACED EMERGENCY POWER TRIGGER MECHANISM ON L-1 DOOR IAW B757 AMM 52-11-32.SDR USAA2009040890838Support · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON R-2 DOOR DRAIN TROUGH GUTTER SUPPORT BETWEEN BS 720 TO BS 740, WL 208, RBL 62. REPLACED R-2 DOOR DRAIN TROUGH GUTTER SUPPORT BETWEEN BS720 TO BS 740, WL 208, RBL 62 IAW B757 SRM 51-40-02.SDR USAA2009031690612Support · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON L-4 DOOR RAIN GUTTER SUPPORT AT BS 1656, WL 208. REPLACED L-4 DOOR RAIN GUTTER SUPPORT AT BS 1656, WL 208 IAW B757 SRM 51-10-02, 53-60-01 & 51-40-02.SDR USAA2009040390792Floor Support · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON FLOOR SUPPORT BETWEEN BS 720 TO BS 740, RBL 54. REPLACED FLOOR SUPPORT BETWEEN BS 720 TO BS 740, RBL 54 IAW B757 SRM 51-40-02.SDR USAA2009040890841Frame · crackedMCN - C1 - MAJOR REPAIR - FRAME CHORD CRACKED AT FORWARD END OF PANEL 195BL, BS 1147 INSIDE LEFT MAIN LANDING GEAR WHEEL WELL. REPLACED FRAME CHORD AT FORWARD END OF PANEL 195BL, BS 1147 INSIDE LEFT MAIN LANDING GEAR WHEEL WELL IAW B757 SRM 51-40-02 & BOEING SDR USAA2009040390795Floorbeam · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 740, WL 208, LBL 55. REPAIRED FLOORBEAM AT BS 740, WL 208, LBL 55 IAW US AIRWAYS EA 130213.SDR USAA2009040390796Floorbeam · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 700, WL 208 BETWEEN LBL 45 & LBL 65. REPAIRED FLOORBEAM AT BS 700, WL 208 BETWEEN LBL 45 & LBL 65 IAW US AIRWAYS EA 130213.SDR USAA2009040390790Support · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON SUPPORT BETWEEN BS 684 TO BS 700, WL 208, LBL 65. REPLACED SUPPORT BETWEEN BS 684 TO BS 700, WL 208, LBL 65 IAW B757 SRM 51-40-02.SDR USAA2009040390789Intercostal · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON INTERCOSTAL AT BS 684, WL 208, LBL 45. REPLACED INTERCOSTAL AT BS 684, WL 208, LBL 45 IAW B757 SRM 51-40-02.SDR USAA2009040390788Support Angle · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON SUPPORT ANGLE BETWEEN BS 684 TO BS 700, WL 208, LBL 65. REPLACED SUPPORT ANGLE BETWEEN BS 684 TO BS 700, WL 208, LBL 65 IAW B757 SRM 51-40-02.SDR USAA2009032490676Sill · corrodedMCN - MAJOR REPAIR - C1 CHECK - CORROSION ON L2 DOOR SILL CHORD AT BS 600 - BS 740, LBL 65, WL 208.1 REPLACED L2 DOOR SILL CHORD AT BS 600 - BS 740, LBL 65, WL 208.1 IAW B757 SRM 51-40-02.SDR USAA2009032490675Floor Support · corrodedMCN - MAJOR REPAIR - C1 CHECK - CORROSION ON FLOOR SUPPORT AT BS 720 - BS 740, LBL 65, WL 208.1. REPLACED FLOOR SUPPORT AT BS 720 - BS 740, LBL 65, WL 208.1 IAW B757 SRM 51-40-02.SDR USAA2009040390791Structure · deterioratedMCN - C1 - MAJOR REPAIR - DETERIORATED COMPSITE ON AILERON AT WBL 720. REPAIRED DETERIORATED COMPSITE ON AILERON AT WBL 720 IAW B757 SRM 51-70-03.
Back to N939UW