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 AALA202508182729Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT, AFT BULKHEAD, LOWER LOBE SUPPORT ASSEMBLY LOCATED AT BS 500I FROM S20L TO S25L. REPLACED SUPPORT PER AARD 51-00-05-1.SDR DALA2025081606131Dampener · inoperativeEMERGENCY DOOR DAMPER 842 DOESN`T WORK CORRECTLY, REF. AMDS CARD 5210-7089-RA. RII). REPLACED EMERGENCY DOOR DAMPER.SDR CALA2025081407760Frame · no discrepancyON THE BS 380 FRAME AT STRINGER 16R, ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5311-03377 ON OR BEFORE 20 JULY 2027.SDR CALA2025081407759Skin · no discrepancyON THE FUSELAGE SKIN AT BS 540 BETWEEN STR 28L-28R, ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5330-07564 ON OR BEFORE 11 JULY 2027.SDR CALA2025081407758Skin · no discrepancyON THE RT WING OUTBD LOWER SKIN PANEL BETWEEN WSTA 564.5 AND WSTA 591.5 AT STRINGER 9, ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5720-03542 ON OR BEFORE 11 JANUARY 2027.SDR CALA2025081407757Window Frame · no discrepancyON THE R3 WINDOW FRAME E-F POST ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5311-03375 ON OR BEFORE 11 JULY 2027.SDR CALA2025081407756Window Frame · no discrepancyON THE L3 WINDOW FRAME E-F POST ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5311-03376 ON OR BEFORE 50,000 TOTAL CYCLES. L3 WINDOW FRAME E-F POST ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF ECRA 5311-03376 ON OR BEFORE 50,000 TOTAL CYCLES.SDR DALA2025081306064Apu · odorDIRTY SOCK ODOR WHEN APU BLEED SELECTED ON. R/R APU PER W/C 4900-9002.SDR SWIA20250813007Windshield · crackedCAPTAIN WINDSHIELD CRACKED (FLIGHT 5844 - FILED CLOSED) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30628908 WITH THE FOLLOWING CORRECTIVE ACTION: "COMPLIED WITH TASK CARD 56-220-1000-SKY (CL600-2C11) CRJ-550 COCKPIT WINDSHIELD/SIDE WINDOW INSTALLATION. OPSSDR SWAA2025081399544Girt Bar · unsecureCR RR L1 DOOR FWD. GIRT BAR FITTING NEEDS SECURED. SECURED L1 DOOR FWD GIRT BAR FITTING IAW B737-800 AMM 25-66-02-201 AND 20-50-11-910-801.SDR SWAA2025081399545Girt Bar · unsecureCR RR R1 DOOR FWD. GIRT BAR FITTING NEEDS SECURED. TORQUED FASTENERS ON TOP BRACKET OF GIRT BAR FITTING IAW B737-800 20-50-11-910-801.SDR SWAA2025081399317Girt Bar · unsecureCR RR L1 DOOR FWD GIRT BAR FITTING NEEDS SECURED. SECURED L1 DOOR FWD GIRT BAR FITTING IAW B737-800 AMM 25-66-02-201 AND 20-50-11-910-801.SDR SWAA2025081399541Handle · unsecureL2 DOOR AND AIRFRAME SIDE ASSIST HANDLES NEEDS SECURED. SECURED L2 DOOR AND AIRFRAME SIDE ASSIST HANDLES IAW B737-800 AMM TASK 25-21-25-420-801.SDR SWAA2025081399323Handle · unsecureL2 DOOR AND AIRFRAME SIDE ASSIST HANDLES NEED SECURED. SECURED L2 DOOR AND AIRFRAME ASSIST HANDLES IAW AMM 52-13-31.SDR SWAA2025081399318Handle · unsecureCR RR R1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR FDEA202508071387Floor Panel · damagedMAIN DECK COMP. AT APROX STA 350 &RBL11 TO LBL11 FLOORBOARD PANEL 221CFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) FABRICATED NEW FLOOR PANEL 221CFF, MPN: 141T5856-105, LBL 11- RBL 11, STA 285- 412 IN REF. TO BOEING DWG 141T5856-105. SEE JPF FOR ALL THE SDR AALA202508130082Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR DOOR FORWARD HINGE FITTING SPHERICAL BEARING WORN. MAINTENANCE REPLACED HINGE FITTING PER CMM 52-81-18.SDR DALA2025081306039Indicator · inoperativeSLIDE INDICATOR LIGHT INOP OR DAMAGED / LOCATIONS:601. FOUND DOOR 2 RIGHT LIGHT OUT. REPLACED THE SAME. OK FOR SERVICE.SDR SWAA2025081299366Panel · delaminatedRIGHT SIDE RUDDER SEAL IS DELAMINATED AT RS 288. INSTALLED NEW PANEL REF AMM 55-33-31.SDR SWAA2025081299365Panel · delaminatedRIGHT SIDE RUDDER SEAL IS DELAMINATED AT STATION STA 269. INSTALLED NEW PANEL IAW AMM 55-33-31.SDR SWAA2025081299367Panel · delaminatedRIGHT SIDE RUDDER SEAL IS DELAMINATED AT STATION STA 194. INSTALLED NEW PANEL IAW AMM 55-33-31.SDR SWAA2025081200440Panel · delaminatedRIGHT SIDE RUDDER SEAL IS DELAMINATED AT STATION STA 269. INSTALLED NEW PANEL REF AMM 55-33-31.SDR SWAA2025081200441Panel · delaminatedRIGHT SIDE RUDDER SEAL IS DELAMINATED AT STATION STA 288. INSTALLED NEW PANEL IAW AMM 55-33-31.SDR SWAA2025081200442Panel · delaminatedRIGHT SIDE RUDDER SEAL IS DELAMINATED AT STATION STA 194. INSTALLED NEW PANEL REF AMM 55-33-31.SDR SWAA2025081299322Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ON OVERHEAD BINS AT ROW 17DEF; 21DEF; AND RT LOWER EXTERIOR LIGHT ARE INOPERATIVE. REMOVED & REPLACED, OP CHECKED BATTERY PACK IAW AMM 33-51-06-960-805. BATTERY PACK AND LIGHTS OP CHECKED GOOD.SDR SWAA2025081299320Bulb · inoperativeEMERGENCY LIGHTS ABOVE L1 DOOR 2 EA. BULBS INOPERATIVE. RELAMPED EMERGENCY LIGHTS OVER L1 DOOR AND OPS CHECK GOOD IAW AMM 33-51-01-960-801.SDR SWAA2025081299324Bulb · inoperativeCR RR EMERGENCY LIGHTS ABOVE R1 DOOR 2 EA. BULBS INOPERATIVE. RELAMPED EMERGENCY LIGHTS OVER R1 DOOR AND OPS CHECK GOOD IAW AMM 33-51-01-960-801.SDR SWAA2025081299321Bulb · inoperativeEMERGENCY LIGHTS ABOVE R2 DOOR 1 EA. BULB INOPERATIVE RELAMPED EMERGENCY LIGHTS OVER R2 DOOR AND OPS CHECK GOOD IAW AMM 33-51-01-960-801.SDR MASA2025080700067Anti-Ice System · leakingANTI-ICE WING LEAK 2 WARNING ON EICAS - PLACED ON MELSDR AALA202508120644Sensor · fault messageAIRCRAFT WAS GROUNDED: ON APPROACH AFTER FLAPS 1 SELECTED AND EXTENDED, NOSE GEAR LIGHTS BOTH RED AND GREEN WERE FLASHING AND MOMENTARILY STAYING LIT WITHOUT GEAR BEING ACTUATED. **SUPPLEMENTAL REPORT FOR (AALA202508110644): REMOVED AND REPLACED NOSE GEAR DOWNSDR REXA2025081200802Floorbeam · corrodedCABIN FLOOR CROSSBEAM CORRODED FS 333, RBL 30 AROUND NUT PLATE. COMPLIED WITH MHIRJ REO 690-53-21-1996 REV -- DATED 2025-08-04.SDR REXA2025081200801Lug · damaged"FOUND R/H AILERON SIDE BEARING LUGS LABELED ""B"" AND ""G"" TO BE PREVIOUSLY OVERSIZED. COMPLIED WITH BOMBARDIER REO 670-57-61-237 REV-- DATED 2017-07-25 STEPS F(10-13) THRU G."SDR REXA2025081200800Lug · damaged"FOUND L/H AILERON SIDE BEARING LUGS LABELED ""B"" AND ""G"" TO BE PREVIOUSLY OVER SIZED. COMPLIED WITH BOMBARDIER REO 670-57-61-237 REV-- DATED 2017-07-25."SDR SWAA2025081199623Seat Back · out of positionROW 12 SEAT A SEAT BACK WILL NOT STAY IN UPRIGHT POSITION<[01] ADJUSTED SEAT BACK PER AMM 25-22-00SDR SWAA2025081199231Megaphone · brokenAFT CABIN MEGAPHONE HANDLE BROKEN<[01] REMOVED AND REPLACED AFT CABIN MEGAPHONE IAW SIPSDR SWAA2025081199230Battery · inoperative3EA CABIN EMERGENCY FLASHLIGHTS DEAD.<[01] REMOVED AND REPLACED 1 FWD AND 2 AFT EMERGENCY FLASHLIGHT BATTERIES IAW SIPSDR SWAA2025081199243Flashlight · inoperativeEMERGENCY FLASHLIGHT AFT GALLEY F/O'S SIDEWALL NOT TEST<[01] PREFORMED OPS CHECK OF TEST FUNCTIONS OF ALL AFT GALLEY FLASHLIGHTS OPS CHECK GOOD AND RESEALED AMM 25-64-00SDR SWAA2025081199349Battery · inoperativeFLASHLIGHT @ FLIGHT ATTENDANT STATION D FLASHING RED. R & R ATTENDANT FLASHLIGHT BATTERY REF AMM 25-64-00; OPS CHK GOOD.SDR SWAA2025081199341Slide · looseCREW REPORTS FWD GIRT BAR WILL NOT STAY SECURED WHEN OPENING FWD SERVICE DOOR. REMOVED AND REPACKED FWD SERVICE EMERGENCY ESCAPE SLIDE PER MT 725-61-06.SDR SWAA2025081199625Slide · out of limitsL1 DOOR SLIDE PRESSURE OUT OF LIMITS. REPLACED DOOR L1 ESCAPE SLIDE<BR>IAW MT 725-61-06SDR SWAA2025081199352Actuator · trippedON INITIAL APPROACH FLAPS LOCKED OUT AT 5 DEGREES. PERFORMED A GO AROUND. RECONFIGURED FOR A FLAPS 30 LANDING WITH NORMAL INDICATIONS ON SECOND APPROACH. PERFORMED FSEU BITE PER FIM 27-51 TASK 801. NO FAULTS FOUND. PERFORMED FIM 27-51 TASK 836. FAULT FOUND TSDR SWAA2025081199339Fuel Tank · leakingUPON ARRIVAL TO AIRCRAFT FOND LARGE FUEL SPILL AND LEAKING FROM RIGHT MAIN TANK. FUELED SAID AUTOMATIC SHUTOFF DID NOT STOP. CHECKED FUEL SHUTOFF VALVES NO FAULTS NOTICED PER MM 28-21-51.SDR SWAA2025081199344Lens · detachedCREW REPORTS F.O. SIDE OVERWING EXIT LIGHT LENS COVER DEATTACHED. SECURED WITH TAPE. OK TO CONT. PER EA# MT M-21-133-00720.SDR SWAA2025081199251Light · inoperativeLH AFT FUSELAGE EMERGENCY EXIT LIGHT INOP. REPLACED LH AFT FUSELAGE EMERGENCY EXIT LIGHT IAW AMM 33-51-04-960-801 TEST IS OK.SDR SWAA2025081199075Battery Pack · inoperativePASSENGER CABIN EMERGENCY LIGHTS AT ROWS 20ABC;13ABC INOP. R&R PASSENGER CABIN EMERGENCY LIGHT BATTERY PACKS AT ROWS 20ABC;7ABC 33-51-06. ROW 13ABC BATTERY BACK GOOD.SDR SWAA2025081199183Sill Drain · odorTERRIBLE SMELL COMING FROM AFT GALLEY FLOOR DRAINS<[01] CLEANED AND FLUSHED AFT ENTRY AND AFT SERVICE DOOR SILL DRAINS REF AMM 38-31-00SDR SWAA2025081199000Seal · crackedRIGHT UPPER STABILIZER TO BODY FRONT SPAR SLIDING SEAL IS CRACKED. REMOVED AND REPLACED PER AMM 53-31-31-401 CONFIG 2-NG.SDR SWAA2025081199001Seal · crackedLEFT UPPER STABILIZER TO BODY FRONT SPAR SLIDING SEAL IS CRACKED.REMOVED AND REPLACED PER AMM 53-31-31-401 CONFIG 2-NG.SDR GTIA2025081139040A/C Pack · odorDESCENDING THROUGH 12,000 FEET FUMES NOTICED. PACK ONE OFF CLEARED THE FUMES NO ODOR FROM PACK 2 APPEARS TO BE LIMITED TO COCKPIT ONLY. DESCRIPTION OF ODOR/FUMES: PERSISTENT, OIL/BURNING OIL SMELL. APPARENT CABIN SOURCE: UNKOWN, FLIGHT DECK. NO VISIBLE SMOKE/HSDR GTIA2025081139039Flashlight · no testONE FORWARD CABIN, FLIGHT ATTENDANT SEAT FLASHLIGHT TESTED INOPERATIVE. FLASHLIGHT AND HOLDERS, FLIGHT DECK OR CABIN. R & R FWD FA FLASHLIGHT IAW AMM 25-65-52. THIS CLEARS DMI 3569439-1 PLACARD REMOVED.