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 AALA202601154039Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE-FITTING AT BS 947, FROM RBL 52 TO LBL 52. REPLACED UPPER TEE FITTING PER SRM 53-70-51-2R-5SDR AALA202601153880Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER T-FITTING AT STA 986.5, LBL 43. REPAIRED TEE FITTING PER SRM 53-70-51-2R-6.SDR AALA202601151327Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 95O, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202601154980Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER T-FITTING AT BS 947, RBL 24. REPAIRED UPPER TEE FITTING PER SRM 53-70-51-2R-5.SDR AALA202601154566Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 951, RBL 25. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-01.SDR AALA202601150200Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 951, LBL 25. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-01.SDR AALA202601150764Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT FROM BS 950 TO BS 957, AT LBL 50. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202601157803Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT UPPER SECTION FROM BS 944 TO BS 947, AT LBL 25. REPLACED THE UPPER SECTION PER AARD 51-00-05-1.SDR AALA202601155449Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT BS 986.5, LBL 42.5. REPAIRED THE FLOORBEAM TEE IAW SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202601156784Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAMAT BS 951, FROM RBL 27 TO RBL 49. REPLACED FLOORBEAM IAW AARD 51-00-05-01.SDR AALA202511190417Pump · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING CRUISE NR 2 FUEL TANK AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AND REMAINED ILLUMINATED. VERIFIED NR 2 AFT FUEL BOOST PUMP INOPERATIVE. REMOVED AND REPLACED NR 2 AFT FUEL TANK IMPELLER PUMP MOTOR. PER AMM 28-22-41. OPS CSDR AALA202511130073Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 284.5, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202511041624Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT ROW EXIT SIGN ON OVER HEAD WAS KNOCKED OFF BY PASSENGER. REINSTALLED EXIT SIGN ON OVERHEAD IN CABIN. OPERATIONAL CHECKS NORMAL. PER AMM 33-51-01-960-802.SDR AALA202511040417Pump · low pressureAIRCRAFT WAS NOT GROUNDED: DURING CRUISE NUMBER 2 FUEL TANK AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AND REMAINED ILLUMINATED. VERIFIED NUMBER 2 AFT FUEL BOOST PUMP INOPERATIVE. (OPEN).SDR AALA202511047059Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ATTACHMENT UNSECURE AT SEAT 15C. RESECURED SEAT MOUNTED LIGHT AT 15C. PER AMM 33-51-11.SDR AALA202511041333Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY FLASHLIGHTS ON THE RIGHT SIDE IN THE AFT GALLEY ARE INOPERATIVE. RESET CONTACTS ON OUTBOARD FLASHLIGHT (AALA202511041333), OPERATIONAL CHECKS GOOD. ADDITIONALLY, REMOVED AND REPLACED INBOARD FLASHLIGHT (AALA20251104SDR AALA202511047047Coffeemaker · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORT BURNING SMELL IN AFT GALLEY. TROUBLESHOT AND FOUND AFT GALLEY UPPER COFFEE MAKER LEAKING ON HEATING PAD. REMOVE AND REPLACED AFT GALLEY UPPER COFFEE MAKER. PER AMM 25-32-00. GROUND OPERATIONAL CHECK GOOD ATTHIS TISDR AALA202511041627Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY FLASHLIGHTS ON THE RIGHT SIDE IN THE AFT GALLEY ARE INOPERATIVE. RESET CONTACTS ON OUTBOARD FLASHLIGHT (AALA202511041333), OPERATIONAL CHECKS GOOD. ADDITIONALLY, REMOVED AND REPLACED INBOARD FLASHLIGHT (AALA20251104SDR AALA202511033306Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR VERY DIFFICULT TO OPEN. LAVATORY-D DOOR ADJUSTED AND LUBRICATED. PER AMM 52-50.SDR AALA202511036223Fitting · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT DOOR AIRCRAFT RIGHT GIRT FLAP NOT PROPERLY PLACED INSIDE SLIDE COMPARTMENT HARD TO ARM DISARM DOOR. ADJUSTED GIRT BAR RETAINER CLIPS ON 2R PASSENGER DOOR. PER AMM 25-66-01.SDR AALA202511039391Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, LOCATED IN RIGHT ECS BAY, AT BS 663, RBL 20. REPLACED THE ATTACH ANGLE IAW SRM 57-10-10-2R-5.SDR AALA202511038553Light · not seatedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOPERATIVE AT ROW 19 LEFT SIDE. RESEATED OVERHEAD EMERGENCY LIGHT ASSEMBLY. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202511035115Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. REMOVE AND REPALCED LAVATORY-D DOOR ASSEMBLY. PER CMM 25-40-64.SDR AALA202511037617Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202511035458Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: OVERHEAT EXIT SIGN DAMAGED FROM PASSENGERS BAG ROW 16-17. SECURED THE LIGHT. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202511035678Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR HOLDER HAS A LOOSE CLIP. TIGHTENED GIRT BAR HOLDER. PER AMM 52-11-00. OPERATIONAL CHECK GOOD.SDR AALA202511032395Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LOCK ON FORWARD LAVATORY DOOR IS DIFFICULT TO LOCK AND UNLOCK. LUBED FORWARD LAVATORY LOCK. OPERATIONAL CHECK GOOD.SDR AALA202511032583Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED DOOR HANDLE.SDR AALA202511035433Cradle · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND FLIGHT ATTENDANT SEAT OUTBOARD FLASHLIGHT BRACKET GREEN LIGHT WILL NOT TURN ON. REMOVED AND REPLACED FLASHLIGHT MOUNTING BRACKET. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202511031928Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT ENTRY DOOR LEFT GIRT BAR HARD TO DISARM. ADJUSTED L2 DOOR GIRT BAR HOOKS. PER AMM 25-66-01. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202511038050Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: LEFT AFT FUEL PUMP DOES NOT ILLUMINATE LOW PRESSURE IN THE OFF POSITION. REMOVED AND REPLACED LEFT AFT FUEL PUMP LOW PRESSURE SWITCH. PER MM 28-42-11. OPERATIONAL AND LEAK CHECKS GOOD.SDR AALA202511037432Sign · unsecureAIRCRAFT WAS NOT GROUNDED: 27C EXIT SIGN WILL NOT STAY ON. RESECURED SEAT 27C FLOOR PROXIMITY LIGHT. PER AMM 33-51-11.SDR AALA202511038694Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT ROW LIGHT DETACHED FROM CEILING. RESECURED EMERGENCY EXITS LIGHT BRACKET. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202510315693Gust Lock · brokenAIRCRAFT WAS GROUNDED: L1 DOOR WILL NOT OPEN. FOUND GUST LOCK LICK BROKEN. REMOVED AND REPLACED L1 ENTRY DOOR HINGE PIN. PER AARD 52-10-00-4 REPAIR 4.SDR AALA202512091284Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK IN FLOORBEAM LOCATED AT BS 540 BETWEEN LBL 1 AND LBL 24. REPLACED FLOORBEAM IAW AARD 51-00-05-01.SDR AALA202512065874Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540 FROM RBL 1 TO RBL 24. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510318811Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: R2 DOOR GIRT BAR RED HEAT SHRINK MISSING ON ONE SIDE. INSTALLED RED HEATSHRINK ON R2 DOOR GIRT BAR.SDR AALA202510315548Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: LEFT FUEL FILTER BYPASS LIGHT CAME ON AFTER TAKEOFF. REMOVED AND REPLACED LEFT ENGINE FUEL FILTER. PER MM 73-11-02. OPERATIONAL AND LEAK CHECK GOOD.SDR AALA202510315994Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. INSPECTED LAVATORY-D BIFOLD DOOR, ADJUSTED LATCH, LUBED TRACKS, OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202510319363Door · looseAIRCRAFT WAS NOT GROUNDED: DOOR IS VERY DIFFICULT TO OPEN AND CLOSE IN LAVATORY-D IN REAR OF AIRCRAFT. FOUND TOP DOOR TRACK SCREWS LOOSE RESECURED AS REQUIRED.SDR AALA202510312883Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT ATTENDANTS IN THE AFT CABIN REPORTED A STRONG BURNING SMELL OF A BURNING ELECTRICAL CABLE JUST AFTER TAKEOFF. THIS WAS ALSO REPORTED BY PASSENGERS IN THE LAST 6 ROWS OF THE CABIN. AIRCRAFT AIR INTSDR AALA202511040653Air Filter · contaminatedAIRCRAFT WAS GROUNDED: DIRTY SOCK SMELL ON CLIMB OUT AND LANDING IN THE CABIN AND COCKPIT. COMPLIED WITH JOB CARD 08L00021001 AND FOUND NO DEFECTS AT HIS TIME WITH EITHER ACM, RECIRCULATING FANS, HEAT EXCHANGERS OR CONDENSERS. CHANGED RECIRCULATING FILTERS ASDR AALA202510309537Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER FORWARD FLIGHT ATTENDANT JUMPSEAT IS INOPERATIVE. REMOVED AND REPLACED FLISHLIGHT UNDER JUMPSEAT. PER IAW AMM 25-64-00.SDR AALA202510300653Unknown · odorAIRCRAFT WAS GROUNDED: DIRTY SOCK SMELL ON CLIMB OUT AND LANDING IN THE CABIN AND COCKPIT. (OPEN).SDR AALA202510302533Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB INTERNAL WEB AT THIRD STIFFENER AFT OF FORWARD SPAR, AT STABILIZER STA 92.70. REPLACED WEB PER SRM 51-40-02.SDR AALA202510291172Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ELEVATOR UPPER SKIN DELAMINATED / DISBONDED, AT ELEVATOR STA 70, STAB BL 113.25. REPAIRED SKIN PER SRM 51-70-04-2R-1.SDR AALA202510291625Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT LOCATED AT FORWARD ENTRY JUMPSEAT 3 IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT. PER 25-64-00-600.SDR AALA202511047189Elec Connector · shortedAIRCRAFT WAS NOT GROUNDED: ANTI-SKID INOPERATIVE ON TOUCHDOWN AUTO-BRAKE DISARMED AND ANTI-SKIP INOPERATIVE LIGHT ILLUMINATED. ACCOMPLISHED BITE OF AACU FOUND FAULT FOR XDCR3. PERFORMED FIM 32-42-00-810-806. FOUND CONNECTOR D11124 IS INTERNALLY SHORTING. REPLSDR AALA202510301497Engine · contaminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ODOR THROUGHOUT THE WHOLE CABIN. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED BIRD STRIKE INSP. PER J/C08L00005056. ALSO ECO WASHON ENGINE NUMBER 2 PER J/C 08L40072009 AN SOF TSDR AALA202510297189Anti-Skid Sys · faultedAIRCRAFT WAS NOT GROUNDED: ANTI-SKID INOPERATIVE ON TOUCHDOWN AUTO-BRAKE DISARMED AND ANTI-SKIP INOPERATIVE LIGHT ILLUMINATED. ACCOMPLISHED BITE OF AACU FOUND FAULT FOR XDCR3. OPEN.
Back to Boeing 737-823