N796UA
Service difficulty reports · 193
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 = 'N796UA' 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 = 'N796UA' 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 UALA2012011000221Oven · overheatedGALLEY OVEN BECAME VERY VERY HOT AND SHUTDOWN. CIRCUIT BREAKER DID NOT TRIP. REPLACED OVEN.SDR UALA2012010300008Control Unit · failedFUEL SPILL RT MAIN TANK SHUTOFF FAILED FUEL IN TANK NOW 67.6. REPLACED INBD RT WING REFUEL VALVE PER MM. OPS AND LEAK CHECKED GOOD AND VTO CHECKED NORMAL.SDR UALA2011122107046Starter · faultyAPU WILL NOT START AFTER 3 TRIES APU ON STATUS PAGE. REPLACED APU STARTER TO CORRECT, OPS CHECKED NORMAL.SDR UALA2011121606920Display · inoperativeCAPTAIN'S INBD DISPLAY BLANK. REPLACED DISPLAY UNIT PER MM.SDR UALA2011121206803Switch · malfunctionedFLT CREW STAB TRIM PICKLE SWITCHES INTERMITTENT, DID NOT TRY MANUAL. LATER IN FLIGHT PICKLE SWITCHES OPS NORMAL. TRIM INDICATOR REMAINS FROZEN. REPLACED CAPT'S PITCH TRIM SWITCH.SDR UALA2011112106403Stowage Box · crackedROW 37 OXYGEN MASK DEPLOYED. DUE TO OVERHEAD BIN AT SEAT 37CDE HINGE BROKEN, IT CRACKED THE O2 MASK COMPARTMENT DOOR. COMPARTMENT DOOR HAS BEEN TAPED CLOSED. REPLACED BOX.SDR UALA2011112106408Warning System · false activationSTATUS MESSAGE BLEED FAMV R. AHM SHOWS IN ADDITION TO MSG 36-10340, MSG 36-10532 FOR RVDT CIRCUIT OPEN OR SHORTED. REPLACED VALVE PER MM. NO HELP, REACTIVATED FAMV, AIR SUPPLY CONTROL SYS TEST PASSED ON MAT & ENG AIR SUPPLY TEST FOR FAMV NORMAL & MSG CLEAREDSDR UALA2011111506245Ace · malfunctionedFLT CTL SYS STATUS MSG. FOUND CB 'BATT INTLK' OPEN ON FACE OF PSA RIGHT, RESET AND TRIPPED AGAIN. PCN 566-9015. ACCOMPLISHED TROUBLESHOOTING PER MAINT MESSAGE 27-15102 FIM 27-02 TASK 851, FOUND ACE R M 27221 CAUSING CB D8-R AT POWER SUPPLY RIGHT M24201 POPPSDR UALA2011111006144Computer · faultyPER A CHECK JC 2-2020B, MAINT MESSAGE REVIEW FOUND MAINT MSG 27-14008 PFC (CTR) LANE 3 HAS A FAULT HAS OCCURED MORE THAN ONCE IN LAST 5 FLT LEGS. :T/S PER FIM27-02 TASK 937, LANE WON'T RESET, TRIED NEW PFC BUT INCOMPATABLE OPS SOFTWARE INSTALLED, CAN'T DATA LSDR UALA2011110906113Float Valve · faultyK SCAVENGE SYSTEM FAILED THE HIGH LEVEL OUTLET FLOAT TEST. DURING TEST FUEL MOVED FROM THE CTR TO THE RIGHT MAIN TANK AT A RATE OF 100 LBS PER 12 MIN. REF CH2149 AND MM. REPLACED SCAVENGE LINE AND FLOAT VALVE. SCAVENGE TEST PASS.SDR UALA2011110906112Probe · faultyPER A CHECK JC 2-2020B MAINT MESSAGE REVIEW FOUND MAINT MESSAGE 75-40802 TCA THERMOCOUPLE PROBE (R ENG,CH A) SIGNAL IS OUT OF RANGE HAS OCCURED MORE THAN ONCE DURING LAST 5 FLT LEGS. REPLACED NR 2 ENG TCA THERMOCOUPLE PROBE.SDR UALA2011110706039Actuator · faultyFOUND STS MSG APU DOOR, APU STILL WORKING, INLET DOOR FULLY OPEN. REPLACED APU DOOR ACTUATOR.SDR UALA2011110706008Valve · faultyFUEL IMBALANCE OF 1400LBS BETWEEN MAIN TANKS 5 HRS INTO FLIGHT. LT 64.0 AND RT 65.4 AND CENTER TANK FUEL STILL BEING BURNED. ENGINE FUEL FLOW EVEN BETWEEN ENGINES THROUGHOUT FLT INFORMATION ONLY FROM CREW DUE TO FUEL IMBALANCE HISTORY. ACCOMPLISHED SCAVENGESDR UALA2011110305961Apu · malfunctionedUPON ARRIVAL APU OIL AT 1.3 WITH APU RUNNING. AFTER SHUTDOWN QTY TO 0.0. SIGHT GAUGE SHOWS NO OIL IN APU . SVC OIL. CHECK FOR LEAKS. NO LEAKS NOTED. APU QTY NOW READS 7.2. APU STARTS NORMALLY. APU QUICK INSPECTION SHOWED NO OBVIOUS LEAKS EXTERNALLY OR TAISDR UALA2011101005487Sensor · failedFLAP-SLAT SKEW SENSORS FAILURE OF ONE OR MORE SLAT AND-OR FLAP SKEW DETECTION SENSORS.SDR UALA2011091605018Control Valve · faultyPRIMARY FLAPS FAIL EICAS THIRD FLIGHT IN A ROW SYSTEM GOES ALTN FLAP. SAMC TEXT: PLZ ACP MT27-001R1. T/S PER 777MT 27-011 R1. FOUND FLAP PCV CONNECTOR DV27004B PIN 5-12 LOOP IS OPEN. REPLACED FLAP PCV, LEAK CHECK OK & FLAP OPS CHECK NORMAL PER MM.SDR UALA2011091605017Fseu · faultySTATUS MSG FLAP PRIMARY MSG 27-20372. REPLACED FSEU 2 PER MM, OKAY.SDR UALA2011080804145Float Valve · unsecureFUEL IMBALANCE. FUEL SYSTEM IS CONTINUALLY BEING WRITTEN UP FOR FUEL IMBALANCE. THE SCAVENGE SYSTEM HAS BEEN CHECKED ON CH1904 WITH NO FAULTS FOUND, PLEASE ACCOMPLISH A REFUEL-JETTISON & FUEL FEED MANIFOLD LEAK TEST WITH REFERENCE TO MM. IF REQUIRED MM FOR CSDR UALA2011080304030Pump · malfunctionedFUEL IMBALANCE ADVISORY. ACCOMPLISHED SCAVENGE SYS AND FQPU PER MM AND MT 28-008 R2. NO STATUS AND NO ADVISORY MSG FOUND AND NO EXISTING FAULT ON ARR. REMAINING FUEL ON ARR- 11.4 LT AND 12.1 RT. GROUND CHECKED OK.SDR UALA2011071103416Unknown · malfunctionedELEC STANDBY SYS ELECTRICAL DC-STANDBY POWER SYSTEM FAILED THE SYSTEM SELF-CHECK. MTC MSG24-13783,24-13037. ACFT REPOWERED. CHECKED RELAY K24013 IN P210. NO ABNORMAL DEFECT NOTED. STATUS MSG DISAPPEARED AND FUNCTION CHECKED OK PER FIM24-32 TAS K802.SDR UALA2011070503331Chip Detector · separatedAPU LEAKING OIL ON GROUND. FOUND CHIP DETECTOR ASSY ON LOWER GEARBOX SEPARATED FROM ADAPTER ASSY. REPLACED CHIP DETECTOR ASSY. RAN APU AND NO LEAKS NOTED.SDR UALA2011070503330Oven · malfunctionedOVEN R-32 STARTED SMOKING. F/A T-SHUT OVEN DOWN. SMOKE STOPPED. CLEANED OVEN RAN 30 MIN, NO SMOKING AT THIS TIME TEMP HOLDS 350 DEGREES.SDR UALA2011042101924Valve · faultyDURING FUELING OPERATION, FOUND FUEL SEEPING FROM LT JETTISON VALVE. VALVE DEF IN CLOSED POS PER MEL. CB COLLARED. NO FUEL NOTED. PER MEL FUEL TANK ENTRY REQUIRED THROUGH ACCESS PNL 543AB. 2-3 SHIFT SLOT FOR TANK ENTRY RQSTD VIA RQSLOT. VALVE AND ACTUATOSDR UALA2011041901894Rotary Actuator · faultyRT LEADING EDGE KRUEGER FLAP JUST INBOARD OF NR 2 ENGINE STUCK PARTIALLY EXTENDED. SUSPECT ROTARY ACTUATOR FAILED PCN 120-9025 (IF REPLACEMENT REQUIRED). RUN SLATS, FOUND RT KRUEGER ROTARY ACT AT FAULT. REMOVED LOWER PNL 611PB FOR ACCESS. REPLACED RT WING SDR UALA2011032101356Light · inoperativeONE EA SEAT MOUNTED EMERGENCY EXIT LIGHT IS INOP AT SEAT 2E. REPLACED LIGHT ASSY, OPS CHECKS GOOD.SDR UALA2011021100747Apu · leakingOIL ODOR IN CABIN. DUE TO OIL ODOR IN CABIN BOROSCOPE APU LOAD COMPRESSOR AND LOOK FOR SIGNS OF OIL LEAKAGE. ACCOMPLISHED BOROSCOPE INSPECTION OF APU LOAD COMPRESSOR. EVIDENCE OF OIL LEAKAGE AND COKING. REPLACED NR 2 ENGINE, APU, LT ACM AND LT HEAT EXCHANGERSDR UALA2011020700652Bearing · leakingHOT OIL ODOR IN CABIN. FOUND EVIDENCE OF OIL LEAKAGE FROM NR 1 BEARING IN SPINNER CONE AND A LIGHT AMOUNT OF OIL AT 6 O'CLOCK POSITION OF FAN INLET. REPLACED ENGINE.SDR UALA2011020300586Oven · contaminatedCREW REPORTED PLASTIC BURNING ODOR FROM WARMING OVEN R13. FOUND PLASTIC BURNED ODOR FROM INSIDE OF R13 WARMING OVEN. CLEANED THIS OVEN INSIDE AND CHECKED OK. NO ELECTRICAL ODOR FOUND.SDR UALA2011012400371Audio Panel · inoperativeCAPTAIN'S LT VHF SPEAKER SWITCH IS INOPERATIVE, REQUIRES NEW PANEL. REPLACED LT VHF AUDIO PANEL IAW MM. OPS NORMAL.SDR UALA2011010700124Wire Harness · inoperativeSEAT 2F BOTH EMERGENCY LIGHTS INOP. REPLACED EMERGENCY LIGHT SEAT HARNESS. CHECKS OKAY.SDR UALA2011010700123Smoke Detector · inoperativeLAV AT DOOR 2L SMOKE DETECTOR INOPERATIVE. REPLACED SMOKE DETECTOR PER MM, TESTS OKAY.SDR UALA2011010700122Connector · looseEMERGENCY LIGHT INOPERATIVE FWD POSITION SEAT 2E. SECURED LIGHT ASSY CONNECTOR, TEST OKAY.SDR UALA2011010300038Idg · failedLEFT GENERATOR SYSTEM IDG HAS DISCONNECTED OR A PROTECTIVE TRIP OF THE GENERATOR CONTROL BREAKER HAS OCCURRED OR A PROTECTIVE TRIP OF THE BTB HAS OCCURRED. STATUS MSG01-LATCHED CRUISE MODE DEPENDENT; INTEGRATED DRIVE GENERATOR (LT) FREQUENCY IS LOW. DB-GENERASDR UALA2010120804481Actuator · leakingFUEL LEAKING OUT OF LEFT FUEL DUMP MAST. STREAM IS DIAMETER OF PENCIL. PERFORMED TESTED FUEL FUEL JETTISON SYS PER MM. FOUND NO MORE FUEL LEAK FROM JETTISON NOZZLE VALVE. NEED MORE RED PER MEL. DEACTIVATED FUEL JETTISON NOZZLE VALVE TO CLOSE POSITION PER MEL SDR UALA2010110904163Actuator · leakingNR 1 ENGINE VARIABLE STATOR VANE ACTUATOR FUEL IS LEAKING FROM DRAIN MAST. INSTALLED SVA UP TO 3H(1)G (ATTACH THE GROUND CABLE TO STATOR VANE ACTUATOR). REPLACED SVA PER MM.SDR UALA2010091403423Wire · damagedABORTED TAKEOFF AT 60 KNOTS DUE TO WING BLEED VALVE & SPOILER DEP MESSAGE. REPLACED BROKEN DUCT & DAMAGED WIRES. ACCOMPLISHED TIME LIMITED REPAIR PER UA-EVA-80111. PERMANENT REPAIR ACCOMPLISHED RR39 221 SHOP 273. INSTALLED ON WU J9108Q.SDR UALA2010042801420Power Supply · faultyEMERGENCY LIGHTS WON'T TEST, ROWS 31 THRU 43. THIS SEAT GROUPS BLOW FUSE IN THE POWER SUPPLY M33401 LOCATED IN DR 3R OVER DOOR PANEL. ISOLATED SEAT ROWS 31 THRU 35 ARE GOOD AND THE PROBLEM IS 36 AND OR BEYOND. THE BAD AND NEW POWER SUPPLIES IN RE OFFICE. PSDR UALA2010041501266Light · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT SEAT 2E. REPLACED EMERGENCY LIGHT. OPS CHK NORMAL.SDR UALA2010040601155Battery · failedBATT CHARGER APU, APU BATTERY CHARGER FAILURE. REPLACED BATTERY AND BATTERY CHARGER, GROUND CHECK NORMAL.SDR UALA2010032601013Light · inoperativeSEAT 1E FWD EMERGENCY LIGHT INOPERATIVE. REPLACED SEAT 1E FWD EMERGENCY LIGHT ASSY. EMERGENCY LIGHT OPS CHECK GOOD.SDR UALA2010032601012Light · inoperativeF-C PAX SEAT 3F FWD EMERGENCY LIGHT ASSY INOPERATIVE. REPLACED PAX SEAT EMERGENCY LIGHT ASSY AND OPS CKD ALL GOOD.SDR UALA2010022500695Fuel Control · faultyLEFT ENG FUEL CUTOFF SWITCH RED WARNING LIGHT WILL NOT TEST. SWITCH SHIPPING FROM LHR. REPLACED LEFT ENG FUEL CONTROL MODULE AND PERFORMED THE RELATED TEST. TEST PASSED AND INDICATION NORMAL.SDR UALA2010011900232Cover · brokenSEATS 37CDEFG PASSENGER OXYGEN MASK PANEL COVER IS BROKEN. NEEDS PANEL DOOR SEATS NOT USEABLE. REPLACED O2 BOX ASSY.SDR UALA2009122303986Inlet · gougedNR 2 ENG INLET WAS GOUGED AND SCRATCHED AT THE 4:30 POSITION WHEN THE FLIGHT CREW TAXIED INTO A BREAKAWAY STOP SIGN.SDR UALA2009120203714Connector · dirtyON ENGINE START LEFT ENG N1 JUMPS TO MORE THAN 80 PERCENT CAUSING TAKEOFF WARNING TO SOUND WITH CONFIG WARNING FOR 2 SECONDS. UPON ARRIVAL CREW REPORTED THIS IS REPEAT OCCURRENCE (HIT LAX-891-29NOV), AT ENG START AS SOON AS N1 JUST BEGINS T O ROTATE, N1 IND JSDR UALA2009110903509Connector · looseEMERGENCY EEL LIGHTS AT 1E INOP. FOUND CONNECTOR LOOSE. SECURED LIGHTS, CHECK NORMAL.SDR UALA2009100703149Battery · dischargedDOOR THREE LEFT EXTERIOR EMERGENCY LIGHT INOP. REPLACED BATTERY POWER ASSY ABOVE DOOR 3L. OPS CHECKED GOOD.SDR UALA2009100103087Idg · malfunctionedON TAXI OUT, RT ENGINE GEN DRIVE LIGHT ILLUMINATED AND RT GEN OFF LIGHT ILLUMINATED, SHUT DOWN ENGINE. RESTART ENG AND RIGHT GEN DRIVE LIGHT ILLUMINATED, GEN NOT POWERING BUS. DISCONNECTED RIGHT IDG. FOUND DELTA P POPPED. NO CONTAMINATION TO EXTERNAL OIL CSDR UALA2009082402630Gcu · faultyELEC GEN OFF L LEFT GENERATOR CONTROL BREAKER (GCB) OPEN OR GENERATOR CONTROL SWITCH OFF AND ENGINE NOT SHUT DOWN. ADVISORY CREW COMMENTS: ELEC GEN OFF L WON'T RESET MSG-2430031 LATCHD ER MODE REPLACED GCU, NO HELP. REPLACED IDG, ALL OPS NORMAL NOW.SDR UALA2009060101560O-Ring · brokenFUEL LEAK FROM NR 1 ENGINE. REPLACED FUEL PUMP FILTER ELEMENT SEAL ASSY. PERFORMED LEAK CHECK ALL OK.
Back to N796UA