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 AALA201807028005Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 277 - 294.5, BL 0. REPLACED THE FLOOR SUPPORT IAW DRAWING 141A5400, AND 51-00-05-1.SDR AALA201807028002Floorbeam · corrodedFORWARD CARGO BAY FLOORBEAM ANGLE CORRODED BETWEEN RBL 24 - LBL 24, BS 500I. REPLACED THE FLOORBEAM ANGLE IAW SRM 51-40-02, AND 51-00-05-01.SDR AALA201807028001Transition Panel · corrodedRIGHT TRANSITION PANEL FOUND CORRODED BETWEEN BS 400 - 420, RBL24. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R, REPAIR 5.SDR AALA201807029005Spring · defectiveBOTH LEFT FORWARD EMERGENCY EXIT HATCH COUNTER BALANCE SPRINGS ARE BAD. BOTH SPRINGS REPLACED IAW E8 9796287 AND ITEM 2 OF 9796255.SDR AALA20180628004Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED INTERCOSTAL BETWEEN STA 312 TO STA 328, RBL 31. REPLACED INTERCOSTAL PER DRAWING 141A5400, 51-00-05-1 AND SRM 51-40-02.SDR AALA20180628010Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK ON FLOOR INTERCOSTAL AT STA 316, LBL 46. REPLACED INTERCOSTAL PER 51-00-05.SDR AALA20180628006Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED INTERCOSTAL BETWEEN STA 328 TO STA 344, LBL 45. REPLACED INTERCOSTAL PER SRM 53-10-51, 51-00-05-1, AND DRAWING 141A5400 SHEET 44.SDR AALA201806299014Lug · damagedAIRCRAFT WAS GROUNDED. LEFTHAND FORWARD OVERWING DOOR EXIT, AFT COUNTER BALANCE ACTUATOR DOOR LUG DAMAGED. MAINTENANCE INSTALLED NEW HINGE ASSY ON LEFTHAND FORWARD EMERGENCY EXIT DOOR PER AMM 20-50-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180628012Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED INTERCOSTAL FOUND BETWEEN STA 328-313 RBL 32. REPLACED INTERCOSTAL PER 51-00-05.SDR AALA201806299010Bulkhead Web · crackedLEFT WHEEL WELL BULKHEAD WEB WAS CRACKED, EXTEND 3 INCHES BEYOND A REPAIR THRU VERTICAL BAR. REPAIRED THE BULKHEAD WEB IAW 57-10-10-9.SDR AALA201907028003Transition Panel · corrodedRIGHT AFT TRANSITION PANEL CORRODED, BS 490 - 500A, RBL 24. REPLACED THE TRANSITION PANEL IAW 51-00-05.SDR AALA201807028008Floor Support · crackedCRACK WAS FOUND ON FLOOR SUPPORT AT BS 328 - 344, LBL 46. REPLACED THE FLOOR SUPPORT 141A5410-16.SDR AALA20180629003Battery Pack · failedAIRCRAFT WAS GROUNDED. FAILED BATTERY PACK (M1695), SIC 2908. MAINTENANCE REPLACED BATTERY PACK (M1695) PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180628007Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL WAS CRACKED BETWEEN STA 313-328 46" LBL. REPLACED INTERCOSTAL PER SRM 53-10-51.SDR AALA201806289018Slide · low pressureAIRCRAFT WAS GROUNDED: RIGHT AFT DOOR SLIDE PRESSURE LOW. MAINTENANCE REPLACED RIGHT AFT DOOR SLIDE PER AMM 25-66-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806279011Cap · missingTHE AIRCRAFT WAS GROUNDED. RIGHT FORWARD SERVICE DOOR MISSING PLASTIC END CAP ON GIRT BAR. REPLACED SPRING CLIP SLEEVE AND GIRT BAR PER 25-66-00-06. OK FOR SERVICE.SDR AALA201806276002Floor Support · crackedCABIN FLOOR SUPPORT CRACKED AT BS 540, RBL 2. REPLACED FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA201806276001Floor Support · crackedCABIN FLOOR SUPPORT CRACKED, BS 540, LBL 2. FOUND OUT OF LIMITS. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA201807063001Rib · crackedRIGHT STABILIZIER RIB 92.7 WAS CRACKED AT THE NR 2 STIFFENER. REPAIRED THE RIB DOUBLER IAW SRM 51-40-02.SDR AALA20180703019Rib · crackedAIRCRAFT IN BASE MAINTENANCE. LEFT HAND STABILIZER RIB 92.7 CRACKED AT 1 THRU 4 STIFFENERS. REPLACED RIB PER 51-00-05 AND PRINT 182A5301.SDR AALA20180625008Controller · malfunctionedLOST CABIN PRESSURE AT FL370, IN AUTO MODE, PERFORMED QRH AND SWITCHED TO ALT. STILL NO CONTROL OF CABIN ALTITUDE. SWITCHED TO MANUAL AND FINALLY GOT CONTROL OF CABIN PRESSURE AT 15,000 FT. DIVERTED EMERGENCY DECLARED AND LANDED WITHOUT FURTHER INCIDENT. ASDR AALA20180625006Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. LEFT HAND TRANSITION PANEL CORRODED BEYOND LIMITS BETWEEN STA 460-480. REPAIRED PANEL PER SRM 53-00-53-2R-5.SDR AALA20180625005Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. INTERCOSTAL CRACKED BETWEEN STA 312 TO STA 328, RBL 33 IN CABIN FLOOR. REPLACED INTERCOSTAL PER 51-00-05-1 AND PRINT 141A5400.SDR AALA20180625003Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 312 TO 328, LBL 45. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201806279001Outlet · faultyAIRCRAFT WAS NOT GROUNDED. ELECTRIC OUTLET IN AFT GALLEY PRODUCED SPARKS WHEN FLIGHT ATTENDANT TABLET WAS PLUGGED IN. REPLACED FAULTY 120V OUTLET AT AFT GALLEY. OPERATIONS CHECK GOOD PER MM 25-29-07.SDR AALA201806269018Windshield · delaminatedL1 WINDOW DELAMINATED CENTER BOTTOM. REPLACED THE L1 WINDOW IAW MCM CARD 56-94-03.SDR AALA20180625004Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOOR INTERCOSTAL CRACKED BETWEEN STA 277-294.5. REPLACED INTERCOSTAL PER 51-00-05-01 AND PRINT 141A5400.SDR AALA20180625002Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOOR INTERCOSTAL CRACKED AT STA 328-344 LBL 45. REPLACED INTERCOSTAL PER 51-00-05-01 AND 141A5400.SDR AALA201806269003Pin · bindingAIRCRAFT WAS GROUNDED. L1 DOOR DIFFICULT TO OPEN, UPPER HINGE SLIDE ARM BINDING. REPLACED PIN, KEYWASHER AND SCREW FOR L1 DOOR GUIDE ARM TO FUSELAGE ATTACHMENT POINT PER MM 52-11-21. OPERATIONS CHECK GOOD.SDR AALA201806259004Window Shade · defectiveAIRCRAFT WAS NOT GROUNDED. COACH SEAT WINDOW SHADE/HANDLE SEAT 14F EMERGENCY EXIT WINDOW SHADE WILL NOT RETRACT. **SUPPLEMENT TO BE FILED UPON FINAL CORRECTIVE ACTION. (OPEN)SDR AALA201806259007Flashlight · missingFLASHLIGHT MISSING AT THE R4 DOOR. REPLACED THE FLASHLIGHT IAW AMM 25-64-00. OPERATIONS CHECKED GOOD.SDR AALA201806252004Gcu · damagedSHORTLY AFTER LIFT OFF AT 35,000 FT, THE NR 2 AUTOPILOT DISENGAGED, FOLLOWED BY THE NR 2 SOURCE OFF LIGHT ILLUMINATION, FOLLOWED BY NR 2 DRIVE LIGHT ILLUMINATION. EMERGENCY DECLARED DUE TO AN ACRID ODOR IN COCKPIT AND CABIN. LANDED APPROXITMATELY 20 MINUTESDR AALA201807187004Stringer Clip · crackedSTRINGER CLIP BS 986 WAS S CRACKED. REPLACED THE STRINGER CLIP IAW 53-00-01-6.SDR AALA201807176002Floorbeam · corrodedCORROSION ON THE TOP OF THE FLOORBEAM AT BS 986, RBL 43. REPLACED THE FLOORBEAM IAW SRM 51-20-01.SDR AALA201806269024Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. PER CARD 2908 EMERGENCY LIGHTS SIGN (OVER WING HATCH SIGN) ROW 13, 14 AND 15 RIGHT HAND SIDE FAILED TO STAY ON DURING TEST OF BATTERY PACK CAPACITY CHECK. REPLACED POWER SUPPLY (M1695) PER AMM 33-51-06, OPERATIONS CHECK NORMAL.SDR AALA20180622002Gcu · shortedAIRCRAFT WAS GROUNDED. IN DESCENT TO SEA BELOW 6000 FT A SMOKE SCENT SIMILAR TO CIGARETTE SMOKE BECAME EVIDENT. AS WE CONTINUED DESCENT SMELL WAS STRONGER. AS WE CONTINUED COCKPIT CREW DONNED OXYGEN ON FINAL TO 16C. THE RIGHT "ENG GEN OFF BUS" LIGHT ILLUMINATESDR AALA201806229013Battery Pack · dischargedAIRCRAFT WAS GROUNDED. LEFT OVERWING EXIT LIGHTS COME ON DURING TAKE OFF ROLL. REPLACED BATTERY PACK M1694, OPERATIONS CHECKS NORMAL ON GROUND REF AMM 33-51-06.SDR AALA201806229012Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS OVERHEAD SEATS 25 AND 27 RIGHT HAND SIDE FAILED TO STAY ON DURING TEST OF BATTERY PACK CAPACITY CHECK. REPLACED EMERGENCY POWER SUPPLY BATTERY PACK (M1672) PER AMM 33-51-06. OPERATIONS CHECK NORMAL.SDR AALA201806229011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SEAT MOUNTED ROW 22 THRU ROW 30 RIGHT HAND SIDE FAILED TO STAY ON DURING TEST OF BATTERY PACK CAPACITY CHECK. REPLACED BATTERY PACK (M1671) PER AMM 33-51-06 OPERATIONS CHECK NORMAL.SDR AALA201806229001Skin · crackedAIRCRAFT WAS NOT GROUNDED. LEFT WING NR 3 SLAT TRAILING EDGE FLEX SKIN CRACKED. REPAIRED 3 SLAT TRAILING EDGE FLEX SKIN PER EA 281769.SDR AALA201806219023Window · crackedAIRCRAFT WAS GROUNDED. DFW FLT 2583 EN-ROUTE BNA -DFW. CAPTAINS FLIGHT DECK WINDOW CRACKED ON INNER PANE. REPLACED CAPTAINS L1 WINDOW AS PER WC 56-94-03, OK FOR CONTINUED SERVICE.SDR AALA20180618003Web · corrodedR2 DOOR THRESHOLD WEB CORRODED. REPLACED THE THRESHOLD WEB IAW 51-00-05, AND DRAWING 147A8510.SDR AALA201806189001Overheat Loop · faultyWING BODY OVERHEAT LIGHT ILLUMINATED AT CRUISE POWER ON RT SIDE ONLY. LIGHT REMAINED ON FOR 5 MINUTES AFTER COMPLETION OF THE CHECKLIST TO SHUTING OFF TRIM AIR. WINGBODY OVERHEAT ILLUMINATED AGAIN AFTER 25-30 MINUTES AFTER PREVIOUS EVENT. DECLARED AN EMERGESDR AALA201806187005Angle · corrodedCORROSION AT THE AFT BULKHEAD WALL LOWER SUPPORT ANGLE OF THE LEFT SIDE, JUST INBOARD OF THE ZEE ANGLE. REPLACED THE SUPPORT ANGLE IAW 51-00-05-1, BD 143A9481.SDR AALA201806187004Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO TRANSITION PANEL, BS 727I TO 727J. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-1A.SDR AALA201806187001Angle · corrodedZEE ANGLE AT BS 992 TO 1016, RBL 32 WAS CORRODED. REPLACED THE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018062099030Sliding Window · out of adjustSLIDING WINDOW WILL NOT STAY CLOSED. MAINTENANCE PERFORMED AN ADJUSTMENT AND CHECK OF THE SLIDING WINDOW IAW AMM 56-12-11, AND PERFORMED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDEDSDR AALA2018061989037Pin · damagedAFTER THE AIRCRAFT ARRIVED, THE GATE AGENT WAS NOT ABLE TO OPEN THE FOWARD ENTRY L1 DOOR. AIRCRAFT WAS GROUNDED. MAINTENANCE FOUND A SCREW BROKEN AT THE UPPER RADIUS LINK THROUGH GUIDE ARM TO LOWER RADIUS LINK ON FOWARD ENTRY DOOR ATTACH POINT. MAINTENANCESDR AALA201806199013Smoke Detector · false activationFORWARD LAVATORY SMOKE DETECTOR ALARM WENT OFF. ACCOMPLISHED SMOKE DETECTOR TEST IAW AMM 26-14-00. SYSTEMS CHECKED GOOD.SDR AALA201806199017Smoke Detector · intermittentLEFT AFT LAVATORY SMOKE DETECTOR CAME ON INTERMITTENTLY. REPLACED THE SMOKE DETECTOR. OPS CHECKED GOOD IAW AMM 26-14-01.
Back to Boeing 737-823