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 AALA202308238662Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: MEGAPHONE IN FORWARD CLOSET INOPERATIVE. REMOVED AND REPLACED MEGAPHONE IN FORWARD CLOSET. PER AMM 25-64-00.SDR AALA202309138108Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR WEB LOCATED AT BS 988 AND RBL 33.5. REPAIRED WEB PER EA 347402 AND SRM 51-70-13-2R-4.SDR AALA202309137962Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT Z ANGLE LOCATED AT BS 993 AND RBL 31.5. REPLACED ANGLE PER SRM 51-40-02, DWG 147A5700 AND AARD 51-00-05-1.SDR AALA202308233792Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED:: AFT LAVATORY D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED AFT LAVATORY D ENTRY DOOR UPPER TRIM.SDR AALA202308235501Shade · stickingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT 17F WINDOW SHADE STICKS PARTIALLY OPEN. REMOVED AND REPLACED EMERGENCY EXIT DOOR 17F WINDOW SHADE PER AMM TASK 25-21-12-000/400-801.SDR AALA202308222852Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL, LOCATED BETWEEN BS 500C TO BS 500D, S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202308225585Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL LOCATED AT BS 500B + 10 INCHES, S26L. REMOVED, FABRICATED, AND INSTALLED TRANSITION PANEL PER SRM 51-40-02-0G-01.SDR AALA202308227823Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL LOCATED AT BS 500I, S26L. REMOVED, FABRICATED, AND INSTALLED TRANSITION PANEL PER SRM 51-40-02-0G-01.SDR AALA202308217332Battery Pack · faultyAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY LEFT FLASHLIGHT NEEDS A NEW BATTERY PACK. REMOVED AND REPLACED FORWARD LEFT FLASHLIGHT BATTERY PACK PER CMM 25-60-15.SDR AALA202308210984Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT INOPERATIVE. REPLACED AFT FLIGHT ATTENDANTS JUMPSEAT FLASHLIGHT PER AMM 25-64-00.SDR AALA202308212097Failsafe · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STABILIZER LEFT HAND AFT LUG, FORWARD FAILSAFE FITTING LOCATED AT BS 1094, FROM S2L TO S3L. REPLACED FAILSAFE FITTING PER SRM 51-40-02.SDR AALA202308217345Failsafe · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STABILIZER LEFT HAND AFT LUG, AFT FAILSAFE FITTING LOCATED AT BS 1088, FROM S2L TO S3L. REPLACED FAILSAFE FITTING PER SRM 51-40-02.SDR AALA202308213205Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS NOT ARMED LIGHT, HAS A LAMP INOPERATIVE. RELAMP EMERGENCY EXIT LIGHT NOT ARMED LIGHT.SDR AALA202308212781Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CHORD LOCATED IN FORWARD ELECTRICAL AND ENVIRONMENTAL COMPARTMENT, FROM BS 312 TO BS 320, S23L. REPAIRED STRINGER PER EA 346840.SDR AALA202308281614Connector · defectiveAIRCRAFT WAS NOT GROUNDED: OVERHEAD BIN EMERGENCY LIGHT SEAT AT 12D IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202308211614: REPLACED CONNECTOR D14816 PER SWPM 20-63-02. CHECKED EMERGENCY LIGHT PER AMM 33-51-00.**(CLOSED)SDR AALA202308256420Beam · wornAIRCRAFT IN BASE MAINTENANCE: AT ENVIRONMENTAL CONTROL SYSTEM ACCESS DOOR 192CR, LOWER WING BEAM FRAME WORN LOCATED AT BS 578, WL 155. REPAIRED PER SRM 57-10-13-2R.SDR AALA202308237325Module · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IND DUE TO AFT CARGO FIRE WARNING. WARNING WENT OUT ON ITS OWN. NO SMOKE OR FUMES. AIRCRAFT LANDED SAFELY AT IND WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202308217325:SDR AALA202308213259Attach Bolt · wrong partAIRCRAFT WAS GROUNDED: DURING REPLACEMENT OF L1 DOOR SLIDE. FOUND INCORRECT HARDWARE INSTALLED IN DOOR SLIDE PACK ATTACHMENT POINTS. REMOVED AND REPLACED FORWARD AND AFT SLIDE PACK ATTACHMENT BOLTS. PER JOB CARD 08L22125001.SDR AALA202308211614Unknown · unknownAIRCRAFT WAS NOT GROUNDED: OVERHEAD BIN EMERGENCY LIGHT SEAT AT 12D IS INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN).SDR AALA202308213436Relay · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO SPEED TRIM FAIL LIGHT ILLUMINATED AT 18,0000 FEET. THE AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED MAIN ELECTRIC STAB TRIM RELAY R64 PER SDR AALA202308217325Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IND DUE TO AFT CARGO FIRE WARNING. WARNING WENT OUT ON ITS OWN. NO SMOKE OR FUMES. AIRCRAFT LANDED SAFELY AT IND WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** SDR AALA202308221394Detector · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO ENGINE #1 OVERHEAT LIGHT ILLUMINATED ON INITIAL CLIMB. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202308214097: MAINTENANCE SDR AALA202308220767Detector · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO ENGINE #1 OVERHEAT LIGHT ILLUMINATED ON INITIAL CLIMB. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202308214097: MAINTENANCE SDR AALA202308221262Detector · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO ENGINE #1 OVERHEAT LIGHT ILLUMINATED ON INITIAL CLIMB. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202308214097: MAINTENANCE SDR AALA202308224097Detector · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO ENGINE #1 OVERHEAT LIGHT ILLUMINATED ON INITIAL CLIMB. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202308214097: MAINTENANCE SDR AALA202308224591Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ELECTRICAL GROUND POWER RECEPTACLE SURROUND DOUBLER LOWER FLANGE, LOCATED AT BS 230, S23R, WL 150.45. REPAIRED DOUBLER PER SRM 53-10-15-2R-4.SDR AALA202308213269Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO POSSIBLE FUEL LEAK FROM ENGINE #1 OR LEFT TANK IN FLIGHT. THE AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. MAINTENANCE ACCOMPLISHED LEAK CHECK OF LEFT WING FUELSDR AALA202308213956Plate · malfunctionedAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED PLATE AT AFT LAVATORY.SDR AALA202308214097Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO ENGINE #1 OVERHEAT LIGHT ILLUMINATED ON INITIAL CLIMB. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202308215656Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT OUTBOARD FLIGHT ATTENDANT'S FLASHLIGHT DOESN'T TEST. REMOVED AND REPLACED RIGHT AFT OUTBOARD FLIGHT ATTENDANT FLASHLIGHT PER B737NG SRM 51-40-02.SDR AALA202308189449Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF PASSENGER CABIN FLOORBEAM LOCATED AT BS 987 AND RBL 46. REPAIRED FLOORBEAM UPPER CHORD PER SRM 53-70-51-2R PROCEDURE 6 ALTERNATIVE 4.SDR AALA202308185578Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING RIGHT HAND WHEEL WELL VAPOR BARRIER WEB LOCATED AT BS 663.75 AND RBL 31. REPAIRED VAPOR BARRIER WEB PER AARD 57-10-10-9 AND SRM 51-70-04-2R-10.SDR AALA202308220323Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540 AND LBL 2. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA202308223958Unknown · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540 AND RBL 2. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA202308222612Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 500E TO BS 500F, S26R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G-01.SDR AALA202308186784Shield · corrodedAIRCARF IN BASE MAINTENANCE: CORROSION SHIELD ASSEMBLY LOCATED FROM BS 767 TO BS 793 AT RBL 25. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05-1.SDR AALA202308182010Sliding Window · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT HAND COCKPIT SLIDER WINDOW IS EXTREMELY DIFFICULT TO TO OPEN AND CLOSE. ADJUSTED SLIDING WINDOW PER AMM 56-12-11.SDR AALA202308181411Sliding Window · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT HAND COCKPIT SLIDER WINDOW IS EXTREMELY DIFFICULT TO TO OPEN & CLOSE. ADJUSTED SLIDING WINDOW. PER AMM 56-12-11.SDR AALA202308183128Door · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR HANDLE MIGRATED ON LANDING. DOOR WARNING INDICATION EXTINGUISHED WHEN DOOR HANDLE CLOSED. ACCOMPLISHED FORWARD ENTRY DOOR ADJUSTMENT. PER M/M 52-11-00.SDR AALA202308180596Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: 1L DOOR GUST LOCK DOES NOT STAY IN DOWN POSITION. LUBED FORWARD ENTRY DOOR 1L GUST LOCK ENGAGES AND DISENGAGES. PER AMM 12-25-11.SDR AALA202308181551Door Seal · out of positionAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR DIFFICULT TO OPERATE. FOUND AFT ENTRY DOOR SEAL PULLED FROM THE TRACK. REINSTALLED DUST SEAL PER AMM 52-13-31. OPERATIONAL CHECK OF DOOR NORMAL PER AMM 52-13-00.SDR AALA202308169516Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: FLOOR BEAM AT BS 987, HAS AREAS OF CORROSION ON UPPER SURFACE. AROUND NUT PLATE HOLES BETWEEN LBL 25 AND LBL 45. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R PROCEDURE 6 ALTERNATIVE 4.SDR AALA202308171434Pump · overheatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO HYDRAULIC SYSTEM B ELECTRIC MOTOR DRIVEN PUMP (EMDP) OVERHEAT LIGHT ILLUMINATED. AIRCRAFT LANDED SAFELY WITHOUT FURTER INCIDENT. MAINTENANCE REPLACED HYDRAULIC SYSTEM B EMSDR AALA202308175787Connector · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO HYDRAULIC SYSTEM B ELECTRIC MOTOR DRIVEN PUMP (EMDP) OVERHEAT LIGHT ILLUMINATED. AIRCRAFT LANDED SAFELY WITHOUT FURTER INCIDENT. MAINTENANCE REPLACED HYDRAULIC SYSTEM B EMSDR AALA202308171282Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT 22C BROKEN. REPLACED EMERGENCY LIGHT AT 22C PER AMM 33-51-00.SDR AALA202308160869Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED L2 DOOR EMERGENCY EXIT LIGHT BULBS PER AMM 33-51-01.SDR AALA202308155936Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663, RBL 9.0. REPLACED ATTACH ANGLE PER SRM 57-10-10-2R PROCEDURE 5 REPAIR 5.SDR AALA202308169452Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: L2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP PER AMM 33-51-04. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202308162342Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE CARGO TIE DOWN TRACK RAIL LOCATED BETWEEN BS 787 AND BS 837, RBL 14.5. REPLACED CARGO TRACK RAIL PER SRM 53-00-53-2R-3.SDR AALA202308160147Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 1016, LBL 46. REMOVED, FABRICATED, AND INSTALLED NEW INTERCOSTAL PER SRM 51-40-02-0G.
Back to Boeing 737-823