N508MC, cancelled Jun 7, 2011
Service difficulty reports · 80
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 = 'N508MC' AND deregistration_id = 'N508MC-2011-06-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 = 'N508MC' AND deregistration_id = 'N508MC-2011-06-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 WRNA20080031Skin · dentedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-100-01 FUSELAGE SKIN WAS FOUND WITH A DENT AND 1/2 INCH LONG CRACK AT STATION 515 JUST BELOW STRINGER 39R. REMOVED DAMAGE, FABRICATED FILLER AND DOUBLER, INSTALLED REPAIR IAW SRM 53-30-03 FIGURE 48.SDR WRNA20080030Skin · damagedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-100-01 LEVEL LL CORROSION WAS NOTED AT BUTT SPLICE, STATION 1960 STRINGER 47R - 51R. REMOVED 11 3/4 INCH BY 2 INCH SECTION OF SKIN CORRODED OUT OF LIMIT IAW SRM 53-30-03. FABRICATED FILLER AND REPAIR DOUBLER SDR WRNA20080033Seat Track · corrodedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-210-01, LEVEL LL CORROSION WAS FOUND AT SEAT TRACK SPLICE AT STATION 778 LBL 47. INSTALLED SEAT TRACK SPLICE AND ANGLES IAW SRM 53-10-05 FIGURE 1A DETAIL LLL AND SRM 51-30-02.SDR WRNA20080032Skin · damagedDURING C CHECK, WHILE ACCOMPLISHING SSID F25-1, A CRACK WAS FOUND BY HFEC INSPECTION UNDER COUNTERSUNK HEAD AT STRINGER 14L STATION 370, CRACK EXTENDED 1/8 INCH AFT OF HOLE. REMOVED DAMAGED SECTION OF SKIN IAW SRM 53-30-03 FIG 17. FABRICATED FILLER AND DOUBLSDR WRNA20080036Frame · chafedDURING C CHECK, FRAME AT STATION 2664.19 LBL 38, WL 295 WAS FOUND CHAFED. REMOVED DAMAGE AND FABRICATED REPAIR PARTS IAW SRM 51-40-03 FIGURE 1. INSTALLED REPAIR PARTS IAW SRM 51-40-03-FIG 1.SDR WRNA20080035Seat Track · damagedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-210-01, SEAT TRACK AT STATION 1900 LBL 99 WAS FOUND DAMAGED. REMOVED DAMAGED SEAT TRACK FROM STATION 1890 - 1905 AT LBL 99. INSTALLED SEAT TRACK IAW SRM 53-10-01 FIGURE 1A.SDR WRNA20080034Seat Track · corrodedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-210-01, LEVEL II CORROSION WAS FOUND AT SEAT TRACK BETWEEN STATION 500 - 540 RBL 48. REMOVE CORRODED SEAT TRACK SECTION. INSTALLED SEAT TRACK SECTION IAW SRM 53-10-05 FIG 6 AND SRM 51-30-02.SDR WRNA20080029Skin · damagedDURING C CHECK, FOUND FUSELAGE SKIN DAMAGED AT STATION 1810 STRINGER 45R TO 46R. CUT OUT DAMAGE AND FABRICATED REPAIR FILLER AND DOUBLER IAW SRM 53-30-03 FIGURE 17. INSTALLED REPAIR IAW SRM 53-30-03 FIGURE 17.SDR WRNA200800005Rib · brokenDURING CARGO LOADING, LOADED PALLET CONTACTED AND BROKE RIB, RIGHT HAND SIDE AT STA 1760, 8 FEET ABOVE WATER LINE. ACCOMPLISHED UNPRESSURIZED FERRY FLIGHT TO OSCODA MICHIGAN FOR REPAIRS. REPAIR ACCOMPLISHED IAW B747 SRM 51-40-03 FIGURE 2. AIRCRAFT RETURNED SDR WRNA200800004Acm · activatedDURING CRUISE, NR 3 PACK SHUTDOWN, LEAVING NO OPERATIONAL PACK, (NR 1 PACK WAS ON MEL, AND NR 2 PACK IS DEACTIVATED). AIRCRAFT DIVERTED TO IAH AND MADE A SAFE LANDING. REPLACED NR 3 ACM, NOTE: ALSO REPLACED NR 1 ACM AND REMOVED FROM MEL. A/C RETURNED TO SESDR WRNA200700027Engine · unserviceableAFTER TAKEOFF, DURING CLIMB NR 1 ENGINE EXPERIENCED MULTIPLE STALLS. POWER WAS REDUCED, 160,000 POUNDS OF FUEL WERE DUMPED. AIRCRAFT RETURNED TO FIELD AND MADE A SAFE LANDING. ENGINE WAS VISUALLY AND BORESCOPE INSPECTED PER BOEING MM 72-00-00 PAGE 680Q WITHSDR WRNA200700023Flap · delaminatedDURING B-CHECK, RIGHT INBOARD FORE FLAP WAS FOUND WITH DAMAGE, A 42 INCH LONG X 19 INCH WIDE PREVIOUS REPAIR, 45 INCHS FROM OUTBOARD END, DEPARTED FORE FLAP WITH 40% MATERIAL LOSS. ACCOMPLISHED REPAIR PER 747 SRM 51-40-12.SDR WRNA200600041Housing · crackedDURING CRUISE, AT 33,400 FEET, NR 3 ENGINE OIL QUANTITY AND OIL PRESSURE DROPPED RAPIDLY TOWARDS -0- PERFORMED PRECAUTIONARY SHUTDOWN. FLIGHT CONTINUED TO DESTINATION AND MADE A SAFE LANDING. INVESTIGATION REVEALED RADIAL DRIVE LEAKING, REPLACED RADIAL DRIVESDR P5CA0601474Circuit Card · looseCREW REPORTED ON ENGINE START, NR 4 ENGINE -B- LOOP HAD INTERMITTANT WARNING. NR 4 ENGINE -A- LOOP ON MEL. RESEATED FIRE WARNING CARD, OPS NORMAL PER 26-12-00.SDR P5CA0601460Actuator · crackedCREW REPORTED DURING CRUISE, NR 1 HYDRAULIC SYSTEM LOST ABOUT 1 GALLON IN 1 HOUR. TURNED ADP OFF AND EDP TO DEPR PER CHECKLIST. FOUND LEFT CCA LEAKING. REPLACED LEFT CCA IAW AMM 27-61-08. CHECKED FOUND ALL WORKING. ADDED HYDRAULIC FLUID TO SYSTEM NR 1 IAWSDR P5CA0601458Relief Valve · failedCREW REPORTED ON CLIMB, NR 2 ENGINE NACELLE TEMP WENT TO 9.0. AFTER RETARDING THROTTLES, TEMP STABILIZED. REPLACED NR 2 ENGINE RELIEF VALVE; APPARENT SPRING FAILURE. OPS NORMAL.SDR P5CA0501416Metering Tube · leakingNR1 ENGINE FUEL LEAK AT FUEL METERING UNIT VBV ROD END TUBE. VBV ACTUATOR FUEL TUBE REPLACED AT FUEL CONTROL AND PERFORMED ENGINE RUN AND LEAK CHECK IAW MM 73-21-01.SDR P5CA0501414Coupler · defectiveFO'S HEADING, FLIGHT DIRECTOR, AND BOTH VOR FLAGS IN RMI CAME INTO VIEW WITH HEADING FLAG IN HSI. REMOVED AND REPLACED NR 2 COMPASS COUPLER IAW AMM 34-21-00.SDR P5CA0501410Rudder · out of positionCREW REPORTED LOWER RUDDER OFF TO LEFT 3 DEGREES WITH UPPER RUDDER NEUTRAL. CLEANED PLUG ON SURFACE POSITION INDICATOR, CYCLED RUDDER, ALL OPS AND INDICATIONS NORMAL IAW MM.SDR P5CA0501398Check Valve · failedAT FL 37.0 NR 3 ENGINE COMPRESSOR STALLED, ALL PARAMETERS NORMAL. OPS OK AT LOWER ALTITUDE. BORESCOPE PER MM 72-00-00 PG 680P, NO FINDINGS. FOUND 8TH STAGE CHECK VALVE FAILED. REPLACED SAME, OPS NORMAL PER 36-11-02.SDR P5CA0501373Engine · failedAFTER TAKEOFF NR 1 ENGINE FAILED. SHUT DOWN ENGINE AND JETTISON FUEL IAW CHECK LIST. AFTER SHUT DOWN OIL PRESSURE ZERO. NR 1 ENGINE REPLACED PER ENGINE CHANGE FORM 00-AA-45. RUN UP OK PER MM 71-00-00 TEST NR 3, 8 AND 9.SDR P5CA0501365Torque Tube · damagedNR 22 LEADING EDGE PANEL BROKEN. REPLACED NR 22 LEADING EDGE PANEL, 2 ROTARY ACTUATORS AND TORQUE TUBE. RIGGED AND OPS CHECK PER MM 27-81-00.SDR P5CA0501364Panel · brokenNR 22 LEADING EDGE PANEL BROKEN. REPLACED NR 22 LEADING EDGE PANEL, 2 ROTARY ACTUATORS AND TORQUE TUBE. RIGGED AND OPS CHECK PER MM 27-81-00.SDR P5CA0501363Actuator · failedNR 22 LEADING EDGE PANEL BROKEN. REPLACED NR 22 LEADING EDGE PANEL, 2 ROTARY ACTUATORS AND TORQUE TUBE. RIGGED AND OPS CHECK IAW MM 27-81-00.SDR P5CA0501350Wheel · failedCREW REPORTED HEARING TWO LOUD BANGS AFTER TAKEOFF. FOUND NR 8 TIRE BLOWN AND PANEL 193E MISSING. REPLACED NR 7 & 8 WHEEL ASSY'S.SDR P5CA0501358Structure · crackedNOSE GEAR WHEEL BOX STRUCTURE FOUND SEVERAL CRACKS AT STATION 320L BETWEEN WL 140 AND 150, AT STATION 300R BETWEEN WL 170 AND 180, AT STATION 300L AT WL 175. ACCOMPLISHED INTERIM REPAIR PER BOEING INSTRUCTIONS SEP-SIN-05-00574C AND 1-1HZQME AND FAA FORM 8100-SDR P5CA0501357Skin · chafedLEFT INBOARD ELEVATOR TOP LEADING EDGE SKIN FOUND CHAFED. ACCOMPLISHED REPAIR PER BOEING INSTRUCTIONS 1-1HR8MP AND FAA FORM 8100-9.SDR P5CA0501356Bulkhead · crackedBS 1241 LEFT SIDE CANTED BULKHEAD HAS CRACK IN WEB AREA ABOVE BULKHEAD FITTING. ACCOMPLISHED REPAIR PER BOEING INSTRUCTIONS 1-1I9Y5F AND FAA FORM 8100-9.SDR P5CA0501355Skin · crackedNR 4 PYLON INBOARD ACCESS PANEL CUTOUT AT NAC STATION 275-295 CRACKED AT EDGE. ACCOMPLISHED REPAIR PER BOEING INSTRUCTIONS 1-1HGUJB AND FAA FORM 8100-3.SDR P5CA0501354Skin · wornNR 2 PYLON INBOARD ACCESS PANEL CUTOUT AT NAC STATION 280-300 WORN AT EDGE. ACCOMPLISHED REPAIR PER BOEING INSTRUCTIONS 1-1IO8DO AND FAA FORM 8100-3.SDR P5CA0501353Skin · deformedDORSAL FIN FOUND WITH DEFECTS DEFORMED AT TOP EDGE. ACCOMPLISHED REPAIR PER BOEING INSTRUCTIONS 1-1I9VRK AND FAA FORM 8100-3.SDR P5CA0501352Stiffener · crackedNR 4R DOOR INTERNAL STIFFENER JUST FORWARD OF WINDOW CUT-OUT FOUND CRACKED. ACCOMPLISHED REPAIR PER BOEING 1-1I26OS AND FAA FORM 8100-3.SDR P5CA0501351Skin · crackedNR 2, 3 AND 4 PYLON PRECOOLER CUTOUT CRACKED AT AFT LOWER CORNER. ACCOMPLISHED REPAIR PER BOEING INSTRUCTIONS 1-1I08HV AND FAA FORM 8100-3.SDR P5CA0501337Clamp · looseON TAKEOFF GROUND ROLL & SETTING TAKEOFF THRUST AT 105.4 DEGREES. SET ROLLING APPROXIMATELY 90 KNOTS. NR 2 ENGINE FIRE LIGHT CAME ON, ABORTED TAKEOFF WITH THROTTLES BACK AT IDLE & SHUT DOWN NR 2 ENGINE. BOTH A & B LOOPS READING 8 UNITS. BRAKE TEMPS ALL GRESDR P5CA0501341Regulator Valve · malfunctionedDURING CLIMBOUT NR 1 ENGINE NACELLE LOOPS A & B WENT INTO THE RED - SET BELL OFF - ENGINE SHUT DOWN OIL PRESSURE 45 PSI. REPLACED ENGINE PRESSURE REGULATING VALVE, LEAK CHECK OK. OPS CHECKED OK DURING ENGINE HIGH POWER ASSURANCE RUN, MM 36-11-19 & MM 36-11-0SDR P5CA0501336Shutoff Valve · failedDURING CLIMBOUT, NR 1 ENGINE NACELLE LOOPS A & B WENT INTO RED, SET WARNING BELLS OFF. ENGINE SHUTDOWN. OIL PRESSURE 45 PSI. REPLACED NR 1 ENGINE HIGH PRESSURE SHUTOFF VALVE PER MM 36-11-05. LEAK CHECK OIL, OPS CHECK NORMAL ON HIGH POWER RUN UP PER MM 71-0SDR P5CAO501312Engine · stalledDURING CRUISE AT FL 310, NR 3 ENGINE COMPRESSOR STALLED, EGT WENT TO 500 DEGREES, N1 50 PERCENT, N2 40 PERCENT. PERFORMED RESTART THE ENGINE WOULD NOT START PAST 30 PERCENT N1, 40 PERCENT N2, WITH EGT AT 625 DEGREES & F/F AT 400 PPH. THROTTLE MOVEMENT HAD NOSDR P5CA0401288Link · missingNR 4 ENGINE T/R BLOCKER DOOR LINK MISSING AT 4 O'CLOCK POSITION. REMOVED BLOCKER DOOR AND BROKEN LINK PER CDL 78-31-1. T/R LOCKED OUT PER DDPG 78-1.SDR P5CA0401287Regulator Valve · failedON TAXI OUT DUCT LOW PRESS LIGHT CAME ON WITH DROP IN DUCT PRESSURE ON GAGE. ISOLATED LEFT WING PRESS LESS THAN 15 PSI. REPLACED PRESSURE REGULATOR VALVE ON ENGINE NR 2 PER MM 36-1114. PERFORMED ENGINE RUN PER MM 71-00-00. OPS CHECK OK.SDR P5CA0401251Wire · chafedNR 3 ENGINE BLEED VALVE CLOSED, LIGHT STAYS ON AT CRUISE PWR & POPPED C/B AT LANDING. REPAIRED CHAFED WIRE PYLON TO HIGH STAGE BLEED VALVE PER WPM CH 20-10-13, OPERATIONAL CHECK OK.SDR P5CA0401174Transducer · failedAUTO BRAKES INOP. REPLACED ANTI-SKID TRANSDUCER NR 3 POSITION, SPIN CHECK NORMAL (NO LIGHT ILLUMINATE PER MM 32-43-00).SDR P5CA0401136Comparator · inoperativeRUDDER RATIO LIGHT CAME ON AFTER TAKEOFF. REMOVED AND REPLACED RUDDER RATIO COMPARATOR.SDR P5CA0401137Connector · looseRUDDER RATIO LIGHT CAME ON DURING CLIMBOUT, 220KTS, FLAPS 1 DEGREE. RESEATED CONNECTOR TO RUDDER RATIO CONTROLLER AND SERVO ACTUATOR IAW AMM 27-21-00..SDR P5CA0401133Pressure Valve · inoperativeDURING ENGINE START NR 3 ENGINE ROTATION WAS SLOW, LIGHT OFF NORMAL BUT WOULD NOT ACCELERATE PAST 30 PERCENT. REPLACED NR 3 ENGINE PRESSURE RELIEF VALVE, OPERATIONAL CHECK GOOD IAW MM 36-11-00.SDR P5CA0401173Charger · smokeSMOKE IN COCKPIT. MAIN BATTERY CHARGER FAULTY. SWAPPED MAIN CHARGER WITH APU CHARGER, OPS CHECK OK PER AMM 24-31-00. DEFERRED APU BATTERY CHARGER PER MEL 24-24.SDR P5CA0401114Indicator · inoperativeFLIGHT OFFICER AIRSPEED INDICATOR INOPERATIVE, NO MOVEMENT. REPLACED INDICATOR OPS CHECK OK, IAW MM 34-17-03.SDR P5CA0401106Valve · failedNR 3 ENGINE FIRE WARNING CAME ON DURING CLIMB, A & B LOOPS READ 7 TO 10 UNITS, THAN STABILIZED TO 4 UNITS SCALE WHEN THROTTLE MOVED TO IDLE. FOUND NR 3 ENGINE HIGH-STAGE BLEED VALVE LEAK. REMOVED AND REPLACED NR 3 ENGINE HIGH STAGE BLEED VALVE AS PER MM 36-1SDR P5CA0401092Line · looseNR 3 BRAKE LEAK, FOUND ON PRE-FLIGHT. TIGHTENED NR 3 BRAKE LINES AS PER MM 32-41-03, LEAK CHECK OK.SDR P5CA0401081Wire · brokenON ENGINE START, ELEVATOR FEELS LIGHT. DID NOT COME ON WITH HYD SYST NR 2 PRESSURIZED AND SYST 3 UNPRESSURIZED. FOUND BROKEN WIRE AT MISOI, REPAIRED IAW 20-10-13. PERFORMED SYST CHECK PER 27-31-00, SYST OPS NORMALLY.SDR UIEA200400006Logic Card · damagedTLV/AMS - ON CALL BEFORE LANDING CHECK, GEAR INDICAT DOWN, INTERMITTENT BEEPING WAS HEARD. GEAR LIGHT WENT RED. PRIMARY AND ALTERNATE CHECK SHOWED RIGHT BODY AND RIGHT WING GEAR NO DOWN. CREW INITIATED GO AROUND, LEFT GEAR DOWN AND LEVEL OFF GEAR LIGHT WENT
Back to N508MC, cancelled Jun 7, 2011