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 QR9R2025080100002Recorder · over voltageACFT SLAB BATTERY MUST BE DISCONNECTED WHEN NOT FLYING. TROUBLESHOOTING REVEALED CVFDR HAD CONSTANT DRAIN ON BATTERY. REMOVED AND REPLACED FA5001 CVFDR IAW AMM 31-32-00, 4-1.SDR DALA2025080105757Skin · crackedCRACK FOUND IN HOLE 6 AT 7 O'CLOCK POSITION IN SKIN LAYER JUST ABOVE SHIM LAYER. FURTHER INSPECTION AND REPAIR REQUIRED PRIOR TO FURTHER FLIGHT. SEE NR FOR ADDITIONAL INFORMATION 010-0001:5720-01100-04B/001 00001, COMPLIED WITH E/RA 589741-14AD REV. D.SDR IXXA20250801001Support Angle · crackedNUMBER 2 ENGINE PYLON PANEL 447DB AFT FAIRING (STINGER) INTERNAL O/B SUPPORT ANGLE CRACKED.SDR ABXA2025081167Warning Message · illuminatedDURING TAXI, LEFT INBOARD AILERON POSITION DISAGREEMENT WITH THE INDICATOR ON THE LOWER STATUS PAGE. AIRCRAFT RETURNED TO BLOCKS. (BTB). MAINTENANCE DEFERRED IAW MEL C ABX-27-08-1. AIRCRAFT RETURNED TO SERVICE.SDR AALA202508019554Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: MID LAVATORY SMOKE ALARM RANDOMLY CHIRPS. MAINTENANCE ACCOMPLISHED A SATSFACTORY OPERATIONAL CHECK OF THE LAVATORY SMOKE DETECTION SYSTEM PER AMM 26-17-00 WITH NO CHIRPS NOTED.SDR QR9R2025080100001Sensor · failed#2 OVERSPEED FAIL CAUTION REPEATEDLY APPEARED DURING HOVER AND AT FLIGHT. REMOVED AND REPLACED #2 ENG OVERSPEED SENSOR IAW MM 77-14-00-802-A01. T/F SUCCESSFULLY COMPLETED IAW AMM 05-60-00, 6-12.SDR DALA2026073004414Skin · debondedDTE / MONITOR INSPECTION LOG REF. ER/A 601550-14 REV A. A220 / HORIZONTAL STABILIZER / UPPER AND LOWER SKINS / @ REAR SPAR / HINGE RIB 2 TO HINGE RIB 3 / DISBOND. SUBJECT REPAIR REQUIRES FOLLOW-ON ACTION. REPAIR APPROVAL IS LIMITED TO 12 MONTHS SERVICE FROM 31SDR SWIA2025073175153Floor Support · crackedPOSSIBLE CRACK ON THE COCKPIT FLOOR SUPPORT, FWD ANGLE (MARKED) (C-CHECK RO 02/01/2026)REMOVED AND REPLACED FLOOR SUPPORT STRUCTURE WITH NEW P/N CC670-34095-1 FS 280 (FWD ANGLE) IAW CRJ 900 SRM 51-42-06-001-001-A01 & CRJ 900 SRM 51-42-21-001-001-A01 AND DWG CSDR SWIA2025073175152Support Angle · corrodedFS280, FLOORBOARD CRAWLWAY SUPPORT ANGLE, HAS 3EA AREAS OF CORROSION (MARKED) (C-CHECK RO 02/01/2026)REMOVED AND INSTALLED NEW FS280, FLOORBOARD CRAWLWAY SUPPORT ANGLE REF CRJ-900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG CC670-34010 REV SDR SWIA2025073175151Stringer · corrodedCORROSION ON STGR23L BETWEEN FS1069.75- FS1088.20 AS MARKED (C-CHECK RO 02/01/2026)REMOVED CORROSION ON STGR23L BETWEEN FS1069.75- FS1088.20 REF CRJ-900 SRM 51-21-06-001-001-A01NOMINAL THICKNESS IS: 0.100" REF. BOMBARDIER DWG MM670-35151 REV R MINIMUM REMAINSDR SWIA2025073175150Stringer · corrodedCORROSION ON STGR24L BETWEEN FS985.00 - FS1000.00 AS MARKED (C-CHECK RO 02/01/2026)REMOVED CORROSION ON STGR24L BETWEEN FS985 - FS1000. MATERIAL LOSS OF 0.005" IS WITHIN LIMITS OF REO 690-53-61-1656 REV -- DATED 2025-08-07. RESTORED FINISH. SEE CONTINUATSDR SWIA2025073175149Door Sill · corrodedAFT BAGGAGE DOOR SILL CORRODED AS MARKED (C-CHECK RO 02/01/2026)AFT BAGGAGE DOOR SILL. P/N MM670-35655-003, NO DAMAGE IS ALLOWED ON THE SURROUND STRUCTURE OF THE AFT BAGGAGE BAY DOOR. IAW. CRJ900 SRM 53-61-23-101-001-A01REMOVED AND REPLACED AFT BAGGAGE DOOR SSDR SWIA2025073175132Stringer · corrodedCORROSION ON STGR26L BETWEEN FS1000.00 - FS1015.00 AS MARKED (C-CHECK RO 02/01/2026)REMOVED CORROSION ON STGR26L BETWEEN FS1000 - FS1015. MATERIAL LOSS OF 0.010" IS WITHIN LIMITS OF REO 690-53-61-1654 REV -- DATED 2025-08-06. RESTORED FINISH. SEE CONTINUATSDR SWIA202512020731Support Angle · corrodedPANEL 642AZ, FWD SUPPORT ANGLE IS CORRODED. REPLACED PANEL 642AZ FWD SUPPORT ANGLE IAW DWG CC670-10320, REV F, SRM 51-42-21-001-001-A01. LEAK CHECKED GOOD. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR AALA202512014262Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLIGHT DECK WINDSHIELD LEFT HAND LATERAL FRAME BETWEEN FR 4 AND FR 8. REPAIRED WINDSHIELD FRAME PER EA 366681.SDR JJBA20251111059Access Panel · corrodedR/H WING FUEL ACCESS PANELS AND CLAMP RINGS:641BB, 631CB, 156CZ, 651AB, 641CB, 641EB, 641DB, 631DB, 631BB, 631AB, AND 641AB HAVE CORROSION AND FRETTING DAMAGE (PITTING). PERFORMED CORROSION REMOVAL PROCESS ON RH FUEL ACCESS DOOR PANEL 641CB, 641EB, 641DB, 631DSDR JJBA20251111056Brace · crackedCARGO COMPARTMENT DOOR CUTOUT BRACES CRACKED. INSTALLED NEW CARGO THRESHOLD BRACE AND ANGLE.SDR VNAA20251016006Rib · corrodedCORROSION AT ATTACHMENTS FITTING OF CONECTORS PX01J1 AND PX09J1 BEHIND ACCESS PANEL642AZ. ON RH WING. EVALUATED, DUE TO EXCESSIVE DAMAGE AT ATTACHMENTS FITTING OF CONECTORS PX01J1 AND PX09J1 BEHIND ACCESS PANEL642AZ. ON RH WING AND REPLACED PER CRJ-900 SRM 5SDR VNAA20251016002Support Bracket · corrodedCORROSION ON BRACKET SUPPORT OF THE ELECTRICAL CONNECTORS PX19 AND PX34, LEFT WHEEL WELL. BRACKET SUPPORT OF THE ELECTRICAL CONNECTORS PX19 AND PX34, LEFT WHEEL WELL WAS REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR VNAA20251015019Support Bracket · corrodedCORROSION ON FOUR BRACKET SUPPORT AND TWO ANGLES IN THE LEFT MLG WHEEL WELL STRUCTURE. BRACKET SUPPORT (2 EAS) AND ANGLE (1 EA) WERE REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01 AND SRM 51-42-21-001-001-A01 AND CORROSION ON BRACKET SUPPORT (2 EAS) AND ANGLESDR VNAA20251015017Support Bracket · corrodedCORROSION ON 2EA PLATES SUPPORTS OF CONNECTORS AND HYD LINES FWD SIDE RH WHEEL/WELL. 2EA PLATES SUPPORTS OF CONNECTORS AND HYD LINES FWD SIDE RH WHEEL/WELL WERE REPACED PER CRJ900 SRM 51-42-21-001-001-A01 AND SRM 51-42-06-001-001-A01SDR VNAA20251015016Angle · corrodedCORROSION ON BRACKET SUPPORT OF FLEXIBLES HYD LINES FWD SIDE AT RH WHEEL/WELL. BRACKET SUPPORT OF FLEXIBLES HYD LINES FWD SIDE AT RH WHEEL/WELL WAS REPLACED PER CRJ900 SRM 51-41-02-001-001-A01.SDR VNAA20251015015Angle · corrodedCORROSION AT SETTLEMENT ANGLE OF ACCESS PANEL642AZ. ON RH WING. EVALUATED, DUE TO EXCESSIVE DAMAGE ON SETTLEMENT ANGLE OF ACCESS PANEL642AZ. ON RH WING PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01.SDR VNAA20251015011Rib · corrodedCORROSION ON RIB, MLG HARNESS INTERFACE AT LH/RH WING. CORROSION ON RIB, MLG HARNESS INTERFACE AT LH/RH WING WAS EVALUATED DUE EXCESSIVE DAMAGE PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01, SRM 51-42-10-001-001-A01 ANSDR NACA2025073100003Valve · leakingDURING WALK AROUND FOUND LH ENGINE HAS OIL LEAK. FOUND LH ENG AIR/OIL HEAT EXCHANGER VALVE RETURN TUBE LEAKING OIL . TIGHTENED A/O HEAT EXCHANGER VALVE RETURN B-NUT PER AMM 79-21-09SDR NACA2025073100002Elec Connector · out of limitsFOUND THE LEFT ENGINE EEC C2 MAINT MESSAGE. FOUND LH ENG 21B LVDT CONNECTOR 0830OP BETWEEN P2N AND PIN 2 RESISTANCE OUT OF LIMIT REPLACED LH ENG INBD TR LOCK HYD ACTUATOR AND CARRIED OUT INSTALL TEST. ENGINE INFORMATION UNAVAILABLE.SDR SWIA202509250731Channel · crackedCRACK FOUND IN WEB CHANNEL OF COPILOT'S SIDE WINDOW FRAME SUPPORT STRUCTURE CAMP#30584259 (C-CHECK RO 09/24/2025)REMOVED AND INSTALLED CLIP ATTACHED TO WEB CHANNEL AT LOWER SECTION REF. CRJ200 SRM 51-42-06 AND DWG 601R34032 REV. -V. AND COMPLIED WITH TASK CARSDR VNAA202509250016Skin · dentedDENT ON EXTERNAL LOWER FUSELAGE BTW FS310.00 TO FS319.00 AND STGR#21 TO STGR#20 RH SIDE. DENT ON EXTERNAL LOWER FUSELAGE BTW FS310.00 TO FS319.00 AND STGR#21 TO STGR#20 RH SIDE WAS REPAIRED PER REO 670-53-21 -2673 REV-.SDR VNAA202509250015Door Frame · wornWEAR ON SURROUND OF HANDLE OF AFT COMPARTMENT DOOR. WEAR ON SURROUND OF HANDLE OF AFT COMPARTMENT DOOR WAS REPAIRED PER REO 670-52-31-031 REV BSDR VNAA202509250009Fairing · damagedFAIRING ASSY, LOWER VISOR (LH) 326CL WITHIN 2016.46 FLIGHT HOURS AFTER SECTION I, ACCOMPLISH A PERMANENT REPAIR AT DISCREPANT AREA IN ACCORDANCE WITH APPROVED PROCEDURES OR REPLACE PART. FAIRING ASSY, LOWER VISOR (LH) 326CL WAS REPLACED BY NEW FAIRNG PER EA 5SDR SWAA2025091197254Angle · crackedCRACK ON GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 21L AT FWD CARGO COMPARTMENT. REPLACED GUSSET LOCATED BS 500I AT LEVEL STR 21L AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9 ;SRM 51-40-02 AND DWG 143A7902 SHEET 256 REV B.SDR SWAA2025091097255Angle · crackedCRACK ON ANGLE LOCATED AFT FACE BS 500H AT LEVEL STR 26L AT FWD CARGO COMPARTMENT. REPLACED ANGLE LOCATED AFT FACE BS 500H AT LEVEL STR 26L AT FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9 AND SRM 51-40-02 DWG 143A7505 SHEET 124 REV- REV-.SDR SWAA2025091096897Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT. REPAIRED THE AFT CORNER SCUFF PLATE OF FWD CARGO COMPARTMENT IAW BOEING SRM 53-30-15-2R-1 REPAIR 1 AND BAC 5975.SDR SWAA2025091097103Angle · crackedCRACK ANGLE LOCATED AFT FACE BS 500H AT LVEL STR 26R AT FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOCATED AFT FACE BS 500H AT STR 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 AND DWG 143A7505 SHEET 123 REV. -.SDR SWAA2025091097104Angle · crackedCRACK ANGLE LOCATED FWD FACE BS 500H AT LVEL STR 26R AT FWD CARGO COMPARTMENT. REPLACED ANGLE LOCATED FWD FACE BS 500H AT STR 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 AND DWG 143A7505 SHEET 123 REV -.SDR SWAA2025091097106Angle · crackedCRACK ON ANGLE LOCATED FWD FACE BS 500H AT LEVEL STR 26L AT FWD CARGO COMPARTMENT. REPLACED ANGLE LOCATED FWD FACE BS 500H AT LEVEL STR 26L AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 DWG 143A7505 SHEET 124 REV- .SDR SWAA2025091097105Angle · crackedCRACK ON GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 19R AT FWD CARGO COMPARTMENT. REPLACED GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 19R AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9 ;SRM 51-40-02 AND DWG 143A7902 SHEET 256 REV B.SDR SWAA2025091097265Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986. LBL 43 WL 208.1 AT AFT GALLEY AREA. PERFORMED PERMANENT REPAIR ON FLOOR BEAM LOCATED BS 986. LBL 43 WL 208.1 AT AFT GALLEY AREA I.A.W SRM 53-70-51-2R-6 REPAIR 6.SDR SWAA2025091097263Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5 RBL 30 WL 208.1. PERFORMED REPAIR ON FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6.SDR SWAA2025091097260Floorbeam · corrodedCORROSION ON EXISTING REPAIR LOCATED ON FLOORBEAM BS 947.5 LBL52 WL 208. PERFORMED PERMANENT REPAIR.SDR SWAA2025091097258Floorbeam · corrodedCORROSION ON EXISTING REPAIR LOCATED ON FLOORBEAM BS 947 RBL 53 WL 208.1. PERFORMED PERMANENT REPAIR.SDR SWAA2025091097257Floorbeam · corrodedCORROSION ON EXISTING REPAIR ON FLOORBEAM BS 947.5, RBL 23, WL 208.1, IN AFT GALLEY. PERFORMED PERMANENT REPAIR ON THE FLOORBEAM LOCATED IAW EA 25-153-02199, AND SRM 53-70-51-2R-5, REPAIR 5.SDR SWAA2025091097107Angle · crackedCRACK ON ANGLE LOCATED FWD FACE OF BS 500G, STRINGER 26R IN FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-40-02-0G-0, AND DWG 143A7505, SHEET 123, REV -. MEASUREMENT OF CRACK: L= 1.600.SDR IPXA2025081516184Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD SIDE OF BS 2360, S10L. ACCOMPLISHED REPAIR IAW SRM 53-60-03-2R-8, REV 46, TR:53-149, EGAT WORK SHEET 50610, EO-94717-REQ 1, REV 1, AND EGAT EI F2025A53M-1778 REV 0.SDR SWAA2025090397246Stiffener · crackedFORWARD CARGO COMPARTMENT 540 BULKHEAD VERTICAL STRUCTURE STIFFENER HAS CRACK STA 540 LBL 24.97. REPLACED VERTICAL STIFFENER LOCATED AT BSTA 540 AND LBL 24.97 FWD CARGO COMPARTMENT IAW EA# 25-157-02184-WIP1 AND EA# 25-157-02184.SDR SWAA2025090397101Bulkhead Web · crackedCRACK ON VAPOR BARRIER WEB LOCATED AT BS 663.75 BTW RBL 45.64 TO RBL 54.21 MAIN WHEEL WELL COMPARTMENT. REPAIRED PROCESS IAW B737-700 SRM 51-70-04-2R-10.SDR SWAA2025090397098Nut Plate · crackedCRACK RAIL NUT PLATE OTBD FRONT SPAR OFSS 465 AT RT WING. REPLACED RAIL NUT PLATE O/B FRONT SPAR OFSS 465 AT RT WING IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 112A4402 SHEET:13 REV:-.SDR SWAA2025090397243Plate · crackedCRACK INBOARD TRAILING EDGE CORRUGATED PLATE IRSS 216 AT RT WING. REPLACED CORRUGATED PLATE LOCATED INBOARD TRAILING EDGE IRSS 216 AT RT WING IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND AND DWG: 115A2713 SHEET: 4 REV -.SDR SWAA2025090397248Floorbeam · corrodedMAIN CABIN FWD WET AREA; FLOORBEAM UPPER SURFACE; FITTING HAS CORROSION; STA 312; LBL 54. REPLACED FITTING AND FASTENERS LOCATED ON BS 312 LBL54 FLOORBEAM IAW B737-700 SRM 51-40-02-0G-0 AND DWG:141A5503;SHEET:15;REV:-.SDR SWAA2025090397099Nut Plate · crackedCRACK RAIL NUT PLATE O/B FRONT SPAR OFSS 491 AT RT WING. REPLACED RAIL NUT PLATE O/B FRONT SPAR OFSS 491 AT RT WING IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG: 112A4402 SHEET: 14 REV:- MEASURE CRACK IS L:0.200 INCHES.