N545UA, cancelled Nov 17, 2018
Service difficulty reports · 262
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 = 'N545UA' AND deregistration_id = 'N545UA-2018-11-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 = 'N545UA' AND deregistration_id = 'N545UA-2018-11-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 CALA2015030293183Unknown · malfunctionedLEADING EDGE & TE FLAP DISAGREE AT 20. CREW SELECTED FLAP 30, BUT FLAP WAS STOPPED AT 22, USED ALT TO PUT FLAP AT 20 & DIVERTED. TEST ON FSEU IAW AMM 27-51-01, ALSO DID A VISUAL INSP OF FLAPS, FOUND NO DEFECTS.SDR CALA2015021293147Smoke Detector · defectiveAFT CABIN AFT LAVATORY SMOKE DETECTOR GREEN LIGHT IS OFF. REPLACED AFT LAVATORY SMOKE DETECTOR ASSEMBLY. OPERATIONS CHECKED NORMAL.SDR CALA2014081391972Apu · faultyAPU HAD SHUTDOWN, FAULT LIGHT ILLUMINATED & EICAS MSG APU FAULT DISPLAYED. ADDED 6 QTS OIL, RAN APU, HAD AUTO SHUTDOWN WITHIN 4 MINUTES WITH HEAVY WHITE SMOKE COMING OUT OF THE TAIL PIPE. OIL TANK WAS EMPTY WHEN CHECKED AFTER SHUTDOWN. OIL DRIPPING FROM BOTSDR CALA2014042190880Skin · damagedDAMAGED SKIN CUT OUT & A DOUBLER REPAIR INSTALLED IAW SRM 53-00-01, REPAIR NR 3. IAW SRM TABLE V, THIS IS A CAT B REPAIR IN ZONE A. WHERE THINNEST ORIGINAL SKIN THICKNESS IS .049.SDR CALA2014041090800Door Frame · damagedFUSELAGE FRAME ON FWD SIDE OF L1 DOOR IS CRACKED & BENT. REPAIRED L1 DOORWAY BS 338 UPPER FRAME INBD CHORD IAW ECRA 5300-01886.SDR CALA2014040890788Skin · dentedDENT REPORTED BY CS APPROXIMATE 3FT AFT OF DOOR 3RT & 4FT UP FROM BOTTOM OF DOOR. DENT IS .075 INCH DEEP BY .5 INCHES WIDE. INSTALLED REPAIR DOUBLER IAW SRM 53-00-01 REPAIR 3 FG 201.SDR CALA2014040890787Skin · damagedDOUBLER REPAIR INSTALLED 3FT AFT OF DOOR 3 RT BS 1703 AT STRINGER 12RT SKIN THICKNESS IN REPAIR AREA IS .056. REPAIR INSTALLED IAW SRM 53-00-01 RPR 3 FG 201.SDR CALA2014040390760Skin · dentedREF PREVIOUSLY ARCHIVED DENT CF9088, DAMAGED SKIN CUT OUT & A DOUBLER REPAIR INSTALLED IAW SRM 53-00-01, RPR 3 IAW SRM TABLE V, THIS IS A CAT B REPAIR IN ZONE A WHERE THINNEST ORIGINAL SKIN THICKNESS IS .049.SDR CALA2014033190732Skin · dentedFUSELAGE HAS DENT APPROXIMATELY 4FT FWD OF OUTFLOW VLV. =1 & Y=.047 & DENT IS IN MIDDLE OF BAY NOT AFFECTING INTERNAL STRUCTURE & SMOOTH. CUT OUT DAMAGED SKIN AT BS 1585 LT, BETWEEN STRINGER 22L TO STRINGER 23L. FABRICATED & INSTALLED A REPAIR DOUBLER IAW SSDR CALA2014032790712Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM UPPER CAP AT BS 1661, WL 208.10 & LBL 8-19. REMOVED CORROSION & MATERIAL REMAINING IS OUT OF LIMITS IAW SRM 53-00-51, FIG 101 & DETAIL III. FORMED -1 REPAIR ANGLE & INSTALLED IAW ECRA 5310- 05538.SDR CALA2014032790711Angle · corrodedCORROSION ON CHORD JUST BELOW RT OVERWING EXIT DOOR CUT OUT STATION 960, JUST ABOVE STRINGER 17. REPLACED T CHORD ANGLE, PN 144N8611-28 IAW SRM 51-40-2 & DWG 144N8611 ON NON-ROUTINE.SDR CALA2013120593483Sensor · missingIAW DF0035, FWD CARGO LOADING SYS IS MISSING RETRACT LIMIT SWITCH SENSOR & SUPPORT BRACKET ON MODULE 3. WORK IN PROGRESS MEL 2553A IS NOT ACTIVE. REPLACED SENSOR & BRACKET.SDR CALA2013120593482Diode · weakLT REVERSE FAILS TO DEPLOY. IAW WDM 32-09-11 PG5C SH2 FOUND WEAK DIODE R10319. CHECKED WIRING FROM K199 X2 TO K177 12. WIRING CONTINUITY GOOD & NO SHORTS TO GND. REPLACED DIODE R10319. LT REVERSE OPERATIONS NORMAL WITH OR WITHOUT ENGS RUNNING.SDR CALA2013120293352Idg · faultyRT GEN KICKED OFF WENT TO THRUST. PERFORMED BITE CHECK OF BSCU FOUND OVER SPEED FAULT. REPLACED NR 2 ENG IDG IAW AMM & RAN ENG IAW JRH CHECKED OK.SDR CALA2013111993043Motor · leakingLT WING HAS EVIDENCE OF A HYD LEAK ON LOWER FWD WING ROOT TO BODY FAIRING. FOUND HYD MOTOR LEAKING FROM DRAIN TUBE. REPLACED HYD MOTOR IAW AMM 27-81-08, LEAK CHECKED OK. ACCOMPLISHED TO STEP 3 FP OF OPERATIONS CHECKED IAW 27-81-08.SDR CALA2013110592666Shim · migratedACCOMPLISHED INSPECTION OR RECHECK IAW CF9081. RT WING WSS 298 ABOVE INBD FLAP, OTBD FLAP TRACK, SHIM MIGRATING FROM UNDER WING SUPPORT BRACKET.SDR CALA2013110592665Adi · malfunctionedCAPTAIN ADI & HSI NOT GOING INTO TEST MODE.SDR CALA2013103192542Attach Fitting · missingAFT CARGO BAY , FWD RT CARGO NET MISSING CLIP. REPLACED DAMAGED NET.SDR CALA2013100791775Starter · faultyDURING LEFT ENGINE START ATTEMPT, WHILE ENGINE WAS ROTATING, HAD EICAS ENGINE STARTER MESSAGE, ABORTED START. MX CLEANED CONNECTOR & PERFORMED ENGINE MOTOR VALVE APPEARS STIFF.SDR CALA2013091091171Cover · contaminatedAMMONIA OR FERMENT SMELL IN FWD GALLEY UNABLE TO DETERMINE SOURCE. PASSENGER IN ROW 1 EYES BURN. DUE TO REPORTS OF A STRONG AMMONIA SMELL AT ROW 31, REPLACE ALL SEAT COVERS & SEAT CUSHIONS AT ROW 30A,B,C,D,E,F & ROW 31 A,B,C,D,E,F & ROW 32 A,B,C,D,E,F. IN ASDR CALA2013082190626Lanyard · out of positionDOOR WILL NOT ARM: 4R FOUND SURVIVAL LANYARD IN BRIDAL ON GIRT BAR. STOWED ROPE BACK IN BRIDAL, OPS CHECKED NORMAL. DOOR NOW ARMS AND DISARMS.SDR CALA2013082290671Valve · faultyFLIGHT DECK TOO HOT WITH LT A/C PACK IN AUTO. ALSO TOO HOT WITH COCKPIT TRIM AIR OFF. REPLACED FLIGHT DECK TRIM AIR VALVE PER MM, OPERATIONS CHECKED NORMALSDR CALA2013080890258O-Ring · leakingRT ENGINE THRUST REVERSER INOPERATIVE, HYD LEAK AT OTBD CENTER THRUST REVERSER ACTUATOR UPPER FLEX SHAFT. REPLACED O-RING, OPS CHECKED GOOD, NO LEAKS FOUND.SDR CALA2013082690774Shaft · leakingRT ENGINE REVERSER IS INOPERATIVE. ACCOUNT OF HYDRAULIC LEAK AT OUTBOARD CENTER REVERSER. ACTUATOR UPPER FLEX SHAFT.SDR CALA2013080690187O-Ring · leakingRT ENGINE REVERSER IS INOPERATIVE DUE TO HYD LEAK AT OTBD CENTER REV ACTUATOR UPPER FLEX SHAFT. REPLACED O-RING, OPS CHECKED, NO LEAKS FOUND.SDR UALA2013071905087Isolation Valve · inoperativeNR 1 ENGINE LT THRUST REVERSER INOPERATIVE. REPLACED LT THRUST REVERSER ISOLATION VALVE.SDR UALA2013071204869Filter · faultyDURING TAXI OUT, EQUPMENT OVERHEAT EICAS WITH EQUPMENT COOLING FLOW STATUS MESSAGE. SAME INDICATION IN ALTERNATE POSITION. REPLACED EQUPMENT COOLING FILTER.SDR UALA2013062704499Fan · noisyCOMMUNICATION IMPOSSIBLE WITH RT RECIRCULATION FAN ON. REPLACED RT RECIRCULATION FAN, OPS CHECKED OK. NO LEAKS NOTED.SDR UALA2013062604427Plate · crackedFWD CARGO BAY THRESHOLD PLATE HAS ONE PREVIOUSLY WELD REPAIR THAT IS CRACKED. STOP DRILLED ONE INCH CRACK IAW ECRA 5310-04203. FILLED CRACK WITH SEALANT APPLIED ALUMINUM TAPE OVER CRACK.SDR UALA2013061304070Smoke Detector · failedL1 LAVATORY SMOKE DETECTOR INOPERATIVE. REPLACED SMOKE DETECTOR, OPS CHECKED GOOD.SDR UALA2013060303846Start Valve · failedNR 1 ENGINE HUNG START BEFORE STARTER CUTOUT. REPLACED STARTER AND VALVE IAW AMM.SDR UALA2013050603147Control Unit · malfunctionedACFT IS NOT SENDING TAKEOFF DATA POINTS. FOUND INCORRECT SOFTWARE INSTALLED AND "DMM" LIGHT ON FRONT OF UNIT WOULDN'T EXTINGUISH. INSTALLED SOFTWARE, NO HELP. REPLACED UNIT REF MM 31-31-03-401, INSTALLED SOFTWARE, NO DEFECTS NOTED.SDR UALA2013042502871Frame · dentedAFT CARGO BAY FRAME DENTED BS 1400 S26L. CUT OUT DAMAGED AREA AND FABRICATED A REPAIR ANGLE AND INSTALLED PER SRM 53-00-07, REPAIR 5. MAJOR REPAIR.SDR UALA2013042502870Skin · dentedDENT IN FUSELAGE BS 628 S26-27L. FOUND TO BE OUT OF LIMITS PER SRM 53-00-01. CUT OUT DAMAGED SKIN AND FABRICATED AND INSTALLED A REPAIR DOUBLER PER SRM 53-00-01, REPAIR 3. MAJOR REPAIR.SDR UALA2013041102484Connector · damagedSTAB TRIM LIGHT AND UPPER EICAS ILLUMINATED WHEN STAB MOVED. STAB TRIM SHUTOFF LEFT CIRCUIT BREAKER ON P-11 WILL NOT RESET. FOUND D1851 CONNECTOR INSULATION DAMAGED. REPLACED CONNECTOR D1851 PER WDM 27-41-11.SDR UALA2013041102483O-Ring · leakingHYDRAULIC QUANTITY DECREASED TO 47. QUANTITY STABLE WITH PUMPS OFF, LEFT SYSTEM. CONFERENCE WITH CREW FOLLOWING QRH 130.2 FLUID LEAKING FROM ENGINE DRIVEN PUMP CASE DRAIN PRESSURE MODULE. REPLACED O-RINGS ON DIFFERENTAL PRESSURE INDICATOR, LEAK CHECKED GOOD.SDR UALA2013040302205Switch · failedLEFT A/C PACK BITE EICAS MESSAGE. REPLACED CABIN ALTERNATE SWITCH IAW AMM, BITE CHECKED GOOD.SDR UALA2013040302204Module · failedEICAS MESSAGE 'STAB TRIM' DISPLAYED AND STAB TRIM LIGHT ON. REPLACED RIGHT STAB TRIM ASSY MODULE.SDR UALA2013040302203Starter · failedAPU WILL NOT START, APU FADEC SHOWS LRU STARTER FAULT . REPLACED STARTER.SDR UALA2013040102106Girt Bar · dirtyL1 DOOR SLIDE LIGHT DOES NOT COME ON WITH SLIDE ARMED. CLEANED GIRT BAR AREA AND CYCLED DOOR. ARM LIGHT CHECKED OKAY.SDR UALA2013032902046Light · unsecureLEFT EMERGENCY ESCAPE TEST 1 LIGHT INOP. SECURED LIGHT IN SOCKET.SDR UALA2013021500901Seat · looseLAV AT 2L HAS A BROKEN TOILET SEAT FOUND SEAT ASSY JUST LOOSE. SECURED AND INSTALLED MISSING PLACARD.SDR UALA2013020700753Pressure Switch · failedLEFT ENGINE LOW PRESSURE LIGHT TESTED OK. LIGHT OFF WITH ENGINE SHUT DOWN. REPLACED LOW PRESSURE EDP SWITCH AS PER AMM, LIGHT OPS NORMAL.SDR UALA2013020400692Unknown · odorFAINT ODOR LIKE BURNING RUBBER ON F/O'S SIDE ONLY, INTERMITTENT. NO SIGNS OF ANY OVERHEATING. PER CREW, NOT AN ELECTRICAL ODOR. RAN PACKS BOTH HOT AND COLD, OPERATED FOOT AND SHOULDER HEATERS, PERFORMED ENGINE RUNS AND SUPPLIED PACKS WITH ENGINE AIR, APU AISDR UALA2013012800479Ground Wire · damagedLEFT PACK, GROUNDING WIRE PULLED FROM SHIELD SPLICE AT PACK COMPRESSOR OUTLET TEMP SENSOR. REPAIRED GROUND WIRE FOR SHIELD SPLICE PER SWPM 20-10-15.SDR UALA2013012100357Heat Exchanger · crackedLEFT A/C PACK SECONDARY HEAT EXCHANGER IS CRACKED. REMOVED LEFT PACK PRIMARY AND SECONDARY HEAT EXCHANGERS.SDR UALA2012111906677Jack · inoperativeNR 2 MINITEL MICROPHONE JACK INOPERATIVE. HAND MICROPHONE OPERATES NORMALLY. REPLACED F/O MICROPHONE JACK. OPS CHECKED GOOD.SDR UALA2012111206489Light · inoperativeDURING SHUTDOWN OF LEFT ENGINE FUEL VALVE LIGHT DID NOT ILLUM, NEEDS FURTHER TROUBLESHOOTING. SPAR VLV OPS OK, ONLY ENGINE VLV LIGHT DOES NOT ILLUMINATE AT ALL. ACCOMPLISHED CHECK, LEFT ENGINE START UP AND SHUTDOWN NORMALLY.SDR UALA2012110806441Door · obstructedFLIGHT ATTENDANT REPORTS DOOR 1R WILL NOT ARM. REMOVED WATER BOTTLE CAP FROM DOOR SILL AREA. CLEANED AND LUBRICATED SLIDE GIRT BAR.SDR UALA2012110606373Controller · malfunctionedAT CRUISE LEFT DUCT PRESS AT 38 PSI & RIGHT AT 22 PSI. PLACED ON MEL CW MEL DDP LOCKED VALVE CLOSED AND PILOT PLUG DISCONNECTED. REPLACED HIGH STAGE PILOT CONTROLLER PER AMM. REACTIVATED CONTROLLER REF MEL3611C. RUN WITHIN LIMITS.
Back to N545UA, cancelled Nov 17, 2018