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 AALA202212152564Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1675 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212158145Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1676 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212150932Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1694 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212158778Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1695 FAILS OPERATIONAL TEST. REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202212134103Warning Message · illuminatedAIRCRAFT WAS NOT GROUNDED: LEFT AFT FUEL LOW PRESSURE LIGHT CAME ON IN FLIGHT. PRIMED LEFT AFT FUEL BOOST PUMP PER FIM 28-22-00-810-803. PUMP OPERATES NORMAL.SDR AALA202212122233Door · out of rigAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED AFTER LANDING. L1 DOOR WAS RIGGED AND ADJUSTED.SDR AALA202212122215Cradle · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT RIGHT INBOARD JUMP SEAT FLASHLIGHT BASE INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT BASE AT FLIGHT ATTENDANT'S AFT RIGHT INBOARD JUMPSEAT PER AMM 25-64-00.SDR AALA202212128962Hinge · lack of lubeAIRCRAFT WAS GROUNDED: CABIN ENTRY DOOR FWD ENTRY LIGHT ILLUMINATED AFTER LANDING. DOOR DIFFICULT TO OPEN. LUBED DOOR HINGES, OPERATED DOOR SEVERAL TIMES. NO DEFECTS NOTED.SDR AALA202212121707Gust Lock · inoperativeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR GUST LOCK WON'T STAY ENGAGED. ADJUSTED GUST LOCK PER AMM 52-11-21.SDR AALA202212129254Cabin Air Sys · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT SMELLED SMOKE IN BACK OF AIRCRAFT ON TAKEOFF. DID NOT SEE SMOKE OR FIRE. EMERGENCY DECLARED. FLIGHT DIVERTED TO IAD LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202212099254: MAINTENANCE ACCOMPLISHED SMOKE ODOR FUME TROSDR AALA202212129819Oven · smokeAIRCRAFT WAS GROUNDED: RIGHT FORWARD GALLEY OVEN ARCING AND SMOKING. OVEN TURNED OFF, SMOKING STOPPED. REPLACED OVEN PER AMM 25-32-03.SDR AALA202212120118Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR NEEDS ADJUSTMENT. ADJUSTED L1 ENTRY DOOR GIRT BAR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212099254Unknown · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT SMELLED SMOKE IN BACK OF AIRCRAFT ON TAKEOFF. DID NOT SEE SMOKE OR FIRE. EMERGENCY DECLARED. FLIGHT DIVERTED TO IAD LANDING SAFELY. (OPEN)SDR AALA202301255387Web · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK AFT WET AREA STA 986.5 AND RIGHT BUTT LINE 39 WEB CORRODED. REMOVED AND REPLACED MAIN DECK WEB PER SRM.SDR AALA202301095434Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301096137Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301094301Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301097849Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 8 INCHES FROM FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301099546Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301090969Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 184.70, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301094357Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT 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 AALA202301067729Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT 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 AALA202212200723Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 500D TO BS 500E AT LBL 25. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05-1.SDR AALA202212202692Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 500E TO BS 500F AT LBL 25. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05-1.SDR AALA202212205023Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT ENTRY FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 948 AND LBL 26. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202212131278Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AT AFT WET AREA FLOOR STRUCTURE INTERCOSTAL TOP SURFACE STA 947 LBL 25. REMOVED AND REPLACED AFT WET AREA FLOOR STRUCTURE INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212134820Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: AFT WET AREA FLOOR STRUCTURE INTERCOSTAL TOP SURFACE SCRATCHED STA 947 LEFT BUTT LINE 16. REMOVED AND REPLACED AFT WET AREA FLOOR STRUCTURE INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212138776Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO INTERCOSTAL STA 500C-500D ABOVE STR 25L UPPER SURFACE CORRODED AROUND FASTENER HOLES, BROKEN AT FORWARD END. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02-OGSDR AALA202212090100Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY DOOR AS REQUIRED PER AMM 25-40-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212091496Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY SMOKE LIGHT ILLUMINATED. NO SMOKE EXISTED. ACCOMPLISHED SATISFACTORY LAVATORY SMOKE TEST FOR AFT RIGHT LAVATORY PER AMM 26-14-00.SDR AALA202212094936Transmitter · faultyAIRCRAFT WAS GROUNDED: AFTER TAKEOFF FIRST OFFICER FLIGHT DIRECTOR WORKED INTERMITTENTLY, MACH TRIM FAIL AND SPEED TRIM FAIL ILLUMINATED. EMERGENCY DECLARED. FLIGHT DIVERTED TO ORD LANDING SAFELY. MAINTENANCE TROUBLESHOOT MACH TRIM FAIL AND SPEED TRIM FAIL TO SDR AALA202212096291Girt Bar · obstructedAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE DIFFICULT TO ARM. MAINTENANCE FOUND GIRT BAR MATERIAL STRAP FOLD PROHIBITED ARMING OF SLIDE EASILY. FOLDED PROPERLY PER AMM 25-61-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212091330Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE DISLODGED. REPLACED THE L1 DOOR SLIDE PER JOB CARD 08L22125001.SDR AALA202301109406Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WING CENTER SECTION FORWARD RIGHT LOWER SKIN LOCATED AT BS 540 AN RBL 53.2. REPAIRED SKIN PER EA 341176A.SDR AALA202212204467Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND FLOOR SUPPORT BREAK ASSEMBLY LOCATED AB BS 540 AND LBL 1. REPLACED BREAK ASSEMBLY PER AARD 51-00-05 -01.SDR AALA202212207167Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND FLOOR SUPPORT BREAK ASSEMBLY LOCATED AB BS 540 AND RBL 1. REPLACED BREAK ASSEMBLY PER AARD 51-00-05 -01.SDR AALA202212099304Winglet · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING WINGLET CENTER LEADING EDGE PANEL OUTBOARD SIDE. MAINTENANCE REPLACED WINGLET PER AMM 57-21-21-400-801.SDR AALA202212097137Door Track · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS DIFFICULT TO OPEN / CLOSE. TIGHTENED LOOSE SCREWS IN TOP JAMB. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212096674Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR STIFF. CLEANED AND LUBRICATE DOOR PER AMM 25-40-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212099597Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR PER AMM 25-40-14. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212096935Housing · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON SEAT 23C IS BROKEN AND ON FLOOR. REPLACED EMERGENCY EXIT LIGHT HOUSING PER AMM 33-51-11.SDR AALA202212090173Door · unserviceableAIRCRAFT WAS NOT GROUNDED: LAVATORY D ENTRY DOOR LOCK HARD TO OPEN. REPLACED DOOR ASSEMBLY PER CMM 25-40-64. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301179377Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SKIN PANEL AROUND AFT DRAIN MAST LOCATED BETWEEN BS 968.5 AND BS 1016, AND BETWEEN S24L AND S25L. REPAIRED SKIN PANEL PER EA 328200 AND SRM 51-40-02-0G.SDR AALA202301106228Apu · odorAIRCRAFT WAS GROUNDED: ON INITIAL TAXI WITH POWER UP GOT DIRTY SOCK SMELL IN COCKPIT. FLIGHT ATTENDANTS DID NOT SMELL. DISSIPATED ON TAKEOFF ROLL SMELL BEGAN AGAIN AND STRONGER. FROM GASPER VENTS. FLIGHT ATTENDANTS DETECTED SMELL DIRTY SOCKS FOR 5 MINUTES, THESDR AALA202212207920Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR INTERCOSTAL IS CRACKED BETWEEN STA 312 TO 328 AND LEFT BUTT LINE 44. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202212206719Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR INTERCOSTAL CRACKED BETWEEN STA 277 AND 291 RIGHT BUTT LINE 3. INSTALLED NEW INTERCOSTAL PER AARD PER 51-00-05-1.SDR AALA202212207138Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN STA 312 TO 328 AND RIGHT BUTT LINE 31. REMOVED AND REPLACED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202212207501Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT WHEEL WELL VAPOR BARRIER IS CRACKED APPROXIMATELY 6 INCHES IN BAY 7R. REMOVED OLD DISBONDED REPAIR, AND REPLACED WITH NEW FABRIC REPAIR PER SRM 10-10-2R-2.SDR AALA202212146064Floor Panel · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR STRUCTURE AT STA 540 LEFT PANEL BREAK CRACKED. REMOVED AND REPLACED CRACKED PANEL BREAK AT STA 540 LEFT PER B737 NG SRM 51-40-02.SDR AALA202212143146Pan · crackedCRACKED PORTABLE WATER SERVICE PANEL, INTERNAL PAN, BS 924, S26R. REPLACED THE PAN IAW DWG 147A7221 AND AARD 51-00-05-1.
Back to Boeing 737-823