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 DALA14006619211Cusp Web · corrodedMAIN CABIN, LEFT CUSP WEB, BETWEEN BS 769 - 775 IS CORRODED. REPAIRED MAIN CABIN CUSP WEB IAW SRM 53-20-02.SDR DALA14006599211Cusp Web · corrodedMAIN CABIN, RIGHT SIDE CUSP WEB, BETWEEN BS 750-757 CORRODED. 100 PERCENT MATERIAL LOSS. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW SRM 53-20-02, FIG 10.SDR DALA14006589211Cusp Web · corrodedCUSP WEB, BS 560-579 CORRODED. FOUND CORROSION OUT OF LIMITS. REMOVED CUSP WEB, FABRICATED AND INSTALLED DOUBLER REPAIR AND FILLER IAW SRM 53-20-02.SDR DALA14006579210Floor Support · corrodedFORWARD WET AREA, FLOOR SUPPORT CORRODED. REMOVED, FABRICATED, AND INSTALLED FLOOR SUPPORT IAW SRM 51-10-05, 51-10-03, PARA 21 AND PARA 14.SDR DALA14006439210Skin · corrodedRIGHT LOWER WING TO BODY AREA DOUBLER REPAIR HAS EVIDENCE OF CORROSION, BS 832, BETWEEN S27-29R. REMOVED CORRODED DOUBLER. FABRICATED NEW DOUBLER AND FILLER AND INSTALLED IAW SRM 51-10-03, 53-30-01.SDR DALA14006419211Cusp Web · corrodedMAIN CABIN, RIGHT CUSP WEB , BS 653 CORRODED. REMOVED CUSP WEB AND FABRICATED NEW CUSP WEB IAW SRM 53-10-02 AND SRM 51-10-05. INSTALLED IAW SRM 51-10-03.SDR DALA14006409211Cusp Web · corrodedMAIN CABIN, RT CUSP WEB, BS 674-685 CORRODED. REMOVED CORROSION AND FOUND 100 PERCENT MATERIAL LOSS. FABRICATED REPAIR DOUBLER AND FILLER AND INSTALLED IAW SRM 53-20-02.SDR DALA14006399211Cusp Web · corrodedMAIN CABIN, RIGHT CUSP WEB BETWEEN BS 655-674 IS CORRODED. REMOVED CUSP WEB AND FABRICATED NEW CUSP WEB IAW SRM 53-10-03 AND SRM 51-10-05.SDR DALA14006389210Cusp Web · corrodedLEFT CUSP WEB HAS CORROSION AT BS 1096. REMOVED CORROSION AND FOUND OUT OF LIMITS. FABRICATED DOUBLER AND FILLER AND INSTALLED IAW SRM 53-20-02.SDR DALA14006379210Cusp Web · crackedLEFT CUSP WEB, BS 1117-1136 CORRODED. REMOVED CORROSION AND FOUND WEB CRACKED. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 53-20-02.SDR DALA14006369210Cusp Web · corrodedLEFT CUSP WEB, BS 500 CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR DOUBLER AND FILLER IAW SRM 53-20-02.SDR DALA14006449234Battery Pack · inoperativeEMERGENCY LIGHT AT SEAT ROWS 36-37 CDE INOPERATIVE. R & R EMERGENCY CEILING LIGHT POWER SUPPLY BATTERY AT ROW 36DE IAW AMM. OPS CHECKED NORMAL.SDR DALA14006429235Release Cable · frayedTAILCONE RELEASE BOTTLE ATTACH CABLE FRAYED. R & R TAILCONE RELEASE BOTTLE CABLE IAW AMM.SDR DALA14006359235Guide · damagedDURING SERVICE CHECK, MAINTENANCE FOUND TAILCONE EXTERIOR EMREGENCY EXIT PULL HANDLE ANGLE BROKEN. R & R ANGLE GUIDE ON TAILCONE EXTERIOR EMERGENCY EXIT PULL HANDLE. OPS CHECKED GOOD IAW AMDS 5352-7116, STEP 5, A-1-A.SDR DALA14009509210Seat Track · damagedCABIN SEAT TRACK, BS 900-1150 SCRATCHED AND SHOWS BARE METAL. BLENDED AND FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED AND INSTALLED NEW SEAT TRACK IAW SRM 53-40-01 AND 51-10-03.SDR DALA14006609211Cusp Web · corrodedMAIN CABIN, LEFT SIDE CUSP WEB, BETWEEN BS 541-560 CORRODED. REMOVED CORROSION. FOUND OUT OF LIMITS. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW SRM 51-30-02.SDR DALA14005569235Handle · brokenEXTERIOR TAILCONE PULL RELEASE HANDLE BROKEN. REPAIR ACCOMPLISHED ON NR 124.SDR DALA14005549235Skin · crackedFUSELAGE EXTERIOR SKIN CRACKED AT CANTED FRAME BS 1542. STOP DRILLED CRACK. INSTALLED DOUBLER IAW SRM 53-00-01, FIG 4.SDR DALA14005579248Structure · dentedL1 DOOR HAS A DENT APPROXIMATELY 6 INCHES AT LOWER FWD EDGE. REPAIRED IAW SRM 52-01-01, PAGE 23-29. OK FOR SERVICE.SDR DALA14005539210Cusp Web · corrodedRIGHT CUSP WEB BS 788 - 807 CORRODED. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW SRM 53-20-02.SDR DALA14005529210Seat Track · damagedLBL 32 SEAT TRACK, BS 1152-1193 HAS LIGHT SCRATCHES. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW SEAT TRACK IAW SRM 53-40-01, 51-30-01, AND 51-10-05.SDR DALA14005349236Release Cable · frayedDURING SERVICE CHECK, FOUND TAILCONE RELEASE CABLE FRAYED. R & R CABLE IAW AMM. RIGGED IAW AMM.SDR DALA14005319236Power Supply · malfunctionedDURING SERVICE CHECK, EMERGENCY LIGHTS ILLUMINATE WITH POWER SURGE. R & R OVERWING EMERGENCY LIGHT POWER SUPPLY IAW AMM. OPS CHECKED GOOD.SDR DALA14005339210Bulkhead · corrodedAFT CARGO BAY AFT PRESSURE BULKHEAD WEB FORWARD FACE, HAS CORROSION AT LOWER CENTER DOUBLER. FOUND BEYOND LIMITS IAW SRM 53-00-01. FABRICATED, AND INSTALLED NEW DOUBLER IAW DWG 5910130.SDR DALA14005329236Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT BETWEEN PANELS 221H AND 221JF/LF. INSTALLED NEW FLOOR SUPPORT IAW DWGS 3932140 AND SRM 51-30-01.SDR DALA14008509259Inlet · crackedSEVERAL CRACKS FOUND ON RAM AIR INLET BEYOND SRM REPAIR LIMITS. REPAIRED IAW ERA 522453-14.SDR DALA14006459255Ground Wire · disconnectedDURING SERVICE CHECK, EMERGENCY LIGHT AT SEAT 21AB INOPERATIVE ON STANDBY POWER. TROUBLESHOT AND FOUND GROUND 5244 DISCONNECTED. TERMINATED IAW SWPM. OPS CHECKED NORMAL.SDR DALA14004319201Structure · dentedSMALL DENT ON BOTTOM OF L1 DOOR AT FORWARD LOWER CORNER. REPAIRED IAW SRM 52-01-01. AIRCRAFT OK FOR SERVICE.SDR DALA14005309210Cusp Web · corrodedRIGHT CUSP WEB BETWEEN BS 522-541 HAS CORROSION ON DOUBLER. R & R CORRODED DOUBLER IAW SRM 53-20-02, FIG 10 AND FIG 18.SDR DALA14004299258Skin · crackedFUSELAGE SKIN CRACKED AT BS 1475, 3 INCHES RT OF VERTICAL STABILIZER/TAIL. CUTOUT DAMAGE, INSTALLED DOUBLER, TRIPLER AND LONGERON SPLICE IAW PRI 522196, REV O AND FINAL ERA 5221914, REV O.SDR DALA14004289216Skin · crackedLEFT HORIZONTAL STAB AFT UPPER SKIN PANEL HAS A SURFACE CRACK .25 LONG FROM AFT EDGE. VERIFIED WITH HFEC. REPAIRED IAW ERA 522297-14, REV O.SDR DALA14003199258Frame · crackedCRACKED WEB AT CANTED FRAME BS 953, LBL 23. REPAIRED.SDR DALA14003209232Release Cable · pulledDURING SERVICE CHECK, COCKPIT DOOR RELEASE CABLES PULLED OUT OF DOOR HINGES. MAINTENANCE R & R UPPER AND LOWER COCKPIT DOOR HINGE CABLES IAW AMM. OPERATION CHECKS GOOD.SDR DALA14005559226Skin · puncturedFUSELAGE, SKIN, BS 77, BELOW AOA VANE PUNCTURED.SDR DALA14001279203Connector · damagedDURING SERVICE CHECK, EMERGENCY LIGHTS ON AFT CATWALK FOUND INOPERATIVE. R & R QUICK DISCONNECTORS IAW SWPM. OPS CHECKED GOOD.SDR DALA14001269231Bulkhead · crackedBULKHEAD CRACKED AT BS 37 AT LOWER RT RADOME ALIGNMENT PIN. CUT OUT DAMAGE IAW ERA 483847-14A, REV A. FABRICATED AND INSTALLED REPAIR IAW ERA 483847-14MA, REV A.SDR DALA13072579217Connector · inoperativeDURING SERVICE CHECK, FOUND TAIL COMPARTMENT WALK WAY EMERGENCY LIGHT INOPERATIVE. R & R QUICK DISCONNECTS AT LIGHT ASSEMBLY IAW SWPM. OPS CHECKS GOOD.SDR DALA13072089260Lamp · inoperativeTWO CABIN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED LAMPS. OPS CHECKED GOOD.SDR DALA13072079242Structure · damagedLIGHTNING STRIKE ON FASTENER AFT CORNER OF MID CARGO DOOR. REPAIRED IAW ERA 521840-14, SECTION I, REV O. REF LP 1243580, DTA.SDR DALA1701139209Spar Cap · damagedVERTICAL STAB LEADING EDGE, FRONT SPAR CAP DAMAGED. REPAIRED IAW 5530-01044 SECT 02.SDR DALA13071359233Battery Pack · inoperativeDURING SERVICE CHECK, FOUND OVERHEAD EMERGENCY LIGHTS ROW 35-36 INOPERATIVE. R & R BATTERY PACK IAW AMM. OPERATION CHECKS GOOD.SDR DALA1701149209Spar · crackedWING REAR SPAR CRACKING. REPAIRED IAW 5710-01119,SECT 01/05.SDR DALA13070219265Wedge · damagedLEFT INBD T/E FLAP WEDGE DAMAGED. FABRICATED AND INSTALLED NEW REPAIR DOUBLER IAW SRM 57-00-01.SDR DALA13070209265Wedge · damagedLEFT INBD T/E FLAP WEDGE DAMAGED. REPAIRED IAW ERA 509956-14MA, REV O.SDR DALA13070199209Longeron · corrodedAFT CARGO BAY FS 1379, LONGERON 30 CORRODED. FOUND TO BE OUT OF LIMITS. REMOVED LONGERON NR 30 BETWEEN BS1354 -1382, FABRICATED AND INSTALLED NEW LONGERON AND SPLICE IAW SRM 53-10-01 AND 51-30-05.SDR DALA13069869209Web · corrodedCABIN FLOOR WEB CORRODED BS 160-200, LBL 10- RBL 10. CUT OUT DAMAGED FLOOR WEB. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 51-11-01 AND ERA 520330-14, REV O.SDR DALA13069849209Spacer · corrodedCENTER CARGO DOOR FRAME SPACER CORRODED. REMOVED AND INSTALLED SPACER IAW SRM 53-60-02, FIG 9.SDR DALA13070189209Skin · crackedLT FUSELAGE SKIN AT BS 1531-1542 BELOW AFT STAIRS CUTOUT IS CRACKED. HFEC INSPECTION AREA. FABRICATED AND INSTALLED PERMANENT REPAIR DOUBLER IAW SRM 53-00-01.SDR DALA13069879236Door Frame · crackedLEFT MLG DOOR SURRROUND, CRACKED AT FORWARD ANGLE, JUST AFT OF HYD SERVICE PANEL. CRACK MEASURES APPROXIMATELY 3.25". R & R FRAME IAW SRM 51-00-01.SDR DALA13069059265Skin · damagedLEFT INBD LOWER SKIN AND T/E WEDGE AFT LT FLAP DAMAGED. FABRICATED AND INSTALLED REPAIR IAW PRI 521487-14, REV O.
Back to Boeing MD-90-30