N958UW
Service difficulty reports · 152
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 = 'N958UW' 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 = 'N958UW' 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 USAA2013041600013Mount · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON PANEL MOUNT AT FR17, LBL 22. REPLACED PANEL MOUNT AT FR17, LBL 22 IAW EMBRAER SRM II 51-41-01, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041600011Upper Sheet · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON UPPER SHEET AT FR85, RBL 11. REPLACED UPPER SHEET AT FR85, RBL 11 IAW EMBRAER SRM II 51-43-03, 51-41-01, 51-40-02, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041600010Upper Sheet · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON UPPER SHEET BETWEEN FR85 TO FR86, LBL 11. REPLACED UPPER SHEET BETWEEN FR85 TO FR86, LBL 11 IAW EMBRAER SRM II 51-41-02, 51-42-02, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500030Sill · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON RIGHT FLOOR SILL BETWEEN FR12 TO FR14 & BETWEEN RBL 40 TO RBL 52. REPLACED RIGHT FLOOR SILL BETWEEN FR12 TO FR14 & BETWEEN RBL 40 TO RBL 52 IAW EMBRAER SRM II 51-41-02, 51-43-04, 51-40-03, 51-23-04, 51-23-05 & 51-23SDR USAA2013041500024Gusset · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON GUSSET AT FR80, RBL 20. REPLACED GUSSET AT FR80, RBL20 IAW EMBRAER SRM II 51-41-02, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500021Floorbeam · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON LEFT FLOORBEAM AT FR86, LBL 11. REPAIRED LEFT FLOORBEAM AT FR86, LBL 11 IAW EMBRAER SRM II 53-23-01, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500020Beam · corrodedC2 CHECK - CORROSION ON AFT CARGO LOWER BEAM BETWEEN FR80 TO FR84, RBL 54. REPLACED AFT CARGO LOWER BEAM BETWEEN FR80 TO FR84, RBL 54 IAW EMBRAER SRM II 51-40-02, 51-41-02, 51-43-01 & 51-23-10.SDR USAA2013041500019Beam · corrodedC2 CHECK - CORROSION ON FORWARD CARGO DOOR BEAM AT FR24, 4 INCHES AFT, S26R, RBL15. REPLACED FORWARD CARGO DOOR BEAM AT FR24, 4 INCHES AFT, S26R, RBL15 IAW EMBRAER SRM II 51-43-03, 51-43-04, 51-41-02 & 51-43-03.SDR USAA2013041500004Light · brokenC2 CHECK - PHOTO LUMINESCENT INDICATOR STRIP LIGHT BROKEN AT L5 POSITION. REPLACED LEFT LIGHT STRIP IAW EMBRAER 1 90 AMM 33-50-21-04.SDR USAA2013041600018Mount · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOOR MOUNT AT FR18, LBL 25. REPLACED FLOOR MOUNT AT FR18, LBL 25 IAW EMBRAER SRM II 51-41-01, 51-40-03, 51-43-01, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041600017Sill · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SILL PLATE AT FR84 BETWEEN RBL 11 TO RBL 45. REPLACED SILL PLATE AT FR84 BETWEEN RBL 11 TO RBL 45 IAW EMBRAER SRM II 51-41-02, 51-43-01, 51-43-02 & 51-40-02.SDR USAA2013041600015Doubler · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON DOUBLER AT FR19 BETWEEN LBL 13 TO LBL 22. REPLACED DOUBLER AT FR19 BETWEEN LBL 13 TO LBL 22 IAW EMBRAER SRM II 51-43-04, 51-41-02, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041600014Mount · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON PANEL MOUNT AT FR17, RBL 22. REPLACED PANEL MOUNT AT FR17, RBL 22 IAW EMBRAER SRM II 51-40-03, 51-41-01, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500033Panel · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON CENTER SHEAR PANEL BETWEEN FR87 TO FR88 & BETWEEN LBL 11 & RBL 11. REPLACED CENTER SHEAR PANEL BETWEEN FR87 TO FR88 & BETWEEN LBL 11 & RBL 11 IAW EMBRAER SRM II 51-40-02, 51-42-01, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500032Panel · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SHEAR PANEL AT FR87, RBL 11 INCHES TO RBL 40 INCHES. REPLACED SHEAR PANEL AT FR87, RBL 11 INCHES TO RBL 40 INCHES IAW EMBRAER SRM II 51-42-01, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500026Gusset · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON GUSSET PLATE AT FR90, RBL 11. REPLACED GUSSET PLATE AT FR90, RBL 11 IAW EMBRAER SRM II 51-41-02, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500025Gusset · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON GUSSET PLATE AT FR90, LBL 11. REPLACED GUSSET PLATE AT FR90, LBL 11 IAW EMBRAER SRM II 51-41-02, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500022Seat Track · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON RIGHT SEAT TRACK BEAM AT FR14, RBL 11. REPLACED RIGHT SEAT TRACK BEAM AT FR14, RBL 11 IAW EMBRAER SRM II 51-41-02, 51-43-01, 51-43-02 & 51-40-02.SDR USAA2013041700025Panel · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON LEFT SHEAR PANEL AT FR87 BETWEEN LBL 11 TO LBL 30. REPLACED LEFT SHEAR PANEL AT FR87 BETWEEN LBL 11 TO LBL 30 IAW EMBRAER 190 SRM II 51-42-03, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041600016Support · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON PANEL SUPPORT AT FR87 AT RBL 25. REPLACED PANEL SUPPORT AT FR87 AT RBL 25 IAW EMBRAER SRM II 51-40-03, 51-41-01 & 51-21-01.SDR USAA2013041600012Doubler · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FORWARD FRAME DOUBLER AT FR16 BETWEEN LBL 11 TO LBL 40. REPLACED FORWARD FRAME DOUBLER AT FR16 BETWEEN LBL 11 TO LBL 40 IAW EMBRAER SRM II 51-41-02, 51-40-02, 51-40-04 & 51-23-04.SDR USAA2013041500031Sill · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON LEFT FLOOR SILL AT L1 DOOR AT FR16, LBL 50. REPLACED LEFT FLOOR SILL AT L1 DOOR AT FR16, LBL 50 IAW EMBRAER SRM II 51-41-02, 51-43-02, 51-23-04, 51-43-04 & 51-23-06.SDR USAA2013041500029Floor Support · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT AT FR15, RBL 27. REPLACED FLOOR SUPPORT AT FR15, RBL 27 IAW EMBRAER SRM II 51-41-07, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041500023Seat Track · corrodedC2 CHECK - CORROSION ON LEFT SEAT TRACK BEAM AT FR16, LBL 11. REPLACED LEFT SEAT TRACK BEAM AT FR16, LBL 11 IAW EMBRAER SRM II 51-41-01, 51-41-02, 51-43-03, 51-43-04, 51-23-04, 51-23-05 & 51-23-06.SDR USAA2013041600002Glowstrip · brokenC2 CHECK - PHOTO LUMINESCENT INDICATOR STRIP BROKEN AT L6 POSITION. REPLACED LEFT NR 6 LIGHT STRIP IAW EMBRAER 190 AMM 33-50-21-04.SDR USAA2013041500027Support · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SUPPORT AT FR87, LBL 30. REPLACED SUPPORT AT FR87, LBL 30 IAW EMBRAER SRM II 51-41-01, 51-40-02, 51-23-03, 51-23-04, 51-23-05 &, 51-23-06.SDR USAA2013041500028Support · crackedC2 CHECK - CRACK ON SUPPORT AT FR85, RBL 30. REPLACED SUPPORT AT FR85, RBL 30 IAW EMBRAER SRM II 51-41-01 & 51-21-01.SDR USAA2013040900013Doubler · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON WAIST BOX DOUBLER AT FR89, RBL 11. REPLACED WAIST BOX DOUBLER AT FR89, RBL 11 IAW EMBRAER SRM II 51-43-02, 51-40-03, 51-23-04 & 51-23-05.SDR USAA2013040900012Support · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SUPPORT AT FR86, LBL 30. REPLACED SUPPORT AT FR86, LBL 30 IAW EMBRAER 190 SRM II 51-40-02 & 51-23-04.SDR USAA2013040900011Support · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SUPPORT AT FR86, RBL 30. REPLACED SUPPORT AT FR86, RBL30 IAW EMBRAER 190 SRM II 51-40-02 & 51-23-04.SDR USAA2012091000004Pneumatic System · low pressureAFT SERVICE DOOR PNEUMATIC ASSEMBLY (DOOR ASSIST) REQUIRE SERVICING. MAINTENANCE SERVICED AFT SERVICE DOOR PNEUMATIC ASSEMBLY.SDR USAA2012091000002Pneumatic System · low pressureFORWARD SERVICE DOOR PNEUMATIC ASSEMBLY (DOOR ASSIST) REQUIRE SERVICING. MAINTENANCE SERVICED FWD SERVICE DOOR PNEUMATIC ASSEMBLY.SDR USAA2012082200006Accumulator · lowR2 DOOR ASSIST PNEUMATIC ASSEMBLY REQUIRES SERVICING. MAINTENANCE SERVICED R2 DOOR ASSIST PNEUMATIC ACCUMULTOR. NO FURTHER DEFECTS NOTED.SDR USAA2012060400005Pneumatic System · low pressureAFT SERVICE DOOR PNEUMATIC ASSEMBLY PRESSURE LOW. MAINTENANCE SERVICED THE PNEUMATIC ASSEMBLY OF RIGHT AFT SERVICE DOOR.SDR USAA2012030100001Bottle · low pressureR2 DOOR BOTTLE NEEDS SERVICED. MAINTENANCE SERVICED THE DOOR BOTTLE PER AMM 52-11-51.SDR USAA2011091500014Battery · dischargedBOS - FOUND NR 2 CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED FRONT RIGHT EMERGENCY LIGHT PSU. OPS CHECK GOOD.SDR USAA2011080100003Light · inoperativeLGA - R1 DOOR EMERGENCY EXIT RED LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED R1 DOOR EMERGENCY EXIT RED LIGHT ASSEMBLY IAW E-190 AMM 33-50-00 OPS CHECK GOOD.SDR USAA20110412EM019Bottle · low pressureBOS - THE R2 DOOR ASSIST BOTTLE BELOW PRESSURE. MAINTENANCE SERVICED THE R2 DOOR ASSIST BOTTLE PER AMM 52-41-51.SDR USAA2011EM016Altimeter · failedFLIGHT 1845, PVD-PHL - ON CLIMBOUT OF PVD THE CREW RECEIVED EICAS MESSAGES "YAW DAMPER OFF","1 RADAR ALTIMETER FAILED", THEN A CONTINUOUS SOUNDING OF THE LANDING GEAR AURAL WARNING HORN. THE CREW RECYCLED THE LANDING GEAR AT 4,000FT WITH NO POSITIVE RESULTS. SDR USAA20110314EM014Bottle · low pressureBOS - THE RIGHT AFT PASSENGER DOOR ASSIST BOTTLE REQUIRES SERVICING. MAINTENANCE SERVICED THE RIGHT AFT PASSENGER DOOR IAW AMM 52-12-51.SDR USAA20110208EM008Disc · puncturedBOS - WHILE PERFORMING THE WEEKLY CHECK MAINTENANCE PERSONNEL FOUND THE PNEUMATIC DOOR ASSEMBLY DISC PUNCTURED ON THE R1 DOOR. MAINTENANCE REMOVED AND REPLACED THE DISC DIAPHRAGM ON THE R1 DOOR AND SERVICED AS REQUIRED PER AMM 52-41-51.SDR USAA20101021EM052Pneumatic System · low pressureBOS - THE LEFT AFT CABIN DOOR EMERGENCY PNUEMATIC ASSEMBLY PRESSURE IS LOW. MAINTENANCE SERVICED THE EMERGENCY PNUEMATIC ASSEMBLY PER AMM 52-12-51.SDR USAA20101011EM049Battery · dischargedPHL - THE FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AIRCRAFT RIGHT AFT DOES NOT FLASH RED. UNABLE TO TELL IF IT IS CHARGING. MAINTENANCE REPLACED THE AFT EMERGENCY FLASHLIGHT BATTERY.SDR USAA20100915EM044Bottle · low pressureBOS - THE R2 PASSENGER DOOR ASSIST BOTTLE PRESSURE IS LOW. MAINTENANCE SERVICED THE DOOR ASSIST BOTTLE PER AMM 52-12-51-03.SDR USAA20100719EM028Indicator · faultyPHL - THE AFT LEFT DOOR IS DIFFICULT TO ARM AND WHEN DISARMED, THE HANDLES APPEAR TO BE IN A LOWER POSITION THAN THE OTHER DOOR HANDLES. REMOVED AND REPLACED THE VISUAL LOCK INDICATOR ASSEMBLY.SDR USAA20100203EM002Sensor · faultyFLIGHT 9198, PHL-CLT - FLIGHT WAS A POSITION FERRY FLIGHT TO CLT. INBOUND THE CREW DECLARED AN EMERGENCY WHILE ON APPROACH TO LANDING FOR FLAPS 1, RECEIVED SLATS 0 FLAP 1 MESSAGE. THE CREW PERFORMED QRH PROCEDURE; LANDED WITH SLATS 0, FLAPS 2. BRAKES WERE USDR USAA20091112EM079Battery · dischargedCLT - THE FORWARD EMERGENCY BREAKAWAY FLASHLIGHT DOES NOT BLINK RED. MAINTENANCE REPLACED THE BATTERY, OPERATIONAL CHECK IS NORMAL.SDR USAA20090902EM058Diaphragm · faultyDCA - THE L1 DOOR PNEUMATIC ASSEMBLY PRESSURE IS LOW. MAINTENANCE REMOVED AND REPLACED THE DIAPHRAGM.SDR USAA20090803EM049Bottle · low pressureBDL - THE R2 DOOR ASSIST BOTTLE PRESSURE IS LOW. MAINTENANCE SERVICED THE BOTTLE TO 2250 PSI.SDR USAA20090527EM031Sign · inoperativePHL - THE R1 DOOR EXIT IDENTIFIER SIGN IS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE R1 DOOR EXIT IDENTIFIER SIGN.
Back to N958UW