N352UA, cancelled May 16, 2005
Service difficulty reports · 48
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 = 'N352UA' AND deregistration_id = 'N352UA-2005-05-16' 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 = 'N352UA' AND deregistration_id = 'N352UA-2005-05-16' 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 2004UALA00781Elevator · malfunctionedRETURNED TO DEN WITH ELEVATOR PROBLEM. NO FAULT HAS BEEN IDENTIFIED WITHIN THE ELEVATOR SYSTEM. THE FOLLOWING ACTIONS WERE TAKEN IN THE COURSE OF TROUBLESHOOTING:1. PITOT LEAK CHECK OF ELEVATOR FEEL SYSTEM. ACCOMPLISHED WITH NO LEAKS FOUND. 2. HORIZONTAL STSDR 2004UALA00733Csd · failedRETURNED TO ORD DUE TO A NR 1 ENGINE GENERATOR DRIVE LIGHT. NR 1 CSD FAILED. OIL LOSS EVIDENT ON COWL, CSD EXTREMELY HOT ON ARRIVAL, SUSPECT INTERNAL FAILURE. REPLACED THE NR 1 CSD, EXCESSIVE METAL FOUND ON CHIP DETECTOR. SHOP FOUND EXTENSIVE INTERNAL CSD FAILSDR 2002UALA01603Door Frame · corrodedAFT CARGO COMPARTMENT DOOR CUTOUT FRAME AT BODY STATION 794 S23R TO S24R AFT SIDE HAS EXCESSIVE MATERIAL REMOVED TO CLEAN CORROSION. MAJOR REPAIR ACCOMPLISHED. FABRICATED REPAIR DOUBLER.SDR 2002UALA01602Skin · crackedCRACK IN FUSELAGE SKIN DOUBLER AT FORWARD EDGE OF FORWARD PIT DOOR CUTOUT 13 INCHES ABOVE LOWER EDGE. MAJOR REPAIR ACCOMPLISHED. TRIPLER REPAIR.SDR 2002UALA01596Intercostal · crackedCABIN FLOOR INTERCOSTAL UPPER FLANGE CRACKED AT BODY STATION 933 BL 0. MAJOR REPAIR ACCOMPLISHED. REPLACED UPPER FLANGE.SDR 2002UALA01587Tee Fitting · corrodedAFT PIT DOOR OPENING FORWARD FRAME TEE FITTING FOR BOTTOM STOP PAD FITTING IS CORRODED BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. REPLACED SUPPORT TEE FITTING.SDR 2002UALA01577Door Frame · crackedFORWARD GALLEY DOOR CUTOUT FORWARD FRAME AT STOP PAD FITTING IS CRACKED (UPPER FITTING). MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE. INSTALLED FRAME.SDR 2002UALA01575Skin · damagedAFT EDGE OF AFT CARGO DOOR CUTOUT SKIN BLENDED WORN. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01574Frame · crackedLEFT HAND BODY STATION 188 FRAME CRACKED AT STRINGER 17 LEFT HAND. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01573Bulkhead · crackedLEFT HAND BODY STATION 178 FUSELAGE CHORD CRACKED AT WL207. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW WEB REPAIR.SDR 2002UALA01572Frame · crackedRIGHT HAND BODY STATION 188 FRAME CRACKED AT STRINGER 17 RIGHT HAND. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01571Bulkhead · crackedRIGHT HAND BODY STATION 178 FUSELAGE CHORD CRACKED AT WL207. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW WEB SECTION REPAIR.SDR 2002UALA01546Crease Beam · corrodedLEFT HAND CREASE BEAM WEB CORRODED BETWEEN BODY STATION 639 AND BODY STATION 663. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR 2002UALA01540Intercostal · crackedCABIN INTERCOSTAL, OUTBOARD ANGLE CRACKED FORWARD OF BODY STATION 291.5 FRAME AND BELOW STRINGER 11 RIGHT HAND. MAJOR REPAIR ACCOMPLISHED. REPLACED ANGLE.SDR 2002UALA01539Crease Beam · corrodedRIGHT HAND CREASE BEAM WEB CORRODED BETWEEN BODY STATION 616 AND 639. MAJOR REPAIR ACCOMPLISHED. NEW WEB INSTALLED.SDR 2002UALA01538Crease Beam · corrodedRIGHT HAND CREASE BEAM WEB CORRODED BETWEEN BODY STATION 578 AND 597. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW WEB.SDR 2002UALA01535Floorbeam · corrodedFORWARD CABIN STATION 360 RBL 12 FLOORBEAM HAS SURFACE CORROSION. MAJOR REPAIR ACCOMPLISHED, INSTALLED STRAP REPAIR.SDR 2002UALA01556Shear Tie · crackedCABIN STATION 787 FRAME WEB JUST ABOVE STRINGER 9R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. J ANGLE REPAIR.SDR 2002UALA01531Frame · crackedCABIN STATION 787 FRAME WEB JUST ABOVE STRINGER 9R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE INSTALLED ON FRAME.SDR 2002UALA01528Frame · crackedCABIN STATION 400 FRAME IS CRACKED AT STATION 9L PASSENGER SERVICE UNIT - VENT SUPPORT INBOARD FASTENER. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01525Splice · crackedCABIN 907 STRINGER 4L STRINGER SPLICE IS CRACKED AT TWO FASTENERS. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SPLICE.SDR 2002UALA01524Frame · crackedCABIN STATION 807 FRAME WEB ABOVE STRINGER 9R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01523Frame · crackedCABIN STATION 480 FRAME IS CRACKED AT STRINGER 9L PASSENGER SERVICE UNIT VENT SUPPORT INBOARD FASTENER. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01522Frame · crackedCABIN STATION 827 FRAME WEB ABOVE STRINGER 9L SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01521Crease Beam · corrodedAFT CABIN RIGHT HAND SIDE FLOOR CREASE BEAM CORRODED BETWEEN STA 947-990 JUST INBOARD OF DOOR 2 RIGHT HAND BELOW DRAIN GUTTER. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR 2002UALA01517Splice · crackedCABIN STATION 907 STRINGER 4R STRINGER SPLICE IS CRACKED AT 2 FASTENERS. MAJOR REPAIR ACCOMPLISHED. REPLACE STRINGER SPLICE.SDR 2002UALA01510Frame · crackedCABIN STATION 440 FRAME IS CRACKED AT STRINGER 10L IN RADIUS JUST INBOARD OF STRINGER CLIP. MAJOR REPAIR ACCOMPLISHED. FUSELAGE FRAME REPAIR INSTALLED.SDR 2002UALA01509Frame · crackedCABIN STATION 887 FRAME WEB ABOVE STRINGER 9R SHEAR TIE IS CRACKED. REPAIR ANGLE INSTALLED ON FRAME.SDR 2002UALA01508Floorbeam · crackedCABIN FLOOR BEAM INTERCOSTAL UPPER FLANGE IS CRACKED BODY STATION 500D-520, BL0, WL208. MAJOR REPAIR ACCOMPLISHED. REPLACED INTERCOSTAL UPPER FLANGE .SDR 2002UALA01507Frame · crackedCABIN STATION 480 FRAME IS CRACKED AT STRINGER 9R AT PASSENGER SERVICE UNIT-VENT SUPPORT INBOARD FASTENER. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2002UALA01505Stringer Clip · crackedSTATION 727A STRINGER CLIP CRACKED STRINGER 6R. MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP.SDR 2002UALA01504Stringer Clip · crackedSTATION BODY STATION 616 STRINGER CLIP CRACKED 4L STRINGER. MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP.SDR 2002UALA01503Frame · crackedCABIN STATION 887 FRAME WEB ABOVE STRINGER 9L SHEAR TIE, IS CRACKED. REPAIR ANGLE INSTALLED ON FRAME.SDR 2002UALA01502Frame · crackedCABIN STATION 827 FRAME WEB ABOVE STRINGER 9R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE INSTALLED ON FRAME.SDR 2002UALA01495Frame · crackedCABIN FRAME WEB CRACKED BODY STATION 807 STRINGER 9L WL 258. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR ON FRAME.SDR 2002UALA01558Floorbeam · corrodedAFT CABIN STATION 1016 FLOORBEAM UPPER CHORD LBL 7 TO 11 HAS EXCESSIVE MATERIAL LOSS DUE TO BLEND REMOVAL OF CORROSION. MAJOR REPAIR ACCOMPLISHED. REPAIR STRAP AND ANGLES INSTALLED.SDR 2001UALA02347Bulkhead · crackedSTATION 178 BULKHEAD RBL 5.7 AT WL 210 HAS CRACK INDICATION. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED FILLER AND DOUBLER AND INSTALLED.SDR 2001UALA02346Bulkhead · crackedSTATION 178 BULKHEAD LBL 5.7 AT WL 210 HAS CRACK INDICATION. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED FILLER AND DOUBLER AND INSTALLED.SDR 2001UALA02345Bulkhead · crackedSTATION 178 BULKHEAD RBL 5.7 WL 200 HAS 2 EA CRACKS. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER AND FILLER.SDR 2001UALA02331Bulkhead · crackedSTATION 178 BULKHEAD RBL 5.7 WL 200 HAS 2 CRACK INDICATIONS FOUND BY NONDESTRUCTIVE TESTING. MAJOR REPAIR ACCOMPLISHED, FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR 2000UALA00416Sensor · failedNORMAL AND ALTERNATE EQUIPMENT COOLING WARNING LIGHTS ILLUMINATED. *S/D* M100 LOW FLOW INSTRUMENT COOLING SENSOR FAILED. REPLACED M100 LOW FLOW INSTRUMENT COOLING SENSOR.SDR 98UAL900520Element · failedAPU FIRE LIGHT CAME ON. NO EXTERIOR INDICATIONS. REPLACED APU TAIL PIPE OVER HEAT SENSING ELEMENT AND WIRE HARNESS FOR OVER HEAT ELEMENT, REF MM 26-15-14. TESTED OK.SDR 98UAL900421Sensor · out of adjustCARGO DOOR WARNING LIGHT ILLUMINATED. *S/D* ADJUSTED SENSOR TARGET.SDR 98UAL900251Trim · failedCREW DIVERTED TO BNA DUE TO INOPERATIVE HORIZONTAL STABILIZER TRIM.SDR 97UAL900793Controller · failedUNABLE TO PRESSURIZE AIRCRAFT AFTER TAKEOFF. AIRCRAFT WAS OPERATING IN AUTO MODE, SWITCHED TO STANDBY AND CABIN STILL CONTINUED TO CLIMB 500 FPM. OUTFLOW VALVE INDICATOR SHOWED FULL CLOSED. NO DOOR WARNING LIGHTS ON. *S/D* REPLACED CABIN PRESSURE CONTROLLSDR 97UAL900556Tire · failedTIRE TREAD LOSS ON TAKEOFF. SURROUNDING GEAR DOORS WERE DAMAGED. *S/D* REPLACED NR 3 AND NR 4 MLG TIRES DUE TO NR 4 TIRE THROWING TREAD. DAMAGE INCURRED TO RT MLG INNER DOOR. NR 4 TIRE CARCASS WAS BF GOODRICH.SDR 96UAL900763Light · failedONE SECTION OF EMERGENCY EGRESS LIGHTING INOP ROW 12. INSTALLED NEW LIGHT SECTION, OPERATION CHECKS NORMAL.SDR 95UAL900209Valve · stickingABORTED TAKEOFF AT LGA AT 75 KNOTS DUE TO NR 2 ENGINE BLEED PROBLEM. REPLACED NR TWO ENGINE HIGH-STAGE VALVE. ALSO, REPLACED NR ONE ENGINE HIGH-STAGE VALVE AND REGULATOR. CHECKS O.K.
Back to N352UA, cancelled May 16, 2005