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 AALA20120426008Mount · corrodedCORROSION ON FORWARD OUTBOARD GALLEY MOUNT 52 INCHES RIGHT OF BUTTLINE 0 AT STATION 1687. REPLACED RIGHT FORWARD G4 FLOOR MOUNT PER AARD 51-00-05-1.SDR AALA20120426007Mount · corrodedCORROSION ON AFT OUTBOARD GALLEY MOUNT 52 INCHES RIGHT OF BUTTLINE 0 AT STATION 1715. REPLACED RIGHT AFT G4 FLOOR MOUNT PER AARD 51-00-05-1.SDR AALA20120426006Angle · corrodedCORROSION ON AFT DECK Z-ANGLE 51 INCHES RIGHT OF BUTTLINE 0 AT STATION 1716. INSTALLED NEW RIGHT Z-ANGLE PER AARD 51-00-05-1.SDR AALA20120418013Angle · corrodedSTATION 1720 T-CHORD HAS TWO SPOTS OF CORROSION AT LEFT BUTTLINES 2 TO 5 AND 20 TO 24. REPLACED CHORD ANGLE PER SRM 51-10-02-0G.SDR AALA20120419028Intercostal · corrodedBULK CARGO COMPARTMENT, INTERCOSTAL CORRODED FROM BODY STATIONS 1600 TO 1620, STRINGERS 29 TO 30 LEFT. REMOVED CORROSION AND REPLACED INTERCOSTAL PER SRM 51-40-02 AND BAC DWG 146N5451.SDR AALA20120419026Intercostal · corrodedBULK CARGO COMPARTMENT INTERCOSTAL CORRODED AT BODY STATIONS 1600 TO 1620, STRINGER 29 TO 30 RIGHT. REPLACED INTERCOSTAL PER SRM 51-40-02 AND BAC DWG 146N5451.SDR AALA20120419001Module · inoperativeEMERGENCY LIGHTING BETWEEN ROWS 9 TO 15 INOPERATIVE. REPLACED MODULE FOR EMERGNCY LIGHTS FROM ROWS 9 TO 15. OPS CHECK NORMAL.SDR AALA20120418012Floor Support · damagedFLOOR SUPPORT AT LEFT BUTTLINE 20, STATIONS 1620 TO 1640, NICKED WHEN CUTTING T-CAP ON 1640 BEAM. REMOVED AND REPLACED FLOOR SUPPORT PER AARD 51-00-05-1, REPAIR 1.SDR AALA20120517001Plate · corrodedCORROSION ON TOP SURFACE OF LEFT PIVOT HINGE STIFFENER PLATE. INSTALLED FASTENERS AT LEFT PIVOT HINGE PER PER EA B757-55-023567 AND SRM 51-40-02.SDR AALA20120418002Plug · defectivePLS - INFLIGHT STT-MIA. CREW REPORTED LEFT ENGINE OIL QUANTITY AND PRESSURE LOSS. LEFT ENGINE WAS SHUTDOWN (SINGLE ENGINE TIME 25 MINS). EMERGENCY DECLARED FLIGHT DIVERTED PLS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. AIRCRAFT FERRIED TO MIASDR AALA20120417027Support · corrodedRIGHT NUMBER 4 DOOR AFT DRAIN SUPPORT CORRODED BETWEEEN STATIONS 1661 AND 1680. REPLACED RIGHT AFT DRAIN SUPPORT FROM STATIONS 1661 TO 1681 PER AARD 51-00-05-1.SDR AALA20120417011Control Unit · inoperativeMEM - INFLIGHT MIA-SFO. CREW REPORTED LEFT ENGINE PARAMETERS FLUCTATING ABNORMALLY. EMERGENCY DECLARED FLIGHT DIVERTED MEM LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BLEED VALVE CONTROL UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120417010Skin · corrodedNUMBER 3 SLAT LOWER LEADING EDGE SKIN 2 FEET FROM THE INBOARD END IS CORRODED. INSTALLED DOUBLER PER SRM 57-43-A1-2 AND AARD 57-43-00A1.SDR AALA20120417009Rib · corrodedRIGHT WING NUMBER 9 SLAT MOST INBOARD RIB HAS 2 EACH AREAS OF CORROSION ON LEADING EDGE SKIN. INSTALLED DOUBLER PER SRM 51-40-02.SDR AALA20120417007Skin · damagedRIGHT WING NUMBER 9 SLAT LEADING EDGE SKIN (OUTBOARD RIB) PREVIOUS BLENDOUT HAS 2 EACH FASTENER HEADS BLENDED. REMOVED DAMAGE PER AARD 57-43-00-1 AND SRM 57-43-2R2. INSTALLED DOUBLER PER SRM 51-40-02.SDR AALA20120430006Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT STATION 300.5 RIGHT BUTTLINE 21. REMOVED DAMAGED SECTION AND INSTALLED NEW SERVICEABLE SECTION OF FLOORBEAM PER AARD 51-00-05-1.SDR AALA20120422013Intercostal · corrodedAFT CARGO COMPARTMENT LEFT INTERCOSTAL FROM BODY STATION 1480 TO 1500, STRINGER 26 LEFT HAS CORROSION. REMOVED AND REPLACED CHORD PER SRM 51-40-02.SDR AALA20120416003Nose Cowl · damagedACCIDENTAL IMPACT TO THE LEFT ENGINE INLET COWL TOP AND UPPER FAIRING. THE NOSE COWL AND UPPER FAIRING WILL NEED TO BE REPLACED. AIRCRAFT CURRENTLY UNDERGOING MAINTENANCE.SDR AALA20120416001Angle · corrodedRIGHT CREASE ANGLE STATIONS 1570 TO 1630 CORRODED. REPLACED RIGHT CREASE ANGLE PER AARD 53-60-13-1.SDR AALA20120417005Pump · leakingLIM - CREW REPORTED LEFT HYDRAULIC SYSTEM QUANTITY LOSS. EMERGENCY DECLARED FLIGHT LANDED LIM WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND FLUID LEAKING FROM LEFT ENGINE DRIVEN PUMP.SDR AALA20120416010Skin · puncturedPUNCTURE IN LOWER FUSELAGE SKIN FRAME STATION 321, 3 INCHES BELOW STRINGER 17 LEFT. INSTALLED BLIND RIVET PER SRM 53-00-01-2 REPAIR 6 SECTION 1 AND SRM 51-40-02-0G.SDR AALA20120416008Skin · damagedTEMPORARY REPAIR, BLIND FASTENER INSTALLED AT FRAME STATION 360, STRINGER 4 LEFT. INSTALLED OF A SOLID RIVET AT FRAME STATION 360, STRINGER 4 LEFT PER SRM 53-00-01-2R 6.SDR AALA20120416004Crease Beam · damagedCREASE BEAM WEB STATIONS 1620 TO 1640 RIGHT HAS DAMAGED FASTENER HOLES. INSTALLED NEW WEB AND WEB SUPPORT BRACKET PER AARD 51-00-05-1.SDR AALA20120418008Light · inoperativeBULLNOSE EMERGENCY LIGHT AT 20ABC INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR BULLNOSE EMERGENCY LIGHT AT 20ABC. OPS CHECK NORMAL.SDR AALA20120418007Light · inoperativeBULLNOSE EMERGENCY LIGHT AT 4AB INOPERATIVE. REPLACED LAMP FOR BULLNOSE EMERGENCY LIGHT AT 4AB. OPS CHECK NORMAL.SDR AALA20120417004Light · inoperativeFORWARD GALLEY FLOOD LIGHT INOPERATIVE. REPLACED LAMP FOR FORWARD GALLEY FLOOD LIGHT. OPS CHECK NORMAL.SDR AALA20120416006Skin · corrodedNUMBER 3 SLAT LEADING EDGE SKIN SIX FEET FROM THE OUTBOARD END IS CORRODED. REMOVED DAMAGE AND FABRICATED A FLUSH REPAIR PER AARD 57-43-01-2.SDR AALA20120415007Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM STATION 365 RIGHT BUTTLINES 2 TO 16. REMOVED CORROSION BY SECTION REMOVAL AND INSTALLED FILLER AND DOUBLERS PER SRM 53-00-51-2R AND EA B757-53-022776.SDR AALA20120413014Floorbeam · corrodedNUMEROUS AREAS OF CORROSION ALONG ENTIRE LENGTH OF STATION 1681 FLOORBEAM TEE CAP. REPLACED UPPER TEE PER EA B757-53-022818.SDR AALA20120413012Floor Support · corrodedFLOOR SUPPORT CORRODED BETWEEN BS 1640 AND 1661 AT BUTTLINE 0. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA20120413011Support · damagedWATER TANK SUPPORT HAS DAMAGED HOLES BETWEEN BS 1640 AND 1660. REMOVED AND REPLACED SUPPORT PER SRM 51-10-02.SDR AALA20120413010Floorbeam · corrodedNUMEROUS AREAS OF CORROSION ALONG ENTIRE LENGTH OF BS 1640 FLOORBEAM. REMOVED AND REPLACED FLOORBEAM PER SRM 51-10-05 AND EA B757-53-022812.SDR AALA20120413015Floor Support · corrodedCORROSION ON FLOOR SUPPORT, 39 INCHES RIGHT OF BUTTLINE 0, STATIONS 318 TO 324. REMOVED FLOOR SUPPORT AND INSTALLED NEW SUPPORT PER AARD 51-00-05-1.SDR AALA20120412027Connector · inoperativeSEAT 33DEF SEAT MOUNTED EMERGENCY LIGHT WILL NOT TEST. RESEATED CONNECTOR AT 33DEF. OPS CHECKED NORMAL.SDR AALA20120412007Floor Support · corrodedFLOOR SUPPORT AT LEFT NUMBER 4 DOOR IS CORRODED. REMOVED AND REPLACED LEFT NUMBER 4 FLOOR SUPPORT PER SRM 51-10-02.SDR AALA20120412006Floor Support · corrodedFLOOR SUPPORT AT LEFT NUMBER 4 DOOR IS CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA20120411022Pump · failedINFLIGHT, CREW REPORTED LOSS OF LEFT HYDRAULIC SYSTEM FLUID. EMERGENCY DECLARED FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE DRIVEN PUMP. SYSTEM GROUND CHECKED NORMAL.SDR AALA20120413028Lens · missingR4 DOOR AFT EXIT SIDEWALL EMERGENCY LIGHT LENS BROKEN. REPLACED LENS FOR R4 DOOR AFT EXIT SIDEWALL EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120413027Connector · looseROW 21D EMERGENCY LIGHT INOPERATIVE. SECURED LOOSE CONNECTOR FOR ROW 21D EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120413026Lamp · burned outLEFT FORWARD OVERWING UPPER EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT FORWARD OVERWING UPPER EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120413025Lamp · burned outR4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR R4 DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120413007Connector · unsecureSEAT 31D ESCAPE PATH LIGHT INOPERATIVE. SECURED LOOSE CONNECTOR AT SIDEWALL. OPS CHECKED NORMAL.SDR AALA20120413004Lamp · burned outAFT CARGO DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR AFT CARGO DOOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120411023Seat Track · corrodedCORROSION ON SEAT TRACK A FORWARD END STATION 377. INSTALLED NEW SEAT TRACK A STATIONS 377 TO 438 PER AARD 51-10-05 - 1, REPAIR 1.SDR AALA20120411010Angle · corrodedCORROSION ON CHORD ANGLE IN LEFT SIDE OF NOSE LANDING GEAR WHEEL WELL. REPLACED CHORD ANGLE PER AARD 51-10-05.SDR AALA20120411009Tee Fitting · corrodedTEE FITTING AT STATION 1720 AT BUTTLINE 59 RIGHT HAS CORROSION. REPLACED TEE FITTING PER SRM 51-10-02.SDR AALA20120411008Ring · corrodedCORROSION ON BREAK RING AT STATION 1720 RIGHT AT STRINGER 17 RIGHT. REWORKED CORROSION PER EA B757-53-022696.SDR AALA20120411003Fseu · inoperativeCREW REPORTED ON APPROACH WHEN SELECTING FLAPS, RECEIVED LEADING EDGE SLAT DISAGREE EICAS MESSAGE. EMERGENCY DECLARED & FLIGHT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. PROPERLY SECURED NR 1 FLAP SLAT ELECTRONICS UNIT IN RACK AND REPLACED NR 2SDR AALA20120410013Radome · puncturedINFLIGHT, CREW REPORTED POSSIBLE LIGHTNING STRIKE DAMAGE. FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. DISCOVERED A PUNCTURE IN UPPER RADOME. REPLACED RADOME. SYSTEM GROUND CHECKED NORMAL.SDR AALA20120410027Seat Track · corrodedCORROSION ON SEAT TRACK B FORWARD END STATION 377. REMOVED AND REPLACED SEAT TRACK PER SRM 51-10-02-0G AND AARD 51-00-05-1, REPAIR 1.
Back to Boeing 757-223