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 SWI2025F01448Frame · corrodedUPON REPEAT INSPECTION FOUND CORROSION ON PREVIOUS REPAIRED LOCATIONS, FS 439, FS 500. (C-CHECK RO 10/19/2025)REMOVED CORROSION ON LHS PREVIOUS REPAIRED LOCATIONS AT FS 439 AND FS 500 IAW BOMBARDIER REO # 601R-53-41-666 REV C DATED 2012-11-06. COMPLETED TASKSDR SWIA2025102000812Floor Support · corrodedUPON REPEAT INSPECTION OF L/H FLOOR SILL FOUND CORROSION ON PREVIOUS REPAIRED LOCATIONS, FS 428, FS 518, AND 541 AROUND SCREW HOLES. (C-CHECK RO 10/19/2025)REMOVED CORROSION FROM LH FLOORSILL AT FS 428, 518, AND 541 AND FOUND IN LIMITS IAW REO 601R-53-41-666SDR SWAA2025092603529Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON FORWARD ENTRY DOOR LINING AT FORWARD GALLEY AREA (4EA). REPLACED ASSIST HANDLE NUT ON FORWARD ENTRY DOOR LINING AT FORWARD GALLEY AREA (4EA) IAW AMM 25-21-31-420-802 STEP 3.B.(6).SDR SWAA2025092603530Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON FORWARD ENTRY DOORWAY LINING AT FORWARD GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ON FORWARD ENTRY DOORWAY LINING AT FORWARD GALLEY AREA (2EA) IAW B737-800 AMM 25-21-31-420-802 STEP 3.B.(6). THE INSTALLATION WILL BE DOCUMSDR SWAA2025092603533Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON AFT ENTRY DOORWAY LINING AT AFT GALLEY AREA (2EA REPLACED ASSIST HANDLE NUT ON AFT ENTRY DOORWAY LINING AT AFT GALLEY AREA (2EA) IAW B737-800 AMM 25-21-25-420-801 STEP 3. B.(5) THE INSTALLATION WILL BE DOCUMENTED ON TTG8R008EHSDR SWAA2025092603534Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON AFT ENTRY DOOR LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ON AFT ENTRY DOOR LINING AT AFT GALLEY AREA (2EA) IAW B737-800 AMM 52-13-31-400-802 STEP 3.G.(2).SDR SWAA2025092603531Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON FWD SERVICE DOOR LINING AT FWD GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ON FWD SERVICE DOOR LINING AT FWD GALLEY AREA (2EA) IAW B737-800 52-41-31-400-802 STEP 3.F.(2).SDR SWAA2025092603536Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON AFT SERVICE DOORWAY LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ON AFT SERVICE DOORWAY LINING AT AFT GALLEY AREA (2EA) IAW B737-800 AMM 25-21-25-420-801 STEP 3. B.(5).SDR SWAA2025092603532Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ON AFT SERVICE DOOR LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ON AFT SERVICE DOOR LINING AT AFT GALLEY AREA (2EA) IAW B737-800 AMM 52-41-31-000-802 STEP 2. D.(4) AND AMM 52-41-31-400-802 STEP 3. F. (2).SDR VNAA202509260002Brake · corrodedDURING REMOVAL OF MLG RH SHOCK STRUCT IN REFERENCE TASK CARD:32-079-003-19-RH CORROSION WAS FOUN ON BRAKE TAKE OUT RINK MLG RH. PIN, BRAKE TORQUE TAKE-OUT MLG RH WAS VERIFIED (P/N:49231-3 S/N: ACR110787) PER CRJ 700 IPC 32-11-39 AND MUST BE INSTALLED WITH JOBSDR VNAA202509260001Skin · mechanic errorLH PYLON ACCESS PANEL 412HB MISDRILLED. GENERATE NEW RFTS REQUEST AND PROVIDE A DETAILS DAMAGE REPORT REQUESTING PERMANENT DISPOSITION. LT PYLON ACCESS PANEL 412HB MISDRILL WAS REPAIRED PER REO 670-54-51-084 REV.--SDR SWAA2025092303342Stub Frame · crackedCRACK INDICATION FOUND ON STUB FRAME LOCATED ON BS 296.5 BTW S8R - 9R AT FWD GALLEY DOOR AREA. REPLACED STUB FRAME IAW SRM 51-40-02-0G-0, AND DWG 141A8370, SHEET 10, REV D.SDR SWAA2025092203341Bear Strap · crackedCRACK INDICATION FOUND ON BEAR STRAP LOCATED BS 294.5 BETWEEN S-8R TO S-9R AT FWD GALLEY DOOR AREA. REPAIRED IAW SRM 53-10-01-2R-6 AND EA M-25-153-01539.SDR SWAA2025092203678Floor Panel · peelingPEELED SURFACE ON FLOOR PANEL 120BF INCLUDING FLOOR PANEL 120CF FWD CARGO COMPARTMENT. APPLIED PROTECTIVE TREATMENT ON FLOOR PANEL 120BF AND 120CF IAW SRM 51-20-01-0G-0.SDR IXXA20250921001Skin · gougedBULK CARGO COMPARTMENT DOOR EXTERIOR SKIN, FWD LOWER CORNER EXISTING REPAIR IS GOUGED ON THE EXTERNAL SURFACESDR JJBA20250916022Support · corrodedCENTER FUSELAGE IV. LH SILL CORRODED BTW FRAME 60-61. CENTER FUSELAGE IV, LH SILL CORRODED BTW FRAME 60-61 BLENDED OUT OF LIMIT. CENTER FUSELAGE IV, LH SILL AT FR 60-61 REMOVED AND REPLACEDSDR SWAA2025091503810Skin · delaminatedLEFT WING OTBD AFT FLAP INBD UPPER SURFACE DELAMINATED. REMOVED AND REPLACED THE LT WING OTBD AFT FLAP IAW AMM 27-51-22-000-801, AND AMM 27-51-22-400-801.SDR SWAA2025091503714Support · crackedLH WING TO BODY FAIRING SUPPORT HAS CRACKED AROUND THE FASTENER. REMOVED AND REPLACED LT WING TO BODY FAIRING SUPPORT IAW SRM 51-40-02 AND DWG 116A3010 ID: 0039 REV -.SDR SWAA2025091203774Floorbeam · crackedCRACKED PANEL BREAK AT PASSENGER COMPARTMENT BS 540; RBL 2; WL 208. REMOVED PANEL BREAK ASSY AT STA 520; RBL 1-24 PER SRM 51-40-02-0G-0. REMOVED AND REPLACED PANEL BREAK AT PASSENGER COMPARTMENT BS 540; RBL 2; WL 208 IAW SRM 51-40-02-0G-0.SDR AALA202509116331Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 947, LBL 8. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5 AND EA 367489.SDR AALA202509115803Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT INBOARD AFT LAVATORY MOUNT, LOCATED AT BS 947 FROM RBL 15 TO LBL 47. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5 AND EA 367489.SDR FDEA202508121408Skin · crackedNDT INSP FOUND RH WING CENTER FLAP TOP SKIN FLANGE RIB26 STGR2.7 AND STGR 2.8 CRACKED COMPLIED WITH EA: 6-5750-T0384484 P1, TITLE: WINGS - FLIGHT SURFACES - RH CENTER FLAP - CRACK IN UPPER FLANGES OF RIB 26 REPAIRED THE CRACKED RIB UPR FLANGE AT RH WING SDR SWAA2025090903709Stub Frame · crackedCRACK NOTED ON R1 DOOR CUT OUT STUB FRAME BS 291.5+5, 0.75' ABOVE SEAL DEPRESSOR, L: 0.9'. REMOVED UPPER FWD R1 DOOR STUB FRAME IAW SRM 51-40-02. LOCATED, & DRILLED NEW STUB FRAME IAW SRM 51-40-05, AND DWG 141A8370, REV C. INSTALLED FSD UPPER STUB FRAME ANDSDR SWAA2025090903524Stringer Clip · crackedCRACK ON STRINGER CLIP AT BS787 S6L. REMOVED AND REPLACED STRINGER CLIP IAW SRM 51-40-05-0G-0 AND DWG 146A1133.SDR SWAA2025090903525Stringer Clip · crackedCRACK ON STRINGER CLIP AT BS 727E, S6L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0 AND DWG 146A1112.SDR SWAA2025090903705Stringer Clip · crackedCRACK ON STRINGER CLIP AT BS727D S-7L. REMOVED AND REPLACED STRINGER CLIP IAW SRM 51-40-02-0G-0 AND DWG 146A1111.SDR SWAA2025090903706Stringer Clip · crackedCRACK ON STRINGER CLIP AT BS706 S-4L. REMOVED AND REPLACED STRINGER CLIP BS 706 S-4L IAW SRM 51-40-02-0G-0 AND DWG 144A1107.SDR SWAA2025090903707Stringer Clip · crackedCRACK ON STRINGER CLIPS AT BS 727B, S6R. REMOVED AND REPLACED NEW ON STRINGER CLIPS IAW SRM 51-40-02 AND DWG 146A1102 ID: 0001 REV: DSDR SWAA2025090903704Stringer Clip · crackedCRACK ON STRINGER CLIPS AT BS 727B S-5R. REMOVED AND REPLACED NEW ON STRINGER CLIP IAW SRM 51-40-02 AND DWG 146A1102 0001 REV: D.SDR JJBA20250909008Crossbeam · corrodedCF1, CENTER CROSSBEAM AT FR20 FOUND CORRODED. CF1 CENTER CROSSBEAM AT FR20 BLENDED AND FOUND OUT OF LIMIT. CF1 CENTER CROSSBEAM AT FR20 INSTALLEDSDR IXXA20250909007Channel · crackedNO. 1 PYLON FAIRING 437DB, OUTBOARD CHANNEL ON BULKHEAD IS CRACKEDSDR SWAA2025090803708Seat Track · crackedFIRST OFFICER`S INBD FWD SEAT TRACK CRACKED. REPLACED F/O'S INBD FWD SEAT TRACK IAW AMM 25-11-11-400-801.SDR SWAA2025090803538Access Panel · delaminatedDELAMINATED ACCESS PANEL 191FL BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 191FL BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-04-2R-6 REPAIR 6 AND SRM 51-70-04-2R-0 REPAIR GENERAL.SDR SIMA2025090812003Seat Track · gougedRIGHT UPPER SEAT TRACK CHAFED AND GOUGED BETWEEN FR 23-24. (MAJOR REPAIR) REMOVED DAMAGED AREA ON RH UPPER SEAT TRACK BETWEEN FR 23-24 IAW ETD2025-170-926989. FABRICATED AND INSTALLED FILLER AND SPLICES ON RH UPPER SEAT TRACK BETWEEN FR 23-24 IAW ETD2025-170-9SDR IPXA2025082834493Hydraulic System · leakingFWD CARGO COMPARTMENT CENTER BILLIAGE AREA INSULATION SATURATED WITH SKYDROLL. CLEANED UNDER FWD CARGO BILLIAGE AREA FROM FR27 TO FR37 WITH 1/4 GAL IAW AMM 12-21-12/201.TREATED FOR CORROSION 2 IAW SRM 51-23-20. REPLACEED 50 FT OF INSULATION IAW AMM 25-50-21SDR SWAA2025090503733Floor Panel · delaminatedDELAMINATED FLOOR PANEL 232RF AT PASSENGER CABIN. REPAIRED FLOOR PANEL 232RF AT PASSENGER CABIN IAW B737-700 SRM 53-00-50-2R-1 REPAIR 1 AND B737-700 SRM 53-00-50-2R-0 REPAIR GENERAL.SDR SWAA2025090503378Battery Pack · inoperativeINOP BATTERY PACK ON LOWER CEILING RT SIDE AT FWD GALLEY AREA. REMOVED AND REPLACED BATTERY PACK ON LOWER CEILING RT SIDE AT FWD GALLEY AREA IAW AMM 33-51-06-960-805 AND PERFORMED TEST THE NEW BATTERY PACK IAW AMM 33-51-06-960-805.SDR ASAA2025081260556Web · corrodedFWD CARGO DOOR SCUFF PLATE SUB FRAME HAS CORROSION IN MULTIPLE LOCATION. GROUNDED - YES. REMOVED CORROSION ON FWD CARGO THRESHOLD WEB ORIGINAL THICKNESS .045, REMOVED .012, REMAINING .033, FOUND TO BE OUT OF LIMITS IAW B737-900ER SRM 53-30-15. REMOVED DAMAGE WSDR SWAA2025090403537Scuff Plate · crackedCRACK ON FWD CORNER SCUFF PLATE LOCATED AT FWD CARGO COMPARTMENT. REPAIRED FWD CORNER SCUFF PLATE LOCATED AT FWD CARGO COMPARTMENT IAW SRM 53-30-15-2R-1 REPAIR 1.SDR SWAA2025090403739Floor Panel · delaminatedDELAMINATED FLOOR PANEL 231YF AT PASSENGER CABIN. REPAIRED FLOOR PANEL 231YF AT PASSENGER CABIN IAW B737-700 SRM 53-00-50-2R-1 REPAIR 1 AND B737-700 SRM 53-00-50-2R-0 REPAIR GENERAL.SDR SWAA2025090403741Floor Panel · delaminatedDELAMINATED FLOOR PANEL 242BF AT PASSENGER CABIN. REPAIRED FLOOR PANEL 242BF AT PASSENGER CABIN IAW SRM 53-00-50-2R-1, REPAIR 1, AND SRM 53-00-50-2R-0, REPAIR GENERAL.SDR IPXA2025090435309Panel · crackedNUMBER 2 PYLON VENT PANEL 443CR HAS A CRACK IN UPPER FWD CORNER. ACCOMPLISHED DVI IAW EO B757-5450-82780-A STEP 4(I). FASTENERS ARE IN SERVICEABLE CONDITION.SDR JJBA20250904003Support · corrodedRIGHT SIDE SILL BTW FR 22-24 FOUND CORRODED. CF1, RH SIDE SILL BTW FR 22-24 BLENDED OUT OF LIMIT. SILL REMOVED AND REPLACED.SDR ASAA2025081260448Transition Panel · corrodedAFT CARGO COMPARTMENT LT FLOOR TRANSITION PANEL, BS 727I+9 TO TO 847, LBL.21. UPPER AND LOWER SURFACE HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION, ORIGINAL THICKNESS .040, REMOVED .040, REMAINING .000. FOUND TO BE OUT OF LIMITS IAW SRM 53-SDR ASAA2025081260446Transition Panel · corrodedAFT CARGO COMPARTMENT, RT FLOOR TRANSITION PANEL TO BS 727 TO 727I+9, RBL21, UPPER AND LOWER SURFACE HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION, ORIGINAL THICKNESS .040, REMOVED .040, REMAINING .000. FOUND TO BE OUT OF LIMITS IAW SRM 53-00SDR ASAA2025081260445Transition Panel · corrodedAFT CARGO COMPARTMENT LT FLOOR TRANSITION PANEL TO BS 727 TO 727I+9, LBL21 UPPER AND LOWER SURFACE HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION, ORIGINAL THICKNESS .040, REMOVED .040, REMIANING .000. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-SDR ASAA2025081260444Transition Panel · corrodedAFT CARGO COMPARTMENT RT FLOOR TRANSITION PANEL BS 7271+9 TO BS 767, RBL21 UPPER AND LOWER SURFACE HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION, ORIGINAL THICKNESS .040, REMOVED .040, REMAINING .000. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1SDR ASAA2025081260443Threshold Web · corrodedAFT CARGO HAS CORROSION AT DOOR THRESHOLD. GROUNDED - YES. REMOVED CORROSION ON AFT CARGO DOOR THRESHOLD WEB ORIGINAL MAT. THICKNESS .050, MATERIAL REMOVED .026 MATERIAL REMAINING .024. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15. REPLACED AFT CARGO THRESHOLD SDR 2025F00211Guide · missingFOUND G1000 GUIDE MISSING, RETURNED TO GATE AND MX REPLACEDSDR SWIA2025090200012Slat Track · chafedRIGHT SLAT NR 4 TRACK RIB 8, INTERNAL OF SLAT CHAFED. REMOVED AND REPLACED RT SLAT PANEL NR 4 IAW AMM 27-81-08 & 30-11-06.