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 AALA202306131894Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT LED DOES NOT FLASH. FLIGHT ATTENDANT 4R DOOR. REPLACED 4R EMERGENCY FLASHLIGHT.SDR AALA202306135442Compensator · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE / LEAK ON TAKEOFF BETWEEN 10K CLIMBING. EMERGENCY DECLARED; FLIGHT RETURNED TO DFW LANDING SAFELY. MAINTENANCE REPLACED LEFT WING FUEL COMPENSATOR UNIT PER AMM 28-41-21-401.SDR AALA202306134457Unknown · unknownAIRCRAFT WAS GROUNDED: ELECTRICAL BURNING SMELL AT ROWS 10-11. MAINTENANCE FOUND POWER PORT BOX AT SEAT 10ABC CRUSHED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306125009Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FAILSAFE CHORD LOCATED AT BS 767 ABOVE S27R. REPAIRED FAILSAFE CHORD PER EA 345277.SDR AALA202306309106Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR INTERCOSTAL CRACKED AT FASTENER HOLE UNDER FLOOR PANEL 221CF AT BS 320 AT LBL 48. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202306309384Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR SUPPORT ANGLE FORWARD FASTENER HOLE CRACKED UNDER FLOOR PANEL 221AF AT BS 260 BETWEEN LBL 24.75 AND RBL 24.75. REPLACED SUPPORT ANGLE PER SRM 51-40-02.SDR AALA202306210356Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 957 AND RBL 50. REPLACED INTERCOSTAL PER DWG 147A5650, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306162158Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: L2 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED L2 EXTERIOR EMERGENCY EXIT LIGHT LAMP.SDR AALA202306163054Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED R2 EXTERIOR EMERGENCY EXIT LIGHT LAMP.SDR AALA202306137812Girt Bar · wornAIRCRAFT WAS GROUNDED: L1 ENTRY DOOR SLIDE GIRT BAR WORN THRU IN MIDDLE SECTION AND AFT END TORN. REMOVED AND REPLACED SLIDE PACK.SDR AALA202306197859Floor Panel · damagedAIRCRAFT WAS NOT GROUNDED: FLOOR NEAR ROW 18 AND 19 SOFT, SEEMS WEAK. **SUPPLEMENTAL REPORT FOR AALA202306147859: ACCOMPLISHED REPAIR PROCEDURE PER AARD 53-00-00-3.** (CLOSED).SDR AALA202306165445Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500D TO BS 500E AT S25R. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05-1.SDR AALA202306159932Tire · deformedAIRCRAFT WAS GROUNDED: SEVERE NOSE GEAR VIBRATION ON TAKE-OFF, FORCES FELT INFLIGHT CONTROLS. EMERGENCY DECLARED; FLIGHT RETURNED TO MIA LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202306132611: NOSE STRUT SERVICED PER AMM 12-15-41 (AALA202306132611). LEFT ASDR AALA202306152611Strut · underservicedAIRCRAFT WAS GROUNDED: SEVERE NOSE GEAR VIBRATION ON TAKE-OFF, FORCES FELT INFLIGHT CONTROLS. EMERGENCY DECLARED; FLIGHT RETURNED TO MIA LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202306132611: NOSE STRUT SERVICED PER AMM 12-15-41 (AALA202306132611). LEFT ASDR AALA202306151821Tire · deformedAIRCRAFT WAS GROUNDED: SEVERE NOSE GEAR VIBRATION ON TAKE-OFF, FORCES FELT INFLIGHT CONTROLS. EMERGENCY DECLARED; FLIGHT RETURNED TO MIA LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202306132611: NOSE STRUT SERVICED PER AMM 12-15-41 (AALA202306132611). LEFT ASDR AALA202306147859Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FLOOR NEAR ROW 18 AND 19 SOFT, SEEMS WEAK. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306132611Unknown · unknownAIRCRAFT WAS GROUNDED: SEVERE NOSE GEAR VIBRATION ON TAKE-OFF, FORCES FELT INFLIGHT CONTROLS. EMERGENCY DECLARED, FLIGHT RETURNED TO MIA LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306125964Pin · faultyAIRCRAFT WAS GROUNDED: L1 DOOR WILL NOT OPEN. FORWARD ENTRY DOOR GUIDE ARM PIN REMOVED AND REPLACED.SDR AALA202306129931Slide Raft · dislodgedAIRCRAFT WAS NOT GROUNDED: SLIDE BUSTLE OUT OF COVER DOOR L1. REINSTALLED SLIDE AT DOOR L1.SDR AALA202306210202Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY PANEL LOCATED AT BS 537L AND LBL 22. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA202306219933Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY PANEL LOCATED AT BS 537R AND RBL 22. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA202306160093Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED AT BS 500 PLUS 5 INCHES AT S25L. REPLACED BAFFLE PER DWG 143A7510 AND AARD 51-00-05-1 AND AARD 53-00-01-6.SDR AALA202306126084Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500C TO BS 500D AT S25R. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05-1.SDR AALA202306122148Windshield · crackedAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND FIRST OFFICER'S WINDSHIELD CRACKED. REPLACED WINDSHIELD PER JOB CARD 08L21056004.SDR AALA202306097894Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TO BULKHEAD CENTER PANEL SUPPORT CHANNEL LOCATED AT BS 947.5 AND RBL 20. REPLACED FLOOR STRUCTURE CENTER PANEL SUPPORT CHANNEL PER SRM 51-40-02-OG.SDR AALA202307281825Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: LAVATORY A EXIT LIGHT BROKEN. **SUPPLEMENTAL REPORT FOR AALA202306141825: REPLACED LIGHT ASSEMBLY PER AMM 33-26-03.** (CLOSED)SDR AALA202306303032Floorboard · delaminatedAIRCARFT IN BASE MAINTENANCE: FLOORBOARD 241UF IS DELAMINATED. REPLACED FLOORBOARD.SDR AALA202306303784Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 222AAA IS DELAMINATED. REPLACED FLOORBOARD PER AMM 53-21-00.SDR AALA202306301802Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 242EF IS DELAMINATED. REPLACED FLOORBOARD PER AMM 53-21-00.SDR AALA202306301195Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 247ABA IS DELAMINATED. REPLACED FLOORBOARD.SDR AALA202306309853Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCED: FLOORBOARD 221CF IS DELAMINATED. REPLACED FLOORBOARD PER AMM 53-21-00.SDR AALA202306187353Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BOARD SUPPORT LOCATED AT BS 54 AND RBL 1. REPLACED BREAK ASSEMBLY AARD PER 51-00-05-1.SDR AALA202306186569Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BOARD SUPPORT LOCATED AT BS 540 AND LBL 1. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202306141825Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: LAVATORY A EXIT LIGHT BROKEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306141201Skin · out of toleranceAIRCRAFT IN BASE MAINTENANCE: OUT OF ROUND HOLE IN RIGHT HAND HORIZONTAL STABILIZER UPPER SKIN LOCATED AT STAB STA 92.70, 7TH HOLE FROM FORWARD END. INSTALLED FILLER DOUBLER REPAIR PER SRM 55-10-01-2R-3.SDR AALA202306123036Window · crackedAIRCRAFT WAS GROUNDED: CAPTAINS LEFTWINDOW SHOWS EVIDENCE OF ARCING AT THE END OF THE BUS BAR, CRACKING, AROUND THE ENTIRE WINDOW INNER PANE, AND MOISTURE INGRESS AT THE TOP. REMOVED AND REPLACED CAPTAINS LEFT WINDOW.SDR AALA202306122770Window · crackedAIRCRAFT WAS GROUNDED: FIRST OFFICERS #1 WINDOW SHOWS EVIDENCE OF ARCING AT THE END OF THE BUS BAR, CRACKING, AROUND THE ENTIRE WINDOW INNER PANE, AND MOISTURE INGRESS AT THE TOP. REMOVED AND REPLACED FIRST OFFICERS #1 WINDOW.SDR AALA202306092068Sign · missingAIRCRAFT WAS NOT GROUNDED: REAR FACING EXIT SIGN PANEL MISSING FROM REAR SIDE OF MID AISLE EXIT SIGN. REPLACED REAR FACING EXIT AISLE SIGN PER AMM 33-50-01A. OPS CHECKS GOOD.SDR AALA202306090532Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED CABIN DOOR GUIDE ARM PER AMM 52-11-00, OPERATION CHECKS GOOD.SDR AALA202306093676Fseu · false indicationAIRCRAFT WAS GROUNDED: LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED IN FLIGHT INTERMITTENTLY. # 3 LEADING EDGE DEVICE SHOWED DEPLOYED INTERMITTENTLY. MAINTENANCE TROUBLESHOT LEADING EDGE FLAPS TRANSIT LIGHT PER AMM 27-88-11-700-801. PERFORMED BITE TEST OF FLAPSDR AALA202306094062Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED CABIN DOOR GUIDE ARM.SDR AALA202306091707Fuse · blownAIRCRAFT IN BASE MAINTENANCE: SEAT EMERGENCY LIGHTS FROM SEAT ROW 18-25 ARE INOPERATIVE. TROUBLESHOOTING CARRIED OUT PER AIRCRAFT WIRING MANUAL 33-51-21 SHEET 2. FOUND FUSE BLOWN ON M1694 BATTERY POWER SUPPLY PIN 10. REMOVED AND REPLACED THE FUSE PER AMM 33-51SDR AALA202306096941Girt Bar · draggingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT GIRT BAR AT 1R DIFFICULT TO ARM/DISARM. FOUND Z FOLD TO BE DRAGGING, REMOVED AND REINSTALLED R1 SLIDE PER AMM 25-66-01. STOWED FOLD AND NO LONGER DRAGGING. PERFORMED GIRT BAR ARM/DISARM SEVERAL TIMES. OPERATIOSDR AALA202306126057Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, SECOND STIFFENER FROM FRONT, LOCATED AT STABILIZER STA 92.70. REPLACED RIB PER AARD 51-00-05-1.SDR AALA202306080560Screw · looseAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR RUBS ON FLOOR AND IS DIFFICULT TO OPEN AND CLOSE INFLIGHT. TIGHTEN FLIGHT DECK DOOR HINGE SCREWS. LUBE LOWER SEAL AND OPERATION CHECKED ON GROUND PER AMM 52-51-00. OK FOR SERVICE.SDR AALA202306086598Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 25-40-11.SDR AALA202306086726Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 767 TO BS 787 AT S27R. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202306124383Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202306072272Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR WEB LOCATED AT BS 1016 AND LBL 24.5. REMOVED AND REPLACED SHEAR WEB PER SRM 51-40-02-0G.SDR AALA202306078395Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHTHAND FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT DOES NOT TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.
Back to Boeing 737-823