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 AALA202304042302Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727 + 15 INCHES TO BS 727I + 8 INCHES, AT LBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5.SDR AALA202303098905Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND SHIELD LOCATED FROM BS 849 TO BS 858 AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1 AND DWG 146A8127.SDR AALA202303060243Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND ELEVATOR SKIN LOCATED ABOVE HINGE #3 AT LEFT HAND ELEVATOR STATION 66.54. REPAIRED SKIN PER SRM 55-20-01-2R.SDR AALA202302213967Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE PANEL SUPPORT LOCATED AT BS 887 AND FROM LBL 9.5 TO RBL 21. REPLACED PANEL SUPPORT PER SRM 51-40-02-0G.SDR AALA202302213151Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN MAIN CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540 FROM BL 0 TO RBL 24.5. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202302217068Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER SURFACE OF FLOOR BEAM LOCATED AT BS 1016 AND LBL 31.5. REPAIRED FLOOR BEAM PER EA 341952.SDR AALA202302202439Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CUTOUT OF FIRST OFFICER #1 WINDOW FRAME LOCATED AT BS 217 AND WL 258. REPAIRED FRAME PER ECO 5616J009-008.SDR AALA202302205834Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SUPPORT ANGLE LOCATED AT BS 540 AND LBL 33. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1 REPAIR 1.SDR AALA202302204431Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SUPPORT INTERCOSTAL LOCATED AT BS 770 AND RBL 5.5. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302204692Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR Z ANGLE LOCATED AT BS 992 AND RBL 32. REPLACED Z ANGLE PER SRM 51-40-02-0G.SDR AALA202302203044Switch · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FA JUMP SEAT 2L TEST LIGHT FLASHES RED DURING TEST. REPLACED BATTERY (AALA202302173149) AND TEST SWITCH (AALA202302203044). ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202302203149Battery · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FA JUMP SEAT 2L TEST LIGHT FLASHES RED DURING TEST. REPLACED BATTERY (AALA202302173149) AND TEST SWITCH (AALA202302203044). ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202302175634Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT LEFT OUT BOARD FLIGHT ATTENDANT FLASHLIGHT PUSH TO TEST LIGHT IS RED. REPLACED BATTERY PER AMM 25-64-00. TEST LIGHT GREEN.SDR AALA202302179937None · looseAIRCRAFT WAS NOT GROUNDED: BRACKET WHERE GIRT BAR IS INSERTED ON SERVICE DOOR SIDE IS LOOSE. ADJUSTED GIRT BAR RETAINER CLIP ON R1 DOOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303156347Door · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT JACKSCREW COMPARTMENT DOOR INNER SURFACE OF DOOR SKIN LOCATED AT BS 1040 AND S21L. REPLACED DOOR PER AMM 52-49-11.SDR AALA202302218251Pressure Deck · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1042, WL 211.1, AND RBL 12. REPAIRED WEB PER SRM 51-40-02-0G.SDR AALA202302215264Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK SUPPORT WEB LOCATED AT BS 1026 AND RBL 21. REPAIRED WEB PER SRM 51-40-02-0G.SDR AALA202302215364Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB #4 LOCATED AT BS 1026 AND LBL 34. REPAIRED WEB PER 51-40-02-0G.SDR AALA202302211150Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE FRAME ATTACH STRINGER CLIP LOCATED AT BS 500G AND LBL 6. REPLACED STRINGER CLIP PER SRM 51-40-02-0G.SDR AALA202302211557Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE FRAME ATTACH STRINGER CLIP LOCATED AT BS 500D AND LBL 6. REPLACED STRINGER CLIP PER SRM 51-40-02-0G.SDR AALA202302203723Pressure Deck · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1026 AND RBL 35. REPLACED WEB PER 51-40-02-0G.SDR AALA202302204079Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT WEB LOCATED AT BS 1018 AND LBL 30. REPLACED WEB PER 51-40-02-0G.SDR AALA202302202341None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR CUTOUT INNER CHORD LOCATED FROM BS 980 TO BS 986.5 AT LBL 55. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202302202039Scuff Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SCUFF PLATE LOCATED AT BS 312 AND LBL 62. REPLACED SCUFF PLATE PER SRM 51-40-02-0G.SDR AALA202302172414Door · out of adjustAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT CAME ON DURING TAKEOFF ROLL AT 90 KNOTS AIRCRAFT PSI STAYED BELOW 5000 FEET LIGHT CAME ON AND OFF SEVERAL TIMES PUSHING HANDLE HAS NO EFFECT. CHECK AND ADJUSTED FORWARD ENTRY DOOR IAW AMM 52-11-00-820-801. ADJUSTSDR AALA202302179160Engine · shutdownAIRCRAFT WAS GROUNDED: NUMBER 1 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED IN FLIGHT, WOULD NOT EXTINGUISH. PERFORMED ENGINE SHUTDOWN CHECKLIST. OIL TEMP REACHED 128C BEFORE ENGINE SHUT DOWN. FLIGHT DIVERTED TO MIA. SINGLE ENGINE TIME WAS 45 MINUTES. EMERGENCYSDR AALA202302155853Smoke Detector · failedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT CARGO SMOKE DETECTOR M2243 TEST FAILS. REPLACED SMOKE DETECTOR PER AMM 26-16-01-000-801 AND AMM 26-16-01-400-801. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 26-16-00-710-01.SDR AALA202302155175Smoke Detector · no testAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT CARGO SMOKE DETECTOR M2247 TEST FAILS. REPLACED SMOKE DETECTOR PER AMM 26-16-01-000-801 AND AMM 26-16-01-400-801. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 26-16-00-710-01.SDR AALA202302156149Window · scratchedAIRCRAFT WAS GROUNDED: CAPTAINS L1 WINDSHIELD IS SCRATCHED. REMOVED AND REPLACED CAPTAINS L1 WINDSHIELD.SDR AALA202302159968Windshield · scratchedAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICER'S R1 WINDSHIELD IS SCRATCHED. REMOVED AND REPLACED FIRST OFFICERS R1 WINDSHIELD.SDR AALA202302215984Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR CUT-OUT INNER CHORD LOCATED FROM BS 947.5 TO BS 992 AT RBL 55. REPLACED CHORD PER SRM 51-40-02-OG AND AARD 51-00-05-1.SDR AALA202302218317Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR WEB LOCATED AT BS 986.5 AND RBL 35. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302210850Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON Z ANGLE LOCATED AT BS 992.8 AND RBL 50. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202302216510Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB LOCATED AT BS 986.5 AND LBL 35. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302201608Floor Support · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PASSENGER CABIN FLOOR SUPPORT LOCATED ABOVE MAIN LANDING GEAR WHEEL WELL AT BS 536 AND FROM RBL 0 TO RBL 24. REPLACED FLOOR SUPPORT PER DWG 143A5400 AND AARD 51-00-05.SDR AALA202302205905Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT LOCATED ABOVE MAIN LANDING GEAR WHEEL WELL AT BS 536 AND FROM LBL 0 TO LBL 24. REPLACED FLOOR SUPPORT PER DWG 143A5400 AND AARD 51-00-05.SDR AALA202302168373Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR 1L GUST LOCK DIFFICULT TO RELEASE. **SUPPLEMENTAL REPORT FOR AALA202302148373: CLEANED AND LUBRICATED GUST LOCK. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202302169050None · noneAIRCRAFT WAS NOT GROUNDED: DOOR 1L GUST LOCK DOES NOT RELEASE PROPERLY. **SUPPLEMENTAL REPORT FOR AALA202302149050: ACCOMPLISHED FIM TASK 52-10-00-810-809. NO DEFECTS NOTED. GUST LOCK LOCKS AND UNLOCKS EASILY. OK FOR SERVICE.** (CLOSED)SDR AALA202302146136Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND AFT RIGHT FLIGHT ATTENDANT FLASHLIGHTS PUSH TO TEST LIGHTS FAIL. REMOVED AND REPLACED FLASHLIGHTS BATTERY.SDR AALA202302146132Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND FORWARD FLIGHT ATTENDANT FLASHLIGHTS PUSH TO TEST LIGHTS FAIL. REMOVED AND REPLACED FLASHLIGHTS BATTERY.SDR AALA202302140437Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND LEFT AFT FLIGHT ATTENDANT FLASHLIGHT PUSH TO TEST LIGHTS FAIL. REMOVED AND REPLACED FLASHLIGHTS BATTERY.SDR AALA202302149050Unknown · unknownAIRCRAFT WAS NOT GROUNDED: DOOR 1L GUST LOCK DOES NOT RELEASE PROPERLY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202302148373Unknown · unknownAIRCRAFT WAS NOT GROUNDED: DOOR 1L GUST LOCK DIFFICULT TO RELEASE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202302216283Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RAIL LOCATED AT BS 500I AND FROM LBL 24 TO RBL 24. REPLACED RAIL PER SRM 51-40-02, 51-10-02, AND 53-30-08-1A.SDR AALA202302214730Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500E TO BS 500F AT S25R. REPLACED INTERCOSTAL PER SRM 51-40-02 AND 51-40-05.SDR AALA202302212995Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER TRAILING EDGE ELEVATOR BALANCE BAY UPPER CLOSE OUT CHANNEL LOCATED FROM STABILIZER STA 166.3 TO 193.9. REPLACED CHANNEL PER AARD 51-00-05-1.SDR AALA202302202647Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ZEE ANGLE LOCATED AT BS 992.8 AND LBL 50. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202302205155Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER #3 WEB LOCATED AT BS 1026 AND LBL 21. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302140097Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR DIFFICULT TO ARM/DISARM. CLEANED GIRT BAR LATCHES AND ADJUSTED LATCH TENSION.SDR AALA202302136564Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. REPLACED AFT MEGAPHONE IAW AMM 25-64-00.
Back to Boeing 737-823