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 AALA20190123004Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 540 AND BL 0. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA201901239003Smoke Detector · false activationAFT LEFT LAVATORY SMOKE DETECTOR ACTIVATED, NO EVIDENCE OF SMOKE OR FIRE. MAINTENANCE ACCOMPLISHED A SMOKE DETECTOR TEST IAW AMM 20-147-00. PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201901232005Floor Support · crackedFORWARD GALLEY FLOOR SUPPORT WAS CRACKED BETWEEN BS 312 AND 328, RBL 30 - RBL 31. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05, AND SRM 51-40-02.SDR AALA20190123005Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 45. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA201901239002Smoke Detector · false activationFORWARD LAVATORY SMOKE DETECTOR WAS GOING OFF. SMOKE INDICATION IN COCKPIT AS WELL. MAINTENANCE REPLACED THE FORWARD LAVATORY SMOKE DETECTOR IAW MM 26-14-01, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201901232003Floorbeam · corrodedCORROSION ON FORWARD CARGO BAY FLOORBEAM ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED THE FLOORBEAM ANGLE IAW SRM 51-10-02.SDR AALA201901221001Lamp · inoperativeEMERGENCY LIGHTS WERE INOPERATIVE AND THE LENS WAS BROKEN OFF.ON THE CENTER CONSOLE. MAINTENANCE REPLACED THE LAMPS AND REASSEMBLED LENS ASSEMBLY. PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA2019012319002Floorbeam · corrodedCORROSION ON THE FLOORBEAM UPPER TEE, BS 947.5, RBL 45.50. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R.SDR AALA2019012319001Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BETWEEN BS 947.5 AND 967, LBL 24 AND LBL 27. REPAIRED THE FLOOR SUPPORT IAW EA 288928.SDR AALA201901229026Electrical Box · failedDETECTED AN ELECTRICAL ODOR BY ROW 26ABC. CONFIRMED SEAT 26B POWER BOX HAD A BURNED ODOR. ACCOMPLISHED MCM 5-96-70, THE UNIT WAS REMOVED AND REPLACED.SDR AALA201901231004Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 400 AND 420. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53, AND 51-10-2.SDR AALA201901231003Transition Panel · corrodedCORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 500A AND BS 500B. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA201901231002Baffle · crackedTHE FORWARD CARGO BAY LEFT BAFFLE WAS CRACKED BETWEEN BS 400 AND 420. REPLACED THE BAFFLE IAW RD 51-00-05.SDR AALA201901238003Support Angle · corrodedCORROSION FOUND ON THE AFT CARGO BAY AFT BULKHEAD LOWER SUPPORT ANGLE AT BS 947, LBL 8.1. REPLACED THE SUPPORT ANGLE IAW RD 51-00-05, AND SRM 51-10-02.SDR AALA20190118001Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN WAS FOUND CRACKED AT HSS 147.90. 25 INCHES AFT OF THE FRONT SPAR. REPAIRED THE SKIN IAW SRM 55-10-01-2R-11.SDR AALA201901176005Clock · failedFLIGHT CREW REPORTED FAINT ELECTRICAL ODOR PRESENT. SUSPECT EXHAUST FAN OR SIMILAR STARTING TO FAIL. AIRCRAFT WAS TAKEN OUT OF SERVICE.ACCOMPLISHED CARD 05-96-70. FOUND CAPTAINS CLOCK AS SOURCE OF ODOR. REPLACED CAPTAINS CLOCK IAW MM 31-25-11. OPERATIONS CHECSDR AALA201901229030Bulkhead Web · crackedBS 663 BULKHEAD FOUND CRACKED BETWEEN RBL 25 AND RBL 31.83. REPAIRED THE BULKHEAD WEB IAW RD 57-10-10-9.SDR AALA201901229024Panel · missingDURING A POST CHECK FLIGHT, IT WAS REPORTED THAT ON CLIMB, NOTICED THE AIRPLANE TOOK APPROXIMATELY 2 UNITS LWD AILERON TO MAINTAIN HEADING. AFTER LEVELING AT 15,000, NOTICED AIRFRAME VIBRATION THAT WAS MORE THAN USUAL. EXTENDED THE FLAPS AND NOTICED THE ASDR AALA201901229010Battery · no testRIGHT FWD CABIN FLASHLIGHT FAILED TO TEST. REMOVED AND REPLACED THE BATTERY IAW AMM 25-64-00. OPS CHECKED NORMAL.SDR AALA201901179007Relay · inoperativeEMERGENCY EXIT LIGHT IN CEILING ABOVE L1 DOOR INOPERATIVE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED R-47 RELAY IN P-6-4 AND PERFORMED SATISFACTORY OPERATIONAL PER WDM 33-29-11.SDR AALA20190116007Stringer · corrodedCORROSION FOUND ON THE AFT CARGO STRINGER 26R REPAIR DOUBLER BETWEEN BS 823 AND 836. REPAIRED THE STRINGER IAW ES0 610000SDR AALA20190116006Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO TRANSITION PANEL BETWEEN BS 767 AND 787, RBL 25. REPLACED THE TRANSITION PANEL IAW RD 51-00-05-01, AND EA 288047.SDR AALA20190116003Beam · crackedFORWARD SERVICE DOOR THIRD BEAM FORWARD AND BELOW DOOR HANDLE RADIUS WAS CRACKED. REPLACED THE DOOR BEAM IAW RD 51-00-05, REPAIR 1.SDR AALA201901179006Connector · disconnectedEMERGENCY LIGHTS, CEILING ROW 29DEF WERE INOPERATIVE. CONNECTED THE CONNECTOR IAW AMM 33-53-01. OPS CHECKED OK.SDR AALA201901165008Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SKIN WAS FOUND CRACKED AT HSS 147.90, 25 INCHES FROM THE FRONT SPAR. REPAIRED THE HORIZONTAL STABILIZER SKIN IAW SRM 55-10-01-2R-11, FIGURE 204, FIGURE 4, SHEET 2, DETAIL B.SDR AALA201901165005Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY TRANSITION PANEL BETWEEN BS 500D AND 500I, STRINGER 25L. REPAIRED THE TRANSITION PANEL IAW SRM 53-0053-2R-5.SDR AALA2019011769006Door · out of adjustL1 LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE ADJUSTED THE DOOR AND LATCH PER MM 52-50-03 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901154010Angle · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR ANGLE BETWEEN BS 893 AND 1016, RBL 51. REPLACED THE FLOOR ANGLE IAW RD 51-00-05.SDR AALA201901154009Angle · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR ANGLE BETWEEN BS 893 AND 1016, LBL 51. REPLACED THE FLOOR ANGLE IAW RD 51-00-05.SDR AALA201901154008Web · corrodedCORROSION ON AFT GALLEY FLOOR WEB BETWEEN BS 986 AND 1016, RBL 45 AND RBL 51. REPLACED THE WEB IAW RD 51-00-05.SDR AALA201901154007Web · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR WEB AT BS 1016 AND RBL 32. REPLACED THE WEB IAW RD 51-00-05.SDR AALA201901154005Floor Support · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR SUPPORT AT BS 993, LBL 33. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201901154004Floor Support · corrodedCORROSION ON AFT GALLEY FLOOR SUPPORT BETWEEN BS 993 AND 1016, LBL 32. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201901154003Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM, BS 993 BETWEEN RBL 33 AND RBL 46. REPLACED THE FLOORBEAM ANGLE IAW RD 51-00-05.SDR AALA201901154002Floor Support · corrodedCORROSION ON THE AFT GALLEY FLOOR SUPPORT BETWEEN BS 993 AND 1016, RBL 32. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201901149003Pump · malfunctionedUNWANTED UNCOMMANDED FUEL TRANSFER FROM THE LEFT WING TANK TO THE CENTER TANK, OF UP TO 380 LBS THREE TIMES, DURING TAXI, CLIMB, AND DESCENT. ACCOMPLISHED FQIS BITE AND GRAUND TEST, NO FAULTS FOUND, GROUND TEST PASSED. OPENED CENTER TANK IAW AMM 28-11-31.SDR AALA201901149010Megaphone · inoperativeCABIN MEGAPHONE INOPERATIVE. REMOVED AND REPLACED THE MEGAPHONE. OPS CHECKED GOOD.SDR AALA201901159004Skin · corrodedCORROSION FOUND ON THE LEFT WING LOWER SKIN BETWEEN WINGLET AND OUTBOARD DRY BAY ACCESS PANEL. THE AIRCRAFT WAS GROUNDED. THE CORROSION WAS REMOVED, FOUND TO BE WIITHIN LIMITS IAW EA 288932.SDR AALA201901154006Fuse · blownOVERWING EMERGENCY EXIT SIGN WAS INOPERATIVE. MAINTENANCE REPLACED THE FUSE AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA201901149015Bulkhead Web · crackedBS 663 BULKHEAD WEB WAS CRACKED. REPAIRED THE BULKHEAD WEB IAW SRM 57-10-10-2R-2 AND RD 57-10-10-9.SDR AALA201901142001Transition Panel · corrodedCORROSION ON FORWARD CARGO TRANSITION PANEL BETWEEN BS 500D AND 500I, RBL 25. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA201901141008Floor Support · corrodedCORROSION ON THE AFT CABIN FLOOR SUPPORT BETWEEN BS 947 AND 967, LBL 49. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA201901141004Floorbeam · corrodedCORROSION FOUND ON THE AFT CABIN FLOORBEAM UPPER TEE AT BS 986.5, BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-7051-2R-4.SDR AALA201901141003Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY TRANSITION PANEL BETWEEN BS 500 AND 500A AT RBL 25. REPAIRED TRANSITION PANEL PER AARD 51-00-05.SDR AALA201901141001Support Angle · corrodedCORROSION ON THE R1 DOOR THRESHOLD SUPPORT ANGLE BETWEEN BS 312 AND 320, STRINGERS 30R AND 33R. REPLACED THE THRESHOLD SUPPORT ANGLE IAW RD 51-00-05-1.SDR AALA2019011429001Flap System · malfunctionedDURING LANDING, FLAPS FAILED TO EXTEND TO THE SELECTED POSITION, EXCECUTED A GO AROUND AND FLAPS WOULD NOT RETRACT. ACCOMPLISHED FSEU BITE IAW FIM 27-51-00, NO CURRENT FAULTS. ACCOMPLISHED FIM 27-51 810-813, NO FAULTS NOTED. ACCOMPLISHED VISUAL INSPECTSDR AALA201901110006Support Strap · corrodedCORROSION FOUND ON THE SUPPORT STRAP, BS 1024, RBL 17.5. REMOVED AND REPLACED THE SUPPORT STRAP IAW DRAWING 147A5700, RD 51-00-05-1, AND SRM 51-40-02.SDR AALA201901110005Support Strap · corrodedCORROSION FOUND ON THE SUPPORT STRAP AT BS 1020 RBL 17.5. REPLACED THE SUPPORT STRAP IAW DRAWING 147A5700, RD 51-00-05-1, AND SRM 51-40-02.SDR AALA201901110004Floor Support · crackedFLOOR SUPPORT WAS CRACKED AT THE UPPER NUTPLATE HOLES, BS 312 TO 328, RBL 31. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1, AND DRAWING 141A5400.SDR AALA201901110003Floorbeam · crackedCABIN FLOORBEAM ANGLE WAS CRACKED, BS 540, LBL 2. REPLACED THE FLOORBEAM ANGLE IAW RD 51-00-05-1, AND DRAWING 143A0060.
Back to Boeing 737-823