N318UA, cancelled Sep 7, 2012
Service difficulty reports · 52
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 = 'N318UA' AND deregistration_id = 'N318UA-2012-09-07' 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 = 'N318UA' AND deregistration_id = 'N318UA-2012-09-07' 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 UALA2009060401605Battery Pack · dischargedEMERGENCY LIGHT WHITE ON STOW BIN SEAT 21DEF INOP. REPLACED AFT CENTER RIGHT CEILING EMERGENCY BATTERY PACK. GROUND TEST OK.SDR UALA2009060401604Battery Pack · dischargedEMERGENCY LIGHT WHITE ON STOW BIN SEAT 20ABC INOP. REPLACED CENTER RIGHT CEILING EMERGENCY LIGHT BATTERY PACK. GROUND TEST OK.SDR UALA2009060401603Battery Pack · dischargedAFT RIGHT DOOR 2 EMERGENCY EXIT LIGHT INOP. REPLACED AFT CENTER RIGHT CEILING EMER BATTERY PACK. EMERGENCY LIGHT GROUND TEST OKAY.SDR UALA2009060401602Battery Pack · dischargedEMERGENCY LIGHT EXTERNAL RIGHT DOOR 2 INOP. REPLACED AFT CENTER RIGHT CEILING EMER BATTERY PACK. EMERGENCY LIGHT GROUND TEST OKAY.SDR UALA2009051901416Slide · looseMATERIAL HANGING DOWN FROM DOOR 1L SLIDE PACK. SLIDE WAS REMOVED TO REPACK GIRT INSTALLATION. SLIDE WAS PLACED ON FLOOR TO POSITION GIRT ON TO HOOK AND LOOP. PIN VERIFIED NOT INSTALLED AND CORRECT HARDWARE FOR MOUNTING PER IPC.SDR UALA2009051801407Slide · out of positionSLIDE PACK DOOR 1L FELL OUT BUT DID NOT DEPLOY. CHECKED SLIDE AND FOUND NOT DAMAGED. REINSTALLED SLIDE.SDR UALA2009010200016Light · inoperativeEEL BULLNOSE LIGHT INOP AT 7DEF. RELAMPED, CHECKS OK.SDR 2008UALA05699Switch · defectiveFOUND EMERGENCY LIGHT TOGGLE SWITCH ON P5 PANEL TO BE DEFECTIVE, MISSING PLUNGER FOR MICRO SWITCH IN CIRCUIT FOR NOT ARMED LIGHT WITH SWITCH IN OFF POSITION. INSTALLED NEW SWITCH ON THE P5 PANEL.SDR 2008UALA04254Slide · unsecureDOOR 1L SLIDE IS FALLING OUT. SUSPECT SLIDE IMPROPERLY INSTALLED. REINSTALLED SLIDE IAW MM 25-61-35 PG 201. AC OK FOR SERVICE.SDR UALA2008111303278Control Panel · damagedCOFFEE SPILLED ON CENTER CONSOLE IN COCKPIT. FLUID GOT ONTO CARGO FIRE SUPPRESSION PANEL ONLY AND DOES NOT TEST. BOTH CARGO FIRE BOTTLES ARE BLOWN. REPLACED CONTROL PANEL, NO HELP. REPLACED BOTH CARGO PIT FIRE SUPPRESSION BOTTLES, DIVERTER VALVE, METERING SDR 2008UALA03278Panel · contaminatedCOFFEE SPILLED ON CENTER CONSOLE IN COCKPIT. FLUID GOT ONTO CARGO FIRE SUPPRESSION PANEL ONLY AND DOES NOT TEST. BOTH CARGO FIRE BOTTLES ARE BLOWN.SDR 2008UALA03115Flap · malfunctionedFLAP RETRACT PROBLEM CAUSED DIVERSION. UNABLE TO DUPLICATE. ADJUSTED CABLE TENSION AND SERVICED NR 7 FLAP TRANSMISSION.SDR 2008UALA03139Skin · dentedFUSELAGE SECTION 46 SKIN DENT AT AFT DOOR 2L. MAJOR REPAIR ACCOMPLISHED. REF EVA 71590 B, FUSELAGE SKIN AND STRINGER REPAIR BETWEEN BS 996 AND BS 1016, S10L TO S16 HAS RECEIVED FIRST STAGE APPROVAL FOR STATIC STRENGTH ONLY, AND IS TIME LIMITED UNTIL 5-30-200SDR 2008UALA03068Skin · damagedFUSELAGE SKIN KINKED JUST BELOW STR 14L LAP JOINT, AFT OF STA 992. MAJOR REPAIR ACCOMPLISHED, REPLACED FUSELAGE SKIN.SDR 2008UALA02946Skin · crackedFUSELAGE SKIN CRACKED AT STR 12 RIGHT, STA 520. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2008UALA01973Smoke Detector · false activationFWD LAVATORY SMOKE DETECTOR WARNING, UNEXPLAINED. REPLACED SMOKE DETECTOR.
SDR 2008UALA01819Shear Tie · crackedSTA 360 FRAME ANGLE ATTACHED TO FUSELAGE SKIN CRACKED, BETWEEN STR 14L AND 15L. MAJOR REPAIR ACCOMPLISHED.SDR 2008UALA01818Stringer · crackedFWD ENTRY DOORWAY STR 15L, STRINGER CHANNEL CRACKED AT STA 360, AFT SIDE OF THE FRAME. MAJOR REPAIR ACCOMPLISHED.SDR 2008UALA01817Support · crackedINTERCOSTAL WEB SUPPORT CLIP, C-T FUSELAGE SKIN, BETWEEN STA 348.2 TO 360 CRACKED AT STR 14L. MAJOR REPAIR ACCOMPLISHED.SDR 2008UALA00101Stowage Box · crackedFIRST OFFICERS O2 MASK STORAGE BOX CRACKED ON LT DOOR. SUSPECT BROKEN DUE TO PRE FLIGHT CHECKS. REPLACED F-O O2 MASK STORAGE BOX. AC OK FOR SERVICE.SDR 2007UALA03053Torque Link · damagedNOSE WHEEL SHIMMY AT TAXI SPEEDS, NORMAL AT HIGH SPEEDS. NOSE WHEEL TORQUE LINKS WORN BEYOND LIMITS CAUSING LOW SPEED SHIMMY. REPLACED BOTH NOSE LANDING TORSION LINKS, PERFORMED TAXI TEST,SDR 2007UALA02127Module · faultyNR 2 ENGINE FIRE LIGHT DOES NOT ILLUMINATE DURING FIRE TEST. [07-13-07] REPLACED FIRE DETECTION CONTROL MODULE.SDR 2007UALA01421Lamp · inoperativeEMERGENCY LIGHT AT RIGHT LOWER AFT FUSELAGE IS OUT. RELAMPED EMERGENCY LIGHT.SDR 2007UALA00493Slide · unsecureFOUND DOOR 2R: SLIDE PACK FALLING OUT. REPACKED SLIDE.SDR 2006UALA02376Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED AT AFT SIDE OF FRAME IN THE RADIOUS JUST ABOVE LOWER STOP FITTING. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED ANGLE REPAIR PER AAR EA I060544 REV IR AND UA EVA 60754.SDR 2006UALA01466Skin · crackedNR 5 SLAT LOWER SKIN APPEARS TO HAVE MULTIPLE CRACKS IN LOWER SKIN INBD OF ACTUATOR ATTACHMENT. REMOVED DAMAGE. FABRICATED AND INSTALLED FILLER DOUBLER REPAIR.SDR 2006UALA00134Light · inoperativeEEL LIGHTS AT BACK OF CABIN INOP.SDR 2005UALA01207Light · burned outEMERGENCY AISLE LIGHT INOP AT ROW 21. RELAMPED WITH NR 1317 LAMP.SDR 2005UALA00851Warning Light · illuminatedFLT SHOWED LE FLAPS IN TRANSIT LIGHT. AMBER ALERT CALLED IN. A FAILED LEADING EDGE (LE) FLAP AND SLAT CONTROL VALVE INHIBITED FULL EXTENTION OF THE LE FLAPS AND SLATS. SUBJECT FAILURE CONSIDERED AN ISOLATED INCIDENTCORRECTIVE ACTION: REPLACED AND TESTED SUBSDR 2005UALA00850Light · inoperativeLEFT AND RIGHT EMERGENCY EXIT LIGHTS INOP (EXTERIOR). REPLACED LIGHT ASSEMBLY.SDR 2005UALA00611Frame · chafedSTA 211 FRAME WEB WAS CHAFED BEYOND LIMITS BETWEEN STR 15R AND 16R, FRAME WAS ALSO GOUGED BEYOND LIMITS. SPLICED IN NEW SECTION OF WEB REF SRM 51-70-13 FIG 1 AND SPLICED IN NEW FRAME FROM STR 15R TO 17R REF SRM 51-70-12.SDR 2005UALA00586Bear Strap · crackedAFT CARGO DOOR CUTOUT AFT SIDE HAS BEAR STRAP REPAIR THAT WAS REMOVED WHEN ACCOMPLISHED SKIN REPLACEMENT. INSTALLED DOUBLER-TRIPLER REPAIR PER SRM 53-00-01 FIG 230.SDR 2004UALA01164Proximity Sensor · malfunctionedRETURNED TO DEN, DUE TO A GEAR IN TRANSIT LIGHT PROBLEM. INDICATION WAS CAUSED BY FAULTY GEAR DOWN LOCK PROXIMITY SWITCH. REPLACED GEAR DOWN LOCK SWITCH. PERFORMED OPERATIONAL AND FUNCTIONAL CHECK OF THE SYSTEM. GEAR OPEARTION AND INDICATION FOUND NORMAL.SDR 2004UALA01172Cylinder · damagedSQUIB FIRED A HOLE STRAIGHT THROUGH THE CYLINDER. FIRE EXTINGUISHER BOTTLE AND CARTRIDGE WERE SUBJECTED TO AN ABNORMALLY HIGH AMBIENT TEMP, NOT CONSISTENT WITH THE DESIGN PARAMETERS OF BOTH UNITS, AND THEY FUNCTIONED AS EXPECTED. THE ELEVATED AMBIENT TEMPERATUSDR 2004UALA01038Duct · failedSKIN, STRINGER AND FRAME HEAT DAMAGE FROM FS 516.5 TO 540. STR 26 TO 28. SUPPLEMENTAL DATA UPDATE - MIX MUFF DUCT OF DUCT ASSEMBLY LOCATED IN MIX CHAMBER AIR DISTRIBUTION BAY AT APPROXIMATE STA 540, BL 0 BLOWN CAUSING HOT AIR TO ESCAPE AND DAMAGE THE STRUCTURSDR 2004UALA01014Duct · leakingFUSELAGE SKIN LOCATED DIRECTLY BELOW DUCT ASSY SHOWS SIGNS OF PEELED PAINT DUE TO MIX CHAMBER DUCT ASSY HOT AIR LEAK. MIX MUFF DUCT OF DUCT ASSEMBLY LOCATED IN MIX CHAMBER AIR DISTRIBUTION BAY AT APPROXIMATE STA 540, BL 0 BLOWN CAUSING HOT AIR TO ESCAPE AND DSDR 2003UALA00764Battery Pack · inoperativeSECTION OF EEL LIGHTS INOP FROM SEATS 3ABC TO 9ABC. REPLACED BATTERY PACK AND INVERTER.SDR 2003UALA00119Actuator · inoperativeAIRCRAFT RETURNED TO FIELD WHEN FLIGHT CREW WAS UNABLE TO RETRACT THE FLAPS. REPLACED NR 2 LE FLAP ACTUATOR.SDR 2002UALA00906Control Panel · faultyCREW REPORTED GETTING A CARGO PANEL FIRE LIGHT WITH NO BELLS. MAINTENANCE FOUND FIRE DETECTION PANEL WOULD NOT TEST. REPLACED CARGO COMPARTMENT PANEL. PERFORMED OPERATIONAL CHECK OF THE SYSTEM AND AIRCRAFT WAS RETURNED TO SERVICE.SDR 2001UALA01059Frame · crackedFRAME CRACKED. STA 181, WL 183 AT INSULATION SPIKE HOLE. MAJOR REPAIR ACCOMPLISHED.INSTALLED NEW WEB AND SPLICED PLATE.SDR 2001UALA01053Frame · crackedFRAME CRACKED. STA 188, WL 207, LEFT SIDE. MAJOR REPAIR ACCOMPLISHED.INSTALLED DOUBLER.SDR 2001UALA01051Skin · wornFUSELAGE SKIN THICKNESS BELOW MINIMUM LIMITS. STA 796, STR 22R-23R. MAJOR REPAIR ACCOMPLISHED.INSTALLED DOUBLER.SDR 2001UALA00987Channel · corrodedAFT PIT BILGE ANTENNA CUTOUT CORRODED STA 727 LBL 11. MAJOR REPAIR ACCOMPLISHED. REPLACED CHANNEL.SDR 2001UALA00966Frame · crackedRT FRAME CRACKED AT BS 188, WL 207. INSTALLED REPAIR ANGLES AND SKIN DOUBLER. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00965Frame · gougedFRAME WEB GOUGED AT FASTENER HOLE UNDER REMOVED STRAP AT BS 945, STR 11R. REPLACED WEB. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00964Frame · damagedAFT PIT FRAME UPPER CHORD RADIUS BLENDED BEYOND LIMITS AT BS 847. ACCOMPLISHED FRAME REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00962Stringer Clip · corrodedSTRINGER CLIP HAS CORROSION AT BS 767, STR 26R, RBL 15. REPLACED CLIP. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00893Bulkhead · gougedAFT PRESSURE BULKHEAD FWD WEB IS GOUGED AT BS 1016, WL 259, RBL 13. ACCOMPLISHED DOUBLER REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00878Bulkhead · damagedCRACK FOUND ON THE BODY STATION 178 BULKHEAD WEB. INSTALLED DOUBLER REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00866Intercostal · crackedINTERCOSTAL FWD END IS CRACKED AT BS 380, BL 0. REPLACED INTERCOSTAL. MAJOR REPAIR ACCOMPLISHED.
Back to N318UA, cancelled Sep 7, 2012