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 AALA202507216291Sign · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 20C EMERGENCY EXIT LIGHT HANGING DOWN BY THE WIRES. RESECURED EMERGENCY LIGHT AT 20C. PER AMM 33-50-00.SDR AALA202507213808Sign · detachedAIRCRAFT WAS NOT GROUNDED: 1L DOOR EXIT SIGN BROKEN AND DETACHED. SECURED LIGHT PER FIM 33-50-00 810- 801. EMERGENCY LIGHTS CHECK.SDR AALA202507217411Bear Strap · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR UPPER FORWARD CUTOUT CORNER BEAR STRAP AT BS 294 FROM S8R TO S9R. REPARED BEAR STRAP PER EA 365781 AND SRM 53-10-01-2R PROCEDURE 6.SDR AALA202508251126Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 315 TO BS 328 AT RBL 57. REPLACED CHORD PER AARD 51-00-05-1 AND EA 366840.SDR AALA202508221722Door Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SURROUND STRUCTURE FRAME CHORD LOCATED AT BS 343, LBL 42. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508050862Spring · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER ELEVATOR TAB CONTROL MECHANISM SPRINGS LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND REPLACED RIGHT HORIZONTAL STABILIZER ELEVATOR TAB CONTROL MECHANISM SPRINGS LOWER HARDWARE AND PERFORMED SSDR AALA202508056420Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 787 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202508010125Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER S27L AT BS 847. REPAIRED STRINGER PER SRM 53-00-03-1A-1 AND EA 366755.SDR AALA202508018925Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER CLIP AT BS 927, S27L, LBL 11. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA202508012756Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY AT BS 727A PLUS 11 INCHES AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508012221Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY AT BS 727D PLUS 8 INCHES AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508015822Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 727B TO BS 727D AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508019016Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 727G TO BS 727H AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508012053Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 727I TO BS 747 AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508014716Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 747 TO BS 767 AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202507284677Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 767 AT S25R, RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202507210805Emer Light Sys · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ON SIDEWALL AT 16A HAS FALLEN OFF. RESECURED PER FIM 33-50-00-810-801.SDR AALA202507217156Life Vest · openAIRCRAFT WAS NOT GROUNDED: LIFE VEST AT FLIGHT ATTANDENT AFT SERVICE DOOR JUMP SEAT SEAL OPENED. REMOVED AND REPLACED 4R FLIGHT ATTANDENT JUMPSEAT LIFE VEST. PER CMM DBF200.SDR AALA202507210905Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORTS THAT LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBEDDOOR. PER GPM 17-11-4.SDR AALA202507210408Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS JAMMED. LUBED AFT LEFT LAVATORY DOOR.SDR AALA202507211342Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: ONE EMERGENCY EXIT BULB INOPERATIVE AT AFT EMERGENCY EXIT DOOR AT ROW 16ABC. REMOVED AND REPLACED LEFT HAND FORWARD OVER WING EMERGENCY EXIT LIGHT. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202507217366Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: TWO EMERGENCY EXIT BULBS INOPERATIVE AT FORWARD OF EMERGENCY EXIT DOOR AT ROW 16ABC. REMOVED AND REPLACED EMERGENCY EXIT LIGITHING PANEL. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202508256023Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 23L CHORD LOCATED FROM BS 334 TO BS 351 AT LBL 42. REPLACED CHORD PER EA 366749.SDR AALA202508255980Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 950, FROM LBL 27 TO LBL 50. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202508133188Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508130723Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947 RBL 53. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5 AND EA 366810 AND EA 366572.SDR AALA202508118526Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 8 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508116414Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508116233Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508114435Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508112753Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508118052Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508079012Attach Fitting · wornAIRCRAFT IN BASE MAINTENANCE: NUMBER 2 TRANSMISSION ATTACH FITTING MOUNTING BOLTS ARE WORN AT TRACK MOUNTS. INSTALLED AND REAMED NUMBER 2 AFT TRACK FORWARD AND AFT TRANSMISSION ATTACH SUPPORT FITTING BUSHINGS. PER SOPM 20-50-03.SDR AALA202508054584Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE FROM BS 380 TO BS 400 AT RBL 10. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202508058956Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE FROM BS 380 TO BS 400 AT BL 0. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202508052179Panel · separatedAIRCRAFT IN BASE MAINTENANCE: PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 520, RBL 42 IS SEPARATED. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202508058819Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 500I TO BS 520 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508057585Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CHORD) AROUND LAVATORY MOUNT AT STA 947, LBL 23.5 REPAIRED UPPER CHORD PER SRM 53-70-51 AND EA 366572SDR AALA202508013327Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 986, RBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202508017803Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 847 AT S25L, LBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202507319800Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AFT LAVATORY VENT LOCATED AT THE SIDE FUSELAGE BS 920 BETWEEN STR 21L TO 22L. INSTALLED DOUBLER REPAIR ON SKIN. PER EA 366657 AND SRM 51-10-01, FIGURE 2.SDR AALA202507250856Fuel Panel · faultedAIRCRAFT WAS NOT GROUNDED: IN FLIGHT RIGHT AFTER FUEL LOW PRESSURE LIGHT ILLUMINATED STEADY FOR SEVERAL MINUTES AND DID NOT EXTINGUISH. VERIFIED RIGHT AFT BOOST PUMP INOPERATIVE. REMOVED AND REPLACED P5 PANEL ASSEMBLY. PER AMM 28-22-43.SDR AALA202507255446Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTANDENT SEAT BY L2 AFT SERVICE DOOR OUTBOARD HAS ONE EACH FLASHLIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202507185446): REMOVED AND REPLACED FLIGHT ATTANDENT AFT SEAT FLASHLIGHT. PER AMM 25-64-00.SDR AALA202507241913Bracket · looseAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EMERGENCY EXIT DOOR FRAME BRACKET LOOSE AT TOP OF OPENING. REATTACHED EMERGENCY DOOR BRACKET TO THE DOOR FRAME. PER AMM 52-22-00.SDR AALA202507225665Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT HAND DOOR EMERGENCY EXIT SIGN DOES NOT ILLUMINATE RECONNECTED EMERGENCY LIGHT CONNECTOR. OPS CHECK GOOD. AMM 33-51-00.SDR AALA202507180856Pump · inoperativeAIRCRAFT WAS NOT GROUNDED: IN FLIGHT RIGHT AFTER FUEL LOW PRESSURE LIGHT ILLUMINATED STEADY FOR SEVERAL MINUTES AND DID NOT EXTINGUISH. VERIFIED RIGHT AFT BOOST PUMP INOPERATIVE. (OPEN).SDR AALA202507185446Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDENT SEAT BY L2 AFT SERVICE DOOR OUTBOARD HAS ONE EACH FLASHLIGHT INOPERATIVE. (OPEN).SDR AALA202507184746Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: THE COCKPIT DOOR WAS CLOSED AND LOCKED UPON ARRIVAL. UNABLE TO OPEN DOOR WITH CODE DESPITE MULTIPLE ATTEMPTS. CALLED MAINTENANCETO DISASSEMBLE THE DOOR TO GAIN ENTRY. RESET ELECTRIC POWER TO FLIGHT DECK DOOR ELECTRIC LATCH. PER AMM52SDR AALA202507180675Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN AND CLOSE. READJUSTED FORWARD LAVATORY DOOR AS REQUIRED, OPERATIONAL CHECK GOOD.SDR AALA202507183822Lockpin · installedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NOSE GEAR DID NOT RETRACT ON TAKEOFF, NOSE GEAR WARNING LIGHT WITH HANDLE UP.AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CTL. REMOVED LANDING GEAR PIN FROM NOSE LANDING GEAR AND PERFORMED BITE
Back to Boeing 737-823