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 DALA1207879236Seat Track · corrodedFWD FLOORS: LT CENTER SEAT TRACK CORRODED BSTA 200-294 IAW SRM 53-40-01 FIG 4 SHEET 1 VOL 1 REV 42.SDR DALA1207869236Seat Track · corrodedFWD FLOORS: LT INBOARD SEAT TRACK CORRODED BSTA 200-275. REPAIRED IAW SRM 53-40-01 FIG 6 SHEET 1 VOL 1 REV 42.SDR DALA1125619213Tail Cone · damagedTAIL CONE T/E LWR END CAP LIGHTNING DAMAGE.SDR DALA1131829224Web · corrodedHMV2 MID CARGO WEB AT DOORWAY STA 673-750 CORRODED. REPLACED WEB PER SRM 51-30-02 AND DRAWING 9940443.SDR DALA1131809224Splice · corrodedHMV2 MID CARGO L29L CORRODED STA 589. REPLACED SPLICE PER ERA 487473-14 REV 0.SDR DALA1125389211Ballast · defectiveFLIGHT DIVERTED INTO SLC DUE TO AN ELECTRICAL ODOR EMANATING FROM THE RIGHT AFT LAVATORY. MAINTENANCE TROUBLESHOT PER MANUAL. RAN PACKS USING ENGINE AND APU AIR. NO ODOR COMING FROM AIR CONDITIONING OUTLETS. FOUND OVERHEATED CEILING LIGHT BALLAST AT ROW 37SDR DALA1207929236Skin · crackedCRACKS ON SKINS AT BSTA 1475 BETWEEN L2LT 7 L2RT REPAIR IAW BOEING MESSAGE HLO HLO-11-0021 10B.SDR DALA1207829236Cusp Web · crackedRT CABIN CUSPS: CUSP PANELS CRACKED BSTA 1344-134 LT SIDE WERE ENGINE WIRING IS LOCATED IAW SRM 53-20-02 SG09530019.SDR DALA1131869224Structure · corrodedHMV2 AFT AIRSTAIR LEFT STEP WALL CORRODED. REPLACED STEP WALL PER SRM 51-10-05.SDR DALA1131839224Cusp Web · crackedHMV2 CUSP WEB CRACKED STA 1134 LBL 54. REPAIRED PER SRM 51-10-03 AND DRAWING SG 09530019.SDR DALA1207919236Skin · dentedDEPRESSION ON FUSELAGE WINDOW BELT AREA AT STA 229-294 L10-L16LT . LARGE DENT ON FUSELAGE.SDR DALA1207809236Attach Angle · crackedVERTICAL STABILIZER TO FUSELAGE ATTACH ANGLE CRACKED AT BSTA 1542-1587. REPAIRED IAW TECHNICAL ORDER PAM-TO-51-10.SDR DALA1141839227Floor Support · corrodedHMV2 FWD CARGO STA 522 RT FLOOR SUPPORT CORRODED. REPAIR PER MD90 SRM 53-00-01.SDR DALA1124139211Fuse · blownDURING LIGHT TEST FIRST CLASS CEILING EMERGENCY EXIT LIGHT WOULD NOT ILLUMINATE. MAINTENANCE TROUBLESHOT AND FOUND BATTERY PACK B5-236 WITH BLOWN FUSE. BATTERY PACK AND EXIT SIGN WAS REPLACED. OPERATION OF LIGHT NOW CHECKS GOOD.SDR DALA1124129211Battery Pack · dischargedDURING LINE CHECK MAINTENANCE FOUND EMERGENCY EXIT OVERWING FORWARD RIGHT SIDEWALL INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR FORWARD LEFT & RIGHT OVERWING EXIT EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-03. OPERATION OF LIGHT NOW CHECKS NORMAL.SDR DALA1124109211Battery Pack · dischargedDURING LINE CHECK MAINTENANCE FOUND EMERGENCY EXIT OVER WING FORWARD LEFT SIDEWALL INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR FORWARD LEFT & RIGHT OVERWING EXIT EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-03. OPERATION OF LIGHT NOW CHECKS NORMAL.SDR DALA1124419224Attach Fitting · corrodedHMV2 RT LWR KEEL BEAM I/B CTR FUEL DRAIN PNEU SUPPORT ROD UPPER ATTACH FITTING CORRODED. REPLACED ATTACH FITTING PER SRM 51-30-05.SDR DALA1124429224Floor Support · corrodedHMV2 MID CARGO COMP FLOOR SUPPORT CORRODED FS 655 LBL 14 TO RBL 14. REPLACED FLOOR SUPPORT PER SRM 51-30-05.SDR DALA1503459228Spar · crackedWING REAR SPAR CRACKED. REPAIRED IAW AA 5710-01119.SDR DALA1503449228Spar Cap · unknownVERTICAL STABILIZER, L/E FRONT SPAR CAP REPAIRED IAW AA 5530-01044.SDR DALA1503409228Lug · unknownHORIZONTAL STABILIZER HINGE RIB PIVOT BEARING LUG REPAIRED IAW AA 5510-01083.SDR DALA1503379228None · nonePYLON AFT SUPPORT FITTING UPPER FASTENERS REPLACED IAW AA 5440-01069.SDR DALA1503369228Frame · unknownBS 883-BS 962 OVERWING FRAMES REPAIRED IAW AA 5310-01375.SDR DALA1503349228Stop Fitting · unknownCARGO DOOR STOP PAD FITTINGS REPLACED IAW AA 5230-01136.SDR DALA1503329228Jackscrew · unknownHORIZONTAL STABILIZER -JACKSCREW ASSY REPAIRED IAW AA 2740-01071.SDR DALA1503299228Unknown · unknownFWD CARGO DOOR REPAIRED IAW EA 02-451701-12.SDR DALA1503269228Jackscrew · unknownHORIZONTAL STABILIZER JACKSCREW REPAIRED IAW EA 02-075254-12.SDR DALA1124439224Skin · corrodedHMV2 FWD CARGO COMP SKIN STA 237-256 BETWEEN L29L-L30 CORRODED. REPLACED INTERNAL ANGLE AND EXTERNAL DOUBLER PER SRM 51-10-03.SDR DALA1124459224Floor Support · corrodedHMV2 MID CARGO FLOOR SUPPORT STA 750 CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-30-05.SDR DALA1122499208Lanyard · disconnectedOPERATIONS REPORTED L-1 DOOR SLIDE BUSTLE RELEASE LANYARD DISCONNECTED. MAINTENANCE RE-SECURED LANYARD PER MAINTENANCE MANUAL. AIRCRAFT OKAY FOR SERVICE.SDR DALA1124469224Frame · crackedHMV2 LT MLG W/W CUTOUT FWD FRAME I/B CORNER CORRODED AND CRACKED. REPLACED FRAME PER SRM 51-30-05.SDR DALA1124449224Doubler · crackedHMV2 LT MLG WHEEL WELL DOOR AFT EDGE DOUBLER CRACKED. REPLACED DOUBLER PER SRM 51-10-03.SDR DALA1124479224Intercostal · corrodedHMV2 FWD CARGO INTERCOSTAL STA 446-427 29R CORRODED. REPLACED INTERCOSTAL PER SRM 51-30-02.SDR DALA1124489224Frame · corrodedHMV2 RT MLG CUTOUT FWD FRAME CORRODED. REPLACED FRAME PER SRM 51-30-02.SDR DALA1500389234Cusp Web · crackedCUSP WEB CRACKED AT BS 1344-1364. REPAIRED IAW SRM 53-20-02, VOL 1, PAR 6.SDR DALA1500379234Skin · dentedDENT ON MID CARGO DOOR BS 718 L22-23R. REPAIRED IAW SRM 53-30-01, FIG 1, SHEET 2.SDR DALA1124509224Intercostal · corrodedHMV2 MID CARGO INTERCOSTAL STA 845 L27L-L28L CORRODED. REPLACED INTERCOSTAL PER SRM 51-30-05.SDR DALA1500449234Skin · crackedFUSELAGE SKIN CRACKED AT BS 1475 AT LONGERON 2L & 2R. REPAIRED IAW TWX HLO-HLO-11-0009-17B - 8100-9.SDR DALA1500369234Attach Angle · crackedATTACH ANGLE CRACKED ON TOP FUSELAGE TO VERTICAL STAB LT AT STA 15230.225 REPAIRED IAW SRM 55.SDR DALA1500359234Cusp Web · crackedCUSP WEB CRACKED. REPAIRED IAW SRM 53.SDR DALA1124599221Intercostal · corrodedHMV2 AFT CARGO INTERCOSTAL CORRODED 1206-1212. REPLACED INTERCOSTAL PER SRM 51-30-05.SDR DALA1118799212Fastener · looseSCREWS ARE LOOSE ON L/E OF VERTICAL STAB. REPAIRED PER EA 02-470871-12 REV A ME-05.SDR DALA1135459220Frame · corrodedHMV STA 1443 LOWER FRAME CORRODED. REMOVED AND REPLACED FRAME IAW SRM 51-10-05 AND SRM 51-30-00.SDR DALA1124569221Floor Support · brokenHMV2 AFT CARGO T-BRACKET STA 1155 BROKEN BETWEEN RBL 16 AND LBL 16. REPLACED FLOOR SUPPORT PER SRM 51-30-02.SDR DALA1124519224Floor Support · corrodedHMV2 MID CARGO FLOOR SUPPORT CORRODED STA 693. REPLACED FLOOR SUPPORT PER SRM 51-30-5.SDR DALA1135449220Intercostal · corrodedHMV SURFACE CORROSION ON INTERCOSTAL FS 1212-1203 LGN 30. REMOVED AND REPLACED CLIPS AND INTERCOASTAL IAW SRM 51-30-02.SDR DALA1118369202Light · inoperativeDURING LINE CHECK, MAINTENANCE FOUND EMERGENCY PATHWAY LIGHTING INOPERATIVE AT ROW 24. MAINTENANCE FOUND PATHWAY NEEDS LIGHT ASSEMBLY AND BULB. FORWARD TO MCO AND PLACARD PER MEL 33-51-01A.SDR DALA1118349211Light · malfunctionedFLIGHT CREW REPORTED ELECTRICAL ODOR EMANATING FROM FORWARD RIGHT GALLEY. THE OVENS WERE OFF SO THE GALLEY POWER WAS THEN TURNED OFF. THE ODOR DISSIPATED SHORTLY THEREAFTER SO THE GALLEY POWER REMAINED OFF FOR REMAINDER OF THE FLIGHT. MAINTENANCE INSPECTED SDR DALA1117629212Light · damagedDURING LINE CHECK, MAINTENANCE FOUND EMERGENCY PATHWAY LIGHT DAMAGED. MISSING LIGHT, HOUSING BROKEN AND WIRE SPLICE SEPARATED. MAINTENANCE SPLICED THE WIRES AND REPLACED THE BULB HOUSING AND THE BULB PER MAINTENANCE MANUAL. OPERATION CHECKS GOOD. AIRCRAFT SDR DALA1116679203Skin · crackedRT HORIZONTAL STABILIZER UPPER SKIN CRACK ERA 490525-14REV ORIG TIME LIMITED REPAIR.
Back to Boeing MD-90-30