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 AALA202411120865Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787, RBL 26. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202411071266Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727J TO STA 747, RBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202411070724Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, LBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4 AND EA 359257.SDR AALA202411079387Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 727C, RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202411070075Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727G TO STA 727H, RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202411050646Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT FROM STA 957 TO STA 959, LBL 49. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411052362Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, RBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202410256103Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, RBL 45.64. REPAIRED CRACK PER SRM 57-10-10-2R-2.SDR AALA202410256207Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STUB BEAM AT STA 616, LBL 70.85. ACCOMPLISHED REPAIR PER EA 358007.SDR AALA202410257483Window · undertorquedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CLIMBING THROUGH FL 220, NOTICED WIRE AND STRING FLAPPING UP AGAINST CAPTAIN BOTTOM OF SIDE WINDOW. AT ABOUT 24,500 LOUD SQUEAL STARTED COMING FROM WINDOW AREA; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDESDR AALA202410254231Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT FLASH LIGHT BATTERY REQUIRES REPLACEMENT. REPLACED FLIGHT ATTANDENT FLASHLIGHT BATTERY. PER AMM 25-64-00.SDR AALA202410258035Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT ADVISED CABIN MEGAPHONE INOPERATIVE. REPLACED BATTERIES IN MEGAPHONE, OPERTIONAL CHECK.SDR AALA202411269348Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO TRANSITION PANEL LOCATED FROM STA 400 TO STA 500I, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202411085910Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM STA 400 TO STA 500I, RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202410256124Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: WHEN ATTEMPTING TO OPEN FLIGHT DECK DOOR AT ABOUT HALFWAY OPEN. IT GETS STUCK AND NEED A GOOD PUSH TO OPEN FULLY. LUBRICATED COCKPIT DOOR STOP ASSEMBLY. ACCOMPLISHED DOOR LATCH ASSEMBLY OPERTIONAL CHECK, PER AMM 52-51-02.SDR AALA202410259195Guide · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR INOPERATIVE RAILS ARE EXTREMELY STIFF, PAX ALMOST GOT STUCK INSIDE. LUBED LAVATORY-D DOOR GUIDE AND PERFORMED OPERTIONAL TEST OF DOOR, OPERTIONAL CHECK GOOD. PER MM 25-41-00.SDR AALA202410255339Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 25C EMERGENCY EXIT LIGHTING LIGHT FELL OFF AND CANNOT BE PUSHED BACK IN. ADJUSTED AND SECURED SEAT 25C EMERGENCY LIGHT AND EPL SHROUD ASSEMBLY. PER CMM 25-23-67.SDR AALA202410240135Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EXTERNAL POWER DOOR LOWER CUTOUT SURROUND DOUBLER LOCATED FROM STA 229 TO STA 235.8, FROM S21R TO S22R. REPAIRED DOUBLER PER SRM 53-10-15-2R-4.SDR AALA202411069419Skin · 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 AALA202410256677Gusset · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT AFT BULKHEAD GUSSET AT STA 500I, S18R. REPLACED GUSSET PER AARD 51-00-05-1.SDR AALA202410251364Unknown · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT INFORMED US THAT THERE WAS A "FUEL OR BUTANE" SMELL IN MID-CABIN DURING CLIMB OUT. THEY SEARCHED THE OVERHEAD BINS AND SMELL WAS PREVALENT IN BINS 12 THROUGH 16 AIRCRAFT RIGHT. SMELL LASTED ABOUT 5 MINS AND DISSIPATED. TSDR AALA202410259874Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAV DOOR GETS STUCK IN FLIGHT AND IS DIFFICULT TO OPERATE. **SUPPLEMENTAL REPORT (AALA202410239874): REMOVED AND REPLACED AFT LEFT HAND LAVATORY DOOR. OPERTIONAL CHECK GOOD. PER CMM 25-40-64**(CLOSED.SDR AALA202410233331Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 DOOR EXTERIOR SLIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED R2 DOOR SLIDE LIGHT, OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202410238225Battery · no testAIRCRAFT WAS NOT GROUNDED: L1 DOOR JUMP SEAT LEFT HAND FLASHLIGHT BATTERY LOW. REMOVED AND REPLACED FLASHLIGHT BATTERY AT L1 DOOR JUMP SEAT LEFT HAND SIDE. PER AMM 25-64-00.SDR AALA202410239874Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAV DOOR GETS STUCK IN FLIGHT AND IS DIFFICULT TO OPERATE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202410237043Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED AFT LEFT LAVATORY DOOR TRACK DOOR OPERATES FREELY NOW.SDR AALA202410230789Unknown · odorAIRCRAFT WAS GROUNDED: UNUSUAL SMELL ON ENGINE START, ONLY IN COCKPIT, DISSIPATED AFTER START BUT THEN RETURNED IN DESCENT AND UPON LANDING FOR MOST OF THE TAXI IN. ACCOMPLISHED J/C 08L00021001, NO SMELL NOTED. NO LEAKS AND OPERTIONAL CHECK GOOD, NO FAULT FOUNSDR AALA202410231364Unknown · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT INFORMED US THAT THERE WAS A "FUEL OR BUTANE" SMELL IN MID-CABIN DURING CLIMB OUT. THEY SEARCHED THE OVERHEAD BINS AND SMELL WAS PREVALENT IN BINS 12 THROUGH 16 AIRCRAFT RIGHT. SMELL LASTED ABOUT 5 MINS AND DISSIPATED. TSDR AALA202410231436Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE TO AFT CARGO COMPARTMENT FLOOR SUPPORT FROM STA 747 TO STA 767, RBL 3. REPAIRED FLOOR SUPPORT PER SRM 53-00-53-2R-2.SDR AALA202410231878Unknown · fumesAIRCRAFT WAS GROUNDED: ON DESCENT AND AT THE GATE FLIGHT ATTANDENT REPORTED A STRONG BURNING SMELL IN THE CABIN, THE ODOR LASTED ABOUT 5 MINUTES AND THEN WENT AWAY. THE FRONT OF THE CABIN HAD AN EXHAUST OR BURNING SMELL LIKE A MUSTY AND OILY SMELL. **SUPPLEMENSDR AALA202410221878Bleed Air Sys · odorAIRCRAFT WAS GROUNDED: ON DESCENT AND AT THE GATE FLIGHT ATTANDENT REPORTED A STRONG BURNING SMELL IN THE CABIN, THE ODOR LASTED ABOUT 5 MINUTES AND THEN WENT AWAY. THE FRONT OF THE CABIN HAD AN EXHAUST OR BURNING SMELL LIKE A MUSTY AND OILY SMELL. **SUPPLEMENSDR AALA202410227715Ground Wire · dislodgedAIRCRAFT WAS GROUNDED: GROUNDING WIRE PROTRUDING FROM LIFE RAFT BOX POSITION FOWARD SERVICE DOOR. REINSTALLED GROUNDING WIRE TO ESCAPE SLIDE PACK, AND COVER ON DOOR R1. PER AMM 26-66-01.SDR AALA202410228151Slide · faultedAIRCRAFT WAS NOT GROUNDED: L2 SIDE REQ'S REPLACAMENT DUE TO PRECAUTIONARY OF ISD. REMOVE AND REPLACED L2 SLIDE ASSEMBLY. PER J/C 08L22125001.SDR AALA202410236580Hydraulic Line · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC LOW PRESSURE LIGHT FOR ENGINE NUMBER 1 AFTER CAME ON AFTER TAKEOFF; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED NUMBER 1 ENGINE HYDRAULIC PRESSURE HOSE (AALASDR AALA202410234131Hose · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC LOW PRESSURE LIGHT FOR ENGINE NUMBER 1 AFTER CAME ON AFTER TAKEOFF; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED NUMBER 1 ENGINE HYDRAULIC PRESSURE HOSE (AALASDR AALA202410227907Lock · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK DIFFICULT TO MOVE. **SUPPLEMENTAL REPORT FOR (AALA202410217907): RESECURED SCREWS ON LAVATORY-D. LAVATORY-D DOOR LOCK OPERATIONAL CHECK GOOD. PER CMM 25-40-64**(CLOSED).SDR AALA202410211634Light · brokenAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT DOORWAY EMERGENCY EXIT SIGN LENS BROCKEN. REPLACED THE LEFT HAND AFT DOORWAY GALLEY MOUNTED EMERGENCY EXIT LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202410218997Handle · jammedAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D (LEFT SIDE) DOOR WILL NOT OPEN FULLY. REMOVED AND REPLACED THE INSIDE DOOR ASSIST HANDLE. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202410217907Lock · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK DIFFICULT TO MOVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202410214426Light · damagedAIRCRAFT WAS NOT GROUNDED: 16C EMERGENCY EXIT LIGHT FIXTURE DAMAGED. REPLACED SEAT 16C EMERGENCYEXIT LIGHT ASSEMBLY. OPERTIONAL CHECK NORMAL. PER AMM 33-51-11.SDR AALA202410215843Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN COVER MISSING IN AFT GALLEY ON TRHE LEFT SIDE. REPLACED EMERGENCY LIGHT. PER AMM 33-51-01.SDR AALA202410215476Controller · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT AT ROUGHLY 5000 FEET WE HAD THE MC AND EQUIP DOOR ILLUMINATE. IN ADDITION THE AIRCRAFT WAS NOT PRESSURIZING AT 8000 FEET. DESCENDED TO 4000 AND RAN QRH PROCEDURES; AIRCRAFT AIR INTERRUPTED BSDR AALA202410218477Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, RBL 31.83. REPAIRED CRACK PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202410181558Girt Bar · damagedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR, THE SLIDE GIRT ON THE LOWER SIDE THE MATERIAL IS SEPARATING. REPLACED AFT ENTRY DOOR SLIDE PER JOB CARD 08L22125001.SDR AALA202410185971Plate · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR GETS STUCK IN THE CLOSED POSITION. ADJUSTED FLOOR PLATE, OPERATION CHECKS NORMAL.SDR AALA202410182780Lamp · burned outAIRCRAFT WAS NOT GROUNDED: RIGHT AFT SLIDE/OVERWING EMERGENCY LIGHT BURNED OUT. RELAMPED RIGHT AFT SLIDE EMERGENCY LIGHT PER AMM 33-51-04.SDR AALA202410302498Door Frame · gougedAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME-MOUNTED LOWER LATCH TRACK FITTING HAS A GOUGE ON ROLLER TRACK AREA. REMOVED AND REPLACED FORWARD ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME-MOUNTED LOWER LATCH TRASDR AALA202410305079Door Frame · gougedAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY DOOR AFT FRAME-MOUNTED LOWER LATCH TRACK FITTING HAS A GOUGE, INBOARD LOWER CORNER. REMOVED AND REPLACED FORWARD GALLEY DOOR AFT FRAME-MOUNTED LOWER LATCH TRACK FITTING. PER B737-NG SRM 51-40-02-0G AND B737-NG SOPM SDR AALA202410306223Door Frame · gougedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME-MOUNTED UPPER LATCH TRACK FITTING HAS A GOUGE. REMOVED AND REPLACED AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME-MOUNTED UPPER LATCH TRACK FITTING. PER B737-NG SRM 5SDR AALA202410216015Starter · leakingAIRCRAFT WAS GROUNDED: STRONG MUSTY DIRTY SOCK SMELL, PERSISTED THROUGHOUT FLIGHT STRONG IN BACK BUT DISSIPATED FOR A LITTLE WHILE, BUT CAME BACK VERY STRONG DURING ARRIVAL. FLIGHT ATTANDENT NEEDED TO WEAR MASK. **SUPPLEMENTAL REPORT FOR (AALA202410176015): RE
Back to Boeing 737-823