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 DALA1117529223Cargo Track · corrodedHMV2 AFT CARGO COMP TIE DOWN TRACK CORRODED STA 1212-1145 RT. REPLACED TRACK PER SRM 51-30-01.SDR DALA1117519223Cargo Track · corrodedHMV2 AFT CARGO COMP RT TIE DOWN TRACK STA 1269-1307 CORRODED. REPLACED TRACK PER SRM 51-30-01.SDR DALA1109629223Floor Support · corrodedCABIN FLOOR SUPPORT CORRODED STA 1364-1395. REPLACED FLOOR SUPPORT IAW SRM 51-30-01.SDR DALA1102429202Acoustic Liner · departedFLIGHT CREW DIVERTED, DUE TO REPORTS OF DEBRIS ON DEPARTURE RUNWAY OUT OF MSP WHICH "MAY HAVE COME OFF OF OUR JET". DEBRIS IDENTIFIED AS ACOUSTICAL LINER AND ACFT WAS THE LAST TO DEPART. MX FOUND ACOUSTIC MATERIAL MISSING ON THE NR1 ENGINE THRUST REVERSER. USDR DALA1102279217Water Separator · frozenON FINAL APPROACH THE CABIN CREW REPORTED THAT THE CABIN WAS FILLING WITH SMOKE AND PASSENGERS WERE COMPLAINING OF THE SMELL. LAVATORY SMOKE DETECTORS DID NOT GO OFF. NO EMERGENCY WAS DECLARED AND THE ACFT ARRIVED AT THE GATE WITH NORMAL OPERATIONS AND NO SMOSDR DALA1117599223Frame · corrodedHMV2 AFT CARGO STA 1328 BETWEEN 28RT AND 26LT FRAME CORRODED. REPLACED FRAME PER SRM 51-30-02.SDR DALA1117459223Frame · corrodedHMV2 AFT CARGO STA 1344 BETWEEN 29RT AND 29LT FRAME CORRODED. REPAIR FRAME PER SRM 53-10-02.SDR DALA1109679223Longeron · corrodedAFT CARGO STA 1344-1364, LONGERON 30 CORRODED. REPAIR LONGERON 30 IAW SRM 53-00-01, 51-30-02.SDR DALA1109639223Frame · corrodedAFT CARGO STA 1364 BETWEEN STGR 29RT AND 29LT FRAME CORRODED. REPAIR IAW SRM 53-00-01 51-30-05.SDR DALA1109619223Frame · corrodedHMV2 AFT CARGO STA 1307 BETWEEN STGR 30 AND 28LT FRAME CORRODED. REPAIR IAW SRM 53-10-02, 51-30-05.SDR DALA1117569223Web · crackedHMV2 LEFT WHEEL WELL CUTOUT FWD WEB CRACKED 3 PLACES. REPLACED WEB PER SRM 51-30-02.SDR DALA1117559223Cargo Track · corrodedHMV2 AFT CARGO COMP LT TIE DOWN TRACK STA 1060-1155 CORRODED. REPLACED TIE DOWN TRACK PER SRM 51-30-05.SDR DALA1117449223Cargo Track · corrodedHMV2 AFT CARGO RT TIE DOWN TRACK STA 1060-1155 CORRODED. REPLACED TRACK PER SRM 51-30-01.SDR DALA1117369223Cargo Track · corrodedHMV2 AFT CARGO COMP LT TIE DOWN TRACK STA 1155-1227 CORRODED. REPLACED TRACK PER SRM 51-30-05.SDR DALA1117309223Hinge Fitting · chafedHMV2 RT WING INBD FLT SPOILER CENTER FITTING FOUND WITH HEAVY CHAFING. REPLACED FITTING PER SRM 51-30-01.SDR DALA1109649223Longeron · corrodedCORROSION ON L28R, STA 168. REPAIR L28R, STA 168 IAW 53-10-01, 51-30-02.SDR DALA1101989209Light · inoperativeDURING LINE CHECK, MX FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN ROWS 1DC, 16CDE AND FWD OF ROW 10CDE WERE INOPERATIVE. MX REPLACED THE LIGHT LENS ASSEMBLIES AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK OF THEM.SDR DALA1135389220Longeron · corrodedAFT CARGO COMPARTMENT LONGERON 29L AT BS 1345 ON LOWER SIDE EXFOLIATED. REMOVED DAMAGE SECTION OF LONGERON AND SPLICED NEW SECTION IN IAW SRM 53-10-01 FIG 7 FROM STA 1317 TO 1354 LONGERON 29L.SDR DALA1117589223Pan · corrodedHMV2 AFT CARGO DOOR INNER PAN CORRODED. REPLACED PAN PER SRM 51-10-03 52-00-01.SDR DALA1112929222Rub Strip · corrodedHMV2 UPPER FUEL PANEL CUT OUT NR 520 FT HAS SURFACE CORROSION ON EXTERIOR RIM. REPLACED RUB STRIP PER 57-10-05.SDR DALA1112859222Longeron · corrodedHMV2 AFT PRESS BULK HEAD CORROSION ON L28R. REPLACED L28R PER SRM 51-30-02.SDR DALA1112839222Fitting · corrodedHMV2 MID CARGO DOOR CUT OUT LWR AFT CORNER FITTING CORRODED. REPLACED FITTING PER SRM 51-10-04.SDR DALA1112769222Floor Support · corrodedHMV2 MID CARGO STA 750 FLOOR SUPPORT ANGLE CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-30-02.SDR DALA1117539223Angle · corrodedHMV2 AFT ACCY COMP AFT AIRSTAIR CUTOUT RT STA 1469 CANT 1542 CORRODED.SDR DALA1117339223Frame · corrodedHMV2 AFT CARGO COMP STA 1364 BETWEEN STR 29RT AND 29LT FRAME CORRODED. REPAIRED FRAME PER SRM 53-10-02.SDR DALA1112939222Floor Support · corrodedHMV2 FWD CARGO COMP BS 332 LONGERON28L-28R FLOOR SUPPORT CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-30-02.SDR DALA1117299223Longeron · corrodedHMV2 AFT CARGO LONG 28 RT CORRODED STA 1184-1288. REPLACED LONGERON 28R PER SRM 51-30-05.SDR DALA1112919222Floor Support · corrodedHMV2 AFT CARGO FLOOR SUPPORT STA 1212-1269 ABOVE L29R CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-30-01.SDR DALA1112879222Rub Strip · corrodedHMV2 LT WING UPPER FUEL PANEL CUT OUT NR 520AT HAS SURFACE CORROSION ON EXTERNAL RIM. REPLACED RUB STRIP PER SRM 57-10-05.SDR DALA1053439206Skin · dentedFUSELAGE DENTED AT STA 271 BETWEEN LONGERON 30 AND LONGERON 29RT. DENT CAUSED BY MAINT ATTEMPT TO JACK ACFT AT FWD LAV DRAIN HOLE DURING NLG STRUT SERVICING. DENT WAS CUT-OUT AND REPAIRED IAW ERA 488513-14. NON ROUTINE NR1.SDR DALA1200199232Skin · damagedSTA 541 L18L LIGHTNING STRIKE REPAIR IAW SRM 53-30-01, PARA 10 AND BOEING MESSAGE BNI-BNI-10-0081-07B AND DWG SG 09530008.SDR DALA1113889222Bulkhead · crackedHMV2 AFT AIRSTAIR AT STA 1520 BULKHEAD BETWEEN LONGERONS 2L-2R CRACKED. REPAIR PER ERA487592-14 REV ORIG.SDR DALA1124649221Support Frame · corrodedHMV2 PANEL 160SR SUPPORT FRAME CORRODED. REPAIR PER SRM 51-10-3.SDR DALA1517989236Door Frame · corrodedAFT CARGO DOOR FRAME BEAM, L28R, CORRODED. REPAIRED IAW ERA 398119-14.SDR DALA1510819255Door Frame · corrodedAFT CARGO DOOR FRAME L28R CORRODED. REPAIRED IAW ERA 398119-14.SDR DALA1510649230Beam · corrodedAFT CARGO DOOR FRAME BEAM, L28R, CORRODED. REPAIRED IAW ERA 398119-14.SDR DALA1506089220Floorbeam · corrodedFORWARD CARGO BAY FLOOR SUPPORT AT BS 218, LONGERON 28L TO 28R LEVEL 1 CORROSION. REPLACED IAW SRM 51-30-02, VOL II, PAGE 11, PN 9936719-169. NR 19838.SDR DALA1504169263Door Frame · corrodedFUSELAGE, AFT CARGO DOORWAY LOWER JAMB BEAM, L-28R CORROSION REPAIRED IAW ERA 398119-14.SDR DALA1503909235Beam · corrodedAFT CARGO DOORWAY LOWER JAMB BEAM CORRODED. REPAIRED IAW ERA 398119-14SDR DALA1117719221Support · corrodedHMV2 WING TO BODY FAIRING 160SR LOWER SUPPORT CORRODED STA 1098 RBL 3. REPAIR PER SRM 53-00-01.SDR DALA1506109220Door Frame · corrodedAFT CARGO BAY FUSELAGE CUTOUT DOOR JAMB HAS SURFACE CORROSION LEVEL 2 AT LOWER CENTER OF DOOR JAMB OUT OF LIMITS. REPAIRED IAW SRM 53-60-02, VOL 1, PARA 11.SDR DALA1135429220Frame · corrodedCENTER CARGO STA 807 FRAME CORRODED. REPAIRED FRAME IAW ERA 487594-14 REVISION ORIG.SDR DALA1135489220Floorbeam · corrodedAFT COMPARTMENT CARGO SURFACE CORRSION ON FLOORBOARD SUPPORT STA 1212 LGN 28L-28R. REMOVED CORROSION ON FLOOR SUPPORT ORIG THICKNESS .063 AFTER BLENDING .50 REMAINS .013 MAT LOSS OUT OF LIMITS PER SRM 53-00-01 PG 9. REPLACED FLOOR SUPPORT.SDR DALA1135379220Angle · corrodedFWD CARGO COMPARTMENT FLOOR SUPPORT Z ANGLE IS CORRODED ON BOTTOM SIDE AROUND FASTENER HOLES STA 427 THRU 446 X15 TO X18. REMOVED AND REPLACED Z ANGLE FROM STA 427 TO 446 IAW SRM 53-40-01 VOL 1 FIG 7.SDR DALA1124679221Door · crackedHMV2 LT MLG DOOR AFT EDGE REPAIR CRACKED. REPLACED REPAIR PER SRM 51-10-03.SDR DALA1117759221Pan · corrodedHMV2 FWD CARGO DOOR JAMB CORRODED STA 376-427. REPLACED DOOR PAN PER SRM 53-05 FIG 44.SDR DALA1113869222Angle · corrodedHMV2 FWD CARGO Z ANGLE CORRODED STA 427-446. REPLACED Z ANGLE PER SRM 53-40-01.SDR DALA1113859222Floor Support · corrodedHMV2 FWD CARGO FLOOR SUPPORT CORRODED STA 427-465. REPLACED Z ANGLE PER SRM 53-40-01.SDR DALA1509929254Beam · corrodedFUSELAGE/ AFT CARGO DOORWAY/ LOWER BEAM, L-28R CORROSION REPAIRED IAW ERA 398119-14.SDR DALA1506099220Support Angle · corrodedCENTER CARGO BILGE BS 655 SUPPORT ANGLE ON FRAME IS CORRODED, LEVEL 2 FROM LONGERON 28R TO 28L. REPLACED SUPPORT ANGLE IAW ERA 487593-14 AND SRM 51-30-02, FIG 2, PG 4, FIG 3, PG 5, AND FIG 7, PG 11.
Back to Boeing MD-90-30