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 AALA20170424004Stiffener · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. HORIZONTAL STIFFENER CORRODED IN LOWER APU FIREWALL, FUSELAGE STATION 1885.2 BL0, 3 INCHES FROM BOTTOM OF FORWARD BULKHEAD ALONG UPPER SURFACE. REMOVED AND REPLACED STIFFENER IAW SRM 51-40-02, AARD 51-00-05-1, EA 269362, ANSDR AALA201704249025Lens · missingEMERGENCY EXIT SIGN AT L2 DOOR HAS A MISSING LENS. INSTALLED A NEW LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201704259026Warning Message · illuminatedEMERGENCY DECLARED. RETURNED TO FIELD. DURING FLIGHT RECEIVED EICAS HYD QTY LOW MESSAGE ACCOMPLANIED BY AN INDICATION OF SLOW LOSS OF FLUID INDICATED. IT WAS DETERMINED THAT THE LEFT HYDRAULIC QUANTITY INDICATION WAS ON MEL AND PLACARDED PER 29-9 AUTH: 4-421DSDR AALA201704249024Battery · dischargedFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT AFT GALLEY RIGHT OTBD SEAT IS DIM. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECKED GOOD.SDR AALA201704249028Lamp · looseEXTERIOR EMERGENCY EVACUATION SLIDE LIGHT AT L4 DOOR IS INOPERATIVE. SECURED THE LAMP IN THE LIGHT ASSEMBLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201704249026Battery · inoperativeFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECKED GOOD.SDR AALA20170421002Lens · missingEMERGENCY EXIT SIGN AT R2 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170421001Lens · missingEMERGENCY EXIT SIGN OUTSIDE FORWARD GALLEY LOWER AISLE HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201704219023Bulb · looseEMERGENCY EVACUATION SLIDE EXTERIOR LIGHT AT L2 DOOR IS INOPERATIVE. SECURED BULB IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201704209013Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR HAS A DETACHED LENS COVER. REATTACHED LENS COVER . OPERATIONAL CHECK GOOD.SDR AALA20170417001Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT R4/L4 DOORS AND SEAT MOUNTED ESCAPE PATH LIGHTS AT SEATS 26D-36D ARE VERY DIM. REMOVED AND REPLACED BATTERY PACK AT L4 DOOR IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201704179053Fan · failedCAPTAIN REPORTED ELECTRICAL ODOR IN CABIN AFTER THE LEFT RECIRCULATION FAN FAILED. REMOVED AND REPLACED LEFT RECIRCULATION FAN IAW AMM 21-25-01. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201704189017Battery Pack · dischargedEMERGENCY EXIT SIGNS AT THE L1, L2, R1, R2 DOORS AND SEAT MOUNTED EMERGENCY LIGHTS ON SEATS 1E-4E AND 9D-15D ARE ALL DIM. ACCOMPLISHED BATTERY PACK CHARGE IAW AMM 33-51-07-610-801. OPERATIONAL CHECKED GOOD.SDR AALA201704179056Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 4C HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201704139002Girt Bar · out of adjustAIRCRAFT WAS GROUNDED. L1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR IS DIFFICULT TO OPEN. ADJUSTED GIRT BAR IAW AMM 52-11-25. OPERATIONAL CHECK GOOD.SDR AALA201704139001Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L2 DOOR HAS A MISSING LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201704139003Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EXTERIOR EMERGENCY EXIT LIGHT BY L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA201704119015Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS AT L4/R4 DOORS ARE DIM. RECHARGED EMERGENCY LIGHTS SYSTEM IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201704119014Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AFT CABIN RIGHT OUTERMOST SEAT IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-60-00. OPERATIONAL CHECK GOOD.SDR AALA201704119013Slider · dirtyAIRCRAFT WAS NOT GROUNDED. R2 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR SHOWS ARMED WHEN PHYSICALLY DISARMED. CLEANED GIRT BAR SLIDERS. OPERATIONAL CHECK GOOD.SDR AALA201704109053Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R4 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201704109048Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L2 DOOR HAS A LOOSE LENS COVER. SECURED LENS COVER IAW AMM 33-24-00. OPERATIONAL CHECK GOOD.SDR AALA201704109046Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L1 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201704109045Connector · looseAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 17D SEAT IS INOPERATIVE. RESEATED SEAT CONNECTOR IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA201704109047Channel · lack of lubeAIRCRAFT WAS NOT GROUNDED. CAPTAINS SLIDING WINDOW IS EXTREMELY DIFFICULT TO OPEN AND CLOSE. LUBRICATED GUIDE CHANNEL AND TRACKS IAW AMM 56-10-00. OPERATIONAL CHECK GOOD.SDR AALA201704079021Reservoir · low pressureL2 DOOR EMERGENCY POWER RESERVOIR PRESSURE IS LOW. REMOVED AND REPLACED RESERVOIR IAW AMM 52-11-30. OPERATIONAL CHECKED GOOD.SDR AALA201704069022Panel · unsecureFLIGHT ATTENDANT REPORTED THE LIFE RAFT DOOR PANEL IN MAIN CABIN CEILING IS NOT SECURE. SECURED THE PANEL ASSEMBLY. OPERATIONAL CHECKED GOOD.SDR AALA20170405008Fitting · corrodedFORWARD GALLEY FLOOR BEAM MOUNT FITTING CORRODED AT BS 327, RBL 42. REMOVED AND REPLACED FITTING ASSEMBLY IAW 51-00-05-1.SDR AALA20170405007Fitting · corrodedAFT GALLEY FLOOR BEAM CENTER MOUNT FITTING CORRODED AT BS 1688, BL 0. REMOVED AND REPLACED THE FITTING ASSEMBLY IAW SRM 51-40-02.SDR AALA20170405005Fitting · corrodedAFT GALLEY FLOOR BEAM MOUNT FITTING CORRODED AT BS 1713, RBL52. REMOVED AND REPLACED THE FITTING ASSEMBLY IAW SRM 51-40-02.SDR AALA20170405004Fitting · corrodedAFT GALLEY FLOORBEAM MOUNT FITTING CORRODED AT BS 1712, LBL 51. REMOVED AND REPLACED THE FITTING ASSEMBLY IAW SRM 51-40-02.SDR AALA201704049016Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT BOTTOM OF SEAT 4E HAS A DETACHED LENS COVER. REPLACED LENS COVER IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA20170419002Skin · corrodedLEFT PYLON CORRODED ON THE RIGHT SIDE OF THE PRESSURE REGULATING AND SHUTOFF VALVE ACCESS PANEL LANDING. REPAIRED IAW SRM 51-10-02-0G AND EA 268826.SDR AALA201703289001Pawl · disengagedAIRCRAFT WAS NOT GROUNDED. FORWARD SLIDE GIRT BAR ENGAGE LIGHT DOES NOT ILLUMINATE WHEN SLIDE IS ARMED DUE TO PAWL NOT ENGAGING. REINSTALLED GIRT BAR PAWL IAW AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA20170425003Skin · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. LEFT ENGINE PYLON INBOARD SKIN CORRODED AFT OF THE LOWER CHORD FLANGE. REPAIRED IAW EA 268963.SDR AALA201703279026Indicator · faultyDURING TAKEOFF ROLL, CAPTAIN`S AIRSPEED INDICATOR FAILED. ABORTED TAKEOFF AT 100 KNOTS. REMOVED AND REPLACED THE MACH AIRSPEED INDICATOR IAW AMM 34-13-02. OPS CHECKED GOOD.SDR U2RA201703250001Light · inoperativeEMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 34 DOES NOT ILLUMINATE. RELAMPED EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 34 IN ACCORDANCE WITH AMM 33-51-11 LIGHT TESTS GOOD.SDR AALA201703279037Lens · missingEMERGENCY LIGHT HAS A MISSING LENS COVER. INSTALLED THE LENS. OPERATIONAL CHECK GOOD.SDR AALA201703279036Lens · missingFLOOR PROXIMITY EMERGENCY EXIT FLOODLIGHT IN THE FORWARD GALLEY HAS A MISSING LENS COVER. REPLACED LENS . OPERATIONAL CHECKED GOOD.SDR AALA201703279039Bulb · looseL2 DOOR EMERGENCY EVACUATION SLIDE LIGHT IS INOPERATIVE. RESEATED BULB IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201703279038Connector · looseSEAT MOUNTED EMERGENCY LIGHT AT SEAT 24D IS INOPERATIVE. SEATED LOOSE CONNECTOR IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201703239018Switch · damagedNOSE LANDING GEAR EMERGENCY LIGHT SWITCH IS DAMAGED. REMOVED AND REPLACED SWITCH S10035 IAW WDM 33-51-11. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201703229016Cover · damagedL4 DOOR SLIDE COVER HAS A HOLE IN IT AT THE 1 OCLOCK POSITION. REMOVED AND REPLACED THE SLIDE COVER IAW AMM 25-66-01. OPS CHECKED GOOD.SDR AALA201703239016Charger · inoperativeALL EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-51-11. REMOVED AND REPLACED CHARGER ASSEMBLES IAW AMM 33-51-11. OPS CHECKED GOOD. ACFT GROUNDED.SDR AALA201703239015Charger · inoperativeALL EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-51-11. REMOVED AND REPLACED CHARGER ASSEMBLES IAW AMM 33-51-11. OPS CHECKED GOOD. ACFT GROUNDED.SDR AALA201703239014Charger · inoperativeALL EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-51-11. REMOVED AND REPLACED CHARGER ASSEMBLES IAW AMM 33-51-11. OPS CHECKED GOOD. ACFT GROUNDED.SDR AALA201703239013Battery Pack · inoperativeALL EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-51-11. REMOVED AND REPLACED CHARGER ASSEMBLES IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201703239012Battery Pack · inoperativeALL EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-51-11. REMOVED AND REPLACED CHARGER ASSEMBLES IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201703239009Light · brokenL1 DOOR AFT EMERGENCY LIGHT INDICATOR ASSEMBLY IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10. OPS CHECKED GOOD.SDR AALA201703239007Battery Pack · inoperativeALL EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-51-11. REMOVED AND REPLACED CHARGER ASSEMBLES IAW AMM 33-51-11. OPS CHECKED GOOD.
Back to Boeing 757-223