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 AALA202107237615Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING PS CHECK FOUND EMERGENCY LIGHTS AT ROWS 28,29,30,31,32 AND 33 ABC INOPERATIVE. ACCOMPLISHED FIM 33-50-00. FOUND EMERGENCY LIGHT CANNON PLUG DISCONNECTED AT ROW 28ABC. RECONNECTED AND SECURED PLUG IAW AMM 33-51-06.SDR AALA202107277247Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: EXTERNAL POWER DOOR CUTOUT DOUBLER CRACKED. REPLACED DOUBLER PER SRM 51-40-02 AND DWG 141A3702.SDR AALA202107264954Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT BETWEEN STA 787 AND 907 RIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY. (STA 787 AND 907 RIGHT) PER B737NG AMM 33-51-03.SDR AALA202107230043Housing · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 33C IS LOOSE. SECURED ESCAPE PATH LIGHT HOUSING IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202107224137Door · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR IN FORWARD CABIN IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR PER AMM 52-05-03.SDR AALA202107227889Light · brokenAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT LIGHT COVER BROKEN. REPLACED EMERGENCY EXIT LIGHT OPERATIONS CHECK GOOD PER AMM 35-51-11.SDR AALA202107221124Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: AT BEGINNING OF TAKE OFF ROLL BOTH RIGHT AFT AND FWD OVERWING EXIT LIGHTS ILLUMINATED. FOUND CIRCUIT BREAKER D1 ON P6-2 OUT. RESET CIRCUIT BREAKER PER AMM 20-60-01-2 AND PER FIM 32-09-00-810-801. SYSTEM CHECKED GOOD. LIGHTS ARE OUT. SDR AALA202107223583Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT GUIDE LIGHT AT 9C FELL OFF. SECURED EMERGENXY FLOOR LIGHT ON SEAT 9C REF AMM 33-51-11.SDR AALA202107220445Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR 1L GUST LOCK VERY DIFFICULT TO CLOSE. LUBED LOCK MECHANISM AS REQUIRED. OPS CHECK NORMAL.SDR AALA202108175978Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT STA 986.5 AND LBL 44, MEASURING L=1.50 IN, W=1.00 IN, D=0.023 IN. REPAIRED PER SRM 53-70-51 AND EA 329364.SDR AALA202108101338Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB LOCATED AT STA 986.5 AND LBL 43. REPAIRED PER EA 329366.SDR AALA202108097973Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF SHEAR WEB AT STA 992 AND RBL 31, MEASURING L=1.0 IN, W=1.0 IN, D=0.009 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW EA 329311.SDR AALA202107275199Structure · crackedAIRCRAFT IN BASE MAINTENANCE: BRAKE ASSEMBLY CRACKED AT STA 540, RIGHT BUTT LINE 35 TO RIGHT BUTT LINE 45. REMOVED AND REPLACED BRAKE ASSEMBLY PER SRM 51-40-02.SDR AALA202107218911Lanyard · unsecureAIRCRAFT WAS NOT GROUNDED: 16 A RED LANYARD COVER NOT SECURE AT OVERWING EXIT. RE SECURED LANYARD FOR OVERWING WINDOW EXIT AT 16A.SDR AALA202107213197Retainer · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY GIRT BAR CLIP LOOSE. REMOVED DEBRIS AND RESECURED GIRT BAR CLIP ON L1 DOOR PER AMM 25-66-01.SDR AALA202107210647Rail · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY 4 DOOR STICKS CLOSED. UPPER RAIL BINDING. ADJUSTED RAIL.SDR AALA202107212838Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LOCK DIFFICULT TO OPERATE. CLEANED AND LUBRICATED DOOR LOCK PER AMM 25-40-14.SDR AALA202107211952Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL LOCATED AT STA 325 AND LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202107212240Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL LOCATED AT STA 285 AND RBL 1. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202108165666Keelbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: TIME LIMITED REPAIR MADE TO LOWER SURFACE OF KEEL BEAM FOR CORROSION AT STA. 649. REPAIR ACCOMPLISHED ON EA 329124. **SUPPLEMENTAL REPORT FOR AALA202107215666: CURRENT STATUS OF REPAIRS HAS BEEN CLASSIFIED AS PERMANENT, NO ADDITISDR AALA202107266103Cover · brokenAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY TRIM LIGHT COVER BROKEN ON ROW 30 C,B,A. **SUPPLEMENTAL REPORT FOR AALA202107216103: REMOVED AND REPLACED AT SEAT ROW 30CBA EMERGENCY TRIM LIGHT COVER PER AMM 25-21-00.** (CLOSED)SDR AALA202107215106Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY SMOKE DETECTOR GOES OFF COMES ON INTERMITTENTLY. NO SIGN OF SMOKE IN LAVATORY OR TRASH CAN COMPARTMENT. REPLACED FORWARD SMOKE DETECTOR PER AMM 26-14-01.SDR AALA202107215666Keelbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: TIME LIMITED REPAIR MADE TO LOWER SURFACE OF KEEL BEAM FOR CORROSION AT STA. 649. REPAIR ACCOMPLISHED ON EA 329124. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202107201651Sensor · inoperativeAIRCRAFT WAS GROUNDED: LEADING EDGE SLAT POSITION FOUR REMAINED ILLUMINATED AFTER FLAP RETRACTION. CREW DECLARED EMERGENCY AND RETURNED TO PHL. REMOVED AND REPLACED #4 LEADING EDGE FLAP RETRACT AND EXTENDED SENSOR. OPS CK GOOD AMM 27-88-11SDR AALA202107207355Retainer · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR CLIP AT DOOR 1L IS LOOSE. SECURED CLIPS PER AMM 25-66-01.SDR AALA202107260283Shroud · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 14C. **SUPPLEMENTAL FOR AALA202107200283: REPLACED SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202107266091Shroud · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 19C. **SUPPLEMENTAL FOR AALA202107206091: REPLACED SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202107261523Shroud · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER IS OFF AT SEAT 10C. **SUPPLEMENTAL REPORT FOR AALA202107211523: REMOVED AND REPLACED SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202107211523Lens · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER IS OFF AT SEAT 10C. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202107203528Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR STUCK IN ACTUAL DOOR. UNABLE TO FREE GIRT BAR. RESECURED GIRT BAR ON GIRT BAR RETAINER CLIPS ON DOOR PER AMM 25-66-01.SDR AALA202107201338Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOR LIGHT AT SEAT 23C LOOSE. SECURED LIGHT PER AMM 33-51-11.SDR AALA202107207198Connector · unsecureAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT EMERGENCY EXIT WINDOW LIGHT IS INOPERATIVE. SECURED LIGHT CONNECTOR PER AMM 33-51-00.SDR AALA202107207670Lamp · no testAIRCRAFT WAS NOT GROUNDED. RIGHT HAND AFT SLIDE OVERWING LIGHT INOPERATIVE. REPLACED LIGHT LAMP PER AMM 33-51-04.SDR AALA202107200283Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 14C. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202107206091Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 19C. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202107192750Slide · inoperativeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE LATCH ASSEMBLY REQUIRES REPLACEMENT. REPLACED SLIDE.SDR AALA202107260994Cover · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 30C ESCAPE PATH LIGHT COVER DAMAGED/LOOSE. **SUPPLEMENTAL REPORT FOR AALA202107210994: ADJUSTED ESCAPE PATH LIGHT COVER AS PER ESO 61106.** (CLOSED)SDR AALA202107237141Cover · brokenAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY TRIM LIGHT COVER BROKEN ON ROW 26 CBA. REMOVED AND REPLACED EMERGENCY LIGHT TRIM COVER IAW AMM 33-51-11.SDR AALA202107230939Cover · brokenAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY TRIM LIGHT COVER BROKEN ON ROW 21 CBA. REMOVED AND REPLACED EMERGENCY LIGHT TRIM COVER IAW AMM 33-51-11.SDR AALA202107233355Cover · missingAIRCRAFT WAS NOT GROUNDED: 13C AISLE EXIT LIGHT COVER CAME OFF. REMOVED AND REPLACED 13C AISLE EXIT LIGHT COVER IAW CMM 25-23-67,SDR AALA202107206409Light · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 10C ESCAPE PATH LIGHT COVER DAMAGED. RE INSTALLED LIGHT ASSEMBLY AND OPERATIONS CHECK OK PER AMM 33-51-14.SDR AALA202107193355Light · unknownAIRCRAFT WAS NOT GROUNDED: 13C AISLE EXIT LIGHT COVER CAME OFF. **SUPPLEMENTAL INFORMATION WILL BE SUBMITTED.** (OPEN)SDR AALA202107211008Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK WAS FOUND AROUND SCREW HOLE OF INTERCOSTAL LOCATED AT STA 325, WATERLINE 0 AND BUTTLNE 32. INSTALLED NEW INTERCOSTAL WITH FAYING SURFACE SEALANT AND WET FASTENERS PER AMM 51-31-00 AND SRM 51-40-02.SDR AALA202107208364Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WHEEL WELL FORWARD BULKHEAD VAPOR BARRIER WALL HAS 18 INCH CRACK. INSTALLED DOUBLER REPAIR REF 737 SRM 57-10-10-2R-2.SDR AALA202107209420Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT DETACHED AT SEAT 9C. SECURED LIGHT ASSEMBLY IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202107202286Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: LH AFT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00, OPS CHECK GOOD.SDR AALA202107206165Slide · displacedAIRCRAFT WAS NOT GROUNDED: SLIDE AT DOOR 1L SLIGHTLY VISIBLE BELOW COVER. SECURED SLIDE BELOW COVER IAW AMM 25-61-00.SDR AALA202107201952Lens · crackedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS CRACKED AT L2 DOOR. REPLACED LENS IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202107202865Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BROKEN AT DOOR 2R. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202107205216Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FWD EMERGENCY FLASHLIGHT BATTERY INOPERATIVE. REPLACED EMERGENCY FLASHLIGHT BATTERY IAW MCM WORKCARD 0094, OPS CHECK GOOD.
Back to Boeing 737-823