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 AALA202306194546Ferrule · out of positionAIRCRAFT WAS NOT GROUNDED: R1 SLIDE GIRT BAR FERRULE CAME OFF. REINSTALLED GIRT BAR FERRULE TO R1 SLIDE AS REQUIRED PER AMM 25-60-00.SDR AALA202306190170Idg · faultyAIRCRAFT WAS NOT GROUNDED: #2 SOURCE / GENERATOR LIGHT CAME ON CLIMB. FLIGHT RETURNED TO AUS LANDING SAFELY. MAINTENANCE REPLACED #1 INTEGRATED DRIVE GENERATOR (IDG) PER AMM 24-11-11.SDR AALA202306194626Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED FORWARD OUTBOARD FLIGHT ATTENDANT JUMSEAT EMERGENCY FLASHLIGHT AND HOLDER ASSEMBLY PER AMM 25-64-00. OPERATION CHECKS GOOD.SDR AALA202306198262Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR HARD TO OPEN. LUBRICATED DOOR LOCK MECHANISM.SDR AALA202306196022Housing · inoperativeAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 33C INOPERATIVE. REMOVED AND REPLACED ESCAPE PATH LIGHT HOUSING AT SEAT 33C.SDR AALA202306161208Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL UPPER SURFACE SCREW HOLE LOCATED AT BS 320 AND LBL 47.0. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202306168498Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERCOSTAL UPPER SURFACE AT FASTENER HOLE LOCATED FROM BS 312 TO BS 328 AT RBL 31.0. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202306169630Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND INNER CHORD LOCATED AT BS 992 AND RBL 46.0. REPLACED CHORD SRM PER 51-40-02-0G.SDR AALA202306167290Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 REPAIR 1.SDR AALA202306271270Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FLAT CEILING MOUNTED EMERGENCY AISLE LIGHT AT ROW 19 INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202306161270: ACCOMPLISHED SPLICE REPAIR OF EMERGENCY LIGHT WIRING ABOVE CEILING LIGHT ASSEMBLY ROW 19.** (CLOSED)SDR AALA202306163629Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STRINGER CLIP LOCATED AT BS 5OOH AND S18R. REPLACED CLIP PER SRM 51-40-02-0G.SDR AALA202306168226Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STRINGER CLIP LOCATED AT BS 500G AND S25R. REMOVED, FABRICATED, AND INSTALLED CLIP PER SRM 51-40-02-0G.SDR AALA202306161278Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP LOCATED AT BS 500H AND S25R. REPLACED CLIP PER SRM 51-40-02-0G.SDR AALA202306161280Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500E TO BS 500I AT S25R. REMOVED, FABRICATED, AND INSTALLED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306161270Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FLAT CEILING MOUNTED EMERGENCY AISLE LIGHT AT ROW 19 INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306164742Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT WHEEL WELL VAPOR BARRIER WEB LOCATED AT BS 663.75 AT RBL 45.64. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 REPAIR 9 PAR 3B.SDR AALA202306168806Fan · odorAIRCRAFT WAS GROUNDED: BURNING ELECTRICAL SMELL. MAINTENANCE REPLACED LEFT AND RIGHT AIR RE-CIRCULATING FANS PER AMM 21-25-02. (AALA202306168806, AALA202306162838)SDR AALA202306162838Fan · odorAIRCRAFT WAS GROUNDED: BURNING ELECTRICAL SMELL. MAINTENANCE REPLACED LEFT AND RIGHT AIR RE-CIRCULATING FANS PER AMM 21-25-02. (AALA202306168806, AALA202306162838)SDR AALA202306211381Unknown · wornAIRCRAFT IN BASE MAINTENANCE: WEAR DAMAGE ON WING CENTER SECTION, ENVIRONMENTAL CONTROL SYSTEMS ACCESS DOOR LATCH, STRIKER PLATE CHORD LOCATED AT BS 545 AND RBL 40.9. REPAIRED CHORD PER SRM 57-10-13-2R-3.SDR AALA202306151320Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 430 AND S26R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306159161Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 500I AT 26L. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306150408Transition Panel · puncturedAIRCRAFT IN BASE MAINTENANCE: PUNCTURE IN FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500 TO BS 500A AT S26R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306147775Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 492 TO BS 500A AT S25R. REMOVED, FABRICATED, HEAT TREATED, AND REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202307055410Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD LOCATED AT BS 860, S25R, AND RBL 20. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1A.SDR AALA202306163183Tat Probe · faultyAIRCRAFT WAS GROUNDED: ON TAKEOFF LOST N1 REFERENCE READ OUT ON DISPLAYS, LOST FIRST OFFICERÏ¿½S FLIGHT DIRECTOR, AND AUTO THROTTLES FAILED. EMERGENCY DECLARED; FLIGHT RETURNED TO DFW LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202306153183: MAINTENANCE FOUNSDR AALA202306153281Light · unsecureAIRCRAFT WAS NOT GROUNDED: GROUND EMERGENCY LIGHTS AT ROW 8ABC BROKEN. **SUPPLEMENTAL REPORT FOR AALA202306133281: MAINTENANCE FOUND LIGHT FUNCTIONAL. SECURED SEAT 8ABC EMERGENCY LIGHT TRIM PER CMM 25-23-67.** (CLOSED)SDR AALA202306153183Unknown · unknownAIRCRAFT WAS GROUNDED: ON TAKEOFF LOST N1 REFERENCE READ OUT ON DISPLAYS, LOST FIRST OFFICERÏ¿½S FLIGHT DIRECTOR, AND AUTO THROTTLES FAILED. EMERGENCY DECLARED; FLIGHT RETURNED TO DFW LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306148329Bulkhead Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1016 FROM LBL 26.96 TO LBL 40. REMOVED, FABRICATED, AND INSTALLED LOWER WEB PER SRM 51-40-02-0G.SDR AALA202306149995Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1016 FROM RBL 56.98 TO RBL 16.73. REMOVED, FABRICATED, AND INSTALLED LOWER WEB PER SRM 51-40-02-0G.SDR AALA202306140119Unknown · unknownAIRCRAFT WAS GROUNDED: SMOKE / FUME IN AFT GALLEY AND LAST 3 ROWS OF MAIN CABIN OCCURRED AT CRUISE. EMERGENCY DECLARED; FLIGHT DIVERTED TO CUN LANDING SAFELY. MAINTENANCE ACCOMPLISHED JOB CARD 08L00021001 AND FOUND NO EVIDENCE OF ODOR.SDR AALA202306147817Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR, WHITE ROLLER IS LOOSE AND SLIDES OFF. REPLACED L1 DOOR GIRT BAR RELEASE STOP.SDR AALA202306141370Intercostal · crackedAIRCRAFT IN BASE MAINTENANCED: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 440 TO BS 460 AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202306133281Unknown · unknownAIRCRAFT WAS NOT GROUNDED: GROUND EMERGENCY LIGHTS AT ROW 8ABC BROKEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202307316682Windshield · crackedAIRCRAFT WAS NOT GROUNDED: CAPTAIN'S L1 WINDOW HAS DEEP CRACK INSIDE PANE LOWER CENTER. **SUPPLEMENTAL REPORT FOR AALA202306136682: L1 WINDSHIELD REPLACED PER JOB CARD 08C21156001.** (CLOSED)SDR AALA202307058214Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 747 TO BS 807 AT LBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202307055237Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 480 TO BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 51-00-05-0G.SDR AALA202307050045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 727I AT LBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202307050050Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 490 TO BS 500 AT S26R. REPLACED TRANSITION PANEL PER SRM 50-30-15.SDR AALA202307053422Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM LOCATED AT BS 986.5 AND S46L. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-6.SDR AALA202307051960Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN ENTRY AREA FLOORBEAM LOCATED AT BS 312 AND LBL 15. REPAIRED FLOORBEAM PER SRM 53-10-51-2R-15.SDR AALA202306264794Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 CREASE ANGLE LOCATED FROM BS 294 TO BS 338, S17R, AND RBL 54. REPLACED CREASE ANGLE PER SRM 53-10-15-1A-2.SDR AALA202306264457Power Port · crushedAIRCRAFT WAS GROUNDED: ELECTRICAL BURNING SMELL AT ROWS 10-11. MAINTENANCE FOUND POWER PORT BOX AT SEAT 10ABC CRUSHED. **SUPPLEMENTAL REPORT FOR AALA202306134457: REPLACED SEAT ROW 10ABC PER AMM 25-22-00.** (CLOSED)SDR AALA202306216924Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCED: CORROSION ON FORWARD CARGO DOOR SILL WEB LOCATED FROM BS 440 TO BS 492 AT S25R, LBL 32. REPLACED WEB PER AARD 51-00-10-05-1.SDR AALA202306218960Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT BS 986.5 AND RBL 46. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE REPAIR 4.SDR AALA202306217723Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCED: CORROSION ON FLOOR BOARD SUPPORT ANGLE LOCATED AT BS 995 AT RBL 46. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1 AND DWG 147A5700.SDR AALA202306131205Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: DURING GATE ARRIVAL FLIGHT ATTENDANT REPORTS L1 SLIDE PACKAGE FELL OUT AS DOOR WAS OPENING. DOOR WAS HALF WAY OPEN WITH SLIDE PACKAGE RESTING ON DOOR SILL. INSTALLED DOOR SLIDE.SDR AALA202306139556Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR STUCK. ADJUSTED R1 DOOR GIRT BAR.SDR AALA202306132922Oven · odorAIRCRAFT WAS GROUNDED: DURING DESCENT, BURNING SMELL. IN COCKPIT AND CABIN. MAINTENANCE FOUND FOOD DEBRIS IN FORWARD GALLEY LEFT HAND OVEN. CLEANED AND RAN OVEN. NO DEFECTS OR SMELL NOTED.SDR AALA202306136682Unknown · unknownAIRCRAFT WAS NOT GROUNDED: CAPTAIN'S L1 WINDOW HAS DEEP CRACK INSIDE PANE LOWER CENTER. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306137117Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT LED DOES NOT FLASH, FLIGHT ATTENDANT 1L AISLE. REPLACED 1L DOOR EMERGENCY FLASHLIGHT.
Back to Boeing 737-823