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 AALA202211188820Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 420 TO BS 440 AT RBL 16. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211180971Sidewall Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL PANEL SUPPORT LOCATED AT BS 500D AND S26R. REPLACED PANEL SUPPORT PER SRM 51-40-02-0G.SDR AALA202211164512Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY D DIFFICULT TO OPEN AND CLOSE CORRECTED ATA CODE. (OPEN)SDR AALA202211165954Pump · leakingAIRCRAFT WAS GROUNDED: ON DOWNWIND AT DFW PLANE WENT INTO MANUAL REVERSION. SYSTEM B WENT TO 60%, SYSTEM A WAS NORMAL. GEAR WAS EXTENDED MANUAL AND LANDED WITH FLAP 5 ON THE FLAP HANDLE, INDICATOR SHOWED 5. BRAKE PRESSURE SHOWED 2500 APPROXIMATELY ON FINAL THESDR AALA202211151860Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT FLIGHT ATTENDANT FLASHLIGHT #1 INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00. OPERATIONAL TEST GOOD.SDR AALA202211157417Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT FLIGHT ATTENDANT FLASHLIGHT #2 INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00. OPERATIONAL TEST GOOD.SDR AALA202211151359Sign · missingAIRCRAFT WAS NOT GROUNDED: CEILING OVERHEAD EMERGENCY EXIT SIGN MISSING IN MAIN CABIN. INSTALLED CEILING OVERHEAD EMERGENCY EXIT SIGN AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202211147373Battery Pack · no testAIRCRAFT WAS GROUNDED: DURING EMERGENCY LIGHT TEST FOUND BATTERY PACK M1673 INOPERATIVE. REPLACED BATTERY PACK M1673 PER AMM 33-51-06-960-805. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212066259Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500F TO BS 500D. REPLACED TRANSITION PANEL PER SRM 53-00-53-R2.SDR AALA202212065225Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500D TO BS 500B. REPLACED TRANSITION PANEL PER SRM 53-00-53-R2.SDR AALA202212067742Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LEFT HAND OUTER SUPPORT ANGLE LOCATED AT BS 500I FROM S20L TO S25L. REPLACED SUPPORT ANGLE PER ARM 51-10-02, AARD 51-00-05-1, AND DWG 143A9481.SDR AALA202212067849Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 101.90, THIRD STIFFENER FROM FRONT SPAR. REPLACED RIB PER AARD 51-00-05-01 AND DWG 182A3001.SDR AALA202212063365Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 101.90, SECOND STIFFENER FROM FRONT SPAR. REPLACED RIB PER AARD 51-00-05-01 AND DWG 182A3001.SDR AALA202212067802Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500I TO BS 500F AT LBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212069408Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 480 TO BS 460. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212062640Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500 TO BS 500B. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202211308920Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION FOUND ON THE FORWARD CARGO BAY RIGHT TRANSITION PANEL, BS 500D - 500B, S25R. REPLACED THE TRANSITION PANEL IAW AARD 51-00-05.SDR AALA202211300658Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO BAY RIGHT TRANSITION PANEL, BS 500F - 500D, S25R. REPLACED THE TRANSITION PANEL IAW AARD 51-00-05-1.SDR AALA202211292029Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON STRAP INBOARD OF CREASE ANGLE LOCATED BETWEEN STA 297 - 302 AND RIGHT BUTT LINE 55-56. INSTALLED NEW STRAP PER AARD 51-00-05-1.SDR AALA202211290470Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED BETWEEN 500I TO 500F AND STR 25R. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202211251565Intercostal · out of limitsAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL HOLES BEYOND LIMITS LOCATED BETWEEN STA 947 AND 967 AND LEFT BUTT LINE 24.5. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202211150918Threshold · damagedAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY (D) DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE REPLACED THRESHOLD RAIL TRIM, RAIL EDGE PER AMM 25-40-64.SDR AALA202211153970Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE TO MAIN CABIN SEAT TRACK LOCATED AT BS 727I PLUS 16 INCHES AND AT RBL 45L. REPAIRED SEAT TRACK PER SRM 53-00-52-2R-5.SDR AALA202211149318Slide · looseAIRCRAFT WAS NOT GROUNDED: L1 DOOR LOOSE SLIDE. MAINTENANCE RESECURED L1 DOOR SLIDE PER AMM 25-61-00.SDR AALA202211145022Sliding Window · out of positionAIRCRAFT WAS GROUNDED: FIRST OFFICERÏ¿½S R2 SLIDING WINDOW VERY DIFFICULT TO OPEN AND CLOSE. ADJUSTED WINDOW VERTICAL POSITION PER AMM 56-12-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK AND LEAK CHECK.SDR AALA202211155627Slide · detachedAIRCRAFT WAS GROUNDED: LEFT AFT L2 DOOR RAFT APPARATUS BROKEN OFF INDIRECTLY BY CATERING. REMOVED AND REPLACED L2 DOOR RAFT (SLIDE) PER CARD NUMBER 08L22125001.SDR AALA202211141739Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR STICKS OPENING AND CLOSING. MAINTENANCE ADJUSTED DOOR HINGE PER CMM 25-47-21.SDR AALA202211148155Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND FLOOR SUPPORT LOCATED FROM BS 950 TO BS 967 AT RBL 52. REPLACED FLOOR SUPPORT PER SRM 53-70-51-1A.SDR AALA202211147716Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: SIDEWALL EMERGENCY EXIT SIGN AT SEATS 17 DEF HAS AN INOPERATIVE BULB. REPLACED BULB.SDR AALA202212070803Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: VAPOR BARRIER CRACK AT STA 663 RUNNING DIAGONALLY FROM RIGHT BUTT LINE 30 AND WATER LINE 167 TO RIGHT BUTT LINE 35 AND WATER LINE 153 REPAIRED PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2 REPAIR 2. EFFECTIVE LENGTH OF CRACK IS APPROXSDR AALA202211154786Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND SIDE BAFFLE UPPER AFT FASTENER HOLE LOCATED FROM BS 500A TO BS 500B AT S25R. REPLACED BAFFLE PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA202211157140Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FLOOR INTERCOSTAL LOCATED AT BS 927 AND S25R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211144658Floor Panel · damagedAIRCRAFT WAS GROUNDED: CABIN FLOOR AT SEAT ROWS 17-18 SOFT AND MAKING "POPING" NOISE WHEN WALKED ON. MAINTENANCE REPAIRED FLOOR PANEL PER AARD 53-00-00-6.SDR AALA202211146541Sliding Window · dislodgedAIRCRAFT WAS GROUNDED: CAPTAINÏ¿½S L2 WINDOW IS OFF THE TRACK. REPLACED L2 SLIDING WINDOW PER JOB CARD 08L21056001.SDR AALA202211141078Grommet · detachedAIRCRAFT WAS NOT GROUNDED: GIRT BAR GROMMET CAME OFF. RE-INSTALLED GIRT BAR RELEASE STOP PER AMM 25-66-01.SDR AALA202211111261Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING TEST OF EMERGENCY LIGHT SYSTEM, FOUND LIGHT EXTERIOR AT L2 DOOR INOPERATIVE. REMOVED AND REPLACED L2 EXTERIOR EMERGENCY LIGHT PER AMM 33-51-04.SDR AALA202211114703Bracket · stickingAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD DOOR GIRT BAR DIFFICULT TO STOW IN HOOKS ON DOOR. BAR SEEMS OFF CENTER. ADJUSTED R1 DOOR GIRT BAR BRACKETS.SDR AALA202211112449Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE LIGHT AT ROW 23,24 AND 25 ABC INOPERATIVE. FOUND CONNECTOR BACKED OUT OF SOCKET UNDERNEATH SEAT, RESECURED CONNECTOR PER SWPM 20-62-26.SDR AALA202211116943Bypass Valve · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, LANDING GEAR WOULD NOT RETRACT. RAN QUICK REFERENCE HANDBOOK PROCEDURE. UNABLE TO RAISE GEAR. HANDLE WOULD NOT MOVE UP AT ALL, WITH OR WITHOUT USING TRIGGER OVERRIDE. EMERGENCY WAS DECLARED AND RETURNED TO JFK. REMOVED ANDSDR AALA202211115236Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR MUST BE CLOSED VERY FIRMLY TO LOCK SECURELY. LUBRICATED COCKPIT DOOR LATCH PER AMM 52-51-00.SDR AALA202211308315Fairing · crackedAIRCRAFT WAS NOT GROUNDED: LEFT INBOARD FLAP TRACK FAIRING HAS MULTIPLE CRACKS PERFORATIONS AND DAMAGE. INSTALLED LEFT INBOARD TAIL CONE FAIRING IAW AMM 27-51-18.SDR AALA202211216659Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON CARGO BAFFLE LOCATED BETWEEN STA 500C AND 500D AND LEFT BUTT LINE 25. REMOVED AND REPLACED PER AARD 55-00-05-1.SDR AALA202211217121Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO BAFFLE CREASED LOCATED BETWEEN STA 500G AND 500H AND STR L 26R. REMOVED AND REPLACED BAFFLE PER AARD 55-00-05-1.SDR AALA202211211400Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON BAFFLE LOCATED BETWEEN STA 500G AND 500H AND LEFT BUTT LINE 25. REMOVED AND REPLACED CARGO BAFFLE PER AARD 55-00-05-1SDR AALA202211216625Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON BAFFLE LOCATED BETWEEN STA 500F AND 500G AND LEFT BUTT LINE 25. REMOVED AND REPLACED BAFFLE PER AARD 55-00-05-1.SDR AALA202211210673Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CRACKED BETWEEN STA 500D AND 500E AND LEFT BUTT LINE 25. REMOVED AND REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202211157333Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT RIGHT HAND LOWER CENTER RAIL LOCATED AT BS 500I FROM LBL 16.5 TO RBL 16.5. REPLACED RAIL PER SRM 51-40-02-0G.SDR AALA202211147151Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT AFT BULKHEAD CENTER ACCESS PANEL LOWER SUPPORT LOCATED AT BS 947.5 FROM LBL 10 TO RBL 16. REPLACED PANEL SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202211147314Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND FLOOR TRANSITION PANEL LOCATED BETWEEN BS 727G AND BS 787 AT LBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211118315Fairing · crackedAIRCRAFT WAS NOT GROUNDED: LEFT INBOARD FLAP TRACK FAIRING HAS MULTIPLE CRACKS PERFORATIONS AND DAMAGE. (OPEN)
Back to Boeing 737-823