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 DALA1504119263Lug · unknownHORIZONTAL STABILIZER HINGE RIB PIVOT BEARING LUG REPAIRED IAW AA 5510-01083.SDR DALA1504109263Fastener · unknownPYLON AFT SPRT FITTING UPPER FASTENERS REPLACED IAW AA 5440-01069.SDR DALA1504099263Frame · unknownBS 883-BS962 OVERWING FRAMES REPAIRED IAW AA 5310-01375.SDR DALA1504089263Stop Fitting · unknownCARGO DOOR STOP PAD FITTINGS REPAIRED IAW AA 5230-01136.SDR DALA1504079263Jackscrew · unknownHORIZONTAL STABILIZER, JACKSCREW ASSY REPAIRED IAW AA 2740-01071.SDR DALA1213369235Skin · crackedRUDDER SKIN CRACKED AT NR 3 HINGE CUTOUT RT SIDE. REPAIRED RUDDER SKIN AT NR 3 HINGE CUTOUT PER MD 90 SRM 55-41-01 PAGES 111 AND 112 AND PERFORMED WEIGHT AND BALANCE USING CHECK WEIGHT METHOD WITHIN LIMITS PER MD90 SRM 55-40-01.SDR DALA1209699226Control Unit · odorACFT EXPERIENCED HAZE AND FUMES IN THE CABIN DURING TOP OF DESCENT. MAINTENANCE OPERATED CABIN LIGHTING AND GALLEY ELECTRICAL POWER. NO TROUBLE FOUND. OPERATED BOTH PACKS WITH APU AIR AT HOT AND COLD. RAN ENGINES AT HIGH POWERSETTINGS WITH PACKS RUNNING. SDR DALA13059589208Skin · crackedFUSELAGE SKIN BS 1475 L2L CRACKED, REPAIRED IAW ERA 500312-14, REV B.SDR DALA1216089202Cusp Web · crackedCABIN RT CUSP WEB BETWEEN STA 1344 AND STA 1364 AT LIGHTENING HOLE EDGE CRACKED. REMOVED DAMAGE AND FASTENERS. FABRICATED DOUBLER, FILLER, AND INSTALLED REPAIR PARTS PER MD 90 SRM 53-20-02 FIG. 6.SDR DALA1209589208Skin · crackedDURING PSV, A CRACK WAS DISCOVERED IN THE FUSELAGE SKIN AT BS 1494 BETWEEN L2R AND L3R. ACCOMPLISHED REPAIR PER SRM 53-31-03 FIG 8.SDR DALA1504129263Skin · unknownHORIZONTAL STABILIZER UPPER CENTER SKIN PANEL REPAIRED IAW AA 5510-01085.SDR DALA1317569208Frame · crackedCANTED FRAME AT BS 1542 WAS FOUND WITH A CRACK APPROX .5". THE CRACK RUNS FROM THE CORNER INBD NEAR ZR=-30. REPAIR IAW ERA 500264-14.SDR DALA1212169202Floorbeam · damagedREMOVED EXISTING REPAIR BEAM STA 712 TO 731 AS PER MD90 SRM 51-30-04. FOUND TO BE OUT OF LIMITS AT STA 699 AND 744 AS PER MD90 SRM 53-00-01. AFTER FURTHER INSP, HOLE OF SHEAR FASTENERS TO BE ELONGATED. REPAIRED HOLES AS PER MD90 SRM 51-30-0 PG 1 INSTALLED FSDR DALA1212119202Floorbeam · damagedREMOVED EXISTING REPAIR BEAM STA 712 TO 731 AS PER 51-30-04. FOUND TO BE OUT OF LIMITS STA 699 AND STA 744 AS PER MD90 SRM 53-00-01. AFTER FURTHER INSP, HOLE OF SHEAR FASTENERS TO BE ELONGATED. REPAIRED HOLES AS PER MD 90 SRM 51-30-00 PG 1. INSTALLED FREEZSDR DALA1209759225Battery Pack · inoperativeDURING CHECK, MAINTENANCE FOUND BOTH OVERWING EMERGENCY LIGHTS WOULD NOT GO OUT IN THE ARMED POSITION. REMOVED AND REPLACED BATTERY PACK FOR THE OVERWING EMERGENCY LIGHTS. OPS CHECKED GOOD PER AMM. AIRCRAFT OKAY FOR SERVICE.SDR DALA1214699202Seat Track · corrodedMAIN CABIN SEAT TRACK AT RBL 54.50 STA 452 TO 845 FOUND CORREDED & OUT OF LIMITS IN REF WITH MD90 SRM 53-40-01. FABRICATED SEAT TRACKS AT RBL 54.5 STA 452-845IN REF WITH DWG 5930565 SHT 1. INSTALLED SEAT TRACKS IN REF WITH MD90 AMM 53-42-01.SDR DALA1211969202Seat Track · corrodedMAIN CABIN SEAT TRACKS AT RBL 54.50, STA 452 TO STA 845 FOUND CORRODED & OUT OF LIMITS IN REF WITH MD 90 SRM 53-40-01. FABRICATED SEAT TRACKS AT RBL 54.50 STA 452 TO STA 845 IN REF WITH DWG 5930565 SHT 1. INSTALLED SEAT TRACKS IN REF WITH MD 90 AMM 53-42-01.SDR DALA1208819208Skin · crackedDURING PSV, A CRACK WAS FOUND ON THE FUSELAGE SKIN AT BS 1475 AND L3L. REPAIRED PER ER/A 500312-14.SDR DALA1208459236Fastener · looseCW EA 02-476701-12AD INSPECTED PYLON SUPPORT FITTING FOR LOOSE OR MISSING FASTENERS. REMOVED & REPLACED FASTENERS IN ROW A PER OPN 0301 NR 1 PYLON.SDR DALA1208489230Skin · dentedON INSPECTION, FOUND DENT AT STATION 234, 34 INCHES AFT OF L1 DOOR AND 24 INCHES UP FROM LOWER LIP OF DOOR. PERFORMED INSPECTION PER ERA500280-14. PERMANENT REPAIR PER ERA 500280-14. DUPLICATE WRITE-UP ON DELTA LOG 959383001.SDR DALA1208469236Fastener · looseCW PYLON SUPPORT FITTING FASTENER INSPECTION FOR LOOSE, DAMAGE OR MISSING FASTENERS CONDITION PER EA02-476701-12AD.SDR DALA1215669235Support Fitting · damagedINSPECT AND REPLACE LT MLG ACTUATOR SUPPORT FITTING. DAMAGE FOUND PER STEPS 5 & 6 PER EA02-093855-03AD REV A. AAR N/R 838261 GENERATED FOR BEARING BORE AND BUSHING BORE. INSTALLED NEW SUPPORT BEARING, BUSHING, AND FITTING PER EA 02-093855-03AD REV A OPN 010SDR DALA1214819235Skin · damagedFIXED ELT DEACTIVATION APPROX STA 1374. REMOVED ELT ANTENNA AND REPAIR WAS ACCOMPLISHED ON FUSELAGE PER SRM 53-30-01 REF ERA 02-477733-03 REV D ME04 OPN 0401. REF AAR N/R 838287.SDR DALA1214609235Doubler · damagedFIXED ELT DEACTIVATION APPROX STA 1374. REMOVED ELT ANTENNA AND REPAIR WAS ACCOMPLISHED ON FUSELAGE PER SRM 53-30-01, 53-31-03 REF EA 02-477733-03 REV D ME 04 OPN 0401.SDR DALA1209139208Release Cable · frayedTAIL CONE JETTISON BOTTLE CABLE FRAYED. REMOVED AND REPLACED CABLE. INSTALLED ON AIRCRAFT SIDE. CONNECTION TO TAIL CONE ACCOMPLISHED.SDR DALA1209129208Screw · looseTAIL CONE JETTISON NOZZLE, MISSING SCREW AND OTHER OTHER SCREWS LOOSE. INSTALLED NEW SCREW AND TIGHTENED REMAINING 3 LOOSE SCREWS.SDR DALA1209119208Release Cable · misinstalledTAIL CONE JETTISON BOTTLE ACTUATION CABLE IMPROPERLY INSTALLED, WRAPPED AROUND BOTTLE. REMOVED AND REPLACED CABLE.SDR DALA1208049227Power Supply · inoperativeDURING SERVICE CHECK, MAINTENANCE FOUND RIGHT CEILING EMERGENCY LIGHT INOPERATIVE, ROW 38DEF. MAINTENANCE REMOVED AND REPLACED AFT POWER SUPPLY, ABOVE FLIGHT ATTENDANT STATION. OPERATION CHECKS GOOD. AIRCRAFT OKAY FOR SERVICE.SDR DALA1227449234Structure · damagedDURING HMV AT MIA, THE AFT FUSELAGE WAS DAMAGED DURING A JACKING INCIDENT. AREAS REPAIRED ERA 502765-14 REV O.SDR DALA1227419234Skin · damagedFUSELAGE WRINKLED BETWEEN STA 769-788 BETWEEN L26L AND L18L DURING JACKING INCIDENT. REPAIRED PER ERA 491788-14 REV O.SDR DALA1227399234Skin · damagedFUSELAGE SKIN WRINKLED BETWEEN STA 769-807 BETWEEN L26R AND L26L DURING A JACKING INCIDENT. REPAIR PER ERA 487467-14 REV O.SDR DALA1216229202Cusp Web · corrodedCORROSION FROM STA 160 TO STA 200 LBL 10 ON CUSP WEB. REMOVED CORROSION AND FOUND OUT OF LIMITS. FABRICATED WEB FROM 7075 T6 .020 AND DOUBLER FROM 7075 T6 .025. INSTALLED REPAIR PER MD 90 SRM 53-20-02SDR DALA1227429234Stiffener · crackedLT UPPER FUSELAGE VENT BOX FWD STIFFENER CRACKED. REPLACED STIFFENER PER MD 90 SRM 51-30-05.SDR DALA1227409234Skin · damagedFUSELAGE SKIN AND FRAME CLIPS PULLED OUTWARD AT 4 EA EXTERNAL WEIGHT ATTACH POINTS. ALSO BOTH LOWER BLIND NUTS LOOSE STA 218 L19L TO L20L. DAMAGE OCCURRED DURING JACKING INCIDENT. REPAIRED AREAS PER ERA 491740-14SDR DALA1214669202Cusp Web · crackedCABIN LT CUSP WEB CRACKED AT STA 1136. REMOVED DAMAGE CUSP WEB. FABRICATED CUSP WEB IN REF DWG 9910151 SHEET 8. INSTALLED CUSP WEB IN REF MD90 SRM 53-20-02.SDR DALA1211999202Cusp Web · crackedCABIN LT CUSP WEB CRACKED AT STA 1136. REMOVED DAMAGED CUSP WEB FABRICATED CUSP WEB IN REF DWG 9910151 SHT 8. INSTALLED CUSP WEB IN REF MD90 SRM 53-20-02 REF N/R 862342 (53-20-02).SDR DALA1210489202Door Frame · corrodedFWD LWR CARGO COMPT DOOR JAMB FROM STA 389 - 427 FOUND AREAS CORRODED. CORROSION FOUND OUT OF LIMITS OF MD 90 SRM 53-00-01. CUT OUT DAMAGED LWR DOOR JAMB PER SRM 53-60-02. FABRICATED REPAIR SPLICE AND PARTS. INSTALLED REPAIR IAW MD-90 SRM 53-60-02.SDR DALA1214759202Skin · corrodedFWD CARGO COMPT CORRODED AT INNER SKIN O/B OF L26L, FWD OF STA 237. REMOVED CORROSION ON INNER SKIN & LONGERON L26L & FOUND WEAR. REMOVED CORROSION OF FINGER DOUBLER & FOUND OUT OF LIMITS. REMOVED DAMAGED FINGER DOUBLER. FABRICATED NEW FINGER DOUBLER. INSSDR DALA1211989202Cusp Web · corrodedCABIN RT CUSP WEB CORRODED AT STA 1079 TO STA 1098. REMOVED FASTENERS AND CUTOUT DAMAGED AREA. FABRICATED DOUBLER REPAIR PARTS. TREATED AND PRIMED REPAIR PARTS. INSTALLED REPAIR DOUBLERS REF AAR N/R 862366 (53-20-02 FIG 11)SDR DALA1210509202Skin · corrodedFWD CARGO COMP CORRODED AT INNER SKIN O/B OF L26L FWD OF STA 237. REPLACED SKIN AND DOUBLER.SDR DALA1227439234Frame · damagedAPU COMP AT FWD PRESSURE BULKHEAD LWR FRAME DAMAGED DURING JACKING INCIDENT. BOEING AOG REPLACED FRAME UNDER BOEING AGREEMENT #DAL-RE-1207549R2 AND REPAIR INDEX ITEM # 7.2 DAMAGE SURVEY 21.SDR DALA1214659202Cusp Web · crackedCABIN LT CUSP WEB BETWEEN STA 962 & STA 984 LIGHTNING HOLES CRACKED IN TWO PLACES. REMOVED FASTENERS & CUT OUT DAMAGED AREA FABRICATED DOUBLER REPAIRS, TREATED & PRIMED REPAIR PARTS. INSTALLED REPAIR IN REF WITH MD90 SRM 53-20-02. REF SRM 53-20-02 FIG 7.SDR DALA1211979202Cusp Web · crackedCABIN LT CUSP WEB BETWEEN STA 962 TO 984 LIGHTENING HOLES CRACKED IN TWO PLACES. REMOVED FASTENERS AND CUTOUT DAMAGED AREA. FABRICATED DOUBLER REPAIRS. TREATED AND PRIMED REPAIR PARTS. INSTALLED REPAIR IN REF WITH MD90 SRM 53-20-02. REF AAR N/R 862345 (SRSDR DALA1206739201Structure · damagedPERFORMED BOLT HOLE INSPECTION PER PRI 499823-14 AND DOUGLAS/BOEING NDTSP MANUAL PART 6 CHAPTER 06-10.003. NO CRACKS NOTED. PRI REPLACED BY ERA 499823-14 REV O.SDR DALA1206729201Skin · damagedPERFORMED HFEC L-17L 2 INCHES FORWARD AND AFT OF FS 238 PER DOUGLAS BOEING NDTSP MANUAL PART 06-10-01-001 STEP 5 OF PRI 499823-14. NO CRACKS NOTED. STEP 5 OF PRI 499823-14 REPLACED BY ERA 499823-14 REV O.SDR DALA1206719201Pan · crackedDURING REPAIR OF DOUBLER FOUND CRACK IN FLOOR PAN AT FS 229 INBOARD OF L-18L APPROXIMATELY 2.25 INCHES LONG. REMOVED DAMAGED FLOOR WEB, DRILLED AND INSTALLED REPLACEMENT FLOOR WEB PER SRM 51-30-02, FS 229 INBOARD OF L-18L.SDR DALA1206699201Skin · damagedCOMPLY WITH ITEM 7 OF PRI, RE-ACCOMPLISH AFT QUADRANT SKIN REPAIR. DRILLED, INSTALLED AND PAINTED AFT QUADRANT SKIN REPAIR DOUBLER PER ERA 499823-14 REV O.SDR DALA1206679201Shear Tie · damagedCOMPLY WITH STEP 6 OF PRI. REPLACED P/N 99-11524-3, SHEAR TIE ANGLE. DRILLED UP NEW SHEAR TIE ANGLE AND INSTALLED PER ERA 499823-14 REV O.SDR DALA1206669201Doubler · damagedREMOVED DOUBLER REPAIR INSTALLED PER ERA385357-14 PER PRI499823-14. PRI REPLACED BY ERA 499823-14 REV O.SDR DALA1206659201Shear Tie · damagedREMOVED DAMAGED FORMER SHEAR TIE ANGLE PER PRI499823-14. PRI REPLACED BY ERA 499823-14 REV ORIGINAL.
Back to Boeing MD-90-30