N347UA, cancelled Sep 1, 2010
Service difficulty reports · 85
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 = 'N347UA' AND deregistration_id = 'N347UA-2010-09-01' 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 = 'N347UA' AND deregistration_id = 'N347UA-2010-09-01' 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 UALA2009072402206Light · unsecureEMERGENCY ROW LIGHT COMING UP ROW 20, 21. FOUND EEL TRACK FEEDER STRIP FAULTED. REPLACED FEED STRIP INSIDE OF TRACK AND OPS CHECKED LIGHTS OK.SDR UALA2009070801973Unknown · unknownRETURNED TO THE FIELD WITH A STABILIZER TRIM ISSUE. AMBER DECLARED.SDR UALA2009070701951Module · failedSTAB TRIM PROBLEM, RTFL. AFTER TAKEOFF STAB TRIM INOP IN NOSE DOWN POS. RMV COLUMN SWITCH MODULE M1201, FOUND PUSHED BACK PIN ON K4 B2. NEED TO CONTINUE T/S AFTER RPL OF M1201. REPLACED COLUMN CUTOUT SWITCH MODULE. ALSO REPLACED S115 NOSEUP LIMIT SWITCH. SDR UALA2009062901855Power Strip · inoperativeEMERGENCY EXIT PATH LIGHTING INOP FROM ROW 15 AND BACK. REPLACED POWER STRIP, CHECKS NORMAL.SDR UALA2009061701723Target · bentCARGO DOOR LIGHT ILLUM. RTFL. FOUND CARGO PROX SWITCH TARGET BENT. STRAIGHTENED AND DOOR LIGHTS OP NORMAL.SDR 2008UALA06201Light · inoperativeLEFT OVERWING SLIDE EEL LIGHT INOP. RELAMPED, OPS CHECK OKAY.SDR 2008UALA02226Feeder Cable · cutFLOOR EMERGENCY LIGHTS INOP FROM SEAT 15ABC TO AFT GALLEY CARPET. REPLACED EEL LIGHT RIBBON CABLE, REF 33-50-00 OP CHECKED OK. AC OK FOR SERVICE.
SDR 2008UALA00672Receptacle · faultyEXTERNAL POWER WAS ARCHING WHEN IN USE. SIGN OF CHARRING ON PANEL. REPLACED EXTERNAL POWER RECEPTACAL.
SDR 2008UALA00201Fitting · damagedDIVERTED UNDER AMBER ALERT DUE TO HYDRAULIC PROBLEM. FOUND LOOSE GROUND SPOILER PRESSURE FITTING AT THE NR 5 SPOILER INBOARD ACTUATOR. REPLACED UNION AND PACKING.
SDR 2007UALA03496Feeder Cable · brokenFLOOR EEL LIGHTS ARE INOP FROM SEAT ROW 10 AFT. BROKEN LEAD, FEEDER CABLE. REPLACED LEAD ON THE MIDDLE SECTION, FOUND INVERTER AND FEEDER CABLE BAD.REPLACED INVERTER AND FEEDER CABLE.SDR 2007UALA03495Lamp · burned outRIGHT AFT FUSELAGE SLIDE EEL LIGHT IS INOPERATIVE. LAMP BURNED OUT. RELAMPED LIGHT ASSY, OPS CHECK NORMAL.SDR 2007UALA02345Hook · broken1R DOOR RETAINER HOOK FOR DOOR SLIDE FOUND BROKEN. INSTALLED NEW RETAINER FOR GIRT BAR.SDR 2007UALA00135Structure · misdrilledFWD INBOARD HOLE OF UPPER WING WAS MISDRILLED. MAJOR REPAIR: INSTALLED FREEZE PLUG REPAIR TO DAMAGED HOLE.SDR 2007UALA00133Fitting · tool damageRIGHT MLG FITTING HAS TWO EACH TOOLING MARKS. MAJOR REPAIR: BLENDED TOOLING MARKS PER AAR EA I060568 REV IR AND FAA FORM 8100-9.SDR 2007UALA00132Skin Panel · wornEXTERIOR FUSELAGE SKIN BS 964 TO 970 LBL 12 SKIN WORN AT DORSAL FIN SEAL AREA. MAJOR REPAIR: FABRICATED AND INSTALLED DOUBLER TRIPLER AND STAINLESS WEAR TRIPLER PER AAR EA I060562 REV IR.SDR 2007UALA00116Attach Fitting · corrodedLT HORIZ STAB FWD UPPER LUG CORRODED, AFT FACE. MAJOR REPAIR: BLENDED AND REWORKED LUG PER AAR EA I060563 AND SRM 55-10-10 DAMAGE 3.SDR 2007UALA00115Skin · wornEXTERNAL FUSELAGE SKIN WORN UNDER DORSAL FIN LANDING. MAJOR REPAIR: INSTALLED EXTERNAL SKIN DOUBLER-TRIPLER REPAIR PER SRM 53-60-01 REPAIR 9.SDR 2007UALA00114Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT DOORWAY FRAME BS 492 IS CRACKED IN TWO PLACES JUST ABOVE LOWER STOP FITTING. MAJOR REPAIR: INSTALLED NESTED DOUBLER FRAME REPAIR PER AAR EA I060559 AND UA EVA 70030 ON AAR NR11660-1400-0001.SDR 2007UALA00113Frame · corrodedAFT CARGO DOOR CUTOUT, FWD FRAME BS 847 CORRODED ON AFT SIDE BTWN STR'S 24R AND 25R. INSTALLED NEW FRAME SECTION REPAIR PER SRM 51-40-02.SDR 2007UALA00112Frame · corrodedAFT CARGO DOOR CUTOUT, AFT FRAME BS 797 CORRODED ON FWD SIDE BTWN STR 24R AND 25R. INSTALLED NEW FRAME SECTION PER SRM 51-40-02.SDR 2007UALA00111Bear Strap · damagedAFT PIT DOOR CUTOUT BEAR STRAP DAMAGED AT STOP FITTING LOCATIONS STR'S 21R, 22R, 23R. INSTALLED LOWER DOOR CUTOUT WRAP AROUND EXTERNAL SKIN DOUBLER-TRIPLER AND INTERNAL FILLER PER SRM 53-00-01 REPAIR 31 AND 32.SDR 2007UALA00088Web · corrodedAFT CARGO COMPARTMENT THRESHOLD SILL WEB STA 780-787 RBL 20-21 HAS CORROSION. MAJOR REPAIR: REMOVED AND REPALCED THRESHOLD WEB PER SRM 51-40-02.SDR 2007UALA00087Floorbeam · corrodedFLOORBEAM CORRODED AT STA 947 LBL 16 - RBL 16. MAJOR REPAIR: REMOVED DAMAGE. REPAIRED THE T-CAP AT STA 947 PER MM 53-10-95. REPLACED ENTIRE UPPOER FLOOR BEAM CAP, SPLICE LOCATED AT 947 RBL6.SDR 2007UALA00086Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277 STR 15R. MAJOR REPAIR: REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02.SDR 2007UALA00085Stringer Clip · damagedAFT CARGO PIT STA 787L STR 23L ATTACH CLIP IS DAMAGED. MAJOR REPAIR: REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02.SDR 2007UALA00084Attach Fitting · damagedAFT CARGO PIT LEFT STA 787 STR 22L ATTACH CLIP DAMAGED. MAJOR REPAIR: REMOVED AND REPLACED CLIP PER SRM 51-40-02 PAGE 2.SDR 2007UALA00083Crease Beam · corrodedAFT GALLEY DOOR TRESHOLD SEAL AREA HAS NUMEROUS SPOTS OF CORROSION, CREASE BEAM INNER CHORD CORRODED STA 947.5 - STA 994. 5 STR 17R RBL 44 TO RBL 52. MAJOR REPAIR: REMOVED AND REPLACED CREASE BEAM PER SRM 51-40-02 AND SRM 51-20-01.SDR 2007UALA00102Bracket · misinstalledAFT ENTRY DOOR EVAC SLIDE COVER FWD GIRT BAR STORAGE BRACKET IS LOOSE. INCORRECT FASTENERS INSTALLED. INSTALLED CORRECT FASTENERS.SDR 2007UALA00081Skin · dentedRIGHT LOWER EXTERIOR FUSELAGE SKIN APPROX STA 253 BETWEEN STR 25R & 24R HAS A DENT. ACCOMPLISHED MANUFACTURED AND INSTALLED DOUBLER AND STRUCTURAL FILLER.SDR 2007UALA00073Door Frame · crackedFWD ENTRY DOOR AFT FRAME CRACKED AT 4TH STOP FROM BOTTOM. REMOVED DAMAGE. FABRICATED AND INSTALLED EXTERNAL DOUBLER REPAIR PER SRM 51-70-11 PAGE 1-6.SDR 2007UALA00029Frame · crackedINTERIOR CABIN OVERWING EXIT FRAME BS 616 LT FWD INBOARD SIDE FRAME STUB INNER CHORD BOTTOM FASTENER HOLE JUST ABOVE PRESSURE DECK IS CRACKED. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED NESTED ANGLE AND FILLER REPAIR PER MM 53-11-89.SDR 2007UALA00028Keelbeam · corrodedFWD PIT KEEL BEAM EXFOLIATED AT BS 500D TO 500D +5\ RBL 7 TO RBL 8 AT WL 145. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED NESTED ANGLE REPAIR PER SRM 53-30-12 REPAIR NR 2.SDR 2007UALA00027Pin · corrodedLEFT MLG AFT MAIN BEAM O/B ATTACH PIN CORRODED. MAJOR REPAIR: REPLACED ATTACH PIN.SDR 2006UALA01473Pump · malfunctionedUNWANTED FUEL TRANSFER, IN CLIMB-OUT GOT A 600LB FUEL IMBALANCE NR 2 TANK LOW. IMBALANCE OCCURRED WHEN BURNING 2000 LBS OUT OF CTR TANK. ONCE CTR TANK FUEL DEPLETED, THE IMBALANCE REMAINED AT 600 LBS. REPLACED CENTER TANK CHECK VALVE AND BOOST PUMP.SDR 2006UALA01233Lamp · inoperativeOFF WING EMERGENCY LIGHT AFT OF RT WING INOP. LAMP INOPERATIVE.SDR 2006UALA01232Wire · unknownAFT CABIN EEL LIGHTS INOP FROM ROW 15 AFT TO AND INCLUDING EEL STRIP IN FRONT OF AFT GALLEY CART STOWAGE COMPARTMENT.SDR 2006UALA00031Slide · dislodgedEMERGENCY ESCAPE SLIDE PACK AT DOOR 2L HAS FALLEN OFF DOOR. CAUSE FOR THE DOOR 2L SLIDE FALLING OFF THE DOOR IS UNKNOWN. HOWEVER, THE SLIDE (MR25656-1332) WAS RECENTLY INSTALLED, JUST 4 DAYS PRIOR TO THIS INCIDENT. PER APPLICABLE AMM, 25-61-35, THE SLIDE WASDR 2005UALA01396Wire · inoperativeEEL LIGHT INOP AT AFT GALLEY CART STOWAGE. REPLACED RIBBON CABLE.SDR 2005UALA01007Odor · detectedELECTRICAL SMELL OCCURRED IN COCKPIT AND CABIN AFTER 1ST ATTEMPT TO CONNECT GROUND POWER. REMOVED SPEED SENSOR ACC PNL FOUND APU INLET OIL SOAKED, RAN APU UNABLE TO FIND SOURCE 22SEP SFO: PER AMM 49-00-00-0101 PG 180M FIG 140 LK 21. REPLACE SPEED SENSOR PACKINSDR 2005UALA00852Skin · dentedEXT FUSELAGE SKIN IS DENTED 0.75 INCH FWD OF STA 1006 & IMMEDIATELY BELOW SKIN LAP AT S14L.SDR 2005UALA00848Skin · damagedEXTERNAL FUSELAGE STA 434 STR 2R BLENDED SKIN AROUND A FASTENER IS DAMAGED.SDR 2005UALA00704Wire · damagedEMERGENCY EXIT PATH LIGHTS STRIP INOP FROM ROW NR 15 AFT. REPLACED CABLE.SDR 2005UALA00566Pin · brokenTHE SAFETY PIN WAS BROKEN OFF IN THE CYLINDER HEAD. CAUSE COULD NOT BE DETERMINED. REMOVED THE BROKEN PIN FROM CYLINDER AND REPLACE WITH A NEW SAFETY PIN.SDR 2005UALA00452Wire · cutAFT EEL LIGHTS FROM ROW 17 AFT INOP. FEEDER CABLE CUT OR DAMAGED - REPLACED.SDR 2004UALA01216Light · inoperativeAFT EMERGENCY FLOOR EEL LIGHTS INOP FROM MID TO AFT OF AIRCRAFT. REPLACED EEL LIGHTS MID TO AFT GALLEY.SDR 2004UALA00584Light · contaminatedEMERGENCY EXIT PATH LIGHTS ARE INOP FROM ROW 15 AFT. REMOVED COFFEE AND CLEANED EEL TRACKS. OPS CHECKED NORMAL.SDR 2003UALA00839Lamp · inoperativeEMERGENCY EXIT FLOOR LIGHTING PULLED UP AND INOPERATIVE AT ROW 21. REPLACED LIGHT STRIP.SDR 2003UALA00607Pump · leakingAIRCRAFT MADE A LANDING UNDER AMBER ALERT DUE TO HYDRAULIC FLUID LEAKAGE. INSPECTION REVEALED THAT THE B SYSTEM ENGINE DRIVEN HYDRAULIC PUMP WAS LEAKING FROM THE SPLINED INPUT SHAFT. THE PUMP WAS REPLACED AND THE SYSTEM WAS TESTED WITH NO LEAKS NOTED. INTERNSDR 2003UALA00572Warning Light · illuminatedAIRCRAFT ABORTED TAKEOFF AT 90 KNOTS DUE TO NR 2 ENGINE RED EGT LIGHT ON. EGT EXCEEDANCE CHECK PERFORMED, POWER MANAGMENT CONTROL (PMC) SYSTEM CHECKED . ALL RESISTANCE CHECKS OK, EXCEPT FOR T12 TEMP SENSOR. T12 SENSOR WAS REPLACED. PLA VOLTAGE ON PMC WITHIN LSDR 2002UALA01873Bulkhead · dentedAFT PRESSURE BULKHEAD, RIGHT FORWARD CIRCUMFERENTIAL STRAP BULKHEAD DENTED AT FASTENERS. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED AND INSTALLED DOUBLER REPAIR.
Back to N347UA, cancelled Sep 1, 2010