N504UA, cancelled Mar 10, 2015
Service difficulty reports · 112
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 = 'N504UA' AND deregistration_id = 'N504UA-2015-03-10' 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 = 'N504UA' AND deregistration_id = 'N504UA-2015-03-10' 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 CALA2014051391016Cable · misinstalledDURING FCD 2560 - 02646 INSPECTION FOUND CABLE ATTACHED INCORRECTLY RT OVERWING SLIDE. REINSTALLED CABLE.SDR CALA2014012890248Floorbeam · crackedMAIN CABIN FLOOR BEAM BS 660 LBL 45 CRACKED IN RADIUS. REPAIRED MAIN CABIN FLOOR BEAM AT BS 660 LBL 38 TO LBL 60 IAW UAL ECRA 5300-01829.SDR CALA2014012890247Angle · damagedAFT CARGO COMPARTMENT DOOR LOWER SILL LT ANGLE HAS FOUR EACH DENTS & GOUGE BS 1403- 1394 RBL 22. REPAIRED AFT CARGO DOOR LOWER SILL FROM BS 1392 TO BS 1428 IAW UAL ECRA 5360-01359.SDR CALA2014012490221Floorbeam · crackedMAIN CABIN FLOOR BEAM BS 700, LBL45 CRACKED IN RADIUS. REPAIRED MAIN CABIN FLOOR BEAM AT BS 700 FROM LBL 8 TO LBL 60 IAW UAL ECRA 5300-01823 ON NON-ROUTINE 38346.SDR CALA2014012290213Cover · looseRT OVERWING SLIDE DEPINNED & COVER COMING LOOSE. R & R RT OVERWING SLIDE IAW BOEING 757 AMM 25-65-00, 25-65-01 & 20-11- 00.SDR CALA2013121693735Mechanism · obstructedDOOR 1L WILL NOT ARM WITH DOOR CLOSED. REMOVED DEBRIS FROM ARMING MECHANISM, OPERATIONS CHECKED GOOD.SDR CALA2013120393394Status Message · activatedRT ELEVATOR PCU STATUS MESSAGE.SDR CALA2013112593222Module · faultyRT ELEV PCU STATUS MSG, FLIGHT DIVERTED. R & R RUDDER ELEV PCA MONITOR MODULE IAW AMM 27-23-02 UP TO & INCLUDING STEP 3 D4. NEEDS SYS TEST.SDR CALA2013112193175Door · damagedDUE TO CF410 LT MLG DOOR DAMAGE OUT OF TIME, REPAIR DOOR IAW ECRA 5280-01584 OR REPLACE DOOR. PERFORMED PERMANENT REPAIR IAW ECRA 5280-01584 & SRM 51-70-04.SDR CALA2013112293203Door · dentedRAMP REPORTS DENT IN LT HAND MLG DOOR, OTBD UPPER AREA.SDR CALA2013092791512Light · unsecureEMERGENCY EXIT FLOOR STRIP COMING UP BY AFT GALLEY. RESECURED STRIP.SDR UALA2013070204603Scuff Plate · tornAFT CARGO DOOR LOWER SILL SCUFF PLATE IS TORN. FOUND DAMAGE WITHIN ALLOWABLE LIMITS. PERFORMED INTERIM REPAIR IAW ECRA 5310-04203, PART 1. REQUIRES DAILY INSPECTION OF REPAIR IAW PART 2.SDR UALA2013053103796Wire · shortedDURING FLAP SELECTION FROM 1 TO 5, EICAS L/E SLAT ASSYM INDICATED. FOUND SPLICE SP2198 SHIELDING SHORTING TO CENTER CONDUCTOR, REPAIRED IAW WDM 27-81-31 AND SWP 20-10-15, OPS CHECKED GOOD. NO FAULTS ON FSEU AND NO EICAS MESSAGES NOTED AT THIS TIME.SDR UALA2013052203540Attach Bracket · brokenHALON FIRE EXTINGUISHER BRACKET BROKEN AT FIRST CLASS BULKHEAD, ACFT LEFT. ATTACHED BRACKET AT FIRST CLASS BULKHEAD FIRE EXT, OPS CHECKED GOOD.SDR UALA2013051703436Nut · looseRIGHT AFT ENTRY DOOR EICAS MESSAGE DURING TAXI CYCLES ON AND OFF. WHEN HANDLE IS CLOSED AND IT STILL JIGGLES A LITTLE, RIGHT AFT ENTRY DOOR EICAS MESSAGE IS DISPLAYED & OVERHEAD ENTRY DOOR LIGHT IS ILLUMINATED. WHEN HANDLE IS CLOSED HARD, WITH NO LOOSENESS, SDR UALA2013051603412Light · unsecureFLOOR LIGHT AT EDGE OF CARPET BY SECURITY GATE IS LIFTING. SECURED LIGHT.SDR UALA2013041102463Guide Arm · out of adjustL2 DOOR HARD TO OPEN. ADJUSTED DOOR GUIDE ARM AS PER MM. DOOR OPS CHECKED GOOD.SDR UALA2013040302187Toilet · obstructedAFT LAV OVERFLOW, RTFL. CLEARED DEBRIS AND TANK DRAINED NORMALLY. FILLED AND DRAINED SEVERAL TIMES. BLUE WATER CONTAINED IN LAV. CLEANED AREA LAV, OP CKS GOOD.SDR UALA2013032001728Wire · damagedNR 1 LEADING EDGE SLAT ASYM MESSAGE ON EICAS. PER TROUBLESHOOTING FIM TASK 27-81-05 REMOVED AND REPLACED LT OUTBOARD SLAT LOSS SENSOR SWITCH PER AMM. REPAIRED WIRE WITH ENVIRONMENTAL SPLICE PER SWPD 20-10- 12. SYSTEM OPS CHECKED OKAY.SDR UALA2013030701363Door · bindingCOCKPIT DOOR BINDING. ADJUSTED METAL TRIM.SDR UALA2013030601343Trim System · malfunctionedRUDDER TRIM FROM FL240-350 IS 4.5 UNITS OF RIGHT TRIM TO MAINTAIN WINGS LEVEL. CREW REPORTED AT CRUISE TRIM IS NOW 3.8 UNITS OF RIGHT TRIM. PER CREW DEBRIEFING WENT TO A HIGHER ALT AND WAS SUPPOSE TO BURN LESS FUEL AT THAT ALT AND BURNED MORE FUEL. ACCOMPLSDR UALA2013012400408Floorbeam · damagedBS 310 FLOORBEAM WEB AT RBL 12 DAMAGED. REPAIRED.SDR UALA2013010200009Light · inoperativeLEFT FWD OVERWING EXIT EMERGENCY LIGHT INOP. REPLACED TWO EACH LAMPS AT LEFT FWD OVERWING EMERGENGY EXIT ILLUMINATION LIGHT ASSEMBLY. REFERENCE MM 33-51-01, OPS CHECKS GOOD.SDR UALA2013010200008Light · inoperativeDOOR 2L EXTERIOR EMERGENCY EXIT LIGHT INOP. RESET BULB. OPS CHECK GOOD.SDR UALA2013010200007Connector · disconnectedROW 32ABC EEL STRIP LIGHTS INOP. RECONNECTED CONNECTOR. OPS CHECK GOOD.SDR UALA2012101905991Cover · unknownEMERGENCY PATH LIGHTING REQUIRES REPLACEMENT OF CLEAR COVER IN COACH CABIN. OLD COVER HAS BEEN REMOVED. CLEAR COVER INSTALLED IN COACH CABIN, REQUIRES INSTALLATION OF END CAPS.SDR UALA2012101905982Lens · activatedFOUND 10 SMALL LIGHT LENS COVERS STAINED YELLOW THRU OUT CABIN. INSTALLED LIGHT LENS COVERS.SDR UALA2012101905981Lens · defectiveFOUND 40 LENS COVERS THRU OUT CABIN STAINED YELLOW AND REQUIRE REPLACEMENT PCN 564-1007. INSTALLED LENS COVERS THRU OUT COACH. REQUIRES RETAINERS ON LEN COVERS.SDR UALA2012100505642Switch · dirtyEMERGENCY LIGHTS UNARMED LIGHT DID NOT EXTINGUISH WITH SWITCH IN ARM OR ON. CLEANED ARMING SWITCH MICRO SWITCHES. OPS CHECKED NORMAL.SDR UALA2012091905317Striker · defectiveCOCKPIT DOOR EXCESSIVELY TIGHT. REPLACED ELECTRIC STRIKE ASSY PER AMM, OPS CHECK GOOD.SDR UALA2012082004597Valve · misriggedWHILE SERVICING CREW O-2 FOUND INDICATION ERRONEOUS BETWEEN FLT DECK AND BOTTLE, ALSO MAIN BOTTLE WON'T FILL TO FULL. FOUND O-2 BOTTLE VALVE SAFETIED TO OFF POSITION, OPENED VALVE AND SERVICED BOTTLE TO FULL, ALL INDICATIONS NORMAL.SDR UALA2012062903413Lamp · inoperativeFWD LAVATORY LIGHTS INOPERATIVE. RELAMPED, OPS CHECKED GOOD.SDR UALA2012030601424Floorbeam · corrodedFLOORBEAM AT STA 377 RBL 56 HAS CORROSION AROUND CLIP NUT HOLE. WORK ACCOMPLISHED ON SCAL NR 9961277. MAJOR REPAIR ACCOMPLISHED: REPAIRED FLOORBEAM PER ECRA 5310-05460. CF CREATED TO ACCOMPLISH A PERMANENT REPAIR ON OR BEFORE 3-4-2013. PLANNING TO CONTACTSDR UALA2012030601421Structure · corrodedCORROSION BETWEEN PRESSURE DECK AND BEAM STA 1681 RBL 38 TO 41. MAJOR REPAIR ACCOMPLISHED: CORROSION REPAIRED BETWEEN PRESSURE DECK AND FLOORBEAM AT STATION 1681, RBL 3 TO 53 PER ECRA 5310-05446. SEE NR 9961458-9960477-9960480-9961495.SDR UALA2012030601418Floorbeam · corrodedFLOORBEAM UPPER CHORD SEVERE EXFOLIATION CORROSION STA 310 RBL 26-38. SEE NR 9960422. *SUPPLEMENTAL DATA UPDATE* ACCOMPLISHED REPAIR PER ECRA 5310-05447.SDR UALA2012030501355Skin · damagedSKIN DAMAGED DURING FASTENER REMOVAL AT APPROX STA 570 RBL 5 JUST INBD OF S-1R. MAJOR REPAIR ACCOMPLISHED. RMV'D DAMAGE SECTION OF SKIN FABBED DOUBLER AND INSTALLED REF SRM 53-00-01 REPAIR 3. CF CREATED TO INSPECT AT 25000 CYC AND REPEAT INSPECT EVERY 3000 SDR UALA2012030501324Crease Beam · corrodedCREASE BEAM WEB HAS CORROSION RT SIDE BS-960. MAJOR REPAIR ACCOMPLISHED PER ECRA 5310-05463 ON SCAL LP# 9961379.SDR UALA2012030501323Crease Beam · corrodedCABIN, CREASE BEAM WEB BETWEEN STA 1400-1420 RT SIDE HAS CORROSION AT TOP SURFACE. MAJOR REPAIR ACCOMPLISHED. REPAIRED CREASE BEAM PER ECRA 5310-05463 DURING SCAL HMV ON LOG PAGE 9961173.SDR UALA2012030501322Skin · damagedLEFT FUSELAGE STA 580 AND BETWEEN STRINGERS 23L AND 22L HAS SEVERAL BLENDOUTS 4 EA MARKED. ACCOMPLISH RII INSPECTION OF AMIS ITEM 8262152. REPAIRED IN ACCORDANCE WITH ECRA 5330-04211. ACCOMPLISHED DURING SCAL HMV. ACCOMPLISH INITIAL INSPECTION ON OR BEFORESDR UALA2012030201308Skin · dentedDENT ON FUSE STA 525 REPAIRED PER ECRA 5330-04210. WORK ACCOMPLISHED DURING SCAL HMV ON LP 9960565. ACCOMP INITIAL INSPECTIONS PER PART 2 ON OR BEFORE THE AIRCRAFT REACHING 50,000 CYCLES PERFORM REPEAT AT INTERVALS NOT TO EXCEED 12,000 FLT CYC THEREAFTER. RSDR UALA2012030201297Floorbeam · puncturedFLOORBEAM WEB PUNCTURED AT STA 310 RBL 12 ABOVE LOWER CHORD. REPAIRED PER ECRA 5310-05 443. ACCOMPLISHED REPAIR AT STATION 310 FLOORBEAM WEB AT RBL 12. ACCOMPLISHED DURING SCAL HMV ON LOG PAGE 9962 010.SDR UALA2012022901255Floorbeam · corrodedFLOORBEAM AT STA 1640 SHOWS NUMEROUS SPOTS OF CORROSION ON EXISTING CAP REPAIR FROM LBL 10-RBL 56. REPAIRED PER E CRA 5310-05453. ALL STEPS COMPLIED WITH ON ECRA 5310-05453 REV A. WORK ACCOMPLISHED ON SCAL NR 9960499.SDR UALA2012022901248Floorbeam · corrodedFLOORBEAM UPPER CHORD SEVERE EXFOLIATION CORROSION STA 324 RBL 42.5 THROUGH RBL 64.5. MAJOR REPAIR ACCOMPLISHED. REPAIRED STA 324 FLOORBEAM AS PER ECRA 5310-05452.SDR UALA2012022901247Crease Beam · corrodedCREASE BEAM AT STA 1200 RT HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. CREASE BEAM REPLACED.SDR UALA2012022901245Skin · dentedFOUND DENT ON WALK AROUND ON RT SIDE OF FUSELAGE AT BS 446 BETWEEN STR 15R AND STR 16R. DENT MEASURES 2"W X 3"L X .093"D. A OVER Y RATIO IS 18.6. DENT IS IN FIELD AREA. NO FASTENERS OR SUB STRUCTURE IN INVOLVED. DENT IS NOT GOUGED OR SCRATCHED AND ROUND BSDR UALA2012022801236Gate · corrodedR2 DOOR LWR GATE CORRODED ON EDGES. INSTALLED NEW R2 LOWER GATE REF MM 52-11-38. VERIFIED NEW PART NUMBER 143N6106-46 REFERENCE UAL IPC 52-11-01- 030. RII INSPECTED.SDR UALA2012022801228Gate · corrodedNR 1 RT SERVICE ENTRY DOOR LOWER GATE HAS LEVEL 1 CORROSION IN SEVERAL PLACES. REPLACED R-1 DOOR LOWER GATE PER 52-10-02 P/N 141N6206-23 ON SCAL LOG #9960061.SDR UALA2012022801227Gate · corrodedR4 DOOR LOWER GATE CORRODED ON EDGES. REMOVED & REPLACED R4 DOOR LOWER GATE WITH P/N 146N6106-64 REF SRM 51-40-02.SDR UALA2012022801226Gate · corrodedL2 DOOR LOWER GATE CORRODED. REPLACED L2 DOOR GATE PER AMM 52-11-13, P/N 143N6106 ON SCAL LOG 9960576.SDR UALA2012022801225Support · corrodedGALLEY SUPPORT CORRODED BS 300 RBL 39 THRU RBL 42. REPLACED MOUNT SUPPORT P/N 141N516U8 ON SCAL LOG.
Back to N504UA, cancelled Mar 10, 2015