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 AALA201806073005Probe · inaccurateDIVERTED DUE TO A FUEL IMBALANCE OF 3500 POUNDS. AN EMERGENCY DECLARED. THE AIRCRAFT LANDED WITHOUT INCIDENT AND REMOVED FROM SERVICE. DETERMINED THAT THE RIGHT FUEL QUANTITY WAS INCORRECT. PERFORMED FIM 28-41-00-810-814, NO FAULTS NOTED. TEST PASSED. FQIS SDR AALA201806052007Support Angle · corrodedCORROSION FOUND ON THE SUPPORT ANGLE AT BS 1016, LBL 32. REPLACED THE SUPPORT ANGLE IAW 51-00-05.SDR AALA201806059022Spring · brokenA SPRING WAS FOUND BROKEN ON THE L1 DOOR HINGE RELEASE TAB GUST LOCK, YELLOW LEVER. REPLACED THE SPRING IAW AMM 52-11-00. OPS CHECKED OK.SDR AALA201806052006Angle · corrodedCORROSION FOUND ON GALLEY FLOORBEAM ANGLE AT BS 993, BETWEEN LBL 32 - 46. REPLACED THE FLOORBEAM ANGLE IAW 51-00-05.SDR AALA201806052001Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM ANGLE AT BS 993, BETWEEN RBL 32-46. REPLACED THE FLOORBEAM ANGLE IAW 51-00-05.SDR AALA2018060691002Transition Panel · corrodedRIGHT TRANSITION PANEL HAD CORROSION AT BS 727A +9. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA2018060691003Transition Panel · corrodedDURING INSPECTION, FOUND NUMEROUS CORROSION AREAS ON THE LEFT TRANSITION PANEL BETWEEN BS 807 - 827. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA201806054003Transition Panel · corrodedCORROSION FOUND ON THE TRANSITION PANEL AT NUMEROUS LOCATIONS BETWEEN BS 727D - 847. REPLACED ENTIRE LEFT TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA201806051007Web · corrodedAFT CARGO DOOR THRESHOLD WEB CORRODED AT MULTIPLE PLACES FROM BS 807 - 827. REPLACED THE ENTIRE WEB IAW 51-00-5-R1.SDR AALA201806051009Support Angle · corrodedCORROSION WAS FOUND ON THE ZEE ANGLE AT BS 1016, RBL 32. REPLACED ANGLE IAW 51-00-05-1.SDR AALA201806051006Web · corrodedTHE DOORWAY WEB WAS FOUND TO HAVE CORROSION IN SEVERAL SPOTS. REPLACED ENTIRE WEB ASSEMBLY AT THE AFT CARGO THRESHOLD IAW 51-00-05-R1.SDR AALA201806041016Floor Support · corrodedCORROSION FOUND ON THE ON FLOOR SUPPORT BS 951, LBL 22. REPAIRED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 147A5650.SDR AALA201806041015Transition Panel · corrodedRIGHT TRANSITION PANEL CORRODED BETWEEN BS 847 TO 867. REPLACED THE TRANSITION PANEL IAW SRM 51-10-2, PARAGRAPH G.SDR AALA201806041014Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 767 PLUS 6 INCHES, RBL 24. REPLACED THE FLOOR SUPPORT IAW DRAWING 146A8128 AND 51-00-05-1.SDR AALA201806041013Transition Panel · corrodedRIGHT TRANSITION PANEL CORRODED BETWEEN BS 767 TO 787. REPLACED THE TRANSITION PANEL IAW DRAWING 146A8127, AND 51-00-01-1.SDR AALA2018060631002Floorbeam · crackedFLOORBEAM ASSEMBLY CRACKED AT BS 540, RBL 2. REPLACED FLOORBEAM ANGLE IAW SRM 51-40-02.SDR AALA2018060419004Light · brokenCOVER FOR THE EMERGENCY LIGHT IN THE FORWARD ENTRY GALLEY AREA, MISSING SOME CONNECTION TABS CAUSING COVER TO FALL OFF ON OCCASION. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14.SDR AALA2018060131001Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 AND 328, LEFT SIDE, JUST BELOW L1 ENTRY DOOR AREA. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 141A5400.SDR AALA2018060631003Floorbeam · crackedFLOORBEAM CRACKED BETWEEN SEAT TRACKS 1 AND 2, BS 540. REPLACED THE FLOORBEAM IAW SRM 51-40-02.SDR AALA201806049015Spacer · detachedPIECE OF TEFLON FELL OFF FORWARD R1 DOOR SLIDE. INSTALLED TEFLON SPACER ON THE GIRT BAR, OPS CHECKED NORMAL IAW AMM 25-66-01.SDR AALA201805310010Floorbeam · corrodedCORROSION ON THE TOP OF THE FLOORBEAM, BS 947.5, LBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R-1, AND SRM 51-40-02.SDR AALA201805310008Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT AROUND A FASTENER AT BS 951, LBL 17. REPLACED THE FLOOR SUPPORT IAW SRM 51-00-05-1R-1.SDR AALA201805310005Skin · crackedCRACK ON LOWER SKIN OF THE LEFT HORIZONTAL STABILIZER ALONG THE RIB LINE AT HSS 129.50. REPAIRED THE SKIN IAW 55-10-01-2R-11.SDR AALA2018053100009Floorbeam · corrodedCORROSION FOUND ON THE TOP OF THE FLOORBEAM BS 947.5, RBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R, AND SRM 51-40-02.SDR AALA2018053100006Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL BETWEEN BS 747 - 787. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-1A-2.SDR AALA2018060519004Girt Bar · detachedFORWARD GALLEY SLIDE GIRT BAR APPEARS TO BE PULLED OUT. FABRIC DRAGS. REPOSITIONED SEALING SKIRT AND VERIFIED SLIDE AND GIRT BAR INSTALLATION IAW MM 26-62-44.SDR AALA201806049002Battery · inoperativeLEFT AFT CABIN FLASHLIGHT WAS FOUND INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY IAW MM 25-64-00.SDR AALA2018053029006Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 - 344, LBL 46. REPLACED THE FLOOR SUPPORT IAW DRAWING 141A5410, AND 51-00-05-1.SDR AALA2018060529004Battery Pack · faultedEMERGENCY LIGHT REMAINED ON ALL THE TIME. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED NORMAL. OK FOR SERVICE. THE AIRCRAFT WAS GROUNDED.SDR AALA2018060459007Indicator · malfunctionedAFTER TAKE OFF DURING GEAR RETRACTION RECEIVED THREE RED LIGHTS WHILE GEAR HANDLE SELECTED UP. AN EMERGENCY WAS DECLARED. FLIGHT LANDED WITHOUT INCIDENT. AIRCRAFT WAS GROUNDED. PERFORMED FIM 32-61-00-810-809. NO FAULTS FOUND, SWUNG GEAR. OPS CHECKED NORMAL. SDR AALA201805299048Sliding Window · defectiveAIRCRAFT WAS NOT GROUNDED. LEFT HAND SLIDING WINDOW DIFFICULT TO CLOSE. REPLACED LEFT HAND COCKPIT WINDOW ASSEMBLY NR 2 PER AMM 56-12-11.SDR AALA201805299009Sliding Window · crackedFIRST OFFICER`S SLIDING SIDE WINDOW WAS CRACKED. REPLACED THE SLIDING WINDOW IAW MCM CARD 56-94-02. OPS AND LEAK CHECKED OK. AIRCRAFT WAS GROUNDED.SDR AALA20180528004Floorbeam · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON TOP OF FLOORBEAM AT STATION 951 LBL 50.5. REPLACED FLOORBEAM PER 51-00-05.SDR AALA20180528002Floorbeam · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. SEVERAL AREAS OF CORROSION FOUND OUT OF LIMITS ALONG UPPER T CHORD AT STATION 986.5 FROM LBL 53 TO RBL 53. REPAIRED UPPER T CHORD PER SRM 53-70-51-2R-4.SDR AALA2018060528005Pressure Switch · failedFUEL FILTER BYPASS LIGHT, RIGHT ENGINE, DURING CLIMBOUT, CAME ON TWICE AND STAYED ON THRU LANDING. EMERGENCY WAS DECLARED, FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED RIGHT ENGINE FUEL DIFFERENTIAL PRESSURE SWITCH IAW AMM 73-34-01 AND PERFSDR AALA20180527003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: L1 EMERGENCY EXIT LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT, BATTERY PACK, M1675 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA2018052989022Battery Pack · dischargedFORWARD FLIGHT ATTENDANT STATION, RIGHT FLASHLIGHT HAD A LOW BATTERY CHARGE. REPLACED THE FLASHLIGHT ASSEMBLY AND OPS CHECKED OK IAW AMM 25-60-00.SDR AALA2018052989013Floor Panel · damagedMAIN CABIN FLOOR PANEL HAS SOFT SPOT AT SEAT ROW 12. REPAIRED THE FLOOR PANEL IAW 53-00-00-6, REPAIR 6. AIRCRAFT WAS GROUNDEDSDR AALA201805299001Smoke Warning · false activationLAVATORY SMOKE LIGHT ILLUMINATED DURING CRUISE FOR APPROX. 5-6 SECONDS, AND THEN EXTINGUISHED. NO EVIDENCE IN LAVATORYS OF SMOKE OR FUMES. ACCOMPLISHED A LAVATORY SMOKE DETECTION TEST IAW AMM 26-14-00. ALL CHECKED NORMAL.SDR AALA201805295009Strap · corrodedAFT CARGO INTERCOSTAL STRAP HAS CORROSION AT BS 787 PLUS 5 INCHES, STRINGER 24L. REPLACED THE STRAP IAW 51-00-05-1.SDR AALA2018052959017Girt Bar · detachedGIRT BAR CAME OUT OF THE SHROUD AT THE L4 DOOR. SECURED THE GIRT BAR IAW AMM 25-66-01. NO OTHER DEFECTS NOTED. AIRCRAFT OK FOR SERVICE.SDR AALA20180524005Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT HAND TRANSITION PANEL BETWEEN STA 727I TO STA 747. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA20180524003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON AFT CARGO, RIGHT HAND TRANSITION PANEL, BETWEEN STA 727J TO STA 767. REPAIRED RIGHT HAND TRANSITION PANEL PER SRM 53-00-53-2R 5.SDR AALA201805259007Window · crackedFLIGHT ATTENDANT REPORTED DAMAGE TO THE WINDOW OF THE R4 DOOR. CHECKED AND FOUND APPROXIMATELY A 1-1/2 INCH CRACK IN INNER PANE. VISIBILITY OK. OK FOR SERVICE IAW MM 56-31-00. REPLACED IAW AMM56-31-00.SDR AALA201805259006Window · crackedFLIGHT ATTENDANT REPORTED DAMAGE TO THE WINDOW AT THE L4 DOOR. CHECKED AND FOUND APPROXIMATELY A 1/2 INCH CRACK IN THE INNER PANE. VISIBILITY OK. REPLACED IAW AMM 56-31-00. OK FOR SERVICE.SDR AALA20180523006Shield · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND IN SEVERAL AREAS OF THE RIGHT HAND SHIELD ASSEMBLY BETWEEN STA 767 TO STA 787. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05 AND SRM 51-10-02.SDR AALA20180523001Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT CREASE ANGLE BETWEEN STA 325 TO STA 332 AT FORWARD SERVICE DOOR AREA. REPLACED CREASE ANGLE PER 51-00-05-1.SDR AALA2018060523007Connector · brokenFOUND CONNECTOR D40040P BROKEN AT THE L1 DOORWAY HEADER PANEL. REMOVED AND REPLACED THE CONNECTOR IAW SWPM 20-72-24, WDM 35-21-21, 33-51-12, AND 23-31-04. PERFORMED AN OPS TEST IAW AMM 33-51-00, 23-31-01, AND 35-22-00. OPS CHECKED GOOD. THE AIRCRAFT WAS GRSDR AALA201805259005Brake · seizedAIRCRAFT WAS GROUNDED. ON THE LANDING, #2 TIRE BLEW AND CAUSED DAMAGE TO LEFT HAND INBOARD MAN/AFT FLAP. REPLACED THE NR 2 MAIN LANDING GEAR BRAKE ASSEMBLY PER AMM 32-41-41. (SEE ALSO SDR'S AALA20180522007 AND AALA201805239028.)SDR AALA2018052939028Tire · failedNR 1 TIRE BLEW ON LANDING ROLLOUT. NORMAL LANDING WITH NO INDICATIONS OF TIRE PROBLEM ON LANDING OR ROLLOUT OR TAXI. REPLACED THE NR 1 MAIN WHEEL ASSY IAW AMM 32-45-11. AIRCRAFT WAS GROUNDED.
Back to Boeing 737-823