N338UA, cancelled Jun 27, 2013
Service difficulty reports · 65
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 = 'N338UA' AND deregistration_id = 'N338UA-2013-06-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 = 'N338UA' AND deregistration_id = 'N338UA-2013-06-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 2008UALA06009Door Frame · crackedFWD RIGHT GALLEY DOOR OPENING CRACKED AT AFT LOWER CORNER. INSTALLED DOUBLER REPAIR AT AFT LWR CORNER OF FWD RT GALLEY DOOR OPENING.SDR 2008UALA05428Feeder Cable · damagedAFT GALLEY EEL STRIP INOP. FOUND FEEDER CABLE DAMAGED. REPAIRED FEEDER CABLE. AC OK FOR SERVICE.
SDR 2008UALA05427Lamp · inoperativeEMERGENCY LIGHT LAMP INOP ROW 12. REPLACED LAMP.SDR 2008UALA05426Lamp · inoperativeEMERGENCY LIGHT LAMP INOP ROW 11. REPLACED EMERGENCY LIGHT LAMP.SDR 2008UALA03928Lamp · inoperativeFLOOR EEL INOP FROM ROW 16 TO AFT OF AIRCRAFT. FOUND LIGHT STRIP FAULTY. REPLACED LAMP STRIP OP CHECK GOOD. AC OK FOR SERVICE.SDR 2008UALA03852Compressor · damagedNR 2 COMPRESSOR STALL. RTFL. TWO LPT 4TH STAGE BLADES WERE FOUND TO HAVE FRACTURE ABOUT .5 INCHES FROM BLADE PLATFORM. CHANGED ENGINE.
SDR 2008UALA03439Engine · making metalENGINE 2 COMPRESSOR STALL ON TAKEOFF 95 PERCENT N1 TARGET, SERIES OF LOUD BANGS, ASSOCIATED YAW, EGT THRU 725 DEGS. RETARDED THROTTLES. THE ACFT BEHIND REPORTED FLAMES FROM ENGINE EXHAUST. FOUND METAL FOUND IN TAILPIPE. CHANGED ENGINES.SDR 2008UALA03381Light · burned outDOOR 2R EXTERIOR EMERGENCY ESCAPE SLIDE LIGHT INOP. FOUND LIGHT BURNED OUT AND FUSE BLOWN. REPLACED LIGHT ASSEMBLY AND FUSE OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA02688Slide · faultyDOOR 1R GIRT BAR NOT SECURING PROPERLY. SUSPECT FAULTY DOOR SLIDE ASSEMBLY. REPLACED DOOR SLIDE ASSEMBLY IAW MM 25-61-35. AC OK FOR SERVICE.SDR 2008UALA02189Light · inoperativeEEL LIGHTING IS INOP FROM ROW 15, AFT. REPLACED LIGHT OPS CHECKED OK. AC OK FOR SERVICE.SDR UALA2008111300446Accessory Unit · malfunctionedLANDED UNDER AMBER ALERT DUE TO A TRIM PROBLEM. EXTENSIVE TROUBLESHOOTING PERFORMED. FOUND FAULTY AUTOPILOT ACCESSORY UNIT. REPLACED THE AUTOPILOT ACCESSORY UNIT.SDR 2008UALA00446Trim System · unknownLANDED UNDER AMBER ALERT DUE TO A TRIM PROBLEM. RESUBMITTED. UNKNOWN PART INFO.SDR 2008UALA00106Outflow Valve · malfunctionedCREW REPORTS DURING SINGLE PACK OPERATION, THE A/C FAILED TO MAINTAIN PRESSURIZATION DURING THE APPROACH. AIRCRAFT HAS CHRONIC PRESSURIZATION ISSUE. REPLACED REAR OUTFLOW VALVE. REPLACED FIRST OFFICER'S ALTIMETER, REPAIRED MISCELLANEOUS FUSELAGE DRAINS, REPSDR 2007UALA05017Light · buckledFOUND EMERGENCY LIGHTS AT ROW 6 BUCKLED. STRAIGHTENED LIGHT AT ROW 6.SDR 2007UALA05016Light · inoperativeAFT SECTION EMERGENCY FLOOR LIGHTS INOPERATIVE. REPLACED POWER STRIP.
SDR 2007UALA02813Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT CHEM-MILLED STEP, AT STR 10R, FROM STA 890-892. FABRICATED AND INSTALLED EXTERNAL DOUBLER-FILLER REPAIR PER MM 53-31-96 FIGURE 602.SDR 2007UALA02068Slat System · slowNR 2 L/E SLAT SLOW TO EXTEND. LAGS NR 1 & 3 L/E SLATS IN EXTEND AND RETRACT. [07-06-07] FOUND FAULTY NR 2 ACTUATOR. REPLACED NR 2 ACTUATOR. FOUND WORN SEALS. REPLACED SEALS.SDR 2007UALA00726Lamp · inoperativeLEFT AFT OVERWING EMERGENCY EXIT LIGHT ON EXTERIOR OF ACFT INOPERATIVE. RELAMPED.SDR 2006UALA01483Light · malfunctionedAFT EMERGENCY LIGHT SCAM ON AFTER T/O. RECYCLED F/A SWITCH AND LIGHT TURNED OFF BUT CAME BACK ON. REPLACED BATTERY PACK CHARGER AND REPAIRED EEL LIGHTING STRIP AT AFT GALLEY CART LOCATION.SDR 2006UALA00279Skin · gougedFUSELAGE SKIN GOUGED AT STA 362, STR 17L. *S/D* TRIPLER REPAIR WITH RE-INFORCING STRINGER REPAIR ACP'D.SDR 2006UALA00277Stringer · crackedSTRINGER 10L UPPER FLANGE CRACKED AT STA 297. *S/D* INSTALLED STRAP AND STRINGER CLIP REPAIR PER EA I060076-IR & EVA-60082.SDR 2006UALA00278Skin · crackedLEFT HORIZONTAL STAB LWR SURFACE CRACKED, AFT SIDE JUST FWD OF ELEV STA 98. LT HORIZONTAL STAB LOWER SURFACE FOUND CRACKED. NEW SKIN SECTION WAS SPLICED IN BETWEEN STATIONS 105.7 AND 180. REFERENCE AAR EO 1060094 AND APPROVED WITH AN 8100-9 FORM.SDR 2006UALA00267Door Frame · crackedFWD CARGO DOOR BS 1618 CRACK AT INBD RADIUS AT AFT LOWER FRAME. *S/D* DAMAGE REMOVED, INSTALLED NEW FRAME PER SRM 51-40-02. ACCOMPLISHED ON BASE WRITE UP, 10991-8100-0013. NO FURTHER FINDINGS, OK FOR SERVICE.SDR 2006UALA00260Skin · dentedRIGHT HORIZONTAL STABILZER HAS DENT APPROX 4 FT OUTBOARD ON LEADING EDGE. DENT MEASURES 2"L X 1.25W X .125D. RIGHT HORIZONTAL STABILIZER LEADING EDGE SKIN REPLACED TO ADDRESS DENT.SDR 2006UALA00253Stringer · misdrilledSTR 20L STA 907 HAS MISDRILLED HOLE IN UPPER FLANGE OF STRINGER. REMOVED DAMAGE SECTION ACCOMPLISHED REPAIR PER SRM 53-00-03. INSTALLED A SPLICE.SDR 2006UALA00252Fastener · misinstalledSTRINGER CLIP AT STA 867 STRINGER 20R INSTALLED WITH LOCK FASTENER THAT FAIL MAXIMUM PROTRUSION TEST ON GO-NO GO GAGE. REMOVED & INSTALLED NEW STRINGER CLIP & FASTENERS REF 51-40-02.SDR 2006UALA00251Skin · dentedAFT FUSELAGE STA 1050 S25R IN JACK SCREW COMPARTMENT HAS DENT. DAMAGE REMOVED AND STR 25R REPAIRED REF SRM 53-00-03 REPAIR 1.SDR 2006UALA00242Bulkhead · damagedAFT CARGO PIT FWD BULKHEAD STA 727 STRINGER 27R FWD ATTACHMENT FASTENERS 3RD AND 4TH FROM BOTTOM ARE WORKING. INSTALLED NEW STA 727 BULKHEAD FITTING AT STR 27R REF SRM 51-40-02.SDR 2006UALA00241Attach Angle · crackedAFT PIT BILGE STA 727 STR 27L ATTACH ANGLE COMMON TO BULKHEAD IS CRACKED AT 4TH FASTENER FROM BOTTOM OF ANGLE. INSTALLED NEW STA 727 BULKHEAD FITTING AT STR 27L REF SRM 51-40-02.SDR 2006UALA00234Attach Fitting · crackedTHE RIGHT MLG BEAM O/B ATTACH FITTING WAS FOUND CRACKED AT HOLE D. RIGHT MAIN LANDING GEAR SUPPORT BEAM FITTING REPLACED PER JIC 4S127. RELATED TO AD 2005-18-08. COA 930022 SIGNED OFF TO RECORD TERMINATING ACTION FOR AD.SDR 2006UALA00211Stringer · dentedAFT CARGO PIT STA 907 STR 24L, STR AND STR SPLICE DENTED AT HOLES FROM FASTENER REMOVAL. MAJOR REPAIR ACP'D, HAT CHANNEL DOUBLER REPAIR ACP'D PER SRM 53-00-03 PG 201.SDR 2006UALA00210Crease Beam · corrodedFWD RIGHT ENTRY DOOR CREASE BEAM HAS SEVERAL AREAS OF CORROSION STA 294 TO 336, RBL 70, WL 208. NEW CREASE BEAM INSTALLED PER SRM 51-40-02.SDR 2006UALA00209Stringer · damagedSTR 20R DAMAGED AT STA 727A. REPAIRED STRINGER REF SRM 53-60-03 REPAIR 1.SDR 2006UALA00198Angle · crackedAFT RIGHT FUSELAGE, BS 1142, CUTOUT FOR HORIZONTAL STAB AFT SPAR ATTACH FITTINGS, UPPER-INSIDE CHORD ANGLE, CRACK, 2 INCH -3 INCH LONG. *S/D* REPAIRED CHORD ANGLE REF MM 53-10-93.SDR 2006UALA00197Bulkhead · crackedFWD SIDE OF 1016 BULKHEAD FOUND 3 EACH CRACKS AT FASTENERS IN WEB ABOVE STIFFENER 7L RIVETS 7, 8, AND 9. *S/D* REMOVED DAMAGE INSTALLED FILLER, DOUBLER, TRIPLER SEALED EDGES, & DINOLED REF SRM 53-80-08.SDR 2006UALA00181Angle · crackedAFT LEFT FUSELAGE BS 1142, CUTOUT FOR HORIZ STAB AFT SPAR FITTINGS, UPPER-INSIDE CHORD ANGLE, CRACK APPROX 2.5 INCHES LONG. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLE REF SRM 51-70-11.SDR 2006UALA00180Skin · crackedAFT GALLEY DOOR LOWER HINGE CUTOUT, SKIN CRACKED IN FWD RADIUS BY SPRING LOADED DOOR. REPAIRED CRACK AT AFT GALLEY DOOR LOWER HINGE CUTOUT REF SRM 53-60-01 REPAIR 7.SDR 2006UALA00176Lap Joint · crackedSKIN LAP AT STR 10L STA 421 TO STA 429 IS CRACKED AT CHEM MILLED STEP. PER JC REPAIR PER MM 53-31-96 OR SRM 53-00-01 FIG 229 IF WITHIN SRM LIMITATIONS. FASTENERS AND DAMAGE REMOVED, NDT FOR CRACKS. INSURANCE CUT MADE & DEBURRED. REPAIR DOUBLERS MADE & AREASDR 2005UALA01516Light · inoperativeEMERGENCY FLOOR LIGHTING INOP AT ROW 17 AFT.SDR 2005UALA00457Light · shortedEMERGENCY EXIT FLOOR LIGHTS BEYOND ROW 15 INOP. LIGHT STRIP SHORTED, REPLACED.SDR 2006UALA00125Rivet · crackedCRACKED RIVETS. REPLACED RIVETS REF SRM 51-40-02 & 53-00-01.SDR 2004UALA00140Circuit Card · failedUNABLE TO RAISE THE LANDING GEAR AFTER TAKEOFF. REPLACED MAIN GEAR LOGIC CARD M991.SDR LI32003F00001Manifold · brokenFUEL LEAK APU AUTO SHUTDOWN. APU DEFERRED. C/B PULLED. FOUND LEAK AT FUEL HEATER. HEATER NOT LEAKING. MAIN FUEL MANIFOLD CRACKED AT 11:00 O`CLOCK POSITION AT FUEL NOZZLE (INJECTOR) MANIFOLD HAS 14 FUEL TUBES. ONE HAS A BROKEN TUBE BETWEEN THE FLEXIBLE FSDR 2002UALA00092Frame · crackedFRAME 188 AT WL 207 STRINGER 17L HAS CRACK. MAJOR REPAIR ACCOMPLISHED. INSTALLED FRAME REPAIR DOUBLER AND INSTALLED EXTERNAL FUSELAGE DOUBLER.SDR 2002UALA00081Pressure Panel · crackedLEFT WHEEL WELL UPPER BULKHEAD CRACKED AT LBL 31 STATION 663.75 + 2. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. INSTALLED DOUBLER REPAIR.SDR 2002UALA00038Crease Beam · corrodedSTATION 312-360, WL 208, LBL 56 INBOARD CHORD ON CREASE BEAM HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. CHORD REPLACED.SDR 2002UALA00037Frame · crackedCABIN BODY STUB FRAME OUTER FLANGE IS CRACKED AT BODY STATION 296 STRINGER 8R. MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME STUB.SDR 2002UALA00016Frame · crackedCABIN BODY FRAME WEB IS CRACKED AT PSU SUPPORT BRACKET FASTENER BODY STATION 380, STRINGER 8L - 9L. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED FRAME REPAIR.SDR 2001UALA02487Skin · dentedFUSELAGE SKIN DENTED AT STATION 1005 AFT OF DOOR 2L BETWEEN STRINGER 12L AND 13L. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2001UALA02485Floorbeam · corrodedSTATION 1006, WL 208 LBL 26, FLOORBEAM MATERIAL LOSS AFTER CORROSION REMOVAL EXCEEDS LIMITS. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED FLOORBEAM REPAIR.
Back to N338UA, cancelled Jun 27, 2013