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 AALA202311176812Indicator · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS FAILED TO EXTEND IN PRIMARY AND ALTERNATE MODE. AIRCRAFT DIVERTED AND LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202311163716): REMOVE AND REPLACED NUMBER 1 FLAP SDR AALA202311173103Fseu · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS FAILED TO EXTEND IN PRIMARY AND ALTERNATE MODE. AIRCRAFT DIVERTED AND LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202311163716): REMOVE AND REPLACED NUMBER 1 FLAP SDR AALA202311160423Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: 1.5 INCH CRACKED ON MAIN DECK FLOOR SUPPORT AT AIRCRAFT STA 540 AND LBL 3. INSTALLED NEW MAIN DECK FLOOR SUPPORT (143A5240-35SD). PER B737 NG SRM 51-40-02-0G.SDR AALA202311162844Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. CLEAN AND LUBRICATED FORWARD LAVATORY DOOR LATCH. FUNCTIONAL CHECK GOOD. PER 52-35-00.SDR AALA202311162992Unknown · unknownAIRCRAFT WAS GROUNDED: LEFT REAR DOOR WILL NOT OPEN FROM OUTSIDE. (OPEN).SDR AALA202311163716Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS FAILED TO EXTEND IN PRIMARY AND ALTERNATE MODE. AIRCRAFT DIVERTED AND LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202311205700Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL JUST AFT OF LAVATORY MOUNT, FROM BS 294 TO BS 312, LBL 12. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND DWG 141A5600.SDR AALA202311203055Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311206623Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311205426Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311208002Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311208426Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311177748Skin · corrodedAIRCRAFT IN BASE MAINTENACE: LOWER FUSELAGE EXTERIOR SKIN HAS EVIDENCE OF CORROSION AROUND BELLY DRAINS AT BS 727J + 3. BETWEEN BLO AND LBL9. INSTALLED DOUBLER REPAIR PER EA 348642.SDR AALA202311173489Fitting · brokenAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF ACCESS PANEL 192E FOUND BRACKET BROKEN. REMOVED AND REPLACED 1 EA NEW BRACKET (FITTING) ON UNDER KEEL AT STA 546.26 OF ACCESS PANEL 192E BRACKET P/N:149A7712-42. PER B737 NG SRM 51-40-02.SDR AALA202311163105Door · brokenAIRCRAFT WAS NOT GROUNDED: UNABLE TO UNLOCK L4 LAVATORY FROM THE INSIDE. REMOVED AND REPLACED L4 LAVATORY DOOR. PER CMM 25-40-64.SDR AALA202311156147Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR LATCH DIFFICULT TO CLOSE AND OPEN. ADJUSTED LAVATORY D DOOR LATCH. FUNCTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202311152159Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED TRACK AT 2L LAVATORY. OPERATIONAL CHECK GOOD.SDR AALA202311151331Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: SUPPORT ANGLE HAS 0.9 INCH CRACKED. AT AIRCRAFT STA 663.5 AND RBL 2.0. INSTALLED REPLACEMENT ANGLE AND SPLICE ANGLE. PER SRM 57-10-10-2R-5 AND AARD 57-10-10-10 PROCEDURE 10.SDR AALA202311175785Drain Mast · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT FUSELAGE LOWER DRAIN MAST HAS SEVERAL AREAS OF CORROSION. BS 1005 WL208. REPLACED DRAIN MAST PER AMM 38-31-01-400-801.SDR AALA202311156706Bulb · inoperativeAIRCRAFT WAS GROUNDED: R2 DOOR EMERGENCY LIGHT BURNED OUT. REMOVED AND REPLACED LIGHT BULB. PER MM 33-51-03,SDR AALA202311150849Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: 1.375 INCH CRACKED AT INTERCOSTAL FROM AIRCRAFT STA 328 TO 344 AT BL 45.6 AND WATERLINE 207. REMOVE AND REPLACED INTERCOSTAL. PER AARD 51-00-05.SDR AALA202311159914Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: 0.75 INCH CRACKED ON INTERCOSTAL AT AIRCRAFT STA 312 TO 328, LBL 45.6, AND WATERLINE 207. REMOVE AND REPLACED INTERCOSTAL. PER AARD 51.00.05.SDR AALA202311145080Wire · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS HAS LOOSE WIRES HANGING UNDERNEATH SEAT 13C. SECURED LOOSE WIRES HANGING UNDERNEATH SEAT 13C FOR EMERGENCY LIGHTS, OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202311145081Compensator · faultyAIRCRAFT WAS GROUNDED: RIGHT FUEL QUANTITY INDICATION ERRATIC. DIFFERENT READING DURING PREFLIGHT AND DURING CRUISE. FUEL LEVELS KEEP DROPPING.**SUPPLEMENTAL REPORT FOR (AALA202311135081): REMOVED AND REPLACED THE RIGHT COMPENSATOR. PER AA B737 AMM 28-41-21. OSDR AALA202311135081Unknown · unknownAIRCRAFT WAS GROUNDED: RIGHT FUEL QUANTITY INDICATION ERRATIC. DIFFERENT READING DURING PREFLIGHT AND DURING CRUISE. FUEL LEVELS DROPPING DURING TANK BALANCING.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202311139872Shroud · damagedAIRCRAFT WAS GROUNDED: EXIT PATH LIGHTING SEAT 32C NEEDS SECURED. MAINTENANCE REMOVED AND REPLACED THE EXIT PATH LIGHT ASSY AT SEAT 32C IAW CMM 25-23-67.SDR AALA202311135577Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LIGHT OVER RIGHT SIDE OVER WING EXIT FLASHING LIKE A STROBE LIGHT. ADJUSTED LAMP ASSEMBLY AS REQUIRED PER AMM 33-50-00.SDR AALA202311135300Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: AFT ENTRY (L2) DOOR GIRT BAR LOOSE. STOVED EXCESS GIRT MATERIAL AT L4 SLIDE. PER AMM 25-66-01.SDR AALA202312065886Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT BREAK ASSEMBLY PANEL AT STA 540, RBL 0 TO RBL 24.7. REPLACED FLOORBOARD SUPPORT BREAK ASSEMBLY PANEL PER AARD 51-00-05-01 REPAIR 1.SDR AALA202312060117Intercostal · noneAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL BETWEEN BS 500D AND BS 500E AT LBL 24 REQUIRES REPLACEMENT DUE EXISTING REPAIR. REPLACED INTERCOSTAL PER AARD AARD 51-00-05-1.SDR AALA202312065904Intercostal · noneAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL BETWEEN BS 460 AND BS 480 AT LBL 24 REQUIRES REPLACEMENT DUE EXISTING REPAIR. REPLACED INTERCOSTAL PER AARD AARD 51-00-05-1.SDR AALA202312060810Intercostal · noneAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL BETWEEN BS 440 AND BS 460 AT LBL 24 REQUIRES REPLACEMENT DUE EXISTING REPAIR. REPLACED INTERCOSTAL PER AARD AARD 51-00-05-1.SDR AALA202311169026Sign · unserviceableAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY LIGHT "EXIT" IDENTIFIERS UNSERVICEABLE. REMOVED AND REPLACED G4 EXIT SIGNS PER. B737NG AMM 33-51-01-960-802. OPERATIONAL CHECK GOOD.SDR AALA202311168548Sign · unserviceableAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY LIGHT "EXIT" IDENTIFIERS UNSERVICEABLE. REMOVED AND REPLACED G4 EXIT SIGNS PER. B737NG AMM 33-51-01-960-802. OPERATIONAL CHECK GOOD.SDR AALA202311151191Door · stuckAIRCRAFT WAS NOT GROUNDED: L4 LAVATORY DOOR STUCK SHUT.**SUPPLEMENTAL REPORT FOR (AALA202311131191): REMOVED AND REPLACED AFT LAVATORY DOOR LEFT HAND. PER AMM 25-40-00 **(CLOSED).SDR AALA202311130681Fseu · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS WOULD NOT EXTEND PAST 15 ON APPROACHAIRCRAFT LANDED SAFELY AT PHX WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED FSEU (FLAP SLAT ELECTRONICS UNIT). PERFORMED SUCCESSFUL BITE TEST OF FSEU. PER AMM 2SDR AALA202311131191Unknown · stuckAIRCRAFT WAS NOT GROUNDED: L4 LAVATORY DOOR STUCK SHUT.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202311138755Flashlight · no testAIRCRAFT WAS NOT GROUNDED: NUMBER 1 FLIGHT ATTENDANT STATION FLASHLIGHT FAILS BATTERY TEST WITH RED ALERT LIGHT. REMOVED AND REPLACED NUMBER 1 FLASHLIGHT. OPERATIONAL CHECK GOOD.SDR AALA202311131899Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR NOT OPENING AND CLOSING PROPERLY. LUBRICATED L1 DOOR OUTER DOOR MECHANISM, OPERATIONAL CHECK GOOD. PER 12-25-11.SDR AALA202311139223Hinge · missingAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR IS MISSING RETAINING PIN ON THE GUST LOCK ASSEMBLY. FORWARD ENTRY DOOR WILL NOT CLOSE. REPLACED L1 DOOR HINGE, OPERATIONAL CHECKS GOOD. PER AARD 52-10-00-4 REPAIR 4.SDR AALA202311137135Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 350, BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202312069748Intercostal · noneAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL BETWEEN BS 500G AND BS 500H AT LBL 24 REQUIRES REPLACEMENT DUE EXISTING REPAIR. REPLACED INTERCOSTAL PER AARD AARD 51-00-05-1.SDR AALA202311159868Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL AT STA 500A TO 500I AND RBL 25. REPLACED RIGHT HAND TRANSITION PANEL. PER AARD 51-00-05-1.SDR AALA202311138036Sensor · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS ONE SELECTED, LEADING FLAPS TRANSIT LIGHT REMAINED ILLUMINATED. GREEN LEADING FLAPS EXTENDED LIGHT DID NOT ILLUMINATE. AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT.**SUPPLEMENTAL REPORT FSDR AALA202311139737Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN STA 947 AND STA 967 AT LBL 24. REPLACED INTERCOSTAL PER SRM 51-40-02 OG.SDR AALA202311134400Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN STA 947 AND STA 961 AT RBL 25. REPLACED INTERCOSTAL PER SRM 51-40-02 OG.SDR AALA202311138286Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT LAVATORY INBOARD AFT MOUNT AT BS 947.5, LBL 45. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R.SDR AALA202311108036Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS ONE SELECTED, LEADING FLAPS TRANSIT LIGHT REMAINED ILLUMINATED. GREEN LEADING FLAPS EXTENDED LIGHT DID NOT ILLUMINATE. AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT.**SUPPLEMENTAL REPORT WSDR AALA202312069776Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT BREAK ASSEMBLY PANEL AT STA 540, LBL 0 TO LBL 24.7. REPLACED FLOORBOARD SUPPORT BREAK ASSEMBLY PANEL PER AARD 51-00-05-01 REPAIR 1.SDR AALA202312067880Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 986.5, RBL 34. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R PROCEDURE 4.
Back to Boeing 737-823