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 AALA202212142634Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT BS 986.5 AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R PROCEDURE 4.SDR AALA202212147432Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 270 FROM LBL 10 TO RBL 10. REPAIRED INTERCOSTAL PER EA 340149.SDR AALA202212144620Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN LEFT SIDE CHORD LOCATED FROM BS 294.5 TO BS 360 AT LBL 62. REPLACED CHORD PER SRM 53-10-15-1A AND SRM 51-40-02.SDR AALA202212148726Floorbeam · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN MAIN CABIN FLOORBEAM BS 727B, LBL 55. REPAIRED FLOORBEAM IAW EA 340488.SDR AALA202212140848Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 270 AND FROM LBL 10 TO RBL 10. REPAIRED INTERCOSTAL PER EA 340149.SDR AALA202212137778Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT LEFT SIDE GILLINER ATTACH ANGLE "CHANNEL" HAS CORROSION AT NUTPLATE HOLE. LOCATED AT STA 440 AND BETWEEN STR 35L AND 26L. REPAIRED WITH SPLICE PER EA.SDR AALA202212059026Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: PASSENGER ENTRY DOOR GIRT BAR BRACKETS ON THE DOOR DIFFICULT TO ARM AND DISARM. ADJUSTED GIRT BAR BRACKETS PER AMM 25-66-00.SDR AALA202212050118Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR BRACKETS ON THE DOOR DIFFICULT TO ARM AND DISARM. ADJUSTED GIRT BAR BRACKETS PER AMM 25-66-00.SDR AALA202212053111Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED AND CLEANED AFT LOWER LAVATORY DOOR PER CMM 25-40-65.SDR AALA202212051728Door · off trackAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY ENTRY DOOR HARD TO OPEN. MAINTENANCE FOUND LAVATORY DOOR OUT OF TRACK. RE-SECURED IN TRACK PER AMM 38-0-00.SDR AALA202212052525Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR HARD TO SECURE. ADJUSTED SLIDE COVER GIRT BAR RETAINER CLIPS. OPERATIONAL TEST GOOD PER AMM 25-66-00.SDR AALA202212050235Oven · odorAIRCRAFT WAS NOT GROUNDED: #2 OVEN IN FORWARD GALLEY SMOKES WHEN IN USE. REPLACED OVEN PER AMM 25-32-03.SDR AALA202302171080Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUTOUT LOWER SILL WEB LOCATED FROM BS 810 TO BS 833 AT RBL 20. REPLACED WEB PER SRM 53-60-15-2R-1 AND SRM 51-40-02-0G.SDR AALA202302135720Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500A + 5 INCHES TO BS 500H + 11 INCHES AT LBL 21. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202301114356Trans Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727I TO BS 727H AT LBL 21. REPAIRED TRANSITION PANEL PER SRM 53-00-53-6.SDR AALA202212147828Panel · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT WING LEADING EDGE PANEL 621LB HAS CORROSION ON EDGE OF PANEL STRUCTURE. ACCOMPLISHED PERMANENT REPAIR OF 621LB RIGHT WING LEADING PANEL EDGE CORROSION PER B737NG SRM 57-41-01-2R-6.SDR AALA202212021100Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT DOOR FLIGHT ATTENDANTÏ¿½S EMERGENCY FLASHLIGHT LED DOES NOT FLASH. REPLACED FLASHLIGHT BATTERY REF AMM 25-64-00.SDR AALA202212149639Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT BS 947.5 AND LBL 26. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA202212012790Slide · out of positionAIRCRAFT WAS GROUNDED: SERVICE DOOR SLIDE HANGING DOWN. REPOSITIONED SLIDE PACK ON SERVICE DOOR PER AMM 25-66-01.SDR AALA202212019407Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO CLOSE AND SECURE. ADJUSTED COCKPIT DOOR LOCK.SDR AALA202301187939Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231GF HAS EDGE DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202212226600Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT RIGHT FLOOR TRANSITION PANEL HAS AREAS OF CORROSION ON UPPER SURFACE BETWEEN STA 727F AND STA 787 AND RIGHT BUTT LINE 30. CUT OUT CORRODED Z CHANNEL, FABRICATED 2 EACH Z CHANNELS AND 2 EACH SPLICE PLATES AND SDR AALA202212212246Skin · dentedAIRCRAFT IN BASE MAINTENANCE: DENT IN RIGHT HAND ELEVATOR UPPER SKIN LOCATED AT ELEVATOR STATION 216 AND STAB RBL 180. REPAIRED SKIN PER SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-14.SDR AALA202212216034Skin · dentedAIRCRAFT IN BASE MAINTENANCE: DENT IN RIGHT HAND ELEVATOR UPPER SKIN LOCATED AT ELEVATOR STATION 186 AND STAB RBL 160. REPAIRED SKIN PER SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-14.SDR AALA202212211910Skin · dentedAIRCRAFT IN BASE MAINTENANCE: DENT IN RIGHT HAND ELEVATOR UPPER SKIN LOCATED AT ELEVATOR STATION 140 AND STAB RBL 155. REPAIRED SKIN PER SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-14.SDR AALA202212143763Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN MAIN DECK SEAT TRACK LOCATED FROM BS 480 TO BS 700 AT RBL 45. REPAIRED SEAT TRACK PER SRM 53-00-52-2R PROCEDURE 4.SDR AALA202212137606Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATED RIGHT HAND ELEVATOR UPPER SKIN LOCATED AT ELEVATOR STA 177 AND RBL 180. REPAIRED SKIN PER SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-1.SDR AALA202212131787Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: PUNCTURE IN RIGHT HAND ELEVATOR UPPER SKIN LOCATED AT ELEVATOR STA 70 AND RBL 140. REPAIRED SKIN PER SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-1.SDR AALA202212139992Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: PUNCTURE IN RIGHT HAND ELEVATOR UPPER SKIN LOCATED AT ELEVATOR STA 93 AND RBL 150. REPAIRED SKIN PER SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-1.SDR AALA202212026327Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND CONNECTOR D11074 NOT PROPERLY SEATED. PROPERLY INSTALLED CONNECTOR PER WDM 33-51-12 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202301127767Skin · crackedAIRCRAFT WAS GROUNDED: CRACK IN INNER SKIN IS HORIZONTAL APPROXIMATELY 1 INCH IN LENGTH. FORWARD END OF CRACK IS LOCATED 2.7 INCHES AFT OF STIFFENER AND 0.6 INCHES BELOW NEAREST FASTENER HOLE. STA 663, STR 18L AND WATERLINE 0. PERFORMED A FLUSH DOUBLER REPAIR SDR AALA202212191556Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FORWARD SERVICE DOOR INTERNAL STRUCTURE BEAM LOCATED AT STA 299.10 TO STA 328.87 AND BEAM 4. REMOVED AND REPLACED INTERNAL STRUCTURE TRACE BEAM PER SRM 51-40-02-0G.SDR AALA202212023809Overheat Sensor · false activationAIRCRAFT WAS GROUNDED: AIR RETURNED TO DFW ACCOUNT RIGHT WING BODY OVERHEAT INDICATION. EMERGENCY WAS DECLARED. RIGHT WING BODY OVERHEAT LIGHT ILLUMINATED. REMOVED AND REPLACED DET M1764 (AALA202212023809) AND DET M1763 (AALA202212025735) IAW AMM 26-18-02.SDR AALA202212025735Overheat Sensor · false activationAIRCRAFT WAS GROUNDED: AIR RETURNED TO DFW ACCOUNT RIGHT WING BODY OVERHEAT INDICATION. EMERGENCY WAS DECLARED. RIGHT WING BODY OVERHEAT LIGHT ILLUMINATED. REMOVED AND REPLACED DET M1764 (AALA202212023809) AND DET M1763 (AALA202212025735) IAW AMM 26-18-02.SDR AALA202301186247Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242JF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188608Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232FF HAS DAMAGE ON TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301183557Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232EF HAS DAMAGE ON TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188035Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232CF HAS DAMAGE TO TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186667Floor Panel · puncturedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231XF HAS MULTIPLE PUNCTURES IN TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301187426Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231NF HAS DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188549Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231LF HAS DAMAGE ON TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301189703Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231EF HAS DAMAGE TO TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186147Support Bracket · brokenAIRCRAFT IN BASE MAINTENANCE: AFT CARGO, FORWARD BULKHEAD HAS BROKEN SUPPORT BRACKET. REMOVED AND REPLACED SUPPORT BRACKET ON AFT CARGO FORWARD BULKHEAD.SDR AALA202211289734Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT ATTENDANT SEAT INBOARD EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT RIGHT ATTENDANT SEAT INBOARD EMERGENCY FLASHLIGHT PER AMM 25-64-00.SDR AALA202211289277Hinge · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS DIFFICULT TO OPEN AND CLOSE AND ALSO DIFFICULT TO LOCK. FOUND LAVATORY "D" DOOR JAMMING ON FLOOR SILL WITH LOOSE DOOR HINGE. RESECURED PER AMM 20-50-00. OPERATIONS CHECKED GOOD.SDR AALA202211289589Sensor · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKEOFF COULD NOT MAINTAIN FLIGHT DECK TEMPERATURE. DUCT TEMP RANGED ABOVE 160 DEGREES BELOW 70 DEGREES. RETURNED TO DFW. REMOVED AND REPLACED FLIGHT DECK CABIN TEMPERATURE SENSOR (AALA202211289589) PER AMM 21-61-10. PERFORMED PACKSDR AALA202211283024Valve · faultedAIRCRAFT WAS GROUNDED: AFTER TAKEOFF COULD NOT MAINTAIN FLIGHT DECK TEMPERATURE. DUCT TEMP RANGED ABOVE 160 DEGREES BELOW 70 DEGREES. RETURNED TO DFW. REMOVED AND REPLACED FLIGHT DECK CABIN TEMPERATURE SENSOR (AALA202211289589) PER AMM 21-61-10. PERFORMED PACKSDR AALA202301060847Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF AFT PRESSURE BULKHEAD LOWER SEAL FOUND CORROSION AFT PRESSURE BULKHEAD LOWER INTERCOSTAL ATTACHMENT. LOCATED AT STA 1016 AND BETWEEN RIGHT BUTT LINE 17-16. REMOVED AND REPLACED INTERCOSTAL.SDR AALA202212018029Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: BAFFLE BETWEEN STA 500C AND STA 500D AND AT LEFT BUTT LINE 25 HAS CRACKED. REMOVED AND REPLACED BAFFLE PER SRM 51-40-02.SDR AALA202212011133Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE CORROSION ON LEFT CORROSION ON LEFT TRANSITION PANEL BETWEEN STA 500B TO STA 500G AND LEFT BUTT LINE 25. REMOVED AND REPLACED TRANSITION PANEL PER SRM 51-40-02.
Back to Boeing 737-823