N556UA, cancelled Dec 7, 2016
Service difficulty reports · 142
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 = 'N556UA' AND deregistration_id = 'N556UA-2016-12-07' 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 = 'N556UA' AND deregistration_id = 'N556UA-2016-12-07' 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 CALA2014012890254Vsi · failedVERTICAL SPEED INDICATOR SHOWS OFF FLAG AT ALTITUDE, STOPPED WORKING.SDR CALA2013112793298Strap · unsecureCRASH AXE RETENTION STRAP FALLING OFF, NEEDS ANCHORING. SECURED STRAP & STOWED CRASH AXE.SDR CALA2013110592663Unknown · malfunctionedUPON RETURN TO AIRCRAFT THE COCKPIT DOOR WAS CLOSED. ATTEMPTED TO GAIN ACCESS USING EMERGENCY PROCEDURES, FLIGHT CREW ENTERED CODE SEVERAL TIMES TO GAIN ENTRY TO CONTROL CABIN, NO HELP. HAD TO SHUT OFF APU USING FIRE HANDLE. FLT CREW TRIED 2 TIMES TO OPEN DSDR CALA2013102992483Bumper · damagedNR 2 ENG REVERSER SLEEVE OTBD SIDE AT 3 O'CLOCK POSITION BUMPER ASSEMBLY DAMAGED PREVENTING TRANSLATING SLEEVE FROM PROPERLY STOWING. REPLACED POSITION BUMPER ASSEMBLY IAW IPC 78-31-10-005 ITEM 148.SDR CALA2013081990539Striker · inoperativeFLT DECK DOOR ENTRY PAD NR 1 DOES NOT SOUND FOR ENTRY. R & R FLIGHT DECK DOOR ELECTRIC STRIKER IAW AMM. OPS CHECKED GOOD.SDR UALA2013072305160Unknown · unknownR4 DOOR ARM LIGHT DOES NOT ILLUMINATE. REPLACED LAMP IN R4 DOOR ARMED LIGHT. LIGHT WORKS FOR A COUPLE OF CYCLES THEN DOES NOT WORK.SDR UALA2013071204870Cover · unsecureEMERGENCY FLOOR LIGHT IS PEELING AT ROW 10. SNAP BACK ON FLOOR LIGHT STRIP COVER. ACFT OK TO CONT.SDR UALA2013062604428Actuator · leakingNR 1 ENGINE ACCUMULATED A LARGE PUDDLE OF HYD FLUID ON GROUND IN LESS THAN 30 MINS. RAN THRUST REVERSER AND FOUND ACTIVE LEAK COMING FROM ROD END OF INBD CENTER ACTUATOR. STARTED REMOVAL AND INSTALLATION IAW AMM.SDR UALA2013060603931Cover · looseEMERGENCY EXIT LIGHTS ROW 11-12 ABC SEPARATING FROM THE FLOOR. INSURED 11 ABC EXIT LIGHT COVER IS SECURE. CHECKED OK.SDR UALA2013052803719Handset · malfunctionedHANDSET HAS A LOUD SQUEAL WHEN FIRST OFFICER TRANSMITS. REPLACED HANDSET.SDR UALA2013052003483Sensor · faultyCREW REPORTED CABIN HOT & SLOW TO COOL, TOOK TWO HOURS. RT PACK CONTROLLER SHOWS RT PACK SENSOR FAULT. REPLACED RT PACK NR 1 TEMP SENSOR IAW MM. LEAK AND OPS CHECKED GOOD.SDR UALA2013050203057Sealant · deterioratedABNORMAL NOISE, VIBRATION AROUND L GLARESHIELD OR L WINDSHIELD AREA. CREW COMMENTS: CONSTANT SOUND OF AIR ESCAPING ON CAPT SIDE UPPER PART OF SIDE WINDOWS. FOUND SILICONE DETERIORATING UPPER FORWARD CORNER. APPLIED NEW SEALANT PER MM 56-11-02.SDR UALA2013043003036Cover · detachedTOP PLATE COVER FOR CARGO FIRE DISCHARGE BUTTONS NOT ATTACHED. COMPLIED WITH ECRA 2623-0104.SDR UALA2013040902392Window Frame · loose20F EMERGENCY EXIT WINDOW FRAME LOOSE. SECURED WINDOW FRAME.SDR UALA2013040802342Cap · missingSEAT 8C EMERGENCY LIGHT END CAP IS MISSING. REPLACED END CAP.SDR UALA2013040802341Cap · missingSEAT 1B EMERGENCY LIGHT MISSING END CAP. REPLACED END CAP.SDR UALA2013040802340Light · looseEMERGENCY LIGHT AT ROWS 11A AND 11B LOOSE. SECURED LIGHT.SDR UALA2013040802339Cover · unsecureEMERGENCY LIGHT ROW 11 UNSECURE. SECURED EMERGENCY LIGHT COVERED, OPS CHECKED GOOD.SDR UALA2013040802338Light · missingAIRCRAFT MISSING FLOOR EMERGENCY LIGHT IN FRONT OF MID LAV DOOR. REPLACED MISSING EMERGENCY LIGHT AT DOOR 2 LAV IAW DWG 15F6889 AND MM 33-51-95. OP CHECKED OK.SDR UALA2013040802337Light · missingAIRCRAFT IS MISSING ORANGE EMERGENCY LIGHT BY FIRST CLASS CLOSET DOOR. INSTALLED MISSING EMERGENCY LIGHT PER MM, OPS CHECKED OKAY.SDR UALA2013040802336Carpet · mismanufacturedPER IPC 33-52-00 AIRCRAFT IS MISSING EEL FLOOR LAMP IN FRONT OF AFT FWD LAV DOOR. EEL FLOOR LAMP IS PRESENT BUT IS COVERED BY CARPET. TRIMMED CARPET AND REPAIRED EEL LAMP PER MM AND IPC. OP CHECKS OKAY.SDR UALA2013021800929Charger · faultyMAIN BATTERY CHARGER MESSAGE ON STATUS PAGE. T-SHOT PER FIM 24-31-00. REPLACED BATTERY CHARGER PER MM 24-31-02.SDR UALA2013021800918Connector · unsecureEMERGENCY EXIT SIGNS DO NOT ILLUMINATE DURING EMERGENCY LIGHT TEST. SECURED LOOSE CONNECTOR ON INVERTER M110834.SDR UALA2013021800917Fan · damagedDUE TO REPORTED HEAT DAMAGE TO INSULATION IN AREA OF FORWARD EQUIPMENT COOLING FANS, IDENTIFY SOURCE OF HEAT, REPAIR ANY DISCREPANCIES AND REPORT FINDINGS TO 757 FLEET CONTROLLER. CONCLUSION OF HEAT SOURCE WAS RECIRC FAN IN FWD CARGO PIT. PERFORMED EG7709. SDR UALA2013021500903Connector · unsecureDURING EMERGENCY LIGHT TEST OVERWNG EXIT AT 21F INOP. SECURED CONNECTOR AT SEAT 21ABC, IT POWERS 21F ALSO. OPS CHECK NORMAL.SDR UALA2013021500902Connector · looseDURING EMERGENCY LIGHT TEST OVERWING EXIT AT 20A INOP. TROUBLESHOOTING FOUND CONNECTOR ON INVERTOR AT SEAT 21ABC LOOSE, IT POWERS SEAT 20A ALSO. OPS CHECK NORMAL.SDR UALA2013021200837Fitting · corrodedLEFT MLG CENTER MOUNT FITTING VERTICAL FLANGE IS CORRODED. INSTALLED NEW FITTING IAW EA 130167IR.SDR UALA2013021200835Skin · dentedFOUND DENT JUST UNDER MID LAVATORY SERVICE PANEL TWO INCHES ABOVE STRINGER 23 AT BS 720. NO CRACKS PRESENT. BLENDED OUT SCRATCH, INSTALLED DOUBLER REPAIR PER ECRA 5330-04439 AND EA 130164.SDR UALA2013021100829Wire · brokenAFT EQUIP EXHAUST FAN CONNECTOR D2360, WIRE W2634-0006-16 IS BROKEN ONE INCH FROM CONNECTOR. SPLICED IN NEW PIECE OF WIRE, TERMINATED AND INSTALLED IN CONNECTOR D2360. OPS CHECKED GOOD REF AMM 21-58-00.SDR UALA2013021100792Skin · wornLEFT WING INBD MAIN FLAP OUTBOARD UPPER SURFACE WORN. INSTALLED REPAIR DOUBLER AND TRIPLER PER ECRA 5750-04524 AND EA 130134 REV IR.SDR UALA2013021100790Beam · damagedFWD CARGO BAY, BS 570, RBL 22, DOOR CUTOUT, LOWER MAIN SILL BEAM UPPER ANGLE HAS EXISTING MISDRILLED HOLES ADJACENT TO NUT PLATE HOLE. INSTALLED FREEZE PLUG REPAIR PER ECRA 5330-04433, & EA 130118 REV IR.SDR UALA2013021100828Floorbeam · corrodedCORROSION ON EXISTING REPAIR STA 365 FLOORBEAM UPPER CORD AT LBL 11 TO THE RIGHT END OF JOINT. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR PER ECRA 5310-05680 AND ARR EA 130071 IR.SDR UALA2013021100791Skin · damagedRIGHT EXT SKIN STA 800-860, WL 200 - 212 ALONG CONTACT SURFACE FOR BODY FAIRING PANEL HAS SCRIBE MARKS. MAINT TEXT: INSTALLED DOUBLER RPR PER ECRA 5330-04430, AND AAR EA 130084IR.SDR UALA2013021100780Skin · dentedSKIN DENTED AT BS 664, WL 209, S17L. CUT OUT DAMAGED SKIN AND INSTALLED DOUBLER REPAIR PER ECRA5330-04423 AND EA 130077 REV IR. STAGE II CATEGORY B MAJOR REPAIR.SDR UALA2013021100811Wire · damagedWIRE REPAIR. DOOR 4R AFT GIRT BAR PROX SWITCH WIRING HAS DAMAGE TO PRIMARY INSULATION. MAINT TEXT: SPLICED REPAIRED WIRES W3682-F-PA AND W3682-F-GA PER SWPM20-10-13, WDM25-66-11. STA 1644, WL 240, RBL 40. OPS CHECKS GOOD REF AMM 52-11-96. PERMANENT RPR.SDR UALA2013021100810Wire · damagedWIRE REPAIR. DOOR 4R FWD GIRT BAR PROX SWITCH, S10224, HAS DAMAGE HISTORY. SPLICE WIRE W3682E PA (RED) AT STA 1644 PER WDM25-66-11, AND SWPM20-30-12. OPS CHECKS GOOD REF AMM 52-11-96 STEP E. THIS IS PERMANENT RPR.SDR UALA2013021100809Wire · damagedDAMAGED WIRES. DOOR 1R, FWD GIRT BAR FITTING HAS DAMAGED WIRES. SPLICE RPR WIRES W3682-003-20 AND W3682- 001-20 PER SWPM 20-30-12 AND GNMM 05-30-40, WDM25-66-11. OPS CHECKS GOOD REF AMM52-11-96, PG 607. LOCATED STA 344.SDR UALA2013021100806Skin · dentedEXT FUSELAGE SKIN HAS DENT, STA 800, BETWEEN STR 13R AND 14R. MAINT TEXT: CUT OUT DAMAGED SKIN DOUBLER RPR REF ECRA 5330-04427 AND AAR EA 130078 REV IR. RPR DOUBLER STA 790 - 803, STR 12R - 15R.SDR UALA2013020800769Floorbeam · corrodedFORWARD CABIN WET AREA TRANSVERSE FLOORBEAM UPPER TEE CORRODED BS 310.5, RBL 35 TO 41. CUT OUT DAMAGE AND INSTALLED REPAIR PER ECRA 5310-05675 AND AAR EA 130069 REV IR. MAJOR REPAIR.SDR UALA2013020800758Skin · damagedFORWARD LOWER FUELAGE SKIN HAS LIGHTNING STRIKE AT BS 366, ABOVE STR 27R. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECRA 5330-04422. CAT B MAJOR REPAIR.SDR UALA2013020700737Crease Beam · corrodedCABIN FWD WET AREA CREASE BEAM WEB CORRODED UNDER R1 DOOR THRESHOLD, BS 355-365, RBL 63. REMOVED AND INSTALL NEW CREASE BEAM IAW DWG 141N8422. MAJOR REPAIRSDR UALA2013020600724Skin · dentedL1 DOOR HAS A DENT, 5.5 INCHES FROM LOWER EDGE. CUT OUT DAMAGE, INSTALLED DOUBLER REPAIR WITH FLUSH FASTENERS PER SRM 52-10-01, REPAIR 7, FIG 201. HFEC DAMAGE REMOVE PER NDT PT 6, 51-00-19, ALL DAMAGE REMOVED. MAJOR REPAIRSDR UALA2013020700736Window · scratchedL3 WINDOW SCRATCHED. L3 WINDOW REPLACED IAW TC 521140001.SDR UALA2013020600723Attach Angle · corrodedBS 1816 AT S6R APU INLET DOOR ATTACH ANGLE CORRODED. FABRICATED NEW ATTACH ANGLE, STRAPS, & ANGLE. INSTALLED IAW SRM 53-80-15 FIG 202, DETAIL I, AND SRM 51-40-02. MAJOR REPAIRSDR UALA2013020400639Floorbeam · corrodedCABIN FWD WET AREA. FLOORBEAM CORRODED BS 333 RBL 7-23. REMOVED CORROSION, FOUND OUT OF LIMITS. FABRICATED NEW FLOORBEAM IAW SRM 53-00-04, 51-10-02, 51-21-01 & GMMN 1-0-1-007. MAJOR REPAIR.SDR UALA2013020400637Crease Beam · corrodedCABIN FWD WET AREA. CREASE BEAM INNER STRUCTURE CORRODED AT BS 415-419 RBL 63. REMOVED CORROSION FROM BEAM OUT OF LIMITS. REMOVED & FABRICATED NEW CREASE BEAM IAW 53-00-51, 51- 40-02, 51-40-05, 51-20-01 AND INSTALLED CREASE BEAM SRM 51-40-02 & DWG 141N 842SDR UALA2013020400636Skin · dentedRIGHT WING I/B FLAP LOWER SURFACE 25 INCH OF O/B EDGE AND 2. 5 FWD OF T/E HAS SMALL DENT. MAJOR REPAIR ACCOMPLISHED. EVALUATED DAMAGE ON RT WING I/B FLAP LWR SKIN & FOUND TO BE OUT OF LIMITS SRM 57-53-01, REMOVED DAMAGE VERIFIED MATERIAL & FABRICATED DOUBLERSDR UALA2013020400635Crease Beam · corrodedCABIN FWD AREA CREASE BEAM INNER CHORD CORRODED AT STA 439 RBL 63. MAJOR REPAIR ACCOMPLISHED. REMOVED BEAM STA 349 FABRICATED NEW BEAM TAG A42735, INSTALLED BEAM IAW SRM 53-00-51,51-4 0-02, 51-40-05, 51-40-05, 51-20-01, 53-60-51 & DWG 140N0504.SDR UALA2013013100581Skin · damagedDURING THE SCRIBE INSPECTION AN AREA OF DAMAGE WAS NOTED NOT A SCRIBE BUT POSSIBLE TOOLING DAMAGE AT STRINGER 10L TWO INCHES LONG BETWEEN BS 1706 AND 1708 .072 FROM BELOW LAP .0064 DEEP PER SRM 53-00-01 PAGE 105 ZONE A.SDR UALA2013012900534Skin · dentedFUSELAGE SKIN DENTED BELOW STRINGER 20L, BS 752. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM. MAJOR REPAIR
Back to N556UA, cancelled Dec 7, 2016