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 AALA201912129018Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR INTERCOSTAL BETWEEN BS 986 AND BS 1006 AT LBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA2019120439056Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN EXPANSION JOINT AT BS 540 AND LBL 7. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA2019120299007Computer · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING DESCENT LNAV AND VNAV DISCONNECTED SEVERAL TIMES AND WOULD NOT REMAIN ENGAGED .AUTO PILOT B WAS ENGAGED ON PATH AND COUSE. MAINTENANCE PERFORMED LAND VERIFY TEST IAW AMM 22-11-00. FAILED ON ELEV SERVO AMP FCC-A. REPSDR AALA2019122399031Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR INTERCOSTAL AT BS 952 AND LBL 50. REPLACED INTERCOSTAL PER SRM 53-70-51-2R-5 AND SRM 51-40-02.SDR AALA2019122399030Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM UPPER "T" CAP AT BS 947 AND LBL 24. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA2019122399029Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM UPPER "T" CAP AT BS 947 AND LBL 50. REPAIRED FLOOR BEAM PER SRM 53-70-51-5R-5.SDR AALA2019121659003Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM AT BS 947 AND RBL 50. REPAIRED FLOOR BEAM PER SRM 53-70-51-25-R, EA 301303, EA 301175 AND EA 301138.SDR AALA2019120659024Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT BS 947 AND RBL 51. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA2019120549022Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT RBL 33. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019120549021Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 344 AND BS 366 AT RBL 6. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA2019120439059Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL AT BS 319 AND RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019120439057Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL AT BS 328 AND LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-01.SDR AALA201911289012Skin · crackedAIRCRAFT IN BASE VISIT: 0.900" CRACK IN L/H HORIZONTAL STABILIZER LOWER SURFACE IN-SPAR SKIN. REMOVED DAMAGED SKIN AND INSTALLED EXTERNAL DOUBLER WITH FILLER. INSTALLED REPAIR IAW SRM 55-10-01-2R-11.SDR AALA201911289011Skin · crackedAIRCRAFT IN BASE VISIT: 0.900" CRACK IN L/H HORIZONTAL STABILIZER LOWER SURFACE IN-SPAR SKIN. REMOVED DAMAGED SKIN AND INSTALLED EXTERNAL DOUBLER WITH FILLER. INSTALLED REPAIR IAW SRM 55-10-01-2R-11.SDR AALA201911289002Gust Lock · lack of lubeAIRCRAFT NOT GROUNDED: 1L GUST LOCK IS HARD TO OPERATE. LUBRICATED FWD ENTRY DOOR GUST LOCK IAW AMM12-25-11.SDR AALA201911279014Slide · out of positionAIRCRAFT WAS GROUNDED: AT DFW AFTER GATE ARRIVAL, CATERING DISCOVERED THE GIRT BAR WAS STILL ATTACHED TO THE FLOOR AT THE 1R DOOR. THE SLIDE BUSTLE FELL FROM THE DOOR CASING CAUSING AN INADVERTENT/UNSUCCESSFUL PARTIAL SLIDE DEPLOYMENT. MAINTENANCE REPLACED SLISDR AALA201912179023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER 51-00-05-1. SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVESDR AALA2019120659035Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727H AND BS 787 AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1. SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NOSDR AALA201912059034Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727 AND BS 727H AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1. SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NOSDR AALA2019120549023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727 AND BS 727H AT RBL 27. REPLACED TRANSITION PANEL PER AARD 51-00-05-1. SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVSDR AALA2019121879024Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT "L" CHANNEL AT FR 500I BETWEEN S27L AND S27R. REPLACED "L" CHANNEL PER AARD 51-00-05-1.SDR AALA2019121329057Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727H AND BS 787 AT S23R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201912109001Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION ANGLE BETWEEN BS 500B AND BS 520 AT S24L. REPAIRED TRANSITION ANGLE PER SRM 53-00-53-2R-5.SDR AALA2019120659032Pad · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON GIRT BAR RETAINER PAD AT BS 344 AND LBL 60. REPLACED PAD PER SRM 51-40-02.SDR AALA2019120439058Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL AT BS 352 AND LBL 12. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019121879022Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM AT BS 986 AND LBL 9. REPAIRED FLOOR BEAM PER EA 301074 AND SRM 53-70-51-2R.SDR AALA2019121639018Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA "Z" ANGLE AT BS 1014.5 AND LBL 29. REPLACED "Z" ANGLE PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA2019121639017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA "Z" ANGLE AT BS 992 AND LBL 29. REPLACED "Z" ANGLE PER AARD 51-00-05-1SDR AALA2019121639016Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM AT BS 947 AND BL 0. REPAIRED FLOOR BEAM PER EA 300873 AND SRM 53-00-51-2R.SDR AALA2019121329069Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA INNER CREASE ANGLE BETWEEN BS 990 AND BS 992 BETWEEN RBL 45 AND RBL 47. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA2019121329068Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM AT BS 986 AND LBL 17. REPAIRED FLOOR BEAM PER EA 301074.SDR AALA2019121329067Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM AT BS 986 AND LBL 45. REPAIRED FLOOR BEAM PER EA 301074.SDR AALA2019121329066Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR BEAM AT BS 986 BETWEEN LBL 39 AND LBL 41. REPAIRED FLOOR BEAM PER EA 301074.SDR AALA2019121329056Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA INNER CREASE ANGLE BETWEEN BS 977 AND BS 988 BETWEEN RBL 49 AND RBL 53. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA2019121329055Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA INNER CREASE ANGLE AT BS 951 BETWEEN RBL 52 AND RBL 55. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA2019121329054Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT ANGLE AT BS 792 AND RBL 24. REPLACED FLOOR SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA2019121329053Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANISITION PANEL SHIELD AT BS 767 AND RBL 21. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2019121329052Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT FLOOR SUPPORT WEB AT BS 842 AND RBL 27. REPLACED WEB PER AARD 51-00-05-1.SDR AALA2019112759022Computer · unreliableAIRCRAFT WAS GROUNDED: FLIGHT AIR RETURNED TO MIA ON ACCOUNT OF NAVIGATION ISSUES AND NOISES FROM THE AVIONICS BAY. AN EMERGENCY WAS DECLARED. MAINTENANCE GAINED ACCESS TO E&E BAY. CHECKED EQUIPMENT FOR SECURITY. PERFORMED GVI OF E&E BAY. FOUND NO OBVIOUS SIGNSDR AALA201911269006Door · lack of lubeAIRCRAFT NOT GROUNDED: MANUAL GEAR EXTENSION DOOR WILL NOT OPEN. CLEANED AND LUBRICATED DOOR PULL AND FLANGE. OPS CHECKED GOOD.SDR AALA201912059020Pressure Switch · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS NO. 2 FUEL FILTER BYPASS ILLUMINATED DURING TAKEOFF ROLL. LOW SPEED ABORT 10 KTS. MAINTENANCE REMOVED & REPLACED #2 ENGINE LOW FUEL PRESSURE SWITCH IAW AMM 73-34-01 OK FOR SERVICE.SDR AALA2019120439062Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D AND BS 500E AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5SDR AALA2019120439061Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500D AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019120439060Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL SHIELD AT BS 500 AND S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2019112759028Drain Line · brokenAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT A SMELL OF DIRTY SOCKS IN THE MAIN CABIN. NO SMELL DETECTED ON THE FLIGHT DECK. TURNING OFF THE RIGHT AIR CONDITIONING PACK SEEMS TO DECREASE THE ODOR ALONG WITH THE RECIRC FANS OFF. MAINTENANCE REPORTS FOUL ODORSDR AALA2019112659010Connector · looseAIRCRAFT WAS GROUNDED: ROW 14, 15, AND 16 DEF EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE RECONNECTED LOOSE CONNECTORS AND REVERSED PINS AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER WDW 31-51-13.SDR AALA201911259026Unknown · fireAIRCRAFT NOT GROUNDED: WHILE ON TAXI. FLT CREW FROM A FOLLOWING AIRCRAFT REPORTED FIRE EMANATING FROM NO. 2 ENGINE BREATHER TUBE. MAINTENANCE INSPECTED #2 ENGINE IAW-AMM 71-00-00-800-803 F00 AND FOUND OKAY FOR SERVICE.SDR AALA201911259025Landing Gear · malfunctionedAIRCRAFT NOT GROUNDED: AFTER TAKEOFF AND LNDG GEAR RETRACTED- IN THE PROCESS OF PLACING THE LNDG GEAR HANDLE IN THE OFF POSTION THE RED LNDG GEAR IN TRANSIT LTS ILLUMINATED AND THE GEAR BEGAN TO EXTEND. PLACED GEAR HANDLE TO UP POSISTION BEFORE THE GEAR FULLYSDR AALA201911259027Smoke Detector · false activationAIRCRAFT NOT GROUNDED: FWD LAV SMOKE DETECTOR CHIMED 4 TIMES. NO SMOKE OR HEAT SEEN OR FELT. ACCOMPLISHED OPS CHECK FWD LAV. DET. OPS CHECK PASSED IAW AMM 26-014-00.SDR AALA201912189023Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 537 AND RBL 24. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.
Back to Boeing 737-823