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 AALA202508145638Transducer · faultedAIRCRAFT WAS GROUNDED: CREW PRESSURE O2 INDICATION INOP. DECESION MADE TO RETURN TO DFW. MAINTENANCE REPLACED CREW OXYGEN CYLINDER PRESSURE TRANSDUCER IAW AMM 35-11-03.SDR GTIA2025081439047A/C Pack · odorAQE PACK 1 OIL SMELL ON DESCENT, QRH PROCEDURE FOR PACK 1 COMPLIED WITH SMELL DISSIPATED. DESCRIPTION OF ODOR/FUMES: PERSISTENT, OIL/OIL BURNING SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK, FWD CABIN/GALLEY (LAV), MID CABIN, AND AFT CABINSDR GTIA2025081439046Egt Indication · illuminatedENG 2 EGT OVRLMT ON TOGA TAKEOFF-PERFORMED INSPECTION (GVI) OF THE ENG #2 EXHAUST AREA IAW AMM 72-00-00-210-812-A (REF TSM 71-00-00-810-855-A) OPS CHECK AND GVI INSPECTION GOOD. NO DEFECTS NOTED. A/C OK FOR SERVICESDR GTIA2025081439045Flashlight · no testAFT FA FLASHLIGHT INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R&R AFT FA FLASH LIGHT IAW SPIRIT DRAWING A320 EMERGENCY EQUIPMENT LAYOUT THIS CLEARS MDDR 117239 PLACARD FREMOVED MOC # 62154SDR SWAA2025081403397Skin · crackedCRACKED SHEETMETAL AT LOWER CUTOUT OF EXTERNAL ACCESS POWER DOOR. REPAIRED DAMAGED LOCATION PER SRM 53-10-15-2R-4. PERFORMED HIGH FREQUENCY EDDY CURRENT (HFEC) INSPECTION OF THE TRIM OUT EDGE IAW NDT PART 6; 51-00-00; PROCEDURE 23. NO DEFECTS NOTED.SDR SWAA2025081403226Light · missingPASSENGER CABIN SEAT ROW 24ABC PHOTOLUMINESCENT STRIP MISSING OR CARPET MISSING BEHIND SEAT. INSTALLED MISSING PHOTOLUMINESCENT STRIP PER AMM 33-51-15.SDR SWAA2025081403550Lamp · inoperativeCENTER AISLE AFT EMERGENCY EXIT SIGN HAS 2 LIGHTS INOP. RELAMPED CENTER AISLE AFT EMERGENCY EXIT SIGN REF AMM. 33-51-01. OPS CHECKS GOOD AT THIS TIME.SDR SWAA2025081403232Skirt · frayedAFT GALLEY SERVICE DOOR EMERGENCY EXIT SLIDE SKIRT WORN AND FRAYED. R & R AFT GALLEY SERVICE DOOR EMERGENCY EXIT SLIDE IAW AMM 25-66-01. INSPECTION C/W R&R AFT GALLEY SERVICE DOOR EMERGENCY EXIT SLIDE IAW AMM 25-66-01SDR SWAA2025081403416Elec Connector · disconnectedRIGHT FWD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RECONNECTED OVERWING EXIT LIGHT ASSEMBLY CONNECTOR AT ROW 14DEF (RH FWD SIDE) OPS CK GOOD FOR EMERGENCY EXIT LIGHT PER AMM 33-21-00.SDR SWAA2025081403931Lens · detachedCTR AISLE OVHD EXIT SIGN LENS FELL OUT. SECURED LENS REF AMM 33-51-01.SDR SWAA2025081403470Bulb · inoperativeOVERHEAD EMERGENCY BULB AT RH FWD SERVICE DOOR INOP. REMOVED AND REPLACED IAW AMM 33-51-01-960-801.SDR SWAA2025081403546Battery Pack · failedFORWARD LEFT HAND OVERWING UPPER AND LOWER EXIT SIGNS FAIL OPERATIONAL CHECK<[01] REMOVED AND REPLACED BATTERY AND BATTERY CHARGER AT M1694 IAW SWA B737-800 AMM 33-51-06. PERFORMED A GOOD OPERATIONAL TEST OF THE FORWARD LEFT HAND OVERWING UPPER AND LOWER EXIT SDR SWAA2025081403545Light · no testRIGHT FORWARD OVERWING LOWER EXIT LIGHT DOES FAILS OPERATIONAL TEST. PERFORMED A GOOD OPS CHECK OF THE RT FORWARD OVERWING LOWER EXIT LIGHT IAW AMM 33-51-00. REFERENCE TASK CARD TTG8Q014HXFW. PERFORMED A GOOD OPERATIONAL CHECK OF THE RT FORWARD OVERWING SDR SWAA2025081403172Battery · no testCAPT EMERGENCY FLIASHLIGHT WILL NOT TEST. R & R CAPT FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR DXTA2025081404584Battery Pack · defectiveEMERGENCY LIGHTS STAY ON WHEN SWITCH IS IN THE ARM POSITION, AIRCRAFT ON THE GROUND TRIED WITH GPU CONNECTED AND GPU DISCONNECTED. CORRECTIVE ACTION: REPLACED #1 AND #2 EMERGENCY LIGHTING BATTERY OPS CHECK GOOD WORD DONE IAW EMBRAER EMB-505 AMMSDR DALA2025081406071Skin · corrodedSHIP 3146 CORROSION FOUND ON LHWING TOP SKIN PANEL 2, TEOH, UPPER AN LOWER SURFACES. CORRECIVE ACTION: COMPLIED WITH ER/A 627460-14. (1140343).SDR ANCF2025081400224Engine · vibrationENG 1 FAIL REQUEST TO DOWNLOAD FDR DURING INITIAL TAKEOFF, WHEN T.O THRUST WAS APPLIED. A LOUD BANG FROM THE ENG 1 LEFT SIDE WAS HEARD, FOLLOWED BY AN ENG FAIL ECAM, VIBRATIONS COMING FROM THAT SIDE COOLD BE FELT.SDR YENA2025081400837Smoke Detector · failedFLT#1752, SJU-TPA. "LAV B SMOKE DETECTOR INTERMITTENTLY GOING OFF; REMOVED AND REPLACED LAV F SMOKE DETECTOR IAW AMM 26-17-15. CHECKS OK."SDR CALA2025081407763Window Frame · crackedDEFECT NON-ROUTINE ESR #002, REQUESTING ENGINEERING SUPPORT FO R EA5310-08195 REVISION C, RH SIDE NUMBER 3 WINDOW FRAME POST - PERMANENT REPAIR OP 004. CRACK SIGNAL NOTED AT #4 HOLE (BOTTOM TO TOP), HOLE WAS REAMED AT 0.297 IN DIAMETER, CRACK SIGNAL CONTINUE.SDR CALA2025081407762Window Frame · crackedDEFECT NON-ROUTINE ESR #003, REQUESTING ENGINEERING SUPPORT FOR EA5310-08195 REVISION C ?LH SIDE NUMBER 3 WINDOW FRAME POST - PERMANENT REPAIR OP 003. CRACK SIGNAL NOTED AT #3 HOLE AT 3O?CLOC K POSITION, HOLE WAS REAMED AT 0.297 IN DIAMETER, CRACK SIGNAL CONTISDR CALA2025081407733Beam · corrodedFORWARD LARGE CARGO DOOR LOWER BEAM BS 562.4 - 575.6. ALL OF STEPS OF ECRA 5233-01037 WERE ACCOMPLISHED WITHOUT DEVIATION.SDR CALA2025081407732Packing · leakingODOR IN CABIN DURING APU VISUAL INSPECTION, FOUND APU FCU LEAKING FUEL AT IGV ACTUATOR LINES ON FCU SIDE, R & R FUEL DRAIN, RETURN TUBE & TWO SUPPLY TUBE PACKINGS TO FCU IAW AMM 49-31-01-004-001-001. OPS & LEAK CHECKS PERFORMED. NO LEAKS NOTED. PERFORMED CHECSDR CALA2025081407723Slide · faultedREMOVED AND REPLACED DOOR L2 SLIDE UP TO STEP E(5) IAW AMM 25-66-01, DUE TO NO POWER ON THE ACFT. TURN THE EPAS BATTERY SAFETY SWITCH TO THE ARM POSITION AND COMPLETED TASK CARD 23-2566-1-2011.SDR CALA2025081407722Girt Bar · misinstalledGIRT BAR BRACKET ON LEFT SIDE OF DOOR L1 IS LOOSE. INSPECTED BOTH DOOR SIDE AND ACFT SIDE BRACKETS AND FOUND NO DEFECTS, FOUND GIRT BAR NOT PROPERLY INSTALLED IN BRACKET. SET GIRT BAR IN BRACKET, IAW AMM 25-66-01, 25-66-02, 25-66-00. OK FOR SERVICE.SDR CALA2025081407721Lanyard · out of positionR2 SLIDE PACK HAS LANYARD HANGING OUT, FOUND THE R2 DOOR SLIDE PACK AFT COVER PIN LANYARD SLIGHTLY PROTRUDING BESIDE SLIDE PACK, PIN NOT DISLODGED, REPOSITIONED LANYARD.SDR CALA2025081407720Girt Bar · obstructedL4 DOOR WILL NOT ARM. FOUND SLIDE STRING BLOCKING GIRT BAR MECHANISM. SECURED STRING ON L4 SLIDE IAW AMM 52-11-25. VERIFIED DOOR L4 SLIDE ARMS CORRECTLY.SDR CALA2025081407719Handle · unsecureRTO APPROX 100KTS FWD ENTRY DOOR LIGHT FAS INDICATE HANDLE POPPED, DEBRIEF CREW FOR ENTRY DOOR LIGHT, ON AT 80 KNOTS. REJECTED TAKEOFF BRAKES ENGAGED AT ABOUT 100 KN FLIGHT ATTENDANT REPORTED L1 DOOR HANDLE WAS UP ABOUT 2 INCHES. L1 DOOR HANDLE FEELS A LITTSDR CALA2025081407714Light · malfunctionedEMERGENCY EXIT LIGHTS AFT GALLEY CAME ON DURING TAKEOFF ROLL, STAYED ON FOR ABOUT 3-5 MINUTES. UNABLE TO DUPLICATE, PERFORMED EMERGENCY LIGHT TEST IAW MM 33-51-00. OPS CHECKED GOOD.SDR CALA2025081407713Light · unsecure34C EMERGENCY LIGHT CONTAINER IS HANGING RESECURED. EMERGENCY LIGHT CONTAINER AT SEAT 34C IN REF WITH AMM 33-51-11-960-802, OPS CHECK GOODSDR DALA2025081306047Sensor · faultedSHIP 3259 - DIV - TO MAF DUE TO LT ENG BLEED OVER-TEMP WITH RT PACK UNABLE TO MAINTAIN CABIN. MASKS DID NOT DEPLOY. CORRECTIVE ACTION: LEFT ENGINE BLEED TEMP SENSOR TRIGGERING FALSE HIGH TEMPERATURE DUE TO A FAULTY SENSOR. FOUND BELLOWS TORN ON THE RT PACK. RESDR HALA20250813246Cabin Pressure · malfunctionedDIV - AVIONICS DOOR OPEN IN FLIGHT MESSAGE A/C NOT PRESSURIZING NORMALLY. PERFORMED VISUAL INSPECTION OF AVIONICS DOOR. PERFORMED PRESSURIZATION TEST FOR AIR LEAKS PER AMM 05-53-00. NO DEFECTS NOTED. OK TO CONTINUE.SDR ASAA2025081260043Cover · missingEXIT LIGHT COVER MISSING ROW 16 EXIT ROW A/C LEFT. GROUNDED - YES. REMOVED AND REPLACED EXIT FLOOR LIGHT ASSY AT ROW 16 ABC. OPS CHECK GOOD. REF AMM 33-51-01-960-802.SDR DALA2025081306069Doubler · crackedSERVICE PANEL CUTOUT, INTERNAL DOUBLER WITH CRACK INDICATION IN 1 (E.A.) OPEN HOLE DUE TO CORROSION AT FR65, STGR 39RH. REPLACED INTERNAL DOUBLER IAW A319 SRM 53-41-11-53A.SDR DALA2025081306068Doubler · corrodedLOWER AFT FUSELAGE AT FR 65 BETWEEN STGR 38R AND STGR 40R, TOILET SERVICE PANEL INTERNAL DOUBLER WITH CORROSION. REPAIR PERFORMED WITH ORNRC 100-63.SDR DALA2025081306062Skin · corrodedCORROSION FOUND ON LHWING TOP SKIN PANEL 2 TEOH, UPPER AN LOWER SURFACES. REPAIRED PER ER/A 31-627460.SDR DALA2025081306061Skin · corrodedCORROSION FOUND ON LH WING TOP SKIN PANEL 2 TEOH, UPPER AN LOWER SURFACES. REPAIRED PER ER/A 31-627460.SDR DALA2025081306060Access Panel · crackedCRACKED ACCESS PANEL 423DL ON RH PYLON. REPAIRED PER ER/A 540187-14.SDR DALA2025081306059Structure · damagedFOUND LAMINATE DAMAGED IN FWD GALLEY. REPLACED LAMINATE PER P.S. 900-9-1-11.SDR DALA2025081306058Fitting · corrodedCORROSION BORE SPIGOT FITTING RECEPTACLE ON RH PYLON. REPLACED BORE SPIGOT FITTING ON RH PYLON AS PER A319 SRM 54-51- 12-300-001 AND A319 SRM 54-51-12-283-001. AND A319 SRM 51-44-11- 801 AND A319 SRM 51-74-00.SDR DALA2025081306057Bearing · looseLEFT WING O/B MAIN FLAP I/B SPHERICAL BEARING LOOSE. COMPLIED WITH ER/A 627489-14.SDR MTNA20250813001Warning Light · illuminatedON THE TAKEOFF ROLL, BELOW V1, ENGINE OIL LOW PRESSURE MASTER WARNING ILLUMINATED EXTINGUISHED THEN ILLUMINATED AGAIN TAKEOFF ABORTEDSDR SWAA2025081303565Circuit Breaker · brokenCABIN EMER LIGHTS C/B BROKEN OFF. R & R CABIN EMERGENCY LIGHT BREAKER IAW WDM #33-51-11. OPS CK GOOD. ALSO SWPM 20-30-00.SDR IXXA20250812043Relay · unknownMULTIPLE EICAS MESSAGE WITH STANDBY POWER AUTO DURING DESCENT FL290. EMERGENCY DECLARED TO KCVG. AIRCRAFT LANDED WITHOUT INCIDENT NO OTHER PRECAUTIONARY ACTIONS TAKEN. AIRCRAFT WAS GROUNDED FOR INSPECTION AND MAINTENANCE. LINE MAINTENANCE REMOVED AND REPLACED SDR FDEA202508121416Floor Panel · damagedHOLE ON FLOOR PANEL 252 MFF ON MAIN DECK. HOLE ON FLOOR PANEL 252 MFF ON MAIN DECK WAS REPAIRED I.A.W. B767 S.R.M. 53-00-50-2R REP 4.B. FIG. 201 REV. 92, APR 15, 2025.SDR FDEA202508121414Floor Panel · damagedPUNCTURE ON UPPER SURFACE OF FLOOR PANEL 231 QFF AT SEC. 43 OF MDC. UPPER SURFACE OF FLOOR PANEL 231 QFF, AT SEC. 43 OF MDC, WAS REPAIRED I.A.W. B767 S.R.M. 53-00-50-2R REP 4.B. FIG. 201 REV. 92, APR 15, 2025.SDR FDEA202508121413Floor Panel · crackedCRACK ON UPPER SURFACE OF FLOOR PANEL 232 DFF, SEC. 43, MDC. UPPER SURFACE OF FLOOR PANEL 232 DFF, SEC. 43, MDC, WAS REPAIRED I.A.W. B767 S.R.M. 53- 00-50-2R REP 4.B. FIG. 201 REV. 92, APR 15, 2025.SDR FDEA202508121412Floor Panel · crackedCRACK ON UPPER SURFACE OF FLOOR PANEL 231EFF, SEC. 43, MDC. UPPER SURFACE OF FLOOR PANEL 231EFF, SEC. 43, MDC WAS REPAIRED I.A.W. B767 S.R.M. 53-00- 50-2R, REP. 4.B. FIG. 201, REV. 92 APR 15, 2025.SDR FDEA202508121411Floor Panel · crackedCRACK ON UPPER SURFACE OF FLOOR PANEL 221GFF SECTION 41, MDC. UPPER SURFACE OF FLOOR PANEL 221GFF SECTION 41, MDC, WAS REPAIRED I.A.W. B767 S.R.M. 53-00-50-2R, REP 4B, FIG. 201 REV. 92 APR 15, 2025SDR FDEA202508121409Selector Valve · faultedLANDING GEAR WOULD NOT RETRACT AFTER TAKE-OFF. L/G RETRACTION FAULT ON ECAM. EMERGENCY DECLARED. COMPLIED WITH ECAM AND QRH. EMERGENCY DECLARED. AMM: 32-31-12-04, REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE 3GA, OPS AND LEAK CHECK GOOD IAW ABOVE AMSDR FDEA202508121415Floor Panel · damagedPUNCTURE ON UPPER SURFACE OF FLOOR PANEL 231 SFF, AT SEC. 43 OF MDC. UPPER SURFACE OF FLOOR PANEL 231 SFF, AT SEC. 43 OF MDC, WAS REPAIRED I.A.W. B767 S.R.M. 53-00-50-2R PAR 4.B. FIG. 201 REV. 92, APR 15, 2025.