N195UW
Service difficulty reports · 182
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 = 'N195UW' 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 = 'N195UW' 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 AALA202008189003Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 6 ELEVATOR ON RH HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING #6 ON RH HORIZONTAL STABILIZER I.AW AMM 55-16-42-400-001-A.SDR AALA2020081979005Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE - DELAMINATED FLOOR PANEL, 221PF, FORWARD LAV WET AREA. REPLACED FLOOR PANEL 221PF WITH NEW REPLACEMENT MATERIAL PER A321 SRM 53-12-00-300-006, AND IRM 9701, REV. I.SDR AALA2020082879008Splice · wornAIRCRAFT IN BASE MAINTENANCE: FOUND WEAR ON LOWER INBOARD SPLICE (0.199 INCHES) ON LOWER SILL IN AFT GALLEY. REPLACED SPLICE LOWER INBOARD SIDE IAW A321 SRM 51-72-11-911-001 AND DWG E53474250.SDR AALA2020082879007Splice · wornAIRCRAFT IN BASE MAINTENANCE: FOUND SPLICE UPPER INBOARD SIDE ON LOWER SILL IN AFT GALLEY WORN MEASURING 0.219 INCHES. REPLACED SPLICE UPPER INBOARD SIDE IAW A321 SRM 51-72-11-911-001 AND DWG E53474250.SDR AALA202009089019Anchor Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF JACK ANCHORAGE FITTING OF RH MAIN LANDING GEAR BETWEEN WSTA 700 AND WSTA 1406, MEASURING L=0.795 IN, W=1.260 IN, D=0.020 IN. ACCOMPLISHED PERMANENT REPAIR OF JACK ANCHORAGE FITTING WITH BORE/FASTENER HOLE REWORK IAW ASDR AALA202009159017Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 1 INCH CRACK AREA ON SHEAR PLATE AT FR 69-FR 70 AND STR 23R AT AFT GALLEY. REMOVED AND REPLACED SHEAR PLATE, REF SRM 51-72-11-911-001.SDR AALA202009089015Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SHEAR PLATE BETWEEN FR69 AND FR70 AT STR 23L, MEASURING L=1.011 IN. REPLACED SHEAR PLATE WITH NEW IAW A321 SRM 51-42-11-801 AND DRAWING D53474180.SDR AALA2020090129019Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND 2.017 X 0.873 X 0.040 INCH CORRODED AREA ON LOWER SILL BETWEEN FR66 TO FR68 AT STR 23R IN AFT GALLET AREA. REPLACED LOWER SILL IAW SRM 51-72-11-911-001.SDR AALA2020082879010Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION (L= 1.403 INCHES W= 0.954 INCHES D= 0.048 INCHES) ON LOWER SILL LOCATED FROM FR66 TO FR68 AND STR 23L AT AFT GALLEY AREA. REPLACED SILL IAW A321 SRM 51-72-11-911-001 AND DWG # D53480505 AND # E53474250.SDR AALA2020082879009Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION (L= 4.024 INCHES W= 0.600 INCHES D= 0.078 INCHES) ON CENTER FITTING OF SHAPE SILL LOCATED FROM FR66 TO FR68 AND STR 23R AT AFT GALLEY AREA. REPLACED FITTING IAW A321 SRM 51-72-11-911-001 AND DWG # D5348050.SDR AALA202008189015Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF CENTER FITTING BETWEEN FR66 AND FR68 AT STR 23L, MEASURING L=9.507 IN, W=0.600 IN. REPLACED CENTER FITTING WITH NEW IAW A319 SRM 51-72-11-911-001 AND DRAWING D53480048202.SDR AALA2020082539022Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE - DELAMINATED/DISBONDED FLOOR PANEL, 231AF, FORWARD GALLEY WET AREA. REPLACED FLOOR PANEL 231AF WITH REPLACEMENT MATERIALS PER A321 SRM 51-72-11-911-001.SDR AALA2020081979004Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE - DELAMINATED FLOOR PANEL, 222EF, FORWARD GALLEY WET AREA. REPLACED FLOOR PANEL 222EF WITH NEW REPLACEMENT MATERIAL PER A321 SRM 53-12-00-300-006, AND IRM 9701, REV. I.SDR AALA2020081869028Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE - DELAMINATED FLOOR PANEL, 222FF, FORWARD GALLEY WET AREA. REPLACED FLOOR PANEL 222FF WITH NEW REPLACEMENT MATERIAL PER A321 AMM 53-00-00-400-801-A.SDR AALA202008169027Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE - DELAMINATED FLOOR PANEL, 221DF, FORWARD GALLEY WET AREA. REPLACED FLOOR PANEL 221DF WITH NEW REPLACEMENT MATERIAL PER A321 SRM 53-12-00-300-006, AND IRM 9701, REV. I.SDR AALA2020081769026Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATION OF FLOOR PANEL 241JF BETWEEN FR42 AND FR47 BETWEEN BL -Y254 AND BL Y254, MEASURING L=20.0 IN, W=17.0 IN. REPLACED FLOOR PANEL WITH NEW IAW A321 SRM 53-02-00-300-011.SDR AALA2020072429017Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED, EMERGENCY ESCAPE PATH LIGHT INOPERATIVE AT SEAT ROW 30ABC. RELAMPED EMERGENCY ESCAPE PATH LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR AALA201909279003Pitot Line · cloggedAIRCRAFT WAS GROUNDED: PILOT ABORTED TAKE OFF AT HIGH SPEED ON ACCOUNT OF CAPTAIN'S AIRSPEED INDICATOR FAILED. FLIGHT TAXIED TO THE GATE. MAINTENANCE FLUSHED CAPT PITOT LINE IAW AMM 34-10-001-700-1A AND PERFORMED LEAK TEST OF MAIN AIR DATA SYSTEM IAW AMM 34-1SDR AALA201905019025Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BROKEN AT SEAT ROW 20ABC. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201902129011Floor Panel · delaminatedAFT CARGO FLOOR PANEL 151MK DELAMINATED. REPLACED THE FLOOR PANEL IAW AMM 53-42-14.SDR AALA201812199016Unknown · odorAIRCRAFT WAS GROUNDED. AT START OF DESCENT OIL VAPOR SMELL LEFT ENGINE WAS REPORTED. MAINTENANCE ACCOMPLISHED CABIN ODOR TROUBLE SHOOTING TASK CARD 26L00021001 AND WAS UNABLE TO DUPLICATE OR DETERMINE THE SOURCE OF THE ODOR. THE AIRCRAFT WAS DETERMINED TO BE OSDR AALA201811059026Flashlight · inoperativeFORWARD FLIGHT ATTENDANT FLASHLIGHT WAS INOPERATIVE. REPLACED THE FLASHLIGHT IAW AMM 25-60-00.SDR AALA201810259025Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHT INOPERABLE AT SEAT ROW 34. MAINTENANCE REPAIRED LIGHT AT SEAT ROW 34 PER ESPM 20-53-55 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA201805249014Warning System · malfunctionedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR SHOWED OPEN ON ECAM AFTER DOOR WAS CLOSED. MAINTENANCE CYCLED DOOR SENSOR POWER PER AMM 52-73-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805149045Warning Light · false activationFLIGHT ATTENDANT CIDS PANEL EMERGENCY BUTTON ILLUMINATED. SWITCH LIGHT DIM MODE IS NORMAL. ACCOMPLISHED EMERGENCY LIGHT TEST ESPU AT MCDU. TEST PASSED AND SYSTEMS CHECKED OK IAW MM 33-51-00.SDR AALA201802269028Lens · missingRED EMERGENCY LIGHT LENS MISSING AT AISLE 9D. REPLACED THE LENS IAW AMM 33-51-18.SDR AALA201711139016Lens · detachedR3 DOOR EXIT LIGHT LENS FELL OFF. REPLACED THE LENS IAW AMM.SDR AALA201710059016Lever · looseL3 DOOR ARMING LEVER FOUND LOOSE. REPLACED THE ARMING LEVER IAW AMM.SDR AALA201708239014Handle · looseL3 DOOR SLIDE HANDLE LOOSE. TIGHTEN THE HANDLE IAW AMM.SDR AALA201708089029Cable Assy · faulty32L SEAT ESCAPE PATH LIGHT INOPERATIVE. REPLACED 32L PREFABRICATED CABLE ASSY AND SECURED PROTECTIVE CAP.SDR AALA201705269008Lens · missingL4 DOOR MISSING THE EXIT SIGN LENS. INSTALLED THE LENS.SDR AALA201703139011Arming Lever · looseAIRCRAFT NOT GROUNDED. 3L DOOR ARMING LEVER IS LOOSE. TIGHTENED LOOSE LEVER. CHECKED OK.SDR AALA201611309017Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS FORWARD FLIGHT ATTENDANT STATION FLASHLIGHT BATTERY, LIGHT NOT BLINKING. MAINTENANCE REPLACED FLASHLIGHT ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201610109022Diaphragm · leakingR1 DOOR BOTTLE LOW PRESSURE. REMOVED & REPLACED R1 DOOR DIAPHRAM IAW AMM 52-22-00-614-002. LEAK CHECKED GOOD.SDR AALA201610069006Bottle · low pressureR1 DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED R1 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR AALA201610039011Damper · low pressureCIDS PANEL INDICATES "CHECK DOOR PRESSURE" FOR DOOR 1R. DOOR ASSIST DAMPER IS DEGRADED, SERVICED DOOR PER AMM 52-10-00.SDR AALA201609309013Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. CIDS PANEL CAUTION CHECK DOOR PRESSURE 1R. SERVICED 1R DOOR ASSIST BOTTLE PER AMM 52-10-01.SDR AALA201609279003Floor Panel · delaminatedAFT CARGO FLOOR PANEL 151GF IS DELAMINATED. AIRCRAFT WAS GROUNDED. REPLACED FLOOR PANEL IAW AMM 53-42-14.SDR AALA201605069004Bottle · low pressureAIRCRAFT WAS NOT GNDED. R3 DOOR ASSIST BOTTLE PRESS LOW. SERVICED R3 DOOR ASSIST BOTTLE IAW AMM 52-20-00-614-002-A.SDR AALA201603019001Unknown · odorAIRCRAFT WAS GNDED. AFTER TAKEOFF FLIGHT ATTENDANTS REPORTED FUMES IN CABIN, DESCRIBED AS A PUNGENT & ACRID ODOR. ACFT RETURNED, CREW DID NOT DECLARE AN EMER. ATC DID DECLARE & EMER CFR RESPONDED. PERFORMED JC 26L00021001, TROUBLESHOOT CABIN AIR QUALITY, WSDR AALA201602099005Battery · dischargedAIRCRAFT WAS NOT GNDED. THE FLASHLIGHT AT FLIGHT ATTENDANT POSITION 2R IS INOPERATIVE. R & R FLASHLIGHT BATTERY. OPERATIONAL CHECKED NORMAL.SDR USAA2015030400002Slide · defectiveL4 PAX & CREW DOOR EMER ESCAPE SLIDE COVER, LOWER LATCHES WILL NOT LATCH. SLIDE PACKED INCORRECTLY. R & R L4 SLIDE ASSEMBLY.SDR USAA2015021900003Hinge Fitting · damagedS1 CHECK, HINGE FITTING DAMAGED BEYOND LIMITS. REPLACED HINGE FITTING IAW AMM 55-16-42.SDR USAA2014123100002Arming Lever · brokenARMING HANDLE R2 BROKEN OFF. REPLACED R2 DOOR HANDLE ARMING IAW CMM 52-21-30. SYS OPERATIONS CHECKED GOOD.SDR USAA2014120100014Bushing · wornDOOR 1L WILL NOT STAY LOCKED IN OPEN POSITION. REPLACED UPPER & LOWER BUSHINGS FOR SECONDARY ROD ON 1L DOOR GUST LOCK MECHANISM IAW TSM 52-11-00-810-822-A & AMM 52-11-12-400-802-A.SDR USAA2014092600008Coffeemaker · unserviceableFWD & AFT ODOR OF A BURNING SMELL EN ROUTE & DURING DESCENT. R & R AFT COFFEEMAKERS & FOUND FOOD DEBRIS IN FWD GALLEY OVEN. REMOVED SHELVES & CLEANED INSIDE OVEN. NO ODOR PRESENT DURING TESTING.SDR USAA2014072800020Mechanism · lack of lubeTHE GUST LOCK AT DOOR 1L BROKEN. IDENTIFIED GUST LOCK LINKAGE ON 1L DOOR, LUBED MECHANISM. OPERATIONS CHECKED GOOD.SDR USAA2014072100018Lever · missingTHE ARMING & DISARMING LEVER LOOSE AT 3L. REPLACED MISSING ARM & DISARM LEVER AT 3L IAW AMM 52-22-00-0201-00. HANDLE OPERATIONS NORMAL.SDR USAA2014061200019Floor Panel · delaminatedSY6 CHECK DELAMINATION ON FLOOR PANEL 221DF BETWEEN FRAME 16 TO 21, Z-500. REPLACED FLOOR PANEL 221DF IAW IRM 9701 REV G.SDR USAA2014060900014Shear Plate · corrodedC11 CHECK CABIN FLOOR SHEAR PLATE CORRODED BETWEEN FRAME 69 & 70 AT Y1732. R & R SHEAR PLATE IAW SRM 51-72-00.
Back to N195UW