N797UA
Service difficulty reports · 153
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 = 'N797UA' 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 = 'N797UA' 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 UALA2011052602579Module · faultyCOCKPIT ENTRY & REST AREA LIGHTS FLICKER. REPLACED FAILED ZMU 1 PER MM. SYS CHECKS GOOD.SDR UALA2011052302502Transceiver · faultyRIGHT WX RADAR WILL NOT TEST OR WORK. LEFT RADAR IS FINE. REPLACED RIGHT WX RADAR TRANSCEIVER, OPS CHECK OKAY.SDR UALA2011051202358Precooler · crackedNR 1 ENG PRECOOLER CRACKED, BLEW APART 2 INSULATION BLANKETS. HAVE PRECOOLER PLANESIDE. WILL START PRECOOLER RPL AFTER 'A' CHECK IS COMPLETED. BLANKETS EST 0930.SDR UALA2011051202357Oxygen Mask · defectiveFIRST OFFICER O2 MASK COMM INOP. REPLACED PER MM.SDR UALA2011040601653Seal · damagedON WALK AROUND SECTION OF DAMAGED SEAL, LESS THAN 10 PERCENT. REMAINING SEAL SECURE AND RESEALED ENDS WERE DAMAGED REMOVED. PART INF (PCN 120-2870). NIL STOCK IN SYSTEM. LOOKED FOR SEAL MATCH AT SMB NOTHING FOUND NEED 120-2870. MF7133 CREATED TO MONITOR. UPONSDR UALA2011040401599Module · faultyWASTE SYSTEM FAILURE, FLIGHT DIVERTED. RPL LOGIC CONTROL MODULE FOR NR 1 WASTE TANK PER MM. RPL DOOR 3 FWD TOILET ASSY PER MM. FOUND FAULT MESSAGE 38-110 00 AND REPLACED I-O CARD M24400A. LATCHED MESSAGE CLEARED.SDR UALA2011040101571Blade · chippedNR 1 ENG ONE EACH BLADE L/E TIP CHIPPED (SIX O'CLOCK POSITION). BLADE HAS PIECE MISSING AROUND .093 DEEP AND .156 LONG, BLADE IS OUT OF LIMITS PER MM. TALKED TO OPBEMC, BLADE OUT OF LIMITS. REPLACED DAMAGED BLADE PER EG 5443-1. REMOVED DAMAGE BLD S-N CBDUSDR UALA2011011900334Shutoff Valve · malfunctionedCREW REPORT: ACFT DEVELOPED 4000 LB FUEL IMBALANCE IN 9HRS FUEL USED EQUAL. REPLACED RT MAIN TANK FLOAT-OPERATED SHUTOFF VALVE. COMPLETED FUNCTIONAL TEST IAW MM. FOUND NO TRANSFER OF FUEL.SDR UALA2010122204688Idg · failedRIGHT ENG GENERATOR FAILURE, FLIGHT DIVERTED. APPLIED MEL 2411A, RIGHT IDG DISCONNECTED. MEL STATES IDG OIL SHOULD BE CHANGED WHEN DF ITEM IS CLEARED. REPLACED NR 2 IDG PER MM, OPS NORMAL.SDR UALA2010121604591Switch · faultyPACK FCV L ONE (BUT NOT BOTH) OF THE 2 LT PACK FLOW CONTROL VALVES (FCV) ARE NOT IN THE COMMANDED POSITION. STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; FLOW CONTROL VALVE PROXIMITY SWITCH FAILED. DB- CABIN TEMP CONTROLLER (L CHAN2) MSG02- LATCHED CRUISE MOSDR UALA2010110304094Tube · leakingNR 2 ENG HOC. OPENED ENGINE, OIL LEAKAGE CKD. FOUND THE MAIN GEARBOX OIL PRESSURE TUBE LOCKPLATE LOOSENED, RETIGHTENED BOLTS AND TUBE CKD OK. RAN ENGINE, NO LEAKAGE FOUND. CKD OIL QUANTITY BY EICAS, SHOWS NORMAL. TUBE ASSY REF IPC 79-21. BOLT REF IPC. RASDR UALA2010091403414Control Unit · defectivePDCU L LT PANEL DATA CONCENTRATOR UNIT (PDCU) IS FAULTED. REPLACED THE DEFECTIVE PDCU. OPS ARE OK.SDR UALA2010091003355Charger · faultyAPU WILL NOT START. REPLACED APU BATTERY, NO HELP. APU WILL NOT START ELECTRICALLY OR PNEUMATICALLY, APU FAULT LIGHT STAYS ON WITH APU STATUS MESSAGE. APU BATT DROPPED TO 7VOLTS WITH 173 AMP DISCHARGE, NO RPM INDICATED WITH EITHER ELEC OR PNEU START. REPLACEDSDR UALA2010082303085Actuator · faultyPASS O2 AT 34CDEF INOPERATIVE. DOOR RELEASE MECHANISM PROBLEM. REPLACED LATCH.SDR UALA2010072802720Lens · missingDR 2L AFT EMERGENCY EXIT LIGHT LENS MISSING. LIGHT ASSY AFT DOOR EDGE 2L INOP. OTHER DOOR LIGHTS OPERATE AT 2L, CROSS AISLE LIGHTS OPERATE NORMALLY. FLIGHT DECK EMERGENCY DOME LIGHT OPERATES NORMALLY. REPLACED LIGHT ASSY, OPS CHECKS GOOD.SDR UALA2010051701653Cabin Pressure · malfunctionedDECOMPRESSON ISSUE, RTFL. REPLACED LT ASCPC, GROUND TEST PASSED. ALSO CABIN PRESSURE SYS GROUND TEST PASSED. OPERATED BOTH OUTFLOW VALVES MANUALLY. COMPARED WITH INDICATION, ALL OK.SDR UALA2010051201613Light · inoperativeSEAT 1E AND 2E AFT EEL LIGHT OUT. REPLACED LAMP ASSY AT 1E AND SECURED 2E. CHECK OKAY.SDR UALA2010042601381Generator · faultyELEC BACKUP GEN L LEFT BACKUP GENERATOR OFF DUE TO A PROTECTIVE TRIP. REPLACED BACKUP GENERATOR CONVERTOR. DID NOT CORRECT PROBLEM. REPLACED LT BACKUP GENERATOR, ALL OPS NORMAL. SERVICED NR 2 ENG BACKUP GENERATOR OIL PER SERVICE MESSAGE.SDR UALA2010030900815Light · inoperativePAX SEAT 2F AFT EMERGENCY LIGHT ASSY INOPERATIVE. REPLACED PAX SEAT AFT EMERGECY LIGHT ASSY AND OPS CHECKED GOOD.SDR UALA2009102103284Pcu · malfunctionedNR 3 SPOILER MESSAGES. REPLACED NR 3 SPOILER PCU. GROUND CHECKS GOOD MAT TEST PASSED NO FAULTS.SDR UALA2009101403221Hinge · brokenROW 42 OXYGEN MASKS FELL. OXYGEN MODULE HINGES ARE BROKEN, STOW BIN MAY HAVE CONTACTED OXYGEN DOOR. OXYGEN MASK-GEN MODULE WILL NEED REPLACED. ROW 41 IS TAPED AND INOP, ROW 42 IS SERVICEABLE. REPLACED WITH NEW 02 BOX ASSY. CHECKS OKAY.SDR UALA2009101303219Control Unit · malfunctionedCENTER LEFT REFUELING VALVE INOP. REPLACED LEFT CENTER FUELING VALVE CONTROL UNIT. OPERATIONAL CHECK NORMAL.SDR UALA2009090402793Pressure Switch · faultyENG OIL FILT SNSR R THE PRESSURE SWITCH FOR DETECTING IMPENDING OIL FILTER BYPASS ON THE RIGHT ENGINE HAS FAILED. DETECTOR FOR PRESENCE OF SOLID CONTAMINANTS NORMAL AND CONTAMINATION IS WITHIN LIMITS. ALSO NO LEAK EXISTED WITH ENG RUN. MOST COMMON CAUSE OF SDR UALA2009082502659Light · missingTHE 3E SIDE LIGHTING FIXTURE FEW OFF. REPLACED EEL LIGHT STRIP.SDR UALA2009072302194Light · missingTHE 1F EMERGENCY LIGHT MISSING STRIP IN COCKPIT. REPLACED EMERGENCY LIGHT AT 1F.SDR UALA2009032300868Wire Harness · defectiveSEAT 3F EMERGENCY LIGHTS INOP. FOUND 3F WORKING & 1F INOP. CONNECTOR TO AFT LIGHT STRIP ON SEAT 1F NEEDS TO BE REPLACED OR HARNESS NEEDS TO BE REPLACED. MADE TEMP REPAIR & LIGHT WORKED. NEED AT LEAST 2 HRS TO FIX. REPLACED CABLE AT SEAT 1F. EMERGENCY LIGSDR UALA2009031000080Wire · looseEMERGENCY LIGHT 1F AFT INOP. SECURED LOOSE CONNECTION.SDR UALA2009010800080Connector · looseEMERGENCY LITE 1F AFT INOP. SECURED LOOSE CONNECTION.SDR UALA2008111306183Connector · unsecureSEATS 1E AND 3F 1EA SEAT EEL LIGHTS INOP. SECURED CONNECTOR ON SEAT 1, REPLACED LAMP ASSY ON SEAT 3, OPS CHECK.SDR 2008UALA06183Connector · looseSEATS 1E AND 3F 1EA SEAT EEL LIGHTS INOP. SECURED CONNECTOR ON SEAT 1, REPLACED LAMP ASSY ON SEAT 3, OPS CHECK.SDR 2008UALA03628Actuator · malfunctionedFUEL JETTISON NOZZLE RIGHT JETTISON NOZZLE VALVE IS NOT IN COMMANDED POSITION. STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; RIGHT JETTISON NOZZLE VALVE IS NOT IN COMMANDED POSITION. DB- ELMS P210 ELECTRONICS UNIT MSG-2812007 LATCHED ER MODE. SUSPECT FAULTYSDR 2008UALA03457Start Valve · faultyRIGHT STARTER AIR VALVE POSITION DISAGREES WITH COMMANDED POSITION. ADVISORY MSG-8061562 INACTV TA MODE. *S/D* FOUND FAULTY STARTER AIR VALVE. REPLACED STARTER VALVE ASSEMBLY PER 80-11-02. ALL OPS AND STARTS NORMAL MSG ERASED. AC OK FOR SERVICE.SDR 2008UALA03414Valve · faultyBLEED OFF ENG L - EICAS MSG ON TAXIOUT. SUSPECT FAULTY HIGH PRESSURE SHUT OFF VALVE. REPLACED NR 1 ENGINE HPSOV REF AMM 36-11-07. AC OK FOR SERVICE.SDR 2008UALA03103Disc · leakingLOW BOTTLE. RUPTURE DISC LEAKING. REMOVED AND REPLACED RUPTURE DISC. REPLACED RUPTURE DISC AND SLIDE BOTTLE. AC OK FOR SERVICE.SDR 2008UALA02711Slide · low pressureMAIN ENTRY DOOR 3R SLIDE PRESSURE LOW. SUSPECT FAULTY O-RING. REPLACED SLIDE ASSEMBLY PER AMM 25-66-01. OPS CHECK OK. AC OK FOR SERVICE.SDR 2008UALA01518Light · inoperativeSEAT 1E ONE EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY & CHECK OKAY.SDR 2007UALA05273Oxygen Bottle · low pressureCREW OXYGEN PRESSURE READING 1450 PSI. SUSPECT LOW DUE TO CREW CHECKS DOING PRE FLIGHT CHECK LIST. REPLACED CREW O2 BOTTLE AND LEAK CHECKED OK. ACFT OK FOR SERVICE.SDR 2007UALA05065Girt Bar · misinstalled1R DOOR SLIDE-RAFT GIRT BAR IN INSTALLED INCORRECTLY. GIRT BAR IS INSTALLED INCORRECTLY. INSTALLED GIRT BAR AND SLIDE. AC OK FOR SERVICE.SDR 2007UALA04991Skin · misrepairedEXTERNAL FUSELAGE HAS 1 EA LARGE TRI-WING FASTENER INSTALLED THROUGH SKIN AT STATION 2200 NEAR STRINGER 32R. SUSPECTED LIGHTNING STRIKE. FASTENER IS SUBSTITUTED FOR RIVET SRM 51-40-03-001 PARA 4. REMOVED FASTENER DID HFEC INSP, NO CRACK. INSTALLED REPAIR 5SDR 2007UALA02563Light · inoperativeBOTH EEL LIGHTS AT SEAT 1E ARE INOP. [07-27-07] REPLACED BOTH EEL STRIPS, OPS CK OK.SDR 2007UALA02080Oxygen System · reads lowCREW OXYGEN 1200 PSI. [07-17-07] SERVICED CREW OXYGEN. NO LEAKS DETECTED. OK FOR SERVICE.SDR 2007UALA01791Electrical Sys · no testELEC STANDBY SYS ELECTRICAL DC-STANDBY POWER SYSTEM FAILED THE SYSTEM SELF-CHECK. [07-06-07] REPLACED BUSS TIE, MAIN BATTERY RELAY. AIRPLANE OK FOR SERVICE.SDR 2006UALA01732Unknown · odorZONE-B AROUND 9B ELECTRICAL BURNING ODOR. INBD FLIGHT ATTENDENT COMMENT: SEAT 9B & 9C PAX SMELLED ELEC BURN ODOR ABOVE SEAT 9B & 9C. INSPECTED INSIDE OF PSU AT SEAT 9AB & 9CDF, CEILING LIGHTS, ABOVE CEILING PANEL AREA, BUSINESS CLASS GALLEY AT DOOR-2 AND DOOSDR 2002UALA00297Skin · crackedLEFT HAND FUSELAGE SKIN CRACKED STATION 2276 (FWD OF HORIZ STAB FAIRING TRACK). MAJOR REPAIR ACCOMPLISHED. REPAIRED AND EDDY CURRENT ACCOMPLISHED.SDR 2002UALA00295Skin · crackedRIGHT HAND EXT FUSELAGE SKIN CRACKED AT STATION 2276 (FWD OF HORIZ STAB FAIRING TRACK). MAJOR REPAIR ACCOMPLISHED. REPAIR AND EDDY CURRENT ACCOMPLISHED.SDR 2001UALA00216Module · leakingCREW VERBAL ON AIRCRAFT DESCENT AT 7K, ODOR IN THE FORWARD CABIN FLT DESK. CREW SAID IT SMELLS LIKE HOT OIL SMELL OR OZONE CONVERTER. SUPPLEMENTAL DATA UPDATE THE PROBLEM WAS DUE TO FAULTY RH HYDRAULIC PNEUMATIC PRESSURIZATION MODULE. THE PNEUMATIC DUCTING SDR 2001UALA00163Module · leakingSTRONG ODOR DETECTED IN COCKPIT DURING CRUISE WHEN UPPER RECIRCULATING FAN IS TURNED OFF. ODOR GOES AWAY QUICKLY WHEN FAN IS TURNED BACK ON. LOWER FAN OK. SUPPLEMENTAL DATA UPDATE THE PROBLEM WAS DUE TO FAULTY RT HYDRAULIC PNEUMATIC PRESSURIZATION MODULE. SDR 2001UALA00197Floorbeam · crackedCRACKED STA 246 FLOORBEAM MID CHORD AT CUTOUT- LBL 38.5, BUCKLED STIFFENERS STA 246 FLOORBEAM - RBL 7 AND 26. *S/D* REPAIR CRACK PER SRM 53-10-51, REPAIR 1, PAGE 201. REPLACED STIFFENERS PER SRM 53-10-51, REPAIR 3, PAGE 201.SDR 2001UALA00063Seal · leakingDURING CRUISE, FLT REPORTED HOT, ELEC SMELL IN COCKPIT & CABIN WITH RECIRC FANS OFF. WITH RECIRC FANS ON, SMELL GOES AWAY. DIVERTED TO ORD. *S/D* GROUND RUNUP REVEALED SLIGHT OIL SMELL IN COCKPIT & CABIN WHEN ISOLATED TO RIGHT PACK AND RIGHT ENG. NO ELEC SDR 2001UALA00035Fan · odorDURING CRUISE AFTER TURNING ON RT RECIR FAN UNUSUAL ODOR FILLED THE COCKPIT AND FIRST CLASS CABIN. NOT AS BAD IN FIRST CLASS, SMELL LIKE OZONE OR ELECTRIC BURNING SMELL. ODOR COULD NOT BE DUPLICATED ON GROUND. SINCE IT WAS REPORTED THAT THE ODOR WAS LIKE OZ
Back to N797UA