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 AALA201910249015Angle · corrodedAIRCRAFT IN BASE VISIT: LH TRANSITION ANGLE CORRODED AT 727D-847, LBL24. REMOVED AND REPLACED TRANSITION ANGLE IAW SRM 53-00-53-2R.SDR AALA2019102219001Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229012Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229013Compensator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229014Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229015Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229017Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229026Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER FROM BOTH WINGS TO CENTER IN FLIGHT. OVER 1000 LBS DRAINED FROM THE WINGS BEFORE THE CENTER WAS EMPTY. MAINTENANCE REMOVED AND REPLACED LH TANK PROBES 1, 3, AND COMPENSATOR AND RH PROBES 1 ,3, 7, 9SDR AALA201910229029Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT ANGLE AT BS 540 AND RBL 1. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA201910229028Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT ANGLE AT BS 540 AND LBL 1. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA201910219051Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRCKED FORWARD WET AREA FLOOR INTERCOSTAL BETWEEN BS 277 AND BS 293 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201910219044Fmc · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS DURING CRUISE, LNAV AND VNAV BOTH DISCONNECTED, FOLLOWED BY VTK AMBER ANNUNC ON F/OS NAV DISPLAY. BOTH SIDES LOST RTE INFO. COULD NOT SELECT ANY DIRECT WYPTS. COULD NOT SELECT INIT REF PAGE. F/OS FMC MOMENTARILY DISPLAYEDSDR AALA201910219041Not Reported · noneAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS EVIDENCE OF BIRD STRIKE. MAINTENANCE ACCOMPLISHED ENG #2 INSPECTION IAW JOB CARD 05-96-12 AND AMM 71-00-00. OK FOR SERVICE. NO DEFECTS NOTED.SDR AALA201910219030Control Unit · unreliableAIRCRAFT WAS GROUNDED: CREW DECLARED AN EMERGENCY ON FINAL APPROACH INTO DFW ON ACCOUNT OF FLAP DISAGREE. MAINTENANCE ACCOMPLISHED FIM TASK 27-51-00-810-820 RH FLAPS POSTED TRANSMITTER DISAGREE PROBLEM FOR MAIN MESSAGE 27-52260. REMOVED AND REPLACED FSEU IAW ASDR AALA201910219037Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT STATION 138.7 AT THE 7TH RIB FROM THE INBOARD END APROXIMATELY 9 INCHES AFT OF THE FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA201910219031Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD WET AREA FLOOR INTERCOSTAL AT BS 290 AND BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019102189002Computer · faultedAIRCRAFT NOT GROUNDED: PILOT REPORTS VNAV NOT WORKING NORMAL T/O AT 1000 FT VNAV WOULD NOT ENGAGE. T/O WINDOW SHOWED A/T LIM WITH WHITE BOX AROUND IT )-NO CLB OR CRZ OR TO), TAT NORMAL. NO N1 LIM JUST GREEN DASHES ABOVE N1 GAUGES COND A/T AND A/P WORKED IN MSDR AALA201910229021Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 335 AND BS 336 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201910229020Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 318 AND BS 319 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201910219045Fmc · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPROTS BOTH FMC WENT OFF AND ALL FMC DOES BLANKED, BOTH RETURNED IN APPROX. 30 SEC. MAINTENACNE ACCOMPLISHED FMC RESET AND FIM TASK 34-61-00 WITH NO FAULTS FOUND.SDR AALA201910219035Hinge · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LAVATORY SERVICE PANEL FORWARD HINGE AT BS 847 AND S25. REPLACED HINGE PER SRM 51-10-02.SDR AALA201910189001Flap System · malfunctionedAIRCRAFT WAS GROUNDED: PILOT REPORTS LANDING FLAPS ONLY EXTENDED TO 15 WHEN SELECTED MORE THAN 15. MAINTENANCE RESET C/BS AT P6-2 C/B A11 AND P6-4 C/B D14 EXTENDED FLAPS AND SLATS, OPS CK NORMAL. ACCOMPLISHED FSEU BITE IAW FIM 27-51-00-810-801. OPS CHECK NORMASDR AALA201910189011Battery · dischargedAIRCRAFT WAS NOT GROUNDED: L1 DOOR, FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY DEAD. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00-201.SDR AALA201910189010Battery · dischargedAIRCRAFT WAS NOT GROUNDED: R2 DOOR, FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY DEAD. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00-201.SDR AALA201910249020Fitting · corrodedAIRCRAFT IN BASE VISIT: CORROSION ON GIRT BAR FLOOR FITTING AT BS344, S17L, LBL59. REMOVED AND REPLACED GIRT BAR FLOOR FITTING IAW SRM 51-00-05-1.SDR AALA201910249021Transition Panel · corrodedAIRCRAFT IN BASE VISIT: FWD CARGO COMPT. LH TRANSITION PANEL IS CORRODED FROM STA470-500H, LBL35. INSTALLED NEW SPLICE PLATES AND REPAIRED IAW SRM 53-160-00.SDR AALA201910249024Baffle · crackedAIRCRAFT IN BASE VISIT: BAFFLE CLIP IS CRACKED BELOW RH TRANSITION PANEL JUST AFTWARD OF BS 500H, S26R. REMOVED AND REPLACED BAFFLE CLIP IAW SRM 51-40-02.SDR AALA201910249025Angle · crackedAIRCRAFT IN BASE VISIT: BAFFLE CLIP IS CRACKED BELOW RH TRANSITION PANEL FORWARD OF BS 500H, S26R. REMOVED AND REPLACED BAFFLE CLIP IAW SRM 51-40-02.SDR AALA201910229022Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ATTACH ANGLE BETWEEN BS 500 AND BS 528 AT RBL 64. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA2019101869016Cabin Pressure · unknownAIRCRAFT WAS GROUNDED: FLIGHT RETURNED TO BNA ON ACCOUNT OF PRESSURIZATION PROBLEM. AN EMERGENCY WAS DECLARED. MAINTENANCE ACCOMPLISHED BIT TEST OF BOTH PRESS CONTROLLERS, NO FAULTS IAW FIM 21-31, TASK 801. ACCOMPLISHED PRESS SYS GROUND TEST IAW AMM 21-31-00-7SDR AALA201910179011Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILZER LOWER SURFACE SKIN AT STATION 147.9. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA201910169015Engine · cokedAIRCRAFT WAS GROUNDED: FLIGHT RETURNED TO ONT ON ACCOUNT OF LEFT ENGINE OIL BYPASS LIGHT ILLUMINATED. AN EMERGENCY WAS DECLARED. MAINTENANCE FOUND COKE/CARBON PARTICLES ON THE SCAVENGE FILTER. REMOVED AND REPLACED L/H ENGINE SCAVENGE OIL FILTER IAW AMM 79-21-0SDR AALA2019101869015Engine · cokedAIRCRAFT WAS GROUNDED: FLIGHT RETURNED TO ONT ON ACCOUNT OF LEFT ENGINE OIL BYPASS LIGHT ILLUMINATED. AN EMERGENCY WAS DECLARED. MAINTENANCE FOUND COKE/CARBON PARTICLES ON THE SCAVENGE FILTER. REMOVED AND REPLACED L/H ENGINE SCAVENGE OIL FILTER IAW AMM 79-21-0SDR AALA201910179024Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN SHEAR TIE AT BS 277 AND 10R. REPLACED SHEAR TIE PER SRM 51-10-02.SDR AALA2019101759022Switch · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS LANDING GEAR DID NOT RETRACT AFTER TAKEOFF, LANDING WEIGHT 150.0 LBS NORMALLANDING SINK RATE 200 FMP. MAINTENANCE CHECKED ALTERNATE GEAR DOOR SWITCH AND CLEANED IAW AMM 32-34-00. CHECKED FRANGIBLE FITTINGS IAW AMM 32-32-52.SDR AALA2019101759037Warning Light · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS UNCOMMANDED AUTO THROTTLE DISCONNECT. A/T RED LIGHT FLASH. MAINTENANCE PERFORMED AUTOTHROTTLE BITE PROCEDURE IAW AMM 22-31-00. ALL TESTS FOUND NORMAL. NO CURRENT FAULTS.SDR AALA201910179014Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 320 AT LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201910169001Retainer · missingAIRCRAFT WAS GROUNDED: L2 DOOR ESCAPE SLIDE GIRT BAR RETAINER MISSING. MAINTENANCE REPLACED PIN RETAINER PER 737 AMM 25-26-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019101659039Flashlight Assy · inoperativeAIRCRAFT WAS NOT GROUNDED: CABIN EMERGENCY FLASHLIGHT/HOLDER AT FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK OF FLASHLIGHT PER AMM 25-64-00, INSTALLED FLASHLIGHT IN MOUNTING BRACKET, AND REPLACED TAMPER SDR AALA201910159020Engine · unknownAIRCRAFT WAS GROUNDED: PILOT REPORTS UPON ENGINE SHUTDOWN THE NO.1 ENG DID NOT SHUT DOWN FOR APPROX. 15 SEC AFTER CUTOFF SELECTED. MAINTENANCE CHECKED HPSOV CONTROL POWER AT DP1203 LEFT HMU IAW FIM 73-06-00.VOLTAGE OK IN IDLE AND CUTOFF POSITIONS. CHECKED RESISDR AALA201910159070Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND S25R. REPLACED CLIP PER AARD 53-00-01-6.SDR AALA2019101549005Battery Pack · no testAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159016Battery Pack · no testAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159017Battery Pack · no testAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159018Power Supply · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159038Slide · looseAIRCRAFT NOT GROUNDED: PILOT REPORTS UPON ARRIVAL TO AIRCRAFT FOUND L1 DOOR SLIDE LOOSE FROM CASING. MAINTENANCE INSTALLED NEW SLIDE ON L1 DOOR IAW AMM 25-66-01. OPS CHECKED GOOD.SDR AALA2019101549001Windshield · crackedAIRCRAFT WAS GROUNDED: FLIGHT DECK CAPTAINS FORWARD WINDSHIELD HAS LARGE CRACK. REPLACED WINDSHIELD PER TASK CARD 56-94-03.SDR AALA201910219038Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT BS 986 BETWEEN LBL 25 AND LBL 45. REMOVED CORROSION, TREATED AND PRIMED FLOOR BEAM PER AARD 53-00-00-8.SDR AALA201911139035Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN CREASE ANGLE BETWEEN BS 940 AND BS 986 AT RBL 46. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA201911139034Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR INTERCOSTAL AT BS 947 AND LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.
Back to Boeing 737-823