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 DALA1135439220Skin · corrodedAFT CARGO COMPT SURFACE CORROSION AROUND DRAIN VALVE SKIN FASTENERS L30 FS 1344. REPAIRED SKIN WITH 0.071 DOUBLER AND INTERNAL FINGER DOUBLER IAW SRM 53-30-01 FIG 1 VOL1.SDR DALA1117729221Floor Support · corrodedHMV2 FLOOR SUPPORT CORRODED STA 788. REPLACED SUPPORT PER SRM 51-30-02.SDR DALA1124709221Longeron · corrodedHMV2 MID CARGO 655 L30 CORRODED. REPLACED SPLICE PER SRM 53-00-01.SDR DALA1117769221Splice · corrodedHMV2 MID CARGO STA 655 L29L FASTENERS AND SPLICE CORRODED. REPLACED SPLICE AND FASTENERS PER SRM 53-00-01 51-30-00.SDR DALA1124699221Frame · wornHMV2 AFT ASSY COMP FRAME 1437 LT WORN. REPAIR PER SRM 53-00-01.SDR DALA1117789221Frame · corrodedHMV2 AFT BILGE AREA STA 1231 HAS CORROSION ON FRAME. REPAIR PER SRM 53-10-02 FIG 3.SDR DALA1124689221Skin · crackedHMV2 RT MLG DOOR OUTER SKIN CRACKED. INSTALLED NEW REPAIR PER SRM 51-30-02.SDR DALA1117709221Intercostal · corrodedHMV2 INTERCOSTAL STA 826-845 CORRODED BETWEEN L27R AND L28R. REPLACED INTERCOSTAL PER SRM 51-30-02.SDR DALA1117699221Longeron · crackedHMV2 L20R CRACKED STA 1060. REPAIR PER SRM 51-10-03 AND DRAWING SG09530021.SDR DALA1145979202Skin · damagedFUSELAGE RT SKIN TAIL SECTION FS 1494, L-2R TO L-3R REPAIRED IAW ERA 487196-14.SDR DALA1146089202Skate Angle · damagedFUSELAGE RT DORSAL TO FUSELAGE ATTACH SKATE ANGLE SPLICE REPAIR PER ERA 487528-14.SDR DALA1146079202Skate Angle · damagedFUSELAGE LT DORSAL TO FUSELAGE ATTACH SKATE ANGLE SPLICE REPAIR PER ERA 487507-14.SDR DALA1033869207Duct · delaminatedRT ENGINE FIRE DET FAULT ON CLIMBOUT. RETURNED TO DEPARTURE, OVERWEIGHT LANDING. LOWER T/R C DUCT WAS FOUND DELAMINATED AND COMING APART IN THE COLD STREAM AREA. 7TH STAGE BLEED VALVE SOLENOID WAS REPLACED. LOWER COWL/ T/R ASSY WAS ALSO REPLACED.SDR DALA1117679221Intercostal · crackedHMV2 AFT FUSELAGE INTERNAL LT SIDE BETWEEN CANT 1531.604 AND 1542.019 AT STR L19 INTERCOSTAL CRACKED. REPAIR PER SRM 51-70-01.SDR DALA1124659221Cargo Track · corrodedHMV2 MID CARGO RT TIE DOWN RAIL CORRODED STA 522-845. REPLACED RAIL PER SRM 51-30-01.SDR DALA1117689221Longeron · crackedHMV2 LT LONGERON 20L CRACKED STA 1060. REPAIR PER SRM 51-10-03 AND DRAWING SG09530021.SDR DALA1032799204Wire · damagedDURING LINE CHECK MAINTENANCE FOUND EMERGENCY PATH LIGHT AT SEAT 1C INOPERATIVE. MAINTENANCE RE-TERMINATED THE WIRES AND OPERATION OF LIGHT NOW CHECKS OK. (2010-D1376) (DLM90103210)SDR DALA1124639221Longeron · corrodedHMV2 AFT CARGO L30 STA 1395-1379 CORRODED. REPAIR PER SRM 53-10-0.SDR DALA1034259202Skin · crackedA CRACK WAS FOUND ON THE 5911432-81 SKIN PANEL AT STA 1475 BETWEEN LONGERON 2 LT AND 3 LT SKIN IS 2024-T3 (DLM90103296)SDR DALA1124669221Floor Support · corrodedHMV2 FLOOR SUPPORT CORRODED STA 1212 IN AFT CARGO. REPLACED SUPPORT PER SRM 51-30-02.SDR DALA1124619221Beam · corrodedHMV2 L29R CORRODED AT STA 1193-1202. REPLACED BEAM PER SRM 51-30-01.SDR DALA1124589221Beam · corrodedHMV2 AFT CARGO L29R BEAM CORRODED. REPLACED BEAM PER SRM 51-30-05.SDR DALA1124579221Floor Support · corrodedHMV2 AFT CARGO FLOOR SUPPORT CORRODED STA 1212-1218 RBL 8. REPLACED FLOOR SUPPORT PER SRM 51-30-02.SDR DALA1124559221Attach Bracket · corrodedHMV2 EPC ACCESS PANEL LWR ATTACH BRACKET CORRODED. REPLACED BRACKET PER SRM 51-30-02.SDR DALA1124549221Cargo Track · corrodedHMV2 AFT CARGO TIE DOWN RAIL CORRODED STA 1146-1212 RT. REPLACED TIE DOWN RAIL PER SRM 51-30-01.SDR DALA1124539221Cargo Track · crackedHMV2 FLOOR SUPPORT TIE DOWN RAIL IN AFT CARGO STA 1146-1064 CRACKED. REPLACE TIE DOWN TRACK PER SRM 51-30-01.SDR DALA1124529221Floor Support · corrodedHMV2 AFT CARGO FLOOR SUPPORT CORRODED STA 1231. REPLACED FLOOR SUPPORT PER SRM 51-30-01.SDR DALA1117799221Intercostal · corrodedHMV2 AFT BILGE AREA 5 EACH INTERCOSTALS ABOVE STR 30 CORRODED AT STA 1274-1288 1288-1307 1326-1344 1269-1274, 1307-1326. REPLACED INTERCOSTALS 1274-1288, 1288-1307, 1307-1326, 1326-1344 PER SRM 51-30-05, INTERCOSTAL 1269-1274 FOUND WITHIN LIMITS PER SRM 53-0SDR DALA1117669221Skin · corrodedHMV2 AFT BILGE SKIN SPLICE CORRODED STA 1241 26L-29R. REPLACED SPLICE PER SRM 51-30-02.SDR DALA1117659221Splice · corrodedHMV2 STR 29L SPLICE AT STA 1136-1156 CORRODED. REPLACED SPLICE PER SRM 51-30-05.SDR DALA1117649221Support Angle · corrodedHMV2 RT WHEEL WELL AFT OF DOOR HINGE SUPPORT ANGLE CORRODED. REPLACED ANGLE PER SRM 51-10-05.SDR DALA1124609221Frame · corrodedHMV2 FRAME CORRODED STA 1212 L28L AND L28R. REPLACED NEW FRAME PER SRM 51-30-05.SDR DALA1117639221Doubler · crackedHMV2 RT MLG DOOR INNER SURFACE O/B AFT CORNER REPAIR CRACKED. REPLACED DOUBLER PER SRM 51-10-05.SDR DALA1034299202Skin · crackedA CRACK WAS FOUND IN LONGERON 2 LT AT STA 1475. THIS CRACK FOUND DURING INSP OF TAIL AREA, AFTER FINDING FUSELAGE SKIN CRACKS AT STA 1494 BOTH LT AND RT SIDES. A NEW SECTION OF LONGERON WAS FABRICATED AND A SPLICE MADE IAW ERA.SDR DALA1034289202Skin · crackedA CRACK WAS FOUND UNDER THE PREVIOUSLY INSTALLED DOUBLER AT STA 1475 LONGERON 1 AND 2 RT. NEW CRACK WAS TRIMMED OUT AND DOUBLER ENLARGED TO REPAIR BOTH SKIN CUT-OUTS.SDR DALA1034279202Skin · crackedTHE RT AFT FUSELAGE SKIN AT STA 1494 ABOVE LONGERON 3 RT AND JUST BELOW THE VERT STAB SKATE ANGLE WAS FOUND CRACKED. LENGTH OF CRACK APPROX 3.5 ". A REPAIR DOUBLER AND STRUCTURAL SHIM WERE INSTALLED.SDR DALA1034269202Skin · crackedTHE LT SKIN AT STA 1494 BETWEEN LONGERON 2LT AND 3LT WAS FOUND CRACKED APPROX 3" LONG. DURING INSP IAW ERA 487106-14. DURING OPEN HOLE INSP MORE CRACKS WERE DETECTED AND A SECTION VERT STAB SKATE ANGLE WAS REMOVED. FINAL TRIM-OUT SIZE 4.3" X 5"A .063" DOUBLSDR DALA1027789201Wire · brokenDURING LINE CHECK MAINTENANCE FOUND EMERGENCY LIGHT AT ROW 24 INOPERATIVE. MAINTENANCE REPAIRED A BROKEN WIRE AT ROW 24. OPERATION OF THE LIGHT NOW CHECKS GOOD. (2010-D1248) (DLM90102853)SDR DALA1157699229Frame · corrodedSTA 1379 L27-29RT AFT CARGO COMPARTMENT FRAME REPAIRED IAW SRM 53-10-02 VOL I FIGURE 2_(TO 80).SDR DALA1157689229Skin · corrodedSTA 769-788 L28-29 RT SKIN REPAIR IAW SRM 53-30-01 VOL I FIG 9 PARA 11_(TO 79).SDR DALA1157679229Seat Track · corrodedSTA 200-237 MID SEAT TRACK GALLEY ATTACH POINTS SPLICE REPAIR IAW SRM 53-40-01 VOL I FIG 6_(TO 58).SDR DALA1157669229Attach Angle · crackedSTA 1542 CANT, DORSAL FIN ATTACH ANGLE REPAIRED IAW BAC TWX BNI-BNI-10-168-01C DWG SR09530296 S/B MD90-53-027 R2(TO 57).SDR DALA1157659229Channel · crackedLT MLG FORWARD LOWER DOOR JAMB CHANNEL REPAIR IAW SRM 53-60-02 VOL I PARA 8 FIG 6 AREA REWORKED AND NEW REPAIR COMPLETED SRM 53-60-02.SDR DALA1157649229Angle · crackedSTA 1542 NESTED ANGLES REPAIRED IAW SRM 54-00-01 VOL I FIG 2 SHEET 2 AND THE ORIGINAL REPAIR BAC APPROVED BY A 8100-9 BAC TWX 1-201845718-2 AND BLUE 1 AIRLINES EOM 90-53-004.SDR DALA1157639229Skin · chafedSTA 1458 L7LT REPAIR IAW SRM 53-10-02 VOL I FIG 4 AND BLUE 1 AIRLINES EOM90-53-002. (TO 16A).SDR DALA1157629229Skin · corrodedSTA 1364 L29-29RT REPAIRED IAW SRM 53-10-02 VOL I FIG 2.SDR DALA1157619229Door Frame · damagedAFT CARGO DOOR JAMB REPAIRED IAW SRM 53-60-02 VOL I FIG 9.SDR DALA1157609229Skin · damagedSTA 229-275 L10-16LT SKIN REPAIRED IAW BAC TWX BNI-BNI-10-0071-10B 8100-9 RECEIVED 09/28/2011 (TO 89).SDR DALA1157599229Cusp Web · corrodedSTA 685-796 CUSP REPAIR IAW DWG SG09530019 SRM 53-20-02 VOL I PARA 6__(TO 87).SDR DALA1157589229Cusp Web · crackedSTA 1344-1364 LT CUSP MEMBRANE REPAIRED IAW DWG SG09530019 SRM 53-20-02 VOL I PARA 6__(TO 86).
Back to Boeing MD-90-30