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 AALA201909039004Pump · failedAIRCRAFT WAS GROUNDED: PILOT DECLARED EMERGENCY ON ACCOUNT OF HYDRAULIC GREEN SYSTEM OVHT ON ECAM AFTER T/O THROUGH 6K FT. GREEN SYSTEM LOW PRESSURE IAW QRH MANUAL LAND. GEAR EXTENSION G SYSTEM LOW PRESSURE G 1 ENGINE PUMP LOW PRESSURE (ECAM MESSAGE). MAINTENSDR AALA201909039010Plate · crackedAIRCRAFT WAS GROUNDED: R1 DOOR FORWARD BOTTOM STOP BEARING PLATE IS CRACKED. REPLACED STOP BEARING PLATE PER AMM 52-41-01.SDR AALA201909029003Oven · odorAIRCRAFT WAS GROUNDED: PILOT REPORTS STRONG MUSTY/ACRID ODOR IN CLIMB OUT. DISSIPATED ON ITS OWN, BOTH COCKPIT AND CABIN. MAINTENANCE REPORTS ODOR/FUMES TROUBLESHOOTING ACCOMPLISHED IAW JOB CARD 05-96-70. SOURCE OF ODOR DETERMINED TO BE FROM FORWARD GALLEY OVESDR AALA201909019004Bracket · lack of lubeAIRCRAFT NOT GROUNDED: L1 EMERGENCY SLIDE DIFFICULT TO ARM AND DISARM. LUBRICATED L1 SLIDE ARM AND DISARM BRACKETS IAW AMM 25-66-00. CHECKS OK PER AMM 25-66-00.SDR AALA201909179025Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT LOWER THRESHOLD WEB BETWEEN BS 445 AND BS 490 AT S25R AND RBL 29. REPLACED WEB SRM 51-10-02.SDR AALA201909099052Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BAFFLE CLIP AT FORWARD SIDE OF FRAME AT FR 500G, S-25L TO S-26L. REPLACED BAFFLE CLIP PER 51-00-05-01 AND DRAWING 143A7505.SDR AALA201909099051Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BAFFLE CLIP AT FORWARD SIDE OF FRAME AT FR 500H, S25L TO S26L. REPLACED BAFFLE CLIP PER 51-00-05 AND DRAWING 143A7505.SDR AALA201909099046Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO BAFFLE CLIP FORWARD SIDE OF FRAME AT FR 500H, S-25R TO S-26R. REPLACED BAFFLE CLIP PER 51-00-05-1 AND DRAWING #143A7505.SDR AALA201909099045Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO BAFFLE AFT SIDE OF FRAME AT FR 500, S-25R TO S-26R. REPLACED BAFFLE PER 51-00-05-1 AND DRAWING #142A7505.SDR AALA201909099044Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO BAFFLE AT FR 500H, S-25R TO S-26R. REPLACED BAFFLE PER 51-00-05-1 AND DRAWING #142A7503.SDR AALA201909119026Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BAFFLE CLIP ON FORWARD CARGO AT FR 500G, S25L TO S26L, RBL-24. REPLACED BAFFLE CLIP PER 51-00-05.SDR AALA201909069028Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB AT BS 1016 AND LBL 32. REPLACED WEB PER 51-00-05-1.SDR AALA201909049064Not Reported · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FASTENER HOLE AT FR 353. REPLACED FASTENER HOLE PER SRM 51-40-02-0G AND DRAWING 141A5410.SDR AALA201909049037Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL FROM FR 312 TO FR 328, LBL41. REPLACED INTERCOSTAL PER 51-00-05-1 AND DRAWING #141A5400.SDR AALA201909049036Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT FR 313, RBL-31. REPLACED INTERCOSTAL PER 51-00-05-1 AND INSTALLATION DRAWING #141A5400.SDR AALA201909049074Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 244 AND BS 328 AT LBL 45. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA201908319005Slide · unsecureAIRCRAFT WAS GROUNDED: 1L EMERGENCY SLIDE FELL OUT OF DOOR UPON OPENING AT GATE. MAINTENANCE REMOVED AND REPLACED #1L EMERGENCY SLIDE IAW AMM 25-66-01.SDR AALA201908319008Smoke Detector · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS AFT RIGHT LAV SMOKE DETECTOR GOES OFF WITHOUT ANYONE IN LAVATORY. MAINTENANCE REMOVED AND REPLACED AFT RIGHT LAV SMOKE DETECTOR IAW AMM 26-14-00. OPS CHECK GOOD.SDR AALA201908319009Fmc · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS DUAL FMC FAILURE 30 MIN INTO FLIGHT AT 370 FL. WHILE ACCOMPLISHING QRH PROCEDURE BOTH FMCS REBOOTED BY THEM SELFS, RELOADED FLIGHT PLAN AND CONTINUED FLIGHT. MAINTENANCE ACCOMPLISHED BITE OF BOTH FMCS WITH NO FAULTS IAW FISDR AALA2019083000022Indicator · splitON APPROCH,FLAP INDICATOR SPLIT NEEDLES AT 7+9 AND FLAPS STOPPED TRACKING. COMPLETED QRH AND RESET FLAP LEVER TO 5. LANDED WITH FLAP LEVER AT 5.THE NEEDLES COME TOGETHER AT APPROX. 7.SDR AALA201909169032Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727F TO FR 727G, S-25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 767 TO FR 787, S-25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 747 TO FR 767, S-25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727J TO FR 747, S-25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727I TO FR 727J, S-25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727H TO FR 727I, S-25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169026Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727G TO FR 727H, S-25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727E TO FR 727F, S-25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169035Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL FROM FR 767 TO FR 787, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727D TO FR 727E, S-25R. REPAIRED TRANSITION PANEL WITH SPLICE PER SRM 53-00-53-2R-5.SDR AALA201909169023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727C TO FR 727D, S-25R. REPAIRED TRANSITION PANEL WITH SPLICE PER SRM 53-00-53-2R-5.SDR AALA201909169022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727B TO FR 727C, S-25R. REPAIRED TRANSITION PANEL WITH SPLICE PER SRM 53-00-53-2R-5.SDR AALA201909169021Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM FR 727A TO FR 727B, S-25R. REPAIRED TRANSITION PANEL WITH SPLICE PER SRM 53-00-53-2R-5.SDR AALA201909129009Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CLIP AT FR 1129, RBL-20. REPLACED CLIP PER 51-00-05.SDR AALA201909129008Stiffener · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STIFFENER AT FR 1126, RBL-16. REPLACED STIFFENER PER 51-00-05.SDR AALA201909049061Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT FR 225, RBL-12. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201908319010Antenna · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS ON FINAL APPROACH WITH COUPLED ILS IN COMMAND B , CAPTAINS FO BARS DISAPPEARED AND BOTH FD MASTER LIGHTS CAME ON. MAINTENANCE TROUBLESHOT IAW FIM TASK 22-11-00-810-801; FOUND MULTIPLE INSTANCES OF FAULT CODE 22-11051, NO RASDR AALA201908309006Transmitter · unreliableAIRCRAFT WAS GROUNDED: FLIGHT DIVERTED ON ACCOUNT OF FLAP ASYMETRY ISSUE. EMERGENCY DECLARED. ON APPROACH INTO CZM FLAP INDICATOR SPLIT NEEDLES AT 7+9 DEG AND FLAPS STOPPED TRACKING, COMPLETED QRH AND RESET FLAP LEVER TO 5 DEG THE NEEDLES CAME TOGETHER AT APPSDR AALA201909219005Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM UPPER FLANGE AT BS 987 BETWEEN LBL 28 AND LBL 45. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-4.SDR AALA201909219004Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT WET AREA FLOOR CREASE ANGLE AT BS 940 AND LBL 57. REPLACED CREASE ANGLE PER 51-00-05-1.SDR AALA201909199024Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT WET AREA FLOOR CREASE ANGLE BETWEEN BS 940 AND BS 993 BETWEEN RBL 46 AND RBL 55. REPLACED CREASE ANGLE PER 51-00-05-1.SDR AALA201909179019Intercostal · corrodedAIRCRAFT IN BASE MAINTENNACE: CORROSION ON AFT WET AREA FLOOR INTERCOSTAL AT BS 950 AT RBL 51. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA201909179018Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOORBEAM UPPER FLANGE AT BS 947.5 AND LBL 4. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5 AND EA 297899.SDR AALA201909179017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT "T" ANGLE AT BS 952 AND LBL 20. REPLACED ANGLE PER 51-00-05-1.SDR AALA201909179016Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER BETWEEN BS 310 AND BS 318 AT S23L. REPAIRED STRINGER PER SRM 53-00-03 AND EA 297923.SDR AALA201909169037Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL FROM FR 727I TO FR 727J, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169036Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL FROM FR 727J TO FR 747, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169034Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL FROM FR 727H TO FR 727I, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201909169033Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL FROM FR 727G TO FR 727H, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5SDR AALA201909129012Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727F AND BS 727G AT LBL 27. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.
Back to Boeing 737-823