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 AALA2024111290219Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. VERIFIED AFT LAVATYORY-D DOOR DIFFICULT TO OPEN AND CLOSE ALSO SOMETIMES IT JAMES CLOSED AND VERY DIFFICULT TO OPEN. ADJUSTED AFT LAVATORY-D DOOR NOW DOOR. OPERTIONAL CHECKS GOOD. PER SDR AALA202411127871Slide · dislodgedAIRCRAFT WAS GROUNDED: THE RAFT FELL OUT OF THE DOOR BOX ON THE MAIN CABIN DOOR DURING DOOR OPERATION. RESECURED L1 CABIN DOOR SLIDE. OPERTIONAL CHECK GOOD. PER AMM 25-66-01-400-801.SDR AALA202411126012Elec Connector · looseAIRCRAFT IN BASE MAINTENANCE: FOUND EMERGENCY LIGHT INOPERATIVE AT AFT LEFT HAND LAVATORY-D AREA. SECURED LOOSE CONNECTORS. OPERTIONAL CHECK GOOD. PER 33-51-01.SDR AALA202411129172Elec Connector · looseAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT AT CEILING LOCATION ABOVE ROW 29ABC INOPERATIVE. FOUND LOOSE CONNECTOR ABOVE SEAT, SECUREED CONNECTOR. OPERTIONAL CHECK GOOD. PER 33-51-03.SDR AALA202412090380Frame · gougedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FRAME GOUGED AT BS 294.5 AND STR 2L. REPAIRED THE GOUGED MAIN CABIN FRAME AT BS 294.5 STR 2L. PER B737NG SRM 53-00-07-2R-1.SDR AALA202411258798Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED AT STA 727F PLUS 2 INCHES, S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202411194316Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SIDE AFT WET AREA JUST AFT OF LEFT HAND LAVATORY OUTBOARD FLOOR FITTING HAS (3) AREAS OF CORROSION. REPALCED FLOOR FITTING ON NR-00296.SDR AALA202411194529Support · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR DRAIN SUPPORT INBOARD OF L2 BS 971 HAS SIGNS OF CORROSION. REMOVED AND REPLACED THE MAIN CABIN FLOOR SUPPORT AT BS 971 AND LBL 45. PER B737 AIPC 53-42-51-23 AND N737NG SRM 51-40-02.SDR AALA202411145270Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: HOLES IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY LOCATED FROM STA 500F TO STA 500G, LBL 26. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202411131854Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED FROM STA 500C TO STA 500D, S25R. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202411123930Vapor Barrier · deterioratedAIRCRAFT IN BASE MAINTENANCE: ACCOMPLISHED RENSECT OF EXISTING REPAIR, FOUND EXISTING REPAIR DETERIORATED. REMOVED AND APPLIED NEW REPAIR VAPOR BARRIER AT BS 663.75 AND LBL 54.21. PER AARD 57-10-10-9 AND B737NG SRM 57-10-10-2R-2 PARA. 6SDR AALA202411124678Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB, CRUISE, AND DESCENT WE WERE GETTING A "LEADING EDGE FLAPS TRANSIT" LIGHT AND NUMBER 8 PANEL ILLUMINATED ON THE OVERHEAD PANEL; AIRCRAFT LANDED SAFELY AT PHL. CORRECTED PROXIMITY SENSOR DIMESDR AALA202411220107Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: OFF AIRCRAFT INSPECTION, GIRT FOR FORWARD GALLEY DOOR SLIDE FRAYED AND DISBONDING. REMOVE AND REPLACEMENT OF THE R1 EES, PER TASK CARD 08L22125001-R1.SDR AALA202411085803Flashlight · no testAIRCRAFT WAS NOT GROUNDED: OUTBOARD FLASHLIGHT DOES NOT TEST ON RIGHT AFT FLIGHT ATTENDANT STATION. REMOVED AND REPLACED AFT FLIGHT ATTENDANT FLASHLIGHT. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202411089039Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED L1 ATTENDANT RIGHT SEAT FLASHLIGHT INDICATOR IS RED. REPLACED BATTERY AND REAPPLIED SEAL OPS CHECK SATISFACTORY PER AMM 25-64-00.SDR AALA202411089265Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT EMERGENCY FLASH LIGHT IS INOP. MAINTENANCE REPLACED EMERGENCY FLASHLIGHT AND BASE AND OPS CHECKED GOOD IAW AMM 25-64-00.SDR AALA202411084707Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY FLASH LIGHT IS NOT CHARGING. MAINTENANCE REPLACED EMERGENCY FLASHLIGHT AND BASE AND OPS CHECKED GOOD IAW AMM 25-64-00.SDR AALA202411088409Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, RBL 24.82. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202411085050Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, LBL 24.82. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202411076792Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD FUSELAGE EXTERNAL POWER ACCESS DOOR SURROUND DOUBLER AT STA 235.8, FROM S21R TO S22R. REPAIRED DOUBLER PER SRM 53-10-15-2R PROCEDURE 4.SDR AALA202412245434Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTIONFOR TASKS CPCP- 53-390-00 FOUND AFT WET AREA AT RIGHT HAND STABILIZER G-4 FITTING CORRODED. REMOVED AND REPLACED AFT WET AREA G-4 RIGHT HAND STABILIZER. PER B737NG AMM 25-31-41.SDR AALA202412240318Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: DURING INSEPCTION FOR TASK CPCP-53-390-00 FOUND AFT WET AREA LEFT HAND STABILIZER G-4 FITTING CORRODED. REMOVED AND REPLACED AFT WET AREA G-4 LEFT HAND STABILIZER. PER B737NG AMM 25-31-41.SDR AALA202411127090Skin · separatedAIRCRAFT IN BASE MAINTENANCE: UPPER AFT CORNER OF L1 DOOR SKIN IS SEPARATED, LOCATED AT STA 311, WL 137.8. ACCOMPLISHED REPAIR DOUBLER PER CMM 52-16-12 AND EA 359426.SDR AALA202411082841Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT STA 663.5, RBL 8. REPAIRED ANGLE PER SRM 57-10-10 2R-5.SDR AALA202411071362Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: DURING PS CHECK FOUND FLASHLIGHT AFT CABIN ATTENDANT SEAT TEST FAILED. REPLACED FLASHLIGHT BATTERY. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202411072936Life Raft · low pressureAIRCRAFT WAS NOT GROUNDED: 25 PERSON LIFE RAFT PRESSURE OUT OF LIMITS. REPLACED 25 PERSON LIFE RAFT. PER AMM 25-64-00.SDR AALA202411075525Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTADNENT JUMPSEAT EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202411073379Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: FOUND L2 SLIDE LAYING ON THE AFT GALLY FLOOR. INSTALLED NEW SLIDE. PER MM 25-66-01.SDR AALA202411060742Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: DURING OPERATIONAL TEST OF EMERGENCY LIGHTING J/C 08T20033001, FOUND RIGHT HAND OVERWING ESCAPE GROUND ILLUMINATION LIGHT INOPERATIVE AFT OF WHEEL WELL. REMOVED AND REPLACED M01672 BATTERY PACK. PER AMM 33-51-06.SDR AALA202411130445Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 317, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411085574Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE LOCATED BETWEEN STA 380 TO STA 400, LBL 24. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202411075971Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 350, LBL 13. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411074485Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 353, LBL 1. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411064910Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: FOUND RIGHT AFT OVER WING EMERGENCY LIGHT INOPERABLE. REMOVED AND REPLACED RIGHT AFT OVER WING EXTERIOR EMERGENCY LIGHT. PER AMM 31-54-04.SDR AALA202411067444Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: FOUND RIGHT AFT OVER WING EMERGENCY LIGHT INOPERABLE. REMOVED AND REPLACED RIGHT AFT OVERWING EXTERIOR EMERGENCY LIGHT. PER AMM 31-54-04.SDR AALA202411067203Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: UNDER LEFT HAND AFT FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHTS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHTS BATTERIES. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202411061815Fitting · 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 AALA202411065674Fitting · 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 AALA202411069163Fitting · 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 AALA202411060630Fitting · 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 AALA202411064660Fitting · 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 AALA202411061124Fitting · 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 AALA202411069932Fitting · 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 AALA202411066272Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411062840Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411068359Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411081285Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 344 TO STA 360, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202411083496Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM STA 344 TO STA 360, LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202411050421Elec Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN ABOVE FORWARD GALLEY SERVICE DOOR INOPERATIVE. CANNON PLUG WAS RESEATED D40042P. PERFORMED SATISFACTORY OPERTIONAL CHECK GOOD. PER B737NG WDM 33-51-12.SDR AALA202411057659Wire · damagedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND OVERWING AFT DOOR FLOOR EXIT EMERGENCY LIGHT IS INOPERATIVE. PERFORMED TROUBLESHOOTING AND REPAIRED WIRE ON D3672, PIN 1. PERFOMRED SATISFACTORY OPERTIONAL CHECK GOOD. PER B737NG WDM 33-51-21 AND AMM 33-51-00.
Back to Boeing 737-823