N189UW
Service difficulty reports · 362
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 = 'N189UW' 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 = 'N189UW' 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 USAA2012091900002Lens · broken2S CHECK - CABIN WALL MOUNTED L2 DOOR EMERGENCY EXIT SIGN LENS COVER BROKEN. REPLACED CABIN WALL MOUNTED L2 DOOR EMERGENCY EXIT SIGN LENS COVER IAW A321 AMM 33-51-13.SDR USAA2012092100006Connector · not seated2S CHECK - L1 DOOR EMERGENCY EXIT SIGN LIGHT INOPERATIVE. RESEATED EMERGENCY LIGHT CONNECTOR AND PERFORMED OPS TEST IAW A321 AMM 33-51-00-710-008, TEST GOOD.SDR USAA2012090700012Profile · corroded2S CHECK - GALVANIC CORROSION ON PROFILE CORNER BETWEEN FR56 TO FR58, S23R. REPLACED PROFILE CORNER BETWEEN FR56 TO FR58, S23R IAW A321 SRM 51-42-11.SDR USAA2012090700013Support · corroded2S CHECK - GALVANIC CORROSION ON SCUFF PLATE SUPPORT BETWEEN FR16 TO FR20, S23R, -Y1732 PLUS 5 INCHES. REPLACED SCUFF PLATE SUPPORT BETWEEN FR16 TO FR20, S23R, -Y1732 IAW A321 SRM 51-73-11 AND SRM 51-42-11.SDR USAA2012082300006Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR39 TO FR46, Y1292. REPLACED SEAT TRACK BETWEEN FR39 TO FR46, Y1292 IAW A321 SRM 51-74-00, 53-31-15, 51-42-11 & 51-44-11.SDR USAA2012082300001Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK AT FR47, -Y756. REPLACED SEAT TRACK AT FR47, -Y756 IAW A321 SRM 53-31-15 FIG 103, 51-54-11, 51-42-11 & 51-75-12.SDR USAA2012082200013Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR36 TO FR41, Y1292. REPLACED SEAT TRACK BETWEEN FR36 TO FR41, Y1292 IAW A321 SRM 53-31-15 FIG 101 & 51-42-11.SDR USAA2012052100025Slide · faultyRED CAUTION LIGHT ON CIDS PANEL FOR R4 DOOR SLIDE. REMOVED AND REPLACED R4 DOOR ESCAPE SLIDE.SDR USAA2011120900010Megaphone · weakAFT EMERGENCY MEGAPHONE WEAK. MAINTENANCE REPLACED THE AFT MEGAPHONE.SDR USAA2011111400016Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 151GF BETWEEN FR53 TO FR56, -Z1500 & BETWEEN Y1000 TO -Y1000. REPLACED FLOOR PANEL 151GF IAW A321 AMM 53-42-14-400-001.SDR USAA2011111000011Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 261DF AT FR20, Y510. REPLACED FLOOR PANEL 261DF IAW MCGILL IRM 9701 REV G.SDR USAA2011111000010Shear Plate · crackedC11 CHECK - CRACK ON SHEAR PLATE BETWEEN FR68 TO FR69, S23L. REPLACED SHEAR PLATE BETWEEN FR68 TO FR69, S23L IAW A321 SRM 51-72-11.SDR USAA2011111000009Stringer · corrodedC11 CHECK - CORROSION ON STRINGER BETWEEN FR35 TO FR35.8, S41R. SPLICED STRINGER BETWEEN FR35 TO FR35.8, S41R IAW EA 201213.SDR USAA2011111000001Fitting · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON CORNER FITTING AT FR68, S23L, Y1589. REPLACED CORNER FITTING AT FR68, S23L, Y1589 IAW A321 SRM 51-72-11.SDR USAA2011111000021Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 232FF BETWEEN FR20 TO FR24, -Y1497. REPLACED FLOOR PANEL 232FF IAW MCGILL IRM 9701 REV G.SDR USAA2011110200013Fitting · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON CORNER FITTING AT FR68, S23R. REPLACED CORNER FITTING AT FR68, S23R IAW A321 SRM 51-72-11.SDR USAA2011110100012Sill · corrodedC11 CHECK - LEVEL 2 GALVANIC CORROSION ON SHAPE SILL BETWEEN FR68, -Y1732. REPLACED SHAPE SILL BETWEEN FR68, -Y1732 IAW A321 SRM 51-72-11.SDR USAA2011110700003Frame · corrodedC11 CHECK - LEVEL 2 SURFACE CORROSION ON FUSELAGE FRAME AT FR68, S23R. REPAIRED FUSELAGE FRAME AT FR68, S23R IAW A321 SRM SRM 53-41-12.SDR USAA2011111100002Sill · corrodedC11 CHECK - LEVEL 2 GALVANIC CORROSION ON L4 DOOR SILL AT FR66, S23L, Y1589. REPAIRED L4 DOOR SILL ANGLE BRACKET AT FR66, S23L, Y1589 IAW EA 201206.SDR USAA2011111000015Sill · corrodedC11 CHECK - GALVANIC CORROSION ON SILL PLATE AT FR66, S23R. REPAIRED SILL PLATE AT FR66, S23R IAW EA 201205.SDR USAA2011110400007Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR47.2 TO FR47.5, Y1629. REPLACED FLOORBEAM BETWEEN FR47.2 TO FR47.5, Y1629 IAW A321 SRM 51-72-11.SDR USAA2011111000022Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR66 TO FR69, Y1162. REPLACED FLOORBEAM BETWEEN FR66 TO FR69, Y1162 IAW A321 SRM 51-42-11.SDR USAA2011111000008Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, Y1162.5. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Y1162.5 IAW A321 SRM 51-75-12.SDR USAA2011111000007Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, Y1162.5. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Y1162.5 IAW A321 SRM 51-72-11.SDR USAA2011110900005Shear Plate · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON SHEAR PLATE BETWEEN FR69 TO FR70, S23L. REPLACED SHEAR PLATE BETWEEN FR69 TO FR70, S23L IAW A321 SRM 51-72-11, AND TYPICAL REPAIR 320-2528-10-0011.SDR USAA2011110800005Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR66, S23R, -Y1292. REPLACED FLOORBEAM AT FR66, S23R, -Y1292 IAW A321 SRM 52-41-11 & 51-72-11.SDR USAA2011110800004Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM, BETWEEN FR66 TO FR68, S23R, -Y1162. REPLACED FLOOR BEAM, BETWEEN FR66 TO FR68, S23R, -Y1162 IAW A321 SRM 51-42-11 & 51-72-11.SDR USAA2011110800003Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR68, S23R, -Y1162.5. REPLACED FLOORBEAM AT FR68, S23R, -Y1162.5 IAW A321 SRM 51-42-11, 51-72-11.SDR USAA2011110800002Shear Tie · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SHEAR TIE PLATE BETWEEN FR69 TO FR70, -Y1162.5. REPLACED SHEAR TIE PLATE BETWEEN FR69 TO FR70, -Y1162.5 IAW A321 SRM 51-72-11 AND TYPICAL REPAIR 320-258-10-0011.SDR USAA2011110400008Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR66, -Y464.8. REPLACED FLOORBEAM AT FR66, -Y464.8 IAW A321 SRM 51-72-11.SDR USAA2011110400006Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR65 TO FR68, S23L, Y765. REPLACED FLOOR BEAM BETWEEN FR65 TO FR68, S23L, Y765 IAW A321 SRM 51-72-11.SDR USAA2011110300013Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR BEAM BETWEEN FR66 TO FR68, S23R, -Y765. REPLACED FLOOR BEAM BETWEEN FR66 TO FR68, S23R, -Y765 IAW A321 SRM 51-72-11.SDR USAA2011110300006Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM FR20 TO FR20, 23R, -Y189. REPLACED FLOORBEAM FR20 TO FR20, 23R, -Y189 IAW A321 SRM 51-72-11.SDR USAA2011110300005Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOOR BEAM BETWEEN FR16 TO FR20, S23R, -Y254. REPLACED FLOORBEAM BETWEEN FR16 TO FR20, S23R, -Y254 IAW A321 SRM 51-72-11.SDR USAA2011110200018Floor Support · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FR12 TO FR16, Y503.2. REPLACED FLOOR SUPPORT BETWEEN FR12 TO FR16, Y503.2 IAW A321 SRM 51-72-11.SDR USAA2011110200017Seat Track · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, Y765. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, Y765 IAW A321 SRM 51-72-11, 53-00-15 FIGURE 104.SDR USAA2011110200014Seat Track · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON SEAT TRACK BETWEEN FR12 TO FR24, -Y1292. REPLACED SEAT TRACK BETWEEN FR12 TO FR24, -Y1292 IAW A321 SRM 51-72-11, 53-11-15 FIGURE 107.SDR USAA2011110200001Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR16, S23R, -Y1379.5. REPLACED FLOORBEAM AT FR16, S23R, -Y1379.5 IAW A321 SRM 51-42-11, 51-72-11.SDR USAA2011110100011Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR12 TO FR16, S23R, -Y81. REPLACED FLOORBEAM BETWEEN FR12 TO FR16, S23R, -Y81 IAW A321 SRM 51-42-11 & 51-72-11.SDR USAA2011103100011Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR16 TO FR23, S23L, Y254. REPLACED FLOORBEAM BETWEEN FR16 TO FR23, S23L, Y254 IAW A321 SRM 51-72-11 & AIRBUS DRAWING B2D53112554.SDR USAA2011060800004Bottle · defectivePHL - EES - R3 DOOR ASSIST BOTTLE ACTUATOR REQUIRES REPLACEMENT. MAINTENANCE REMOVED AND REPLACED R3 DOOR ASSIST BOTTLE ACTUATOR IAW AIRBUS MAINTENANCE MANUAL 52-22-14.SDR USAA2011053100018Actuator · low pressureLAX - EES - CIDS CAUTION DOOR PRESSURE LOW. MAINTENANCE SERVICED 3R DOOR ASSIST.SDR USAA2011053100013Bottle · low pressurePHL - EES - CIDS WARNING ILLUMINATED FOR R3 DOOR. MAINTENANCE SERVICED R3 DOOR ASSIST BOTTLE PER AIRBUS MAINTENANCE MANUAL 52-22-00.SDR USAA2011050491754Unknown · odorFLT 1471 LAX-PHX - ODOR - DIRTY SOCK SMELL IN COCKPIT AND MID CABIN AT 31,000". CREW REPORTED OF HEADACHES AND DIZZINESS. SMELL WENT WAY ON DESCENT WHEN APU BLEED WAS SELECTED ON. COULD NOT DETECT ANY ODOR IN CABIN WHILE USING APU OR ENGINES AT VARIED POWERSDR USAA2011040991394Lens · missingMX - LAX - EEL - EMERGENCY LIGHT LENS COVER MISSING AT SEAT 22R. MAINTENANCE INSTALLED EMERGENCY LIGHT LENS AT 22R.SDR USAA2011030790987Bottle · low pressureFLT 1746 - MCO - EES - CABIN CONTROL PANEL BY THE 1L DOOR IS DISPLAYING RED CIDS CAUTION LIGHTS. MAINTENANCE SERVICED R-3 DOOR ASSIST BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-22-614-002.SDR USAA2010122893257Actuator · low pressureFLT 710 - LAX - EES - RED LIGHT ON CIDS CAUTION PANEL FOR R2 AND R3 DOOR PRESSURE LOW. MAINTENANCE SERVICED R3 DOOR IAW AIRBUS MAINTENANCE MANUAL 52-22-00-614-002.SDR USAA2010122893255Actuator · low pressureFLT 710 - LAX - EES - RED LIGHT ON CIDS CAUTION PANEL FOR R2 AND R3 DOOR PRESSURE LOW. MAINTENANCE SERVICED R2 DOOR IAW AIRBUS MAINTENANCE MANUAL 52-22-00-614-002.SDR USAA2010062991297Megaphone · inoperativeFLT 1630 - LGA - EMERGENCY EQUIPMENT - AFT MEGAPHONE FOUND INOPERATIVE. REMOVED AND REPLACED AFT MEGAPHONE IAW AIRBUS MAINTENANCE MANUAL 25-65-51.SDR USAA2010062491253Bottle · low pressureFLT 1792 - CLT - EES - LOW DOOR PRESSURE ALERT ON CIDS. MAINTENANCE FOUND 3R DOOR OPENING ASSIST BOTTLE PRESSURE LOW. SERVICED BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-22-00.
Back to N189UW