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 AALA20120410016Skin · damagedLIGHTNING STRIKE ON UPPER FUSELAGE STATION 581 STRINGER 7 LEFT. CUT OUT DAMAGE AREA AND INSTALLED DOUBLER PER EA B757-53-022701.SDR AALA20120410001Angle · corrodedLEFT CREASE ANGLE CORRODED FROM STATIONS 1620 TO 1610 LEFT BUTTLINE 60. REMOVED AND REPLACED LEFT CREASE ANGLE FROM STATIONS 1620 TO 1610 LEFT BUTTLINE 60 PER AARD 53-60-13-1.SDR AALA20120411015Skin · corrodedNUMBER 1 LEFT OUTBOARD SLAT CORRODED 30 INCHES FROM INBOARD END TOP SKIN. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20120410024Floor Support · corrodedMAIN CABIN FLOOR SUPPORT ANGLE AND SILL SUPPORT PLATE CORRODED UNDER DOOR DRAIN PLATE FROM BODY STATIONS 676 TO 740, RIGHT BUTTLINES 62 TO 65. REMOVED AND REPLACED SILL SUPPORT PER DWG 143N8322.SDR AALA20120421006Beam · corrodedCORROSION ON LATERAL I BEAM AT STATION 1681 LEFT BUTTLINE 40. REPLACED I BEAM.SDR AALA20120407013Fmc · inoperativeCREW REPORTED FLIGHT CREW LOST ROUTE INFORMATION FROM BOTH FLIGHT MANAGEMENT COMPUTERS. EMERGENCY DECLARED FLIGHT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT FLIGHT MANAGEMENT COMPUTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120410023Floor Support · corrodedMAIN CABIN FLOOR SUPPORT ANGLE AND SILL SUPPORT STRUCTURE CORRODED UNDER DRAIN PLATE FROM BODY STATIONS 676 TO 740, LEFT BUTTLINES 61 TO 64. REMOVED AND REPLACED MAIN CABIN FLOOR SUPPORT SILL PER BAC DWG 143N8322.SDR AALA20120410022Floor Support · corrodedMAIN CABIN FLOORBOARD ATTACH ANGLE CORRODED FROM BODY STATIONS 1597 TO 1600 LEFT BUTTLINE 63. REMOVED AND REPLACED DAMAGE ATTACHED ANGLE PER AARD 53-60-73-1.SDR AALA20120407003Skin · crackedR2 DOOR UPPER HINGE CUTOUT CRACKED. ROUTED OUT AREA OF CRACK AND INSTALLED DOUBLER PER ESO 90284 AND EA COMP-52-022813.SDR AALA20120406025Governor · inoperativeCREW REPORTED DURING DESCENT RIGHT ENGINE SHUTDOWN (SINGLE ENGINE TIME 10 MINS). CREW ABLE TO RESTART ENGINE AT APPROXIMATELY 10000 FEET. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FUEL FLOW GOVERNOR AND SDR AALA20120410014Placard · damagedRIGHT AFT OVERWING EMERGENCY EXIT IDENTIFIER STICKER DAMAGED. REPLACED RIGHT AFT OVERWING EMERGENCY EXIT IDENTIFIER STICKER.SDR AALA20120409001Placard · damagedRIGHT FORWARD OVERWING EMERGENCY EXIT IDENTIFIER STICKER DAMAGED. REPLACED RIGHT FORWARD OVERWING EMERGENCY EXIT IDENTIFIER STICKER, OPS CHECK NORMAL.SDR AALA20120406019Skin · damagedAFT CARGO DOOR, EXTERIOR SKIN, TOP FORWARD DOUBLER HAS HOLE BESIDE RIVET. REMOVED DAMAGED AREA OF SKIN AND INSTALLED DOUBLER AND FILLER PER SRM 51-10-02-G8 AND EA COMP-52-022854.SDR AALA20120411016Skin · damagedDEEP BLEND WITH BLIND FASTENER ON NUMBER 3 SLAT UPPER SKIN AT INBOARD DRIVE TRACK. INSTALLED DOUBLER REPAIR PER AARD 57-43-00-1.SDR AALA20120411014Skin · corrodedDEEP BLEND ON NUMBER 1 SLAT UPPER SKIN AT OUTBOARD DRIVE TRACK. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20120410012Lamp · burned outL4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR L4 DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120410011Lens · dirtyEMERGENCY LIGHT LENS AT SEAT 12DEF HAS RESIDUE OBSTRUCTING LIGHT. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 12DEF. OPS CHECKED NORMAL.SDR AALA20120410010Lamp · burned outR4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR R4 DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120410009Lamp · burned outLEFT NUMBER 1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 1 DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120410008Lamp · burned outLEFT NUMBER 1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 1 DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120410007Lamp · burned outR1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 1 DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120406026Connector · damagedP62 PANEL, EMERGENCY LIGHT TEST SWITCH INOPERATIVE. FOUND PIN TO GROUND PUSHED BACK IN CONNECTOR D40488. LOCKED PIN. OPS CHECKED NORMAL.SDR AALA20120406024Light · crackedCREW REPORTED RIGHT NUMBER 4 DOOR EMERGENCY LIGHT LENS MISSING. FOUND ASSEMBLY CRACKED. REPLACED LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20120405011Floorbeam · corrodedCORROSION ON T-CAP AT STATION 1640 AND BUTTLINE 0. REMOVED CORROSION PER SRM 51-10-02-0G. REPLACED T-CAP PER BOEING DRAWING LOR 5L53005 AND EA B757-53-022669.SDR AALA20120412024Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 1200 TO 1220 BUTTLINE 0 FORWARD TOP CORNER 3/4 INCHES LONG. INSTALLED WEB AND UPPER ANGLE PER SRM 51-10-02-0G.SDR AALA20120405004Lamp · burned outSEAT 1B OVERHEAD BAGGAGE BIN EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 1B OVERHEAD EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120405003Shroud · damagedSEAT 5F AFT EMERGENCY LIGHT SHROUD DAMAGED. REPLACED SEAT 5F AFT EMERGENCY LIGHT SHROUD. OPS CHECK NORMAL.SDR AALA20120404023Door Frame · corrodedAFT CARGO FORWARD DOOR FRAME AT BS 1380 WAS CORRODED. INSTALLED DOUBLER PER 53-00-07 2R2.SDR AALA20120404011Plate · corrodedCORROSION ON AFT DECK PLATE BETWEEN BS 1680 TO 1720. REPLACED AFT DECK PLATE PER 51-00-05-1 AND EA B757-53-022697.SDR AALA20120404005Door Frame · corrodedCORROSION ON FORWARD SIDE OF AFT CARGO DOOR FRAME WEB. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-07-2R 2.SDR AALA20120420011Skin · dentedHAIL DAMAGE TO THE RIGHT OUTBOARD AFT FLAP UPPER SKIN. ACCOMPLISHED BONDED REPAIR PER EA B757-51-023001.SDR AALA20120420010Flap · dentedHAIL DAMAGE TO THE INBOARD AFT FLAP. ACCOMPLISHED BONDED REPAIR PER EA B757-51-023001.SDR AALA20120420009Skin · dentedHAIL DAMAGE TO THE RIGHT AILERON UPPER SKIN. ACCOMPLISHED BONDED REPAIR PER EA B757-51-023001.SDR AALA20120420008Skin · dentedHAIL DAMAGE TO LEFT AILERON UPPER SKIN. ACCOMPLISHED BONDED REPAIR PER EA B757-51-023001.SDR AALA20120403013Service Door · dislodgedCREW REPORTED VIBRATION FELT IN CLIMB OUT FOLLOWED BY LOSS OF CENTER HYDRAULIC SYSTEM. EMERGENCY DECLARED FLIGHT RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. DISCOVERED THE LEFT HYDRAULIC SERVICE DOOR HAD BECOME LOOSE AND SDR AALA20120403020Structure · corrodedCORROSION ON OUTER CHORD STATION 1640 LEFT BUTTLINE 65. CUT OUT DAMAGED SECTION AND INSTALLED DOUBLER REPAIR PER EA B757-53-022750.SDR AALA20120402009Floor Support · corrodedFLOOR SUPPORT STRUCTURE CORRODED AT STATION 1640. INSTALLED TEE CAP PER EA B757-53-022722 AND BOEING LOR5L53005 DRAWING REPAIR 4 AND FIGURE 1 REPAIR SKETCH.SDR AALA20120402006Floor Support · corrodedFLOORBOARD SUPPORT AT CENTER LINE, STATIONS 1660 TO 1680 CORRODED. REPLACED FLOORBOARD SUPPORT PER SRM 51-10-02-0G AND AARD 51-00-05-1, REPAIR 1.SDR AALA20120402005Structure · corrodedLEFT NUMBER 4 ENTRY DOOR GUTTER BOX STRUCTURE CORRODED FROM STATIONS 1640 TO 1680. REMOVED AND REPLACED 2 GUTTER BOXES FOR THE LEFT NUMBER 4 ENTRY DOOR, FRAME STATIONS 1640 TO 1680 PER SRM 51-10-02-0G.SDR AALA20120401008Floorbeam · corrodedCORROSION TO NUT CLIP HOLE ON FLOORBEAM AT BS 365, RIGHT BUTTLINE 27. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-51-2R 3.SDR AALA20120402003Lamp · burned outLEFT OVERWING EMERGENCY INOPERATIVE. REPLACED LAMP FOR LEFT OVERWING EMERGENCY. OPS CHECK NORMAL.SDR AALA20120401003Floor Panel · corrodedCORROSION ON AFT PRESSURE DECK FROM BS 1681 TO 1720. REPLACED AFT PRESSURE DECK SRM 51-10-02-0G.SDR AALA20120331010Floorbeam · corrodedFLOORBEAM AT STATION 1681 CORRODED. REPLACEDFLOORBEAM PER SRM 51-10-02-0G.SDR AALA20120331007Light · inoperativeESCAPE PATH LIGHT AT SEAT 28D INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPS CHECKED NORMAL.SDR AALA20120330009Support · corrodedRIGHT NUMBER 4 DOOR GUTTER BOX STRUCTURE CORRODED FROM STATIONS 1640 TO 1680. INSTALLED FORWARD GUTTER SUPPORT AND INSTALLED AFT GUTTER SUPPORT ON RIGHT NUMBER 4 DOOR THRESHOLD PER SRM 51-10-02-0G, 51-40-02-0G AND AARD 51-00-05-1, REPAIR 1.SDR AALA20120330007Frame · damagedFRAME FORWARD OF LEFT 4 DOOR STATION 1646.3 AT FLOOR LEVEL AT LEFT BUTTLINE 63 HAS DAMAGE TO A FASTENER HOLE. INSTALLED REPAIR DOUBLER PER THE SRM 51-70-13-0G.SDR AALA20120331003Lamp · burned outFIRST CLASS CLOSET BULLNOSE OVERHEAD LIGHT INOPERATIVE. REPLACED LAMP. OPS CHECKED NORMALSDR AALA20120331002Lamp · burned outL4 DOOR ENTRY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 4 DOOR. OPS CHECKED NORMAL.SDR AALA20120331001Lamp · burned outR4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR. OPS CHECKED NORMAL.SDR AALA20120329017Floor Support · corrodedMAIN CABIN FLOOR SUPPORT STRUCTURE EXFOLIATED (BLOWN OUT), AT CENTER LINE FUSELAGE STATIONS 1640 TO 1660. INSTALLED FLOOR SUPPORT AT STATIONS 1640 AND 1660 BEAM PER SRM 51-10-02-0G AND AARD 51-10-05-1, REPAIR 1.
Back to Boeing 757-223