N615UA, cancelled May 30, 2018
Service difficulty reports · 43
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 = 'N615UA' AND deregistration_id = 'N615UA-2018-05-30' 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 = 'N615UA' AND deregistration_id = 'N615UA-2018-05-30' 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 2003UALA00708Oil Cooler · failedDIVERTED TO SYR DUE TO NR 1 ENGINE OIL PRESSURE INDICATION. REPLACED OIL COOLER. SHOP TEST CONFIRMED OIL COOLER MATRIX LEAKING INTERNALLY, ALLOWING FUEL TO CONTAMINATE THE ENGINE OIL SYSTEM.SDR 2003UALA00398Wire · looseEMERGENCY EXIT LIGHTS FROM SEAT 26F AFT TO AFT GALLEY INOP. SUPPLEMENTAL DATA UPDATE SECURED LOOSE LEAD WIRE CONNECTORS AT EEL.SDR 2003UALA00416Warning Light · illuminatedA/C RECEIVED LEFT GENERATOR DRIVE LIGHT INDICATION. DISCONNECTED IDG AND FELT VIBRATION. REMOVED AND REPLACE THE LEFT IDG. SHOP FINDINGS SHOW THAT THE UNIT HAD A FAILURE IN THE HYDRAULIC LOG.SDR 2003UALA00027Bearing · failedAIRCRAFT LOST NR 4 RIGHT AFT MLG WHEEL. RETURNED TO FIELD. WHEEL LOSS BELIEVED DUE TO BEARING FAILURE. INSPECTION OF RECOVERED PARTS REFLECT LACK OF LUBRICATION OF INBOARD WHEEL BEARING. NR 4R WHEEL AND BRAKE REPLACED. NR 3R MATE REPLACED, REAR AXLE REPLASDR 2002UALA01842Fuel Control · failedLOSS OF POWER TO NR 2 ENGINE. ENGINE RESTARTED. ENGINE WOULD NOT GO ABOVE IDLE. FCU CHANGED. BENCH CHECK SHOWED ACCEL & DECEL SCHEDULE UNDER LOW LIMITS, PROBABLE CAUSE OF POWER LOSS AT ALT 41K.SDR 2002UALA01629Pump · fluctuatesFROM TAKE OFF TO ABOUT 6000 FT AT REDUCED CLIMB THRUST, NR 1 ENGINE FLUCTUATED ABOUT 4 PERCENT (N1). STABILIZED AFTER THAT. SUPPLEMENTAL DATA UPDATE FUEL CONTROL AND FUEL PUMP REPLACED PER MM. ENGINE RUN, CHECKED OK. FP AND FCU ROUTED TO OSV.SDR 2002UALA01300Bearing · failedRIGHT ENGINE OIL FILTER MESSAGE DISPLAYED. RIGHT ENGINE SHUTDOWN BEFORE LANDING. FAILURE OF THE NUMBER THREE BEARING. ENGINE WAS 85 HOURS TSO. FAILURE BEING INVESTIGATED BY ENGINE OVERHAUL OSV AND BEARING OSV.SDR 2001UALA02287Actuator · failedCAPTAIN CONTACTED DISPATCH ON APPROACH TO SFO WITH A LEFT MAIN GEAR UNSAFE INDICATION. FLIGHT LANDED SAFELY. LEFT MLG RETRACT ACTUATOR PISTON HAD TENSILE FAILURE AT ROD END ATTACHMENT. SUBSEQUENT FREEFALL DAMAGED DOWNLOCK SENSOR. SENSOR REPLACEDSDR 2001UALA01976Control Unit · faultyRETURNED TO SFO DUE RUDDER TRIM ANOMALY. REPLACED AILERON AND RUDDER TRIM CONTROL. OPERATIONALLY CHECKED RUDDER SYSTEM PER APPLICABLE MAINTENANCE MANUAL. ALL OPS CHECKS NORMAL.SDR 2001UALA01723Bearing · seizedRUDDER PEDALS EXTREMELY STIFF DURING APPROACH AND LANDING AFTER FIVE AND A HALF HOUR FLIGHT. SUPPLEMENTAL DATA UPDATE CAUSE: A SEIZED CAM BEARING IN THE RUDDER FEEL AND CENTERING MECHANISM CAUSED THE HEAVY FORCE CONDITION IN THE RUDDER PEDALS.CORR ECTION: SUSDR 2001UALA00992Charger · failedALL EEL AND EMERGENCY LIGHTS ILLUMINATED AFT OF ROW 27 WITH EMERGENCY LIGHT SWITCH IN AUTO. UNABLE TO EXTINGUISH LIGHTS EXCEPT BY PLACING EMERGENCY LIGHT SWITCH TO OFF. *S/D* REPLACED BATTERY PACK AND BATTERY CHARGER M9035. OP CHECKS OK PER MM 33-51-00 PAGESDR 2001UALA01074Floorbeam · corrodedAFT CARGO PIT BS 1175 UNDER T-CAP FROM LBL 30-RBL 45, BOTH SIDES OF WEB CORRODED UNDER NUT PLATES. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP PER SRM 53-00-51, BAC DRAWING 146T1060 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01073Stringer · corrodedAFT BULK PIT AT BS 1540 - 1562, STRINGER 39L IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED STRINGER SECTION AND SPLICE PER SRM 53-00-03 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01072Splice · corrodedFWD CARGO PIT AT BS 434 STRINGER 32L, SPLICE FITTING IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED NEW SPLICE PER BAC DRAWING 140T0115 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01071Frame · corrodedAFT CARGO PIT AT BS 1263 AT RBL 20-35, FRAME T-CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED NEW T-CAP SECTION PER BAC DRAWING 146T1060 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01070Stringer Clip · damagedSTA 434 STR 39L ELONGATED HOLE IN STRINGER CLIP. MAJOR REPAIR ACCOMPLISHED. REPLACED STRINGER CLIP PER BAC DRAWING 140T2101 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01069Attach Angle · corrodedCABIN BS 1263, STR 12R STRINGER ATTACH ANGLE HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. FABRICATED NEW CLIP PER BAC DRAWING 140T2101 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01068Frame · corrodedAFT CARGO PIT AT BS 1263 AT RBL 20-35, FRAME T-CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP SECTION PER BAC DRAWING 146T1060 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01067Floorbeam · corrodedFWD PIT STA 544, LBL 20, T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIRED T-CAP PER SRM 53-30-07, FIG 1.SDR 2001UALA01066Floorbeam · corrodedAFT CARGO PIT BS 1175 UNDER T-CAP FROM LBL 30 TO RBL 45, BOTH SIDES OF BS 1175 WEB CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP PER SRM 53-00-51 AND 51-40-02 AND BAC DRAWING 146T1060.SDR 2001UALA01014Floorbeam · corrodedAFT CARGO PIT AT BS 1285, LBL 45-RBL 45, FRAME T-CAP IS CORRODED.SDR 2001UALA00996Frame · corrodedAFT CARGO PIT AT BS 1285, LBL 45-RBL 45, FRAME T-CAP IS CORRODED.SDR 2001UALA01013Floorbeam · corrodedPIT FLOOR T CAP CORRODED BS 1153 RBL 45-LBL 45.SDR 2001UALA01007Splice · corrodedFWD PIT STR SPLICE CORRODED BS 434 STR 39R.SDR 2001UALA01006Stringer · gougedPIT STRINGER GAUGED BS 434-456 STR 39L.SDR 2001UALA01005Stringer · corrodedSTR CORRODED BS 1540-1562 STR 39R.SDR 2001UALA01004Splice · corrodedSTR SPLICE FITTING CORRODED BS 434 STR 35L.SDR 2001UALA01003Stringer · crackedSTR CRACKED BS 434 STR 39R.SDR 2001UALA01002Splice · corrodedSTRINGER SPLICE FITTING CORRODED BS 434 STR 39L.SDR 2001UALA01001Shear Tie · corrodedSHEARTIE CORRODED BS 368 STR 38R-39R.SDR 2001UALA00995Stringer · crackedSTR CRACKED BS 434 STR 39R.SDR 2001UALA00994Splice · corrodedSTR SPLICE FITTING CORRODED BS 434 STR 35L.SDR 2001UALA01039Stringer · corrodedBS 355 STR 39L CORRODED.SDR 2001UALA00818Shear Tie · corrodedBS 434 STRINGER 37L - 38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWINGS 140T2102 AND 143T1001.SDR 2001UALA00817Frame · corrodedBS 1241 LBL 45 - RBL 45 FRAME T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SRM 51-40-02 AND BAC DRAWINGS 141T1060 AND 146T1208.SDR 2001UALA00091Battery Pack · dischargedRIGHT SIDE EEL LIGHTS ON WITH OVERHEAD SWITCH IN THE ARM POSITION. *S/D* ADJUSTED EMERGENCY LIGHT MICROSWITCH ON OVERHEAD PANEL. CHECKED 28VDC CHARGING VOLTAGE AND GROUNDS, ALL OK. REPLACED EMERGENCY LIGHT POWER SUPPLY. (NOTE - EEL LIGHT PROBLEMS IN 2 PRESDR 2001UALA00089Switch · stuckON CLIMBOUT OF JFK, EMERGENCY SIGN LIGHTS ON, ON RIGHT SIDE OF FIRST AND BUSINESS CLASS. *S/D* FOUND FLIGHT ATTENDANT EMERGENCY LIGHT TEST SWITCH STUCK. CYCLED SWITCH, OPS CHECK GOOD.SDR 2001UALA00087Light · intermittentRIGHT HAND FORWARD CABIN EEL LIGHTS COMES ON INTERMITTENTLY WITH SWITCH IN ARM POSITION.SDR 2000UALA00718Gear · wornL/E SLAT ASYM DURING FLAP EXTENTION ON APPROACH. *S/D* THE RIGHT WING SLATS DID NOT MOVE TO THE COMMANDED POSITION DUE TO A SEVERELY WORN OUTBOARD LEADING EDGE SLAT DRIVE TORQUE TUBE. WHEN THE LEFT WING L/E SLAT POSITION DOES NOT MATCH THE RIGHT WING L/E SLSDR 99UAL900490Enertainment Sys · failedELECTRICAL SMELL IN MID CABIN ROW 10-11 READING LIGHTS AND ENTERTAINMENT SYSTEM NOT ACCEPTING COMMANDS NORMALLY. *S/D* FOUND SEAT ELECTRONIC BOX AT SEAT 9 E, F BURNT. REPLACED SEAT ELECTRONIC BOX.SDR 99UAL900321Bleed Control · malfunctionedON TAKEOFF, NR 2 ENGINE SUSTAINED TWO SHORT COMPRESSOR STALLS. SURGE CHECKS WERE ACCOMPLISHED REFERENCE MAINTENANCE MANUAL. THE ENGINE VANE BLEED CONTROL WOULD NOT TRIM, AND IT WAS REPLACED. THE STATOR VANE ACTUATOR WAS REPLACED PRECAUTIONARY.SDR 97UAL900058Connector · failedAILERON LOCKOUT LIGHT APPEARED DURING CLIMB AT APPROXIMATELY 300 KNOTS. THE AIRCRAFT CONTINUED TO JFK. FOUND SHORT AT LEFT AILERON ACTUATOR CONNECTOR. REPLACED THE CONNECTOR. PERFORMED OPERATIONAL CHECK.SDR 95UAL900111Hyd Pump · failedRETURNED TO FIELD UNDER AMBER ALERT WITH NR TWO SYSTEM HYDRAULIC FAILURE. FOUND ENGINE DRIVEN PUMP FAILED. REPLACED PUMP. CHECKS O.K.
Back to N615UA, cancelled May 30, 2018