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 DALA2013100489220Hinge Fitting · corrodedEVIDENCE OF FRETTING ON RIGHT OUTER LUG FACE, RT HORIZONTAL STABILIZER HINGE FITTING. REMOVED CORROSION IAW SRM 55-30-05.SDR DALA2013100479220Hinge Fitting · corrodedEVIDENCE OF FRETTING ON LT OUTER LUG FACE, LEFT HORIZONTAL STABILIZER HINGE FITTING ON VERTICAL STABILIZER. CORROSION REMOVED/REWORKED IAW SRM 55-30-05.SDR DALA13049629207Floor Support · corrodedPASSENGER CABIN, FLOOR STRUCTURE, BS 200, RBL 57, BELOW U CHANNEL FOR R1 DOOR STRUCTURE IS CORRODED. COMPLIED WITH PRI AND ERA 518594-14, REV O.SDR DALA13048009204Wire · disconnectedDURING SERVICE CHECK, OVERWING EMERGENCY EXIT SIGN INOPERATIVE. FOUND WIRES DISCONNECTED IN CEILING PANEL. RECONNECTED WIRES. OPERATION CHECKS GOOD.SDR DALA13047989207Intercostal · crackedAFT ACCESSORY BAY, LT, BS 1549 CANTED FRAME, LOWER INTERCOSTAL IS CRACKED. R & R INTERCOSTAL AND REPAIR DOUBLER SPLICE IAW SRM 51-70-01, 51-00-01, 53-00-01 AND 51-10-03.SDR DALA13047969207Skin · corrodedAFT CARGO BAY DOOR CUT OUT, LOWER INNER SKIN, BETWEEN BS 1237 -1250, OUTSIDE OF S28R CORRODED. COMPLIED WITH ERA 517827-14, REV O AND PRI 517824-14 REV O.SDR DALA13047909207Angle · corrodedAFT CARGO BAY, BS 1276, ANGLE AT FRAME AND OTBD SIDE OF 28R IS CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. INSTALLED NEW ANGLE IAW SRM 51-30-05.SDR DALA13047889207Skin · corrodedON REMOVAL OF LONGERON 27R, FOUND CORROSION ON INTERSKIN DOUBLER AT BS 1354. COMPLIED WITH ERA 517834-14, REV O AND PRI 517834-14, REV O AT STA 1354, L27R.SDR DALA13047869207Floorbeam · damagedMAIN CABIN LT FLOORBEAM AT STA 1060, LBL 48 HAS A DAMAGED HOLE. REMOVED DAMAGE AND REPAIRED IAW SRM 51-70-01.SDR DALA13047879207Frame · corrodedAFT CARGO BAY, BS 1344, BETWEEN L29L AND L27R, FORWARD FACE AND LOWER FLANGE OF FRAME IS CORRODED. FRAME FOUND TO BE OUT OF LIMITS. INSTALLED NEW FRAME ASSY IAW SRM 53-10-02.SDR DALA13047859207Shear Tie · corrodedAFT CARGO BAY, SHEAR TIE, BS 1276, IS CORRODED BETWEEN L28 - 30R. REMOVED SHIEAR. LOCATED, DRILLED AND INSTALLED SHEAR TIE IAW SRM 51-30-02 AND 51-30-05.SDR DALA13047849207Frame · corrodedAFT CARGO BAY, LOWER AFT FLANGE OF FRAME, BS 1307 CORRODED BETWEEN L29L AND L29R. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM 53-10-02.SDR DALA13047919207Shear Tie · corrodedAFT CARGO BAY, BS 1288, L29 - 30L, HAS EVIDENCE OF CORROSION BELOW SHEAR TIE. REMOVED CORROSION. 100 PERCENT MATERIAL LOSS. REPLACED SHEAR TIE IAW SRM 53-10-02.SDR DALA13047899207Shear Tie · corrodedAFT CARGO BAY, BS 1288, L28 - 30R, AFT SIDE OF SHEAR TIES ARE CORRODED.. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R SHEAR TIE IAW SRM 51-10-05 AND 51-30-02.SDR DALA13051179232Oven · contaminatedFIRST CLASS GALLEY OVEN STARTED SMOKING WHEN IT WAS TURNED ON. MX INSPECTED CONTENTS OF OVEN, NO SPILT FOOD OR SAUCE. FD TO MCO/PLAC IAW MEL 25-34-02. CIRCUIT BREAKER PULLED AND COLLARED. PERFORMED VISUAL INSPECTION OF OVEN. FOUND COOKED MEALS IN THE OVENSDR DALA13047999249Acm · overservicedEXPERIENCED A PLASTIC ODOR COMING FROM THE AIR CONDITIONING SYS ON CLIMBOUT THROUGH 15000 FT. ODOR DISSIPATED AND THEN REOCCURRED ON DESCENT BELOW 10000 FT. PERFORMED TROUBLESHOOTING IAW FIM WITH PACKS ON. NO ODOR NOTED IN CABIN. FOUND LEFT ACM OVER SERVICESDR DALA13047959219Spring · failedTAILCONE LATCH, LT UPPER, DOESN'T SPRING CLOSED. R & R SPRING IAW CMM. OPS CHECKED ON AMDS 1200-6647.SDR DALA13047949219Spring · failedTAILCONE LATCH, RT LOWER, IS SPRING LOADED TO OPEN. R & R SPRING IAW CMM. OPS CHECKED ON AMDS 1200-6647.SDR DALA13047939219Spring · failedTAILCONE LATCH, RT UPPER, DOESN'T SPRING CLOSED. R & R SPRING IAW CMM. OPS CHECKED ON AMDS 1200-6647.SDR DALA13047929219Spring · failedTAILCONE LATCH, LT LOWER, IS SPRING LOADED TO OPEN. R & R SPRING IAW CMM. OPERATIONS CHECKED ON AMDS 1200-6647.SDR DALA13047599207Cusp Web · damagedMAIN CABIN BS 1060 CUSP WEB BETWEEN OTBD AND MIDDLE TRACKS HAS ELONGATED HOLES AT NUTPLATES. R & R IAW SRM 51-30-02 AND DWG 9940443, REV A.SDR DALA13047589207Longeron · corrodedAFT CARGO BAY, LONGERON L29R CORRODED BETWEEN BS 1354-1364. REPLACED LONGERON IAW SRM 51-30-05 AND 53-10-01.SDR DALA13047579207Shear Tie · corrodedAFT CARGO BAY BS 1250, SHEAR TIE IS CORRODED FROM LONGERON 29L-29R, 100 PERCENT MATERIAL LOSS. REPLACED SHEAR TIE IAW SRM 51-30-02 AND 53-00-01.SDR DALA13047569207Seat Track · corrodedMAIN CABIN COMPARTMENT, LT, BS 1180, OTBD SEAT TRACK UPPER SURFACE, IN TRACK, CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R SEAT TRACK IAW SRM 53-40-01, 53-42-01 AND 53-20-01.SDR DALA13047559207Frame · corrodedAFT CARGO BAY BS 1260, STUB FRAME, OTBD OF LONGERON 28R, HAS CORROSION ON FWD AND AFT SIDES. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED, AND INSTALLED NEW STUB FRAME IAW SRM 51-10-05 AND 53-00-01.SDR DALA13047549207Shear Tie · corrodedAFT CARGO BAY BS 1205, LONGERON 29L AND 29R, SHEAR TIE IS CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPLACED SHEAR TIE IAW SRM 51-30-02 AND 51-30-05.SDR DALA13047539207Support Angle · crackedMID CARGO BAY BULKHEAD BS 522, RT SUPPORT ANGLE ABOVE LONGERON 28R IS CRACKED. R & R RT SUPPORT ANGLE IN MID CARGO COMPARTMENT. BULLKHEAD STA 522 IAW SRM 51-30-01 AND DWG 5936592-12, REV B.SDR DALA13047529207Frame Splice · corrodedAFT CARGO BAY, AFT REPAIR SPLICE AT FRAME, BS 1328 CORRODED, BETWEEN 29L AND 29R. FABRICATED AND INSTALLED NEW SPLICE IAW SRM 53-10-02.SDR DALA13047979207Angle · corrodedAFT CARGO BAY, AFT SIDE OF APB WEB RT SIDE BACK-UP ANGLE FOR JACK POINT HAS CORROSION IN CORNER. COMPLIED WITH ERA 517823-14, REV O AND PRI 517823-14, REV O AT JACK POINT BACK UP ANGLE.SDR DALA13047519207Frame · corrodedAFT CARGO BAY AFT SIDE OF FRAME, BS 1364 CORRODED, S26L- 29R. R & R SECTION OF FRAME IAW SRM 53-10-02.SDR DALA13047509207Structure · crackedFORWARD ENTRY DOOR, UPPER CORNER IS CRACKED. REPAIR OF FORWARD ENTRY DOOR ACCOMPLISHED IAW 27985-8000-0003.SDR DALA13047499207Attach Angle · crackedFORWARD ENTRY DOOR, FIRST FRAME FROM TOP, AFT END ATTACH ANGLE IS CRACKED. REPAIRED IAW 27982-8000-0002.SDR DALA13047489207Attach Angle · crackedFORWARD ENTRY DOOR, FIRST FRAME FROM TOP, FORWARD END ATTACH ANGLE IS CRACKED. REPAIRED.SDR DALA13047149207Shear Tie · corrodedAFT CARGO BAY, SHEAR TIE AT BS 1364, BETWEEN 28-29L, CORRODED. R & R SHEAR TIE IAW SRM 53-10-02.SDR DALA13047139207Shear Tie · corrodedAFT CARGO BAY, BS 1364, BETWEEN L28-29R FORWARD SIDE OF SHEAR TIE IS CORRODED. REPLACED SHEAR TIE SECTION.SDR DALA13046969207Shear Tie · corrodedAFT CARGO COMPARTMENT, BS 1364, SHEAR TIE BETWEEN L30 AND L29L IS CORRODED ON FWD SIDE. REPLACED SHEAR TIE.SDR DALA13046989207Frame · gougedTAIL COMPARTMENT LEFT SIDE FRAME AT BS 1437, JUST AFT OF TRIM AIR VALVE PREVIOUS REPAIR IS GOUGED. REMOVED GOUGE. DRILLED, TREATED, PRIMED AND INSTALLED NEW FILLER AND DOUBLER REPAIR IAW SRM 53-00-01, 51-30-00, 51-40-02, 51-10-31, 51-10-05.SDR DALA13046959207Cusp Web · corrodedLEFT PASSENGER CABIN, CUSP WEB HAS CORRODED ON LOWER SURFACE, BS 583, LBL 57 AT LIGHTNING HOLE. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW IAW SRM 53-00-01, 51-30-02 AND SMAL 2-13569.SDR DALA13047109207Seat Track · corrodedRT PASSENGER CABIN, OTBD SEAT TRACK HAS NUMEROUS AREAS OF CORROSION ALONG ENTIRE UPPER SURFACE, BS 852-1136. BLENDED CORROSION. FOUND TO BE OUT LIMITS. R & R SEAT TRACK IAW SRM 53-40-01, 51-10-03, AND 53-42-01.SDR DALA13047009207Cusp Web · corrodedMAIN CABIN, BS 560-579, RBL 60 CUSP WEB UPPER SURFACE HAS CORROSION. COMPLIED WITH ERA 517837-14, REV O AND PRI 517937-14, REV. O.SDR DALA13046639207Frame · corrodedAFT CARGO BAY STUB FRAME UNDER WEB, BS 1240, CORRODED. REMOVED STUB FRAME. FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED, AND INSTALLED FRAME IAW SRM 51-10-05 AND 51-30-05.SDR DALA13046629207Fitting · corrodedFORWARD GALLEY & LAV WET AREA, BS 195-198, RBL 52-55, GIRT BAR FITTING HAS CORROSION ON UPPER SURFACE. FOUND FITTING TO BE OUT OF LIMITS. REPLACED GIRT IAW SRM 51-30-01.SDR DALA13046619207Frame · corrodedAFT CARGO BAY STUB FRAME UNDER WEB BS 1250, CORRODED. REMOVED CORROSION, 100 PERCENT MATERIAL LOSS. DRILLED IAW SRM 51-10-05. INSTALLED ON NRC 27980-1600/0013.SDR DALA13046609207Frame · corrodedAFT CARGO BAY BS 1250, FRAME IS CORRODED ON LOWER FLANGE AFT SIDE OF FRAME ABOVE LONGERON 30. NEW STUB FRAME INSTALLED ON NRC 27980/1600/0013.SDR DALA13046599207Frame · corrodedAFT CARGO BAY STUB FRAME UNDER WEB BS 1220 CORRODED. REMOVED CORROSION, 100 PERCENT MATERIAL LOSS. LOCATED, DRILLED AND INSTALLED FRAME.SDR DALA13046589207Seat Track · corrodedMAIN CABIN BS 610-674, OTBD SEAT TRACK UPPER SURFACE, CORRODED. REMOVED CORRODED SEAT TRACK FROM BS 540-850, LT OTBD. CORROSION OUT OF LIMITS. NEW SEAT TRACK FABRICATED AND INSTALLED IAW SRM 53-10-02.SDR DALA13046579207Seat Track · corrodedRT PASSENGER CABIN, OTBD SEAT TRACK HAS MULTIPLE AREAS OF CORROSION ALONG UPPER SURFACE, BS 589-845. FOUND OUT OF LIMITS IAW SRM 53-40-01. REMOVED, REPAIRED AND REINSTALLED SEAT TRACK IAW SRM 53-40-01.SDR DALA13046569207Seat Track · corrodedRIGHT PASSENGER CABIN, OTBD SEAT TRACK HAS CORROSION ON UPPER SURFACE, BS 1330-1336. FOUND OUT OF LIMITS. REMOVED, REPAIRED, AND REINSTALLED SEAT TRACK IAW SRM 53-40-01.SDR DALA13046659207Fitting · out of limitsFORWARD GALLEY & LAVATORY WET AREA, BS 171- 174, RBL 52 - 55. FOUND GIRT BAR FITTING OUT OF LIMITS IAW SRM 53-00-01. R & R GIRT BAR FITTING IAW SRM 51-30-01.SDR DALA13047119207Cusp Web · corrodedMAIN CABIN, BS 522-2, RBL 60, CUSP WEB UPPER SURFACE HAS CORROSION. REPAIRED DAMAGED CUSP WEB IAW SRM 53-20-02.
Back to Boeing MD-90-30