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 DALA14035469233Trunnion · damagedLEFT NLG TRUNNION DAMAGED. REMOVED, REAMED AND INSTALLED TRUNNION IAW DWG 9910088.SDR DALA14035459233Longeron · damagedBS 110, LONGERONS 29L DAMAGED. R & R DAMAGED LONGERON IAW DWG 5911401, SHEET 1, ZONE 12.SDR DALA14035449253Skin · crackedSKIN CRACKED FORE AND AFT OF FASTENER HOLE AT BS 1475, TWO INCHES OTBD OF LONGERON 2R. REPAIRED IAW ERA 526638-14, REV O, SECTION I.SDR DALA14036469253Skin · crackedSKIN HAS FOUR CRACKS NEAR L2R, BS 1475. COMPLIED WITH ERA 526638-14, SECTION I.SDR DALA14035539216Bracket · corrodedCORROSION AT OTBD SIDE, BRACKET, ATTACHED TO RT CUSP WEB, RBL 56, BS 1301. REMOVED AND REPAIRED CUSP WEB IAW SRM 53-201-02, FIG 10 AND 51-10-03.SDR DALA14035549216Cusp Web · corrodedRIGHT CUSP WEB, BS 1231-1250, CORRODED. R & R IAW SRM 53-20-02, FIG 10 AND 53-10-03, FIG 11.SDR DALA14035439216Cusp Web · crackedRIGHT CUSP WEB BS 788-807 CRACKED. R & R IAW SRM 53-20-02, 53-10-02.SDR DALA14033989256Skin · corrodedCORROSION ON INTERIOR SKIN 6 INCHES AFT OF BS 1211 NEAR C3 BEAM AFT CARGO. REPAIRED DURING C-CHECK.SDR DALA14033969256Shear Tie · crackedDURING HFEC, FOUND CRACKS EMANATING FROM FASTENER HOLE, BS 1475, L2R. REMOVED FASTENERS, CLIPS AND SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE AND SKATE ANGLE IAW ERA 526295-14, REV O.SDR DALA14033959256Frame · crackedDURING HFEC, FOUND LT SIDE OVERWING FRAME BS 962 IS CRACKED. R & R FRAME IAW AMDS WC 5310-01375-0302.SDR DALA14033949256Frame · crackedLEFT SIDE OVERWING FRAME BS 962, IS CRACKED. R & R LEFT OVERWING FRAME IAW WC 5310-01375-0302.SDR DALA14033599256Skin · corrodedCORROSION ON INTERIOR SKIN, 6 INCHES AFT OF BS 1211. REPAIRED IAW ERA 526299-14, REV O.SDR DALA14033579232Oil System · leakingPERFORMED AN IN FLIGHT SHUTDOWN AND AN AIR TURN BACK DUE TO LT ENGINE OIL QUANTITY LOSS WITH OIL QTY INDICATION AT ZERO. MAINTENANCE FOUND OIL IN COWLING AND ON ENGINE. ENGINE CHANGE REQUIRED DUE TO ENGINE OPERATION WITH NO OIL PRESSURE FOR 3 MINUTES.SDR DALA14033999220Clevis · brokenFOUND CATWALK DOWN AND CABLE ON LT SIDE OF CATWALK LOOSE. FOUND LT CABLE AFT CLEVIS SNAPPED. R & R CLEVIS AND RIGGED IAW AMM.SDR DALA14033979222Structure · damagedDAMAGE FOUND ON THE RT LOWER HORIZONTAL STABILIZER PLANK JUST AFT OF THE FRONT SPAR. REPAIR COMPLETE IAW ERA 526487-14, REV O.SDR DALA14033609256Seal Depressor · corrodedDURING C CHECK, CORROSION FOUND ADJACENT TO THE C3 BEAM AND SEAL DEPRESSOR APPROXIMATELY AT BS 1220. ERA 526299-14, SECTION I REPAIR WAS ACCOMPLISHED.SDR DALA14032979222Skin · corrodedFOUND EVIDENCE OF CORROSION AT LAP JOINT, FWD OF RT APU DOOR, APPROXIMATELY BS 1394 BETWEEN L24 -25R. COMPLIED WITH ERA 525661-14, REV O.SDR DALA14032999246Pin · disengagedL1 DOOR SLIDE PACK PINS PULLED. R & R SLIDE IAW AMDS WC 2561-01-01358-02A.SDR DALA14033569222Skin · damagedSKIN DAMAGED BS 1318, L26L - 26R. REPAIRED IAW ERA 525752-14, SECTION 1.SDR DALA14032949222Attach Fitting · corrodedFUSELAGE TAILCON ATTACH FRAME HAS MILD CORROSION ON AFT FACE AT 6 O'CLOCK POSITION FROM LBL 14 TO RBL 14. REPAIRED IAW ERA 526342-14, REV O.SDR DALA14032929222Beam · damagedAFT CARGO DOOR BEAM, FOUND OUT OF LIMITS AND R & R IAW DWG 591104.SDR DALA14032919222Skin · stretchedLOWER FUSELAGE EXTERNAL SKIN STRETCHED AT FORWAD SIDE OF AFT PRESSURE BULKHEAD FS 1402. R & R BELLY SKIN IAW DWG 593667 AND ERA 525752-14 REV O.SDR DALA14032909222Tee Fitting · corrodedCORROSION ON AFT PRESSURE BULKHEAD TEE FITTING LOWER FORWARD FLANGE LOWER SURFACE BETWEEN LONGERON 27R AND 28R. ACCOMPLISHED ERA 525970-14, REV O, SECTION I.SDR DALA14032899222Longeron · corrodedMULTIPLE SPOTS OF CORROSION ON LONGERON 27R BS 1318 - 1402. R & R LONGERON IAW DWG 5936667 AND ERA 525752-14, REV O, SECTION I.
SDR DALA14032889222Longeron · corrodedMULTIPLE SPOTS OF CORROSION ON LONGERON 28R AT BS 1318 - 1402. R & R LONGERON IAW DWG 5936667 AD ERA 1463600-14, REV O, SECT I.SDR DALA14032879222Tee Fitting · corrodedCORROSION ON AFT PRESSURE BULKHEAD TEE FITTING, BS 1395, LOWER HORIZONTAL SURFACE BETWEEN LONGERON 26R - 26L. R & R IAW ERA 525970-14, REV O.SDR DALA14032869222Longeron · corrodedMULTIPLE SPOTS OF CORROSION LONGERON 29R FROM SPLICE BS 1318 AFT BS 1402. R & R LONGERON IAW DWG 5936667 AND ERA 525752-14, REV O.SDR DALA14032859222Longeron · corrodedCORROSION ON LONGERON 29L BETWEEN FS 1290-1307. R & R THE LONGERON IAW DWG 5936667 AND ERA 52752-14, REV O. SECTION I.SDR DALA14032849222Longeron · corrodedCORROSION ON LONGERON 30 FORWARD OF BS 1307. R & R THE LONGERON IAW DWG 5936667 AND ERA 525752-14, REV O., SECT I.SDR DALA14032969256Frame · crackedCANTED FRAME BS 1520 FORWARD AND AFT WEBS CRACKED LT SIDE. REPAIRED CANTED FRAME IAW ERA 526282-14, REV O.SDR DALA14032959256Frame · crackedCANTED FRAME, BS 1542 FORWARD AND AFT WEBS CRACKED LT SIDE. CUT OUT CRACKED FRAME AND HFEC. REPAIRED IAW SRM 53-10-03, PARA 14.SDR DALA14032729222Frame · corrodedCORROSION AFT OF FRAME BS 1328 BETWEEN L29-30L. REPAIRED IAW SRM 51-70-01.SDR DALA14032719222Frame · corrodedFRAME BS 1364, CORRODED BETWEEN LONGERON 29L AND 29R AT AFT SIDE OF FRAME. REPAIRED IAW SRM 51-70-01.SDR DALA14032989264Pin · disengagedDURING SERVICE CHECK, NOTED LT SLIDE PINS NOT ENGAGED. R & R L1 DOOR SLIDE IAW AMDS 2561-4641.SDR DALA14032709222Skin · crackedSKIN CRACKED AT BS 1475 BETWEEN L1 AND L2R. REPAIRED IAW ERA 525798-14, REV O.SDR DALA14032939251Skin · damagedFOUND LIGHTNING STRIKE FS 160, BETWEEN STRINGERS 2 & 3, REMOVED DAMAGE, PERFORMED INSPECTION AND INSTALLED REPAIR FASTENERS IAW SR 53-31-02.SDR DALA14032429213Release Cable · corrodedTAILCONE RELEASE CABLE TERMINAL CORRODED. R & R TAIL CONE RELEASE CABLE. OPERATION CHECKED IAW AMDS 53-52-7116.SDR DALA14032419203Wire · damagedLT SIDEWALL AFT EMERGENCY STAIRWELL LIGHT IS INOPERATIVE. FOUND AND REPAIRED BROKEN WIRE IN TAILCONE AREA BEHIND LEFT AFT BULKHEAD. OPS CHECKED GOOD.SDR DALA14032389213Vane · damagedRIGHT FIXED VANE INBD HAS PUNCTURE AND A GOUGE. SANDED, CLEANED, FABRICATED AND INSTALLED DOUBLER IAW SRM 51-10-02 AND 59-20-05.SDR DALA14032699257Frame · chafedFOUND CHAFING DAMAGE ON FRAME WEB AT BS 1437, L4L. COMPLIED WITH ERA 526153-14, REV O.SDR DALA14032409225Battery Pack · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF LT WING IS ON WITH EMERGENCY LIGHT SWITCH IS IN "ARM" POSITION. R & R EMERGENCY LIGHT POWER SUPPLY BATTERY PACK. OPS CHECKED GOOD.SDR DALA14032399213Skin · crackedAFT ACCESSORY COMPARTMENT AT BS 1520 INBD SIDE OF LONGERON 2R SKIN DOUBLER CRACKED. CUT OUT DAMAGED SECTION. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-10-03.SDR DALA14032689257Skin · crackedLEFT LOWER AFT FUSELAGE, BS 1531, SKIN CRACKED, AT RIVET ABOVE VENTRAL STAIR CUTOUT. REMOVED DAMAGE. COMPLETED REPAIR IAW SRM 53-00-01, FIG 6.SDR DALA14032679257Skin · crackedSKIN HAS A CRACK THROUGH 2 SIDE OF FASTENER HOLE, BS 1475, L2R. REPAIRED FUSELAGE AND INSTALLED DOUBLER IAW ERA 526106-14, REV O.SDR DALA14032669222Frame · chafedFRAME BS 1458 CHAFED THROUGH AT L7L. REPAIRED IAW SRM 53-10-02.SDR DALA14032439213Web · crackedAFT ACCESSORY COMPARTMENT AT BS 1520 WEB CRACKED. CUTOUT DAMAGE. FABRICATED AND INSTALLED REPAIR IAW ERA 524972-14.SDR DALA14032379213Stop Fitting · wornAFT CARGO DOOR LOWER AFT STOP FITTING IS WORN AND HAS BARE METAL. R & R LOWER STOP FITTING ON AFT CARGO DOOR IAW SRM 51-30-02.SDR DALA14032359222Frame · chafedTAIL INTERIOR FRAME, BS 1458, IS CHAFED THROUGH AT LONGERON 7L. REPAIRED IAW SRM 53-10-02.SDR DALA14032369213Frame · damagedAFT CARGO FRAME BS 1344, LONGERON 28L IS OUT OF LIMITS. CUT OUT DAMAGED SECTION OF FRAME. FABRICATED AND INSTALLED REPAIR IAW SRM 53-10-02.SDR DALA14031659213Structure · corrodedBS 1364, LONERON 29R CORRODED WHERE FRAME ATTACH ANGLES AND SKIN JOINT. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW FORMER IAW SRM 51-10-03.
Back to Boeing MD-90-30