N109UW
Service difficulty reports · 207
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 = 'N109UW' 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 = 'N109UW' 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 USAA2011053100031Fitting · corrodedPIT - S5 - CHECK LEVEL 2 EXFOLIATION CORROSION ON DOOR FRAME SILL FITTING 1.25 INCHES FORWARD OF FR 68, STR 23R. REPLACED DOOR FRAME SILL FITTING 1.25 INCHES FORWARD OF FR 68, STR 23R IAW A320 SRM 51-72-11.SDR USAA2011060300014Attach Fitting · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON CARGO BIN FRAME ATTACH FITTING AT FR 31, BETWEEN STR 40R TO STR 41R. REPLACED CARGO BIN FRAME ATTACH FITTING AT FR 31, BETWEEN STR 40R TO STR 41R IAW A320 SRM 51-42-11.SDR USAA2011053100036Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION ON FLOORBEAM AT FR 24, BL -Y1292. REPLACED FLOORBEAM AT FR 24, BL -Y1292 IAW A320 SRM 51-72-11.SDR USAA2011053100035Floorbeam · corrodedPIT - S5 CHECK LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 20 TO FR 21, BL Y765. REPLACED FLOORBEAM BETWEEN FR 20 TO FR 21, BL Y765 IAW A320 SRM 51-72-11.SDR USAA2011053100034Support Angle · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SUPPORT ANGLE AT FR 20, BL Y1600. REPLACED SUPPORT ANGLE AT FR 20, BL Y1600 IAW A320 SRM 51-72-11.SDR USAA2011053100033Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM 6 INCHES FORWARD OF FR 66, BL -Y465. REPLACED FLOORBEAM 6 INCHES FORWARD OF FR 66, BL -Y465 IAW A320 SRM 51-43-00.SDR USAA2011053100032Sill · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON DOOR SILL BETWEEN FR 66 T0 68, BL -Y1292. REPLACED DOOR SILL BETWEEN FR 66 T0 68, BL -Y1292 IAW A320 SRM 53-41-14 AND AIRBUS DRAWING D53480505.SDR USAA2011053100028Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR 20, BL -Y765. REPLACED FLOORBEAM AT FR 20, BL -Y765 IAW A320 SRM 51-72-11.SDR USAA2011053100030Floorbeam · corrodedPIT - S5 CHECK - EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 16 TO FR 21, BL -Y1292. REPLACED FLOORBEAM BETWEEN FR 16 TO FR 21, BL -Y1292 IAW SRM 51-72-11.SDR USAA2011053100029Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 66 TO FR 68, BL -Y765. REPLACED FLOORBEAM BETWEEN FR 66 TO FR 68, BL -Y765 IAW A320 SRM 51-72-11.SDR USAA2011053100027Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 18 TO FR 21, BL Y254. REPLACED FLOORBEAM BETWEEN FR 18 TO FR 21, BL Y254 IAW A320 SRM 51-72-11.SDR USAA2011053100026Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR 14, BL -Y81. REPLACED FLOORBEAM AT FR 14, BL -Y81 IAW A 320 SRM 51-71-11, DWG D53112829.SDR USAA2011053100025Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR 16, BL Y503. REPLACED FLOORBEAM AT FR 16, BL Y503 IAW A320 SRM 51-72-11.SDR USAA2011053100024Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 16 TO FR 24, BL Y1292. REPLACED FLOORBEAM BETWEEN FR 16 TO FR 24, BL Y1292 IAW A320 SRM 51-72-11.SDR USAA2011053100023Floorbeam · corrodedPIT - S2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 66 TO FR 67, BL Y765. REPLACED FLOORBEAM BETWEEN FR 66 TO FR 67, BL Y765 IAW A320 SRM 51-72-11.SDR USAA2011053100022Sill · corrodedPIT - S2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON DOOR SILL BETWEEN FR 66 TO FR 68, BL 1160. REPLACED DOOR SILL BETWEEN FR 66 TO FR 68, BL 1160 IAW AIRBUS DWG 18D53480020.SDR USAA2011053100021Floorbeam · corrodedPIT - S2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 65 TO FR 66, BL Y515. REPLACED FLOORBEAM BETWEEN FR 65 TO FR 66, BL Y515 IAW A320 SRM 51-72-11 AND EA 117866.SDR USAA2011053100020Floorbeam · corrodedPIT - S2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR 68, BL -Y254. REPLACED FLOORBEAM AT FR 68, BL -Y254 IAW A320 SRM 53-41-14.SDR USAA2011053100041Shear Web · crackedPIT - S5 CHECK - CRACK ON SHEAR WEB BETWEEN FR 68 AND FR 69, STR 23L. REPLACED SHEAR WEB BETWEEN FR 68 AND FR 69, STR 23L IAW AIRBUS DRAWING 18D53480020.SDR USAA2011053100037Floorbeam · corrodedPIT - S5 CHECK LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR 66, BL Y1292. REPLACED FLOORBEAM AT FR 66, BL Y1292 IAW A320 SRM 53-41-14.SDR USAA2011053100046Floorbeam · corrodedPIT -S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR 65, BL -Y1292. REPLACED FLOORBEAM AT FR 65, BL -Y1292 IAW A320 SRM 51-72-11 AND AIRBUS DRAWING 53472780.SDR USAA2011053100044Shear Plate · corrodedPIT - S5 CHECK - LEVEL 2 CORROSION ON SHEAR PLATE BETWEEN FR 69 AND FR 70, STR 23R. REPLACED SHEAR PLATE BETWEEN FR 69 AND FR 70, STR 23R IAW A320 SRM 51-72-11.SDR USAA2011053100043Shear Plate · corrodedPIT - S5 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON SHEAR PLATE BETWEEN FR 68 AND FR 69, STR 23L. REPLACED SHEAR PLATE BETWEEN FR 68 AND FR 69, STR 23L IAW TR 320-2528-10-0011A.SDR USAA2011053100042Shear Web · crackedPIT - S5 CHECK CRACK ON SHEAR WEB BETWEEN FR 68 AND FR 69, STR 23L. REPLACED SHEAR WEB BETWEEN FR 68 AND FR 69, STR 23L IAW A320 SRM 51-72-11 AND AIRBUS DRAWING D1853480020.SDR USAA2011053100040Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 68 TO FR 69, BL -Y1292. REPLACED FLOORBEAM BETWEEN FR 68 TO FR 69, BL -Y1292 IAW A320 SRM 51-72-11.SDR USAA2011053100039Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 66 TO FR 68, BL -Y1292. REPLACED FLOORBEAM BETWEEN FR 66 TO FR 68, BL -Y1292 IAW A320 SRM 53-41-14.SDR USAA2011053100038Floorbeam · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 68 TO FR 69, BL Y1292. REPLACED BETWEEN FR 68 TO FR 69, BL Y1292 IAW A320 SRM SRM 53-41-14.SDR USAA2011060300013Shear Plate · corrodedPIT - S5 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON SHEAR PLATE BETWEEN FR 69 TO FR 70, BL -Y1292. REPLACED SHEAR PLATE BETWEEN FR 69 TO FR 70, BL -Y1292 IAW AIRBUS DRAWING D53474180 AND TR 320-2528-10-0011A.SDR USAA2010102092325Lens · brokenFLT 894 - ATL - EEL - R1 DOOR EMERGENCY LIGHT LENS BROKEN. MAINTENANCE REPLACED R1 DOOR EMERGENCY LIGHT LENS.SDR USAA2010091391977Control System · contaminatedFLT 1885 PHL-FLL - CABIN ODOR - FLIGHT RETURNED TO PHL DUE TO A STRONG, VILE ODOR IN THE CABIN. FUMES WERE OF UNKNOWN ORIGIN AND CAUSED ONE PASSENGER TO BECOME ILL. MAINTENANCE FOUND OIL CONTAMINATION IN APU - DECONTAMINATED ENVIRONMENTAL CONTROL SYSTEM.SDR USAA2010090891962Connector · disconnectedFLT 927 - BOS - EEL - SEAT MOUNTED EMERGENCY EXIT LIGHT AT ROW 9 LEFT IS NOT ILLUMINATING. MAINTENANCE FOUND CONNECTOR DISCONNECTED. RECONNECTED, OPERATIONAL CHECK GOOD.SDR USAA2010090891961Lens · missingFLT 927 - BOS - EEL - SEAT MOUNTED EMERGENCY EXIT LENS IS MISSING AT ROW 11 RIGHT. MAINTENANCE INSTALLED NEW LENS PER AIRBUS MAINTENANCE MANUAL 33-51-18-04.SDR USAA2010081791691Battery · dischargedFLT 950 - DEN - EEL - FLIGHT ATTENDANT 'B' FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED THE BATTERY FOR F/A 'B' FLASHLIGHT.SDR USAA920081460Flashlight · inoperativeFLT 973 PDX-CLT - EMERGENCY EQUIPMENT - BREAKAWAY FLASHLIGHTS AT 2L AND 1L JUMPSEATS NEED REPLACED. MAINTENANCE REMOVED AND REPLACED FLASHLIGHTS AT 2L AND 1L AND BREAKAWAY STRAPS. (S)SDR USAA920081358Power Supply · failedLOG# 4288237 - LAX- C-9-FWD EMERGENCY POWER SUPPLY UNIT WILL NOT TEST. MX REPLACED THE EPSU. OPERATIONAL TEST WAS GOOD. (B)SDR USAA920080756Cylinder · brokenFLT 1550 - PHX-CLT - EMERGENCY EQUIP - FOUND L-1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER WITH BROKEN SPRING AT TRIGGER ASSEMBLY. MAINTENANCE REMOVED AND REPLACED L-1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER. OPERATIONAL CHECK WAS GOOD.SDR USAA920080698Hydraulic Line · crackedFLT NR 1584 - CREW REPORTED DURING CLIMB-OUT, LOST GREEN HYDRAULIC PUMP THEN YELLOW SYSTEM OVERHEAT MESSAGE ILLUMINATED. CREW DECLARED AN EMERGENCY, PERFORMED A MANUAL GEAR EXTENSION AND RETURNED TO FIELD. MX DISCOVERED PTU LINE LEAKING. MX REPLACED LINE, LSDR SA06017Spring · brokenTHE AFT LT ENTRANCE DOOR EMERGENCY ESCAPE SLIDE GIRT BAR AFT ATTACHMENT HOOK ASSEMBLY HAD A BROKEN SPRING. MAINTENANCE REPLACED THE AFT LT ENTRANCE DOOR AFT ATTACHMENT HOOK ASSEMBLY. OK FOR SERVICE.SDR SA05116Epsu · failedDCA - THE MID CABIN RIGHT HAND EMERGENCY POWER SUPPLY UNIT FAILED THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE MID CABIN, RIGHT HAND EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR USAA050974Floorbeam · corrodedPIT - S2 - FLOORBEAM, .5 INCH X .5 INCH AND 3 INCH X 2.5 INCH, CORROSION; LEVEL 1; TASK JA260-53500, FWD OF FRA 66-68, 30 INCHES LT OF CTR. REMOVED AND REPLACED BEAM. DEFECTIVE PART REPLACED WITH IDENTICAL PART. (K)SDR USAA050887Floorbeam · corrodedFOUND FLOOR SUPPORT BEAM 1 INCH DIAMETER .070 DEEP CORROSION, 20 INCH LT OF CENTERLINE AT C16. CORROSION LEVEL 1, TASK JA-220-53500. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM 51-72-11. (M)SDR USAA050888Floorbeam · corrodedFOUND FLOORBEAM CORRODED 1 INCH BY 1.5 INCH, 1 INCH BY 3 INCH, FRAME 66-68. CORROSION LEVEL 1. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW JA-260-53500. (M)SDR USAA050889Floorbeam · corrodedFOUND FLOORBEAM CORRODED .040 INCH DEEP BY .5 INCH DIAMETER, 41 INCHES LT OF CENTER LINE A C16. CORROSION LEVEL 1, TASK JA-220-53500. REMOVED AND REPLACED BEAM IAW SRM 51-40-00. (M)SDR USAA050890Floorbeam · corrodedFOUND FLOORBEAM CORRODED 2 INCH BY 4 INCH, FORWARD FRAME 66, 31 INCHES RIGHT OF CENTER LINE. CORROSION LEVEL 1, TASK JA-220-53500. REMOVED AND REPLACED FLOORBEAM PER SRM 51-40-00. (M)SDR USAA050891Beam · corrodedFOUND BEAM CORRODED 1 INCH BY 1 INCH BY .100 INCH DEEP, FORWARD CABIN TOP OF BEAM AT CENTER LINE A C16. CORROSION LEVEL 1, TASK JA-220-53500. REMOVED AND REPLACED BEAM, REPLACED WITH IDENTICAL PART NR. (M)SDR USAA050892Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY 2 INCH ON EACH OF THREE BEAMS, FRAME 64-69, 50 INCHES RIGHT OF CENTER. REMOVED AND REPLACED WITH IDENTICAL PART PER SRM 51-72-11. CORROSION LEVEL 2, TASK JA-260-53500. (M)SDR USAA050893Floorbeam · corrodedFOUND FLOORBEAM CORRODED .5 INCH BY 1 INCH AREA, FRAME 66 RT SIDE AT DOOR CUTOUT. CORROSION LEVEL 1, TASK JA-260-53500. INSTALLED REPAIR ANGLES AND FILLER IAW SRM 53-41-14. (M)SDR USAA050872Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH DIAMETER BY .050 DEEP AREA, FLOORBEAM AT C16 Y254. DEFECTIVE PART REPLACED WITH IDENT PART NR PER SRM 51-72-11. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR USAA050873Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY 1.5 INCH AREA, FRAME 66 LEFT SIDE OF DOOR CUTOUT. INSTALLED REPAIR ANGLES AND FILLER PER SRM 53-41-14 REPAIR PRINCIPLE 6. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR SA05072Strap · misroutedPIT - THE AFT RIGHT SLIDE YELLOW RELEASE STRAP WAS FOUND NOT ROUTED THROUGH THE RELEASE TRIGGER OF THE GIRT BAR. MAINTENANCE CORRECTLY ROUTED THE RELEASE STRAP. OK FOR SERVICE.
Back to N109UW