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 UALA2009111203529Oxygen Mask · brokenSECOND OBSERVER O2 MASK BROKEN. SWAPPED WITH CAPTAIN'S, NEED MASK AND BOX ASSY. REPLACED MASK AND STOWAGE BOX.SDR UALA2009111103522Battery · inoperativeAFT LAV LT SIDE EMERGENCY LIGHT INOPERATIVE. REF PTT SEQ 9522015. REPLACED BATTERY, OPS CHECKED, OKAY.SDR UALA2009111103521Battery · dischargedSEAT 35AB -41AB EMERGENCY LIGHT INOP. REPLACED BATTERY LOC SEAT 39AB. OPS CHECKED OKAY.SDR UALA2009100503103Wire Harness · chafedRT IDG DRIVE LIGHT ILLUMINATING. SERVICED RT IDG. FOUND CHAFED AND SHORTING WIRES IN HARNESS W3538 ABOUT 8 INCHES FROM IDG CONNECTOR D10964. MADE SPLICE REPAIR OF RT GEN WIRES W3538-203B (R)-18. SPLICES LOCATED IN HORIZONTAL RUN BETWEEN TWO CLAMPS APPROX 1SDR UALA2009092803038Light · missingSEAT 14HJ SIDE SEAT EEL STRIP IS MISSING. REPLACED MISSING EEL STRIP AT SEAT 14HJ. OPS CHECKS NORMAL.SDR UALA2009091502909Power Supply · faultyEMERGENCY EXIT LIGHTS FLICKERING ROWS 20-24 HJ. REPLACED POWER SUPPLY, EMERGENCY LIGHTS 20-24HJ CHECKED GOOD.SDR UALA2009091402890Control Unit · malfunctionedSPOILERS EICAS MESSAGE WITH SPOILERS LIGHT ON OVERHEAD PANEL. REPLACED NR 3R SCM, OPERATIONAL CHECK GOOD. NO EICAS MESSAGE DISPLAYED OR SPOILER LIGHT ON OVERHEAD PANEL.SDR UALA2009083102702Fuse · blownDOORS L1 AND R1 EXIT SIGNS INOP. REPLACED FUSE AND CHECKED OPERATION OF LIGHT CHECKS GOOD PER MM 33-51-00.SDR UALA2009083102701Feeder Cable · damagedA-ZONE AISLE LIGHTS ON SEATS ARE INOP. REPAIRED UNDER SEAT CABLE INTERFACE ASSY FOR SEAT MOUNTED EMERGENCY LIGHTS AND TESTED GOOD.SDR UALA2009082802691Skin · puncturedEXT FUSELAGE STA 1685 BETWEEN STR 34L AND 35L HAS SKIN PUNCTURE. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR. NO CRACKS NOTED AFTER DAMAGE REMOVED.SDR UALA2009082702677Splash Guard · corrodedR-1 DOOR SPLASH GUARD CORRODED. INSTALLED NEW SPLASH GUARD.SDR UALA2009082702676Light · inoperativeEXTERIOR EMERGENCY LIGHTS L396, L645, AND L391 ARE INOP. RELAMPED LIGHTS L645 AND L391, OPS CHECKS GOOD. LIGHT L396 OPS CHECKS NORMAL.SDR UALA2009082702675Light · missingSEAT 32 AB EMERGENCY BAR MISSING. SEAT OVERHAULED AT REGENT, RECEIVED WITH 8130-9 WITH LIGHT BAR INSTALLED.SDR UALA2009082702674Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 25-26 RT IS INOP. RELAMPED AISLE LIGHT AT ROW 25-25. OPS CHECKS GOOD.SDR UALA2009082702673Light · inoperativeROW 2 LEFT CEILING EMERGENCY LIGHT INOP. RELAMPED AISLE LIGHT AT ROW 2L, OPS CHECKS GOOD.SDR UALA2009082102589Slide · damagedRIGHT OVERWING SLIDE FOUND UNLACED. REMOVED AND REPLACED RIGHT OVERWING SLIDE ASSY.SDR UALA2009082402597Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 325, LBL 30 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. CUT OUT UPPER T-CAP FROM RBL 30 TO RBL 70, STA 325. INSTALLED REPAIR T-CAP.SDR UALA2009082402596Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT STA 287, BL 0 TO LBL 10. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW UPPER T-CAP FROM ZERO BL TO RBL 70, STA 287.SDR UALA2009082402595Floor Support · corrodedMAIN CABIN FLOOR SUPPORT AT BS 347-350, RBL 89 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW FLOOR SUPPORT STA 347 TO 368, RBL 89.SDR UALA2009082102567Seat Track · corrodedMAIN SEAT TRACK STA 325 LBL 11 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SECTION OF SEAT TRACK STA 325 TO 425, LBL 11.SDR UALA2009082102566Seat Track · corrodedMAIN CABIN SEAT TRACK STA 325 RBL 11 CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED SEAT TRACK SECTION STA 325 TO 425, RBL 11.SDR UALA2009081902541Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 347 APPROX RBL 30 IS CORRODED. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGED TEE CAP RBL ZERO TO 70. FABRICATED SPLICE ANGLES AND NEW 'T' CAP AND INSTALLED.SDR UALA2009081702512Cable · frayedLEFT AFT ENTRY DOOR COUNTERBALANCE PRIMARY CABLE IS FRAYING, BS 1461-1480, STR 1L-2L. REMOVED AND REPLACED LEFT AFT ENTRY DOOR COUNTERBALANCE PRIMARY CABLE. SYSTEM TESTED GOOD.SDR UALA2009081702511Pulley · wornLEFT AFT ENTRY DOOR COUNTERBALANCE PRIMARY SWIVEL CABLE PULLEY WORN, BS 1461- BS 1480, STR 1L - 2L. REPLACED COUNTERBALANCE PULLEY AT BS 1461-1480, STR 1L-2L. DOOR OPS CHECK NORMAL.SDR UALA2009072302189Battery · no testRIGHT EMERGENCY ESCAPE SLIDE WON'T TEST. REPLACED OFF WING ESCAPE EMERGENCY BATTERY M962 RIGHT SIDE, OPS CHECKS NORMAL.SDR UALA2009072202167Control Panel · unsecureRT SLIDE SQUIB DOES NOT TEST. RESEATED TEST PANEL. SYSTEM OPS CHECK OKAY.SDR UALA2009070601918Light · shortedFOUND EEL INOP FROM SEAT 35AB TO 41AB. TRIED BATTERY PACK AND CHARGER, NO HELP. LIGHTS ON VERY DIM. LOWER SIDEWALL AT SEAT 40AB REMOVED AND PART OF CARPET UP AT SEAT 41AB. FOUND LIGHT ASSY AT 39AB SHORTED, REPLACED IT, SYSTEM CHECKS GOOD. CLOSED AND SECURSDR UALA2009062601802Wire · brokenEMERGENYC LIGHTS AT ROW 23AB 31AB AND 17HJ INOP LT ASSY. REPLACED EMERGENCY LIGHT AT SEAT 23AB. STILL NEED TO REPLACE LIGHTS AT ROW 31AB AND 17HJ. AT SEAT 31AB AND 17HJ EMERGENCY LIGHT HAS BROKEN WIRES AT CONNECTOR GOING TO EMERGENCY LIGHT ON SEAT HARNESS SSDR UALA2009060501613Bypass Valve · failedLEFT ENGINE FUEL OIL COOLER BYPASS VALVE ASSY HAS A RUNNING OIL LEAK AROUND ASSY. RE-CLEANED AREA WITH CONTACT CLEANER AND RE-RUN ENGINE AND BYPASS ASSY IS DRIPPING AFTER ENGINE SHUTDOWN. OIL IS VISIBLE RUNNING DOWN FWD CONNECTORS OF BYPASS VLV.SDR UALA2009032300871Battery · defectiveMAIN BATTERY CHARGER STATUS MESSAGE CAME ON IN DESCENT. REPLACED SHIPS MAIN BATTERY. BATTERY AND CHARGER OPS CHECK OKAY.SDR UALA2009031600801Cable · damagedSEAT 1B EEL INOP. REPAIRED EEL CABLE. OP CHECKED OK.SDR UALA2009031600806Connector · damagedEEL INOP BETWEEN DOOR 1L AND 1R, (CROSSAISLE) FLOOR LIGHT. REPAIRED LIGHT CONNECTION AT SIDEWALL, OPS NORMAL.SDR UALA2009031600800Connector · looseAFT GALLEY RT FLOOR STRIP EEL INOP. SECURED EEL CONNECTOR AT SEATS 41HJ, EMERGENCY LIGHTS CHECK OKAY.SDR UALA2009031600799Connector · looseLT AND RT AFT LAV FLOOR STRIP EEL INOP. SECURED EEL CABLE CONNECTORS, EMERGENCY LIGHTS CHECK OK.SDR UALA2009031600798Cable · defectiveSEATS 1B, 17H, 37H, 38H, 39H, 41H EEL INOP. REPLACED EEL CABLE AT SEATS 41HF FEEDER, EMERGENCY LIGHTS CHECK OK.SDR UALA2009031600792Light · inoperativeLT AND RT AFT MID SLIDE GROUND ILLUMINATION EMERGENCY LIGHT INOP. SECURED LAMPS, OPS CHECKS OK.SDR UALA2009031600791Light · inoperativeLOWER CEILING EMERGENCY LIGHTS AT 8A AND 40A INOP. RELAMPED EMERGENCY LIGHT.SDR UALA2009031600790Light · missingSEAT 39A MISSING EEL LIGHT. REPLACED EEL STRIP.SDR UALA2009031000636Rvdt · faultyNR 7 L/E SLAT SHUTDOWN STATUS MESSAGE. TRBLSTG 27-81-00 FIG 112A. BITE SHOWS M603 FLAP LEVER RVDT MISRIG (SECT 1). SUSPECT INTERMITTENT RVDT. WILL REPLACE ONCE IN HAND. REPLACED M603 RVDT.SDR UALA2009022400636Warning System · activatedNR 7 L/E SLAT SHUTDOWN STATUS MESSAGE.SDR UALA2009022300626Light · missingONE EEL STRIP LIGHT ON SIDE OF SEAT 3H IS MISSING. REPLACED EEL LIGHT ASSEMBLY.SDR UALA2009031000627Rotary Actuator · trippedT/E FLAP DISAGREE INDICATION, WHEN CREW WENT TO FLAPS 5. LOWERED FLAPS WITH ALT SWITCH PER CL. FOUND LT WING INBOARD FLAP OUTBOARD ROTARY ACT TRIPPED; RESET. ALSO FOUND RT WING OUTBOARD FLAP OUTBOARD FLAP ROTARY ACT TRIPPED; RESET. OPERATED FLAPS ONE CYCLESDR UALA2009022300627Rotary Actuator · trippedTRAILING EDGE FLAP DISAGREE INDICATION WHEN WE WENT TO FLAPS 5. LOWERED FLAPS WITH ALT SWITCH PER CL FOUND LT WING INBOARD FLAP OUTBOARD ROTARY ACT TRIPPED; RESET. ALSO FOUND RT WING OUTBOARD FLAP OUTBOARD FLAP ROTARY ACT TRIPPED; RESET. OPERATED FLAPS ONE SDR UALA2009012000215Pump · faultyNR 2 ENG EDP DRIVE PAD LEAKING OIL AT 30 DROPS A MIN DURING ENG RUN AND AFTER SHUTDOWN. REMOVED AND REPLACED HYDRAULIC PUMP DRIVE OIL SEAL. REPLACED EDP CARBON SEAL & REPLACED EDP. NO LEAKS NOTED.SDR UALA2009011900191Light · missingEXIT STRIP LIGHTING MISSING FROM 31B, PART AT DOOR 1L. REPLACED EEL STRIP. TESTS OKAY.SDR UALA2008123007038Charger · faultyEICAS MSG MAIN BATTERY CHARGER. REPLACED MAIN BATTERY CHARGER.SDR UALA2008122306971Pump · leakingEDP HYD OVERHEAT LGT ILLUM. EICAS MSG (L, R) PRIM HYD OVERHEAT DISPLAYED. PUMP WAS DEACTIVATED, POS 1 (01=L,02=R). FOUND L ENG HYD PUMP LEAKING. REPLACED PUMP. ACP'D SYSTEM FLUSH, REPLACED CASE DRAIN AND PRESSURE FILTERS 3 TIMES. SERVICED L HYD SYS TO FUSDR UALA2008120506769Warning System · malfunctionedTHE 'T-E FLAP DISAGREE' EICAS MSG DISPLAYED WITH FLAPS AT 20 UNITS. ACCOMPLISHED BITE TEST OF FSEU AT GATE IN SFO WITH FLAPS STILL AT 20 UNITS. FSEU IS THE OLD NON-DIGITAL TYPE. SHOWED FAULTS FOR M548 AND M603. PERFORMED BITE TEST PER MM 27-51-00-FIG 104, SDR UALA2008112506670Valve · failedLEFT ENG HPSOV ON MOMENTARILY DURING DESCENT. PER FLT CREW, CAME ON WHEN PWR PULLED TO IDLE FOR DESCENT AND EXTINGUISHED AFTER APPROX 1 MIN. FOUND HPSOV BAD ON HEALTH CHECK. REPLACED HPSOV. OPS AND LEAK CHECK OKAY. NO FAULTS OR MESSAGES.SDR 2008UALA06051Panel · delaminatedRIGHT OVERWING SLIDE PANEL HAS A FOOTBALL SIZE DELAMINATION. DELAMINATED PANEL REMOVED & ROUTED TO SHOP. DOOR ASSY 416T2009-7 ON ORDER FROM BOEING. REPLACED RT OVERWING SLIDE DOOR. RIGGED AND ADJUSTED. REPLACED KEEPERS. EG EVALUATED THE FLUSHNESS CONDITION AN
Back to N665UA