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 CALA2025091709002Door · out of adjustFLIGHT CREW INDICATED DURING CREW DEBRIEF THAT LANDING GEAR FAILED TO RETRACT. DURING INITIAL EVALUATION FOUND ALT GEAR EXT HANDLE DOOR IN COCKPIT NOT SEATED. CREW INDICATED CYCLED ALT GEAR EXT HANDLE DOOR & VERIFIED CLOSED. ATTEMPED ANOTHER GEAR RETRACTIONSDR CALA2025091708987Slide · no discrepancySLIDE STICKING OUT OF GIRT BAR DOOR 1L INSPECTED 1L SLIDE PACK ORIENTATION, Z FOLD CORRECT AND CORRECT SLIDE PRESSURE GOOD REF AMM 25-66-01-200-802.SDR ASAA2025091460908Lamp · burned outROW 16 CEILING EMERGENCY EXIT LIGHT BURNED OUT. GROUNDED - YES. RELAMPED ROW 16 EMERGENCY EXIT LIGHT REF AMM 33-21-00 OPS CHECK GOOD.SDR SWAA2025091614190Megaphone · inoperativeAFT MEGAPHONE AFTER MEGAPHONE WILL NOT TEST. R & R AFT MEGAPHONE IAW AMM 25-64-00.SDR SWAA2025091614587Battery · dischargedAFTER EMERGENCY FLASHLIGHT HAS DEAD BATTERY. REMOVED AND REPLACED AFT EMERGENCY FLASHLIGHT BATTERY PER AMM 25-64-00.SDR SWAA2025091614412Battery · inoperativeLH FWD EMERGENCY EXIT LIGHTS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY AT ROW 7 LT IAW AMM 33-51-06.SDR SWAA2025091614417Battery · inoperativeLH EMERGENCY. EXIT LIGHTS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY AT LT 12CBA POSITION.SDR DALA2025091606814Door · out of alignmentDIVERTED TO STL DUE TO INTERMITTENT AIRFRAME VIBRATION ABOVE 270KTS, SLOWED TO 250KTS AND VIBRATION STOPPED. FOUND RIGHT NOSE GEAR DOOR GAP MUCH LARGER THAN LEFT NOSE GEAR DOOR GAP, ADJUSTED GAP ON RIGHT DOOR AND PERFORMED PRELOAD CHECK AND FINAL ADJUSTMENT.SDR IPXA2025091401260Panel · crackedNUMBER 2 ENG BETWEEN 2 & 4 O CLOCK 2 PANEL CRACK OUTTER PANEL ABOVE IGNITER PLUG. DURING BORESCOPE INSPECTION, FOUND CRACKS ON PANELS 1 AND 2 AT THE 2/4 O'CLOCK POSITION ON THE COMBUSTION OUTER LINER. ITEM DEFERRED WRT B767 MM 72-00-00-206-361-H00 TABLE 684SDR IPXA2025091401257Panel · crackedNUMBER 2 ENG BETWEEN 12 & 1 O CLOCK 2 PANEL CRACK OUTTER PANEL. DURING BORESCOPE INSPECTION, FOUND CRACK(S) ON PANELS 1 AND 2 AT THE 12/1 O'CLOCK POSITION ON THE COMBUSTION OUTER LINER. ITEM DEFERRED WRT B767 MM 72-00-00-206-361-H00 TABLE 684.SDR IPXA2025091401263Panel · crackedNUMBER 2 ENG BETWEEN 5 & 6 O CLOCK POS 2 PANEL CRACK OUTTER PANEL. DURING BORESCOPE INSPECTION, FOUND CRACKS ON PANELS 1 AND 2 AT THE 5/6 O'CLOCK POSITION ON THE COMBUSTION OUTER LINER. ITEM DEFERRED WRT B767 MM 72-00-00-206-361-H00 TABLE 684.SDR IPXA2025091401278Panel · crackedNUMBER 2 ENG BETWEEN 9 & 8 O CLOCK 2 PANEL CRACK OUTTER PANEL. DURING BORESCOPE INSPECTION, FOUND CRACKS ON PANELS 1 AND 2 AT THE 9/8 O'CLOCK POSITION ON THE COMBUSTION OUTER LINER. ITEM DEFERRED WRT B767 MM 72-00-00-206-361-H00 TABLE 684.SDR IPXA2025091401250Panel · crackedNUMBER 2 ENGINE BETWEEN 4 & 5 O`CLOCK, PANELS CRACKED OUTTER PANEL BY LWD IGNITER PLUG. DURING BORESCOPE INSPECTION, FOUND CRACKS ON PANELS 1 AND 2 AT THE 4/5 O'CLOCK POSITION ON THE COMBUSTION OUTER LINER. ITEM DEFERRED WRT B767 MM 72-00-00-206-361-H00 TABLESDR DALA2025091606807Battery Pack · no test(LOG 7203154) DURING SERVICE CHECK FOUND EMERGENCY CEILING LIGHTS ROW 3-15 ABC OUT. R/R EMERGENCY BATTERY PACK PER B737 AMM 33-51. OPS CHECK NORMAL.SDR DALA2025091606806Wire · detached(LOG 7286655) DURING SVC CHECK FOUND AISLE EMERGENCY LIGHTS OUT AT ROWS 28 THRU 32 FED. RECONNECTED WIRES FOUND UNDER SEAT 32FED IAW B737 SWPM 20-30. OPS CHECK GOOD.SDR DALA2025091606802Light · detached(LOG 7512788) EMERGENCY LIGHT ON OVERHEAD AT 13F FELL OFF. REINSTALLED LIGHT ASSY PER B737 AMM 33-20.SDR DALA2025091606800Wire · broken(LOG 7612544) DURING SVC CHECK FOUND EMERGENCY LIGHT INOP AT 24DEF. FOUND GROUND WIRE BROKEN UNDER SEAT 24E. REPAIRED WIRE REF B737 WDM 33-51. OPS CHECK GOOD IAW B737 AMM 33-51.SDR DALA2025091606799Window Frame · cracked(LOG 1198897) CRACK ON 1 LH WINDOW FRAME OF: 0.625IN. NO1 LH WINDOW FRAME WAS REPAIRED PER ER/A 619132-14ADTR REV. A SECTION I PERMANANT REPAIR.SDR DALA2025091606805Battery Pack · no test(LOG 7847518) 3 EMERGENCY CEILING LIGHTS LT SIDE ARE OUT. R/R BATTERY M233T. OPS CHECK GOOD.SDR DALA2025091606804Battery Pack · no test(LOG 7612414) DURING SVC CHK FOUND FWD LEFT EMERGENCY EXIT LIGHT NOT ILLUMINATED. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK (M1675) PER B737 AMM 33-51. OPS CHK GOOD.SDR AALA202509162173Brake · overheatedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO PHX DUE TO THE FLIGHT CREW REPORTING A BRAKES HOT ILLUMINATED IN FLIGHT AT FL250 FOR THE RIGHT INBOARD BRAKE. THE AIRCRAFT LANDED SAFELY AT PHX AND TAXIED TO THE GATE UNDER ITS OWN POWER, MAINTESDR AALA202509164040Light · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY EXIT LIGHT ON SEAT ROW 28 FOUND TO BE INOPERATIVE DURING SYSTEM TEST. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA202509163830Outlet · meltedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORTED ELECTRICAL SMELL, BURNING SMELL IN THE LAST THREE ROWS OF THE AIRCRAFT ASKED THE PASSENGERS TO UNPLUG ANY DEVICES. THEY HAD PLUGGED INTO THE POWER PORTS, AND THE SMELL SEEMED TO DISSIPATE. MAINTENANCE FOUND THESDR AALA202509169932Elec Connector · not seatedAIRCRAFT WAS GROUNDED: OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROW 27 INOPERATIVE ON BOTH SIDES. MAINTENANCE RESEATED EMERGENCY EXIT LIGHT CONNECTOR AT SEAR ROW 17 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202509164137Bottle · low pressureAIRCRAFT WAS GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509166634Light · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY EXIT LIGHT ON SEAT ROW 27 FOUND TO BE INOPERATIVE DURING SYSTEM TEST. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA202509168767Bottle · low pressureAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS CIDS PANEL SHOWS CHECK DOOR PRESSURE AT 1R. MAINTENANCE SERVICED R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509167822Battery · no testAIRCRAFT WAS NOT GROUNDED: 2R DOOR FLIGHT ATTENDANT JUMPSEAT EMERGENCY FLASHLIGHT CHARGE LIGHT NOT FLASHING. MAINTENANCE REPLACED FLASHLIGHT BATTERY AS REQUIRED.SDR AALA202509161938Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509162186Pin · defectiveAIRCRAFT WAS GROUNDED: 2R DOOR ARMING LEVER BENT INWARD. MAINTENANCE REPLACED THE R2 DOOR ARMING LEVER GRIP PLATE ANTI-ROTATION PIN PER AMM 52-22-22. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202509167858Door · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WOULD ONLY OPEN WHEN THE HANDLE WAS TURNED COUNTERCLOCKWISE. MAINTENANCE CLEANED, LUBED FLIGHT DECK DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-00SDR AALA202509163213Arming Lever · looseAIRCRAFT WAS NOT GROUNDED: DOOR 3R RIGHT ARMING MECHANISM IS LOOSE. MAINTENANCE TIGHTENED ARMING MECHANISM ON 3R DOOR PER AMM 52-21-00.SDR CALA2025091608954Battery Pack · faultedEVAC LIGHTS ON IN ECON CABIN REPLACED BATTERY PACK AT DOORS 4L. R& R, PACKS M33407, M33408 & M33409 REF MM 33-51-06-960-802, ALL EXIT LIGHTS CK OK.SDR CALA2025091608953O-Ring · leakingLOSS OF HYDRAULIC SYSTEM B PRESSURE AND QUANTITY IN FLIGHT. FOUND B SYS QTY AT ZERO. FOUND LEAK AT B SYS HYD MODULE PLUG. REPLACED PLUG ORING RETORQUED AND SAFTEID. WILL NEED LEAK CHECK WHEN HYDRAULICS ARE RESTORED. FOUND "B" SYSTEM HYDRAULIC RESERVOIR AT 0% SDR CALA2025091608952Attach Angle · crackedRT AIR CONDITIONER BAY AFT UPPER ANGLE CRACKED ON IB SIDE. REF. AAR N/R:99950870 ESFR TRANSACTION COMPLETE REMOVED DAMAGED SECTION AND INSTALLED REPAIR AT STA 663 RH VAPOR BARRIER UPPER ATTACH ANGLE AND SPLICE FROM RBL5 TO RBL30 PER PER SRM 57-10-10-2R-5.SDR CALA2025091608950Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP REMOVED AND REPLACED L2 DOOR EMERGENCY LIGHT IN REF WITH AMM 33-51-04. OPS CHECK GOOD.SDR DXTA2025091604975Battery Pack · faultedFORWARD CABIN EMERGENCY LIGHTS COME ON FOR A FEW MINUTES THEN GO OUT FOR AWHILE AND THEN COME BACK ON FOR A FEW MINUTES, REPEATEDLY. REMOVED BOTH EMERGENCY BATTERY PACKS AND INSTALL OPERATOR SUPPLIED BATTERY PACKS PER AMM 33-52-01. ALL OPS CHECKS GOOD, NO FSDR HALA20250915279Pump · leakingETOPS - LEAKING COMING FROM #2 ENG DRAIN MAST. HAYDRAULIC PUMP#1. #2 ENG G HYD. EDP. REMOVED AND INSTALLED UP TO STEP 4. D. 19 OF AMM 29-11-51-400-805-A.REPLACED ENG 2 G HYD EDP MOUNTING NUTS PER AMM 29-11-51. PERFORMED LEAK CHECK AND ENGINE RUN PER AMM 29-11-SDR HALA20250915280Pump · leakingETOPS - LEAKING COMING FROM #2 ENG DRAIN MAST. HAYDRAULIC PUMP#1. #2 ENG G HYD. EDP. REMOVED AND INSTALLED UP TO STEP 4. D. 19 OF AMM 29-11-51-400-805-A.REPLACED ENG 2 G HYD EDP MOUNTING NUTS PER AMM 29-11-51. PERFORMED LEAK CHECK AND ENGINE RUN PER AMM 29-11-SDR HALA20250915278Gauge · abnormalETOPS - ACCUMULATOR GAUGE WAS FILLED WITH HYDRAULIC FLUID. REMOVED AND REPLACED GREEN SYSTEM ACCUMULATOR AND PRESSURE GAUGE. OPS CHECK GOOD, OKAY FOR SERVICE PER AMM 29-11-42.SDR ASAA2025091460881Gust Lock · frozenL1 GUST LOCK FROZEN, UNABLE TO CLOSE L1 DOOR. GROUNDED - YES. CLEANED AND LUBED GUST LOCK ON L1 DOOR REF MM 52-11-00, OPS GOOD.SDR AALA202509155454Seal · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC PRESSURE DURING FLIGHT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DTW. NUMBER 2 ENGINE DRIVEN HYDRAULIC PUMP DRIVE PAD SEAL ON THE GEAR BOX REQUIRES REPLACEMENT DUE TO PUMP FAILURE AND HEAT. RESDR SWAA2025091514592Slide · out of limitsR2 SLIDE OUT OF LIMITS. REMOVED AND REPLACED THE R2 SLIDE IAW AMM 25-60 6-01.SDR SWI2025F01311Warning Message · activatedFLAPS FAIL. ON CLIMB SEQUENCE (FLIGHT 5754 - FILED CLOSED)RESET AND OPERATED FLAPS 5 FUL CYCLES AND COMPETED AD 2009-16-12/10 COMPLIANCE FORM OK TO CONTINUE IN SERVICE FOR 10 FLIGHT CYCLES COMPLIED WITH IN ACCORDANCE WITH FIM FMRP CHAPTER 27 RESET PROCEDURESDR SWIA2025091500014Valve · misinstalledL BLEED DUCT WARNING AND CAUTION MESSAGE TOGETHER (FLIGHT 6452)UPON ARRIVAL TO AIRCRAFT WHEN FLIGHT CREW WAS ONBOARD AND DEBOARDING PASSENGERS, L BLEED DUCT WARNING WAS NOT PRESENT ON EICAS. INTERROGATED MDC AND FOUND CODE 349536. PERFORMED BLEED LEAK EVENTSDR DALA2025091506794Transmitter · faultedDE/FCNT- DUE TO TRAILING EDGE FLAP ASYM MESSAGE. REPLACED RIGHT FLAP POSITION TRANSMITTER. (LP 7354652, 1198726)SDR DALA2025091506793Shim · migratedRIGHT WING L/E INBD DRAG FITTING HAS SHIM MIGRATION AT LOCATION (1, A) FIGURE 4, AT AFT I/B SIDE OF FITTING PER AD CARD #5720-01100-02B. REPLACED RIGHT WING LE INBD DRAG FITTING SHIM IAW ERA 628611-14AD. (LP 1198810)SDR DALA2025091506792Light · malfunctionedOVERHEAD EMERGENCY LIGHTS ILLUMINATED DURING FLIGHT. T/S PER 33-51-00-810-881-A. NO FAULTS NOTED. ALL OPS NML. (6999584).SDR DALA2025091506791Light · malfunctionedEMERGENCY LIGHTS TURN ON AND OFF RANDOMLY. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00-710- 008. (6999582).SDR DALA2025091506790Light · illuminatedOVERHEAD EMERGENCY LIGHTS ILLUMINATED. PERFORMED OPS CK OF EMERGENCY LIGHTS IAW AMM 33-51. (6999580).