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 VNAA202508280034Seat Track · corrodedRH SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 863 AND FS 969 RH SIDE SEAT RAIL AT STGR 15R BETWEEN FS 863 AND FS 969 WAS FOUND TO BE OUT OF LIMITS IAW CRJ700 SRM 53-51-49-101-001-A01. REQUIRES REPLACEMENT. INSTALLED NEW SERVICEABLE SEAT TRACK AT RH SDR VNAA202508280033Seat Track · corrodedRH SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 785 AND FS 863. REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A03. SH670-36260-5SDR VNAA202508280032Seat Track · corrodedRH SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 712 AND FS 761 REMOVED R/H SIDE SEAT TRACK AT STGR 15R BETWEEN FS 712 - FS 761 IAW CRJ-700 AMM 53-00-49-000-801-A03. RH SIDE SEAT RAIL AT STGR 15R, FS 712-761 FABRICATED ON HN00245299, SO# 400415030. COMPLIESDR VNAA202508280031Seat Track · corrodedRH SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 677 AND FS 712. CORRECTIVE ACTION: REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A03. PN SH670-36255-3SDR VNAA202508280030Seat Track · corrodedSIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 572 AND FS 677. INSTALLED NEW SERVICEABLE RH SIDE SEAT RAIL AT STGR 15R BETWEEN FS 572 AND FS 677 IAW CRJ-700 AMM 53-00-49-400-801-A03. (PN- SH670-33558-3).SDR VNAA202508280029Seat Track · corrodedTHE RH SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 485 AND FS 572. CORRECTIVE ACTION: REMOVED RH SIDE SEAR RAIL AT STGR 15R IAW CRJ700 AMM 53-00-49-000-801-A03. FABRICATED NEW SEAT TRACK FROM EXTRUSION PN: 0276-288-0-0 IAW MHIRJ REO 670-53-00-589. REV-C SDR VNAA202508280028Seat Track · corrodedLH SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 677 AND FS 712. LH SIDE SEAT RAIL AT STGR 15L IS BETWEEN FS 677 AND FS 712 FOUND TO BE OUT OF LIMITS DUE TO MULTIPLE DAMAGED AREA IAW CRJ700 SRM 53-41-49-101-001-A01. REMOVED LH SIDE SEAT RAIL AT STGR 15L BESDR VNAA202508280027Seat Track · corrodedLH SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 572 AND FS 677. REMOVED LH SIDE SEAT RAIL AT STGR 15L BETWEEN FS 572 AND FS 677 FOR REPLACEMENT. IAW CRJ-700 AMM 53-00-49-000-801-A03. INSTALLED NEW SERVICEABLE LH SIDE SEAT RAIL AT STGR 15L BETWEEN FS 572 ASDR VNAA202508280026Panel · mechanic error"PANEL 522BL HAS ONE DRILL START NEXT TO A FASTENER HOLE MARKED WITH RED TAPE. FOUND THE DRILL START ON LEADING EDGE PANEL 522BL TO BE OUT OF LIMITS IAW CRJ-700 SRM 57-41-01-101-001-A01.
PERFORMED REPAIR BY COMPLYING WITH MHIRJ REO 670-57-41-621 REV -- DATESDR VNAA202508280025Bracket · corrodedWHEEL BIN FWD. I/B MOUNT BRACKETS 2 EA. AT FS 797 LBL14 AND RBL 14 HAVE AREAS OF FRETTING CORROSION ON VERTICAL SURFACE (WHEEL BIN MOUNT). (THIS SDR IS WRITTEN FOR THE LBL BRACKET.) REMOVED LH WHEEL BIN FWD IB BRACKET AT FS 797 LBL 14 IAW CRJ 700 SRM 51-42-21-SDR VNAA202508280024Bracket · corrodedWHEEL BIN FWD. INBD MOUNT BRACKETS 2 EA. AT FS 797 LBL14 AND RBL 14 HAVE AREAS OF FRETTING CORROSION ON VERTICAL SURFACE (WHEEL BIN MOUNT) REQUIRING BLENDING AND EVALUATION AND BARE METAL ON HORIZONTAL ANGLES WITH DISTORTED SEALANT BEDS REQUIRING STRIPPING ANDSDR VNAA202508280023Skin · corrodedEXTERNAL SKIN AT FS607-FS594 STGR19R-26R IS CORRODED BENEATH SEALANT BED ALONG ENTIRE LENGTH. COMPLIED WITH MHIRJ REO 670-53-31-1030 REV: -- .SDR VNAA202508280022Attach Bracket · corrodedBOTH SIDES OF BOTTOM/AFT ATTACHMENT BRACKET FOR PANEL 586BB IS CORRODED. REMOVED AND REPLACED 4 EACH BRACKETS, 2 EACH CC670-14188-3, 1 EACH CC670-14192-3, AND 1 EACH CC670-14193-3 AT WS 129.537 IAW CRJ-700 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, AND SDR VNAA202508280021Skin · gougedFUSELAGE OUT SKIN IS GOUGED IN MULTIPLE LOCATIONS AROUND LOW-PRESSURE AIR GROUND CONNECTION DOOR. COMPLIED WITH MHIRJ REO 670-53-31-1030 REV: -- .SDR VNAA202508280020Tie Down · corrodedFWD CARGO TIE DOWN PLATE IS CORRODED BETWEEN F.S. 549 TO F.S. 565 AND BETWEEN STGR 25R TO STGR 24R. REMOVED AND INSTALLED NEW SERVICEABLE FWD CARGO TIE DOWN PLATE/BRACKET P/N SH670-33852-1 BETWEEN F.S. 549.00 TO F.S. 565.00 AND BETWEEN STGR 25R AND 24R IAW CSDR VNAA202508280019Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 379 AND FS 485. REMOVED THE RH SEAT RAIL ON STGR 15R FS 379 - FS485 AND REPLACED THE TRACK WITH (P/N SH670-32233-3) IAW CRJ-700 AMM 53-00-49-000-801-A03 & AMM 53-00-49-400-801-A03.SDR VNAA202508280018Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 379 AND FS 485. REMOVED THE RH SEAT RAIL ON STGR 15R FS 379 - FS485 AND REPLACED THE TRACK WITH (P/N SH670-32233-3) IAW CRJ-700 AMM 53-00-49-000-801-A03 & AMM 53-00-49-400-801-A03.SDR VNAA202508280017Floor Panel · crackedFORWARD EQUIPMENT COMPARTMENT FLOOR IS CRACKED NEXT TO ADG PUMP. UPON FURTHER INVESTIGATION FOUND TO BE PREVIOUSLY INSTALLED REPAIR DOUBLER, REFERENCE "" REO 670-53-11-509 REV -E. REMOVED DAMAGED DOUBLER AND ANGLE IAW CRJ700 SRM 51-42-06-001-001-A01. FABRISDR VNAA202508280016Stringer · corrodedSTRINGER 24L BETWEEN FS 295.00 AND FS 310.00 IS CORRODED SH670-31212-1. INSTALLED STRINGER 24L BETWEEN FS280 TO FACTORY SPLICE AT FS 333 IAW CRJ 700 SRM 51-42-06-001-001-A01. INSTALLED SPLICE AT FS 333 STRINGER 24L IAW CRJ 700 SRM 51-42-06-001-001-A01.SDR VNAA202508280015Stringer · corrodedSTRINGER 23R IS CORRODED BETWEEN FS 280 AND FS 333. REMOVED AND REPLACED STRINGER 23R IAW CRJ-700 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01. SH670-31211-4U.SDR VNAA202508280014Frame · corrodedFS 295 FRAME IS CORRODED BETWEEN STGR 27 AND 23R, REPAIRED FS 295 FRAME IAW MHIRJ REO 670-53-21-2637 REV-- DATED 2025-07-02 SH670-31353-1S"SDR VNAA202508280013Beam · gougedRIGHT UPPER C-DUCT INBOARD HINGE BEAM LUGS HAVE GOUGE / CHAFE DAMAGE. PERFORMED REPAIR BY COMPLYING WITH MHIRJ REO 670-54-22-114 REV: -- DATED: 2025-07-01- REPAIR FOR DAMAGED BOLT HOLE AND BLENDED CHAFE DAMAGE TO RH UPPER THRUST REVERSER HINGE BEAM LUGS. REFERSDR VNAA202508280012Handle · gougedGALLEY SERVICE DOOR INNER HANDLE MOUNT FITTING HAS GOUGES AT THE AFT UPPER EDGE. PERFORMED REPAIR BY COMPLYING WITH MHIRJ REO 670-52-41-124 REV -- DATED 2025-05-16. CC670-38237-1.SDR VNAA202508280011Seat Track · corrodedRBL 9 SEAT RAIL IS CORRODED BETWEEN FS 581 AND FS 693. INSTALLED NEW FABRICATED SEAT TRACK P/N (SH670-33425-3) AT RBL 9 FS 581 TO FS 693 IAW CRJ-700 AMM 53-00-49-400-801-A03..SDR VNAA202508280010Seat Track · corrodedRBL 9 SEAT RAIL IS CORRODED BETWEEN FS 581 AND FS 693. INSTALLED NEW FABRICATED SEAT TRACK P/N (SH670-33425-3) AT RBL 9 FS 581 TO FS 693 IAW CRJ-700 AMM 53-00-49-400-801-A03..SDR VNAA202508280009Seat Track · corrodedLBL 9 SEAT RAIL IS CORRODED BETWEEN FS 581 AND FS 693. REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A03 SH670-33425-3.SDR VNAA202508280008Seat Track · corrodedLEFT SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 863 AND FS 969. L/H SIDE SEAT RAIL AT STGR 15L FROM FS 863 TO FS 969 FOUND TO BE OUT OF LIMITS DUE TO MULTIPLE DAMAGED AREAS IAW CRJ700 SRM 53-51-49-101-001-A01. INSTALLED NEW SERVICEABLE LH SIDE SEAT RAILSDR UIEA2025082801145Seal · brokenCAPTAIN EVAS TAMPER SEAL BROKEN(<P>INSTALLED NEW SEAL & NO FURTHER DEFECTS NOTED PER STC ST00892LA. DMI 237059 CLOSED</P>)SDR VNAA202508280007Seat Track · corrodedLEFT SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 785 AND FS 863 SH670-36260-5. REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A03.SDR CALA2025082908282Control Unit · inoperativeDOOR 4L EMERGENCY LIGHTS INOP. REMOVED AND REPLACED WELS CONTROL BOX AT DOOR 4L IN REF 33-51-07. DOWNLOAD SOFTWARE. OPS CK GOOD.SDR CALA2025082908279Fuse · no testEMERGENCY LIGHTS OPERATIONAL CHECK, DOOR L2 EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REPLACED FUSE ON BATTERY CHARGER OPS CK GOOD IAW AMM 33-51-00.SDR CALA2025082908278Light · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT (SIDEWALL LIGHT) INOPERATIVE. WDM 33-51-13-4. AT D14724, VERIFIED WIRES TO POWER SUPPLY AND GROUND CHKD NORMAL. NEED LIGHT ASSY. REPLACED RT AFT OVERWING LIGHT ASSY IAW AMM 33-21-00-960-802. EMERGENCY LIGHTS OPS CHKD NORMAL.SDR CALA2025082908277Lamp · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK {B737-33-3-0235} - L/H OVERHEAD BINS #22, #24 AND #27 AREA LIGHT ARE INOP. RELAMPED L/H OVERHEAD BINS #22, #24, AND #27 AREA LIGHTS REF AMM TASK 33-51-03-960-801. OPS CHECK WAS GOOD REF AMM 33-51-03. OK FOR SERVICE.SDR CALA2025082908276Handle · out of positionFO SIDE EMERG EXIT HANDLE UNDER WINDSCREEN PROTRUDING FOUND R2 WINDOW EMERGENCY EXIT HANDLE FLIPPED UPSIDE DOWN. RESEATED, VERIFIED SPRING PULLS HANDLE FLUSH AT THIS TIME, HANDLE OPS CHECKED GOOD IAW AMM 56-12-11-710-803, OK TO CONTINUESDR CALA2025082908274Housing · damagedEMERGENCY EXIT SIGN ATTACHED TO LIFE RAFT COMPARTMENT IN BUSINESS CLASS DAMAGED. PART 1 OF EC/RA 3351-01511 HAS BEEN COMPLIED WITH. ACCOMPLISH INSPECTIONS PER PART 2 PERIOR TO EACH FLIGHT CYCLE & ACCOMPLISH PART 3 WITHIN 4 FLT CYCLES. INTERIM REPAIR OF BUSINSDR CALA2025082908270Bottle · emptyDOOR 2R SLIDE PRESSURE IN RED. FOUND DOOR 2R SLIDE PRESSURE INDICATING EMPTY. REMOVED AND REPLACED 2R DOOR SLIDE IAW AMM 25-66-01-000-802 AND AMM 25-66-01-400-801. IAW GMM 09-25-05.SDR CALA2025082908269Hook · missingR1 SLIDE MISSING CLIP FROM STRAP THAT ATTACHES TO SLIDE DOOR.SDR CALA2025082908267Floor Support · corrodedAFT MAIN CABIN STA 1681 - 1660, BL-0. FLOOR SUPPORT HAS CORROSION. REMOVED AND REPLACED U CHANNEL FLOOR SUPPORT PN 146N5323U5 REI NSTALLED 1EA PLATE IAW SRM 51-40-02.SDR CALA2025082908266Union · leakingR ENG OIL LEAK, REF LP 6069024 FOUND PRIMER ADAPTER/UNION ON PRESSURE OIL FILTER HOUSING, IPC 79-21-04-01, ITEM 60 LOOSE, HELD ON WIRELOCKING. PRIMER REMOVED CLEANED AND RETORQUED WITH REF TO AMM 79-21-07-434-007-R00. GROUND IDLE ENGINE RUN COMPLETED, NO LEAKSSDR CALA2025082908265Elec Connector · disconnectedAFT RT OVERWING EXIT EXTERIOR EMERGENCY LIGHT INOPERATIVE. CONNECTED THE ELEC CONNECTOR D12018 TO OVERWING ESCAPE LIGHT L7. OPS TESTED GOOD. IAW AMM 33-51-00 AND WDM 33-51- 14.SDR CALA2025082908264Control Unit · faultedDURING SOFTWRE CHECK OF NR 9 AND 30 WELS BATTERY FOUND NOT IN NET FOR WBUS 02,09,17,21, AND 30. REMOVED AND REPLACED WELS CONTROL UNIT AT L1 IAW AMM B787-A-33-51-07-01A-520A-A AND B787-A-33-51-07-01A-720A-A REFERENCE FIM 33-50-F1-FAA-421A. SOFTWARE LOADED ANDSDR CALA2025082908263Bulb · burned outEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCH PROCEDURE. RT FWD OVER WING EMERGENCY LIGHT INOP RELAMPED. OPS CKD OK REF AMM 33-51-06.SDR VNAA202508280006Seat Track · corrodedLEFT SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 712 AND FS 761. RH SIDE SEAT RAIL AT STGR 15R BETWEEN FS 863 AND FS 969 WAS FOUND TO BE OUT OF LIMITS IAW CRJ700 SRM 53-51-49-101-001-A01. REQUIRES REPLACEMENT. INSTALLED NEW SERVICEABLE SEAT TRACK AT RSDR VNAA202508280005Seat Track · corrodedRIGHT SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 863 AND FS 969.RH SIDE SEAT RAIL AT STGR 15R BETWEEN FS 863 AND FS 969 WAS FOUND TO BE OUT OF LIMITS IAW CRJ700 SRM 53-51-49-101-001-A01. REQUIRES REPLACEMENT. INSTALLED NEW SERVICEABLE SEAT TRACK AT RH STGR 1SDR HNAA2025082900582Dau · failedE1 REV DISAGREE DISPLAYED DURING TO. DEACTIVED TR 1. ENG 1 OR 2 REV DISAGREE MESSAGES FACT 30AUG25 03:03 ROA T/S IAW FIM 78-30-00-810-814-A FOUND NO CONTINUITY BETWEEN PINS A-36 OF CONNECTER J1018 TO GROUND, R&R #2 DAU IRT AMM 31-41-01. OPS CK GOOD. NSDR VNAA202508280004Seat Track · corrodedRIGHT SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 785 AND FS 863. REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A03 SH670-36260-5SDR VNAA202508280003Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 712 AND FS 761. REMOVED R/H SIDE SEAT TRACK AT STGR 15R BETWEEN FS 712 - FS 761 IAW CRJ-700 AMM 53-00-49-000-801-A03. RH SIDE SEAT RAIL AT STGR 15R, FS 712-761 FABRICATED ON HN00245299, SO# 400415030. COSDR VNAA202508280002Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 677 AND FS 712. PN SH670-36255-3. REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A03.SDR VNAA202508280001Seat Track · corrodedRH SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 572 AND FS 677. INSTALLED NEW SERVICEABLE RH SIDE SEAT RAIL AT STGR 15R BETWEEN FS 572 AND FS 677 IAW CRJ-700 AMM 53-00-49-400-801-A03. (PN- SH670-33558-3).SDR DXTA2025082904755Pushrod · out of adjustUPON OPENING DOOR WE HEARD A LOUD GRINDING/BINDING NOISE ON DOOR DOWNWARD DESCENT, DOOR IS DIFFICULT TO LOCK DOWN AND REQUIRES EXCESSIVE FORCE TO LIFT HANDLE OVER DETENT TO CLOSE. VERIFIED. T/S DOOR AND FOUND CLOSING HANDLE PUSHROD TO BE OUT OF ADJUSTMENT.