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 AALA20180418009Structure · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER. LEADING EDGE CHORD CRACKED AT STATION 114.55, REPLACED CHORD PER AARD 51-00-05-01.SDR AALA20180418008Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AT R2 DOOR THRESHOLD WEB, ON BOTTOM SIDE, AT STATION 947 TO STATION 986. REPLACED R2 DOOR THRESHOLD WEB PER DRAWING 147A8510 AND AARD 51-00-05, AND EA 279053.SDR AALA201804239013Lens · missingR1 DOOR EMERGENCY LIGHT COVER MISSING. REPLACED THE EXIT SIGN ASSEMBLY IAW AMM 35-31-01.SDR AALA201804199035Lens · detachedFORWARD SERVICE DOOR EXIT LIGHT LENS DETACHED. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR AALA201804208011Skin · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED RIGHT STABILIZER LOWER SKIN AT HSS175.5. INSTALLED FILLER AND DOUBLER IAW SRM 55-10-01-2R-11.SDR AALA20180418010Angle · corrodedRIGHT CREASE ANGLE IS CORRODED BETWEEN BS 955 TO 986. REPLACED THE CREASE ANGLE IAW DRAWING 147A8501.SDR AALA2018042617007Transition Panel · corrodedCORROSION FOUND ON THE TRANISITION PANEL BETWEEN BS 500A - 500I. REPLACED THE TRANSITION PANEL IAW 51-00-05-1.SDR AALA20180418013Angle · corrodedAFT CARGO AFT BULKHEAD FLOORBEAM ANGLE CORRODED AT BS 947.5 BETWEEN RBL 18 TO LBL 13. INSTALLED A NEW FLOORBEAM ANGLE ASSEMBLY IAW SRM 51-40-02-0G.SDR AALA20180417012Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT, BS 951 - 966, LBL 52. CORROSION FOUND TO BE OUT OF LIMITS. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180417010Bulkhead Web · crackedINSPECTION FOUND A CRACK IN THE PRESSURE BULKHEAD WEB AT BS 663, RBL 40 - 45. REPAIRED THE PRESSURE BULKHEAD WEB IAW SRM 57-10-10-2R-3 ALT 2.SDR AALA20180417009Floorbeam · corrodedCORROSION WAS FOUND AROUND FASTENER HOLE ON THE FLOORBEAM BS 986, JUST INBOARD OF THE RIGHT CREASE ANGLE. REPAIRED IAW EA 279300, AND SRM 53-00-51-2R-1.SDR AALA20180417011Bulkhead Web · crackedBULKHEAD WEB CRACKED, BS 663, RBL 40 - 45.64. REMOVED THE DAMAGE AND REPAIRED IAW SRM 57-10-10-2R-3.SDR AALA20180417005Floorbeam · corrodedFLOORBEAM BS 986.5 CORRODED AT LBL 4, 26, 33, 43 AND RBL 20, 32, 34, 42. A FLOORBEAM TEE REPAIR WAS INSTALLED IAW SRM 53-70-51-2R-4.SDR AALA2018042009018Lens · missingTHE L4 DOOR EMERGENCY LIGHT LENS WAS FOUND MISSING. REPLACED THE LENS.SDR AALA2018042019025Smoke Detector · false indicationSMOKE ANNUNCIATOR ILLUMINATED FOR RIGHT HAND AFT LAVATORY. LATER FORWARD LAVATORY SMOKE DETECTOR SOUNDED. REPLACED RIGHT HAND AFT LAVATORY AND FORWARD LAVATORY SMOKE DETECTORS PER AMM 26-14-01.SDR AALA201804199015Lens · missingFWD DOOR EMERGENCY LIGHT MISSING THE LENS. REPLACED THE LENS IAW AMM 33-50-00.SDR AALA20180416013Intercostal · corrodedDURING REPLACEMENT OF THE SHIELD ASSMEBLY, FORWARD OF THE AFT CARGO DOOR, FOUND ATTACHMENT INTERCOSTAL CORRODED. REPLACED THE INTERCOSTAL.SDR AALA20180416017Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT RBL 12. REPLACED THE INTERCOSTAL IAW 51-00-05 AND DRAWING 148A0922 REVISION A.SDR AALA20180416012Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRIDED AT LBL 5. REPLACED INTERCOSTAL PER AARD 51-00-05 AND BOEING DRAWING 148A0922 REVISION A.SDR AALA20180416010Floorbeam · corrodedAFT CARGO, CORROSION ON THE FLOORBEAM ANGLE, BS 947.5, RBL 10. INSTALLED NEW FLOORBOARD SUPPORT BRACKET ASSEMBLY.SDR AALA201804189025Cover · detachedEMERGENCY EXIT SIGN COVER FELL OFF IN AFT GALLEY NEAR THE LT ENTRY DOOR. REPLACED THE EXIT SIGN ASSEMBLY IAW AMM 33-51-01.SDR AALA20180416015Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT LBL 21. REPLACED THE INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA201804180014Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT LBL 12. REPLACED THE INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA2018041806018Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT RBL 21. REPLACED INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA201804180016Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT RBL 5. REPLACED INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA20180416011Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL AT STRINGER 34R IS CORRODED. REPLACED INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA201804183Battery Pack · inoperativeEMERGENCY LIGHT AT FORWARD LT ESCAPE SLIDE FOUND INOPERATIVE. REPLACED THE BATTERY PACK M02816 IAW AMM 33-51-06.SDR AALA2018041800009Web · corrodedCORROSION ON THE L2 DOOR LOWER CUT OUT WEB BETWEEN BS 951 TO 992, LBL 51. REPLACED THE WEB IAW 51-00-05-1, AND DRAWING 147A8501.SDR AALA20180416008Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL CORRODED AT BS 1028, LBL 34. REPLACED THE INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA2018041800007Floor Support · crackedLEFT CENTER FLOOR SUPPORT CRACKED AT BS 540, BL 0. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-2.SDR AALA2018041800006Floor Support · crackedRIGHT CENTER FLOOR SUPPORT CRACKED AT BS 540, BL 0. REPLACED THE FLOOR SUPPORT IAW 51-10-2.SDR AALA20180416005Angle · corrodedLEFT ZEE ANGLE CORRODED AT BS 992, FROM LBL 32 TO LBL 44. INSTALLED A NEW ZEE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018041800003Angle · corrodedLEFT ZEE ANGLE CORRODED BETWEEN BS 992 & 1016, LBL 32. INSTALLED A NEW ZEE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018041800002Web · corrodedLEFT K ANGLE WEB CORRODED BETWEEN BS 986 TO 991, LBL 31. INSTALLED A NEW WEB IAW 51-00-07, AND DRAWING 147A5700.SDR AALA20180416019Rib · crackedRT HORIZONTAL STAB MACHINED VERTICAL STIFFENERS, CRACKED ON RIB AT HSS 92.7. REPLACED THE RIB IAW 51-00-05-1, AND SRM 51-40-02-0G.SDR AALA2018042049014Handle · damagedRIGHT EMERGENCY OVERWING EXIT DOOR LIFT HANDLE ASSEMBLY THAT HOUSES RED LANYARD MISSING HARDWARE. REPLACED FASTENERS IAW AMM 52-22-51, OK FOR SERVICE.SDR AALA201804189024Battery · no testAFT LEFT INBOARD FLASHLIGHT IS TEST FLASHING RED. REPLACED AFT LEFT INBOARD FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR AALA201804189037Housing · faultyEXIT LIGHT LENS IN THE FORWARD GALLEY WAS MISSING. MAINTENANCE REPLACED THE LIGHT HOUSING, INSTALLED THE LENS, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA201804189035Lens · missingEXIT LIGHT LENS IN THE FORWARD GALLEY WAS FOUND MISSING. MAINTENANCE REPLACED LIGHT HOUSING AND INSTALLED THE LENS. PERFORMED A SATISFACTORY OPS CHECK IAW AMM 33-51-01.SDR AALA201804189010Slide · dislodgedR1 DOOR SLIDE FELL OUT OF THE CONTAINER. REPLACED THE DOOR SLIDE IAW 25-94-11.SDR AALA201804208001Angle · corrodedCORROSION FOUND ON RIGHT ZEE ANGLE AT BS 986.5 AND 1016, RBL 40. REPLACED THE ZEE ANGLE IAW 51-00-05-1.SDR AALA20180413004Angle · corrodedCORROSION WAS FOUND ON THE LEFT ZEE ANGLE AT BS 990, LBL 45. REPLACED THE ZEE ANGLE IAW 51-00-05.SDR AALA20180414001Fan · faultyAPPROXIMATELY 10 MINUTES AFTER DEPARTURE, FLIGHT ATTENDANTS NOTED AN ODOR THROUGHOUT THE CABIN WITH NO OBSERVANCE OF SMOKE. ODOR NOTICEABLE IN COCKPIT. RAN SMOKE CHECKLIST, AFTER COMPLETING STEPS TO TURN OFF THE RECIRCULATION FANS AND EQUIPMENT COOLING ALTERSDR AALA20180413005Angle · corrodedCORROSION ON THE ZEE ANGLE BETWEEN BS 986 TO 1016, LBL 45. REPLACED ZEE ANGLE IAW 51-00-05.SDR AALA20180413003Angle · corrodedCORROSION ON THE RIGHT ZEE ANGLE AT BS 992, LBL 45. REPLACED THE ZEE ANGLE IAW 51-00-05.SDR AALA20180413002Angle · corrodedLEFT CREASE BEAM ANGLE CORRODED BETWEEN BS 947 TO 992. REPLACED THE CREASE BEAM ANGLE IAW 51-00-05, AND DRAWING 147A8501.SDR AALA20180413006Bulkhead · corrodedCRACK IN THE VERTICAL PRESSURE BULKHEAD AT BS 663.75, RBL 31.83 - 40. INSTALLED A REPAIR IAW EA 279353 DRAFT 1.SDR AALA201804189033Lens · missingEXIT SIGN AT ROW 15F WAS MISSING THE LENS, ON THE BOTTOM. MAINTENANCE INSTALLED THE EXIT SIGN LENS AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA20180412006Bulkhead Web · crackedCRACKED PRESSURE BULKHEAD WEB IN RIGHT HAND WHEEL WELL AT BS 663 BETWEEN RBL 31.83 TO RBL 40. REPAIRED THE BULKHEAD WEB IAW EA 279173.SDR AALA20180412005Bulkhead Web · crackedBULKHEAD WEB, BS 663, BETWEEN LBL 31.83 TO LBL 40. REPAIRED THE BULKHEAD WEB IAW EA 279171.
Back to Boeing 737-823