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 AALA20180119004Floor Support · corrodedCORROSION IN THE AFT CARGO FLOORBEAM AT BS 887. INSTALLED A NEW FLOORBEAM IAW SRM 51-40-02.SDR AALA20180118006Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 344 - 360, BL 0. REPLACED THE FLOOR SUPPORT AMM 53-21-00, DRAWING 141A5400, AND 51-00-05, 1, REPAIR 1.SDR AALA20180118004Bear Strap · corrodedCORROSION AT AFT CARGO BEAR STRAP FOR INNER DOOR CUT OUT, FORWARD LOWER CORNER AT BS 798. INSTALLED A REPAIR DOUBLER AND FILLER IAW EA 274683.SDR AALA20180118003Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION TO CABIN FLOOR WEB BETWEEN BS 986 TO 1016, LBL 30 TO LBL 47. INSTALLED A NEW WEB IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA201801229032Girt Bar · out of adjustL1 DOOR GIRT BAR OUT OF ADJUSTMENT, HAS TO MUCH SLACK. MAINTENANCE ADJUSTED THE L1 GIRT BAR AND PERFORMED SATISFACTORY OPS CHECK IAW MM 25-66-01.SDR AALA201801229020Lens · missingLIGHT NEXT TO RIGHT FORWARD DOOR HAS EXIT LIGHT LENS MISSING. REPLACED EMERGENCY PROXIMITY EXIT LIGHT ASSEMBLY AT 1R PER 33-51-14.SDR AALA201801229026Lens · missingLEFT AFT SERVICE DOOR IS MISSING THE EMERGENCY LIGHT LENS. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR AALA201801229019Lens · missingRIGHT AFT GALLEY DOOR EMERGENCY EXIT LIGHT MISSING THE LENS. REPLACED THE LIGHT ASSY IAW AMM 33-53-01.SDR AALA20180118008Skin · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. SUSPECTED SKIN CRACK ON RIGHT HAND HORIZONTAL STABILIZER, LOWER SKIN AT STAB STATION 101.90. VERIFIED CRACK REMOVED. INSTALLED FILLER AND DOUBLER AND SEALED PER SRM 55-10-01-2R-11.SDR AALA20180118007Cargo Track · corrodedCORROSION ON AFT CARGO BAY, CARGO TRACK, RBL 13.8, BS 787 - 847. REPLACED THE CARGO TRACK IAW SRM 51-10-02, BOEING DRAWING 146A7501, AND 51-00-05.SDR AALA20180118005Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 312 - 328, LBL 46. REMOVED & REPLACED THE FLOOR SUPPORT IAW DRAWING 141A5400, AND 51-00-05-1, REPAIR 1.SDR AALA20180118009Floorbeam · corrodedFLOORBEAM AT BS 987, APPROXIMATELY LBL 18 AND LBL 21, HAS CORROSION ON THE UNDERSIDE OF THE AFT LEG OF TOP FLANGE AROUND FLOORBOARD HOLES. REMOVED CORROSION IAW SRM 51-10-02. FABRICATED AND DRILLED ALL REPAIR PARTS, DEBURRED, ALODINED AND PRIMED ALL PARTS IASDR AALA20180118002Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM UPPER TEE CAP AT BS 987, RBL 48. REPAIRED THE FLOOR BEAM TEE IAW EA 276504, AND SRM 53-00-51-R1.SDR AALA20180118001Floorbeam · corrodedCORROSION ON THE FLOORBEAM, BS 987, LBL 43. REPLACED THE REPAIR FILLER IAW EA B737-53-022852, AND SRM 53-00-51-R1.SDR AALA201801199003Light · looseEXIT SIGN FOR RIGHT AFT SERVICE DOOR FOUND LOOSE. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201801199015Lens · missingEMERGENCY AISLE LIGHT LENS MISSING AT ROW 14D TOP OF OVERHEAD BIN AREA. THE LENS WAS REPLACED IAW AMM 33-51-03.SDR AALA201801199014Connector · unsecureROW 30 AISLE EMERGENCY LIGHT INOPERATIVE. SECURED THE CONNECTOR . OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA20180117006Floor Support · corrodedCORROSION ON FLOOR SUPPORT BS 948.5, RBL 51. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, DRAWINGS 815A0010, AND 147A5700.SDR AALA20180117005Floorbeam · corrodedCORROSION ON THE FLOORBEAM AT BS 951, LBL 27 TO LBL 48. REPLACED FLOORBEAM IAW 51-00-05-1, SRM 51-10-02, AND DRAWING 147A5650.SDR AALA20180117004Web · corrodedCORROSION ON THE AFT WEB BETWEEN BS 986.5 TO 991, LBL 33 TO LBL 44. REPLACED THE WEB IAW 51-00-05 AND DRAWING 147A5700.SDR AALA20180116009Transition Panel · corrodedRIGHT TRANSITION PANEL HAS AREAS OF CORROSION ON LOWER SURFACE FROM BS 767 - 793. INSTALLED THE TRANSITION PANEL IAW 51-00-05-1 AND DRAWING 146A0081.SDR AALA201801199032Connector · damagedEMERGENCY LIGHT ROW 19 IS INOPERATIVE. SECURED THE PIN IN SIDE WALL CONNECTOR IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201801199004Lens · unsecureEMERGENCY EXIT SIGN LENS OVER AFT GALLEY SERVICE DOOR UNSECURE. REPLACED THE LENS IAW AMM 33-51-00.SDR AALA20180116002Web · corrodedCORROSION ON WEB UNDER GALLEY STA 1016-1031 LBL 14, OUT OF LIMNITS. REMOVED AND INSTALLED A NEW WEB IAW 51-00-05-1, AND DRAWING 147A500.SDR AALA20180116007Bracket · brokenBRACKET IN AFT CARGO FOR LOWER ANGLED FRAME TO VACUUM WASTE EQUIPMENT PANEL LEFT SIDE AT BS 887, LBL 16 BROKEN OFF. REPLACED THE BRACKET IAW 51-00-05-1.SDR AALA20180116004Web · corrodedCORROSION ON WEB UNDER GALLEY BETWEEN BS 1016 TO 1031 AT BL 0 TO RBL 14. REPLACED THE WEB IAW 51-00-05-1, AND DRAWING 147A5700.SDR AALA20180116003Support Angle · corrodedCORROSION OF AFT WALL LOWER SUPPORT ANGLE AT BS 947.5, LBL 10 TO RBL 23. REPLACED SUPPORT ANGLE IAW SRM 53-00-53.SDR AALA20180116006Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM BS 993 LBL 33 TO 46. REPLACED THE FLOORBEAM IAW 51-00-05.SDR AALA20180116005Floor Support · corrodedCORROSION FOUND ON GALLEY FLOOR SUPPORT AT BS 990 - 1016, LBL 33. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-10-02.SDR AALA20180116008Transition Panel · corrodedCORROSION ON AFT CARGO LEFT TRANSITION PANEL, AT MULTIPLE LOCATIONS, BS 727 TO 847. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53, AND 51-00-05-R1.SDR AALA201801199019Lens · brokenEMERGENCY LIGHT COVER AT FOWARD ENTRANCE FELL OFF AND WAS BROKEN. MAINTENANCE REPLACED FORWARD ENTRY THRESHOLD LIGHT ASSEMBLY, AND PERFORMED A SATISFACTORY OPS CHECK IAW MM 33-29-00-960-803.SDR AALA201801229014Lens · missingEMERGENCY LIGHT ON SEAT 14D, THE LENS WAS MISSING. INSTALLED THE LENS. AIRCRAFT WAS GROUNDED.SDR AALA201801199007Sign · missingEXIT SIGN AT FWD ENTRY SERVICE DOOR IS MISSING. REPLACED EMERGENCY EXIT SIGN IAW MM 33-51-02.SDR AALA201801199020Lens · missingLIGHT LENS BELOW THE FORWARD ENTRY DOOR EXIT LIGHT MISSING. MAINTENANCE REPLACED THE LENS. PERFORMED A SATISFACTORY OPS CHECK.SDR AALA20180115006Strap · corrodedCORROSION ON WEB STRAP BETWEEN BS 1018 TO 1028, LBL 27. INSTALLED THE STRAP WEB SUPPORT IAW 51-00-05-1 AND DRAWING 147A5714.SDR AALA20180115005Strap · corrodedCORROSION ON WEB STRAP BETWEEN BS 1016 TO 1028, LBL 18. REPLACED STRAP IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA20180115007Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FLOORBEAM TO FLOOR WEB STRAP CORRODED FROM STA 1020 TO STA 1029 RBL 28. REMOVED WEB SUPPORT STRAP PER SRM 51-10-02.SDR AALA20180115003Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT WEB AT BS 987 BETWEEN RBL 47 TO RBL 50. REPLACED THE WEB IAW 51-00-05-1 AND DRAWING 147A8510-24.SDR AALA20180115014Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL AT BS 767 - 787. INSTALLED A NEW TRANSITION PANEL IAW DRAWING 146A0081 AND 51-00-05-1.SDR AALA20180115011Pan · corrodedCORROSION ON DECK AROUND LEFT AFT GALLEY MOUNT PAN AT BS 1016, LBL 33. REPLACED THE PAN ASSEMBLY IAW 51-00-05-1 AND DRAWING 147A5712.SDR AALA20180115004Strap · corrodedCORROSION ON WEB STRAP BETWEEN BS 1017 TO 1029, LBL 3. A NEW STRAP WAS FABRICATED AND INSTALLED IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA20180114002Web · corrodedCORROSION FOUND ON THE CARGO DOOR THRESHOLD WEB BS 448. REPLACED THE THRESHOLD WEB IAW SRM 51-10-02.SDR AALA201801189026Stick Shaker · malfunctionedINTERMITTENT STICK SHAKER WARNING AIRSPEED NORMAL. EMERGENCY DECLARED AND FLIGHT RETURNED WITHOUT INCIDENT. AIRCRAFT WAS GROUNDED. MAINTNENANCE ACCOMPLISHED MACH AIRSPEED WARNING SYSTEM NR 1 AND 2 IAW MM 34-16-00. UNABLE TO DUPLICATE FAULT. REPLACED THE NRSDR AALA201801169019Stick Shaker · malfunctionedINTERMITTENT STICK SHAKER WARNING AIRSPEED NORMAL. EMERGENCY DECLARED AND FLIGHT RETURNED WITHOUT FURTHER INCIDENT. AIRCRAFT WAS GROUNDED. MAINTNENANCE ACCOMPLISHED MACH AIRSPEED WARNING SYSTEM NR 1 AND 2 IAW MM 34-16-00. UNABLE TO DUPLICATE THE FAULT. REPLSDR AALA20180116001Warning Horn · false activationCLIMBING THROUGH 6000 FEET CABIN ALTITUDE HORN SOUNDED. WARNING HORN CAME ON AND OFF INTERMITTENTLY, AND EVENTUALLY WENT OFF. RETARD DISPLAY IN HUD ALSO EVENTUALLY WENT OFF. NO EMERGENCY WAS DECLARED, AND THE FLIGHT RETURNED WITHOUT FURTHER INCIDENT. ACCOMPLSDR AALA201801189027Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. DOOR R-1 EMERGENCY EXIT LIGHT COVER MISSING. REPLACED R-1 DOOR EMERGENCY LIGHT ASSY. OPS CKS NORM. REF 33-51-01 AMM.SDR AALA201801189017Shade · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT WINDOW SHADE LT AFT DAMAGED. REMOVED AND REPLACED EMERGENCY WINDOW SHADE LT AFT IAW AMM 25-21-12 .SDR AALA201801189011Cover · detachedAIRCRAFT WAS NOT GROUNDED: DOOR EMERGENCY EXIT LIGHT AT 1L FELL OFF. MAINTENANCE REINSTALLED DOOR 1L EXIT LIGHT COVER PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180112008Transition Panel · corrodedLEFT TRANSITION PANEL CORRODED FROM BS 500 - 500I. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53 AND SRM 51-10-02.SDR AALA20180112007Floor Support · corrodedHEAVY CORROSION ON FLOORBOARD TO BULKHEAD SUPPORT ANGLE AT BS 500I. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-10-02.
Back to Boeing 737-823