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 CALA2022072501874None · missingLH WING PANEL 561QB IS MISSING. REQUIRE A NEW PANEL FOR INSTALLATION. FABRICATING AND INSTALLING TEMPORARY PANEL 561QB. REF L/P 9141481 FOR DIP TO PERFORM PART 2 BEFORE EACH CYCLE INSPECTION AND PART 3 PERMANENT REPAIR.SDR CALA2021111102087Skin · crackedAD 2019-11-02 SUPPORT TASK EA 5310-06900 OP 13 3EA HOLE CRACK FOUND AT FX SKIN BS 1035 UNDERWING LONGERON, DETAIL REFER REPORT. TRANSFER REF L/P 9130955 AND ORIGINATED BY V917699 4000 TOTAL CYCLES. CARRIED FOR DTA. ACCOMPLISH THE INSPECTIONS PER THE LATEST REVSDR CALA2021111002068Fitting · crackedSUPPORT TASK FUSELAGE BS1035 LH BUILT- UP UNDERWING LONGERON THE MOST I/B LAYER FOUND 1EA CRACK, PLEASE PRINT AND ACCOMPLISH OP 13 OF THIS EA. TRANSFER REF L/P 9130189 AND ORIGINATED BY V906013 FUSELAGE BS1035 LH UNDERWING LONGERON FITTING REPLACED AND INSTA LSDR CALA2021111002067Charger · failedB777-33-3-7015 M33424DR L1 EMER. LIGHTING BATT. PACK CAPACITY FUNCTIONAL TEST FAIL. TRANSFER NON-ROUTINE L/P 9130497 AND ORIGINATED BY V935381 M33424 DR L1 EMER LIGHT POWER SUPPLY AND BATTERY REPLACED AND TESTED NORMAL AS PER AMM 33-51-06 ADD EMP:V896958 M3342SDR CALA2021111002066Battery · noneB777-33-3-7015 M33097 EMERGENCY LIGHTING BATTERY PACK CAPACITY FUNCTIONAL TEST FAIL. TRANSFER REF NON-ROUTINE L/P 9130448 AND ORIGINATED BY V935381 IDT INSP APPROVED BY HX102640 M33097 EMER LT BATTERY PACK REPLACED AND TEST NORMAL AS PER AMM 33-51-06 ADD EMP:VSDR CALA2021111002065Charger · noneB777-33-3-7015 M33405 EMER. LIGHTING BATTERY PACK CAPACITY FUNCTIONAL TEST FAIL. TRANSFER REF NON-ROUTINE L/P 9130450 AND ORIGINATED BY V935381 M33405 EMER LIGHT BATTERY PACK AND POWER SUPPY REPLACED AND TEST ED NORMAL AS PER AMM 33-51-06 ADD EMP:V896958 M3340SDR CALA2021111002064None · noneAD 2019-11-02 SUPPORT TASK EA 5310-06900 2EA HOLES FOUND CRACK AT LH BS1035 CTR SECTION FRONT SPAR LWR CHORD. TRANSFER REF L/P 9130956 AND ORIGINATED BY V917699 WING CENTER SECTION FRONT SPAR LOWER CHORD REPAIRED AS PER SRM 5 7-10-10-2R-1 REPAIR 1 JUST AT LBL SDR CALA2021092201654Battery Pack · inoperativeEMERGENCY BATTERY PACK INOP LOCATED ABOVE 3L DOOR REMOVED AND REPLACED EMERGENCY BATTERY PACK LOCATED ABOVE 3L DOOR REF B777 AMM 33-51-06 REV 92A OPPS CHECK GOODSDR CALA2021092201653Battery Pack · inoperativeEMERGENCY BATTERY PACK INOP LOCATED ABOVE 2L DOOR REMOVED AND REPLACED EMERGENCY BATTERY PACK REF B777 AMM 33-51-06 REV 92A OPPS CHECK GOODSDR CALA2019121302203Battery · discharged''A'' ZONE CTR SEAT R/H EMERGENCY LIGHT BATTERY LOW CAPACITY.REF N ON ROUTINE NO.9495732, ORIGINATED BY EMP V905305 SPEC NO.777-33- 3-7019SDR CALA2019121302202Battery · discharged''C'' ZONE CTR SEAT EMERGENCY LIGHT BATTERY LOW CAPACITY REF NON R OUTINE NO.9495731,ORIGINATED BY EMP V905305 SPEC NO.B777-33-3-70 19SDR CALA2019072401237Bracket · out of adjustLOUD SOUND RTND VARIOUS ALT. CANNOT COMMUNICATE DUE TO NOISE. PER AMM 56-11-02-820-801 ADJUSTED GUIDE ROLLER, UPPER FWD ROLLER BRACKET, LWR AFT LINK ARM, CAM BLOCK PER AMM 56-11-02-501 & 601 INSPECT BULB SEAL, TRACKS, ROLLERS AND WINDOW FRAME, NO DEFECT FOUNDSDR CALA2019071801221Bracket · out of adjustUNBEARABLE LOUD SQUEAL FROM CAPT SLIDING WINDW, LEAK STOPPED FL230 7.3P. ADJUSTED L2 WINDOW UPPER FWD ROLLER BRACKET AND LWR AFT LINK ARM PER MM 56-11-02. WINDOW OPENS AND CLOSES GOOD. PRESSURIZED A/C TO 3.5 PSI (DELTA PRESSURE) WITH NO LEAKS NOR NOISES NOTEDSDR CALA2019040500530Seat Track · corrodedM/D STA 1504-1565,RBL 74 SEAT TRACK FOUND CORROSION. M/D STA1540 - 1565 RBL74 SEAT TRACK CORROSION IS OUT OF SRM 53- -00-52 ALLOWABLE DAMAGE I FIG 102 REV.79 ALLOWABLE DAMAGE LIMITS ,THE SRM LIMIT IS REMOVED THICKNESS EQUAL 0.040 IN MAX,MEASURED O/T:0.150",R/TSDR CALA2019040500529Battery · dischargedEMER LIGHT SYSTEM OPERATIONAL TEST FOUND L3 DR M33405 POSITION BATTERY CAN NOT CHARGE. REPLACED THE M33405 BATTERY AT L3 DR POSITION AND EMER LIGHT SYSTEM TEST FOUND NORMAL IAW AMM 33-51-06-200-801 REV.85.SDR CALA2019040500528Charger · inoperativeEMER LIGHT SYSTEM TEST FOUND R2 M33098 BATTERY CHARGER. REPLACED THE R2 DR M33908 BATTERY CHARGER AND EMER LIGHT SYSTEM OPERATION TEST FOUND NORMAL IAW AMM 33-51-06-960-803 REV.85.SDR CALA2019040500527Battery · dischargedEMER LIGHT CAPACITY TEST FOUND EMER LIGHT BATTERY (M33098) AT R2 AND L3 DOORS CAPACITY LOW. REPLACED THE M33098 BATTERY. EMER LIGHT SYSTEM CAPACITY TEST FOUND NORMAL IAW AMM 33-51-06-200-801 REV.85.SDR CALA2019040500526Battery · dischargedEMER LIGHT TEST FOUND M33406 BATTERY CAN NOT CHANGE. REPLACED THE M33406 BATTERY AT L3 DOOR. EMER LIGHT SYSTEM OPERATION TEST FOUND NORMAL REF AMM 33- 51-06-960-803 REV.85.SDR CALA2019040200517Support · gougedAFT SIDE OF THE FLIGHT DECK PARTITION,ALUMINUM SUPPORT STRUCTURE IS GOUGED AT 2 LOCATIONS AT APPROXIMATELY STA 245 RBL20 WL230. AFT SIDE OF THE FIGHT DECK PARTITION ALUMINUM SUPPORT STRUCTURE AT STA245 RBL20 WL230 REPAIRED AS PER EC/RA 5315-01116. ADD EMP:V923SDR CALA2019040200516Seat Track · corrodedM/D STA 1504-1565,RBL 74 SEAT TRACK FOUND CORROSION. M/D STA1540 - 1565 RBL74 SEAT TRACK CORROSION IS OUT OF SRM 53- -00-52 ALLOWABLE DAMAGE I FIG 102 REV.79 ALLOWABLE DAMAGE LIMITS ,THE SRM LIMIT IS REMOVED THICKNESS EQUAL 0.040 IN MAX, MEASURED O/T:0.150",R/SDR CALA2018110302263Display · faultyCREW REPORTED LOSS OF AIRSPEED AND ALTITUDE ON INTEGRATED STANDBY FLIGHT DISPLAY (ISFD) MAINT MSG 34-10083 AND FOUND THE INTEGRATED STANDBY FLIGHT DISPLAY TO BE AT FAULT. REPLACED THE ISFD IAW AMM 34-24-01-420-801. OPS CK GOOD ROTABLE PARTS CHANGE WAS INDICATESDR CALA2018060531359Skin · wornFUSELAGE SKIN AT BS 2108 TO 2150, STRINGER 2L WAS FOUND WORN. THE SKIN WAS REPAIRED IAW SRM 53-70-01, REPAIR 2, REV 76, AND ECRA 5330-06369.SDR CALA2018060531358Skin · wornFUSELAGE SKIN AT BS 2108 TO 2150, STRINGER 2R WAS FOUND WORN. THE SKIN WAS REPAIRED IAW SRM 53-70-01, REPAIR 2, REV 76, AND ECRA 5330-06369.SDR CALA2018060531325Battery · dischargedEMERGENCY LIGHT POWER SUPPLY BATTERY HAD LOW CAPACITY. REPLACED THE BATTERY AND OP TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018051501291Battery Pack · dischargedMAIN DECK L1 DOOR EMERGENCY LIGHT BATTERY PACK M33424 HAD LOW CAPACITY. REPLACED THE BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018051501290Battery Pack · no testMAIN DECK R3 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33404 WITH LOW CAPACITY. REPLACED BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018051501289Battery Pack · no testM/D R2 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33097 TO HAVE LOW CAPACITY. REPLACED BATTERY PACK. OP TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018051501273Battery Pack · no testMAIN DECK L4 DOOR EMERGENCY LIGHT BATTERY PACK M33407 FOUND TO HAVE LOW CAPACITY. REPLACED BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501272Battery Pack · no testM/D R4 DOOR EMERGENCY LIGHT BATTERY PACK M33408 FOUND TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK. OPS TESTED NORMAL IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501271Battery Pack · no testM/D L1 DOOR EMERGENCY LIGHT BATTERY PACK M33093 FOUND TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK. OP TESTED GOOD IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501270Battery Pack · no testM/D L1 DOOR EMERGENCY LIGHT BATTERY PACK M33093 FOUND TO HAVE LOW CAPACITY. REPLACED BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-803, REV 82.SDR CALA2018051501269Sign · damagedM/D R2 DOOR AREA OVER EXIT SIGN FOUND CRACKED AND LOOSE. REPLACED THE SIGN HOUSING AND LENS. OPS TESTED NORMAL IAW AMM 33-51-01-960-802, REV 82.SDR CALA2018051501268Sign · brokenM/D L1 DOOR AFT, R1 DOOR FWD & AFT THREE EXIT SIGNS FOUND BROKEN. REPLACED SIGNS. OPS TESTED NORMAL IAW AMM 33-51-01-960-802, REV 82.SDR CALA2018051501267Light · brokenM/D A & B ZONE CTR PARTITION FOUR LWR EMERGENCY LIGHTS FOUND BROKEN. REPLACED THE EMERGENCY LIGHTS AND OPS TESTED NORMAL IAW AMM 33-51-05-960-802, REV 82.SDR CALA2017090803064Unknown · odorACRID ODOR IN CABIN. ACCOMPLISH SMOKE ODOR CONDITIONAL INSPECTION IAW AMM 05-51-58-800-801C WITH ENG IDLE RUN. THE PROBLEM COULD NOT BE DUPLICATED AT THIS TIME.SDR CALA2015101694597Panel · missingDURING CLIMB IN A RT TURN, FELT ACFT SHUDDER LIKE HITTING POTHOLE. CABIN NOISE CONSISTENT WITH CARGO SHIFT, BETWEEN DOOR 3 & 4. ENSUING TURNS & PITCH CHANGES DID NOT HAVE SAME ISSUE. ONLY HAPPENED ONCE, NORMAL AT THIS TIME. ACFT ARRIVED WITH RT BODY FAIRINSDR CALA2015092994543Engine · malfunctionedCLIMBING THRU 21,000' CREW HEARD A LOUD BANG. THE ACFT STARTED TO SHUTTER, THE LT ENG OIL QTY DROPPED TO ZERO, OIL PRESS DROPPED TO 2 PSI, N2 WENT TO ZERO. ACCOMPLISHED ENG 1 SHUTDOWN CHECKLIST & FIRE HANDLE WAS PULLED. AIRFRAME CONTINUED TO VIBRATE AT A MESDR CALA2015091494351Actuator · failedFOUND MX MSG 52-12120, PERFORMED FIM 52-11 TASK 809 PED PROXIMITY SENSOR TARGET PROBLEMS. REPLACED FLIGHT LOCK DISENGAGED PROXIMITY SENSOR S52105 WITH NEW IAW AMM 52-71-01 PG 201. PERFORM TEST FOR FLIGHT LOCK CONTROL IAW 52-11-26, WHILE PERFORMING THE TEST DSDR CALA2015081394214Battery Pack · dischargedTESTED & FOUND M33407 & M33409 EMER LIGHT STAY ON LESS THAN 15 MINUTES. REPLACED BOTH EMER LIGHT PACKS. OPERATIONS CHECKED NORMAL IAW AMM 33-51-06 REV 74.SDR CALA2014043090906Indication Sys · activatedHIGH OIL TEMP INDICATED ON APPROACH AT APPROXIMATELY 14,000FT. CHECK LIST FOLLOWED & ENG SHUT DOWN. MAXIMUM TEMP OBSERVED WAS 187 DEGREES. EMERGENCY WAS DECLARED. ACCOMPLISHED EM ITEMS 4545, 4546 & 4547. ALSO ACCOMPLISHED ECRA 7200-03519.SDR CALA2014033190718Valve · damagedFUEL SPAR VLV RT EICAS STATUS MESSAGE DISPLAYED ON ARRIVAL. MX MSG 28-14002 SHOWS & RT ENG FUEL SPAR VLV CB A19 TRIPPED. REMOVED SPAR VLV & FOUND RUBBER DEBRIS STUCK IN VLV. RUBBER IS FROM OLD DISCHARGE CHECK VLV ON ONE OF THE BOOST PUMPS. REPLACED VLV IAWSDR CALA2013123094020Skin · chafedNR 2 PYLON LT SIDE ACCESS PANEL 443CL CUTOUT SKIN AT NAC STATION 325 FOUND 4 LOCATION WITH CHAFING MARK. NR 2 PYLON LT SIDE ACCESS PANEL 443CL CUTOUT SKIN AT NAC STATION 325 AREA TRIPLER INTERIM REPAIRED IAW ECRA 5450- 02128 REV PART 1. HFEC INSPECTED NO CRSDR CALA2013123094019Wire · faultyNR 3 RT DOOR EPAS BATTERY CHECKED MODE SEL SW HIGH OHM 9.8M OHM. WIRE W3060-0121-20 REPLACED & CHECKED NORMAL IAW WDM 52-11-15 & AMM 52-11-20. WORK ACCOMPLISHED NR HX169509.SDR CALA2013122793986Battery Pack · dischargedNR 3 RT DOOR EPAS BATTERY AMBER TEST INDICATOR NOT COME ON WHEN TEST EPAS FUNCTION CHECK. NR 3 RT DOOR EPAS BATTERY AMBER TEST CHECKED NORMAL IAW AMM 52-11-20 AFTER EPAS BATTERY PACK REPLACED IAW AMM 52-11-20. HX142076. WIRE W3060-0121-20 REPLACED & CHECKED SDR CALA2013102492338Unknown · odorCREW NOTICED A SWEET ODOR FROM AROUND ROWS 8 & 9AB & DOOR 2L AREA. CREW SHUT OFF POWER TO ROW 8 & 9, SHUT DOWN VIDEO SYSTEM POWER AT DOOR 2L & REMOVED FLUORESCENT BULBS FROM 2L LAVATORY. CHECKED GALLEY AREA FOR SOURCE, SMELL DISSIPATED BUT UNABLE TO LOCATE SDR CALA2013100891864Sensor · faultyRT PACK STATUS MESSAGE PRESENT. FAULTING RT PRIMARY HEAT EXCHANGER INLET TEMPERATURE SENSOR IAW MM 21-51-04. NO MESSAGE NO FAULTS.SDR CALA2013090290906Connector · looseNR 2 ENGINE ANGLE GEARBOX SHOWS SIGNS OF OIL LEAKING. SPRAYED DOWN AREA OF NR 2 ENGINE ANGLE GEARBOX WITH ALCOHOL, 5 MINUTE IDLE RUN ENGINE, CONFIRMED OIL LEAK & POSSIBLE CRACK IN CASE, OIL COMING OUT OF GEARBOX COVER. REPLACED ANGLE GEARBOX COVER O-RING IPCSDR CALA2013090290905Support · wornNR 1 ENGINE REV AFT CROSS TIE SUPPORT ASSEMBLY WORN. ROD BINDS UP WHEN TRYING TO CLOSE REV. REPLACED NR 1 ENGINE REV TIE SUPPORT ASSEMBLY.SDR CALA2013090290898Gearbox · leakingNR 2 ENGINE ANGLE GEAR BOX SHOWS SIGNS OF OIL LEAKING. SPRAYED DOWN AREA OF NR 2 ENGINE ANGLE GEARBOX WITH ALCOHOL, 5 MINUTES IDLE RUN ENGINE. CONFIRMED OIL LEAK & POSSIBLE CRACK IN CASE, OIL COMING OUT OF GEAR BOX COVER. REPLACED ANGLE GEARBOX COVER O-RINGSDR UALA2013071204892Display · dimCOPILOT NAVIGATION DISPLAY VERY DIM WITH KNOBS SET FULL BRIGHT.
Back to N787UA