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 AALA201809265012Floorbeam · crackedFLOORBEAM ANGLE CRACKED AT BS 540, RBL 2. REPLACED THE FLOORBEAM ANGLE IAW SRM 51-10-02-0G.SDR AALA201809265006Angle · corrodedCORROSION WAS FOUND ON THE ZEE ANGLE AT LBL 33 - 45, BS 993. REPLACED THE ANGLE IAW 51-00-05.SDR AALA201809265005Angle · corrodedCORROSION WAS FOUND ON ZEE ANGLE AT BS 993, RBL 33 - 45. REPLACED THE ANGLE IAW 51-00-05 .SDR AALA201809265004Angle · corrodedRIGHT CREASE ANGLE HAD CORROSION, RBL 52, BS 890 TO 1016. REPLACED THE ANGLE IAW 51-00-05-1, DRAWINGS 147A8540, AND 147A5700.SDR AALA201809265013Floorbeam · crackedCRACKED FLOORBEAM ANGLE AT BS 540, BL 0 TO LBL 2, WATERLINE 0 TO -2. REPLACED FLOORBEAM ANGLE IAW SRM 51-10-02-0G.SDR AALA201809265003Floorbeam · corrodedCORROSION ON THE TOP OF THE FLOORBEAM TEE NEAR THE LAVATORY MOUNTS AND FASTENER HOLES AT BS 947.5, LBL 52 TO RBL 52. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5.SDR AALA201809265002Web · corrodedCORROSION FOUND ON THE WEB BETWEEN BS 967 TO 986, LBL 52. REPLACED THE WEB IAW 51-00-05-1, DRAWING 147A8501, AND EA 285077, DRAFT 2.SDR AALA201809265001Web · corrodedCORROSION FOUND ON THE WEB BETWEEN BS 967 TO 986, RBL 52. REPLACED THE WEB IAW 51-00-05-1, DRAWING 147A5710, AND EA 285077.SDR AALA201809254005Floorbeam · corrodedCORROSION WAS FOUND ON THE TOP OF TEE CAP ON THE FLOORBEAM AT BS 986, LBL 52 - RBL 52. REPLACED THE FLOORBEAM TEE IAW SRM 53-70-51-2R.SDR AALA201809254002Web · corrodedCORROSION WAS FOUND ON FLOOR WEB AT BS 986 - 1016 , RBL 32 - 50. REPLACED THE WEB IAW 51-00-05.SDR AALA201810121003Angle · corrodedCORROSION FOUND ON THE CREASE ANGLE BETWEEN BS 992 AND 947, LBL 50. REPLACED THE ANGLE IAW SRM 53-00-05-1, AND DRAWING 147A8501.SDR AALA201810098002Angle · corrodedCORROSION ON THE R1 DOOR CREASE ANGLE BETWEEN BS 296 AND 330, RBL 51. REPLACED THE ANGLE IAW SRM 51-40-02, SRM 51-40-03, DRAWING 141A8310, AND 51-00-5-1.SDR AALA201809275010Transition Panel · corrodedCORROSION FOUND ON THE LEFT TRANSITION PANEL AT STATIONS 453-480 IN THE FWD CARGO BAY. REPLACED THE TRANSITION PANEL IAW SRM 51-10-2, PAR.9, AND SRM 53-00-53-2R.SDR AALA201809265011Transition Panel · corrodedFORWARD CARGO, RIGHT TRANSITION PANEL, BS 500A - 500I HAD MANY AREAS OF CORROSION. REPLACED THE TRANSITION PANEL IAW SRM 51-10-2 PAR 9, AND SRM 53-00-53-2R.SDR AALA2018092549040Spring · out of positionL1 DOOR GUST LOCK WOULD NOT STAY LATCHED. MAINTENANCE FOUND THE SPRING OUT OF PLACE AND REPOSITIONED THE SPRING, OPERATED DOOR.SDR AALA201810086008Scuff Plate · corrodedCORROSION AROUND AFT CARGO DOOR CUTOUT LOWER CORNER SCUFF PLATE BETWEEN BS 788 TO 809, STRINGER 22R TO STRINGER 26R. INSTALLED A REPAIR DOUBLER IAW EA 285202.SDR AALA201809259013Connector · disconnectedL1 DOOR EMERGENCY LIGHTS WERE INOPERATIVE. FOUND THE CONNECTOR WAS DISCONNECTED, REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA201809254007Splice Angle · corrodedCORROSION FOUND ON THE FLOORBEAM SPLICE ANGLE AT BS 887, BETWEEN RBL 20 TO LBL 20, AFT CARGO AREA. REPLACED THE FLOORBEAM SPLICE ANGLE IAW SRM 51-10-02.SDR AALA201809241002Floor Support · crackedCABIN RT, CENTER, INBOARD BS 540 FLOOR SUPPORT WAS FOUND CRACKED. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA201809263002Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO, RIGHT TRANSITION PANEL, BS 847 TO 867. REPLACED THE TRANSITION PANEL IAW SRM 51-10-02, 51-00-05, AND DRAWING 146A8127.SDR AALA201809241003Floor Support · crackedTHE CABIN FLOOR SUPPORT WAS FOUND CRACKED BETWEEN BS 328 - 344, LBL 45. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND PRINT 141A5400.SDR AALA20180921001Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED RIGHT HAND OUTBOARD CENTER FLOORBOARD SUPPORT AT STA 540. REPLACED RIGHT HAND OUTBOARD CENTER FLOORBOARD SUPPORT (INTERCOSTAL) PER 51-00-05-1.SDR AALA201809239001Connector · unsecureLAS FLT 168 EN-ROUTE ORD - LAS. THE AIRCRAFT WAS NOT GROUNDED. LIGHT ELECTRICAL BURNING ODOR NOTED BY CREW AND PAX IN AREA OF ROW 10 A & B, DISSIPATED WHEN LIGHTS WERE TURNED OFF. THE FLIGHT CONTINUED TO LAS AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCSDR AALA201809210005Trunnion · corrodedCORROSION ON THE RIGHT MAIN LANDING GEAR FORWARD TRUNNION FITTING ON THE WING LOWER OUTBOARD HOLE BORE. REPLACED THE TRUNNION FITTING IAW 51-00-05.SDR AALA201809210004Sidewall Support · corrodedCORROSION ON THE FORWARD CARGO BAY LEFT FLOOR TO SIDEWALL SUPPORT, BS 500D - 500I, LBL 21. REPAIRED THE SIDEWALL SUPPORT IAW 51-40-02-0G, AND SRM 53-00-53-2R.SDR AALA20180925014Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO RT TRANSITION ANGLE HAS CORROSION LOCATED BETWEEN STA 727G -767. REPLACED TRANSITION ANGLE AND SPLICE PER 51-00-05-1, DRAWING 146A7502 AND SRM 53-00-53-2R-5.SDR AALA201809259004Battery Pack · inoperativeEMERGENCY EXIT OVERHEAD AILSE LIGHT WAS INOPERATIVE ABOVE SEAT ROWS 18 ABC AND 21 ABC. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1670, OPS CHECKED NORMAL IAW AMM 33-51-06.SDR AALA201809210008Transition Panel · corrodedCORRODED ON THE RIGHT TRANSITION PANEL IN THE AFT CARGO BETWEEN BS 867 TO 887. REPLACED THE TRANSITION PANEL IAW SRM 21-10-02, AND SRM 51-40-02.SDR AALA201809209025Connector · not seatedDURING CHECK, THE EMERGENCY LIGHT ON SEATS 26ABC -33ABC WERE INOPERATIVE. THE AIRCRAFT WAS GROUNDED. SEATED THE CONNECTOR D10744 ON THE BATTERY PACK M1672 AND PERFORMED A SUCCESSFUL OPS CHECK IAW AMM 33-51-06.SDR AALA201809209014Connector · damagedDURING CHECK. THE R2 DOOR SLIDE LIGHT WAS INOPERATIVE. PINNED THE D10744 CONNECTOR, PIN 11 IAW WDM 33-51-14, AND SEATED THE AISLE LIGHT CONNECTOR IAW SWPM 28-60-06. OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA201809209013Connector · looseDURING HEAVY CHECK, THE EMERGENCY EXIT SIGN. LEFT OVERWING, CONNECTOR WAS LOOSE. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED THE CONNECTOR IAW WPM 20-61-28, AND OPS CHECKED GOOD IAW AMM 33-51-00-710-801.SDR AALA201809219011Battery · dischargedL1 DOOR OUTBOARD JUMP SEAT EMERGENCY FLASHLIGHT LOW ON POWER. REPLACED THE BATTERY IAW AMM 25-64-00, OPS CHECKED OK. OK FOR SERVICE.SDR AALA201809209011Unknown · odorDURING CLIMBOUT, FLIGHT ATTENDANTS NOTED A BURNING ODOR AND HAZE IN THE CABIN AROUND EMERGENCY EXIT ROW 16. IN THE COCKPIT, SMELLED LIKE A CANDLE WICK. RAN SMOKE, FIRE OR FUMES CHECKLIST. COULD NOT FIND AN IDENTIFIABLE SOURCE. RETURNED TO DEPARTURE. THE SDR AALA2018092019004Strap · corrodedCORROSION ON AFT CARGO DOOR SILL STRAP BETWEEN BS 790 AND 797. REPLACED THE STRAP IAW 51-00-05, SRM 51-10-02, AND DRAWING 146A8128.SDR AALA2018092089014Line · leakingDURING FLIGHT, LOSS OF HYDRAULIC SYSTEM A. WORKED THRU QRH. SYSTEM FAILURE BUT HAD NO LOW PRESSURE INDICATIONS. DIVERTED. AN EMERGENCY WAS DECLARED, AND LANDED WITHOUT INCIDENT. REMOVED FROM SERVICE. REPLACED TWO AFT BRAKE PRESSURE LINES ABOVE THESDR AALA201809219010Coffeemaker · odorNR 2 COFFEEMAKER, WHEN TURNED ON CREATED A BAD ELECTRICAL ODOR. REPLACED THE NR 2 COFFEEMAKER IAW AMM 25-32-00. OPS CHECKED OK FOR SERVICE.SDR AALA201809209047Connector · damagedBOTH EMERGENCY LIGHTS WERE INOPERATIVE ON SEAT 13D. THE AIRCRAFT WAS GROUNDED. MAINTENANCE PINNED THE CONNECTOR AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00SDR AALA20180918003Hydraulic Line · rupturedAIRCRAFT WAS GROUNDED. PHL-TPA DIVERTED CLT ACCOUNT HYDRAULIC SYSTEM-A LOSS ENROUTE. EMERGENCY WAS DECLARED AND AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. HYDRAULIC SYSTEM A FAILED IN FLIGHT, ALTERNATE LANDING GEAR EXTENSION USED. FOUND LEFT ELEVATOR PCA OUTBOASDR AALA20180917001Intercostal · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION WAS FOUND ON CABIN SUBFLOOR (INTERCOSTAL) AT STA 947-967, RBL 48-50. REPLACED INTERCOSTAL PER SRM 51-10-02, SRM 51-40-02.SDR AALA201809187004Floorbeam · corrodedCORROSION ON THE RIGHT FLOORBEAM, BS 947, BETWEEN LBL 38 TO LBL 50. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5.SDR AALA20180918002Battery Pack · no testEPL ON ROWS 16-20 WILL NOT STAY ON FOR THE TEST IAW CARD 2908. REPLACED THE BATTERY PACK IAW AMM 33-51-06. PROXIMITY LIGHTS FOR ROWS 16-20 TEST GOOD.SDR AALA201809186002Skin · corrodedCORROSION ON FUSELAGE SKIN INBOARD OF LEFT RAM AIR BETWEEN BS 500I & 520, STRINGER 22L - 23L. REPLACED THE SKIN IAW EA #283713.SDR AALA2018091989025Spring · faultyFOWARD ENTRY DOOR GUST LOCK WILL NOT LOCK DOWN WHEN UNLOCKING IT. MAINTENANCE ADJUSTED SPRING ON THE GUST LOCK, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018091184013Skin · corrodedCORROSION ON THE LEFT WING LOWER SKIN AT WS 540, STRINGER 22. REPLACED SKIN IAW SRM 51-10-02 AND EA 284449.SDR AALA201809184010Web · corrodedCORROSION FOUND ON THE FLOOR WEB, BS 988, LBL 33. REPAIRED THE WEB IAW EA 284374, DRAFT 1.SDR AALA2018091869002Battery Pack · failedBATTERY PACK M1673 FAILED A FUNCTIONAL CHECK IAW CARD 2908. REPLACED THE BATTERY PACK. OPS CHECKED OK.SDR AALA2018100128009Floor Support · corrodedCORROSION FOUND ON THE AFT CABIN FLOOR SUPPORT, BS 947 - 967, RBL 50. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA201809179011Battery Pack · no testBATTERY PACK M1695 FAILED A FUNCTIONAL CHECK IAW CARD 2908. REPLACED THE BATTERY PACK IAW MM 33-51-06. OPS CHECKED OK.SDR AALA201809179009Battery Pack · no testBATTERY PACK M1694 FAILED A FUNCTIONAL CHECK IAW CARD 2908. REPLACED THE BATTERY PACK. OPS CHECKED OK.SDR AALA201809179006Battery Pack · no testBATTERY PACK M1674 FAILED A FUNCTION CHECK IAW CARD 2908. REPLACED THE BATTERY PACK IAW MM 33-51-06. OPS CHECKED OK.
Back to Boeing 737-823