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 AALA202312068467Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 986.5, RBL 38. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R PROCEDURE 4.SDR AALA202312065994Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 986.5, RBL 43.5. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R PROCEDURE 4.SDR AALA202311292802Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311293098Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311292485Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311295390Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311296049Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00 REPAIR 1.SDR AALA202311295600Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311292554Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311290531Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311296831Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311299909Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311222785Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM UPPER CHORD AT BS 986 FROM LBL 0 TO LBL 43.5. REPAIRED FLOORBEAM CHORD PER SRM 53-70-51-2R-6-ALTERNATIVE 4.SDR AALA202311098689Bracket · looseAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR SEAL DRAGS ON FLOOR, DIFFICULT TO OPEN DOOR FULLY DURING FLIGHT. FOUND BRACKET LOOSE ON LOWER DOOR. TIGHTENED THE BRACKET. OPERATIONAL CHECK SATISFACTORY.SDR AALA202311090604Handle · lack of lubeAIRCRAFT WAS NOT GROUND: AFT LEFT LAVATORY LATCH HANDLE HARD TO OPEN FROM INSIDE. LUBE LEFT LAVATORY HANDLE OPERATIONAL CHECK GOOD. PER CMM 25-46-08.SDR AALA202402031756Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE LOCATED FROM BS 947 TO BS 955, LBL 54. REPAIRED CREASE ANGLE PER SRM 51-10-02 AND EA 349654.SDR AALA202312187239Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR BOARD SUPPORT ANGLE AT BS 772, LBL 13. REPAIRED ANGLE PER SRM 53-00-53 R2.SDR AALA202312188415Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR BOARD SUPPORT ANGLE AT BS 772, LBL 9. REPAIRED ANGLE PER SRM 53-00-53 R2.SDR AALA202312072238Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN UPPER CHORD OF FLOOR BEAM AT BS 986, LBL 41. REPAIRED CHORD PER SRM 53-70-51-2R-4 AND EA 349708 AND EA 349842SDR AALA202312078763Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR INTERCOSTAL BETWEEN BS 947 AND BS 967, LBL 50. REPLACED INTERCOSTAL PER AARD 51-11-05.SDR AALA202312068007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500CAND BS 500I AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202312060769Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500E AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202312064280Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202311200299Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 986, FROM RBL 28 TO RBL 38. REPAIRED FLOORBEAM CHORD PER EA 349347 AND SRM 51-40-02.SDR AALA202311090337Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EXTERNAL POWER DOOR SURROUND STRUCTURE LOWER FRAME FROM BS 235.8 TO BS 243.7, AND FROM S19R TO S22R. INSTALLED DOUBLER REPAIR PER SRM 53-10-15-2R PROCEDURE 4.SDR AALA202311091255Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR MOUNT INTERCOSTAL FROM BS 947 TO BS 961, RBL 51. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202311098067Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN BS 312 AND BS 328, RBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202311082979Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS. UNSTUCK, CLEANED, AND LUBRICATED FORWARD LAVATORY LATCH AND FUNCTIONAL CHECKED GOOD.SDR AALA202311082977Unknown · unknownAIRCRAFT WAS NOT GROUNDED: DURING CLIMB AND DECENT FUEL QUANTITY MOVED FROM TANKS WITHOUT COMMAND. NEEDED TO MANUALLY REBALANCE SEVERAL TIMES THROUGHOUT FLIGHT. PERFORMED FIM TASK 28-21-00-810-803. TEST PASSED. NO ISSUES FOUND WITH FUEL MIGRATION. PERFORMED FISDR AALA202311088683Holder · inoperativeAIRCRAFT WAS GROUNDED: DURING THE PS CHECK FOUND THE EMERGENCY (EXIT SIGN) ABOVE SIDEWALL LIGHT INOPERATIVE AT ROW 17CAB. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY (AALA202311088683) AND FUSE ON POWER SUPPLY CHARGER (AALA202311084897). PER AMM 33-51-06 & ASDR AALA202311084897Fuse · inoperativeAIRCRAFT WAS GROUNDED: DURING THE PS CHECK FOUND THE EMERGENCY (EXIT SIGN) ABOVE SIDEWALL LIGHT INOPERATIVE AT ROW 17CAB. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY (AALA202311088683) AND FUSE ON POWER SUPPLY CHARGER (AALA202311084897). PER AMM 33-51-06 & ASDR AALA202311091470Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT FOR (AALA202311071470): ADJUSTED LAVATORY D DOOR HINGE. PER AMM 25-40-14. FUNCTIONAL CHECK GOOD**(CLOSED).SDR AALA202311083324Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT SERVICE GIRT BAR HAS MISSING RED TUBING ON THE BAR.**SUPPLEMENTAL REPORT FOR (AALA202311073324): PERFORMED PERMANENT REPAIR ON AFT RIGHT SERVICE DOOR HEAT SHRINK. PER AARD 25-66-00-4.**(CLOSED).SDR AALA202311087483Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 787 TO BS 805, RBL 25. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202311087185Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR PANEL SUPPORT ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202311082866Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL ATTACH ANGLE AT BS 500G RBL 24. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202311073324Girt Bar · damagedAIRCRAFT WAS NOT GROUNDED: AFT SERVICE GIRT BAR HAS MISSING RED TUBING ON THE BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202311077767Door · jammedAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR LATCH JAMS IN CLOSED POSITION WHILE INFLIGHT. ADJUSTED LAVATORY D DOOR. PER CMM 25-40-64.SDR AALA202311071470Unknown · unknownAIRCRAFT WAS NOT GROUNDED: LAVATORY D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202311076331Trim Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB BOTH PILOT AND COPILOT ELECTRIC TRIM DOWN FAULTED AND DID NOT WORK. AIRCRAFT DIVERTED AND LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT. PERFORM TROUBLESHOOT PER FIM 27-41-00-810-802 . RSDR AALA202311062452Unknown · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. CATCHES ON DOOR FRAME. TIGHTENED SEAL PLATE HARDWARE AT FLOOR PER AMM 52-50-00.SDR AALA202311065740Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR OFF TRACK, HARD TO OPEN AND CLOSE. RESECURED LAVATORY D DOOR ONTO TRACK PER AMM 25-40-14.SDR AALA202311066603Terminal · dirtyAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EMERGENCY EXIT, EXTERIOR LIGHT INOPERATIVE. FOUND HIGH RESISTANCE ON LAMP TERMINALS. CLEANED TERMINALS PER AMM 20-10-78. OPERATIONAL CHECK GOOD PER AMM 33-51-04.SDR AALA202311078887Sign · brokenAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT SIGN BASE ASSEMBLY BROKEN. REMOVED AND REPLACED LOWER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L1208 (AALA202311078887). UPPER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L140SDR AALA202311072338Sign · brokenAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT SIGN BASE ASSEMBLY BROKEN. REMOVED AND REPLACED LOWER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L1208 (AALA202311078887). UPPER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L140SDR AALA202311075627Sign · brokenAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT SIGN BASE ASSEMBLY BROKEN. REMOVED AND REPLACED LOWER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L1208 (AALA202311078887). UPPER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L140SDR AALA202311076088Sign · brokenAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT SIGN BASE ASSEMBLY BROKEN. REMOVED AND REPLACED LOWER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L1208 (AALA202311078887). UPPER EXIT FLOOD LIGHT IDENTIFIER AT LEFT HAND FORWARD OVERWING EXIT L140SDR AALA202311076032Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING EMERGENCY LIGHT WORK CARD 08T20033001 FOUND RIGHT EXTEMERENGY LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202311066032): REMOVED AND REPLACED THE M1671 POWER SUPPLY. PER AMM 33-51-06-960-805, FUNCTIONAL CHECK GSDR AALA202311074106Light · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LANDING GEAR INDICATION LIGHT DISAGREE. AIRCRAFT DIVERTED AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. REPLACED LIGHT ASSEMBLIES (L2) LEFT GEAR (AALA202311064106), NOSE GEAR (L6) ON P2-3 (AALA20231SDR AALA202311078200Light · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LANDING GEAR INDICATION LIGHT DISAGREE. AIRCRAFT DIVERTED AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. REPLACED LIGHT ASSEMBLIES (L2) LEFT GEAR (AALA202311064106), NOSE GEAR (L6) ON P2-3 (AALA20231
Back to Boeing 737-823