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 AALA202302023097Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01671 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302018590Door Latch · looseAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT LAVATORY DOOR LATCH TOO TIGHT. PASSENGER LOCKING THEMSELVES IN THE LAVATORY. TROUBLESHOOT THE AFT RIGHT LAV E, LOCKING MECHANISM AND FOUND LOOSE. ADJUSTED THE LATCH MECHANISMSDR AALA202302014244Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS AT BOTTOM. ADJUSTED DOOR PER CMM 25-45-4. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302016430Light · damagedAIRCRAFT WAS NOT GROUNDED: ROW 33ABC ESCAPE PATH LIGHT DAMAGED. REPLACED SEAT MOUNTED FLOOR PROXIMITY LIGHT ASSEMBLY PER AMM 38-51-11.SDR AALA202304041540Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED FROM BS 947.5 TO BS 967, AT LBL 47. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302079656Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE DECK BULKHEAD LOWER SECTION INTERCOSTAL #4 FROM RIGHT HAND SIDE, LOCATED AT BS 1016 AND RBL 3. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302076450Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE DECK BULKHEAD LOWER SECTION INTERCOSTAL #4 FROM LEFT HAND SIDE, LOCATED AT BS 1016 AND LBL 3. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302077628Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE DECK BULKHEAD LOWER SECTION INTERCOSTAL #1 FROM LEFT HAND SIDE, LOCATED AT BS 1016 AND LBL 36. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302076696Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE DECK BULKHEAD LOWER SECTION INTERCOSTAL #2 FROM LEFT HAND SIDE, LOCATED AT BS 1016 AND LBL 25. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302079034Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE DECK BULKHEAD LOWER SECTION INTERCOSTAL #3 FROM LEFT HAND SIDE, LOCATED AT BS 1016 AND LBL 12. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302073677Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE DECK BULKHEAD LOWER SECTION INTERCOSTAL #3 FROM RIGHT HAND SIDE, LOCATED AT BS 1016 AND RBL 12. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302062677Power Supply · inoperativeAIRCRAFT WAS NOT GROUND: CEILING EMERGENCY EXIT SIGN BY ROW 12 IS MISSING. **SUPPLEMENTAL REPORT FOR AALA202301312677: MAINTENANCE FOUND EMERGENCY EXIT SIGN INOPERATIVE. REPLACED EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1695 PER AMM 33-51-06. ACCOMPLISHEDSDR AALA202302062818Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT STRINGER, AROUND FASTENER HOLE, LOCATED AT BS 500G + 10 INCHES AND S23R. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202302064978Seat Track · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN SEAT TRACK LOCATED AT BS 495 AND LBL 24.5. REPAIRED SEAT TRACK PER SRM 53-00-52-2R-4.SDR AALA202302069068Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD INTERCOSTAL LOCATED AT BS 1016 AND RBL 25. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302069235Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER SECTION INTERCOSTAL LOCATED AT BS 1016 AND RBL 36. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302065603Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR MOP SILL INNER CHORD LOCATED AT BS 312 AND LBL 60. REPAIRED INNER CHORD SRM PER 51-40-02-0G.SDR AALA202302068038Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 974.5 FROM LBL 5 TO RBL 27. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R.SDR AALA202302064048Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727H + 10 INCHES TO BS 767 AT RBL 22. REPAIRED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202302062441Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER INTERCOSTAL LOCATED FROM BS 947.5 TO BS 967 AT RBL 47. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302062357Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER FLOOR BEAM LOCATED AT BS 986.5 FROM LBL 60 TO RBL 60. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4.SDR AALA202302060296Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR MOP SILL INNER CHORD LOCATED FROM BS 303 TO BS 328 AT RBL 60. REPAIRED INNER CHORD SRM PER 51-40-02-0G.SDR AALA202302018334Light · unsecureAIRCRAFT WAS NOT GROUNDED: CABIN CREW REPORTED SEAT 15C EMERGENCY ESCAPE LIGHT ASSEMBLY NOT SECURED. RESECURED EMERGENCY ESCAPE LIGHT ASSEMBLY ON SEAT 15C PER CMM 25-23-67.SDR AALA202301316462Girt Bar · looseAIRCRAFT WAS NOT GROUND: L1 DOOR GIRT BAR LOOSE AND HANGING. SECURED L1 GIRT BAR PER AMM 25-66-01.SDR AALA202301317153Lock · bindingAIRCRAFT WAS NOT GROUND: FORWARD LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. MAINTENANCE FOUND DOOR LOCK KNOB TRIM ON INSIDE OF DOOR JAMMING LOCK. SECURED TRIM PER AMM 25-00-00.SDR AALA202301312677Sign · missingAIRCRAFT WAS NOT GROUND: CEILING EMERGENCY EXIT SIGN BY ROW 12 IS MISSING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202302024100Slide · low pressureAIRCRAFT IN BASE MAINTENANCE: LOW PRESSURE, SLIDE PACK ASSEMBLY ON AFT ENTRY DOOR 834. REPLACED DOOR SLIDE PACK ASSEMBLY ON AFT ENTRY DOOR 834 PER JOB CARD 08L22125001.SDR AALA202301313723Structure · unsecureAIRCRAFT WAS NOT GROUNDED: 1L CABIN DOOR GIRT BAR CLIP LOOSE. RE-SECURED DOOR 1L GIRT BAR RETAINER CLIP.SDR AALA202302072894Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 947 TO BS 967 AT RBL 54. REPLACED INTERCOSTAL PER SRM 53-70-51-1A PROCEDURE 1 DAMAGE 1.SDR AALA202302070622Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR Z ANGLE LOCATED AT BS 990 AND RBL 33. REPLACED ANGLE PER SRM 53-70-51-1A-1.SDR AALA202302024822Sensor · leakingAIRCRAFT WAS GROUNDED: RIGHT AFTER TAKEOFF NOTICED DIRTY SOCK SMELL IN CABIN AND FLIGHT DECK. SMELL DISAPPEARED SHORTLY THEREAFTER. **SUPPLEMENTAL REPORT FOR AALA202301314822: MAINTENANCE FOUND #2 ENGINE OIL LEAK AS SOURCE OF THE FUMES. REPLACED LEAKING #2 ENSDR AALA202302021170Packing · deterioratedAIRCRAFT WAS GROUNDED: RIGHT AFTER TAKEOFF NOTICED DIRTY SOCK SMELL IN CABIN AND FLIGHT DECK. SMELL DISAPPEARED SHORTLY THEREAFTER. **SUPPLEMENTAL REPORT FOR AALA202301314822: MAINTENANCE FOUND #2 ENGINE OIL LEAK AS SOURCE OF THE FUMES. REPLACED LEAKING #2 ENSDR AALA202302015650Regulator Valve · abnormalAIRCRAFT WAS GROUNDED: LEFT ENGINE DUCT PRESSURE INDICATES 0 ON CLIMB AND CRUISE. FLIGHT ATTENDANT REPORT NO AIRFLOW IN CABIN. FLIGHT AIR INTERRUPTED BACK TO MIA. NO EMERGENCY DECLARED. REMOVED AND REPLACED PRESSURE REGULATING SHUT OFF VALVE (AALA202302015650)SDR AALA202302018831Valve · abnormalAIRCRAFT WAS GROUNDED: LEFT ENGINE DUCT PRESSURE INDICATES 0 ON CLIMB AND CRUISE. FLIGHT ATTENDANT REPORT NO AIRFLOW IN CABIN. FLIGHT AIR INTERRUPTED BACK TO MIA. NO EMERGENCY DECLARED. REMOVED AND REPLACED PRESSURE REGULATING SHUT OFF VALVE (AALA202302015650)SDR AALA202302012675Regulator · abnormalAIRCRAFT WAS GROUNDED: LEFT ENGINE DUCT PRESSURE INDICATES 0 ON CLIMB AND CRUISE. FLIGHT ATTENDANT REPORT NO AIRFLOW IN CABIN. FLIGHT AIR INTERRUPTED BACK TO MIA. NO EMERGENCY DECLARED. REMOVED AND REPLACED PRESSURE REGULATING SHUT OFF VALVE (AALA202302015650)SDR AALA202301313112Window · scratchedAIRCRAFT WAS GROUNDED: TWO DEEP SCRATCHES ON CAPTAIN WINDSHIELD INSIDE PANE. IMPLEADS VISION. REMOVED AND REPLACED LEFT COCKPIT WINDOW NO 1.SDR AALA202301314822Unknown · odorAIRCRAFT WAS GROUNDED: RIGHT AFTER TAKEOFF NOTICED DIRTY SOCK SMELL IN CABIN AND FLIGHT DECK. SMELL DISAPPEARED SHORTLY THEREAFTER. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202301300864Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301301116Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301300246Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301303735Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301304027Door · bindingAIRCRAFT WAS NOT GROUNDED: AIRCRAFT AFT LAVATORY (D) AIRCRAFT LEFT DOOR IS BINDING ON BOTTOM MAKING IT HARD TO OPEN AND CLOSE. PERFORMED ADJUSTMENT OF AFT LAVATORY D BI-FOLD DOOR.SDR AALA202301300784Sign · damagedAIRCRAFT WAS NOT GROUNDED: ROW 17 EMERGENCY EXIT SIGN MISSING "EXIT" PLASTIC TRIM. REPLACED EXIT SIGN PER AMM 33-51-00.SDR AALA202301305161Windshield · delaminatedAIRCRAFT IN BASE MAINTENANCE: CAPTAIN`S L1 WINDSHIELD DELAMINATED. REMOVED AND REPLACED L1 WINDSHIELD PER AMM 56-11-11 AND JOB CARD 08C21156001.SDR AALA202301302327Connector · not seatedAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS FROM 14 ABC TO 8 ABC ARE INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY M1694 (AALA202301303586) AND RESEATED CONNECTOR AT ROW 8 ABC (AALA202301302327). ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301303586Power Supply · inoperativeAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS FROM 14 ABC TO 8 ABC ARE INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY M1694 (AALA202301303586) AND RESEATED CONNECTOR AT ROW 8 ABC (AALA202301302327). ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303284767Oven · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED BURNING SMELL COMING FROM NUMBER 1 OVEN IN G1 GALLEY. **SUPPLEMENTAL REPORT FOR AALA202301304767: REMOVED AND REPLACED #1 OVEN IN G1 GALLEY PER AMM 25-32-03. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CSDR AALA202301316344Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND SUPPORT ANGLE LOCATED AT BS 665, OUT BOARD OF AIRCONDITIONING BAY. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202301318326Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE LANDING GEAR WHEEL WELL RIGHT HAND WALL T ANGLE LOCATED AT BS 273 AND WL 160. REPLACED T ANGLE PER AARD 51-00-05-1.SDR AALA202301319600Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE LANDING GEAR WHEEL WELL LEFT HAND WALL T ANGLE LOCATED AT BS 273 AND WL 160. REPLACED T ANGLE PER AARD 51-00-05-1.
Back to Boeing 737-823