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 DALA13053559220Fitting · damagedDAMAGE AT UPPER AFT HOLE ON CENTER SECTION FITTING. REAMED AND REMOVED DAMAGE IAW SRM 55-10-03 HFEC. INSTALLED BUSHING. REPAIR COMPLETE IAW ERA 519682-14.SDR DALA13053499208Cusp Web · corrodedCUSP WEB, LOWER SURFACE, BS 503 HAS CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED DOUBLER AND FILLER AND INSTALLED IAW SRM 53-20-02.SDR DALA13053349239Wire Harness · shortedDIVERTED DUE TO SMOKE IN THE CABIN. DECLARED AN EMERGENCY. L1 DOOR F/A HANDSET WAS OVERHEATING AND STARTING TO SMOKE. MX FOUND FORWARD F/A HANDSET WIRE SHORTED. R & R MID CABIN HANDSET IAW AMM. OPS CHECKED NORMAL.SDR DALA13053099226Latch · misinstalledL2 DOOR GIRT BAR LATCH INSTALLED BACKWARDS AND UNABLE TO ARM GIRT BAR. REPOSITIONED LATCH. OPS CHECKED GOOD. AIRCRAFT OK FOR SERVICE.SDR DALA13053089208Seat Track · damagedSEAT TRACK, RBL 24, BS 1250 HAS GROOVES AND SMALL GOUGES. CUT OUT DAMAGE. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW SEAT TRACK IAW SRM 53-40-01.SDR DALA13053079208Cusp Web · corrodedMAIN CABIN RT CUSP WEB, BS 807-826 HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED DOUBLER AND FILLER AND INSTALLED IAW SRM 53-20-02 AND 53-20-00.SDR DALA13053069208Cusp Web · corrodedMAIN CABIN RIGHT CUSP WEB, BS 1079-1096 CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW SRM 53-20-02.SDR DALA13052779208Cusp Web · corrodedMAIN CABIN, BS 475 LBL 58, HAS CORROSION AT LIGHTNING HOLE CUSP WEB. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-20-02.SDR DALA13052739208Seat Track · corrodedCORROSION ON WEB AND ON SCALLOPS, RBL 54.5, SEAT TRACK BS 995 -1025. FABRICATED AND INSTALLED NEW SEAT TRACK IAW SRM 53-40-01.SDR DALA13052719208Cusp Web · corrodedLEFT SIDE OF FUSELAGE INTERIOR FS 541 TO 522 AND LBL 54 - 58 HAS CORRODED CUSP WEB. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR IAW SRM 53-20-02.SDR DALA13052729208Cusp Web · corrodedMAIN CABIN, RIGHT CUSP WEB BETWEEN BS 446 -465 HAD CORROSION AT LIGHTNING HOLE. REMOVED CORROSION. FOUND TO BE OUT OF LIMTIS. FABRICATED AND INSTALLED DOUBLER IAW SRM 53-20-02.SDR DALA13052099243Wire · failedEXPERIENCED A SIGNIFICANT ELECTRICAL FAILURE AT 13,000 FEET DUE TO A LT BUSS GENERATOR AND FEEDER FAULTS. EMERGENCY DECLARED. AND LANDED, . AFTER TROUBLESHOOTING, MX FOUND FAULTY WIRING. CIRCUIT BREAKERS, "LM" WITH THE LEFT CHANNEL OC TRIPPED "XLM" MESSAGESDR DALA13052759208Cusp Web · corrodedLT SIDE OF FUSELAGE INTERIOR FS 541 TO 560, LBL 54-58 HAD CORRODED CUSP WEB. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED DOUBLER REPAIR IAW SRM 53-20-02.SDR DALA13052749208Cusp Web · corrodedMAIN CABIN, RT CUSP WEB BETWEEN BS 489 -503 HAS CORROSION AT LIGHTNING HOLE. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED, TREATED, PRIMED, TOPCOATED AND INSTALLED REPAIR PARTS IAW SRM 53-20-02.SDR DALA13051169207Bracket · misinstalledDURING CHECK, AFT GIRT BAR BRACKET WAS INSTALLED BACKWARDS. MX RE-INSTALLED GIRT BAR BRACKET CORRECTLY.SDR DALA13050429243Light · failedF/A REPORTED SMOKE COMING FROM PASSENGER SEAT 25C READING LIGHT. R & R READING LIGHT ASSEMBLY IAW AMM. OPS CHECKED NORMAL. NO SMOKE OR ODOR NOTED.SDR DALA13050399215Controller · failedFLIGHT CREW REPORTED SLIGHT HAZE AND WARM AIR COMING FROM REAR OF ACFT. R & R LEFT TEMPERATURE CONTROL IAW AMM. OPS CHECKED GOOD. MCO/PLAC REMOVED.SDR DALA13050339240Lamp · inoperativeDURING SERVICE CHECK, CATWALK EMERGENCY LIGHTS FOUND INOPERATIVE. R & R TEN LAMPS. OPS CHECKED GOOD.SDR DALA13050379206Wire · damagedDURING SERVICE CHECK, MX FOUND CEILING EMERGENCY LIGHT 10R, INOPERATIVE. FOUND BROKEN SPLICE CONNECTOR OVER CEILING PANER REPAIRED IAW SWPM. OPS CHECKS GOOD.SDR DALA13050369206Wire · damagedDURING SERVICE CHECK, MX FOUND CEILING EMERGENCY LIGHT 10L INOPERATIVE. FOUND BROKEN SPLICE CONNECTOR OVER CEILING PANEL. REPAIRED IAW SWPM. OPS CHECKS GOOD.SDR DALA13050359206Wire · damagedDURING SERVICE CHECK, MX FOUND CEILING EMERGENCY LIGHT 37L INOPERATIVE. TROUBLESHOT, FOUND SPLICE CONNECTOR ABOVE CEILING PANEL OPEN. REPAIRED SPLICE CONNECTOR IAW SWPM. OPS CHECKS GOOD.SDR DALA13050349206Wire · damagedDURING SERVICE CHECK, MX FOUND CEILING LIGHT 30L , EMERGENCY LIGHT INOPERATIVE. FOUND BROKEN SPLICE CONNECTOR ABOVE OVERHEAD PANEL. REPAIRED IAW SWPM. OPERATION CHECKS GOOD.SDR DALA13050299207Skin · damagedVERTICAL STABILIZER SKIN AT 1520 LONGERON 3R DAMAGED. ACCOMPLISHED REPAIR TO AFT FUSELAGE TO DORSAL FIN /SKATE ANGLE SPLICE IAW ERA 518618-14, REV O.SDR DALA13050289207Beam · corrodedAFT CARGO BAY, MAIN BEAM L28R, CORRODED BETWEEN BS 1269-1250. BEAM FOUND TO BE OUT OF LIMITS. R & R BEAM IAW SRM 51-30-05 AND DWG 5730483 AT STA 1174-1307.SDR DALA13050279207Floor Support · corrodedAFT CARGO BAY, BS 1231-1269, FLOOR SUPPORT ANGLE ABOVE LONGERON 29R, CORRODED AROUND SEVERAL NUTPLATE HOLES. REPAIRED FLOOR SUPPORT IAW SRM 53-00-01 AND REINSTALLED IAW SRM 51-30-05.SDR DALA13050259207Rib · crackedRIGHT STABILIZER L/E AT SPLICE BELT, INBD RIB IS CRACKED AT LIGHTNING HOLE. REPAIRED IAW ERA 519210, REV O.SDR DALA13050249207Frame · crackedINTERNAL TAIL EMPENNAGE AREA, NEAR TOP OF CANTED BULKHEAD FRAME BS 1520 JUST INBD OF STRINGER 3R FRAME ANGLE IS CRACKED. REPAIRED IAW ERA 517836-14, REV O AND PRI ERA 517836-14, REV 0, 1, 2.SDR DALA13052799207Skin · crackedFUSELAGE AFT TAIL CONE AREA UPPER SKIN STRUCTURE, BS 1520, CANTED DOUBLER AND SKIN CRACKED AT LONGERON 3R. OEM APPROVED REPAIR AS PERMANENT, SECTION I COMPLETED IAW ER/A 517836-14.SDR DALA13050419204Lamp · inoperativeDURING SERVICE CHECK, MX FOUND EMERGENCY CEILING LIGHT ROW 38R INOPERATIVE. REPLACED LAMP. OPS CHECKED GOOD.SDR DALA13050409204Lamp · inoperativeDURING SERVICE CHECK, MX FOUND EMERGENCY LIGHT ROW 36L, INOPERATIVE. REPLACED LAMP. OPS CHECKED GOOD.SDR DALA13050389207Attach Angle · brokenTHE RT FUSELAGE TO DORSAL FIN ATTACH ANGLE WAS CUT AT STA 1520, COMPLETELY SEVERED. OEM APPROVED REPAIR AS PERMANENT, ERA 518618-14. REQUIRES GVI AT 3000 CYCLES OR CHECK THRESHOLD.SDR DALA13050329207Attach Angle · crackedCENTER WING BOX UPPER SKIN, BS 883, XCW 48, LT CENTER TANK SKIN ATTACH ANGLE IS CRACKED. R & R DAMAGE IAW ERA 49819-14MA.SDR DALA13050269207Skin · crackedAFT ACCESSORY COMPARTMENT, RT SIDE CANT FRAME BS 1531, FUSELAGE SKIN IS CRACKED. COMPLIED WITH PRI REV O, AND ERA 518608-14, REV A.SDR DALA13050239207Skin · damagedNR 1 PYLON LOWER SKIN WORN. REPAIRED IAW ERA 517820-14, REV O.SDR DALA13050219207Stop Fitting · crackedFORWARD CARGO DOOR, FORWARD UPPER FOUR STOP FITTINGS CRACKED. R & R STOP FITTINGS IAW CMM 52-30-01.SDR DALA13050209207Skin · corrodedAFT CARGO BAY, SKIN CORRODED, BS 1340-1347 BETWEEN L27-28R. ACCOMPLISHED ERA 517839-14, REV O.SDR DALA13050319207Skin · corrodedFORWARD RT WING TO BODY FAIRINGS BS 807-864, L26-29R HAS CORROSION ON SKIN. COMPLIED WITH PRI 518624-14 REV 0,1,2 AND ERA 518604-14, REV O.SDR DALA13050309207Attach Angle · crackedCENTER WING BOX, UPPER SKIN, BS 883, XCW 48, RT CENTER TANK, UPPER SKIN ATTACH ANGLE IS CRACKED. COMPLIED WITH PRI 518597-14, REV O AND ERA 518597-14, REV O AND ERA 498182-14MA.SDR DALA13050229207Structure · crackedAFT ACCESSORY COMPARTMENT, BS 1542, UPPER AFT CORNER OF LT VENT BOX IS CRACKED. R & R ANGLE SUPPORT IAW SRM 51-30-02, 51-30-05 AND 51-30-01.SDR DALA2013100469207Splice · corrodedAFT CARGO BAY BS 1358, L29L, CHANNEL SPLICE HAS CORROSION. R & R CHANNEL SPLICE IAW SRM 51-30-05, 53-10-01, AND 51-10-03.SDR DALA2013100459207Beam · corrodedAFT CARGO COMPARTMENT, STA 1212-1288, L29R BEAM IS CORRODED UNDER INTERCOSTAL. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPLACED BEAM IAW SRM 53-00-01 AND 51-10-05 AND 51-30-05.SDR DALA1503399228Door Frame · unknownFUSELAGE, AFT CARGO DOORWAY, LOWER JAMB BEAM, L-28R CORROSION REPAIRED IAW ERA 398119-14.SDR DALA20131004207Longeron · corrodedAFT CARGO BAY, LONGERON 30L CORRODED BETWEEN BS 1315 AND 1355. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED LONGERON. FABRICATED NEW AND INSTALLED IAW SRM 53-10-01.SDR DALA13049639207Shear Tie · corrodedAFT CARGO BAY BS 1288, L29-30R, SHEAR TIE IS CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SHEAR TIE IAW SRM 51-30-02.SDR DALA13050519207Shear Tie · crackedAFT ACCESSORY BAY, LT SIDE BETWEEN LONGERONS 14 AND 15 LEFT, BS 1458, SHEAR TIE IS CRACKED AT UPPER FASTENER. REPLACED SHEARTIE IAW DWG 5913596 AND SRM 51-30-02, 51-30-05 AND 51-40-00.SDR DALA13050509207Intercostal · corrodedAFT CARGO BAY, BS 1326-1344, L30 INTERCOSTAL HAS CORROSION ON UPPER AND LOWER FLANGES AND FORWARD TIE STRAP. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. INSTALLED NEW INTERCOSTAL IAW SRM 51-30-05.SDR DALA13050499207Longeron · corrodedAFT CARGO BAY, LONGERON 27R CORRODED BETWEEN BS 1390 -1394. REMOVED LONGERON. LOCATED, DRILLED, TREATED, PRIMED, PAINTED AND INSTALLED NEW LONGERON IAW SRM 53-10-01, 51-10-05, & 51-10-03, 51-30-05.SDR DALA13050489207Intercostal · corrodedAFT CARGO BAY, INTERCOSTAL CORRODED BETWEEN BS 1204 - 1212, L29 AND 30R. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. INSTALLED NEW INTERCOSTAL IAW SRM 51-30-02 AND 51-30-05.SDR DALA13050529207Longeron · corrodedAFT CARGO BAY, LONGERON L28R CORRODED BETWEEN BS 1315-1364. REMOVED CORROSION. LOCATED, DRILLED, TREATED, PRIMED, PAINTED AND INSTALLED LONGERON IAW SRM 51-10-05, 51-10-03, AND 51-30-05.SDR DALA2013100499219Structure · out of positionDURING TAXI OUT, F/A HEARD A LOUD THUD IN TAILCONE. RETURNED TO GATE. FOUND AFT VENTRAL STAIRS CATWALK OUT OF RIG. FOUND CATWALK CATCHING ON LOOSE TRIM. SECURED TRIM. OPS CHECKED GOOD.
Back to Boeing MD-90-30