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 AALA20120220017Floor Support · corrodedMAIN CABIN FLOOR SUPPORT UPPER SURFACE CORRODED FROM BS 324 TO 344, RBL 62. INSTALLED NEW FLOOR SUPPORT PER SRM 51-40-02.SDR AALA20120220016Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER TEE SURFACE CORRODED AT BS 1640, LBL 6 TO RBL 17. INSTALLED NEW STRAP PER SRM`S 53-00-51, 51-20-01 AND 51-40-02.SDR AALA20120212TUL02Skin · damagedDENT WITH A GOUGE ON THE RIGHT SIDE OF THE AIRCRAFT JUST BELOW FORWARD CARGO STATIONS 580 TO 600. INSTALLED REPAIR DOUBLER PER EA B757-53-021826.SDR AALA20120222021Channel · corrodedMAIN CABIN RIGHT NUMBER 4 DOOR LOWER SILL U CHANNEL CORRODED FROM BS 1640 - 1660. INSTALLED NEW U CHANNEL PER SRM 51-40-02 AND DRAWING 146N5230.SDR AALA20120220015Angle · corrodedMAIN CABIN, LEFT NUMBER 4 DOOR LOWER SILL L ANGLE CORRODED FROM BS 1674 TO 1679. REPLACED LEFT NUMBER 4 DOOR LOWER SILL L ANGLE PER SRM 51-40-02.SDR AALA20120220013Channel · corrodedMAIN CABIN, LEFT NUMBER 4 DOOR LOWER SILL U CHANNEL CORRODED FROM BS 1660 TO 1680. REPLACED LEFT NUMBER 4 DOOR LOWER SILL U CHANNEL PER SRM 51-40-02.SDR AALA20120220012Channel · corrodedMAIN CABIN, LEFT NUMBER 4 DOOR SILL U CHANNEL CORRODED FROM BODY STATIONS 1640 TO 1660. REPLACED LEFT NUMBER 4 DOOR LOWER SILL U CHANNEL PER SRM 51-40-02.SDR AALA20120220011Angle · corrodedMAIN CABIN, RIGHT NUMBER 4 DOOR LOWER SILL, L ANGLE CORRODED AT BODY STATIONS 1675 TO 1680. REPLACED L ANGLE PER SRM 51-40-02.SDR AALA20120220010Channel · corrodedMAIN CABIN, RIGHT NUMBER 4 DOOR LOWER SILL, U CHANNEL CORRODED FROM BODY STATIONS 1660 TO 1680. REMOVED AND REPLACED U CHANNEL PER SRM 51-40-02.SDR AALA20120216TUL05Connector · defectiveRIGHT NUMBER 4 DOOR FORWARD LOWER SIDEWALL EMERGENCY LIGHT INOPERATIVE. REPLACED CONNECTOR FOR RIGHT NUMBER 4 DOOR FORWARD LOWER SIDEWALL EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120216TUL04Light · inoperativeRIGHT NUMBER 4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120216TUL03Connector · defectiveROW 9DEF SEAT MOUNTED AFT EMERGENCY LIGHT INOPERATIVE. REPLACED PLUG ON SEAT HARNESS. OPS CHECK NORMAL.SDR AALA20120213DFW01Light · inoperativeRIGHT AFT LAVATORY SIDEWALL EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR AFT LAVATORY SIDEWALL EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA201202140007Terminal · arcedLEFT LOWER WING TO BODY AREA, LANDING LIGHT TERMINAL WIRE ARCING AGAINST STRUCTURE AT BULB. REMOVED AND REPLACED TERMINAL BACTM 140. OPS CHECKED NORMAL.SDR AALA20120210TUL02Deck Plate · corrodedCORROSION ON DECK PLATE AT STATION 1682 AND LEFT BUTTLINE 4. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-60-51-2R 2.SDR AALA20120228042Skin · damagedLIGHTNING STRIKE TO STATION 635 AT STRINGER 29 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R 2.SDR AALA20120228041Frame · dentedACCIDENATL IMPACT TO STATION 1500, STRINGERS 26 TO 28 LEFT FRAME. INSTALLED DOUBLER AND H-CLIPS PER SRM 53-00-07-2R 5 DETAIL 2.SDR AALA20120228040Frame · dentedACCIDENTAL IMPACT TO LEFT AFT CARGO 1520 FRAME. INSTALLED DOUBLER REPAIR PER SRM 53-00-07-2R5 DETAIL 3.SDR AALA20120224004Skin · corrodedLEFT WING- SMALL AREA OF CORROSION INBOARD FLAP TOP SKIN AT INBOARD END OF FLAP. FABRICATED DOUBLER AND FILLER AND BONDED REPAIR IN PLACE PER EA COMP-57-021990.SDR AALA20120207DFW01Battery Pack · dischargedROWS 16 TO 25 EMERGENCY LIGHTS DIM. REPLACED BATTERY PACK FOR ROWS 16 TO 25 EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120206TUL03Structure · damagedFORWARD CARGO DOOR LOWER SEAL LANDING CORNER IS DAMAGED. REMOVED DAMAGED LOWER FORWARD SEAL LANDING CORNER AND INSTALLED NEW SEAL LANDING CORNER PER ESO 90114.SDR AALA20120205MIA01Battery Pack · dischargedROWS 9 TO 16 EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY BATTERY PACK FOR ROWS 9 TO 16 EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120204TUL01Beam · damagedFORWARD CARGO DOOR BOTTOM EDGE BEAM IS DENTED AND GOUGED. REMOVED DAMAGED EDGE BEAM AND INSTALLED NEW EDGE BEAM PER ESO 90114.SDR AALA20120203TUL07Skin · damagedNUMBER 2 CARGO DOOR OUTER SKIN HAS DAMAGED AT FORWARD LOWER CORNER AROUND 8 INCHES FROM FORWARD EDGE AND 2 INCHES FROM BOTTOM EDGE. TRIMMED OUT THE DAMAGED SECTION OF SKIN AND INSTALLED A DOUBLER REPAIR AT THE LOWER FORWARD CORNER OF THE NUMBER 2 CARGO DOOR PSDR AALA20120203TUL06Skin · damagedLIGHTNING STRIKE FROM STATIONS 390 TO 417 AND STRINGERS 3 TO 5 RIGHT. INSTALLED DOUBLER PER SRM 53-00-01-2R AND EA B757-53-021708.SDR AALA20120203TUL03Sill · damagedLEFT NUMBER 4 DOOR SILL WEB FROM STATIONS 1640 TO 1681 DAMAGED. REPLACED WEB PER AARD 51-10-05-1.SDR AALA20120203TUL05Skin · damagedLIGHTNING STRIKE FROM STATIONS 550 TO 600 AND STRINGER 3 TO 4 RIGHT. INSTALLED DOUBLER PER SRM 53-00-01 AND EA B757-53-021656.SDR AALA20120201TUL05Slat · corrodedLEFT WING NUMBER 1 SLAT OUTBOARD END HAS CORROSION AROUND FASTENER. REMOVED BLENDED AREA AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20120201TUL04Slat · corrodedCORROSION AROUND FASTENER 29 INCHS FROM INBOARD END ON BOTTOM SIDE. REMOVED CORROSION AND INSTALLED DOOUBLER PER AARD 57-43-00-1.SDR AALA20120201TUL03Slat · corrodedCORROSION AROUND FASTRNER 44 INCHES FROM OUTBOARD END ON BOTTOM SIDE ON NUMBER 1 SLAT. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20120131JFK01Light · inoperativeLEFT NUMBER 2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120130TUL10Support · corrodedRIGHT NUMBER 4 DOOR GUTTER SUPPORT CORRODED BETWEEN STATIONS 1640 TO 1660. INSTALLED RIGHT NUMBER 4 DRAIN SUPPORT FROM STATIONS 1640 TO 1660 PER SRM 51-10-02-OG.SDR AALA20120129JFK01Connector · defectiveJFK - CREW REPORTED LEFT GENERATOR TRIPPED AND CAUSED MULTIPLE STATUS MESSAGES. LEFT INTEGRATED DRIVE GENERATOR UNABLE TO BE RESET BY FLIGHT CREW. EMERGENCY DECLARED FLIGHT RETURNED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CONNESDR AALA20120128TUL01Fitting · damagedTWO LOOSE FASTENERS FOUND ON THE VERTICAL FLANGE OF THE DIAGONAL BRACE FITTING. ACCOMPLISHED INTERIM REPAIR TO LEFT PYLON VERTICAL FLANGE DIAGONAL BRACE FITTING PER EA B757-54-015408.SDR AALA20120128DWH01Skin · damagedSCRIBE LINE FOUND AT LAP SEAM BODY STATION 1344, STRINGER 14 LEFT APPROXIMATELY 1 INCH IN LENGTH. INSTALLED DOUBLER REPAIR PER EA B757-53-021569.SDR AALA20120127DWH02Pan · gougedRIGHT NUMBER 4 DOOR HANDLE PAN HAS A .015 INCH GOUGE THAT HAS INTERIM REPAIR ACCOMPLISHED. REMOVED AND REPLACED HANDLE PAN PER SRM 51-40-02 AND BAC DRAWING 146N6100, REVISION C.SDR AALA20120127DWH01Door Frame · crackedLEFT NUMBER 2 DOOR FORWARD FRAME UPPER HINGE CUTOUT IS CRACKED. INSTALLED REPAIR DOUBLER PER SRM 52-10-02-2R.SDR AALA20120127TUL05Door Frame · crackedRIGHT NUMBER 2 DOOR FORWARD FRAME UPPER HINGE CUTOUT IS CRACKED. INSTALLED REPAIR DOUBLER PER SRM 52-10-02-2R.SDR AALA20120127TUL03Structure · crackedRIGHT NUMBER 1 DOOR HANDLE BOX HAS CRACKS AT INSERTS AND LIGHT PITTING. REMOVED HANDLE BOX AND INSTALLED NEW BOX PER B757-200 CMM 52-11-09 AND AMM 52-11-13-2.SDR AALA20120126TUL11Skin · dentedFUSELAGE DENT WITH GOUGE AT STATION 760 STRINGER 15 LEFT. HFEC CHECKED AREA NO CRACKS FOUND. INSTALLED RIVET PER SRM 53-00-01-2R SECTION I PARAGRAPH 3.SDR AALA20120126TUL10Door · dentedLEFT NUMBER 1 DOOR IN WHITE STRIPE AREA HAS DENT. INSTALLED REPAIR DOUBLER PER SRM 52-10-01-2R 7.SDR AALA20120126TUL09Slat · corrodedLEFT WING NUMBER 3 SLAT - CORROSION AROUND FASTENER AT APPROXIMATE STATION 530. REMOVED CORROSION AND INSTALLED FLUSH DOUBLER PER AARD 57-43-00-1.SDR AALA20120125TUL13Structure · damagedAFT DECK FROM STATIONS 1716 TO 1720 DAMAGED. INSTALLED DOUBLER REPAIR PER EA B757-53-021042.SDR AALA20120125TUL12Floorbeam · gougedDAMAGE TO FLOORBEAM AT STATION 680 LEFT BUTTLINE 17 TO RIGHT BUTTLINE 33. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B757-53-021298 DATED 01/23/12.SDR AALA20120202TUL06Skin · damagedNUMBER 2 CARGO DOOR OUTER SKIN HAS DAMAGED AT FORWARD LOWER CORNER AROUND 8 INCHES FROM FORWARD EDGE AND 2 INCHES FROM BOTTOM EDGE. TRIMMED OUT THE DAMAGED SECTION OF SKIN AND INSTALLED A DOUBLER REPAIR AT LOWER FORWARD CORNER OF THE NUMBER 2 CARGO DOOR PER SSDR AALA20120127TUL06Slide · out of positionLEFT NUMBER 4 DOOR SLIDE INADVERTENTLY UNSUCCESSFULLY DEPLOYED. SLIDE FELL OUT OF HOUSING AND ASSIST BOTTLE DISCHARGED. AIRCRAFT FERRIED TO MIA FOR REPAIRS. REPLACED LEFT NUMBER 4 DOOR SLIDE AND ASSIST BOTTLE ON 01/24/2012 AT MIA. SYSTEM GROUND CHECK NORMASDR AALA20120124TUL02Trans Panel · corrodedFORWARD CARGO DOOR SILL, FLOOR SUPPORT CHANNEL CORRODED THROUGHOUT BODY STATIONS 560 TO 620. REMOVED AND REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA20120124TUL01Stringer · crackedFUSELAGE INTERNAL STRINGER NUMBER 13 AT STATION 680 RIGHT IS CRACKED. REMOVED AND REPLACED STRINGER NUMBER 13 PER SRM 51-40-02 AND BAC DRAWING 143N8334.SDR AALA20120123MIA05Shutoff Valve · looseMIA INFLIGHT PUJ-JFK. CREW REPORTED RIGHT ENGINE BLEED LIGHT ILLUMUNATED ON TAKE OFF. FLIGHT DIVERTED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. TIGHTENED PRESSURE REGULATING SHUT-OFF VALVE AND SENSE LINE THAT WERE LOOSE. SYSTEM GROUND CHSDR AALA20120123TUL06Stringer · corrodedBETWEEN STATIONS 1680 TO 1701 STRINGER 21 LEFT EXFOLIATED CORROSION. ACCOMPLISHED NESTED REPAIR ANGLE PER SRM 53-00-03-R1.
Back to Boeing 757-223