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 AALA202411050960Slide Raft · low pressureAIRCRAFT WAS NOT GROUNDED: AFT COMPARTMENT TOURIST CLASS LIFE RAFT PRESSURE LOW. REPLACED AFT COMPARTMENT TOURIST CLASS LIFE RAFT. PER AMM 25-64-00.SDR AALA202411257414Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, FROM LBL 52 TO LBL 24. ACCOMPLISHED REPAIR PER PER SRM 53-70-51-2R-5.SDR AALA202411255097Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 956, LBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411132992Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, AT THIRD STIFFENER FROM FRONT SPAR, LOCATED AT STABILIZER STA 92.70. REPLACED RIB PER 51-00-03-01.SDR AALA202411082745Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED AT STA 947, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411041476Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT REPORTS 1R DOOR GIRT BAR FLAP IS VERY STIFF AND DIFFICULT TO DISARM DOOR. LUBRICATED GIRT BAR FLAP AT 1R DOOR. PER AMM 52-11-00.SDR AALA202411046172Switch · no testAIRCRAFT WAS GROUNDED: FOUND EMERGENCY PATH LIGHTS 18ABC TO 25ABC INOPERATIVE WHILE WORKING JOBCARD #09T20033001. FOUND EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT SEAT AT FAULT. CYCLED SWITCH. NO FAULTS NOTED. PER AMM 33-51-00SDR AALA202411043366Switch · no testAIRCRAFT WAS GROUNDED: FOUND AISLE EMERGENCY LIGHT ABOVE OVERHEAD BIN ROW 17ABC INOPERATIVE WHILE WORKING JOBCARD #09T20033001. FOUND EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT SEAT AT FAULTY. CYCLED SWITCH. NO FAULTS NOTED. PER AMM 33-51-00.SDR AALA202411049549Switch · no testAIRCRAFT WAS GROUNDED: FOUND AISLE EMERGENCY LIGHT ABOVE OVERHEAD BIN ROWS 12DEF AND 16DEF AND CELLING AISLE EMERGENCY LIGHT BETWEEN ROW 4 AND 8 INOPERATIVE WHILE WORKING JOBCARD #09T20033001. FOUND EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT SEAT AT FAULTYSDR AALA202411049699Switch · no testAIRCRAFT WAS GROUNDED: FOUND RIGHT HAND FORWARD OVERWING EMERGENCY LIGHT INOPERATIVE WHILE WORKING JOBCARD #09T20033001. FOUND EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT SEAT AT FAULTY. CYCLED SWITCH. NO FAULTS NOTED. PER AMM 33-51-00.SDR AALA202411043394Switch · no testAIRCRAFT WAS GROUNDED: FOUND LEFT HAND WING SLIDE EMERGENCY LIGHT BY TRAILING EDGE INOPERATIVE WHILE WORKING JOBCARD #09T20033001. FOUND EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT SEAT AT FAULTY. CYCLED SWITCH. NO FAULTS NOTED. PER AMM 33-51-00.SDR AALA202411049299Switch · no testAIRCRAFT WAS GROUNDED: FOUND LEFT HAND OVERWING AFT EMERGENCY LIGHT INOPERATIVE WHILE WORKING JOBCARD #09T20033001. FOUND EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT SEAT AT FAULT. CYCLED SWITCH. NO FAULTY NOTED. PER AMM 33-51-00.SDR AALA202411049862Girt Bar · dislodgedAIRCRAFT WAS NOT GROUNDED: DOOR 4L GIRT BAR GOT KNOCKED OUT OF POSITION. SECURED GIRT BAR. PER GPM 02.01.2.SDR AALA202411044085Proximity Sensor · dirtyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAP TRANSIT ILLUMINATED AFTER SELECTION OF FLAPS 1, 4, AND 5; AIRCRAFT ABORTED APPROACH AND RELANDED SAFELY AT ORD. ACCOMPLISHED BITE OF FLAP AND SLAT CONTROL UNIT. FOUND EXT PROX SENSOR EXSDR AALA202411072725Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500H, S26R. REPLACED BAFFLE CLIP PER AARD 51-00-05-01.SDR AALA202411071391Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CIP AT STA 500G, RBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-01.SDR AALA202411041089Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500H, RBL 26. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202411263936Attach Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU DOOR RIB 3 INSULATION BLANKET ATTACH BRACKET AT STA 1112, WL 148.5. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202411266596Attach Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU DOOR RIB 4 INSULATION BLANKET ATTACH BRACKET AT STA 1112, WL 148.5. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202411261746Attach Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU DOOR RIB 5 INSULATION BLANKET ATTACH BRACKET AT STA 1112, WL 148.5. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202411259845Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM STA 500C TO STA 500I, S25R. REPLACED TRASSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202411251951Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD LOCATED FROM STA 498 TO STA 502, RBL 25. REPLACED SHIEL PER AARD 51-00-05-1.SDR AALA202411252512Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM STA 500D TO STA 500E, LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202411259371Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR THRESHOLD WEB LOCATED FROM STA 440 TO STA 490, RBL 26. REPLACED THRESHOLD WEB PER AARD 51-00-05-1.SDR AALA202411258708Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT STA 540, RBL 3. REPLACED BREAK ASSEMBLY PANEL AARD PER 51-00-05-1.SDR AALA202411189769Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WING INBOARD AFT FLAP HAS EVIDENCE OF A PUNCTURE 24 INCHS FROM INBOARD END. ACCOMPLISHED EVALUATION OF EXISTING DENTS AND REPAIRED PUNCTURE ON LEFT HAND INBOARD AFT FLAP LOWER SKIN.SDR AALA202411134054Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 747, S26R. ACCOMPLISHED SPLICE REPAIR PER AARD 51-00-05-1 AND SRM 53-00-53-2R-5,.SDR AALA202411042313Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN A CLOSE AND GETS STUCK. ADJUSTED LAVATORY-D DOOR, OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202411049367Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT AFT FLIGHT ATTENDANT POSITION IS BLINKING RED. REPLACED FLASHLIGHT AT AFT FLIGHT ATTENDENT POSITION LEFT SIDE.SDR AALA202411041474Sign · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT COVER LEFT AFT LAVATORY IS MISSING. REPLACED MISSING AFT LAVATORY EXIT LIGHT. PER AMM 33-50-00.SDR AALA202411044903Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500F, S26R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202411043010Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500G, S26R. REPLACED CLIP PERAARD 51-00-05-1.SDR AALA202411047860Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51.00.05.1.SDR AALA202411045315Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51.00.05.01.SDR AALA202411011014Connector · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT WIRING AT SEAT 3B SEAT PAN HAS BROKEN CONNECTOR. RECONNECTED CONNECTOR, CONNECTOR SECURED AND OPERTIONAL CHECKS GOOD. PER SWPM 20-61-28.SDR AALA202411042955Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING EMERGENCY EXIT AFT EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELMAPED, OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202411041986Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500H, LBL 26. REPLACED CLIP PER AARD 53-00-01-6.SDR AALA202411041648Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500G, LBL 26. REPLACED CLIP PER AARD 53-00-01-6.SDR AALA202411013646Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER OUTBOARD CLOSURE RIB AT STA 1145, STAB BL 281.81. REPLACED RIB PER SRM 51-40-02.SDR AALA202411012693Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT HAND FORWARD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP, OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202411011156Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 31C IS HANGING ON THE CABIN FLOOR. SECURED SEAT 31C EMERGENCY ESCAPE PATH LIGHT, OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202411262163Skin · wornAIRCRAFT IN BASE MAINTENANCE: WEAR MARK ON FUSELAGE SKIN INTERNAL SURFACE AT STA 277 PLUS 6 INCHES, FROM S2L TO S3L. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-01-2R PROCEDURE 20.SDR AALA202411139483Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR LOWER SILL INNER CHORD (CREASE ANGLE) AT STA 1000, RBL 45. REPLACED CHORD PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202411134553Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 950, LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411082104Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE STRAP LOCATED AT STA 300, RBL 54. REPLACED STRAP PER SRM 51-00-05-1.SDR AALA202411073355Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 321, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411072300Floor 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 AALA202411079838Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 284, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411066217Splice · 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 AALA202411062265Skin · corrodedACFT WAS GROUNDED: LARGE AREA OF SEVERE CORROSION APROX 2" X 1" AT BS 887 S27L. 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 REPAIR PE
Back to Boeing 737-823