N665UA
Service difficulty reports · 373
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 = 'N665UA' AND registry_match = 'registration' 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 = 'N665UA' AND registry_match = 'registration' 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 UALA2013022201065Amu · faultyOFF THE GATE ACARS INOP, BLANK SCREEN, PER CREW. CREW CYCLED G6 (MU UNIT) AND G13 (CMU-ACRAS DC CBS.ACARS BACK ON AND OPS NORMAL.SDR UALA2013022201063Battery · failedDOOR 2R EMERGENCY LIGHT BLINKS. DUE TO THE CHRONIC HISTORY OF DOOR 2R EMERGENCY EXIT IDENTIFIER SIGN LOWER LIGHT INTERMITTENTLY BLINKING. PLEASE REPLACE BATTERY ASSEMBLY M1556 REF AMM. (PCN 585-4495). REMOVED AND REPLACED M1556, OPS CHECKED SATISFACTORY.SDR UALA2013022201062Cdu · faultyOFF THE GATE ACARS INOP, BLANK SCREEN, PER CREW. CREW CYCLED G6 (MU UNIT) AND G13 (CMU-ACRAS DC CBS.ACARS BACK ON AND OPS NORMAL. REMOVED AND REPLACED REF AMM 23-22-02. OPS CHECK NORMAL.SDR UALA2013021800965Oxygen Bottle · low pressurePSX PORTABLE OXYGEN CYLINDER(S) PRESS IS LOW OR ZERO (AT 01 LOCATIONS). AFT LEFT DOOR REPLACED AFT POB.SDR UALA2013020700728Light · inoperativeCOCKPIT DOOR EMERGENCY LIGHT INOPERATIVE. LIGHT ASSY REPLACED PER AMM. OPS CHECKED OKAY.SDR UALA2013020500700Web · damagedFOUND TWO PUNCH HOLES ON FWD FACE OF BS 246 RBL 12 VERTICAL WEB LOWER AREA. BS 246 FLOORBEAM AT RBL 12 VERTICAL WEB LOWER AREA HOLES REPAIRED PER ECRA 5310-05679 PART 1.SDR UALA2013020500699Skin · dentedFUSELAGE SKIN DENTED AT BS 434 STRINGER 38 LT. DOUBLER REPAIR INSTALLED PER ECRA 5331-01-680. MAJOR REPAIR.SDR UALA2013020400654Floorbeam · corrodedFOUND CORROSION ON UPPER TEE OF FLOORBEAM BS 303 LBL 4 - 16. CUT OUT CORROSION LBL 4 - 34 AND INSTALLED REPAIR PER SRM 53-00-51 REPAIR 1 FIG 201. MAJOR REPAIR.SDR UALA2013020400653Floorbeam · corrodedFLOORBEAM UPPER TEE CORRODED BS 347 RBL 28 - 49. CUT OUT DAMAGE FLOORBEAM TEE FROM BL 0 TO RBL 88 AND INSTALLED REPAIR PER SRM 53-00-51 REPAIR 1 FIGURE 201. MAJOR REPAIR.SDR UALA2013020400652Floorbeam · damagedFLOORBEAM UPPER TEE HAS MISDRILLED HOLES AT BS 1480 RBL 31. CUT OUT DAMAGED AND REPAIRED PER SRM 53-00 -51 REPAIR 2 FIG 20. MAJOR REPAIRSDR UALA2013020400651Floorbeam · damagedELONGATED HOLES FOUND IN UPPER TEE OF FLOORBEAM BS 303 RBL 60. CUT OUT DAMAGE SECTION AND REPAIRED PER SRM 53-00-51 REPAIR 2 FIG 201. MAJOR REPAIR.SDR UALA2013020400650Floorbeam · crackedFLOORBEAM CRACKED AT BS 1518 RBL 2 UPPER TEE. CUT OUT DAMAGED FLOORBEAM TEE FROM LBL 35 TO RBL 35 AND REPAIRED PER SRM 53-00-51 REPAIR 1 FIG 201. MAJOR REPAIR.SDR UALA2013020400649Seat Track · corrodedSEAT TRACK CORRODED BS 546 TO 549 RBL 88. REPLACED SEAT TRACK SECTION FROM BS 546 TO 658 PER ECRA 5300-01458 AND SRM 53-00-52 REPAIR 3.SDR UALA2013011600275Seat Track · corrodedRBL 88, BS 1329 - 1334, SEAT TRACK FOUND CORRODED. SEAT TRACK REPLACED IAW SRM 51-40-02.SDR UALA2013011600274Seat Track · corrodedRBL 88 BS 1185 TO 1189 SEAT TRACK FOUND CORRODED. SEAT TRACK REPLACED IAW SRM 51-40-02.SDR UALA2012122407395Unknown · malfunctionedNR 2 RADIO NOT TRANSMITTING OR RECEIVING. NO AUDIO COMING FROM RT VHF TRANSRECEIVER JACK. TRANSRECEIVER BITE OK. REF :WD-23-12-21 PAGE 2, ANT CABLE IS OPEN. REPLACED NR 2 VHF ANTENNA (PRECAUTIONARY).SDR UALA2012121907291Stiffener · crackedNOSE WHEEL WELL STA 287 VERTICAL STIFFENER CORD HAS CRACK BETWEEN FASTENER 12 AND 13 STARTING FROM TOP. REMOVED DAMAGED AREA, FAB 4 EA RPR PARTS PER SRM51-70-12 AND 51-40-05. INSTALLED RPR REF SRM 51-70-12, FIG 1.SDR UALA2012121907290Skin · nickedLOWER EXTERNAL FUSELAGE E&E DOOR SKIN NICK ENTIRE SKIN. MAJOR REPAIR ACCOMPLISHED: FABRICATED AND INSTALLED DOUBLER IAW SRM 52-40-01, REPAIR 5.SDR UALA2012112806830Light · looseESCAPE PATH LIGHTS ARE DISLODGED AND HANGING LOOSE IN FIRST CLASS. RE-SECURED EMERGENCY ESCAPE LIGHTS, OPS CHECK OKAY.SDR UALA2012112106735Circuit Card · faulty'R INOP' & 'PACK OFF 'LIGHTS ON. EICAS MSG 'R PACK OFF' DISPLAYED.' REPLACED RIGHT FLOW CONTROL CARD PER MM. RAN PACK FOR 2 HOURS. NO FAULTS.SDR UALA2012112106724Slide · damagedWORKING EQ5095 REMOVED SLIDE PACK -779 FROM DOOR 1L WHEN INSTALLING SLIDE -773 SLIDE WAS DAMAGED RIVETS PULLED LOOSE. NEW SLIDE ON ORDER. DO NOT OPEN DOOR 1L FROM EXTERIOR. REMOVED PER MM.SDR UALA2012111906674Indicator · faultyCAPTS STAB TRIM IND 5-7-F/O STAB TRIM 2. CAPT INDICATION IN ERROR, COMPLIED WITH MEL2748A, CAPT SIDE INDICATION COVERED. REPLACED CAPTAINS STAB TRIM INDICATOR AND OPS OKAY.SDR UALA2012102606159Shutoff Valve · faultyCREW REPORT: L ENGINE HPSOV AND LT ENGINE BLEED LIGHT LIGHT ON IDLE POWER ADVANCING POWER CLEARED LIGHT. INOP'D LEFT ENGINE HI STAGE VALVE PER MEL3611Q PROCEDURES. REPLACED NR 1 ENG HPSOV.SDR UALA2012102506131Indicator · faultySTANDBY ALTIMETER IS 360 FEET HIGH AT FL320. REPLACED STANDBY AIRSPEED INDICATOR AND PERFORMED PITOT STATIC CHECK.SDR UALA2012101105790Probe · faultyA-C RETURNED TO BLOCKS FOR :L AUX PITOT EICAS MSG AND ANNUNCIATOR LT FOR SAME. VERIFIED CB NOT POPPED AND L AUX PITOT DOES NOT OPERATE WHEN TEST SW ACTUATED. REPLACED LEFT AUX PITOT PROBE, OP CHECKS NORMAL, LEAK CHECKS WITHIN LIMITS PER MM.SDR UALA2012100405637Light · out of positionEMERGENCY EXIT LIGHT STRIP PULLED OFF SEAT 1B. REPLACED EEL STRIP ON SEAT 1B, LIGHT OPS CHECKS OKAY.SDR UALA2012100305599Light · missingCABIN FIRST CLASS SEAT 1B EEL LIGHT ASSY MISSING. REPLACED LIGHT, CHECKS OK.SDR UALA2012100205587Connector · unsecureCABIN EEL LIGHTS INOP FROM ROWS 25H TO 31. SECURED CONNECTOR UNDER SEAT 31HJ, CHECKS OKAY.SDR UALA2012082804835Bolt · looseFUELER REPORTS FUEL ADAPTOR BOLTS LOOSE. REPLACED ALL FASTENERS AND SECURED.SDR UALA2012082904853Clamp · unsecureNR 1 ENGINE LOWER FORWARD FIRE LOOP CLAMP HANGING FROM BRACKET 6 O`CLOCK POSITION. SECURED CLAMP.SDR UALA2012080804307Apu · shutdownAPU AUTO SHUT DOWN AT DEPARTURE. ACCOMPLISHED BITE CHECK ON APUC. NO FAULT DATA ON ALL RUNS. "NO DATA" DISPLAYED ON ALL RUNS. TROUBLESHOT IAW MM 49-61-00-101 SECTION G4 OR FCU REF SSM. REPLACED APU PER MM. OPS AND LEAK CHECKED GOOD.SDR UALA2012080704241Valve · faulty'R PACK INOP' LIGHT ON. EICAS MSG 'R PACK TEMP' DISPLAYED. REPLACED APU SURGE CONTROL VALVE AND AIR SUPPLY SHUTOFF VALVE. APU BLEED PSI NORMAL WITH BOTH PACKS ON AND CTR ADP ON, APU BLEED PSI NORMAL DURING ENGINE DRY MOTOR. APU AIR SUPPLY SHUTOFF VALVE REPSDR UALA2012080704240Valve · faultyAPU BLEED AIR ONLY 8PSI , UNABLE TO START EITHER ENGINE. REPLACED APU SURGE CONTROL VALVE AND AIR SUPPLY SHUTOFF VALVE. APU BLEED PSI NORMAL WITH BOTH PACKS ON AND CTR ADP ON, APU BLEED PSI NORMAL DURING ENGINE DRY MOTOR.SDR UALA2012080604218Sdu · malfunctionedSATCOM STATUS ON LINK STATUS PAGE IS NO COMM. REPLACED SATELLITE DATA UNIT. SATCOM SYSTEM CHECKED NORMAL.SDR UALA2012070503586Shutoff Valve · faultyLEFT ENGINE HPSOV EICAS WHEN ENGINE REDUCED FOR DESCENT. ACCOMPLISHED QRH. FOUND NR 1 ENGINE HPSOV VALVE WOULD NOT FULLY CLOSE. REPLACED HPSOV PER MM. OP CHECKED GOOD PER SAME MM. PERFORMED 10 MIN IDLE RUN, NO FAULTS.SDR UALA2012062203320Shutoff Valve · activatedCREW REPORTS INFLIGHT TRANSFER TO CENTER FUEL TANK. SEALED RIB 3 AT 1400, 12 HR CURE. REPLACED LT IB MAIN SHUT OFF VALVE. TANKS CLOSED. TO FUEL 0530 FOR LK & OP CKS. ACP MM28-11-95 ITEM 2.A (4) FOUND SMALL FUEL LEAK AT RIB 3 UPPER AREA BETWEEN STA. L5 AND L6SDR UALA2012051102756Relay · failedLEFT ELECTRICAL DEMAND PUMP IN AUTO DISPLAYS SYS PRESSURE LIGHT AND PRESS LIGHT WITH 90 PSI. REPLACED K680 LT ENGINE START SENSE RELAY AND K681 RT ENGINE START SENSE RELAY PER WDM 29-11-12 PG 2, RAN BOTH ENGINE, OPS CHECKED NORMAL. NO FAULT LIGHTS.SDR UALA2012051102761Speaker · distortedPA SPEAKER ABOVE 3HJ SOUND IS DISTORTED. REPLACED SPEAKER. OPS OK.SDR UALA2012051002708Pump · malfunctionedWITH LEFT ELECTRIC HYDRAULIC PUMP SELECTED, SYSTEM PRESSURE LIGHT IS ON. REPLACED PUMP, OPS CHECKED OK.SDR UALA2012050202585Window · crackedDIVERTED TO DEPARTURE, DUE TO CRACKED EXTERNAL WINDOW. DURING VISUAL INSPECTION OF CABIN WINDOWS. 1J PASSENGER WINDOW HAS A CHIP ON UPPER FWD CORNER. REPLACED WINDOW AT 1J.SDR UALA2012040902174Valve · faultyAPU AIR PRESS CYCLES FOR NO REASON. DEFERRED PNEUMATICS INOP PER MEL. REPLACED APU SURGE VALVE. RAN APU FOR 30 MINUTES WITH DIFFERENT LOADS. NO SURGING NOTED.SDR UALA2012032901980Unknown · malfunctionedAPU AUTO SHUTDOWN AT GATE BEFORE PUSHBACK. BITE OF BOX FAULTS LOW OIL PRESS SWITCH. REPLACED APU CONTROLLER, NO HELP.SDR UALA2012032001799Sliding Window · leakingCREW REPORT: F/O SIDE FORWARD WINDOW (ONE THAT OPENS) HAS AIR LEAK SQUEAL. REPLACED WINDOW PER MM. MR56604 DASH 105 OFF NEW WINDOW INSTALLED FROM CONTINENTAL SN 799 ON. OPS CHECK NORMAL.SDR UALA2012031201638B-Nut · looseRIGHT ENGINE LEAKING FLUID 60-100 DRIPS PER MINUTE. FOUND PRESSURE LINE ON RT ENG HYDRAULIC PUMP LEAKING, TIGHTENED 'B' NUT AND DRY MOTORED ENGINE. NO LEAKS DETECTED, CHECKS GOOD.SDR UALA2012022901251Rotary Actuator · faultyRAMP REPORTED THAT FWD CARGO DOOR MAKING NOISE WHEN CLOSING. RAN FWD CARGO DOOR THRU RECYCLE AND FOUND FWD CARGO DOOR MAKING NOISE IN BOTH DIRECTION. NOISE SEEMS TO BE COMING FROM LIFT ACTUATOR OR DOOR LINKS BEARING CYCLE DOOR CLOSE AND CONFIRMED DOOR CLOSESDR UALA2012022801237Light · inoperativeSEAT MOUNTED EEL LIGHT INOP 3B. ACCOMPLISH NON-RII INSPECTION OF AMIS ITEM 0922011. RPL'D EEL LIGHT AT 3B. OPS CHECK GOOD. ACCOMPLISHED IDT INSPECTION OF EEL LIGHT STRIP INSTALLED AT SEAT 3B.SDR UALA2012021300844Controller · malfunctionedSTATUS MESSAGE 'CABIN ALT 1'. MEL M2131A. FOUND CABIN ALT 1 UNIT NO POWER. RPLC'D UNIT PER MM, BITE CHECK OKAY.SDR UALA2012021300853Brake · fireMOMENTARY FIRE OBSERVED BY GROUND CREW COMING FROM NR 2 MLG FWD BRAKE ASSY. RPLC'D NR 2 BRAKE ASSY PER MM. ALSO ACP MM. REPLACED NR 6 BRAKE ASSY PER MM. ALSO ACP MM 05-51-15 BRAKE SEIZURE INSPECTION.SDR UALA2012021300836Brake Assy · faultyL TRUCK INBD REAR BRAKE TEMP 6. REPLACED NR 6 BRAKE ASSY. ALSO ACP MM05-51-15 BRAKE SEIZURE INSPECTION.SDR UALA2012010500112Blade · damagedRT ENGINE HAS A SIGNIFICANT NICK IN BLADE 2, BLADE DAMAGE IS AT DIM LEADING EDGE FROM BASE TO DAMAGE IS 20.700. APPROX 750. DEPTH AND LENGTH IS 1.0 INCH. PER MM DOCUMENT BLADE IS NOT REPAIRABLE. REPLACED NR 2 1ST STAGE FAN BLADE AND OPPOSITE FAN BLADE NR 21.
Back to N665UA