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 VNAA202601280030Floorbeam · crackedCRACKED CENTER COCKPIT FLOOR BEAM RBL 12 AT FS280.0 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT CENTER COCKPIT FLOOR BEAM RBL 12 AT FS280.0 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT WAS REPAIRED PER REO
690-53-11-2095 REV. -."SDR VNAA202601280029Web · crackedCRACK ON FLOOR WEB RH SIDE (BELOW ADG SUPPORT DOUBLER) FS 193 AT FWD EQUIPMENT COMPARTMENT. FLOOR WEB RH SIDE (BELOW ADG SUPPORT DOUBLER) FS 193 AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER CRJ-900 SRM 53-11-43-201-001-A01.SDR VNAA202601280028Crossbeam · corrodedIN REFERENECE TO NRC 00129: AFTER REMOVAL OF ANGLE CAP, CORROSION ON LH CROSSBEAM AT FS280 WAS FOUND. LT CROSSBEAM AT FS280 WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ 900 SRM 51-42-21-001-001-A01, SRM 51-42-06-001-00SDR VNAA202601280027Clamp · corrodedCORROSION ON SUPPORTS CLAMPS (4 EAS, TWO PER SIDE) BEHIND ACCESS PANELS; 542AZ AND 642AZ AT LH/RH MLG AREA. SUPPORTS CLAMPS (4 EAS, TWO PER SIDE) BEHIND ACCESS PANELS; 542AZ AND 642AZ AT LH/RH MLG AREA WERE REPLACED REPLACED PER CRJ-900 SRM 51-10-06-001-001-SDR VNAA202601280026Angle · corrodedCORROSION ON ANGLES (2 EAS, ONE PER SIDE) BEHIND ACCESS PANELS; 542AZ AND 642AZ AT LH/RH MLG AREA. ANGLES (2 EAS, ONE PER SIDE) BEHIND ACCESS PANELS; 542AZ AND 642AZ AT LH/RH MLG AREA WERE REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01"SDR VNAA202601280025Retainer · corrodedCORROSION ON SEAL RETAINERS OF HINGE FAIRINGS NBR 597AB, 595AB, 586AB, 592AB, 583AB, 695AB, 686AB, 683AB & 683BB OF RH/LH WINGS CORROSION ON SEAL RETAINERS OF FAIRINGS 595AB(2EAS), 586AB(2EAS), 592AB(3EAS), 583AB(4EAS) 695AB(2AES), 686AB(2EAS), 683AB(2EAS) WASSDR JR2R20260128175Rib · corrodedR/H WING I/B MAIN FLAP TORQUE TUBE SUPPORT STRUCTURE RIB 1 IS CORRODED IN MULTIPLE SPOTS. PERFORMED TEMPORARY REPAIR IAW ETD2026-170-000513.SDR VNAA202601280024Fitting · corrodedCORROSION ON FITTINGS (2 EAS) BTW FS310.00 TO FS349.00 WL 72.00 ENTRY PASSENGER DOOR AT PAX CABIN. FITTINGS (2 EAS) BTW FS310.00 TO FS349.00 WL 72.00 ENTRY PASSENGER DOOR AT PAX CABIN WERE EVALUATED OUT OF LIMITS PER CRJ-900 SRM 51-10-06-001-001-A01, REPLACESDR VNAA202601280023Strap · corrodedCORROSION AT SUPPORT STRUCTURE STRAP BTW FAIRING ACCESS PANEL 193AL & 193AR TO FAIRING ACCESS PANEL 193AB. DUE TO EXCESESIVE CORROSION AT SUPPORT STRUCTURE STRAP BTW FAIRING ACCESS PANEL 193AL & 193AR TO FAIRING ACCESS PANEL 193AB WERE REPLACED PER CRJ900 SRSDR VNAA202601280022Beam · corrodedCORROSION ON BEAM SIDE, RIGHT SIDE FROM FS985.00 TO FS1088.20 WL 72.00 AND LEFT SIDE FROM FS1049.00 TO FS1053.00 WL 72.00 AT AFT BAGGAGE-BAY. CORROSION ON BEAM SIDE, RIGHT SIDE FROM FS985.00 TO FS 1015.00 AND FS1069.75 TO FS1088.20 WL 72.00 AND LEFT SIDE FROSDR AALA202601282250Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT INOPERATIVE AT SEAT ROW 24ABC. MAINTENANCE FOUND WALL TO SEAT EMERGENCY LIGHT HARNESS AND THE LIGHT ASSEMBLY FAULTY. REPLACED THE HARNESS (AALA202601284180) AND THE LIGHT ASSEMBLY (AALA202601282250) PER AMM 33-5SDR AALA202601284180Harness · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT INOPERATIVE AT SEAT ROW 24ABC. MAINTENANCE FOUND WALL TO SEAT EMERGENCY LIGHT HARNESS AND THE LIGHT ASSEMBLY FAULTY. REPLACED THE HARNESS (AALA202601284180) AND THE LIGHT ASSEMBLY (AALA202601282250) PER AMM 33-5SDR AALA202601288290Battery · activation errorAIRCRAFT WAS GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 15WL DISPLAYED DURING SYSTEM TEST. MAINTENANCE REPLACED THE BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK CARD 26C00033004.SDR AALA202601281044Battery · abnormalAIRCRAFT WAS GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. MAINTENANCE REPLACED THE BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK CARD 26C00033004.SDR VNAA202601280021Access Panel · corrodedCORROSION ON ACCESS PANELS 542AZ, 622EZ AND 599AB. ACCESS PANEL 542AZ WAS REMOVED PER CRJ 900 SRM 51-21-06-001-001-A01 AND WITHIN LIMITS PER CRJ-900 SRM 53-00-00-101-001-A01. W ACCESS PANEL 599BB WAS VERIFIED ( P/N: 601R13442-7) PER CRJ-900 AIPC 27-15-01. ACCSDR VNAA202601280020Retainer · corrodedCORROSION AT LH & RH P-SEAL GANG CHANNELS AND ATTACHED RETAINERS WS10-WS14.5 (NUT CHANNEL, 2 EAS, ONE PER SIDE. LT & RT P-SEAL GANG CHANNELS AND ATTACHED RETAINERS WS10-WS14.5 WERE REPLACED PER CRJ-900 SRM51-41-02-001-001-A01.SDR VNA2026F00001Retainer · corrodedCORROSION AT LT & RT P-SEAL GANG CHANNELS AND ATTACHED RETAINERS WS10-WS14.5 (NUT CHANNEL, 2 EAS, ONE PER SIDE. LT & RT P-SEAL GANG CHANNELS AND ATTACHED RETAINERS WS10-WS14.5 WERE REPLACED PER CRJ-900 SRM51-41-02-001-001-A01"SDR VNAA202601280019Bonding Jumper · corrodedCORROSION ON AILERON HINGE FITTING ASSEMBLIES ON SETTLEMENTE AREA OF BODING JUMPERS (4E/A) ON LH WING AND (4E/A) ON RH WING ALSO CORROSION ON HARDWARE TO ATTACH THE SAME BONDING JUMPERS. BONDING JUMPERS P/N MS25083-2BB8 (4E/A) ON RH WING AND BONDING JUMPERSSDR VNAA202601280018Support · corrodedCORROSION ON SUPPORTS ON CROSS BEAM ON FS: 208.00 (1 EA) AND FS: 310.00 (2 EAS) , ALSO FS: 315.00 (1 EA) RBL 5, FS: 349.00 LBL 19 APPROX. CORROSION ON SUPPORTS ON CROSS BEAM ON FS: 208.00 (1 EA) AND FS: 310.00 (2 EAS) , ALSO FS: 315.00 (1 EA) RBL 5, FS: 349.SDR VNAA202601280017Seat Track · corrodedCORROSION ON LH FLOOR SEAT RAILS LBL9 AS FOLLOW; (4E/A) FROM FS349 TO FS677 AND (2E/A) FROM FS677 TO FS954 AT PAX CABIN. DUE TO EXCESSIVE DAMAGE ON LH FLOOR SEAT RAILS LBL9 AS FOLLOW; (4E/A) FROM FS349 TO FS677 AND (2E/A) FROM FS677 TO FS954 AT PAX CABIN. WESDR ABXA20260128034Circuit Card · defectiveDURING TAXI OUT, FWD EQUIP VALVE MSG ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS (BTB). REMOVED & REPLACED EQUIP COOLING INDICATION CARD I.A.W AMM 21-58-24 OPS CHECK GOOD I.A.W AMM 21-58-00 MESSAGE CLEARED, A/C NO ETOPS. AIRCRAFT RETURNED TO SERVICE.SDR VNAA202601280016Seat Track · corrodedCORROSION ON INBD RH FLOOR SEAT RAILS RBL9 AS FOLLOW; (4E/A) FROM FS379 TO FS677 AND (2E/A) FROM FS677 TO FS954 AT PAX CABIN. DUE TO EXCESSIVE DAMAGE ON INBD RH FLOOR SEAT RAILS RBL9 AS FOLLOW; (4E/A) FROM FS379 TO FS677 AND (2E/A) FROM FS677 TO FS954 AT PAXSDR VNAA202601280015Seat Track · corrodedCORROSION ON LH SIDE SEAT RAILS (STGR 15L) AS FOLLOW; (6E/A) FROM FS379 TO FS720, (1E/A) FROM FS744 TO FS761, (1E/A) FROM FS785 TO FS847+5 AND (1E/A) FROM FS847+20 TO FS900 AT PAX CABIN.
CORRECTIVE ACTION: SUMMARY: DUE TO EXCESSIVE DAMAGE ON LH SIDE SEAT RAILSDR VNAA202601280014Seat Track · corroded"DISCREPANCY: CORROSION ON RH SIDE SEAT RAILS (STGR 15R) AS FOLLOW; (6E/A) FROM FS379 TO FS720, (1E/A) FROM FS744 TO FS761 AND (1E/A) FROM FS785 TO FS847+5 AT PAX CABIN.
CORRECTIVE ACTION: SUMMARY:DUE TO EXCESSIVE DAMAGE ON RH SIDE SEAT RAILS (STGR 15R) AS FOSDR VNAA202601280013Web · corrodedCORROSION ON WEB LBL 12 OF THE BULKHEAD FS280.0 AT PASSENGER COMPARTMENT. DUE EXCESSIVE CORROSION ON WEB LBL 12 OF THE BULKHEAD FS280.0 AT PASSENGER COMPARTMENT WAS REPAIRED PER CRJ 900 SRM 53-11-10-201-004-A01.SDR ABXA20260128033Apu · shutdownON TAXI OUT, APU AUTO SHUT OFF 2 TIMES. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED IAW ABX-49-11-1A. AIRCRAFT RETURNED TO SERVICE.SDR VNAA202601280012Drip Tray · corrodedCORROSION ON DRIP TRAY AT FS 280.00 LBL 12 APPROX AT PASSENGER COMPARMENT. DUE TO EXCESIVE DAMAGE ON DRIP TRAY AT FS 280.00 LBL 12 APPROX AT PASSENGER COMPARMENT WAS EVA LUATED OUT OF LIMITS PER CRJ 900 SRM 53-00-00-101-001-A01, REPLACED PER CRJ-900 SRM 51-4SDR ABXA20260128032Warning Message · false activationON TAXI OUT, FWD EQPT VALVE MESSAGE ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE PERFORMED FIM 21-58, TASK 805. MSG CLEARED, A/C OK FOR SERVICE.SDR DALA2026012800659Engine · damagedATB DUE TO RIGHT ENGINE STALL ON TAKEOFF. PERFORMED BORESCOPE AND FOUND VIGV AND STAGE 1 LPC BLADE DAMAGE. REPLACED RIGHT ENGINE. (LP 8432570)SDR VNAA202601280011Channel · corrodedCORROSION ON SUPPORT ANGLE, FS280.0 BTW LBL11 TO RBL 11 AT COCKPIT FLOOR STRUCTURE. CORROSION ON SUPPORT ANGLE, FS280.0 BTW LBL11 TO RBL 11 AT COCKPIT FLOOR STRUCTURE WAS EVALUATED OUT OF LIMITS PER CRJ-900 SRM 51-10-06-001-001-A01, REPLACED PER CRJ900 SRM 5SDR ICRR202601280001Bushing · crackedCRACK WAS FOUND ON BUSHING DURING RECEIVING INSPECTIONSDR VNAA202601280010Channel · corrodedCORROSION ON CHANNEL OF TCAS ANTENNA BTW FS295.0 TO FS310.0 BTW S-26L TO S-26R AT MAIN AVIONCS COMPARTMENT. CHANNEL OF TCAS ANTENNA BTW FS295.0 TO FS310.0 BTW S-26L TO S-26R AT MAIN AVIONCS COMPARTMENT WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01"SDR ABXA20260128031Warning Message · illuminatedON TAXI OUT, AFTER CROSS BLEED ENGINE START, HAD LEFT BLEED INOP AND LEFT PACK INOP INDICATIONS. AIRCRAFT RETURNED TO BLOCKS (BTB). PERFORMED OPS CHECK OF LT ENG BLEED AIR. OPS CK GOOD IAW B767 AM 36-11-00. AIRCRAFT REMAINS NO ETOPS. AIRCRAFT RETURNED TO SDR VNAA202601280009Fitting · corrodedCORROSION ON FITTINGS 2EA BTW FS 349 TO FS 364 AND STRG 25LH TO STGR 27 AT AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE. CORROSION ON FITTING 1EA BTW FS 349 TO FS 364 AND STRG 26LH AT AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE WAS REMOVED PER CRJ 900 SRM 51SDR VNAA202601280008Bracket · corrodedCORROSION ON BRACKET'S MACHINED BTW FS 515 STGR 22LH TO STGR 23LH, FS 515 STGR 26LH TO STGR 27,FS 629 STGR 26LH TO STGR 27,FS 661+8 STGR 22LH TO 23LH AND FS 661+8 STGR 26LH TO STGR 27 AT FWD BAGGAGE COMPARTMENT. BRACKET'S MACHINED BTW FS 515 STGR 22LH TO STGSDR DALA2026012800657Repair · no discrepancySHIP 3320 FOUND FUSELAGE SKIN FR 75 -FR76 BETWEEN STR45L AND49L EXISTING DOUBLER REINFORCING REPAIR. CORRECTIVE ACTION: PERFORMED PERMANENT SKIN REPAIR FOR PREVIOUS REPAIR AREA AT FR75-FR76 BETWEEN STGR 45L AND STGR 49L PER A330 SRM 53-41-11-300-015. (1423155)SDR DALA2026012800656Floor Support · corrodedCABIN FWD GALLEY FLOOR SUPPORT AT FR 13A Y300 FOUND WITH CORROSION. REPLACED THE DAMAGED FLOOR SUPPORT AT FR 13A Y300 PER A330 SRM 51-72-11-911-001. (1423106)SDR DALA2026012800655Floor Support · corrodedCABIN FWD GALLEY FLOOR SUPPORT AT FR 13A Y550 FOUND WITH CORROSION. REPLACED THE DAMAGED FLOOR SUPPORT AT FR13A Y550 PER A330 SRM 51-72-11-911-001. (1423095)SDR DALA2026012800654Cross Bar · corrodedRIGHT AFT CABIN 01EA FLOOR SUPPORT/CROSS BEAM AT FR 73+10 INCHES, -YB TO -YC1 FOUND HEAVY CORROSION. REPLACED THE DAMAGED SUPPORT BEAM AT -YB TO -YC1 FR73+10 INCHES PER A330 SRM 51-72-11-911-001. (1423061)SDR DALA2026012800653Crossbeam · corrodedRIGHT AFT CABIN ONE FLOOR SUPPORT/CROSS BEAM AT FR73+10 INCHES, -YA TO -YB1, FOUND WITH HEAVY CORROSION. REPLACED THE DAMAGED SUPPORT BEAM AT -YA TO -YB1 FR73+10 INCHES PER A330 SRM 51-72-11-911-001. (1423049)SDR DALA2026012800652Seat Track · corrodedSEAT TRACK-AFT CABIN FLOOR LONGERON AT Y381 FR 75-79 UPPER SURFACE FOUND WITH CORROSION. REPLACED THE DAMAGED LONGERON BEAM AT Y381 FR75-78 PER A330 SRM 51-72-11-911-001. (1423031)SDR VNAA202601280007Hydraulic Line · corrodedCORROSION ON THE HYDRAULIC LINES AND ELECTRICAL HARNESSES SUPPORTS (3EAS) AT LH MLG WW. HYDRAULIC LINES AND ELECTRICAL HARNESSES SUPPORTS (3EAS) AT LH MLG WHEEL CRJ-900 SRM 51-42-21-001-001-A01, SRM 51-42-06 001-001-A01 AND SRM 51-41-02-001-001-A01.SDR VNAA202601280006Skin · corrodedCORROSION ON EXTERNAL SKIN OF FUSELAGE ON STGR 16RH BTW FS629.00 & FS645.00, FS661.00+16.00 & FS661.00+32.00 BTW STGR 26RH & STGR 27, FS661.00+16.00 BTW STGR 3RH & STGR 3LH AND FS1015.00 & FS1031.00 BTW STGR 23RH & STGR 24RH. CORROSION ON EXTERNAL SKIN OF FUSSDR VNAA202601280005Angle · corrodedCORROSION ON MIDCAP ANGLE AT DOOR (L1) SURROUND STRUCTURE. MIDCAP ANGLE AT DOOR (L1) SURROUND STRUCTURE WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SRM 51-41-02-001-001-A01.SDR VNA2026F00000Angle · corrodedCORROSION ON MIDCAP ANGLE AT DOOR (L1) SURROUND STRUCTURE. MIDCAP ANGLE AT DOOR (L1) SURROUND STRUCTURE WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SRM 51-41-02-001-001-A01"SDR VNAA202601280004Angle · corrodedCORROSION ON KICKPLATE ANGLE AT DOOR (L1) SURROUND STRUCTURE. DUE TO EXCESSIVE DAMAGE ON KICKPLATE ANGLE AT DOOR (L1) SURROUND STRUCTURE WAS REPLACED PER CRJ-900 SRM 51-10-06-001-001-A01, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01.SDR VNAA20260128000Hydraulic Line · corrodedCORROSION FOUND ON THE THREE HYDRAULIC LINES AND ELECTRICAL HARNESSES SUPPORTS ON RH MLG WHEEL WELL FORWARD SIDE. HYDRAULIC LINES SUPPORTS BRACKETS 3 E/A'S, FS797 (RT MLG WHEEL WELL) WERE REPLACED PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SRMSDR VNAA202601280002Cowling · damagedTEMPORARY REPAIR TO THE LH LOWER FORWARD CORE COWL INBOARD LOWER Z-DISHING AND FIRE SHIELD THE FOLLOWING TEMPORARY REPAIR IS VALID FOR A MAXIMUM OF 8000 FLIGHT HOURS FROM THE TIME OF INCORPORATION OF THIS REO AT REV -. LEFT LOWER FORWARD CORE COWL INBD LOWERSDR VNAA202601280001Hinge Fitting · wornFREE PLAY ON SELF-ALIGN SELF-LUB BEARING PLAIN ON HINGE FITTING NR 2 AND NR 3 AT VERTICAL STABILIZER REAR SPAR MIDDLE SECTION. HINGE FITTING NR 2 AND NR 3 AT VERTICAL STABILIZER REAR SPAR MIDDLE SECTION WERE REPLACED IAW SRM 51-42-21-001-001-A01 AND RIL 2103 SDR YENA2026012800077Fcu · failedFLT 2124. LAX-JFK ( ETOPS). CAT II STATUS MSG ( CATEGORY IIIB NOT AUTHORIZED ).;AUTOTHRUST FUNCTION INOP ( AUTOTHRUST FUNCTION WITH SOFT GO-AROUND ). REMOVED AND REPLACED FCU PER AMM 22-81-12. OPS CHKD GOOD . MDDR CLEARED MX-4 UPDATED PLACARD REMOVED.