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 YENA2025111901112Unknown · odorFLT#860, PHX-FLL. DESCENDING BELOW 10,000FT MODERATE ODOR UNTIL PARKING AT THE GATE NOTICED IN COCKPIT AND THROUGHOUT CABIN. OPEN.SDR N6WA2025111908Floorbeam · corrodedCORROSION ON ANGLE AT FS280 BETWEEN RBL12-LBL12. REMOVED AND REPLACED ANGLE AT FS280 BETWEEN RBL12-LBL12 IAW CRJ SRM 51-42-06SDR YENA2025111901111Unknown · odorFLT#1891, PVD-RSW. DIRTY SOCK ODOR IN AFT CABIN REPORTED BY INFLIGHT DESCENDING THROUGH 10,000 FT. NO ODOR OBSERVED IN COCKPIT.SDR N6WA2025111907Angle · corrodedCORROSION ON ANGLE AT FS259.16-FS280 AT RBL12. REMOVED AND REPLACED ANGLE AT FS259.16-FS280 AT RBL12 IAW CRJ SRM 51-42-06SDR VNAA2025111911102Warning Message · false activationLEFT PACK TEMP AN RT PACT TEMP CAUTION IN FLIGHT. UNPRESSURIZED CHECKLIST RTF. PERFORMED OPS CHECK OF TEMP CONTROL PANEL IN MANUAL MODE IAW AMM 21-61-02. OPS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIME.SDR VNAA2025111911101Warning Message · false activationRTF-AFT CARGO DOOR CAUTION MSG AFTER TAKE OFF. PERFORMED OPS TEST OF AFT BAGGAGE DOOR IAW AMM 52-31-00-710-801.SDR N6WA2025111906Angle · corrodedCORROSION ON ANGLE AT FS259.16-FS280 AT LBL12. REMOVE AND REPLACED ANGLE AT FS259.16-FS280 AT LBL12 IAW CRJ SRM 51-42-06SDR N6WA2025111905Floorbeam · corrodedCORROSION ON ANGLE AT FS260 BETWEEN RBL12-LBL12. REMOVED AND REPLACED ANGLE AT FS260 BETWEEN RBL12-LBL12 IAW CRJ SRM 51-42-06SDR AALA202511195066Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL OVERHANG LOWER SURFACE AT LEVEL RIB 15. REPAIRED SKIN PANEL PER EA 368796.SDR AALA202511190754Chiller · odorAIRCRAFT WAS GROUNDED: AT CRUISE ALTITUDE FLIGHT ATTENDANTS REPORTED A BURNING SMELL COMING FROM THE AFT GALLEY CENTER METAL STORAGE BOX AREA. FLIGHT ATTENDANTS TURNED OFF THE MASTER GALLEY SWITCH AND THE SMELL WAS ELIMINATED. MAINTENANCE FOUND AFT GALLEY CHILSDR SCNA20251119446Glowstrip · dirtyREMOVE & INSTALL AND CLEAN PHOTOLUMINESCENT FLOOR PROXIMITY STRIPS AND REPLACE AS REQUIRED. OPENSDR SCNA20251119445Retainer · looseLOOSE FASTENERS ON GIRT BAR RETAINER CLIPS OF EMERGENCY ESCAPE SLIDE AT FWD PASSENGER L1. OPENSDR CALA2025111911348Unknown · odorDUR FLT FAINT SMOKE SMELL BTW ROWS 12-21 AIRCRAFT LEFT. SMELL DISSIPATED AFTR 5 MINS FLIGHT AND CABIN CREW COMPLETED FORM 46-6020. DEBRIEFED FLIGHT AND CABIN CREW ON ASSOCATED SMOKE/ODOR IN CABIN. INSPECTED AREAS SUSECTED TO CAUSE CONCERN REF AMM TASK 05-51-SDR CALA2025111911345Deck Plate · corrodedFWD EDGE OF DECK PLATE AT STA 1681 HAS CORROSION IN SEVERAL AREAS. SEE IMAGES. REPLACED DECK PLATE PER BOEING DWG NO:. 146N300 AND BOEING 757 SRM 51-40-02SDR CALA2025111911343Floorbeam · corrodedCORROSION FOUND AROUND NUPLATE HOLE ON UPPER PART OF FLOOR BEAM AT STA 1681 RBL-32 PERFORMED BOEING 757 SRM 53-60-51-2R-3 REPAIR COMPLETED BOEING 757 SRM 53-60-51-2R-3 REPAIRSDR SCNA20251119444Light · unsecureFLOOR STRIP IN AISLE ROW 12ABC NEEDS TO BE SECURED. SECURED LIGHT STRIP IAW AMM 33-51-15.SDR SCNA20251119443A/C Pack · odorSMOKE AND FUMES IN CABIN WHEN PACKS SELECTED ON. DUCT PRESSURE 10 PSI. DUCT SUPPLY TEMP 120. FOLLOWED FIM 21-00 TASK 806, INSPECTED APU FOR OVER SERVICING AND OIL CONTAMINATION IN THE BLEED AIR SYSTEM AND FOUND NO CONTAMINATION OF OVER SERVICING. INSPECTED LHSDR HNAA2025111900750Cart · odorODOR EMINATING FROM G1 CREW CLOSET BOTTOM. INSPECTED COAT CLOSET ELECTRICAL COMPARTMENT FOUND ALL COMPONENTS AND WIRING IN GOOD CONDITION. CLEANED GALLEY CART STORAGE. ERADICATED THE ODOR FROM GALLEY ACFT OK FOR STORAGE AT THIS TIME.SDR MASA2025111800094Brake · malfunctionedEMERGENCY BRAKE NOT HOLDING. PERFORMED OPS CHECK OF EMERGENCY PARKING BRAKE. OPS CHECKED GOOD.SDR JR2R20251118258Skin · erodedRIGHT WING SLAT 4 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251118107Skin · erodedRH WING SLAT 4 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251118105Skin · erodedRH WING SLAT 3 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251118104Skin · erodedRH WING SLAT 2 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGESDR JR2R20251118103Skin · erodedRIGHT WING SLAT 1 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251118102Skin · erodedLEFT WING SLAT 4 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251118101Skin · erodedLEFT WING SLAT 3 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251118100Skin · erodedLEFT WING SLAT 2 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR 2025FA0000766Air Box · crackedAIRBOX CRACKED, FOUND DURING SCHEDULED INSPECTIONSDR JR2R20251118199Skin · erodedRIGHT WING SLAT 1 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR DALA2025111808414Hinge · corrodedFOUND CORROSION ON LT MLG ACTUATING CYLINDER INBOARD HINGE. COMPLIED WITH ER/A 630497- 14. (1309462).SDR DALA2025111808429Tee Angle · damagedFRAMES 61 - 62 LT TEE ANGLE BETWEEN STRINGERS 2 - 3L DAMAGED. REPLACED IAW ERA 628197-14 REV O. (1309485)SDR AALA202511189942Life Raft · low pressureAIRCRAFT WAS NOT GROUNDED: FIRST CLASS FORWARD LIFE RAFT PRESSURE OUT OF LIMITS. REMOVED AND REPLACED LIFE RAFT. PER AMM 25-64-00.SDR 2025FA0000764Brake Disc · shearedPILOT REPORTED THAT AFTER LANDING AND EXITING THE RUNWAY, HE ATTEMPTED TO MAKE A LEFT TURN ON A TAXIWAY USING DIFFERENTIAL BRAKING. HE STATED HE HEARD A POPPING SOUND AND LOST EFFECTIVE BRAKING OF THE LEFT BRAKE. WE BROUGHT PLANE IN FOR MAINTENANCE TO CORRECT SDR DALA2025111808412Brake · overtempATO - BELOW AT 30KTS DUE TO A BRAKES HOT MESSAGE. #2 BRAKE TEMP AT 350C. REPLACED LT GEAR BTMU DUE TO A FAULTY HARNESS. (LP 7971108)SDR FDEA202511182189Structure · no discrepancyWE HEARD A LOUD BANG IN FLIGHT AT THE TOP OF DESCENT. THE SAME NOISE OCCURRED SEVERAL MORE TIMES AT THE BEGINNING OF EACH DESCENT. UPON INSPECTION AFTER LANDING, THE DEMI CAN IN POSITION 7D WAS NOT PROPERLY SECURED AND IT WAS SLIDING BACK AND FORTH DURINGSDR KCSA202511181225Structure · crackedWHILE WORKING AD 2016-25-05 G2/SB 747-55A2050, FOUND 2EA HOLE CRACKED AT HORIZONTAL STAB CENTER SECTION I/B OF LBL 43.5SDR DALA2025111808404Mount · corrodedG2 GALLEY MOUNT FOOTING EXFOLIATED CORROSION. GALLEY SUPPORT REPLACED ON NR 186.SDR DALA2025111808403Threshold · gougedG1 THRESHOLD CORROSION AND GOUGED. REPLACED THRESHOLD REF B737 AMM 25-11-04.SDR DALA2025111808406Battery Pack · no testEMERGENCY ISLE LIGHTS ROW 11DEF TO 17DEF INOP. R & R BATTERY PACK SUPPLY PER B737 AMM 33-51-06. OPS CHECK GOOD.SDR DALA2025111808405Battery Pack · no testLEFT INTERIOR OVERWING EMERGENCY LIGHTS INOP. R & R BATTERY PACK SUPPLY PER B737 AMM 33-51-06. OPS CHECK GOOD.SDR DALA2025111808402Battery Pack · no testEMERGENCY EXIT PATHWAY LIGHTS INOP FROM ROW 19 TO ROW 21. REMOVED AND REPLACED BATTERY PACK ASSY AT SEAT 19ABC PER B737 AMM 33-51.SDR DALA2025111808401Battery Pack · inoperativeON SVC CHECK FOUND FIRST CLASS EMERGENCY LIGHTS INOP. R & R BATTERY PACK (M2816) IAW B737 AMM 33-51. OPS TEST GOOD.SDR DALA2025111808399Angle · corrodedFWD CARGO BS 500L, FLOOR TO BLKHD ANGLE CORRODED STR 25L TO 25R. REMOVED AND REPLACED ANGLE AT FLOD CARGO STA500L FLOOR TO BULKHEAD ANGLE STR 25L-25P. IAW B737-900 SRM 51-40-02.SDR KCSA202511181224Frame · crackedSTA 2231 AT L5 DOOR STRG 17L FRAME STRAP AND AFT INNER CHORD CRACKEDSDR 2A6R2025111804604Angle · damagedDAMAGE WAS IDENTIFIED ON THE ATTACHMENT ANGLE (PN 350A21-4064-21), AS ILLUSTRATED IN FIGURE 1 OF DOCUMENT 17-5300-EA-5339, REV. –. THE DAMAGED COMPONENT, LOCATED BENEATH THE MAIN CABIN FLOOR AT BS 845 AND SHOWN IN THE SAME FIGURE, COULD NOT BE OBTAINED IN TIMESDR JGVR20251118001Skin · corrodedBLENDED CORRODED AREA ON THE OUTER SKIN OF THE EMERGENCY EXIT DOOR IN THE LOWER AFT CORNER, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED AREA PER NETJETS REQUEST FOR TECHNICAL SERVICES REPORT.SDR SWIA2025111776571Doubler · crackedSUSPICIOUS CRACK ON PAX DOOR FWD PULL IN CAM DOUBLER. REMOVED AND INSTALLED NEW PAX DOOR FWD PULL IN CAM DOUBLER IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG 601R31702 REV. N AND COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025111776569Frame · corrodedMAIN AVIONICS FRAME BS 349 HAS CORROSION BETWEEN S26L - S25L. INSTALLED NEW MAIN AVIONICS FRAME BS 349 BETWEEN S23L -24R IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG SH690-31350 REV. M. LEAK CHECK GOOD, COMPLIED WITH SKYWEST TASK CARD 51-900SDR SWIA2025111776526Intercostal · crackedSUSPICIOUS CRACK ON PAX DOOR FWD DD1 INTERCOSTAL. REMOVED AND INSTALLED NEW FWD DD1 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2026070676514Doubler · crackedSUSPICIOUS CRACK ON PAX DOOR AFT PULL IN CAM DOUBLER. REMOVED AND INSTALLED NEW PAX DOOR FWD PULL IN CAM DOUBLER IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH TASK CARD 51-900-1002-SKY.