N787UA
Service difficulty reports · 214
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 = 'N787UA' 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 = 'N787UA' 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 UALA2011022200900Connector · damagedHIGH PRESSURE (HP) FUEL SHUTOFF VALVE POSITION DISAGREES WITH COMMANDED POSITION. STATUS MSG-7360211 INACTV SD MODE. MAINT MSG 73-60021 PERFORM ED WET MOTOR NOW HELP. PERFORMED WIRE CHECK FOUND HIGH RESISTANCE BETWEEN PLUG D71024P AND D71074J, CLEANED BOTH CSDR UALA2011021400781Probe · faultyFUEL TRANSFER WHEN NOT COMMANDED. CTR TANK SCAVENGES EARLY AND ONLY TO LT MAIN TANK. APPROX 40,000 LBS IN THE WING TANKS, WHEN SCAVENGING STARTED, SUSPECT LT OUTLET FLOAT VALVE POSSIBLY OPENS TOO EARLY. NO TIME TO ACCOMPLISH TEST PER FIM. NO FAULTS FOUND OUSDR UALA2010122104662Waste Tank · missingLOST WASTE TANKS, FLIGHT DIVERTED. LOST WASTE TANKS 1 AND 2 IN FLIGHT, CYCLED LAV SYS 1 AND LAV SYS 2 CB'S PER SAMC. NO HELP. DOWN TO 3 LAVS OF WASTE TANK 1. NO FURTHER MAINTENANCE ACTION NEEDED PER OPBLM. SERVICED ALL 3 LAVS AND OPERATION IS NORMAL.SDR UALA2010120604458Pin · burnedFWD GROUND POWER RECEPTACLE HAS BURNED PINS. REPLACED FWD GROUND POWER RECEPTACLE, OPS NORMAL.SDR UALA2010101803860Oil System · emptyAPU AUTO SHUT DOWN AFTER ENG START. OIL QTY READING LOW. PERFORMED VISUAL CHECK AT APU. FOUND NO OIL QTY IN SIGHT GAUGE AND MCD AND SCAVENGE CD HAVE METAL ON THEM. REPLACED APU, OPS CHECK GOOD.SDR UALA2010101803859Transceiver · faultyRH HF INOPERATIVE. TRANSCEIVER FOUND DEFECTIVE. RH HF TRANSCEIVER REPLACED & OPS TEST OKAY.SDR UALA2010101803836Connector · unsecureDOOR 1L EMERGENCY LIGHTS COME ON INTERMITTENTLY. DOOR 1L FWD BATTERY PACK MODULE TURNS ON LIGHTS WHEN HANDLED. NEEDS NEW BATTERY PACK MODULE. RESEATED AND SECURED CONN D3101P AT MED 1L THRESHOLD PANEL. EMERGENCY LIGHTS OP CKD GOOD.SDR UALA2010081102936Light · inoperativeSEAT 1E AFT EMERGENCY LIGHT IS INOPERATIVE. REPLACED EMERGENCY LIGHT STRIP, OPS CHECKED OKAY.SDR UALA2010080502838Light · brokenSEAT 11F FWD EMERGENCY LIGHT BROKEN. REPLACED SEAT 11F FWD EMER LIGHT ASSY. OP CK OK.SDR UALA2010072602678Turbine Blades · damagedNR 1 ENG, S/N 222140, DURING ACK BORESCOPE FOUND HPT-1 BLADE DAMAGED BEYOND SERVICEABLE LIMITS. CHANGE ENGINE AS REQUIRED. MATERIAL BREAK THROUGH AND BURN THROUGH INTO INTERNAL CAVITY.SDR UALA2010071202487Sliding Window · noisyLOUD SQUEALING NOISE FROM CAPTS SLIDING WINDOW. REPLACED NR 2 SLIDING WINDOW. PRESSURIZED AIRCRAFT NO LEAKS OR DEFECTS NOTED.SDR UALA2010060701991Window · damagedHIGH PITCH SQUEAL LWR LT CORNER OF CAPTAIN'S SLIDE WINDOW. MAINT TEXT: L/E OF LT NR3 WINDOW DELAMINATED AND CRACKING BETWEEN PANES. REPLACED WINDOW.SDR UALA2010051701671Pcu · malfunctioned'FLIGHT CONTROL SYS' STATUS MESSAGE & 'SPOILERS' ADVISORY MESSAGE WITH CORRELATED MSG. REPLACED SPOILER NR 5 PCU (M27120) OPS NORMAL.SDR UALA2010042101333Cable · faultyDIFFICULTIES ENCOUNTERED ARMING OR DISARMING DOOR 3L.SDR UALA2010041901286Connector · dirtySPOILERS FAILURE OF ONE OR MORE SPOILER PAIRS. ADVISORY MSG-2711504 LATCHED DC HARD. CLEANED CONNECTOR AT DM27120 AND D2137 ON LT SPOILER NR 5. GRD TEST PASSED ON THE MAT AND OPS CKD OK.SDR UALA2010040601150Hydraulic System · leakingHYD FLUID LOSS FROM LT SYS. QTY WENT DOWN TO APPROX .65 WITHIN FIRST 4 HRS OF FLIGHT. CREW SELECTED LT ENG AND ELECT HYD PUMPS TO OFF AS A PRECAUTION TO CONSERVE FLUID FOR DESCENT, HYD FLUID LOSS STOPPED WITH PUMPS TURNED OFF. NEVER HAD LOW PRESS OR OVHT INDSDR UALA2009111803604Motor · malfunctionedAPU CONTROLLER STATUS MSG DISPLAYED. MAINT MSG 49-10760. MAINT MSG IS FOR BRUSH ON ELECTRIC MOTOR. REPLACED APU ELECTRIC START MOTOR, OPS CHECK GOOD.SDR UALA2009101203192Holder · burnedLAV 3R AFT MIRROR LIGHT INOPERATIVE. FOUND FWD HOLDER BURNT. REQUIRES HOLDER. DISCONNECTED AND SAFETIED BALLAST CONNECTOR. DOME LIGHT OPS NORMAL.SDR UALA2009090802828Light · brokenSEAT 20C FLOOR PROXIMITY EMERGENCY LIGHT BROKEN OFF. REPLACED LIGHT ASSY.SDR UALA2009080502368Apu · malfunctionedAPU WILL NOT START. APU HAS HISTORY OF 'APU CONTROL' EICAS MSG WITH NO FAULTS FOUND AND PREVIOUS PARTS REPLACED STARTER, I-O CARD, AND RELAY K49002. NO HELP. REPLACED APU.SDR UALA2009072802264Light · inoperativeONE (1) EA EEL STRIP LIGHT ON SIDE OF SEAT 3F INOPERATIVE. REPLACED EEL STRIP LIGHT. OPS CHECKS GOOD.SDR UALA2009072302195Generator · faultyNR 2 ENG "BACK UP GENERATOR" OIL LEVEL INDICATION BLANK. REPLACED BUG. OPS CHECKS NORMAL. ELECTRIC INDICATIONS ARE READING NORMAL. OILS WERE SERVICED TO FULL. SERVICED AND RAN ENGINE. LEAK CHECKED. NO LEAKS WERE NOTED.SDR UALA2009072302196Starter · failedSTATUS MSG APU CONTROL. REPLACED APU BATTERY FOR BORROWED ONE. APU NO START. REPLACED APU CHARGER, NO HELP. REPLACED STARTER MOTOR, STARTS NORMAL.SDR UALA2009072302175Battery · malfunctionedSTATUS MSG 'APU BATTERY' AND 'APU BATTERY OVHT'. REPLACED THE APU BATTERY.SDR UALA2009071302057Controller · faultyREPLACE APU CONTROLLER FOR TROUBLESHOOTING. REPLACED APU CONTROLLER FOR TROUBLESHOOTING. FOUND STARTER CLUTCH FAILURE. INSPECTED MAG PLUGS AND REPLACED LUBE PRESSURE AND SCAVENGE FILTERS, NO METAL NOTED. REPLACED STARTER CLUTCH & REPLACED STARTER. OPS ANDSDR UALA2009060101547Battery · failedMAIN BATTERY FAILURE. REPLACED MAIN BATTERY. ALL OPS NORMAL.SDR UALA2009041301060Solenoid · malfunctionedFLAPS PRIMARY FAIL PRIMARY (HYDRAULIC) FLAPS DRIVE FAILURE. FLAPS OPERATING IN SECONDARY (ELECTRIC) MODE. CAUTION MAINT TEXT: FOUND FLAP PRIMARY FAIL OF FSEU 2. FLAP-SLAT CONTROL 2 FAULT. REF MT 27-011 R1, SWAPPED FSEU'S WITH NO HELP. NEEDS LOW SPEED SOSDR UALA2009012600283Control Unit · faultyFLIGHT CONTROL SYS NR 4 AND 11 SPOILERS. REPLACED ACE L2. PERFORMED MAT GROUND TEST SPOILER 4 AND 11 SYSTEM. TEST PASSED. MSG CLEARED.SDR UALA2008112406615Battery · faultySTATUS MSG BATTERY CHARGER MAIN. REPLACED MAIN BATTERY CHARGER AND BATTERY, NO HELP. SWAPPED APU BATTERY WITH MAIN BATTERY AND CHECKS OKAY.SDR 2008UALA06020Battery · inoperativeTHE "BAT CHARGE APU AND APU BATTERY" STATUS DISPLAYED ON LOWER EICAS. REPLACED CHARGER, NO HELP. REPLACED BATTERY & MESSAGE CLEARED.SDR 2008UALA06019Generator · underservicedELEC BACKUP GEN R RIGHT BACKUP GENERATOR OFF DUE TO A PROTECTIVE TRIP. STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; BACKUP GENERATOR (R) OIL PRESSURE IS LOW. DB- BACKUP CONVERTER MSG-2446090 LATCHD ER MODE. ON ARRIVAL FOUND BACKUP GEN OIL IS ABOVE LOW LEVSDR UALA2008111305534Processing Unit · faultyFUEL QTY INDICATION STATUS MSG PER CREW. L MAIN TANK QTY INTERMITTENT, CTR READS NORMAL AND RIGHT MAIN TANK WAS BLANK FOR ABOUT 1.5 HOURS AND THEN ALL TANK READINGS RETURNED TO NORMAL. WITH ALL TANK READINGS NORMAL THE TTL QTY IND WAS STILL BLANK. FOUND FAUSDR 2008UALA04260Gcu · malfunctionedELEC GEN OFF R RIGHT GENERATOR CONTROL BREAKER (GCB) OPEN OR GENERATOR CONTROL SWITCH OFF, AND ENGINE NOT SHUT DOWN. ADVISORY MSG01- LATCHED TAKEOFF ROLL MODE DEPENDENT; INTEGRATED DRIVE GENERATOR (R) EXCITER FIELD CURRENT IS OUT OF RANGE. DB- GENERATOR CONTSDR 2008UALA02957Electronic Unit · activatedPRIMARY CHANNEL MESSAGE ON MAINTENANCE PAGE WHEN LOWERING FLAPS AND FLAPS ARE SLOW. SUSPECT FAULTY FSEU. REPLACED NR 2 FSEU REF. MM 21-51-01. OP CHECKS GOOD. AC OK FOR SERVICE.SDR 2008UALA02701Shaft · shearedELEC BACKUP GEN L LEFT BACKUP GENERATOR IS OFF OR HAS FAILED. ADVISORY MSG01- LATCHED CRUISE MODE DEPENDENT; BACKUP GENERATOR (L) OIL PRESSURE IS LOW. DB- BACKUP CONVERTER MSG02- ACTIVE CRUISE MODE DEPENDENT; BACKUP GENERATOR (L) HAS A SHEARED SHAFT. DB- BSDR 2008UALA01812Engine · oil consumptionAPU HIGH OIL CONSUMPTION GENERATED RED ALERT. UNABLE TO DUPLICATE PROBLEM. APU HOC TROUBLE-SHOOTING DUE TO INCREASE APU OIL CONSUMPTION, ACCOMPLISH HIGH OIL CONSUMPTION TROUBLESHOOTING PER 777 FIM 49-20-00-810-818 TASK 818 PG252 REPAIR ALL LEAKS. 26MAR SFSDR 2008UALA01655Circuit Card · faultyFIRE CARD APU FIRE DETECTION CARD FAULT OR FAILURE OR LOSS OF ARINC 629-429 COMMUNICATION WITH CARD.SDR 2008UALA01292Circuit Card · malfunctionedAIRCRAFT HAS NUMEROUS STATUS MESSAGES ALL RELATED TO LOSS OF POWER DURING FLIGHT. AFTER EXTENSIVE TROUBLE SHOOTING FOUND POWER SUPPLY CARD FAULTY. REPLACED A18 POWER SUPPLY CARD MSG CLEARED. AC OK FOR SERVICE.SDR 2008UALA01195Connector · failedFLIGHT CONTROL SYS STATUS MSG ON PUSHBACK, WILL NOT CLEAR. AFTER EXTENSIVE TROUBLE SHOOTING FOUND BAD CONNECTOR. REPLACED ACE L2 BENCH PLUG DM27122AC. PERFORMED ACE LRU TEST,ACE ACTUATOR MONITOR TEST PER MM 27-02-02-501,AND ACE ACTUATOR CONFIDENCE TEST.ALL TSDR 2008UALA00222Insulator · missingP300 BACK PLANE AUXILARY POWER BREAKER (APB L9-C24335) HAS INSULATOR MATERIAL MISSING, ALSO C PHASE (BLUE) POWER FEEDER WIRE WAS DISCOLORED. RESISTANCE READING AT L9 C24335 C2 EXCEEDED LIMITS. SUSPECT SHORT AT POWER PANEL P300. REPLACED P300 AUX PANEL AND PESDR 2008UALA00124Smoke Detector · faultyDETECTOR FAN 1 CARGO FWD STATUS MSG DISPLAY & DET CHANNEL 1 E-E SMOKE STATUS MSG DISPLAY. SUSPECT FAULTY SMOKE DETECTOR. REPLACED FWD LWR CARGO SMOKE DETECTOR.
SDR 2007UALA05234Line · puncturedEMERGENCY DECLARED DUE TO CENTER HYDRAULIC SYSTEM FAILURE. HYDRAULIC LINE FOR NOSE GEAR STEERING PUNCTURED, REPLACED HYDRAULIC LINE. SERVICED HYDRAULIC CENTER SYSTEM. AC OK FOR SERVICE
SDR 2007UALA04478Fmc · malfunctionedCAPTAIN'S FMC POINTING 15 DEGREES RIGHT, F/O' S POINTS STRAIGHT AHEAD. LEFT CALCULATED BEARING HEADING 15 DEGREES DIFFERENCE FROM RIGHT. EXTENSIVE TROUBLE SHOOTING PERFORMED ON AIMS. UNABLE TO DUPLICATE FAULT. FMC TESTS NORMALLY AFTER RESET. A/C OK FOR SERSDR 2007UALA04312Circuit Breaker · burnedAPU GEN IS INOPERATIVE. REPLACED APB CONTACTOR . APU OPS CHECKED GOOD. SUSPECT AUX POWER BREAKER BURNED AND UNABLE TO HOLD SET POSITION. AC OK FOR SERVICE.SDR 2007UALA03876Terminal · corrodedAPU DISCHARGE LIGHT ON INTERMITTENTLY. CLEANED CORRODED TERMINALS AT L26504 GD TERMINAL 2, AT P5 BTL DISCH AND AT P40 BTL DISCH LIGHT. OP CHECKS GOOD.SDR 2007UALA03491Unknown · unknownENG OIL PRESS L LEFT ENGINE OIL PRESSURE BELOW THE RED LINE LIMIT WITH ENGINE RUNNING. ENGINE REPLACED AT ORD. SHOP TEARDOWN REVEALED A FAILURE OF THE NR 2 BALL BEARING. A 2.5" CIRCUMFERENTIAL X 1" WIDE CHUNK WAS BROKEN OFF OF THE OUTER RACE. THE BEARING HSDR 2007UALA02805Unknown · unknownCENTER FUEL QUANTITY INOPERATIVE.SDR 2007UALA01197Bottle · lowCREW OXYGEN PRESSURE LOW 900 PSI. [SUP 05-16-07] REPLACED OXY BOTTLE. LEAK CHKD AND INDICATED OK. SUSPECT LOW PRESSURE THE RESULT OF CREW SNIFF TESTS DURING CHECK LIST.SDR 2007UALA00314Battery · faultyFOUND SEAT MOUNTED EMERGENCY LIGHT AT ZONE B FWD STAY ON. REPLACED BATTERY & TESTED OK PER MM 33-51-00.SDR 2006UALA02304Light · inoperativeSEAT 1F AFT EMERGENCY LIGHT INOP. RELAMPED; TESTED GOOD.
Back to N787UA