N798UA
Service difficulty reports · 187
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 = 'N798UA' 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 = 'N798UA' 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 UALA2009031000083Gearbox · making metalAPU HAD A NO START. FOUND LOTS OF METAL ON GEAR BOX DRAIN CHIP DETECTOR. REPLACED APU. OPS CHECK NORMAL, NO LEAKS NOTED, NO MSG DISPLAYED.SDR UALA2009010800083Apu · making metalAPU HAD A NO START. FOUND LOTS OF METAL ON GEAR BOX DRAIN CHIP DETECTOR. REPLACED APU. OPS CHECK NORMAL, NO LEAKS NOTED, NO MSG DISPLAYED.SDR UALA2008122206951Pressure Switch · failedENGINE OIL FILTER SENSOR L THE PRESSURE SWITCH FOR DETECTING IMPENDING OIL FILTER BYPASS ON THE LEFT ENGINE HAS FAILED. STATUS MSG01- ACTIVE CRUISE MODE DEPENDENT; SWITCH POSITION SIGNAL FROM OIL FILTER DIFFRNTL PRESS SW (L ENG) CHANNEL A AND B DO NOT AGREE.SDR UALA2008111306414Hydraulic Line · leakingRIGHT MLG WHEEL WELL HYD LEAK. FOUND TUBING THAT IS LEAKING. REMOVED LEAKING HYDRAULIC LINE FROM AIRCRAFT AND ROUTED TO TUBE SHOP FOR MANUFACTURING OF NEW LINE. NEW LINE WILL BE READY AROUND 2100. INSTALLED NEW DOOR LOCK LOWER HYD LINE FROM ACTUATOR TO TEESDR 2008UALA06415Pressure Switch · failedENGINE OIL FILTER SENSOR L THE PRESSURE SWITCH FOR DETECTING IMPENDING OIL FILTER BYPASS ON THE LEFT ENGINE HAS FAILED. STATUS MSG-7960861 ACTIVE ERROR MODE MSG-7960861 ACTIVE ER MODE. ACPD LEFT ENG OIL TANK MASTER CHIP DETECTOR FOR CONTAMINATION. CHIP DETESDR 2008UALA06414Hydraulic Line · leakingRT MLG WHEEL WELL HYD LEAK. FOUND TUBING THAT IS LEAKING. REMOVED LEAKING HYDRAULIC LINE FROM AIRCRAFT AND ROUTED TO TUBE SHOP FOR MANUFACTURING OF NEW LINE. NEW LINE WILL BE READY AROUND 2100. INSTALLED NEW DOOR LOCK LOWER HYD LINE FROM ACTUATOR TO TEE FISDR UALA2008111303845Probe · faultyFUEL IMBALANCE MSG DISPLAYED. LEFT TANK FUEL QTY INDICATOR IS FAILING. SHOWED 3.5 LOW, HAS HISTORY. IDENTIFIED SEVERAL PROBES WITH POSSIBLE FAULTS. PROBES REPLACED (REPLACED NR 1, 3 & 6 LEFT CENTER TANK UNITS), CLOSING UP & LEAK CHECKING. OP CHECKS NORMALSDR 2008UALA03845Warning Message · illuminatedFUEL IMBALANCE MSG DISPLAYED.SDR 2008UALA03513Gearbox · making metalFOUND METAL ON NR 2 ENGINE MAIN GEAR BOX CHIP DETECTOR. ENGINE REMOVED. SHOP TEARDOWN REVEALED THAT MAIN GEARBOX MB7 BEARING HAD FAILED. ALL RELEVANT HARDWARE WAS RETURNED TO MANUFACTURER FOR FURTHER ANALYSIS. THIS IS AN ONGOING PROBLEM THAT MANUFACTURER ISSDR 2008UALA02707Compressor · failedAIR COMPRESSOR MOTOR BURNED UP AT DEPT, INITIAL CALL WAS FOR SMOKE ODOR IN AFT GALLEY. SUSPECT FAULTY BEARING. REPLACED AIR COMPRESSOR PER AMM 38-42-01. POTABLE WATER SYSTEM OPS CHECK GOOD. AC OK FOR SERVICE.SDR 2008UALA02754Pump · low pressureFUEL PUMP L FWD LEFT FORWARD (BOOST) FUEL PUMP SWITCH ON AND PUMP OUTPUT PRESSURE LOW. STATUS MSG01, LATCHED CRUISE MODE DEPENDENT, L FWD FUEL BOOST PUMP PRESSURE SWITCH SIGNAL IS LOW WITH L FWD FUEL BOOST PUMP ON. DB- ELMS P310 ELECTRONICS UNIT MSG-2813111SDR 2008UALA02663Oil Filter · false activationL ENG OIL FILTER STATUS MESSAGES. REPLACED MAIN OIL FILTER. NO SLUDGE OR CONTAMINATION NOTED, CHECKED MASTER CHIP DETECTOR, NOTHING FOUND. RAN ENGINE, CLEARED MESSAGE, NO FURTHER ANOMALIES NOTED. NO LEAKS NOTED AFTER ENGINE RUN.
SDR 2008UALA01929Panel · wornWEAR WAS FOUND ON THE PANEL OF THE RT WING T/E OUTBOARD FLAP UPPER SURFACE, O/B END L=35". DID NDT INSP PER NDT MANUAL PART1. 51-01-01 FIG 9, NO DELAMINATION. REPAIRED REF 777EN-57-0031-01, TOUCH-UP PAINT REF AMM 51-21-10P701.AC OK FOR SERVICE.SDR 2008UALA01928Panel · wornWEAR WAS FOUND ON THE PANEL OF THE RT WING T/E OUTBOARD FLAP UPPER SURFACE NEAR MID POINT L=50". DID NDT INSP PER NDT MANUAL PART1. 51-01-01 FIG 9, NO DELAMINATION. REPAIRED REF 777EN-57-0031-01, TOUCH-UP PAINT REF AMM 51-21-10P701.AC OK FOR SERVICE.SDR 2008UALA01927Panel · wornWEAR WAS FOUND ON THE PANEL OF THE RT WING T/E OUTBOARD FLAP UPPER SURFACE, INBOARD END L=31". DID NDT INSP PER 777 NDT MANUAL PART 1. 51-01-01 FIG 9, NO DELAMINATION, REPAIRED PER 777EN-57-0031-01, TOUCH UP PAINT REF TO AMM 51-21-10 P701.AC OK FOR SERVICE.SDR 2008UALA01926Plate · wornHONEYCOMB PLATE WEAR WAS FOUND AT UPPER SURFACE OF LEFT WING OUTBOARD FLAP. DID NDT INSP PER NDT MANUAL PART1 51-01-01 FIG 9, NO DELAMINATION. REPAIRED REF 777EN-57-0030-01, TOUCH UP PAINT PER AMM 51-21-10P701. AC OK FOR SERVICE.SDR 2008UALA01697Skin · damagedTHE EXTERIOR SKIN HAS A CAT "C" BLIND FASTENER REPAIRS AT BS 400, 404, 423, 444 AND 445 AT STR 20L. REPLACED FASTENERS WITH SOLID FASTENERS DURING OVERHAUL VISIT. AC OK FOR SERVICE.SDR 2008UALA00449Oven · smokeAFT GALLEY HAD SMOKE AND CONTROL PANEL VERY HOT. ALL AFT GALLEY C/B PULLED. SMOKE HAS DISSIPATED. OVEN SHORT -FOUND OVEN R52 SMOKING. REPLACED OVEN. TURNED ON ALL GALLEY EQUIPMENT NO SMOKE NOTED IN AFT GALLEY,CONTROL PANEL IS NORMAL. ACFT OK FOR SERVICE.SDR 2008UALA00344Fire Detector · false indicationPER FLIGHT ATTENDANT PANEL AT DOOR 1 LEFT FLASHED RED WITH FIRE DETECTED AND AT DOOR 3 RIGHT GOT A RED FIRE INDICATION. RESET PAX SERVICE ENTERTAINMENT UNIT (PSEU) AND ACCOMPLISHED PSEU ADJUSTMENT. TESTED & CHECKED FIRE DETECTION SYSTEM PER MM'S 26- 10-01, SDR 2007UALA00653Lamp · inoperativeEEL LIGHT OUT AT 18 C&G. RELAMPED. TESTED GOOD.SDR 2006UALA02412Electrical Box · failedLOSS OF SAARU-SECONDARY ATTITUDE AIR DATA. SHORTLY AFTER T/O CAP PHONED PILOT TO DISCUSS LOSS OF SAARU-SECONDARY ATTITUDE AIR DATA REF UNIT (MEL-3421J). AFTER MUCH DISCUSSION IT WAS DETERMINED BEST TO RETURN TO SFO FOR REPAIR. TROUBLESHOOTING IDENTIFIED SECSDR 2006UALA01969Converter · smokeAN ONBOARD POWER CONVERTER BEING USED IN SEAT 11D STARTED SMOKING. FLIGHT ATTENDANT USED A HALON BOTTLE TO PUT THE SMOKE OUT. CHECKED SEAT CONNECTION TO PERSONAL COMPUTER POWER SUPPLY. NO PROBLEM NOTED. RESET SYSTEM. OP CHECKED OK.SDR 2006UALA01754Light · inoperativeAFT EEL LIGHT ON SEAT 2F IS INOP. REPLACED AFT EEL LIGHT ASSY ON SEAT 2F.SDR 2006UALA00177Wire Harness · damagedEEL LIGHTS, SEAT 1F INOP AT BOTH EEL PROX LIGHTS POSITION.SDR 2005UALA01379Light · looseEXIT PATH LIGHT AT 2E IS LOOSE. SECURED LOOSE EEL EXIT PATH LIGHTING AT 2E. JARRED LOOSE DURING PASSENGER ENTRY OR EGRESS.SDR 2005UALA01281Connector · looseSEAT 2F AFT EMERGENCY LIGHT INOP. CONNECTOR LOOSE.SDR 2005UALA01280Lamp · failedSEAT 1F AFT EMERGENCY LIGHT INOP. REPLACE BULB.SDR 2005UALA00778Wire · frayedPANEL OPENED AT POTABLE WATER COMPRESSOR IN AFT BULK PIT. FOUND WIRING AND CONNECTOR TO COMPRESSOR FRYED. FOUND COMPRESSOR NOT RUNNING AND VERY HOT. ON AUGUST 1, LAX CLEANED COMPRESSOR ELEC CONNECTOR TO CLEAR W/U FOR LOW H2O PRESS. REPEAT W/U ON AUG 4, SFSDR 2005UALA00560Skin · damagedAFT CARGO DOOR HAS LOWER AFT CORNER DAMAGED. AIRCRAFT REPAIRED PER 777 SRM 52-30-01, REPAIR 17.SDR 2004UALA00331Light · inoperativeEMERGENCY LIGHT INOP AT AISLE SEATS 18G AND 23G. REPLACED LIGHT ASSY.SDR 2002UALA00404Skin · crackedRT FUSELAGE SKIN AT LOWER FWD END OF HORIZ STAB BOX CUTOUT, BS 2268, SEAL FAIRING SKIN IS CRACKED. MAJOR REPAIR ACCOMPLISHED.SDR 2002UALA00403Skin · crackedLT FUSELAGE SKIN AT LOWER END OF HORIZ STAB BOX CUTOUT, BS 2268, SEAL FAIRING SKIN IS CRACKED. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA01924Pcu · leakingACFT RETURNED TO FIELD DUE TO HYDRAULIC LEAK. FOUND NR 6 SPOILER, LEFT WING SECOND SPOILER FROM FUSELAGE LEAKING. THIS IS PART OF THE RIGHT HYDRAULIC SYSTEM JUST INBOARD OF LEFT PYLON. PANEL 552FB REMOVED AND HARDWARE IS BAGGED. MAINT REPLACED LEAKING NR 6 SDR 2001UALA00544Clamp · brokenEICAS BLEED LOSS WING RIGHT INDICATION, FOLLOWED BY RIGHT ISOLATION VALVE CLOSURE, THEN FINALLY THE LOSS OF THE RIGHT AIR CONDITIONING PACK LEAD TO FLIGHT DIVERTING TO MIA. *S/D* FOUND FWD BAND CLAMP FAILED AT LWR RT FLOW CONTROL VLV. THIS CAUSED AIR LEAK, SDR 2000UALA00419Video Unit · overheatedAFTER DEPARTURE EXPERIENCED SMOKE IN CABIN FROM ENTERTAINMENT SYSTEM UNDERSEAT ELECTRONIC UNIT AT SEAT 17AB. AIRCRAFT RETURNED TO FIELD. *S/D* FILTER CAPACITORS IN THE POWER SUPPLY FAILED CAUSING OVERHEAT DAMAGE TO THE CIRCUIT BOARD. THE VIDEO DISTRIBUTIONSDR 99UAL900521Fuel Cluster · failedAPU WOULD NOT START ON LANDING. *S/D* PRIMARY CAUSE WAS ATTRIBUTED TO A FAILED FUEL CLUSTER.SDR 99UAL900365T1 Blade · fracturedAFTER TAKEOFF FROM LHR CREW NOTICED EGT RISE WITH LOSS OF POWER ON NR 1 ENGINE. ENGINE WAS SHUT DOWN AND FLIGHT RETURNED TO LHR. *S/D* NR 1 ENGINE REMOVED. FOUND HIGH PRESSURE TURBINE DAMAGE ORIGINATING AT STAGE 1 BLADE FRACTURED IN AIRFOIL ABOVE THE PLATF
Back to N798UA