Boeing 737-724
Service difficulty reports · 3,423
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 = '737724' 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 = '737724' 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 CALA0700077Battery Pack · dischargedTHE AISLE PATH EMERGENCY LIGHTING AT ROWS 15-21 ABC WERE FOUND INOPERATIVE. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 33-51-06-960-805.SDR CALA0700057Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT STA 946-967 (DRAIN SUPPORT), LBL 49. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0700034Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT STA 947.5-967, RBL 30-45. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND 51-40-02.SDR CALA0700045Intercostal · crackedINSPECTION FOUND A 1/2" CRACK IN INTERCOSTAL BETWEEN STA 328 AND 344, LBL 35. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-42-21.SDR CALA0700042Intercostal · crackedINSPECTION FOUND A .5 INCH CRACK IN INTERCOSTAL AT STA 312-328, LBL 35. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-42-21.SDR CALA0700041Intercostal · crackedINSPECTION FOUND A .5 INCH CRACK IN INTERCOSTAL BETWEEN STA 280 AND 294.5, BL 0. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-42-21.SDR CALA0700040Intercostal · crackedINSPECTION FOUND A .5 INCH CRACK IN INTERCOSTAL AT STA 312-328, RBL 30. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-42-21.SDR CALA0700039Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5 BETWEEN LBL 26.5 AND LBL 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5320-01876.SDR CALA0700036Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5 BETWEEN RBL 22.5 AND 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5320-01877.SDR CALA0700023Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER TEE CORRODED AT FASTENER HOLE, STA 986.5, LBL 27. REPAIRED IAW ECRA 5321-01437.SDR CALA0700022Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT FASTENER HOLE, STA 986.5, LBL 4. REPAIRED IAW ECRA 5321-01437.SDR CALA0700020Intercostal · crackedINSPECTION FOUND A 1/2" CRACK IN INTERCOSTAL AT BS 312-328, RBL 31.6. A NEW INTERCOSTAL WAS INSTALLED IAW SRM 51-40-02.SDR CALA0700019Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT STA 949.5, RBL 51. A NEW INTERCOSTAL WAS INSTALLED IAW SRM 51-40-02.SDR CALA0700018Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT STA 947.5, LBL 51. A NEW INTERCOSTAL WAS INSTALLED IAW SRM 51-40-02.SDR CALA0700013Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 43 TO RBL 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01435.SDR CALA0700049Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 25.5. REPAIRED IAW SRM 53-00-51.SDR CALA0600546Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 50 TO RBL 50. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01430.SDR CALA0600540Floorbeam · corrodedINSPECTION FOUND LIGHT SURFACE CORROSION ON FLOORBEAM AT STA 344, LBL 3 TO LBL 15. REPAIRED FLOORBEAM IAW ECRA 5321-01330.SDR CALA0600547Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED UNDER LAV MOUNT AT STA 947.5, RBL 50. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01433.SDR CALA0600521Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT STA 947.5 - 967, RBL 26. THE INTERCOSTAL WAS REPLACED IAW SRM 51-40-02.SDR CALA0600520Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986, LBL 43. REPAIRED IAW ECRA 5321-01427, REV A.SDR CALA0600519Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986, RBL 43. REPAIRED IAW ECRA 5321-01428.SDR CALA0600518Floor Skin · corrodedINSPECTION FOUND AFT CABIN FLOOR WEB CORRODED AROUND GALLEY MOUNT AT FS 986, RBL 30. A REPAIR DOUBLER WAS INSTALLED IAW SRM 51-70-03 AND 51-40-02.SDR CALA0600517Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947.5, RBL 50. REPAIRED IAW ECRA 5321-01426.SDR CALA0600515Floorboard · corrodedTHE AFT CABIN FLOORBOARD WAS FOUND CORRODED AROUND HOLE AT STA 986.5, RBL 29. REPAIR ANGLES WERE INSTALLED IAW SRM 53-00-01.SDR CALA0600514Floorboard · corrodedINSPECTION FOUND FLOORBOARD CORRODED AT STA 986.5, LBL 26. REPAIRED IAW SRM 53-00-51.SDR CALA0600513Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 22. REPAIRED IAW SRM 53-00-51.SDR CALA0600510Floorboard · corrodedINSPECTION FOUND FLOORBOARD CORRODED AT STA 986.5, RBL 4. REPAIRED IAW SRM 53-00-51, FIGURE 203, PAGE 208.SDR CALA0600508Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FASTENER HOLES AT STA 360, LBL 9. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01423.SDR CALA0600506Intercostal · crackedINSPECTION FOUND A 2.16 INCH CRACK IN INTERCOSTAL BETWEEN STA 344 AND 360, BL 0. THE INTERCOSTAL WAS REPAIRED IAW ECRA 5321-01421.SDR CALA0600501Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, BL 0 TO RBL 55. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01422.SDR CALA0600484Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986, LBL 43. REPAIRED IAW ECRA 5321-01488.SDR CALA0600483Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 27-31. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1.SDR CALA0600472Battery Pack · inoperativeTHE EMERGENCY LIGHTS AT ROW 18-19ABC WERE FOUND INOPERATIVE. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 31-51-06-960-805.SDR CALA0600471Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5 FROM LBL 20 TO LBL 43. REPAIRED IAW ECRA 5321-01415.SDR CALA0600467Structure · corrodedINSPECTION FOUND R-2 DOOR CHORD CORRODED. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0600464Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT SCREW HOLE, STA 986.5, RBL 2. REPAIRED IAW SRM 53-00-51.SDR CALA0600463Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT SCREW HOLE, STA 986.5, RBL 25. REPAIRED IAW SRM 53-00-51.SDR CALA0600462Intercostal · crackedINSPECTION FOUND A .25 INCH CRACK IN INTERCOSTAL AT STA 328-344, LBL 47. THE INTERCOSTAL WAS REPLACED IAW SRM 51-40-02.SDR CALA0600461Intercostal · crackedINSPECTION FOUND A 0.025 INCH CRACK IN INTERCOSTAL AT STA 312-328, LBL 47. THE INTERCOSTAL WAS REPLACED IAW SRM 51-40-02.SDR CALA0600456Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT SCREW HOLE, STA 986.5, RBL 5. REPAIRED IAW SRM 53-00-51.SDR CALA0600445Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT HOLE FOR NUT CLIP AT STA 986.5, RBL 29. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01410.SDR CALA0600396Floorbeam · corrodedCORRODED FLOORBEAM AT STA 967, BL 5. REPAIRED IAW SRM 53-00-51.SDR CALA0600398Intercostal · crackedCRACKED INTERCOSTAL BETWEEN STA 312 AND 328, RBL 31. REPLACED INTERCOSTAL IAW SRM 51-40-02.SDR CALA0600397Intercostal · crackedCRACKED INTERCOSTAL BETWEEN STA 277 & 294.5, BL 0. REPLACED INTERCOSTAL IAW 51-40-02.SDR CALA0600392Floorbeam · corrodedCORRODED FLOORBEAM AT STA 986.5 RBL 22.5 TO 29. REPAIRED IAW SRM 53-00-51.SDR CALA0600391Floorbeam · corrodedCORRODED FLOORBEAM AT STA 986.5 LBL 26.5 - LBL 34.5. REPAIRED IAW SRM 53-00-51.SDR CALA0600390Floorbeam · corrodedCORRODED FLOORBEAM AT STA 344 AROUND SEVERAL SCREW HOLES FROM LBL 21 - BL 0. REPAIRED IAW ECRA 5321-01330.SDR CALA0600372Floorbeam · corrodedINSPECTION FOUND BEAM AT GALLEY MOUNT CORRODED AT STA 947, RBL 49.25-54. REPAIRED IAW ECRA 5321-01397.SDR CALA0600371Intercostal · corrodedINSPECTION FOUND INTERCOSTAL FORWARD OF R-2 DOOR CORRODED AT STA 947.5-967, RBL 51. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-02.
Back to Boeing 737-724