N278WA, cancelled Apr 17, 2013
Service difficulty reports · 81
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 = 'N278WA' AND deregistration_id = 'N278WA-2013-04-17' 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 = 'N278WA' AND deregistration_id = 'N278WA-2013-04-17' 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 WRLA20111212527Oven · malfunctionedGALLEY BUS 3 OFF ALERT CAME ON WHEN F/A STARTED OVENS IN AFT GALLEY. SUSPECT OVENS 1 AND 2. F/A HEARD A POP SOUND AND SAW SPARKS FROM OVEN. SHUT OVENS 1 AND 2 OFF AND RESET GALLEY BUS 3.SDR WRLA20110615492Fire Loop · failedLEVEL 3 FIRE WARNING, NR 3 ENG INTERMITTENT ON CLIMBOUT. ON/OFF SEVERAL TIMES, FOLLOWED BY LEVEL 1 ENG 3 FIRE DET FAIL. SECOND ALERT WAS INTERMITTENT FOR 20 MINS. BOTH WERE OFF IN CRUISE. ISSUED DMI PER MEL 26-11-01-01 CAT C LOOP "B" FAIL DM: M26JU1111-76SDR WRLA20101225457Battery · dischargedDURING CREW PREFLT EMERGENCY LIGHT BATT TEST FAILED NR 1 BATT. MX HAS CHANGED THE BATTERY WITH NO HELP.SDR WRLA20100830444Fan · seizedSMOKE IN CABIN, NR 1 RECIRCULATION FAN HAD SEIZED UP.SDR WRLA20100613381Frame · crackedCRACK - FOUND FRAME AFT WASTE TANK COMPARTMENT BILGE AREA AT STA Y=1986 L50R TO LS'OL CRACKED, NRC U05046 ISSUED.SDR WRLA20100609382Frame · corrodedCORROSION - FRAME AND FLOOR STRUT AFT WASTE TANK COMPARTMENT BILGE AREA AT STA 1981, X=-3, NRC U05041 ISSUED.SDR WRLA20100609380Stiffener · crackedCRACK - FOUND STIFFENER, AFT CARGO COMPARTMENT BILGE AREA, AT STA 1840, X=-20, NRC U05042 ISSUED.SDR WRLA20100609374Rib · crackedCRACK - THE LWR RIB AT THE RIGHT WING FIXED L/E CAVITY XOS 1025.5, NRC U05038 ISSUED.SDR WRLA20100608372Seat Track · corrodedCORROSION - FOUND M/D SEAT TRACK P/N ACA7101-510 CORROSION AT Y=1239-1321 X=-72.25, NRC U05043 ISSUED. REPAIRED THE CORROSION SEAT TRACK IAW SRM 53-00-52 REPAIR 1 REV 43. CONDITION CHECK, SATISFACTORY.SDR WRLA20100608371Seat Track · corrodedCORROSION - Y=1850-1856 X=-72.25, CABIN SEAT TRACK CORRODED NRC U05019 ISSUED. REPAIRED THE CORROSION SEAT TRACK IAW SRM 53-00-52 REPAIR 1 REV 43, CHECK CONDITION SATISFACTORY.SDR WRLA20100608370Seat Track · corrodedCORROSION - FOUND M/D SEAT TRACK P/N AFA7795-507 CORROSION AT Y=1831 X=-8.5, NRC U05035 ISSUED. REPAIRED THE CORROSION SEAT TRACK IAW SRM 53-000-52 REPAIR 1 REV 43. CONDITION CHECK, SATISFACTORY.SDR WRLA20100608369Seat Track · corrodedCORROSION - FOUND M/D SEAT TRACK P/N AFA7795-510 CORROSION AT Y=1833 X=-27.5, NRC U05036 ISSUED. REPAIRED THE CORROSION SEAT TRACK IAW MD-11 SRM 53-00-52 REPAIR 1 REV 43. CONDITION CHECK, SATISFACTORY.SDR WRLA20100608368Seat Track · corrodedCORROSION - FOUND M/D SEAT TRACK P/N AFA7795-509 CORROSION AT Y=1826 X=27.50, NRC U05044 ISSUED. REPAIRED THE CORROSION SEAT TRACK IAW MD-11 SRM 53-00-52 REPAIR 1 REV 43. COND CHECK NORMAL AND JOB COMPLETED.SDR WRLA20100608367Rib · crackedCRACKED - FOUND RIGHT WING INBOARD RIB OF L/E SLAT TRACK 16, NRC U05045 ISSUED.SDR WRLA20100608366Angle · crackedCRACK - TAIL DIVERTER INSIDE PNL 364RF AT STA 2060 1 EA ANGLE CRACKED. NRC U05040 ISSUED.SDR WRLA20100608365Support Beam · corrodedCORROSION - FOUND M/D FLOOR SUPPORT BEAM CORROSION AT Y=1821-1887 X=35.8, NRC U05037 ISSUED. REMOVED AND REPLACED THE SUPPORT BEAM IAW SRM 51-31-01 REV43, FABRICATE A NEW PART IAW EI NR W2010P53B-1228 REV00, INSTALLED NEW SUPPORT BEAM IAW SRM 51-31-01 REV 43 SDR WRLA20100607383Torque Box · crackedCRACK - FOUND TAIL AFT BODY SECTION UPPER TORQUE BOX WEB CRACK AT Y=2015, X=-15, NRC U05023 ISSUED.SDR WRLA20100607379Rib · crackedCRACK - FOUND NR 1 PYLON 437 CENTER PANEL INSIDE FWD LT SIDE RIB ANGLE CRACK, NRC U05018 ISSUED.SDR WRLA20100607378Doubler · crackedCRACK - THE DOUBLER OF THE FORMER AT XOS 667 FIXED L/E CAVITY RIGHT WING, NRC U05025 ISSUED.SDR WRLA20100607377Stiffener · crackedCRACK ZEE STIFFENERS OF FIXED L/E UPPER PNL 616ET, RIGHT WING QTY 3 EA, NRC U05024 ISSUED.SDR WRLA20100607375Web · crackedCRACK - WEB OBSERVER SEAT STA 360 X=-10 OVERHEAD OF AVIONICS COMPT, NRC U05031 ISSUED.SDR WRLA20100607359Support Beam · corrodedCORROSION - Y=1821-1887 X=-35.8, CABIN SUPPORT BEAM P/N S492249012000 CORROSION, NRC U05020 ISSUED. REMOVED THE SUPPORT BEAM IAW SRM 51-31-01 REV43. FABRICATE A NEW PART IAW EI NR W2010P53B-1192 REV00, INSTALLED NEW SUPPORT BEAM IAW 51-31-01 REV 43 CONDITIONSDR WRLA20100606376Stringer · crackedCRACK - LOWER STRINGER DOUBLE OF FIXED L/E NOSE XOS 605 RT WING, NRC U05027 ISSUED.SDR WRLA20100606358Door Frame · crackedCRACK - FOUND LT MAIN LANDING GEAR DOOR JAMB (Y=1479 X=-100), TEE P/N ANB7203-151 CRACKED, NRC U05003 ISSUED.SDR WRLA20100605360Doubler · crackedCRACK - FOUND CENTER LANDING GEAR WHEEL WELL RT WALL FWD LOWER CORNER DOUBLER AEA0526-2 CRACKED, NRC U05001 ISSUED.SDR WRLA2009061Skin · dentedDURING A-2 CHECK IN ATL INSPECTION FOUND C-2 CARGO DOOR CUTOUT AFT SKIN HAS VERTICAL DENT 22 INCHES LONG AT STA 1781 STR 40-42. DAMAGED SKIN CUT OUT AND REPAIRED IAW ERA 473349-14 AND PRI REV 4 WORLD ERA 09-53-362. APPROVAL ON FAR FORM 8100.SDR WRLA2008064Actuator · odorFLT 1000 (KIAH/FNLU) ITEM: DURING FLIGHT, SMOKE/FUMES IN CABIN IN VICINITY OF ROW 16 & 17. MAINTENANCE FOUND LARGEST ACTUATOR AT SEAT 18G AS SOURCE OF ELECTRICAL ODOR. DEACTIVATED CONTROL BOX FOR SEATS 18 D&G BY STOWING CONNECTORS AND PULLED C/B. REMOVED ASDR WRLA2007127Support Beam · corrodedDURING C-CHECK INSPECTION CORROSION FOUND RT WING TO BODY FAIRING SUPPORT BEAM AT STA Y=1348 Z=-20. REPAIRED THE RT WING TO BODY FAIRING SUPPORT BEAM AT STA Y=1348 Z-20 PER SRM VOL 1 53-00-01 FIG 9 REV 40. REF EGAT NRC U05030.SDR WRLA2007123Seat Track · corrodedDURING C-CHECK INSPECTION CORROSION FOUND RIGHT HAND SEAT TRACK STA Y=555 X=75.25. REPLACED DAMAGED SEAT TRACK PER MD11 SRM 51-33-01 VOL.II REV.40.SDR WRLA2007120Seat Track · corrodedDURING C-CHECK INSPECTION FOUND CORROSION AFT CABIN FLOOR CURVED SEAT TRACK AT STA Y=2007 X =107.25. REF EGAT NRC U05001. REPLACED THE DAMAGED AREA PER MD11 SRM 53-70-00 VOL.I FIGURE 8 REV.40. REF EGAT NRC U05028.SDR WRLA2007121Skin · corrodedDURING C-CHECK INSPECTION CORROSION FOUND ON RIGHT CENTER WING TANK UPPER SKIN AT XCW=110S1. ACCOMPLISHED ENGINEERING INSTRUCTION NO.W2007A57B-668 REV.00, REPAIR CORROSION ON CENTER WING UPPER SKIN UPPER SURFACE AT XCW=110 S1. REF EGAT NRC U05027.SDR WRLA2007128Floor Support · corrodedDURING C-CHECK INSPECTION CORROSION FOUND AFT FUSELAGE FLOOR SUPPORT AT STA Y=2007 X=-23.5. REPLACED DAMAGED SUPPORT PER MD11 SRM VOL II 51-31-01 REV 40. REF EGAT NRC U05025.SDR WRLA2007126Floor Support · corrodedDURING C-CHECK INSPECTION CORROSION FOUND ON AFT FUSELAGE FLOOR SUPPORT AT STA Y=1990 X=27.5. REPLACED DAMAGE SUPPORT PER MD11 SRM VOL.1 51-31-01 REV.40 REF EGAT NRC U05024.SDR WRLA2007125Tee Fitting · corrodedDURING C-CHECK INSPECTION, CORROSION FOUND ON BULKHEAD TEE CHORD STA Y=2007 X=27.5. REPLACED DAMAGE TEE CHORD PER MD11 SRM VOL.II 51-35-01 REV.40 REF EGAT NRC U05014.SDR WRLA2007122Floor Support · corrodedDURING C-CHECK INSPECTION FOUND CORROSION AFT FUSELAGE FLOOR SUPPORT AT STA Y=2007 X=23.5. REPLACED DAMAGED FLOOR SUPPORT PER SRM 51-31-01.SDR WRLA2007119Skin · crackedDURING C CHECK INSPECTION FOUND CRACK IN RIGHT HAND NR 3 AIR CONDITION COMPARTMENT DOOR OUTER UPPER SKIN L=4". REF EGAT NRC U05001. REPAIRED RIGHT NR 3 AIR CONDITION COMPARTMENT DOOR OUTER UPPER SKIN PER MD-11 SRM VOL 1 52-10-00 FIG 1 REV 40.SDR WRLA2007104Unknown · odorFLT 1001 FNLU/KIAH. DURING CRUISE FLT 9+20HRS AFTER DEPART ELEC ODOR EMANATING NEAR INSTRUMENT PANEL. NO SMOKE WAS OBSERVED. SOURCE OF ODOR UNKNOWN. ELEC ODOR DISSIPATED OVER TIME. SEL ANNUNCIATOR LIGHT TEST IND MASTER WARNING, MASTER CAUTION AND ABS DISASDR WRLA2007090Connector · failedFLT 100 KIAH/FNLU ELECTRICAL ODOR/SMELL EMANATING FROM SEATS 25A-C DURING CRUISE. POWER PLUG SUPPLY PULLED C/B TO AFFECTED ZONES. 10-18-07 R & R 26A-C SEAT CONTROL BOX, REPAIRED DAL NR 68 & NR 14 REF WOA WO D10106.SDR WRLA2007076Control Unit · smokeFNLU/KIAH FLT 101 05/31/07. SEAT 14G CONTROL INOPERATIVE. SMOKE AND ODOR COMING FROM SEAT WHEN SEAT ACTIVATED. ISOLATED TO POWER CONTROL UNIT. REMOVED POWER CONTROL UNIT, DEACTIVATED SEAT ELECTRICALLY AS PRECAUTIONARY MEASURE. PLACED SEAT ON DMI M25JU0107SDR WLDA200443Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER RT BARREL NUT HOLE NR 29. PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB RT BARREL NUT HOLE NR 29 SDR WLDA200484Skin · puncturedDURING 4C-CHECK, WHILE PERFORMING J/C NR WA5740 FOUND A PUNCH HOLE ON RT WING LEADING EDGE SLAT NR 3 AT STA XOS435. PERFORMED REPAIR OF RT WING LEADING EDGE SLAT NR 3 IAW EGAT EI NR W2004A53B. CONDITION CHECK SATISFACTORY.SDR WLDA200483Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 1.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 1 FOUSDR WLDA200482Panel · corrodedITEM: DURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 3.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR SDR WLDA200480Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 6.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 6 FOUNSDR WLDA200479Structure · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 13.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 13 FOUSDR WLDA200477Structure · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 15.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE 15 FOUND SDR WLDA200474Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 20.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 20 FOUSDR WLDA200473Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION PER EO 02-5510-098 REV 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LEFT BARREL NUT HOLE NR 22.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 22 FOUSDR WLDA200466Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 31.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 31 FOUSDR WLDA200464Panel · corrodedDURING 4C-CHECK, PERFORMED INSPECTION IAW EO 02-5510-098 REV NR 1, FOUND CORROSION LOCATED AT HORIZONTAL STABILIZER LT BARREL NUT HOLE NR 33.PERFORMED CORROSION REPAIR IAW EO 02-5510-098 REV NR 1. CONDITION CHECK OF HORIZONTAL STAB LT BARREL NUT HOLE NR 33 FO
Back to N278WA, cancelled Apr 17, 2013