Boeing 757-223
Service difficulty reports · 8,750
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 = '757223' 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 = '757223' 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 AALA20111116JFK01Light · inoperativeLEFT NUMBER 2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111115TUL02Skin · damagedDAMAGE ON NUMBER 4 SLAT LEADING EDGE SKIN AT OSS 331. INSTALLED FLUSH DOUBLER REPAIR PER SRM 57-43-01-2R.SDR AALA20111114TUL07Bracket · damagedCAMLOCK BRACKET IN P34 PANEL BESIDE NOSE WHEEL WELL LIGHT CIRCUIT BREAKER HAS ELECTRICAL ARCH DAMAGE. REMOVED DAMAGE PER SRM 51-20-02-0G AND ALODINED PER SRM 51-20-01-01. NO MATERIAL LOSS. (SUPPLEMENTAL CLOSED)SDR AALA20111114TUL02Floorbeam · corrodedFLOORBEAM CORRODED STATION 1681. ACCOMPLISHED FLOORBEAM REPAIR.SDR AALA20111114TUL08Tear Strap · debondedEXTERNAL FUSELAGE STATION 1600 BETWEEN STRINGERS 8 AND 10 LEFT TEAR STRAP HAD AREAS DISBONDED. CURRENTLY UNDERGOING REPAIRS.SDR AALA20111114TUL06Angle · crackedFUSELAGE INTERNAL STRINGER ANGLE STATION 685 TO 677 CRACKED (2 PLACES). CURRENTLY UNDERGOING REPAIRS.SDR AALA20111114DWH01Skin · damagedACCIDENTAL IMPACT AT FUSELAGE SKIN AT APPROXIMATE STATION 1545 AT STRINGER 22 RIGHT. INSTALLED EXTERNAL DOUBLER PER EA B757-53-020017.SDR AALA20111114TUL01Duct · leakingNAS - INFLIGHT PUJ-MIA. CREW REPORTED LEFT BLEED DUCT LEAK WARNING FOLLOWED BY ODOR IN COCKPIT. EMERGENCY DECLARED FLIGHT DIVERTED NAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. AIRCRAFT CURRENTLY UNDERGOING MAINTENANCE. SYSTEM GROUND CHECK NSDR AALA20111114TUL09Web · corrodedMAIN CABIN WEB CORRODED AT STATION 1720 RIGHT BUTTLINE 65. REMOVED AND REPLACED WEB PER SRM 51-40-02 AND BAC 146N8722.SDR AALA20111114TUL10Shear Web · corrodedMAIN CABIN UNDER FLOOR, OVERWING PRESSURE DECK CORRODED AT BODY STATION 1000 TO 1020, LEFT BUTTLINE 65. REMOVED AND REPLACED SHEAR WEB WEB IAW AAL B757 SRM 51-40-02 AND BAC DWG 144N5140. (SUPPLEMENTAL CLOSED)SDR AALA20111110TUL14Fitting · corrodedCORROSION ON T-CAP INSIDE AFT CARGO DOOR, LOWER EDGE ABOVE LOWER INTERCOSTALS. INSTALLED REAPIR PER SRM 51-70-12-0G AND EA B757-52-020269.SDR AALA20111110TUL13Skin · dentedDENT IN DOOR SKIN DOOR LEFT NUMBER 4 BOTTOM RIGHT CORNER. INSTALLED DOUBLER REPAIR PER SRM 52-10-01-2R REPAIR 7.SDR AALA20111110TUL11Doubler · damagedAFT GALLEY DECK PLATE DOUBLER DAMAGED. REPAIRED DECK PLATE BY REPLACING DOUBLER PER SRM 53-60-51-2. REPAIR 2 AND EA B757-53-0020036.SDR AALA20111109TUL04Structure · corrodedREMOVED RE-ENFORCING ANGLES FROM FORWARD SIDE OF LATERAL I BEAM/FLOOR SUPPORT TO FACILITATE CORROSION REMOVAL, STATION 1680, WATERLINES 206 TO 207.8. REINFORCED LATERAL I BEAM/FLOOR SUPPORT BY INSTALLING NEW REINFORCING ANGLES ON THE FORWARD SIDE OF I BEAM PESDR AALA20111114TUL16Stringer · corrodedAFT PIT AREA UNDER AFT GALLEY, STRINGER 29 LEFT AT INTERSECTION OF FRAME 1700 HAS EXFOLIATED CORROSION. CURRENTLY UNDERGOING REPAIRS.SDR AALA20111108TUL03Floorbeam · crackedCRACKED FLOORBEAM AT STATION 700 LEFT BUTTLINES 24 TO 48. INSTALLED DOUBLER PER SRM 53-00-51-2R.SDR AALA20111114TUL17Web · corrodedMAIN CABIN UNDER FLOOR, WEB REPAIR DOUBLER BODY STATIONS 1711 TO 1720 HAS CORROSION, RIGHT BUTTLINES 32 TO 42 (ABOUT 2 SQUARE INCHES). CURRENTLY UNDERGOING REPAIRS.SDR AALA20111107TUL03Floorbeam · corrodedSTATION 1640 UPPER FLOORBEAM REPAIR UPPER DOUBLER AND FRAME CORRODED LEFT BUTTLINE 6 TO RIGHT BUTTLINE 12. REPAIRED LATERAL I BEAM/FLOOR SUPPORT BY INSTALLING T CAP REPAIR PER SRM 53-00-51-2, REPAIR 3.SDR AALA20111107TUL02Pan · gougedLEFT NUMBER 2 DOOR HANDLE PAN GOUGED. REMOVED AND REPLACED HANDLE PAN PER ESO 90282.SDR AALA20111107TUL01Floor Support · corrodedHAT SECTION FLOORBOARD SUPPORT CORRODED AT BUTTLINE 0, STATIONS 1660 TO 1680. INSTALLED NEW FLOORBOARD SUPPORT PER SRM 51-10-02-0G.SDR AALA20111107TUL04Floor Support · corrodedCENTER HAT SECTION FLOORBOARD SUPPORT IS CORRODED AT STATIONS 1640 TO 1660 BUTTLINE 0. REMOVED AND REPLACED SECTION OF FLOOR SUPPORT PER SRM 51-10-02-0G.SDR AALA20111106TUL04Skin · dentedDENT IN FUSELAGE SKIN BETWEEN STATIONS 720 TO 740. REPAIRED DENT PER SRM 53-00-01-2R AND EA B757-53-020175.SDR AALA20111109TUL02Floorbeam · corrodedCORROSION ON FLOORBEAM FROM RIGHT BUTTLINES 12 TO 56 AT STATION 1680. ACCOMPLISHED NESTED ANGLE REPAIR PER SRM 53-00-51-2, REPAIR 2.SDR AALA20111104TUL12Angle · corrodedZ-ANGLE SUPPORT CORRODED AT STATIONS 1680, RIGHT BUTTLINE 50. REPLACED Z-ANGLE PER SRM 51-10-02-0G, PARAGRAPH 9.SDR AALA20111104TUL11Angle · corrodedZ-ANGLE IS CORRODED AT BOTH ENDS ON THE AFT GALLEY DECK PLATE LEFT BUTTLINE 50 STATIONS 1680 TO 1715. REPLACED Z-ANGLE PER SRM 51-10-02-0G.SDR AALA20111104TUL10Channel · corrodedAFT GALLEY DECK PLATE "CENTER HAT SECTION" SUPPORT IS CORRODED AT BUTTLINE 0, STATIONS 1685 TO 1715. INSTALLED NEW CENTER HAT SECTION AR BUTTLINE 0 STATIONS 1685 TO 1715 PER SRM 51-10-02-G9.SDR AALA20111104TUL07Angle · crackedT-ANGLE CRACKED FOR FLOORBOARD INTERCOSTAL SUPPORT STATIONS 660 TO 680 BUTTLINE 0. INSTALLED SERVICABLE UPPER T-ANGLE PER SRM 51-10-02.SDR AALA20111104TUL05Skin · dentedDENT IN FUSELAGE SKIN 4 FEET AFT OF RIGHT NUMBER 1 DOOR. INSTALLED STRINGER REPAIR PER SRM 53-00-03-2R 1 AND INSTALLED EXTERNAL REPAIR DOUBLER PER SRM 53-00-01-2R 2 AND EA B757-53-020146.SDR AALA20111104TUL02Slat · puncturedNUMBER 4 SLAT HAS A .5 INCH PUNCTURE MID SPAN UNDERSIDE OF TRAILING EDGE. INSTALLED HOT BOND DOUBLER REPAIR PER SRM 51-70-10-2.SDR AALA20111114TUL15Frame · corrodedAFT CARGO FRAME UPPER CHORD CORRODED BODY STATION 1440, RIGHT BUTTLINE 2. CURRENTLY UNDERGOING REPAIRS.SDR AALA20111114TUL14Web · crackedWEB AT STRINGER 12 RIGHT STATION 680 IS CRACKED. CURRENTLY UNDERGOING REPAIRS.SDR AALA20111114TUL13Web · crackedWEB AT STRINGER 13 LEFT STATION 680 IS CRACKED. CURRENTLY UNDERGOING REPAIRS.SDR AALA20111114TUL12Web · crackedWEB AT STRINGER 13 RIGHT STATION 680 IS CRACKED. CURRENTLY UNDERGOING REPAIRS.SDR AALA20111104TUL01Pump · failedVVI - INFLIGHT MIA-LPB. CREW REPORTED LEFT HYDRAULIC PUMP AND POWER TRANSFER UNIT FAILED IN FLIGHT. FLIGHT DIVERTED VVI LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE DRIVEN PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20111102TUL11Strap · crackedAFT CARGO STRAP CRACKED ABOVE CARGO DOOR AT STATION 1380. INSTALLED DOUBLER TO STRAP PER SRM 53-60-51-4.SDR AALA20111102MIA02Lens · missingSEAT 24D EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24D EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111102MIA01Light · inoperativeSEAT 20D EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 20D EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111102TUL02Skin · corrodedNUMBER 9 SLAT HAS CORROSION ALONG BLEND, UPPER SKIN SURFACE ABOVE INBOARD SLAT TRACK. REPAIRED PER AARD 57-43-00-1.SDR AALA20111031JFK01Light · inoperativeEMERGENCY LIGHT BY LEFT NUMBER 2 DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT BY LEFT NUMBER 2 DOOR. OPS CHECK NORMAL.SDR AALA20111031TUL07Door · dentedLOWER AFT CORNER OF CARGO DOOR DENT BEYOND LIMITS. ACCOMPLISHED REPAIR PER SRM 52-30-01-2R4 FIGURE 201.SDR AALA20111031TUL03Web · corrodedCORROSION ON LOWER PORTION OF THE WEB AT STATIONS 1400 TO 1420 BUTTLINE 5 LEFT. INSTALLED NEW WEB PER SRM 51-70-00-0G.SDR AALA20111031TUL02Web · corrodedCORROSION ON THE LOWER PORTION OF THE WEB AT STATIONS 1400 TO 1420 BUTTLINE 5 RIGHT. REPLACED DAMAGED WEB PER SRM 51-70-00-0G.SDR AALA20111029JFK01Gcu · inoperativeJFK - CREW REPORTED RIGHT ENGINE GENERATOR FAILED. EMERGENCY DECLARED FLIGHT RETURNED JFK LANDED WITHOUT INCIDENT. PLACARDED RIGHT INTEGRATED DRIVE GENERATOR INOPERATIVE. FLIGHT CONTINUED TO AUA. REPLACED GENERATOR CONTROL UNIT AT TUL ON 11/1/2011. SYSTEMSDR AALA20111028TUL01Frame · corrodedCORROSION ON FRAME STATION 1480, STRINGER 26 RIGHT. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-07-2R.SDR AALA20111110TUL03Support · corrodedLEFT NUMBER 4 DOOR GUTTER BOX DRAIN SUPPORT CORRODED. REPLACED LEFT NUMBER 4 GUTTER BOX DRAIN SUPPORT PER SRM 51-10-02-0G.SDR AALA20111109TUL01Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 365 RIGHT BUTTLINES 0 TO 64. REPAIRED FLOORBEAM PER SRM 53-00-51-2R-5.SDR AALA20111028DWH01Bushing · corrodedFOUND CORROSION ON THE BORE EDGE AT OUTBOARD SIDE OF THE UPPER OUTBOARD BUSHING FOR THE FORWARD TRUNNION. ACCOMPLISHED REPAIR PER EA B757-57-019897.SDR AALA20111027TUL03Pump · inoperativeSJU - INFLIGHT MIA-BSB. CREW REPORTED LEFT ENGINE HYDRAULIC OVERHEAT MESSAGE. EMERGENCY DECLARED FLIGHT DIVERTED SJU LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SEVRICE. REPLACED LEFT ENGINE DRIVEN HYDRAULIC PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20111025TUL08Skin · dentedDENT AT STATION 1305 STATION 8 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR AALA20111024TUL03Web · crackedDOME SEALANT MISSING ON FASTENERS AT PP STATION 172 NUMBER 2 PYLON, VERTICAL FASTENER THROUGH UPPER SPAR AT STATION 172 OUTBOARD SIDE SHOWS SIGN OF ROTATION. INSTALLED FREEZE PLUG REPAIR PER EA 757-54-019893.
Back to Boeing 757-223