N476UA
Service difficulty reports · 113
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 = 'N476UA' 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 = 'N476UA' 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 CALA2022071501740Seat Track · corroded(A3NB-53-3-6102) FWD CABIN, FR20 Y-254 SEAT TRACK CORRODED. DOT 88-012()SDR CALA2019040500522O-Ring · failedY RSVR LO LVL DISPLAYED ON UPPER ECAM SCREEN. - HYD. CHANGED 2 O-RINGS ON THE AUTO SELECTOR BRAKE VALVE. LEAK CHECKED, BUT VALVE STILL LEAKED HYDRAULIC FLUID DUE TO A CRACK IN THE VALVE.SDR CALA2019031500403Door Sill · corrodedDATA TRANSFER REFERENCE LCQ NR 9290421 R2 DOOR HAS CORROSION AT FASTENER HOLE 1 INCH AFT OF FR66. REMOVED AND REPLACED R2 DOOR SILL IAW SRM 51-72-11-911-001.SDR CALA2019031500402Shear Plate · corrodedDATA TRANSFER REFERENCE LCQ NR 9290308 AFT CABIN RT LATERAL SHEAR PLATE HAS 3EA SPOTS OF CORROSION. REMOVED AND REPLACED RT LATERAL SHEAR PLATE IAW SRM 51-72-11-911-001.SDR CALA2019031500401Shear Plate · corrodedDATA TRANSFER REFERENCE LCQ NR 9290304 AFT CABIN LT LATERAL SHEAR PLATE HAS A FEW SPOTS OF CORROSION. REMOVED AND REPLACED LT LATERAL SHEAR PLATE IAW SRM 51-72-11-911-001.SDR CALA2019030400355Plate · corrodedAFT CABIN LT FLOOR PLATE UNDER LATERAL SHEAR PLATE HAS EVIDENCE OF CORROSION A3NB-53-3-6222 PER LCQ NON ROUTINE 9290303 REMOVED AND REPLACED 1EA CORRODED AFT CABIN LT FLOOR PLATE UNDER LATERAL SHEAR PLATE IAW SRM 51-72-11-911-001.SDR CALA2019030400354Plate · corrodedAFT CABIN RT FLOOR PLATE UNDER LATERAL SHEAR PLATE AS EVIDENCE OF CORROSION A3NB-53-3-6222 PER LCQ NON ROUTINE 9290301 REMOVED AND REPLACED 1EA CORRODED FLOOR PLATE UNDER LATERAL SHEAR PLATE IN THE AFT CABIN IAW SRM 51-72-11-911-001.SDR CALA2019030400343Stringer · corrodedCORROSION ON FUSELAGE STRINGER IN AFT BULK CARGO COMPARTMENT FWD OF OUT FLOW VALVE AT FR65 STR 29R PER LCQ NR 9290370 REMOVED AND REPLACED STR31R IN AFT BULK CARGO FWD OF OUTFLOW VAL VE IAW SRM 51-72-11 BY MECH CORRECTION TO STRINGER THE CORRECT STRINGER IS 31SDR CALA2016120296013Structure · corrodedCORROSION ON FLOOR STRUCTURE Y-765 AT FR20. REPAIRED FLOOR STRUCTURE AT Y-765 AT FR20 IAW SRM53-11-15 FIG208.SDR CALA2016120296012Structure · corrodedCORROSION ON FLOOR STRUCTURE Y-1292 AT FR20. REPAIRED FLOOR STRUCTURE AT Y-1292 AT FR20 IAW SRM53-11-15.SDR CALA2016110495971Unknown · malfunctionedEMERGENCY EXIT LIGHTS STAY ON WITH POWER OFF. RESET LIGHTS, NOW OFF.SDR CALA2016050695346Skin · corrodedFOUND SIGNIFICANT EXFOLIATION ON FUSELAGE SKIN AT LAVATORY TANK VENT PORT, BETWEEN FRAME 69 & 70, BETWEEN STRINGER 31 & 32 RT. INSTALLED PERMANENT REPAIR IAW SRM 53-41-11.SDR CALA2015081894224Skin · dentedEXTERNAL FUSELAGE DENTED AT FRAME 29, STRINGER 39L. DENT OUT OF LIMITS, SO DAMAGE CUT OUT & EXTERNAL DOUBLER INSTALLED IAW PER SRM 53-00-11 FIG 239. IAW SRI 53-00-11-2-017-00 PARA 3L FIG 225, REPAIR NEEDS TO BE INSPECTED AT 60,000 CYCLES FROM TIME OF REPAIR SDR CALA2015012693022Unknown · leakingNUMBER 2 ENG OIL QTY SHOWING ZERO WITH PIL PRESS & TEMP GOOD. NR 2 ENG SHUTDOWN INFLIGHT. OPENED FAN COWLS & FOUND OIL RESIDUE COVERING EVERYTHING. WIPED UP OIL & RECHECKED AREA, OIL PUMP CONTINUING TO LEAK. SUSPECT OIL PUMP HOUSING FAILURE. ENG REMOVED DSDR CALA2014010890082Warning Message · activatedDURING TEST OF SYS IAW AMM 33-51-00-710-001-A, THE MESSAGE EPSU BATTERY EMERGENCY SHOWS ON THE PTP.SDR CALA2013122393878Stringer · corrodedAFT PIT STRINGER 38R AT FR 58 - 61 HAS CORROSION. INSTALLED STRINGER SPLICE REPAIR IAW SRM 53-00-13 FIG 201 SHEET 2.SDR CALA2013121693739Skin · dentedLT FUSELAGE SKIN HAS DENT 5 FEET BELOW COCKPIT SLIDING WINDOW & 4 INCHES ABOVE TAT SENSOR. FUSELAGE SKIN DENT IS CRACK FREE & WITHIN LIMITS IAW SRM 53-11-11-101 PG 127 DIA A02. FOUND DENT TO BE CREASED & OUT OF LIMITS IAW SRM 53-11-11, PG 103. FABRICATED SDR CALA2013121693719Structure · dentedFUSELAGE DENT FR 78 - 80 BETWEEN STRINGER 19L - 20L.SDR CALA2013121693718Stringer · corrodedFWD CARGO COMPARTMENT FRAME 33 - 34, STRINGER 42 RT HAS CORROSION. R & R STRINGER 42 RT BETWEEN STATION FRAME 31 & FRAME 34 IAW A320 SRM 53-21-13 & SRM 51-21-13.SDR CALA2013121293617Threshold · corrodedL-1 DOOR THRESHOLD HAS CORROSION AT FWD & AFT GIRT BAR PLATE ATTACH. REMOVED CORROSION AROUND GIRT BAR ATTACH HOLES, FWD OTBD HOLE WITHIN LIMITS, REAMED FWD INBD & AFT INBD & OTBD HOLES. FABRICATED & INSTALLED BUSHINGS IAW SRM 53-11-14 FIG 108. ACCOMPLISHEDSDR CALA2013121293618Threshold · corrodedR1 DOOR THRESHOLD HAS CORROSION AT FWD & AFT GIRT BAR PLATE ATTACH POINTS. REMOVED CORROSION AROUND GIRT BAR ATTACH HOLES, REAMED & FABRICATED BUSHINGS FOR FWD 4 HOLES & AFT 2 HOLES IAW SRM 53-14-11 FIG 108. ACCOMPLISHED HFEC FOR ALL AREAS IAW NTM 51-10-01 SDR CALA2013111392889Power Supply · failedESPU EMERGENCY FWD LT FAILED ON TEST. INSTALLED NEW ESPU FWD LT POSITION IAW AMM, TEST PASSED.SDR CALA2013110592651Lens · missingVIEWPORT FOR SLIDE PRESSURE GAUGE MISSING AT DOOR 1L. ACCOMPLISHED TEMPORARY REPAIR WITH CLEAR MYLAR TAPE. VIEWPORT LENS PCN 110-3639. REPLACED VIEW PORT LENS AS REQUIRED.SDR CALA2013092791533Panel · faultyNR 2 RADIO BLEEDS THROUGH THE FLIGHT INTERPHONE WHEN SELECTED. REPLACED NR 1 RMP. BITE TESTED OKAY.SDR CALA2013092391357Regulator · leakingCREW OXYGEN SYSTEM LOW. REPLACED O2 PRESSURE REGULATOR LEAKS CHECKED OK. NO DROP IN PRESSURE ON 20 MIN.SDR CALA2013092391371Seal · missingAIRFRAME VIBRATION INFLIGHT MORE NOTICEABLE IN REAR CABIN AREA. STARTED FL 280 MACH .79. ACCOMPLISHED MT 53-005 IAW TSM 05-50-00-810-801-A. NO NOTICEABLE PLAY IN RUDDER OR ELEVATORS. FOUND YELLOW HYDRAULIC BAY ACCESS PANEL 196BB LOOSE WITH PIECES OF SEAL SDR CALA2013080590123Switch · brokenPUSH TO TALK ON F/O SIDESTICK IS BROKEN OFF. REPLACED SIDE STICK IAW MM. OPS CHECKED IAW MM, OPS CHECKED GOOD.SDR UALA2013072605245Warning Light · illuminatedBCL 2, FAULT DISPLAYED ON UPPER ECAM SCREEN. REPLACED BCL2, IAW MM 24-38-34, OPS CHECKED GOOD.SDR UALA2013062804540Insulator · missingBMC2 TEST FAILED. MESSAGE RT WING LOOP "B" INOPERATIVE AFTER REPLACING "B" LOOP 79HF. REPLACED MISSING SOCKET INSULATOR, CONNECTOR AT 64HF REF AMM. BMC2 TEST NORMAL.SDR UALA2013062604467Wire Harness · inoperativeEMERGENCY LIGHT AT 11 ABC INOPERATIVE. REPLACED EMERGENCY LIGHT HARNESS. OPS CHECKED GOOD, IAW AWM 33-51-06.SDR UALA2013061804219Battery Pack · failedEMERGENCY LIGHT TEST FAILED. REPLACED BATTERIES AT EPSU LOCATIONS 12WL AND 11WL IAW AMM, OP TESTED OK.SDR UALA2013050703170Power Supply · not seatedDURING 2 SVC CHECK OF EMERGENCY LIGHTS EPSU INT LOAD EMER L. RESEATED LEFT OVERWING POWER SUPPLY TESTED OK PER MM.SDR UALA2013030401281Brake · wornBRAKES, HOT DISPLAYED ON UPPER ECAM SCREEN. . REPORTED LEFT OUTBOARD BRAKE TEMP WENT TO 445 DEG. F/A REPORTED ODD ODOR IN AFT CABIN. BRAKE WORN BEYOND LIMITS, REPLACED BRAKE.SDR UALA2013012800501Warning Message · illuminatedNR 1 ENGINE FUEL HEAT ECAM MESSAGE. TROUBLESHOT PER TSM 73-00 -00-810-809-B. INSPECTED FUEL DIVERTER RETURN VALVE. CLEANED AND RESECURED CONNECTORS. PER TSM HIGH POWER RUN TO BE ACCOMPLISHED TO ENSURE FAULTS EXIST OR NOT. NO FAULTS EXIST AFTER HP RUNS.SDR UALA2012120607062Placard · missingCREW REPORT: ARROW POINTING TO ARMED PIN AT DOOR 1L MISSING. PLACARD PCN 781-1826 ALREADY INSTALLED.SDR UALA2012110506353Tail Cone · crackedNR 1 ENGINE TAIL CONE CRACKED. EXISTING 4 INCH CRACK IN ZONE ONE OF NR 1 ENGINE TAIL CONE WAS STOP DRILLED CRACK HAS NOW MIGRATED A .5 OF AN INCH FORWARD. STOP DRILLED CRACK WITH 1-4" DRILL PER MM. TOTAL CRACK LENGTH IS NOW 5 INCHES.SDR UALA2012101105785Case · peelingNR 1 ENGINE AT 1130 POSITION LOOKS LIKE SKIN OF ENGINE IS PEELING AND A COUPLE OF RIVETS POPPED. PERFORMED INTERIM REPAIR PER ADVANCE REVISION MT78-14B 13SEP2012 AND ECRA 7830-02545.SDR UALA2012070503587Contactor · faultyON FINAL APPROACH, FLIGHT ATTENDANTS SMELLED A SMOKE ODOR BETWEEN OVERWING EMERGENCY EXIT ROW AND ROW 9. NO VISIBLE SMOKE, ONLY ODOR. FO ND DISPLAY INOP. CHATTERING BRAKES, LAX WILL SUPPLY EFS FOR ENGINE RUNS, FBO WORKING ITEMS. REF LOG 1 ON CHATTERING RELSDR UALA2012043002535Spring · failedNOSE GEAR RT LOCK SPRING IS UNSERVICEABLE REPLACE PER 3SVC AND MM 32-21-18. NOTE THIS RT SPRING WAS JUST INSTALLED 12-06-2011, FAILED IN 5 MONTHS OF USE. REPLACED RT NLG SPRING IAW AMM.SDR UALA2012022000970Battery Pack · dischargedEMERGENCY LIGHT SYSTEM WILL NOT TEST SUCCESSFULLY, GIVES EPSU BATT AFT L ATA 33-51-38 MESSAGE. REPLACE BATTERY PACK.SDR UALA2011122807132Lens · missingCOVER MISSING FROM EMER EXIT LIGHTS SEATS 2 AND 3. REPLACED LENS COVERS, ACCOMPLISHED TEST OF CABIN EMERGENCY LIGHTING OPS CHECKED NORMAL.SDR UALA2011120806740Epsu · inoperativeACCOMPLISHED SLIDE TEST ON BOTH FWD LT AND RT SLIDES, NO HELP. TEST FAULTS 'EPSU EXT LOAD FWD L' TROUBLESHOT PER TSM, NO HELP. CONTINUE WITH WIRING CHECKS PARA E. REPLACED EPSU 11WL AND BATTERY PER MM, SELF TEST NORMAL. DOORS 1L & 1R SLIDES WERE REMOVED FOSDR UALA2011120806752Spring · deformedRT NOSE GEAR DOWN LOCK SAFETY SPRING SHOWS SIGNS OF UNUSUAL DEFORMATION. THERE IS ONLY ONE WRAP HOLDING SPRING ON CLEVIS. REPLACED RT NOSE DOWN LOCK SPRING.SDR UALA2011092905283Rod · damagedAPU PERFORMANCE DETERIORATION. UPON APU REMOVAL AND FIRE WALL INSPECTION FOUND BAD ROD END AT LEFT UPPER OUTBD POSITION. REPLACED ROD ASSY.SDR UALA2011092305142Bleed Air Sys · malfunctionedAPU RUNNING BUT NO AIR PRESSURE. ACCOMPLISHED RESET OF APU BLEED WITH OUTBOUND FLT CREW AND ALL SYSTEMS OPS NORMAL, OK WITH FLT CREW TO CLEAR ITEM.SDR UALA2011091304954Shade · crackedSLIGHTLY CRACKED WINDOW BLIND ASSEMBLY. REPLACED WINDOW BLIND ASSEMBLY.SDR UALA2011072503774Warning System · false activationAVIONICS DOOR EICAS, RTFL. CLIMBING THRU 9000 FEET ECAM DOOR..AVIONICS DOOR DISPLAYED OPEN. WARNING EXTINGUISHED UPON LANDING. CONFIRMED DOOR CLOSED, OK TO CONTINUE.SDR UALA2011060902833Leaf Spring · out of adjustL FWD E/E ECAM, RTFL FOUND LEFT FWD EXIT HATCH COVER LOOSE. ADJUSTED LEAF SPRING. SECURED HATCH COVER, ECAM DOOR PAGE SHOWS NORMAL.SDR UALA2011050902277Starter · faultyCREW REPORT: DURING ENGINE START GND CREW SAW SPARKS FROM BOTTOM OF ENG 2 & HEARD CLANGING..NO VIB. SAMC TEXT: OPEN FAN COWLS PER MM AND INSPECT STARTER AND DUCT INSTALLATION PER MM. INSPECT INLET AND EXHAUST FOR ANY OBVIOUS DEFECTS. REPORT FINDINGS TO EMCSDR UALA2010012700326Fitting · leakingENG NR1 FOUND EXCESSIVE HYD & OIL FLUIDS COVERING BOTTOM OF ENGINE. REMOVED "WATERFALL" COVER FOR INSP OF LINES, FOUND POSSIBLE LEAK AT HYD LINE FITTING. WRENCH TIGHTENED HYD FITTING AT "WATERFALL". DRIED ALL EXCESS FLUID OFF OF ENG, DRY MOTORED ENG, NO NO
Back to N476UA