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.
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
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 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.SDR CALA2017011300092Connector · contaminatedL5 DOOR SIDEWALL EMERGENCY EXIT LIGHT INOPERATIVE. FOUND THE COONECTOR WATER SATURATED. DRIED AND SECURED THE CONNECTOR. OPS CHECKED OK.SDR CALA2017011300091Lamp · inoperativeRIGHT SIDE ISLE OVERHEAD EMERGENCY LIGHT AT SEAT 47 FOUND INOPERATIVE. REPLACED THE LAMPS IAW WDM 33-51-61, OPS CHECKED OK.SDR CALA2017011300094Lamp · inoperativeOVERHEAD EMERGENCY LIGHT LEFT ISLE AT ROW 55 IS INOPERATIVE. REPLACED THE LAMP IAW WDM 33-51-62, OPS CHECKED OK.SDR CALA2017011300090Light · inoperativeEMERGENCY LIGHT ON SEAT 38 KJH INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED OKSDR CALA2017011300096Light · inoperativeEMERGENCY LIGHT AT SEAT 35 ABC IS INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED GOOD.SDR CALA2017011300095Lamp · inoperativeOVERHEAD EMERGENCY LIGHT LEFT ISLE AT ROW 50 IS INOPERATIVE. REPLACED THE LAMP IAW WDM 33-51-62, OPS CHECKED GOOD.SDR CALA2016070895515Connector · disconnectedEMERGENCY LIGHTS INOPERATIVE AT SEAT ROW 23, 24, & 25 ABC. CONNECTED CONNECTOR AND PERFORMED OPS TEST SATISFACTORY.SDR CALA2016070895514Connector · unsecureEMERGENCY LIGHTS INOPERATIVE AT SEAT ROW 53 ABC. SECURED CONNECTOR AND PERFORMED OPS TEST SATISFACTORY.SDR CALA2016070895513Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 33KJH TO 45KJH. POWER SUPPLY REPLACED AND SYSTEM OPERATION TEST OKSDR 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.SDR 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 EMERSDR 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.SDR 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.SDR CALA2015051893796Light · failedRUBBER BURNING SMELL IN UPPER DECK GALLEY ELEVATOR, SUSPECT FAILED LIGHT ASSEMBLY. REPLACED ASSEMBLY, NO FURTHER BURNED SMELLS DETECTED.SDR 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.SDR CALA2015012793028Skin · dentedEXTERNAL FUSELAGE BS 2295 - 2300, STRINGER 20R - 21R DENT. REMOVED DAMAGE, FABRICATED & INSTALLED REPAIR PARTS IAW ECRA 5330-05027.SDR 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.SDR 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.SDR 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. SDR 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 DSDR 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.SDR CALA2013122793996Light · inoperativeALL FOUR LT SIDE OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED M7919 IAW WD 33-51-42, OPERATIONS NORMAL.SDR CALA2013122793992Light · inoperativeLT SIDE SLIDE LIGHT INOPERATIVE, 3RD LIGHT DOWN FROM THE TOP, RELAMPED LIGHT.SDR 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 SEALSDR CALA2013091891286Oxygen Mask · failedSECOND OBSERVERS OXYGEN MASK FAILED TEST.SDR CALA2013090991103Cart · defectiveFOUR PIGTAILS AFT GALLEY INOPERATIVE. REPLACED ALL CARTS NOW OKSDR 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.SDR 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.SDR 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 & RECONNESDR CALA2013081990533Panel · damagedOTBD NR 1 SAIL TAIL DOOR HAD POPPED RIVETS ON L/E APPROX 1 FT FROM LOWER EDGE. INSTALLED PANEL.SDR CALA2013080890261Failsafe · crackedBS 1220, FRAME DOUBLER & FAILSAFE CRACKED.SDR CALA2013080890247Frame · mismanufacturedBS 1265, FRAME MISMANUFACTURED. REPAIRED IAW ECRA 5310-05788.SDR CALA2013080690172Frame · crackedBS 1265, FRAME WEB, NR 1 FASTENER HOLE CRACKED. REPAIRED.SDR CALA2013073190102Skin · crackedBS 2650, S11L FUSELAGE SKIN CRACK. INTERIM REPAIR. REMOVED DAMAGE. HFEC. MFG AND INSTALLED REPAIR.SDR CALA2013072990009Skin · corrodedBS 1840-1860, S51L-S51R, SKIN CORRODED. MAJOR REPAIR ACCOMPLISHED REMOVED DAMAGED HFEC AND INSTALLED REPAIR.SDR CALA2013072990008Skin · corrodedBS 1840-1860, S51L-S51R SKIN CORRODED. REMOVED DAMAGE, HFEC, AND INSTALLED REPAIR.SDR 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 REPAIRSDR CALA2013082090609Frame · damagedBS 1180 FRAME CRACKED AT TENSION TIE. REMOVED DAMAGED, HFEC. INSTALLED NEW FRAME IAW SRM 51-40-02. MAJOR REPAIRSDR CALA2013073090089Doubler · crackedBS 1180, LEFT FRAME DOUBLER CRACK AT TENSION TIE. REMOVED DOUBLER. HFEC INSTALLED NEW DOUBLER IAW SRM 51-40-02. MAJOR REPAIRSDR CALA2013072990058Radome · damagedBS 1840 & 1900 GCS RADOME FASTENER HOLES MISDRILLED. REPAIRED IAW ECRA 5330-04636.SDR 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.SDR CALA2013072990056Floorbeam · corrodedBS 520, RBL 33 FLOORBEAM CORRODED ON UPPER TEE. REMOVED DAMAGE. HFEC AND INSTALLED REPAIR PARTS IAW S 53-10-51, REPAIR 3.SDR CALA2013072990055Bulkhead Web · crackedBS 1480, BULKHEAD WEB CRACKED, LBL 107. REPAIRED IAW ECRA 5310-05780.SDR 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.SDR 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.SDR 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.SDR UALA2013071905064Skin · damagedFUSELAGE SKIN BS 560-580 BELOW S27L DAMAGED. REPAIRED AT IAW SRM 53-00-01, REPAIR 1.SDR 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.SDR UALA2013071905062Floorbeam · corrodedBS 1660, MAIN DECK FLOORBEAM AT RBL 25 CORRODED. REMOVED DAMAGE. HFEC. CAT "A" REPAIRED IAW ECRA 5320-02155. MAJOR REPAIR.
Back to N179UA, cancelled Aug 17, 2017