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 AALA202506130316Stringer · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STRINGER S3L AT BS 294.5. REPAIRED STRINGER PER SRM 53-00-03-2R-3.SDR AALA202507118408Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 986, RBL 44. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-4.SDR AALA202507026803Support Fitting · wornAIRCRAFT IN BASE MAINTENANCE: NUMBER 3 TRANSMISSION ATTACH FITTING SUPPORT AND TRACK BUSHING ARE LOOSE AND WORN. INSTALL TRANSMISSION ATTACH FITTING SUPPORT TO TRANSMISSION, PER 27-51-31-400-801 STEP F SUBTASK 420-001(1)(A) THRU (E)1.SDR AALA202507024915Support Fitting · wornAIRCRAFT IN BASE MAINTENANCE: NUMBER 7 TRANSMISSION ATTACH FITTING SUPPORT AND TRACK BUSHING ARE LOOSE AND WORN. INSTALL TRANSMISSION ATTACH FITTING SUPPORT TO TRANSMISSION. PER AMM 27-51-41-400-802SDR AALA202507024439Fitting · wornAIRCRAFT IN BASE MAINTENANCE: NUMBER 6 TRANSMISSION ATTACH FITTING SUPPORT AND TRACK BUSHING ARE LOOSE AND WORN. INSTALL TRANSMISSION ATTACH FITTING SUPPORT TO TRACK. PER AMM 27-51-31-400-801.SDR AALA202506279521Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-01-5.SDR AALA202506274342Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-01-5.SDR AALA202506269300Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR MAIN SILL INNER CHORD (CREASE ANGLE) AT BS 990, RBL 46. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202506261143Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 60. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202506251536Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F, LBL 26. REPAIRED PER SRM 51-10-02.SDR AALA202506250995Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F, LBL 26. REPAIRED PER SRM 51-10-02.SDR AALA202506256132Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F, LBL 26. REPAIRED PER SRM 51-10-02.SDR AALA202506245740Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, RBL 24. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202506249129Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 312, LBL 15. REPAIRED UPPER CHORD PER SRM 53-10-51-2R-15 ALTERNATIVE 3.SDR AALA202506235493Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506238624Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500H PLUS 16 INCHES, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506236537Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500G, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506232377Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500G, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506239814Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500G, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506230675Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500H, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506232556Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500H, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506206261Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506207192Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506204257Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F PLUS 11.5 INCHES, S25R . REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506203424Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 480 PLUS 8 INCHES, S25L, LBL 33. REPAIRED PER SRM 51-10-02.SDR AALA202506203529Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506208810Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506205847Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500D PLUS 7 INCHES, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506209771Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500D PLUS 11.5 INCHES, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506207558Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500D PLUS 16 INCHES, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506208357Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506208440Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506208557Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E, LBL26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506202484Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 950 TO BS 967, AT LBL48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506182220Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER FUSELAGE POTABLE WATER SERVICE DOOR 146AR CUTOUT SKIN AT BS 917. ACCOMPLISHED DOUBLER REPAIR PER DWG 147A7221.SDR AALA202506182667Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: WHILE IN CRUISE FLIGHT AT FL330, ICING CONDITIONS WERE ENCOUNTERED AND ENGINE ANTI-ICE WAS TURNED ON. THE NUMBER 1 ENGINE BLUE COWL VALVE OPEN LIGHT ILLUMINATED BRIGHT AND DID NOT DIM. SHORTLY THERE SDR AALA202506131457Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE AT STA 663, LBL 8. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202506135841Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE AT STA 663, RBL 8. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202506122667Anti-Ice Valve · warning lightAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: WHILE IN CRUISE FLIGHT AT FL330 ICING CONDITIONS WERE ENCOUNTERED AND ENGINE ANTI-ICE WAS TURNED ON. THE NUMBER 1 ENGINE BLUE COWL VALVE OPEN LIGHT ILLUMINATED BRIGHT AND DID NOT DIM. SHORTLY THERE ASDR AALA202506113534Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS HARD TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. PER AMM 25-40-14. OPERTIONAL CHECKED NORMAL.SDR AALA202507248553Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING INBOARD MAIN FLAP HAS AREA OF DELAMANATION AT OUTBOARD LOWER TRAILING EDGE. INSTALLED WEDGE PANEL. PER SRM 51-40-02.SDR AALA202506271604Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT BS 990, RBL 31. ACCOMPLISHED DOUBLER REPAIR PER SRM 51-40-02-0G, SRM 51-70-13-2R-4 AND EA 295213.SDR AALA202506274434Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT BS 986.5, RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202506242097Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR LOWER SILL INNER CHORD (CREASE ANGLE) AT BS 956, RBL 46. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202506247383Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, RBL 50. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202506182768Pressure Switch · failedAIRCRAFT WAS NOT GROUNDED: AUTO BRAKE DISARMED, LIGHT ILLUMINATED BEFORE LANDING. IT FAILED TO ARM AGAIN. AUTO BRAKE SWITCH TURNED OFF. THIS IS A REPEATED WRITE-UP AND FOR THE THIRD FLIGHT IN A ROW. MULTIPLE BITE TESTS HAVE BEEN ACCOMPLISHED, AND THE AUTO BRAKSDR AALA202506179244Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, LEFT HAND WHEEL WELL, AT STA 663.75, LBL 40. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 51-70-04-2R-10SDR AALA202506130807Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, RIGHT HAND WHEEL WELL, AT STA 663, RBL 31.83. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2.SDR AALA202506112768Autobrake Sys · faultedAIRCRAFT WAS NOT GROUNDED: AUTO BRAKE DISARMED LIGHT ILLUMINATED BEFORE LANDING. IT FAILEDTO ARM AGAIN. AUTO BRAKE SWITCH TURNED OFF. THIS IS A REPEATED WRITE UP AND FOR THE THIRD FLIGHT IN A ROW. MULTIPLE BITE TEST HAS BEEN ACCOMPLISHED AND THE AUTO BRAKE CONSDR AALA202506181962Oven · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT IS SAYING THE NUMBER 1 OVEN HAS A BURNING SMELL WHEN USED. REMOVE AND REPLACE NUMBER 1 OVEN. PER AMM 25-32-03. OPERATIONAL CHECK GOOD.
Back to Boeing 737-823