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 AALA20130112001Sign · inoperativeAFT GALLEY EXIT SIGN INOPERATIVE. REPLACED AFT GALLEY EXIT SIGN. OPS CHECK NORMAL.SDR AALA20130109002Connector · looseSEAT NUMBER 4E EMERGENCY EXIT LIGHT INOPERATIVE. RE-SEATED CONNECTOR FOR SEAT 4E EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130108003Skin Panel · damagedLEFT WING INBOARD MAIN FLAP, UPPER SKIN PANEL 113N2401 IS MISDRILLED IN 2 LOCATIONS, MF STATIONS 145.5 AND 209. INSTALLED FREEZE PLUGS PER REO-G15813 REVISION A. INSTALLED FASTENERS THROUGH FREEZE PLUGS AND COMPLETED REPAIR PER EA B757-57-027773.SDR AALA20130107022Gate · corrodedLEFT NUMBER 4 DOOR LOWER GATE EXTERIOR CORRODED BOTH SIDES OF RUB STRIP. REPAIRED CORRODED LOWER GATE PER EA B757-52-027758.SDR AALA20130106010Sign · damagedRIGHT AFT GALLEY RIGHT NUMBER 4 DOOR EMERGENCY EXIT SIGN MISSING LENS AND DAMAGED. REPLACED RIGHT AFT GALLEY EXIT SIGN. OPS CHECK NORMAL.SDR AALA20130106009Frame · dentedAFT CARGO COMPARTMENT, STATION 1500, STRINGERS 25 TO 26 LEFT, FUSELAGE FRAME IS DENTED IN TWO LOCATIONS (DOTS F112 AND F113). INSTALLED REPAIR ANGLE PER SRM 53-00-07-2R5.SDR AALA20130106008Stop Fitting · gougedLEFT NUMBER 1 DOOR UPPER FORWARD STOP FITTING GOUGED. INSTALLED NEW FITTING PER BAC DRAWING 141N8341 AND AARD 51-00-05-1.SDR AALA20130106007Frame · dentedAFT CARGO COMPARTMENT, STATION 1400 AT STRINGER 25 LEFT, FUSELAGE FRAME IS DENTED. INSTALLED REPAIR ANGLE AND STRINGER CLIP PER SRM 53-00-072R5, FIGURE 201 DETAIL III.SDR AALA20130105009Fitting · damagedNUMBER 1 ENGINE PYLON, 3 SHEARED FASTENERS ON INBOARD AFT HINGE THRUST REVERSER FITTING. INSTALLED DOUBLER PER EA B757-54-027263.SDR AALA20130104001Intercostal · crackedINTERCOSTAL WEB CRACKED AT RIGHT BUTTLINE 24 AND BODY STATION 325. REMOVED AND REPLACED WEB INTERCOSTAL PER SRM 51-40-02.SDR AALA20130104006Intercostal · crackedCOCKPIT FLOORBEAM AREA INTERCOSTAL CRACKED AT BODY STATION 300, LEFT BUTTLINE 9, THRU ACCESS PANEL 117AL. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA20130103006Support · corrodedMAIN CABIN FLOORBEAM SUPPORT UPPER SURFACE CORRODED AT BODY STATION 403, RIGHT BUTTLINES 12 TO 23. REPLACED SUPPORT PER SRM 51-40-02.SDR AALA20130103005Support · corrodedMAIN CABIN FLOORBEAM SUPPORT UPPER SURFACE CORRODED FROM BODY STATIONS 395 TO 405, RIGHT BUTTLINE 11. INSTALLED NEW SUPPORT PER SRM 51-40-02.SDR AALA20130103004Support · corrodedMAIN CABIN FLOORBEAM SUPPORT UPPER SURFACE CORRODED AT BODY STATION 347, RIGHT BUTTLINE 23. INSTALLED NEW T-CAP SUPPORT PER SRM 51-40-05 AND BOEING DRAWING 141N5150.SDR AALA20130103003Support · corrodedMAIN CABIN FLOORBEAM SUPPORT UPPER SURFACE CORRODED FROM BODY STATIONS 395 TO 405, RIGHT BUTTLINE 62. INSTALLED SUPPORT AND ASSEMBLY PER SRM 51-40-02.SDR AALA20130103002Attach Angle · corrodedMAIN CABIN FLOOR SUPPORT LOWER ATTACH ANGLE CORRODED BODY STATION 335, RIGHT BUTTLINE 27. REPLACED ANGLE PER SRM 51-40-02.SDR AALA20130103001Support · corrodedMAIN CABIN FLOORBEAM SUPPORT UPPER SURFACE CORRODD BODY STATION 403, RIGHT BUTTLINES 47 TO 58. REPLACED SUPPORT AND ASSEMBLY SRM 51-40-02.SDR AALA20121227005Sensor · inoperativeMIA - CREW REPORTED LEFT FUEL QUANTITY BLANKED OUT. EMERGENCY DECLARED FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. PLACARD TOTAL FUEL QUANTITY INDICATOR INOPERATIVE PER MEL 28-13A. FLIGHT CONTINUED TO DESTINATION. REPLACED LEFT MAIN TANK UNIT NUMBER 1 TO SDR AALA20121226006Battery Pack · dischargedSEAT MOUNTED EMERGENCY LIGHTS FROM ROWS 9 TO 16 INOPERTIVE. REPLACED BATTERY PACK M10952. OPS CHECK NORMAL.SDR AALA20121226001Light · inoperativeEMERGENCY EXIT LIGHT AT 36DEF BULL-NOSE INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT 36DEF. OPS CHECK NORMAL.SDR AALA20121226005Socket · dirtyLEFT NUMBER 3 EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. CLEANED SOCKET. OPS CHECK NORMAL.SDR AALA20121224001Jackscrew · lack of lubeSFO - CREW REPORTED EICAS MESSAGE TRAILING EDGE FLAP DISAGREE. EMERGENCY DECLARED FLIGHT LANDED SFO WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND NUMBER 6 TORQUE LIMITER TRIPPED. RESET AND LUBED JACKSCREW. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20121222003Transmission · failedSFO - CREW REPORTED TRAILING EDGE FLAP ASYMMETRY EICAS MESSAGE. EMERGENCY DECLARED FLIGHT LANDED SFO WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND RIGHT INBOARD FLAP TRANSMISSION INDICATOR POPPED. REPLACED NUMBER 5 FLAP TRANSMISSION. SYSTEM GROUNSDR AALA20121222001Battery Pack · dischargedSEAT EMERGENCY EVACUATING LIGHTS FROM ROWS 1 TO 6 INOPERATIVE. REPLACED BATTERY PACK M10798. OPS CHECK NORMAL.SDR AALA20121226002Connector · looseEMERGENCY EXIT LIGHT AT SEAT 36DEF INOPERATIVE. SECURED LOOSE CONNECTOR. OPS CHECK NORMAL.SDR AALA20121219007Pump · leakingMIA - CREW REPORTED LEFT ENGINE HYDRAULIC PUMP EICAS WARNING. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEFT ENGINE HYDRAULIC PUMP LEAKING. REPLACED ENGINE DRIVEN HYDRAULIC PUMP. SYSTEM GROUND CHECK NORMALSDR AALA20121216001Stop Fitting · wornLEFT NUMBER 1 UPPER FORWARD DOOR STOP FITTING WORN. REMOVED AND REPLACED FITTING PER AARD 51-00-05 FIGURE 1.SDR AALA20130107006Shear Tie · gougedSHEAR TIE GOUGED IN THE AFT CARGO STATION 1540, STRINGER 25 RIGHT. REPAIRED SHEAR TIE PER SRM 53-00-03-2R FIGURE 201.SDR AALA20121214005Smoke Detector · defectiveLBB - INFLIGHT JAC-DFW. CREW REPORTED FORWARD LAVATORY SMOKE DETECTOR FIRE WARNING MESSAGE. EMERGENCY DECLARED FLIGHT DIVERTED LBB LANDED WITHOUT INCIDENT. PLACARD SMOKE DETECTOR PER MEL. REPLACED FORWARD LAVATORY SMOKE DETECTOR. SYSTEM GROUND CHECK NORMASDR AALA20121213014Stop Fitting · out of adjustJFK - CREW REPORTED LEFT NUMBER 4 DOOR HANDLE MOVED IN FLIGHT AND DOOR INDICATION EICAS MESSAGE INDICATION. FLIGHT RETURNED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND SEVERAL DOOR STOPS OUT OF ADJUSTMENT. RE-ADJUSTED DOOR STOPS. SYSTSDR AALA20130107004Frame · dentedAFT CARGO, STATION 1540 STRINGER 25 RIGHT FRAME DENTED. INSTALLED NESTED ANGLE REPAIR PER SRM 53-00-07-2R.SDR AALA20130104014Support · corrodedMAIN FLOORBEAM SUPPORT UPPER SURFACE CORRODED BODY STATION 365, RIGHT BUTTLINES 44 TO 47. REMOVED DAMAGE AND REPAIRED SUPPORT PER EA B757-53-027701.SDR AALA20121212003Light · inoperativeSEAT 36D EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 36D EMERGENCY EXIT LIGHT. OPS CHECK NORMAL.SDR AALA20130107007Frame · dentedAFT CARGO, FRAME STATION 1480 DENTED FROM STRINGERS 25 TO 27 LEFT. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-07-2R.SDR AALA20130107005Frame · dentedFRAME DENTED AT SATTION 1440, STRINGER 26 LEFT. INSTALLED NESTED ANGLE REPAIR PER SRM 53-00-07-2R 5 FIG 201 DETAIL I.SDR AALA20121212017Connector · disconnectedEMERGENCY LIGHTS MOUNTED ON FORWARD GALLEY ENTRY WALL (DOUBLE ARROW WITH RED TIPS LENS) INOPERATIVE. CONNECTED CONNECTORS PROPERLY. OPS CHECK NORMAL.SDR AALA20121212016Wire · pinchedEMERGENCY LIGHTS FROM SEATS 1E TO 4E STAY ON WITH POWER OFF. REPAIRED PINCHED WIRE AT RIGHT NUMBER 1 DOOR. OPS CHECK NORMAL.SDR AALA20121210015Hydraulic Line · leakingSJU - CREW REPORTED LEFT HYDRAULIC QUANTITY LOSS. EMERGENCY DECLARED FLIGHT RETURNED SJU LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED STEERING FLEX HOSE IN NOSE GEAR WHEEL WELL. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20121211011Light · inoperativeEMERGENCY EXIT SPOT LIGHT AT ROW 18ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT SPOT LIGHT AT ROW 18ABC. OPS CHECK NORMAL.SDR AALA20121211005Light · inoperativeEXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER 4 DOOR INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20121210002Light · brokenEMERGENCY PATH LIGHT AT SEAT 28D BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY PATH LIGHT AT SEAT 28D. OPS CHECK NORMAL.SDR AALA20121209013Skin · damagedLIGHTNING STRIKES AT STATION 660 STRINGER 21 RIGHT. INSTALLED DOUBLER AT STATION 660 PER EA B757-53-027481.SDR AALA20121209009Skin · damagedLIGHTNING STRIKE TO STATION 1458 BETWEEN STRINGERS 2 AND 3 RIGHT. INSTALLED DOUBLER PER EA B757-53-027450.SDR AALA20121209008Skin · damagedLIGHTNING STRIKE DAMAGE TO STATION 1442. INSTALLED DOUBLER PER EA B757-53-027479.SDR AALA20121208001Light · inoperativeEMERGENCY LIGHT AT SEAT 32D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 32D. OPS CHECK NORMAL.SDR AALA20121205001Idg · failedEWR - INFLIGHT BGI-JFK CREW REPORTED LEFT AC BUSS FAILED. EMERGENCY DECLARED FLIGHT DIVERTED EWR LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED INTEGRATED DRIVE GENERATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20121205003Connector · looseROW 15D SEAT EMERGENCY LIGHT INOPERATIVE. RESEATED LOOSE CONNECTOR AT SEAT 15D. OPS CHECK NORMAL.SDR AALA20121202009Control Panel · shortedPTY INFLIGHT MIA-UIO. CREW REPORTED ELECTRICAL SPARKS IN FLIGHT DECK OVERHEAD PANEL. EMERGENCY DECLARED FLIGHT DIVERTED PTY LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED EXTERIOR LIGHTS CONTROL PANEL THAT HAD SHORTED. SYSTEM GROUND CHECSDR AALA20121201011Frame · gougedDEEP GOUGE IN FRAME, FORWARD SIDE OF E AND E ACCESS DOOR CUTOUT. INSTALLED DOUBLER REPAIR PER EA B757-53-027257.SDR AALA20121201012Web · crackedRIGHT HORIZONTAL INTERNAL WEB AT RIB 11 BENT AND CRACKED. WEB AND CHORD REPLACED PER B757 AARD 51-00-05-1 AND 51-20-00-1.
Back to Boeing 757-223