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 DALA1241179264Frame · crackedRT AFT CABIN FUSELAGE FRAME TIE CRACKED AT STA 1364 L15R TO L16R. REMOVED AND REPLACED FORMER FROM RT AFT CABIN FUSELAGE AND BULKHEAD WEB AT BS 1364 BETWEEN LONGERONS L13R-L16R IN REF WITH SRM 51-30-05, 51-30-03 VOL II AND DRAWING NR 9912243.SDR DALA1241189264Frame · crackedLT CABIN FUSELAGE FRAME CRACKED AT BS 1364 L15L TO L16L. REMOVED AND REPLACED FRAME BS 1364 BETWEEN L13L-L16L IN REF WITH SRM 51-30-05, 51-30-03 VOL II AND DRAWING 9912243.SDR DALA1241169264Cargo Track · corrodedREMOVED AND REPLACED TIE-DOWN TRACK BETWEEN FS 845-512 FOUND OUT OF LIMITS WITH CORROSION IN REF SRM 51-10-03 AND 53-00-01. FABRICATED AND INSTALLED NEW SPLICE AT FS 720 LT IN REF SRM 53-40-01 VOL I.SDR DALA1245199265Skin · crackedBS 1435 TITANIUM SKIN-CRACKED JUST FWD OF CUT OUT FOR AFT VENTRAL STAIR MANUAL CONTROL. REMOVED AND REPLACED SKIN PER DWG 5911429 AND SRM 51-30-02 VOL II.SDR DALA1241069265Shear Tie · corrodedAFT CARGO BS 1269 STRINGER 29RT SHEAR TIE CORRODED, FOUND OUT OF LIMITS PER REF SRM 53-00-01. REPLACE WITH NEW SHEAR TIE.SDR DALA1241159264Doubler · corrodedMID CARGO COMP ANTENNA DOUBLER BETWEEN FS 769-788 HAS CORROSION. REMOVED AND REPLACED DOUBLER AT FS 769-788 IN REF MD-90 SRM 51-30-02, 51-30-05.SDR DALA1241099264Doubler · corrodedAFT CARGO COMPARTMENT AFT PRESSURE BULKHEAD LOWER ANGLE CORROEDED AT BS 1395 LONGERON 30. REMOVED AND REPLACED DOUBLER AFT PRESSURE BULKHEAD AND TEE EXTRUSION AS PER SRM 53-00-01.SDR DALA1240379258Battery Pack · inoperativeDURING SERVICE CHECK, MAINTENANCE FOUND OVERWING EMERGENCY LIGHTS REMAIN ILLUMINATED WITH SWITCH TURNED OFF. REMOVED AND REPLACED OVERWING BATTERY PACK PER AMM. OPERATION CHECKS GOOD.SDR DALA1240369213Door Frame · crackedRIGHT FORWARD GEAR DOOR FRAME HAS 2.5 INCH CRACK LOCATED JUST BELOW DOOR CLOSED PROXIMITY SENSOR. REMOVED AND REPLACED FRAME PER SRM 53-60-02 AND 51-00-00.SDR DALA1241139264Cargo Track · corrodedMID CARGO COMP LT TIE DOWN TRACK SPLICE BETWEEN FS 598-617 HAS CORROSION. REMOVED AND REPLACED TIE-DOWN SPLICE AT FS 608 IN REF SRM 51-10-03, 51-10-05, 51-30-05 VOL II, 51-40-01 FIG 7 VOL I DWG NR 3936702.SDR DALA1241119264Beam · corrodedBEAM FOUND CORRODED. REMOVED AND REPLACED LOWER BEAM 28R BETWEEN BS 655 THRU 788 AS PER DRAWING NR 5930481 AND PER SRM 51-30-05.SDR DALA1241129264Cargo Track · corrodedFWD CARGO BAY LEFT TIE DOWN TRACK FS 218-512 FRAME ATTACH POINTS AND UPPER, LOWER SURFACE FLANGE CORROSION OUT OF LIMITS IN REF SRM 53-00-01. REMOVED AND INSTALLED NEW TIE DOWN TRACK WITH 2 NEW SPLICES IN REF SRM 53-40-01, 51-30-05 AND 51-30-02. TREATED AND SDR DALA1240319205Battery Pack · inoperativeDURING SERVICE CHECK, MAINTENANCE FOUND 8 OVERHEAD EMERGENCY EXIT LIGHTS INOPERATIVE BETWEEN ROWS 15 AND 23. TROUBLESHOT AND FOUND BATTERY PACK AT ROW 19 BAD. CHANGED BATTERY PACK. OPS CHECKED GOOD.SDR DALA1240159264Gusset · corrodedREMOVED CORROSION AT GUSSETS BS 370 AND 427 IAW SRM 51-10-03 VOL II. FOUND OUT OF LIMITS IN REF SRM53-00-01 VOL I. REMOVED AND REPLACED GUSSETS AT FS 370 AND 427 IN REF SRM 51-30-05 AND DWG NR 5910142.SDR DALA1240169264Web · corrodedBLENDED OUT DAMAGE AND REPLACED WEB IN FWD CARGO COMPARTMENT CUT OUT DOOR FRAME FROM FS 362.5 - 434.5 BETWEEN L29R - L24R IAW SRM NR 51-30-02 VOL II AND DRAWING 3 5910142.SDR DALA1239819253Seat Track · corrodedFOUND LT OUTBD SEAT TRACK BETWEEN BS 1155-1174 IS CORRODED. REPLACED SECTION OF SEAT TRACK FROM BS 1145-1364 IAW SRM 53-40-01 FIG 6 VOL I.SDR DALA1239809253Seat Track · corrodedFOUND LT INBD SEAT TRACK HAS CORROSION BETWEEN BS 1155-1174. REMOVED AND REPLACED SECTION OF SEAT TRACK 1145-1364 IAW SRM VOL I 53-40-01 FIG 6.SDR DALA1239799253Seat Track · damagedFOUND MAIN CABIN BS 218-589 RBL44 SEAT TRACK HAS DEEP CORROSION AND GOUGES. REMOVED CORROSION AND BLENDED OUT GOUGES ON RBL44.5 SEAT TRACK IAW SRM VOL II 51-10-03 PARA 26. FOUND SEAT TRACK TO BE WITHIN LIMITS IAW SRM VOL I 53-40-01 FIG 4,. REMOVED DAMAGE SEATSDR DALA1239789253Seat Track · corrodedFOUND PAX CABIN FWD ENTRY BS 200 RBL 22 SEAT TRACK HAS PITTING CORROSION. REPLACED SECTION OF SEAT TRACK FROM BS 200-465 RBL 22 IAW SRM 53-40-01 FIG 6 VOL I.SDR DALA1239759253Seat Track · gougedFOUND MAIN CABIN SEAT TRACK LBL 24 HAS GOUGED SCALLOPS BS 218-560. REMOVED AND REPLACED SECTION OF SEAT TRACK FROM BS 200-334 IAW SRM 53-40-01, FIG 6, VOL I STA 300-560 FOUND TO BE WITHIN LIMITS IAW SRM 53-40-01 FIG 4.SDR DALA1239749253Tee Fitting · corrodedFOUND BS 1437 TEE FITTING RT SIDE OF APU DUCT IS CORRODED. REMOVED AND REPLACED TEE FITTING FRAME IAW SRM 51-30-02 AND 51-30-05 VOL II.SDR DALA1239729253Bulkhead · corrodedFOUND AFT PRESSURE BULKHEAD FWD FACE LOWER CHORD DOUBLER HAS CORROSION FROM L29L TO L29R. LOWER CHORD DOUBLER FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01 FIG 3 VOL I. REMOVED AND REPLACED LOWER CHORD DOUBLER IAW SRM 51-10-05 AND 51-30-05 VOL II.SDR DALA1243629264Intercostal · corrodedMID CARGO COMPARTMENT, GUSSETS AND INTERCOSTAL BETWEEN BS 750-757.5 AND L30-L29R HAVE CORROSION. REMOVED AND REPLACED INTERCOSTAL AND GUSSETS PER 51-30-02 VOL II, 53-00-01 VOL I, 51-10-01 VOL II, 51-10-02 VOL II, AND 51-10-03 VOL II.SDR DALA1243619264Floor Support · corrodedFWD CARGO COMPT, SMALL FLOOR SUPPORT BRACKETS AT STA 427 AND 370 BETWEEN L28-29R HAVE SURFACE CORROSION. REMOVED AND REPLACED FLOOR SUPPORTS PER SRM 51-30-05 AND 51-30-02.SDR DALA1240339202Tire · failedNUMBER 2 MAIN LANDING GEAR TIRE BLEW ON ROTATION. INNER LOWER LEFT WING BUTT DOOR WAS RIPPED OFF LEFT WING. LEFT MAIN LANDING GEAR ANTI-SKID AND GROUND PROXIMITY HARNESS DAMAGED. EVIDENCE OF TIRE INGESTION IN LEFT ENGINE.SDR DALA1240149264Frame · corrodedAFT ACCY LOWER FRAME SECTION BS 1437 LBL 16 TO RBL 16 HAS CORROSION ON AFT SIDE OF TEE CAP ALSO FUSELAGE SKIN JUST AFT HAS BARE SPOTS. REMOVED CORROSION, FOUND OUT OF LIMITS. REMOVED FRAME SECTION LOCATED AND DRILLED NEW FRAME, TREATED AND PRIMED SKIN AND FRASDR DALA1239659253Cargo Track · corrodedFOUND AFT CARGO COMPARTMENT BS 1064 TO 1307 LT CARGO TRACK HAS DEEP CORROSION BLEND OUTS THROUGHOUT ITS FULL LENGTH. REPLACED SECTION ON CARGO TRACK AND SPLICE REPAIR IAW SRM 53-40-01, FIG 7 VOL 1.SDR DALA1239649253Beam · corrodedFOUND AFT PIT LOWER DOOR JAMB INBOARD HEADER BEAM FROM STA 1193-1290 HAS AREAS OF CORRSION L29R MRB 53-123-02. REMOVED AND EXISTING INBD HEADER BEAM AND INSTALLED NEW HEADER BEAM IAW DWG 5930483 REV AK.SDR DALA1239619253Longeron · corrodedFOUND AFT CARGO COMPARTMENT L30 CORRODED AT BS 1250. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER ER/A 501868-14 REV ORIG.SDR DALA1243609264Gusset · corrodedMID CARGO BAY GUSSET FROM BS 757 BETWEEN L27-30R CORRODED AND HOLE ELONGATED. REMOVED AND REPLACED GUSSET PER DWG 5936039, SRM 51-30-05 VOL II, 51-10-03 VOL II, AND 53-00-01 FIG 3 VOL I.SDR DALA1243369264Channel · damagedREMOVED AND REPLACED INTERCOSTAL CHANNEL AT STA 674 BETWEEN L-28R - L29R IN REF DRAWING 9936577.SDR DALA1240119264Bracket · corrodedAFT CARGO BS 1250 BRACKET FOR LEFT TIE DOWN TRACK, UNDER TRACK, IS CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS. LOCATED AND DRILLED NEW BRACKET AT STA 1250 P/N 3936595-517. INSTALLED NEW BRACKET REF MD-90 SRM 51-10-05 AND 51-30-05.SDR DALA1240109264Web · corrodedLOWER DOOR FRAME CORRODED. REMOVED AND INSTALLED NEW PANEL SECTION AT FWD CARGO BAY LOWER DOOR FRAME BETWEEN BS 370 AND 427 IAW SRM 53-60-02 VOL I FIGURE 11.SDR DALA1241109264Floor Support · corrodedFLOOR SUPPORT AT BS 1212 HAS CORROSION TOP AND BOTTOM. REMOVED CORROSION FOUND OUT OF LIMITS LOCATED AND DRILLED NEW FLOOR SUPPORT TOP COATED NEW FLOOR SUPPORT. INSTALLED NED FLOOR SUPPORT IAW SRM 51-30-2 VOLUME II.SDR DALA1241059265Seat Track · corrodedPITTING CORROSION ON SEAT TRACK BS 237 TO 256. REMOVED DAMAGED AREA AND REPLACE WITH NEW SPLICED SECTION PER SRM 53-40-01 VOL I FIG 6.SDR DALA1241149264Frame · corrodedAFT CARGO BAY BS 1307 FRAME CORRODED BETWEEN LONGERON 28 RT AND LONG 28 LT. REMOVED CORROSION FOUND OUT OF LIMITS CUTOUT DAMAGED AREA. FABRICATED FRAME REPAIR TREATED PRIMED AND TOP COAT ALL PARTS. INSTALLED FRAME REPAIR. REF DWG SR09530057.SDR DALA1238549265Seat Track · corrodedCORROSION ON SEAT TRACK AT BS 221, LBL 44.5. REMOVED AND REPLACED SEAT TRACK AT BS 200-228 LBL44.5 PER SRM 53-40-01 VOL I FIG 6.SDR DALA1238479264Intercostal · corrodedE/E BAU INTERCOSTAL BETWEEN FS 160-180 AT L28L HAS CORROSION. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-30-02 VOL II, 53-00-01 VOL I, 53-10-01 VOL III, AND 51-10-03 VOL II.SDR DALA1238499264Seat Track · corrodedCORROSION AT SEAT TRACK RBL 44 BS 200 INBD EDGE LWR SURFACE. REMOVED CORRODED SECTION FROM BS 200-246 AND INSTALLED REPAIR SPLICE PER SRM 53-40-01 FIG 6 VOL I.SDR DALA1238019264Stringer · corrodedE/E COMPARTMENT STRINGER 29L STA 160-200 HAS SPOTS OF CORROSION. REPAIRED PER 53-10-01 FIG 7 ON NR 1000/419/1016165.SDR DALA1237999264Longeron · corrodedE/E COMPARTMENT L 28 FS 170-180 HAS SPOTS OF CORROSION. REPAIRED PER SRM 53-10-01 FIG 7.SDR DALA1237979264Longeron · corrodedE/E COMPARTMENT L30 FROM FS 160 - 200 HAS SPOTS OF CORROSION. REPAIRED LONGERON PER SRM 53-10-01-FIG 7 ON NR 1000 10417 1016163.SDR DALA1237679256Beam · corrodedFOUND AFT CARGO BAY BS 1212-1269 L28R LOWER DOOR FRAME HEADER BEAM IS CORRODED. REMOVED AND REPLACED HEADER BEAM IAW SRM 51-30-05 VOL II AND DWG 5936038-501.SDR DALA1237669256Beam · corrodedFOUND MID CARGO BAY BS 693-750 L28R LOWER DOOR FRAME HEADER BEAM IS CORRODED. REMOVED DAMAGED JAMB HEADER BEAM, LOCATED, DRILLED AND INSTALLED NEW HEADER BEAM IAW SRM 51-10-05, 51-30-02, 51-30-01, 51-30-05 VOL II AND DWG 5930481.SDR DALA1237659256Bulkhead · corrodedFOUND AFT PRESSURE BULKHEAD FWD FACE AT BOTTOM, Y CHORD DOUBLER CORRODED BETWEEN L28L - L29R BS 1395. REMOVED DAMAGED Y-CHORD DOUBLER, LOCATED AND DRILLED NEW DOUBLER AND INSTALLED DOUBLER IAW SRM 51-30-02 VOL II, SRM 51-30-05 VOL II, SRM 51-10-05 VOL II AND SDR DALA1510059254Fitting · galledVERTICAL STABILIZER AFT LT OTBD ATTACH FITTING F, OR HORIZONTAL STABILIZER HAS GALLING. REPAIRED ON N/R CARD 24519 3300 0043, ENLARGED BORE TO 1.453 TO REMOVE DAMAGE IAW SRM 55-, 30-05. INSTALLED BUSHING.SDR DALA1237969254Fitting · galledVERTICAL STABILIZER AFT LEFT OUTBOARD ATTACH FITTING FOR HORIZONTAL STABILIZER HAS GALLING. ENLARGED BORE TO 1.453 TO REMOVE DAMAGE PER SRM55-30-05. INSTALLED BUSHING ON NRC 24519-3300-0043.SDR DALA1237889219Slide · wrong partTAILCONE SLIDE FOUND TO BE INCORRECT, REMOVED AND REPLACED TAILCONE SLIDE PER OPN 7008.SDR DALA1241079265Seat Track · corrodedSEAT TRACK CORRODED BS 1262. REMOVED AND REPLACED SEAT TRACK FROM BS 1146 TO 1280.SDR DALA1238029264Cusp Web · corrodedCABIN LT SIDE CUSP WEB AT BS 1193 TO 1235 HAS CORROSION. REPAIRED PER SRM 53-20-02-FIG 26 CONFIG 7041 VI NR 1015731.
Back to Boeing MD-90-30