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 2008UALA06040Connector · looseLT MID LAV EEL LIGHT INOP. SECURED CONNECTOR TEST OK.SDR 2008UALA06039Light · inoperativeTHE 15AB EEL LIGHT INOP. REPLACED LAMP. TEST OK.SDR 2008UALA06038Light · inoperativeTHE 29HJ EEL LIGHT INOP. REPLACED LAMP. TEST OK.SDR 2008UALA06033Pump · malfunctionedEDP HYD OVERHEAT LIGHT ILLUM EICAS MSG (L, R) PRIM HYD OVERHEAT DISPLAYED. PUMP WAS DEACTIVATED. POS 1 (01=L,02=R). SAMC TEXT: AFTER EDP SECURED SEVERAL MINUTES LATER LT QTY DROPPED TO ZERO AND EMDP WAS TURNED OFF. REPLACED LT ENG HYD PUMP AND CASE DRAIN SDR UALA2008111305468Unknown · contaminatedHEAVY ODOR (BURNING SMELL) IN CABIN. RTFL. AC SYSTEM OIL CONTAMINATION REMOVAL. ENGINE RUN TO REMOVE OIL ODORS. SIX QUARTS OIL REMOVED FROM OIL TANK. ALL OIL SMELL HAS DISSIPATED FROM NR 1 ENG BLEED SYSTEM. NO ODORS PRESENT AT END OF PACK BURN.SDR 2008UALA05468Unknown · odorHEAVY ODOR (BURNING SMELL) IN CABIN. RTFL.SDR 2008UALA05467Turbine Blades · failedLEFT ENGINE SURGE DET STATUS MSG. FOUND METAL IN THE TAILPIPE. THE ENGINE WAS REPLACED AT PRIOR TO FURTHER FLIGHT. SHOP TEARDOWN REVEALED THAT THE ENGINE HAD SUFFERED AN HP TURBINE STAGE-2 BLADE UNDER PLATFORM STRESS CORROSION (SCC) FAILURE. ONE BLADE FRACSDR 2008UALA04275Filter · unknownR ENG OIL FILTER EICAS LIGHT ILLUM APPROX 1 MIN, WENT AWAY. R OIL FILTER STATUS MSG REMAIN. *S/D* REPLACED MAIN OIL FILTER.SDR 2008UALA03951Engine · bird ingestionNR 1 ENGINE VIBRATION/POSSIBLE BIRD STRIKE. RTFL. ENGINE NOT SHUT DOWN. AFTER RTF, BIRD STRIKE CONFIRMED. MM FOUND 2 DAMAGED FAN BLADES. REPLACED DAMAGED BLADES AND OPPOSITE BLADES. HP COMPRESSOR BORESCOPE OK. AIRCRAFT RETURNED TO SERVICE.SDR 2008UALA03962Idg · malfunctionedEICAS MSG ON RIGHT ENGINE GEN DRIVE DISPLAYED. LIGHT ILLUM GEN DRIVE DISCONNECTED. REPLACED RIGHT IDG.SDR 2008UALA03910Starter · failedENG 1 HUNG START AT 43 PERCENT N2, EGT STABLE, START VALVE MESSAGE & START VALVE LIGHT DISAGREE ON OVERHEAD PANEL. ENGINE SHUT DOWN. GROUND CREW REPORTED LOUD BANG. FOUND STARTER SOAKED WITH OIL. OPENED START VALVE AND THERE WAS A STEADY STREAM OF OIL OUT TSDR 2008UALA03219Skin · damagedBAG CART HIT AIRCRAFT BELLY JUST AFT OF MAIN LANDING GEAR. MAJOR REPAIR ACCOMPLISHED: ROUTED OUT DAMAGED SKIN AT BS 1171-1175 AND 1197+22-1197+29 BETWEEN STR 36L-38R. FABRICATED & INSTALLED DOUBLERS, TRIPLERS AND FILLERS.SDR 2008UALA02546Power Supply · faultyEMERGENCY LIGHTS AT RIGHT SIDE FROM ROW 26 BACK ON WITH SWITCH ARMED, WENT OFF WITH SWITCH OFF. REPLACED EMERGENCY LIGHT POWER SUPPLY FOR EEL LIGHTING PRECAUTIONARY.SDR 2008UALA02489Warning System · activatedCREW REPORTED A T/E FLAP DISAGREE.SDR 2008UALA01726Flap System · stuckFLAP HANDLE AT 5, FLAPS LOCKED UP AT 1 EICAS, T/E FLAP DISAGREE.SDR 2008UALA00781Battery Pack · inoperativeLEFT EMERGENCY LIGHTS L1 AND L3 OVERWING LIGHTS ARE INOP. REPLACED BATTERY PACK.
SDR 2008UALA00791Structure · dentedAFT MANUAL CARGO DOOR HAS DENT APPROX 3 INCHES FROM AFT EDGE AND THREE FEET FROM BOTTOM. REMOVED DAMAGED AREA. FABRICATED AND INSTALLED DOUBLER REPAIR. A/C OK FOR RETURN TO SERVICE.SDR 2008UALA00779Light · inoperativeIN SEAT EMERGENCY LIGHTS AT SEATS 3HJ, 24HJ AND 35HJ ARE INOP. REMOVED AND REPLACED LIGHTS.SDR 2008UALA00778Support · crackedBS 246 AT BL 0, PULLEY SUPPORT CRACKED.SDR 2008UALA00777Lamp · faultyEMERGENCY AISLE LIGHT ABOVE SEAT 12HJ IS DIM. REMOVED AND REPLACED LAMP.SDR 2008UALA00776Connector · looseL-1 DOOR EMERGENCY EXIT LIGHT IS INOP. RESEATED CONNECTOR.SDR 2008UALA00775Connector · unsecureEXTERIOR LIGHTS, OVERWING EMERGENCY SLIDE AND DOOR LIGHTS ARE INOP (LEFT SIDE). RESEATED CONNECTOR.SDR 2008UALA00774Cylinder · defectiveLEFT OVERWING SLIDE CABLE BALL IS BELOW RETAINER SPRING ON INFLATION CYLINDER.SDR 2008UALA00771Housing · crackedLEFT OVERWING EMERGENCY SLIDE DISCONNECT HOUSING IS CRACKED.SDR 2008UALA00770Lamp · inoperativeRIGHT AFT DOOR UPPER EMERGENCY EXIT LIGHT, DOOR HANDLE ILLUMINATION PORTION IS INOP. RELAMPED.SDR 2008UALA00703Light · unsecureEMERGENCY EXIT LIGHT AT L-1 DOOR-UPPER SIGN IS NOT PROPERLY SECURED, CAUSES LENSE TO BE LOOSE.SDR 2008UALA00702Support Bracket · crackedBS 246, RBL 13.96 PULLEY SUPPORT BRACKET IS CRACKED.SDR 2008UALA00694Battery Pack · inoperativeAFT ENTRY DOOR LEFT AND RIGHT EMERGENCY EXIT LIGHT IS INOP. INSTALLED NEW BATTERY.
SDR 2008UALA00693Support · crackedBS 246 AT RBL 15.78 PULLEY SUPPORT CRACKED.SDR 2008UALA00692Connector · looseFOUND EMERGENCY LIGHT AT SEAT 17HJ IS INOP. RESECURED LOOSE CONNECTION.SDR 2008UALA00678Light · faultyWITH FLIGHT DECK EMERGENCY LIGHT SWITCH IN ARM, INTERIOR EMERGENCY EXIT LIGHTS TURN ON. AFTER FURTHER TROUBLESHOOTING FOUND EMERGENCY C/B TO BE COLLARED. RESET C/B`S AND CHECKED GOOD IAW MM 33-51-00.SDR 2008UALA00677Lens · crackedSEVERAL LOWER EMERGENCY EXIT LIGHT IDENTIFIER LENSES ARE CRACKED OR EXCESSIVELY DIRTY.SDR 2008UALA00668Stiffener · crackedBS 246 AT LBL 26.39 STIFFENER IS CRACKED.SDR 2008UALA00525Light · inoperativeSEAT 31B EEL INOP. REPLACED LIGHT STRIP.SDR 2008UALA00524Light · inoperativeSEAT 17H EEL INOPERATIVE. REPLACED LIGHT STRIP.SDR 2007UALA05324Apu · flamed outAPU FLAMED OUT AND WOULD NOT RESTART.SDR 2007UALA04607Light · missingEEL STRIP AT 26HJ MISSING. REPLACED LIGHT STRIP.SDR 2007UALA04382Connector · looseFLAP - SLAT ELEC EICAS MSG DISPLAYED. REPLACED FLAP POSITION TRANSMITTER. SECURED CONNECTOR ON FLAP POSITION TRANSMITTER 1L ON LEFT WING. OPERATED FLAPS, NO MESSAGES, BITE TEST OF FSEU SHOWED NO FAULTS.
SDR 2007UALA04261Skin · damagedRT FUSELAGE APPROX 20 INCHES AFT OF AFT CARGO DOOR STA 1360 STR 27 HAS DAMAGE. ACCOMPLISHED REPAIR PER EVA-70734A AND SRM 53-00-01 FIG201. ACFT OK FOR SERVICE.SDR 2007UALA03859Aileron · sticksAILERON STICKS WHILE INFLIGHT AND HESITATES WHEN CHECKED ON GROUND AFTER LAG. 10-19-07 REPLACED LEFT LATERAL CONTROL ACTUATOR TORQUE TUBE REF MM 27-11-16. AILERON OPS CHECKS GOOD.SDR 2007UALA03858Spoiler · malfunctionedBINDING IN NR 6 SPOILER. BINDING OCCURRED ONLY WITH LEFT HYD SYSTEM AND LEFT WING DOWN - SPOILER NR 6 UP. SPOILER WAS CHATTERING WITH ASSOCIATED NOISE. WITH ONLY CENTER OR RIGHT HYD, NO BINDING OR NOISE NOTED. NR 6 SPOILER FAILED TO LIFT WITH LEFT HYD POWESDR 2007UALA01925Structure · scratchedALT STATIC PORT, RIGHT SIDE FUSELAGE, JUST FWD OF FWD CARGO DOOR HAS 5 IN LONG SCRATCH THRU WHITE CIRCLE, JUST UNDER STATIC PORT. [08-08-07] DAMAGE DEPTH IS .0021 OK PER 53-00-01 ALSO PER 51-10-03 ITEM F. BURNISHED SCRATCH PER SRM 51-10-02. TOUCHED UP WHISDR 2007UALA01853Autopilot Sys · failedCENTER & RIGHT AUTOPILOTS FAILED CAUSING A DIVERSION. [07-31-07] RE-ALIGNED RT FCC. STILL HAD PROBLEM. REPLACED LEFT ELEVATOR SERVO VALVE ASSY. RELOADED NAV DATABASE. TESTS OK.SDR 2007UALA00964Aspirator · leakingASPIRATOR LEAKING. CAUSE UNKNOWN DUE TO INTERNAL LEAKING. REPLACED ASPIRATOR.SDR 2006UALA02155Bottle · lowFOUND LOW BOTTLE PRESSURE. REPLACED SLIDE. AIRCRAFT RETURNED TO SERVICE.SDR 2006UALA01751Support Beam · crackedLT MLG TRUNNION WING DOOR ATTACH SUPPORT BEAM CRACKED. STRUT ASSY FOUND GOUGED & CRACKED. ACCOMPLISHED MAJOR REPAIR PER REO G1 1788. HFEC INSP FOR HIDDEN CRACKING AFTER REPAIR PER NDT 51-00-00-19, PT 6. OK FOR SERVICE.SDR 2006UALA01722Stiffener · crackedCRACKED VERTICAL STIFFENER ON FLOORBEAM BS 246, LBL 40, AFT SIDE. FABRICATED STIFFENER 141T5171-64 PER BACO DWG 141T5171 AND REPLACED PER SRM 53-10-51 AND 51-40-2. SUSPECT FORWARD GALLEY SERVICE EQUIPMENT LOADS.SDR 2006UALA01223Bearing · unserviceableFOUND THREE (3) DAMAGED BEARINGS. EXCESSIVE TENSION ON THE TENSION ROD. REPLACED DAMAGED BEARINGS. AIRCRAFT RETURNED TO SERVICE. ROOT CAUSE WAS EXCESSIVE TENSION BUILT IN DURING SLIDE ASSEMBLY.SDR 2006UALA01113Pump · failedDIVERTED DUE TO CENTER HYDRAULIC PUMP FAILURE. NR 3 SPOILER ACTUATOR LEAKING HYDRAULIC FLUID. REPLACED NR 3 SPOILER ACTUATOR LAST CHANCE FILTER PLUG O-RING. LEAK CHECKED SPOILER ACTUATORS. LEAK CHECKED OK.SDR 2006UALA00807Wire · inoperativeEEL STRIP INOP AT 1H, 22A AND FROM 14HJ TO MID GALLEY RIGHT LAV. REPLACED EEL STRIP AT SEAT 1H. REPLACED FEEDER CABLE TO EEL STRIP AT SEAT 22A. REATTACHED FEEDER CABLE CONNECTOR AT SEAT 14HJ TO MID-GALLEY-RIGHT LAV EEL STRIP. ALL EEL LIGHTS, OP CHECK OK.
Back to N665UA