N369UA, cancelled Apr 5, 2011
Service difficulty reports · 53
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 = 'N369UA' AND deregistration_id = 'N369UA-2011-04-05' 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 = 'N369UA' AND deregistration_id = 'N369UA-2011-04-05' 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 2008UALA04166Lamp · inoperativeLEFT OVERWING HATCH ILLUMINATION EMERGENCY LIGHTS INOP. *S/D* RELAMPED WITH 2EA LAMPS.SDR 2008UALA04164Lamp · inoperativeFLIGHT DECK EMERGENCY LIGHT INOP. *S/D* RELAMPED, OP CHECKS OKAY.SDR 2008UALA02662Spindle · corrodedCORROSION SUSPECTED AT LT OB FLAP, INBD SPINDLE.SDR 2008UALA02074Fitting · failedCAPTAINS O2 FITTING SNAPPED OFF IN STOWAGE BOX. REPLACED CAPTS O2 MASK BOX PER MM 35-12-96. AC OK FOR SERVICE.
SDR 2007UALA05175Extinguisher · low pressureFWD GALLEY HALON FIRE EXTINGUISHER PRESSURE APPEARS LOW. REPLACED HALON EXTINGUISHER IN FWD GALLEY.SDR 2007UALA04363Skin · damagedFUSELAGE SKIN 16 INCHES FWD OF FWD CARGO DOOR CUTOUT IS DENTED WITH A GOUGE IN MIDDLE OF DENT. MEASURES 3.5" LONG, .25" WIDE, .080" DEPTH AND RUNS THROUGH 2 RIVETS. PERFORMED SRM REPAIR OF AREA.SDR 2007UALA03591Fire Bottle · low pressureLEFT ENGINE (FORWARD) FIRE BOTTLE LOW PSI, READS 700 PSI.SDR 2007UALA02541Terminal · looseGEAR WARNING HORN SOUNDS WITH THROTTLES IN IDLE AND FLAPS UP. FOUND GROUND GD2858 DC LOOSE AT TERMINAL STUD SECURED LUG,SDR 2007UALA02482Keelbeam · wornWEAR ON UPPER KEEL BEAM RIGHT HAND FROM 2 PANEL FASTENER RBL 7 STA 720-722. [07-27-07] MAJOR REPAIR: INSTALLED AN ANGLE, CUTOUT FILLER AND REPAIR FILLER. ACCOMPLISHED PER AAR EA REV IR, EAI070461 IR.SDR 2007UALA02481Light · inoperativeRIGHT LOWER AFT FUSELAGE EMERGENCY EXIT LIGHT IS INOP. [07-27-07] RELAMPED RT LOWER AFT FUSELAGE EMERGENCYSDR 2007UALA02480Skin · wornEXTERNAL CROWN SKIN HAS WEAR DAMAGE UNDER DORSAL LANDING ON LEFT SIDE FROM BS 908-965. [07-27-07] MAJOR REPAIR: INSTALLED DOUBLER, TEAR STRAP DOUBLER, AND TAPE RED FILLER. REFERENCE AAR EA I0700457 IR.SDR 2007UALA02479Door Frame · crackedFWD PIT DOORWAY CUTOUT FWD FRAME IS CRACKED AT LWR DOOR STOP FITTING. [07-27-07] MAJOR REPAIR: REMOVED CRACK AND ACCOMPLISHED ANGLE REPAIR PER MM 53-30-75.SDR 2007UALA02478Bearing · looseFWD ENTRY DOOR CUTOUT HAS AN AFT STOP PAD LOOSE. [07-20-07] REMOVED AND REPLACED BEARING STOP PAD.SDR 2007UALA02474Bearing · looseFWD ENTRY DOOR CUTOUT FWD & AFT STOP PADS ARE LOOSE. [07-20-07] REMOVED & REPLACED BEARING STOP PAD.SDR 2007UALA02473Cable · misroutedRIGHT AILERON CABLE MISROUTED ABOVE CONTROL QUADRANT CASTING DAMAGE TO CABLE AND AILERON QUADRANT ATTACH HARDWARE. [07-31-07] REMOVED AND REPLACED MISROUTED CABLE.SDR 2007UALA02472Skin · damagedUPPER FUSELAGE ATC ANTENNA HAD A DEEP SCRIBE IN SKIN FOUND AFTER ANTENNA REMOVED. [07-27-07] MAJOR REPAIR: INSTALLED A DOUBLER PER EA 1070451 REV IR.SDR 2007UALA02471Skin · dentedLWR AFT FUSELAGE BELLY SKIN, BS 807 BL 0 BETWEEN STRINGERS 27L-27R HAS LARGE DENT ADJACENT TO FRAME CAUSING FASTENER PROTRUSION. [07-27-07] MAJOR REPAIR: REMOVED DAMAGE AND REPAIRED THE SKIN BY INSTALLING A DOUBLER. REFERENCE SRM 53-00-01 REPAIR 13.SDR 2007UALA02470Shear Tie · crackedAFT PIT STA 807 BETWEEN STR 27R AND 27L AT BL 0, SHEAR TIE IS CRACKED IN RADIUS AT OUTER SKIN. [07-27-07] MAJOR REPAIR: ACCOMPLISHED SHEAR TIE REPLACEMENT AT STA 807 STR 27R TO STR 27L.SDR 2007UALA02469Support Angle · crackedAFT PIT STA 807, BETWEEN STR 26R AND 25R LOWER DOOR SILL SUPPORT ANGLE IS CRACKED. [07-27-07] MAJOR REPAIR: REPLACED SUPPORT ANGLE AT STA 807 BETWEEN STR 26R AND 25R. REFERENCE SRM 51-40-02.SDR 2007UALA02468Skin · dentedFUSELAGE SKIN DENTED AT STA 870 STR 28R TO STR 28L. [07-27-07] MAJOR REPAIR: REMOVED DAMAGE. ACCOMPLISHED A DOUBLER REPAIR. ALSO REPLACED THE CRACKED SHEAR TIE IN THE AFT PIT. REFERENCE SRM 53-00-07 REPAIR 4.SDR 2007UALA02467Torque Tube · excess playAFT GALLEY DOOR CUTOUT TORQUE TUBE HAS MOVEMENT BEYOND .003. [07-31-07] REMOVED TORQUE TUBE, SPIGOT, AND BOTH GUIDE PLATES WITH BEARINGS. REINSTALLED BOTH GUIDE PLATES WITH NEW BEARINGS AND INSTALLED NEW TORQUE TUBE AND SPIGOTS.SDR 2007UALA02466Torque Tube · excess playAFT ENTRY DOOR CUTOUT TORQUE TUBE HAS MOVEMENT BEYOND .003 INCH. [07-31-07] REMOVED TORQUE TUBE, SPIGOT, AND BOTH GUIDE PLATES WITH BEARINGS. REINSTALLED BOTH GUIDE PLATES WITH NEW BEARINGS AND INSTALLED NEW TORQUE TUBE AND SPIGOTS.SDR 2007UALA02426Bushing · corrodedLEFT HORIZONTAL STAB FWD SPAR UPPER LUG AFT FACE 8 - 11 O'CLOCK POS HAS CORROSION OUTSIDE OF THE SPOT FACE. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION. MANUFACTURED & INSTALLED BUSHING.SDR 2007UALA02425Bushing · corrodedLEFT HORIZONTAL STAB, UPPER FRONT SPAR TO CTR SECTION ATTACH LUG HAS CORROSION EMITTING FROM BUSHING. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION. MANUFACTURED & INSTALLED BUSHING.SDR 2007UALA02424Torque Tube · excess playFWD ENTRY DOOR CUTOUT TORQUE TUBE HAS MOVEMENT BEYOND .003. REMOVED & REPLACED BODY TORQUE TUBE.SDR 2007UALA02423Structure · crackedFWD ENTRY DOOR UPPER HINGE CUTOUT 5EA FASTENER HOLES ARE CRACKED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. INSTALLED DOUBLER & STRUCTURAL FILLER REPAIR.SDR 2007UALA02422Structure · crackedFWD ENTRY DOOR CUTOUT, UPPER AND LOWER HINGE CUTOUTS CRACKED OUT OF FASTENER HOLES. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. MFG'D & INSTALLED 2EA STRUCTURAL FILLER & DOUBLER REPAIR.SDR 2007UALA02421Stringer Splice · crackedFUSELAGE STRINGER SPLICE IS CRACKED AT LOWER FLANGE AND UPPER FLANGE BS360 STR 15L. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED STRINGER SPLICE 15L AT STA 360.SDR 2007UALA02391Structure · dentedAFT CARGO HAS DENT 9 INCHES FROM UPPER AFT CORNER AND 8 INCHES DOWN FROM TOP. REMOVED DAMAGE. INSTALLED DOUBLER REPAIR.SDR 2007UALA02390Skin · damagedFWD CARGO DOOR S/N 1783 EXTERNAL SKIN HAS LARGE AREA OF DAMAGE CREASED 9 INCHES FROM FWD TO 9 INCHES FROM AFT AND 18 INCHES FROM TOP TO 27 INCHES FROM TOP. REMOVED DAMAGE AREA. REPLACED WITH NEW CARGO DOOR SKIN.SDR 2007UALA02257Skin · chafedUPPER EXTERNAL FUSE SKIN HAS CHAFING WEAR AT DORSAL FIN LANDING FROM BS 860 - 907 BL 0 - LBL 8. MAJOR REPAIR: BLENDED CROWN SKIN WEAR. APPLIED .020 WEAR STRIPS PER SRM 53-60-01 REPAIR 10 PARAGRAPH 5.SDR 2007UALA02161Seat Track · corrodedAFT RT LAV AREA FLOOR STRUCTURE OB SEAT TRACK STA 995-1016 LBL 39 LBL40 WL 208-208 UPPER SURFACE HAS CORROSION. REMOVED AND REPLACED FLOOR TRACK AND WEB.SDR 2007UALA02160Floorbeam · corrodedAFT CABIN FLOORBEAM CAP UPPER SURFACE STA 985-987 RBL 40 TO RBL 45 WL 208 HAS CORROSION.SDR 2007UALA02159Skin · crackedPASSENGER CABIN BELOW FLOOR LEVEL BD 663 LBL 32, PRESSURE DECK UPPER SKIN CRACKED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER/FILLER REPAIR.SDR 2007UALA02123Skin · gougedFWD UPPER FUSELAGE CROWN AT STA 290 STR 2L SKIN IS GOUGED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED AND INSTALLED DOUBLER, TRIPLER AND FILLER.SDR 2007UALA02122Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED BS 470 STR 14R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION. INSTALLED DOUBLER/FILLER REPAIR.SDR 2007UALA02114Crease Beam · corrodedAFT CABIN FLOOR CREASE BEAM HAS AREAS OF CORROSION JUST BELOW AFT ENTRY DOOR CUTOUT BS 967-986. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW INNER CREASE BEAM.SDR 2007UALA02029Angle · crackedLEFT WW AREA BS 695 INNER CHORD ANGLE CRACKED IN RADIOUS LOCATED JUST ABOVE AND AFT OF UPLOCK. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED THE ANGLE.SDR 2007UALA00072Adc · faultyRETURNED TO LAX, DUE TO LOSS OF FIRST OFFICERS INSTRUMENTS. FAULTY ADC. ADC HAD LOOSE SCREW IN IT FROM T2 A9. REPLACED ADC IN A/C. SCREW ON REMOVED UNIT HAS BEEN SECURED PROPERLY.SDR 2006UALA00314Light · inoperativeDOOR 1 LEFT EEL LIGHT INDICATIONS INOP. ALSO FWD CENTER AISLE EXIT SIGN AND DOOR 1 RIGHT SLIDE LIGHT INOP.SDR 2004UALA01041Overheat Loop · malfunctionedDIVERTED TO COS DUE TO WING BODY OVERHEAT INDICATION. EXPERIENCED RIGHT WING BODY OVERHEAT WARNING IN FLIGHT WITH ENGINE SUPPLYING AIR. ISOLATED TO RIGHT WING LEADING EDGE OVERHEAT DETECTOR LOOP M1204. REPLACED OVERHEAT DETECTOR LOOP M1204. SYSTEM OPERATIOSDR 2003UALA00767Access Panel · damagedLEFT WING INBOARD FLAP LOWER ACCESS PANEL 8407L DAMAGED AT ATTACH HOLE COUNTERSINK. MAJOR REPAIR ACCOMPLISHED. REPLACED PANEL.SDR 2003UALA00723Floorbeam · corrodedCABIN FLOORBEAM AT STA 294.4 HAS CORROSION FROM RBL 24 TO RBL45. MAJOR REPAIR ACCOMPLISHED, INSTALLED REPLACEMENT WITH ANGLE SPLICE.SDR 2003UALA00730Skin · dentedTHREE DENTS IN FUSELAGE SKIN ABOUT 24 INCHES AFT OF DOOR 2R, JUST FWD OF APU INLET. MAJOR REPAIR ACCOMPLISHED, INSTALLED REPLACEMENT PANEL.SDR 2003UALA00720Frame · corrodedSTA 805 FUSE FRAME HAS CORROSION ON THE AFT SIDE, JUST ABOVE AND FWD OF THE CARGO DOOR THRESHOLD. MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIR.SDR 2003UALA00717Door Frame · damagedFWD LOWER FRAME OF THE FWD RT DOOR CUT-OUT HAS A PIECE MISSING. MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIR.SDR 2003UALA00715Floorbeam · gougedCABIN FLOORBEAM IS GOUGED AT STA 360 AND BL 0. MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIR.SDR 2003UALA00714Floorbeam · crackedCABIN FLOORBEAM IS CRACKED IN THE RADIUS AT STA 927 RBL 45. MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIR.SDR 2002UALA00447Coffeemaker · malfunctionedUNSCHEDULED LANDING DUE TO BURNING ODOR. FORWARD COFFEEMAKER HEATING ELEMENT MALFUNCTIONED. REPLACED COFFEEMAKER. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE WITHOUT FURTHER INCIDENT.SDR 97UAL900260Light · inoperativeEMERGENCY EXIT LIGHTS, FLOOR LIGHT DAMAGED AT 7B LIGHT ASSEMBLY RAISED OFF FLOOR. SECURED TRACK, OPS CHECK GOOD.
Back to N369UA, cancelled Apr 5, 2011