N657UA
Service difficulty reports · 337
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 = 'N657UA' 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 = 'N657UA' 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 2008UALA03487Floor Support · corrodedMAIN CABIN FLOOR SUPPORT ANGLE -SPLASH GUARD- HAS CORROSION AT BS 285 AND RBL 83.SDR 2008UALA03466Structure · damagedLT FWD NLG DOOR SKIN HAS A LIGHTNING STRIKE APROX 17 INCHES AFT OF LEADING EDGE OF DOOR AND 7.75 INCHES FROM INBOARD EDGE OF DOOR. *S/D* FOUND LIGHTNING STRIKE IN NOSE LANDING GEAR DOOR. REMOVED DAMAGE TO LT FWD NLG DOOR AND INSTALLED COMPOSITE REPAIR PER SSDR 2008UALA03464Floorbeam · corrodedCORROSION FOUND AT BS 805, LBL 11, UNDER MAIN CABIN FLOOR. *S/D* SUSPECT MOISTURE CONTAMINATION. CUT OUT DAMAGED SECTION OF T-CAP SPLICED IN NEW SECTION PER SRM 53-00-51, SRM 51-20-01 AND SRM 51-40-02. AC OK FOR SERVICE.
SDR 2008UALA03465Stiffener · crackedE&E COMPARTMENT AT STA 246 FLOORBEAM AND LBL 40 HAS CRACKED VERTICAL STIFFENER. REPLACED CRACKED STIFFENER. FABRICATED & INSTALLED NEW REPAIR.SDR 2008UALA03445Floorbeam · wornMAIN CABIN FLOORBEAM UPPER SURFACE HAS WEAR MARKS AROUND FASTENER HOLE AT BS 764 BETWEEN RBL 20 AND RBL 54. *S/D* SUSPECT TOOLING MARKS. REMOVED DAMAGE AREA, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-51 FIG 201 TABLE I. AC OK FOR SERVICE.SDR 2008UALA03444Floorbeam · corrodedCABIN FLOORBEAM AT BS 805, RBL 11 IS CORRODED. REMOVED DAMAGE, FABRICATED NEW REPAIR AND INSTALLED IAW SRM 53-00-51 AND SRM 51-40-02. AC OK FOR SERVICE.SDR 2008UALA03443Floorbeam · crackedSTA 303, RBL 88.5, CRACK ON FLOORBEAM. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED T-CHORD, REPAIR SPLICE & STRAP.SDR 2008UALA03350Angle · crackedMAIN CABIN UNDER FLOOR, INTERCOSTAL UPPER ANGLE CRACKED BETWEEN BS 742 AND BS 764, AND RBL 40. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW ANGLE (P/N OA00002UD).SDR 2008UALA03359Shutoff Valve · faultyNR 1 ENG PRSOV FAILED HEALTH CHECK REFERENCE PRESSURE LOW. *S/D* DURING HEALTH CHECK FOUND PRESSURE REGULATING SHUT OFF VALVE FAULTY. REPLACED PRSOV. AC OK FOR SERVICE.SDR 2008UALA01153Power Cable · damagedEEL ADJACENT TO DR 1R INOP. REPAIRED POWER CABLE.SDR 2008UALA00559Lamp · inoperativeFWD LEFT OVERWING EMERGENCY LIGHT INOP. RELAMPED.SDR 2008UALA00543Skin · dentedEXTERIOR FUSELAGE SKIN AT BS 1373 AND STR 28R DENTED. MAJOR REPAIR ACCOMPLISHED: CUT-OUT DAMAGE TO EXTERNAL FUSELAGE AND FABRICATED REPAIR DOUBLERS AND FILLERS AND INSTALLED. REMOVED CRACKED SHEAR TIE AND FABRICATED A NEW -818 SHEAR TIE AND INSTALLED.SDR 2008UALA00374Oxygen Bottle · low pressureO2 BOTTLE AT DOOR 2R LOW. SUSPECT FAULTY VALVE. REPLACED O2 BOTTLE AT DOOR 2R. ACFT OK FOR SERVICE.
SDR 2008UALA00365Hose · collapsedRIGHT EMERGENCY EXIT SLIDE INFLATION HOSE IN THE HYDRAULIC SERVICE BAY IS COLLAPSED AND SPONGY. REPLACED HOSE ASSY. HYDRAULIC SPLASH DURING SERVICING MAKES CONTACT WITH HOSE & PARTIALLY DISSOLVES IT, BECOMING SPONGY. HOSE THEN IS PRONE TO COLLAPSING.SDR 2008UALA00364Skin · damagedON ARRIVAL FOUND SKIN DAMAGE AFT OF REAR CARGO DOOR. SUSPECT AC DAMAGE FROM GROUND EQUIPMENT. CUT-OUT DAMAGE TO EXTERNAL FUSELAGE AND FABRICATED REPAIR DOUBLERS AND FILLERS AND INSTALLED PER SRM 53-00-01, FIG. 201.REMOVED CRACK SHEAR 85625 TIE AND FABRICATEDSDR 2008UALA00074Anti-Ice Valve · inoperativeEICAS MSG ENG-ANTI ICE DISPLAYED. REPLACED NR 2 ENG ANTI ICE VALVE, AND OP CHECKED PER MM 30-21-03 -401. CHECKS GOOD.SDR 2007UALA04675Aspirator · unserviceableASPIRATOR LEAKING. REPLACED ASPIRATOR AND SLIDE. ACFT OK FOR SERVICE.SDR 2007UALA04074Unknown · unknownCREW COMMENTS: TEMPS VERY DIFFICULT IN COCKPIT, FIRST, BUS CLASSES.SDR 2007UALA03738Ballast · faultyFWD GALLEY OVERHEAD LIGHT EMITTED ODOR WHILE ON BUT WENT AWAY. LEFT IT OFF FOR REMAINDER OF FLIGHT. 10-9-07 REPLACED BALLAST M660, OP CHECKS OK.FOR SERVICE.SDR 2007UALA03607Warning Light · illuminatedGEAR DISAGREE LIGHT ILLUM WHEN GEAR WAS EXTENDED FOLLOWED BY TAIL SKID LIGHT.SDR 2007UALA03238Oven · fireGALLEY OVEN R42 CAUGHT ON FIRE. FIRE EXTINGUISED WITH HALON. REPLACED R42 GALLEY OVEN. OPS CKS OK. SUSPECT SHORT IN HEATING ELEMENT.SDR 2007UALA03044Structure · damagedFUSELAGE DAMAGED BELOW BULK CARGO DOOR. 08-31-07 ACP'D MAT'L LOSS INSP USING ULTRASONIC THICKNESS TESTER ON REPAIRED SKIN DAMAGE BELOW BULK CARGO DOOR. BLENDED DAMAGED AREA. REPAIR OK PER EVA 70500 IS FAA APPROVED VIA FAA 8100-9 FORM. AIRCRAFT OK FOR RESDR 2007UALA02381Lens · inoperativeRED FIRE WARNING LIGHT DOES NOT ILLUMINATE WHEN TESTED. [07-27-07] REPLACED FIRE ANNUNICATOR LENS ASSY. OP CHECKS NORMALLY.SDR 2007UALA01271Engine · surgesNR 2 ENGINE SILENT SURGE. [SUP 05-18-07] REPLACED NR 2 ENG ELECTRONIC ENGINE CONTROL PER AMM 73 -21-04. RT ENG PIMU HAD 'EEC CH-A T29 RNG FAIL' REF SMC 2. REF LOG 1 DURING ENG RUN AFTER REPLACE OF EEC FOUND PIMU FAULT 'EEC CH-A T29 RNG FAIL'. REPLACED NR 2 SDR 2007UALA00898Circuit Card · inoperativeRIGHT FUEL CUT OFF SWITCH FIRE TEST INOPERATIVE. [SUP 4-20-07] AFTER TROUBLESHOOTING FOUND LOGIC TEST FIRE OVERHEAT CARD M10274 AT FAULT. REPLACED CARD PER MM26-10-0 1, OP CHECKS GOOD. RETURN TO SERVICE.SDR 2007UALA00274Feeder Cable · damagedEEL STRIP LEFT FWD CABIN INOPERATIVE. REPAIRED EEL CABLE. A/C OK FOR SERVICE.SDR 2007UALA00228Wire Harness · damagedEMERGENCY FLOOR LIGHT IN FIRST CAM OUT OF TRACK. FOUND 2 EEL STRIPS INOP AT FWD DOOR AND CROSSOVER. REPAIRED HARNESSES PER GNMM 2-0-15-005. ALL GROUND CHECKS GOOD.SDR 2006UALA02364Angle · crackedNR 2 PYLON MIDSPAR FITTING CLOSE OUT ANGLE, OUTBOARD SIDE, INBOARD FASTENER HAS CRACK INDICATION APPROX .75 INCH LONG LOCATED AFT SIDE. STOP DRILLED THE CRACK AND ACCOMPLISHED HIGH FREQ EDDY CURRENT INSP. CRACK CONTAINMENT CONFIRMED. FABRICATED REPAIR SPLISDR 2005UALA00792Light · inoperativeLEFT SIDE FIRST CLASS EEL STRIPS INOP.SDR 2005UALA00651Power Supply · dischargedEMERGENCY LIGHTS L900, L908 AND L976 ON WITH SW IN ARMED POSITION. BATTERY PACK NOT HOLDING CHARGE. REPLACED OK.SDR 2005UALA00647Engine · overheatedRETURNED TO THE FIELD DUE TO HIGH OIL TEMPERATURE ON NR 2 ENGINE. REPLACED FUEL/OIL COOLER BYPASS VALVE SOLENOID. TESTED OK AFTER REPLACEMENT.SDR 2005UALA00601Hinge Fitting · damagedLT INBD FLAP CENTER HINGE FITTING LINE INBD SIDE DAMAGED. LEFT INBOARD FLAP CENTER HINGE FITTING FOUND DAMAGED ON INBOARD SIDE. REPAIRED PER SRM 57-53-02.SDR 2005UALA00600Skin · corrodedBS 955 CENTER WING BOX UPPER SKIN AT RBL 3 AT AFT SPAR CORRODED, SKIN SPLICE FITTING AND AFT SPAR. CORROSION CAUSED BY MOISTURE IN THE AREA. BLENDED WING SKIN, FABRICATED REPAIR SHIM BETWEEN SKIN AND FITTING, BLENDED SPAR CHORD, AND FABRICATED MODIFIED FITTSDR 2005UALA00593Skin · dentedDENT IN BULK CARGO DOOR, .5 INCHES BELOW EXISTING EXTERNAL REPAIR DOUBLER. INTERIM REPAIR PER EVA MOC1-8779A. ACCOMPLISH A DETAILED, EXTERNAL VISUAL INSPECTION EVERY 'A' CHECK UNTIL NEXT 'C10' CHECK. INTERIM REPAIR PER EVA MOC1-8779A. ACCOMPLISH A DETAILESDR 2006UALA01172Latch · wornLT O/W SLIDE DOOR LATCH FAILS EDGE MARGIN CHECK (NR 3 LATCH). REPLACE LATCH IAW 767, MM 25-65-98.SDR 2005UALA00282Aspirator · leakingTHE ASPIRATOR LEAKING BY BARREL. REPLACED ASPIRATOR.SDR 2004UALA00926Idg · vibrationDIVERTED WHEN LEFT ENGINE INDICATED IDLE FUEL FLOW AND IDLE THRUST. SHOP FOUND LOG PISTON FAILURE ON REMOVED LT IDG. CORRESPONDENCE BETWEEN COMPONENTS ENGINEERING, POWER PLANT ENGINEERING, SUNDSTRAND, AND PWA, INDICATES THERE IS A POTENTIAL ANOMALY FOR A WORSDR 2004UALA00131Autothrottle Sys · malfunctionedFLIGHT ABORTED TAKEOFF AT 100 KTS DUE TO AUTOTHROTTLE INDICATION. RETURNED TO BLOCKS. THRUST MANAGEMENT COMPUTER WAS REMOVED AS A PRECAUTION. UNIT CHECKED OK IN THE SHOP. MCDP FAULT DATA DID NOT RECORD ANY TMC-RELATED FAULTS DURING THE EVENT. REASON FOR TSDR 2004UALA00419Light · malfunctionedEEL LIGHTS BLINKING FROM ROWS 20 TO 28 CHECKED SYSTEM PER WDM33-51-11 & 33-51-14, SPLICES SM42, SM41,SM5 OVER M1559 OK. SPLICES SM44, SM43 & SM45 OVER M1556 ALSO OK.SDR 2003UALA00948Skin · crackedCRACK ON FWD UPPER PYLON SKIN INSIDE ACCESS PNL 432BR, NR 1 ENG. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2003UALA00951Line · failedC-HYDRAULIC SYSTEM QTY SLOWLY DECREASING. LEFT MAIN GEAR HYDRAULIC LINE FOUND LEAKING AT UPPER TRUNNION LOCATION. RESERVICED CENTER SYSTEM TO NORMAL. RYNGLOK REPAIR ACCOMPLISHED ON BRAKE HYDRAULIC LINE/TUBE. SPECIFIC HYDRAULIC LINE AND CAUSE OF LEAK NOT IDESDR 2003UALA00827Screw · looseNR 2 ENGINE FLAMEOUT. FLAME OUT WAS CAUSED BY FUEL LEAK AT THE AIR/OIL COOLER MUSCLE LINE. THE FUEL MUSCLE LINE WAS REPLACED AND THE ENGINE WAS REMOVED WITH IN 25 CYCLES DUE TO A SURGE ABOVE 1.25 EPR CAUSED BY THE FLAME OUT. THE MUSCLE LINE FAILED DUE TO VIBRSDR 2003UALA00650Switch · failedFWD EQUIP OVERHEAT MSG DISPLAYED. THE CABIN PRESSSURIZATION CONTROL MODULE M17, ROTARY SWITCH FAILED. THE SWITCH WAS REPLACED.SDR 2003UALA00582Battery · damagedMAIN BATTERY CHARGER STATUS MESSAGE. MAIN BATTERY REPLACED. SHOP REPORTS THE BATTERY WAS COMPLETELY DISCHARGED. BATTERY WAS PROCESSED THROUGH THE OVERHAUL CYCLE AND PASSED ITS ACCEPTANCE TEST.SDR 2002UALA01799Light · inoperativeEMERGENCY EXTERIOR LIGHT INOPERATIVE, AFT OF RIGHT WING. RELAMPED LIGHT.SDR 2002UALA01113Pump · leakingLOSS OF HYDRAULIC FLUID FROM RIGHT SYSTEM. REPLACED RIGHT ENGINE HYD PUMP DUE TO LEAK BETWEEN MATING SEAM. ACP ENG RUN, NO LEAKS NOTED.SDR 2002UALA01023Floorbeam · corrodedAFT PIT T-CAP CORRODED BODY STATION 1207 AND RBL 40. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM T-CAP.SDR 2002UALA01022Floorbeam · corrodedAFT PIT T-CAP CORRODED BODY STATION 1285, LBL 40. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM T-CAP.SDR 2002UALA01021Floorbeam · corrodedAFT PIT T-CAP CORRODED AT BODY STATION 1175, BL 0 TO RBL 40. MAJOR REPAIR ACCOMPLISHED. REPAIRED AND INSTALLED FLOORBEAM T-CAP.SDR 2002UALA01020Floorbeam · corrodedCABIN STATION 825-850, RBL 34, TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIRED BEAM.
Back to N657UA