Boeing MD-90-30
Service difficulty reports · 6,066
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'MD9030' 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 aircraft_model_key = 'MD9030' 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 DALA1157579229Structure · crackedSTA 1475 L3LT-L3RT DORSAL FIN REPAIRED IAW BNI-BNI-10-0069-09B 8100-9 RECEIVED 09/23/2011___(TO 85.SDR DALA1157569229Cusp Web · crackedSTA 1344-1364 RT CUSP MEMBRANE REPAIRED IAW PMT-PMT-10-0001-02B DWG SG09530019 SRM 53-20-02 VOL I, PARA 6__(TO 84).SDR DALA1157559229Angle · crackedSTA 1542 CANT, RT FUSELAGE TO VERTICAL STABILIZER DORSAL FIN REPAIRED IAW BAC TWX BNI-BNI-10-168-01C, DWG SR09530296 AND SERVICE BULLETIN MD90-53-027 R2__(TO 82).SDR DALA1319369212Skin · damagedTHE HORIZONTAL STABILIZER RT UPPER AFT SKIN PANEL DAMAGED. REPAIRED IAW ERA 477402-14.SDR 2010FA0001099Generator · damaged(HZ3R) GENERATOR WAS SEPARATED AT THE END BELL AND STATOR. HELICOILS WERE PULLED. THE MAIN DRIVE SHAFT WAS BROKEN. METAL WAS FOUND IN THE FILTER. THE PUMP WAS SEIZED AND PACKED FULL OF DEBRIS. THE PUMP DRIVE SHAFT WAS IN GOOD CONDITION. THE END BELL EXCISDR 2010FA0001098Rotor · damaged(HZ3R) PUMP ASSY HAD SEVERE DAMAGES, SUCH AS GEAR BUSHING BROKE AND GEAR SHAFT DISASSEMBLE FROM NORMAL POSITION (STILL MOUNTED IN THE ROTOR) STATOR ASSY - SEVERE DAMAGES FROM ROTOR ASSY END BELL ASSY - LINER HAS BEEN DISINTEGRATED. LINER MOUNTING STRUCTURES ASDR DALA1319389212Skin · crackedCRACKS FOUND IN THE HORIZONTAL STABILIZER RT UPPER AFT SKIN PANEL. REPAIRED IAW 02-460214-12, ME06 02-460214-12.SDR DALA1023449208Frame · crackedFATIGUE CRACK IN FRAME FS 962 RT. R & R FRAME EO 02-460094-12AD REVA ME03 OPN0301.SDR DALA1023629206Actuator · intermittentACTION CLIMBING THROUGH 11,000 FT AND ACCELERATING THROUGH 310 KNOTS, NOSE GEAR DOOR CAME OPEN. SLOWED TO 250 KNOTS, DOOR APPEARED TO CLOSE. REPLACED NOSE GEAR DOOR LINK ACTUATOR AND RIGGED SAME IAW AMM. PERFORMED NOSE GEAR RETRACTION CHECK.SDR DALA1023379206Release Mech · lack of lubeTHE ACFT RETURNED TO DEPARTURE, DUE TO VIBRATION FELT IN THE NOSE AREA DURING TAKEOFF. MX FOUND THE LT NOSE GEAR DOOR OPEN ON LANDING. THE DOOR RELEASE HANDLE WAS CLEANED, LUBED, AND CYCLED. FUNCTIONAL CHECK OF THE DOOR CLOSING AND SECURING WAS NORMAL.SDR DALA1022599208Door Frame · crackedOVERWING EXIT FRAME 962 RT WAS FOUND CRACKED AND R & R IAW EA 02-460094-12AD.SDR DALA1052709226Skin · dentedACFT MODIFIED IAW ERA484704-14, REV A, STABILIZER, HORIZONTAL, RT, LOWER SKIN PANELS REPLACEMENT.SDR DALA1021790904Lens · missingDURING LINE CHECK MX, FOUND EMERGENCY LIGHT INOPERATIVE AND MISSING LENS IN ROW 1. MX REPAIRED CRUSHED WIRING AND REPLACED MISSING LENS MODULE IN ROW 1. OPS CHECK OF LIGHT CHECKS OK.SDR 2010FA0001004Rotor · failedSHAFT IS SHEARED, THE STATOR HSG HAS SEPARATED FROM THE END-BELL (ALL HELI-COILS ARE PULLED AND BOLTS BROKEN). NOTE: OIL PUMP IS STILL MOUNTED TO THE END-BELL, SUSPECT SEVERE INTERNAL DAMAGE. ROTOR FAILURE. OPENSDR DALA1020729216Lamp · inoperativeDURING LINE CHECK MX FOUND EMERGENCY PATH LIGHT INOP AND MODULE MISSING AT 15C. MX RE-LAMPED AND REPLACED MISSING MODULE. OPS OF LIGHT NOW CHECKS GOOD.SDR DALA1020039212Wire · brokenDURING CHECK VIDEO CONTROL UNIT EMERGENCY LIGHTING FLOOR LIGHTS INOPERATIVE. ITEM WAS FWD TO MCO/PLACARD ON 16AUG10. THEN ON 18AUG10 MSP MX REPAIRED BROKEN WIRE AT 10CDE. ALL FLOOR PATH LIGHTS NOW OPERATE NORMAL AND THE MCO/PLACARD WAS REMOVED.SDR 2010FA0000847Pump · failed(HZ3R) PUMP ASSY HAD SEVERE DAMAGES, SUCH AS GEAR BUSHINGS BROKE AND GEAR SHAFT DISASSEMBLED FROM NORMAL POSITION (STILL MOUNTED IN THE ROTOR). STATOR ASSY - SEVERE DAMAGES FROM ROTOR ASSY. END BELL ASSY - LINER HAS BEEN DISINTEGRATED. LINER MOUNTING STRUCSDR 2010FA0000846Generator · failed(HZ3R) DISASSEMBLED UNIT AND FOUND THE INSIDE TO BE COMPLETELY VOID OF OIL. THERE WAS A LARGE AMOUNT OF ALUMINUM INSIDE OF THE FILTER HOUSING. THE PUMP WAS SEIZED AND THE PUMP BEARING CAGE WAS PROTRUDING FROM THE HOUSING. THE PUMP DRIVE SHAFT WAS ALSO BROKESDR DALA1018299207Wire · damagedACTION DURING LINE CHECK MX FOUND FIRST CLASS EMERGENCY LIGHTS WITH EXPOSED WIRES AND BROKEN. MX REPAIRED DAMAGED WIRES AND REPLACED LIGHTS. OPS CHECK OF LIGHTS NOW CHECK GOOD.SDR DALA1018689208Light · damagedEMERGENCY FLOOR LIGHTS WERE FOUND TO BE INOPERATIVE & DAMAGED. MAINTENANCE REPLACED THE LIGHT MODULE ASSEMBLY. AN OPERATIONAL CHECK WAS PERFORMED AND THE AIRCRAFT WAS RETURNED TO SERVICESDR DALA1017509208Wire · brokenTHE EMERGENCY LIGHT AT SEAT 3C WAS FOUND TO BE INOPERATIVE /DAMAGED. MAINTENANCE REPAIRED A BROKEN WIRE UNDER THE TRACK COVER. AN OPERATIONAL CHECK WAS PERFORMED AND THE AIRCRAFT WAS RETURNED TO SERVICE (2010-D0900) (DLM90101964).SDR DALA1403459219Attach Fitting · unknownFWD GALLEY AND LAV UPPER ATTACH STRUCURE REPAIRED IAW EA 02-477514-03, ME 01 & 05.SDR DALA1403449219Structure · unknownFWD GALLEY FLOOR STRUCTURE REPAIRED IAW EA 02-477513-03, ME 01 & 04.SDR DALA1403439219Brake Sys · unknownBRAKE SYSTEM REPAIRED IAW EA 02-476765-03, ME01.SDR DALA1015819206Light · damagedCREW WROTE UP EMERGENCY FLOOR LIGHT AT ROW 39C AS DAMAGED AND INOPERATIVE. MAINTENANCE RE-INSTALLED LIGHTING CONDUIT AND SPLICED AS NEEDED. OPERATIONAL CHECK OF LIGHT NOW CHECKS GOOD (2010-D0813)(DLM90101774).SDR DALA1154629232Skin · damagedNEW SKIN SECTION SPLICE IN BETWEEN LOCATIONS STA Y=229 AND SPLICE IN FRAME BAY STA Y=275 AND Y=294 IAW SRM 53-30-01 FIG 5 REF A10690.SDR DALA1017189218Structure · damagedAFT CARGO DOOR, LOWER END CHAFED & GOUGED IN 4 PLACES, FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR DOUBLERS IAW SRM 52-30-02, PRIMED & PAINTED DOUBLERS IAW SRM 51-10-04, INSTALLED DOUBLERS IAW SRM 52-30-04 VOL I.SDR DALA1405979218Fastener · damagedPYLON AFT FITTING UPPER FASTENERS DAMAGED. REPLACED IAW AA 5440-01069.SDR DALA1405969218Frame · damagedBS 883 OVERWING FRAME DAMAGED. REPAIRED IAW AA 5310-01375.SDR DALA1405959218Stop Fitting · damagedCARGO DOOR STOP PAD FITTINGS DAMAGED. REPAIRED IAW AA 5230-01136.SDR DALA1405949218Jackscrew · damagedHORIZONTAL STABILIZER JACKSCREW ASSY DAMAGED. REPAIRED IAW AA 2740-01071.SDR DALA1014130909Bulb · missingCREW WROTE UP NUMEROUS EMERGENCY LIGHTS WERE INOPERATIVE THRU OUT CABIN MISSING COVERS AND MISSING BULBS. MSP MX TAPED ROW 3, 4, AND 38. LIGHT INOPERATIVE AT ROW 2 AND FOWARD TO MCO/PLACARDED. BOS MX REPLACED ALL MISSING BULBS AND LENS COVERS. NOW LIGHTSDR DALA1014120908Distributor · overheatedON APPROACH THE CABIN CREW REPORTED THAT THEY HAD A SMELL OF SMOKE/ODOR. NO VISIBLE SMOKE AND THE ODOR DISSIPATED WITHIN A FEW MINUTES. MX FOUND DISTRIBUTION UNIT AT 22E OVERHEATED. UNIT WAS REPLACED UNIT AND NEW UNIT OVER HEATED.(DLM90101581)SDR DALA1013280907Sign · inoperativeMX SET UP TO VERIFY ALL EMERGENCY LIGHTS AND SIGNS. MX FOUND EXIT SIGN AT L2 INOPERATIVE. SIGN WAS REPLACED AND OPS CHECK OF SIGN NOW OK.SDR DLM90101290Wire · brokenON FLIGHT CHECK, MX FOUND CABIN EMERGENCY LIGHTS INOP FROM ROW 33 AND AFT. MX FOUND BROKEN WIRE AT SEAT ROW 35CDE. MX REPAIRED WIRE AND OPS CHECK OF LIGHTS NOW CHECK GOOD.SDR DLM90101300Light · inoperativeON 18MAY, THE INBOUND FLIGHT PILOT WROTE UP A FLOOR EMERGENCY ESCAPE PATH LIGHT AT SEAT 3C AS INOPERATIVE. MX FORWARDED THE LOG TO MX CONTROL WHO PLACARDED IT DUE TO PARTS NOT AVAILABLE . ON 26MAY, MX REPLACED RECEPTACLE AND LENS. OPS CHECK OF LIGHT, NOW CHSDR DLM90101250Wire Harness · inoperativeON FLIGHT CHECK MX FOUND EMERGENCY TRACK LIGHT INOPERATIVE, ROW 22. RE-LAMPED AND NO HELP ON 5-16-10 DCA MX REPLACED WIRING HARNESS. OPS CHECK OF LIGHT NOW CHECKS OK.SDR DALA1503659228Bulkhead · unknownSTA 1344, TEE BULKHEAD REPAIR BETWEEN L30 & 23R, SRM 53-10-02.SDR DLM90100969Socket · inoperativeON LAYOVER CHECK MX FOUND EMERGENCY LIGHTS 29C AND 3C INOP. REPLACED LIGHT SOCKET ASSY AT 29C AND LIGHT TRACK SECTION AT 3C. OPS CHECK NOW OK.SDR DALA1405329217Frame · damagedBS 883-962 OVERWING FRAME WAS DAMAGED. REPAIRED IAW AA 5310-01375.SDR DALA1405319217Stop Fitting · damagedCARGO DOOR STOP PAD FITTINGS DAMAGED. REPAIRED IAW AA 5230-01136.SDR DALA1405309217Jackscrew · damagedHORIZONTAL STABILIZER JACKSCREW ASSY DAMAGED. REPAIRED IAW AA 2740-01071.SDR DLM90100845Light · inoperativeEMERGENCY FLOOR LIGHTING INOP AT 35C. REPLACED FLOOR TRACK LIGHT ASSY AND RED LENS. OPS CHECK OF LIGHT NOW OK.SDR DLM90100844Wire · brokenINBOUND PILOT CREW WROTE UP 4 EMERGENCY TRACK LIGHTS WERE OUT AT ROW 10-13. SLC. MX REPAIRED BROKEN WIRE IN LIGHT TRACK. OPS OF EMERGENCY LIGHTS NOW OPERATIONAL.SDR DLM90100790Hydraulic System · lowJUST PRIOR TO DECENDING, RT HYD SYS QTY DROPPED TO 6, DID ABNORMAL IN QRH 1213. CONFIGUERED FOR LAND ICW QRH, LANDED W 28 DEGREE FLAPS. UNEVENTFUL SHUTDOWN WITH LT QTY 11 RT 8 DECLARED EMERGENCY LANDING.SDR DLM90100797Light · damagedDAMAGED SECTION OF EMERGENCY TRACK LIGHTING AT SEAT 32C.SDR DLM90100796Light · damagedEMERGENCY TRACK LIGHT LENS AND LIGHT DAMAGED AT SEAT 3C. REPAIRED AS REQD.SDR DLM90100798Bulb · burned outEMERG FLOOR PROX ESCAPE PATH LIGHTING BY SEAT 03C LOOSE, 2 ADJACENT WHITE LIGHTS INOP. FOUND BOTH BULBS BURNED OUT. RELAMPED SAME. OPS NORMAL AT THIS TIME. MCO AND PLACARD REMOVED.SDR DLM90100743Bulb · inoperativeEMERGENCY RED LIGHT AT 28C INOPERATIVE. REPLACED BULB AND LIGHT SOCKET ASSY. SYS CHECKS GOOD.SDR DLM90100549Light · inoperativeEMERGENCY ESCAPE PATH LIGHTS INOP AT SEAT ROWS 13C AND 14C. REPLACED ENTIRE FLOOR TRACK LIGHTING FROM ROWS 10 THRU 14 ALL LIGHTS NOW TEST OK.
Back to Boeing MD-90-30