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 DALA2025071705381Floorbeam · damaged(LOG 1082241) ELONGATED HOLE ON FLOOR BEAM RBL 18 STA 277 AT PASSENGER CABIN. HOLE ON FLOOR BEAM RBL 18 STA 277 AT PASSENGER CABIN WAS REPAIRED PER ER/A 627645-14 REV. ORIGINAL SECTION: I REPAIR INSTRUCTIONS AND PRI 627645-14 REV.0.SDR DALA2025071705380Plate · corroded(LOG 1082144) AFTER BLEND OUT CORROSION, (UT) MEASUREMENT THICKNESS WAS ACCOMPLISHED ON LH SIDE PLATES SEVERAL POINTS FROM STA 500D +18 TO STA 500I AT FWD CARGO COMPARTMENT WITH A ORIGINAL THICKNESS 0.040IN AND MINIMUM REMAINING THICKNESS 0.020IN THEREFORE IS SDR DALA2025071705379Skate Angle · corroded(LOG 1081913) AFT CABIN FLOOR STRUCTUE RT SIDE SKATE ANGLE HAS AREAS OF CORROSION STA 968- 986 RBL 42. REMOVED AND REPLACED AFT CABIN FLOOR STRUCTUE RT SIDE SKATE ANGLE P/N 147A8540-8 AT STA 968- 986 RBL 42.IAW B737 SRM 51-40-02.SDR DALA2025071705378Web · corroded(LOG 1081813) AFT CABIN FLOOR STRUCTURE HAS AREAS OF CORROSION STA 986-993 RBL 35- RBL 41. REMOVED AND REPLACED Z ANGLE AND WEB AFT CABIN FLOOR STRUCTURE STA 986-993 RBL 35- RBL 41 IAW B737 SRM 51-40-02.SDR DALA2025071705377Frame · no discrepancy(LOG 1081311) ACCOMPLISH AMDS 5311-01251-02B - RIGHT HAND STA 727 FRAME INNER CHORD 737 SECTION 02. ACCOMPLISHED AMDS 5311-01251-02B - RIGHT HAND STA 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02.SDR DALA2025071705376Frame · no discrepancy(LOG 1081301) ACCOMPLISH AMDS 5311-01251-02A - LEFT HAND STA 727 FRAME INNER CHORD 737 REPAIR SECTION 02. ACCOMPLISHED AMDS 5311-01251-02A - LEFT HAND STA 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02.SDR DALA2025071705375Intercostal · corroded(LOG 1080996) LH SIDE PLATE, CORROSION FOUND ON 4 INTERCOSTALS FROM STA 500D TO STA 500I AND S-25L AT FWD CARGO COMPARTMENT. INTERCOSTALS FROM STA 500D TO STA 500I AND S-25L AT FWD CARGO COMPARTMENT WERE REPLACED PER B737-800 SRM 51-40-02-0G AND INTERCOSTAL BTSDR UIEA2025071500954Smoke Detector · false activationEQUIPMENT SMOKE STATUS MESSAGE AFTER EQUIPMENT COOLING MESSAGE. REMOVED AND REPLACED EQUIPMENT COOLING SMOKE DETECTOR IAW AMM 26-16-51. PERFORMED GROUND TEST .</P> / <P>TEST PASSED MESSAGE CLEARED.SDR UIEA2025071400949Bracket · damagedFLIGHT DECK FIRE EXTINGUISHER HOLDING BRACKET INOPERATIVE. RE-ADJUSTED FLIGHT DECK FIRE EXTINGUISHING BRACKET IAW B767 AMM 26-26-02. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR UIEA2025071300947Strut · crackedNUMBER 1 PYLON INBOARD STRUT SKIN IS FOUND CRACKED AT 452ER PANEL, CUTOUT LENGTH 1.2". NR 1 PYLON INBOARD STRUT SKIN CRACK AT 452ER PANEL CUTOUT AREA, REPAIRED IAW RI-54-50-17774 REV A. NO FURTHER DEFECTS NOTED.SDR CALA2025071706674Aoa · faultedSPD LIM FLAG CAPT PFD NO VERTICAL FD GUIDANCE INTMT STICK SHAKER CA SIDE. REMOVED AND REPLACED CAPT AOA SENSOR REF AMM 34-21-05 OPS CHECK GOOD.SDR CALA2025071706673Static Inverter · faultedREJECTED T/O DURING T/O ELEC LIGHT ILLUMINATED. PER FLT CREW VIA DISPATCH, RTO AT 30 KTS. STATIC INVERTER WAS REPLACED TWICE AND SPCU WAS REPLACED ONPERFORMED POWER CHECK ON FRONT OF STATIC INVERTER WITH 27.29V DC. POWER CHECK BETWEEN PIN 1 AND PIN 3 OF D46 SDR CALA2025071706669Slide · not seated1R SLIDE PACK APPEARS TO NOT BE SEATED. REMOVED REPACKED AND INSTALLED R1 DOOR SLIDE PACK REF AMM 25-66-01/401. A/C OK FOR SERVICE. RENDER SAFE CHECKLIST C/W. RII INSPECTION OF R1 DOOR SLIDE PACK REINSTALLATION. VERIFIED SLIDE BOTTLE SAFETY PIN REMOVED AND SSDR CALA2025071706668Slide · low pressureDOOR 1L SLIDE GAUGE PRESSURE IN THE RED. BEGAN REMOVAL OF LEFT FWD ESCAPE SLIDE ASSY, REF AMM 25-62-44. REMOVED AND REPLACED 1L DOOR SLIDE IN REF WITH AMM 25-62-44. OK FOR SERVICE. COMPLIED WITH GMM 09-25-05 FOR REMOVAL AND INSTALLATION, NO DEFECTS NOTED COMSDR CALA2025071706657Skin · dentedTHE FWD CARGO DOOR EXTERNAL SKIN HAD EXCESSIVE DAMAGE, DENTS. FORWARD CARGO DOOR SKIN REPLACED IN RFD DURING D CHECK. REMOVED AND REPLACED THE FWD CARGO DOOR EXTERNAL SKIN IAW SRM 52 -30-01-2R-3.SDR UIEA2025062800817Longeron Fitting · crackedLEFT BS 1480 LONGERON EXTENSION FITTING FOUND CRACKED. CRACK LONGERON EXTENSION FITTING REPAIRED AS PER ATLAS AIR EO 4453A818 REV 20 PART 7. NO FURTHER DEFECTS NOTED.SDR UIEA2025062800818Doubler · crackedMAIN DECK - L1 ENTRY DR UPR HINGE DOUBLER FND CRACKED. DOUBLER REPLACED AS PER SRM 51-10-02 AND NEW DOUBLER HOLES TRANSFERRED AS PER SRM 51-40-05 AND NEW DOUBLER INSTALLED AS PER SRM 51-40-02. NO FURTHER DEFECTS NOTED.SDR UIEA2025063000819Lug · cracked1 EA CRACK WAS FOUND ON BS 1000 RBL 11.33 INTERCOSTAL LUG FITTING. INTERCOSTAL LUG FITTING REPLACED AS PER ATLAS AIR EO 4453C024 REV.4 PART 7 STEP 3. NO FURTHER DEFECTS NOTED.SDR UIEA2025063000820Lug · cracked1 EA CRACK WAS FOUND ON BS 1000 LBL 11.33" INTERCOSTAL LUG FITTING. INTERCOSTAL LUG FITTING REPLACED AS PER ATLAS AIR EO 4453C024 REV.4 PART 3 STEP 3. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100821Fairing · delaminatedRIGHT WING I/B MID FLAP L/E FAIRING FOUND DELAMINATION AT I/B 13". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100822Fairing · delaminatedRIGHT WING I/B AFT FLAP MID L/E FAIRING FOUND DELAMINATION AT O/B 180". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100823Fairing · delaminatedLEFT WING I/B MID FLAP L/E FAIRING FOUND DELAMINATION AT O/B 70". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100824Fairing · delaminatedRIGHT WING O/B MID FLAP L/E FAIRING FOUND DELAMINATION AT I/B 39". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100825Fairing · delaminatedRIGHT WING O/B MID FLAP L/E FAIRING FOUND DELAMINATION AT I/B 12". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100826Fairing · puncturedLEFT WING I/B FORE FLAP MID L/E FAIRING FOUND PUNCH HOLE FROM I/B 133". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. C. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100827Fairing · delaminatedRIGHT WING O/B MID FLAP L/E FAIRING FOUND DELAMINATION AT O/B 180". PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025070100828Fairing · chafedRHW I/B AFT FLAP I/B L/E FAIRING FOUND CHAFING. PERFORMED PERMANENT REPAIR AS PER SRM 51-70-07 PAR 5.G. NO FURTHER DEFECTS NOTED.SDR UIEA2025070300830Power Supply · no testFUNCTIONAL TEST EMERGENCY LIGHTS BATTERY PACKS FOR CAPACITY (15 MIN. MINIMUM). FOUND EMERGENCY LT L1533, L5733, L5767 & M4915 WENT OFF IN LESS THAN 15 MINUTES. EMERGENCY LT POWER PACK M5169 REPLACED AND OPERATION CHECKED NORMAL IAW AMM 33-51-04.SDR UIEA2025070500835Lamp · inoperativeDOOR L1 FWD EMERGENCY SILL LT L1853 FOUND INOP. DOOR L1 FWD EMERGENCY SILL LT L1853 LAMP REPLACED AND TEST NORMAL IAW AMM 33-51-05.SDR UIEA2025070700844Seat Track · crackedM/D STA753 TO STA757 LBL11" SEAT TRACK FOUND CRACKED. SEAT TRACK CRACK AREA REPAIRED AS PER SRM 53-00-52-2R-12 REPAIR12 FIG 201. NO FURTHER DEFECTS NOTED.SDR UIEA2025070700846Seat Track · chafedM/D STA 1980 TO STA 1985 RBL 11.33" SEAT TRACK CROWN CHAFED. CHAFED AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED OUT AREA MEASURED L:6" X W:0.3" X D:0.007" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NSDR UIEA2025070700847Seat Track · chafedM/D STA 2020 TO STA 2026 RBL 11 SEAT TRACK CROWN CHAFED. CHAFED AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED OUT AREA MEASURED L:7" X W:0.3" X D:0.008", WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO SDR UIEA2025070700848Seat Track · chafedM/D STA 646 TO STA 656 LBL 11 SEAT TRACK CROWN FOUND CHAFED. CHAFE AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED OUT AREA MEASURED L:5" X W:0.3" X D:0.007", WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NSDR UIEA2025070700849Seat Track · chafedM/D STA 1890 TO 1893 LBL 11 SEAT TRACK CROWN FOUND CHAFED. CHAFE AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND CHAFING SMOOTHED OUT AREA MEASURED AS PER SRM 53-00-52-1A-1. WITHIN ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTHER DESDR UIEA2025070700850Seat Track · chafedM/D STA 1968 TO STA 1970 LBL 11 SEAT TRACK CROWN FOUND CHAFED. CHAFE AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED OUT AREA MEASURED L:4" X W:03" X D:0.006", WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NSDR UIEA2025070700851Seat Track · scratchedM/D SEAT TRACK CTR GUIDE STUD AREAS FOUND SCRATCHED AT RBL 11 STA 1370, STA 1390, STA 1410. SCRATCH AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, SMOOTHED AREA MEASURED L:4" X W:0.7" X D:0.008" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DSDR UIEA2025070700852Seat Track · corrodedM/D STA 780, 783 LBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED L=5" X W=0.7", D=0.006" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTHER DSDR UIEA2025070700854Seat Track · scratchedM/D SEAT TRACK CTR GUIDE STUD AREAS FOUND SCRATCHED AT RBL 11 STA 1430, STA 1450 & STA 1470. SCRATCH AREAS SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED AREA MEASURED L:4" X W:0.7" X D:0.009", WITHIN SRM 53-00-52-1A-1 ALLOWSDR UIEA2025070800855Seat Track · corrodedM/D STA 606-STA 624 LBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED: L=8" X W=0.7" X D=0.006" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMTIS. NO FURTSDR UIEA2025070800856Seat Track · scratchedM/D SEAT TRACK CTR GUIDE STUD AREAS FOUND SCRATCHED AT RBL 11 STA 1611, STA 1631, STA 1772. SCRATCH AREAS SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED AREA MEASURED L:3" X W:0.7" X D:0.007", WITHIN SRM 53-00-52-1A-1 ALLOWASDR UIEA2025070800857Seat Track · corrodedM/D STA 566-STA 592 LBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED: L=15" X W=0.7" X D=0.008" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURSDR UIEA2025070800858Seat Track · corrodedM/D STA 545-STA 559 LBL 11 SEAT TRACK CROWN CORRODED. CORRSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED: L=8" X W=0.7" X D=0.007" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTHSDR UIEA2025070800859Seat Track · corrodedM/D STA 872-STA 875 RBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED: L=6" X W=0.7" X D=0.005" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTSDR UIEA2025070800860Seat Track · corrodedM/D STA 750-STA 783 RBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED" L=4" X W=0.7" X D=0.007" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTSDR UIEA2025070800861Seat Track · scratchedM/D SEAT TRACK CTR GUIDE STUD AREA FOUND SCRATCHED AT LBL 11 STA 1430, STA 1450, STA 1470. SCRATCH AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, BLENDED OUT AREA MEASURED L:4' X W:0.7" X D:0.008", WITHIN SRM 53-00-52-1A-1 ALLOWABLSDR UIEA2025070800862Seat Track · corrodedM/D STA 730-STA 752 RBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED: L=6" X W=0.7" X D=0.005" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTSDR UIEA2025070800863Seat Track · corrodedM/D SEAT TRACK CTR GUIDE STUD AREAS FOUND SCRATCHED AT RBL 11.33 STA 1853 AND STA 1913. SCRATCH AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED AREA MEASURED L:6" X W:0.7" X D:0.006", WITHIN SRM 53-00-52-1A-1 ALLOWABLE DSDR UIEA2025070800864Seat Track · corrodedM/D STA 687-STA 694 RBL 11 SEAT TRACK CROWN CORRODED. CORROSION AREA REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01, CORROSION REMOVED AREA MEASURED: L=8" X W=0.7" X D=0.007" WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO FURTHSDR UIEA2025070800865Guide · corrodedM/D STA 1920 - 1980 SCD AFT SIDE GUIDE FOUND CORROSION. CORROSION AREA REMOVED AS PER CMM 25-55-06 AND REPROTECTED AS PER SRM 51-20-01 AND CORROSION REMOVED AREA MEASURE L:13" X W:2" X D:0.028", ORG THICKNESS 0.152" WITHIN CMM 25-55-06 LIMITS. NO FURTHER DEFSDR UIEA2025070800868Seat Track · chafedM/D STA 1457 TO STA 1461 RBL 11 SEAT TRACK CROWN CHAFING. CHAFING AREA SMOOTHED OUT AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01 AND SMOOTHED OUT AREA MEASURED L:7" X W:0.3" X D:0.008", WITHIN SRM 53-00-52-1A-1 ALLOWABLE DAMAGE 1 FIG 101 LIMITS. NO