N803UA
Service difficulty reports · 97
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 = 'N803UA' 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 = 'N803UA' 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 CALA2013121293636Connector · looseNW STEER FAULT DISPLAYED ON UPPER ECAM SCREEN, WHEEL. 2 OCCURRENCES, RESET PROCESS APPLIED OK BUT THEN FAULTED AGAIN, ITEM ROLLED FORWARD. CFDS FAULT STEERING ELECTRO HYD MODULE 6GC, 6GC PCN 644-9554. CHECK ELECTRIC CONNECTOR ON 6GC FOR WATER CONTAMINATION.SDR CALA2013120593488Pump · leakingFOUND BIG PUDDLE OF OIL UNDER NR 2 ENG. SERVICED WITH 4 QTS OF OIL. RAN NR 2 ENG & FOUND A PIN HOLE SIZE STREAM OF OIL COMING OUT OF THE SIDE OF THE OIL PUMP ASSEMBLY. R & R OIL PRESS PUMP & FILTER ASSEMBLY IAW MM. OPERATIONS & LEAK CHECKED GOOD AT THIS TISDR CALA2013111492940Computer · faultyHORN SOUNDING, AVIONIC VENT SYS FAULT, NO DATA FROM AEVC. REPLACED AEVC IAW AMM, SYS OPERATIONS CHECKED NORMAL, FAULT CLEARED.SDR CALA2013102292273Actuator · faultyPACK 2 RAM AIR FAULTS. DUE TO REPEAT FAULTS ON AHM FOR PACK 2 RAM AIR OUTLET ACTUATOR. R & R THE PACK 2 RAM AIR OUTLET ACTUATOR FIN 29HH IAW AMM 21-61-52 PB401. IAW IPC 21-61-03-13A PCN 565-9028. TEMP CONTROL SYSTEM OPERATIONS CHECKED GOOD.SDR UALA2013041702635Battery · faultyESPU BATTERY FWD LEFT MSG ON CIDS PANEL. REPLACED BATTERY. OPS CHECKED GOOD.SDR UALA2012121907285Light · improper partCABIN SEAT ROW 12 LEFT HAS WRONG COLOR LENS INSTALLED. REMOVED AND REPLACED EMERGENCY LIGHT LENS WITH CORRECT COLOR (RED) AT SEAT ROW 12 LEFT EMERGENCY EXIT ROW.SDR UALA2012112906858Power Supply · no testLEFT EMERGENCY LIGHT SYS POWER SUPPLY IN CABIN NOT TESTING REF SMC2. REPLACED LEFT EMERGENCY LIGHT POWER SUPPLY.SDR UALA2012112906855Light · brokenFOUND AFT EMERGENCY OVERWING LIGHT 63WL BROKEN. REPLACED OVERWING AFT EMERGENCY LIGHT 63WL PER AMM.SDR UALA2012112906853Battery Pack · faultyAFT EMERGENCY LIGHT BATTERY FAULT. REPLACED BATTERY PACK BETWEEN DOOR 2, NO HELP. REPLACED SAME BATTERY, OPS GOOD.SDR UALA2012112806809Wire Harness · faultyTESTING EPSU 11WL GIVES FLASHING INT AND EXT LOADS FAULT LIGHTS. (REF SMC2) PER TSM 33-51-00-810-808-A SUSPECT OVERWING SLIDE. REMOVED AND INSTALLED LT WING SLIDE REF AMM 25-62-42-000-001-A & AMM 25-62-42-400-001-A, NO HELP. EMERGENCY LIGHT STILL SHOWS FAULTSDR UALA2012112906857Cable · faultyFOUND CON UNDER SEAT 26ABC ON SIDE WALL .5IN OFF CABIN FLOOR. CON REMOVED. REPLACED EEL CABLE AT SEAT 26ABC.SDR UALA2012102306074Wheel · vibrationNOSE LANDING GEAR VIBRATION DURING TAKEOFF ROLL. HEAVY VIBRATION ON TAKEOFF, LITTLE AT 70 KNOTS AND LOTS AT V ROTATION. REPLACED BOTH NLG WHEEL ASSY FOR REMOVAL AND REF 32-41-12-400- 001-A FOR INSTALLATION.SDR UALA2012082904858Tire · faultyHEAVY TIRE VIBRATION AFTER ROTATION UNTIL WHEELS STOPPED ROLLING IN WHEEL WELL. REPLACED BOTH NOSE TIRE ASSEMBLIES PER MM.SDR UALA2012080604191Apu · odorSMOKE ODOR IN COCKPIT, RETURNED TO FIELD. FLIGHT ATTENDANT REPORTED BOTH AFT LAV DETECTORS ALARMED. ODOR DISSIPATED AFTER LEVEL OFF AND THROTTLES RETARDED TO IDLE. LAV SMOKE DETECTORS STOPPED ALARMING AT THAT TIME. ODOR APPEARS TO BE COMING FROM VENTS. OPESDR UALA2011091504989Sensor · faultyAC CONTINUES PULLING RIGHT WHILE TAXIING. 3.2 UNITS OF RUDDER TRIM NEEDED TO KEEP STRAIGHT. REPLACED THE NOSE WHEEL STEERING FEEDBACK SENSOR (3GC) IAW AMM.SDR UALA2011090504788Tire · wornNOSE TRACKS TO THE RIGHT WHEN TAXIING. FOUND RT NOSE TIRE WORN AND LT NOSE TIRE ALMOST NEW. REPLACED RT NOSE TIRE PER MM.SDR UALA2011072203742Computer · faultyELAC 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. FLT CONTROL ELAC PITCH FAULT WILL NOT RESET PER SYS RESET. CIRCUIT BREAKER RESET NO HELP, ELAC 1 REPLACED: NO HELP, FAILS DURING FLT CONTROL CHECK WITH FAULT CODE "ELAC 1 COM OR WIRING TO L.B. ELEV SERVO 34CE3". SDR UALA2011042902106Servo · leakingLEFT SIDE SERVO ELEVATOR GREEN SYSTEM LEAK FROM BODY. REPLACED LT SIDE SERVO ELEVATOR ACTUATOR GREEN SYSTEM 34CE1 PER AMM, NO LEAKS AND ALL TESTS OKAY.SDR UALA2011041801885Sensor · faultyAFT CARGO DOOR ECAM, RTFL. SAMC TEXT: CONTACT SAMC, CFDS FAULT CODE 52-32-15. RE-OPEN DF702, AND PERFORM OVERWEIGHT CHECK PER MM. CREW REPORTS TOUCHDOWN WAS AT LESS THAN 360 FPM, WITHIN LIMITS OF MM. ACP'D OVERWEIGHT LANDING CHECK IAW AMM. CHECKED ALL. FOSDR UALA2011040101581Structure · delaminatedRT OVERWING ESCAPE SLIDE ENCLOSURE HAS CRACKS AND DELAMINATION ON TRAILING EDGE FLANGE. T/E FLANGE OF RT OVER WING SLIDE ENCLOSURE HAS 2EA CRACKED AND DELAMINATED AREAS. THE CRACKS ARE APPROX 6.5 INCHES IN LENGTH AND THE DELAMINATED AREAS ARE APPROX 10 INCHESDR UALA2011020800674Link · faultyFWD CARGO DOOR WILL NOT OPEN-CLOSE. REPLACED LINK THAT HOOKS TO HINGE ASSY ARM. AT LOWER POINT. OPS DOOR LATCHING OPERATION AND OPS NORMAL.SDR UALA2011010600101Light · inoperativeEPSU EXT LOAD EMERGENCY LIGHT FAULT DURING EMERGENCY LIGHT TEST. TROUBLESHOT PER TSM. REPLACED EPSU AND BATTERY 11WL, NO HELP REINSTALLED OLD UNIT. TEST ON PSU 11WL SHOWS RED LED FAULT EXTERIOR LIGHTS BUT ALL LIGHTS COME ON TEST ON 11WL.SDR UALA2010081602985Line · leakingDURING APU START FOR LEAK CHECK, SMALL FIRE FLARE UP AT AFT UPPER LUBE LINE, LOCATION HAS HEAVY COKING AROUND FITTING & UNDER HEAT BLANKET. NO DAMAGE FROM FLARE UP IN APU BAY, APU SHUTDOWN IMMEDIATELY. ACCOMPLISHED INSP OF APU BAY FOR DAMAGE, NO IRREGS NOTESDR UALA2010062302232Aspirator · failedDOOR SLIDE AT 2R HAS BAD ASPIRATOR WILL NOT STAY CLOSED. REPLACED DOOR 2R SLIDE ASSY.SDR UALA2010052401779Filter · dirtyOILY SMELL COMING FROM AIR CONDITIONING. APU INOPERATIVE DUE TO HISTORY OF OIL SMELL. ACCMP'D PACK BURNOUT AND REPLACED RECIRCULATION FILTERS. APU WAS A FULL RIP LSV AND JUST INSTALLED. CHECK FOR OIL IN BLEED DUCT. CHECK OIL LINE FROM OIL COOLER, LOP SWITCH, ESDR UALA2010050601531Apu · malfunctionedSTRONG ODOR THROUGHOUT PLANE WITH APU BLEED AND PACKS ON. APU BILLOWING SMOKE. CABIN HAS SMOKEY OILY ODOR. REPLACED APU PER MM. OPS CHECK GOOD.SDR UALA2009112003611Power Supply · faultyEPSU BATTERY AFT L MESSAGE. REPLACED AFT LEFT UNIT FOR UNIT FAULT. TESTS OKAY.SDR 2008UALA04283Fitting · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT FITTING CORRODED RT SIDE FRAME 59 UPPER FLANGE. ACCOMPLISHED MAJOR REPAIR AT LCQ-REO-L01099 AND RAS-DAHAM-4 025656-2008 ON NR K8546B AND INSPECTED.SDR 2008UALA04244Sill · corrodedR2 DOOR SILL HAS HEAVY CORROSION IN NUMEROUS LOCATIONS. MAJOR REPAIR ACCOMPLISHED: REPLACED SILL.SDR 2008UALA04246Skin · damagedDENT AND SCRATCH BEHIND NOSE GEAR AND JUST ABOVE YELLOW ANT. UNDER ACCESS DOOR. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2008UALA04245Skin · dentedFUSELAGE DENT LEFT OF FWD ELECTRONICS DOOR. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2008UALA04199Skin · dentedFUSELAGE DENT FWD OF FR 22 STR 24L. MAJOR REPAIR ACCOMPLISHED: REMOVED ADJACENT DOUBLER REPAIR. CUT OUT EXISTING DAMAGE. FABRICATED & INSTALLED EXTERNAL DOUBLER INCORPORATING ADJACENT REPAIR & CURRENT DENT CUTOUT.SDR 2008UALA04198Skin · damagedDENT - CREASE LT SIDE OF FUSELAGE FR 26 BETWEEN STRINGERS 39L & 38L. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED EXTERNAL DOUBLER REPAIR.SDR 2008UALA02267Packing · leakingLANDED WITH LOSS OF GREEN HYDRAULIC SYSTEM. FOUND PTU MANIFOLD CHECK VALVE LEAKING, O-RING FAILURE. REMOVED AND REPLACE PACKINGS ON VALVE, CKS OK NO LEAKS NOTED.SDR 2008UALA01421Microphone · shortedCREW REPORT: F/O O2 MASK IS INTERMITTENT. NO SOUND THROUGH SPEAKER. INTERMITTENT SHORT IN MIC. REPLACED MASK ASSY.SDR 2008UALA00716Oxygen System · low pressureOXYGEN NEEDS TO BE SERVICED. SERVICED O2 TO FULL, NO LEAKS WERE NOTED AT TIME OF SERVICE.SDR 2008UALA00485Oil System · leakingCREW COMMENTS: OIL SMELL IN CABIN, WORSE ONCE AIRBORNE. OIL LEAKAGE DUE TO BEARING FAILURE. SMELL WAS NEVER TRACED TO A PARTICULAR COMPONENT, HOWEVER THE NR 1 ENG WAS REPLACED DUE TO AN OIL LEAK AROUND 4TH STAGE IGV AT 6 O'CLOCK POS AND LEASE RETURN AGREEMESDR 2008UALA00161Seal · failedSTRONG OIL SMELL NOT ELECTICAL SMELL IN CABIN. RAN ENGINE TO PWR, WITH ONE BLEED AND ONE PACK AT A TIME. BURN OIL SMELL IS STRONGER WITH LEFT ENGINE BLEED. FOUND OIL IN EXTENSION SHAFT (NR 1 ENG). CLEANED OIL AND PERFORMED A PACK BURN AND INSTALLED BLIND CSDR 2007UALA04657Oxygen Bottle · reads lowTHE O2 BOTTLE AT 24C LOW. REPLACED THE LONG O2 BOTTLE UNDER SEAT 24C WITH A NEW ONE.SDR 2007UALA03260Battery · weak3 SERVICE CABIN EMERGENCY LIGHTING CHECK GIVES THE MESSAGE EPSU INT LOAD EMERGENCY LIGHT. FOUND WEAK BATTERY. REPLACED AFT LT EMERGENCY LIGHT BATTERY.SDR 2006UALA02032Power Supply · inoperativeAFT ENTRY DOOR EXIT LIGHTS INOPERATIVE. REPLACED EPSU. OPS CHECKED OK.SDR 2005UALA01524Engine · fireSMOKE AND FLAME COMING FROM NR 2 ENGINE WHILE IN REVERSE. THIS ENGINE HAS ACCUMULATED 20236 TSLSV(SINCE THE NUMBER 5 BEARING COMPARTMENT WAS ACCESSED). THE NUMBER (5) BEARING WAS NOT DPI'D AT THE PRIOR SHOP VISIT SO THERE IS A GOOD CHANCE THE BEARING/CARBON SDR 2002UALA01134Lavatory · leakingIMMEDIATELY AFTER TAKEOFF CREW NOTICED WATER LEAKING FROM THE AFT LAV. FLIGHT RETURNED TO SFO FOR REPAIR.SDR 2001UALA02384Computer · failedAFTER TAKE-OFF, HEARD A THUMP ON THE RIGHT SIDE OF THE AIRCRAFT. ELECTRONIC CENTRALIZED AIRCRAFT MONITORING WARNING - RIGHT WINDSHIELD HEAT & RIGHT WINDOW HEAT. SLIGHT ELECTRICAL ODOR. CIRCUIT BREAKER ANTI-ICE RIGHT WINDSHIELD POPPED. THE WINDOW HEAT COMPSDR 2000UALA00083Blade · separatedDIVERSION TO STL DUE TO N2 COMPRESSOR STALL AT FL350. AFTER PATCH WITH SAMC ALL AGREED TO NR 2 ENGINE SHUT DOWN AND STL DIVERT. AN AMBER ALERT WAS DECLARED AND EMERGENCY EQUIPMENT WAS REQESTED BY DISPATCH THROUGH STL TRACON. *S/D* A HPC 4TH STAGE BLADE FAISDR 99UAL900102Valve · failedRIGHT SIDE FUEL BURNING MUCH FASTER THAN LEFT SIDE. IN 2:30 FLT TIME, FUEL IMBALANCE BECAME GREATER THAN 300 LBS AND CAUSED A FUEL IMBALANCE ECAM WARNING. AT THAT TIME, THE XFEED VALVE INDICATED CLOSED. CROSSFEED VALVE FAILED OPEN. ECAM AND PB SWITCH BOTH SDR 99UAL900057Valve · malfunctionedFUEL TRANSFERRING FROM RT WING TANK TO LT WING TANK IN FLIGHT WITH CROSSFEED VALVE CLOSED. NO ECAM WARNINGS.
Back to N803UA