Boeing 737-823
Service difficulty reports · 31,890
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 = '737823' 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 = '737823' 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 AALA201805010012Stiffener · corrodedCORROSION ON LOWER HORIZONTAL STIFFENER IN THE APU INLET AROUND FASTENER HOLE BETWEEN BS 1088 TO 1136. REPLACED THE STIFFENER IAW SRM 51-10-02, 51-00-05, REPAIR 1, AND DRAWING 148A8650.SDR AALA201805010011Stiffener · corrodedCORROSION ON STIFFENER AT BS 1125, RIGHT SIDE IN APU BAY. REPLACED THE STIFFENER IAW 51-00-05-R1, AND DRAWING 148A8650.SDR AALA2018052119002Angle · corrodedRIGHT ZEE ANGLE CORRODED FROM THE AFT CORNER OF THE DOOR SILL BETWEEN BS 480 TO 500A. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA201805019017Slide · defectiveTHE AIRCRAFT WAS NOT GROUNDED. FABRIC THAT CONNECTS GIRT BAR TO SLIDE APPEARS TO BE LONG AND DRAGS ALONG FLOOR WHEN DOOR 1R IS OPEN. REMOVED AND REPLACED R1 DOOR SLIDE PER MAINTENANCE WORK CARD 25-94-11.SDR AALA201804309051Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK M1695 FAILED. REPLACED EMERGENCY POWER SUPPLY PER AMM 33-51-06.SDR AALA201804309050Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK M1694 FAILED. REPLACED EMERGENCY BATTERY POWER SUPPLY M1694 PER AMM 33-51-06.SDR AALA2018005019049Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M1672 FAILED. REPLACED THE BATTERY PACK M1672 IAW AMM 33-51-06.SDR AALA201805017006Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT HSS 138.70, 25 INCHES AND 33 INCHES AFT OF THE FORWARD SPAR. REPAIRED STAB SKIN IAW SRM 55-10-01-2R-11.SDR AALA2018050109057Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 7DEF. INSTALLED A NEW LENS IAW MM 33-51-03. GOOD FOR SERVICE.SDR AALA201805019021Battery Pack · no testEMERGENCY LIGHTS FUNCTIONAL TEST FOUND EMERGENCY LIGHTS ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED BATTERY PACK AS REQUIRED. THIS SDR IS FOR ZONE M1672 BATTERY PACK.SDR AALA201805019020Battery Pack · no testEMERGENCY LIGHTS FUNCTIONAL TEST FOUND EMERGENCY LIGHTS ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED BATTERY PACK AS REQUIRED. THIS SDR IS FOR ZONE M1695 BATTERY PACK.SDR AALA201805018003Battery Pack · no testDURING AN EMERGENCY LIGHTS FUNCTIONAL TEST, FOUND THE EMERGENCY LIGHTS AT ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED THE BATTERY PACK.SDR AALA201805018002Switch · inoperativeALL LAVATORIES INOPERATIVE AT CRUISE ALTITUDE. REPLACED THE VACUUM BLOWER BAROMETRIC SWITCH IAW AMM 38-32-12. AIRCRAFT WAS GROUNDED.SDR AALA201804309006Floorboard · damagedFLOORBOARD SOFT NEAR ROW 4.SDR AALA201804306003Floor Support · crackedCABIN FLOOR SUPPORT WAS FOUND CRACKED BETWEEN BS 312 - 328, RBL 31. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201805015007Floor Support · crackedFORWARD AND AFT FLOOR SUPPORT CRACKED AT BS 540, RBL 2. REPLACED FLOOR SUPPORT IAW SRM 51-10-02-0G, PARA 9.SDR AALA2018050109015Lens · missingVERTICAL EMERGENCY EXIT SIGN LENS MISSING AT THE R1 DOOR. REPLACED SIGN ASSEMBLY IAW AMM 33-51-01. AIRCRAFT WAS GROUNDED.SDR AALA201804300008Floor Support · crackedFORWARD AFT FLOOR SUPPORT CRACKED AT BS 540, LBL 2. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02-0G PARAGRAPH 9.SDR AALA2018042700004Transition Panel · corrodedCORROSION FOUND ON THE TRANSITION PANEL BETWEEN BS 420 - 440, RIGHT SIDE, IN THE FORWARD CARGO. REPLACED THE TRANSITION PANEL IAW SRM 53-30-53-OI-2.SDR AALA2018042500001Floorbeam · corrodedCORROSION ON FLOORBEAM ANGLE AT BS 500I. REPLACED THE FLOORBEAM ANGLE IAW DRAWING 143A9481.SDR AALA201804265Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT AT BS 494 INBD OF STRINGER 25R. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201804264Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL LOCATED BETWEEN BS 492 - 500A. REPLACED THE TRANSITION PANEL IAW 51-00-05-1.SDR AALA201804262Web · corrodedCORROSION FOUND ON LOWER CARGO DOOR SILL WEB LOCATED BETWEEN BS 420 - 480. REPLACED THE WEB.SDR AALA201804264009Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL, BS 400 - 420. REPLACED THE TRANSITION PANEL IAW SRM 53-30-53.SDR AALA2018042500013Floor Support · corrodedFORWARD CROSS SECTION HAS CORROSION ON FLOOR SUPPORT AT RBL 16 AT THE FASTNER HOLES AND NUT PLATES AT POD LOCK AT BS 500I MINUS 4 INCHES. REPAIRED THE FLOOR SUPPORT IAW EA 279913 AND SRM 53-00-53-2R-4.SDR AALA2018042500012Door Frame · crackedEXTERNAL POWER RECEIVING DOOR LOWER FRAME FOUND CRACKED. INSTALLED A DOUBLER, FILLER AND RUB BLOCK IAW EA 279797 DRAFT 1, AND OPS CHECKED THE DOOR IAW AMM 52-49-02.SDR AALA20180424008Channel · corrodedDURING W/C INSPECTION, THE LEFT TRANSITION PANEL CHANNEL WAS FOUND TO HAVE NUMEORUS CORROSION SPOTS. REMOVED AND REPLACED THE CHANNEL IAW SRM 53-00-53-2R-5.SDR AALA201804269027Snubber · faultyPRIOR TO BOARDING, FLIGHT ATTENDANT REPORTED THAT AFT LEFT SERVICE DOOR WAS VERY DIFFICULT TO OPEN. MAINTENANCE ACCOMPLISHED TEST IAW MM 52-13-00. REPLACED GUIDE ARM IAW MM 52-41-00 AND SNUBBER IAW MM 52-13-51 AND PERFORMED SATISFACTORY OPERATIONAL CHECK. AISDR AALA201804269025Spring · faultyCAPTAIN`S WINDOW WOULD NOT OPEN FULLY. MAINTENANCE REPLACED THE SPRING. PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 56-12-11. AIRCRAFT WAS GROUNDEDSDR AALA20180423003Threshold · corrodedCORROSION FOUND ON THE DOOR THRESHOLD BETWEEN BS 471 - 478, STRINGER 26R. REPLACED IAW 51-00-05-1.SDR AALA201804269037Cover · detachedL4 DOOR EXIT SIGN COVER DETACHED. REPLACED THE EXIT SIGN ASSEMBLY IAW AMM 33-51-01.SDR AALA2018042503008Baffle · crackedLEFT BAFFLE IN FORWARD CARGO CRACKED AT BS 460 - 480. REPLACED THE BAFFLE IAW 53-00-1-6, AND DRAWING NR 143A7510.SDR AALA2018042503009Baffle · crackedRIGHT BAFFLE IN FORWARD CARGO BAY CRACKED BETWEEN BS 400 TO 420. REPLACED THE BAFFLE IAW 51-00-05-1, AND DRAWING 143A7510.SDR AALA2018042509002Lens · missingEMERGENCY LIGHT LENS MISSING AT THE R1 DOOR. REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR AALA201804269014Guide Arm · faultyPRIOR TO BOARDING, FLIGHT ATTENDANT REPORTED THAT AFT LEFT SERVICE DOOR WAS VERY DIFFICULT TO OPEN. MAINTENANCE ACCOMPLISHED TEST IAW MM 52-13-00, REPLACED THE GUIDE ARM IAW MM 52-41-00 AND SNUBBER IAW MM 52-13-51 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018042659038Sign · detachedEXIT SIGN OVER THE FORWARD GALLEY DOOR DETACHED. REMOVED AND REPLACED THE SIGN IAW MM 33-51-01. OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA2018042615006Stringer · corrodedAFT END ON FORWARD CARGO, BS 540, STRINGER 25R FOUND CORRODED. REMOVED AND REPLACED THE STRINGER SECTION IAW SRM 53-00-03.SDR AALA201804259034Sign · brokenEXIT SIGN BY FORWARD GALLEY DOOR, BROKEN. REPLACED THE SIGN ASSEMBLY. OPS CHECKED IAW AMM 33-51-01.SDR AALA2018050179011Sliding Window · overheatedFIRST OFFICER SLIDING WINDOW NR 4 OVERHEATING AND HAD A DISTINCT ACRID ODOR. REPLACED THE WINDOW AND HEAT CONTROLLER IAW MCM 56-94-02, AND MM 30-41-11. AIRCRAFT WAS GROUNDED.SDR AALA2018042615005Stringer · corrodedAFT END OF FORWARD CARGO, BS 540, STRINGER 26R IS CORRODED. REMOVED AND REPLACED THE STRINGER IAW SRM 53-090-03.SDR AALA201804259007Sign · detachedEXIT SIGN OVER ROWS 14 AND 15, DETACHED. MAINTENANCE SECURED THE EXIT SIGN AND PERFORMED SATISFACTORY OPS CHECK.SDR AALA201804239012Proximity Sensor · faultyDURING APPROACH EXTENDING FLAPS PAST 5 DEGREES, THE AMBER LE FLAP TRANSIT LIGHT ILLUMINATED FOLLOWED BY AURAL WARNING TOO LOW AIRSPEED AND A BRIEF STICK SHAKER. QUICK REFERENCE HANDBOOK PROCEDURE COMPLETED. CREW REPORTED FLAP CONFIGURATION PROBLEM, EMERGENCYSDR AALA201804239007Lens · brokenFLOOR LEVEL EXIT LIGHT NEAR FORWARD JUMPSEAT AND ENTRY DOOR, LENS WAS BROKEN. REPLACED THE EMERGENCY LIGHT LENS ASSEMBLY. OPS CHECKED NORMAL.SDR AALA201804239004Lens · missingDURING PRE-FLIGHT INSPECTION, THE FLIGHT ATTENDANT DISCOVERED A WALL MOUNTED EXIT SIGN LENS MISSING FROM FIRST CLASS GALLEY. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR AALA20180420011Floor Support · corrodedLEFT FLOOR SUPPORT CORRODED AT BS 951, LBL 26. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180419010Floorbeam · corrodedFLOORBEAM CORRODED AT BS 951, LBL 17 - LBL 26. INSTALLED SERVICABLE FLOORBEAM ANGLE IAW 51-00-05-1, AND DRAWING 815A0010, AND 141A5676.SDR AALA2018042019009Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM, BS 951, BETWEEN LBL 27 AND 48. REPLACED THE FLOORBEAM TEE IAW 51-00-05-1, AND DWG 815A0010.SDR AALA20180419008Web · corrodedCORROSION FOUND ON THE RIGHT WEB, BS 998. REPLACED THE WEB IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018042019007Angle · corrodedCORROSION FOUND ON THE RIGHT ZEE ANGLE LOCATED BETWEEN BS 990 AND 1016, RBL 32. REPLACED THE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018042019006Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BS 958, RBL 52. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.
Back to Boeing 737-823