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 DALA1141829227Support · corrodedHMV2 STA 218-237 SIDEWALL SUPPORT CORRODED. REPAIR PER MD90 SRM 53-40-01 VOL 1 FIG 7.SDR DALA1135479220Shear Tie · corrodedHMV FOUND SHEAR TIE AT STA 1212 L30-29L CORRODED. FABRICATED NEW SHEAR TIE AND INSTALLED IAW 51-30-02.SDR DALA1117029212Light · inoperativeCABIN ATTENDANT FOUND TWO FLOOR EMERGENCY PATHWAY LIGHTS BROKEN BY ROW 5. MAINTENANCE REPLACED LIGHT ASSEMBLIES AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK OF THEM.SDR DALA1116249217Coffeemaker · odorF/A REPORTED ELECTRICAL ODOR IN FIRST CLASS GALLEY. FLIGHT CREW PERFORMED QRH, PULLED THE GALLEY POWER SWITCH OFF, AND THE ODOR DISSIPATED. MX OPERATED FWD GALLEY OVEN AND COFFEEMAKERS BUT NO SMOKE OR ODOR WAS NOTED. SOME SPILLED/BURNED COFFEE WAS FOUND ONSDR DALA1116999216Light · inoperativeDURING LINE CHECK, MAINTENANCE FOUND EMERGENCY PATHWAY LIGHTING AT ROWS 12, 14, 18, 28 AND 32 INOPERATIVE. MAINTENANCE LAMPED THE EMERGENCY PATHWAY LIGHTING AND OPERATIONALLY CHECKED THE SYSTEM. AIRCRAFT OKAY FOR SERVICE.SDR DALA1116959209Stringer · crackedTAIL INTERIOR STRINGER 2L AT STA 1475 (AFT) HAS CRACK IN STRINGER. REPAIRED PER ER/A 490622-14 REV 0 & 01 STEPS 1-9. INSTALLED NEW STRINGER & SPLICE.SDR DALA1116949209Stringer · crackedTAIL INTERIOR STRINGER 2L AT STA 1475 (AFT) HAS CRACK IN STRINGER. ACCOMPLISHED ER/A 490622-14 REV 0 & 01 STEPS 1-9.SDR DALA1141939227Doubler · corrodedHMV2 FWD E/E BAY CORROSION ON INTERNAL DOUBLER STA 140-160 L28L-L28R. REPAIR PER ERA 489840-14 REV ORIG.SDR DALA1141919227Frame · corrodedHMV2 STA 1443 AFT SIDE OF FRAME HAS CORROSION FROM L30-L27R. REPLACED CHORD PER MD90 SRM 51-30-02.SDR DALA1141949227Longeron · corrodedHMV2 CORROSION AT FS 826-864 L29R. REPAIRED PER ERA 490979-14 REV ORIG.SDR DALA1131819224Longeron · crackedHMV2 L20R CRACKED AT STA 1051. REPAIR PER SRM 53-10-01 AND BOEING DRAWING SG09530021.SDR DALA1131799224Splice · corrodedHMV2 MID CARGO L30 AND L29R STA 580 SPLICES CORRODED. REPLACED SPLICES PER ERA 487473-14 REV 0.SDR DALA1141959227Frame · damagedHMV2 TAIL COMP STA 1437 LT FRAME AT 10 0 CLOCK POS FWD WEB DAMAGED. REPAIR PER MD90 SRM 51-11-01 FIG 2.SDR DALA1117359223Longeron Splice · corrodedHMV2 FWD CARGO COMP BETWEEN 484-503 STR 29LT CORROSION ON FASTENERS. REPAIRED/REPLACED LONGERON 29LT SPLICE AND FASTENERS PER SRM 51-30-05.SDR DALA1117349223Longeron Splice · corrodedHMV2 FWD CARGO STA 484-503 LONG 30 FASTENERS RUSTY. REPLACED LONGERON SPLICE AND FASTENERS PER SRM 51-30-05.SDR DALA1115219223Longeron · corrodedFWD CARGO COMPT BETWEEN STA 484 AND STA 503, STR 30 FASTENER WITH RUST (MK11-25) COMPLIED WITH ON NON-ROUTINE W/O 2003107, ZONE 1000, ITEM 0135. R & R LONGERON 30 SPLICE AND HARDWARE AT FWD CARGO BETWEEN STA 484 TO STA 503 IAW SRM 51-30-05.SDR DALA1115209223Longeron Splice · corrodedFWD CARGO COMPT BETWEEN STA 484 AND STA 503, STR 29 LT FASTENER WITH RUST (MK11-26). COMPLIED WITH ON NON-ROUTINE W/O 2003107, ZONE 1000, ITEM 0136. R & R LONGERON SPLICE AND HARDWARE AT FWD CARGO BETWEEN STA 484 AND STA 503, LONGERON 29 LT IAW SRM 51-30-05.SDR DALA1113769206Slide · out of positionFLIGHT CREW NOTIFIED MCC, VIA ACARS THAT 1R DOOR SLIDE PANEL FELL OFF AND SLIDE PACK FELL OUT. MAINTENANCE RE-INSTALLED SLIDE PER MAINTENANCE MANUAL. ALL CHECKS GOOD. AIRCRAFT OKAY FOR SERVICE.SDR DALA1141969227Cusp Web · corrodedHMV2 PAX CABIN RT CUSP WEB CORRODED STA 370. REPAIR PER MD90 SRM 53-20-02 VOL 1 AND SG DRWG 09530019.SDR DALA1124499224Bulkhead · corrodedHMV2 AFT PRESSURE BULKHEAD FWD SIDE LOWER LOBE CORRODED. REPLACED DOUBLER PER SRM 51-30-5.SDR DALA1115049223Cargo Track · corrodedAFT CARGO COMPT LT TIE DOWN TRACK FROM STA 1060 TO STA 1155, WITH SURFACE CORROSION. COMPLIED WITH W/O 2003107 ITEM 0091. REMOVED AFT CARGO COMPT LT TIE DOWN TRACK FROM STA 1060 TO STA 1155. REF SRM 51-30-05. INSTALLED NEW TIE DOWNTRACK AND SPLICE REF SRM SDR DALA1114669223Frame · misrepairedFRAME REPAIR AT STA 1364 SPLICE PLATES WITH NO ED COMPLIED WITH COMPARTMENT STA 1364 BETWEEN L 28L AND 29L AND AT LONG 29R AS PER MD 90 SRM 51-30-05- SRM 53-10-02 SRM 51-10-04 AND 51-20-00.SDR DALA1317559208Cusp Web · puncturedPUNCTURE DAMAGE WAS FOUND ON FLOOR CUSP WEB. PUNCTURES ARE LOCATED AT BS 146, RBL1. REPAIR IAW ERA 490154-14.SDR DALA1141849227Web · corrodedHMV2 MID CARGO STA 704 WEB UPPER DOOR CUTOUT CORRODED. REPAIR PER ERA 490973-14 REV ORIG.SDR DALA1113749214Slide · disconnectedFLIGHT CREW FOUND THE 1L DOOR GIRT BAR TO SLIDE CABLE DISCONNECTED. MAINTENANCE RECONNECTED 1L DOOR GIRT BAR CABLE. AIRCRAFT OK FOR SERVICE.SDR DALA1112819222Shear Tie · corrodedHMV2 SHEAR TIE STA 1269 L30-L29R CORRODED. REPLACED SHEAR TIE PER SRM 51-30-02SDR DALA1114639223Frame · misinstalledAFT CARGO COMPARTMENT STA 1344 BETWEEN L 29R AND 29LT CIRCUMFERENTIAL REPAIR WENT IN DRY, NO SHIMS INSTALL IN THE BOW REPAIR AND FASTENERS HAVE NO EDGE DISTANCE DOT- 30-01. COMPLIED WITH W/O 2003107 ITEM 0326. INSTALLED CIRCUMFERENTIAL REPAIR WITH SHIMS AND SDR DALA1142129227Bulkhead · corrodedHMV2 AFT PRESSURE BULKHEAD CORRODED BL 0 STA 1395 LOWER. INSTALLED NEW DOUBLER PER MD90 SRM 51030-05 VOL 2 AND DRWG 5910130.SDR DALA1114649223Frame · misrepairedREPAIR IN AFT CARGO COMP STA 1328 BETWEEN STR 28R AND 28L CIRCUMFERENTIAL NOT PERFORMED PER SRM 53-10-02 PAR 27 ITEM 8 AND SRM 51-20-00 DID NOT USR SEALER O0N REPAIR PARS. COMPLIED WITH AT AIR MIAMI ON W/O 2003107 ITEM 0325 REMOVED REPAIR (2 SECTIONS) AND APPSDR DALA1142099227Stiffener · crackedHMV2 CENTER WING BOX FS 883 RT STIFFENER CRACKED. REPAIRED PER ERA 489826-14 REV ORIG.SDR DALA1141859227Frame · crackedHMV2 AFT AIR STAIR COMPARTMENT FRAME 1542.019 CRACKED. REPAIR PER MD90 SRM 53-10-02 PG 72 VOL 1.SDR DALA1111909223Cargo Track · corrodedCENTER CARGO COMPT. BETWEEN STA 636 AND STA 655 LT TIE DOWN TRACK WITH CORROSION (MK 11-11). COMPLIED WITH W/O 2003107 ITEM 0026.SDR DALA1111679223Cargo Track · corrodedCENTER CARGO COMPT BETWEEN STA 636 AND STA 655 LT TIE DOWN TRACK WITH CORROSION. COMPLIED WITH ON W/O 2003107 ITME 0026.SDR DALA1142149227Cargo Track · corrodedHMV2 AFT CARGO FS 1053-1307 LT CARGO TRACK CORRODED. SPLICED IN NEW SECTION PER MD90 SRM 53-40-01.SDR DALA1141909227Cargo Track · corrodedHMV2 AFT CARGO FS 1053-1204 RT CARGO TRACK CORRODED. REPLACED CARGO TRACK PER MD90 SRM 51-00-00.SDR DALA1141889227Floor Support · corrodedHMV2 AFT CARGO FS 1136 FLOOR SUPPORT CORRODED. REPLACED SUPPORT PER MD90 SRM 51-30-02 PG 1 VOL 2.SDR DALA1141879227Cargo Track · corrodedHMV2 AFT CARGO FS 1053 TO FS 1204 RT CARGO TRACK CORRODED. REPLACED CARGO TRACK PER MD90 SRM 51-00-01.SDR DALA1117399223Cargo Track · corrodedHMV2 CTR CARGO COMP STA 655 LT TIE DOWN TRACK CORRODED. REPLACED TRACK STA 598-845 LT PER SRM 51-30-03.SDR DALA1142079227Floor Support · corrodedHMV2 MID CARGO STA 598 CENTER FLOOR SUPPORT CORRODED. REMOVED, FABRICATED AND INSTALLED PER ERA 490976-14 REV A.SDR DALA1141899227Attach Angle · corrodedHMV2 MID CARGO STA 769-845 RT FLOOR PANEL ATTACH ANGLE CORRODED. REPLACED TRACK PER MD90 SRM 51-00-00.SDR DALA1111689223Cargo Track · corrodedAFT CARGO COMPT. TIE DOWN TRACK HAS SIX CORROSION SPOTS AND IS DIRTY. DOT 80-33 LOCATED AT 28R STA 1212 TO STA 1145. COMPLIED WITH W/O 2003107 ITEM 0232.SDR DALA1142109227Stiffener · crackedHMV2 CENTER WING BOX STA 883 LT STIFFENER CRACKED. REPAIRED PER ERA 489826-14 REV ORIG.SDR DALA1112869222Fitting · corrodedHMV2 L29R FITTING CORRODED STA 1395. REPLACED FITTING PER SRM 51-10-05.SDR DALA1112799222Longeron · corrodedHMV2 L29L LONGERON CORRODED STA 1395. REPLACED LONGERON PER SRM 51-30-02.SDR DALA1117319223Floor Panel · crackedHMV2 CABIN FLOOR PANEL CRACKED PNL NR 221XF. PANEL REPAIR PER SRM 51-10-03 AND TIMCO DWG 09T229MO42.SDR DALA1111699223Frame · corrodedAFT CARGO COMPARTMENT STA 1344 BETWEEN STR 29RT AND STR 29 LT CIRCUMFERENTIAL WITH CORROSION (KM 11-16). COMPLIED WITH AT AAR MIAMI ON W/O 2003107 ITEM 0106.SDR DALA1109719208Bracket · disconnectedFLIGHT CREW FOUND SLIDE PACK BRACKET DISCONNECTED AT DOOR 2L. MX RECONNECTED SLIDE PACK LOWER CLIP. ACFT OK FOR SERVICE.SDR DALA1111899223Floor Support · corrodedCENTER CARGO COMPT STA 598, CENTER FLOOR SUPPORT PANEL, WITH CORROSION (MK 11-09), COMPLIED WITH W/O 2003107 ITEM 0024. REMOVED CORROSION FLOOR SUPPORT 2 MATERIAL FOUND OUT OF LIMITS3. REMOVED FLOOR SUPPORT 4 DRILLED AND LOCATED HOLES NEW PART5 INSTALLED FLSDR DALA1117549223Frame · corrodedHMV2 RT WHEEL WELL FWD CUTOUT FRAME CORRODED. REPLACED FRAME PER SRM 51-30-02.SDR DALA1117579223Web · crackedHMV2 RT MLG WHEEL WELL CUTOUT WEB CRACKED. REPLACED WEB PER SRM 51-30-02
Back to Boeing MD-90-30