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 AALA2020022659004Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND, FORWARD, EMERGENCY EXIT WINDOW LIGHT BALLAST INOPERABLE. MAINTENANCE REPLACED LIGHT BALLAST PER AMM 33-21-00.SDR AALA202002259011Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: AUTO THROTTLES FAILED BEGINNING DESCENT FROM FL 200. ACCOMPLISHED DFCS/AT BITE TEST IAW AMM 22-11-00. NO FAULT NOTED.SDR AALA2020022549034Gearbox · faultyAIRCRAFT NOT GROUNDED: AUTO THROTTLE DISCONNECTED DURING TAKEOFF. ***SUPPLEMENTAL ACTION SECT 4 AND 5: REMOVED AND REPLACED LH AUTOTHROTTLE GEARBOX IAW AMM 22-31-91.***(CLOSED)SDR AALA202003049006Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540 AND LBL 2. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA202003049005Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540 AND RBL 2. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA2020032489024Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT AT BS 957 AND LBL 47. REPLACED FLOOR SUPPORT PER AARD 51-00-05.SDR AALA2020032489019Pressure Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND MAIN LANDING GEAR WHEEL WELL PRESSURE WEB AT BS 663 AND RBL 40. REPAIRED PRESSURE WEB PER SRM 57-10-10-02R.SDR AALA202003109024Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT FORWARD BAFFLE CLIP AT BS 500H AND RBL 24. REPLACED BAFFLE CLIP PER AARD 53-00-01-6.SDR AALA202003049010Fitting · crackedAIRCRAFT IN BASE MAINTENANCE:CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP ON THE FORWARD SIDE OF THE FRAME AT BS 500G AND RBL 24. REPLACED CLIP PER AARD 53-00-01-6.SDR AALA202002249026Tire · blownAIRCRAFT WAS GROUNDED: DFW REPORTS NB 2 MLG TIRE BLEW ON TAKEOFF FROM RIC TRIP 2204. MAIN LANDING GEAR TIRE TO BLOW. THIS CAUSED THE TREAD CAP TO SEPARATE FROM THE TIRE, STRIKING AND CAUSING DAMAGE TO THE LEFT TRAILING EDGE FLAP AND THE LEFT WING TO BODY FAIRISDR AALA2020022549010Battery · faultyAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT JUMPSEAT RIGHT SIDE NEEDED BATTERY. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER MM 25-22-00.SDR AALA202003049008Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 344 AND BS 360 AT BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202002249025Condenser · crackedAIRCRAFT WAS GROUNDED: AT TOP OF DECENT AND POWER REDUCTION HAD SMELL OF DIRTY SOCKS FOR 3-4 MI. FOUND L/H CONDENSER CRACKED AT TWO LOCATIONS. REMOVED AND REPLACED L/H CONDENSER UNIT IAW AMM 21-51-12. LEAK AND OPS CHECK GOOD.SDR AALA202002249038Indicator · false indicationAIRCRAFT WAS GROUNDED: DIVERTED IAH ACCOUNT REPORTED FUEL IMBALANCE. FUEL QUANITY IMBALANCE. LEFT MAIN DECREASING RIGHT,MAIN DOES NOT. EMERGENCY DECLARED. PERFORMED FUEL TRANSFER AND FUEL QUANITY STICK CHECK.FOUND NORMAL.READINGS MATCH. ACCOMPLISHED OPS TEST FSDR AALA2020032489015Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP ON THE FORWARD SIDE OF THE FRAME AT BS 500F AND RBL 26. REPLACED CLIP PER SRM 51-40-02.SDR AALA2020032489013Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 46. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA2020032489012Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP ON THE AFT SIDE OF FRAME AT BS 500H AND S26L. REPLACED CLIP PER SRM 51-40-02.SDR AALA202003109023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727C AND BS 847 AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202003109022Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 767 AND BS 787 AT S25R. REPLACED SHIELD PER AARD 51-00-05-01.SDR AALA202003049007Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND FORWARD DOOR CUT OUT LOWER THRESHOLD CREASE ANGLE AT BS 326. REPAIRED CORROSION PER SRM 53-10-15-1A AND 51-20-01. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS SDR AALA202002249020Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE DETECTOR ILLUMINATED IN FLIGHT. FLIGHT ATTENDANTS SMELLED HEAVY SMOKE. MAINTENANCE PERFORMED SATISFACTORY LAVATORY SMOKE DETECTION TEST PER AMM 26-14-00.SDR AALA202002219031Wire · frayedAIRCRAFT WAS GROUNDED: WITH FLAPS 5 SELECTED LE FLAPS TRANSIT LIGHT ILLUMINATED. RAN CHECKLIST NO.4 PANEL LEADNG EDGE PANEL SHOWED IN TRANSIT. AFTER SLOWING FOR APPROACH LE FLAPS EXT LIGHT ILLUMINATED AND STAYED ON FOR THE REST OF APPROACH. NO.4 PANEL SHOWEDSDR AALA202002219034Indicator · malfunctionedAIRCRAFT NOT GROUNDED: AIR RETURNED TO MIA. SUSPECTED FUEL LEAK LEFT SIDE. FUEL WAS BALANCED AT,CENTER TANK OFF. DURING HIGH POWER CLIMB FUEL IN,LEFT TANK VISIBLY COUNTED DOWN 200 IMBALANCE. EMERGENCY DECLARED. PERFORMED FIM 28-41-00-810-801. NO FAULTS FOUND. SDR AALA2020032489017Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 540 AND LBL 3. REPLACED FLOOR SUPPORT PER SRM 51-31-00.SDR AALA2020032489016Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 540 AND RBL 3. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA202003049009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2020022769012Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR WHEEL WELL VERTICAL PRESSURE DECK WEB CRACKED AT BS 663.75 AND LBL 36, 4 INCHES DOWN FROM THE CEILING. REPAIRED PRESSURE DECK PER SRM 57-10-10-2R-4.SDR AALA202002219024Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE AT SEAT 2. MAINTENANCE REPLACED FORWARD SEAT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202002219023Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE AT SEAT 1. MAINTENANCE REPLACED FORWARD SEAT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202002219025Retainer · misalignedAIRCRAFT NOT GROUNDED: 2R SLIDE COMING OUT HARD TO ARM GIRT BAR. REALIGNED GIRT BAR RETAINER IAW AMM 25-66-00.SDR AALA202002209007Engine · fireAIRCRAFT WAS GROUNDED: AIRCRAFT TAXING BEHIND US REPORTED FLAMES COMING FROM TAIL PIPE ON NO.2 ENGINE, NO INDICATION IN FLIGHT DECK. INSPECTED #2 ENGINE INLET AND EXHAUST IAW FIM 71-05-00 NO DAMAGE NOTED. FLIGHT CREW RAN ENGINE AT IDLE ALL CHECKS NORMAL; OK FSDR AALA202002209009Slide · out of alignmentAIRCRAFT NOT GROUNDED: SLIDE ON 1R OUT OF HOLDER COVER. REMOVED AND REPLACED 1R DOOR MOUNTED ESCAPE SLIDE IAW AMM 25-66-01.SDR AALA2020022099003Flashlight · brokenAIRCRAFT WAS NOT GROUNDED: BROKEN EMERGENCY FLASHLIGHT AT FORWARD FLIGHT ATTENDANT SEAT. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA2020022099021Indicator · malfunctionedAIRCRAFT WAS GROUNDED: AT FL370 CABIN DIFFERENTIAL PRESSURE WAS NORMAL. AT FL 380 IT WENT TO 8.65-8.70 (8.35NORMAL). AT FL380 CABIN PRESSURE WAS 6500-7000FEET. DESCENDED TO FL360 AND DIFFERENTIAL STAYED HIGH (8.4-8.5) UNTIL WE DESCENDED THROUGH ABOUT FL 300. ASDR AALA202002199013Slide · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT SERVICE DOOR SLIDE PROTRUDES OUT AND NEEDED TO BE ADJUSTED. MAINTENANCE REPLACED L2 DOOR SLIDE PER CARD 25-94-13.SDR AALA202002259036Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 344 AND BS 360 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202002259035Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202002259034Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA2020022089005Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED AT BS 663 BETWEEN LBL 42 AND LBL 49.5. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9R9 AND SRM 57-10-10-2R2.SDR AALA2020022089027Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: DUE TO REPEATS OF R-1 DOOR SLIDE DISLODGED OR NOT SECURE REPLACEMENT OF THE SLIDE REQUIRED. REPLACED SLIDE PER AMM 25-66-01.SDR AALA202002199012Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS FROM SEAT 16 TO 20 RIGHTHAND, INOPERABLE DURING BATTERY TEST. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA202002189021Doubler · crackedAIRCRAFT WAS NOT GROUNDED: CRACKED FUSELAGE SKIN DOUBLER AT THE EXTERNAL GROUND POWER DOOR CUT OUT WHERE THE DOOR LATCH CONTACTS. REPAIRED SKIN DOUBLER PER EA 303418.SDR AALA202002179012Wire Harness · damagedAIRCRAFT WAS GROUNDED: AIRCRAFT RETURNED TO MIA WHEN AFTER TAKE OFF WHILE FEEDING FROM THE CENTER TANK THE RIGHT FUEL TANK INDICATION DECREASED TO 7500 LBS. AN EMERGENCY WAS DECLARED AND THE FLIGHT LANDED WITHOUT FUTHER INCIDENT. OPENED RT WING MAIN TANK ALLSDR AALA202002259031Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR BEAM EXPANSION JOINT AT BS 540 AND LBL 3. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA202002179016Pump · faultedAIRCRAFT WAS IN BASE MAINTENANCE: AIRCRAFT FAILED FUNCTION CHECK FLIGHT DUR TO AT TAKEOFF THRUST, THE RIGHT ENGINE STABILIZED AT 98)? N1 AND LEFT ENGINE AT 90)? N1, AS L THROTTLE WAS ADVANCE TO MATCH, DID NOT ACHIEVE 98)? IN CLIMB, BOTH THROTTLES ACHIEVED COSDR AALA2020021769019Hmu · faultyAIRCRAFT WAS IN BASE MAINTENANCE: AIRCRAFT FAILED FUNCTION CHECK FLIGHT DUR TO AT TAKEOFF THRUST, THE RIGHT ENGINE STABILIZED AT 98)? N1 AND LEFT ENGINE AT 90)? N1, AS L THROTTLE WAS ADVANCE TO MATCH, DID NOT ACHIEVE 98)? IN CLIMB, BOTH THROTTLES ACHIEVED COSDR AALA2020021769010Shade · damagedAIRCRAFT WAS GROUNDED: SEAT ROW 14F EMERGENCY EXIT DOOR WINDOW SHADE AND HANDLE DAMAGED AND PARTIALLY BLOCKING VISIBILTY OF THE WINDOW. REPLACED WINDOW SHADE ASSEMBLY PER AMM 52-22-00.SDR AALA2020021759007Oven · odorAIRCRAFT WAS NOT GROUNDED: FIRST CLASS GALLEY OVEN #2 HAS AN ELECTRICAL ODOR. **SUPPLEMENTAL ACTION SECT 4 AND 5: REPLACED #2 F/C OVEN REF AMM 25-32-03.***(CLOSED)SDR AALA202002259030Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR BEAM EXPANSION JOINT AT BS 540 AND RBL 3. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA2020022419005Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STATION 138, 17 INCHES AFT OF THE LEADING EDGE. REPAIRED SKIN PER SRM 55-10-01-2R-11.
Back to Boeing 737-823