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 AALA202406069450Floorbeam · noneAIRCRAFT IN BASE MAINTENANCE: VALIDATION OF EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOORBEAM FROM STA 443 TO STA 450, LBL 9 REQUIRED. SPLICE REPAIR ACCOMPLISHED PER SRM 53-00-53-2R PROCEDURE 2.SDR AALA202406065604Transition Panel · noneAIRCRAFT IN BASE MAINTENANCE: VALIDATION OF EXISTING REPAIR TO FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500B + 12 INCHES, LBL 24 REQUIRED. SPLICE REPAIR ACCOMPLISHED PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202406061391Floorbeam · noneAIRCRAFT IN BASE MAINTENANCE: VALIDATION OF EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOORBEAM FROM STA 451 TO STA 455, RBL 2 REQUIRED. SPLICE REPAIR ACCOMPLISHED PER SRM 53-00-53-2R PROCEDURE 2.SDR AALA202406060066Transition Panel · noneAIRCRAFT IN BASE MAINTENANCE: VALIDATION OF EXISTING REPAIR TO FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500G + 10 INCHES, RBL 24 REQUIRED. SPLICE REPAIR ACCOMPLISHED PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202406061231Floor Support · noneAIRCRAFT IN BASE MAINTENANCE: VALIDATION OF EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOOR SUPPORT AT STA 445, LBL 18 REQUIRED. SPLICE REPAIR ACCOMPLISHED PER SRM 53-00-53-2R PROCEDURE 2.SDR AALA202406064650Keelbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO KEEL BEAM HAS CORROSION ON LONGERON LOCATED AT STR 27R BETWEEN BS 727I TO 727J. INSTALL NEW SEGMENT OF KEEL BEAM CHORD. PER EA NUMBER 353348.SDR AALA202406108635Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERNAL FUSELAGE SKIN FROM STA 927 TO STA 947, FROM S27L TO S27R. REPAIRED SKIN PER EA 352646.SDR AALA202406076943Spring · brokenAIRCRAFT WAS GROUNDED: EXTERIOR HANDLE ON L1 DOOR MOVED OUTSIDE FLUSH HOUSING TO THE VERTICAL POSITION IN FLIGHT AROUND 10000 FEET. AIRCRAFT ARRIVED AT GATE WITH THE HANDLE IN THEVERTICAL POSITION. REMOVED AND REPLACED BROKEN EXTERIOR DOOR HANDLE RETRACTION SPSDR AALA202406078811Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406072677Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406075798Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406076327Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406075345Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406079825Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406076063Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406061979Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT SLIDE EXTERIOR LIGHT INOPERATIVE. REPLACED EXTERIOR SLIDE EMERGENCY INDICATION LAMP PER AMM 33-51-04. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202406064301Air Filter · dirtyAIRCRAFT WAS GROUNDED: ROTTEN SOCK SMELL WHEN APU IS RUNNING. FOUND BOTH LEFT AND RIGHT HEPA FILTERS EXTREMELY DIRTY. REPLACED LEFT (AALA202406064301) AND RIGHT (AALA202406062241) RECIRCULATION FILTERS,PER AMM 21-25-01. SMELL CHECK GOOD. FOUND LEFT PACK HPWS-HSDR AALA202406062241Air Filter · dirtyAIRCRAFT WAS GROUNDED: ROTTEN SOCK SMELL WHEN APU IS RUNNING. FOUND BOTH LEFT AND RIGHT HEPA FILTERS EXTREMELY DIRTY. REPLACED LEFT (AALA202406064301) AND RIGHT (AALA202406062241) RECIRCULATION FILTERS,PER AMM 21-25-01. SMELL CHECK GOOD. FOUND LEFT PACK HPWS-HSDR AALA202406062283Boot · tornAIRCRAFT WAS GROUNDED: ROTTEN SOCK SMELL WHEN APU IS RUNNING. FOUND BOTH LEFT AND RIGHT HEPA FILTERS EXTREMELY DIRTY. REPLACED LEFT (AALA202406064301) AND RIGHT (AALA202406062241) RECIRCULATION FILTERS,PER AMM 21-25-01. SMELL CHECK GOOD. FOUND LEFT PACK HPWS-HSDR AALA202406065015Module · stickingAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, WHEN MOVING GEAR HANDLE FROM "UP" TO "OFF", GEAR HANDLE FAILED TO LATCH INTO THE OFF POSITION AND MOVED SLIGHTLY PAST THE DETENT. A RED NOSE GEAR LIGHT ILLUMINATED BRIEFLY AND THE LANDING GEAR HANDLE WAS RETURNED TO THE UPSDR AALA202406067389Skin · crackedAIRCRAFT WAS GROUNDED: AT WALK AROUND FOUND ELECTRICAL GROUND POWER CUTOUT BOTTOM SIDEIS CRACKED OUT. REPAIRED ELECTRICAL GROUND POWER CUTOUT. PER SRM 53-10-15.SDR AALA202406056794Door Frame · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D LEFT HAND SIDE DOOR GETS STUCK AND HARD TO OPEN. ADJUSTED DOOR FRAME ASSEMBLY FOR LAVATORY-D DOOR. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202406056673Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: L2 DOOR INTERIOR EMERGENCY EXIT SIGN LIGHTS INOPERATIVE. CHARGED BATTERY PACK. PER AMM 33-51-06SDR AALA202406058124Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: L2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. CHARGED BATTERY PACK. PER AMM 33-51-06.SDR AALA202406051412Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 ENTRY DOOR DIFFICULT TO CLOSE. LUBRICATED AND OPERATED L1 DOOR IN REFERENCE TO AMM 52-11-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202406047441Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY ISLE LIGHT IS LOOSE 15ABCE. SECURED LOOSE ISLE LIGHT 15ABC.SDR AALA202406046456Oil Cooler · faultedAIRCRAFT WAS GROUNDED: APU WENT OFFLINE, BUT A VERY STRONG ELECTRICAL BURNING SMELL WAS IN AIRCRAFT CABIN AND FLIGHT DECK. AFTER APU RESTART. ACCOMPLISHED WORK CARD 08L00021001 FOR SMOKE ODOR FUMES, FOUND OIL COOLER FAULTY. REMOVE AND REPLACED OIL COOLER (AALASDR AALA202406043169Pressure Switch · faultedAIRCRAFT WAS GROUNDED: APU WENT OFFLINE, BUT A VERY STRONG ELECTRICAL BURNING SMELL WAS IN AIRCRAFT CABIN AND FLIGHT DECK AFTER APU RESTART. ACCOMPLISHED WORK CARD 08L00021001 FOR SMOKE ODOR FUMES, FOUND OIL COOLER FAULTY. REMOVE AND REPLACED OIL COOLER (AALA2SDR AALA202406043633Hinge · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN. TIGHTENED HINGE FASTENERS ON FORWARD LAVATORY DOOR. PER CMM 25-44-49.SDR AALA202406030664Anti-Ice Valve · failedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: COWL VALVE FAILURE ON BOTH ENGINES AT CRUISE WHEN ATTEMPTING TO USE ENG ANTI-ICE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED ANTI ICE GROUND TEST FOR BOTH ENGINES PER AMMSDR AALA202406039501Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR LOCK IS DIFFICULT TO LOCK AND UNLOCK. ADJUSTED AFT RIGHT LAVATORY DOOR LOCK. OPERTIONAL CHECK GOOD. PER CMM 25-40-65.SDR AALA202406037642Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND VAPOR BARRIER IS CRACKED OUTBOARD OF PACK EXHAUST DUCT APPOX 10 INCHES IN LENGTH. INSTALLED FABRIC PATCH REPAIR. PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202406036757Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND VAPOR BARRIER IS CRACKED 10 INCHES IN LENGTH AT OUTBOARD OF PACK EXHAUST. INSTALLED NEW FABRIC PATCH REPAIR. PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202406030232Keelbeam · crackedAIRCRAFT WAS NOT GROUNDED: 11 INCH CRACK IN LEFT WHEEL WELL NEXT TO KEEL BEAM. ACCOMPLISHED FIXED. PER AARD 57-10-10-9.SDR AALA202406030558Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR REPORTED HARD TO OPEN AND CLOSE. ADJUSTED DOOR LATCH ASSEMBLY, OPERTIONAL CHECK GOOD. PER CMM 25-44-49.SDR AALA202406032862Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT PANEL AT BOTTOM SEAT ROW 18ABC IS HANGING LOOSE FROM THE BOTTOM OF SEAT. RESECURED EMERGENCY LIGHT PANEL AT BOTTOM OF SEAT 18ABC.SDR AALA202406039832Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: UNSPECIFIED DAMAGE TO PASSENGER CABIN FLOORBOARD SUPPORT FROM STA 947 TO STA 967, RBL 16. REPLACED SUPPORT PER AARD 51-00-05.SDR AALA202407107316Valve · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB OUT AT APPROXIMATELY 17000 FEET RIGHT FUEL IMBALANCE WAS NOTICED AND RAPIDLY DECREASING; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHX. REPLACED LEFT WING BOOST PUMP BYPASS (AALSDR AALA202407101766Pump · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB OUT AT APPROXIMATELY 17000 FEET RIGHT FUEL IMBALANCE WAS NOTICED AND RAPIDLY DECREASING; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHX. REPLACED LEFT WING BOOST PUMP BYPASS (AASDR AALA202406129451Trim Panel · out of positionAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STUCK AND INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202406039451): REMOVE AND REPLACED LAVATOR-D UPPER TRIM RAIL EDGE. OPERTIONAL CHECK GOOD. PER CMM 25-40-64**(CLOSED).SDR AALA202406047651Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN (STICKING AT BOTTOM OF DOOR). **SUPPLEMENTAL REPORT FOR (AALA202406037651): ADJUSTED FORWARD LAVATORY DOOR. PER AMM FIN TASK 52-99-00. **(CLOSED).SDR AALA202406031766Fuel Sys · out of balanceAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB OUT AT APPROXIMATELY 17000 FEET RIGHT FUEL IMBALANCE WAS NOTICED AND RAPIDLY DECREASING; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHX. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(SDR AALA202406030603Stop · missingAIRCRAFT WAS NOT GROUNDED: A PIECE OF THE GIRT BAR ON L1 DOOR FELL OFF. REMOVED AND REPLACED L1 DOOR GIRT BAR STOP ASSEMBLY. L1 DOOR GIRT BAR OPERTIONAL CHECK NORMAL GOOD. PER AMM 25-60-00.SDR AALA202406032950Light · out of positionAIRCRAFT WAS NOT GROUNDED: FLOOR EMERGENCY EXIT LIGHTS AT SEAT 24A OUT OF PLACE. RESECURED SEAT 24A EMERGENCY LIGHT. PER AMM 33-51-11.SDR AALA202406039680Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN ABOVE LEFT AFT DOOR CAME OFF. RE-INSTALLED EXIT LIGHT CAP, OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202406039451Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STUCK AND INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406031041Clamp · looseAIRCRAFT WAS GROUNDED: STRONG ODOR SMELL IN FLIGHT DECK AND FIRST CLASS CABIN COMING FROM FORWARD LAVATORY. LIQUID LEAKING IN TO GALLEY AREA FROM UNDER LAVATORY FLOOR PAN AT DOOR TRANSITION. FOUND COUPLING CLAMP FROM DISCHARGE DRAIN HEADING DOWN TO FORWARD E&ESDR AALA202406037651Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN (STICKING AT BOTTOM OF DOOR). **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406147279Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM STA 727 TO STA 727I. REPARED PANEL PER SRM 51-10-02 AND EA 355116.SDR AALA202406146664Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINTER S23L FROM STA 312 TO STA 325. REPARIED STRINGER PER EA 354578.
Back to Boeing 737-823