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 DALA13034739206Seat Track · corrodedMAIN CABIN BS 207+6 TO 216+10, RBL 55, SEAT TRACK INBD AND OTBD UPPER FLANGE HAS MULTIPLE AREAS OF CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED AND REPAIRED SEAT TRACK FROM STA 207 TO 266, RBL 55 IAW SRM 53-40-01, FIG 6 AND SRM 51-30-0SDR DALA13035309206Cusp Web · corrodedRIGHT CABIN CUSP WEB CORRODED, BS 522-532. CUTOUT CORROSION. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 51-10-03, 53-00-01, 53-20-02 AND AMM.SDR DALA13037149206Floor Support · corrodedFORWARD WET AREA, FLOORBOARD SUPPORT HAS CORROSION AROUND SCREW HOLE AREA ON UPPER AND LOWER FLANGE SURFACE. TASK 53-211-01. R & R FLOORBOARD SUPPORT IAW SRM 51-30-02 AND 51-30-05.SDR DALA13034759205Skin · corrodedSECTION I OF ERA 516023-14 ISSUED TO REPAIR CORROSION ON CENTER WING SECTION UPPER SKIN AT BS 955 BETWEEN LBL 42 & 60. ACCOMPLISH SECTION II REPETITIVE INSPECTION EVERY 24 MONTHS STARTING 02JUL13.SDR DALA13034749205Casting · gougedELEVATOR AND TAB MECHANISM INSTALLATION, BS 1160, RBL6, 5" BELOW FLOOR LEVEL, CASTING IS GOUGED. REPAIRED IAW PRI ERA 51603-14, REV O AND FINAL ERA 516031-14.SDR DALA13034729206Structure · crackedAFT CARGO BAY DOOR, AFT EDGE, 1ST FROM TOP STOP PAD FITTING, IS CRACKED AND LOOSE. INSTALLED AFT CARGO DOOR AFT UPPER EDGE TOP STOP PAD FITTING IAW SRM 51-10-05, FIG 1 AND FIG 4 AND OM 52-30-1, FIG 1 SHEET 5 (T).SDR DALA13034719247Skin · corrodedHORIZONTAL STABILIZER LOWER SKIN BARREL NUT HOLE ID 55 IS CORRODED. TASK 55-113-03. REMOVED BARREL NUT. REMOVED CORROSION. REAMED HOLE IAW SRM 55-10-03, FIG 15. FABRICATED BUSHING AND INSTALLED. INSTALLED BOLT THROUGH REPAIR IAW SRM 51-30-01. IDENTIFIED SDR DALA13034799205Bellcrank · gougedELEVATOR BELLCRANK ARM IS GOUGED, BS 1165, RBL 12, THREE INCHES BELOW FLOOR LEVEL. REPAIRED BELLCRANK IAW PRI ERA 516029-14, REV O AND FINAL ERA 516031-14, REV O.SDR DALA13037629206Web · damagedFORWARD WET AREA FLOOR WEB IN FRONT OF SERVICE DOOR CORRODED BETWEEN FS 195 - 200 RBL 45 & 53. REMOVED DAMAGE, REPAIRED IAW SRM 51-11-01 AND 51-30-02.SDR DALA13035379206Web · corrodedFORWARD WET AREA, FLOOR WEB IN FRONT OF SERVICE DOOR, CORRODED, BETWEEN BS 195 AND 200, RBL 45 - 53. REMOVED DAMAGE, REPAIRED IAW SRM 51-11-01 AND 51-30-02.SDR DALA13034969201Wire · brokenF/A REPORTS STRONG ELECTRICAL BURNING ODOR IN AFT OF ACFT. RETURN TO BLOCKS. MX FOUND SIDEWALL LIGHT DIMMER SWITCH WITH BROKEN TERMINAL AND WIRE. MX SECURED BROKEN WIRE TO SWITCH AT AFT F/A PANEL IAW AMM. CHECKED OK.SDR DALA13034339246Power Supply · inoperativeDURING SERVICE CHECK, AFT EMERGENCY LIGHTS FOUND BLINKING. R & R AFT EMERGENCY LIGHTS POWER SUPPLY IAW AMM.SDR DALA13034319205Structure · bentAFT CARGO DOOR LOWER INBD EDGE IS BENT BS 1225-1260. STRAIGHTEND EDGE IAW SRM 52-01-01, PARA 8C, ERA 516038-14 REV O.SDR DALA13034309239Skin · damagedL1 DOOR LOWER FORWARD OUTER SKIN DAMAGED. RETURNED TO ORIGINAL CONTOUR AND INSPECTED DOOR HINGES AND HARDWARD. NO DAMAGE TO HARDWARE OR HINGES. NO CRACKS OR FASTENERS DAMAGED. WORK DONE IAW SRM 52-01-01.SDR DALA13034299206Seat Track · corrodedF/O OTBD SEAT TRACK AFT CORNER HAS CORROSION. COMPLIED WITH ERA 51601-14, REV O AND PRI ER/A 516041-14, REV O.SDR DALA13034329260Bulb · contaminatedF/A REPORTED PLASTIC BURNING ODOR ON FINAL IN FORWARD RT GALLEY. MX FOUND WIRE TAG MELTED TO WORK LIGHT BULB IN RT GALLEY. REPLACED CEILING LIGHT. OPS CHECKED GOOD. NO ODOR NOTED.SDR DALA13034269247Structure · damagedRIGHT HORIZONTAL STABILIZER CENTER BOX 01B JOINT AT STA XH.26 UPPER SURFACE HAS 1 EA BARREL NUT HOLE WITH CORROSION. REMOVED CORROSION, REAMED HOLE, INSTALLED BUSHING 1 EACH ON BARREL NUT HOLE IAW SRM 55-10-03, FIG 15, PARA D, 51-10-03 AND 51-20-00.SDR DALA13034259247Skin · damagedRT HORIZONTAL STABILIZER CENTER BOSS UPPER SURFACE INBD JOINT HAS 3 EA BARREL NUT SEALER PLUG LOOSE. CORROSION FOUND 1 EACH BARREL NUT HOLE. REMOVED CORROSION, REAMED HOLE, INSTALLED BUSHING ON 1 EACH BARREL NUT HOLE IAW SRM 55-10-03 FIG 15, PARA D, 51-20-00SDR DALA13035329205Support Fitting · out of limitsRIGHT MLG RETRACT ACTUATOR SUPPORT FITTING INBD BORE IS OVER 2.2755 RE-WORK LIMIT IAW 5740-01140-0201. REPAIRED RT MLG BUSHING IAW PRI ERA 51490-14AD, REV O AND FINAL ERA 514904-14AD, REV O.SDR DALA13035069258Light · overheatedFLIGHT CREW REPORTED READING LIGHT AT 28A OVERHEATING AND STRONG BURNING PLASTIC ODOR. MX R & R LIGHT ASSY 28A IAW AMM. OPS CHECKS OK.SDR DALA13034289205Pulley Bracket · wornRIGHT HORIZONTAL STABILIZER ANTI-FLOAT TAB PULLEY BRACKET WORN. REPAIRED IAW PRI ERA 514894-14, REV O AND ERA 514894-14, REV O.SDR DALA13034279205Support Fitting · damagedRIGHT MLG RETRACT ACTUATOR SUPPORT FITTING BORE IS OVER 1.5260 REWORK LIMIT IAW 5740-01140-0201. REPAIRED IAW PRI ERA 514907-14AD, REV O.SDR DALA13034239205Mechanism · gougedRIGHT HORIZONTAL STABILIZER L/E FLOAT TAB MECHANISM GOUGED. REPAIRED IAW ERA 514984-14, REV O AND FINAL ERA 514894-14, REV O.SDR DALA13034229206Cargo Track · corrodedCARGO TRACK CORRODED, BS 1269-1307, TASK 53-302-07. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R CARGO TRACK IAW SRM 51-30-01 AND 53-40-01, FIG 7, PG 40, 47.SDR DALA13034219206Seat Track · corrodedSEAT TRACK AT RBL 56 HAS CORROSION FROM FS 757+6 TO FS 769. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R SEAT TRACK IAW SRM 53-40-01, 51-10-03, 51-10-05 AND 53-42-01-020-801.SDR DALA13034209205Door Frame · corrodedE & E COMPARTMENT INTERIOR DOOR FRAME LONGERON 28R LIGHTENING HOLE HAS CORROSION. REPAIRED CUTOUT IAW ER/A 516026-14, REV O.SDR DALA13034199206Shear Tie · corrodedFORWARD CARGO BAY, SHEAR TIE FOR FS 408 BETWEEN LONGERONS 29-30R HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R SHEAR TIE IAW SRM 53-10-02.SDR DALA13034179206Skin · corrodedDOME NUT MATING SURFACES IN THE AFT CARGO BAY, CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPAIRED DAMAGE IAW SRM 53-30-01, PARA II, 51-10-03 PARA 26, PROCESS STANDARD 900-5-1, NR 4.SDR DALA13034169206Seat Track · corrodedBS 237, RBL 45, SEAT TRACK CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R SEAT TRACK BS 200 -247, IAW SRM 51-30-05.SDR DALA13038559206Cusp Web · corrodedRIGHT CABIN CUSP WEB CORRODED BS 474, TASK 53-211-02. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE PARTS AND INSTALLED REPAIR PARTS IAW SRM 51-30-02.SDR DALA13034249205Bracket · gougedLEFT HORIZONTAL STABILIZER FLOAT TAB BRACKET GOUGED. REPAIRED IAW ERA 514894-14, REV O.SDR DALA13033889247Skin · crackedRT HORIZONTAL STABILIZER UPPER AFT SKIN CRACKED. REMOVED DAMAGED SKIN, LOCATED AND DRILLED NEW SKIN SECTION, SPLICES AND DOUBLER. INSTALLED IAW DWG SR 90550000 AND DELTA W/E 5510-01090-06.SDR DALA13033929205Attach Bracket · corrodedAFT CARGO BAY DOOR FRAME BS 1269, HAS CORROSION ON FORWARD SIDE OF LOWER CORNER ABOVE THERSHOLD PLATE ATTACH BRAKET. TASK 53-123-02. REMOVED CORROSION FROM CORNER ATTACH BRACKET. FOUND TO BE OUT OF LIMITS. INSTALLED NEW BRACKET IAW SRM 51-30-02 AND 51-30-05SDR DALA13033959225Lamp · inoperativeRT WING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP IAW AMM. OPS CHECKED GOOD.SDR DALA13033949205Floor Support · corrodedCABIN FORWARD WET AREA FLOOR STRUCTURE LT SIDE BS 200 LBL 57, FLOOR SUPPORT CORRODED. TASK 53-211-01. BLENDED ANGLES BEYOND LIMITS. R & R FLOOR SUPPORT IAW SRM 51-30-02, 51-30-05, 51-30-08 AND DWG 9910078.SDR DALA13033939205Floor Support · corrodedAFT LAVATORY AREA BS 1364 RBL 15 FLOOR SUPPORT HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R FLOOR SUPPORT IAW SRM 51-30-05.SDR DALA13033899205Skin · corrodedRT SIDE FORWARD WING TO BODY, UNDER THE FAIRING LOWER AREA ON FUSELAGE SKIN STA 830, CORROSION AROUND FASTENER HOLE. CUTOUT DAMAGED AREA AND INSTALLED DOUBLER AND TRIPLER IAW SRN 53-30-01.SDR DALA13039609206Shear Tie · corrodedAFT CARGO, FRAME SHEAR TIE HAS CORROSION BS 1344 LONGERON 28L - 28R. AFTER REPLACEMENT OF THE SHEAR TIE, THERE ARE SEVERAL FASTENERS INSTALLED INCORRECTLY ORIGINAL LP 0971305. REPLACED OR SHAVED RIVETS IAW SRM 51-30-02.SDR DALA13033699205Frame · crackedPASS CABIN BS 480 BETWEEN STR 8 AND 9L FRAME CRACKED. REPAIRED FRAME IAW PRI ERA 516030-14AD, REV O.SDR DALA13033689205Frame · crackedPASSENGER CABIN BS 440 FRAME BETWEEN STR 8 AND 9L CRACKED. REPAIRED FRAME IAW ERA 516030-14AD, REV O.SDR DALA13033679205Frame · crackedPASSENGER CABIN BS 440 BETWEEN S8 AND 9R FRAME CRACKED. REPAIRED FRAME IAW ERA 516030-14AD, REV O.SDR DALA13033669205Frame · crackedPASSENGER CABIN BS 480 BETWEEN STR 8 AND 9 RIGHT FRAME CRACKED. REPAIRED FRAME IAW ERA 516030-14AD, REV O.SDR DALA13033659236Skin · crackedUPPER RT AFT HORIZONTAL STAB SKIN PANEL CRACKED. COMPLIED WITH ERA 516568-14AD, REV O.SDR DALA13033969235Terminal · damagedEXTERIOR EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK AND CONTROLLER IAW AMM 33-51-03. REPAIRED DAMAGED TERMINAL. OPS CHECKED GOOD.SDR DALA13033259205Intercostal · damagedMAIN CABIN INTERCOSTAL FROM BS 1344-1364, BL 0 CRACKED ON THE TOP FLANGE. R & R DAMAGED INTERCOSTAL IAW SRM 51-70-01, PG 2.SDR DALA13033209205Strap · corrodedPASSENGER CABIN FWD WET AREA FLOOR STRUCTURE RT SIDE BS 160 -200 RBL 54 THRESHOLD STRAP CORRODED. TASK NR 53-211-01. R & R OUT OF LIMITS STRAP AND FILLER AT R1 DOOR FLOOR IAW SRM 53-00-01 AND DWG 9957828.SDR DALA13033729245Light · missingFLIGHT CREW REPORTED EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. MX REPLACED 20" OF MISSING LIGHT IAW MM.SDR DALA13033229206Fitting · crackedAFT CARGO COMPARTMENT DOOR, FORWARD EDGE TOP DOOR STOP FITTING IS CRACKED AND PAD IS LOOSE IN FITTING. R & R AFT CARGO COMPARTMENT DOOR FORWARD EDGE TOP DOOR STOP FITTING IAW SRM 51-30-05, PARA 7 AND PARA 8, VOL II.SDR DALA13033219206Fitting · crackedAFT CARGO COMPARTMENT DOOR, FORWARD EDGE 2ND FROM BOTTOM DOOR STOP FITTING IS CRACKED AND PAD IS LOOSE. R & R AFT CARGO COMPARTMENT DOOR, FORWARD EDGE 2ND FROM BOTTOM DOOR STOP FITTING IAW SRM 51-30-05, PARA 7 AND PARA 8, VOL II.SDR DALA13033199205Cusp Web · corrodedPASSENGER CABIN, LT CUSP WEB, BS 1231-1250 HAS CORROSION AROUND LIGHTNING HOLE TASK 53-211-02. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPAIRED CUSP WEB IAW SRM 53-20-02.
Back to Boeing MD-90-30