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 UALA2013071104823Starter · failedRT ENGINE STARTER FAILED. REPLACED STARTER AND START VALVE, OPS CHECKED GOOD.SDR UALA2013062704521Fire Loop · failedLEFT ENGINE FIRE DETECTION SYSTEM LOOP 2 FAILURE.SDR UALA2013062404357Fire Loop · failedLT LEFT ENGINE FIRE DETECTION SYS LOOP 2 FAILURE. REPLACED M26004.SDR UALA2013053003763Lens · dislodgedR4 DOOR EXIT COVER FELL OFF ON TAKE OFF. BROKEN CLIP. REPLACED LENS AND BASE ASSEMBLIES IAW AMM, OPS CHECKED GOOD.SDR UALA2013053003764Wire Harness · failedNR 2 ENGINE FIRE LOOP STATUS MESSAGE. REPLACED WIRE HARNESS W656 IAW WD 26-11-11.TEST PASS IAW AMM 26-11-00.SDR UALA2013053003762Cover · missingEMERGENCY EXIT PLASTIC COVER MISSING. COMPLIED WITH ECRA 3351- 01060. OPS CHECKED SATISFACTORY.SDR UALA2013052203528Shutoff Valve · failedLEFT TAIL HYD SHUTOFF VALVE IS FAILED IN THE CLOSED POSITION. REPLACED VALVE.SDR UALA2013052203527Isolation Valve · failedRIGHT BLEED ISOLATION VALVE STATUS MESSAGE. REPLACED ISOLATION VALVE, ALL TEST PASSED & INDICATIONS NORMAL.SDR UALA2013031401509Handset · faultyCABIN INTERPHONE INOPERATIVE. REPLACED HANDSET AND CORD IAW MM.SDR UALA2013020100600Display · faultyDISPLAY UNIT BLANK, REPLACED CAPTAIN`S INBD DU IAW AMM, TESTED NORMAL.SDR UALA2012120406942Feeder Cable · damagedIDG FEEDER CABLE RED INSULATION DAMAGED. INSTALLED RED INSULATION.SDR UALA2012120306902Sensor · faultyFUEL TANK SIGNAL UNITS OUT OF RANGE IN TANKS LEFT MAIN NR 14, CNTR RIGHT NR 2, & CNTR LEFT NR 2. PER FIM 28-41 TASK 824 P105 & 106. REPLACED APPLICABLE TANK UNITS.SDR UALA2012111906641Display · malfunctionedCENTER CDU FAIL, EICAS MESSAGE AND CDU BLANK. REPLACED CENTER CDU.SDR UALA2012100805667Exciter · failedENGINE IGNITOR L2 LEFT ENGINE FAILED TO IGNITE USING IGNITOR 2. FAILED AUDIBLE TEST PER MM, NO POP. REPLACED IGNITION EXCITER IGNITION LEAD AND IGNITION PLUG AND ACCOMPLISHED IGNITION SYSTEM, OPERATIONAL CHECK BOTH L1 AND L2 FUNCTIONED NORMAL.SDR UALA2012082704787Fmu · faultyDURING ENGINE SHUTDOWN AFTER ARRIVAL, FUEL VAPOR OBSERVED FROM EXHAUST PIPE OF LEFT ENGINE. REPLACED FMU. ENGINE RUN CHECK PER JRH - OK. REPLACED FMU. ENGINE RUN CHECK PER JRH - OK. NO DEFECTS NOTED.SDR UALA2012080604195Engine · unknownON ENGINE START NR 1 OIL PRESSURE 121, NR 2 152, EGT 480 AND CLIMBING NO ROLL BACK ON NR 1. ACCOMPLISHED NORMAL START. ALL PARAMETERS NORMAL AT IDLE.SDR UALA2012071103722Hook And Loop · wornFIRST OFFICER'S SEAT LIFE PRESERVER POUCH HOOK AND LOOP DOESN'T HOLD. REPLACED HOOK AND LOOP STRIP.SDR UALA2012042302426Line · brokenCREW REPORTED LEFT ENGINE START VALVE DID NOT OPEN ON FIRST TWO START ATTEMPTS. CREW CYCLED CB B01 FOR LEFT START VALVE. START VALVE STILL NOT OPENING. OPENED FAN COWLS & FOUND SENSE LINE BROKEN ON START VALVE. MAINTENANCE FOUND ENGINE START VALVE SENSE LISDR UALA2012041202216Gcu · faultyGENERATOR CONTROL UNIT HAS AN INTERNAL FAULT, MAT SHOWED MAINTENANCE MESSAGE 24-30001. REPLACED WITH A NEW GCU, TEST AND FAULT STILL REF MM. REPLACED WITH A NEW IDG AND TEST OKAY.SDR UALA2012041202213Spar · corrodedRT WING REAR SPAR WEB BETWEEN IRSS 340 AND IRSS 350, CORROSION AROUND THE FUEL TANK BOOST PUMP FASTENERS. BLEND OUT REPAIR ACCOMPLISHED IAW ECRA 5720-02274. CATEGORY A MAJOR REPAIR.SDR UALA2012031201626Transducer · faultyAUTO SPEEDBRAKE FAILURE OF AUTO SPEEDBRAKE LEVER ACTUATOR OR FAILURE OF THE AUTO SPEEDBRAKE SYSTEM. ADVISORY MSG01- LATCHED APPROACH MODE DEPENDENT; GEAR TILT PRESSURE (R) SIGNAL IS LOW WHEN GEAR IS DOWN AND HYDRAULICS IS PRESSURIZED. DB- PRIMARY FLIGHT COMPSDR UALA2012030801510Connector · improper partCABIN LIGHT ASSY D33080 AT APPROX STA 282, LBL 29 CONNECTION IS NON COMPLIANT PER FCD 3321-01019 REV B PAGE #5 ITEM #6. REPLACED CONNECTOR D33080.SDR UALA2012030801509Connector · improper partCEILING LIGHT ASSY D3256J APPROX STA 391 LBL 31, CONNECTION IS NON COMPLIANT PER FCD 3321-01019 REV B PAGE NR 5 STEP NR 4. REPLACED CONNECTOR ASSY AT D3256J.SDR UALA2012030701480Connector · improper partWIRE BUNDLE W236 STA 1990, LBL 90, CONN DM33036C IS NON COMPLIANT FCD REV B. MUST BE REPLACED BEFORE FURTHER FLIGHT. REPLACED CONNECTOR. INSPECTED NEW CONNECTOR INSTALLATION.SDR UALA2012030701479Connector · improper partCEILING LIGHT ASSY DM33036C AT APPROX STA 1990, RBL 90, CONNECTION IS NON COMPLIANT PER FCD 3321-01019 REV B PAGE 40 ITEM 23. THIS IS THE JACK SIDE (AIRCRAFT SIDE). REPLACED WITH CONNECTOR BACC65AJ111S (WHITE) AND RE-SECURE CEILING LIGHT ASSY CONNECTOR TO THSDR UALA2012030701478Connector · improper partCEILING LIGHT ASSY DM330XXE AND DM330XXF AT APPROX. STA 1012, RBL 90 CONNECTION IS NON COMPLIANT PER FCD 3321-01019 REV B PAGE 26 ITEM 25. REPLACED CONN AS REQUIRED. INSPECTED NEW CONNECTOR INSTALLATION.SDR UALA2012011900417Seal · damaged54/EQ4498 HEAT SHIELD INSP, FOUND NUMEROUS LOOSE FASTENERS AND DAMAGED SEAL. 6 FASTENERS LOOSE ON LT PYLON FAIRING FWD HEATSHIELD SEAL 2,4,5,8,12, & 16 (NUMBERED INBD TO OTBD, REF EQ4498). REMOVED HEATSHIELD FWD SEAL ATTACH FASTENERS, BACB30VG6K7 HI-LOKS PERSDR UALA2011122707126Transducer · malfunctionedAUTO SPEED BRAKE LEVER ACTUATOR INOPERATIVE. REPLACED GEAR TILT PRESSURE TRANSDUCER IAW MM. LEAK CHECKED OK.SDR UALA2011121906948Unknown · malfunctionedSPEEDBRAKE DID NOT EXTEND. DEPLOYED MANUALLY. DEF PER MEL. -INF- :BOEING AHM DOWNLINKING MMSGS 32-11910, 12760, 12010, 12860 REF MT 27-029R2 & 27-UA08. THE MT'S REFERENCED MMSG'S NOT DISPLAYED BUT APPEARS BOTH MLG TILT ACTUATORS EXPERIENCING LOW PRESSURE DSDR UALA2011121606919Fastener · missingRT WING INBD SLAT INBD SLAT LINKAGE FAIRING PANEL MISSING 1 FASTENER.SDR UALA2011120606694Strip · damagedNR 2 ENG AFT PYLON HEAT SHIELD GAP STRIP NR 3 DAMAGED. REMOVED 3EA PYLON HEATSHEILD SEGMENTS FOR WEAR EVALUATION & GAP STRIP NR 3 REPLACEMENT. REPLACE NR 2 ENG PYLON HEAT SHIELD SEGMENTS 2, 3, 4, 5, 6 PER MM WITH SERVICEABLE SEGMENTS.SDR UALA2011120606693Strip · wornNR 2 ENG PYLON MOST FWD SEGMENT HEAT SHIELD HAS EXCESSIVE WEAR ON TRAILING EDGE COVER STRIP. INSTALLED NEW COVER STRIP.SDR UALA2011120606692Heat Shield · damagedNR 2 ENGINE, HEAT SHIELD NR 4 AND NR 5 NEED NDT REMAINING THICKNESS AND HFEC FOR CRACKS. ACCOMPLISHED HFEC AS REQUIRED ON AREAS AFTER BLENDING REF NDT MANUAL PART 6 51-00-06. NO CRACKS FOUND. ALSO PERFORMED ULTRASONIC REMAINING THICKNESS REF NDT MANUAL PARTSDR UALA2011111106173Sensor · out of adjustMAN PRESS LEFT MSG SHOW ON EICAS. DF PER MEL 3621A. -INF- :MSG SHOULD READS MAN PRESS SENSOR LEFT. -ADJ- :MSG 36-10480 LATCHED. PERFORMED FIM 36-21 TASK 805 AND GRD TEST PASSED. MSG ERASED AND NO FAULT NOTED.SDR UALA2011110706056Anti-Ice Valve · faultyWAI VALVE L LEFT WING ANTI-ICE (WAI) VALVE FAILURE. REPLACED WAI VALVE AND RPL ACIPS CARD PER MM. OPS NORMAL PER MAT TEST.SDR UALA2011101305571Light · unknownREFERENCE EVA 81392 LLAR BULBS ARE REMOVED. BULBS REMOVED PER EVA81392 AWAITING DISPOSITION OF FURTHER ACTION BY ENGINEERING.SDR UALA2011090704832Pbe · faultyPBE 4L IS SOFT. REPLACED PBE.SDR UALA2011090704831Pbe · faultyPBE SR IS SOFT. REPLACED PBE.SDR UALA2011090704830Pbe · faultyPBE 2L IS SOFT. REPLACED PBE.SDR UALA2011090704829Pbe · faultyPBE 1L SOFT. REPLACED PBE.SDR UALA2011090104708Diplexer · faultySATCOM VOICE AND DATA SHOW INOP ON EICAS, UNABLE TO CONTACT SAM USING SATCOM. ACCMP'D SATCOM TEST THRU MAT SATCOM CK OK ACCMP'D SATVOICE CALL TO CHI. CHECKS OKAY. REPLACED LOW NOISE AMPLIFIER-DIPLEXER FOR HGA PORT, L SYS PER MM. SATCOM SYSTEM CHECKS OK. BOSDR UALA2011090104707Transceiver · faultyNR 2 HF RADIO INOPERATIVE. PER MEL 2311H REPLACED NR 2 HF TRANSCEIVER. RADIO CHECK NR 2 HF, CHECK OK. ACFT RETURNED TO GATE FOR NR 2 HF WILL NOT TRANSMIT. REPLACED RIGHT HF ANTENNA COUPLER PER MM (RIGHT HF).SDR UALA2011082904641Pump · faultyLEFT AFT FUEL PUMP LOW PRESS LIGHTS INOP. LEFT AFT FUEL PUMP LOW PRESS LIGHTS INOP. THE OTHER LOW PRESS LIGHTS WORK OK. SYNOPTIC AGREES WITH SWITCH POSITION. SWITCH LIGHT TEST OK, BUT NO LIGHT WHEN PUMP & APU OFF. L AFT BOOST PUMP IS INOP. RPL LT AFT MAISDR UALA2011082604578Drain · blockedAT DEPARTURE FOUND WATER LEAK FROM THE MID GALLEY POWER PNL, FOUND THE UPPER MAIN WIRE CABLES UNDER WATER AND WIRES CORRODED. MID GALLEY DISASSEMBLY FOR ACCESS, PICS ON RVI SITE, REMOVING TERMINAL BLOCK, CLAMPS AND CONTACTS. FOUND BLOCKAGE AT CONNECTION TO WSDR UALA2011082604579Transceiver · weakHF RADIO - TRANSMISSION PROBLEM. CREW COMMENTS: R HF VERY WEAK TRANSMITTER. RT HF RADIO UNUSABLE. REPEAT WRITE UP. REPLACED RT HF XCVR. OPS CHECKS OK MAT SYSTEM TEST AND GNS HF TEST TO RADIO.SDR UALA2011082604580Amplifier · unreliableSATCOM VOICE AND DATA LINK UNRELIABLE AND INTERMITTENT. PREVIOUS FAULT SHOWS 23-60061 & 23-60041. SUGGEST REPLACING HIGH POWER AMPLIFIER HIGH GAIN ANTENNA UNIT. REPLACE MR23808. SYSTEM TESTS OKAY. ACARS SATCOM FUNCTION ENABLED.SDR UALA2011081904422Filter · inoperativeEQUIP COOLING EQUIPMENT COOLING FUNCTION IS INOPERATIVE (LOW FLOW), OR COOLING SUPPLY AIR TEMPERATURE IS EXCESSIVE ON THE GROUND, OR BOTH EQUIPMENT COOLING OVERRIDE VALVE ACTUATORS (NR 1 AND NR 2) HAVE FAILED BITE TEST OR HAVE FAILED TO REACH COMMANDED POSITIOSDR UALA2011041501841Satcom · faultySATVOICE LOST ON ALL TRIP. STATUS SAT HIGH GAIN CYCLES ON AND OFF. REPLACED SATELLITE DATA UNIT M23106 IAW MM AS PER FIM 23-15 TASK FOR MAINT MSG 23-60021. SATCOM BITE AND SYS OPERATIONAL TESTS PASSED.SDR UALA2011031401211Gcu · faultyREPLACED RIGHT GCU.SDR UALA2011031401210Idg · faultyACFT BACK TO GATE DUE IDG MSG.GET MSG 2431662, REF FIM 2 421 TASK 812, RESET SWITCH AND RUN ENG, NO HELP. NOTIFIED DD & MAKE DEF. RIGHT IDG OIL SHOULD BE CHANGED WHEN DEFERRAL IS CLEARED IAW MEL 2411A. REPLACED AND OPS CHECK RIGHT ENG IDG PER MM.
Back to N787UA