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 DLM90081108Fitting · corrodedFOUND CLIP CORRODED. REPLACED CLIP.SDR DLM90081102Angle · corrodedFOUND CORROSION FROM STA 1250 TO 1265. REPLACED ANGLE PER SRM 51-30-03 AND 51-30-05.SDR DLM90081115Skin · corrodedCORROSION ON FUSELAGE SKIN STA 795-885 AT ATTACH POINTS FOR LOWER WING TO BODY FAIRING. REPAIRED DAMAGED SKIN IAW SRM 53-04 FIG 53.SDR DLM90081107Seat Track · gougedFOUND SEAT TRACK GOUGED, REPAIRED.SDR DLM90081106Intercostal · corrodedFOUND INTERCOSTAL EXFOLIATED, REPLACED.SDR DLM90081104Support · corrodedFOUND SUPPORT CORRODED. REPLACED SUPPORT.SDR DLM90081105Support · corrodedFOUND SUPPORT CORRODED. REPLACED SUPPORT.SDR DLM90081114Cusp Web · puncturedCABIN CUSP WEB PUNCTURED ON I/B SIDE OF SEAT TRACK AT FS 360 CBL 54/CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER IAW SRM 51-11-01 VOL 1.SDR DALA1129339224Skin Panel · corrodedPERFORMED TASK CARD 65070043, SKIN PANEL CORROSION BETWEEN STA 1204.5 AND STA 1212, L30 SRM 53-30-01 VOL 3 FIG 3. C/W 65070043.SDR DALA1129329224Skin Panel · corrodedPERFORMED TASK CARD 65070038 SKIN PANEL CORROSION BETWEEN STA 1259.5 AND STA 1276, L30 SRM 53-30-01 VOL 3 FIG 3. C/W 65070038.SDR DALA1129359224Stiffener · corrodedPERFORMED TASK CARD 65070174, CORROSION ON APU RT ACCESS DOOR STIFFENER. C/W 65070174.SDR DLM90080823Seat Track · corrodedCABIN SEAT TRACK RBL 22 STA 1310 OUT OF LIMITS. REMOVED AND INSTALLED NEW SEAT TRACK IAW MD90 SRM 53-40-01.SDR DLM90080822Cusp Web · corrodedLEFT CABIN CUSP WEB FS 998 CORRODED AT LIGHTNING HOLE. REMOVED CORROSION IAW MD90 SRM 53-00-01 FIG 3. MATERIAL LOSS 100 PERCENT OUT OF LIMITS IAW MD90 SRM 53-00-01 FIG 3. INSTALLED REPAIR DOUBLER IAW MD 80 SRM 53-05D FIG 827D.SDR DLM90080821Web · corrodedLEFT CABIN CUSP WEB FS 588-586 CORRODED. INSTALLED REPAIR DOUBLER IAW MD 80 SRM 53-05D FIG 827D.SDR DALA1129489224Longeron · corrodedPERFORMED TASK CARD 65070083, CORROSION ON 30L BETWWEN STA 1344 AND STA 1364 OF AFT CARGO COMPARTMENT SRM 53-10-03 FIG 2. C/W 65070083.SDR DALA1129499224Seat Track · corrodedPERFORMED TASK CARD 65070093, CORROSION ON LT NR 2 SEAT TRACK BETWEEN STA 1200 AND STA 1300 SRM 53-40-01 FIG 6. C/W 65070093.SDR DALA1129479224Fitting · corrodedPERFORMED TASK CARD 65070054, CORROSION ON TRACK FITTING BETWEEN STA 1136 AND STA 1155 SRM 53-40-01 FIG 7. C/W 65070054.SDR DLM90080777Proximity Sensor · malfunctionedAFTER T/O RAISED GEAR HANDLE AND RT GEAR UNSAFE LIGHT STAYED ILLUMINATED. REPLACED RT MAIN UP LATCH PROX SENSOR D1-25. PERFORMED GEAR SWING 3 TO 4 TIMES. ALL INDICATIONS CHECKED NORMAL. PROX SENSOR ALWAYS SHOWED FAR WITH ORIGINAL AND NEW PSEU.SDR DALA1129459224Fitting · corrodedPERFORMED TASK CARD 65070009, CORROSION ON RT TRACK FITTING BETWEEN STA 579 AND STA 598 OF MID CARGO COMPARTMENT SRM 53-40-01 FIG 7. C/W 65070009.SDR DALA1129449224Cargo Track · corrodedPERFORMED TASK CARD 65070006, CORROSION ON TRACK BETWEEN STA 579 AND STA 693 OF MID CARGO COMPARTMENT SRM 53-40-01 FIG 7. C/W 65070006.SDR DALA1129439224Beam · corrodedPERFORMED TASK CARD 65059946, CORROSION ON SPACER OF MID CARGO DOOR BEAM BETWEEN STA 693 AND STA 750 SRM 53-60-02 FIG 9.C/W 65059946.SDR DALA1129429224Cargo Track · corrodedPERFORMED TASK CARD 65069819, CORROSION ON LT TRACK FITTING BETWEEN STA 503 AND STA 522 OF FWD CARGO COMPARTMENT SRM 53-40-01 FIG 7. C/W 65069819.SDR DALA1129419224Cargo Track · corrodedPERFORMED TASK CARD 65059816, CORROSION ON RT TRACK BETWEEN STA 228 AND STA 232 OF FWD CARGO COMPARTMENT SRM 53-40-01 FIG 7. C/W 65059816.SDR DLM90080789Intercostal · brokenINTERCOSTAL AT FS 1360 BLO TO HAVE A SECTION OF UPPER FLANGE BROKEN OFF. REPAIRED INTERCOSTAL, IAW DELTA ER/A 12670 DATE 5/19/08 REV I/R.SDR DLM90080788Door Frame · corrodedAFTER REMOVAL OF WEATHER SEAL, FOUND VENTRAL STAIRWAY DOOR JAMB CORRODED OUT OF LIMITS, LOWER SECTION AT FLOOR LEVEL. REPAIRED STAIRWAY DOOR JAMB, IAW DELTA ER/A 468148-14 REV ORIG.SDR DLM90080787Door Frame · corrodedAFT CARGO BAY LOWER DOOR JAMB BEAM CORRODED BETWEEN STA 1212 AND 1269 LONGERON 28R. REPAIRED AFT CARGO LOWER JAMB BEAM, IAW DELTA ER/A 468149-14, REV ORIG DATED 05MAY08.SDR DLM90080786Door Frame · corrodedMIDPIT DOOR JAMB LWR SURFACE HAS CORROSION ON LWR SURFACE AT FASTENER HOLES. REPAIRED MIDPIT DOOR JAMB, IAW DELTA ER/A 468150-14, REV ORIG DATE ISSUED 05MAY08 VIA AAR EA 12661 REV I/R DATE ISSUED 05/05/08.SDR DLM90080733Skin · crackedLEFT WING O/B FLAP CENTER FIXED VANE UPPER SURFACE IS CRACKED. REMOVED & REPLACED LT O/B CENTER FIXED VANE, IAW MD90 AMM 27-50-02.SDR DLM90080732Skin · dentedLEFT WING I/B FIXED VANE LOWER SURFACE HAS SEVERAL SMALL DINGS. REPAIRED DENT DAMAGE TO LOWER SURFACE OF LT WING I/B FIXED VANE, IAW MD90 SRM 57-20-05D, PARA 14, FIG 21.SDR DLM90080718Heater · shortedWASTE OVBD VENT TEE HEATER SHORTED OUT AND BURNT A 3 INCH HOLE IN THE TEE THEN THE A/C COULD NOT PRESSURIZE WITH 1 PACK.SDR DLM90080702Skin · dentedPRIOR TO FIRST FLT OF THE DAY, FOUND FUSELAGE SKIN DENTED AT FS 237 BETWEEN LONGERON 18L AND 19L AND REPAIR ID TAG MISSING. REPAIRED DAMAGED AREA, IAW MD80 SRM 53-04D, FIG 12 B AND MD90 SRM VOL 1, 51-00-01.SDR DLM90080701Frame · corrodedAFT CARGO BAY FRAME CORRODED AFT SIDE STA 1364 BETWEEN LONG 27L AND 28R. REPAIRED FRAME, IAW MD90 53-10-02.SDR DLM90080700Longeron · corrodedAFT CARGO BAY LONG 27L CORRODED AROUND FASTENERS AND DRAIN HOLES STA 1344-1364. REPAIRED LONG, IAW MD90 SRM 53-10-01, FIG 7 VOL 1.SDR DLM90080714Cusp Web · corrodedRIGHT CUSP WEB CORRODED ON UPPER AND LWR SURFACE FROM STA 446-465 RT. REMOVED AND REPLACED CUSP WEB, IAW MD90 SRM 51-30-01, 51-30-02, 51-30-05 AND DELTA ER/A 398181-14MA DATED 9-18-02 REV 1, STEP NR 9 FIG NR 5.SDR DLM90080713Cusp Web · corrodedRIGHT CUSP WEB CORRODED ON LWR SURFACE BETWEEN STA 484-503 AT CENTER LIGHTENING HOLE. WEB FOUND TO BE OUT OF LIMITS, IAW MD90 SRM 53-00-01, FIG 3. WORK TO BE ACCOMPLISHED ON N/R 1003732 2400/0215.SDR DLM90080712Cusp Web · corrodedRIGHT CUSP WEB CORRODED AT FIRST LIGHTNING HOLE AFT OF STA 465 ON UPPER AND LWR SURFACE. WEB WAS FOUND TO BE OUT OF LIMITS, IAW MD90 SRM 53-00-01, FIG 3. WORK TO BE ACCOMPLISHED ON N/R 1003732 2400/0215 S/N 109915.SDR DLM90080706Seat Track · gougedCABIN SEAT TRACK FS 674-760 RBL 54 OUT OF LIMITS. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01, VOL 1.SDR DLM90080705Cusp Web · corrodedRIGHT CUSP WEB CORRODED ON DOUBLER FROM STA 674-769. REPLACED CUSP WEB, IAW MD90 SRM 51-10-05.SDR DLM90080704Web · corrodedFLOOR MEMBRANE CORRODED FS 200 RBL 48-54. REPAIRED FLOOR MEMBRANE, IAW MD90 SRM 51-30-02, VOL 3.SDR DLM90080703Seat Track · corrodedSEAT TRACK EXFOLIATED AT FS 1204 LBL 22. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01, FIG 6.SDR DLM90080709Cusp Web · crackedLT STA 1360 CUSP WEB CRACKED. REPAIRED CUSP WEB, IAW MD90 SRM 51-11-01, FIG 2.SDR DLM90080708Seat Track · gougedCABIN SEAT TRACK FS 1136-1174 RBL 54 OUT OF LIMITS. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01, VOL I.SDR DLM90080707Seat Track · gougedCABIN SEAT TRACK FS 845-879 LBL 54 OUT OF LIMITS. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01, VOL I.SDR DLM90080663Bracket · crackedFOUND CRACK AFT OF STA 1494 BETWEEN LONGERONS L-1 AND L-2. REMOVED AND REPLACED BRACKET, IAW MD90 SRM 51-30-05.SDR DLM90080662Cusp Web · corrodedRIGHT CUSP WEB CORRODED ON LOWER SURFACE BETWEEN STA 579-598 AT LIGHTNING HOLES. REPAIRED RT CUSP WEB STA 579-598, IAW DELTA ER/A 398191-14MA REV ORIG 09-18-02.SDR DLM90080711Cusp Web · corrodedLT CUSP WEB HAS CORROSION ON UPPER SURFACE AT STA 541-560. REPAIRED CUSP WEB, IAW MD80 SRM 53-05D, FIG 827D.SDR DLM90080710Cusp Web · corrodedLT CUSP WEB HAS CORROSION AT LIGHT WING HOLE AFT OF STA 560 ON UPPER AND LOWER SURFACE. REPAIRED CUSP WEB, IAW MD80 SRM 53-05D, FIG 827D.SDR DLM90080669Cargo Track · corrodedAFT CARGO BAY RT CARGO TRACK CORRODED AROUND FASTENER STA 1269 TO 1307. REMOVED AND REPLACED TRACK, IAW MD90 SRM 51-30-01.SDR DLM90080674Cusp Web · damagedLT CUSP WEB AT STA 560 O/B SEAT TRACK HAS A HOLE IN WEB ON O/B SIDE OF TRACK BELOW CLIP NUT. REPAIRED CUSP WEB, IAW MD90 SRM 51-11-01, FIG 6.SDR DLM90080673Seat Track · gougedCABIN SEAT TRACK FS 1326-LBL 22 OUT OF LIMITS. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01, FIG 6 VOL I.
Back to Boeing MD-90-30