N179UA, cancelled Aug 17, 2017

Service difficulty reports · 391

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 = 'N179UA' AND deregistration_id = 'N179UA-2017-08-17'
  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.

SDR CALA2017011300093Connector · contaminatedEMERGENCY LIGHTS ON LEFT SEATS FROM 45 TO 60 ABC ARE INOPERATIVE. FOUND THE CONNECTOR WATER STATURATED. DRIED AND SECURED THE CONNECTOR. OPS CHECKED OK.Jan 13, 2017 · N179UA · Boeing 747422 · Light System WiringSDR CALA2017011300092Connector · contaminatedL5 DOOR SIDEWALL EMERGENCY EXIT LIGHT INOPERATIVE. FOUND THE COONECTOR WATER SATURATED. DRIED AND SECURED THE CONNECTOR. OPS CHECKED OK.Jan 13, 2017 · N179UA · Boeing 747422 · Light System WiringSDR CALA2017011300091Lamp · inoperativeRIGHT SIDE ISLE OVERHEAD EMERGENCY LIGHT AT SEAT 47 FOUND INOPERATIVE. REPLACED THE LAMPS IAW WDM 33-51-61, OPS CHECKED OK.Jan 13, 2017 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2017011300094Lamp · inoperativeOVERHEAD EMERGENCY LIGHT LEFT ISLE AT ROW 55 IS INOPERATIVE. REPLACED THE LAMP IAW WDM 33-51-62, OPS CHECKED OK.Jan 13, 2017 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2017011300090Light · inoperativeEMERGENCY LIGHT ON SEAT 38 KJH INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED OKJan 13, 2017 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2017011300096Light · inoperativeEMERGENCY LIGHT AT SEAT 35 ABC IS INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED GOOD.Jan 13, 2017 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2017011300095Lamp · inoperativeOVERHEAD EMERGENCY LIGHT LEFT ISLE AT ROW 50 IS INOPERATIVE. REPLACED THE LAMP IAW WDM 33-51-62, OPS CHECKED GOOD.Jan 13, 2017 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2016070895515Connector · disconnectedEMERGENCY LIGHTS INOPERATIVE AT SEAT ROW 23, 24, & 25 ABC. CONNECTED CONNECTOR AND PERFORMED OPS TEST SATISFACTORY.Jul 3, 2016 · N179UA · Boeing 747422 · Light System WiringSDR CALA2016070895514Connector · unsecureEMERGENCY LIGHTS INOPERATIVE AT SEAT ROW 53 ABC. SECURED CONNECTOR AND PERFORMED OPS TEST SATISFACTORY.Jul 3, 2016 · N179UA · Boeing 747422 · Light System WiringSDR CALA2016070895513Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 33KJH TO 45KJH. POWER SUPPLY REPLACED AND SYSTEM OPERATION TEST OKJul 3, 2016 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2016060695436Wire · chafedEMERGENCY EXIT LIGHT ON WHEN IN ARMED POSITION, FOUND WIRE CHAFED AT ATTENDANTS SEAT DOOR 1 LT HANDSET CRADLE. REPAIRED VIA TWO SPLICES, OPERATIONS TESTED OK.Jun 5, 2016 · N179UA · Boeing 747422 · Light System WiringSDR CALA2016033195247Spring · missingEMERGENCY EXIT LIGHTS TURN ON WITH THE SWITCH IN THE OFF POSITION. FOUND GUARD ON EMER LIGHT SWITCH AT DOOR 1L MISSING SPRINGS & SLIDING OVER PUSH BUTTON SWITCH & ENGAGING EMER LIGHTS. REPLACED GUARD IAW IPC 33-21-56-01 & ACCOMPLISHED OPERATION CHECK OF EMERMar 29, 2016 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2015080394179Socket · burnedBURNING ODOR NEAR SEAT 15 UPPER DECK. IAW FIM 21-00-08 FOUND SEAT 15K LIGHT TUBE SOCKET BURNT. NO MORE ODOR OR FUME SMELL.Aug 3, 2015 · N179UA · Boeing 747422 · Passenger Compartment LightingSDR CALA2015061893990Power Supply · defectiveROWS 54 - 61 RT SIDE AISLE EMER LIGHTS & DOOR 5R EMER LIGHT ILLUMINATES INTERMITTENT. IAW FIM 33-51 TASK REPORT PG 302 ITEM 3 FOUND LIGHTS ON DIM INTERMITTENTLY. REPLACED POWER SUPPLY M6012 IAW MM 33-51-04 PG 201. TESTED NORMAL.Jun 18, 2015 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2015051893796Light · failedRUBBER BURNING SMELL IN UPPER DECK GALLEY ELEVATOR, SUSPECT FAILED LIGHT ASSEMBLY. REPLACED ASSEMBLY, NO FURTHER BURNED SMELLS DETECTED.May 16, 2015 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2015021293148Motor · odorELECTRICAL ODOR IN SERVICE ELEVATOR SHAFT, DEACTIVATED THE MOTORS IAW MEL. VERIFIED NO EVIDENCE OF ODOR IN ELEVATOR SHAFT EXCEPT MOTORS. THERE IS THE ELEC ODOR FROM HOT MOTORS. CHECKED THE ELEVATOR & WIRES ARE NORMAL.Feb 10, 2015 · N179UA · Boeing 747422 · Buffet/GalleysSDR CALA2015012793028Skin · dentedEXTERNAL FUSELAGE BS 2295 - 2300, STRINGER 20R - 21R DENT. REMOVED DAMAGE, FABRICATED & INSTALLED REPAIR PARTS IAW ECRA 5330-05027.Jan 25, 2015 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR CALA2015012793027Skin · crackedFUSELAGE SKIN CUT OUT AT MED DOOR 5L UPPER AFT CORNER FOUND CRACKED. INTERIM REPAIR INSTALLED IAW ECRA 5331-02001 REV A & E A5331-01798 OP9 OP10 & REF PTT SEQ4956264. THIS IS A CAT B REPAIR.Jan 25, 2015 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR CALA2015012793025Skin · corrodedRIGHT FUSELAGE SKIN AT WASTE SYS, OVERBOARD VENT BS 2090 STRINGER 35 - 36R, FOUND CORRODED. FUSELAGE SKIN REPAIRED IAW SRM 53-60-01 REPAIR 5 FIG 201 DETAIL 2 PAGE 202 REV 91.Jan 24, 2015 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR CALA2014040890790Roller · brokenWHILE OPENING THE DOOR 5L UPON ARRIVAL, THE RAMP AGENT REPORTED THAT HE HEARD A LOUD BANG & THE DOOR WAS THEN HANGING CROOKED. FOUND L5 DOOR EMERGENCY SYS LINKAGE ARM ROLLER & BEARING BROKEN. CLOSED & LOCKED L5 DOOR. PERFORMED PRESS CHECK, NO LEAKS NOTED. Apr 5, 2014 · N179UA · Boeing 747422 · Passenger/Crew DoorsSDR CALA2014021090355Cooling Fan · failedFAINT ODOR IN FLIGHT DECK & POSSIBLY AROUND DOOR 1R. FOLLOWED CHECKLIST 5.1 SHUTOFF TRIM AIR, NR 2 PACK & SHUTOFF BLEED ISOLATION VLVS TO ISOLATE BLEED SYSTEM AS WELL AS SHUTTING DOWN UTILITY BUSSES. FLIGHT ATTENDANT BROUGHT IN TO CONFIRM PRESENCE OF ODOR DFeb 7, 2014 · N179UA · Boeing 747422 · Air Distribution FanSDR CALA2013122393900Electronic Unit · faultyAFT GALLEY CHIME GOING CONTINUOUSLY. REPLACED OEU AT DOOR 5 RT POSITION 3-2-15, OPERATIONS CHECKED AFT CROW SMOKE PANEL, ALL LIGHT TEST.Dec 22, 2013 · N179UA · Boeing 747422 · Smoke DetectionSDR CALA2013122793996Light · inoperativeALL FOUR LT SIDE OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED M7919 IAW WD 33-51-42, OPERATIONS NORMAL.Dec 14, 2013 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2013122793992Light · inoperativeLT SIDE SLIDE LIGHT INOPERATIVE, 3RD LIGHT DOWN FROM THE TOP, RELAMPED LIGHT.Dec 14, 2013 · N179UA · Boeing 747422 · Emergency LightingSDR CALA2013100191618Sealant · misinstalledFOUND MULTIPLE CORNERS OF DOOR 5L WITH IMPROPER SEALING TECHNIQUE ACCOMPLISHED. CLEANED OUT ALL SEALANT THAT DOES NOT STICK TO DOOR STRUCTURE. REAPPLIED NEW RTV102 TO ALL AREAS EFFECTED BY IMPROPER CLEANING OF DOOR IAW REF MM 52-09-01-4 01 ITEM D8. NEW SEALOct 1, 2013 · N179UA · Boeing 747422 · Passenger/Crew DoorsSDR CALA2013091891286Oxygen Mask · failedSECOND OBSERVERS OXYGEN MASK FAILED TEST.Sep 17, 2013 · N179UA · Boeing 747422 · Crew Oxygen SystemSDR CALA2013090991103Cart · defectiveFOUR PIGTAILS AFT GALLEY INOPERATIVE. REPLACED ALL CARTS NOW OKSep 6, 2013 · N179UA · Boeing 747422 · Buffet/GalleysSDR CALA2013090591008Unknown · malfunctionedWHEN ENGAGING CENTER A-P TO CMD IT DISCONNECTS. AUTOPILOT DISCONNECT EICAS & MASTER. FCC-C TEST PASSED IN CMC. AILERON SERVO TEST FAILED. MESSAGE 22239, NO TIME TO T-S. AIRCRAFT DOWN GRADED TO AUTOLAND LIMIT LAND 2.Sep 2, 2013 · N179UA · Boeing 747422 · Autopilot SystemSDR CALA2013082190638Seal · brokenLIFE VEST SEALS BROKEN, MISSING 2A, 3A, 6K , 8G, 10K. KICK PANEL SEALS BROKEN, MISSING 10A, 20K, 21K, 22K, 23K, 24A, 24K, 25K. REPLACED MISSING SECURITY SEALS.Aug 20, 2013 · N179UA · Boeing 747422 · Emergency EquipmentSDR CALA2013082190639Unknown · unknownEMERGENCY EVACUATION SYSTEM IS EMITTING LOW LEVEL OFF BEAT SIGNAL. PULLED CIRCUIT BREAKER TO SILENCE ALARM, REVIEWED WDM TO VERIFY CIRCUIT BREAKER IS SOLELY FOR EVAC SIGNAL SYSTEM 25- 63-11 & -12. RDF-T :DISCONNECTED ALL DOORS EVAC UNIT & OVERSTAIR & RECONNEAug 18, 2013 · N179UA · Boeing 747422 · Emergency EquipmentSDR CALA2013081990533Panel · damagedOTBD NR 1 SAIL TAIL DOOR HAD POPPED RIVETS ON L/E APPROX 1 FT FROM LOWER EDGE. INSTALLED PANEL.Aug 18, 2013 · N179UA · Boeing 747422 · Standard Practices/StructuresSDR CALA2013080890261Failsafe · crackedBS 1220, FRAME DOUBLER & FAILSAFE CRACKED.Aug 8, 2013 · N179UA · Boeing 747422 · Fuselage Main, StructureSDR CALA2013080890247Frame · mismanufacturedBS 1265, FRAME MISMANUFACTURED. REPAIRED IAW ECRA 5310-05788.Aug 6, 2013 · N179UA · Boeing 747422 · Fuselage Main, FrameSDR CALA2013080690172Frame · crackedBS 1265, FRAME WEB, NR 1 FASTENER HOLE CRACKED. REPAIRED.Aug 6, 2013 · N179UA · Boeing 747422 · Fuselage Main, FrameSDR CALA2013073190102Skin · crackedBS 2650, S11L FUSELAGE SKIN CRACK. INTERIM REPAIR. REMOVED DAMAGE. HFEC. MFG AND INSTALLED REPAIR.Jul 31, 2013 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR CALA2013072990009Skin · corrodedBS 1840-1860, S51L-S51R, SKIN CORRODED. MAJOR REPAIR ACCOMPLISHED REMOVED DAMAGED HFEC AND INSTALLED REPAIR.Jul 29, 2013 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR CALA2013072990008Skin · corrodedBS 1840-1860, S51L-S51R SKIN CORRODED. REMOVED DAMAGE, HFEC, AND INSTALLED REPAIR.Jul 29, 2013 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR CALA2013082090610Floorbeam · damagedBS 1050 LBL 75.92 MAIN DECK FLOORBEAM UPPER TEE CRACKED. REMOVED DAMAGE. PERFORMED HFEC. FABRICATED AND INSTALLED REPAIR PARTS IAW ECRA 5320-02157. MAJOR REPAIRJul 28, 2013 · N179UA · Boeing 747422 · Fuselage Main, Floor BeamSDR CALA2013082090609Frame · damagedBS 1180 FRAME CRACKED AT TENSION TIE. REMOVED DAMAGED, HFEC. INSTALLED NEW FRAME IAW SRM 51-40-02. MAJOR REPAIRJul 28, 2013 · N179UA · Boeing 747422 · Fuselage Main, FrameSDR CALA2013073090089Doubler · crackedBS 1180, LEFT FRAME DOUBLER CRACK AT TENSION TIE. REMOVED DOUBLER. HFEC INSTALLED NEW DOUBLER IAW SRM 51-40-02. MAJOR REPAIRJul 28, 2013 · N179UA · Boeing 747422 · Fuselage Main, FrameSDR CALA2013072990058Radome · damagedBS 1840 & 1900 GCS RADOME FASTENER HOLES MISDRILLED. REPAIRED IAW ECRA 5330-04636.Jul 28, 2013 · N179UA · Boeing 747422 · Aerodynamic FairingsSDR CALA2013072990057Angle · crackedBS 1180, ANGLE CRACKED AT LT TENSION TIE. REMOVED DAMAGE. HFEC, FABRICATED AND INSTALLED REPAIR PARTS IAW A 53-10-99, SRM 53-40-07, REPAIR 4 AND SRM 51-70-11, REPAIR 1.Jul 27, 2013 · N179UA · Boeing 747422 · Fuselage Miscellaneous StructureSDR CALA2013072990056Floorbeam · corrodedBS 520, RBL 33 FLOORBEAM CORRODED ON UPPER TEE. REMOVED DAMAGE. HFEC AND INSTALLED REPAIR PARTS IAW S 53-10-51, REPAIR 3.Jul 27, 2013 · N179UA · Boeing 747422 · Fuselage Main, Floor BeamSDR CALA2013072990055Bulkhead Web · crackedBS 1480, BULKHEAD WEB CRACKED, LBL 107. REPAIRED IAW ECRA 5310-05780.Jul 27, 2013 · N179UA · Boeing 747422 · Fuselage Main, BulkheadSDR UALA2013072505223Tension Tie · damagedBS 1220 RT TENSION TIE FASTENER HOLE HAS SHORT EDGE MARGIN. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30, REPAIR 2.Jul 25, 2013 · N179UA · Boeing 747422 · Fuselage Main, StructureSDR UALA2013072505222Tension Tie · crackedBS 1180, LT TENSION TIE, TWO FASTENER HOLES CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30, REPAIR 2.Jul 25, 2013 · N179UA · Boeing 747422 · Fuselage Main, StructureSDR UALA2013072505221Tension Tie · crackedBS 1140, LT TENSION TIE THREE FASTENER HOLES CRACKED. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30, REPAIR 2.Jul 25, 2013 · N179UA · Boeing 747422 · Fuselage Main, StructureSDR UALA2013071905064Skin · damagedFUSELAGE SKIN BS 560-580 BELOW S27L DAMAGED. REPAIRED AT IAW SRM 53-00-01, REPAIR 1.Jul 19, 2013 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR UALA2013071905063Skin · corrodedBS 1478, FUSELAGE SKIN CORRODED S15-S16R. REMOVED DAMAGE. PERFORMED HFEC. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-00-01 REPAIR 15. MAJOR REPAIR.Jul 19, 2013 · N179UA · Boeing 747422 · Fuselage Main, Plate/SkinSDR UALA2013071905062Floorbeam · corrodedBS 1660, MAIN DECK FLOORBEAM AT RBL 25 CORRODED. REMOVED DAMAGE. HFEC. CAT "A" REPAIRED IAW ECRA 5320-02155. MAJOR REPAIR.Jul 19, 2013 · N179UA · Boeing 747422 · Fuselage Main, Floor Beam
Back to N179UA, cancelled Aug 17, 2017