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 UALA2009052701522Light · inoperativeONE (1) EMERGENCY LIGHT ON SIDE OF 2F INOP. REPLACED EMERGENCY LIGHT STRIP. OP'S CHECKED GOOD.SDR UALA2009050401280Connector · unsecureEEL LIGHT ON SEAT 2F INOP. SECURED CONNECTION UNDER SEAT ASSY, OPS NORMAL.SDR UALA2009042001136Light · unsecureSEAT 3E AFT EMERGENCY LIGHT HANGING DOWN. SECURED SEAT EMERGENCY LIGHT 3E, CHECKS OKAY.SDR UALA2009041601108Chip Detector · contaminatedCHECKED ALL CDS AND FOUND METAL ON MAIN GBX CD AND MASTER CD. ALSO CHECKED MAIN OIL FILTER. EPH ALL CHIP DETECTORS.SDR UALA2009032700912Light · inoperativeSEAT 3F AFT EMERGENCY LIGHT IS INOP. RELAMPED EMERGENCY LIGHT. OP CK NORMAL.SDR UALA2009032700911Connector · looseSEAT 2F FWD EMERGENCY EXIT LIGHT IS INOP. RESECURED EMERGENCY LIGHT CONNECTOR. OP CK NORMAL.SDR UALA2009031200760Connector · damagedR PACK EICAS 5 HRS INTO FLIGHT. RESET, NO HELP. R FCV VLV STATUS ALSO. FOUND BENT PIN ON CONNECTOR DV21514B. UNABLE TO STRAIGHTEN. REPLACED RIGHT PACK LOWER FLOW CONTROL VALVE, OPS CK'S GOOD, NO FAULTS.SDR UALA2009012300258Skin · damagedRT FUSELAGE EXTERNAL SURFACE HAS A PROTRUSION AT BS 2252, 3 INCHES ABOVE STR-45R, S:1 X 1 INCH. CUT OUT DAMAGED AREA, HFEC INSP NO CRACK FOUND. REPAIRED AREA PER SRM 53-00-01, PART 2, AND 777EN-53-0400-02.SDR UALA2008120506766Actuator · leakingNR 1 ENGINE HAS FUEL LEAKING FROM NR 2 DRAIN. REPLACED TCC ACTUATOR, NO HELP. LINE STILL LEAKING. FOUND STATOR VANE ACTUATOR LEAK BEYOND LIMITS. REPLACED SVA. OP CHECKS GOOD.SDR 2008UALA06434Light · missingAFT EEL STRIP MISSING AT SEAT 3F. REPLACED EEL ASSY AND CHECKED OKAY.SDR 2008UALA04341Smoke Detector · intermittentSMOKE ALARM INTERMITTENT AT LAV 3L FWD. FOUND FAULTY DETECTOR. REPLACED SMOKE ALARM AT LAV 3L. REACTIVATED LAV TO NORMAL.SDR 2008UALA03809Idg · faultyELEC BACKUP GEN R RIGHT BACKUP GENERATOR IS OFF OR HAS FAILED. ADVISORY MSG-2446010 ACTIVE DC MODE MSG-2447010 INACTV DC MODE MSG-2447010 INACTV DC MODE. *S/D* SUSPECT FAULTY IDG AND OR BUG. REPLACED BOTH IDG AND BUG OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA00461Light · out of positionEMERGENCY PATH LIGHT IS OUT OF ITS TRACK 3F. RESECURED PATH LIGHTING.SDR 2007UALA03034Light · inoperativeEMERGENCY EEL LT INOP AT SEAT 35CD. 08-31-07 REPLACED LT ASSY AT SEAT 35CD. OP CHECKED OK.SDR 2007UALA03033Wire · shortedEMERGENCY EXIT LIGHTS AT SEATS 3E (AFT SIDE) AND 3F (AFT POSN) ARE INOPERATIVE. 08-31-07 FOUND SHORT IN-SEAT EEL STRIP. REPLACED EEL LIGHT ASSY. OP CHECKS OK.SDR 2007UALA02621Charger · faultyEICAS STATUS MESSAGES, APU BATTERY, APU BATTERY CHARGER. [08-07-07] REPLACED APU BATTERY AND APU CHARGER. AIRCRAFT READY FOR SERVICE.SDR 2007UALA01857Unknown · smokeRTFL WITH SMOKE IN THE CABIN. [07-06-07] FOUND MAT MSG 49-11150 "APU CONTROLLER FAILED". CONTINUED TROUBLE SHOOTING & DETERMINED SOURCE OF SMOKE WAS APU. REPLACED GTCP331-500B APU. ACCOMPLISHED APU VERIFICATION FLIGHT. AIRCRAFT OK FOR SERVICE. SUSPECT ISDR 2006UALA02199Unknown · odorELEC SMELL AFT AND MIDGALLEYS. FWD FIRST CLASS. CREW REPORTS INTERMITTENT ACRID ODOR THROUGHOUT CABIN BUT CENTERED IN MID GALLEY AREA. CREW SELECTED RECIRCS AND GASPARS OFF AND TURNED OFF SEAT POWER AT CACP, ALSO SECURED POWER IN ALL GALLEYS BUT ODOR LINGERSDR 2006UALA00763Frame · damagedFOUND STA 298.5 LT FRAME OUTER CHORD AT STR 28-30 IS DAMAGED. TEMPORARY REPAIR AND REPETITIVE INSPECTION WAS PERFORMED PER EVA G95-7785A. PERMANENT REPAIR OF THE DAMAGE WAS ACCOMPLISHED PER EVA G95-7785B .SDR 2006UALA00588Lamp · missingFOUND SEAT 3E AFT AISLE EEL LT IS MISSING.SDR 2006UALA00280Precooler · damagedRIGHT ENGINE PNEUMATIC STRUT PRECOOLER HAS A 5 INCH BY 1-4 INCH GAP AT BOTTOM LEFT SIDE. REPLACED RIGHT ENGINE PRECOOLER. OP CHECKS OK. THE DAMAGE FOUND WAS TYPICAL FOR THIS UNIT. THE CYCLING OF THE HPSOV AND THE ASSOCIATED PRESSURE SPIKES CAUSE FATIGUE CRSDR 2005UALA00976Sensor · unknownFLIGHT LOST APU. *S/D* LT IDG WAS INOPED 09SEP05. THE RT IDG WAS INOPED, REPLACED. ON 10SEP05 THE APUC GAVE THE MSG COMPLETE LOSS OF APUC BUS ACTIVITY (BOTH LT AND RT 629) FOR 3 SECONDS AFTER THE APU MASTER CONTROL SWITCH HAS BEEN IN THE ON POSITION FOR TESDR 2005UALA00520Lamp · inoperativeEEL INOP AT SEAT 3F. LIGHT ASSEMBLY WAS REPLACED.SDR 2003UALA00758Carbon Seal · damagedOIL SMELL IN COCKPIT ON DESCENT. APU WAS REPLACED AND SHOP DISASSEMBLED GEARBOX AND LOAD COMPRESSOR. ENGINEERING FOUND INDICATIONS THAT THE LOAD COMPRESSOR FRONT CARBON SEAL TO BE THE ROOT CAUSE FOR SMELL IN CABIN. THE LOAD COMPRESSOR CARBON SEAL HOUSING WSDR 2003UALA00742A/C Pack · odorRANCID ODOR COMING AIR CONDITIONER. SMOKE OR FUMES IN CABIN. APU WAS REPLACED AND SHOP DISASSEMBLED GEARBOX AND LOAD COMPRESSOR. ENGINEERING FOUND INDICATIONS THAT THE LOAD COMPRESSOR FRONT CARBON SEAL TO BE THE ROOT CAUSE FOR ODOR IN CABIN. THE LOAD COMPRSDR 2003UALA00583Warning Light · inoperativeNR 1 ENG IDG DRIVE LIGHT INOP, IDG OIL LEVEL BLANK AND NO AMBER INDICATION ON SYNOPTIC. FOUND WIRE HARNESS W0623 CHAFFED AT SEVERAL CLAMP LOCATIONS. REPLACED WIRE HARNESS AND OIL LEVEL INDICATION REMAINED BLANK. FOUND IDG INTERNAL CHARGE PRESSURE SWITCH FAISDR 2003UALA00272Control Panel · shortedSPARKS, SMOKE AND ODOR IN CABIN FROM OVERHEAD PANEL IN PAX COMPARTMENT. MECHANICS FOUND MELTED PLASTIC INSIDE BOTH MID-GALLEY WARMING OVENS. MID-GALLEY IS LOCATED JUST FORWARD OF ROW 11. PLASTIC WAS REMOVED FROM WARMING OVENS, OVENS CLEANED AND OP CHECK SDR 2002UALA01336Switch · malfunctionedNR 1 ENGINE OIL FILTER LT STATUS MESSAGE. ALSO RIGHT PACK FCV STATUS MESSAGE. REPLACED THE OIL FILTER DIFFERENTIAL PRESSURE SWITCH. THE REMOVED SWITCH WAS A PRE PW SERVICE BULLETIN PW4G-112-79-12 CONFIGURATION. MESSAGE WAS DUE TO FAILED PROX SWITCH ON LWR SDR 2002UALA00834Actuator · malfunctionedABORTED TAKEOFF AT ABOUT 80 KTS DUE TO GEAR CONFIGURATION RED WARNING LIGHT AND HORN COMING ON. A/C TAXIED OFF RUNWAY WITHOUT INCIDENT. ONE OF THE MAIN GEAR STEERING POWER CONTROL ACTUATORS (PCA) MAY BE SLOW TO LOCK OR IS LOCKING INTERMITTENTLY. THE PCA WASSDR 2002UALA00049Frame · crackedSTA 298.5 LT FRAME OUTER CHORD AT STRINGER 28-30 WAS REPAIRED PER EVA G95-7785A. INTERIM MAJOR REPAIR ACCOMPLISHED. DAMAGE WAS CUT OUT AND REPAIRED.SDR 2002UALA00052Shear Tie · crackedSTA 298.5 LT SHEAR TIE CRACKED AT STRINGER 28-29.SDR 2002UALA00024Skin · dentedEXTERNAL SKIN DENTED BETWEEN STA 292 TO 298 AT STRINGER 29L. MAJOR REPAIR ACCOMPLISHED. DENT REMOVED AND DOUBLER INSTALLED. DENT WAS CUT OUT AND REPAIRED.SDR 2001UALA01867Light · inoperativeAFT EEL LIGHT ON SEAT 1F INOP.SDR 2001UALA01420Structure · gougedMAJOR REPAIR: DENTED AND GOUGE 18 INCHES AFT OF NR 4 LT. MED CUTOUT 8 INCHES UP FROM THRESHOLD. REPAIRED DOUBLER PER SRM 53-00-01 AT APPROX. BS 2087 S-26L.SDR 2000UALA00818Slide Raft · leakingDOOR 4 LT SLIDE/RAFT FAILED AIR RETENTION CHECK. FOUND TWO HOLES IN INFLATABLE, ONE IS UPPER TUBE AND ONE IN LOWER TUBE. PROBABLE CAUSE OF BOTH HOLES APPEARS TO BE CAUSED DURING PACKING. UNIT IS BEING SENT TO VENDOR FOR REPAIR.SDR 2000UALA00795Light · inoperativeFOUND EEL LIGHT IN AFT SIDE OF SEAT 3F INOP. REPLACED LIGHT ASSY. CHECK GOOD.SDR 2000UALA00132Control Panel · shortedWHILE EN ROUTE, FLIGHT EXPERIENCED HOT ELECTRICAL SMELL/HEAT AT CABIN AREA CONTROL PANEL DOOR 4R AREA. PULLED CIRCUIT BREAKER AND SMELL/HEAT DISAPPEARED. *S/D* INSULATION AT THE BASE OF THE LAMPS OVERHEATED DUE TO THE FAILURE OF THE LAMP. THE CACP WAS REPLSDR 99UAL900622Heat Exchanger · failedON GROUND, AC PACK NOISE FOLLOWED BY SUBSEQUENT PACK SHUT DOWN AND EICAS MESSAGE RT DUCT LEAK. *S/D* FOUND RIGHTHAND HEAT EXCHANGER (P/N 810208-2 ) PRIMARY INLET TORN, INITIAL EXAM REVEALED THAT THE DAMAGE STARTED FROM THE V-NOTCH AREA. THE RT HEAT EXCHANGERSDR 99UAL900528Wire · looseEMERGENCY LIGHTS AT SEATS 1EF AND 2F ARE INOPERATIVE. *S/D* SECURED WIRES IN CENTER BETWEEN SEATS 2B, C. ALL LIGHTS OPERATIONALLY CHECK NORMAL.SDR 99UAL900527Light · inopEMERGENCY LIGHT OUTSIDE DOOR 1L WAS INOPERATIVE. *S/D* FOUND SOME LIGHT CORROSION IN SOCKET. CLEANED OUT SOCKET AND REPLACED BULB. OPERATIONAL CHECK WAS SATISFACTORY.SDR 99UAL900522Cables · chafedWHILE CHECKING INOPERATIVE VIDEO ENTERTAINMENT SYSTEM PROBLEM, FOUND BUFFER BOX NR 2 AND NR 3 CIRCUIT BREAKERS POPPED. ATTEMPTED RESET RESULTED IN SPARKS IN VIDEO CLOSET BEHIND VIDEO EQUIPMENT. SUBSEQUENT INVESTIGATION UNCOVERED BURNED WIRES AT CONNECTOR P3-DSDR 98UAL900365Seal · failedAFTER TAKEOFF AT 1500 FEET, LEFT OIL QUANTITY WENT TO ZERO, LEFT N1 WENT TO ZERO, SMOKE REPORTED IN COCKPIT, LEFT ENGINE SHUT DOWN. RETURNED TO LHR. *S/D* THE ENGINE WAS REMOVED AND ANALYSIS REVEALED THE NR 2 BEARING FRONT CARBON SEAL (51G944) WAS FOUND WORN SDR 98UAL900271Fmc · defectiveFIGHT DIVERTED TO IAD DUE TO BOTH FMC'S NOT OPERATING NORMALLY. LANDED OVERWEIGHT. *S/D* THE FLIGHT MANAGEMENT SYSTEM SOFTWARE PROGRAM COULD NOT COMPLETELY PROCESS THE NEW NAV DATA BASE SOFTWARE (P/N UA4-9807-002). NEW NAV DATA BASE SOFTWARE WAS CREATED AN
Back to N796UA