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 AALA202102159050Collar · missingAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON DOOR 1R IS MISSING A PLASTIC COLLAR. INSTALLED NEW COLLAR (AALA202102159028) AND PIN (AALA202102159050) ON GIRT BAR IAW AMM 25-66-01.SDR AALA202102159028Collar · missingAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON DOOR 1R IS MISSING A PLASTIC COLLAR. INSTALLED NEW COLLAR (AALA202102159028) AND PIN (AALA202102159050) ON GIRT BAR IAW AMM 25-66-01.SDR AALA202102159023Panel · out of adjustAIRCRAFT WAS NOT GROUNDED: PANEL BELOW OVERWING EXIT DOOR ROW16A IS NOT PROPERLY SET. CYCLED EMERGENCY EXIT DOOR AND REPOSITIONED PANEL 16A REF AMM 52-22-51.SDR AALA202102159014Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIELD REPORTS L2 SERVICE DOOR EXTERIOR HANDLE, FOUND TO BE IN THE NOT STOWED/FLUSH POSITION AT GATE ARRIVALS. PERFORMED L2 SERVICE DOOR LUBRICATION-COMPONENTS AND SERVICING MECHANISM IAW AMM 12-25-12-640-801/802.SDR AALA202102159021Panel · out of positionAIRCRAFT WAS NOT GROUNDED: PANEL BELOW OVERWING EXIT DOOR ROW 17F IS NOT PROPERLY SET. CYCLED OVERWING EXIT DOOR AND REPOSITIONED PANEL IAW AMM 52-22-51.SDR AALA202102159022Panel · out of positionAIRCRAFT WAS NOT GROUNDED: PANEL BELOW OVERWING EXIT DOOR ROW 16A IS NOT PROPERLY SET. CYCLED OVERWING EXIT DOOR AND RE POSITIONED PANEL.SDR AALA202102169015Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS INOPERATIVE NEAR OVERWING EXITS. REPLACED FUSE WITH NEW AT POWER SUPPLY M1695 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202102159017Panel · unsecureAIRCRAFT WAS GROUNDED: FORWARD LEFT EMERGENY EXIT KICK PANEL IS DOWN. OPENED EMERGENCY EXIT DOOR, RAISED PANEL. CLOSED AND SECURED DOOR PER AMM 52-22-00.SDR AALA202102159018Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR LOWER RH ATTACHMENTS LOOSE. ADJUSTED GIRT BAR J CLIPS AT L1 DOOR IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202102159015Slide · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE BOTTOM RUBBER PROTECTIVE COVER WORN THROUGH IN SEVERAL PLACES. REPLACED R1 DOOR SLIDE WITH SERVICEABLE UNIT IAW B737NG AMM 25-66-01.SDR AALA202102189017Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FUSELAGE SKIN FROM CONTACT WITH APU DOOR HINGE ARMS BETWEEN STA 1101 AND STA 1149 AT STR 20R, MEASURING L=0.5 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 53-80-01-2R-1.SDR AALA202102169014Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE AT SEATS 26-32ABC. REPLACED FUSE AT POWER SUPPLY M1672 WITH NEW IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202102129005Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND LEFT AFT EMERGENCY EXIT HATCH LIGHT INOPERATIVE. RELAMPED LEFT AFT EMERGENCY LIGHT EXIT HATCH.SDR AALA202102119009Grommet · missingAIRCRAFT WAS NOT GROUNDED: GROMMET MISSING ON THE L1 DOOR GIRT BAR. INSTALLED NEW GROMMET IAW AMM 25-61-01.SDR AALA202102159016Lamp · burned outAIRCRAFT WAS NOT GROUNDED: LEFT REAR OUTSIDE EMERGENCY LIGHT NEXT TO L2 DOOR IS OUT. RELAMPED LEFT REAR OUTSIDE EMERGENCY LIGHT NEXT TO L2 DOOR PER AMM 33-51-04.SDR AALA202102119010Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT SLIDE/OVERWING LIGHT INOPERATIVE. RELAMPED RIGHT SLIDE/OVERWING LIGHT, OPERATIONS CHECK NORMAL PER AMM 33-51-04.SDR AALA202102119008Hook · detachedAIRCRAFT WAS NOT GROUNDED: R1 SLIDE GIRT CLIP OFF. INSTALLED GIRT BAR CLIP PER AMM 25-61-01.SDR AALA202102119006Window · noisyAIRCRAFT WAS GROUNDED: AIRCRAFT RETURNED AFTER TAKE OFF DUE TO MILD RAPID BANGING SOUND ON RIGHT SIDE OF FORWARD FUSELAGE NEAR R2 WINDOW. REPLACED COCKPIT WINDOW #2 IAW CARD 08L21056002.SDR AALA202102099004Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER DETACHED AT SEAT 24C. REPLACED EMERGENCY EXIT LIGHT COVER IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202102089013Compensator · faultyAIRCRAFT WAS GROUNDED: SIGNIFICANT LEFT MAIN/WING TANK LOW FUEL IMBALANCE 5 MINUTES AFTER TAKEOFF, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD WITHOUT FURTHER INCIDENT. PERFORMED TANK AND COMPENSATOR UNIT DRY CAPACITANCE AND RESISTANCE CHECK IAW AMM 28-41-SDR AALA202102089019Slide · looseAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE HAS MATERIAL HANGING DOWN WHEN SLIDE IS ARMED. RE-TUCKED SLIDE Z-FOLD, OPS CHECK GOOD.SDR AALA202102089018Battery · inoperativeAIRCRAFT WAS GROUNDED: RIGHT AFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR AALA202102089016Cover · inoperativeAIRCRAFT WAS NOT GROUNDED: INOPERATIVE PASSENGER SEAT-MOUNTED ESCAPE PATH LIGHT AT SEAT 21C. REPLACED BULB COVER 21 ABC IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202102089017Fabric · tornAIRCRAFT IN BASE MAINTENANCE: R2 DOOR ESCAPE SLIDE GIRT BAR FABRIC APRON TORN. REMOVED AND REPLACED R2 DOOR ESCAPE SLIDE PER AMM 25-66-01SDR AALA202102089014Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FLIGHT ATTENDANT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202102089012Window · overheatedAIRCRAFT WAS GROUNDED: LEFT FORWARD WINDOW OVERHEAT LIGHT ILLUMINATED ON SHUTDOWN. ACCOMPLISHED LEFT SIDE WINDOW NUMBER 1 REMOVAL AND INSTALLATION PER JOB CARD 08L21056003.SDR AALA202102089015Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT DAMAGED BELOW SEAT 13C. SECURED ESCAPE PATH LIGHT AT 13C.SDR AALA202102089010B-Nut · looseAIRCRAFT WAS GROUNDED: AIRSPEED AND ALTITUDE UNRELIABLE IN FLIGHT, CREW DECLARED EMERGENCY AND ARRIVED AT DESTINATION WITHOUT INCIDENT. TIGHTENED B-NUT ON RH PITOT PROBE IAW AMM 34-11-01, OPS CHECK GOOD.SDR AALA202102089025Support Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FWD SUPPORT FITTING OF LH MLG TRUNNION. REPLACED FITTING WITH NEW IAW WORKCARD 32-94-24.SDR AALA202102059007Windshield · unserviceableAIRCRAFT IN BASE MAINTENANCE: L1 WINDSHIELD REQUIRES REMOVAL AND REPLACEMENT FOR HEAVY C CHECK, WORK CARD 2711. REMOVED AND REPLACED L1 WINDSHIELD PER AMM 56-11-11.SDR AALA202102049003Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT NOT ARMED 1 BULB INOPERATIVE. RELAMPED EMERGENCY EXIT "NOT ARMED" LIGHT BULB PER AMM 33-51-01.SDR AALA202102049002Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT NOT ARMED BULB INOPERATIVE. RELAMPED EMERGENCY EXIT "NOT ARMED" LIGHT BULB PER AMM 33-51-01.SDR AALA202102049001Windshield · not reportedAIRCRAFT IN BASE MAINTENANCE: R1 WINDSHIELD REQUIRES REMOVAL AND REPLACEMENT FOR HEAVY C CHECK. REMOVED AND REPLACED R1 WINDSHIELD IAW AMM 56-11-11, WORK CARD 2712.SDR AALA202102059012Pin · damagedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EMERGENCY EXIT SIGN L1189 INOPERATIVE. REPLACED JIFFY SPLICE PIN WITH NEW IAW AMM 33-51-14, OPS CHECK GOOD.SDR AALA202102059011Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHT AT SEATS 26ABC-33ABC INOPERATIVE. REPLACED FUSE WITH NEW AT M1672 IAW AMM 33-51-00 AND WDM 33-51-22, OPS CHECK GOOD.SDR AALA202102059010Shroud · brokenAIRCRAFT IN BASE MAINTENANCE: SEAT 27ABC EMERGENCY PATH LIGHT SHROUD BROKEN AND HANGING FROM SEAT. REPLACED SHROUD WITH NEW IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202102039008Slide · out of positionAIRCRAFT WAS NOT GROUNDED: CLEANERS KNOCKED OFF L1 DOOR ESCAPE SLIDE. REINSTALLED L1 DOOR SLIDE IAW AMM 25-66-01.SDR AALA202102039006Slide · out of positionAIRCRAFT WAS NOT GROUNDED, FOUND LEFT MAIN ENTRY DOOR EMERGENCY SLIDE ASSEMBLY COMING OUT OF SHROUD. R & R LT MAIN ENTRY DOOR EMERGENCY SLIDE ASSEMBLY PER JOB CARD 08L22125001.SDR AALA202102039007Battery Pack · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ROWS 26ABC TO BACK ROW FAILED FUNCTIONAL CHECK. REPLACED RIGHTHAND AFT EMERGENCY LIGHT POWER SUPPLY BATTERY PACK PER AMM 33-51-06.SDR AALA202102039004Windshield · not reportedAIRCRAFT IN BASE MAINTENANCE: FOUND R1 WINDSHIELD REQUIRES REMOVAL AND REPLACEMENT FOR C CHECK. REMOVED AND REPLACED R1 WINDSHIELD IAW AMM 56-11-11, WORK CARD 2712.SDR AALA202102029023Shroud · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT IS HANGING DOWN AT ROW 29 ABC. REMOVED AND REPLACED ESCAPE PATH LIGHTING SHROUD ASSEMBLY ON ROW 29ABC PER CMM 25-23-67.SDR AALA202102029022Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HANGING DOWN AT ROW 13 ABC. REMOVED AND REPLACED ESCAPE PATH LIGHTING SHROUD ASSEMBLY ON ROW 13ABC PER CMM 25-23-67.SDR AALA202102029021Girt Bar · looseAIRCRAFT WAS GROUNDED: GIRT BAR CLIP ON 1R DOOR FOUND TO BE LOOSE. SECURED R1 DOOR GIRT BAR J HOOK IAW AMM 20-20-00.SDR AALA202102029025Bracket · looseAIRCRAFT WAS GROUNDED: L1 SLIDE GRIT BAR FORWARD LOCKING CLIP LOOSE. RESECURED CLIP PER AMM 25-66-02.SDR AALA202102029024Slide · displacedAIRCRAFT WAS GROUNDED: 1L DOOR SLIDE FELL OUT OF PACK DURING ARRIVAL AT GATE. REPLACED L1 DOOR SLIDE PER JOB CARD 08L22125001.SDR AALA202102029020Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT FLASH LIGHT IN THE 1 POSITION NOT TESTING. REPLACED BATERY PER AMM25-64-00. OPS CHECK GOOD..SDR AALA202102019034Cover · out of positionAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING ON SEAT 20 NEEDS TO BE REATTACHED TO SEAT. SECURED SEAT 20 LEFT PATH LIGHT COVER PER AMM 33-51-11.SDR AALA202102019035Sliding Window · delaminatedAIRCRAFT WAS NOT GROUNDED: CAPTAIN L2 SLIDING WINDOW DELAMINATED. ALSO, SMALL PINPOINT ARCING WAS OCCURRING IN TOP RIGHT HAND CORNER. R & R CAPTAIN SLIDING WINDOW L2 IAW AMM 56-12-11.SDR AALA202102119012Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON SHIELD RIGHT HAND SIDE AT STA 767-787 AND STR 26R. REPLACED SHIELD REF AARD 51-00-05.SDR AALA202102099019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RH TRANSITION PANEL IN AFT CARGO COMPARTMENT BETWEEN STA 727C AND STA 787 AT RBL 46, MEASURING L=2.7 IN, W=1.25 IN, D=0.008 IN. ACCOMPLISHED PERMANENT BLEND REPAIR IAW SRM 51-10-02-06 AND EA325161.
Back to Boeing 737-823