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 AALA202212140128Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR D IS STICKING. ADJUSTED LAVATORY D DOOR PER CMM 25-40-64.SDR AALA202212148253Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR DIFFICULT TO ARM AND DISARM. ADJUSTED R1 GIRT BAR DISARM HOLD RETAINER CLIPS.SDR AALA202301101673Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70. REPLACED RIB PER AARD 51-00-05-01 AND DWG 182A5301.SDR AALA202301033815Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.75 BETWEEN LBL 5 AND LBL 25. REPAIRED PER SRM 57-10-10-2R PROCEDURE 5.SDR AALA202212289827Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. RIGHT TRANSITION ANGLE HAD CORROSION, BS 500A-500G+9, RBL 24. INSTALLED A NEW ANGLE.SDR AALA202212200354Rib · crackedAIRCRAFT IN BASE MAINTENANCE, A CRACK FOUND ON RIGHT HORIZONTAL STAB RIB, HSS 92.70, THIRD STIFFENER FROM THE FRONT SPAR. REPAIRED RIB IAW SRM 55-10-09-2R-4.SDR AALA202212202263Rib · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK FOUND ON THE RIGHT HORIZONTAL STAB RIB, HSS 92.70, SECOND STIFFENER FROM THE FRONT SPAR. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202212142024Gcu · faultedAIRCRAFT WAS GROUNDED: CLIMBING THRU FIGHT LEVEL 340 EXPERIENCED A LOSS OF ELECTRICAL POWER. STARTED APU; PLACED APU ON LEFT TRANSFER BUS. FLIGHT DECLARED AN EMERGENCY AND RETURNED TO CLT LANDING SAFELY. MAINTENANCE REPLACED GENERATOR CONTROL UNITS #1 (AALA202SDR AALA202212142315Gcu · faultedAIRCRAFT WAS GROUNDED: CLIMBING THRU FLIGHT LEVEL 340 EXPERIENCED A LOSS OF ELECTRICAL POWER. STARTED APU; PLACED APU ON LEFT TRANSFER BUS. FLIGHT DECLARED AN EMERGENCY AND RETURNED TO CLT LANDING SAFELY. MAINTENANCE REPLACED GENERATOR CONTROL UNITS #1 (AALA20SDR AALA202212145920Buss Tie · faultedAIRCRAFT WAS GROUNDED: CLIMBING THRU FLIGHT LEVEL 340 EXPERIENCED A LOSS OF ELECTRICAL POWER. STARTED APU; PLACED APU ON LEFT TRANSFER BUS. FLIGHT DECLARED AN EMERGENCY AND RETURNED TO CLT LANDING SAFELY. MAINTENANCE REPLACED GENERATOR CONTROL UNITS #1 (AALA20SDR AALA202212145445Buss · faultedAIRCRAFT WAS GROUNDED: CLIMBING THRU FLIGHT LEVEL 340 EXPERIENCED A LOSS OF ELECTRICAL POWER. STARTED APU; PLACED APU ON LEFT TRANSFER BUS. FLIGHT DECLARED AN EMERGENCY AND RETURNED TO CLT LANDING SAFELY. MAINTENANCE REPLACED GENERATOR CONTROL UNITS #1 (AALA20SDR AALA202212132267Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 DOOR DIFFICULT TO OPEN FROM EXTERIOR. LUBRICATED DOOR HINGES PER AMM 25-40-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212132846Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR LATCH DIFFICULT TO CLOSE. LUBRICATED DOOR LATCH. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-02.SDR AALA202212281805Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT TRANSITION PANEL HAS CORROSION LOCATED AT STA 490 AND 500G+9 AND STR 25L. REMOVED AND REPLACED TRANSITION PANEL.SDR AALA202212231201Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986.5 AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 3 AND EA 341078.SDR AALA202212213501Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986.5 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202212216508Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN LEFT HAND FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 957 LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND DWG 147A5650.SDR AALA202212124063Screw · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE. RESECURED SCREW AROUND TRACK AREA L4 OK FOR SERVICE.SDR AALA202212129961Light · out of positionAIRCRAFT WAS NOT GROUNDED: ROW 30 C EMERGENCY EXIT LIGHT WIRE IS HANGING DOWN. REMOVED/REPLACED EMERGENCY LIGHT BRACKET 30C ROW PER AMM 33-51-11.SDR AALA202212124876Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: INBOARD AFT FLIGHT ATTENDANT FLASHLIGHT UNDER JUMPSEAT NEAR R2 DOOR DOES NOT TEST PROPERLY. REPLACED WITH SERVICEABLE UNIT PER B737 AMM 25-64-00.SDR AALA202212126741Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT OPERATE. LUBRICATED DOOR LOCK.SDR AALA202212123535Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR SLIDE EMERGENCY EXIT EXTERIOR LIGHT INOPERATIVE. REPLACED LAMP PER AMM 33-51-04.SDR AALA202212213929Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727E TO BS 727F AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212217864Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 767 TO BS 747 AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212212929Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727H TO BS 727I AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212217161Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727J TO BS 727I AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212213250Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727G TO BS 727F AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212218868Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT TRANSITION PANEL LOCATED AT BS 727B AND S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-SDR AALA202212219400Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 767 TO BS 807 AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212214516Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 727D AND S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212213266Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 727C AND S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212208353Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON CARGO SHIELD LOCATED BETWEEN STA 767 AND 787 AND RIGHT BUTT LINE 25. REMOVED AND REPLACED AFT CARGO SHIELD PER AARD 51-00-05-1.SDR AALA202212208399Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR SILL LOCATED AT STA 460 AND STR 26R. REMOVED AND REPLACED CARGO DOOR SILL WEB PER AARD 51-00-05-1.SDR AALA202212207366Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON THRESHOLD WEB. LOCATED AT BS 787+6 TO 847 AND STR 25. INSTALLED NEW WEB PER SRM 51-40-02.SDR AALA202212206113Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727J TO BS 747 AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212201940Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 727B AND S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202212148401Smoke Detector · no testAFT CARGO A3 SMOKE DETECTOR INOPERATIVE. REPLACED THE SMOKE DETECTOR IAW AMM 26-16-01 AND ACCOMPLISHED A SATISFACTORY OPS TEST IAW AMM 26-16-00-710-801.SDR AALA202212134946Windshield · delaminatedAIRCRAFT WAS GROUNDED: L1 WINDSHIELD DELAMINATION. REPLACED WINDSHIELD PER JOB CARD 08L21056003.SDR AALA202212120738Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 28ABC EMERGENCY LIGHT PATH ASSEMBLY BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT PATH ASSEMBLY AT SEAT 28ABC PER CMM 25-23-67.SDR AALA202212122773Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR HARD TO CLOSE. LUBRICATED COCKPIT DOOR HINGE AND DOOR LATCH OPERATIONS CHECK NORMAL PER AMM 52-51-00.SDR AALA202212125608Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 ENTRY DOOR DIFFICULT TO ARM / DISARM. RE-VELCROED GIRT BAR AREA.SDR AALA202212127412Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1L SLIDE HARD TO ARM / DISARM. ADJUSTED GIRT BAR PER AMM 25-66-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212227442Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER INTERCOSTAL LOCATED AT BS 1016 AND LBL 31. REPLACED INTERCOSTAL PER SRM 51-00-04-0G.SDR AALA202212220764Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER INTERCOSTAL LOCATED AT BS 1016 AND RBL 31. REPLACED INTERCOSTAL PER SRM 51-00-04-0G.SDR AALA202212169387Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN PRESSURE BULKHEAD LOWER INTERCOSTAL LOCATED AT BS 1016 AND LBL 20. REPAIRED INTERCOSTAL PER SRM 53-80-08-1A-1.SDR AALA202212154454Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1670 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212157810Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1671 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212156043Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1672 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212150023Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1673 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212152007Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1674 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.
Back to Boeing 737-823