N786UA
Service difficulty reports · 207
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 = 'N786UA' 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 = 'N786UA' 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 UALA2010032300996Transceiver · defectiveLEFT HF WILL NOT TUNE. TRANSCEIVER DEFECTIVE. INSTALLED SERVICEABLE TRANSCEIVER IAW MM. OPS CHECKED IAW SAME. SYS PASSES NOTED CHECKS. RETURNED ACFT BACK TO NORMAL. OK FOR SERVICE.SDR UALA2010022600712Controller · faultyAPU FAILED TO START. UNABLE TO UNLATCH IAW FIM DUE TO LACK OF AIRSTART AVAILABILITY. IT S/B NOTED THAT CHECK VALVE REPLACED ON 9TH FEB & HAS CAUSED THIS PROBLEM SINCE FITTMENT. PLACED BLEED OFF & STARTED APU ELECTRICALLY BUT WHEN BLEED VALVE OPENS GET APU BSDR UALA2010022300666Light · dislodged1E EMERGENCY LIGHT STRIP FALLING OFF SEAT. AFT EMERGENCY LIGHT STRIP, ON SEAT 1E SIDE-BROKEN IN HALF. REPLACED LIGHT STRIP EEL. OPS CHECKS OKAY.SDR UALA2010020900508Pump · faultyRT ELEC HYD DEMAND PUMP INOPERATIVE. SWAPPED RT ELEC PUMP AND CTR ELEC PUMP NR C2 IAW MM AND NOW RT ELEC PUMP TESTS NORMAL. DF ITEM CREATED FOR C2 ELEC PUMP. PUMP STOPPED WORKING AND REPLACED ELCU M29203 AND OPS NORMAL. DF ITEM CREATED FOR C2 ELEC PUMP. PUSDR UALA2010020100402Bypass Valve · failedUPON ARRIVAL FOUND RT CABIN TEMP CONTROL SYSTEM MSG 21-23502 (SECOND STAGE TURBINE BYPASS VALVE AC MOTOR IS NOT IN COMMANDED POSITION ) AS DETECTED BY RCHANNEL 2 TEMP CONTROLLER. REPLACED 2ND STAGE TURBINE BYPASS VALVE ON RIGHT PACK, OPS TEST OK.SDR UALA2010020100403Control Valve · faultyPACK FCV L STATUS MSG RESET MESSAGE CLEARED THEN REAPPEARED. LT UPPER FCV INOPERATIVE. DEACTIVATED UPR FCV IN CLOSED POSITION PER MEL. REPLACED UPPER FCSOV ON LH PACK. OPS CHECK OKAY. REOPENED BY OPBLM ON 30JAN10 FOR FCV MSG HIT BEFORE ACFT DEPARTED IAD. SUSPESDR UALA2010020100380Valve · failedBLEED FAMV RIGHT ENGINE BLEED FAN AIR MODULATING VALVE (FAMV) FAILED OPEN OR CLOSED, OR RIGHT AIR SUPPLY AND CABIN PRESSURE CONTROLLER FAILURE.STATUS MSG-3610532 LATCHD ER MODE MSG-3610532 LATCHD ER MODE. SUPPLEMENTAL DATA UPDATE MSG 36-10532.CHRONIC ITEM. VASDR UALA2010011500195Light · inoperativeSEAT 1E AFT EMERGENCY LIGHT INOPERATIVE. REPLACED WITH NEW EMERGENCY LIGHT. OPS CHECKS FINE.SDR UALA2009123004059O-Ring · leakingACFT LEAKING FUEL AT GATE. RIGHT WING PANEL 652HB REMOVED FOR T-SHOOTING FUEL LEAK. FOUND RT JETTISON PUMP LEAKING. REPLACED RT JETTISON PUMP O-RINGS. OPS CHKS NORMAL, NO LEAKS NOTED. REINSTALLED WING PANEL.SDR UALA2009120203716Smoke Detector · dirtyFWD CARGO FIRE DET SYS INOP, FLT DIVERTED. OFF-LOADED CARGO FROM FWD PIT. DISCONNECTED TUBING AT SMOKE DETECTOR, CAPPED OFF MOST OF SAMPLING PORTS FOR ZONE 3 USING TAPE & UTILIZED LOW PRESSURE COMPRESSED AIR TO BLOW OUT TUBING FROM DETECTOR OUT TO SAMPLING PSDR UALA2009102603330Wire · exposedEMERGENCY LIGHT MOUNTED ON SIDE OF SEATS 1E & 3E HAVE EXPOSED WIRES. INSTALLED SERVICEABLE EMERGENCY LIGHTS. RETURNED A/C BACK TO NORMAL. OPS CKD, SYS OPS NORM. OK FOR SVCSDR UALA2009100603132Lens · brokenDOOR 4L FWD EXIT LIGHT ASSY BROKEN LENS WON'T STAY ON LIGHT WORKS. REPLACED FWD EXIT LIGHT ASSY AT DOOR 4L, OP CHECKS GOOD.SDR UALA2009092303010Lamp · inoperativeAT 1E ELECTRIC LIGHT DISCONNECTED. FOUND AFT SEAT MOUNTED EMERGENCY LIGHT ASSY MISSING, RE-INSTALLED NEW EMERGENCY LIGHT LAMP ASSY AT SEAT 1E (AFT).SDR UALA2009083102729Light · looseFLOOR PROXIMITY EMERGENCY LIGHT ON THE SIDE OF SEAT 3E LOOSE AND HANGING BY THE WIRES. SECURED PROXIMITY LAMPS SEAT 3E, OPS CHECKS OK.SDR UALA2009083102728Light · looseFLOOR PROXIMITY EMERGENCY LIGHT ON THE SIDE OF SEAT 1E LOOSE AND HANGING BY THE WIRES. REPLACED AFT PROXIMITY LAMP SEAT 1E, OPS CHECKS OKAY.SDR UALA2009060801625Filter · dirtyEQUIPMENT COOLING AIR FILTER NEEDS REPLACEMENT. REPLACED FILTER.SDR UALA2009052101467Slide · failedAFTER THE SLIDE HAD BEEN FIRED THE TECHNICIAN WENT TO REMOVE THE RESERVOIR FROM THE SLING UNDERNEATH SLIDE AND THE BOTTOM TUBE OF THE SLIDE BLEW FROM THE SEAM. REPLACED SLIDE, 3R SLIDE PERFORMED RII INSP OF 3R SLIDE INSTALLATION ASSY. NO DEFECTS FOUND.SDR UALA2009031000714Power Supply · failedALL SEAT EEL LIGHTS INOP IN AFT SECTION. REPLACED POWER SUPPLY AND BATTERY M33401, CHECKS GOOD.SDR UALA2009030400714Power Supply · failedALL SEAT EEL LIGHTS INOP IN AFT SECTION. REPLACED POWER SUPPLY AND BATTERY M33401, CHECKS GOOD.SDR UALA2009010900088Oxygen System · leakingFOUND SECOND OBS OX MASK STORAGE BOX LEAKING. DISCONNECTED O2 BOX AND CAPPED LINE. LEAK CHECKS GOOD. REPLACED SECOND OBS O2 MASK STORAGE BOX. AT THIS TIME O2 GAGE PRESSURE IS 1720 PSIG.SDR UALA2009031000066Regulator · faultyCREW O2 IS FAULTY. ACCOMPLISHED LEAK CK ON ALL CREW MASKS AND LINES. FOUND LEAK AT 'PRESSURE REGULATOR' TOP PORT. REPLACED REGULATOR. SERVICED OXYGEN TO LIMITS. ACCOMPLISHED POST LK CK. CK'S GOOD. CREW O2 HOLDS STEADY.SDR UALA2009010600066Regulator · faultyCREW O2 IS FAULTY. ACCOMPLISHED LEAK CHK ON ALL CREW MASKS AND LINES. FOUND LEAK AT 'PRESSURE REGULATOR' TOP PORT. REPLACED REGULATOR. SERVICED OXYGEN TO LIMITS. ACCOMPLISHED POST LK CHK. CHECKED GOOD. CREW O2 HOLDS STEADY.SDR UALA2008122406999Oxygen Mask · faultyOBSERVER O2 MASK EMERGENCY BUTTON STICKING. CREW O2 HAS A HISTORY OF BEING LOW. SUSPECT MASK. REPLACED O2 MASK.SDR UALA2008111306499Wire Harness · faultyNR 2 ENG IDG WILL NOT DISCONNECT. SWAPPED NR 1 AND NR 2 IDG DISCONNECT SWITCH ON OVERHEAD, NO HELP. REMOVED ALL IDG ELECTRICAL CONNECTORS, NO BENT PINS OR DEFECTS NOTED. SUSPECT BAD IDG FROM STOCK. NEW IDG ON ORDER. REPLACED IDG, NO HELP. GCU BITE TEST OSDR 2008UALA06499Wire Harness · shortedNR 2 ENG IDG WILL NOT DISCONNECT. SWAPPED NR 1 AND NR 2 IDG DISCONNECT SWITCH ON OVERHEAD, NO HELP. REMOVED ALL IDG ELECTRICAL CONNECTORS, NO BENT PINS OR DEFECTS NOTED. SUSPECT BAD IDG FROM STOCK. NEW IDG ON ORDER. REPLACED IDG PER MM 24-11-01-401, NO HESDR 2008UALA06484Oxygen System · malfunctionedF/O OXYGEN MASK TEST DOES NOT TEST. REPLACED O2 BOX. OPS OKAY, LEAK CHECKED GOOD.SDR 2008UALA04028Wire · brokenEMERGENCY LIGHT ON SEAT 3E AFT SIDE INOP. *S/D* FOUND BROKEN WIRE ON LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03365Fseu · faultyEICAS STATUS MESSAGE FLAP SLAT CONTROL 2 SHOWS ON STATUS PAGE. *S/D* SUSPECT FAULTY FLAP-SLAT ELECTRONIC UNIT. REPLACED NR 2 FSEU, OPS CHECKED GOOD IAW MM 27-51-01. AC OK FOR SERVICE.SDR 2008UALA02424Receiver · faultyPRE-DEPARTURE CHECK FOUND NO LAND 3 ILS C ON STATUS PAGE. FOUND CENTER INSTRUMENT LANDING SYSTEM RECEIVER FAULTY. REPLACED CENTER ILS RECEIVER PER AMM 34-31-01. CAT III CHECK OKAY PER AMM 22-11-00. AC OK FOR SERVICE.SDR 2008UALA01930Idg · faultyELEC GEN SYSTEM L IDG HAS DISCONNECTED OR A PROTECTIVE TRIP OF THE GENERATOR CONTROL BREAKER HAS OCCURRED OR A PROTECTIVE TRIP OF THE BTB HAS OCCURRED. AFTER EXTENSIVE TROUBLESHOOTING FOUND IDG TO BE FAULTY. SUSPECT FAULTY BEARING. REPLACED LEFT IDG PER AMMSDR 2008UALA01037Generator · faultyLEFT BUG HAS TRIPPED DELTA PRESSURE INDICATOR SWITCH. SUSPECT BLOCKED FILTER. REPLACED BACKUP GENERATOR IN ACCORDANCE WITH AMM. OPS & LEAK CHECK OK. AC OK FOR SERVICE.SDR 2008UALA00342Reservoir · malfunctionedSLIDE GAUGE AT DOOR 2L ONE IS HIGH AND ONE IS LOW. REPLACED DOOR 2L EMERGENCY POWER ASSIST RESERVIOR PER MM. DOOR SLIDE PRESSURE SHOWS WITHIN ACCEPTABLE LIMITS.SDR 2008UALA00052Starter · malfunctionedAPU NO START WITH FLAMES, RESTART NO HELP WITH FAULT LIGHT ON. SUSPECT FAULTY STARTER. REPLACED ELECT STARTER. OP CHECK NORMAL AC OK FOR SERVICE
SDR 2007UALA04731Valve · faultyFLIGHT DIVERTED TO YEG TO REMOVE AN ILL PASSENGER. THE AIRCRAFT DEVELOPED A MECHANICAL PROBLEM AND RETURNED TO SFO. REPLACED RT JET ISOLATION VALVE. OP CHK'D THRU MAINT ACCESS TERMINAL. PASSED, NO EXISTING FAULT. NO STATUS MSG.SDR 2007UALA04637Charger · faultyAFTER BLOCKING OUT -MAIN BATTERY DISCHARGE- ADVISORY MESSAGE DISPLAY, WITH A -12 AMP DISCHARGE ON MAIN BATTERY. CYCLED STBY POWER SW ON OVERHEAD AND DISCHARGE DECREASED TO -2 AMP WITH 24 VDC ON MAIN BATTERY. REPLACED MAIN BATTERY CHARGER, OP CHECKED OK FOR SSDR 2007UALA04348Drive Unit · failedWEATHER RADAR SYSTEM FAILURE. REPLACED RADAR ANTENNA DRIVE UNIT, OPS CHEKS OK. SUSPECT BAD ANTENNA CONNECTION. AC OK FOR SERVICE
SDR 2007UALA03799Girt Bar · bentCREW VERBAL: FLIGHT ATTENDANT REPORTS DOOR 2R DISARM LEVER IS STIFF. 10-16-07 REINSTALLED GIRT BAR ACP INSPECTION OF DOOR AND ARMING MECHANISM .DOOR OPS NORMAL. REPLACED GIRT BAR PICK-UP FITTING. FOUND AFT HOOK ASSY. BENT. GIRT BAR IS BINDING ON AFT FLSDR 2007UALA03237Light · inoperativeFOUND SEAT 1F HAS AFT EEL LIGHT INOPERATIVE. 08-31-07 REPLACED LIGHT ASSY. OP CHECKS GOOD.SDR 2007UALA02006Filter · cloggedLEFT ENG IDG DPI POPPED. [07-13-07] REPLACED INTEGRATED DRIVE GENERATOR. OP CHECKS GOOD FOR SERVICE. SUSPECT INTERNAL DEBRIS CLOGGED FILTER & CAUSED DPI TO POP.SDR 2007UALA01915Tank · leakingFUEL IMBALANCE. EICAS FUEL HAS HISTORY. [07-13-07] TROUBLESHOOTING FUEL IMBALANCE. FOUND LEAK IN LT MAIN TANK, DEFUELED, SUMPED TANK. FND AFT BOOST PUMP DISCHARGE CHECK VALVE BAD. INSTALLED REPLACEMENT FLAPPER FUEL TANK OVERRIDE VALVE & SYSTEM CHECKED OKSDR 2007UALA01183Light · detachedEMERGENCY EXIT PATH LIGHTING STRIP ON LEFT SIDE OF SEAT 1E FELL OFF AGAIN. REPLACED LIGHT ASSY. OPS CHECKS GOOD.SDR 2007UALA00578Unknown · smokeSMOKE COMING FROM FWD OUTFLOW VALVE AFTER ENGINE START.SDR 2007UALA00463Light · inoperativeAFT EMERGENCY LIGHT INOPERATIVE AT SEAT 1E. REPLACED LIGHT ASSY, OPS CHECKS OK .SDR 2006UALA01465Chiller · failedBURNING ELECTRICAL SMELL COMING FROM ECONOMY GALLEY AFTER CHILLER C51 FAILED. PERFORMED DIAGNOSTIC, OPERATING CHILLER. OPERATED FOR 10 MINUTES THEN STOPPED RUNNING BUT RUN LT STILL ON. REPLACED CHILLER PER MM 25-33-93 PG 401 AND OPS NORMAL WITH NO BURNING SSDR 2005UALA01250Lamp · inoperativeEMERGENCY WHITE AISLE LIGHT INOP AT SEAT 35G. SUPPLEMENTAL DATA UPDATE REPLACED LAMP.SDR 2005UALA01249Lamp · inoperativeSEAT 1E AFT EMERGENCY LIGHT ASSEMBLY BROKEN. SUPPLEMENTAL DATA UPDATE RELAMPED AFT EMERGENCY LIGHT AT 1E.SDR 2005UALA00783Totalizer · malfunctionedCREW REPORTED FUEL IMBALANCE, INCORRECT TOTALIZER & FMC CALCULATED TO CONTINUE TO LHR. KICKED OFF A-P & ACFT LT WING HEAVY. MX REPLACED FUEL QTY PROCESSING UNIT. FAULT REPEATED INBOUND. FUEL TANK PROBES R13 & R14 REPLACED. NO FURTHER FUEL IMBALANCE OR INDISDR 2005UALA00599Power Unit · malfunctioned4R EPAS BATTERY INDICATOR LIGHTS INTERMITTENT WHILE TAXIING. POSSIBLE SWITCH FAILURE. TEST LIGHT CHECKED DURING OPERATIONAL TESTING OF EPAS FOR BATTERY CHARGE AT CHECK INTERVALS PER EC 20-5211-000AA-A. UNIT CYCLED TO SHOP FOR BATTERY REPLACEMENT AT INTERVALSSDR 2003UALA00427Light · inoperativeEXTERNAL EEL LIGHT INOP AT DOOR 4R. RELAMPED EXTERNAL EEL LIGHT.SDR 2001UALA02394Computer · malfunctionedACFT RETURNED TO STAND WITH RIGHT ENGINE BLEED PROBLEM. NO STATUS MESSAGE. CONFIRMED RIGHT ENGINE PRSOV NOT OPERATING CORRECTLY. FOUND IOM 004 MODULE IN THE RIGHT AIMS SHOWING HARD FAULT. RESET AIMS MODULE AND SWAPPED RIGHT AIMS IOM 009 WITH RIGHT AIMS IOM
Back to N786UA