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 AALA201710049017Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR IS MISSING. REPLACED EXIT SIGN (IDENTIFIER) PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20171003004Computer · faultyEMERGENCY DECLARED. FLIGHT RETURNED TO DEPARTURE ACCOUNT TAIL STRIKE INDICATION ON TAKEOFF. LANDING UNEVENTFUL. REMOVED AND REPLACED HEADS UP GUIDANCE SYSTEM COMPUTER IAW AMM 34-36-01. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20171003001Light · brokenEMERGENCY EXIT LIGHT BY THE R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20171002008Channel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON CABIN AFT ENTRY DOOR FORWARD DOOR DRAIN CHANNEL BETWEEN BS 947 AND 967, LBL 50. REMOVED AND REPLACED THE CHANNEL IAW D 51-00-05-1, SRM 51-40-02, AND DRAWING 147A5650.SDR AALA20171002007Channel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON CABIN AFT SERVICE DOOR DRAIN CHANNEL BETWEEN BS 947 & 967, RBL 50. REMOVED AND REPLACED THE CHANNEL IAW SRM 51-40-02, D 51-00-05-1, AND DRAWING 147A5650.SDR AALA20171002004Intercostal · corrodedCORROSION ON AFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL AT BS 1018, RBL 32. REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-40-02.SDR AALA20171002003Intercostal · corrodedCORROSION ON AFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL AT BS 1024, RBL 20. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-40-02.SDR AALA20171002002Intercostal · corrodedCORROSION ON AFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL AT BS 1022, RBL 12. REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-40-02.SDR AALA201710049016Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY SEAT 23D IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201710039032Lens · missingEMERGENCY EXIT SIGN BY THE L2 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201710049001Floor Panel · delaminatedCABIN FLOOR PANEL NEAR ROW 5 HAS A SOFT SPOT. REMOVED AND REPLACED FLOOR PANEL IAW AMM 53-21-00. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20171002006Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 AND 328 AT LBL 46. REMOVED AND REPLACED THE FLOOR SUPPORT IAW D 51-00-05-1 AND DRAWING 141A5400.SDR AALA201710039031Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R1 DOOR HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201710039004Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN OVER THE R4 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201710039001Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R1 DOOR HAS A DETACHED LENS COVER. REPLACED EXIT SIGN PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170930004Light · damagedEMERGENCY EXIT LIGHT BY THE R4 DOOR GALLEY FRONT IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-02. OPS CHECKED GOOD.SDR AALA20170929009Floorbeam · corrodedCORROSION ON THE FLOORBEAM AT BS 947, LBL 50 AND RBL 50. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-2.SDR AALA20170929003Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY FLOOR ZEE ANGLE AT FUSELAGE STATION 993 BETWEEN RBL33 AND RBL45. REMOVED AND REPLACED ANGLE PER AARD 51-00-05-1 AND PRINT 147A5700.SDR AALA20170929002Plenum · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED AUXILIARY POWER UNIT INLET DUCT PLENUM ASSEMBLY. REMOVED AND REPLACED PLENUM PANEL PER SRM 53-80-30-01, AARD 51-20-01-1, AND AMM 49-15-15.SDR AALA20170929008Transition Panel · corrodedCORROSION ON FORWARD CARGO LEFT TRANSITION PANEL BETWEEN BS 500 AND 500G. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20170929006Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 - 344, LBL45. REMOVED AND REPLACED THE FLOOR SUPPORT IAW D 51-00-05-1 AND PRINT 141A5400.SDR AALA20170929004Floor Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED FLOOR SUPPORT BS 344 TO 360, BL 0. REMOVED AND REPLACED THE FLOOR SUPPORT D 51-00-05-1 AND PRINT 141A5400.SDR AALA20170928009Intercostal · corrodedCORROSION ON INTERCOSTAL AT THE R2 DOOR BETWEEN BS 947 & 967, RBL 50. REMOVED AND REPLACED THE INTERCOSTAL IAW D 51-00-05-1, AND SRM 53-70-51.SDR AALA20170928006Web · corrodedCORROSION FOUND ON THE AFT CABIN WEB BETWEEN BS 986 -1016, RBL 30 - 45. REMOVED AND REPLACED THE WEB IAW D 51-00-5-1 AND DRAWING 147A5700.SDR AALA20170928005Web · corrodedCORROSION ON AFT CABIN LEFT WEB BETWEEN BS 986 AND 1016, LBL 30 - LBL 45. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1 AND DRAWING 147A5700.SDR AALA20170928002Web · corrodedCORROSION ON AFT CABIN LEFT FLOOR WEB FORWARD OF AFT PRESSURE BULKHEAD AT BS 1020, LBL31. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1 AND DRAWING 147A5700.SDR AALA201709299024Lens · detachedEMERGENCY EXIT SIGN BY THE L1 DOOR HAS A DETACHED LENS. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20170928012Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY FLOOR ZEE ANGLE BETWEEN FUSELAGE STATIONS 997 AND 1016 AT RBL32. REMOVED AND REPLACED ANGLE PER AARD 51-00-05-1 AND PRINT 147A5700.SDR AALA20170928010Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT GALLEY FLOOR ZEE ANGLE BETWEEN FUSELAGE STATIONS 991 AND 1016 AT LBL32. REMOVED AND REPLACED ANGLE PER AARD 51-00-05-1 AND PRINT 147A5700.SDR AALA20170929001Frame · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED AUXILIARY POWER UNIT INLET DUCT PLENUM ASSEMBLY FRAME. REPLACED PLENUM FRAME PER SRM 53-80-30-01 AND AMM 49-15-15.SDR AALA20170928003Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT AT RBL 32 BETWEEN BS 990 AND 992. REMOVED AND REPLACED THE FLOOR SUPPORT IAW D 51-00-05-1 AND DRAWING 147A5700.SDR AALA201709299025Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR IS MISSING. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170928013Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 - 328, LBL46. REMOVED AND REPLACED THE FLOOR SUPPORT 51-00-05-01 AND DRAWING 141A5400.SDR AALA20171012010Angle · corrodedCORROSION ON THE ZEE ANGLE AT BS 992, BETWEEN LBL 32 AND LBL 42. REMOVED AND REPLACED THE ANGLE IAW SRM 51-00-05-1 AND DRAWING 147A5700.SDR AALA20170927001Floor Support · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT BS 986 TO 1006, LBL 32. REMOVED AND REPLACED THE FLOOR SUPPORT IAW D 51-00-05-1 AND DRAWING 147A5700.SDR AALA20170927004Rail · corrodedCORROSION ON FORWARD CARGO AFT LOWER BULKHEAD RAIL AROUND THE FASTENER HOLES AT BS 500I, BETWEEN STRINGERS 28L AND 28R. REMOVED AND REPLACED RAIL ASSEMBLY IAW 51-00-05-1 AND SRM 51-10-02.SDR AALA201709289011Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY SEAT ROW 15 IS LOOSE. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA201709289010Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE L2 DOOR HAS A MISSING LENS COVER. REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170926005Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM AT BS 1016, LBL 30. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-R4, AND EA 273426.SDR AALA20170926010Stringer · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT CARGO FLOOR STRINGER AT FUSELAGE STATION 767 +5 AND RBL11. REPAIRED STRINGER PER SRM 53-00-53-2R-2 AND EA 273506.SDR AALA20170926009Stringer · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT CARGO FLOOR STRINGER AT FUSELAGE STATION 767 +5 AND RBL3. REPAIRED STRINGER PER SRM 53-00-53-2R-2 AND EA 273506.SDR AALA20170926008Structure · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT CARGO FLOOR STRINGER AT FUSELAGE STATION 767 +5 AND LBL3. REPAIRED STRINGER PER SRM 53-00-53-2R-2 AND EA 273506.SDR AALA20170926007Support Angle · corrodedCORROSION ON FORWARD SERVICE DOOR CREASE ANGLE ON THE VERTICAL FLANGE AT RBL 58 BETWEEN BS 308 - 328. REMOVED AND REPLACED SUPPORT ANGLE IAW 51-00-05 AND DRAWING 141A312.SDR AALA20170926003Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BS 344 - 360, LBL 12. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 141A5400.SDR AALA201709289012Megaphone · brokenAIRCRAFT WAS NOT GROUNDED. MEGAPHONE IN THE FIRST CLASS HAS A BROKEN GREEN SEAL. REMOVED AND REPLACED MEGAPHONE PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA201709279015Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT THE R1 DOOR HAS A MISSING LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170926011Intercostal · crackedCRACKED INTERCOSTAL IN THE E & E BAY CEILING, BS 328 & 344, LBL 45. REMOVED AND REPLACED THE INTERCOSTAL IAW DWG 51-00-05-01 AND DRAWING 141A5410.SDR AALA20170925001Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM AT BS 986 BETWEEN LBL 46 AND RBL 46. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA20170929005Floorbeam · crackedCRACKED FLOORBEAM ANGLE AT BS 540, LBL 2. REMOVED AND REPLACED THE ANGLE IAW SRM 51-10-02-0G, PARAGRAPH 9.SDR AALA201709269013Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R4 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-50-00. OPERATIONAL CHECK GOOD.
Back to Boeing 737-823