N516UA, cancelled Feb 21, 2018
Service difficulty reports · 181
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 = 'N516UA' AND deregistration_id = 'N516UA-2018-02-21' 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 = 'N516UA' AND deregistration_id = 'N516UA-2018-02-21' 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 CALA2015062994028Pca · faultyUNCOMMANDED ROLL TO THE RT WITH THE RT SYS HYD SELECTED OFF. INSTALLED NR 11 SPOILER PCA IAW AMM 27-61-02. OPERATIONS CHECKED OK.SDR CALA2015052693810Light · inoperativeDURING TESTING FOUND MAIN ENTRY DOOR 2LT EMER EVACUATION LIGHT INOPERATIVE. RELAMPED EXTERIOR EMER EVACUATION LIGHT & TESTED, NO DEFECTS NOTED.SDR CALA2015052193801Light · inoperativeDURING TESTING FOUND MED 2 LT EMER EVACUATION LIGHT INOPERATIVE. RELAMPED EXTERIOR EMER EVACUATION LIGHT & TESTED, NO DEFECTS NOTED.SDR CALA2015011392954Sensor · faultyAPU ALTITUDE NO START VERIFICATION. APU ROTATES BUT NO EGT INDICATIONS DURING START. REPLACED OIL TEMP SENSOR IAW AMM -49-94-01.SDR CALA2014042190877Compressor · stalledLT ENG COMPRESSOR STALL ON TAKEOFF CLIMBING THRU 1000 FT. STALL WAS AUDIBLE 4X. ENG RECOVERED & CONTINUED TO OPERATE NORMALLY DURING RETURN TO FIELD. REPLACED ENG IAW 71-00-02 CONFIG 1.SDR CALA2014041790864Compressor · stalledFLIGHT EXPERIENCED COMPRESSOR STALL ON CLIMB.SDR CALA2014032790705Cap · missingGROUND POWER INDICATION LIGHT BROKEN. REPLACED MISSING LIGHT CAP. GROUND POWER NOT IN USE, CHECKED GOOD.SDR CALA2014031990637Dead Bolt · faultyFLIGHT DECK DOOR ELEC SWITCH TESTS GOOD, BUT WHEN DOOR CLOSED WITH SWITCH ARMED DOOR CAN BE OPENED. DEAD BOLT WORKS NORMALLY. REPLACED DEAD BOLT ASSEMBLY, OPERATIONS CHECKED GOOD, DOOR LOCKS.SDR CALA2014030390513Warning System · activatedLT ENG REVERSER CONTROL ENG SEC CONT EICAS MESSAGES ITEM ROLLED FORWARD. EPCS MESSAGES PDIU EEC & 274-18. ACCOMPLISHED EPCS 71-01-0 0 FOR PDIU EEC & 274-18 FIG 105. OPERATED ENG & REVERSER, OPERATION NORMAL.SDR CALA2014020390295Charger · inoperativeEMERGENCY EXIT LIGHT JUST FWD OF RT AFT GALLEY DOOR INOPERATIVE. REPLACED CHARGER M108 18 IAW MM 33-51-09, OPERATIONS CHECKED NORMAL.SDR CALA2014011690164Fire Loop · faultySTATUS MESSAGE ON CLIMB OUT APU FIRE LOOP 2. REPLACED APU UPPER FIRE DETECTOR ELEMENT IAW AMM26-15-02. UNABLE TO DUPLICATE PROBLEM, TESTED OK.SDR CALA2013122793976Controller · faultyLT SIDE WINDOW EICAS CAME ON AGAIN. R & R LT WINDOW HEAT CONTROLLER, OPERATIONS CHECKED GOOD.SDR CALA2013121393682Duct · damagedAIR DUCTS OVER ROWS 8-14 REPORTED TO BE VERY LOUD. REPAIRED DUCT IAW AMM.SDR CALA2013111292865Seat · looseSEAT 32ABC LOOSE IN TRACK. REPLACED BOTH FWD TRACK FITTINGS.SDR CALA2013111292864Seat · looseSEAT 30 ABC LOOSE IN TRACK. SECURED LOOSE SEAT.SDR CALA2013092491394O-Ring · damagedNR 2 ENG OTBD BYPASS VALVE ON AIR OIL COOLER IS LEAKING. REPLACED O-RINGS ON OTBD BYPASS VALVE ON AIR OIL COOLER IAW IPC 79-21-00A-007A. ACP 5 MIN IDLE LEAKED CHECKED GOOD.SDR CALA2013090991111Socket · dirtyBATTERY DISCHARGE LIGHT INOPERATIVE ON STANDBY POWER PANEL. CLEANED SOCKET, LIGHT OPERATIONS CHECK GOOD.SDR CALA2013073090093Skin · crackedL4 DOOR INNER SKIN CRACKED AT WEB LIGHTNING HOLE, TWO AREAS. REPAIRED INNER SKIN IAW UAL ECRA 5200-01251 & REO-M0716.SDR UALA2013071805033Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 760-780 RBL 60, REPAIRED IAW NR 2046.SDR UALA2013071805032Window · scratchedRIGHT NR 2 FLIGHT COMPARTMENT WINDOW HAS SCRATCHES IN THE INNER PANE. R & R ADJUSTED AND OPS CHECKED GOOD.SDR UALA2013071705009Shear Tie · corrodedCORROSION ON BILGE SHEAR TIE BS 1701, S27-28R. CORROSION FOUND TO BE OUT OF LIMITS. REMOVED CORROSION ON BILGE SHEAR TIE IAW SRM 51-10-02, PAR4, FIG 1. MAJOR REPAIRSDR UALA2013071604985Gate · corrodedR1 DOOR LOWER GATE EDGE AND SKIN HAS CORROSION. REMOVED CORROSION FROM GATE AND FOUND OUT OF LIMITS IAW SRM 52-10-02. R & R LOWER GATE IAW SRM 51-40-02, PARA 4B, FIG 3. MAJOR REPAIR.SDR UALA2013071604984Keelbeam · crackedKEEL BEAM BS 1180, WL 133.00, RBL 11 ANGLE CRACKED. R & R ANGLE IAW SRN 51-40-02, PAR 7, FIG 12. MAJOR REPAIR.SDR UALA2013071504927Keelbeam · crackedKEELBEAM BS 1180, WL 133.00 LBL 11 REPAIR ANGLE CRACKED. MAJOR REPAIR ACCOMPLISHED: R & R ANGLE IAW SRM 51-40-02, PARA 7, FIG 12.SDR UALA2013071604956Fitting · corrodedRT OVERWING SLIDE ABSORBER ASSY HAS CORROSION ON THE END FITTING. R & R RT WING SLIDE SNUBBER AND FITTING.SDR UALA2013071104828Skin · crackedFUSELAGE SKIN CRACKED BS 513 JUST ABOVE STRINGER 28R. REPAIRED SKIN IAW SRM 53-00-01, FIG 201, REPAIR 2.SDR UALA2013071004800Skin · puncturedPUNCTURE ONE LEFT ELEVATOR LOWER L/E, ES 160. REPAIRED LEFT ELEVATOR LWR L/E IAW SRM 51-70-04, REPAIR FIG 10.SDR UALA2013070504695Seat Track · damagedSEAT TRACK HAS HOLE DRILLED THROUGH IT, BS 1094, LBL 45. REMOVED, LOCATED, DRILLED AND INSTALLED NEW SEAT TRACK IAW SRM 51-4 0-02, PAR 7D, FIG 12 AND PAR 9, 51-40-05, FIG2.SDR UALA2013070504694Cusp Web · corrodedMAIN CABIN BS 1060 TO 1080, S17R CUSP WEB CORRODED. FOUND TO BEYOND ALLOWABLE LIMITS IAW SRM 53-40-13. FIG 101. R & R CUSP WEB IN MAIN CABIN BS1060 TO BS1080, STR 17R IAW SRM 51-40-02, PAR 7D. MAJOR REPAIR.SDR UALA2013070504693Cusp Web · corrodedMAIN CABIN BS 1020 TO 1040, S17L CUSP WEB HAS CORROSION. FOUND TO BE OUT OF LIMITS IAW SRM 53-40-13, FIG 101. R & R CUSP WEB IAW SRM 51-40-02, PAR 7D.SDR UALA2013070504692Floor Support · crackedMAIN CABIN FLOOR SUPPORT WEB UPPER ATTACH ANGLE HAS CRACKS AROUND FASTNER HOLES BS 780 TO 800, BL 0. R & R FLOOR SUPPORT IAW DWG 140N3505 AND SRM 51-40-02, PAR 7C AND 53-00-51, FIG 201. MAJOR REPAIR.SDR UALA2013070504691Intercostal · crackedBS 540 TO 560, BL 0, WL 208.6, INTERCOSTAL IS CRACKED. R & R INTERCOSTAL IAW SRM 53-00-51, FIG 201, PARA 7.SDR UALA2013070504690Cusp Web · crackedMAIN CABIN BS 996 TO 1020, CUSP WEB CRACKED AT FWD END AT S17L. R & R CUSP WEB IAW SRM 51-40-02, PA R 4, FIG 8 AND PAR 7D, ITEM 6, FIG 12. MAJOR REPAIR.SDR UALA2013070504689Attach Fitting · crackedMAIN CABIN LT FWD ENTRY DOOR UPPER FRAME TO STRINGER ATTACH FITTING IS CRACKED AT BS 350, S6L, WL 281. R & R L1 DOOR UPPER FRAME TO STRINGER ATTACH FITTING IAW SRM 51-40-02 PAR 7, FIG 12. MAJOR REPAIR.SDR UALA2013070504679Intercostal · crackedMAIN CABIN INTERCOSTAL BS 1520 - 1540, BL 0 CRACKED SEVERAL PLACES AT UPPER ANGLE. REPAIRED INTERCOSTAL. MAJOR REPAIR.SDR UALA2013062804533Floorbeam · damagedSCRIBE MARK DAMAGE ON CABIN FLOORBEAM AT BS 1600 RBL 27-43. REPAIRED DAMAGE ON CABIN FLOORBEAM .SDR UALA2013062804532Attach Bracket · corrodedMAIN CABIN, BS 1140, S17R CUSP WEB ATTACH BRACKET HAS CORROSION BS 1140 STR 17R. SUP: REPAIR IN COMPLIANCE WITH NON ROUTINE, NR 20452, REMOVED CORROSION ON MAIN CABIN CUSP WEB ATTACH BRACKET AT BS 1140 STR 17R ORIGINAL MAT THICKNESS OF .063IN MAT REMOVED IS 00SDR UALA2013062804531Floorbeam · corrodedMAIN CABIN BS 1681, LBL 52 FLOORBEAM ANGLE HAS CORROSION BS 1681, LBL 52. REPAIR IN COMPLIANCE WITH NON ROUTINE NR 20419. R & R ANGLE IAW SRM 51-40-02, PAR 7, FIG 12. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51 FIG 101. REMOVED AND REPLACED MAIN CABSDR UALA2013061304083Cap · missing1B EMERGENCY FLOOR LIGHT CAP IS MISSING, AS REPORTED BY CREW. REPLACED ABOVE LIGHT CAP.SDR UALA2013042502881Light · missingFWD COAT CLOSET EMERGENCY LIGHT MISSING. INSTALLED EMERGENCY LIGHT PER DWG 15F6889-504 AND WD33-51-21 AND AMM 25-27-01 AND OPS GOOD.SDR UALA2013041502563Wire · brokenRIGHT LANDING GEAR GREEN LIGHT HALF BURNED OUT. FOUND L399 RT HALF INOP. REPLACED LANDING CARD AT P51 PANEL MR31510-9 OFF AND 123 ON. FOUND BROKEN WIRE AT L399. WHILE REMOVING P3-1 PANEL TO REPAIR WIRE LOST RIGHT HALF OF LEFT, NOSE, GEAR AND DOORS. NEEDS SDR UALA2013040302189Adapter · missingNR 1 BOOM MIC IS DEFECTIVE. (01=CAPT, 02=1ST OFF, 03=1ST OBS). CREW COMMENTS: MISSING THREADED ADAPTOR FOR EARPIECE. PLACED IT IN SPARE MINITEL BAG. USING SPARE REPLACED WITH NEW MINITEL.SDR UALA2013031201457Connector · unsecureINTERIOR EMERGENCY LIGHT INOPERATIVE AT SEAT 5FE. SECURED CONNECTOR TO EMERGENCY LIGHT AT SEAT 5FE, OPS NORMAL.SDR UALA2013022801217Engine · faultyDIRTY SOCK ODOR IN COCKPIT AFTER DEPT PASSING THROUGH 7000 FT. LASTED ABOUT 5 MINUTES. REPLACED NR 1 ENGINE PER AM M 71-00-02. COMPLETED INSPECTION OF NR 3 BEARING & PNEUMATIC DUCTS, AND SPINNER. NO OIL FOUND. DRAINED GEARBOX, ONLY TWO QTS FROM GEARBOX. SDR UALA2013021100787Computer · faultedELEVATOR FEEL STATUS MESSAGE ILLUMINATED. DUE TO CHRONIC PREVIOUS HISTORY OF ELEVATOR FEEL STATUS MESSAGES. REPLACED ELEVATOR FEEL COMPUTER, IAW FIM 27-31-00 PG 117 AND SERVICE TIP 27-31-00 PG 100.SDR CALA2014111092673Skin · damagedMAJOR REPAIR LT FUSELAGE SKIN BS 660 - 740 WL 145.0 HAS SCRIBE MARKS AT LAP JOINT. ECRA 5330-04413 HAS BEEN APPROVED AS AMOC TO AD2007-19-07 & REQUIREMENTS OF SB757-53A0092, LR TS, HAVE BEEN TERMINATED AT THIS LOCATION. DURING THE ACCOMPLISHMENT OF EQ7735 WHSDR CALA2014111092672Skin · damagedMAJOR REPAIR LT FUSELAGE SKIN BS 657 - 661 AT STRINGER 26L HAS SCRIBE MARK DAMAGE & MUST BE INSP IAW REQUIREMENTS OF AMM53-31-93 PRIOR TO THRESHOLD OF 28,996 PTC & EVERY 2000 CYCLES THEREAFTER. ACCOMPLISH INSP IAW PART II OF ECRA 5330-04413. REPAIRED LT FUSESDR UALA2013012400433Floor Support · damagedAFT CARGO BS 1410-1414 LBL 3 FLOOR SUPPORT HAS FOUR HOLES IN UPPER FLANGE. REMOVED AND REPLACED FLOOR SUPPORT. MAJOR REPAIRSDR UALA2013012400432Wire · disconnectedWIRE BS 680 WL155 IS PULLED OUT OF TERMINAL LUG. REPLACED TERMINAL LUG. OPS CHECKED GOOD ON FWD CARGO LOADER SYSTEM.SDR UALA2013012400438Skin · damagedFUSELAGE SKIN BS 1384-1401 S38 LT-27 RT DAMAGED REPAIRED SKIN BELOW IAW ECRA 5360-01245.
Back to N516UA, cancelled Feb 21, 2018