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 DALA13061369253Lanyard · frayedL1 DOOR SLIDE LANYARD FRAYED. REMOVED AND REPLACED SLIDE LANYARD PER AMM. CHECKED NORMAL.SDR DALA13061329217Frame · crackedCANTED FRAME WEB CRACKED, BS 1520. REPAIRED IAW ERA 520724-14, REV ORIGINAL.SDR DALA13061139208Lanyard · frayedDURING SERVICE CHECK, R1 DOOR SLIDE LANYARD FOUND FRAYED. REMOVED AND REPLACED LANYARD IAW AMM.SDR DALA13061119217Frame · crackedBS 1549 FRAME CRACKED. REPAIRED IAW SRM 53-10-03.SDR DALA13061129230Cable · brokenFOUND L1 DOOR GIRT BAR CABLE BROKEN. REMOVED AND REPLACED CABLE ASSEMBLY. OPS CHECKED OK IAW AMM.SDR DALA13060099259Lanyard · frayedDURING SERVICE CHECK, FOUND DOOR SLIDE LANYARD FRAYED. MAINTENANCE REMOVED AND REPLACED SLIDE LANYARD PER MM.SDR DALA13060049246Socket · damagedEMERGENCY CEILING LIGHT, ROW S INOPERATIVE. MAINTENANCE ADJUSTED TAB ON SOCKET. OPS CHECKED NORMAL IN STANDBY POSITION.SDR DALA13060119203Cable · frayedL2 GIRT BAR CABLE FRAYED. MAINTENANCE REMOVED AND REPLACED GIRT BAR LANYARD PER AMM.SDR DALA13060019208Vapor Barrier · corrodedBS 938, VAPOR BARRIER HAS CORROSION LBL 54. REMOVED CORROSION. RESTORED IAW ERA 516488-14AD, REV O.SDR DALA13060009208Fuel Cell · corrodedCENTER TANK UPPER SURFACE, BS 950, HAS CORROSION. CUT OUT DAMAGED AREA. FABRICATED NEW FILLER, DOUBLER AND SHEAR CLIPS. TREATED, PRIMED AND INSTALLED REPAIR PARTS IAW ERA 516488-14AD, REV O.SDR DALA13059999208Skin · corrodedSKIN CORRODED AT BS 952, LBL 24-44L. REMOVED CORROSION, REWORKED, TREATED, PRIMED AND RESTORED VAPOR BARRIER IAW ERA 516488-MA, REV O.SDR DALA1405369217Spar Cap · damagedVERTICAL STABILIZER, L/E FRONT SPAR CAP FOUND DAMAGED. REPAIRED IAW AA 5530-01044.SDR DALA13060029215Attach Angle · crackedDURING VERTICAL STABILIZER INSPECTION, FOUND RIGHT INTERNAL ATTACH ANGLE CRACKED. REMOVED AND REPLACED ANGLE AND FASTENERS IAW DWG 5912188 AND SRM 51-30.SDR DALA1405359217Skin · damagedHORIZONTAL STAB UPPER CENTER SKIN PANEL FOUND DAMAGED. REPAIRED IAW AA 5510-01085.SDR DALA13060039208Bulkhead · corrodedAFT PRESSURE BULKHEAD LOWER DOOR JAMB HAS CORROSION. CUT OUT DAMAGE. LOCATED, DRILLED, FABRICATED AND INSTALLED REPAIR SPLICE DOUBLER IAW SRM 51-30-02, 53-60-02, FIG 3 AND 51-10-05.SDR DALA13059559225Receptacle · wornDURING SERVICE CHECK, TAILCONE RELEASE UPPER TWO LATCH PINS AND RECEPTICLES WORN. REMOVED AND REPLACED UPPER LATCH PINS AND RECEPTICLES IAW SRM 53-52-01. OPS CHECKED ON AMDS 5352-7116.SDR DALA13059229225Lanyard · frayedDURING SERVICE CHECK, TAILCONE NITROGEN JETTISON LANYARD WAS FOUND FRAYED. MAINTENANCE REMOVED AND REPLACE LANYARD.SDR DALA13059219239Lanyard · frayedDURING SERVICE CHECK, R1 DOOR SLIDE LANYARD WAS FOUND FRAYED. MAINTENANCE REMOVED AND REPLACED R1 DOOR SLIDE LANYARD IAW AMM.SDR DALA13060109208Cusp Web · corrodedCUSP WEB FS 950 CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED CUSP WEB FROM BS 902 TO 962 IAW SRM 53-20-02 AND DWG 69940443.SDR DALA13059569208Longeron · crackedAFT ACCESSORY COMPARTMENT, BS 1475, LONGERON 2 LT CRACKED. FABRICATED AND INSTALLED NEW LONGERON AND ANGLE SUPPORT IAW SRM 51-30-05 AND ERA 500312-14.SDR DALA13059549208Frame · crackedBS 962 FRAME HAS A CRACKED. REMOVED DAMAGED FRAME SECTION. LOCATED, DRILLED AND INSTALLED NEW FRAME SECTION IAW DWG SR90530027, REV A.SDR DALA13059209208Seat Track · damagedMAIN CABIN SEAT TRACK FROM FS 845-1155, LBL 54.5, HOLES FOUND ELONGATED. FABRICATED, TREATED, PRIMED AND INSTALLED NEW SEAT TRACK IAW SRM 53-40-01, 51-10-03, & 51-30-02.SDR DALA13059239251Pin · unsecureL1 DOOR SLIDE PACK DEPLOYMENT CABLE PIN IS NOT ATTACHED. MAINTENANCE ATTACHED CABLE PIN, SHOULD HAVE BEEN REMOVED DURING SLIDE INSTALLATION. AIRCRAFT OKAY FOR SERVICE.SDR DALA13059199229Web · damagedFOUND DAMAGE ON WEB BY MID JACKSCREW AREA 1 X 1 1/2 HOLE. INSTALLED REPAIR IAW PRI ERA 520433-14 .SDR DALA13059179208Skin · chafedCHAFING IN SKIN ON LT WING OUTBOARD FLAP, UPPER SURFACE, APPROXIMATELY 24 INCHES FROM OUTBOARD END. BLENDED AREA. FOUND TO BE OUT OF LIMITS. FABRICATED, TREATED, PRIMED INSTALLED IAW ERA 516489-14.SDR DALA13059189232Bottle · out of toleranceDURING SERVICE CHECK, MAINTENANCE FOUND TAILCONE EVACUATION SLIDE DISCHARGE BOTTLE PRESSURE OUT OF RANGE. MAINTENANCE REMOVED AND REPLACED TAILCONE SLIDE.SDR DALA13059169208Frame · corrodedAFT CARGO BILGE AREA, BS 1364, LOWER FRAME HAS CORROSION LONGERON 28R-28L. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. INSTALLED FRAME REPAIR IAW SRM 53-10-02.SDR DALA13058079228Battery Pack · inoperativeDURING SERVICE CHECK, FOUND LOWER EMERGENCY EXIT LIGHTS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY PACK. OPS CHECKED NORMAL.SDR DALA13058069228Battery Pack · inoperativeDURING SERVICE CHECK, OVERHEAD EMERGENCY LIGHTS AT ROW 24 AND 25 FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY PACK. OPS CHECKED NORMAL.SDR DALA13058059201Wire · damagedDURING SERVICE CHECK, FOUND TWO EMERGENCY LIGHTS AT ROW 5-7 INOPERATIVE. MAINTENANCE FOUND LOOSE WIRE SPLICE FOR CEILING EMERGENCY LIGHTING. WIRE TERMINAL RESEATED. OPS CHECKED NORMAL.SDR DALA13058049253Power Supply · inoperativeDURING SERVICE CHECK, FOUND LEFT AND RIGHT EXIT SIGNS, AFT OVERWING THRESHOLD INOPERATIVE. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY B5-230. OPS CHECKED NORMAL.SDR DALA13056579208Door Frame · damagedAFT CARGO DOOR FRAME SURROUNDING DOOR STOPS STRUCTURAL HAS DETERIORATED, CHIPPED PAINT. REPAIRED IAW SRM 53-60-02, PARA 14.SDR DALA13060059208Skin · dentedLEFT HAND LOWER FUSELAGE SKIN BS 275 BETWEEN L25-26L FOUND DENTED. EVALUATED DENT, FOUND TO BE OUT OF LIMITS. DRILLED AREA, HFEC, NO CRACKS FOUND. TREATED, PRIMED AND INSTALLED RIVETS IAW SRM 53-31-01, 53-31-02 AND 51-10-03.SDR DALA13056589208Skin · corrodedEXTERIOR SKIN AT FS 864, LONGERON 29R CORRODED. REMOVED CORROSION, FABRICATED, TREATED, PRIMED AND INSTALLED NEW DOUBLER IAW SRM 53-30-01, 51-30-03 AND PL 900-5-1, NR 4.SDR DALA13055619223Battery Pack · inoperativeDURING SERVICE CHECK, FOUND TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE RESET AFT BATTERY RACK. OPS CHECKED GOOD.SDR DALA13055609220Spar Cap · crackedRT HORIZONTAL STABILIZER UPPER SPAR CAP, CRACKED. REPAIRED IAW PRI 519463-14, REV 2. C/W FINAL ERA 519463-14AD, REV ORG.SDR DALA13055599220Spar Cap · crackedRT HORIZONTAL STABILIZER UPPER SPAR CAP CRACKED. REPAIRED IAW PRI ERA 519463-14, REV 0 AND PRI ERA 519463-14 REV 2.SDR DALA13056599208Bulkhead · damagedFORWARD FACE OF AFT PRESSURE BULKHEAD, BS 1395, HAS BARE METAL EXPOSED. BOTTOM OF LONGERON 30-29R. CLEANED THE AREA'S METAL AND LOCATED HEAVY CORROSION THAT IS OUT OF LIMITS. REPAIRED IAW SRM 51-10-05, 51-30-05 AND DWG 9915561.SDR DALA13055249220Fitting · crackedRIGHT HORIZONTAL STABILIZER HINGE PIVOT FITTING CRACKED. CRACK EXCEEDS LIMITS. REPAIRED IAW ERA 519756-14AD ORIG.SDR DALA13055239220Skin · crackedAFT UPPER SKIN CRACKED ON HORIZONTAL STABILIZER. REPAIRED IAW ERA 519495-14, REV ORIG.SDR DALA13054539220Pin · galledHORIZONTAL STABILIZER PIVOT PIN GALLED. INSTALLED NEW PIN ON PRI 519756-14.SDR DALA13054529220Pin · galledHORIZONTAL STABILIZER PIVOT PIN GALLED. NEW PIN INSTALLED ON PRI 519756-14.SDR DALA13054549220Structure · corrodedUPPER AFT HOLE ON CENTER SECTION, RT SIDE, CORRODED. OPENED HOLE. REMOVED CORROSION. NO CRACKS FOUND. FABRICATED AND INSTALLED BUSHING IAW PRI 519682-14, REV 4.SDR DALA13054579234Battery Pack · inoperativeDURING SERVICE CHECK, EMERGENCY CEILING LIGHTS, ROW 13-21, WILL NOT REMAIN ARMED. MAINTENANCE R & R B5-228 BATTERY PACK IAW AMM. OPS CHECKED NORMAL.SDR DALA13054559220Spar · corrodedRIGHT HORIZONTAL STABILIZER, UPPER AFT SPAR INBD FORWARD ATTACH HOLE BORE IS CORRODED. BURNISHED OUT CORROSION. FABRICATED AND INSTALLED BUSHING IAW ERA 519683-14.SDR DALA13054519220Fitting · damagedDAMAGE AT UPPER SECOND FROM AFT HOLE ON CENTER SECTION, FITTING. REMOVED DAMAGE. INSTALLED BUSHINGS IAW SRM 55-10-03.SDR DALA13054569208Skin · damagedFUSELAGE SKIN, BS 351, BETWEEN LONGERONS 26 AND 27R HAVE LIGHTNING STRIKES. BLENDED LIGHTNING STRIKE. FOUND TO BE OUT OF LIMITS. FABRICATED INTERNAL DOUBLER, TREATED, PRIMED, AND INSTALLED DOUBLER REPAIR IAW SRM 51-31-01, 53-31-02 AND 51-30-02.SDR DALA13053549238Battery Pack · disconnectedDURING SERVICE CHECK, EMERGENCY EXIT LIGHTS IN CEILING AT ROWS 24 AND 25 INOPERATIVE. FOUND BATTERY PACK NOT CONNECTED. RECONNECTED AT LOCATION B5-243. OPS CHECKS GOOD.SDR DALA13053489208Seat Track · corrodedMAIN CABIN SEAT TRACK, BS 1193, LBL 44, IS CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW SEAT TRACK IAW SRM 53-40-01.SDR DALA13053479208Seat Track · corrodedSEAT TRACK, BS 200-256 RBL 44 HAS CORROSION ON UPPER SURFACE OF SCALLOPS AND UPPER SURFACE OF FLANGE. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. CUTOUT DAMAGED SEAT TRACK. FABRICATED NEW SEAT TRACK SECTION AND INSTALLED IAW SRM 53-40-01 AND 51-10-03.
Back to Boeing MD-90-30