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 CALA0500228Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 360-380, LBL 22. A REPAIR WAS INSTALLED IAW ECRA 5321-01253.SDR CALA0500218Floorbeam · corrodedAFT GALLEY FLOORBEAM CORRODED AT SEVERAL AREAS UNDER NUT PLATE AREA AT STA 986.5, LBL 54 TO RBL 54. REPAIRED FLOORBEAM IAW ECRA 5321-01246.SDR CALA0500213Battery · dischargedTHE LEFT HAND AFT FLASHLIGHT LED WAS NOT BLINKING. THE FLASHLIGHT BATTERY WAS REMOVED AND REPLACED IAW MM 25-64-00.SDR CALA0500212Engine · malfunctionedLOUD THUMP HEARD AFTER T/O. ALL ENG IND`S NORMAL THROUGH CLIMB-OUT TO 10,000 FT. PASSING 10,000 FT SEVERAL SUCCESSIVE THUMPS WITH NO ABNORMAL ENG IND`S. A/C RETURNED WITH NORMAL LANDING. ENG SHUTDOWN AFTER LANDING. L-1 AND L-2 DOOR SLIDES DEPLOYED & PAX`S EVSDR CALA0500202Seat Track · corrodedINSP FOUND LT I/B SEAT TRACK CORRODED BETWEEN STA 360 AND 380, LBL 24.75. NEW SEAT TRACK INSTALLED IAW SRM 51-40-02.SDR CALA0500194Spar · corrodedINSPECTION FOUND LT WING FRONT SPAR CORRODED AT LT NR 1 BOOST PUMP UPPER BONDING JUMPER STRAP CONTACT, WS 120-121. REPAIRED IAW ECRA 5711-01140.SDR CALA0500193Support Bracket · corrodedINSPECTION FOUND SUPPORT BRACKET FOR BELLY PANEL RT SIDE OF A/C EXHAUST DUCT CORRODED AT STA 649.96. REPAIRED IAW ECRA 5336-01002 AND SRM 53-40-01.SDR CALA0500191Frame · corrodedINSPECTION FOUND R-1 DOOR FLOOR CUTOUT THRESHOLD FRAME CORRODED AT STA 290-300, RBL 48. THE THRESHOLD FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0500190Floorbeam · corrodedINSPECTION FOUND FLOORBEAM TEE CAP CORRODED AT STA 294.5, RBL 0 TO RBL 24. A REPAIR WAS INSTALLED IAW ECRA 5321-01231.SDR CALA0500189Angle · corrodedINSPECTION FOUND L-ANGLE CORRODED AT STA 1002, LBL 32. A NEW ANGLE WAS INSTALLED IAW DRAWING 147A5710, SRM 51-20-01, AND 51-40-02.SDR CALA0500188Support Angle · corrodedINSPECTION FOUND SUPPORT ANGLE CORRODED AT STA 1000, RBL 32. A NEW ANGLE WAS INSTALLED IAW DRAWING 147A5710, SRM 51-20-01, AND 51-40-02.SDR CALA0500187Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AROUND NUT PLATE AT STA 986, LBL 43. REPAIRED IAW ECRA 5321-01230.SDR CALA0500186Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT STA 380, LBL 18. A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-40-02.SDR CALA0500185Intercostal · corrodedINSPECTION FOUND FLOOR INTERCOSTAL CORRODED AT STA 957, RBL 48. THE FLOOR INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0500181Battery Pack · dischargedTHE EMERGENCY AISLE LIGHTS ON BAGGAGE BINS AT SEATS 14, 16, 19, 21, AND 26 RIGHT WERE FOUND INOPERATIVE DURING TESTING. THE BATTERY PACK AT SEAT 19DEF WAS REMOVED AND REPLACED IAW MM 33-51-06-960-805.SDR CALA0500179Skin · corrodedINSPECTION FOUND CORROSION ON SKIN AROUND CENTER DRAIN PLUG BETWEEN STA 727E AND 727F. REPAIRED IAW ECRA 5330-03444 AND PLACED ON DIP TO PERFORM PERMANENT REPAIR PER PART 3 WITHIN 12 MONTHS.SDR CALA0500165Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 43 TO RBL 29. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01222.SDR CALA0500164Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED BETWEEN BS 360 AND 380 CLOSET MOUNT TRACK, LBL 45.5. THE SEAT TRACK WAS REMOVED AND REPLACED IAW ECRA 5321-01226.SDR CALA0500163Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 45 TO RBL 49. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01227.SDR CALA0500157Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 10. A REPAIR WAS INSTALLED IAW ECRA 5321-01223.SDR CALA0500156Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 12. A CAP WAS INSTALLED ON FLOORBEAM IAW ECRA 5321-01224.SDR CALA0500175Intercostal · crackedINSPECTION FOUND A 3/4" CRACK IN INTERCOSTAL AT STA 312-328, LBL 38. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 53-10-51, 51-20-01, AND 51-40-02,SDR CALA0500174Intercostal · crackedINSPECTION FOUND A 1/2 INCH CRACK IN INTERCOSTAL AT STA 270-294, LBL 50. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-10-51, 51-20-01, AND 51-40-02.SDR CALA0500173Intercostal · crackedINSPECTION FOUND A 3/4 INCH CRACK IN INTERCOSTAL AT STA 312-328, RBL 50. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-10-51, 51-20-01, AND 51-40-02.SDR CALA0500153Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, BL 0 TO RBL 12. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01220.SDR CALA0500152Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER SURFACE NEAR R-1 DOOR, STA 320, BL 0 TO RBL 24. REPAIRED FLOORBEAM IAW ECRA 5321-01216.SDR CALA0500151Door Frame · corrodedINSPECTION FOUND R-2 DOOR FRAME CORRODED AT Z-CHANNEL SILL, STA 990, RBL 64 TO LBL 24. THE FRAME WAS REPAIRED IAW ECRA 5311-01225.SDR CALA0500150Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, RBL 8 TO LBL 12. REPAIRED IAW ECRA 5321-01219.SDR CALA0500149Floorbeam · corrodedINSPECTION FOUND THE L-2 DOOR AREA FLOORBEAM NUT CLIP HOLES CORRODED AT STA 986.5, LBL 22.5 TO LBL 43. REPAIRED IAW ECRA 5321-01215.SDR CALA0500172Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT STA 947-967, RBL 50, I/B OF R-2 DOOR FRAME. THE INTERCOSTAL WAS REPAIRED IAW ECRA 5321-01218.SDR CALA0500144Wire · burnedSMOKE APPEARED IN THE AFT GALLEY WHILE EN ROUTE TO PHX. GALLEY CIRCUIT BREAKERS WERE PULLED AND THE SMOKE CEASED AND DISSIPATED. THE FLIGHT WAS CONTINUED TO PHX WHERE IT LANDED WITHOUT FURTHER PROBLEM. MAINTENANCE FOUND THAT THE AFT GALLEY COFFEE WARMER HADSDR CALA0500120Odor · detectedJUST PRIOR TO V, F/O AND CAPT DETECTED A STRONG ELECTRICAL BURNING ODOR AND SAW A GRAY HAZE BETWEEN F/O AND F/O CONSOLE AFTER AIRBORNE. PERFORMED INSP PER 05-51-26-200-801C1 WITH NO DEFECTS NOTED.SDR CALA0500119Battery · inoperativeEMERGENCY EXIT AISLE AND FLOOD LIGHTS ARE INOP IN FIRST CLASS CABIN AND AFT OF ROW 25. REPLACED 2 BATTERIES FOR M1674 AND M1672 AND A FUSE AT M1674 PER AMM 33-51-00-701-801.SDR CALA0500115Module · looseAISLE LIGHTING IN THE FIRST CLASS CABIN LOOSE AT G7 GALLEY. REPLACED LIGHT MODULE.SDR CALA0500106Battery Pack · inoperativeLAST SECTION OF AISLE EMERGENCY LIGHTS INOPERATIVE. REPLACED AND TESTED BATTERY PACK.SDR CALA0500105Battery Pack · inoperativeFWD EMERGENCY LIGHTS TO COCKPIT INOPERATIVE. REPLACED FWD EMERGENCY LIGHT BATTERY PACK.SDR CALA0500081Battery Pack · inoperativeTHE RT SIDE OVERHEAD EMERGENCY LIGHTS AT ROW 14 -20 WERE FOUND INOPERATIVE. THE BATTERY PACK AT ROW 19 WAS REMOVED AND REPLACED IAW MM 33-51-06 AND OPERATION OF THE EMERGENCY LIGHTS WAS RESTORED.SDR CALA0500015Charger · inoperativeTHE OVERWING DOOR EMERGENCY EXIT LIGHTS WERE FOUND INOPERATIVE (LEFT OUTSIDE FORWARD AND RIGHT OUTSIDE FORWARD AND AFT). THE BATTERY CHARGER WAS REMOVED AND REPLACED IAW MM 33-51-00. OPERATION CHECKED GOOD ON AFT RIGHT LIGHT. RELAMPED FORWARD LEFT AND FORWASDR CALA0400753Floor Support · corrodedINSPECTION FOUND CENTER FLOOR SUPPORT BEAM CORRODED AT STA 500I, LBL 30 TO RBL 30. SUPPORT IS LOCATED DIRECTLY BELOW BULKHEAD PANEL AT STA 500I, FORWARD BAGGAGE BIN. THE CENTER FLOOR SUPPORT BEAM WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0400674Fan · odorHEAVY BURNING SMELL IN AFT CABIN AREA. STARTED QRH FOR AIR CONDITIONING/ SMOKE FUMES. SMELL DISSIPATED. REPLACED RT RECIRCULATION FAN PER AMM 21-25-02.SDR CALA0400644Skin · dentedINSPECTION FOUND A DENT IN THE AFT CARGO DOOR SKIN. THE DENT WAS LOCATED IN THE SKIN BAY BETWEEN BEAMS B, C, AND D JUST FORWARD OF BS 809.35. THE DOOR SKIN WAS REPAIRED IAW ECRA 5231-01058.SDR CALA0400641Battery · inoperativeTHE EMERGENCY BATTERY PACK AT LT SEAT ROW 20 & 21 (STA 1250) FAILED TEST. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 33-51-00.SDR CALA0400594Fan · inoperativeTHE FLIGHT ATTENDANTS REPORTED GRAY SMOKE IN THE CABIN IN THE AREA AROUND THE OVERWING EXIT WHILE ENROUTE. THE ENTERTAINMENT SYSTEM WAS SECURED, CABIN LIGHTS WERE TURNED OFF AND THE IFE CIRCUIT BREAKERS WERE PULLED. THE SMOKE DISSIPATED AND THE FLIGHT WAS CONTSDR CALA0400570Battery Pack · inoperativeTHE EMERGENCY LIGHTS IN THE FIRST FIVE ROWS OF COACH SECTION WERE FOUND INOPERATIVE. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 33-51-06-960-80P.SDR CALA0400537Angle · corrodedCORRODED ANGLE FROM LEFT 500 TO 500I AND HAS A HOLE IN LEFT FORWARD CARGO. INSTALLED FARBRICATED ZEE CHANNEL PER SRM 51-40-02 AND 53-00-53.SDR CALA0400566Skin · dentedINSPECTION FOUND A DENT WITH GOUGE IN THE AFT CARGO DOOR AT STA 809.35. THE DENT WAS LOCATED IN THE SKIN BAY BETWEEN BEAMS B AND C JUST FORWARD OF BS 809.35. HFEC INSPECTION OF THE AREA DISCOVERED THAT THE GOUGE CONTAINED A CRACK. THE AFT CARGO DOOR WAS REPSDR CALA0400534Angle · corrodedINSPECTION FOUND LOWER ANGLE AT AFT BULKHEAD OF FORWARD CARGO COMPARTMENT CORRODED. THE ANGLE WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0400533Channel · corrodedINSPECTION FOUND Z-CHANNEL CORRODED AT STA 500A-500I IN RT FORWARD CARGO AREA. A NEW Z-CHANNEL WAS INSTALLED IAW SRM 51-40-02.SDR CALA0400532Channel · corrodedINSPECTION FOUND Z-CHANNEL CORRODED AT STA 747-767, RT SIDE OF AFT CARGO PIT. A NEW Z-CHANNEL WAS INSTALLED IAW SRM 53-00-53.SDR CALA0400518Battery Pack · dischargedINSPECTION FOUND THE LEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. THE BATTERY PACK WAS REMOVED AND REPLACED IAW MM 33-51-06.
Back to Boeing 737-824