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 CALA0700632Intercostal · crackedINSPECTION FOUND A 1 INCH CRACK IN INTERCOSTAL AT STA 294.5, BL 0. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700663Skin · corrodedCORROSION WAS FOUND IN FUSELAGE SKIN AT LT AFT FUSELAGE AT VACUUM WASTE EXHAUST, STA 907-927, S21L TO S22L DURING A WALKAROUND. THE SKIN WAS REPAIRED IAW ECRA 5330-03715 AND A DIP WAS INITIATED TO PERFORM A PERMANENT REPAIR WITHIN 12 MONTHS.SDR CALA0700462Battery · dischargedTHE EMERGENCY LIGHT BATTERY PACKS ABOVE AFT GALLEY BOTH LEFT AND RIGHT WOULD NOT HOLD CHARGE. BOTH BATTERY PACKS WERE REMOVED AND REPLACED.SDR CALA0700386Structure · corrodedINSPECTION FOUND A CHORD CORRODED AT R-2 DOOR STA 807-1016, RBL 56. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700378Intercostal · crackedINSPECTION FOUND A 1.5" CRACK IN INTERCOSTAL AT STA 277-294.5, BL 0. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR MZZA0700009Stringer · corrodedINSPECTION FOUND STRINGER 27L AT BAY 14 IN FORWARD CARGO COMPARTMENT WITH ROWS OF RIVETS CORRODED, STA 500-500A.SDR MZZA0700008Stringer Clip · corrodedINSPECTION FOUND STRINGER CLIP CORRODED BETWEEN BAY 13 AND 14 AT STA 500-500A, S28R. THE CLIP WAS REPLACED IAW SRM 51-40-02.SDR CALA0700336Vapor Barrier · crackedINSPECTION FOUND MLG WHEEL WELL LEFT FORWARD BULKHEAD HAD A CRACK ON VAPOR BARRIER, REAR SPAR CENTER SECTION, LT SIDE THAT HAD MIGRATED BEYOND A STOP DRILL. THE CRACK WAS NOW 18 INCHES LONG. A TEMPORARY REPAIR HAD BEEN PERFORMED PREVIOUSLY A FEW MONTHS PRIORSDR CALA0700319Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 360, LBL 8. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01485.SDR CALA0700389Intercostal · crackedINSPECTION FOUND A 1 INCH CRACK IN INTERCOSTAL AT STA 540, BL 0. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-2.SDR CALA0700316Intercostal · crackedINSPECTION FOUND A 2 INCH CRACK IN INTERCOSTAL AT STA 344-360, BL 0. THE INTERCOSTAL WAS REPAIRED IAW ECRA 5321-01484.SDR CALA0700289Vapor Barrier · crackedINSPECTION FOUND FIVE CRACKS IN THE RT WHEEL WELL FORWARD BULKHEAD (WING CENTER SECTION AFT SPAR VAPOR BARRIER). THREE OF THE CRACKS WERE LOCATED AT THE B-SYSTEM RETURN FILTER, ONE AT RBL 45, AND ONE AT RBL 25. THE VAPOR BARRIER WAS REMOVED AND REPLACED IAW SDR CALA0700261Battery Pack · inoperativeTHE FIRST CLASS EMERGENCY EXIT LIGHTS WERE FOUND INOPERATIVE. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 33-51-06.SDR CALA0700251Bulkhead · crackedINSPECTION FOUND THE RIGHT WHEEL WELL FORWARD BULKHEAD (WING CENTER SECTION AFT SPAR VAPOR BARRIER) CRACKED. THERE WERE TWO CRACKS MEASURING 12.75 INCHES AND 8 INCHES. THE VAPOR BARRIER WAS REMOVED AND REPLACED IAW ECRA 5710-02116.SDR CALA0700250Vapor Barrier · crackedINSPECTION FOUND THE LEFT WHEEL WELL FORWARD BULKHEAD (WING CENTER SECTION AFT SPAR VAPOR BARRIER) CRACKED. THREE CRACKS WERE FOUND MEASURING 7 INCHES, 19.5 INCHES, AND 4 INCHES. THE VAPOR BARRIER WAS REMOVED AND REPLACED IAW ECRA 5710-02116.SDR CALA0700249Frame · corrodedINSPECTION FOUND AFT FRAME CHORD AT R-2 DOOR LOWER SILL, STA 992, S17R, LBL 0 TO RBL 64 CORRODED. THE FRAME WAS REPAIRED IAW ECRA 5311-01315.SDR CALA0700222Door Frame · corrodedINSPECTION FOUND THE R-2 LOWER DOOR SILL AFT FRAME CHORD CORRODED AT STA 992.8, S17R, RBL 45. REPAIRED IAW ECRA 5311-01315.SDR CALA0700211Battery Pack · dischargedEMERGENCY PATH LIGHTS INOP BETWEEN ROWS 15ABC AND 24ABC. REPAIRED IAW AMM 33-51-06.SDR MZZA0700007Skin · corrodedINSPECTION FOUND UPPER RUDDER T/E CORRODED AT LOWER STATIC WICK ALONG BASE PLATE LOWER FORWARD EDGE, RUD STA 278-283. THE RUDDER WAS REPAIRED IAW ECRA 5540-01234 AND ECRA 5540-01232. A RUDDER BALANCE PROCEDURE WAS PERFORMED IAW SRM 51-60-07.SDR CALA0700175Structure · corrodedNUT PLATE HOLE CORRODED AT STA 986, RBL 23. REPAIRED IAW SRM 53-00-51.SDR MZZA0700006Actuator · inoperativeTHE NOSE GEAR FAILED TO RETRACT AFTER TAKEOFF FROM SAIPAN. THE GREEN DOWN AND LOCKED LIGHT REMAINED ILLUMINATED. THE NLG LOCK ACTUATOR WAS REMOVED AND REPLACED IAW MM 32-33-01 AND OPERATIONAL CHECKS WERE GOOD.SDR CALA0700154Structure · corrodedINSPECTION FOUND R-2 DOOR CHORD CORRODED AT STA 958-994, RBL 43. THE CHORD WAS REMOVED AND A NEW CHORD WAS INSTALLED IAW SRM 51-40-02.SDR CALA0700143Structure · corrodedINSPECTION FOUND R-1 DOOR CHORD CORRODED AT STA 277-344, RBL 61 TO RBL 64. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700142Structure · corrodedINSPECTION FOUND R-2 DOOR CHORD CORRODED FROM STA 947.5-1000, RBL 52. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700141Structure · corrodedINSPECTION FOUND L-2 DOOR CHORD CORRODED AT STA 947-986.5, LBL 52. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700133Structure · corrodedINSPECTION FOUND STRUCTURE CORRODED AT STA 986.6, LBL 42. A REPAIR STRAP WAS INSTALLED ALONG WITH REQUIRED NUT PLATES IAW ECRA 5310-01459.SDR CALA0700130Battery Pack · inoperativeTHE SEAT MOUNTED EMERGENCY PATH LIGHTS FROM ROW 15-24 WERE FOUND INOPERATIVE. THE BATTERY PACK AT ROW 20ABC WAS REPLACED IAW MM 33-51-06-960-805.SDR MZZA0700005Bearing · frozenTHE L-1 DOOR WAS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE FOUND THE CAM FOLLOWER BEARING FROZEN. THE BEARING WAS REPLACED. OPERATIONAL CHECKS WERE GOOD IAW MM 52-11-00.SDR MZZA0700004Skin · damagedINSPECTION FOUND SEVERAL AREAS OF LIGHTNING STRIKE DAMAGE ON FUSELAGE SKIN CROWN AREA AT STA 500D-500G FORWARD OF UPPER ANTI-COLLISION LIGHT. THE SKIN WAS REPAIRED IAW SRM 53-00-01, REPAIR B.SDR CALA0700124Door Frame · corrodedINSPECTION FOUND CORROSION AROUND FASTENER HOLES ON L-2 CHORD AT STA 947-987, LBL 53 TO LBL 54. THE CHORD WAS REPLACED IAW SRM 51-40-02.SDR CALA0700122Door Frame · corrodedINSPECTION FOUND CORROSION AROUND FASTENER HOLES ON R-2 FRAME AT BS 947-995, RBL 43 TO RBL 63. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700120Structure · corrodedINSPECTION FOUND CHORD CORRODED AT STA 967-1006, LBL 53. A NEW CHORD WAS INSTALLED IAW SRM 51-40-02.SDR CALA0700112Uplock Actuator · malfunctionedRT MAIN GEAR CAME DOWN IN FLIGHT. REPLACED RT MAIN GEAR UPLOCK ACTUATOR.SDR CALA0700109Intercostal · corrodedINTERCOSTAL FWD OF STA 277 AND AFT COCKPIT CORRODED. REPLACED INTERCOSTAL IAW SRM 51-40-02.SDR CALA0700105Light · inoperativeEMERGENCY PATH LIGHTING INOP AT SEAT 8C. REPAIRED IAW AMM 33-51-01.SDR CALA0700121Channel · corrodedINSPECTION FOUND Z-CHANNEL CORRODED ON FORWARD EDGE AT STA 992-1016, LBL 29. THE Z-CHANNEL WAS REPLACED IAW SRM 51-40-02.SDR CALA0700119Floorbeam · corrodedINSPECTION FOUND LEFT SIDE UPPER SURFACE OF FLOORBEAM CORRODED AT STA 986.5, RBL 6 TO LBL 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01451.SDR CALA0700118Angle · corrodedINSPECTION FOUND LIGHT SURFACE CORROSION AT LEFT SIDE Z-ANGLE AFT OF STA 986.5, LBL 32. THE Z-ANGLE WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700099Channel · corrodedCENTER FLOOR PANEL SUPPORT MEMBER CORRODED. REPAIRED IAW ECRA 5310-04614.SDR CALA0700095Structure · corrodedL1 CHORD CORRODED. REPAIRED IAW SRM 51-40-02.SDR CALA0700098Beam · corrodedCORRODED BEAM AT STA 986.5. REPAIRED IAW ECRA 5321-01450.SDR CALA0700097Structure · corrodedR2 CHORD CORRODED. REPAIRED IAW SRM 51-40-02.SDR MZZA0700003Battery · inoperativeTHE EMERGENCY LIGHT BATTERY PACK AT ROW 19ABC FAILED CAPACITY CHECK. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 33-51-06.SDR CALA0700072Trim Motor · failedTHE ELECTRIC STAB TRIM FAILED WHILE ON APPROACH TO CLE. THE QRH WAS CONSULTED, AN EMERGENCY WAS DECLARED, AND MANUAL ADJUSTMENT OF TRIM WAS USED. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE ELECTRIC STAB TRIM MOTOR IAW MM 27-4SDR CALA0700068Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT STA 986, BL 0 TO LBL 31. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01445.SDR CALA0700064Intercostal · crackedINSPECTION FOUND A 2 INCH CRACK IN INTERCOSTAL AT STA 344-360, LBL 0. THE INTERCOSTAL WAS REPAIRED IAW ECRA 5321-01446.SDR MZZA0700002Battery · inoperativeINSPECTION FOUND FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERATIVE. THE FLASHLIGHT BATTERY WAS REPLACED IAW MM 25-64-00.SDR CALA0700063Idg · leakingLIGHT SMOKE ENTERED THE CABIN AND COCKPIT AFTER TAKEOFF FROM CLE. THE AIRCRAFT WAS RETURNED TO CLE. THE SMOKE DISSIPATED BY THE TIME THE AIRCRAFT RETURNED TO CLE. MAINTENANCE FOUND THE NR 2 IDG DRIVE SHAFT LEAKING AND IDG EMPTY. THE NR 2 IDG AND IDG OIL COSDR CALA0700055Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 50 TO RBL 50. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01443.SDR MZZA0700001Windshield · crackedTHE L-5 COCKPIT WINDOW SHATTERED IN FLIGHT. NO OTHER PROBLEMS WERE REPORTED TO BE ASSOCIATED WITH THE OCCURRENCE. MAINTENANCE FOUND THAT THE WINDOW HAD ALSO SEPARATED AND LIFTED AWAY FROM THE FUSELAGE FRAME. THE L-5 WINDOW WAS REMOVED AND REPLACED IAW MM 56-11
Back to Boeing 737-824