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 DALA2014063003832Frame · wornFUSELAGE FRAME IS WORN AT LT SIDE 10:00 POSITION APPROXIMATELY 48 INCHES AFT OF AFT PRESSURE BULKHEAD. REPAIRED IAW SRM 53-10-02, FIG 2.SDR DALA2014063003831Door Frame · crackedLEFT WHEEL WELL, AFT DOOR FRAME CRACKED AT OTBD END. REPAIR COMPLETED IAW SRM 53-60-02, FIG 8 AND ERA 520684-14MA, REV O.SDR DALA2014062903826Bulkhead · corrodedAFT PRESSURE BULKHEAD DOOR FRAME HAS EXFOLIATION CORROSION AT APPROXIMATELY LBL 16 - RBL 16. METAL RAISED UP. R & R AFT PRESSURE BULKHEAD DOOR FRAME IAW DWG 5917579, REV EE AND SRM 51-30-02, AND 51-30-01.SDR DALA2014062903825Seat Track · corrodedRBL 56 SEAT TRACK HAS MULTIPLE CORROSIONS BETWEEN BS 598-846. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW SECTION IAW 53-40-01, FIG 4 AND 51-10-05.SDR DALA2014101305491Skin · crackedFUSELAGE SKIN CRACKED AT BS 1542 JUST ABOVE STAIRWAY C/O RT SIDE. REMOVED DAMAGE AND HFEC IAW NDT SPM 06-10-01.001 DAMAGE CONTAINED. INSTALLED LOCK FASTENER IAW SRM 53-31-02, VOL I AND SRM 51-30-08, VOL II.SDR DALA2014063003835Skin · crackedFUSELAGE SKIN CRACKED AT NOSE WHEEL WELL LEFT AFT DOOR AFT HINGE. R & R IAW ERA 527126-14, REV O.SDR DALA2014062803824Cusp Web · corrodedCABIN LT CUSP WEB SHOWS SIGNS OF CORROSION AT BS 560-579. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED FILLER AND DOUBLERS IAW SRM 53-20-02.SDR DALA2014062803823Cusp Web · corrodedLEFT CUSP WEB SHOWS SIGNS OF CORROSION AT BS 541-560. REMOVED DAMAGE AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED FILLER AND DOUBLER IAW SRM 53-20-02, FIG 12.SDR DALA2014062803822Cusp Web · corrodedCABIN RT CUSP WEB SHOWS SIGNS OF CORROSION AT BS 1175-1194. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR IAW SRM 53-20-02.SDR DALA2014062703821Finger Doubler · corrodedAFT CARGO LONGERON 26L, FINGER DOUBLER CORRODED, BS 1260-1307. REMOVED DAMAGE. FABRICATED AND INSTALLED NEW FINGER DOUBLER DWG 5936667, REV BZ, BW, AND CD, DWG S00056 AND SR 53-00-01.SDR DALA2014062703820Seat Track · corrodedCABIN SEAT TRACK AT RBL 22, BS 200-265 HAS EXCESSIVE CORROSION. R & R SECTION OF SEAT TRACK IAW SRM 53-40-01, FIG 6.SDR DALA2014062603819Frame · corrodedAFT CARGO FORMER CORRODED MULTIPLE LOCATIONS, BS 1344, LONGERON 26L TO 26R. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW FORMER IAW DWG 9957739, REV DL.SDR DALA2014062603818Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT HEAVILY CORRODED, BS 1268, LONGERON 29R-28R. R & R FLOOR SUPPORT IAW SRM 51-30-02.SDR DALA2014062303716Pin · detachedPARACHUTE PINS ON FORWARD SERVICE DOOR SLIDE ARE DETACHED. R & R FORWARD SERVICE DOOR SLIDE IAW AMDS 2561-4641.SDR DALA2014062303715Battery Pack · inoperativeMAIN ENTRANCE EMERGENCY LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM. OPS CHECKED GOOD.SDR DALA2014062203714Threshold · corrodedFWD CARGO DOOR THRESHOLD HAS CORROSION FROM BS 370-408. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW THRESHOLD IAW SRM 53-60-02.SDR DALA2014062003669Angle · damagedBS 110, LOWER ANGLE DAMAGED. COMPLY WITH ERA 526227-14.SDR DALA2014061903668Bulkhead Web · damagedBS 110, BULKHEAD LOWER WEB DAMAGED. COMPLIED WITH ERA 526088-14, REV O.SDR DALA2014061903666Bulkhead Web · damagedBS 110, UPPER BULKHEAD WEB DAMAGED. COMPLY WITH ERA 526089-14, REV O.SDR DALA2014061903672Landing Gear · collapsedNOSE GEAR COLLAPSED DURING PUSHBACK. NOSE GEAR R & R IAW NR 92-3220-9-0001.SDR DALA14036459253Door Frame · corrodedAFT CARGO, LOWER DOOR FRAME CORRODED. REPAIRED DOOR FRAME IAW SRM 53-60-02, FIG 9A.SDR DALA2014062003671Bottle · low pressureLEFT AFT DOOR SLIDE PRESSURE LOW. R & R LT AFT SERVICE DOOR SLIDE PACK IAW JIC 2561-4642.SDR DALA2014061803664Support Angle · corrodedAFT CARGO DOOR CUTOUT FORWARD LOWER ANGLE SUPPORT CORRODED, BS 1212. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW SUPPORT ANGLE IAW DWG 5936469.SDR DALA2014061803663Skin · damagedDAMAGE INSIDE FIRST THREE HOLES ABOVE SKIN SPLICE AT STA Z52 LT SIDE. REPAIRED DAMAGE IAW ERA 526640-14AD, REV O.SDR DALA14036449216Shear Tie · corrodedAFT CARGO SHEAR TIE CORRODED AND BLOWN OUT, BS 1268 BETWEEN L29-30R. REMOVED, FABRICATED AND INSTALLED NEW SHEAR TIE IAW SRM 51-10-03 AND DWG 9936073, REV W.SDR DALA14036499253Spar · damagedVERTICAL STABILIZER LT SPAR DAMAGED. REPAIRED IAW ERA 526640-14AD, SECTION IISDR DALA14036079233Support · damagedLEFT AND RIGHT NLG AFT STRUT DOOR SUPPORT DAMAGED. R & R DOOR STRUT SUPPORT IAW DWG 5913421.SDR DALA14036479233Skin · damagedDAMAGE TO FUSELAGE SKIN AT BS 110-120, S28L-S28R. REPAIRED IAW ERA 526084-14, SECTION I.SDR DALA14036049230Structure · scratchedL1 DOOR HAS LARGE SCRAPE AT LOWER LEFT. REPAIRED DOOR EDGE IAW SRM 52-01-01. OK FOR SERVICE.SDR DALA14036019253Attach Angle · crackedWYE DUCT CEILING SUPPORT ATTACH ANGLE CRACKED. FABRICATED AND INSTALLED IAW DWG 5937954.SDR DALA14035989216Cusp Web · crackedINSIDE CABIN, BS 1358, CUSP WEB HAS CRACK BY NR 2 ENGINE WIRING AT FLOOR. REPAIRED AND INSTALLED CUSP WEB IAW SRM 53-20-02, FIG 19.SDR DALA14035979253Channel · crackedCRACK WAS FOUND ON CHANNEL ON THE VERTICAL STABILIZER ACTUATOR SUPPORT. REPAIRED IAW ERA 526678-14.SDR DALA14035969253Lug · damagedNOSE GEAR STEERING YOKE LUG DAMAGED. REPAIRED LEFT STEERING LUG IAW CMM 32-21-13.SDR DALA14035959253Lug · damagedNOSE GEAR LT STEERING YOKE LUG DAMAGED. REPAIRED LEFT STEERING LUG IAW CMM 32-21-13.SDR DALA14036489253Unknown · crackedCRACK REPAIRED IAW ERA 526678-14, SECTION I. COMPLIED WITH ERA 526678-14, SECTION II.SDR DALA14036039264Battery Pack · malfunctionedAFT EMERGENCY EXIT SIGN FLASHING ON AND OFF. R & R AFT EMERGENCY CABIN LIGHT BATTERY AND BATTERY PACK. OPERATION CHECKED GOOD.SDR DALA14036029222Electrical Sys · power lossPERFORMED AN AIR TURN BACK DUE TO ELECTRICAL POWER LOSS AFTER TAKEOFF. LT GENERATOR ON DEFERRAL AT TIME OF EVENT. TROUBLESHOT IAW FIM. FOUND CURRENT LIMITERS F1-23, F1-24 AND F1-25 ALL BLOWN. REPLACED CURRENT LIMITER, EPCU, RT GENERATOR, AND RIGHT BUSS TISDR DALA14036009253Frame · crackedAFT CANTED FRAME AT BS 1567 IS CRACKED AT TAIL CONE ALIGNMENT PIN. REMOVED, FABRICATED AND INSTALLED NEW FRAME, LATCHES AND RUBBER SEAL IAW DWG 9911843.SDR DALA14035949216Cusp Web · crackedINSIDE CABIN, BS 1358, CUSP WEB HAS CRACK AT LONGERON, 18L. REPAIRED CUSP WEB, STA 1358L IAW SRM 53-20-02, FIG 19 AND 53-10-02, FIG 11.SDR DALA14035939233Beam · damagedNLG WHEEL WELL UPPER I-BEAM ASSEMBLY DAMAGED. R & R NLG WHEEL WELL UPPER I-BEAM ASSEMBLY IAW ERA 526178-14, REV O AND DWG 9957865.SDR DALA14035929233Bracket · damagedNLG RETRACT ACTUATOR BRACKET DAMAGED. R & R NLG RETRACT ACTUATOR BRACKET IAW ERA 526178-14, REV O AND DWG 9911509.SDR DALA14035919233Support · crackedBS 110, NLG BUNGEE SUPPORT INSTALLATION CRACKED AND BENT. R & R BUNGEE SUPPORT IAW DWG 9911599.SDR DALA14035909232Web · damagedBS 101.55 CAPTAIN`S SIDE ELEVATOR CABLE FEED THROUGH AND WEB DAMAGED. REPAIRED IAW ERA 526158-14, REV O.SDR DALA14035559216Seat Track · damagedSEAT TRACK, RBL 24, BS 860-1070, HAS AREAS OF CORROSION AND WEAR. R & R DAMAGED SEAT TRACK IAW SRM 51-30-05.SDR DALA14035529216Cusp Web · corrodedRIGHT CUSP WEB, BS 579-598, HAS LIGHT AREA OF CORROSION. REPAIRED CUSP WEB IAW SRM 53-20-02.SDR DALA14035519233Bulkhead Web · damagedRIGHT SIDE NOSE WHEEL WEEL WEB DAMAGED. R & R DAMAGED WEB IAW DWG 9910088.SDR DALA14035509233Bulkhead Web · damagedLEFT SIDE NOSE WHEEL WELL WEB DAMAGED. R & R DAMAGED WEB IAW DWG 9910088.SDR DALA14035499233Support · damagedBS 110, E/E BAY MAIN BATTERY SUPPORTS DAMAGED. R & R DAMAGED SUPPORTS IAW DWG 996454, SHEET 1, ZONE 19 AND 22.SDR DALA14035489233Panel · damagedRELAY SUPPORT PANEL, BS 113, DAMAGED. R & R SUPPORT PANEL AND BRACKETS.SDR DALA14035479233Trunnion · damagedRIGHT NLG TRUNNION FITTING DAMAGED. REMOVED, REAMED AND INSTALLED TRUNNION IAW DWG 9910088.
Back to Boeing MD-90-30