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 AALA202409098290Gust Lock · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GUST LOCK LEVER MISSING. REPLACE FORWARD R1 DOOR LOCK ASSEMBLY. PER AMM 52-00-00.SDR AALA202409094146Transmitter · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING THE APPROACH, ON BASE TO FINAL FLAP MOVEMENT STOPPED BETWEEN 0 AND 1 WITH A SPLIT OF THE NEEDLES, PERFROM GOAROUND; AIRCRAFT LANDED SAFELY AT LIR. REMOVED AND REPLACED RIGHT HAND FLAP POSITION TRASDR AALA202409164207Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500D+10 INCHES TO STA 500I, LBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5, AND AARD 51-00-05-1.SDR AALA202409164394Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500F TO STA 500I, RBL 24. REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202409126009Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BREAK ASSEMBLY PANEL AT STA 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202409117818Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR SURROUND STRUCTURE VERTICAL INNER CHORD CREASE ANGLE STRAP AT STA 298, S17R. REPLACED STRAP PER AARD 51-00-05-1.SDR AALA202409094844Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT ANGLE AT BS 500I, BETWEEN LBL 25 AND RBL 25.SDR AALA202409068208Light · unsecureAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 27C IS UNSECURED. REINSTALLED ESCAPE PATH LIGHT ASSEMBLY AT SEAT 27C. PER AMM 33-51-11.SDR AALA202409067110Guide Arm · shearedAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR WILL NOT OPEN ALL THE WAY. UPPER HINGE IS SHEARED AT THE BOTTOM LINK. REMOVED AND REPLACED FORWARD ENTRY DOOR GUIDE ARM ASSEMBLY. OPERTRIONAL CHECK GOOD. PER AMM 52-11-21.SDR AALA202409060096Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH IS BROKEN. PAX GOT STUCK IN LAVATORY. BOTTOM TRIM PIECE IS ALSO DETACHED. LUBED DOOR HINGES AND LOCKS. OPERTIONAL CHECK GOOD.SDR AALA202409066150Light · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING JC 08T20033001 FOUND EMERGENCY AISLE LIGHT ABOVE 25ABC INOPERATIVE. REMOVE AND REPLACED EMERGENCY LIGHT ASSEMBLY ABOVE SEAT 25ABC. PER AMM 33-51-01.SDR AALA202410034387Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FORWARD FLOOR MOUNTED GIRT BAR TIEDOWN AT BS 330.62, WL 208. REPLACED TIE DOWN PER SRM 51-40-02 AND SRM 51-10-02-0G.SDR AALA202409231516Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCES: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 947 TO STA 967, LBL 16. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409201685Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 947 TO STA 960, LBL 50. REPLACED INTERCOSTAL PER SRM 53-70-51-2R.SDR AALA202409206768Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 947, LBL 50. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R REPAIR 5.SDR AALA202409191365Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT GIRT BAR TIEDOWN MOUNTING HOLE, STA 986, WL 206, RBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202409197168Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER FLOOR SUPPORT AT STA 990, FROM RBL 34 TO RBL 41. REPLACED SUPPORT PER AARD 51-00-05.SDR AALA202409169828Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT FLOOR MOUNTED GIRT BAR TIEDOWN AT BS 344, LBL 54. REPLACED TIEDOWN PER 51-00-05-1. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202409160566Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 335, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409109528Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409096821Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR TRANSITION PANEL BETWEEN STA 500D AND STA 500I AT RBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202409055815Fan · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKE OFF SMELLED BURNING ODOR IN FLIGHT DECK AND CABIN; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. FOUND LEFT HAND RECIRCULATION FAN FAULTY. REMOVE AND REPLACED LEFT HAND RECIRCULATSDR AALA202409046212Elt · no testAIRCRAFT IN BASE MAINTENANCE: PORTABLE ELT FAILED CONTINUITY TEST. REMOVED AND REPLACED PORTABLE ELT. PER TASK CARDS 99T20025003 AND 99L20025003 OPERTIONAL CHECK GOOD.SDR AALA202409115283Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS. **SUPPLEMENTAL REPORT FOR (AALA202409045283): REMOVED AND REPLACED AFT LEFT LAVATORY DOOR. PER CMM 25-40-64**(CLOSED).SDR AALA202409095496Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR TRANSITION PANEL BETWEEN STA 500D AND STA 500I AT LBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5 REPAIR 5.SDR AALA202409068566Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND VAPOR BARRIER AT BS 663 IS CRACKED APPROX. 8 INCHES AT RBL 28 TO RBL 36, BAYS 5L AND 7L. INSTALLED FABRIC PATCH REPAIR. CRACK IS 8 INCHES IN LENGTH, AND BOTH ENDS OF CRACK ARE UNDER STRUCTURE. PRIMED AND PAINTED AREA. PESDR AALA202409064650Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND VAPOR BARRIER BS 663 IS CRACKED APPROX. 4 INCHES AT RBL 39 TO RBL 41, AND BAY 7R. REQUIRES A 3000 FLIGHT CYCLE REINSPECT. INSTALLED FABRIC PATCH REPAIR. CRACK IS 4 INCHES IN LENGTH, AND BOTH ENDS OF CRACK ARE UNDER STRUSDR AALA202409069871Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND VAPOR BARRIER BS 663 IS CRACKED APPROX. 9 INCHES AT RBL 45TO RBL 55, BAY 9R. REQUIRES A 3000 FLIGHT CYCLE REINSPECT. INSTALLED FABRIC PATCH REPAIR, CRACK IS 9 INCHES IN LENGTH, ANDBOTH ENDS OF CRACK ARE UNDER STRUCTURE.SDR AALA202409061225Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: WHILE PERFORMING EMERGENCY LIGHTS TEST, FOUND LEFT HAND SEAT ROWS 18-25 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED AND PERFORMED A SATISFACTORY OPERTIONAL CHECK OF NEW EMERGENCY POWER SUPPLY. PER B737-MAX8-AMM 33-51-06-960SDR AALA202409059819Fdas · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR WILL NOT OPEN.**SUPPLEMENTAL REPORT FOR (AALA202409049819): REPLACED COCKPIT DOOR ACCESS (FDAS)FLIGHT DECK ACCESS SYSTEM CONTROLLER CHIME MODULE. PER AMM 52-51-06**(CLOSED).SDR AALA202409045283Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202409049819Door · stuckAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR WILL NOT OPEN.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202409042232Slide · unsecureAIRCRAFT WAS GROUNDED: LEFT AFT DOOR SLIDE BAR IS LOOSE AND HANGING FROM DOOR. REINSTALLED AND SECURED LEFT AFT DOOR SLIDE. ALL TEST NORMAL. PER AMM 25-66-01.SDR AALA202409049768Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAV DOOR DIFFICULT TO OPEN AND CLOSE INFLIGHT. LUBED FORWARD LAVATORY-A DOOR. OPERTIONAL CHECKED DOOR GOOD. PER AMM 25-40-11.SDR AALA202411060337Skin · corrodedACFT WAS GROUNDED: LARGE AREA OF SEVERE CORROSION APROX 2" X 1" AT BS 887 S27L. RIVET HEAD MISSING AND SKIN CRACKED APROX 1" LENGTHWISE OF AC. MX FOUND CORROSION ON FUSELAGE SKIN UNDER SPLICE STRAP AT BS 887, FROM S24L TO S27R. ACCOMPLISHED DOUBLER REPAIR PERSDR AALA202409136642Apu · smokeAIRCRAFT WAS GROUNDED: APU RUNNING PLANE WAS ON APU POWER AND APU BLEED SELECTED. THE POWER DISRUPTED AND THERE WAS A BRIEF SMELL OF SMOKE AND SMOKE WAS VISIBLE IN THE CABIN. **SUPPLEMENTAL REPORT FOR (AALA202409046642): REMOVE AND REPLACED APU, OPERTIONAL CHESDR AALA202409060337Skin · corrodedAIRCRAFT WAS GROUNDED: LARGE AREA OF SEVERE CORROSION APROX 2" X 1" AT BS 887 STR 27L. RIVET HEAD MISSING AN D SKIN CRACKED APROX 1" LENGTHWISE OF AC. MX FOUND CORROSION ON FUSELAGE SKIN UNDER SPLICE STRAP AT BS 887, FROM S24L TO S27R. ACCOMPLISHED DOUBLER RESDR AALA202409040493Sign · detachedAIRCRAFT WAS NOT GROUNDED: LAVATORY-D EXIT SIGN FELL DOWN AND IS NOT ILLUMINATED. REINSTALLED LAVATORY-D EXIT SIGN. PERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202409046642Apu · faultedAIRCRAFT WAS GROUNDED: APU RUNNING PLANE WAS ON APU POWER AND APU BLEED SELECTED. THE POWER DISRUPTED AND THERE WAS A BRIEF SMELL OF SMOKE AND SMOKE WAS VISIBLE IN THE CABIN. (OPEN).SDR AALA202409301029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727 TO STA 807, LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202409166720Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR CUT OUT LOWER WEB FROM STA 438 TO STA 498, S25R. REPLACED WEB PER AARD 51-00-05-01 AND SRM 53-30-15-2R.SDR AALA202409112676Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FORWARD CARGO COMPARTMENT TRANSITION SHIELD FROM STA 420 TO STA 440, RBL 25. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202409111333Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER SUPPORT RAIL AT STA 500I, RBL 25. REPAIRED RAIL PER SRM 53-30-08-0I PROCEDURE 1 AND SRM 51-10-02.SDR AALA202409112444Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 400 TO STA 420, RBL 25. REPAIRED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202409117580Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 400 TO STA 500I, LBL 25. REPAIRED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202409112470Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500A, RBL 25. REPAIRED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202409114626Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500, RBL 25. REPAIRED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202409112650Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT, UNDER DOOR LOWER CUT-OUT SCUFF PLATE, ON FUSELAGE SKIN AT STA 438, RBL 25. REPAIRED SKIN PER SRM 51-10-02.SDR AALA202409113291Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK AROUND FASTENER HOLE IN INTERCOSTAL FROM STA 344 TO STA 360, WL 208.1, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409096093Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STUB FRAME LOCATED ABOVE CENTER WING BOX AT STA 616, RBL 70.85. REPLACED STUB FRAME PER EA 357237.
Back to Boeing 737-823