N342UA, cancelled May 6, 2009
Service difficulty reports · 51
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 = 'N342UA' AND deregistration_id = 'N342UA-2009-05-06' 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 = 'N342UA' AND deregistration_id = 'N342UA-2009-05-06' 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 2008UALA03161Connector · contaminatedEEL LIGHTS INOP FROM SEAT 15 TO BACK OF AIRCRAFT. SUSPECT MOISTURE CONTAMINATION. CLEANED ELECTRICAL CONNECTION POINTS ALONG EEL ON THE AFT END. AC OK FOR SERVICE.SDR 2008UALA02498Light · inoperativeLEFT AFT GALLEY AREA 3' STRIP INOP. REPLACED EEL STRIP. OPS CHECKS NORMAL.SDR 2007UALA04536Fitting · gougedFWD ENTRY DOOR FWD LOWER ROLLER FITTING GOUGED. LIGHTLY BLENDED FITTING. INSTALLED HORSESHOE SHIM.SDR 2007UALA04524Girt Bar · damagedAFT ENTRY DOOR ESCAPE SLIDE GIRT HANGING DOWN TOO FAR. REPLACED AFT ENTRY SLIDE ASSY.SDR 2007UALA03136Oxygen Mask · faultyCAPTAIN'S OXYGEN MASK RUNS CONTINUOUSLY IN RESET TEST.SDR 2007UALA01662Connector · looseFIRST CLASS SECTION EEL LIGHTS INOPERATIVE. SECURED LOOSE CONNECTIONS. OPS CHECK NORMAL.SDR 2007UALA01292Feeder Cable · defectiveFIRST 10 ROWS OF COACH EEL LIGHTS ARE INOPERATIVE. REPLACED EEL LIGHT FEEDER CABLE FROM WALL TO STRIP.SDR 2006UALA01905Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT ON EXTERIOR OF ACFT INOP. REPLACED LIGHT.SDR 2006UALA01904Light · inoperativeAFT CABIN EEL LIGHTS INOP FROM ROW 15 AFT TO AND INCLUDING EEL STRIP IN FRONT OF AFT GALLEY CART STOWAGE COMPARTMENT. REPLACED CABLE AND AFT EEL STRIP.SDR 2006UALA01683Wire · inoperativeEEL LIGHTS INOP FROM ROW 15 TO BACK OF AIRCRAFT. REPLACED CABLE.SDR 2006UALA00974Keelbeam · damagedRT WHEEL WELL KEELBEAM ATTACHED ANGLE HAD HOLE PREVIOUSLY DRILLED INTO AT BS 678.SDR 2006UALA00973Stringer Splice · crackedSTRINGER SPLICE CHANNEL ON UPPER FLANGE IS CRACKED JUST FWD OF BS 360 FRAME, STRINGER 16L.SDR 2006UALA00972Frame · crackedFWD GALLEY DOOR FWD AND AFT FRAMES CRACKED AT LOWER STOP FITTING MOUNT HOLE.SDR 2006UALA00971Crease Beam · corrodedFWD GALLEY DOOR CREASE BEAM INBD OF THRESHOLD FROM STA 294-340 HAS CORROSION.SDR 2006UALA00959Crease Beam · corrodedFWD ENTRY DOOR CREASE BEAM FROM APPROX STA 320 - STA 360 HAS CORROSION.SDR 2006UALA00958Bulkhead · damagedAFT PRESSURE BULKHEAD INSIDE UPPER LEFT WIRE BUNDLE PASS THROUGH HAS DAMAGE IN SEVERAL AREAS.SDR 2006UALA00957Strap · crackedAFT PIT STATION 847 S21R AND S22R STRAP UNDER INNER CHORD OF FRAME IS CRACKED.SDR 2006UALA00931Crease Beam · corrodedFOUND CABIN FLOOR CREASE BEAM WEB CORRODED LT BS 418.SDR 2006UALA00671Light · inoperativeALL EEL LIGHTS AFT OF ROW 15 INOPERATIVE.SDR 2006UALA00524Warning Light · illuminatedFLAP DISAGREE ILLUMINATED ON APPROACH. ON APPROACH, THE FLAP DISAGREE LIGHT ILLUMUNATED. THE TRAILING EDGE FLAP POSITION INDICATOR SHOWED RIGHT FLAP AT 2, LEFT FLAP BETWEEN 2-5. AFTER LANDING, THE TRAILING EDGE FLAP POSITION INDICATOR (MR27583) WAS REPLACEDSDR 2006UALA00315Cover · missingSECTION OF EEL TRACK COVER MISSING AT ROW 3 & 4.SDR 2005UALA01514Light · inoperativeEEL LIGHTS INOP FROM ROW 15 AFT. REPLACED EEL STRIP.SDR 2004UALA01128Wire · failedEEL LIGHTS INOPERATIVE FROM SEATS 17 TO AFT GALLEY. REPLACED FLOOR FEEDER CABLE FOR EEL LTS FROM ROW 17 BACK.SDR 2003UALA00125Inverter · inoperativeEMERGENCY EXIT LIGHTING INOPERATIVE FROM ROW 15 TO THE REAR OF AIRCRAFT. REPLACED INVERTER AND POWER CABLE AT ROW 18, EEL LIGHTS OP CHECKED GOOD.SDR 2002UALA00812Frame · damagedCABIN FRAME 951 AT STRINGER 5R & 6R HAS FASTENER HOLES OVERSIZED PAST LIMITS. HOLES INDICATED CRACK FREE AT .2802, LIMIT .233. MAJOR REPAIR ACCOMPLISHED. INSTALLED FREEZE PLUGS. ALSO INSTALLED REPAIR FILLER, DOUBLER AND TAPERED SHIMS ON FRAME.SDR 2002UALA00809Bulkhead · damagedBODY STATION 178 BULKHEAD RBL 5.7, WL 207 PREVIOUSLY ROUTED OUT FOR ED PROBLEM, AND BULKHEAD SKIN UNDER CHORD ANGLE IS DAMAGED. MAJOR REPAIR ACCOMPLISHED TO AIRCRAFT ANGLE AND SKIN.SDR 2002UALA00808Frame · damagedBULKHEAD 178 RIGHT HAND CHORD AT WL 207 NEEDS TO BE REPLACED. MAJOR REPAIR ACCOMPLISHED. REPLACED CHORD.SDR 2002UALA00807Floorbeam · damagedDAMAGE FOUND FORWARD CABIN STATION 277 RBL 53 UPPER FLOORBEAM HOLE. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2002UALA00806Pressure Panel · crackedCRACK FOUND AT LEFT HAND WHEEL WELL BULKHEAD STATION 665 LBL 32. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2002UALA00805Frame · crackedCABIN STATION 827 STRINGER 9R FRAME IS CRACKED. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR 2002UALA00799Skin · canningAFT CARGO DOOR SKIN DENT COUPLED WITH OIL-CANNING: 14 INCHES DOWN AND 9 INCHES FORWARD FROM UPPER AFT CORNER OF DOOR. MAJOR REPAIR ACCOMPLISHED. FILLER AND STIFFENER INSTALLED.SDR 2002UALA00793Frame · crackedLEFT HAND AFT SIDE OF BODY STATION 188 FRAME IS CRACKED IN THE RADIUS OF THE WEB AT WL 207. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE INSTALLED. VERIFIED NO CRACKS AFTER DAMAGE REMOVED.SDR 2002UALA00791Frame · crackedRIGHT HAND AFT SIDE OF BODY STATION 188 FRAME IS CRACKED IN THE RADIUS OF THE WEB AT WL 207. MAJOR REPAIR ACCOMPLISHED. INSTALLED FRAME REPAIR. VERIFIED NO CRACKS AFTER DAMAGE REMOVED.SDR 2002UALA00788Skin · crackedTHERE IS A 2.5 INCH CRACK IN FUSELAGE AT LOWER AFT RADIUS OF DOOR 1R OPENING. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE INSTALLED. VERIFIED CRACK FREE AFTER DAMAGE REMOVED.SDR 2002UALA00750Skin · crackedEXTERNAL FUSELAGE AT KEEL BEAM STATION 698 LBL 4 LOWER SKIN CRACKED. MAJOR REPAIR ACCOMPLISHED. EXTERNAL DOUBLER INSTALLED.SDR 2002UALA00748Floorbeam · corrodedFLOORBEAM AT BODY STATION 335 RBL 16 TO RBL 24 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM.SDR 2002UALA00747Crease Beam · corrodedRIGHT HAND CABIN STATION 727B TO 727C STRINGER 17R WL 208 CREASE BEAM WEB CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR 2002UALA00746Crease Beam · corrodedSTRINGER 17R CREASE BEAM HAS CORROSION FROM STATION 294 TO 328 RBL 58 INBOARD ANGLE. MAJOR REPAIR ACCOMPLISHED. REPLACED SECTION OF CREASE BEAM INBOARD CHORD ANGLE.SDR 2002UALA00745Crease Beam · corrodedLEFT HAND CABIN STATION 727C TO 727D STRINGER 17 WL 208 CREASE BEAM WEB CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR 2002UALA00742Frame · crackedRIGHT HAND STUB FRAME STATION 294 STRINGER 17R WL 208 CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND DOUBLER.SDR 2002UALA00741Crease Beam · corrodedCREASE BEAM WEB CORRODED 3 AREAS STATION 620 - 640 RIGHT HAND SIDE. MAJOR REPAIR ACCOMPLISHED. REPLACED STRINGER 17R CREASE BEAM WEB.SDR 2002UALA00740Frame · crackedSTATION 867 FRAME IS CRACKED AT STRINGER 9R RIVET HOLE. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR 2002UALA00729Frame · crackedCABIN STATION 887 STRINGER 9R FRAME IS CRACKED AT RIVET. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND DOUBLER.SDR 2002UALA00728Frame · crackedCABIN STATION 867 STRINGER 9L FRAME IS CRACKED AT RIVET. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND DOUBLER.SDR 2002UALA00727Frame · crackedCABIN FRAME STATION 847 CRACKED AT STRINGER 9L RIVET. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR DOUBLER.SDR 2002UALA00725Frame · crackedCABIN FRAME AT STATION 847 STRINGER 9R IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE INSTALLED.SDR 99UAL900541Engine · bird strikeON TAKEOFF, NUMBER TWO ENGINE ENCOUNTERED A BIRD STRIKE. THIS RESULTED IN A JUMP OF ENGINE VIBRATION FROM ZERO TO TWO.SDR 99UAL900231Bearing · wornSIGNIFICANT AIRFRAME VIBRATION FELT IN CONTROLS, FLOOR, AND GLARESHIELD. *S/D* THE VIBRATION WAS CAUSED BY A WORN BEARING AND BUSHINGS ON THE LEFT HAND ELEVATOR TAB INBOARD HINGE. THE WORN PARTS WERE REPLACED. OPS CHECK OK.SDR 97UAL900885Windshield · shatteredCAPTAIN'S WINDSHIELD OUTER PANE SHATTERED. *S/D* REPLACED CAPTAIN'S WINDSHIELD.SDR 97UAL900478Prsov · failedRIGHT BLEED TRIPOFF LIGHT ON AND A SECOND LATER LEFT BLEED TRIPOFF LIGHT ON. TOTAL LOSS OF CABIN PRESSURE. INITIATED EMERGENCY DESCENT PROCEDURES. ACCOMPLISHED PNEUMATIC SYSTEM TROUBLESHOOTING ON BOTH ENGINES. NUMBER ONE ENGINE TESTED GOOD. NUMBER 2 ENGIN
Back to N342UA, cancelled May 6, 2009