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 SWAA2025122254866Brake · fireRIGHT BRAKE CAUGHT FIRE DURING TAXI OUT. ACCOMPLISHED BRAKE SEIZURE CONDITIONAL INSPECTION IAW AMM 05-51-15. FOUND SIGNS OF OVERHEATING ON RT MLG AXLE INTERIOR AND EXTERIOR. NO DAMGE NOTED TO WHEEL SPEED SENSOR WIRING IAW AMM 05-51-07, HIGH ENERGY STOP CONDSDR GTIA2025122239219A/C Pack · odorPILOT REPORTED, JUST BEFORE APPROACH FA CALLED TO REPORT FUMES IN FRONT AND BACK OF CABIN. PERFORMED ODOR IDENTIFICATION IAW TSM 05-50-00-810-831-A. SUSPECT PACK 1 TO BE CAUSE OF ODOR.SDR SWI2025F01848Windshield · crackedRIGHT WINSHIELD ARCING AND WIRES GLOWING, CRACK APPEARED, QRH COMPLETED. (FLIGHT 6290 - FILED OPEN)REMOVED AND REPLACED FO WINDSHIELD WITH A SERVICEABLE UNIT PER CRJ700 AMM 56-11-01. PREFORMED PRESSURIZATION OF THE AC FOR LEAK CHECK PER CRJ700 AMM 21€“31€“0SDR SWIA202512220001Warning Message · illuminatedGEAR DISAGREE WARNING ON DEPARTURE NOSE GEAR DOWN WHILE BOTH MAINS WERE UP. RAN QRH AND EXTENDED GEAR FOR LANDING SUCCESSFULLY. (FLIGHT 5442 - FILED CLOSED) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31401093 WITH THE FOLLOWING CORRECTIVE ACTION: "SEE CP SDR DALA2025122209310Stringer · no discrepancyREPAIR TO S-2R BETWEEN FR 60-63 NEEDS TO BE RE-INSPECTED. COMPLIED WITH ERA 630772-14. (1361301)SDR DALA2025122209309Stringer · no discrepancyFUSELAGE STRINGER S-4R REPAIR, FR 60 TO FR 63. COMPLIED WITH ERA 630736-14. (1361267)SDR DALA2025122209308Stringer · no discrepancyREPAIR TO STRINGER 1L BETWEEN FR 61-63 REQUIRES RE-INSP. COMPLIED WITH ERA 630725-14. (1361233)SDR DALA2025122209307Stringer · not reportedFUSELAGE STRINGER 1R REPAIR, FR 60 TO FR 64. REPAIRED PER ERA 630735-14. (1361227)SDR DALA2025122209306Stringer · damagedTOOLING DAMAGE AND STRINGER REPAIR TO S3R BTW FRAME 61 AND 62. REPAIRED PER ERA 630756. (1361212)SDR DALA2025122209305Stringer · not reportedFUSELAGE S-2L REPAIR, FR 60 TO FR 64 NEEDS RE-INSPECT. COMPLIED WITH ERA 630732. (1361196)SDR DALA2025122209304Stringer · damagedTOOLING DAMAGE AND STRINGER REPAIR TO S3L BTW FRAME 61 AND 62. COMPLIED WITH ERA 630737. (1361145)SDR DALA2025122209303Stringer · not reportedFOLLOW ON ACTION IS REQUIRED AT STR 4L BETWEEN FR 61-62. COMPLIED WITH ERA 630706-14. (1361236)SDR DALA2025122209301Bracket · damagedFRAME 45 STRINGER 7R BRACKET REMOVAL. AFTER BRACKET REMOVAL FOUND TOOLING DAMAGE ON FRAME. REPAIRED PER ERA 630742-14 0 THRU 5. (1361411)SDR DALA2025122209298Stringer · damagedDISCREPANCIES ON STR 3L FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630737-14 REV. ORIG. (1361476)SDR DALA2025122209297Stringer · damagedDISCREPANCIES ON STR 1L FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630725-14 REV. ORIG. (1361464)SDR DALA2025122209296Stringer · damagedDISCREPANCIES ON STR 3R FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630756-14 PRI REV. 0. (1361442)SDR DALA2025122209295Stringer · damagedDISCREPANCIES ON STR 4L FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630706-14 REV. ORIG. (1361420)SDR DALA2025122209294Stringer · damagedDISCREPANCIES ON STR 2R FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630772-14 REV. ORIG. (1361415)SDR DALA2025122209293Stringer · damagedDISCREPANCIES ON STR 2L FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630732-14 REV. ORIG. (1361351)SDR DALA2025122209292Stringer · damagedDISCREPANCIES ON STRINGER 1R FROM FR 60-64 IN THE VIASAT MOD AREA. COMPLIED WITH ERA 630735-14 REV. ORIG. (1361329)SDR DALA2025122209291Stringer · damagedDAMAGED STRINGER 4R, FR 60-64 IN THE VIASAT MOD AREA. REPAIRED IAW ERA 630736-14 PRI, REV. 0. (1361319)SDR DALA2025122209290Coupler · damagedFRAME 23 COUPLER AT STR 4 RT HAS TOOLING DAMAGE. REPAIRED PER ERA 630770-14 REV ORIGINAL. (1361254)SDR DALA2025122209330Bracket · misrepairedFRAME 47, STRINGER 3R - 6R C-WAP BRACKETS HAVE OPEN HOLES, FASTENERS NOT INSTALLED PROPERLY, TOOLING DAMAGE AND CLECO'S STILL INSTALLED THROUGH FRAME. COMPLIED WITH ERA 630861-14 REV ORIGINAL. (1360076)SDR HKGA20251220001Unknown · odorWHILE AT 28K ALTITUDE, CREW TURNED PACKS ON HIGH (HEAT), AFTER 20MIN RT PACK FAILED INDICATION ILLUMINATED, CREW FOLLOWED QRH. ABOUT A MIN LATER WITH PACKS ON LOW SETTING, CREW STARTED GETTING SMOKE. CREW FOLLOWED QRH FOR SMOKE BUT SMOKE DIDN’T EVAC FAST ENOUGSDR DALA2025122209328Door Frame · fodR1 DOOR WILL NOT ARM. CLEARED DOOR JAMB OF DEBRIS AND RESTOWED LANYARD THAT WAS CAUSING JAM. OPS CHECK NORMAL. (7974692)SDR DALA2025122209327Lanyard · out of adjustL1 DOOR WILL NOT ARM. DOOR CLOSES OKAY. INSPECTED TO ENSURE MOORING LINE CORRECT ALIGNMENT. ADJUSTED SAME. PERFORMED OPS OF DOOR ARMING SYSTEM IAW AMM 52-11. (7725056)SDR DALA2025122209326Doubler · corrodedFLC LEFT SIDE TRANSITION PANEL FROM BS 500-640, TIE DOWN DOUBLER ON BOTTOM SIDE OF PANEL, APPEARS CORRODED. REMOVED CORROSION FO TIE DOWN DOUBLER. NEW TRANSITION PANEL RECIEVED FOR REPLACEMENT WITH NEW DOUBLERS ATTACHED. NEW TRANSITION PANEL WILL BE WORKED ASDR DALA2025122209322Repair · not reportedIN REFERENCE TO AMDS 5311-01227-02B STEP 2 , EXISTING REPAIR WAS FOUND IN THE INSPECTION AREA AT STA 1360 STR 26RH. CORRECTIVE ACTION: SUMMARY OF NRC 00054: REPAIR WAS ACCOMPLISHED ACCORDANCE ER/A 538373-14 AD . REV A. SECTION I. (1360222)SDR DALA2025122209321Repair · not reportedIN REFERENCE TO AMDS 5311-01227-02B STEP 2 , EXISTING REPAIR WAS FOUND IN THE INSPECTION AREA AT BS 1300 AT S26R. REPAIR WAS ACCOMPLISHED IAW ER/A 538382-14.AD, REV A .SECTION I. (1360209)SDR WX0A2025122232683Battery · no test(AIRCRAFT NOT GROUNDED) OUTBOARD JUMPSEAT FA2 R2 DOOR FLASHLIGHT INDICATOR NOT FLAHSING AT ALL. R & R FLASHLIGHT BATTERY AT FA2 R2 FOOR FLASHLIGHT IAW SIP. OPS CHECK GOOD.SDR WX0A2025122232682Battery · no test(AIRCRAFT NOT GROUNDED) REAR JUMPSEAT FLASHLIGHT NOT BLINKING ON PREFLIGHT. REMOVED AND REPLACED FLASHLIGHT BATTERY AT REAR JUMPSEAT IAW ASTRONICS CMM 25-60-02. OP TEST GOOD. TSDR WX0A2025122232681Battery · inoperative(AIRCRAFT NOT GROUNDED) FA 3 FLASHLIGHT LED NOT FLASHING. REPLACED BATTERY IN FA 3 FLASHLIGHT IAW AMM 25-64-00-900-001A.SDR YENA2025122201246Unknown · vibrationFLT#147, EWR-SJU. "DURING CRUISE #1 FA CALLED STATING LOUD HUMMING NOISE AND VIBRATION IN CABIN FLOOR NEAR ROW 13. CA INVESTIGATED AS WELL. NO OTHER INDICATIONS ON SYSTEMS. PAGE POSSIBLE LOOSE PANEL OR FAIRING SEAL" (SUPPLEMENTAL INFORMATION TO FOLLOW)SDR JJBA20251222028Pump · inoperative#1 HYD SYSTEM INDICATION SHOWED ZERO MOMENTARILY IN FLIGHT. DURING INITIAL INSPECTION FOUND NO LEAKS PRESENT AND HYD QTY OKAY. PERFORMED GEAR SWINGS. WHILE SWINGING WAS ABLE TO DUPLICATE HYD 1 LOW WTY AND HYD 1 FAILURE. FOUND EMDP TO BE CAVITATING CAUSING LOW SDR R61A2025121600546Power Supply · faultedDURING DECENT INTO JFK THEY HAD A MAU2B FAIL, RECEIVED MULTIPLE FAULT MESSAGES ELE L AND R FAIL, GND PROX FAIL, ADS 2 FAIL, TERRAIN FAIL, WINDSHEAR FAIL, ADSP 3 FAIL, TAT 2 FAIL EMERGENCY DECLARED, LANDED WITHOUT INCIDENT, REMOVED AND REPLACED POWER SUPPLY ON SDR DALA2025122209285Roller · wornWEAR ON CRUISE ROLLER IB FLAP ON RH WING. REPLACED CRUISE ROLLER IB FLAP ON RH WING AS PER AIRBUS CMM 57-52-21, TASK 57-52-21-000-805-A01 AND TASK 57-52-21-400-803-A01. (1360923)SDR DALA2025122209284Bonding Plate · debondedDEBONDED BONDING PLATE FLAP TRACK FAIRING 2 (531CB) ON LH WING. COMPLIED WITH ER/A 622998-14TR. (1360175).SDR DALA2025122209283Bonding Plate · debondedDEBONDED BONDING PLATE FLAP TRACK FAIRING 632CB ON RH WING. COMPLIED WITH ER/A 622998-14TR. (1360171)SDR DALA2025122209282Bonding Plate · debondedDEBONDED BONDING PLATE FLAP TRACK FAIRING 4 (533CB) ON LT WING. COMPLIED WITH ER/A 622998-14TR. (1360147).SDR UIEA2025121901352Skin · crackedLEFT WING OTBD AFT FLAP BOTTOM SKIN AT INBD AREA FOUND CRACKED. LT WING O/B AFT FLAP BOTTOM SKIN AT I/B AREA PERFORMED TIME-LIMITED REPAIR IAW EA 1957A259 PART 1 REV.0. NO FURTHER DEFECTS NOTED.SDR UIEA2025122001355Angle · crackedFOUND 1 INCH LENGTH CRACK ON RH LONGERON BOX FRAME (PN: 65B15001-80) REPAIRED PER EA 4453A258 PART 1, REQUIRE TO PERFORM REPEAT INSPECTION PER EA 4453A258 PART 2. (14340)(<P>WHEN ACCOMPLISHED REPEAT INSPECTION PER EA 4453A258 PART 2, FOUND CRACK ON CLIP AND RSDR UIEA2025122001356Oxygen Bottle · low pressureSUPERNUMERARY O2 BOTTLE PRESSURE LOW. REMOVED AND REPLACED O2 BOTTLE IAW AMM 35-31-00/201. OPS & LEAK CHKD OK.SDR FDEA202512202274Floor Panel · damagedMAIN DECK - THE TOP OF FLOOR PANEL 222AFF IS DAMAGED. FABRICATED NEW FLOOR PANEL 222AFF, RBL11-RBL33, BS 285-412 IAW DRAWING 141T5856-107, AND SR67-53-009. THIS IS A MAJOR REPAIR. INSTALLATION OF THIS PANEL WILL BE ACCOMPLISHED ON WO#91439 NR#142.SDR FDEA202512202273Floor Panel · dentedMAIN CARGO DECK, FLOOR PANEL 242UFF DAMAGED. REPAIRED MAIN DECK FLOOR PANEL 242UFF, AT BS 980-114.82, RBL 54.75- RBL 74.25 IAW 53-00-50-2R. THIS IS A MAJOR REPAIR. SEE JPF FOR ALL WORK PERFORMED. FLOORBOARD WILL BE INSTALLED ON WO 91439, SEQ 114.SDR FDEA202512202272Stringer · corrodedAFT CARGO BAY, STRINGER 30 BTW BS 1440 TO 1460 FOUND CORRODED. REPAIRED THE STRINGER IAW SRM 53-00-03-2R, SRM 51-40-02-0G, & DWG 146N3110, REV B.SDR FDEA202512202271Shear Tie · corrodedAFT CARGO BAY, BS 1460 SHEAR TIE BTW STR-29L TO STR-30, FOUND CORRODED. REPLACED SHEAR TIE IAW SRM 51-40-02-0G, AND DWG 140N2002, REV C.SDR FDEA202512202270Shear Tie · corrodedLOWER HALF OF FUSELAGE BS 1460 BETWEEN S28L AND S29L HAS POSSIBLE CORROSION. REPLACED THE SHEAR TIE IAW SRM 51-40-02-0G, AND DWG 140N2002, REV C.SDR FDEA202512202269Stringer Splice · corrodedAFT CARGO COMPARTMENT BS 1460 SPLICE STRINGER 30 CORRODED. REPLACED SPLICE STRINGER LOCATED BS 1460 IAW SRM 51-40-02-0G, AND DWG 146N3820, REV C.SDR FDEA202512202268Stringer · corrodedAFT CARGO BAY, STRINGER 30L BTW BS 1460 - 1480, FOUND CORRODED. REPAIRED THE STRINGER IAW SRM 51-40-02-0G, & DWG 146N3110, REV C.SDR FDEA202512202267Stringer Splice · corrodedAFT CARGO BAY, BS 1460 STRINGER SPLICE 29L CORRODED. REPLACED THE STRINGER SPLICE IAW SRM 51-40-02-0G, DWG 146N3820, REV C.