N353UA, cancelled Jan 27, 2010
Service difficulty reports · 34
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 = 'N353UA' AND deregistration_id = 'N353UA-2010-01-27' 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 = 'N353UA' AND deregistration_id = 'N353UA-2010-01-27' 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 2003UALA00606Transceiver · failedAIRCRAFT DIVERTED ENROUTE WHEN WEATHER RADAR FAILED. TRANSCEIVER FAILED. REMOVED AND REPLACED TRANSCEIVER. FAILURE WAS CONFIRMED IN THE SHOP AS AN ANTENNA DRIVE FAILURE.SDR 2003UALA00168Frame · crackedSTATION 188 RT SIDE FRAME CRACKED IN RADIUS AT WL 207. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED AND INSTALLED RT SIDE FRAME.SDR 2003UALA00167Frame · crackedLT STATION 188 FRAME IS CRACKED AT WL 207. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED MODIFIED FRAME.SDR 2003UALA00166Stringer · dentedAFT CABIN FUSELAGE STRINGER OUTBOARD SURFACE DENTED APPROXIMATELY BODY STATION 1004 STRINGER 14L. MAJOR REPAIR ACCOMPLISHED. REPLACED STRINGER.SDR 2003UALA00154Frame · crackedLEFT FUSELAGE WING ROOT FRAME CRACKED AT STATION 540 S22L. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2003UALA00150Frame · crackedSTATION 616 WL 208 LT BODY FRAME CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE REPAIR.SDR 2003UALA00148Frame · crackedCABIN FRAME WEB CRACKED AT STATION 616 LT, WL 205. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW WEB SECTION AND SPLICE DOUBLER.SDR 2003UALA00147Frame · crackedCABIN BODY STUB FRAME IS CRACKED BS 296 RT WL 257-277. MAJOR REPAIR ACCOMPLISHED. REPLACED STUB FRAME.SDR 2003UALA00140Channel · corrodedCABIN FLOOR INTERCOSTAL AT STATION 328 TO 344 RBL 51 STRINGER 17R CORRODED. MAJOR REPAIR ACCOMPLISHED. REMOVED INTERCOSTAL EXTRUSION CHANNEL AND REPLACED WITH NEW VENDER PART.SDR 2003UALA00139Floor Support · corrodedCABIN FLOOR SUPPORT AT STATION 335 RBL 52 TO 60, STRINGER 17R HAD EXCESSIVE CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW VENDOR T -ANGLE SUPPORT.SDR 2003UALA00138Intercostal · corrodedCABIN FLOOR INTERCOSTAL AT STATION 1009 TO 1016 LBL 5 TO 9, STRINGER 17L HAD UPPER FLANGE CORRODED TO EXCESS. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW VENDER PART [I-CHANNEL ].SDR 2003UALA00127Floorbeam · corrodedCABIN FLOORBEAM UPPER FLANGE HAD EXCESSIVE CORROSION AT STATION 360 RBL 5 IN TO LBL 18IN STRINGER 17L-17R. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SECTION OF T-CAP MOUNTED ON AFT SIDE OF VERTICAL WEB WITH 9.5 IN, L-ANGLE SPLICES FWD AND AFT OF EACH CUT, FOURSDR 2003UALA00126Web · crackedSHEAR WEB CRACKED AT STRINGER 17L BETWEEN STATION 188 AND 196.5. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR WEB.SDR 2003UALA00122Frame · crackedFRAME AT BODY STATION 727E STRINGER 9L AT SUPPORT RAIL CLIP IS CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR 2003UALA00121Pressure Panel · crackedMLG WHEEL WELL PRESSURE PANEL CRACKED AT STA 670 LBL33, OUTBOARD AND AFT OF AILERON TOWER SHAFT. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR 2003UALA00117Frame · crackedCABIN FRAME AT STATION 747 STRINGER 9R CRACKED AT RAIL SUPPORT CLIP. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2003UALA00113Frame · crackedFRAME CRACKED AT BS 847 STRINGER 9R AT STOW BIN SUPPORT RAIL. MAJOR REPAIR ACCOMPLISHED. FRAME REPAIR.SDR 2003UALA00112Frame · crackedFUSELAGE FRAME CRACKED STATION 807 AT STR 9R SUPPORT RAIL CLIP ATTACH FASTENER. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR 2003UALA00111Crease Beam · corrodedCABIN FLOOR RT CREASE BEAM INNER Z-ANGLE CORRODED FROM STA 270-360. MAJOR REPAIR ACCOMPLISHED. REPLACED Z-ANGLE.SDR 2003UALA00102Frame · crackedCABIN FUSELAGE AT STATION 887, FRAME AT STRINGER 9R IS CRACKED. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2003UALA00101Channel · corrodedAFT CABIN FLOOR MOUNTED HAT CHANNEL WITH L-ANGLE ON UPPER FORWARD WALL MOUNTING HAD CORROSION AT NUT PLATE HOLES STATION 988 13 (RBL OUT TO 43.5) RBL. STR 17R (CABIN FLOOR). MAJOR REPAIR ACCOMPLISHED. CUT TO SIZE NEW SECTION OF HAT CHANNEL EXTRUSION WITH L-ANSDR 2003UALA00100Frame · crackedFRAME AT STATION 867 ABOVE STRINGER 9R CRACKED OUT OF FASTENER HOLE FOR BRACKET SUPPORT FOR AIR GRILL RAIL. MAJOR REPAIR ACCOMPLISHED. INSTALLED FABRICATED J-ANGLE REPAIR.SDR 2003UALA00097Frame · crackedSTATION 767 FRAME CRACKED AT STRINGER 9L AT SUPPORT RAIL ATTACH FASTENER. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR 2003UALA00096Frame · crackedSTATION 767 FRAME CRACKED AT STRINGER 9R AT SUPPORT RAIL ATTACH FASTENER. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2003UALA00095Frame · crackedSTATION 787 FRAME CRACKED AT STRINGER 9R SUPPORT RAIL CLIP ATTACH FASTENER. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2003UALA00094Angle · corrodedCABIN BODY STATION 947 THRU 960 RT ZEE ANGLE UPPER SURFACE CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED ANGLE.SDR 2003UALA00093Clip · crackedFRAME AT BODY STATION 807 STRINGER 9L AT SUPPORT RAIL CLIP CRACKED. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER INSTALLED.SDR 2003UALA00092Crease Beam · corrodedCREASE BEAM WEB AT STATION 827-847 STRINGER 17L HAS CORROSION. ACCOMPLISHED MAJOR REPAIR. REPLACED WEB.SDR 2002UALA01103Pressure Switch · failedLANDED DEN UNDER AMBER ALERT DUE TO A NR 1 ENGINE COWL ANTI-ICE WARNING LIGHT, WHICH CAUSED THE CREW TO SHUT DOWN THE ENGINE. PRESSURE SWITCH 21SN41-52 FAILED. MAINTENANCE REPLACED PRESSURE SWITCH, OPS CHECKS NORMAL.SDR 2001UALA02321Bulkhead · crackedBODY STATION 178 BULKHEAD WEB CRACKED AT LBL 5.7, WL 197. MAJOR REPAIR ACCOMPLISHED, INSTALLED EXTERNAL DOUBLER ON FORWARD SIDE OF WEB.SDR 2001UALA02319Bulkhead · crackedBODY STATION 178 BULKHEAD WEB CRACKED AT LBL 5.7, WL 122. MAJOR REPAIR ACCOMPLISHED, INSTALLED EXTERNAL DOUBLER ON FORWARD SIDE OF WEB.SDR 2001UALA02318Bulkhead · crackedBODY STATION 178 BULKHEAD RBL 5.7, WL 200 WEB CRACKED. MAJOR REPAIR ACCOMPLISHED, INSTALLED REPAIR DOUBLER ON FORWARD SIDE OF BULKHEAD.SDR 2000UALA00458Light · inoperativeEMERGENCY EXIT LIGHTING STRIP INOPERATIVE. REPLACED POWER SUPPLY.SDR 96UAL900101Actuator · failedWHEN AUTOPILOT 'B' SELECTED, THE STABILIZER OUT OF TRIM LIGHT DISPLAYED. AIRCRAFT STARTED DESCENT AND WOULD NOT HOLD ALTITUDE, THE AIRCRAFT CLIMBED SEVERAL TIMES. AFTER DISCONNECTING AUTOPILOT, COULD NOT TRIM FWD USING YOKE SWITCH OR MANUALLY TRIM FWD PAST 4
Back to N353UA, cancelled Jan 27, 2010