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 AALA201810165004Transition Panel · corrodedCORRSOSION FOUND ON THE FORWARD CARGO BAY RIGHT TRANSISTION PANEL, BS 500H - 500I, STRINGER 27R. REPAIRED THE TRANSISTION PANEL IAW SRM 53-00-53-2R5.SDR AALA201810165001Floor Support · shearedSHEARED FLOOR SUPPORT AT BS 540, LBL 1. REPLACED THE FLOOR SUPPORT.SDR AALA2018102414004Light · malfunctionedINTERMITTENT BATTERY DISCHARGE LIGHT ILLUMINATED, DC AMPS SWING FROM -25 TO 204. THE AIRCRAFT WAS GROUNDED. PERFORMED FIM 24-30-00-810-834, AND MAIN BATTERY CHARGER OPS CHECKED IAW MM 24-31-21-710-801. NO FAULTS. OK FOR SERVICE.SDR AALA201810179013Indicator · faultyAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, RIGHT CENTER PUMP LOW PRESSURE LIGHT REMAINED ILLUMINATED WHEN PUMP SELECTED ON, BOTH CENTER PUMPS INOPERABLE. MAINTENANCE ACCOMPLISHED FIM 28-22-00-810-801 AND 28-22-00-810-822. FOUND UFI / RAML CTR FUEL BOOST PUMP STATUSSDR AALA2018101659006Skin · damagedFRONT PASSENGER DOOR WOULD NOT OPEN ON ARRIVAL. THE AIRCRAFT WAS GROUNDED. MAINTENANCE FOUND THE DOOR SKIN DENTED AND DAMAGED AT THE LOWER HINGE AREA OBSTRUCTING THE OPERATION OF THE DOOR. REPAIRED THE DOOR SKIN IAW SRM 52-10-01-1A-1, AND ACCOMPLISHED A SASDR AALA201810169002Megaphone · faultyAFT MEGAPHONE MAKES A SQUEALING NOISE. REPLACED THE MEGAPHONE AND ACCOMPLISHED OPS CHECKED IAW 25-64-99. OPS CHECKED NORMAL. OK FOR SERVICE.SDR AALA201810163006Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 & 344, LBL 41 - LBL 42. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810163005Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 & 328, LBL 41 - LBL 42. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810163003Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 344 -360, LBL 11. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810163001Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 AND 328, RBL 30. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810163002Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 TO 328, LBL 42. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201810159011Engine · odorODOR IN THE FORWARD CABIN. SMELLED LIKE DIRTY SOCKS. NOTICED IN CRUISE FLIGHT. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED MCM 05-96-70 TROUBLESHOOTING. REPLACED THE NR 2 ENGINE IAW MCM 71-94-01.SDR AALA201810152008Web · corrodedCORROSION FOUND ON THE AFT CABIN LEFT FLOOR WEB BETWEEN BS 1016 AND 1024. REPLACED THE WEB IAW 51-00-05-1, AND DRAWING 147A5712.SDR AALA201810159042Slide · defectiveORD - THE AIRCRAFT WAS GROUNDED. FA FOUND ELECTRONIC TYPE WIRE HANGING OUT FROM L1 DOOR SLIDE BUSTLE. MAINTENANCE REMOVED AND REPLACED L1 DOOR SLIDE IAW MCM 25-94-10, OK FOR SERVICE.SDR AALA201810121005Angle · corrodedCORROSION ON AFT CABIN WET AREA LEFT ZEE ANGLE AT BS 992. REPLACED THE ZEE ANGLE IAW 51-00-05-1.SDR AALA2018101219011Drain Line · cloggedDURING CLIMBOUT OUT OF 10,000 FT. FLIGHT ATTENDANTS REPORTED A VERY STRONG DIRTY SOCK, RANCID CHEESE ODOR IN THE FORWARD CABIN. THE FLIGHT DECK CREW DONNED OXYGEN MASKS AND DECLARED AN EMERGENCY. ODOR STARTED TO DISSIPATE SLOWLY AT LEVEL OFF AT 14,000 FT ANSDR AALA2018101219008B-Nut · looseRIGHT WHEEL WELL HYDRAULIC FLUID AND FORWARD WHEEL WELL OVER HEAD WITH FLUID DRIPPING. DISEMBARKING PASSENGERS COMPLAINED OF BURNING ODOR SEATED NEAR WHEEL AREA. THE AIRCRAFT WAS GROUNDED. PERFORMED LEAK CHECK OF WHEEL WELL HYDRAULIC SYSTEM IAW AMM 29-00-00SDR AALA201810129029Guide Arm · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR HARD TO CLOSE, HAD TO PUSH ON UPPER AFT CORNER TO CLOSE DOOR (SEE AALA201810129024) AND HAD SOFT LATCH ISSUE ON DOOR HANDLE. MAINTENANCE ADJUSTED R1 SERVICE DOOR GUIDE ARM PER MM 52-41-00 AND ADJUSTED R1 GALLEY SERVICSDR AALA201810129024Door · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR HARD TO CLOSE, HAD TO PUSH ON UPPER AFT CORNER TO CLOSE DOOR AND HAD SOFT LATCH ISSUE ON DOOR HANDLE (SEE AALA201810129029). MAINTENANCE ADJUSTED R1 SERVICE DOOR GUIDE ARM PER MM 52-41-00 AND ADJUSTED R1 GALLEY SERVICSDR AALA2018101209010Rod End · brokenON OPENING THE L1 DOOR, TOP GUST LOCK BRACKET BOLT SEVERED AT THE EYE BOLT. THE DOOR WAS HALFWAY THROUGH ROTATION WHEN A POP WAS HEARD. VERIFIED THE L1 DOOR CLOSED AND LOCKED. THE AIRCRAFT WAS GROUNDED. REPLACED THE ROD END AND ADJUSTED THE NUT ON THE L1SDR AALA2018101219010Window · gougedR3 WINDOW HAD A COUPLE OF GOUGES THAT WERE OUT OF LIMITS. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE R3 WINDOW IAW MM 56-11-21, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810110002Proximity Sensor · faultyPASSING 32000, LET FLAPS TRANSIT LIGHT ILLUMINATED WITH OVERHEAD LE DEV INDICATOR (6). AN EMERGENCY WAS DECLARED, LANDED WITHOUT INCIDENT. LIGHT WENT OUT DURING DECENT BEFORE QRH PROCEDURE RUN. NORMAL EXTENSION AND LANDING. REPLACED SL6 PROXIMITY OUTBOARDSDR AALA20181011008Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL BETWEEN BS 867 TO 887. REPLACED THE TRANSITION PANEL IAWSRM 51-10-02, AND SRM 51-40-02.SDR AALA2018101090005Cargo Track · corrodedCORROSION FOUND ON THE CARGO TRACK JUST INBOARD OF THE DOOR THRESHOLD WEB BS 767 -827, RBL 14. REPLACED THE CARGO TRACK IAW 51-00-05-R1.SDR AALA2018101090004Strap · corrodedCORROSION FOUND ON THE AFT CARGO DOOR THRESHOLD STRAP LOCATED BOTTOM SIDE OF BS 787 - 794, REPLACED THE STRAP IAW 51-00-05-R1.SDR AALA2018101009007Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL, BS 847 TO 867. REPLACED THE TRANSITION PANEL IAW SRM 51-10-02.SDR AALA2018101009006Transition Panel · corrodedCORROSION FOUND ON THE LEFT TRANSITION PANEL, BS 727 TO 847 IN THE AFT CARGO BAY. REPLACED THE TRANSITION PANEL IAW 51-00-05-1, AND PRINT 146A7502.SDR AALA201810109003Floor Panel · damagedMAIN CABIN AISLE FLOOR PANELS WERE SOFT AT SEAT ROW 22. THE AIRCRAFT WAS GROUNDED. REPAIRED THE FLOOR PANELS IAW EA 285810.SDR AALA201810109002Floor Panel · damagedMAIN CABIN AISLE FLOOR PANELS WERE SOFT AT SEAT ROW 22. THE AIRCRAFT WAS GROUNDED. REPAIRED THE FLOOR PANEL IAW EA 285810.SDR AALA201810108003Heater · failedPITOT HEAT LIGHT WAS ON IN FLIGHT AND FAILED. EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED PITOT PROBE AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810109001Stop Fitting · out of adjustAFT SERVICE DOOR LIGHT ILLUMINATED IN FLIGHT. HANDLE WAS SLIGHTLY RAISED FROM DOWN DETENT. PUSHED HANDLE DOWN AND LIGHT EXTINGUISHED. ACCOMPLISHED AFT ENTRY DOOR (SOFT UNLATCH) CHECK IAW AMM 52-13-00. ADJUSTED DOOR STOP PINS IAW AMM 52-13-00 STEP Q. DOOR OPERSDR AALA201810099019Light · missingAIRCRAFT WAS NOT GROUNDED. LEFT AFT CABIN ENTRY DOOR EXIT LIGHT MISSING. MAINTENANCE REPLACED LIGHT ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR AALA201810099013Megaphone · inoperativeFORWARD CABIN MEGAPHONE WAS INOPERATIVE. REPLACED THE MEGAPHONE IAW AMM 25-64-00.SDR AALA2018100989057Battery · no testFORWARD FLIGHT ATTENDANT FLASHLIGHT WILL NOT TEST. REPLACED THE BATTERY IAW 25-64-00. OPS CHECKED GOOD.SDR AALA201810089032Gust Lock · defectiveL1 DOOR HOLD OPEN LATCH RELEASE. FLIGHT ATTENDANTS REPORTS THAT SHE HAD TO CONTINUOSLY HOLD THE GUST LOCK TO CLOSE THE DOOR. FOUND THE GUST LOCK EASY TO OVERRIDE. FOUND A BROKEN SPRING ON THE LATCH RELEASE AND BAD GUIDE ARM ASSEMBLY. INSTALLED NEW GUIDE ARM SDR AALA201810089027Flashlight · missingEMERGENCY FLASHLIGHTS STORED UNDER THE FORWARD JUMPSEAT WAS MISSING. INSTALLED THE FLASHLIGHT IAW SB 25-1766R2. OK FOR SERVICE.SDR AALA201810095003Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL, BS 767 - 794, STRINGER 25R. REPLACED THE TRANSITION PANEL IAW DWG 146A0081, AND 51-00-05-1.SDR AALA201810095001Web · corrodedCORROSION ON THE AFT CARGO DOOR SILL THRESHOLD WEB BETWEEN BS 793 - 847. REPLACED THE THRESHOLD WEB IAW DRAWING 146A8123 AND SRM 53-13-00-05A.SDR AALA201810089001Indicator · faultyFUEL INDICATION PROGRESSIVELY LOWER THAN FUEL LOG BURN, AFTER 2 HOURS WE WERE 2000 LBS BELOW EXPECTED. ACFT DIVERTED, LANDED WITHOUT INCIDENT AND THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED FUEL QTY BITE PER FIM 28-41-00, NO CURRENT OR FLIGHT FAULTS. VERIFY FUEL SDR AALA201810089029Bulkhead Web · crackedLEFT WHEEL WELL BULKHEAD WEB WAS CRACKED AT LBL 32, BS 663 . REPAIRED THE BULKHEAD WEB IAW 57-10-10-9.SDR AALA201810059002Floor Panel · damagedSOFT SPOT ON THE FLOOR PANEL BY SEAT ROWS 16 - 17 IN THE PASSENGER CABIN. THE AIRCRAFT WAS GROUNDED. REPLACED THE FLOOR PANEL IAW AMM 53-21-00.SDR AALA201810054001Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO, RIGHT TRANSITION PANEL, BETWEEN BS 490 AND 500A, RBL 24. REPLACED THE TRANSITION PANEL IAW 51-00-05.SDR AALA201810059027Spring · migratedL1 DOOR GUST LOCK WILL NOT LOCK IN PLACE WHEN CLOSING. FOUND THE GUST LOCK SPRING MIGRATED OUT OF POSITION. INSTALLED AND SECURED GUST LOCK IAW AMM 52-11-00. OPS CHECKED NORMAL. OK FOR SERVICE. DOOR OPENS, CLOSES AND LOCKS NORMALLY.SDR AALA201810049025Bulkhead Web · crackedRIGHT WHEEL WELL FORWARD BULKHEAD WEB CRACKED. REPAIRED THE BULKHEAD WEB IAW 57-10-10-9.SDR AALA201810043004Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL BETWEEN BS 727 TO 767 AFT CARGO AREA. REPLACED THE RIGHT TRANSITION PANEL IAW 51-00-05-1.SDR AALA201810043002Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL BETWEEN BS 500A TO 500I AROUND SCREW HOLES. REPLACED THE RIGHT TRANSITION PANEL IAW DRAWING 143A7500 AND 51-00-05-1.SDR AALA20181002006Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT HAND FORWARD SHIELD TOP TO BOTTOM AT STA 767-787. REPLACED ENTIRE PART. SHIELD WAS REMOVED AT STA 767-794, RBL 20-24. REPLACED SHIELD (TRANSITION PANEL) PER SRM 51-40-02..SDR AALA20181002005Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON THE LEFT HAND TRANSITION PANEL AT STA 500-520, LBL 24. REPAIRED LEFT HAND TRANSITION PANEL. SPLICE REPAIR WAS ACCOMPLISHED PER SRM 53-00-53-2R-5.SDR AALA20181002004Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT HAND TRANSITION PANEL AT STA 500A-520, RBL 24. REPAIRED TRANSITION PANEL. SPLICE REPAIR WAS ACCOMPLISHED PER SRM 53-00-53-2R-5.SDR AALA20181002003Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT HAND TRANSITION PANEL TOP TO BOTTON AT STA 727B-767. REPAIRED TRANSITION PANEL. SPLICE REPAIR WAS ACCOMPLISHED PER SRM 53-00-53-2R-5.
Back to Boeing 737-823