N779UA
Service difficulty reports · 201
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 = 'N779UA' 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 = 'N779UA' 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 UALA2009071001984Light · brokenAFT EMERGENCY LIGHT BROKEN AT SEAT 1E. RELAMPED, TESTED GOOD.SDR UALA2009061801734Apu · leakingAPU HAS EXCESSIVE OIL LEAK. APU REMOVED FOR EXCESSIVE OIL LEAK. FOUND DURING C-CHECK. APU REMOVED AND REPLACED. ACCOMPLISHED AN ALTITUDE VERIFICATION START.SDR UALA2009040901024Oven · dirtyBURNING SMELL IN BUSINESS GALLEY. FOUND WARMING OVEN W33 VERY DIRTY. CLEANED W33 AND OPS CHECKED OK NOW, NO BURNING SMELL AFTER CLEANING OF WARMING OVEN W33.SDR UALA2009033100932Grommet · defectiveNR 2 ENG PYLON GENERATOR CABLE GROMMETS AT FIREWALL HAVE PUSHED BACK INTO FIREWALL, GROMMETS WILL NOT TIGHTEN UP IN FIREWALL FEED THROUGH BORES. REMOVED INSULATION PANEL AND ACCESS PANEL, GROMMETS WOULD NOT TIGHTEN. REPLACED GROMMETS.SDR UALA2009032300873Light · unsecureEMERGENCY LIGHT STRIP FALLING OFF SEAT 1E. RE-SECURED LIGHT STRIP, LIGHTS OPERATION NORMAL.SDR UALA2009010500025Battery · dischargedEPAS BATTERY AT MED 1 LEFT HAS NO GREEN FLASHING LIGHT. REPLACED 2 EA 9 VOLT BATTERIES IN DOOR 1L EPAS BATTERY PACK. BATTERY PACK INSTALLATION WAS NOT DISTURBED.SDR UALA2008112006573Light · inoperativeEMERGENCY LIGHTS INOP AT SEATS 22C AND 39C.SDR 2008UALA06426Circuit Card · faultyANTI-ICE WING EICAS MESSAGE. REPLACED ACIPS CARD. OPS GOOD.SDR 2008UALA06198Pump · leakingAFTER AIRCRAFT WAS DELIVERED TO GATE, FOUND CENTER (C2) HYDRAULIC PUMP LEAKING. REPLACED PUMP. OP CHECKS NORMAL.SDR 2008UALA05935Relay · failedELEC STANDBY SYS ELECTRICAL DC-STANDBY POWER SYSTEM FAILED THE SYSTEM SELF-CHECK. STATUS MSG-2413035 ACTIVE DC MODE MSG-2413035 ACTIVE DC MODE. REPLACED MAIN BATTERY RELAY. CHECKS OKAY.
SDR 2008UALA05543Lamp · inoperativeSEAT 9F FWD EEL PROX LIGHT INOP. LIGHT FOUND DEFECTIVE. REPLACED LAMP. OPS CHK GOOD.SDR 2008UALA05542Light · inoperativeSEAT 8F AFT EEL PROX LIGHT INOP. FOUND LIGHT INOP. REPLACED LIGHT ASSY. OPS CHECKED GOOD.
SDR 2008UALA05541Light · inoperativeSEAT 3F HAS BOTH FWD AND AFT EEL PROXS LIGHTS INOP. FOUND FAULTY HARNESS. REPLACED SEAT EEL LIGHT HARNESS. OP CHKS OKAY.
SDR 2008UALA04066Modulating Valve · faultyNR 1 ENG FAMV STATUS MESSAGE. FOUND FAULTY FAN AIR MODULATING VALVE. REPLACED FAMV, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03514Idg · malfunctionedELEC GEN DRIVE L LEFT IDG FAULT (LOW INTERNAL OIL PRESSURE). REPLACED IDG PER MM 24-11- 01 OPS AND LEAK CHECK GOOD. AC OK FOR SERVICE.SDR 2008UALA03364Solenoid · faultyENGINE START VALVE R RIGHT STARTER AIR VALVE POSITION DISAGREES WITH COMMANDED POSITION OR STARTER AIR VALVE POSITION INDICATION IS LOST. STATUS MSG-8061562 INACTV SD MODE. *S/D* SUSPECT FAULTY STARTER VALVE SOLENOID. REPLACED STARTER AIR VALVE SOLENOID RESDR 2008UALA02238Light · unsecureSEAT 1E EEL LIGHTING MOUNTED ON THE SEAT NEEDS TO BE SECURED.SDR 2008UALA02237Skin · crackedNR 1 SLAT, OUTBOARD TRACK HAS CRACK ON WING CUTOUT, ABOUT 1.25 INCH LONG. REMOVED 3 RIVETS AND 1 LOCK FASTENER. REMOVED DAMAGE LAID UP REPAIR AND STARTED CURE CYCLE. REF SRM 57-41-01. CURED THEN CLOSED UP. AC OK FOR SERVICE.SDR 2008UALA00983Seal · leakingFUEL LEAK RT WING UNDERSIDE OUTBOARD OF RT ENGINE PYLON. SUSPECT SEAL ON FUEL TANK ACCESS PLATE. REPLACED SEAL. ACFT OK FOR SERVICE.
SDR 2008UALA00027Pcu · faultyTHE "FLIGHT CONTROLS" EICAS APPEARED AFTER ENGINE START. SUSPECT AILERON POWER CONTROL UNIT. REPLACED LT INBOARD AILERON PCU PER MM 27-11-11. ACP'D MAT CKS AND ADJUSTMENTS. RAN ENGINES, NO MSG'S DISPLAYED OR ACTIVE. AC OK FOR SERVICE.SDR 2008UALA0027Warning System · activatedTHE "FLIGHT CONTROLS" EICAS APPEARED AFTER ENGINE START.
SDR 2007UALA05167Battery · misinstalled2R PAX DOOR EPAS BATTERY INSTALLED UPSIDE DOWN. REPOSITIONED EPAS BATTERY. AC OK FOR SERVICE.SDR 2007UALA04502Switch · faultyDOOR 3L EPAS POWER SUPPLY FAILS TEST. FOUND DOOR OPEN SWITCH BAD (S52125). WILL ALSO NEED SLIDE ASSY REPLACED. REPLACED DOOR OPEN SWITCH AT 3L. OP CHECKED GOOD, NO FAULTS. SLIDE ASSY REPLACED. A/C OK FOR SERVICE.SDR 2007UALA04055Reservoir · failedFOUND DOOR 4R POWER ASSIST RESERVOIR SQUIB FAILS TEST. REPLACED DOOR ASSIST RESERVOIR. BITE TEST OK FOR SERVICE.SDR 2007UALA03613Light · inoperativeEMERGENCY LIGHTS INOP AT SEATS 21C & 9F FWD LT.SDR 2007UALA02987Transducer · reads lowO2 PRESSURE TRANSDUCER READS 300 PSI TO LOW. REPLACED TRANSDUCER. READINGS NOW IN CORRECT RANGE. AIRCRAFT OK FOR SERVICE.SDR 2007UALA02700Radar · smokeFLIGHT CREW REPORTED SMOKE IN COCKPIT COMING FROM WX RADAR. PULLED C/B'S AND SMOKE DISSIPATED. [08-17-07] REPLACED WX RADAR CONTROL PANEL, BITE TEST OK. AIRPLANE RETURNED TO SERVICE.SDR 2007UALA02077Light · inoperativeTHE 3F EMERGENCY LIGHT INOP. *S/D* REPLACED LIGHT.SDR 2007UALA00815Light · inoperativeTHE AFT EEL PROX LIGHT AT SEAT 3F IS INOP. REPLACED LAMP ASSEMBLY. OP CHECKS OK FOR SERVICE.SDR 2007UALA00814Wire · damagedBOTH EEL PROX LIGHTS AT 1F ARE INOPERATIVE. REPAIRED WIRE TO EEL LIGHTS. ALSO RELAMPED, OP CHECKS GOOD.SDR 2007UALA00582Charger · faultyBATTERY MAIN CHARGER STATUS MESSAGE. MAIN BATTERY CHARGER FAILURE MESSAGE. ACTIVE ES HARD FAULT. AFTER TROUBLESHOOTING, REPLACED MAIN BATTERY. SYSTEM CHECKS OKSDR 2006UALA01790Lamp · burned outEMERGENCY LIGHT AT SEAT 19C, 22C, 24C & 32C IS OUT. RELAMPED EEL LIGHTS AT SEATS 19C, 22C, 24C & 32C. ALL POSITIONS, OP CHECK GOOD.SDR 2006UALA01379Wire Harness · disconnectedFOUND 34C EEL LIGHT INOPERATIVE. FOUND HARNESS NOT CONNECTED; PULLED APART. RECONNECTED HARNESS TO LIGHTS ASSY, OPS CKD. SYS OPS NORM, RTRND AC BACK TO NORM. OK FOR SVC.SDR 2006UALA01383Light · inoperativeTHE 24G EEL LIGHT INOP. INSTALLED SVCBL ASSY, OPS CKD PER SAME. SYS OPERATES NORMALLY, AIRCRAFT RETURNED TO SERVICESDR 2006UALA01378Lamp · inoperativeTHE 24G EEL LIGHT INOPERATIVE. INSTALLED SVCBL ASSY, OPS CKD PER SAME. SYS OPERATES NORMALLY, AIRCRAFT RETURNED TO SVC.SDR 2006UALA00308Lamp · inoperativeEMERGENCY LIGHTS INOP AT SEATS 1F FWD LT, 3F REAR LT, 9F FWD LT & 22C.SDR 2005UALA01136Odor · detectedELECTRICAL BURNING SMELL AND HUMMING NOISE FROM DOOR 2 AFT CHILLER. MANUFACTURER REPORTS COMPRESSOR CRUSH WASHERS RELIEVED, ALLOWING RELEASE OF REFRIGERANT AND OIL. NO CAUSE FOR OVERPRESSURE FOUND. MANUFACTURER REPORTS PERIOD OF QUALITY DEPARTURE DESCRIBED ASDR 2005UALA00796Light · inoperative2F AFT FLOOR EMERGENCY LIGHT INOP. REPLACED EEL LIGHT ASSEMBLY.SDR 2004UALA00233Fitting · crackedI/B ACTUATOR FITTING CRACKED. REPLACED ACTUATOR FITTING.SDR 2002UALA01155Skin · damagedEXTERNAL SKIN DAMAGED AT STA. 220.5 AT STRINGER 36L. MAJOR REPAIR ACCOMPLISHED. EXTERNAL DOUBLER REPAIR INSTALLED.SDR 2002UALA00071Floorbeam · crackedSTATION 246 FLOORBEAM CHORD CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR.SDR 2002UALA00123Skin · dentedDENT ON LEFT HAND AFT FUSELAGE STATION 2107. MAJOR REPAIR ACCOMPLISHED. FUSELAGE EXTERNAL SKIN STATION 2107 STRINGER 30L REPAIRED.SDR 2002UALA00111Skin · damagedLEFT HAND FUSELAGE SKIN STATION 2268.25 DAMAGED NEAR HORIZONTAL STAB CUTOUT. MAJOR REPAIR ACCOMPLISHED ON SKIN PANEL 148W4912-9.SDR 2001UALA02090Actuator · seizedLEFT ENGINE WOULD NOT COME OUT OF IDLE. DIVERTED TO CCS. LEFT ENGINE WENT INTO SUB-IDLE STALL ACCOMPANIED BY STATOR VANE FAULT MSG. LATER DURING DESCENT TO DIVERSION STATION, ENG FAIL MSG ILLUMINATED & FLIGHT CREW SHUT THE ENGINE DOWN AND MADE A SINGLE-ENGISDR 2001UALA01937Chiller · malfunctionedCHILLER IN BUSINESS CLASS CAUSING BURNING SMELL, CREW TURNED OFF CHILLER AND SMELL DISSIPATED. REPLACED FWD CHILLER, RAN BOTH CHILLERS 5 MINUTES AND NOTED NO SMELL.SDR 2001UALA00645Harness · faultyEEL LIGHTS (2) AT 3E INOP. *S/D* MOVEABLE SIDEREST/ARMREST DAMAGED THE FIRST CLASS PROXIMITY LUMINESCENT LIGHT STRIPS WIRE HARNESSES. REPLACED THE FIRST CLASS PROXIMITY LUMINESCENT LIGHT STRIPS WIRE HARNESSES, 2 EA.SDR 2000UALA00645Oven · dirtyF/A SMELLS RUBBER LIKE BURNING ODOR IN AFT GALLEY. GALLEY POWER OFF AND LIGHTS OFF IN THE AFT GALLEY AND SMELL WENT AWAY-CREW REPORTS. LOG STATES: FAINT SMELL OF SMOKE IN AFT GALLEY. *S/D* FOUND PLASTIC WRAP IN AFT GALLEY (R31) OVEN. REMOVED MELTED PLASTISDR 2000UALA00179Clamp · brokenAFTER DEPARTING ORD EN ROUTE CDG, LOST RIGHT AIR CONDITIONING PACK AND GOT ADVISORY MESSAGE ON RT WING ANTI-ICE OVERHEAT. ALSO RECEIVED BLEED LOSS WING R STATUS MESSAGE. DIVERTED TO IAD. *S/D* FOUND BLEED LOSS RESULTED FROM DUCT SEPARATION AT LOWER FLOW COSDR 99UAL900585Wire · failedEN ROUTE MUC-IAD, SPARKS OBSERVED AT SEAT CONTROL BOX UNDER SEAT 31G. *S/D* POWER CABLE FOR SEAT VIDEO UNIT CHAFED AGAINST THE SHROUD DOOR THAT PROTECTS THE SVU (SEAT VIDEO UNIT) AND CABLE CONECTION. CAUSE ATTRIBUTED TO CABLE ROUTING FROM THE FLOOR TO THE SSDR 97UAL900178Check Valve · damagedAIRCRAFT RETURNED TO BLOCKS WITH LOUD BANGING NOISE. FOUND VIBRATION IN DUCTING FROM LEFT PACK TO THE APU. *S/D* LOUD BANGING AND FLAMES OUT OF EXHAUST WHILE MOTORING APU. FOUND .125 INCH DIAMETER OVAL HOLE IN APU CHECK VALVE (P/N 3202610-4). APU REPLACED
Back to N779UA