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 AALA201912129020Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER INNER RIB AT LOWER END OF 3RD STIFFENER FORWARD OF STATION 92.70. REPLACED RIB PER AARD 55-00-05-1.SDR AALA201912129019Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER INNER RIB AT LOWER END OF 3RD STIFFENER FORWARD OF STATION 92.70. REPLACED RIB PER AARD 55-00-05-1.SDR AALA201912119010Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FORWARD JUMPSEAT ONBOARD POSITION WOULD NOT TEST. MAINTENANCE REPLACED FLASHLIGHT PER STANDARD PRACTICES.SDR AALA2019121639021Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BAFFLE IN THE FORWARD CARGO COMPARTMENT BETWEEN BS 500F AND BS 500G AT S28R. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA2019121219012Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ON FLIGHT ATTENDANT JUMPSEAT INOPERABLE. MAINTENANCE REPLACED EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA2019121209024Window · burnedAIRCRAFT WAS GROUNDED: FIRST OFFICERS SIDE WINDOW JUST OUTSIDE OPEN HANDLE DEVELOPED BLACK BURN MARK IN FLIGHT. REPLACED WINDOW PER TASK CARD 56-94-02.SDR AALA201912119011Battery · dischargedAIRCRAFT WAS NOT GROUNDED: L1 DOOR INBOARD JUMP SEAT FLASHLIGHT LOW ON POWER. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA2019121109020Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 ESCAPE SLIDE PACK BOTTLE PRESSURE LOW. MAINTENANCE REPLACED ESCAPE SLIDE PACK PER AMM 25-66-01.SDR AALA2019121109019Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT AFT SEATS FLASHLIGHT FAILED TEST. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA201912109022Pin · shearedAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS FWD CABIN DOOR L1 HARD TO OPEN AGENT NOTED EXT. DOOR HANDLE AT 90 DEG. TO NORMAL (NON FLUSH). MAINTENANCE FOUND BOLT HOLDING GUST LOCK TO DOOR HINGE SHEARED OFF AT BOTTOM OF DOOR HINGE ARM. REMOVED AND REPLACED BROKESDR AALA201912109021Proximity Sensor · faultyAIRCRAFT WAS GROUNDED: PILOT REPROTS IN CLIMB @ FL 250, AMBER L.E. IN TRANSIT LIGHT ILLUMINATED INTERMITTANTLY. DID QRH PROCEDURES UPON APPROACH TO MIA WITH FLAPS EXT. LIGHT CONTINUED TO FLASH EVEN W/ 15 FLAPS. MAINTENANCE FOUND SL6 PROX OUTBOARD MSG 27-81210SDR AALA201912099033Warning Light · false activationAIRCRAFT NOT GROUNDED: AFTER TAKEOFF ON GEAR RETRACTION THE RED LEFT GEAR LIGHT REMAINED ILLUMINATED. AFTER EXTENDING AND RETRACTING THE GEAR ALL INDICATIONS WERE NORMAL.ACCOMPLISHED PSEU BITE NO FAULTS LOGGED. ACCOMPLISHED GVI OF MAIN LANDING GEAR WIRING, NOSDR AALA201912099042Warning Light · false activationAIRCRAFT NOT GROUNDED: AUTOBRAKE DISARM LIGHT ILLUMINATED AT TOUCHDOWN WITHOUT BRAKE ACTIVATION. RESET POWER. OPS CHECKS GOOD IAW AMM 32-42-00.SDR AALA2019121329061Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AFT SIDE OF FRAME AT BS 500G AND S23R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2019121329060Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP FORWARD SIDE OF FRAME AT BS 500G AND S23R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2019121099040Wire Harness · exposedAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS MULTIPLE WIRE BUNDLES IN CENTER PEDESTAL HAVE EXPOSED WIRES AND SHEATHING DISINTERGRATED. MAINTENANCE REPAIRED SHEATHING ON WIRING HARNESS.SDR AALA2019121329062Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP FORWARD SIDE OF FRAME AT BS 500D AND S23R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA201912099003Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS ON T/O ROLL THE AUTO THROTTLES TURNED OFF TWICE AND WE COULD NOT ENGAGE V NAV AT 1000FT. TRIED THE AUTOTHTOTTLES AGAIN AT 1500 FT AND THEY STAYED ON AND VNAV WORKED OK. AUTO THROTTLES QUIT AGAIN AND VNAV QUIT AT 3000FT IN DSDR AALA201912099012Light · missingAIRCRAFT WAS NOT GROUNDED: EXIT MARKER LIGHT AT L1 DOOR MISSING. MAINTENANCE REPLACED EXIT SIGN LIGHT PER AMM 33-51-01.SDR AALA201912099053Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER LOWER SKIN AT STATION 101.90. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA201912099034Window · delaminatedAIRCRAFT WAS GROUNDED: FLIGHT DECK R1 WINDOW DELAMINATED AND DISCOLORED. REPLACED WINDOW PER TASK CARD 56-94-04.SDR AALA2019120969035Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER RIB VERTICAL STIFFENER AT STATION 101.90. REPLACED RIB PER SRM 51-40-02.SDR AALA201912099010Oven · smokeAIRCRAFT NOT GROUNDED: FORWARD GALLEY OVEN NO.2 SMOKES WHEN TURNED ON. REMOVED AND REPLACED FWD GALLEY #2 OVEN IAW AMM 25-32-03. OPS CHECKED GOOD.SDR AALA2019121329059Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP FORWARD SIDE OF FRAME AT BS 500F AND S23R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2019121329058Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP FORWARD SIDE OF FRAME AT BS 500E AND S23R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA201912109002Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BAFFLE ATTACHMENT CLIP AT BS 500H AND LBL 24. REPLACED CLIP PER SRM 51-10-02.SDR AALA201912069002Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN LEFT HAND FLIGHT ATTENDANT SEAT FLASHLIGHT WOULD NOT TEST. MAINTENANCE REPLACED FLASHLIGHT ASSEMBLY PER AMM 25-64-00.SDR AALA2019121329051Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR EXPANSION JOINT AT BS 540 AND RBL 10. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA2019121329050Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR EXPANSION JOINT AT BS 540 AND LBL 10. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA2019120959013Pump · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS THROTTLE SPLIT ON TAKE OFF DURING CLIMB SPLIT BECAME 3 KNOBS , LT THROTTLE ALMOST AT STOP AT 10,000FT THROTTLES EVENED OUT, NORMAL OPS AFTER THAT. MAINTENANCE REPORTS #1 ENG FUEL PUMP REPLACED IAW AMM 73-11-01 AND JOB 73-94SDR AALA201912069018Warning Message · illuminatedAIRCRAFT NOT GROUNDED: PILOT REPORTS AFTER T.O. WITH TCAS RA WARNING, CA AND FO ND (INBOARD) BLANKED FOR APPROX. 2 MIN AS WELL AS LOWER DU BLANKED. TRANSPONDER TO XPNDER RESET DUS. MAINTENANCE ACCOMPLISHED DEU BITE IAW FIM 31-62-00-810-809, OK FOR SVC IAW FIM SDR AALA2019120659033Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TIE DOWN MOUNT CLIP AT BS 312 AND LBL 60. REPLACED TIE DOWN MOUNT CLIP PER SRM 51-40-02.SDR AALA2019120659028Strap · wornAIRCRAFT IN BASE MAINTENANCE: GROUND AIR DOOR TO FUSELAGE LATCH STRIKER PLATE STRAP PREVIOUS REPAIR WORN THROUGH AT BS 542 AND RBL 40. REPAIRED STRAP PER SRM 57-10-13-2R-3 REPAIR 3.SDR AALA2019120659026Floor Support · out of alignmentAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL TO FLOOR BEAM MOUNTING HOLES ARE MISALLGNED AFTER REPAIR OF FLOOR BEAM "T" CAP BETWEEN BS 947 AND BS 967 AT RBL 52 . REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019120659025Floorbeam · misrepairedAIRCRAFT IN BASE MAINTENANCE: FLOOR BEAM "T" CAP HAD COUNTER SUNK HOLE UNDER THE LAVATORY MOUNT AT BS 947 AND RBL 52. REPAIRED FLOOR BEAM "T" CAP PER EA 301009.SDR AALA2019120659008Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN IN R1 GALLEY WAS MISSING COVER. MAINTENANCE REPLACED EXIT SIGN COVER PER STANDARD PRACTICES.SDR AALA201912059010Warning Message · false activationAIRCRAFT NOT GROUNDED: AT APPROX 10000 FEET GOT LANDING GEAR WARNING NOT DOWN AND LOCKED WITH RED LIGHTS, LASTED 10 SECONDS. ACCOMPLSHED PSEU BITE IAW FIM 32-61-00-3 NO FAULTS NOTED; ALSO LRRA SYST. TEST ACCOMPLISHED IAW AMM 34-33-00 OPS CHECK GOOD.SDR AALA201912059001Gust Lock · lack of lubeAIRCRAFT NOT GROUNDED: FRONT ENTRANCE DOOR 1L GUST LOCK HARD TO OPERATE. LUBRICATED L1 GUST LOCK ASSY IAW STANDARD PRACTICES. OPS CK NORMAL.SDR AALA201912129017Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOORBEAM UPPER "T" CAP AT BS 947 AND RBL 52. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5. SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NOT LEVEL 2. SECTISDR AALA2019120659012Engine · slowAIRCRAFT WAS GROUNDED: PILOT REPORTS FROM SHORTLY AFTER T/O UNTIL 18,000 LEFT ENGINE COMMANDED THRUST WAS 2-3% BELOW N1 COMMANDED THRUST SECTOR. GAP SLOWLY DECREASED UNTIL ALL NORMAL AT 18,000 FT. MAINTENANCE PERFORMED ENGINE ACCELERATION CHECK IAW AMM 71-00-0SDR AALA2019120549001Warning Message · illuminatedAIRCRAFT WAS GROUNDED: PILOT REPORTS CAB ALT WARNING ILLUMINATED AND SOUNDED AS AIRCRAFT PASSED 12,000. LEVELED AT 13,000 THEN DECENDED TO 10,000. CAB ALT WARNING EXTINGUISHED AT @ 8,500 AIRCRAFT ALT. AIRCRAFT FELT A LITTLE GENTLE BUFFETING THROUGHOUT FLIGHT.SDR AALA201912049011Warning Message · false activationAIRCRAFT NOT GROUNDED: ERRONEOUS TAKEOFF CONFIG WARNING JUST BEFORE V1 ON TAKEOFF MOMENTARY. PSEU FAULTS MSG 31-53007. PERFORMED FIM TASK 27-62-00. NO FAULTS.SDR AALA201912049007Handle · stiffAIRCRAFT NOT GROUNDED: CABIN DOOR HANDLE 1L DIFFICULT TO OPERATE ON ARRIVAL INTO GATE AT DFW AGENT SAID THE OUTSIDE DOOR HANDLE WAS NOT FLUSH. PERFORMED INNER AND OUTER DOOR HANDLE OPERATIONAL CKS IAW MM 52-11-00, NORMAL.SDR AALA201912053908Filter · cloggedAIRCRAFT WAS GROUNDED: PILOT REPORTS RIGHT ENGINE INDICATED LOW OIL PRESSURE AND QUANTITY. ENGINE SHUT DOWN IAW QRH. OIL QTY READ 0 AND OIL PRESSURE WAS IN RED BAND. LOW PRESSURE LIGHT WAS INTERMITTENT. MAINTENANCE PERFORMED POWER ASSURANCE CHECK- CHECKED OK, SDR AALA2019120549031Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR INTERCOSTAL HAS OVERSIZED FASTENER HOLES BETWEEN BS 947 AND BS 967 AT RBL 52. REPLACED INTERCOSTAL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA201912139013Warning Message · false activationAIRCRAFT NOT GROUNDED: REJECTED @ APPROX. 75KIAS DUE TO LOW PRESS. LITE ILLUMINATED ON #1 FUEL TANK FWD. PUMP. ACCOMPLISHED OPS. CK. OF FUEL PUMP (LEFT FWD) PUMP OPS CKS. NORM. PRESSURE IND. NORM PER. FIM 28-22-00. ACCOMPLISHED MCM. 05-51-07 HIGH ENERGY STOP. SDR AALA2019120439011Power Port · failedAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS ELECTRICAL ODOR COMING FROM SEAT ROWS 18-22. MAINTENANCE REMOVED AND REPLACED 21ABC SPB IAW AMM 44-22-44. POWERPORTS OPS CHECK NORMAL.SDR AALA2019120329012Unknown · odorAIRCRAFT WAS GROUNDED: RETURN BACK TO IAH AFTER TAKE OFF, REPORT STRONG FUEL SMELL AFT. GALLEY. EMERGENCY WAS DECLARED. MAINTENANCE FOUND EVIDENCE OF A BIRDSTRIKE, ACCOMPLISHED JOB CARD 05-96-12, NO EXTERNAL DAMAGE FOUND, CLEANED FOD. ACCOMPLISHED JOB CARD 05-SDR AALA201912039007Flight Dir · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS FLT DIRECTORS BOTH CA/FO DISAPPEAR WHEN TOGA MODE/SWITCH PRESSED FOR TAKEOFF. COME BACK ON AT 1000 FEET. MAINTENANCE ACCOMPLISHED DFCS BITE FOUND MAINT MSG 22-11210. PERFORMED TASK FIM 22-14-00. FOUND NO FAULTS AT INITIAL ESDR AALA2019120219001Bearing · bindingAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS AILERONS VERY STIFF IN FLIGHT AND ON GROUND. REMOVED & REPLACED AILERON CENTERING MECHANISM CAM FOLLOWER BEARING IAW JOB CARD 1422. OK FOR SERVICE.
Back to Boeing 737-823