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 AALA202402127948Tube · missingAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR MISSING RED BAND ON AFT END. INSTALLED NEW RED BAND ON AFT END OF GIRT BAR.SDR AALA202402093801Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT RIGHT HAND NUMBER 2 EMERGENCY FLASHLIGHT INDICATION BLINKING RED. REMOVE AND REPLACED AFT RIGHT HAND NUMBER 2 EMERGENCY FLASHLIGHT BATTERY. PER AMM 25-64-00. OPERTIONAL CHECK GOOD.SDR AALA202402151692Pressure Deck · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB AT BS 663.75, FROM LBL 24.92 TO LBL 31.83. REPAIRED WEB PER SRM 57-10-10-2R-3 ALTERNATIVE 3.SDR AALA202402146152Threshold · out of toleranceAIRCRAFT WAS GROINDED: AFT LEFT SIDE LAVATORY DOOR HARD TO OPEN AND CLOSE. REPLACED THRESHOLD ((AALA202402096152) AND TRIM PIECE (AALA202402144724)) AS REQUIRED. PER AMM 25-40-14. OPERATES FREELY AND PROPERLY.**(CLOSED).SDR AALA202402144724Trim Panel · out of toleranceAIRCRAFT WAS GROINDED: AFT LEFT SIDE LAVATORY DOOR HARD TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT FOR (AALA202402096152): REPLACED THRESHOLD ((AALA202402096152) AND TRIM PIECE (AALA202402144724)) AS REQUIRED. PER AMM 25-40-14. OPERATES FREELY AND PROPERLY.**(CLOSDR AALA202402123345Stop Fitting · looseAIRCRAFT IN BASE MAINTENANCE: RIGHT FORWARD OVERWING EMERGENCY EXIT FORWARD UPPER DOOR STOP FITTING BOLT ROTATES BY HAND AND LOOSE. RETOURQUED RIGHT FORWARD OVERWING EMERGENCY EXIT FORWARD UPPER DOOR STOP FITTING BOLT. PER B737-MAX AMM 52-22-00-820-801 STEP F(SDR AALA202402125482Transmitter · faultyAIRCRAFT WAS NOT GROUNDED: FUEL FLOW INDICATOR LEFT ENG FLUCTUATES FROM NORMAL TO ZERO AND OCCASIONALLY BLANKS OUT. NUMBER 1 FUEL FLOW TRANSMITTER REPLACED. PER AMM 73-31-01 OPERTIONAL AND LEAK CHECK NORMAL.SDR AALA202402129240Pressure Switch · faultyAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT FUEL PUMP DOES NOT ILLUMINATE WHEN TURNED OFF THE BULB TESTS GOOD. REMOVED AND REPLACED AFT LEFT HAND FUEL PUMP PRESSURE SWITCH. PER AMM 28-42-11**(CLOSED).SDR AALA202402099240Pump · malfunctionedAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT FUEL PUMP DOES NOT ILLUMINATE WHEN TURNED OFF THE BULB TESTS GOOD.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402098856Handle · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT REPORTS AFT RIGHT LAVATORY INSIDE DOOR HANDLE BROKEN. SECURED AFT RIGHT LAVATORY DOOR HANDLE. PER AMM 25-40-00.SDR AALA202402093231Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUTOUT WEB AT BS 829, S17R. REMOVED, FABRICATED, AND INSTALLED WEB PER SRM 51-40-02-0G.SDR AALA202402095488Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727J TO BS 767, S25L. REMOVED, FABRICATED, AND INSTALLED TRANSITION PANEL PER SRM 51-40-02-0.SDR AALA202402093469Flashlight · no testAIRCRAFT WAS NOT GROUNDED: 3 AFT FLIGHT ATTENDANT FLASHLIGHTS WILL NOT TEST. REMOVED AND REPLACE THREE (AALA202402093469), (AALA202402098067), (AALA202402098598) FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERIES. PER AMM 25-64-00.SDR AALA202402098598Flashlight · no testAIRCRAFT WAS NOT GROUNDED: 3 AFT FLIGHT ATTENDANT FLASHLIGHTS WILL NOT TEST. REMOVED AND REPLACE THREE (AALA202402093469), (AALA202402098067), (AALA202402098598) FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERIES. PER AMM 25-64-00.SDR AALA202402098067Flashlight · no testAIRCRAFT WAS NOT GROUNDED: 3 AFT FLIGHT ATTENDANT FLASHLIGHTS WILL NOT TEST. REMOVED AND REPLACE THREE (AALA202402093469), (AALA202402098067), (AALA202402098598) FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERIES. PER AMM 25-64-00.SDR AALA202402096152Door · bindingAIRCRAFT WAS GROINDED: AFT LEFT SIDE LAVATORY DOOR HARD TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402094257Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR ON LAVATORY D IS HARD TO OPEN AND CLOSE. LUBED BI-FOLDING DOOR AT LAVATORY D.SDR AALA202402095984Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER AND WIRES DANGLING DOWN AT ROW 18 ABC. REINSTALLED EMERGENCY AISLE LIGHT AT SEAT 18 ABC. LIGHT TEST OK. PER AMM33-51-11.SDR AALA202402090073Slide · looseAIRCRAFT WAS NOT GROUNDED: SLIDE BUSTLE ON R2 DOOR IS LOOSE. INSPECTED AND SECURED DOOR SLIDE COVER ON THE R2 DOOR. PER AMM 25-66-01.SDR AALA202402092230Door · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPERATE. ACCOMPLISHED REPAIR PER AARD 25-40-10-10 LAVATORY DOOR HINGE REPAIR 10.SDR AALA202403066471Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND HORIZONTAL STABILIZER REAR SPAR LOWER LUG AT BS 1130, RBL 20. BLENDED LUG PER EA 353168.SDR AALA202402083760Sliding Window · unsecureAIRCRAFT WAS GROUNDED: CAPTAINS SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. RESECURED PLASTIC TRIM TO CLEAR SLIDING WINDOW TRACKS AS REQUIRED. SLIDING WINDOW OPERATES SMOOTHLY AT THIS TIME.SDR AALA202402089780Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB VERTRICAL STIFFENER AT STABILIZER STA 110.10, REPLACED RIB PER 51-40-02-0G.SDR AALA202402079890Transition Panel · unknownAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727C TO BS 747, FROM LBL 21 TO RBL 21. INSTALLED REINFORCEMENT REPAIR PER EA 350710.SDR AALA202402143376Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727F TO BS 727G, S25R. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402146482Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727F TO BS 727G, S25L. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402088669Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 947.5, LBL 24. REMOVED, FABRICATED, AND INSTALLED CHORD PER SRM 51-40-02-0G.SDR AALA202402081450Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT BS 986.5, FROM LBL 24 TO LBL 29. REMOVED, FABRICATED, AND INSTALLED FLOOR BEAM SECTION PER SRM 51-40-02-0G.SDR AALA202402072409Slide · not seatedAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE NOT SEATED. RE-SEATED L1 DOOR SLIDE. PER AMM 25-66-01.SDR AALA202402077596Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR AIRCRAFT LEFT IS DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED LAVATORY D DOOR. PER CMM 25-40-64.SDR AALA202402070942Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR BINDING ON FLOOR. ADJUSTED LEFT AFT LAVATORY BI-FOLD DOOR HINGE. PER CMM 25-40-64.SDR AALA202402076211Slide · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR EMERGENCY SLIDE IS PROTRUDING OUT OF IT'S STORAGE BAG. RE-POSITIONED FORWARD SERVICE DOOR SLIDE IN COVER. PER AMM 25-66-01.SDR AALA202402079323Pin · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT FOUND A PIN DOOR SLIDE INSTALLATION IN AIRCRAFT BY DOOR R1. INSTALLED R1 DOOR SLIDE SAFETY PIN INTO POCKET AS REQUIRED. PER AMM 25-66-01.SDR AALA202402077665Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN AT R1 DOOR HAS INOPERATIVE LAMPS. RE-LAMPED R1 DOOR EMERGENCY EXIT SIGN. FUNCATIONAL CHECK GOOD. PER 33-51-01.SDR AALA202402071145Girt Bar · out of adjustAIRCRAFT IN BASE MAINTENANCE: R2 DOOR SLIDE CATCHES AND DRAGS ON DOOR SILL. ADJUSTED R2 DOOR SLIDE GIRT BAR HOLD UP BRACKETS'. PER AMM 25-66-01.SDR AALA202402075398Door · out of adjustAIRCRAFT IN BASE MAINTENANCE: LAVATORY-A DOOR DRAGS ON LOWER AFT CORNER. ADJUSTED DOOR AS REQUIRED. FUNCATIONAL CHECK GOOD. PER CMM 25-45-46.SDR AALA202402075607Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER VISUAL INDICATION OF A CRACK IN LOWERSKIN AT STABILIZER BS 101.90 LOCATED 9 INCHES FROM THE AFT SPAR. FABRICATED DOUBLER PER SRM 55-10-01-2R REPAIR 11 INSTALLED DOUBLER. PER SRM 55-10-01-2R REPAIR SDR AALA202402072371Bulkhead Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT BULKHEAD LOWER WEB AT STA 1016, RBL 38. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202402079783Bulkhead Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT BULKHEAD LOWER WEB AT STA 1016, LBL 38. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202402073371Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT STA 987, RBL 34. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202402070415Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947 TO BS 967, RBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202402073429Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR STRUCTURE BREAK ASSEMBLY AT BS 540, LBL 0. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA202402070780Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BREAK ASSEMBLY AT BS 540, RBL 0. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA202402067206Hinge Pin · missingAIRCRAFT WAS NOT GROUNDED: DURING WALK AROUND FOUND FOWARD ENTRY DOOR HINGE PIN BOTTOM SCREW MISSING, LATCH RELEASE LEVER IS STICKING. REMOVE AND REPLACED HINGE PIN AND SCREW ASSEMBLY. PER AARD 52-10-00-4.SDR AALA202402144223Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727G TO BS 727H, S25L. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402144071Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727G TO BS 727H, S25R. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402143337Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727E TO BS 727F, S25L. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402142063Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727E TO BS 727F, S25R. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402140678Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727B TO BS 727C, RBL 20. BLENDED CORROSION PER SRM 51-10-02-0G.SDR AALA202402146116Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500I, S25R. BLENDED CORROSION PER AMM 51-00-53-201.
Back to Boeing 737-823