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 AALA20140419002Light · inoperativeFIRST CLASS GALLEY SIDE MOUNTED EMERGENCY EXIT LIGHT AISLE ILLUMINATION INOPERATIVE. REPLACED GALLEY EMERGENCY EXIT LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140419008Light · inoperativeRIGHT FWD OVER THE WING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RT FWD OVER THE WING SLIDE LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140419007Battery Pack · dischargedRIGHT OVERWING EMERGENCY INTERIOR DOOR LIGHT INOPERATIVE. REPLACED M10568 BATTERY PACK & M10614 LIGHT ASSEMBLY, OPERATIONS CHECKED NORMAL.SDR AALA20140415012Filter · dirtyDFW INFLIGHT MCO - LAX. CREW REPORTED STRONG ELEC SMELL THROUGHOUT ACFT. FLIGHT DIVERTED DFW & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED LT CABIN RECIRCULATION FILTER. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20140416007Wire · damagedEMERGENCY LIGHTS FROM ROWS 26 TO 36 INOPERATIVE. FOUND DAMAGED WIRES ON L759 EXIT LIGHT. R & R LIGHT FIXTURE L759. OPERATIONS CHECKED NORMAL.SDR AALA20140416006Light · damagedEMERGENCY EXIT LIGHT AT LT NR 4 DOOR DAMAGED. REPLACED LIGHT ASSEMBLY AT LT NR 4 DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20140415007Sign · inoperativeLEFT OVERWING EMERGENCY EXIT SIGN LIGHT INOPERATIVE. REPLACED LT OVERWING EMERGENCY EXIT SIGN LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140414003Skin · crackedNUMBER 2 ENG PYLON HAS A CRACK INDICATION AT INBD UPPER AFT THRUST REVERSER HINGE MOUNT FASTENER HOLE, ALUMINUM SKIN LAYER ONLY. REMOVED CRACK BY ENLARGING HOLE TO .831 INCHES IN ALUMINUM SKIN LAYERS ONLY & INSTALLED FREEZE PLUG. INSTALLED DOUBLER IAW B757-SDR AALA20140413006Seat Track · gougedMAIN CABIN SEAT TRACK GOUGED AT BS 870 & RBL 25. R & R SECTION OF SEAT TRACK IAW SRM 53-00-52.SDR AALA20140413005Doubler · gougedRIGHT NR 1 DOOR INNER DOUBLER IS GOUGED UNDER UPPER HINGE ARM TORQUE TUBE FROM STATIONS 338 TO 302. ACCOMPLISHED REPAIR IAW ESO 90284 PG 1 STEP 1 1 1 12.SDR AALA20140413004Transition Panel · corrodedFORWARD CARGO COMPARTMENT, DOOR SILL SUPPORT STRUCTURE UNDERSIDE CORRODED AT NUTPLATES FROM FRAME STATIONS 560 TO 620. REMOVED CORROSION & REPLACED TRANSITION PANEL FROM STATIONS 560 TO 645.SDR AALA20140413003Transition Panel · corrodedFORWARD CARGO COMPARTMENT, DOORWAY TRANSITION PANEL FROM STATIONS 580 TO 645 HAS SCATTERED SURFACE CORROSION. REMOVED CORROSION & REPLACED TRANSITION PANEL.SDR AALA20140413002Support Channel · corrodedAFT LOWER CARGO DOOR SILL UPPER FLOOR SUPPORT CHANNEL IS CORRODED UNDERNEATH AT SEVERAL NUTPLATES & ON TOP. REMOVED CORROSION & REPLACED SIDE PANEL.SDR AALA20140413001Support · corrodedFORWARD CARGO COMPARTMENT, DOOR SILL SUPPORT STRUCTURE CORRODED FROM FRAME STATIONS 560 TO 620. REMOVED CORROSION & REPLACED TRANSITION PANEL.SDR AALA20140410005Transition Panel · corrodedFORWARD CARGO COMPARTMENT, RT FLOOR TRANSITION PANEL CORRODED FROM FRAME STATIONS 646 TO 666. REMOVED CORROSION & REPAIRED RT FLOOR TRANSITION PANEL.SDR AALA20140409005Floor Panel · corrodedAFT CARGO PIT, NR 1 FLOOR PANEL UNDERSIDE HAS CORROSION AROUND MOST SCREW HOLES. REMOVED CORROSION & INSTALLED NEW PANEL IAW AARD 51-20-00-1.SDR AALA20140409007Line · leakingMIA CREW REPORTED ON GO AROUND, L HYD QTY, LIGHT ILLUMINATED. LANDING TOWER REPORTED RT GEAR SMOKING. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND NR 3 BRAKE LINE LEAKING HYD FLUID. SECURED LINE, SYS GND CHECKED NSDR AALA20140407013Retaining Nut · missingMIA CREW REPORTED TE FLAP ASYMMETRY. EMERGENCY DECLARED FLIGHT RETURNED MIA & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND RETAINING NUT ON BEARING ASSEMBLY MISSING. REPLACED BEARING ASSEMBLY ON RT FLAP, SYS GND CHECKED NORMAL, OPERATION CLOSESDR AALA20140407007Structure · corrodedCORROSION ON INNER CHORD FROM STATION 560 TO 620 & WL 208.10. INSTALLED INNER CHORD & TWO SPLICES IAW AARD 53-30-13-1A.SDR AALA20140406001Web · corrodedCORROSION ON WEB ABOVE FWD CARGO DOOR CUT OUT AT BS 590. REMOVED FLOOR PANEL STATION 560 - 620, RBL 46-64, REMOVED CORRODED WEB & INSTALLED NEW WEB.SDR AALA20140404007Attach Angle · corrodedBS 1020 RT WING UPPER WING TO BODY PANEL ATTACH ANGLE CORRODED. R & R FILLER IAW AARD 51-20-00-1.SDR AALA20140404004Floorbeam · corrodedSTATION 1680 AT LBL 12 T CAP HAS CORROSION UNDER METAL CLIP. FLOORBEAM FOUND TO BE OUT OF LIMITS AFTER CORROSION REMOVED. REPAIRED FLOORBEAM IAW SRM 53-60-51.SDR AALA20140404003Intercostal · corrodedSTATION 1635 AT RBL 20 FLOOR SUPPORT INTERCOSTAL CORRODED. R & R INTERCOSTAL IAW AARD 51-00-05.SDR AALA20140404002Connector · brokenRIGHT ROW 28 EMERGENCY LIGHT CONNECTOR BROKEN. REPLACED RT ROW 28 EMERGENCY LIGHT CONNECTOR, OPERATIONS CHECKED NORMAL.SDR AALA20140404001Contact · dirtyEXTERIOR EMERGENCY LIGHT AT RT NR 2 DOOR INOPERATIVE. CLEANED CONTACTS ON LIGHT ASSEMBLY FOR EXTERIOR EMERGENCY LIGHT AT RT NR 2 DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20140403008Skin · dentedLEFT EXTERIOR FUSELAGE SKIN DENTED FROM BS 570 TO 577 & STRINGERS 16 TO 17 LT. REMOVED DAMAGE, INSTALLED DOUBLER & FILLER IAW SRM 53-00-02.SDR AALA20140403007Floorbeam · corrodedSTATION 1640 FLOORBEAM TEE CAP CORRODED AT RBL 18. REPAIRED 1640 FLOORBEAM FROM LBL 14 TO RBL 36 IAW SRM 53-00-51 REPAIR 10.SDR AALA20140403006Mount · corrodedG4B GALLEY RT SECTION COFFEE MAKER MOUNTING PLATE IS CORRODED. R & R COFFEE MAKER MOUNTING PLATE IAW AARD 25-30-00-8 PAGES 1 - 2.SDR AALA20140408010Floorbeam · corrodedCORROSION AT STATION 1661 & RBL 37 ON TOP OF BEAM. INSTALLED DOUBLER IAW SRM 53-00-51-2R-11.SDR AALA20140403005Lamp · burned outEMERGENCY EXIT LIGHT AT SEAT 36D INOPERATIVE. SECURED CONNECTOR & REPLACED LAMP FOR SEAT 36D EMERGENCY EXIT LIGHT. OPS CHECKED NORMAL.SDR AALA20140403004Lamp · burned outEMERGENCY EXIT LIGHT AT SEAT 34D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 34D. OPS CHECKED NORMAL.SDR AALA20140403003Lamp · burned outEMERGENCY EXIT LIGHT AT SEAT 28D INOPERATIVE. SECURED CONNECTOR & REPLACED LAMP FOR SEAT 28D EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20140402003Floor Support · corrodedFLOOR SUPPORT BS 1635 & LBL 20 CORRODED. R & R FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA20140402002Strap · corrodedNUTPLATE & METAL STRAP IS CORRODED ON T CAP AT BS 1680 AT LBL 12. R & R NUTPLATE & METAL STRAP ON T CAP AT IAW AARD 51-00-05 REPAIR 1.SDR AALA20140331002Sill · corrodedCORROSION ON LT NR 4 DOOR CUT OUT, LOWER SILL, UPPER SURFACE, AT AFT END. R & R ANGLE IAW SRM 51-40-02.SDR AALA20140331001Intercostal · corrodedCORROSION ON INTERCOSTAL INBD OF RT NR 1 DOOR SILL FROM BS 324 TO 365. R & R INTERCOSTAL IAW RD 51-00-05.SDR AALA20140330004Nut Plate · corrodedNR 1 PYLON AFT FAIRING MATTING SURFACES TO STRINGER PANEL NUTPLATE CORRODED THROUGHOUT ON BOTH SIDE. R & R 17 NUTPLATES IAW SRM 51-40-02.SDR AALA20140330003Attach Angle · damagedKEEL BEAM ATTACH ANGLE AT STATION 1100 HAS ELONGATED HOLES. INSTALLED NEW KEEL ANGLE IAW SRM 51-40-02.SDR AALA20140330002Mount · corrodedAFT RT LAVATORY THE INBD AFT MOUNT PAD IS CORRODED. R & R MOUNT PAD IAW SRM 51-40-02.SDR AALA20140330001Bracket · corrodedLAVATORY K DOOR BRACKET CORRODED. R & R BRACKET IAW CMM 25-40-85 PG 706.SDR AALA20140329002Probe · failedDURING CLIMB, RT ENGINE HIGH TEMPERATURE LIGHT ILLUMINATED. EMERGENCY DECLARED, FLIGHT RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND RT ENGINE PROBE FAILED TO HEAT AT PROBE CONNECTOR & WIRE W5032-2500R-20 BROKEN. REPSDR AALA20140328010Angle · corrodedMAIN CABIN BS 365, RT NR 1 LOWER SILL ANGLE CORRODED. R & R ANGLE IAW SRM 51-40-02.SDR AALA20140328008Support · corrodedMAIN CABIN BS 330, RT NR 1 DOOR DRAIN PAN SUPPORT CORRODED. R & R DRAIN PAN SUPPORT IAW SRM 51-40-02.SDR AALA20140328007Mount · corrodedAFT GALLEY, THE RT AFT GALLEY MOUNT IS CORRODED. R & R GALLEY MOUNT IAW AARD 51-00-05.SDR AALA20140328005Light · inoperativeFORWARD OVER THE WING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR FWD OVER THE WING EMERGENCY LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140328001Bulkhead · crackedLT PYLON INBD MID BULKHEAD CRACKED. REPAIRED LT PYLON MID BULKHEAD IAW EA B757-54-034038.SDR AALA20140406005Intercostal · crackedAFT CARGO PIT, CABIN UNDERFLOOR INTERCOSTAL CRACKED IN UPPER FLANGE FROM STATIONS 1580 TO 1600, BL 0. R & R THE CRACKED INTERCOSTAL IAW SRM 51-40-02.SDR AALA20140327006Wire Harness · disconnectedSEAT 25D EMERGENCY LIGHTS INOPERATIVE. RECONNECTED SEAT 25D EMERGENCY LIGHTS WIRE BUNDLE NEXT TO WALL. OPERATIONS CHECKED NORMAL.SDR AALA20140327005Wire Harness · disconnectedSEAT 17D BOTH RED LIGHT EMERGENCY LIGHTS INOPERATIVE. RECONNECTED SEAT 17D EMERGENCY LIGHT WIRE BUNDLE NEXT TO BULKHEAD. OPERATIONS CHECKED NORMAL.SDR AALA20140325006Gate · out of rigDFW CREW REPORTED LT AFT ENTRY DOOR EICAS MSG & ENTRY DOORS OVERHEAD LIGHT ILLUMINATED ALONG WITH LOSS OF PRESSURIZATION. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND LOWER GATE OUT OF RIG. RE-RIGGED LT NR
Back to Boeing 757-223