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 AALA20180305004Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM REPAIR, BS 947, LBL 5. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R1.SDR AALA20180305003Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM REPAIR AT BS 947, RBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R1.SDR AALA201803079020Lens · missingEMERGENCY AISLE LIGHT LENS AT BS 727 MISSING. INSTALLED A NEW LENS IAW AMM 25-63-00.SDR AALA201803079019Lens · missingEMERGENCY AISLE LIGHT LENS AT BS 727 MISSING. INSTALLED A NEW LENS IAW AMM 25-63-00.SDR AALA201803069028Guide Arm · out of adjustL1 DOOR DIFFICULT TO CLOSE, HANDLE CATCHES AND STOPS. HAD TO CYCLE HANDLE SEVERAL TIMES. FOUND GUIDE ARM OUT OF ADJUSTMENT. ADJUSTED THE GUIDE ARM IAW MM 52-11-00. OPS CHECKED GOOD.SDR AALA20180305007Web · corrodedCORROSION ON AFT WEB BS 987, RBL 45. REPLACED THE WEB IAW 51-00-05-1, AND DRAWING 147A5700.SDR AALA20180305006Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT BETWEEN BS 967 TO 947 AT LBL 24. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, 51-00-05-01, AND DRAWING 147A5650.SDR AALA20180305002Floorbeam · corrodedCORROSION FOUND ON THE FLOOR BEAM REPAIR AT BS 947, RBL 10. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R4.SDR AALA20180305015Angle · corrodedRIGHT CREASE ANGLE CORRODED AT BS 992 - 994. REMOVED AND REPLACED THE CREASE ANGLE 147A8540U8 IAW DRAWING 147A8501, 147A0000, AND SRM 51-40-02.SDR AALA201803099001Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. DFW FLT 1594 EN-ROUTE MCO - DCA. AFT LEFT LAV SMOKE DETECTOR INTERMITTENTLY CAME OK, NO SMOKE IN LAV. MAINTENANCE ACCOMPLISHED LT AFT LAV SMOKE DETECTION SELF TEST IAW AMM 26-14-00, CKS OK.SDR AALA201803069004Lens · missingAIRCRAFT WAS NOT GROUNDED. AFT GALLEY RIGHT HAND DOOR LIGHT LENS COVER MISSING. LENS COVER SECURED WITH CLEAR TAPE. REPLACED AFT RIGHT EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA201803069011Ring · detachedNYLON FELL OFF THE L1 DOOR GIRT BAR. MAINTENANCE REINSTALLED NYLON RING ON GIRT BAR ON L1 DOOR PER AMM 25-66-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180304004Control Valve · faultyAT FLIGHT LEVEL 220, SINGLE PACK OPERATIONS, RIGHT PACK OPERATING, UNABLE TO CONTROL CABIN TEMPERATURE. RIGHT PACK OUTPUT TEMPERATURE 110 DEGREES FAHRENHEIT AT CRUISE POWER, REGARDLESS OF TEMPERATURE CONTROL POSITION, INCLUDING ALL 3. FLIGHT ATTENDANT COMPLAINSDR AALA201803069027Door · lack of lubeFLIGHT ATTENDANT REPORTED THE L4 DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED THE DOOR IAW 52-13-00. OPS CHECKED GOOD.SDR AALA201803069034Guide Arm · wornL1 DOOR DIFFICULT TO OPEN AND CLOSE. REPLACED THE GUIDE ARM AND ROLLER ASSEMBLY IAW AMM 52-11-21.SDR AALA20180304001Rib · crackedCRACKED RIGHT HORIZONTAL STABILIZER REMOVABLE L/E 4TH FROM INBOUND RIB HSS 101.90. REPLACED THE HORIZONTAL STABILIZER IAW 51-00-05-1.SDR AALA201803059033Lens · detachedR1 EMERGENCY LIGHT LENS DETACHED. SECURED THE LENS. OK FOR SERVICE IAW AMM 25-63-00.SDR AALA201803059032Lens · brokenAFT EXIT LIGHT COVER BROKEN. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-02.SDR AALA20180304003Angle · crackedCRACKED CABIN ANGLE AT BS 540, LBL 1. REPLACED THE ANGLE IAW 51-00-05-1.SDR AALA20180304002Angle · crackedCRACKED CABIN ANGLE BS 540, 1 INCH OUTBOARD OF BL 0. REPLACED THE ANGLE IAW 51-00-05-1.SDR AALA201803069002Sign · inoperativeAFT EMERGENCY LIGHTS AT LEFT DOOR INOPERATIVE, FOUND CENTER AISLE EXIT SIGN SHORTING OUT ON THE BATTERY PACK. REPLACED SIGN IAW AMM 33-51-00. AIRCRAFT WAS GROUNDED.SDR AALA201803059031Lens · missingEXIT LIGHT ON GALLEY WALL ADJACENT TO THE LEFT AFT ENTRY DOOR HAS A MISSING LENS. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01. OK FOR SERVICE.SDR AALA201803069003Lens · missingL4 DOOR EXIT LENS LENS MISSING. REPLACED THE EMERGENCY EXIT LENS IAW AMM 33-51-01.SDR AALA20180305001Battery Pack · shortedAFT EMERGENCY LIGHTS AT LEFT DOOR INOPERATIVE, FOUND CENTER AISLE EXIT SIGN SHORTING OUT ON THE BATTERY PACK. REPLACED THE BATTERY PACK IAW AMM 33-51-00. AIRCRAFT WAS GROUNDED.SDR AALA201803069005Lens · crackedR1 DOOR SLIDE COVER PLASTIC LENS CRACKED. REPLACED R1 DOOR SLIDE LENS IAW AMM 25-66-01.SDR AALA201803059030Lens · missingEMERGENCY LIGHT LENS MISSING. REPLACED THE L4 DOOR SIGN ASSY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20180303001Battery Pack · no testEMERGENCY LIGHT CAPACITY TEST, MID CABIN LIGHT DID NOT REMAIN ON FOR 15 MINUTES. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA201803059037Bypass Valve · faultyFLAPS ASSYMETRICAL AT 1 DEGREE, OCCURED AFTER TAKEOFF ON FLAP RETRACTION, FROM 1 DEGREE AND HAD TAKE OFF CONFIGURATION ALERT JUST AFTER ROTATION WITH JUST TWO ALERTS. EMERGENCY DECLARED, LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FLAP TRANSMISDR AALA20180302007Transmitter · faultyFLAPS ASSYMETRICAL AT 1 DEGREE, OCCURED AFTER TAKEOFF ON FLAP RETRACTION, FROM 1 DEGREE AND HAD TAKE OFF CONFIGURATION ALERT JUST AFTER ROTATION WITH JUST TWO ALERTS. EMERGENCY DECLARED, LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FLAP TRANSMISDR AALA20180302006Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BETWEEN BS 986, AND 1006, JUST INBORARD OF THE INTERCOSTAL AT RBL 31. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, 51-00-05-1, AND DRAWING 147A5700.SDR AALA20180302004Angle · corrodedCORROSION FOUND ON THE FORWARD SERVICE DOOR CREASE ANGLE LOCATED BETWEEN BS 314 AND 344. INSTALLED A NEW ANGLE IAW SRM 51-40-02, 51-00-05-1, AND DRAWING 141A8310.SDR AALA20180302003Angle · corrodedCORROSION FOUND ON THE FORWARD ENTRY WET AREA LT FLOOR ANGLE BS 342 - 350, LBL 61. INSTALLED AN NEW ANGLE IAW SRM 51-40-02, 51-00-05-1, AND DWG 141A8110.SDR AALA20180302002Mount · corrodedCORROSION FOUND ON THE FORWARD ENTRY FLOORBEAM MOUNT BS 344, LBL 60. INSTALLED A NEW MOUNT IAW 51-00-05-01 & DWG. 141A5220.SDR AALA20180301002Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT RBL 31 AND BETWEEN BS 986 AND 1016. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A5710.SDR AALA201803069025Bulkhead Web · crackedRIGHT MLG WHEEL WELL VAPOR BARRIER CRACKED, RBL 50 - 55, 12 TO 18 INCHES ABOVE LOWER FAIRING. REPAIRED IAW 57-10-10-9.SDR AALA201803069024Bulkhead Web · crackedLEFT WHEEL WELL VAPOR BARRIER CRACKED. REPAIRED IAW 57-10-00-1.SDR AALA201803029029Cover · missingAIRCRAFT WAS NOT GROUNDED. DOOR 4L EXIT LIGHT COVER MISSING. REPLACED MISSING EMERGENCY EXIT LENS AT DOOR 4L PER AMM 33-51-01.SDR AALA201803029028Light · damagedAIRCRAFT WAS NOT GROUNDED. LIGHT ON BRIGHT AT ANKLE HEIGHT BY FORWARD ENTRY DOOR. THE EMERGENCY EXIT LIGHT LOOKS DAMAGED/MELTED. REPLACED THRESHOLD LIGHT ASSEMBLY PER AMM 33-29-00.SDR AALA201803029027Plate · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER PLATE MISSING FROM FIRST CLASS GALLEY WALL (ON THE AISLE). REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY AND TESTED PER AMM 33-51-14.SDR AALA20180301003Intercostal · crackedINTERCOSTAL ON THE AFT PRESSURE BULKHEAD IS CRACKED AT BS 1030 AND RBL 12. REPLACED THE INTERCOSTAL IAW 51-00-05-1 AND DRAWING 65-54862-21.SDR AALA20180301001Angle · corrodedRIGHT ZEE ANGLE AT BS 992, RBL 34 TO RBL 46 CORRODED. INSTALLED A NEW ZEE ANGLE IAW 51-00-05-1 AND DRAWING 147A5710.SDR AALA20180228006Floorbeam · corrodedCORROSION ON THE FLOORBEAM TEE CAP AT BS 986, RBL 30 TO RBL 43. REPAIRED THE FLOORBEAM TEE CAP IAW SRM 53-70-51-2R-4.SDR AALA2018030700005Web · corrodedCORROSION FOUND ON THE WEB AT BS 984, BETWEEN LBL 30 - 31. REPLACED THE WEB IAW 51-00-05-1 AND DRAWING 147A5712.SDR AALA20180228009Floorbeam · corrodedAFT SERVICE DOOR FLOORBEAM TEE CAP CORRODED AT BS 985 BETWEEN RBL 4 AND RBL 43. REPAIRED THE FLOORBEAM IAW EA 277341, 53-00-00-7, AND SRM 53-00-51-2R.SDR AALA201803029026Lens · damagedAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY WAY EMERGENCY FLOOD LIGHT LENS (HOUSING) DAMAGED. REPLACED LIGHT ASSEMBLY FORWARD ENTRY FLOOD LIGHT PER AMM 33-51-01 .SDR AALA201803029025Light · damagedAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EXIT SIGN IDENTIFIER LENS MISSING (LIGHT ASSEMBLY DAMAGED). REPLACED LIGHT ASSEMBLY R1 DOOR PER AMM 33-51-01.SDR AALA201803029024Cover · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER BROKEN AT RIGHT AFT SERVICE DOOR. SECURED EMERGENCY EXIT LIGHT LENS AT AFT RIGHT SERVICE DOOR.SDR AALA201803029023Shade · damagedAIRCRAFT WAS NOT GROUNDED. LEFT AFT OVERWING EMERGENCY EXIT WINDOW SHADE DAMAGED. REPLACED LEFT AFT OVERWING EMERGENCY EXIT WINDOW SHADE PER AMM 25-21-12.SDR AALA201803019028Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN AT RIGHT AFT SERVICE DOOR. SECURED THE LENS.SDR AALA20180228010Cargo Track · corrodedCORROSION FOUND ON CARGO TRACK RBL 13, BS 767 TO 888. INSTALLED A NEW CARGO TRACK IAW 51-00-05-1, AND DRAWING 146A7500.
Back to Boeing 737-823