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 AALA202404049069Skin · crackedAIRCRAFT IN BASE MAINTENANCE: AIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 96. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202404040868Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM BS 727H TO BS 757L PLUS 6 INCHES, LBL 21. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202404041916Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727B TO BS 815, LBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202404018717Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 787, RBL 21. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202403277363Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE SHIELD FROM BS 500 TO BS 500A, S26R. REPLACED SHIELD PER AARD 51-00-5-01.SDR AALA202403273514Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM BS 460 TO BS 500I, S24L. REPLACED TRANSITION PANEL PERSRM 53-00-53-2R-6.SDR AALA202403272198Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT AT BS 992, RBL 37, REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA202403257326Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 322 TO BS 328, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403250473Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727B TO BS 727F, LBL 21. REPAIRED TRANSITION PANEL PER 53-00-53-2R-5.SDR AALA202403251554Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT GIRT BAR TIEDOWN LOCATED AT BS 344 AND LBL 59. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202403254821Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM AT BS 986.5, RBL 29.5. REPAIRED FLOORBEAM PER SRM 51-10-02.SDR AALA202403250716Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR BOARD SUPPORT AT BS 540, BL 0. REPLACED FLOOR BOARD SUPPORT PER AARD 51-00-03-1.SDR AALA202403256565Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR BOARD SUPPORT AT BS 540, BL 0. REPLACED FLOOR BOARD SUPPORT PER AARD 51-00-03-1.SDR AALA202403254840Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500A - BS 500I, S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202403158048Air Filter · dirtyAIRCRAFT WAS GROUNDED: SMOKE ODOR FUME EVENT SUSPECT RECIRC FILTERS. FOUND RECIRC FILTERS VERY DIRTY. REPLACED LEFT (AALA202403158048) AND RIGHT (AALA202403157263) HAND RECIRC FILTERS. PER AMM 21-25-01.SDR AALA202403157263Air Filter · dirtyAIRCRAFT WAS GROUNDED: SMOKE ODOR FUME EVENT SUSPECT RECIRC FILTERS. FOUND RECIRC FILTERS VERY DIRTY. REPLACED LEFT (AALA202403158048) AND RIGHT (AALA202403157263) HAND RECIRC FILTERS. PER AMM 21-25-01.SDR AALA202403156271Slide · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE WORN BEYOND LIMITS. REMOVED AND REPLACED R1 DOOR SLIDE. PER WORK CARD 08L22125001.SDR AALA202403157151Door · out of adjustAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY, LAVATORY-D DOOR LATCH DIFFICULT TO OPEN. ADJUSTED LAVATORY-D DOOR. FUNCTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202403156763Door · out of adjustAIRCRAFT WAS GROUNDED: EXCESSIVE FORCE REQUIRED TO TURN 1L ENTRY DOOR HANDLE, DIFFICULT TO OPEN AND CLOSE. ADJUSTED ROLLER CATCH ON AIRFRAME SIDE OF AIRCRAFT, FUNCTIONAL CHECK GOOD. PER AMM 52-11-00.SDR AALA202403155842Girt Bar · scratchedAIRCRAFT IN BASE MAINTENANCE: PLACARD ON GIRT BAR L1 DOOR IS SCRATCHED AND TORN. REMOVED AND REPLACED GIRT BAR PLACARD. PER AFMM 20-11-26.SDR AALA202403151344Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK DIFFICULT TO MOVE. LUBRICATED LAVATORY-D LOCK. PER AMM 25-40-00.SDR AALA202403151864Door · out of adjustFLIGHT ATTENDANT REPORTED LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. FUNCTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202403142331Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR VERY DIFFICULT TO OPEN AND CLOSE DUE TO THE DOOR STOP PLUNGER NOT OPERATING CORRECTLY AS IT DRAGS ON FLOOR. ADJUSTED DOOR AS REQUIRED OK FOR SERVICE.SDR AALA202403259648Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 951, RBL 31. PREPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403259387Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN RIGHT HAND CREASE ANGLE AT BS 947. REPLACED CREASE ANGLE PER AARD 51-00-05-1-R1.SDR AALA202403255103Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN RIGHT HAND CREASE ANGLE AT R2 DOOR OPENING AT BS 945. REPLACED CREASE ANGLE PER AARD 51-00-05-1-R1.SDR AALA202403257301Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOREAM UPPER CHORD AT BS 986.5, RBL 43. REPAIRED FLOORBEAM CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE REPAIR 4.SDR AALA202403257417Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 951, RBL 32.5. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403254170Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 947 AND BS 967, LBL 16. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403252163Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 952, LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403252246Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM BS 727 TO BS 767, RBL20. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202403257728Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM CHORD AT BS 947, RBL 4. REPAIRED FLOOR BEAM CHORD PER SRM 53-00-51-2R-1.SDR AALA202403256403Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN CREASE ANGLE FROM BS 980 TO BS 986, LBL 48. REPLACED CREASE ANGLE PER AARD 51-00-05-1 R1.SDR AALA202403183669Skin · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK IN AFT LEFT HAND OF SECTION 48 JUST AFT OF BS 1138 MEASURING 2 INCHES LENGTH BY 0.063 IN WIDTH AND 0.30 IN DEPTH. ITEM MINOR IN NATURE. PERFORMED A GENERAL VISUAL INSPECTION OF AREA, FOUND DAMAGE WITHIN LIMITS. PREFOSDR AALA202403153669Not Reported · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK IN AFT LEFT HAND OF SECTION 48 JUST AFT OF BS 1138 MEASURING 2 INCHES LENGTH BY 0.063 IN WIDTH AND 0.30 IN DEPTH. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403154550Air Filter · dirtyAIRCRAFT WAS GROUNDED: AT LEVEL OFF FLIGHT ATTENDANT REPORTS VERY STRONG BURNING PLASTIC ELECTRICAL SMELL THROUGHOUT ENTIRE CABIN. SMELL APPEARED STRONGEST IN AFT CABIN, ODOR LASTED 3-5 MINUTES. **SUPPLEMENTAL REPORT FOR (AALA202403144550): FOUND RECIRC FILTERSDR AALA202403141375Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED AND ADJUSTED LAVATORY-D DOOR. FUNCTIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202403141877Trim Panel · out of positionAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR GETTING STUCK FROM TRIM ON TOP. REPOSITION TRIM ON AFT LEFT LAVATORY DOOR. FUNCTIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202403144550Unknown · odorAIRCRAFT WAS GROUNDED: AT LEVEL OFF FLIGHT ATTENDANT REPORTS VERY STRONG BURNING PLASTIC ELECTRICAL SMELL THROUGHOUT ENTIRE CABIN. SMELL APPEARED STRONGEST IN AFT CABIN, ODOR LASTED 3-5 MINUTES. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403196452Lock · unsecureAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK REPORTED STICKING AND HARD TO OPERATE. SECURED LAVATORY DOOR LOCK PER CMM 25-40-64.SDR AALA202403195459Tail Cone · corrodedAIRCRAFT IN BASE MAINTENANCE: EXFOLIATION CORROSION IN THE ADVANCED STAGE OF DETERIORATION FOUND ON THE RIGHT HAND SIDE OF THE UPPER FORWARD TAIL CONE. LOCATED AT AFT OF RUB STRIP AND JUST UNDER HORIZONTAL STAB. REPAIRED PER AARD 11-20-00-1 REPAIR 1.SDR AALA202403155459Tail Cone · deterioratedAIRCRAFT IN BASE MAINTENANCE: EXFOLIATION CORROSION IN THE ADVANCED STAGE OF DETERIORATION FOUND ON THE RIGHT HAND SIDE OF THE UPPER FORWARD TAIL CONE. LOCATED AT AFT OF RUB STRIP AND JUST UNDER HORIZONTAL STAB. Ï¿½ **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPSDR AALA202403150750Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND BOTTOM CORNER OF (GPU)-ELECTRICAL GROUND POWER RECEPTACLE ACCESS OPENING IS CRACKED. TRIMMED OUT THE DAMAGED AREA OF (GPU) INSTALLED DOUBLER REPAIRED. PER SRM 53-10-15-1A PROCEDURE 4.SDR AALA202403154082Lens · unserviceableAIRCRAFT IN BASE MAINTENANCE: FORWARD CLOSET EMERGENCY LIGHT LENS IS UNSERVICEABLE. REMOVED AND REPLACED NEW FORWARD CLOSET EMERGENCY LIGHT LENS AND TEST GOOD. PER B737NG AMM 33-51-14.SDR AALA202403151891Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT 4R OUTBOARD SEAT INOPERATIVE. : REPLACED FLASHLIGHT ASSEMBLY FOR FLIGHT ATTENDANT SEAT 4R. PER AMM 25-64-00 **(CLOSED).SDR AALA202403155232Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT 4R SEAT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202403135232): REPLACED FLASHLIGHT ASSEMBLY FOR FLIGHT ATTENDANT SEAT 4R. PER AMM 25-64-00**(CLOSED).SDR AALA202403143032Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE GIRT BAR MISSING RED HEAT SHRINK. **SUPPLEMENTAL REPORT FOR (AALA202403133032): ACCOMPLISHED REPLACEMENT OF RED HEAT SHRINK TUBING ON R1 DOOR GIRT BAR. PER AARD 25-66-00-4. OK FOR SERVICE.**(CLOSED).SDR AALA202403138756Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN EMERGENCY FLASHLIGHT WILL NOT TEST. SWAPPED FLASHLIGHTS FROM AFT RIGHT FLIGHT ATTENDANT OUTBOARD SEAT TO FORWARD FLIGHT ATTENDANT SEAT, PER AMM 25-64-00. OK FOR SERVICE.SDR AALA202403135232Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT 4R SEAT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403131891Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT 4R OUTBOARD SEAT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).
Back to Boeing 737-823