# Service difficulty reports: N687JS

A list on [N687JS](https://openairdocs.org/aircraft/N687JS.md).

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Page 1 of 3 · 147 reports

- [SDR HNAA2026100800957](https://openairdocs.org/sdr/HNAA2026100800957.md): Trim System · faulted · Oct 7, 2026 · N687JS · Emb EMB145LR · Stabilizer Position Indicating
  > ON CLIMBOUT, PITCH TRIM MAIN WARNING MESSAGE. BOTH MAIN SWITCHES WERE INOPERATIVE. BACKUP TRIM WAS OPERATIONAL. C/W FIM 27-43-00-810-820-A. CMC MSG HSCU FAIL MSG. IAW FIM 27-43-00-0810-803-A, RESET PITCH TRIM CB`S. OPS CHECKED IAW AMM 27-40-00-700-802-A, PI
- [SDR HNAA2026082600791](https://openairdocs.org/sdr/HNAA2026082600791.md): Charger · inoperative · Aug 25, 2026 · N687JS · Emb EMB145LR · Emergency Lighting
  > SERVICE DOOR AND PAX DOOR EMERGENCY LIGHTS INOP. REMOVED PAX DOOR PANEL &821AW AND FOUND CUT WIRE LEADING TO EMERGENCY LIGHT ASSY AFTER WIRE WAS REPAIRED AND OPS CHECK GOOD REINSTALLED PANEL 821 WITH RETAINING HARDWARE REPAIRED BROKEN WIRE W192-8592-20 IAW W
- [SDR HNAA20261600502](https://openairdocs.org/sdr/HNAA20261600502.md): Charger · faulted · Jun 12, 2026 · N687JS · Emb EMB145LR · Emergency Lighting
  > L/H & RH OVERWING EMERGENCY LIGHT INOPERATIVE. R & R NR 400 BATTERY CHARGER ASSY PER AMM 33-50-04 P/N ON 11-0049 S/N 20110 P/N OFF BAS 0933-901 S/N 201633
- [SDR HNAA2025080500534](https://openairdocs.org/sdr/HNAA2025080500534.md): Inverter · abnormal · Aug 4, 2025 · N687JS · Emb EMB145LR · Emergency Lighting
  > EMERGENCY EXIT LIGHT AT ROW 3B INOP FACT 04AUG25 07:56 SBY R&R #300 INVERTER IAW AMM 33-50-11
- [SDR HNAA2025050900307](https://openairdocs.org/sdr/HNAA2025050900307.md): Cabin Pressure · warning message · May 8, 2025 · N687JS · Emb EMB145LR · Cabin Pressure Control System
  > AUTO PRESS FAIL ON EICAS FACT 08MAY25 18:20 PHL PERFORMED OPS CHECKS IN BOTH AUTO AND MANUAL MODE IAW AMM 21-31-00. NO FURTHER DEFECTS NOTED. BOTH OPS CHECKS GOOD. AC OK FOR SERVICE
- [SDR HNAA2025042800225](https://openairdocs.org/sdr/HNAA2025042800225.md): Relay · faulted · Apr 27, 2025 · N687JS · Emb EMB145LR · Pitot/Static System
  > PITOT 1 INOP MESSAGE ON EICAS DURING T/O ROLL. SWAPPED RELAY K0053 + K0054 IAW AMM 30-31-01. OPS CHECK GOOD IAW AMM 30-31-00 NO PITOT 1 INOP MESSAGE AT THIS TIME. A/C OK FOR SERVICE.
- [SDR HNAA2025031700185](https://openairdocs.org/sdr/HNAA2025031700185.md): Repair · not entered · Mar 5, 2025 · N687JS · Emb EMB145LR · Standard Practices/Structures
  > F031994 CIRCULAR PATCH ON RH TAIL SECTION AROUND FR. 77 THROUGH 79, APPROX. STRGS. 05 - 09R NEED TO BE REMOVED AND REINSTALLED DUE TO NO SUPPORTING DOCUMENTATION FOR THE REPAIR EVALUATION. RE-ACCOMPLISHED CIRCULAR PATCH REPAIR ON RH TAIL SECTION AROUND FR. 77
- [SDR HNAA2025031700184](https://openairdocs.org/sdr/HNAA2025031700184.md): Floor Support · cracked · Feb 22, 2025 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > F030314 LH OMEGA BEAM IS CRACKED AT FRAME 26. REPAIRED LH OMEGA BEAM AT FRAME 26 IAW ETD2025-145-902969 AND PIEDMONT EO1-53-25-0090.
- [SDR HNAA2025031700183](https://openairdocs.org/sdr/HNAA2025031700183.md): Floor Support · cracked · Feb 22, 2025 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > F030310 LH OMEGA BEAM IS CRACKED AT FRAME 25. REPAIRED LH OMEGA BEAM AT FRAME 25 IAW ETD2025-145-902945 AND PDT EO1-53-25-0091.
- [SDR HNAA2025031700182](https://openairdocs.org/sdr/HNAA2025031700182.md): Rib · cracked · Feb 14, 2025 · N687JS · Emb EMB145LR · Wing, Rib/Bulkhead
  > F027765 R/H WING RIB 21 IS CRACKED. PERFORMED CUTOUT, FABRICATED DOUBLER, AND INSTALLED REPAIR DOUBLER ON RH WING RIB 21 IAW EMB 145 SRM 57-20-07, ITEM 4, FIG. 203
- [SDR HNAA2025031700181](https://openairdocs.org/sdr/HNAA2025031700181.md): Stringer Splice · cracked · Feb 12, 2025 · N687JS · Emb EMB145LR · Fuselage Main, Longeron/Stringer
  > F027316 STRINGER 06R SPLICE AT FRAME 13 CRACKED. RAR STGR 6R BTW FR 12-14 IAW EMB 145 SRM 51-40-02.
- [SDR HNAA2025031700180](https://openairdocs.org/sdr/HNAA2025031700180.md): Floor Support · cracked · Feb 11, 2025 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > F027211 LH OMEGA BEAM CRACKED AT RIVET AT FR21. PERFORMED CUTOUT, FABRICATED DOUBLER AND FILLER AND INSTALLED DOUBLER AND FILLER FOR REPAIR ON LH OMEGA BEAM AT FR 21 IAW ETD2025-145-902848 AND EO1-53-25-0098
- [SDR HNAA2025031700179](https://openairdocs.org/sdr/HNAA2025031700179.md): Floor Support · cracked · Feb 11, 2025 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > F026971 LH OMEGA BEAM CRACKED AT RIVET AT FR22. PERFORMED CUTOUT, FABRICATED DOUBLER AND FILLER AND INSTALLED DOUBLER REPAIR ON LH OMEGA BEAM AT FR22 IAW EMB 145 ETD2025-145-902851 AND EO1-53-25-0097
- [SDR HNAA2025031700178](https://openairdocs.org/sdr/HNAA2025031700178.md): Shear Tie · cracked · Feb 10, 2025 · N687JS · Emb EMB145LR · Fuselage Internal Mounting Structure
  > F026440 SHEAR CLIP AT FR 73 HAS POSSIBLE CRACK BTWN STRGRS 9R-10R. REMOVED AND REPLACED SHEAR CLIP AT FR 73 BTWN STRGRS 9R-10R IAW EMB 145 SRM 51-40-02.
- [SDR HNAA2025031700177](https://openairdocs.org/sdr/HNAA2025031700177.md): Shear Tie · cracked · Feb 10, 2025 · N687JS · Emb EMB145LR · Fuselage Internal Mounting Structure
  > F026439 SHEAR CLIP CRACKED AT FR 66 BTWN STGRS 7L-8L. REMOVED AND REPLACED SHEAR CLIP AT FR 66 BTWN STGRS 7L-8L IAW EMB 145 SRM 51-40-02.
- [SDR HNAA2025031700176](https://openairdocs.org/sdr/HNAA2025031700176.md): Door Sill · corroded · Feb 10, 2025 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > F026244 CARGO DOOR CUTOUT LWR SILL HAS CORROSION IN NUMEROUS AREAS. REMOVED AND INSTALLED NEW CARGO DOOR CUTOUT LWR SILL IAW EMB 145 SRM 51-40-02.
- [SDR SIMA20220227002](https://openairdocs.org/sdr/SIMA20220227002.md): Not Reported · not reported · Feb 27, 2022 · N687JS · Emb EMB145LR · Emergency Lighting
  > FWD FA EMERGENCY FLASH LIGHT INOP MEL 25-32 - AUTH# 020282M-C LOG PG ITEM# 4847400/1 -C/A-REMOVED AND REPLACED FWD FA EMERGENCY FLASHLIGHT ASSEMBLY IAW EMB145 AMM 33-50-16. OPC CHECK GOOD NO FURTHER DEFECTS NOTED. MEL RESTORED
- [SDR SIMA20220222001](https://openairdocs.org/sdr/SIMA20220222001.md): None · none · Feb 22, 2022 · N687JS · Emb EMB145LR · Emergency Lighting
  > FWD FA EMERGENCY FLASHLIGHT INOP-C/A-FLT CREW PLACARD FWD FS EMERGENCY FLASHLIGHT IAW MEL 2532 AUTH # 020282M-C MOC # 624980
- [SDR SIMA20220220002](https://openairdocs.org/sdr/SIMA20220220002.md): None · none · Feb 20, 2022 · N687JS · Emb EMB145LR · Cabin Cooling System
  > CA REPORTED BLEED1 LEAK PASSING THROUGH 16,500 AND PRESSURIZATION ISSUE FORCING TO FLY AT FL100 AND BELOW. ATC DECLARED EMERGENCY, FLIGHT LANDED AND TAXIED TO GATE IN ORD WITHOUT FURTHER INCIDENT. -C/A-DURING TROUBLE SHOOTING ITEM #1 FOUND GROUND AIR CONDITION
- [SDR SIMA20220107001](https://openairdocs.org/sdr/SIMA20220107001.md): None · none · Jan 7, 2022 · N687JS · Emb EMB145LR · Emergency Lighting
  > REAR FA EMERGENCY FLASSHLIGHT MISSING.-C/A-AFT EMERGENCY FLASHLIGHT DEFERRED PER MEL 25-52
- [SDR SIMA202108276002](https://openairdocs.org/sdr/SIMA202108276002.md): Cradle · broken · Aug 26, 2021 · N687JS · Emb EMB145LR · Emergency Equipment
  > MEL 2532 - AUTH# 08-352M-C REPAIR - POSITION AFT - FLT DECK/ATTENDANT FLASHLIGHT/HOLDER AFT FA EMERGENCY FLASHLIGHT HOLER BROKEN PLACARDED BY:<MTX ID:<222659 LOGPAGE:<4798567 ITEM:<1. RESTORATION OF MEL ITEMS REVIEW THE MEL AND ENSURE APPROPRIATE MAINTENANCE
- [SDR SIMA20210802002](https://openairdocs.org/sdr/SIMA20210802002.md): Light · inoperative · Aug 2, 2021 · N687JS · Emb EMB145LR · Emergency Lighting
  > RH OVER WING EMERGENCY LIGHT INOP-C/A-RAR RH OVERWING EMERGENCY LIGHT ASSEMBLY IAW EMB 145 AMM 33-50-10. OPC GOOD
- [SDR SIMA20210727002](https://openairdocs.org/sdr/SIMA20210727002.md): Lamp · inoperative · Jul 27, 2021 · N687JS · Emb EMB145LR · Emergency Lighting
  > DURING PS-2 CHECK FOUND RH UPPER FAIRING EMERGENCY LIGHT INOP-C/A-RAR RH UPPER FAIRING EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10. OPC GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.
- [SDR SIMA20210720001](https://openairdocs.org/sdr/SIMA20210720001.md): Lamp · inoperative · Jul 20, 2021 · N687JS · Emb EMB145LR · Emergency Lighting
  > RH OVER WING EMERGENCY LIGHT INOP-C/A-RAR RH OVER WING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD. END.
- [SDR SIMA20210712002](https://openairdocs.org/sdr/SIMA20210712002.md): Bulb · inoperative · Jul 12, 2021 · N687JS · Emb EMB145LR · Emergency Lighting
  > RH UPPER EXTERNAL EMERGENCY LIGHT INOP-C/A-RAR RH UPPER EXTERNAL EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPC GOOD.
- [SDR SIMA20210710001](https://openairdocs.org/sdr/SIMA20210710001.md): Bulb · inoperative · Jul 10, 2021 · N687JS · Emb EMB145LR · Emergency Lighting
  > RH UPPER EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR UPPER RH EXTERIOR EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPC GOOD.
- [SDR SIMA20210301001](https://openairdocs.org/sdr/SIMA20210301001.md): Battery · missing · Mar 1, 2021 · N687JS · Emb EMB145LR · Emergency Equipment
  > AFT FA FLASHLIGHT NO BATTERY.-C/A-REPLACED AFT EMERGENCY FLASHLIGHT BATTERY IAW AMM CH 33-51-01.
- [SDR SIMA20201228002](https://openairdocs.org/sdr/SIMA20201228002.md): Power Supply · inoperative · Dec 28, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > LT AND RT OVER WING EMERGENCY LIGHT INOPERABLE. C/A: REMOVED AND REPLACED NR 4 POWER SUPPLY AND BATTERY PACK, IAW AMM 33-50-04. LT AND RT OVER WING EMERGENCY LIGHTS OPERATIONAL CHECK GOOD.
- [SDR SIMA20201119002](https://openairdocs.org/sdr/SIMA20201119002.md): Cradle · inoperative · Nov 19, 2020 · N687JS · Emb EMB145LR · Emergency Equipment
  > F/A FLASHLIGHT CHARGER STATUS LIGHT INOPERABLE. C/A: R & R F/A FLASHLIGHT ASSEMBLY, IAW AMM 33-50-16.
- [SDR SIMA20200918001](https://openairdocs.org/sdr/SIMA20200918001.md): Warning Message · illuminated · Sep 18, 2020 · N687JS · Emb EMB145LR · Door Warning System
  > BAGGAGE DOOR OPEN INDICATION IN FLIGHT AFTER TAKEOFF. PRESSURIZATION NORMAL. C/A FLIGHT CREW PLACARDED BAGGAGE DOOR INDICATION, MEL 52-5 AUTH 090268-C MOC 437847.
- [SDR SIMA20200617001](https://openairdocs.org/sdr/SIMA20200617001.md): Light · inoperative · Jun 17, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > RT AFT OVERWING EMERGENCY LIGHT INOP. RELAMPED RH AFT OVERWING EMERGENCY LIGHT IAW AMM 33-50-07, OPS CHK GOOD.
- [SDR SIMA2020060805005](https://openairdocs.org/sdr/SIMA2020060805005.md): Light · inoperative · Jun 5, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > LT O/W EMER LIGHT INOP. REMOVED AND REPLACED LT O/W EMER LIGHT IAW AMM 33-50-10.
- [SDR SIMA2020051523002](https://openairdocs.org/sdr/SIMA2020051523002.md): Wire · broken · Mar 23, 2020 · N687JS · Emb EMB145LR · Light System Wiring
  > SERVICE DOOR HINGE COVER EMERGENCY LIGHT WIRE BROKEN-C/A-REPAIRED SERVICE DOOR HINGE COVER EMERGENCY LIGHT IAW EMB145 SWPM 20-21-00 OPC GOOD
- [SDR SIMA2020051423001](https://openairdocs.org/sdr/SIMA2020051423001.md): Connector · disconnected · Mar 23, 2020 · N687JS · Emb EMB145LR · Light System Wiring
  > EMERGENCY EXIT LIGHT ON AFT SIDE PILOTS BULKHEAD INOP-C/A-PROPERLY CONNECTED CANNON PLUG TO EMERGENCY EXIT LIGHT ON AFT SIDE PILOTS BULKHEAD IAW EMB 145 SWPM 20-50-00 OPS CHECK GOOD.
- [SDR SIMA202003187001](https://openairdocs.org/sdr/SIMA202003187001.md): Light · inoperative · Mar 17, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > LH FUSELAGE AFT EMERGENCY LAMP INOP-C/A-REMOVED AND REPLACED LH FUSELAGE AFT EMERGENCY LAMP, OPC GOOD IAW EMB AMM 33-50-10.
- [SDR SIMA202003109001](https://openairdocs.org/sdr/SIMA202003109001.md): Light · inoperative · Mar 9, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > R/H WING EMERGENCY LIGHT INOP-C/A-RAR R/H WING EMERGENCY LIGHT BULB IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.
- [SDR SIMA202003098002](https://openairdocs.org/sdr/SIMA202003098002.md): Light · inoperative · Mar 8, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > FOUND RH OVERWING EMERGENGY LIGHT INOP DURING PS-2-C/A-RAR EMERGENCY LIGHT BULB IAW AMM 33-50-10
- [SDR SIMA202003028003](https://openairdocs.org/sdr/SIMA202003028003.md): Light · inoperative · Feb 28, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > DURING PS-1 CHECK FOUND RH EXTERNAL EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED RH EXTERNAL EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10. OPS CHK GOOD
- [SDR SIMA2020012019001](https://openairdocs.org/sdr/SIMA2020012019001.md): Battery Pack · inoperative · Jan 19, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > DURING OPC OF EMERGENCY LIGHTING SYSTEM FOUND BOTH OVERWING EMERGENCY LIGHT INOP-C/A-RAR BATTERY PACK #4 IAW EMB145 AMM 33-50-04-04 OPS CHECK GOOD.
- [SDR SIMA2020010318002](https://openairdocs.org/sdr/SIMA2020010318002.md): Uplock · failed · Jan 18, 2020 · N687JS · Emb EMB145LR · Landing Gear Retraction/Extension System
  > AFTER TAKEOFF NOSE GEAR DID NOT RETRACT BUT THE MAINS DID. THE NOSE SHOWED IN TRANSIT AND THEN THE MASTER WARNING LANDING GEAD DISAGREE CAME ON. WE PUT THE LANDING GEAR SELECTOR DOWN AND THE NOSE GEAR CAME DOWN IN THE GREEN,NLG INDICATION DECKLARED EMEGENCY-C/
- [SDR SIMA202001087005](https://openairdocs.org/sdr/SIMA202001087005.md): Charger · inoperative · Jan 7, 2020 · N687JS · Emb EMB145LR · Emergency Lighting
  > BOTH UPPER LH AND RH EXTERNAL EMERGENCY LIGHTS INOP-C/A-RELAMPED BOTH R/H AND L/H OVER WING EXTERNAL EMERGENCY LIGHT BULBS IAW EMB 145 AMM 33-50-07. NO FIX. T/S TO POSSIBLE EMERGENCY LIGHTING BATTERY # 4 USING SYSTEM DESCRIPTION MANUAL 33-50-50. REMOVED AND RE
- [SDR SIMA201912230002](https://openairdocs.org/sdr/SIMA201912230002.md): Battery · inoperative · Dec 20, 2019 · N687JS · Emb EMB145LR · Emergency Lighting
  > RH -LH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED EMERGENCY BATTERY ASSY AT POSITION #4 IAW ENVOY MTX WC 33-700-13 AND 33-700-19. OPC GOOD. CHARGER ASSY BATTERY P/N BA5-0933-901 S/N C00959
- [SDR SIMA201912109003](https://openairdocs.org/sdr/SIMA201912109003.md): Flashlight · inoperative · Dec 9, 2019 · N687JS · Emb EMB145LR · Emergency Equipment
  > FORWARD FA FLASHLIGHT INOPERATIVE. SWAPPED FWD AND AFT FLASHLIGHTS. INSPECTED AFT FLASHLIGHT AND FLASHLIGHT CHARGING CRADLE IAW CMM 25-60-14. FOUND FLASHLIGHT AND FLASHLIGHT CHARGING CRADLE TO BE IN WORKING CONDITION. OPS CHECKED GOOD. NO OTHER DEFECTS NOT
- [SDR SIMA2019082618003](https://openairdocs.org/sdr/SIMA2019082618003.md): Frame · cracked · Aug 18, 2019 · N687JS · Emb EMB145LR · Fuselage Main, Frame
  > FRAME CRACKED ON R/H SIDE AT FRAME 29 AND STRINGER 14, BEHIND SEAT TRACK. -C/A-COMPLIED WITH REPAIR IAW SRM 53-00-04.
- [SDR SIMA201908212004](https://openairdocs.org/sdr/SIMA201908212004.md): Floor Support · corroded · Aug 12, 2019 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > L/H OMEGA BEAM IS CORRODED AT FRAME 44.-C/A-REPAIRED L/H OMEGA BEAM AT FRAME 44 IAW ERS-EM-53MR-3861.
- [SDR SIMA20190812003](https://openairdocs.org/sdr/SIMA20190812003.md): Attach Angle · cracked · Aug 12, 2019 · N687JS · Emb EMB145LR · Vertical Stabilizer, Attach Fittings
  > RIGHT VERTICAL STAB TO FUSELAGE ATTACH ANGLE HAS A 1/2" CRACK. REMOVED AND REPLACED RIGHT VERTICAL STAB TO FUSELAGE ATTACH ANGLE IAW SRM 51-40-02. RESTORED SURFACE PROTECTION IAW CPM 51-21-06.
- [SDR SIMA2019082108009](https://openairdocs.org/sdr/SIMA2019082108009.md): Support Bracket · cracked · Aug 8, 2019 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > NLG UPLOCK BOX SUPPORT BRACKET IS CRACKED ON THE FWD L/H SIDE. -C/A-REMOVED AND REPLACED NLG UPLOCK BOX SUPPORT BRACKET LH SIDE IAW SRM 51-40-02.
- [SDR SIMA2019080821008](https://openairdocs.org/sdr/SIMA2019080821008.md): Crossbeam · cracked · Aug 8, 2019 · N687JS · Emb EMB145LR · Fuselage Main, Structure
  > NLG FWD CROSSBEAM IS CRACKED. INSTALLED NEW NLG CROSSBEAM IAW SRM 51-40-02.
- [SDR SIMA2019081608007](https://openairdocs.org/sdr/SIMA2019081608007.md): Support · cracked · Aug 8, 2019 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > RT WING TO FUSELAGE FAIRING UPPER SUPPORT CRACKED AT FRAME 49R. -C/A-REPAIRED RT WING TO FUSELAGE FAIRING UPPER SUPPORT IAW SRM 53-23-12.
- [SDR SIMA2019100231005](https://openairdocs.org/sdr/SIMA2019100231005.md): Frame · cracked · Jul 31, 2019 · N687JS · Emb EMB145LR · Fuselage Miscellaneous Structure
  > FRAME 67 IS CRACKED AT CARGO DOOR SILL ATTACH HOLES-C/A-COMPLETE:REPAIRED FRAME 67 IAW ERS EM-53MR-3872

Next page: https://openairdocs.org/aircraft/N687JS/reports.md?page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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'
WHERE n_number = 'N687JS' AND registry_match = 'registration'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/aircraft/N687JS/reports

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.