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 AALA20181121003Panel · corrodedCORROSION FOUND ON PANEL LOCATED BETWEEN STA 460 -500I. REPLACED PANEL.SDR AALA20181121001Floorbeam · crackedFLOORBEAMFOUND CRACKED AT BS 540, AND FROM RBL 0-20. REPLACED THE FLOORBEAM ANGLE.SDR AALA201811219013Sign · missingFLIGHT ATTENDANT ADVISED EXIT SIGN MISSING ON ROW 15 ABC. CHANGED L1189 LEFT HAND AFT EMERGENCY LIGHT EXIT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201811210003Floorbeam · crackedAFT END OF FORWARD CARGO CABIN FLOORBEAM FOUND CRACKED BS 537.45, BL 0 - LBL 24, AT EXPANSION JOINT. REPAIRED THE FLOORBEAM IAW RD 51-00-05-1.SDR AALA201811219008Slide · defectiveL1 DOOR SLIDE IS EXTENDING OUT OF THE SLIDE COMPARTMENT. REPLACED LOOSE FASTENER IN L1 ESCAPE SLIDE COVER PER SRM 52-10-02. INSTALLED L1 ESCAPE SLIDE ASSEMBLY IAW CARD 25-94-10.SDR AALA201811219005Smoke Detector · malfunctionedFORWARD LAVATORY SMOKE DETECTOR WENT OFF. LAVATORY HAD NO SMOKE WHEN CHECKED BY MAINTENANCE OBSERVERS. REPLACED FORWARD LAVATORY SMOKE DETECTOR IAW AMM 25-40-11. OPS CHECKED GOOD.SDR AALA201811219001Access Panel · missingAIRCRAFT ARRIVED AT GATE WITH THE LAV ACCESS PANEL DOOR MISSING AND THE LAV FLAPPER VALVE HANGING OPEN. CLOSED FLAPPER VALVE AND INSTALLED NEW ACCES PANEL DOOR IAW AMM 52-49-07.SDR AALA201811209014Pressure Switch · faultyDURING CRUISE, WITH THE NR 1 INTEGRATED DRIVE GENERATOR ON MEL, LOW OIL PRESSURE LIGHT ILLUMINATED WITH AN APU AUTO SHUTDOWN, LEAVING TWO A/C ELECTRICAL SOURCES INOPERATIVE. DECLARED AN EMERGENCY AND DIVERTED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUSDR AALA201811209001Battery · no testDURING A PREFLIGHT, THE L1 FLASHLIGHT WAS FOUND INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD, OK FOR SERVICE.SDR AALA2018112018007Floor Support · crackedCABIN FLOOR SUPPORT BS 285, RBL 1, WAS CRACKED. REPLACED THE FLOOR SUPPORT IAW DWG 141A5400, AND RD 51-00-05.SDR AALA201811209017Flashlight · inoperativeFORWARD RIGHT CABIN ATTENDANT EMERGENCY FLASHLIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE FLASHLIGHT IAW MM 25-64-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811197012Floor Support · crackedA CRACK INDICATION WAS FOUND ON THE FLOOR SUPPORT, BS 328 - 344, LBL 45. REPLACED THE FLOOR SUPPORT IAW DRAWING 141A5400, AND RD 51-00-05-1.SDR AALA201811197011Floor Support · crackedA CRACK INDICATION WAS FOUND ON THE FLOOR SUPPORT, BS 312 - 328, LBL 45. REPLACED THE FLOOR SUPPORT IAW DRAWING 141A5400, AND RD 51-00-05-1.SDR AALA201811197009Floor Support · crackedCRACK INDICATION FOUND ON THE FLOOR SUPPORT BETWEEN BS 312-328, RBL 31-32. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1,PRINT 141A5410, AND DRAWING 141A5400.SDR AALA201811197008Floor Support · crackedA CRACK INDICATION WAS FOUND ON THE FLOOR SUPPORT BETWEEN BS 328 - 344, LBL 45. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1, AND PRINT 141A5410, AND DRAWING 141A5400.SDR AALA201811197005Floor Support · crackedCRACK INDICATION FOUND ON THE FLOOR SUPPORT BETWEEN BS 312 - 328, LBL 45. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1, PRINT 141A5410S, AND DRAWING 141A540.SDR AALA201811216003Strap · corrodedCORROSION FOUND ON THE RIGHT HALF MOON PANEL, OUTBOARD STRAP. REPLACED STRAP IAW RD 51-00-05-1, AND DRAWING 147A5700.SDR AALA201811209013Smoke Detector · false activationTHE AFT LAVATORY SMOKE DETECTOR WENT OFF MULTIPLE TIMES WITH NO ASSOCIATED SMOKE OR FIRE. PERFORMED LAVATORY SMOKE DETECTION TEST. OPS CHECKED NORMAL IAW AMM 26-14-00.SDR AALA201811196004Web · corrodedCORROSION FOUND ON THE RIGHT WEB AND SUPPORT CHANNEL AT BS 986.5 - 1016. REPLACED THE WEB AND SUPPORT CHANNEL IAW SRM 51-40-02, AND DRAWING 147A5712.SDR AALA201811196002Angle · corrodedCORROSION FOUND ON THE RIGHT ZEE ANGLE AT BS 992, RBL 33-48. REPLACED THE ANGLE IAW 51-00-05-1, DRAWING 147A5700, AND SRM 51-40-02.SDR AALA201811196001Angle · corrodedCORROSION FOUND ON THE RIGHT ZEE ANGLE, BETWEEN AT BS 922 - 1015, RBL 32. REPLACED Z ANGLE PER AARD 51-00-05-1, BOEING DRAWING 147A5700 AND SRM 51-40-02.SDR AALA2018111205008Floorbeam · crackedFLOORBEAM LOWER ANGLE WAS FOUND CRACKED AT BS 663 AND LBL 45.5. REPAIRED THE FLOORBEAM LOWER ANGLE IAW EA 286846.SDR AALA201811189004Control Unit · faultyATL FLT 1308 EN-ROUTE ORD - MIA. THE AIRCRAFT WAS GROUNDED. AFT CARGO FIRE LITE ILLUMINATED IN FLIGHT. DISCHARGED BOTTLE PER CHECKLIST. THE FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO ATL WITHOUT FURTHER INCIDENT. AIRPORT INSPECTION SHOWED NO SIGNS OF FIRE SSDR AALA201811189003Smoke Detector · faultyATL FLT 1308 EN-ROUTE ORD - MIA. THE AIRCRAFT WAS GROUNDED. AFT CARGO FIRE LITE ILLUMINATED IN FLIGHT. DISCHARGED BOTTLE PER CHECKLIST. THE FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO ATL WITHOUT FURTHER INCIDENT. AIRPORT INSPECTION SHOWED NO SIGNS OF FIRE SOSDR AALA20181115003Smoke Detector · faultyATL FLT 1308 EN-ROUTE ORD - MIA. THE AIRCRAFT WAS GROUNDED. AFT CARGO FIRE LITE ILLUMINATED IN FLIGHT. DISCHARGED BOTTLE PER CHECKLIST. THE FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO ATL WITHOUT FURTHER INCIDENT. AIRPORT INSPECTION SHOWED NO SIGNS OF FIRE SOSDR AALA201811154003Angle · corrodedCORROSION ON MAIN CABIN RIGHT CREASE ANGLE BETWEEN BS 947 AND BS 987. REPLACED CREASE ANGLE IAW RD 51-00-05, AND SRM 51-40-02.SDR AALA201811154002Floorbeam · corrodedCORROSION ON MAIN CABIN FLOORBEAM, BS 986 BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R , SRM 51-40-02, AND RD 51-00-05-1.SDR AALA201811154001Web · corrodedCORROSION ON THE AFT CARGO BAY WEB AT BS 727 AND BL 0. REPLACED THE WEB IAW SRM 51-10-02, AND RD 51-00-05-1.SDR AALA2018111659022Sensor · faultyLEADING EDGE FLAPS TRANSIT LIGHT CAME ON AT 26000. SLOWED ACFT DOWN TO 230 KTS, EXTENDED FLAPS IAW QRH AND BACK UP LIGHT STILL ON. RETURNED TO DEPARTURE. EMERGENCY WAS DELCARED, LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED S173 LEADING SDR AALA201811165001Proximity Sensor · faultyLEADING EDGE FLAPS TRANSIT LIGHT CAME ON AT 26000. SLOWED ACFT DOWN TO 230 KTS, EXTENDED FLAPS IAW QRH AND BACK UP LIGHT STILL ON. RETURNED TO DEPARTURE. EMERGENCY WAS DELCARED, LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED S173 LEADING SDR AALA201811153005Support Angle · corrodedCORROSION ON THE FORWARD CARGO BAY AFT BULKHEAD LOWER ANGLE AT BS 500I BETWEEN STRINGERS 25L AND STR 25R. REPLACED THE SUPPORT ANGLE.SDR AALA201811159001Battery · dischargedAIRCRAFT WAS NOT GROUNDED. L1 DOOR AND FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERIES ARE DEAD. CHANGED BATTERIES IN BOTH EMERGENCY FLASHLIGHTS FOR L1 ATTENDANT STATION PER AMM 25-64-00.SDR AALA201811139033Bulkhead Web · crackedCRACK FOUND ON THE PRESSURE BULKHEAD AT BS 663, BETWEEN LBL 31.83 AND LBL 40. REPAIRED THE BULKHEAD IAW SRM 57-10-10-2R-3, AND EA 287013.SDR AALA201811149004Battery Pack · no testLEFT OVERWING EXIT BATTERY PACK FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA201811132004Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON THE AFT CARGO DOOR CUT OUT THRESHOLD WEB BETWEEN BS 787 AND 847, RBL 28. REPLACED THE THRESHOLD WEB.SDR AALA201811132003Angle · corrodedLEFT CABIN CREASE ANGLE HAD CORROSION FROM BS 986 - 947. REPLACED THE CREASE ANGLE IAW RD 51-00-05-1, AND DWG 147A8540.SDR AALA201811149022Megaphone · inoperativeTUL - THE AIRCRAFT WAS NOT GROUNDED. MEGAPHONE IN F/C DOESN’T WORK. MAINTENANCE REMOVED AND REPLACED F/C MEGAPHONE IAW AMM 25-64-00.SDR AALA201811139016Trim Motor · faultyTHE AIRCRAFT WAS GROUNDED. DURING DESCENT, THE STAB OUT OF TRIM LIGHT ILLUMINATED. PERFORMED THE QRH PROCEDURE. AUTO PILOT TRIM INOPERATIVE. MAIN ELECTRIC TRIM WAS ALSO INOPERATIVE. THE FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO JFK. PERFORMED QRH PROCEDURESDR AALA201811121002Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 420 AND 500I. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM 51-10-2 PAR.9.SDR AALA2018112009002Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 727 AND 847. REPLACED THE TRANSITION PANEL IAW RD 51-00-5-1, AND SRM 53-00-53-2R-5.SDR AALA201811099008Light · brokenTHE R2 DOOR EMERGENCY EXIT LIGHT ON THE RIGHT SIDE OF DOOR IS COMPLETELY BROKEN. MAINTENANCE REMOVED AND REPLACED THE LIGHT ASSY, OPS CHECKED NORMAL IAW AMM 33-51-01.SDR AALA201811508005Floor Support · crackedCABIN FLOOR SUPPORT WAS CRACKED AT BS 291, LBL 34. REPLACED THE FLOOR SUPPORT.SDR AALA20181108003Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN INTERCOSTAL IS CRACKED AT STA 348.2-360. REPLACED INTERCOSTAL PER 51-00-05-1 AND DRAWING 141A5400.SDR AALA2018110128004Floor Support · crackedCABIN FLOOR SUPPORT WAS CRACKED AT BS 313, LBL 34. REPLACED THE FLOOR SUPPORT.SDR AALA201811098001Trim System · inoperativeAFTER TAKEOFF, THE STAB TRIM BECAME COMPLETELY INOPERATIVE, SPEED TRIM FAIL LIGHT ILLUMINATED. EMERGENCY DECLARED AND THE FLIGHT RETURNED TO DEPARTURE WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE ACCOMPLISHED A RESET OF FCC 1 AND 2 AND PSDR AALA201811087006Angle · corrodedCORROSION FOUND ON THE RIGHT ANGLE BETWEEN BS 300 AND 330. REPLACED THE ANGLE IAW RD 51-00-05-1.SDR AALA201811087005Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 492 AND 500A, RBL 25. REPLACED THE TRANSITION PANEL IAW RD 51-00-05-1, AND EA 286697.SDR AALA201811089013Hanger Assy · faultyGIRT BAR HANGER ON THE L1 DOOR WAS LOOSE AND GIRT BAR FELL OFF WHEN DOOR IS OPENED. REPLACED L1 DOOR SLIDE IAW AMM WC 25-94-10, THE GIRT BAR WAS SECURE WHEN DOOR OPEN. OP CHECKED NORMAL.SDR AALA201811076015Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 727 AND 767, RBL 26. REPLACED THE TRANSITION PANEL IAW SRM 51-40-02, RD 51-00-05-01, AND EA 286656.SDR AALA201811076014Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 500A AND 500I, RBL 25. REPLACED THE TRANSITION PANEL IAW SRM 51-40-02 AND 51-00-05-01.
Back to Boeing 737-823