Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 DALA2025091506787Light · no discrepancyEMERGENCY LIGHTS FLICKERING ON RAM DEFERRAL SET FOR KEYWORD: RAM 1. T/S PER 33-51-00-810-881-A. NO FAULTS NOTED. (1198442).SDR DALA2025091506785Fitting · corrodedLEFT PYLON SPIGOT-RECEPTACLE FITTING CORRODED. REPLACED THE LOWER SPIGOT FITTING IAW SRM TASK 54-51-12-300- 001. (1198774).SDR DALA2025091506784Fitting · corrodedRIGHT PYLON SPIGOT-RECEPTACLE FITTING CORRODED. REPLACED LOWER SPIGOT FITTING IAW SRM TASK 54-51-12-300- 001. (1198763).SDR DALA2025091506783Circuit Breaker · trippedDURING FLIGHT OPERATIONAL TEST GOT CIRCUIT BREAKER H07 TRIPPED. REPLACED CIRCUIT BREAKER H07 ON OVERHEAD PANEL 49VU IAW AIRBUS ESPM 20-52 -22. (1198052).SDR GTIA2025091539076Unknown · odorSOUR SMELLL IN THE CABIN FOUND OIL ALL THE WAY TO THE APU. DESCRIPTION OF ODOR/FUMES: TEMPORARY ODOR DURING DESCENT. APPARENT CABIN SOURCE: UNKNOWN. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-REF TSM 05-50-00. APU VERIFIED NO LEAKS. PERSDR YENA2025091500931Oil System · leakingFLT#1383, GUA-FLL. "FUMES EVENT ON DECENT THROUGHT 10,000 FEET STUNK IN BACK LESS UP FRONT DIRTY SOCKS OIL; COMPLIED WITH INFORMATION NOTICE 2017-T015 SECTION B2 TYPE 1 APU AND PERFORMED DECONTAMINATION LEVEL B WAS ACCOMPLISHED PER TSM 05-50-00-810-831-A. AIRCSDR SIMA20250914003Power Supply · inoperativeROW 11/12 EMERGENCY LIGHT IS INOPERATIVE. "TRANSFERRED TO NRWC 742-ORD-01366" RAR ELPU4 REF NRWC 742-ORD-01366. OPS CHECK GOOD.SDR SIMA20250914002Door · no discrepancyGATE AGENT STATES THAT THE L1 CABIN DOOR HANDLE IS VERY HARD TO LIFT UP AND OPEN FROM THE OUTSIDE WHEN OPENING THE DOOR PERFORM OPC OF L1 DOOR IAW:AMM 52-11-00 OPC GOODSDR SIMA20250914001Arming Lever · bindingRH FWD CABIN SERVICE DOOR ARMING LEVER HARD TO OPERATE LUBRICATED RH FWD CABIN SERVICE DOOR ARMING LEVER AND PERFORMED OPS CHECK GOOD IAW AMM 52-41-40SDR SIMA202509154004Module · faultedWITH BLEED 1 ON MEL, BLEED 1 OVERPRESSURE ON CLIMB OUT, BLEED 1 FAIL ON LANDING WITH BLEED SELECTED CLOSED PER MEL 36-13. RAR AMS CONTROLLER MOTOR DRIVE MODULES IAW ERJ 175 AMM 21-00-02. NO FURTHER DEFECTS NOTED. A/C OK FOR SERVICE.SDR YENA2025091500929Thermocouple · failedFLT#34, CDG-BOS. ON ENG 2 SHUTDOWN RECEIVED ECAM ENG 2 MINOR FAULT ( MINOR FAULT CAUTIONS ON ECAM EWD). REMOVED AND REPLACED UPPER R, THERMOCOUPLE EGT AND CLEANED CONNECTORS P33, P14, P13 AND P107 REF TSM 77-21-00-810-810-A. GROUND VERIFICATION SUCCESSFUL.SDR FDEA202509141704Warning Message · illuminatedENROUTE MAIN CARGO DOOR LIGHT ILLUMINATED. ON DESCENT PASSING 22K, LIGHT WENT OUT. RELEASED FOR SERVICE PER MEL : 52-71-01-02 CATEGORY : C. MAIN DECK CARGO DOOR INDICATION SYSTEM - INOP. VERIFY AND RECORD IN AML/EAML THAT MAIN DECK CARGO DOOR IS CLOSEDSDR DALA2025091506773Controller · brokenMULTIPLE ROWS OF EMERGENCY LIGHTS INOPERATIVE. R &R DEU B (3WRH6) PER AMM 23-73. OPS CHECK GOOD. (7615384)SDR HNAA2025091400636Warning Message · illuminatedBAGGAGE DOOR OPEN MESSAGE DURING FLIGHT. BAGGAGE DOOR WARNING / POSITION WARNINGSDR BJNA202509150001Charger · inoperativeDURING SERVICE CHECK FOUND AREA LIGHTS INOP AT 23DEF, 24ABC, 27ABC. R & R CHARGER ASSY M1670 IAW AMM 33-51-06-960-806. OPS CHECK GOOD. THIS CLEARS DMI # 353958. A/C OK FOR SERVICESDR DXTA2025091504962Door · bindingINTERMITTENT MAIN CABIN DOOR HANDLE BINDING, WON`T MOVE TO THE CLOSED POSITION. IF YOU PLAY WITH THE HANDLE, IT WILL CLOSE BUT THEN BIND AGAIN AFTER A COUPLE MORE CYCLES OF THE HANDLE. GAINED ACCESS TO DOOR INTERIOR AND VERIFIED RIGGING WAS WITHIN LIMITATIONSSDR DXTA2025091504965Battery Pack · inoperativeON GROUND EMER LIGHT NOT ARM CAME ON WITH THE SWITCH IN THE ARM POSITION. WE DID THE RESET PROCEDURE AND CAS MESSAGE WENT AWAY. IN FLIGHT THE CABIN EMER LIGHTS CAME ON FOR 15 MIN THEN BEGAN TO FLICKER FOR THE DURATIONS OF THE FLIGHT. PICS ATTACHED PERFORMED SDR CALA2025091508879Light · not reportedEMERGENCY ESCAPE PATH LIGHT ON ROW 48 AFT. MIDDLE SECTION ONLY. ACCOMPLISHED FIM TASK B787-A-33-50-F1-BSA-421A AND EMERGENCY EXIT LIGHTS OPS TEST IAW MM 33-51-00-00C-320A-A, ALL TEST GOOD. ACP'D EMERGENCY LIGHTS FULL GROUND TEST IAW MM B787-A-33-51-00-07A-34SDR CALA2025091508878Light · no testVISUAL INSP FOUND EMERGENCY ROW LIGHTING AT SEAT ROWS 26, 27 AND 28 (ABC) INOPERATIVE. REMOVED AND REPLACED SEAT MOUNTED EMERGENCY LIGHTS FOR ROWS 26,27,28. IAW TASK 33-51-19-000-002-A AND TASK 33-51-19-400-002-A OPS CHECK GOOD.SDR N6WA2025091501Floor Support · corrodedCORROSION ON RH SILL BETWEEN FS280.00 AND FS319.70. REMOVED AND REPLACED RH SILL BETWEEN FS280.00-FS319.70 IAW CRJ SRM 51-42-06SDR MASA2025091500074Flashlight · inoperativeFO FLASHLIGHT IS DEAD - PLACED ON MELSDR DALA2025091406747Drain Valve · leakingAFT FLT ATTENDANTS REPORT A "DIRTY SOCK, PUNGENT" SMELL IN THE AFT HALF OF THE CABIN THE LAST 40 MINS OF FLIGHT. SMELL CLEARED UPON LANDING. FOUND HYDRAULIC LEAK AT YELLOW HYD DRAIN VALVE (GS 315183). REPLACED YELLOW HYD DRAIN VALVE PER A321 AMM 29-13. (LP 7SDR SWIA202512260913Door Frame · gougedDURING THE DVI OF THE AVIONICS BAY DOOR LANDING. THE INTERIOR SURFACE IS DISCOLORED AND HAS LIGHT GOUGES IN MULTIPLE AREAS AROUND THE OPENING. REMOVED DAMAGES ON AVIONIC DOOR SURROUND SKIN INNER SURFACE BETWEEN FS364.00-FS394.00 & STR25R-STR25L REF. SRM 51-12SDR SWIA202511240913Rib · wornRIGHT OTBD FLAP BUTE DOOR CAMS & RIB FITTINGS HAVE WEAR & ARE MUSHROOMED AT ALL 5 LOCATIONS. REPAIRED THE BUTE DOOR CAMS AND RIB FITTINGS, REPLACED OTBD MOST LOCATION IAW REO 670-57-53-008 REV -D, & DWG 601R14502, REV D, CHECKS GOOD. COMPLIED WITH SKYWEST SDR AALA202511183478Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATE HOLE ON SPLICE FITTING L/H LOCATED ON CENTER WINDSHIE LD FRAME POS LOWER ATTACHMENT AREA, MEASURES OF DAMAGE ARE L=0.335IN,W=0.215IN. MAINTENANCE REPLACED SPLICE FITTING L/H LOCATED ON CENTER WINDSHIELD FRAME POST ON LOWSDR CALA2025102410502Pressure Blkhd · crackedFOUND CRACK AT BS 1016 AFT PRESSURE BULKHEAD, 2" ABOVE WL 208.1 AND LBL 3. REPAIRED THE DAMAGED AFT PRESSURE BULKHEAD WEB IAW ESR-WI 2023704-24-12817 AND EC/RA 5380-01428,SDR SWAA2025102314161Support · crackedCRACK CHANNEL SUPPORT LOCATED STA727 AND RBL 3 AT AFT CARGO COMPARTMENT. REPLACED CHANNEL SUPPORT LOCATED STA727 AND RBL 3 AT AFT CARGO COMPARTMENT IAW B737 700 SRM 51-10-02-0G STEP 9 AND DWG 144A2600 SHEET 566 REV -.SDR SWAA2025102314157Gusset · damagedELONGATED HOLE GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT. REPLACED GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT IAW SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG 143A7902; SHEET: 174; REV-.SDR SWAA2025102314160Web · corrodedCORROSION SHIELD WEB FLOOR STRUCTURE LOCATED BETWEEN STA767 TO STA794.3 AND RBL21 WL156 AT AFT CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS LOC. ON FLOOR STRUCTURE BETWEEN STA767 TO STA794.3 AND RBL21 WL156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM51-SDR SWAA2025102214154Rib · crackedCRACKED INSPAR RIB LOCATED STAB STA 120.30 AND 34 INCHES FROM FRONT EDGE LT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON INSPAR RIB IAW SRM 51-40-02, AND SRM 55-10-09-2R-4, REPAIR 4, FIG 202, DETAIL A.SDR SWAA2025102214155Rib · crackedCRACKED INSPAR RIB LOCATED STAB STA 120.30 AND 27 INCHES FROM FRONT EDGE LT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON INSPAR RIB IAW SRM 51-40-02, AND SRM 55-10-09-2R-4, REPAIR 4 FIG 202, DETAIL A.SDR SWAA2025102214156Rib · crackedCRACK INSPAR RIB LOCATED STAB STA 120.30 AND 19 INCHES FROM FRONT EDGE LT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON INSPAR RIB IAW SRM 51-40-02, AND SRM 55-10-09-2R-4, REPAIR 4, FIG 202, DETAIL A.SDR SWAA2025102114314Support Beam · crackedCRACK SUPPORT BEAM #4 LOCATED FWD GALLEY DOOR. REPLACED BEAM NR 4 LOCATED FWD GALLEY DOOR IAW B737-800 SRM 51-10-02 ITEM 9 AND DWG 141A6535 SHEET 13 REV -.SDR SWAA2025102114291Angle · crackedCRACK ANGLE - CLIP ON BS 500H FWD FACE AT LEVEL LBL 21 AT FWD CARGO COMPARTMENT. REPLACED CLIP AND FASTENERS LOCATED BS 500H FWD FACE AT LEVEL LBL 21 AT FWD CARGO COMPARTMENT IAW. B737-800 SRM 51-40-02 AND DWG 143A7505 SHEET 124 REV-.SDR SWAA2025102114292Angle · crackedCRACK ANGLE - CLIP ON BS 500H AFT FACE AT LEVEL LBL 21 AT FWD CARGO COMPARTMENT. REPLACED CLIP AND FASTENERS LOCATED ON BS 500H AFT FACE AT LEVEL LBL 21 AT FWD CARGO COMPARTMENT IAW. B737-800 SRM 51-40-02 AND DWG 143A7505 SHEET 124 REV-.SDR SWAA2025102114297Angle · crackedCRACK ANGLE - CLIP BS 440 AT LEVEL LBL 25 AT FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOCATED BS 440 AT LEVEL LBL 25 AT FWD CARGO COMPARTMENT. IAW B737-800 SRM 51-10-02-0G-0 ITEM 9 AND DWG 143A7505 SHEET: 123 AND 124 REV: -.SDR SWAA2025102114307Strap · corrodedCORROSION ON STRAP LOCATED OFSS581 LEADING EDGE AT RT WING . PERFORMED PERMANENT REPAIR ON STRAP LOCATED OFSS581 LEADING EDGE AT RT WING IAW EA# 25-157-02562-WIP1.SDR SWAA2025102114310Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED ACCESS PANEL 841DZ AT FWD SERVICE DOOR. REPLACED SUPPORT ANGLE LOCATED ACCESS PANEL 841DZ AT FWD SERVICE DOOR IAW B737-800 SRM 51-10-02-0G-0 ITEM 9 AND SRM 51-40-02-0G-0. TOOK MEASURES OF CRACK IS: 0.337.SDR SWAA2025102114296Angle · crackedCRACK ANGLE - CLIP BS 500B AT RBL 21 AT FWD CARGO COMPARTMENT. REPLACED CLIP ASSY LOCATED ON BS 500B AT RBL 21 AT FWD CARGO COMPARTMENT IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG: 143A7505; SHEET: 123; REV -.SDR SWAA2025102114299Angle · crackedCRACK ANGLE ON BS 400 AT LEVEL LBL 21 AT FWD CARGO COMPARTMENT. REPLACED THE ANGLE IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG: 143A7505; SHEET: 123; REV -.SDR SWAA2025102114313Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 14 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 LBL 14 WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9 AND DWG: 143A5400 SHSDR SWAA2025102114305Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 52 WL 208.1 AT PASSENGER CABIN . REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 LBL 52 WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9 AND DWG: 143A5400 SHESDR SWAA2025102114306Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 40 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 RBL 40 WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9 AND DWG: 143A5400 SHESDR SWAA2025102114315Nut Plate · corrodedCORROSION ON RAIL NUT PLATE LOCATED OFSS449 INTERNAL CAVITY LEADING EDGE AT RT WING. REPLACED RAIL NUT PLATE LOCATED OFSS449 INTERNAL CAVITY LEADING EDGE AT RT WING IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 112A4402 SHEET 40, REV A.SDR SWAA2025102114321Nut Plate · corrodedCORROSION ON RAIL NUT PLATE LOCATED OFSS303 INTERNAL CAVITY LEADING EDGE AT RT WING. REPLACED RAIL NUT PLATE LOCATED OFSS303 INTERNAL CAVITY LEADING EDGE AT RT WING IAW SRM 51-40-02-0G-0 AND SRM 51-10-02-0G-0 ITEM 9.SDR SWAA2025102114322Nut Plate · corrodedCORROSION ON RAIL NUT PLATE LOCATED OFSS288 INTERNAL CAVITY LEADING EDGE AT RT WING. REPLACED RAIL NUT PLATE LOCATED OFSS288 INTERNAL CAVITY LEADING EDGE AT RT WING IAW SRM 51-40-02-0G-0 AND SRM 51-10-02-0G-0 ITEM 9.SDR SWAA2025102114316Strap · corrodedCORROSION ON STRAP LOCATED OFSS405 LEADING EDGE AT RT WING . PERFORMED REPAIR ON BETWEEN OSS 163.95 TO OSS 227.95 AT RT WING IAW EA 25-157-02564-WIP1 ; EA 25-157-02564-WIP2 ; EA 25-157-02564-WIP3 ;EA 25-157-02564 B737-800 SRM 51-40-02; DWG 112A4402 SHEET 40; SDR HNAA2025102100716Skin · dentedF069895 FUSELAGE EXTERNAL SKIN HAS A PROTRUSION BETWEEN FR 77/80 STR 18R/19R. INSTALLED FABRICATED REPAIR DOUBLER AND FILLER ON FUSELAGE EXTERNAL SKIN BETWEEN FR. 77-80, STRG. 18R-19R IAW ETD2025-145-928508 AND PIEDMONT EO1-05-25-0363.SDR HNAA2025102100709Structure · corrodedF069855 RH MLG BAY LOWER SKIN FWD OF MAIN SIDE BRACE AT SPAR II HAS CORROSION, BLENDED AREA ON RH MLG BAY. DAMAGE ACCEPTED AS IS IAW ETD2025-145-928499 AND PIEDMONT EO1-05-25-0363.SDR HNAA2025102100708Structure · corrodedF069854 LH MLG BAY LOWER SKIN FWD OF MAIN SIDE BRACE AT SPAR II INTERNAL HAS CORRODED AREA. RAR LH MLG BAY LOWER SKIN FWD OF MAIN SIDE BRACE AT SPAR II IAW EMB 145 SRM 51-40-02.