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 UIEA2025091601220Stringer · crackedSTA 2598 FWD STRINGER 8L FOUND CRACKED. STRINGER 8L REPAIRED IAW SRM 53-80-03-2R-2 TR53-152 REV.46 DATE: 20 JUN 2025. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601221Stringer · crackedSTA 2360 AFT SIDE S24L SUSPECT CRACKED. STRINGER REPAIRED IAW RI-53-80-17740 REV.A. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601222Stringer · crackedONE CRACK FOUND ON BS 2360 FWD STRINGER 10L. STRINGER 10L REPAIRED IAW SRM 53-60-03-2R-8 TR53-157 REV.46 DATE: 20JUN 2025. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601223Stringer · crackedSTA 2598 FWD SIDE STRINGER 5L SUSPECTED CRACKED. STRINGER REPAIRED IAW SRM 53-80-03-2R-2 TR53-152. NO FURTHER DEFECTS NOTEDSDR UIEA2025091601224Stringer · crackedSTA 2598 FWD SIDE STRINGER 1L SUSPECTED CRACKED. STRINGER REPAIRED IAW SRM 53-80-03-2R-2 TR53-152. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601225Stringer · crackedSTA 2598 FWD SIDE STRINGER 6R SUSPECTED CRACKED. STRINGER REPAIRED IAW SRM 53-80-03-2R-2 TR53-152 REV.46 DATE 20 JUN 2025. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601226Stringer · crackedSTA 2598 AFT SIDE STRINGER 4L SUSPECTED CRACKED. STRINGER 4L REPAIRED IAW SRM 53-80-03-2R-2 TR53-152 REV.46 DATE 20 JUN 2025. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601227Stringer · crackedSTA 2598 FWD STRINGER 7R FOUND CRACKED. STRINGER 7R REPAIRED IAW SRM 53-80-03-2R-2 TR53-152 REV.46 DATE 20 JUN 2025 & RI-53-80-17882 REV. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601228Stringer · crackedSTA 2360 AFT SIDE STRINGER 3L SUSPECT CRACKED. STRINGER REPAIRED IAW RI-53-81-17881 REV.A. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601229Rib · crackedRIGHT WING NR 20 VC FLAP PANEL UPPER RIB MOST INBD FOUND CRACKED. RT WING NR 20 VC FLAP PANEL RIB REPAIRED IAW RI-57-44-17855 REV A. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601230Stringer · crackedSTA 2360 AFT STRINGER 20R SUSPECT CRACK. STA 2360 AFT STRINGER 20R SUSPECT CRACK AREA REPAIRED IAW SRM 53-80-03-2R-3 TR53-153. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601231Stringer · crackedSTA 2360 AFT SIDE S20L SUSPECT CRACKED(<P>STA 2360 AFT SIDE S20L SUSPECT CRACKED AREA REPAIRED I.A.W B747-8F SRM 53-80-03-2R-3 TR53-153 REV.46 DATE 20 JUN 2025. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601232Seat Track · out of limitsM/D - STA 1480+50 LBL11. SEAT TRACK INDEX HOLE FOUND OUT OF LIMIT. M/D - STA 1480+50 LBL11. SEAT TRACK INDEX HOLE FOUND OUT OF LIMIT. AREA REPAIRED I.A.W B747-8F SRM 53-00-52-2R-9 REPAIR 9 REV.46 DATE 20 JUN 2025 & RI-53-60-17886 REV.A. NO FURTHER DEFECTS NOTSDR UIEA2025091601233Seat Track · out of limitsM/D STA 1510 AND STA 1550 LBL 11. SEAT TRACK INDEX FOUND OUT OF LIMIT. M/D BS 1510 AND 1550 LBL 11. SEAT TRACK INDEX FOUND OUT OF LIMIT AREA REPAIRED IAW SRM 53-00-52-2R-9 REPAIR 9 REV.46 DATE 20 JUN 2025 & RI-53-60-17886 REV.A. NO FURTHER DEFECTS NOTED.SDR UIEA2025091601234Seat Track · damagedMDC - SEAT TRACK BETWEEN STA 1265 AND 1480 LBL 11.33" FOUND 7EA LOCATION SLOT HOLE ELONGATED AT STA 1250, 1270, 1290, 1350, 1390, 1430 & 1470 AREA(<P>MDC - SEAT TRACK BETWEEN STA 1265 AND 1480 LBL 11.33" FOUND 7EA LOCATION SLOT HOLE ELONGATED AT STA 1250, 1270SDR UIEA2025091601235Seat Track · damagedMDC - STA 1550 RBL 11 SEAT TRACK SLOT HOLE ELONGATED(<P>MDC - STA 1550 RBL 11 SEAT TRACK SLOT HOLE ELONGATED REPAIRED I.A.W RI-53-60-17877 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025091601236Seat Track · damagedMDC - SEAT TRACK BETWEEN STA 1786 AND 2106 LBL 11.33" FOUND 2EA LOCATION SLOT HOLE ELONGATED STA 1850, 1870 AREA(<P>MDC - SEAT TRACK BETWEEN STA 1786 AND 2106 LBL 11.33" FOUND 2EA LOCATION SLOT HOLE ELONGATED STA 1850 & 1870 AREA REPAIRED I.A.W RI-53-60-17850 SDR UIEA2025091601237Seat Track · damagedMDC - SEAT TRACK BETWEEN STA 1000 AND 1265 LBL 11.33" FOUND 5EA LOCATION SLOT HOLE ELONGATED AT STA 1070, 1090, 1110, 1130 & 1150 AREA(<P>MDC - SEAT TRACK BETWEEN STA 1000 AND 1265 LBL 11.33" FOUND 5EA LOCATION SLOT HOLE ELONGATED AT STA 1070, 1090, 1110, 1130SDR DXTA2025091904993Door · lack of lubeDURING OUR FIRST FLIGHT OF THE DAY, WHEN WALKING UP TO THE AIRCRAFT AND ATTEMPTING TO OPEN THE MAIN CABIN DOOR, THE DOOR HANDLE WOULD LIFT UP SLIGHTLY AND THEN BECOME STUCK. WE COULD NOT MOVE IT ANY FURTHER AND WE WERE AFRAID THAT BY APPLYING MUCH MORE PRESSUSDR DXTA2025091904996Striker · out of adjustON THE DECENT AT ABOUT 17000 THE R EMER EXIT DOOR CAS MESSAG ILLUMATED AND THE EMER DOOR SHOWED UNSARE ON THE AIRCRAFT SYNOPTIC THE PROX SWITCH STRIKER BRACKET WAS OUT OF ADJUSTMENT, AIR GAP MEASURED .080". ADJUSTED STRIKER BRACKET AS NEEDED TO ACHIEVE THE REQSDR DXTA2025091904997Battery Pack · no testDURING PREFLIGHT, POWER ON CHECKLIST, EMER LTS CHECK, THE FLOOR EMEGENCY EXIT LIGHT AT SEAT 8 WOULD NOT ILLUMINATE. ALL OTHER LIGHTS EXCEPT SEAT 5 WORKED AS DESIGNED. SEE SEPERATE WRITE UP FOR SEAT 5. EMERGENCY LIGHT COMES ON BRIEFLY, THEN GOES OUT. SUSPECT BASDR I5PA2025091768803Anti-Ice Valve · inoperativeLEFT ENG BLEED VAL WITH ENG ANTI ICE IN CRUISE AT FL330. PERFORMED INSPECTION OF LT ENG ANTI ICE VALVE. FOUND VALVE IN FIXED OPEN POSITION. REPLACED VALVE PER APPLICABLE AMM.SDR I5PA2025091768802Exciter · inoperativeRIGHT ENGINE IGNITION SYSTEM 1 INOP. PERFORMED OPS CHECK, FOUND SYSTEM 1 EXCITER INOP. REPLACED IGNITION EXCITER PER APPLICABLE AMM.SDR I5PA2025091768801Ignition Lead · damagedRIGHT ENGINE IGNITION SYSTEM 1 INOP. PERFORMED FIM, FOUND SYSTEM 1 IGNITION LEAD DAMAGED. REPLACED IGNITION LEAD PER APPLICABLE AMM.SDR HALA20250918282Mount · shearedETOPS - ENG 1 REV FAULT ON LANDING (CLEARED ON SHUTDOWN). PERFORMED TSM 78-37-00-810-833-A. FOUND ENG 1 PCM SUPPORT MOUNTING BRACKET SHEARED FROM MOUNTS. REMOVED ENG 1 PCM PER AMM 73-21-34. REPAIRED MOUNTING BRACKET PER E105-C20228-INI. INSTALLED #1 ENG PCM PESDR HALA20250918281Exciter · faultedETOPS - APU AUTO SHUTDOWN ON TAXI IN. REMOVED AND REPLACED EXCITER - IGNITION BOX PER AMM 49-41-00. OPS CHECK GOOD. OK TO CONTINUE.SDR SWIA2025091800017Bleed Valve · warning messageR 14TH STAGE BLED AIR DUCT MASTER WARNING N CLIMB OUT (FLIGHT 5038) PERFORMED VISUAL INSPECTION OF THE RH 14TH STAGE BLEED DUCTS REFERENCING APPLICABLE STEPS OF AMM 36-12-00. NO DEFECTS NOTED AT THIS TIME. PERFORMED LEAK TEST OF THE 10TH STAGE BLEED AIR SYSSDR AALA202509189568Battery · dischargedAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS UNDER FWD FLT ATTENDANT JUMPSEAT INSTALLED BACKWARDS AND HAVE DEAD BATTERIES. MAINTENANCE REPLACED THE BATTERIES AND CORRECTLY INSTALLED THE FLASHLIGHTS REF CMM 25-60-02.SDR AALA202509185402Battery · misinstalledAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS UNDER FWD FLT ATTENDANT JUMPSEAT INSTALLED BACKWARDS AND HAVE DEAD BATTERIES. MAINTENANCE REPLACED THE BATTERIES AND CORRECTLY INSTALLED THE FLASHLIGHTS REF CMM 25-60-02.SDR GTIA2025091839080Megaphone · inoperativeLOUD SQUEAL FROM L1 DOOR STARTED ON DES AT DP 7.9 AND STOPPED AT DP 6.4-PERFORMED OPS TEST OF CABIN PRESSUERIZATION IAW AMM 21-31-00. FOUND L1 DOOR MEGAPHONE MALFUNCTION. R/R L1 DOOR MEGAPHONE IAW CMM 25-64-00. OPS CHECK GOOD. NO DEFECTS NOTED. A/C OK FOR SVCDSDR GTIA2025091839079Pump · leakingFUME EVENT ON DESCENT TURN OFF PACK 1. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS / OIL BURNING SMELL. APPARENT CABIN SOURCE: COCKPIT. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-PERFORMED TSM 05-50-00-810-831-A. DECESION VALUE TSDR DALA2025091806867Skin · corrodedCORROSION FOUND LWR SKIN AT STA 660 BETWEEN STR 26L AND 27L. REMOVED DAMAGED AREA IN SKIN BETWEEN STRINGERS S-26L AND S27L, FABRICATED REPAIR DOUBLER, FILLERS, AND SPLICE PALTE REPAIR DOUBLER AND INSTALLED PER ER/A 629135-14AD. (LP 1203519)SDR IPXA2025091851427Window · damagedNR 1 WINDSHIELD HAS MATERIAL STREAKING DOWN WHICH CANNOT BE REMOVED BY MX. SAFETY OF FLIGHT ISSUE. DUE TO OBSCURING FIELD OF VIEW. CLEANED CAPT 1L WINDOW PER SOPM-20-30-03. NO OBSCURING FIELD OF VIEW. OK FOR FLIGHT.SDR DALA2025091806858Trim System · failedDIVERTING TO PHL DUE TO STABILIZER TRIM FAIL. FOUND OMS FAULT CODES 2741F0013, 2741F0036 AND 2741F0037. DUE TO INFLIGHT MSG, HSTA REPLACED. (LP# 7769944)SDR TY2A202509180001Engine · flamed outPILOT WAS TOPPING SOME WEATHER WITH INTENT TO DESCEND QUICKLY ON THE OTHER SIDE TO LAND AT AN AIRPORT CLOSE TO THE BACK SIDE OF THE WEATHER. HE WAS AT FL360 WHEN CLEARED TO DECENT AND HAD ALREADY SLOWED TO 200KTS IAS. HE THEN PULLED BOTH POWER LEVERS BACK TO CSDR FDEA202509171738Skin · dentedLEFT WING, OUTBOARD FLAP, UNDER SIDE, HAS A LARGE SMOOTH DENT, 144" FROM INBOARD EDGE AND 22.5" UP FROM TRAILING EDGE OF FLAP AS MARKED. REPAIRED L/H WING OUTER SKIN 7.75" X 6" AREA ON LOWER SURFACE OF OUTBOARD TRAILING EDGE FLAP ALUMINUM HONEYCOMB SKIN PASDR SIMA20250917001Flap · out of positionL1 PLASTIC FLAP ABOVE DOOR HANDLE IN WRONG POSITION FA UNABLE TO OPERATE DOOR PROPERLY REPOSITIONED AIR/DISARM COVER AS REQ REM ERJ 170 AMM 25-23-00 OPS CHECK GOOD IAW ERJ 170 AMM SDS 52-11-00 NO FURTHER DEFEECTS NOTEDSDR DALA2025091806855Unknown · fumesATB, PERFORMED AN AIR TURN BACK DUE TO FUMES IN CABIN AND COCKPIT. PERFORMED WATER WASH AND DRY OUT RUNS ON BOTH ENGINES AND REPLACED BOTH RECIRCULATION FILTERS. (LP 7607148)SDR DALA2025091806851Floor Panel · damagedFOUND FWD CARGO FLOOR PANEL DAMAGED. CORRECTIVE ACTION: COMPLIED WITH ER/A 587849-14TR. (7770058).SDR DALA2025091806850Battery Pack · malfunctionedRAM1 EMER LIGHTS FLICKERING. R & R PSU 12WL AND BATTERY AS PRECAUTION PER A319 AMM 33-51. (6999598).SDR DALA2025091806853Battery Pack · inoperativePILOT REFUSED AIRCRAFT DUE TO MEL FOR 2EA OVERHEAD EMERGENCY LIGHTS. R/R PSU 12WL AND BATTERY AS PRECAUTION PER A319 AMM 33-51. (6999596).SDR YENA2025091800950Battery · no testFLT#1024, LAS-JFK. "DURING EMERGENCY BATTERY CAPACITY TEST BATTERY AT 13WL OVER HEAT MSG ; REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT 13WL IAW AMM 33-54-00 OPS CHK GOOD."SDR AALA202509181868Lanyard · out of positionAIRCRAFT WAS NOT GROUNDED: R1 DOOR HAS A CABLE HANGING FROM THE BOTTOM OF THE DOOR. MAINTENANCE RE-STOWED R1 DOOR SLIDE LANYARD PER AMM 25-62-44.SDR AALA202509186753Connector · looseAIRCRAFT WAS NOT GROUNDED: SEAT 1C EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE RE-SECURED BAD CONNECTION AT 1C SEAT MOUNTED EMERGENCY LIGHT PER AMM 33-51-19. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED PER AMM 33-51-00.SDR AALA202509183326Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT #3 FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-60-00.SDR YENA2025091800949Ignition Sys · faultedFLT#354, DUB-JFK. (ETOPS) "ENG 1 IGN B FAULT ON START UP ( IGNITION SYSTEMS B) SYSTEM B ); PERFORMED SINGLE ENGINE IDLE RUN PER AMM 72-00-00 ALL OPS CHK NORMA; NO CURRENT IGNITION FAULT MDDR CLEARED MX04 UPDATED PLACRD REMOVED.SDR 2025FA0000655Wheel · abnormalNOSE WHEEL SHIMMY, GEAR COLAPS UPON STOPINGSDR ABXA20250917231Detection Sys · faultedDURING THROUGH FLIGHT, MAIN CARGO FIRE DETECTION AMBER LIGHT IN SECTION 3B. MAINTENANCE DEFERRED IAW 26-16-2-1 MEL MAINTENANCE PROCEDURES C/W PLACARD INSTALLED MBCB 9/27/25 REPETITIVE INSPECTION REQUIRED BEFORE EACH DEPARTURE 26-16-2-1 IAW MEL 26-16-2-1. AISDR SCNA20250918381Cover · missingR1 DOOR SLIDE HOUSING PLASTIC GAGE COVER MISSING. OPENSDR CALA2025091809038Lamp · inoperativeFOUND RH SLIDE OVERWING LIGHT INOP PERFORMED RAR OF RH SLIDE OVERWING LIGHT IAW AMM 33-51-04 . OPC GOOD.