N788UA
Service difficulty reports · 191
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 = 'N788UA' 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 = 'N788UA' 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 CALA2017031700624Coffeemaker · faultyCOFFEEMAKER SMOKING & SPARKING M61. REPLACED THE COFFEEMAKER.SDR CALA2017030500534Light · brokenB777-33-3-6019 PER M/D LLAR DOOR FWD AREA 1EA LWR EMER LT FOUND BROKEN. REPLACED THE M/D LLAR DOOR FWD AREA 1EA EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV79.SDR CALA2017030500533Light · inoperativeB777-33-3-6019 M/D A4 GALLEY TTL 4EA LWR EMER LIGHTS FOUND INOP. REPLACED THE M/D A4 GALLEY AREA TOTAL 4EA LWR EMERGENCY LT ASSY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-80 2 REV 79.SDR CALA2017030500532Light · inoperativeB777-33-3-6019 M/D M2 GALLEY LT 1EA LWR EMER LT FOUND INOP. REPLACED THE M/D M2 GALLEY LT 1EA LWR EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2017030500531Light · damagedB777-33-3-6019 PER M/D ''B'' ZONE PARTITION L & R 2EA LWR EMER LIGHTS FOUND BROKEN. REPLACED THE CABIN ZONE ''B'' PARTITION LT & RT SIDE LOWER EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2017030500530Light · damagedB777-33-3-6019 PER M/D ''A'' ZONE PARTITION RT 1EA LWR EMER LT FOUND BROKEN. REPLACED THE M/D ZONE ''A'' PARTITION RT 1EA EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2016081200526Flex Line · brokenHYD PRESSURE SYS C EICAS CAUTION LOW CENTER HYDRAULIC SYSTEM PRESSURE . SYSTEM PRESSURE LESS THAN 1200 PSI. MM 29-10150. ASM 29-11 TASK 894 C HYD SYS RESERVOIR LOWER SIGHT GLASS INDICATION NORMAL. IAW AMM 29-11-00-200-804 EXTERNAL LEAK CHECK ACCOMPLISHED, NOSSDR CALA2016070895511Precooler · damagedSOUND & VIBRATION OCCURED FOR A FEW SECONDS DURING CLIMB AT 10K FT, NOISE HEARD AT DOORS L1, 2, AND R2. LOW RUMBLING SOUND AND VIBRATION. DISSIPATED THEN HEARD AGAIN IN CRUISE ROW 8-10 UNDER FLOORBOARD. IAW AMM 05-51-38-201 AIRFRAME VIBRATION CONDITIONAL INSDR CALA2016070195496Duct · damagedSOUND-VIBRATION OCCURED FOR A FEW SECONDS DURING CLIMB AT 10K FT CREW REPORT NOISE HEARD AT DR1L, 2L, AND 2R. LOW RUMBLING SOUND AND VIBRATION. DISSIPATED THEN HEARD AGAIN IN CRUISE ROW 8-10 UNDER FLOORBOARD, NOT AS LOUD THOUGH. IAW AMM 05-51-38-201 AIRFRAMESDR CALA2016020495087Warning Message · intermittentPRIOR TO DEPARTURE, CREW CALL RT ENG VIB MONITOR MSG DISPLAYED. CYCLED BREAKER, NO HELP. ACCOMPLISHED FIM 77-31-826, DETERMINED INTERMITTENT FAULT, NO MSG LATCHED.SDR CALA2015101594596Unknown · overheatedELECTRIC SMOKE SMELL, HAZY 1ST CLASS CABIN, OCCURRED ON SHORT FINAL, EBB OVERHEATING. AS PRECAUTION, 01H IFE POWER SWITCHED OFF. REST OF 1ST CLASS SEAT OPERATED SATISFACTORY. 1ST CLASS GALLEY ELEC INSERT OPERATED & CHECKED, NO ELEC SMOKE SMELL REOCCURRED.SDR CALA2015090394264Tripler · wornNUMBER 1 & 2 PYLONS, LT SIDES SKINS TITANIUM TRIPLERS, WEAR DAMAGE, DEF 5 8 2012. REPAIRED IAW ECRA 5431-01056. INSPECTION REQUIRED IAW PART 2 OF ECRA AT 8,000 FLIGHT CYCLE INTERVAL WITH THRESHOLD OF 30,000 PLANE TOTAL CYCLES. INSPECT PRIOR TO PTC 30,000. SDR CALA2015070694047Skin · damagedSKIN DAMAGE AT STATION 1905, STRINGER 46R TO 49R. INTERIM REPAIR EXISTING. ACCOMPLISHED REPAIR ECRA 5370-01017.SDR CALA2014123092869Oven · dirtySMOKE ODOR IN MID GALLEY AREA COMING FROM R31 OVEN. OVEN WAS SHUTDOWN & CB PULLED. CREW STATES THEY SAW SMOKE COMING FROM OVEN. WITH OVEN OFF & CB PULLED, ODOR & SMOKE DISSIPATING NO FURTHER ISSUES NOTICED. POS R31 FOUND OVEN TO HAVE MELTED FOOD ON BOTTOM. SDR CALA2014071191439Skin · damagedSKIN DAMAGE AT STATION 1905, STRINGER 46R TO 49R. INTERIM REPAIR ACCOMPLISHED. THIS REPAIR IS APPROVED AS TIME LIMITED, PENDING RESULTS OF A DAMAGE TOLERANCE ANALYSIS. REMOVE ACFT FROM SERVICE NO LATER THAN 7JUL2015, UNLESS A NEW 8100-9 IS RECEIVED, FINDINGSDR CALA2014071191411Wire · chafedFOUND SEVEN WIRES CHAFED & SHORTING TO CARBON FIBER PANEL AT APO315, POS 6 D6113J, WIRES W9971-0035, 0036, 0044, 0045, 0058, 0059 & 0060. REPLACED WIRES W9971-0058 -20, -0059-20, -0060-20 IN D9602P IAW DWG A603301-005 PG 47. ROUTED & SECURED WIRES. TERMINATSDR CALA2014040890769Valve · faultyRIGHT PACK MODE EICAS ADVISORY MESSAGE ILLUMINATED AFTER ENG START. REPLACED LOW LIMIT VLV IAW AMM 21-52-30.SDR CALA2014010290045Processing Unit · faultyFUEL QTY INDICATION FUEL TANK QUANTITY ACCURACY IS UNACCEPTABLE. STATUS MESSAGE 2411111 INACTIVE ER INTER MESSAGE 2412250, INACTIVE ER MODE MESSAGE 2820148 & INACTIVE ER INTER. REPLACED FUEL QTY PROCESSING UNIT IAW AMM, OPERATIONS CHECKED GOOD.SDR CALA2013102492350Rod End · lack of lubeFLUID ON GROUND UNDER RT FLAPERON. INITIALLY ROD END SEAL OF RT OTBD ACTUATOR ROD END SEAL LEAKING IN EXCESS OF 30 DROPS PER MIN. LUBED ROD END & OPERATED FLAPERONS NUMEROUS TIMES, NO FURTHER LEAKAGE.SDR CALA2013092691492Processing Unit · faultyFUEL INDICATION SYSTEM ERRATIC. REPLACED FUEL PROCESSOR UNIT IAW MM. SYSTEM OPERATIONS CHECKED OKAY.SDR CALA2013090590997Fire Loop · failedFIRE LOOP 2 ENGINE L LT ENGINE FIRE DETECTION SYSTEM LOOP 2 FAILURE.SDR CALA2013082690715Connector · disconnectedSTS MESSAGE APPEARED EE COOLING DUCT PRESSURE SENSOR 21-14062. RECONNECTED CANNON PLUG AT VSCF DUCT PRESURE & PERFORMED SYSTEM TEST POWER. NO MESSAGE APPEARED.SDR CALA2013082090577Sensor · faultyDUCT PRESSURE DETECTOR VSCF. REPLACED DUCT PRESSURE SENSOR FOR VSCF SUPPLY DUCT PER AMM, OP CHECKED NORMAL.SDR CALA2013081390418Seal · missingSEAT 9A AND 45A LIFE VEST SECURITY SEAL MISSING. REPLACED SECURITY SEAL IAW MM.SDR UALA2013070104574Amplifier · malfunctionedCHRONIC HISTORY OF SATCOM FAILURES AND AHM SHOWING CMC MESSAGE 23-60061. REPLACEED THE LGA HI-POWER AMPLIFIER M23126 IAW AMM.SDR UALA2013070104573Amplifier · malfunctionedFREQUENT LOSS OF SAT-DATA LINK. NOT RECEIVING SOME DISPATCH MESSAGES. REPLACED HIGH POWER AMPLIFIER FOR LOW GAIN ANTENNA IAW MM. OPS CHECKED NORMAL.SDR UALA2013062404356Connector · dirtyBLEED LOOP 2 BODY STATUS MESSAGE. NO STATUS MSG DISPLAYED, MESSAGE NOT ACTIVE. HAD PREVIOUS HIT ON LEG 8 16TH JUNE. CLEANED AND RESECURED LOOP INTERFACE CONNECTORS FOR LOOP 2 ZONES 13, 14 AND 15. TESTED REF AMM 26-18-04-401, NO CMC OR STATUS MESSAGES PRESENTSDR UALA2013050703174Seal · unsecureRIGHT WING, INBD OF NR 2 ENGINE AND NEXT TO PYLON, SMALL LEADING EDGE FLAP HAS A SEAL HANGING DOWN ON THE INBD SIDE OF THE FLAP. REMOVE THE 5 INCH OF LOOSE SEAL FROM RIGHT KRUEGER FLAP. REPLACED SEAL.SDR UALA2013041802687Fan · failedEQUIPMENT COOLING FAN FAILED, EICAS MESSAGE. REPLACED EQUIPMENT COOLING FAN PER MM21-27-20, OPS NORMAL.SDR UALA2013032101777Thermocouple · faultyDURING EEC SYS TEST FAULT MAINTENANCE MESSAGE 73-51082 OCCURRED MORE THAN ONCE IN LEG 0 THROUGH 5. T3 THERMOCOUPLE PROBE RT ENG, CHANNEL B. REPLACED T3 THERMOCOUPLE.SDR UALA2013031401511Bolt · brokenFOUND AIR SENSE LINE FROM PNEUMATIC CLUSTER UNSECURED FROM PLENUM. FOUND STATIC PRESSURE LINE TO PLENUM RETAINING BOLT HEAD BROKEN OFF DURING INSPECTION OF PNEUMATIC CLUSTER AND SENSE LINES ITEM 33. DRILLED OUT BOLT, THREADS NEED TO BE CLEANED UP OR HELI COSDR UALA2013030401296Idg · leakingRIGHT IDG FAULT, LOW INTERNAL OIL PRESSURE. FOUND OIL LEAK FROM BOSS FILTER ON OUTSIDE OF IDG. REPLACED RIGHT IDG IAW MM, CHECKED OKAY. ACCOMPLISHED IDG POWER PLANT TEST AND IDG OPERATIONAL TEST ALL OKAY.SDR UALA2013022601160Valve · inoperativeLEFT ENGINE FAN AIR MODULATING VALVE STATUS MESSAGE. LEFT FAN AIR MODULATING VALVE INOPERATIVE. REPLACED FAN AIR VALVE FOR LEFT ENGINE.SDR UALA2013022501111Engine · surgesLOUD AIR NOISE AND SURGE DURING TAKEOFF AND LANDING. ON ARRIVAL INBOUND CREW REPORT LEFT ENGINE GOT NOISE AND SURGE DURING TAKEOFF AND DESCENT, CHECKED NO PL FAULT, NO EXISTING FAULT, NO FAULT HISTORY, AND NO EXCEED INDICATION. BOTH ENGINE RUN UP, CHECKED BLSDR UALA2013012900542Control Valve · failedRT UPPER FLOW CONTROL STATUS MESSAGE. REPLACED UPPER FLOW CONTROL VALVE, OPS CHECKED NORMAL. MESSAGE CLEAREDSDR UALA2012121707269Bolt · missingFASTENER MISSING LEADING EDGE LEFT WING ROOT. INSTALLED ONE BOLT FOR PANEL, SECURED.SDR UALA2012121707270Bolt · missingFASTENER MISSING LEADING EDGE RIGHT WING ROOT. INSTALLED ONE BOLT FOR PANEL AND SECURED.SDR UALA2012102906227Unknown · leakingLEFT ENGINE HAS A RUNNING LEAK WITH FUEL EXITING THE NR 9 STRUT DRAIN. FOLLOWING LEAK DETECTION TROUBLESHOOTING FOUND LEAK HAD STOPPED FROM NR 9 STRUT DRAIN. DRY MOTOR CARRIED OUT STILL NO LEAK EVIDENT 2 WET MOTOR RUNS CARRIED OUT AGAIN NO LEAK NOTED AFTER FSDR UALA2012102906171Battery Pack · faultyON TAXI OUT F/A REPORT EMERGENCY EXIT PATH LIGHTS ILLUMINATED ON THE SEATS FROM ROW 19 TO DOOR 3R. CRW CYCLED SWITCH ON OVERHEAD AND F/A PANELS, NO HELP. CYCLED C/B'S ON OVERHEAD H9-11 & H16-18 LIGHTS EXTINGUISHED AND NOW DO NOT COME ON WITH FLT DECK SWITCH SDR UALA2012102606147Probe · faultyFUEL QTY INDICATION FUEL TANK QUANTITY ACCURACY IS UNACCEPTABLE. STATUS CREW COMMENTS: RT MAIN TANK FUEL QTY INDICATOR BLANK. MAINT TEXT: HITTING RT TANK PROBES NR 16 M28061 483-0044 MSG 28-2 0121 & NR 18 M28063 483-0046 MSG 28-20125. NEEDS 4 SHIFT SLOT FSDR UALA2012102506134Control Valve · faultyFLAP-SLAT CONTROL 1 HIGH LIFT CONTROL LANE NR 1 HAS A FAULT. STATUS MSG01- LATCHED DESCENT MODE DEPENDENT; SLATS PRIMARY SHUTOFF SOLENOID CIRCUIT IS OPEN. DB- FSEU 1 MSG-2721011 LATCHD DC MODE. FLAP SLAT CONT 1 MESSAGE. REPLACED PRIMARY SHUTOFF SOLENOIDSDR UALA2012102506129Control Valve · faultyAPU BLEED STATUS AT THE GATE. REPLACED APU SURGE CONTROL VALVE PER MM, OPS NORMAL.SDR UALA2012100205588Skin · bentDOOR 4R FWD LOWER EDGE BENT IN APPROX .075 IN DEPTH 1.5 IN WIDE APPROX 9 INCHES IN LENGTH LOCATED 10 INCHES BACK FROM FWD LOWER CORNER. PERFORMED EDDY CURRENT INSPECTION TO LOWER SKIN AND FASTENER HOLES THAT WERE REMOVED PER NTM PART 6 51-00-01 AND NTM PART 6SDR UALA2012062203319Engine · surgesBOTH ENGINES SHOWING SILENT SURGES.SDR UALA2012060803119Idg · malfunctionedRT GENERATOR WOULD NOT CONNECT AFTER START. REPLACED NR 2 ENGINE IDG AND GCU PER MM. RAN ENGINE, OPS NORMAL.SDR UALA2012051002676Skin · wornDURING C CHECK FOUND OTBD PYLON CUTOUT FOR PNL 433CL, 4 LATCHES HAVE WORN INTO PYLON SKIN. REPAIRED PER EVA UA-EVA 80249. HFEC INSPECTED PER NDT 51-00-01 PT 6, NO CRACKS NOTED.SDR UALA2012051002677Tripler · damagedPYLONS SKINS TITANIUM TRIPLERS HAVE WEAR DAMAGE, REPAIRED IAW ECRA 5431-01056.SDR UALA2012050802667Structure · damagedLIGHTNING STRIKE AT BS 1886. REPAIRED IAW SRM 53-00-01 REPAIR 3.SDR UALA2012050402627Skin · damagedLIGHTNING STRIKE AT STA 1886 S9L REPAIRED IAW SRM 53-00-01 REPAIR 3 .SDR UALA2012021300850Transmitter · faultyENG EEC C1 L LEFT ENGINE CONTROL IS IN A TIME LIMITED DISPATCH CONDITION. ENGINE CONTROL SYSTEM IS OPERATING WITH REDUCED REDUNDANCY. STATUS MSG01- NOT ACTIVE CLIMB INTERMITTENT; OIL PRESSURE TRANSMITTER (L ENG, CH B) PRESSURE IS OUT OF RANGE. DB-ELECTRONI
Back to N788UA