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 AALA202308018101Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 951 FROM RBL 53 TO RBL 43 REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202307313284Door Latch · obstructedAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH IS STICKING. PAX UNABLE TO UNLOCK DOOR FROM INSIDE LAVATORY. FOUND DEBRIS MAKING IT DIFFICULT TO OPERATE. REMOVED DEBRIS.SDR AALA202307315059Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED BURNING PLASTIC SMELL IN AFT GALLEY BEFORE LANDING. ACCOMPLISHED WORK CARD 08L0021001. NUMBER 4 COFFEE MAKER SHOW SIGNS OF BURN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202308110618Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF AFT PASSENGER COMPARTMENT FLOORBEAM LOCATED AT BS 986 AND LBL 51. REPAIRED CHORD PER SRM 53-70-51-2R6.SDR AALA202308022746Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE AT SEAT 12D. REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA202307312385Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD #2 FLIGHT ATTENDANT FLASHLIGHT TEST INOPERATIVE. REMOVED AND REPLACED FORWARD #2 FLIGHT ATTENDANT FLASHLIGHT BATTERY.SDR AALA202307316867Sign · detachedAIRCRAFT WAS GROUNDED: EMERGENCY EXIT SIGN AT SEATS 17 DEF IS NOT ATTACHED. REMOVED AND REPLACED EXIT EMERGENCY LIGHT ASSEMBLY AT SEAT 17 DEF. PER AMM 33-51-01.SDR AALA202307312051Light · odorAIRCRAFT WAS GROUNDED: DURING CLIMB OUT AND CRUISE FLIGHT ATTENDANT REPORTED A BURNING PLASTIC SMELLIN THE AFT GALLEY. PERFORMED SMOKE ODOR WORK CARD 08L00021001. FOUND BURNED OUT WORK LIGHT. REMOVED AND REPLACED LIGHT. NO NEW ODORS NOTED.SDR AALA202308182427Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ROUND FASTENER HOLES ON STRINGER LOCATED AT BS 931.5, S26R. REPAIRED STRINGER PER SRM 53-00-03-2R1 AND EA 347083.SDR AALA202308169827Transition Panel · corrodedAIRCRAFT N BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOWER ATTACH FITTING LOCATED FROM BS 767 TO BS 787, RBL 24. REPLACED TRANSITION PANEL PER SRM 51-10-02-0G.SDR AALA202308104001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 767 TO BS 787 AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202308102704Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202308091300Floor Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540 FROM BL 0 TO LBL 18. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202308096259Floor Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540 FROM BL 0 TO RBL 18. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202308073616Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 500A AT RBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202308074434Shade · damagedAIRCRAFT WAS NOT GROUNDED: 17A WINDOW SHADE CRUMPLED. **SUPPLEMENTAL REPORT FOR AALA202308014434: REPLACED WINDOW SHADE PER AMM 25-21-12.** (CLOSED)SDR AALA202308075639Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR SHIELD LOCATED AT BS 495 AT S26R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202308071346Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR SHIELD LOCATED AT BS 787 AT S24R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202308079965Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1SDR AALA202308079300Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 500I AND BS 500C AT LBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202308073561Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT S26R. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A.SDR AALA202308014434Unknown · unknownAIRCRAFT WAS NOT GROUNDED: 17A WINDOW SHADE CRUMPLED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202307310660Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT RIGHT FLASHLIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED BATTERY PER AMM 25-64-00.SDR AALA202308210560Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, SECOND VERTICAL STIFFENER FROM FRONT ON RIB, 5 INCHES AFT OF SPAR, LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202308212852Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, THIRD VERTICAL STIFFENER FROM FRONT ON RIB, 6 INCHES AFT OF SPAR, LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202308212863Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, FOURTH VERTICAL STIFFENER FROM FRONT ON RIB, 10 INCHES AFT OF SPAR, LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202308108178Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, FIRST STIFFENER FROM FRONT, LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R.SDR AALA202308091619Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-10-02.SDR AALA202308097197Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 277 TO BS 294 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202307287996Unknown · unknownAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE #2 THRUST REVERSER INDICATION ON OVERHEAD PANEL ON DESCENT INTO TPA. QRH PROCEDURE ACCOMPLISHED AND AIRCRAFT LANDED SAFELY AT TPA. MAINTENANCE ACCOMPLISHED FIM 78-31-00 AND FOUND NO FAULTS.SDR AALA202309015114Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPORT ASSEMBLY AT BS 500I AND LBL 24. REPLACED SUPPORT ASSEMBLY PER AARD 51-00-05-1.SDR AALA202309011519Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENERS HOLES IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 950, FROM RBL 24 TO RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308218381Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500C. REPLACED TRANSITION PANEL PER SRM 53-130-00.SDR AALA202308178763Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR THRESHOLD CREASE ANGLE LOCATED AT BS 305, RBL 55. REPLACED CREASE ANGLE PER SRM 51-40-02-00G.SDR AALA202308172289Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR THRESHOLD CREASE ANGLE LOCATED FROM BS 323 TO BS 326, RBL 60. REPLACED CREASE ANGLE PER SRM 51-40-02-00G.SDR AALA202308149193Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON FLOORBOARD SUPPORT INTERCOSTAL LOCATED AT BS 950, RBL 34.75. REPLACED INTERCOSTAL PER AARD 51-00-05 1.SDR AALA202308118079Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF AFT PASSENGER COMPARTMENT FLOORBEAM LOCATED AT BS 986 AND RBL 45.5. REPAIRED CHORD PER SRM 53-70-51-2R6 ALTERNATIVE 4.SDR AALA202308105565Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 961 AND LBL 24.75. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308103780Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 953 AND LBL 24.75. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308103889Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM OUTBOARD OF RIGHT HAND AFT LAVATORY MOUNT, LOCATED AT BS 947 AT RBL 51. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA202308101815Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500H TO BS 500I AT LBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5..SDR AALA202308095939Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 550G + 8 AND RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308088004Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986 AND LBL 44. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202308078017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING UPPER TRAILING EDGE BLADE SEAL RETAINER ANGLE AT WS 405.50 AND RIB 13. REPLACED RETAINER ANGLE PER SRM 51-40-02.SDR AALA202307275726Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE CARGO TRACK-TIE DOWN RAIL LOCATED BETWEEN BS 795 AND BS 847 AT RBL 13.84. REMOVED AND REPLACED TIE-DOWN RAIL PER SRM 53-00-53-2R PROCEDURE 4 REPAIR 4.SDR AALA202307272289Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR STUCK. REMOVED LINT AND LUBRICATED DOOR PER FIM 52-50-00SDR AALA202307275795Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: MEGAPHONE IN THE G7 GALLEY IS INOPERATIVE. REPLACED BATTERIES PER AMM 25-64-00.SDR AALA202307267695Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307264480Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307269720Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.
Back to Boeing 737-823