N823UA
Service difficulty reports · 135
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 = 'N823UA' 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 = 'N823UA' 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 CALA2017070702104Door Sill · corrodedR2 DOOR SILL HAS CORROSION THROUGHOUT. REMOVED CORROSION FROM R2 DOOR SILL FOUND TO BE OUT OF LIMITS IAW SRM 53-41-101-283-002 AND 51-74-00-001 REV 118. RECEIVED NEW R2 DOOR SILL AND INSTALLED R2 DOOR SILL IAW SRM 51 -72-11-911-001 REV 118.SDR CALA2017070702103Door Sill · corrodedR2 DOOR SILL LWR SHAPE SILL HAS CORROSION. REMOVED R2 DOOR SHAPE SILL CORROSION FOUND TO BE OUT OF LIMITS SRM 51-74-00-001 PAR6 REV 118, RECEIVED NEW SHAPE SILL AND INSTALLED IAW SRM 51-72-11-911-001 REV118.SDR CALA2017070702102Fitting · corrodedR2 DOOR SILL FWD & AFT CORNER FITTINGS HAVE CORROSION. REMOVED R2 DOOR FR66-FR68 CORNER FITTING FOUND TO BE OUT OF LIMITS IAW SRM 51-73-11-001 PAGE 6 PAR3 REV 118 RECEIVED NEW CORNER FITTINGS AND INSTALLED FR66-FR68 CORNER FITTINGS R2 DOOR IAW SRM 51-72-11-911SDR CALA2017063002016Attach Angle · corrodedAFT CABIN LEFT AFT SHEAR ATTACH ANGLE HAS CORROSION ON BOTTOM SIDE FRAME 70. REMOVED AND REPLACED ATTACH ANGLE IAW SRM 51-42-11, REV 118.SDR CALA2017050101226Bulb · inoperativeEPSU EXT LOAD EMERGENCY LIGHT MESSAGE ON CIDS PANEL WHILE ACCOMPLISHING EMERGENCY LIGHT TEST. REMOVED AND REPLACED THE FWD OVERWING SLIDE LIGHT BULB IAW AMM 33-5 1-15, OPS CHECKED GOOD. NO DEFECTS NOTEDSDR CALA2017050101225Battery Pack · no testOPS TEST OF EMERGENCY LIGHT SYSTEM. FOUND CIDS FAULT ON TEST. EPSU BATTERY FWD L FAULT ON TEST AND TROUBLESHOT. REMOVED AND REPLACED FWD OVERWING BULB IAW AMM 33-51-15, OPS CHECKED GOOD, REPLACED BATTERY, TESTED GOOD. PERFORMED IDT INSPECTION. NO DEFECTS NSDR CALA2017010600031Battery · dischargedEMERGENCY LIGHTS TEST FAILED AT PTP. REPLACED BATTERY AT 12WL EPSU REF AMM 33-51-38PB401. NOW OK FOR SERVICE.SDR CALA2016050495329Epsu · failedLEFT EPSU 11WL FAILS SELF-TEST. R & R EPSU 11W2 & BATTERY IAW MM 33-51-38-400-001-A. OPERATIONS CHECKED GOOD IAW MM 33-51-38-400-001-A SUBTASK 860-059-A.SDR CALA2015101594589Stop Fitting · crackedRIGHT AFT PAX CREW DOOR CUT OUT DOOR STOP FITTINGS AT FRAME 68 IS CRACKED IN WEB, FIRST FITTING UP FROM FLOOR OTBD UPPER HOLE. OVERSIZED OTBD UPPER HOLE OF R2 DOOR STOP FITTING AT FRAME 68 IAW SRM 53-41-12 PG 213 FIG 203. THIS SRM REFERS TO SRI53-41-12-2 -00SDR CALA2015101294586Stop Fitting · crackedRIGHT AFT PAX CREW DOOR CUT OUT DOOR STOP FITTINGS AT FRAME 68 ARE CRACKED IN WEB, FIRST FITTING UP FROM FLOOR INBD LOWER HOLE. REPAIRED IAW SRM 53-14-12-204.SDR CALA2015100594567Door Sill · corrodedRIGHT AFT DOOR SILL HAS CORROSION AT NUTPLATE HOLE FRAME 68. BLENDED CORROSION ON RT AFT DOOR SILL NUTPLATES HOLE FRAME 68, OUT OF LIMITS IAW SRM 53-41-14. REPAIRED AREA IAW SRM 53-41-14.SDR CALA2015100594566Door Sill · corrodedLEFT AFT DOOR SILL FRAME 68, CORROSION AT NUTPLATE HOLES. BLENDED CORROSION ON LT AFT DOOR SILL NUTPLATE HOLES FRAME 68, OUT OF LIMITS IAW SRM 53-41-14. REPAIRED AREA IAW SRM 53-41-14.SDR CALA2015091094284Switch · defectiveB RSVR LO LVL DISPLAYED ON UPPER ECAM SCREEN. LOSS OF HYDS SUSPECTED. REPLACED BLUE SYS LOW LEVEL SWITCH IAW AMM 29-12-41. TEST & LEAK CHECKED GOOD.SDR CALA2015070794067Slide · low pressureCREW REPORTED SLIDE PRESS AT 2L LOW. R & R SLIDE IAW 25-62-44-000-002-A & 25-62-44-400-006-A.SDR CALA2014122392861Hydraulic Line · leakingHYD Y ENG 2 PUMP LOW PRESS ECAM & YELLOW HYD LOW PRESS ECAM WARNINGS. OBSERVED YELLOW HYD QTY LOW. FOLLOWED QRH, SELECTED NR 2 ENG HYD PUMP OFF, PRESS & QTY STABILIZED. PERFORMED ENG RUNS, NO FAULTS ON ECAM FOUND HYD LINE IN RIGHT WW LEAKING. REPLACED LINESDR CALA2014030390504Actuator · out of adjustREVERSER FAULT DISPLAYED ON UPPER ECAM SCREEN WITH REVERSER INDICATION FLASHING AMBER. ENG 1 CREW COMMENTS ENG 1 REV ISOL FAULT, INOPERATIVE IAW MEL IAW PTT 3762002. HAD TO ADJUST LOCKING ACTUATOR TO GET SLEEVE TO LOCK OUT. SUGGEST REPLACING LOCK ACT & RIG ISDR CALA2014011390122Hose · damagedLEAK FOUND BELOW CHILLER UNIT AT LOWER PANEL, AT CHILLER DRAIN HOSE ATTACH FITTING. NEW CLAMP INSTALLED, NEEDS NEW HOSE, STILL LEAKS. REPLACED HOSE, LEAK CHECKED OK, REPLACED CHILLER, SUSPECT ICING IAW MM 25-34-51. OPERATIONS CHECKED OK, SECURED ALL PANELS.SDR CALA2013121393648Pump · failedENG FAILED 2 MINUTES AFTER START, NO OTHER INDICATIONS. ENG AUTO SHUTDOWN SEE PL 7436002 FOR REPLACEMENT OF NR 2 ENG LOW - HIGH PRESS FUEL PUMP. NR 2 ENG OPERATIONS & LEAK CHECKED GOOD.SDR CALA2013120393398Converter · inoperativeLT WINDSHIELD WIPER INOPERATIVE ANTI ICE. R & R CAPTAIN'S WIPER MOTOR CONVERTER IAW AMM, OPERATIONS CHECKED GOOD. AC UPGRADED TO CAT FULL CAPABILITY IAW 22-97-00.SDR CALA2013111492938O-Ring · damagedYELLOW SYS HYD LEAK AT AFT WALL MAIN WHEEL PTU MODULE. REPLACED O-RING ON THE YELLOW HYD SYS PTU MANIFOLD ASSEMBLY CHECK VLV, PN NAS 1612-20. SEE AIRBUS IPC 29-13-15-02A. LEAK CHECK YELLOW SYS PTU MANIFOLD ASSEMBLY, NO LEAKS FOUND.SDR CALA2013110892757Unknown · malfunctionedUNABLE TO COOL COCKPIT BELOW 86.SDR CALA2013110892756Control Panel · faultyVHF2 INOPERATIVE. REPLACED ACP & SWAPPED VHF2 TO VHF3 IAW TOMC. CREATED TWO DF ITEMS DF744 & DF745.SDR CALA2013110892762Relay · faultyENG 1 REV ISOLATION FAULT ECAM ON LANDING ROLLOUT AFTER THROTTLE WAS BACK TO FWD IDLE. HAD ECAM MSG "ENG 1 REV ISOL FAULT" 77-11-00 WITH CFDS MSG "TR SOV-HCU-EEC1" 78-37-00. TROUBLE SHOT IAW TSM 78-37-00-810-809-A 13, PER STEP 4A2 PG. 2. REPLACED THRUST RESDR CALA2013110792728Tail Cone · crackedCRACK ON TOP OF RT ENG TAIL CONE. CRACK MEASURES 3.75" & RUNS LENGTHWISE ADJACENT TO PREVIOUS WELD. ACCEPTABLE AS IS WITHOUT REPAIR IAW V2500 SRM 54-40.SDR CALA2013093091585Connector · defectiveAVIONICS VENT EXTRACT FAN 2HQ IS POPPED OUT ON GROUND, PANEL 123VU AT AE2. REPLACED CONNECTOR 1278VC IAW AWD 21-26-09. ACCOMPLISHED OPERATION TEST OK IAW AMM 21-26-00-710-008 NB STAYS CLOSED. OK FOR SERVICE.SDR CALA2013092391354Wire Harness · faultyLGCIU 2 SYSTEM FAULT MESSAGE. R & R LT MLG 2M HARNESS ASSEMBLY PN 201400005. IAW AMM 32-11-43-000-001A & -400-002A . PERFORMED OPERATIONS CHECKED CALLED OUT FOR IN AMM. ALL FAULTS CLEARED & LGCIU'S OPERATIONS CHECKED NORMAL.SDR CALA2013090991149Handle · brokenRAMP REPORTS MANUAL PUMP DOOR ASSIST HANDLE BROKEN. REPLACED CARGO DOOR MANUAL ASSIST HANDLE.SDR CALA2013090991147Connector · dirtyLGCIU 2 INOP - L-G. FOUND UNDER PFR TWO FAILURE MESSAGES LT LG EXT PROX SENSOR (23GA) & CHECK LGCIU 2 COMP SIGNALS. CLEANED CONNECTOR & SENSOR, RE-SAFTIED CONNECTOR & CYCLED Q35 CB. ALL MESSAGES ON UPPER ECAM CLEARED & ACP GROUND SCAN & BITE ON LGCIU 2, BOTSDR CALA2013082090598Receptacle · damagedFOUND CREW OXYGEN SYSTEM FILL PORT DAMAGED. REPLACED CREW O2 FILL PORT PER MM, OK FOR SERVICE.SDR CALA2013081990517Warning Light · no testNR 2 ENGINE, AGENT 1 SQUIB LIGHT DOES NOT TEST. LIGHT IS GOOD. OPENSDR UALA2013072405215Connector · unsecureFWD CARGO DOOR OPEN ECAM OCCURRED TWICE. CABIN PRESSURE INDICATIONS NORMAL. FOUND CONNECTOR FOR DOOR INDICATION AT LOWER FWD CARGO DOOR SILL LOOSE. SECURED AND CLAMPED. OPS CHECKED NORMAL.SDR UALA2013071905096Sleeve · burnedCARBON FIBER PEELING ON LOWER PORTION OF NR 1 ENGINE. NR 1 ENGINE SLEEVE HAS APPROX 1.25 X 4.0 INCHES BURNED AREA WITH NO SKIN MISSING MATERIAL, REPAIRED REF MT78-024.SDR UALA2013070304647Sleeve · delaminatedFOUND LT TRANSLATING SLEEVE LOWER AFT T/E SKIN DELAMINATING . APPLIED 2 LAYERS OF TAPE WITH 1.5" OVERLAP IAW PART 1 OF ECRA 7830-02658.SDR UALA2013061804230Door · out of adjustO2 MASKS DROPPED ROW 24 DEF. REPACKED MASKS BUT LATCHES STILL RELEASE WHEN JARRED. NEED MORE TIME TO TROUBLESHOOT. SEATS ARE NOT USEABLE. ALIGNED AND ADJUSTED DOOR AND MASKS. TESTED MASK RELEASE IAW AMM. TESTED NORMAL.SDR UALA2013052303586Oxygen Mask · leakingCAPTAIN`S O2 MASK LEAKS. SWAPPED MASK WITH SECOND OBSERVER'S. MASK DOES NOT LEAK WHILE STOWED. R & R O2 MASK.SDR UALA2013051403344Contact · damagedEVACUATION ALARM CHIRPS DURING POWER TRANSFERS. REPLACED GEN LINI CONTACT OR 9-XU2, TESTED OK.SDR UALA2013041902715Computer · failedFLAP SYSTEM 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. INSTALLED NEW UNIT IN POS 1. IAW MM27-51-34. BITE AND OPS TESTED OK. ACCOMPLISHED LAND TEST.SDR UALA2013041702636Visor · looseCAPTAIN'S INTERIOR SUN VISOR DEFECTIVE. REPLACED CAPTAIN`S SUN VISOR, OPS CHECKED GOOD.SDR UALA2013031101408Rub Strip · looseLEFT OUTBOARD FLAP HAS RUBSTRIP COMING UP AT MIDSPAN IN TWO PLACES APPROX 8 INCHES LONG. PERFORMED INTERIM REPAIR PER SRM 57-53-11.SDR UALA2013030701366Shock Absorber · lack of lubeGRINDING SOUND COMING FROM NOSE WHEEL AREA. LUBRICATED NLG SHOCK ABSORBER PER MM, OPS CHECKED NORMAL.SDR UALA2013020500698Actuator · out of adjustAIRCRAFT FLYS 3 DEG LEFT BANK RUDDER .5 LEFT IN LEVEL FLT, 300 KTS, 5 DEG LEFT BANK AT 320 KTS. ADJUSTED OF RUDDER TRIM ACTUATION IAW AMM 27-22-00-820-001-A AND ADJUSTED OF RUDDER POSITION INDICATING IAW AMM27-25-00-820-001-A.SDR UALA2012121007144Unknown · malfunctionedEFCS OP TEST STBY PWR SP, ACCOMPLISH OPERATIONAL CHECK OF THE LOGICS ACTIVATING, ELAC 1, ELAC 2 AND SEC 1 STANDBY POWER SUPPLY, TO CONFIRM THE ABILITY OF SEC 1 AND SEC 2 TO ACHIEVE PITCH CONTROL, TO CONFIRM THE ABILITY OF SIDESTICK PRIORITY FUNCTION, PER MM SDR UALA2012082004607Power Supply · faultyEMERGENCY LIGHTS TEST SHOWS FAILURE WITH EPSU L FWD MESSAGE. REPLACED EMERGENCY LIGHTS POWER SUPPLY UNIT AT LEFT EMERGENCY EXIT WINDOW AREA & OPS CHECKED OKAY.SDR UALA2012052903009Bushing · missingNR 1 ENGINE, LT THRUST REVERSER, NR 1 (TOP) BLOCKER DOOR MISSING 2 BUSHINGS THROUGH BLOCKER DOOR SPRING. REPLACED BUSHINGS AND HARDWARES PER MT 78-011 ON WU P4439G. OPS CHECKED GOOD.SDR UALA2012052903008Spacer · missingNR 1 ENG, LT THRUST REVERSER, NR 2 (FROM TOP) BLOCKER DOOR MISSING 2 BUSHINGS THROUGH BLOCKER DOOR SPRING. REPLACED SPACERS AND BUSHINGS PER MT 78-011 ON WU P4440G.SDR UALA2012052903007Bolt · faultyNR 1 ENGINE, THRUST REVERSER, NR 3 (FROM TOP) BLOCKER DOOR MISSING 2 BUSHINGS THROUGH BLOCKER DOOR SPRING. REPLACED BOLT AND SPACERS AND BUSHINGS PER MT 78-011 ON WU P4441G.SDR UALA2012030501410Sliding Window · defectiveCAPTAIN'S SIDE WINDOW IS TOO HOT TO TOUCH. CAPTAIN'S SIDE WINDOW IS TOO HOT TO TOUCH, IT IS NOTICEABLY HOTTER THAN F-O SIDE AT CRUISE. CAPTS SLIDING WINDOW CREW STATED THAT THEY ALSO HAD A BURNING SMELL WITH THE OVHT. RPLC'D LEFT SLIDING WINDOW. REPLACED WSDR UALA2012012400497Acoustic Liner · tornTEMP REPAIR OF NR 1 ENG ACOUSTIC LINER IS PEELING BACK AND COMING OFF. RE-SECURED TAPE REF MT 78- 010, SEE CF405 FOR INTERIM REPAIR. NR 1 ENGINE ACOUSTIC LINER INBOARD AFT OF REVERSER HAS TORN PROTECTIVE LINER. FOUND APPROX 900 SQ OF SCREEN MISSING. PER MTSDR UALA2011110305972Compressor Blade · out of limitsENG 1 FAN BLADE TAP TEST OUT OF LIMITS AT ONE BLADE. DURING NR 1 ENGINE FAN BLADE TAP INSPECTION FOUND ONE COMPRESOR FAN BLADE OUT OF LIMITS. VALUE OBTAINED 1880 DB SEC. REPLACED FAN BLADE NBR 9 PER AMM AND ACPD FAN BLADE REDISTRIBUTION AS PER ENG CONTROLLERSDR UALA2011083104669Idg · failedNR 1 IDG FAILURE & APU AUTO SHUTDOWN, RTFL. NR 1 ENG IDG LO OIL PRESS DISPLAYED, IDG DISCONNECTED. APU GEN POWERING NORMALLY. REPLACED IDG ON NR 1 ENG AND REPLACED APU LOW OIL PRESS SWITCH. AFTER IDG CHANGE, RAN ENGINE AND HAD 0 FREQ AND 0 VOLTS. SWAPPED
Back to N823UA