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 AALA202301188331Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 354 AND BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202212279158Floor Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AT AFT WET AREA FLOOR STRUCTURE UPPER SKIN STA 990 AND RIGHT BUTT LINE 33. REMOVED AND REPLACED FLOOR STRUCTURE UPPER SKINSDR AALA202212273422Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212270687Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN INTERCOSTAL LOCATED AT BS 1016 AT LBL 3. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212276009Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500B TO BS 500C AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212236246Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL AT STA 500B-500C STR 24R IS CORRODED. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212226187Floor Support · scratchedAIRCRAFT IN BASE MAINTENANCE: SCRATCHES ON AFT PASSENGER COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 961 TO BS 986.5 AT LBL 16. REPAIRED INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA202212211060Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN LEFT HAND INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND DWG 141A5400.SDR AALA202212209361Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FORWARD ENTRY AREA FLOORBOARD SUPPORT INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05, SRM 51-00-05, AND DWG 141A5400.SDR AALA202212205993Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR ANGLE LOCATED AT BS 394 AND LBL 13. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202212197519Sign · missingAIRCRAFT WAS NOT GROUNDED: RIGHT AFT EMERGENCY EXIT SIGN MISSING. REPLACED RIGHT AFT EMERGENCY EXIT LIGHT SIGN ASSEMBLY PER AMM 33-51-01.SDR AALA202212199585Slide · out of positionAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE MATERIAL DRAGS ON BOTTOM OF DOOR WHEN GIRT BAR STOWED. ADJUSTED DOOR SLIDE MATERIAL PER 25-66-00.SDR AALA202212190259Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT AISLE SIGN FELL OFF ROW 20. REINSTALLED OVERHEAD EXIT SIGN AT ROW 17 AISLE.SDR AALA202212192187Oven · smokeAIRCRAFT WAS NOT GROUNDED: LEFT OVEN SMOKING AND SMELLS LIKE BURNING PLASTIC. REMOVED AND REPLACED LEFT OVEN PER AMM 25-32-03-000-801.SDR AALA202301038460Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPORT ANGLE LOCATED AT BS 500I. REPLACED SUPPORT ANGLE PER AARD 51-00-05-01.SDR AALA202212237539Slide · out of positionAIRCRAFT IN BASE MAINTENANCE: WHILE ATTEMPTING TO CLOSE THE L1 DOOR, THE EMERGENCY ESCAPE SLIDE FELL OFF THE DOOR. REPLACED L1 DOOR SLIDE IAW AMM 25-66-01SDR AALA202212230282Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FROM AFT SPAR. REPAIRED SKIN IAW SRM 55-10-01-2R-11.SDR AALA202212200616Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BREAK PANEL LOCATED AT BS 540 AND LBL 0. REPLACED BREAK PANEL PER SRM 51-40-02.SDR AALA202212201686Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BREAK PANEL LOCATED AT BS 540 AND RBL 0. REPLACED BREAK PANEL PER SRM 51-40-02.SDR AALA202212199922Valve · faultedAIRCRAFT WAS GROUNDED: AIRCRAFT DIVERTED TO ATL DUE TO IMBALANCE MESSAGE/AMBER INDICATION ON FUEL TANK NUMBER 1. EMERGENCY WAS DECLARED AND WAS NOT OVERWEIGHT FOR LANDING. REMOVED AND REPLACED CROSSFEED VALVE PER AMM 28-22-21.SDR AALA202212166586Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND RIGHT AFT GROUND LEVEL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT AFT GROUND LEVEL EMERGENCY LIGHT PER AMM 33-51-04.SDR AALA202212166451Filter · odorAIRCRAFT WAS GROUNDED: DURING CLIMB BLEEDS ON APU OFF ENGINE ON CABIN CREW MEMBERS REPORTED A STRONG STRANGE ODOR PASSENGERS REPORTED SMELLING IT AS WELL. REMOVED AND REPLACED AIRCRAFT AIRCRAFT HEPA RECIRCULATION FILTERS PER AMM 21-25-01-401. RAN ENGINES TO FUSDR AALA202212168230Door Latch · bindingAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO CLOSE FROM OUTSIDE COCKPIT NEED TO SLAM DOOR. CLOSING FROM INSIDE IS EASY ONLY IF TURNING DOORKNOB. CLEANED AND LUBED LATCH.SDR AALA202212163968Radar · faultedAIRCRAFT WAS NOT GROUNDED: WEATHER RADAR UNUSABLE. STUCK IN GROUND MAP MODE. FLIGHT DIVERTED TO DFW LANDING SAFELY. (OPEN)SDR AALA202212162019Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND OUTBOARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT PUSH TO TEST INOPERATIVE. REPLACED FLASHFLIGHT PER AMM AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301031168Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 947 AND RBL 10.5. REPAIRED FLOOR BEAM PER EA 341192 AND SRM 53-70-51-2R-8 ALTERNATE 1.SDR AALA202212299457Trans Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL CORRODED BETWEEN STA 747 AND 767 AND RIGHT BUTT LINE 22. BLENDED REPAIR PER SRM 51-10-02.SDR AALA202212299320Trans Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO LEFT TRANSITION PANEL CORRODED LOCATED AT STA 500A TO 500F AND LEFT BUTT LINE 23. REMOVED AND REPLACED LEFT TRANSITION PANEL.SDR AALA202212298532Trans Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT TRANSITION PANEL CORRODED BETWEEN STA 727J THROUGH 747 AND LEFT BUTT LINE 22. BLENDED REPAIR PER SRM 51-10-02.SDR AALA202212287617Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION FOUND ON THE FLOORBEAM, BS 951, RBL 17. REMOVED AND REPLACED THE FLOORBEAM.SDR AALA202212287256Shield · corrodedAIRCRAFT IN BASE MAINTENANCE. RT SHIELD CORRODED BETWEEN BS 767-787, RBL 22. REMOVED AND REPLACED THE SHIELD.SDR AALA202212285438Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORROSION ON THE FLOORBEAM ANGLE, BS 951, RBL 17. REMOVED AND REPLACED FLOORBEAM ANGLE.SDR AALA202212281850Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. FORWARD CARGO RT TRANSITION PANEL HAD CORROSION, BS 360-540, RBL 22. REMOVED AND REPLACED THE TRANSITION PANEL.SDR AALA202212281273Strap · corrodedAIRCRAFT IN BASE MAINTENANCE. FLOOR WEB STRAP CORRODED, BS 1020, RBL 3. BLENDED OUT CORROSION.SDR AALA202212283911Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON AFT FLOORBEAM, BS 952, BETWEEN LBL 23 AND 25. REMOVED AND REPLACED THE FLOORBEAM.SDR AALA202212286846Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. SIDE TO SIDE FLOORBEAM HAD CORROSION AT BS 951, RBL 48. REMOVED AND REPLACED THE FLOORBEAM.SDR AALA202212284199Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON THE BS 947 FLOORBEAM UPPER SURFACE, RBL 49. BLENDED CORROSION.SDR AALA202212232048Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR INBOARD THRESHOLD SUPPORT LOCATED FROM BS 294 TO BS 328 AT RBL 64. REPAIRED SUPPORT PER SRM 53-10-51.SDR AALA202212234429Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 952 AND RBL 49. REPLACED INTERCOSTAL PER SRM 51-40-02, DWG 147A5660 AND AARD 51-00-05-1.SDR AALA202212234657Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR INBOARD THRESHOLD SUPPORT LOCATED FROM BS 312 TO BS 344 AT LBL 64. REPAIRED SUPPORT PER SRM 51-10-01.SDR AALA202212239994Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202212233923Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202212226814Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND AFT BULKHEAD SUPPORT ANGLE LOCATED AT BS 500I AND FROM S26R TO S19R. REPLACED SUPPORT ANGLE PER SRM 51-40-02 AND DWG 143A7902.SDR AALA202212166396Switch · pilot errorAIRCRAFT WAS GROUNDED: ON DEPARTURE CAPTAIN AND FIRST OFFICER COULD NOT TRIM NOSE DOWN WITH SWITCHES TRIM, WHEEL WORKED FINE. FOUND TRIM GUARD SWITCHED IN OFF POSITION. ACCOMPLISHED FIM 27-41-00. NO FAULTS NOTEDSDR AALA202212165787Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER SUPPORT ANGLE LOCATED AT BS 500I FROM S26L TO S26R. REPLACED SUPPORT ANGLE PER SRM 51-40-02 AND DWG 143A7902.SDR AALA202212149251Power Supply · inoperativeAIRCRAFT WAS GROUNDED: L2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHTS POWER SUPPLY M1673.SDR AALA202301093195Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT WHEEL WELL SMALL CRACK IN FORWARD PART OF THE LEFT WHEEL WELL ACCOMPLISHED PERMANENT REPAIR ON LEFT WHEEL WELL VAPOR BARRIER AT LEFT BUTT LINE 54.21-45.64 STA. 663.75.SDR AALA202301030278Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AND A CRACK ON FUSELAGE SKIN AT LAVATORY VENT PORT AT BS 917 BETWEEN S21L AND S22L. MAINTENANCE REPAIRED SKINPER SRM 53-70-01-R2-3SDR AALA202212223888Vapor Barrier · crackedCRACK IN LEFT WHEEL WELL, FORWARD VAPOR BARRIER. LOCATED AT BS 663.75 AND FROM LBL 45 TO LBL 54. REPAIRED VAPOR BARRIER IAW SRM 57-10-10-2R-2 PARAGRAPH 6 STEP D.SDR AALA202212229381Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947 AND RBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02.
Back to Boeing 737-823