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 AALA202303060674Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303068875Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303061566Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303069189Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303064000Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303063555Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303062033Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303060704Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303061358Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 342705.SDR AALA202303013460Door Frame · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKING. TIGHTENED DOOR JAMB FORWARD LAVATORY.SDR AALA202303081484Slide · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR GIRT BAR IS WORN. REMOVED AND REPLACED R1 DOOR SLIDE.SDR AALA202303087871Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN BAFFLE LOCATED BELOW FORWARD CARGO COMPARTMENT FROM BS 500B TO BS 500C AT RBL 25. REPLACED BAFFLE PER SRM 51-40-02 AND SRM 51-40-05.SDR AALA202303086054Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 947.5 TO BS 967 AT LBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303061765Panel · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WHEEL WELL FORWARD LOWER VAPOR BARRIER PANEL CRACKED. CRACK LOCATED AT STA 663.75 AND LEFT BUTT LINE 24.97.SDR AALA202302280381Bearing · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR AT LEFT HORIZONTAL STABILIZER. REMOVED AND REPLACED BEARING (AALA202302280381) AND SLEEVE (AALA202302282608).SDR AALA202302282608Sleeve · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR AT LEFT HORIZONTAL STABILIZER. REMOVED AND REPLACED BEARING (AALA202302280381) AND SLEEVE (AALA202302282608).SDR AALA202303165777Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATE HOLE IN BAFFLE LOCATED AT BS 500A, S25R, AND RBL 28. REPLACED BAFFLE PER AARD 51-00-05-1 AND 53-00-01-6.SDR AALA202303161812Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATE HOLE IN BAFFLE LOCATED AT BS 500G, S25R, AND RBL 28. REPLACED BAFFLE PER AARD 53-00-01-6.SDR AALA202303132483Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN BAFFLE LOCATED AT BS 500D, S25R, AND RBL 28. REPLACED BAFFLE PER AARD 51-00-05-01 AND SRM 53-00-01-06.SDR AALA202303138085Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN BAFFLE LOCATED AT BS 500I, S25R, AND RBL 28. REPLACED BAFFLE PER AARD 51-00-05-01 AND SRM 53-00-01-06.SDR AALA202303132615Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN BAFFLE LOCATED AT BS 500G, S25R, AND RBL 28. REPLACED BAFFLE PER AARD 51-00-05-01 AND SRM 53-00-01-06.SDR AALA202303080795Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN BAFFLE LOCATED BELOW FORWARD CARGO COMPARTMENT AT BS 500H AND S25R. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05-1 AND AARD 53-00-01-6.SDR AALA202303087766Rib · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND HORIZONTAL STABILIZER RIB 5 LOCATED AT ELEVATOR STATION 66.54. REPAIRED RIB PER EA 342655.SDR AALA202303083698Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN, RIGHT HAND AFT FLOOR SUPPORT INTERCOSTAL, LOCATED AT BS 958 AND RBL 47. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303083603Tee Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN, LEFT HAND AFT FLOOR BEAM T CHORD, LOCATED AT BS 986.5 LBL 44. REPAIRED T CHORD PER SRM 53-70-51-2R-4.SDR AALA202303086556Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN RIGHT HAND SEAT TRACK LOCATED FROM BS 380 TO BS 440 AT RBL 45. REPAIRED SEAT TRACK PER SRM 53-00-52-2R REPAIR 4.SDR AALA202303082576Floorbeam · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN AFT PASSENGER CABIN FLOORBEAM LOCATED AT BS 947.5 AND FROM BL 0 TO RBL 4. REPAIRED FLOORBEAM PER EA 342474.SDR AALA202303066166Transition Panel · inoperativeAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE TRANSITION PANEL SECTION BETWEEN BODY STATION 867 AND BODY STATION 887 AND RIGHT BUTT LINE 20. REMOVED AND REPLACED AFT CARGO COMPARTMENT RIGHT SISDR AALA202303066646Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BOLT FRONT SPAR FITTING FORWARD RIGHT AT VERTICAL STABILIZER BODY STA 959.8 AND VERTICAL FIN WATER LINE 0.0. LENGTH: 0.450 INCHES, WIDTH: 0.230 INCHES, AND DEPTH: 0.003 INCHES. REMOVED AND REPLACED BOLT PER JOB CARD.SDR AALA202303065852Rib · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT ELEVATOR STA 176.64. REPAIRED RIB PER EA 342613.SDR AALA202303016429Window · crackedAIRCRAFT WAS GROUNDED: WINDSHIELD PANE CRACKS AT EDGES IN AREA OF (4) SOLDER JOINTS WITH EVIDENCE OF MOISTURE INGRESSION (CLOUDY WHITE HAZE) AROUND EACH AREA. REMOVED AND REPLACED R1 WINDOW.SDR AALA202302271476None · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR GIRT BAR CLIP IS TOO TIGHT. ADJUSTED GIRT BAR RETAINER CLIPS PER AMM 25-66-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302274605Bearing · lack of lubeAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO OPEN AND CLOSE. LUBED L1 DOOR HANDLE CRANK ASSEMBLY CAM FOLLOWER BEARINGS PER AMM 12-25-11.SDR AALA202302270386Window · crackedAIRCRAFT WAS GROUNDED: ENROUTE THE LEFT FORWARD WINDOW "OVERHEAT" LIGHT ILLUMINATED THIRTY SECONDS LATER THE L1 OUTER PANE CRACKED. EMERGENCY WAS DECLARED INTO ORD. REMOVED AND REPLACED NUMBER 1 WINDOW.SDR AALA202302275643Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: ON APPROACH DURING CONFIGURATION LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED WITH ASSOCIATED NUMBER 3 SLAT AMBER LIGHT ILLUMINATED. REMOVED AND REPLACED S173 LE FLAPS PROXIMITY SENSOR.SDR AALA202302273835Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS MEGAPHONE INOPERATIVE. REMOVED AND REPLACED MEGAPHONE.SDR AALA202302277235Pin · stickingAIRCRAFT WAS GROUNDED: UNABLE TO OPEN FORWARD CABIN DOOR 1L. REPLACED HINGE ARM PIN.SDR AALA202302277776Slide · looseAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE PACK GIRT BAR LOOSE. REPLACED R1 DOOR SLIDE PER AMM 25-66-01 AND JOB CARD 25-9440.SDR AALA202302278846Clamp · looseAIRCRAFT WAS GROUNDED: LEFT PACK LIGHT ILLUMINATED INFLIGHT. RESET WITH TRIP RESET 3 TIMES. LIGHT ILLUMINATED AGAIN AND STAYED ON. FIGHT DECLARED AN EMERGENCY, RETURN TO MIA LANDING SAFELY. MAINTENANCE FOUND LEAKS IN THE LEFT PACK SYSTEM BUT DID NOT DUPLICATE SDR AALA202302273521Clamp · brokenAIRCRAFT WAS GROUNDED: LEFT PACK LIGHT ILLUMINATED INFLIGHT. RESET WITH TRIP RESET 3 TIMES. LIGHT ILLUMINATED AGAIN AND STAYED ON. FIGHT DECLARED AN EMERGENCY, RETURN TO MIA LANDING SAFELY. MAINTENANCE FOUND LEAKS IN THE LEFT PACK SYSTEM BUT DID NOT DUPLICATE SDR AALA202302278700Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G4 GALLEY SIDE ROD ATTACHMENT DOUBLER LOCATED AT BS 1006 AND RBL 54. REPLACED ATTACH DOUBLER PER EA 342272.SDR AALA202302271552Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB 3 LOCATED AT STABILIZER STA 92.7. REPLACED RIB FITTING PER SRM 51-40-02-0G.SDR AALA202302249452Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND RIGHT AFT DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT AFT DOOR EXTERIOR EMERGENCY LAMP.SDR AALA202303098068Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN FLOOR STRUCTURE UPPER ANGLE ON INTERCOSTAL LOCATED FROM BS 520 TO BS 500I AT BL 0. REPLACED ANGLE PER AARD 53-00-05-1.SDR AALA202303090155Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN INTERCOSTAL UPPER ANGLE LOCATED FROM BS 380 TO BS 400 AT LBL 16. REPLACED ANGLE PER AARD 51-00-05-1 AND DWG 143A5400.SDR AALA202303093385Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN INTERCOSTAL UPPER ANGLE LOCATED FROM BS 380 TO BS 400 AT LBL 1. REPLACED ANGLE PER AARD 51-00-05-1 AND DWG 143A5400.SDR AALA202302277866Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY CEILING EMERGENCY LIGHT HAS ONE BULB OUT. RELAMPED AND PERFORMED SATISFACTORY OPERATION CHECK OF THE FORWARD GALLEY CEILING EMERGENCY LIGHT.SDR AALA202302274986Filter · inoperativeAIRCRAFT WAS GROUNDED: SYSTEM A AND B QUANTITY 80 PERCENT IN CRUISE. 1 HOUR LATER SPLIT 64/104. 1 HOUR LATER SYSTEM B STARTED DROPPING 1/10 MIN 70 PERCENT WENT TO 0 PERCENT IN 1 MINUTE SYSTEM B PRESSURE NORMAL UNTIL FLAPS EXTENDED. REMOVED AND REPLACED ELEVATSDR AALA202302276517Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: R2 DOOR OVERHEAD EMERGENCY LIGHT HAS ONE BULB OUT. RE-LAMPED LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01-960-801.SDR AALA202302246020Bracket · stickingAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR IS DIFFICULT TO GET INTO ARMED POSITION. ADJUSTED GIRT BAR SUPPORT BRACKETS AS REQUIRED.
Back to Boeing 737-823