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 AALA20170925004Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED EXIT LIGHT PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170925002Wheel · damagedAIRCRAFT WAS GROUNDED. DURING TAXI OUT TO RUNWAY, CREW REPORTED LEFT BRAKE DRAGGING. MAINTENANCE FOUND NR 2 MAIN LANDING GEAR WHEEL RUBBING ON NR 2 BRAKE. REMOVED AND REPLACED WHEEL AND TIRE ASSEMBLY PER AMM 32-45-11. OPERATIONAL CHECK GOOD.SDR AALA20170923002Sensor · faultyAIRCRAFT WAS GROUNDED. AFTER TAKEOFF WITH THE GEAR HANDLE IN UP POSITION , BOTH RED AND GREEN NOSE LANDING GEAR LIGHTS ILLUMINATED. ACCOMPLISHED QRH PROCEDURES AND ALL THREE GEAR NORMAL ON RETURN LANDING TO MIA. REMOVED AND REPLACED NOSE LANDING GEAR DOWN PSDR AALA20170922012Transition Panel · corrodedCORROSION ON AFT CARGO RIGHT TRANSITION PANEL AT BS 767. INSTALLED NEW TRANSITION PANEL IAW D 51-00-05-1, AND SRM 53-00-53.SDR AALA20170922011Transition Panel · corrodedAFT CARGO RIGHT TRANSITION PANEL AT BS 727C HAS FASTENER PULLED THROUGH WHERE IT IS ATTACHED TO FRAME. INSTALLED A NEW TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20170922010Web · corrodedCORROSION ON AFT CARGO DOOR FRAME LOWER SILL PLATE WEB BETWEEN BS 793 AND 847. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1, DRAWING DBF192, AND DRAWING 146A8123.SDR AALA20170922009Rib · crackedCRACK INDICATIONS ON THE RIGHT HORIZONTAL STABILIZER RIB LOWER RADIUS AT HSS 92.7. REMOVED AND REPLACED THE RIB IAW SRM 55-10-09, SRM 51-40-02, AND DRAWING 182A5301.SDR AALA20170922004Web · corrodedCORROSION ON THE R2 DOOR THRESHOLD WEB AT BS 986, RBL 50. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1, DRAWING 147A8510, AND EA 273488.SDR AALA20170922003Web · corrodedCORROSION ON THE L2 DOOR THRESHOLD WEB BETWEEN BS 967 AND 986. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1, DRAWING 147A8510 AND EA 273488.SDR AALA20170922001Rib · crackedCRACK INDICATIONS ON LEFT HORIZONTAL STABILIZER RIB INBOARD RADIUS AT HSS 92.7. REMOVED AND REPLACED INSPAR RIB IAW SRM 55-10-09 AND SRM 51-40-02.SDR AALA201709289001Proximity Sensor · faultyTHE AIRCRAFT WAS GROUNDED. AT OUTER MARKER OF LAX, RECEIVED NR 4 LE FLAP LEFT SIDE TRANSIT LIGHT AT FLAPS 10. THE FLIGHT LEVELED OFF AT 2000 FEET AND TRACKED THE LOCALIZER. AN EMERGENCY WAS DECLARED. RAN THE CHECKLIST FOR LEADING EDGE TRANSIT LIGHT. THE FSDR AALA201709259035Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L1 DOOR IS DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709259034Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT AT STATION 727 HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA201709259031Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE FORWARD GALLEY IS BROKEN. REMOVED AND REPLACED EXIT SIGN ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709259030Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR IS STUCK ON DOOR. REMOVED AND REPLACED SLIDE PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA20170923001Coupling · disconnectedAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. MIA-GUA FLIGHT DIVERTED TO FLL ACCOUNT UNRELIABLE AIRSPEED INDICATION AFTER TAKEOFF. LANDING UNEVENTFUL. MAINTENANCE FOUND QUICK DISCONNECT ON THE M1750 AIR DATA MODULE LEFT PITOT PRESSURE DISCONNECTED. RECONNECTESDR AALA20170922008Bulkhead Web · crackedCRACK ON BS 663 BULKHEAD WEB, RBL 40 TO 45.64. REPAIRED IAW SRM 57-10-10-2R-3, ALTERNATIVE 2.SDR AALA201709259032Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE LEFT AFT CABIN HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709229026Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A LOOSE LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170920003Skin · crackedCRACK INDICATION ON THE LEFT HORIZONTAL STABILIZER LOWER INSPAR SKIN AT HSS 101.90 AT THE AFT END. REPAIRED THE SKIN IAW SRM 55-10-01-2R-11.SDR AALA20170920002Intercostal · crackedCRACKED INTERCOSTAL IN THE ELECTRICAL AND ELECTRONICS COMPARTMENT BETWEEN BS 312 AND 328, LBL46. REMOVED AND REPLACED IAW 51-00-05-1 AND DRAWING 141A5410.SDR AALA201709219016Bezel · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L1 DOOR HAS A BROKEN BEZEL. REPLACED BEZEL PER AMM 20-00-00. OPERATIONAL CHECK GOOD.SDR AALA20170919015Baffle · crackedCRACKED BAFFLE IN THE FORWARD CARGO UNDER THE LEFT TRANSITION PANEL BETWEEN SS 460 AND 480. REMOVED AND REPLACED BAFFLE IAW D 51-00-05 AND DRAWING 143A7510.SDR AALA20170919008Web · corrodedCORROSION FOUND ON THE RIGHT HALF MOON WEB BETWEEN BS 1016 AND 1026, RBL 28 TO RBL 38. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1 AND DRAWING 147A5700.SDR AALA20170919007Floorbeam · corrodedCORROSION ON FORWARD CARGO AFT FLOORBEAM ANGLE AT BS 500I, LONGERONS 25L AND 25R. REMOVED AND REPLACED THE FLOORBEAM ANGLE SRM 51-10-02 AND D 51-00-05.SDR AALA20170919006Web · corrodedCORROSION ON FORWARD CARGO LOWER DOOR FRAME SILL PLATE WEB BETWEEN BS 440 AND 492, STRINGER 26R. REMOVED AND REPLACED THE WEB IAWSRM 51-40-02.SDR AALA201709219017Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R1 DOOR HAS A DETACHED LENS COVER. REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709219015Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTS ON ALL FIRST CLASS SEATS ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY CHARGER). OPERATIONAL CHECK GOOD.SDR AALA201709219014Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-01-960-802. OPERATIONAL CHECK GOOD.SDR AALA20170919017Wire · pulledAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 6EF HAS BROKEN WIRES THAT ARE PULLED FROM SOCKET. INSTALLED NEW CONNECTOR PER AMM 20-42-01. OPERATIONAL CHECK GOOD.SDR AALA20170919016Warning System · intermittentAIRCRAFT WAS NOT GROUNDED. EMERGENCY DECLARED. DFW-SFO FLIGHT RETURNED TO DFW ACCOUNT NR 3 FLAP STUCK IN TRANSIT AFTER TAKEOFF. FIRST CYCLE OF FLAPS RAISED SLAT, 2 MINUTES LATER THE LIGHT CAME ON AGAIN AND WOULD NOT RESET. OVERWEIGHT LANDING UNEVENTFUL. ASDR AALA201709209030Light · brokenAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT SIGN IN THE RIGHT AFT GALLEY AT L1191 HAS A BROKEN BASE PLATE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709209023Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE RIGHT OVERWING EXIT BY ROW 15 HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170918003Plate · brokenAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT SIGN IN THE LEFT AFT GALLEY AT L1190 HAS A BROKEN BASE PLATE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709219001Guide Arm · failedAIRCRAFT WAS GROUNDED. L1 DOOR GUIDE ARM PIN INSPECTION FOUND DOOR HOLD OPEN LATCH WON'T LOCK DOOR IN OPEN POSITION. REMOVED AND REPLACED UPPER CAM PLATE PER AMM 52-11-00 (AALA201709189049) AND UPPER GUIDE ARM PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA201709199013Seat · unsecureAIRCRAFT WAS NOT GROUNDED. CAPTAINS SEAT WILL NOT LOCK IN THE HORIZONTAL POSITION, SLIDES ON TAKEOFF. REMOVED AND REPLACED CAPTAINS SEAT ASSEMBLY PER AMM 25-11-01. OPERATIONAL CHECK GOOD.SDR AALA201709189049Plate · failedAIRCRAFT WAS GROUNDED. L1 DOOR GUIDE ARM PIN INSPECTION FOUND DOOR HOLD OPEN LATCH WON'T LOCK DOOR IN OPEN POSITION. REMOVED AND REPLACED UPPER CAM PLATE PER AMM 52-11-00 AND UPPER GUIDE ARM PER AMM 52-11-21 (AALA201709219001). OPERATIONAL CHECK GOOD.SDR AALA201709189048Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR HAS A DETACHED LENS COVER. REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170917002Transition Panel · corrodedCORROSION ON FORWARD CARGO LEFT TRANSITION PANEL FROM BS 500 TO 500I. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA20170917003Transition Panel · corrodedCORROSION ON FORWARD CARGO RIGHT TRANSITION PANELS BETWEEN FUSELAGE STATIONS 420 AND 440 AND BETWEEN FUSELAGE STATIONS 500 AND 500I. REMOVED AND REPLACED TRANSITION PANELS IAW DWG 51-00-05-1, SRM 51-10-02, SRM 53-00-53-2R, AND DRAWING 143A8126.SDR AALA201709189050Angle · looseL1 DOOR GIRT BAR ANGLE IS LOOSE. ATTACHED GIRT BAR ANGLE IAW SRM 51-20-01. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201709189042Sign · missingEMERGENCY EXIT SIGN AT ROW 15ABC IS MISSING. REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201709279037Stringer · corrodedCORROSION AROUND FASTENERS BETWEEN BS 807 AND 827 AT STRINGER 25L. REMOVED AND REPLACED THE STRINGER IAW SRM 53-00-03, D 51-00-05, AND DRAWING 146A3233.SDR AALA201709279035Stringer · corrodedCORROSION AROUND FASTENER HOLES ON INSIDE OF STRINGER 26L BETWEEN BS 887 AND 907. REMOVED AND REPLACED THE STRINGER IAW D 51-00-05, DRAWING 147A0040, AND EA 272761.SDR AALA201709279034Intercostal · corrodedCORROSION ON INTERCOSTAL AT STRINGER 21R BETWEEN BS 947.5 AND 952. REMOVED AND REPLACED THE INTERCOSTAL D 51-00-05-1, EA 272761, AND DRAWING 147A8801.SDR AALA201709279033Intercostal · corrodedCORROSION ON INTERCOSTAL AT STRINGER 25R BETWEEN BS 847 AND 855. REMOVED AND REPLACED THE INTERCOSTAL IAW D 51-00-05 AND DRAWING 146A8123.SDR AALA201709279032Stringer · corrodedCORROSION ON STRINGER 21R BETWEEN BS 907 AND 927. REPAIRED THE STRINGER IAW SRM 53-00-03-2R-1 AND EA 272761.SDR AALA201709279022Shear Tie · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON SHEAR TIE UPPER SIDE OF LOWER FLANGE AT FUSELAGE STATION 947.5 BETWEEN STRINGERS 27L AND 27R. REMOVED AND REPLACED SHEAR TIE PER SRM 51-10-02-0G, AARD 51-00-05 AND DRAWING 147A0040.SDR AALA201709279021Shear Tie · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON SHEAR TIE UPPER SIDE OF LOWER FLANGE AT FUSELAGE STATION 947.5 BETWEEN STRINGERS 26L AND 27L. REMOVED AND REPLACED SHEAR TIE PER SRM 51-10-02, AARD 51-00-05, AND DRAWING 147A0040.SDR AALA201709279020Shear Tie · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON SHEAR TIE UPPER SIDE OF LOWER FLANGE AT FUSELAGE STATION 986.5 BETWEEN STRINGERS 26L AND 27L. REMOVED AND REPLACED SHEAR TIE PER SRM 53-00-53-1A AND SRM 51-40-02.
Back to Boeing 737-823