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 AALA201803289001Stop Pin · out of rigL1 DOOR DIFFICULT TO CLOSE AND LOCK WITH HANDLE, APPEARED THAT THE LOCK LINK TO DOOR HANDLE WAS OUT OF RIG. FOUND VERTICAL ADJUSTMENTS AND STOP PINS OUT OF RIG. MAINTENANCE ACCOMPLISHED DOOR RIG IAW AMM 52-11-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180323009Channel · corrodedCORROSION FOUND ON THE AFT CARGO LEFT TRANSITION PANEL CHANNEL BETWEEN BS 727H TO 727G. REPAIRED THE TRANSITION PANEL CHANNEL IAW SRM 53-00-53-2R, 51-00-05-1, AND DRAWING 146A7502.SDR AALA20180323005Bulkhead Web · crackedVERTICAL PRESSURE BULKHEAD WEB AT BS 663 HAS A CRACK BETWEEN RBL 40 TO RBL 45.6. REPAIRED BULKHEAD WEB IAW SRM 57-10-10-2R-3, ALT 2.SDR AALA201804059002Transition Panel · corrodedTRANSITION PANEL HAS CORROSION BETWEEN BS 500 - 500A. INSTALLED A NEW TRANSITION PANEL IAW 53-00-53-2R-5.SDR AALA201803269002Light · damagedFOUND EMERGENCY EXIT LIGHT FORWARD OF R2 ASSEMBLY DAMAGED. REPLACED LIGHT ASSEMBLY IAW AMM 31-51-01-960-802.SDR AALA201803269004Lens · missingRIGHT FORWARD OVERWING EMERGENCY EXIT SIGN LENS MISSING. REMOVED AND REPLACED THE SIGN IAW MM 33-51-01. OPS CHECKED NORMAL.SDR AALA201803269003Light · brokenEMERGENCY LIGHT ASSEMBLY BROKEN ON BULKHEAD AFT OF RIGHT AFT LAVATORY. REPLACED LIGHT ASSEMBLY IAW MM 33-51-01.SDR AALA20180322001Support · erodedLEFT MLG WW WING TO BODY FAIRING SUPPORT LANDING IS ERODED AT BS 663 TO 674, LBL 28. REPLACED THE SUPPORT IAW 51-00-05-1.SDR AALA20180322002Support · erodedRIGHT HAND MAIN LANDING GEAR WHEEL WELL WING TO BODY FAIRING SUPPORT LANDING IS ERODED BETWEEN BS 663 TO 674, RBL 28. REPLACED SUPPORT IAW 51-00-05-1.SDR AALA20180410011Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT HAND TRANSITION PANEL AT STATIONS 500C TO 500D. INSTALLED SPLICE DOUBLER AND NEW SECTION OF TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA20180407002Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL BETWEEN BS 500 TO 500A. REPLACED THE TRANSITION PANEL IAW 51-10-05-1, AND SRM 51-10-02-OG.SDR AALA20180321002Rib · crackedRIGHT HORIZONTAL STABILIZER RIB AT HSS 92.7 HAS A CRACK IN THE 3RD RIB STIFFNER. FABRICATED, TREATED AND PRIMED REPAIR PARTS WITH CLEARANCE TO INSTALL IAW 55-10-09-2R-4.SDR AALA201803269001Sliding Window · defectiveFIRST OFFICER`S WINDOW NOT LATCHING PROPERLY, WINDOW POPPED OPEN VERY SLIGHTLY DURING TAKEOFF ROLL. AFTER LANDING, WINDOW INTERMITTENTLY NOT LOCKING FULLY. REMOVED AND REPLACED THE R2 SLIDING WINDOW. OPS CHECKED OK. IAW 56-94-02.SDR AALA20180321003Keelbeam · crackedCRACKED WING CENTER SECTION KEELBEAM AT BS 40.00 TO 45.64. INSTALLED REPAIR DOUBLER PER SRM 57-10-10-2R-3.SDR AALA20180321005Stiffener · corrodedCORROSION ON APU INLET LOWER HORIZONITAL STIFFENER. REPLACED THE STIFFENER IAW 51-00-05-R1, AND DRAWING 148A8650.SDR AALA20180321004Stiffener · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION ON APU COMPARTMENT INLET VERTICAL STIFFENER AT STATION 1125. REPLACED STIFFENER PER 51-00-05-R1 AND DRAWING 14848650.SDR AALA20180320007Strap · crackedDAMAGED STRAP BETWEEN BS 344 - 348, BL 0, AT ATTACH POINT. REPAIRED THE STRAP IAW SRM 53-10-51-2R-3, FIGURE 203.SDR AALA20180320005Angle · corrodedCORROSION ON THE ANGLE, BS 767, STRINGER 25R. INSTALLED A NEW ANGLE IAW DRAWING 146A0081, AND 51-00-05.SDR AALA20180320006Angle · corrodedCORROSION AROUND A NUTPLATE ON THE RIGHT ZEE ANGLE AT BS 869. REMOVED CORROSION AND INSTALLED A NEW ANGLE SRM 53-00-53-2R, 51-00-05-1, AND DWG 146A7502.SDR AALA201803219027Wire Harness · intermittentSEAT ROW 17DEF EMERGENCY LIGHT INTERMITTENT. REPLACED THE LIGHT ASSEMBLY AND HARNESS IAW AMM 33-51-11.SDR AALA201803219026Light · intermittentSEAT ROW 17DEF EMERGENCY LIGHT INTERMITTENT. REPLACED THE LIGHT ASSEMBLY AND HARNESS IAW AMM 33-51-11.SDR AALA20180320004Transition Panel · corrodedCORROSION ON THE AFT CARGO BAY RIGHT TRANSITION PANEL AT BS 777. REPLACED THE TRANSITION PANEL IAW DRAWING 146A0081, AND 51-00-05.SDR AALA20180319009Floor Support · crackedFLOOR SUPPORT CRACKED AT FLOORBOARD ATTACH HOLE BETWEEN BS 328 AND 344, LBL 46. INSTALLED A SERVICEABLE FLOOR SUPPORT IAW 51-00-05 AND DRAWING 141A5410.SDR AALA201803229004Cover · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN COVER DISLODGED AT ROW 15. MAINTENANCE REINSTALLED EMERGENCY EXIT SIGN ABOVE ROW 15 SEAT ISLE PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803229003Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EEL LENS AT ROW 7DEF MISSING. INSTALLED NEW EEL LENS AT ROW 7DEF PER AMM 33-51-03. GOOD FOR SERVICE.SDR AALA201803219028Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LENS MISSING AT AFT RIGHT GALLEY DOOR. REMOVED AND REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA201803219029Lens · missingCABIN ENTRY DOOR, EMERGENCY EXIT LIGHT LENS MISSING AT THE FORWARD GALLEY DOOR. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-02, AND PERFORMED SATISFACTORY OPERATIONAL CHECK, NO FAULTS NOTED.SDR AALA20180319010Floor Support · crackedCRACKED FLOOR SUPPORT AT BS 350 AND BL 0. INSTALLED A REPLACEMENT FLOOR SUPPORT IAW 51-00-05, AND DRAWING 141A5400.SDR AALA20180319004Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER INSPAR SKIN CRACKED AT HSS 138.70. REPAIRED THE LOWER INSPAR SKIN IAW SRM 55-10-01-2R, REPAIR 11.SDR AALA20180319012Support · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION AROUND FASTENER HOLES ON INBOARD R2 DOOR THRESHOLD SUPPORT CHORD AT STATIONS 963-984, RBL 48-52. REPAIRED THRESHOLD SUPPORT CHORD PER EA 278358.SDR AALA20180319008Intercostal · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. INTERCOSTAL CRACKED AT STATION 320 AND LBL 46 AT CENTER FLOOR BOARD ATTACH HOLE. REPLACED INTERCOSTAL PER 51-00-05 AND DRAWING 141A5410.SDR AALA201803219023Lens · missingRIGHT FORWARD SERVICE DOOR, THE EXIT SIGN LENS WAS MISSING. MAINTENANCE REPLACED THE SIGN LENS IAW AMM 33-25-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803209004Lens · missingFOUND THE AFT LEFT EXIT SIGN LENS MISSING DURING A PREFLIGHT. INSTALLED THE LENS IAW AMM 35-51-01.SDR AALA201803209001Slide · defectiveR1 DOOR SLIDE APPEARS TO BE FALLING OUT OF THE COVER, SLIDE FIRING PIN AND CHAIN ARE DRAGGING OVER THE DOOR THRESHOLD. REPLACED THE R1 DOOR ESCAPE SLIDE IAW AMM 25-66-01.SDR AALA20180318002Rail · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON FORWARD CARGO COMPARTMENT BACK WALL RAIL ASSEMBLY. REPLACED RAIL ASSEMBLY PER 51-00-05-1SDR AALA20180319001Air Filter · contaminatedTHE AIRCRAFT WAS GROUNDED. ON CLIMB OUT EXPERIENCED FUMES IN THE COCKPIT. PERSIST UP TO 12,000 FEET, WENT 100% OXYGEN. APU WAS OFF. THE FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO JFK. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. FUMES NOT NOTICED ON GROUND.SDR AALA201803219019Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT SEAT ROW 15F. REPLACED THE LENS.SDR AALA201803219011Cover · missingOVERWING EMERGENCY EXIT HANDLE COVER MISSING AT ROW 15F. MAINTENANCE REPLACED THE HANDLE COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803209005Floorboard · damagedAISLE FLOORBOARD BETWEEN ROWS 16 AND 17 POPPING. THE FLOORBOARD FROM ROW 15 TO 17 REPLACED IAW MM 53-21-00. AIRCRAFT WAS GROUNDED.SDR AALA201803209011Cover · missingEMERGENCY EXIT COVER MISSING AT SEAT ROW 15F. REPLACED EMERGENCY LIGHT COVER.SDR AALA201803209003Cover · missingROW 15F OVERWING EMERGENCY EXIT HANDLE COVER MISSING. REPLACED THE EMERGENCY EXIT HANDLE.SDR AALA201803199018Pump · defectiveTHE AIRCRAFT WAS GROUNDED. DIVERTED THE FLIGHT DUE TO A RIGHT ENGINE AFT SUMP CHIP DETECTOR INDICATION. DECLARED AN EMERGENCY AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE RIGHT ENGINE LUBRICATION UNIT. PERFORMED INSTALLATION TEST, NO LEAKS SDR AALA201803209002Cover · detachedEMERGENCY EXIT SIGN COVER DETACHED FROM THE AFT GALLEY WALL. REPLACED THE AFT EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201803209017Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. REPEAT ITEM AFT RIGHT EMERGENCY EXIT LENS NEXT TO FLIGHT ATTENDANT JUMP SEAT MISSING. ASSEMBLY CLIPS BROKEN. REMOVED AND REPLACED AFT RIGHT EMERGENCY LIGHT ASSEMBLY AND LENS COVER PER AMM 33-51-00. OPERATIONS CHECK NORMAL.SDR AALA20180316002Skin · crackedCRACK FOUND ON THE LEFT LOWER HORIZONTAL STABILIZER SKIN AT APPROXIMATELY HSS 92.70 AND 17 INCHES AFT OF FRONT SPAR. REPAIRED THE SKIN IAW SRM 55-10-01-2R-11. AIRCRAFT WAS GROUNDED.SDR AALA201803189001Sliding Window · delaminatedR2 SLIDING WINDOW DELAMINATED AT FWD UPPER POSITION. REPLACED THE SLIDING WINDOW IAW AMM 56-94-02. AIRCRAFT WAS GROUNDED.SDR AALA201803169013Lens · missingAFT RIGHT EMERGENCY EXIT SIGN IS MISSING THE LENS. REPLACED LIGHT LENS IAW AMM 33-00-00.SDR AALA201803169024Lens · missingR1 DOOR EMERGENCY EXIT LIGHT COVER MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT HOUSING AND LENS. PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-14.SDR AALA201803169014Housing · damagedR1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT HOUSING AND LENS, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-14.SDR AALA20180315004Floor Support · crackedCABIN FLOOR SUPPORT CRACKED BETWEEN BS 312 - 328, RBL 31. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.
Back to Boeing 737-823