Boeing 737-824
Service difficulty reports · 9,839
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 = '737824' 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 = '737824' 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 CALA2017061101793Bulkhead · crackedMAIN CABIN VERTICAL PRESSURE DECK WEB BS 663, RBL 43 TO 45 FOUND CRACKED. REPAIRED IAW SRM 57-10-10, REP 3, ALT 2.SDR CALA2017060901780Light · inoperativeRT FWD OVERWING EXIT DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED RT FWD OVERWING EXIT EXTERIOR EMERGENCY LIGHT PER AMM 33-51-04-960-801. OPS CKS GOOD.SDR CALA2017060901778Slide · detachedSLIDE AT DOOR 1R DETACHED AND DROPPED DOWN. REPACKED 1R DOOR SLIDE REF AMM25-66-01-400-801.SDR CALA2017060901781Sign · unsecureOVERHEAD EMERGENCY EXIT SIGN FELL OFF ROW 25 ISLE SECURED. OPS CK OK.SDR CALA2017060901777Lens · missingEMERGENCY EXIT LIGHT COVER NEAR LEFT AFT LAV MISSING. REPLACED COVER.SDR CALA2017060901776Light · inoperativeEEL LIGHT INOP AT SEAT 2B. REPLACED FWD LIGHT ASSEMBLY ON SEAT 2B.SDR CALA2017060901743Filter · dirtyFLT ATT REPORTED UNUSUAL ODOR IN CABIN BETWEEN ROWS 8 AND 12. COMPLETED FORM REQUIRED FOR ODOR IN CABIN WRITE UP. INSPECTED CABIN THOROUGHLY WITH NO NOTICEABLE SMELLS. PER MM05-51-26-800-80 AND REPLACED BOTH RECIRCULATION FILTERS. PER MM 21-25-01-000-80 RAN PASDR CALA2017060901737Fuel Sys · leakingREFUELING FUEL TANK AUTO-SHUTOFF IS INOPERATIVE ON TAKEOFF, FUEL LEAKED OUT OF LEFT SURGE TANK. FUEL STREAMED UNTIL TWO THOUSAND FEET, THEN STOPPED. ACCOMPLISHED FIM 28-21-00-810-801, FUEL TANK AUTO SHUT-OFF TESTED NORMAL, CLOSED REFUEL VALVE AT 8800 LBS. WITSDR CALA2017060901736Cover · brokenFOUND OVERHEAD EMERGENCY EXIT LIGHT COVER ON THE FLOOR LOCATED BETWEEN COACH AND FIRST CLASS FOUND EMERGENCY EXIT ASSY TABS BROKEN. REPLACE ASSY REF 33-51-00.SDR CALA2017060501718Switch · intermittentDURING AIRCRAFT POWER FAILURE, EMERGENCY LIGHTS ON ROWS 21, 22, 23 DID NOT OPERATE. VERIFIED WITH THE FLIGHT CREW, CYCLED THE LIGHT SWITCH AND EMERGENCY LIGHTS WORKED OK.SDR CALA2017060501717Bottle · low pressureRIGHT OVERHEAD BIN, 12 MAN LIFE RAFT HAS 1 BOTTLE PRESSURE READING BELOW ALLOWABLE LIMITS. READS 3000 PSI AT 70 DEG. SHOULD BE 4500 PSI MIN TO 4650 MAX. REMOVED AND REPLACED THE RAFT.SDR CALA2017060501716Battery Pack · faultyMULTIPLE EMERGENCY LIGHTS AT THE LT MID CABIN ONLY STAY ON FOR UNDER A MINUTE. REMOVED AND REPLACED THE BATTERY PACK M1670 IAW AMM 33-51-06, OPS CHECKED GOODSDR CALA2017060501714Power Supply · no testEMERGENCY LIGHTNS BETWEEN ROWS 22 AND 31 LEFT SIDE FAILED TO TEST. NOT ILLUMINATING WHEN P-5 SWITCH OR AFT FLIGHT ATTEN DANT TEST SWITCH IS ENERGIZED. REPLACED POWER SUPPLY LOCATED AT BS 727C+13, LEFT SIDE IAW MM 33-51-06-960-805, OPS NORMAL.SDR CALA2017060501713Sign · detachedPLASTIC EXIT SIGN OVER THE CABIN AISLE FOUND DETACHED. THE SIGN WAS REPLACED.SDR CALA2017060501712Lamp · inoperativeTWO EMERGENCY OVERHEAD SIGNS FOUND INOPERATIVE AT THE R1 DOOR AND FIRST CLASS AREA. REPLACED THE LAMPS, RESET SYSTEM, OPS CHECKED NORMAL.SDR CALA2017060501711Battery Pack · inoperativeLEFT OVERWING EMERGENCY EXIT SIGN LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017060501710Cover · missingMID CABIN EMERGENCY SIGN COVER MISSING. INSTALLED A NEW COVER.SDR CALA2017060501709Hook · damagedGIRT BAR AT THE R2 DOOR WILL NOT REMAIN STOWED IN UNARMED POSITION. HOOKS ARE DAMAGED. ADJUSTED GIRT BAR HOOKS ,OK FOR SERVICE IAW MM 25-66-01-200-802.SDR CALA2017060501715Girt Bar · looseL1 DOOR SLIDE GIRT BAR LOOSE. ADJUSTED GIRT BAR END SUPPORT, OPS CHECKED GOOD.SDR CALA2017060501678Hmu · faultyADVANCED POWER FOR INITIAL TAXI AND NR 2 ENGINE DID NOT ACCELERATE. THEN FLAMED OUT. NO MESSAGE ALERT. PERFOMED TROUBLESHOOTING IAW FIM 73-06-00-810-807-F00. NO FAULTS FOUND. REMOVED AND REPLACED HMU IAW AMM 73-21-400-801. REMOVED AND REPLACED ENGINE DRIVEN FUSDR CALA2017060501677Hmu · faultedOUT OF FL200 NR 2 ENGINE LOST 20 PERCENT THRUST FROM 60-40 PERCENT. IT RECOVERED IMMEDIATELY REMOVED AND REPLACED HMU. REF: FIM 73-06-00-810-812-FOO AND TASK 73-21-10-400-801-FOO.SDR CALA2017060501682Altimeter · stickingSTANDBY ALTIMETER PROBLEM ALTITUDE READOUT STICKS DURING CLIMB OR DESCENT THEN JUMPS AS MUCH AS 400 FEET. REPLACED INDICATOR IAW AMM 34-13-01-400-801 UTILIZING QUICK DISC ONNECT FEATURE. OPS OKSDR CALA2017060201652Pad · wornAT PANEL 192DR LATCH PAD AREA WORN THRU AT BS 547, RBL 40.875. REPAIRED IAW EC/RA 5713-01033.SDR CALA2017052901637Battery · dischargedFLASHLIGHT BATTERY LOW IN AFT GALLEY RIGHT. REPLACED THE BATTERY AND SEAL.SDR CALA2017052801630Sign · detachedEMERGENCY EXIT SIGN DETACHED. INSTALLED AND SECURED THE SIGN. OK FOR SERVICE.SDR CALA2017052601592Bulb · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM 33-51-03. LIGHT OP CHECKED OK.SDR CALA2017052601593Light · inoperativeWHITE EMERGENCY EXIT SEAT LIGHT AT 15C INOPERATIVE. REPLACED THE SEAT LIGHT, OPS CHECKED GOOD.SDR CALA2017052201549Battery Pack · dischargedL2 DOOR AND AFT GALLEY EMER LIGHTS INOP. REMOVED AND REPLACED AFT BATTERY PACK AS REQD. OPS CK GOOD.SDR CALA2017052201528Skin · corroded2 EA FUSELAGE DRAIN ASSY SHEETMETAL CORROSION ON SURROUNDING SKIN STA 727E. EC/RA COMPLIED WITH STEPS 1 THRU 14 OF ECRA 5330-06091, REF L/P 460049 1 FOR DIP REQUIREMENTS VERIFIED MATCH UP OF ECRA 5330-06091 TO ESC170514-0201-2C.SDR CALA2017052201527Skin · corroded3 EA FUSELAGE DRAINS SURROUNDING SKIN CORROSION STA 727I. REPAIRED IN ACCORDANCE WITH EC/RA 5330-06090 FUSELAGE SKIN STA 727J BL 0. ALL STEPS OF ECRA 1 THRU 14 C/W. INITIATE DIP TO FOLLOW. VERIFIED EC/RA 5330-06090 ALL STEPS OF THIS ECRA 1 THRU 14 C/W.SDR CALA2017051901506Battery Pack · dischargedFWD RIGHT ROW 20 DEF EMERGENCY LIGHT BATTERYS DEAD. REMOVED & REPLACED EMERGENCY LIGHT BATT PACKS FWD ROW 20DEF REF AMM 33-51-06-960-805, OPS CHECK GOOD.SDR CALA2017051901505Battery Pack · dischargedEMERG LIGHTS ON EXT OF RT SIDE OF A/C INOP. REPLACED M1695 AND M1671 POWER SUPPLY AND BATTERY PACK. OPS CHKS GOOD REF AMM 33-51-06.SDR CALA2017051901504Lens · unsecureEMERGENCY EXIT SIGN OVER AISLE AT OVERWING EMERGENCY ROW FELL OFF. REINSTALLED LENS COVER ON EMERGENCY EXIT COVER AT OVERWING EXITS.SDR CALA2017051901503Light · inoperativeROW 15 RED EMERG PATH LIGHTING INOP. REMOVED AND REPLACED ROW 15 RED EPL LIGHT ASSY. OPS CHECK GOOD.SDR CALA2017051501456Slide · unserviceable2L MED ESCAPE SLIDE PRESSURE IS BELOW LIMITS. REPLACED ESCAPE SLIDE REF AMM25-66-01-400-801.SDR CALA2017051501455Sign · malfunctionedEMERGENCY EXIT SIGN DOES NOT TURN OFF. EXIT SIGN AT EXIT ROWS IS FLICKERING. IT HAS BEEN TURNED OFF. PERFORMED OPS CHECK EMERGENCY LIGHT.NO FAULT NOTED REF AMM 33-51 -00.SDR CALA2017051501454Lens · missingCABIN AISLE OVERHEAD EMERGENCY EXIT SIGN MISSING AFT LENS. REPLACED LENS.SDR CALA2017051501425Fitting · corrodedHEAVY CORROSION AT LEFT MLG TRUNNION SUPPORT ASSY, FWD LOWER INBD ATTACH POINT BUSHING. REMOVED AND REPLACED THE LT MLG TRUNNION SUPPORT FITTING IAW DWG 115A5002 AND SRM 51-40-02.SDR CALA2017051501424Fitting · corrodedRT MLG H FITTING LOWER INBD HOLE CORRODED. REMOVED AND REPLACED RT MLG TRUNNION SUPPORT FITTING IAW DWG 115A5002 AND SRM 51-40-02.SDR CALA2017051201408Light · inoperativeDURING 2 SVC FOUND RT AFT OVERWING EMERGENCY LIGHT INOP. RELAMPED RT AFT OVERWING EMERGENCY LIGHT. OPS CHECK GOOD.SDR CALA2017051201407Light · inoperativeDURING 2 SVC FOUND RT AFT DOOR EMERGENCY LIGHT INOP. RELAMPED RT AFT DOOR EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR CALA2017051201405Cover · loose2 OVERWING EXIT SIGN COVERS HAVE COME OFF. INSTALLED 2 EA EMERGENCY EXIT SIGN COVERS ON MID CEILING AS REQUIRED.SDR CALA2017051201404Lens · brokenRED EMERGENCY EXIT LIGHT LENS BROKEN ROW 20ABC. R&R LENS. OK TO CONTINUE IN SERVICE.SDR CALA2017051201403Lens · brokenWHITE EMERGENCY EXIT LIGHT LENS BROKEN ROW 15ABC. R&R LENS. OK TO CONTINUE IN SERVICE.SDR CALA2017051201402Cover · missingEMERG EXIT SIGN MISSING LITTLE ONE DOWN LOW. INSTALLED MISSING COVER AND OPS CKS OK.SDR CALA2017051201401Battery Pack · dischargedROW 22-30 EMERGENCY LIGHTS OUT. R&R BATTERY PACK REF AMM 33-51-06. OPS CHECK GOOD VERIFIED BATTERY PACK INSTALLATION REF 33-51-06.SDR CALA2017051201399Lens · looseFIRST CLASS EMERGENCY EXIT LENS LITE LOOSE. REINSTALLED AND SECURED LENS, OPS CHECK NORMAL.SDR CALA2017051201398Light · inoperativeEXTERIOR EMERGENCY SLIDE LIGHT BEHIND LEFT WING INOP. REPLACED LAMP IAW AMM 33-51-04. OPS CHK NORMAL. OK TO CONTINUE.SDR CALA2017051201406Lens · detachedROW 25 EMERGENCY EXIT LENS CAP NEEDS REATTACHED. REINSTALLED LIGHT COVER.SDR CALA2017051201366Handle · jammedPER FLT CREW VERBAL, CAPT SIDE WINDOW LOCKING HANDLE IS JAMMED UNABLE TO SECURE CLOSED. APPEARED SECURED CLOSED WHEN DEPARTING SJC BUT HAD A MASSIVE AIR LEAK. DECLARED EMERGENCY. CAPT REPORTS AIR LEAK AT LT SLIDING WINDOW UNABLE TO DUPLICATE. PRESSURIZED CABIN
Back to Boeing 737-824